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-08-30 sorted by cos_tests
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184406 | 184406 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184560 | 184560 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184588 | 184588 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184627 | 184627 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184637 | 184637 | 283.0 | ELA OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.01 | -0.03 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184655 | 184655 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184676 | 184676 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 6 | 3 | 0.04 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184731 | 184731 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 0 | 0.0 | -0.03 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184852 | 184852 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.01 | -0.02 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184863 | 184863 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184864 | 184864 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184865 | 184865 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184866 | 184866 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184944 | 184944 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.21 | 0.21 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184957 | 184957 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.02 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185098 | 185098 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185157 | 185157 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185158 | 185158 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 0 | 0.0 | -0.08 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185159 | 185159 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185160 | 185160 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185161 | 185161 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185162 | 185162 | 808.0 | VA STEAM | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 3 | 0.22 | 0.15 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185177 | 185177 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185203 | 185203 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 2 | 0.03 | 0.02 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185212 | 185212 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 0 | 0.0 | -0.06 | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185234 | 185234 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184397 | 184397 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184398 | 184398 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 5 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184447 | 184447 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184640 | 184640 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184736 | 184736 | 382.0 | HARTE PREP MS | OPEN | green | 4 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 3 | 3 | 0.53 | 0.35 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184803 | 184803 | 449.0 | LA SALLE AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.24 | 0.24 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184870 | 184870 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.29 | -0.58 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185025 | 185025 | 671.0 | RAYMOND AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 3 | 2 | 0.36 | -0.54 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185202 | 185202 | 848.0 | WASHINGTON PREP SH | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.09 | 0.00 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185210 | 185210 | 856.0 | WEST ATHENS EL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 1 | 0.13 | 0.00 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185241 | 185241 | 887.0 | WOODCREST EL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.13 | 0.13 | H.E.E.T. (W) CoS | 10 | 0.18 | -0.02 | 19 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184412 | 184412 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184413 | 184413 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.16 | -0.16 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184462 | 184462 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184529 | 184529 | 175.0 | CASTELAR ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184530 | 184530 | 176.0 | CASTELAR ST EL | OPEN | green | 4 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 15 | 4 | 0.58 | -0.58 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184533 | 184533 | 179.0 | CASTRO MS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 0 | 0.0 | -0.26 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184540 | 184540 | 186.0 | CDS TRI-C | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184542 | 184542 | 188.0 | CENTRAL HS | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.24 | -0.95 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184585 | 184585 | 231.0 | CORTINES SCH OF VAPA | OPEN | green | 45 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 148 | 44 | 2.7 | 1.04 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184602 | 184602 | 248.0 | DBM | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 9 | 5 | 0.42 | -0.25 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184606 | 184606 | 252.0 | DEL OLMO EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 13 | 4 | 0.64 | -0.32 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184669 | 184669 | 315.0 | FLORENCE AVE EL | OPEN | green | 11 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 23 | 12 | 1.71 | -0.29 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184681 | 184681 | 327.0 | GAGE MS | OPEN | green | 11 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 13 | 6 | 0.43 | -1.13 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184756 | 184756 | 402.0 | HOLMES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184757 | 184757 | 403.0 | HOLMES AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184764 | 184764 | 410.0 | HOPE ST EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 13 | 6 | 1.23 | 0.82 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184770 | 184770 | 416.0 | HUNTNGTN PK EL | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 3 | 0 | 0.0 | -0.49 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184771 | 184771 | 417.0 | HUNTNGTN PK SH | OPEN | green | 15 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 20 | 12 | 0.6 | -0.25 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184820 | 184820 | 466.0 | LEE EL MED HLTH MAG | OPEN | green | 10 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 14 | 11 | 1.62 | 1.47 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184832 | 184832 | 478.0 | LILLIAN ST EL | OPEN | green | 3 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 1 | 0.23 | -0.47 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184840 | 184840 | 486.0 | LOGAN ACADEMY | OPEN | green | 8 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 9 | 7 | 1.52 | 0.87 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184841 | 184841 | 487.0 | LOGAN ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184883 | 184883 | 529.0 | MARQUEZ SH HPIAM | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 9 | 3 | 0.3 | -0.49 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184884 | 184884 | 530.0 | MARQUEZ SH LIBRA | OPEN | green | 18 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 23 | 15 | 1.76 | 0.35 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184885 | 184885 | 531.0 | MARQUEZ SH SOC JUS | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 4 | 0.47 | 0.23 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184907 | 184907 | 553.0 | MIDDLETON ST EL | OPEN | green | 9 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 9 | 6 | 0.78 | -0.25 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184908 | 184908 | 554.0 | MIDDLETON ST PC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184910 | 184910 | 556.0 | MILES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184911 | 184911 | 557.0 | MILES AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 21 | 7 | 0.0 | -0.30 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184946 | 184946 | 592.0 | NEWMARK HS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184948 | 184948 | 594.0 | NIMITZ MS | OPEN | green | 4 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 12 | 6 | 0.44 | -0.22 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184978 | 184978 | 624.0 | PACIFIC BLVD SCHOOL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.21 | -0.62 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185003 | 185003 | 649.0 | PLASENCIA EL | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 5 | 4 | 0.71 | -0.18 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185057 | 185057 | 703.0 | ROSEMONT AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185058 | 185058 | 704.0 | ROSEMONT AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 9 | 3 | 1.1 | 0.73 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185061 | 185061 | 707.0 | ROYBAL LC | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 19 | 9 | 0.63 | -0.63 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185062 | 185062 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 7 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 19 | 6 | 1.04 | 0.00 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185065 | 185065 | 711.0 | SAN ANTONIO EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 21 | 7 | 1.21 | -0.35 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185066 | 185066 | 712.0 | SAN ANTONIO HS | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.75 | 0.00 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185180 | 185180 | 826.0 | VERNON CITY EL | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 1 | 0.45 | -0.89 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185188 | 185188 | 834.0 | VIRGIL MS | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 18 | 7 | 0.58 | 0.25 | Downtown CoS | 100 | 0.84 | 0.08 | 264 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185197 | 185197 | 843.0 | WALNUT PARK EL | OPEN | green | 8 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 23 | 4 | 0.56 | -1.26 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185198 | 185198 | 844.0 | WALNUT PARK MS SJ/SL | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 5 | 1 | 0.21 | -1.48 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185199 | 185199 | 845.0 | WALNUT PARK MS STEM | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 1 | 0.25 | -0.25 | Huntington Park/VernonCoS | 100 | 0.64 | -0.38 | 229 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184436 | 184436 | 82.0 | ARMSTRONG MS | OPEN | green | 9 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 26 | 9 | 0.54 | -0.35 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184517 | 184517 | 163.0 | CARDENAS EL | OPEN | green | 3 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 4 | 3 | 0.54 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184539 | 184539 | 185.0 | CDS LONDON | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184544 | 184544 | 190.0 | CHANDLER EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 8 | 4 | 0.83 | -0.42 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184571 | 184571 | 217.0 | COLDWATER CYN EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 10 | 6 | 0.8 | 0.53 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184575 | 184575 | 221.0 | COLUMBUS AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 3 | 1 | 0.2 | -0.41 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184610 | 184610 | 256.0 | DIXIE CYN CC | OPEN | green | 2 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 7 | 2 | 0.26 | -0.66 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184646 | 184646 | 292.0 | ERWIN EL | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 11 | 6 | 0.82 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184712 | 184712 | 358.0 | GRANT SH | OPEN | green | 19 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 15 | 12 | 0.47 | -0.07 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184743 | 184743 | 389.0 | HAZELTINE AVE EL | OPEN | green | 6 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 7 | 4 | 0.49 | -0.37 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184792 | 184792 | 438.0 | KESTER AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 12 | 5 | 0.52 | -0.42 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184799 | 184799 | 445.0 | KITTRIDGE ST EL | OPEN | green | 3 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 2 | 2 | 0.24 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184845 | 184845 | 491.0 | LONDON HS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184861 | 184861 | 507.0 | MADISON MS | OPEN | green | 8 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 11 | 8 | 0.5 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
184918 | 184918 | 564.0 | MONLUX EL | OPEN | green | 8 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 21 | 9 | 1.16 | 0.77 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185046 | 185046 | 692.0 | RIVERSIDE DR CS | OPEN | green | 7 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 10 | 5 | 1.08 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185050 | 185050 | 696.0 | ROGERS HS | OPEN | green | 0 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 1 | 0 | 0.0 | 0.00 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185093 | 185093 | 739.0 | SHERMAN OAKS EL CS | OPEN | green | 11 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 8 | 8 | 1.27 | 0.63 | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
185131 | 185131 | 777.0 | SYLVAN PARK EEC | OPEN | green | 1 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 102 | 0.5 | -0.06 | 195 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM |
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 );