lausd-cases
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- school
- The name of the school.
- status
- Whether the school is open or closed.
- staff_student
- The current number of active cases among staff and students.
- transmission
- The number of school-linked cases.
- staff_student_rate
- The seven-day average of active cases per 100,000 students in this school's community of schools.
- community_rate
- The seven-day average of active cases per 100,000 residents in the school's surrounding community.
- lac_rate
- The seven-day average of active cases per 100,000 residents in Los Angeles County.
- community_schools
- The name of the community of schools that this school belongs to.
- community
- The name of the community where the school is located within.
- date
- The last updated date listed on the district's dashboard.
- time
- The last updated time listed on the district's dashboard.
898 rows where "date" is on date 2022-09-02 sorted by cos_pos_rate
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | Unnamed: 0 | school | status | color | staff_student | transmission | testing_period | tests | pos | pos_rate | change | cos | cos_tests | cos_pos | cos_pos_rate ▼ | cos_change | lausd_tests | lausd_pos | lausd_pos_rate | lausd_change | date | time | staff_student_rate | community_rate | lac_rate | community_schools | community |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187059 | 187059 | 11.0 | 15TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 1 | 0.21 | -0.22 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187088 | 187088 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 7 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 10 | 7 | 1.75 | 1.25 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187116 | 187116 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 0 | 0.0 | -1.16 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187145 | 187145 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187149 | 187149 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187196 | 187196 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187197 | 187197 | 149.0 | CABRILLO AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 4 | 0.96 | -0.24 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187286 | 187286 | 238.0 | CRESTWOOD ST STEAM MG | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.29 | -0.29 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187291 | 187291 | 243.0 | DANA MS | OPEN | green | 8 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 10 | 8 | 0.47 | 0.41 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187305 | 187305 | 257.0 | DODSON MS | OPEN | green | 16 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 77 | 17 | 1.07 | 0.06 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187518 | 187518 | 470.0 | LELAND ST EL | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.2 | -0.20 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187681 | 187681 | 633.0 | PARK WESTERN EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187682 | 187682 | 634.0 | PARK WSTN PL EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 1 | 0.16 | -0.15 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187710 | 187710 | 662.0 | PT FERMIN EL MR/S MG | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187770 | 187770 | 722.0 | SAN PEDRO CAS EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187771 | 187771 | 723.0 | SAN PEDRO SH | OPEN | green | 20 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 22 | 17 | 0.49 | 0.06 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187802 | 187802 | 754.0 | SOUTH SHORES EL PA MG | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 2 | 0.39 | 0.19 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187828 | 187828 | 780.0 | TAPER AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 1 | 0.13 | -0.64 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187916 | 187916 | 868.0 | WHITE POINT EL | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 1 | 0.26 | -1.02 | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187920 | 187920 | 872.0 | WILLENBERG SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 61 | 0.47 | -0.02 | 141 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187078 | 187078 | 30.0 | 52ND ST EL | OPEN | green | 5 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 4 | 0.51 | 0.25 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187081 | 187081 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187135 | 187135 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187136 | 187136 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187188 | 187188 | 140.0 | BUDLONG AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 3 | 0.39 | 0.13 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187237 | 187237 | 189.0 | CENTURY PARK EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 1 | 0.26 | 0.26 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187253 | 187253 | 205.0 | CIMARRON AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 4 | 1.12 | 0.84 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187267 | 187267 | 219.0 | COLISEUM ST EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 0 | 0.0 | -1.49 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187268 | 187268 | 220.0 | COLLINS EEC | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 1.54 | 1.54 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187332 | 187332 | 284.0 | ELEMENTARY CDS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187435 | 187435 | 387.0 | HAWKINS SH C/DAGS | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 9 | 2 | 0.12 | -0.24 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187470 | 187470 | 422.0 | IOVINE YOUNG CTR MAG | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 0 | 0.0 | -1.72 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187511 | 187511 | 463.0 | LAWSON ACAD A/M/S EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 3 | 0.51 | 0.34 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187565 | 187565 | 517.0 | MANN UCLA COMM SCH | OPEN | green | 5 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 2 | 0.29 | -0.58 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187600 | 187600 | 552.0 | MIDDLE COLLEGE HS | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 1 | 0.2 | 0.00 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187625 | 187625 | 577.0 | MUIR MS | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 2 | 0.25 | -0.12 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187684 | 187684 | 636.0 | PARKS/HUERTA EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187778 | 187778 | 730.0 | SECONDARY CDS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187908 | 187908 | 860.0 | WESTERN AV TECH MAG | OPEN | green | 5 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 3 | 0.46 | 0.00 | South Mid-City CoS | 26 | 0.3 | -0.06 | 45 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187062 | 187062 | 14.0 | 20TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 4 | 0.62 | 0.16 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187066 | 187066 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187067 | 187067 | 19.0 | 28TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 2 | 0.32 | -0.48 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187096 | 187096 | 48.0 | 9TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187098 | 187098 | 50.0 | ADAMS MS | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 4 | 0.47 | 0.12 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187260 | 187260 | 212.0 | CLINTON MS | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.12 | -0.12 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187319 | 187319 | 271.0 | EARLY COLLEGE ACAD | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187460 | 187460 | 412.0 | HUERTA EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187476 | 187476 | 428.0 | JONES EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 2 | 0.56 | -0.28 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187480 | 187480 | 432.0 | KAHLO HS | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187529 | 187529 | 481.0 | LIZARRAGA EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 1 | 0.17 | 0.00 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187567 | 187567 | 519.0 | MAPLE PC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187667 | 187667 | 619.0 | ORTHOPAEDIC HSP SH MG | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 2 | 0.21 | -0.11 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187772 | 187772 | 724.0 | SAN PEDRO ST EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 6 | 3 | 0.51 | 0.34 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187774 | 187774 | 726.0 | SANTEE EC | OPEN | green | 6 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 8 | 5 | 0.21 | -0.05 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187844 | 187844 | 796.0 | TRINITY EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 1 | 1.64 | 1.64 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187845 | 187845 | 797.0 | TRINITY ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187888 | 187888 | 840.0 | WADSWORTH AVE EEC | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 2 | 2.27 | 2.27 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187889 | 187889 | 841.0 | WADSWORTH AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 2 | 0.27 | -0.14 | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187907 | 187907 | 859.0 | WEST VERNON AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 29 | 0.26 | -0.08 | 46 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187073 | 187073 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187080 | 187080 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187085 | 187085 | 37.0 | 74TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 1 | 0.22 | 0.00 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187134 | 187134 | 86.0 | AUDUBON MS | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 3 | 0.56 | -0.18 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187170 | 187170 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187283 | 187283 | 235.0 | CRENSHAW MAG STEMM | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.13 | 0.00 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187310 | 187310 | 262.0 | DORSEY SH | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187443 | 187443 | 395.0 | HILLCREST DR EL | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 3 | 0.45 | 0.00 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187466 | 187466 | 418.0 | HYDE PARK EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187877 | 187877 | 829.0 | VIEW PARK CONTN HS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187942 | 187942 | 894.0 | YES ACADEMY | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 2 | 2 | 0.34 | -0.68 | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187944 | 187944 | 896.0 | YOUNG HS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 10 | 0.2 | -0.11 | 17 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187082 | 187082 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187083 | 187083 | 35.0 | 66TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 4 | 0.48 | 0.12 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187139 | 187139 | 91.0 | BACA ARTS ACAD | OPEN | green | 7 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 13 | 7 | 1.05 | 0.30 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187153 | 187153 | 105.0 | BEETHOVEN ST EL | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 0 | 0.0 | -1.08 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187168 | 187168 | 120.0 | BRADDOCK DR EL | OPEN | green | 8 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 9 | 7 | 1.04 | -0.14 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187169 | 187169 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187182 | 187182 | 134.0 | BROADWAY EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 3 | 0.5 | -0.17 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187263 | 187263 | 215.0 | COEUR D ALENE AVE EL | OPEN | green | 11 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 17 | 12 | 2.33 | 1.94 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187311 | 187311 | 263.0 | DREW MS | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.12 | 0.00 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187312 | 187312 | 264.0 | DREW MS UP PBLC SRVC | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.27 | 0.27 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187314 | 187314 | 266.0 | DYMALLY SH | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 3 | 0.3 | -0.10 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187324 | 187324 | 276.0 | EDISON MS | OPEN | green | 6 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 5 | 0.48 | -0.39 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187377 | 187377 | 329.0 | GARCETTI LA | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 0 | 0.0 | -0.46 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187400 | 187400 | 352.0 | GRAHAM EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187401 | 187401 | 353.0 | GRAHAM EL | OPEN | green | 5 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 3 | 0.41 | -0.13 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187403 | 187403 | 355.0 | GRAND VW BL EL | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 5 | 1 | 0.15 | -0.15 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187491 | 187491 | 443.0 | KING-DREW SH MD/S MG | OPEN | green | 13 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 16 | 12 | 0.64 | -0.37 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187568 | 187568 | 520.0 | MAR VISTA EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 6 | 2 | 0.31 | -0.30 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187570 | 187570 | 522.0 | MARINA DEL REY MS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 0 | 0.0 | -0.18 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187571 | 187571 | 523.0 | MARINA EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187573 | 187573 | 525.0 | MARK TWAIN MS | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 4 | 2 | 0.19 | 0.00 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187589 | 187589 | 541.0 | MCBRIDE SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187590 | 187590 | 542.0 | MCKINLEY AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 3 | 2 | 0.3 | 0.30 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187608 | 187608 | 560.0 | MIRAMONTE EEC | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187609 | 187609 | 561.0 | MIRAMONTE EL | OPEN | green | 9 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 6 | 0.74 | 0.00 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187618 | 187618 | 570.0 | MOORE M/S/T ACAD | OPEN | green | 1 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 1 | 1 | 0.15 | 0.15 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187685 | 187685 | 637.0 | PARMELEE AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 6 | 4 | 0.46 | -0.35 | Rivera CoS | 67 | 0.42 | -0.12 | 113 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187692 | 187692 | 644.0 | PHOENIX HS | OPEN | green | 0 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
187698 | 187698 | 650.0 | PLAYA DEL REY EL | OPEN | green | 3 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 7 | 2 | 0.6 | -0.59 | Venice CoS | 44 | 0.42 | -0.12 | 81 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "lausd-cases" ( [Unnamed: 0] FLOAT, [school] TEXT, [status] TEXT, [color] TEXT, [staff_student] INTEGER, [transmission] INTEGER, [testing_period] TEXT, [tests] TEXT, [pos] TEXT, [pos_rate] TEXT, [change] TEXT, [cos] TEXT, [cos_tests] TEXT, [cos_pos] TEXT, [cos_pos_rate] TEXT, [cos_change] TEXT, [lausd_tests] TEXT, [lausd_pos] TEXT, [lausd_pos_rate] TEXT, [lausd_change] FLOAT, [date] TEXT, [time] TEXT, [staff_student_rate] FLOAT, [community_rate] FLOAT, [lac_rate] FLOAT, [community_schools] TEXT, [community] TEXT );