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 31 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 FIRST CHRISTIAN CHURCH FIRST PRESBYTERIAN 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 425120 236115 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 4 2 view top 100 |
| PPB Address 2 | ppb_address2 | text | NO LOC IN OR UNKNOWN NO SPECIFIC LOCATION NO OR LOC NO OREGON LOCATION view top 100 |
| PPB City | ppb_city | text | PORTLAND NA SALEM EUGENE UNKNOWN view top 100 |
| PPB State | ppb_state | text | OR XX WA CA FL 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 9728 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 RESTAURANT CHURCH view top 100 |
| Insurer Num | insurer_num | number | 1 882 615 910 509 view top 100 |
| Insurer Name | insurer_name | text | SAIF CORPORATION TRAVELERS PROPERTY CASUALTY COMPANY OF AMERICA HARTFORD UNDERWRITERS INSURANCE COMPANY TWIN CITY FIRE INSURANCE COMPANY LM INSURANCE CORPORATION view top 100 |
| Liability Begin Date | liab_begin_date | calendar_date | 2019-01-01T00:00:00.000 2018-10-01T00:00:00.000 2019-04-01T00:00:00.000 2019-07-01T00:00:00.000 2019-03-01T00:00:00.000 view top 100 |
| Liability End Date | liad_end_date | calendar_date | 2020-01-01T00:00:00.000 2019-10-01T00:00:00.000 2020-04-01T00:00:00.000 2020-07-01T00:00:00.000 2020-03-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 6708111 2445810 3456000 9609000 view top 100 |
| Mail Address 1 | mail_address1 | text | 10425 W NORTH AVE STE 345 0 25115 SW PARKWAY AVE STE B 00 200 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 97301 97223 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 |
| FEIN | fein | text | 0 930811746 942708481 931144785 931191672 view top 100 |