About this Dataset

COVID-19 In Local Juvenile Detention Facilities

Testing and outcomes data in local juvenile detention facilities.
Organization: State of California
Last updated: 2023-03-10T15:40:50.162560
Tags: board-of-state-and-community-corrections, bscc, coronavirus, covid, covid-19, covid19, facility, hall, juvenile, juvenile-facility, juvenile-hall, local-detention, local-juvenile-detention, outcome, testing, youth

Tables

COVID-19 In Local Juvenile Detention Facilities

@usgov.ca_gov_covid_19_in_local_juvenile_detention_facilities.covid_19_in_local_juvenile_detention_facilities

87.22 kB
15,328 rows
39 columns

CREATE TABLE covid_19_in_local_juvenile_detention_facilities (
  "reporting_period" TIMESTAMP,
  "county" VARCHAR,
  "facility_name" VARCHAR,
  "youth_in_facility" VARCHAR,
  "youth_tested" VARCHAR,
  "youth_confirmed_positive" VARCHAR,
  "youth_confirmed_at_intake_optional" VARCHAR  -- Youth Confirmed At Intake (Optional),
  "youth_confirmed_in_first_14_days_optional" VARCHAR  -- Youth Confirmed In First 14 Days (Optional),
  "youth_confirmed_in_custody_optional" VARCHAR  -- Youth Confirmed In Custody (Optional),
  "youth_hospitalized" VARCHAR,
  "estimated_youth_resolved" VARCHAR,
  "youth_deaths" VARCHAR,
  "additional_information_optional" VARCHAR  -- Additional Information (Optional),
  "staff_tested" VARCHAR,
  "staff_confirmed_positive" VARCHAR,
  "staff_resolved" VARCHAR,
  "additional_county_information" VARCHAR,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38
);