The Employer Database System is a database of all Oregon employers and their history of workers’ compensation (WC) insurance coverage. The system produces a snapshot of current employers with active workers’ compensation insurance policies. The most current data are updated monthly during the first week of the month.
This dataset has the following 30 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Employer Number | employer_num | text | 2405082 1023555 1611607 3345790 1990324 view top 100 |
| Insurer Status | insurer_status | number | 1 12 4 3 view top 100 |
| Insurer Status Date | insurer_status_date | calendar_date | 2012-01-05T00:00:00.000 2012-04-04T00:00:00.000 2012-10-16T00:00:00.000 2012-02-02T00:00:00.000 2011-08-03T00:00:00.000 view top 100 |
| Legal Business Name | legal_business_name | text | STATE OF OREGON FIRST BAPTIST CHURCH CHURCH OF THE NAZARENE GRACE BAPTIST CHURCH FIRST CHRISTIAN CHURCH view top 100 |
| DBA Name | dba_name | text | THEANAGEMENTRUSTORTHWEST DBA SEE STATE SCHEDULES STATE OF OREGON DBA STATE OF OREGON SUBWAY DBA view top 100 |
| Ownership | ownership | number | 50 30 20 10 view top 100 |
| NAICS | naics | text | 999999 722511 236115 425120 813110 view top 100 |
| Employees Range | employees_range | text | 1 to 10 11 to 49 50 to 99 100 to 499 500 or more view top 100 |
| PPB Address 1 | ppb_address1 | text | 0 Y WY 00 2 view top 100 |
| PPB Address 2 | ppb_address2 | text | NO LOC IN OR UNKNOWN NO SPECIFIC LOCATION NO OR LOC 1125 NW COUCH ST STE 700 view top 100 |
| PPB City | ppb_city | text | PORTLAND NA SALEM EUGENE BEND view top 100 |
| PPB State | ppb_state | text | OR XX WA OH MN view top 100 |
| PPB_Zip | ppb_zip | text | 99999 97701 97301 97401 97214 view top 100 |
| PPB Zip 4 | ppb_zip_4 | text | 0000 4129 9701 3607 9700 view top 100 |
| County Code | county_code | number | 51 99 67 5 39 view top 100 |
| Business Type | business_type | text | SEE SIC/NAICS UNKNOWN SEE NAICS CHURCH RESTAURANT view top 100 |
| Insurer Num | insurer_num | number | 1 882 910 615 10 view top 100 |
| Insurer Name | insurer_name | text | SAIF CORPORATION TRAVELERS PROPERTY CASUALTY COMPANY OF AMERICA TWIN CITY FIRE INSURANCE COMPANY HARTFORD UNDERWRITERS INSURANCE COMPANY TRAVELERS CASUALTY AND SURETY COMPANY view top 100 |
| Liability Begin Date | liab_begin_date | calendar_date | 2019-01-01T00:00:00.000 2019-07-01T00:00:00.000 2018-10-01T00:00:00.000 2019-04-01T00:00:00.000 2019-06-01T00:00:00.000 view top 100 |
| Liability End Date | liad_end_date | calendar_date | 2020-01-01T00:00:00.000 2020-07-01T00:00:00.000 2019-10-01T00:00:00.000 2020-04-01T00:00:00.000 2020-06-01T00:00:00.000 view top 100 |
| Entity Code | entity_code | text | 2 B 1 0 5 view top 100 |
| Phone Area | phone_area | number | 503 541 971 360 800 view top 100 |
| Phone | phone | text | 3317700 2445810 6708111 7971830 3456000 view top 100 |
| Mail Address 1 | mail_address1 | text | 10425 W NORTH AVE STE 345 0 25115 SW PARKWAY AVE STE B 00 4800 SW MACADAM AVE STE 245 view top 100 |
| Mail Address 2 | mail_address2 | text | 5433 WESTHEIMER RD STE 500 1125 NW COUCH ST STE 700 2950 N HOLLYWOOD WAY PO BOX 4398 2105 SE 9TH AVE view top 100 |
| Mail City | mail_city | text | PORTLAND SALEM EUGENE BEND BEAVERTON view top 100 |
| Mail State | mail_state | text | OR CA WA TX NY view top 100 |
| Mail Zip | mail_zip | text | 97401 97402 97214 97223 97301 view top 100 |
| Mail Zip 4 | mail_zip_4 | text | 0001 0000 5339 4129 1072 view top 100 |
| Record Origin | record_origin | text | PC1 PC2 view top 100 |