About this Dataset

Closed Iowa Vocational Rehabilitation Cases

Iowa Vocational Rehabilitation Services (IVRS) mission is to provide expert, individualized services to Iowans with disabilities to achieve their independence through successful employment and economic support. This dataset provides information on closed cases where the individual received services from IVRS. Data includes cases closed after October 1, 2008.
Organization: State of Iowa
Last updated: 2023-01-19T23:58:02.789770
Tags: disability, employment, hours-worked, referrals, transition, veteran, wages

Tables

Table 1

@usgov.state_of_iowa_closed_iowa_vocational_rehabilitation_cases.table_1

2.52 MB
62,055 rows
40 columns

CREATE TABLE table_1 (
  "federal_fiscal_year" BIGINT,
  "case_id" BIGINT,
  "client_county" VARCHAR,
  "office_area" VARCHAR,
  "gender" VARCHAR,
  "minority_group" VARCHAR,
  "transition_student_status" VARCHAR,
  "veteran_status" VARCHAR,
  "service_provided" VARCHAR,
  "meet_sd_categories" VARCHAR,
  "disability_category" VARCHAR,
  "disability_type" VARCHAR,
  "application_date" TIMESTAMP,
  "age_at_application" BIGINT,
  "hourly_wage_application" DOUBLE  -- Hourly Wage (Application),
  "monthly_wage_application" DOUBLE  -- Monthly Wage (Application),
  "annual_wage_application" DOUBLE  -- Annual Wage (Application),
  "primary_support_personal_income_application" VARCHAR  -- Primary Support - Personal Income (Application),
  "closure_date" TIMESTAMP,
  "months_case_open" BIGINT,
  "status_code" VARCHAR,
  "status_name" VARCHAR,
  "closure_description" VARCHAR,
  "rsa_closure_reason" VARCHAR,
  "primary_support_closure" VARCHAR  -- Primary Support (Closure),
  "age_at_closure" BIGINT,
  "employed_closure" VARCHAR  -- Employed (Closure),
  "primary_support_personal_income_closure" VARCHAR  -- Primary Support - Personal Income (Closure),
  "competitive_employment_closure" VARCHAR  -- Competitive Employment (Closure),
  "soc_category_closure" VARCHAR  -- SOC Category (Closure),
  "soc_description_closure" VARCHAR  -- SOC Description (Closure),
  "hours_worked_week_closure" DOUBLE  -- Hours Worked/Week (Closure),
  "hourly_wage_closure" DOUBLE  -- Hourly Wage (Closure),
  "monthly_wage_closure" DOUBLE  -- Monthly Wage (Closure),
  "annual_wage_closure" DOUBLE  -- Annual Wage (Closure),
  "hourly_wage_change" DOUBLE,
  "monthly_wage_change" DOUBLE,
  "annual_wage_change" DOUBLE,
  "client_location" VARCHAR,
  "client_location_point" VARCHAR
);