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-10-27 sorted by cos_change
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193486 | 193486 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193640 | 193640 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193668 | 193668 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193707 | 193707 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193717 | 193717 | 283.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193735 | 193735 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193756 | 193756 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193811 | 193811 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193932 | 193932 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193943 | 193943 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193944 | 193944 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193945 | 193945 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193946 | 193946 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194024 | 194024 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194037 | 194037 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194178 | 194178 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194237 | 194237 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194238 | 194238 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194239 | 194239 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194240 | 194240 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194241 | 194241 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194242 | 194242 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194257 | 194257 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194283 | 194283 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194292 | 194292 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194314 | 194314 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193477 | 193477 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193478 | 193478 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193527 | 193527 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193720 | 193720 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193816 | 193816 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193883 | 193883 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193950 | 193950 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.32 | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194105 | 194105 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194282 | 194282 | 848.0 | WASHINGTON PREP SH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194290 | 194290 | 856.0 | WEST ATHENS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194321 | 194321 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193545 | 193545 | 111.0 | BERENDO MS | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 0.29 | 0.15 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193584 | 193584 | 150.0 | CAHUENGA EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193831 | 193831 | 397.0 | HOBART BLVD EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193832 | 193832 | 398.0 | HOBART BLVD EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193842 | 193842 | 408.0 | HOOVER ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193873 | 193873 | 439.0 | KIM ACADEMY | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.12 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193874 | 193874 | 440.0 | KIM EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193930 | 193930 | 496.0 | LOS ANGELES EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193942 | 193942 | 508.0 | MAGNOLIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193958 | 193958 | 524.0 | MARIPOSA-NABI PC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194088 | 194088 | 654.0 | POLITI EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.15 | 0.00 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194110 | 194110 | 676.0 | RFK AMBSDR GLBL EDU | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 1 | 0.27 | 0.27 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194111 | 194111 | 677.0 | RFK AMBSDR GLBL LDSH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194112 | 194112 | 678.0 | RFK LA SH ARTS | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.2 | 0.20 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194113 | 194113 | 679.0 | RFK NEW OPEN WLD | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194114 | 194114 | 680.0 | RFK SCH VIS ARTS/HUM | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194115 | 194115 | 681.0 | RFK UCLA COMM SCH | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 0.18 | 0.18 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194289 | 194289 | 855.0 | WEST ADAMS PREP SH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.16 | Kreatwn/PcoUnion CoS | 7 | 0.06 | -0.01 | 10 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193529 | 193529 | 95.0 | BALDWIN HILLS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193589 | 193589 | 155.0 | CANFIELD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.26 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193607 | 193607 | 173.0 | CARTHAY EL ES MAG | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193611 | 193611 | 177.0 | CASTLE HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193626 | 193626 | 192.0 | CHARNOCK ROAD EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193637 | 193637 | 203.0 | CHEVIOT HILLS HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193647 | 193647 | 213.0 | CLOVER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | 0.00 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193670 | 193670 | 236.0 | CRESCENT HTS BL EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193671 | 193671 | 237.0 | CRESCENT HTS BL EL MG | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 0 | 0.0 | -0.40 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193807 | 193807 | 373.0 | HAMILTON SH | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 2 | 0.08 | -0.08 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193961 | 193961 | 527.0 | MARLTON SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194055 | 194055 | 621.0 | OVERLAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.20 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194062 | 194062 | 628.0 | PALMS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194063 | 194063 | 629.0 | PALMS MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.15 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194170 | 194170 | 736.0 | SHENANDOAH ST EEC | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 2.9 | 2.90 | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
194171 | 194171 | 737.0 | SHENANDOAH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193434 | 193434 | 0.0 | 107TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.1 | 0.10 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193435 | 193435 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 2 | 0.04 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193440 | 193440 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193441 | 193441 | 7.0 | 122ND ST EL | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 2 | 0.29 | 0.14 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193456 | 193456 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193465 | 193465 | 31.0 | 54TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.39 | 0.39 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193470 | 193470 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193472 | 193472 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193473 | 193473 | 39.0 | 75TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.11 | 0.11 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193476 | 193476 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193480 | 193480 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193496 | 193496 | 62.0 | ALTA LOMA EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.22 | 0.22 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193503 | 193503 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193513 | 193513 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193526 | 193526 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193534 | 193534 | 100.0 | BARRETT EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193549 | 193549 | 115.0 | BETHUNE MS | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 0.2 | 0.20 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193563 | 193563 | 129.0 | BRIGHT EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193606 | 193606 | 172.0 | CARSON-GORE ACADEMY | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 1 | 0.22 | -1.32 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193617 | 193617 | 183.0 | CDS JOHNSON | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193638 | 193638 | 204.0 | CIENEGA EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193648 | 193648 | 214.0 | COCHRAN MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193755 | 193755 | 321.0 | FREMONT SH | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 1 | 0.04 | -0.05 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193762 | 193762 | 328.0 | GAL KING SCH FOR STEM | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 1 | 0.12 | 0.00 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193793 | 193793 | 359.0 | GRAPE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193799 | 193799 | 365.0 | GRIFFITH JOYNER EL | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.2 | 0.00 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193843 | 193843 | 409.0 | HOPE HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193864 | 193864 | 430.0 | JORDAN SH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193931 | 193931 | 497.0 | LOS ANGELES SH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM |
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 );