offset problem in data #35
Description
For example, in the table 2023_long_term_care_facilities_utilization_data_nov_2024 in the dataset long-term-care-facilities-annual-utilization-data:
You can see in the data below that there has been a column slip. It is missing the first field and everything is offset by 1.
*************************** 3. row ***************************
description: 206010330
fac_no: HAYWARD RESIDENTIAL TREATMENT FACILITY
fac_name: 1782 B STREET
fac_str_addr: HAYWARD
fac_city: 94541
fac_zip: 2096402768
fac_phone: Claire Akers
fac_admin_name: Yes
fac_operated_this_yr: 2023-01-01 00:00:00
fac_op_per_begin_dt: 2023-12-31 00:00:00
fac_op_per_end_dt: Fair Oaks Residential Treatment Facility LLC
fac_par_corp_name: 2880 Zanker Rd. Suite 106
fac_par_corp_bus_addr: San Jose
fac_par_corp_city: CA - California
fac_par_corp_state: 95134
fac_par_corp_zip: Lee A. Cherbonnier
rept_prep_name: 2024-01-23 12:10:00
submitted_dt: NULL
rev_rept_prep_name: NULL
revised_dt: NULL
corrected_dt: 550007874
license_no: 2023-02-07 00:00:00
license_eff_date: 2024-02-06 00:00:00
license_exp_date: Open
license_status: Parent Facility
facility_level: -122.068364
longitude: 37.68155800
latitude: 37.68155800
assembly_dist: District 10
senate_dist: District 14
congress_dist: 06001435300
census_key: 2n
med_svc_study_area: NULL
la_county_svc_plan_area: 05 - East Bay
health_svc_area: Alameda
county: Congregate Living Health Facility
lic_cat: Investor - Limited Liability Company
licee_toc: NULL
fac_cert_medicare_sn: NULL
fac_cert_medi_cal_sn: NULL
fac_cert_medi_cal_sn_mentally_disord: NULL
cert_fac_medi_cal_ic_gen: NULL
cert_fac_medi_cal_ic_dev_dis: NULL
fac_cert_medi_cal_subacute_pediatric: NULL
sn_dec_31_py_cen: NULL
sn_nursing_plus_adm: NULL
sn_minus_discharges: NULL
sn_dec_31_cen: NULL
sn_pat_days_for: 0
sn_lic_beds: 0
sn_lic_bed_days: 2
pats_admitted_from_home: 107
pats_admitted_from_hsp: NULL
pats_admitted_from_state_hsp: NULL
pats_admitted_from_other_ltc: 3
pats_admitted_from_residential_board_and_care: NULL
pats_admitted_from_other: 112
tot_pats_admitted: NULL
medicare_pats: NULL
medi_cal_pats: 12
managed_care_pats: NULL
private_insurance_pats: NULL
self_pay_pats: NULL
all_other_pats: 12
tot_pats: 9
discharges_lt_2_wks: 30
discharges_2_wks_and_lt_1_month: 71
discharges_1_month_and_lt_3_months: NULL
discharges_3_months_and_lt_7_months: NULL
discharges_7_months_and_lt_1_yr: NULL
discharges_1_yr_and_lt_2_yrs: NULL
discharges_2_yrs_and_lt_3_yrs: NULL
discharges_3_yrs_and_lt_5_yrs: NULL
discharges_5_yrs_and_lt_7_yrs: NULL
discharges_7_yrs_and_lt_10_yrs: NULL
discharges_10_yrs_and_greater: 110
tot_discharges: No
fac_offer_hospice_prog_during_rept_period: 0
pats_diag_aids: No
fac_offer_alzheimer_prog: NULL
pats_primary_or_secondary_alzheimers_disease: NULL
sn_mentally_dis_dec_31_py_cen: NULL
sn_mentally_disord_plus_adm: NULL
sn_mentally_dis_minus_discharges: NULL
sn_mentally_dis_dec_31_cen: NULL
sn_mentally_dis_pat_days_for: 0
sn_mentally_dis_lic_beds: 0
sn_mentally_dis_lic_bed_days: NULL