About this Dataset

Assembled Workers' Compensation Claims: Beginning 2000

The Workers’ Compensation Board (WCB) administers and regulates workers’ compensation benefits, disability benefits, volunteer firefighters’ benefits, volunteer ambulance workers’ benefits, and volunteer civil defense workers’ benefits. The WCB processes and adjudicates claims for benefits; ensures employer compliance with the requirement to maintain appropriate insurance coverage; and regulates the various system stakeholders, including self-insured employers, medical providers, third party administrators, insurance carriers and legal representatives. Claim assembly occurs when the WCB learns of a workplace injury and assigns the claim a WCB claim number. The WCB “assembles” a claim in which an injured worker has lost more than one week of work, has a serious injury that may result in a permanent disability, is disputed by the carrier or employer, or receives a claim form from the injured worker (Form C-3). A reopened claim is one that has been reactivated to resolve new issues following a finding that no further action was necessary
Organization: State of New York
Last updated: 2020-11-12T04:00:07.019361
Tags: assembled-claims, compensation-claims, wcb

Tables

Table 1

@usgov.state_of_new_york_assembled_workers_compensation_claim_f4fb2c32.table_1

250.81 MB
5,248,396 rows
54 columns

CREATE TABLE table_1 (
  "accident" VARCHAR,
  "accident_date" TIMESTAMP,
  "age_at_injury" BIGINT,
  "alternative_dispute_resolution" VARCHAR,
  "ancr_date" TIMESTAMP,
  "assembly_date" TIMESTAMP,
  "attorney_representative" VARCHAR,
  "average_weekly_wage_aww" DOUBLE  -- Average Weekly Wage (AWW),
  "birth_year" BIGINT,
  "c_2_date" TIMESTAMP,
  "c_3_date" TIMESTAMP,
  "carrier_name" VARCHAR,
  "carrier_type" VARCHAR,
  "claim_identifier" BIGINT,
  "claim_injury_type" VARCHAR,
  "claim_type" VARCHAR,
  "closed_count" BIGINT,
  "controverted_date" TIMESTAMP,
  "county_of_injury" VARCHAR,
  "covid_19_indicator" VARCHAR,
  "current_claim_status" VARCHAR,
  "district_name" VARCHAR,
  "first_appeal_date" TIMESTAMP,
  "first_hearing_date" TIMESTAMP,
  "gender" VARCHAR,
  "hearing_count" BIGINT,
  "highest_process" VARCHAR,
  "ime_4_count" DOUBLE,
  "industry_code" DOUBLE,
  "industry_code_description" VARCHAR,
  "interval_assembled_to_ancr" DOUBLE,
  "medical_fee_region" VARCHAR,
  "occupational_disease" VARCHAR,
  "oiics_event_exposure_code" VARCHAR,
  "oiics_event_exposure_description" VARCHAR,
  "oiics_injury_source_code" VARCHAR,
  "oiics_injury_source_description" VARCHAR,
  "oiics_nature_of_injury_code" VARCHAR,
  "oiics_nature_of_injury_description" VARCHAR,
  "oiics_part_of_body_code" VARCHAR,
  "oiics_part_of_body_description" VARCHAR,
  "oiics_secondary_source_code" VARCHAR,
  "oiics_secondary_source_description" VARCHAR,
  "ppd_non_scheduled_loss_date" TIMESTAMP,
  "ppd_scheduled_loss_date" TIMESTAMP,
  "ptd_date" TIMESTAMP,
  "section_32_date" TIMESTAMP,
  "wcio_cause_of_injury_code" DOUBLE,
  "wcio_cause_of_injury_description" VARCHAR,
  "wcio_nature_of_injury_code" DOUBLE,
  "wcio_nature_of_injury_description" VARCHAR,
  "wcio_part_of_body_code" DOUBLE,
  "wcio_part_of_body_description" VARCHAR,
  "zip_code" VARCHAR
);