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-29 sorted by cos_pos descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183532 | 183532 | 76.0 | APPERSON ST EL | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 2 | 0.46 | -0.23 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183579 | 183579 | 123.0 | BRAINARD EL | OPEN | green | 6 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 5 | 2.56 | 2.05 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184029 | 184029 | 573.0 | MOUNT GLEASON MS | OPEN | green | 10 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 107 | 12 | 1.37 | 0.57 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184030 | 184030 | 574.0 | MOUNTAIN VIEW EL | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 3 | 1 | 0.17 | -0.17 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184031 | 184031 | 575.0 | MT LUKENS HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184101 | 184101 | 645.0 | PINEWOOD AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184102 | 184102 | 646.0 | PINEWOOD AVE EL | OPEN | green | 20 | 7 | Past 7 days (8/22/2022 - 8/28/2022) | 201 | 25 | 9.92 | 9.13 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184104 | 184104 | 648.0 | PLAINVIEW ACADEMC CA | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 3 | 2 | 0.56 | 0.56 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184219 | 184219 | 763.0 | STONEHURST STEAM MAG | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | -0.30 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184224 | 184224 | 768.0 | SUNLAND EL | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 0.26 | -0.27 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184280 | 184280 | 824.0 | VERDGO HLS SH | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 8 | 0.5 | 0.00 | Sunland/Tujunga CoS | 56 | 1.08 | 0.58 | 339 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183514 | 183514 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183515 | 183515 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 3 | 3 | 0.48 | 0.48 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183564 | 183564 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183631 | 183631 | 175.0 | CASTELAR ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183632 | 183632 | 176.0 | CASTELAR ST EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 19 | 8 | 1.16 | 0.58 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183635 | 183635 | 179.0 | CASTRO MS | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 0 | 0.0 | -0.27 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183642 | 183642 | 186.0 | CDS TRI-C | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183644 | 183644 | 188.0 | CENTRAL HS | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 1 | 0.24 | -0.95 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183687 | 183687 | 231.0 | CORTINES SCH OF VAPA | OPEN | green | 38 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 149 | 46 | 2.82 | 1.90 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183704 | 183704 | 248.0 | DBM | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 9 | 4 | 0.34 | -0.67 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183708 | 183708 | 252.0 | DEL OLMO EL | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 12 | 4 | 0.64 | -0.16 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183922 | 183922 | 466.0 | LEE EL MED HLTH MAG | OPEN | green | 9 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 12 | 9 | 1.32 | 1.17 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183942 | 183942 | 486.0 | LOGAN ACADEMY | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 7 | 5 | 1.08 | 0.65 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183943 | 183943 | 487.0 | LOGAN ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184048 | 184048 | 592.0 | NEWMARK HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184105 | 184105 | 649.0 | PLASENCIA EL | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 4 | 3 | 0.54 | -0.35 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184159 | 184159 | 703.0 | ROSEMONT AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184160 | 184160 | 704.0 | ROSEMONT AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 4 | 1.47 | 1.47 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184163 | 184163 | 707.0 | ROYBAL LC | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 20 | 10 | 0.7 | -0.35 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184290 | 184290 | 834.0 | VIRGIL MS | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 19 | 7 | 0.58 | 0.16 | Downtown CoS | 104 | 0.88 | 0.26 | 268 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183512 | 183512 | 56.0 | ALDAMA EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 1 | 0.23 | -0.45 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183529 | 183529 | 73.0 | ANNANDALE EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | -1.18 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183539 | 183539 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 7 | 1.35 | -0.19 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183595 | 183595 | 139.0 | BUCHANAN ST EL | OPEN | green | 6 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 37 | 10 | 2.92 | 1.17 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183598 | 183598 | 142.0 | BURBANK MS A/T/C MAG | OPEN | green | 9 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 15 | 7 | 0.64 | -0.09 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183602 | 183602 | 146.0 | BUSHNELL WAY EL | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | -0.44 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183698 | 183698 | 242.0 | DAHLIA HTS EL | OPEN | yellow | 8 | 4 | Past 7 days (8/22/2022 - 8/28/2022) | 38 | 7 | 1.58 | -0.68 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183709 | 183709 | 253.0 | DELEVAN DRIVE EL | OPEN | green | 10 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 9 | 1.6 | 0.00 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183723 | 183723 | 267.0 | EAGLE ROCK EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 5 | 0.56 | 0.00 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183724 | 183724 | 268.0 | EAGLE ROCK HS | OPEN | green | 26 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 51 | 15 | 0.55 | -0.78 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183776 | 183776 | 320.0 | FRANKLIN HS | OPEN | green | 12 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 8 | 0.43 | 0.05 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183792 | 183792 | 336.0 | GARVANZA EL T/L MAG | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 20 | 2 | 0.63 | -0.32 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183850 | 183850 | 394.0 | HIGHLAND PARK HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184003 | 184003 | 547.0 | MERIDIAN EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184023 | 184023 | 567.0 | MONTE VISTA EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 1.18 | 0.00 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184024 | 184024 | 568.0 | MONTE VISTA ST EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 5 | 3 | 1.08 | 0.00 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184032 | 184032 | 576.0 | MT WASHINGTON EL | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 18 | 4 | 0.77 | -0.39 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184142 | 184142 | 686.0 | RIORDAN PC | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 6 | 4 | 2.27 | -2.28 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184150 | 184150 | 694.0 | ROCKDALE VAPA MAG | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 24 | 2 | 0.55 | -0.83 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184177 | 184177 | 721.0 | SAN PASCUAL STEAM MG | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 9 | 2 | 0.69 | -0.35 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184241 | 184241 | 785.0 | TOLAND WAY EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 2 | 0.69 | -0.35 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184351 | 184351 | 895.0 | YORKDALE EL | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 7 | 2 | 0.8 | -0.80 | Eagle Rock/Highland ParkCoS | 91 | 0.76 | -0.33 | 279 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183522 | 183522 | 66.0 | ANATOLA AVE EL | OPEN | green | 6 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 9 | 5 | 1.36 | 1.09 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183572 | 183572 | 116.0 | BLYTHE ST EL | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 2 | 0.51 | -1.27 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183608 | 183608 | 152.0 | CALAHAN ST EL | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 8 | 4 | 0.69 | -0.17 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183615 | 183615 | 159.0 | CANTARA ST EL | OPEN | green | 6 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 16 | 4 | 0.88 | -0.44 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183664 | 183664 | 208.0 | CLEVELAND CHS | OPEN | green | 20 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 24 | 17 | 0.45 | -0.02 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183665 | 183665 | 209.0 | CLEVELAND EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183666 | 183666 | 210.0 | CLEVELAND INFANT CTR | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183781 | 183781 | 325.0 | FULLBRIGHT AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 0.22 | -0.23 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183935 | 183935 | 479.0 | LIMERICK AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183950 | 183950 | 494.0 | LORNE ST EL | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 5 | 3 | 0.71 | 0.71 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184000 | 184000 | 544.0 | MELVIN AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 4 | 3 | 0.66 | 0.00 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184014 | 184014 | 558.0 | MILLER CTC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | 0.00 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184028 | 184028 | 572.0 | MOSK EL | OPEN | yellow | 27 | 4 | Past 7 days (8/22/2022 - 8/28/2022) | 61 | 26 | 4.26 | 0.16 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184038 | 184038 | 582.0 | NAPA ST EL | OPEN | green | 14 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 7 | 1.39 | -1.00 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184061 | 184061 | 605.0 | NORTHRIDGE EEC | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 0.91 | 0.00 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184062 | 184062 | 606.0 | NORTHRIDGE MS | OPEN | green | 8 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 19 | 8 | 0.93 | 0.35 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184097 | 184097 | 641.0 | PEARL SH JRNLS/CMM MG | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 17 | 3 | 0.91 | -1.22 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184212 | 184212 | 756.0 | STAGG ST EL | OPEN | green | 9 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 10 | 8 | 1.39 | 0.87 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184225 | 184225 | 769.0 | SUNNY BRAE AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 4 | 1 | 0.17 | -0.17 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184228 | 184228 | 772.0 | SUTTER MS | OPEN | green | 3 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 4 | 3 | 0.3 | 0.00 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184340 | 184340 | 884.0 | WINNETKA AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 12 | 2 | 0.46 | -0.22 | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184344 | 184344 | 888.0 | WOODEN HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 98 | 0.74 | -0.06 | 217 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183588 | 183588 | 132.0 | BROADOUS EEC | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 2 | 2 | 2.33 | 2.33 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183589 | 183589 | 133.0 | BROADOUS EL | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 15 | 8 | 1.57 | 1.18 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183654 | 183654 | 198.0 | CHAVEZ LA ARTES MAG | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 3 | 2 | 0.43 | 0.22 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183655 | 183655 | 199.0 | CHAVEZ LA ASE | OPEN | green | 9 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 14 | 7 | 1.15 | -0.17 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183656 | 183656 | 200.0 | CHAVEZ LA SJ HUM AC | OPEN | green | 9 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 9 | 1.41 | 0.78 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183657 | 183657 | 201.0 | CHAVEZ LA TECH PREP | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 0.19 | 0.19 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183721 | 183721 | 265.0 | DYER ST EL | OPEN | green | 8 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 26 | 9 | 1.26 | -0.28 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183734 | 183734 | 278.0 | EL DORADO AVE EL | OPEN | green | 10 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 6 | 1.28 | -0.64 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183760 | 183760 | 304.0 | EVERGREEN HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183819 | 183819 | 363.0 | GRIDLEY ST EL | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 2 | 0.32 | -0.63 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183824 | 183824 | 368.0 | HADDON AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | 0.00 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183825 | 183825 | 369.0 | HADDON AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 9 | 6 | 0.72 | 0.12 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183834 | 183834 | 378.0 | HARDING ST EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 6 | 4 | 0.87 | 0.65 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183848 | 183848 | 392.0 | HERRICK AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 17 | 5 | 1.01 | -1.81 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183867 | 183867 | 411.0 | HUBBARD ST EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 6 | 2 | 0.31 | -1.07 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184018 | 184018 | 562.0 | MISSION HS | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | -0.78 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184027 | 184027 | 571.0 | MORNINGSIDE EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 5 | 4 | 0.74 | 0.74 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184065 | 184065 | 615.0 | O'MELVENY EL | OPEN | green | 4 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 4 | 2 | 0.43 | -0.42 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184070 | 184070 | 613.0 | OLIVE VISTA MS | OPEN | green | 5 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 11 | 5 | 0.44 | -0.26 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184076 | 184076 | 620.0 | OSCEOLA ST EL | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 0 | 0.0 | -0.22 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184081 | 184081 | 625.0 | PACOIMA EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 1 | 1 | 1.22 | 0.00 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184169 | 184169 | 713.0 | SAN FERNANDO EEC | OPEN | green | 0 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184170 | 184170 | 714.0 | SAN FERNANDO EL | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184171 | 184171 | 715.0 | SAN FERNANDO MS | OPEN | green | 2 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 3 | 0 | 0.0 | -1.31 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
184172 | 184172 | 716.0 | SAN FERNANDO MS IAM | OPEN | green | 1 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 5 | 2 | 0.5 | -0.50 | San Fernando Valley/SylmarCoS | 131 | 0.67 | -0.16 | 258 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 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 );