Download the data
The 7 computed tables behind our research pages, as CSV: 459 rows in 37 KB, small enough to open in a spreadsheet. This is the CivicDelta computed open-data downloads set — free, no sign-up, and each file ships with a machine-readable record of where every number came from.
These are not copies of a government file. Each one is a computation over the full published records — a join, a rate, a median — that the publisher does not itself publish. The underlying files are linked below; use them if you would rather compute your own.
Three things before you quote a number
- An empty cell is not a zero. An empty cell means the value is not published by the source, or that our sample floor suppresses it. It is never written as 0 — a zero in this file is a measured zero. Every column's note in the tables below says which of the two it is.
- Rates below a sample floor are suppressed, not rounded down. A township-year with fewer than 30 appeals, a study cell with fewer than 100, or a state with fewer than 10 certified homes carries counts but no share — on the page and in the file alike.
- The file and the page are the same numbers. Both are produced by one query in one run; a test fails the build if a figure in a file differs from the figure on the page it mirrors.
Cook County township residential appeal outcomes and reassessment change
Per Cook County township per tax year: closed residential appeals at the Assessor and the share that changed a value, Board of Review appeals and the share decreased, the township's latest reassessment median change, and its verified appeal window.
Download cook-county-township-appeal-outcomes.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| cook-county-township-appeal-outcomes.csv | 114 | 14 KB | 38 townships × tax years 2023–2025 | 2026-09-28 |
Attribution required: Source: Cook County Assessor's Office, “Assessor - Appeals” (dataset y282-6ig3), loaded 2026-09-28; Cook County Assessor's Office, “Assessor - Assessed Values” (dataset uzyt-m557), loaded 2026-09-28; Cook County Board of Review, “Board of Review Appeal Decision History” (dataset 7pny-nedm), loaded 2026-09-28. Computed by CivicDelta.
What it contains
- Residential property only (Cook County class 2xx, including condominium units).
- Counts of appeals that were DECIDED; a pending appeal is not in them.
- Only appeal windows compared against a captured copy of the office's own calendar.
What it does not contain
- Anything about an individual property, owner or appellant — no PINs, no names.
- Dollar amounts. An appeal that changed a value is counted, not measured.
- Commercial, industrial or vacant-land appeals.
- A prediction. These are township-wide rates over closed cases.
Where it comes from
- Cook County Assessor's Office, “Assessor - Appeals” (dataset y282-6ig3), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Cook County Assessor's Office, “Assessor - Assessed Values” (dataset uzyt-m557), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Cook County Board of Review, “Board of Review Appeal Decision History” (dataset 7pny-nedm), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| township | Township name as the Assessor writes it. |
| township_code | The Assessor's township code. |
| triad | The reassessment triad the township sits in (City, North, South). |
| residential_parcels | Residential (class 2xx) parcels in the township in the current parcel universe — the count the township page prints. A property of the township, so it repeats on each of its year rows. |
| tax_year | Tax year the appeals were filed against. |
| assessor_appeals_closed | Closed residential (class 2xx) appeals the Assessor decided. Empty when we hold none for that year. |
| assessor_appeals_changed | Of those, the number where the Assessor's own record says the value changed. Empty when the count is empty. |
| assessor_change_rate_pct | changed ÷ closed, as a percentage to one decimal. EMPTY when the township-year has fewer than 30 closed appeals — the page prints no rate there either. |
| bor_appeals | Residential appeals the Board of Review decided. Empty when we hold none for that year. |
| bor_appeals_decreased | Of those, the number whose recorded result is “Decrease”. |
| bor_decrease_rate_pct | decreased ÷ appeals, as a percentage to one decimal. EMPTY below 30 appeals. |
| latest_reassessment_year | Most recent year clearing 1,000 homes valued in two consecutive years with a median shift of at least 2%. Empty when no year clears it. |
| latest_reassessment_homes_compared | Class-2 properties valued in both years, behind that median. |
| latest_reassessment_median_change_pct | Median change in assessed value at that reassessment, signed, to one decimal. Empty when there is no qualifying year. |
| appeal_window_tax_year | Tax year of the appeal window in the next four columns. Empty when no verified window is held. |
| appeal_window_body | Which office the window belongs to. |
| appeal_window_opens_on | ISO date the window opened. Empty when the calendar does not publish one. |
| appeal_window_closes_on | ISO date the window closes. |
| appeal_window_verified_on | The date this window was last compared, automatically, against a captured copy of the office's published calendar. Empty means we hold no window for that township — we never print a deadline we have not compared. |
Served at /data/downloads/cook-county-township-appeal-outcomes.csv. Machine-readable provenance, including the exact SQL: cook-county-township-appeal-outcomes.meta.json
US nursing home repeat-harm, penalty and staffing shares by state
Every US state and territory: Medicare-certified nursing homes, the share cited for actual harm on one and on two or more separate inspections, the share fined, the median fine, and median nurse turnover and nurse hours per resident day.
Download nursing-home-inspection-records-by-state.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| nursing-home-inspection-records-by-state.csv | 53 | 4 KB | 53 states and territories, 14,690 certified homes | 2026-09-14 |
Attribution required: Source: Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14. Computed by CivicDelta.
What it contains
- Every Medicare-certified nursing home in the CMS provider file, aggregated to its state.
- Citations between the first and last survey dates in the loaded citation file — see coverage.temporal.
What it does not contain
- Any individual home. This is a state aggregate; nothing here identifies a provider.
- A safety ranking. Surveys are run by state agencies that do not cite alike, so a high share can mean hard inspectors as easily as worse homes. Never compare a home in one state with a home in another using these figures.
- The outcome of a disputed citation. The files record that a dispute exists, not how it ended.
- CMS star ratings. These are the citations, not the stars.
Where it comes from
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| state | State or territory name. |
| state_code | Two-letter postal code, as CMS writes it. |
| certified_homes | Medicare-certified nursing homes in the provider file. |
| repeat_harm_homes | Homes cited at scope/severity G or worse on two or more separate survey dates. |
| repeat_harm_pct | repeat_harm_homes ÷ certified_homes. EMPTY for a state with fewer than 10 certified homes — the page prints no share there either. |
| any_harm_homes | Homes cited at G or worse on at least one survey date. |
| any_harm_pct | any_harm_homes ÷ certified_homes. EMPTY below 10 homes. |
| fined_homes | Homes with at least one penalty in the penalties file. |
| fined_pct | fined_homes ÷ certified_homes. EMPTY below 10 homes. |
| median_fine_usd | Median total fine across FINED homes only, US dollars, no separators. Empty when no home in the state is fined. |
| median_nurse_turnover_pct | Median of CMS's reported nurse turnover, over homes in the state that report it. EMPTY where none reports it — a home that reports nothing is left out of the median, never counted as zero. |
| nurse_turnover_reporting_homes | How many homes that median is built on. |
| median_total_nurse_hprd | Median total nurse hours per resident day, CMS's payroll-based figure. Empty where not published. |
| abuse_icon_homes | Homes carrying CMS's own abuse icon. A count, not a share. |
| above_sample_floor | yes when the state has at least 10 certified homes, in which case the shares and medians are printed; no when it has fewer, in which case every share and median column is empty and only the counts are published. |
Served at /data/downloads/nursing-home-inspection-records-by-state.csv. Machine-readable provenance, including the exact SQL: nursing-home-inspection-records-by-state.meta.json
Cook County residential appeal outcomes by representation, 2023–2025
Cook County residential appeal outcomes split by whether the owner filed alone or through a lawyer or tax agent: county-wide for each tax year at both bodies, and by township at the Board of Review for tax year 2025.
Download cook-county-appeal-representation.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| cook-county-appeal-representation.csv | 46 | 4 KB | 6 county rows (2023–2025, both bodies) plus 38 Board of Review township rows for 2025 | 2026-09-28 |
Attribution required: Source: Cook County Assessor's Office, “Assessor - Appeals” (dataset y282-6ig3), loaded 2026-09-28; Cook County Assessor's Office, “Assessor - Assessed Values” (dataset uzyt-m557), loaded 2026-09-28; Cook County Board of Review, “Board of Review Appeal Decision History” (dataset 7pny-nedm), loaded 2026-09-28. Computed by CivicDelta.
What it contains
- Residential property only (class 2xx, including condominium units).
- Closed appeals with a recorded outcome. Pending appeals are excluded.
- Representation as the county's own files record it: an agent or attorney name present, or absent.
What it does not contain
- Evidence that hiring an agent hurts you. Agents pick the cases they take, and this file cannot see which cases those are.
- Any individual appeal, PIN, owner, agent or firm.
- Dollar amounts, or how large a reduction was.
- Townships below the sample floor at either representation level — those rows carry empty rates, not zeros.
Where it comes from
- Cook County Assessor's Office, “Assessor - Appeals” (dataset y282-6ig3), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Cook County Assessor's Office, “Assessor - Assessed Values” (dataset uzyt-m557), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Cook County Board of Review, “Board of Review Appeal Decision History” (dataset 7pny-nedm), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| geography | “Cook County” for a county-wide row, otherwise the township name. |
| geography_level | county or township. |
| tax_year | Tax year the appeals were filed against. |
| appeal_body | assessor or board_of_review. A win at the Assessor is a recorded change of value; a win at the Board of Review is a recorded result of “Decrease”. |
| self_filed_appeals | Appeals with no agent or attorney named on the record. Empty when we hold none. |
| self_filed_won | Of those, the number that changed or decreased the value. |
| self_filed_rate_pct | self_filed_won ÷ self_filed_appeals. EMPTY below 100 appeals — the study prints no share there either. |
| agent_filed_appeals | Appeals with an agent (Assessor file) or attorney firm (Board of Review file) named. |
| agent_filed_won | Of those, the number that changed or decreased the value. |
| agent_filed_rate_pct | agent_filed_won ÷ agent_filed_appeals. EMPTY below 100 appeals. |
| gap_percentage_points | self_filed_rate_pct minus agent_filed_rate_pct, signed. Positive means self-filed appeals were cut more often. Empty when either side is below the floor. |
| all_appeals | self_filed_appeals + agent_filed_appeals — every closed appeal the row covers. |
Served at /data/downloads/cook-county-appeal-representation.csv. Machine-readable provenance, including the exact SQL: cook-county-appeal-representation.meta.json
US nursing homes cited twice for the same harm, by ownership and chain size
US Medicare-certified nursing homes cited at harm level under the same federal requirement on two or more inspections, with harm on two or more inspections, fines and staffing medians, nationally and by ownership type and chain size.
Download nursing-homes-same-harm-by-ownership-and-chain.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| nursing-homes-same-harm-by-ownership-and-chain.csv | 56 | 3 KB | 14,690 certified homes; 56 rows (national, ownership types, chain bands) | 2026-09-14 |
Attribution required: Source: Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Citation Code Look-up” (dataset NH_CitationDescriptions_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14. Computed by CivicDelta.
What it contains
- Every Medicare-certified nursing home in CMS's provider file, in exactly one ownership row and one chain row.
- A requirement row for each federal requirement the study names, counting homes cited at harm level under it twice or more.
What it does not contain
- Any individual home, owner or chain name.
- Evidence that ownership causes harm. The groups differ in size, location, residents, payment and which state inspects them.
- The outcome of a disputed citation.
Where it comes from
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Citation Code Look-up” (dataset NH_CitationDescriptions_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| group_level | One of national, ownership, chain or requirement. |
| group | The ownership type as CMS records its first part, the chain band from CMS's chain fields, or the federal requirement code (prefix and tag) on a requirement row. |
| certified_homes | Medicare-certified homes in the group. |
| same_requirement_repeat_homes | Homes cited at scope/severity G or worse under one deficiency prefix and tag on two or more separate survey dates. |
| same_requirement_repeat_pct | same_requirement_repeat_homes ÷ certified_homes. EMPTY for a group of fewer than 10 homes. |
| repeat_harm_homes | Homes cited at G or worse on two or more separate survey dates, any requirement. |
| repeat_harm_pct | repeat_harm_homes ÷ certified_homes. EMPTY below 10 homes. |
| fined_homes | Homes with at least one fine in CMS's provider file. |
| fined_pct | fined_homes ÷ certified_homes. EMPTY below 10 homes. |
| median_total_nurse_hprd | Median total nurse hours per resident day over homes that report it. EMPTY where none report it or below the floor. |
| nurse_hprd_reporting_homes | How many homes that median is built on. |
| median_nurse_turnover_pct | Median nurse turnover over homes that report it. EMPTY where none report it or below the floor. |
| nurse_turnover_reporting_homes | How many homes that median is built on. |
| harm_citations | Harm-level (G or worse) citations in the file. NATIONAL ROW ONLY: citations are not split by ownership, chain band or requirement here. |
| harm_citations_from_complaints | Of those, citations written on a complaint investigation. National row only. |
| harm_complaint_pct | harm_citations_from_complaints ÷ harm_citations. National row only. |
Served at /data/downloads/nursing-homes-same-harm-by-ownership-and-chain.csv. Machine-readable provenance, including the exact SQL: nursing-homes-same-harm-by-ownership-and-chain.meta.json
US nursing home inspection figures by state
Per state or territory: certified nursing homes, harm on two or more inspections, the same requirement at harm level twice, fines, staffing medians, the complaint share of harm-level citations, Special Focus Facilities and recent ownership changes.
Download nursing-home-state-profiles.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| nursing-home-state-profiles.csv | 54 | 8 KB | 54 states and territories, 14,690 certified homes | 2026-09-14 |
Attribution required: Source: Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Citation Code Look-up” (dataset NH_CitationDescriptions_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14; Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14. Computed by CivicDelta.
What it contains
- Every Medicare-certified nursing home in CMS's provider file, aggregated to its state.
What it does not contain
- Any individual home or chain.
- A comparison between states: inspectors differ from state to state.
Where it comes from
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Citation Code Look-up” (dataset NH_CitationDescriptions_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Health Deficiencies” (dataset NH_HealthCitations_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Penalties” (dataset NH_Penalties_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
- Centers for Medicare & Medicaid Services (CMS) Provider Data Catalog, “CMS Care Compare - Nursing Home Provider Information” (dataset NH_ProviderInfo_Aug2026.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| state | State or territory name. |
| state_code | Two-letter postal code, as CMS writes it. |
| certified_homes | Medicare-certified nursing homes in the provider file. |
| repeat_harm_homes | Homes cited at G or worse on two or more survey dates. |
| repeat_harm_pct | repeat_harm_homes ÷ certified_homes. EMPTY below 10 homes. |
| same_requirement_repeat_homes | Homes cited at G or worse under one requirement on two or more survey dates. |
| same_requirement_repeat_pct | same_requirement_repeat_homes ÷ certified_homes. EMPTY below 10 homes. |
| fined_homes | Homes with at least one fine. |
| fined_pct | fined_homes ÷ certified_homes. EMPTY below 10 homes. |
| median_fine_usd | Median total fine over fined homes, US dollars. EMPTY below 10 homes or where none is fined. |
| median_total_nurse_hprd | Median total nurse hours per resident day over reporting homes. EMPTY below 10 homes. |
| median_nurse_turnover_pct | Median nurse turnover over reporting homes. EMPTY below 10 homes. |
| harm_citations | Harm-level (G or worse) citations at the state's homes. |
| harm_citations_from_complaints | Of those, citations written on a complaint investigation. |
| harm_complaint_pct | harm_citations_from_complaints ÷ harm_citations. EMPTY below 10 homes or 10 citations. |
| special_focus_facilities | Homes CMS lists as a Special Focus Facility. |
| special_focus_candidates | Homes CMS lists as a Special Focus Facility candidate. |
| abuse_icon_homes | Homes carrying CMS's abuse icon. |
| ownership_changed_12_months | Homes CMS flags as having changed ownership in the last 12 months. |
| chain_homes | Homes in this state that CMS lists as part of a chain, counted in this state. EMPTY on the United States row: chains are counted within a state, so these do not add up to a national figure. |
| repeat_harm_rank | Where the state ranks by repeat_harm_pct, 1 = highest, among the states and territories with at least 10 certified homes. EMPTY below that floor and on the United States row. |
| state_page | The page these figures are on. EMPTY where no page is published because the state has too few homes. |
Served at /data/downloads/nursing-home-state-profiles.csv. Machine-readable provenance, including the exact SQL: nursing-home-state-profiles.meta.json
Chicago building violations listed open, by year written and by bureau
City of Chicago building violations by the year they were recorded and by bureau: how many, how many are still listed OPEN, and how long the complied ones took.
Download chicago-building-violations-open-by-year.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| chicago-building-violations-open-by-year.csv | 37 | 2 KB | 2,030,308 violations dated 2006-01-01 to 2026-09-25 | 2026-09-28 |
Attribution required: Source: City of Chicago Department of Buildings, “Building Violations” (dataset 22u3-xenr), loaded 2026-09-28. Computed by CivicDelta.
What it contains
- Every violation in the city's Building Violations file with a violation date.
What it does not contain
- Any address, property or owner.
- Why a violation is still listed open; the file does not say.
Where it comes from
- City of Chicago Department of Buildings, “Building Violations” (dataset 22u3-xenr), loaded 2026-09-28 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| group_level | all for the first row (every violation in the file), then year and bureau rows. |
| group | The year the violation was recorded, or the bureau in the file's department_bureau field. |
| violations | Violations in the group. |
| listed_open | Of those, violations whose status in the city's file is OPEN. |
| listed_open_pct | listed_open ÷ violations. EMPTY below 100 violations. |
| complied | Year rows only: violations whose status is COMPLIED. EMPTY on bureau rows. |
| no_entry | Year rows only: violations whose status is NO ENTRY. EMPTY on bureau rows. |
| median_days_to_comply | Year rows only: median days from violation date to status date for COMPLIED violations with a status date on or after the violation date. EMPTY below 100 such violations and on bureau rows. |
| open_over_ten_years | Open violations recorded before 2016-09-25, on the all row and bureau rows. EMPTY on year rows. |
| open_over_ten_years_pct | open_over_ten_years ÷ listed_open, as a percentage to one decimal. EMPTY on year rows. |
Served at /data/downloads/chicago-building-violations-open-by-year.csv. Machine-readable provenance, including the exact SQL: chicago-building-violations-open-by-year.meta.json
California contractor licences in good standing by workers' compensation coverage and classification
California contractor licences in good standing (status CLEAR) on CSLB's License Master file, by classification: how many carry a workers' compensation exemption and how many carry insurance.
Download california-contractor-workers-comp-exemptions.csv See the page these numbers are on
| File | Rows | Size | Coverage | Last updated |
|---|---|---|---|---|
| california-contractor-workers-comp-exemptions.csv | 99 | 4 KB | 228,727 licences in good standing of 243,921 on the list, records updated to 2026-09-13 | 2026-09-14 |
Attribution required: Source: California Contractors State License Board (CSLB), “CSLB Master List of California Licensed Contractors - License Master” (dataset MasterLicenseData.csv), loaded 2026-09-14. Computed by CivicDelta.
What it contains
- Every licence with status CLEAR on the License Master file loaded on the date in sources.
What it does not contain
- Any licence number, business or person.
- Whether any exemption is used properly; the file cannot show who works on a job.
Where it comes from
- California Contractors State License Board (CSLB), “CSLB Master List of California Licensed Contractors - License Master” (dataset MasterLicenseData.csv), loaded 2026-09-14 — dataset page, publisher's terms (we have not yet had a person verify these terms)
Columns
| Column | What it holds |
|---|---|
| group_level | Either all or classification. |
| classification | CSLB classification code, written as CSLB writes it (C-61 subcategories as C-61/D-n). |
| licences_in_good_standing | Licences with primary status CLEAR holding the classification. A licence with several classifications counts in each. |
| exempt | Of those, licences whose workers' compensation coverage type is Exempt. |
| exempt_pct | exempt ÷ licences_in_good_standing. EMPTY below 1,000 licences. |
| workers_comp_insured | Of those, licences whose coverage type is Workers' Compensation Insurance. |
| exemption_not_allowed | yes for classifications CSLB says must carry insurance regardless of employees (C-8, C-20, C-22, C-39, D-49). EMPTY on the all row. |
Served at /data/downloads/california-contractor-workers-comp-exemptions.csv. Machine-readable provenance, including the exact SQL: california-contractor-workers-comp-exemptions.meta.json
Questions people ask
Can I republish these files?
Yes. CivicDelta's computation over the public records is free to reuse, including commercially, if you carry the attribution line printed with each file. The underlying government files carry their own publisher's terms, linked with each one; where we have not yet had a person verify those terms we say so rather than asserting a license on the publisher's behalf.
How often are they updated?
They are rebuilt in the same run as the pages they mirror, whenever the sources behind them are reloaded. The “Last updated” date on each file is the date we loaded the most recent source behind it, not the day the file happened to be written.
Why is a cell empty?
Either the publisher does not publish that value, or our sample floor suppresses it — fewer than 30 appeals in a township-year, fewer than 100 in a study cell, fewer than 10 certified homes in a state. We never write a zero or a state average in its place, because a reader cannot tell those apart from a measured zero.
What format are they in?
UTF-8 CSV with a single header row of plain column names, one row per record, and no merged or repeated header rows. Each file has a companion .meta.json with the publisher, dataset ID, load date, the exact SQL and the attribution line.