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-27 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181712 | 181712 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181866 | 181866 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.16 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181894 | 181894 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181933 | 181933 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181943 | 181943 | 283.0 | ELA OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.04 | -0.01 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181961 | 181961 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181982 | 181982 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.03 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182037 | 182037 | 377.0 | HARBOR OCC CTR | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182158 | 182158 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182169 | 182169 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182170 | 182170 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182171 | 182171 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182172 | 182172 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182250 | 182250 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.21 | 0.21 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182263 | 182263 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182404 | 182404 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182463 | 182463 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182464 | 182464 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182465 | 182465 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182466 | 182466 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182467 | 182467 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182468 | 182468 | 808.0 | VA STEAM | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.22 | 0.22 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182483 | 182483 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182509 | 182509 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.03 | -0.01 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182518 | 182518 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 2 | 0.02 | -0.08 | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182540 | 182540 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181714 | 181714 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181715 | 181715 | 55.0 | ALBION ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 2.56 | 2.05 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181731 | 181731 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -2.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181784 | 181784 | 124.0 | BRAVO SH MEDICAL MAG | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 12 | 0.55 | 0.04 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181857 | 181857 | 197.0 | CHAVEZ EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 0 | 0.0 | -1.61 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181867 | 181867 | 207.0 | CITY TERRACE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.22 | -0.44 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181940 | 181940 | 280.0 | EL SERENO EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181941 | 181941 | 281.0 | EL SERENO EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 1.52 | 0.61 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181942 | 181942 | 282.0 | EL SERENO MS | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 6 | 0.57 | -0.09 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181969 | 181969 | 309.0 | FARMDALE EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 7 | 1.79 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181998 | 181998 | 338.0 | GATES ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181999 | 181999 | 339.0 | GATES ST EL | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 13 | 10 | 1.67 | 0.67 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182006 | 182006 | 346.0 | GLEN ALTA EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.65 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182024 | 182024 | 364.0 | GRIFFIN AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.47 | -0.47 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182040 | 182040 | 380.0 | HARRISON ST EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 2 | 0.52 | -0.26 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182056 | 182056 | 396.0 | HILLSIDE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 2 | 1.39 | 0.70 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182075 | 182075 | 415.0 | HUNTINGTON DR EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.81 | -0.27 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182093 | 182093 | 433.0 | KENNEDY EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 1.21 | 0.40 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182119 | 182119 | 459.0 | LATONA AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.49 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182140 | 182140 | 480.0 | LINCOLN SH | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 18 | 8 | 0.54 | -0.21 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182153 | 182153 | 493.0 | LORETO ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182239 | 182239 | 579.0 | MULTNOMAH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.25 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182240 | 182240 | 580.0 | MURCHISON EEC | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 2.13 | 1.07 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182241 | 182241 | 581.0 | MURCHISON ST EL | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 9 | 2.01 | 1.12 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182253 | 182253 | 593.0 | NIGHTINGALE MS | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.31 | -0.63 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182323 | 182323 | 663.0 | PUEBLO DE LA HS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182402 | 182402 | 742.0 | SIERRA PARK EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.26 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182403 | 182403 | 743.0 | SIERRA VISTA EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 1.3 | 0.87 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182406 | 182406 | 746.0 | SOLANO AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 4 | 1.77 | 0.44 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182539 | 182539 | 879.0 | WILSON SH | OPEN | green | 14 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 11 | 0.58 | -0.15 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181720 | 181720 | 60.0 | ALLESANDRO EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.25 | 0.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181737 | 181737 | 77.0 | ARAGON AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.4 | 0.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181745 | 181745 | 85.0 | ATWATER AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 3 | 0.75 | -0.51 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181871 | 181871 | 211.0 | CLIFFORD ST M/T MAG | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 2.38 | 1.59 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181906 | 181906 | 246.0 | DAYTON EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181907 | 181907 | 247.0 | DAYTON HEIGHTS EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 5 | 1.62 | 1.30 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181921 | 181921 | 261.0 | DORRIS PLACE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 2 | 0.67 | -1.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181947 | 181947 | 287.0 | ELYSIAN HTS ARTS MAG | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 8 | 7 | 1.59 | 1.13 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181974 | 181974 | 314.0 | FLETCHER DR EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.45 | 0.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181979 | 181979 | 319.0 | FRANKLIN AVE EL | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 6 | 1.24 | 0.21 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182002 | 182002 | 342.0 | GLASSELL PARK EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182003 | 182003 | 343.0 | GLASSELL PK STEAM MAG | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.65 | 0.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182007 | 182007 | 347.0 | GLENFELIZ BLVD EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -1.85 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182008 | 182008 | 348.0 | GLENFELIZ BLVD EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182085 | 182085 | 425.0 | IVANHOE EL | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 7 | 1.39 | 0.99 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182102 | 182102 | 442.0 | KING MS MAG FLM/MDIA | OPEN | green | 24 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 39 | 28 | 1.37 | 0.49 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182134 | 182134 | 474.0 | LEXINGTON AVE PC | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 2 | 1.44 | 0.00 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182145 | 182145 | 485.0 | LOCKWOOD AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182159 | 182159 | 499.0 | LOS FELIZ STEMM MAG | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182192 | 182192 | 532.0 | MARSHALL SH | OPEN | green | 20 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 26 | 17 | 0.62 | -0.25 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182196 | 182196 | 536.0 | MAYBERRY ST EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.46 | -0.46 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182210 | 182210 | 550.0 | MICHELTORENA ST EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.5 | 0.25 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182409 | 182409 | 749.0 | SOTOMAYOR ART/SCI MAG | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.54 | 0.54 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181673 | 181673 | 13.0 | 1ST ST EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.61 | 0.00 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181680 | 181680 | 20.0 | 2ND ST EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.38 | 0.00 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181778 | 181778 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 2.63 | -2.63 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181779 | 181779 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.47 | 0.00 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181785 | 181785 | 125.0 | BREED ST EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.88 | 0.59 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181787 | 181787 | 127.0 | BRIDGE ST EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181901 | 181901 | 241.0 | DACOTAH EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181914 | 181914 | 254.0 | DENA EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181960 | 181960 | 300.0 | EUCLID AVE EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 8 | 8 | 1.06 | 0.93 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181962 | 181962 | 302.0 | EVERGREEN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -1.11 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181963 | 181963 | 303.0 | EVERGREEN AVE EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 6 | 0.92 | 0.31 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181997 | 181997 | 337.0 | GARZA PC | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 2.26 | 1.51 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182059 | 182059 | 399.0 | HOLLENBECK MS | OPEN | green | 14 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 17 | 14 | 1.22 | 0.44 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182152 | 182152 | 492.0 | LORENA ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 5 | 1.06 | 0.42 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182174 | 182174 | 514.0 | MALABAR ST EL | OPEN | green | 11 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 10 | 1.81 | 1.08 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182205 | 182205 | 545.0 | MENDEZ SH | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 7 | 0.56 | 0.40 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182208 | 182208 | 548.0 | METROPOLITAN HS | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 1.69 | 1.69 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182358 | 182358 | 698.0 | ROOSEVELT INFANT | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182359 | 182359 | 699.0 | ROOSEVELT SH | OPEN | green | 22 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 26 | 22 | 0.97 | 0.48 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182360 | 182360 | 700.0 | ROOSEVELT SH STM MAG | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.15 | -0.43 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182398 | 182398 | 738.0 | SHERIDAN ST EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.43 | -0.44 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 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 );