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.
890 rows where "date" is on date 2022-06-28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172719 | 172719 | 205.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 23.0 | 1 | 0.01 | -0.01 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172747 | 172747 | 233.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
172786 | 172786 | 272.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
172796 | 172796 | 282.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172814 | 172814 | 300.0 | EVANS CAS | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 25.0 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172835 | 172835 | 321.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 4.0 | 0 | 0.00 | -0.02 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172890 | 172890 | 376.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172935 | 172935 | 421.0 | IOVINE YOUNG CTR MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
173011 | 173011 | 497.0 | LOS ANGELES TECH CTR | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 11.0 | 2 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173022 | 173022 | 508.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
173023 | 173023 | 509.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
173024 | 173024 | 510.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
173025 | 173025 | 511.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
173103 | 173103 | 589.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 12.0 | 0 | 0.00 | -0.21 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173116 | 173116 | 602.0 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 7.0 | 1 | 0.02 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173256 | 173256 | 742.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 8.0 | 0 | 0.00 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173329 | 173329 | 815.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 0 | 0.00 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173355 | 173355 | 841.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 4.0 | 2 | 0.03 | 0.00 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173364 | 173364 | 850.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 31.0 | 0 | 0.00 | -0.06 | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173386 | 173386 | 872.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | - | 0 | 0.0 | 0.0 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||||
172538 | 172538 | 24.0 | 3RD ST EL | OPEN | green | 4 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 13.0 | 4 | 0.48 | 0.24 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172569 | 172569 | 55.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172586 | 172586 | 72.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172596 | 172596 | 82.0 | ARROYO SECO MUS/S MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172609 | 172609 | 95.0 | BANCROFT MS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172625 | 172625 | 111.0 | BERNSTEIN SH | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 0 | 0.00 | 0.00 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172626 | 172626 | 112.0 | BERNSTEIN SH STEM | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172652 | 172652 | 138.0 | BUCHANAN ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 4.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172655 | 172655 | 141.0 | BURBANK MS A/T/C MAG | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 7.0 | 1 | 0.10 | -0.10 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172657 | 172657 | 143.0 | BURROUGHS MS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172659 | 172659 | 145.0 | BUSHNELL WAY EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172695 | 172695 | 181.0 | CDS ALONZO | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172700 | 172700 | 186.0 | CDS WEST HOLLYWOOD | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172715 | 172715 | 201.0 | CHEREMOYA AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172755 | 172755 | 241.0 | DAHLIA HTS EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172766 | 172766 | 252.0 | DELEVAN DRIVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172780 | 172780 | 266.0 | EAGLE ROCK EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 114.0 | 1 | 0.10 | -0.21 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172781 | 172781 | 267.0 | EAGLE ROCK HS | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 52.0 | 1 | 0.04 | -0.09 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172821 | 172821 | 307.0 | FAIRFAX SH | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 16.0 | 1 | 0.05 | -0.06 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172833 | 172833 | 319.0 | FRANKLIN HS | OPEN | green | 4 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 17.0 | 2 | 0.12 | -0.07 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172847 | 172847 | 333.0 | GARDNER ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | 0.00 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172849 | 172849 | 335.0 | GARVANZA EL T/L MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172869 | 172869 | 355.0 | GRANT EEC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 51.0 | 1 | 1.25 | 1.25 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172870 | 172870 | 356.0 | GRANT EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 17.0 | 0 | 0.00 | 0.00 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172888 | 172888 | 374.0 | HANCOCK PARK EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 1 | 0.20 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172896 | 172896 | 382.0 | HARVARD EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 4.0 | 1 | 0.32 | 0.32 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172907 | 172907 | 393.0 | HIGHLAND PARK HS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172913 | 172913 | 399.0 | HOLLYWOOD EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172914 | 172914 | 400.0 | HOLLYWOOD SH | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 10.0 | 3 | 0.23 | 0.23 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172957 | 172957 | 443.0 | KINGSLEY EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | -0.29 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172963 | 172963 | 449.0 | LACES MAG | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 9.0 | 1 | 0.07 | 0.07 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172973 | 172973 | 459.0 | LAUREL CACT MAG | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 28.0 | 2 | 0.29 | 0.29 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172974 | 172974 | 460.0 | LAUREL EEC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 56.0 | 0 | 0.00 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172977 | 172977 | 463.0 | LE CONTE MS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 8.0 | 0 | 0.00 | -0.30 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173046 | 173046 | 532.0 | MARVIN EEC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 55.0 | 1 | 0.93 | -1.85 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173047 | 173047 | 533.0 | MARVIN EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 97.0 | 0 | 0.00 | -0.14 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173056 | 173056 | 542.0 | MELROSE AVE EL M/S MG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173060 | 173060 | 546.0 | MERIDIAN EEC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 61.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173064 | 173064 | 550.0 | MID-CITY PSES MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173080 | 173080 | 566.0 | MONTE VISTA EEC | OPEN | green | 3 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 76.0 | 3 | 2.83 | 2.83 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173081 | 173081 | 567.0 | MONTE VISTA ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 15.0 | 0 | 0.00 | -0.44 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173089 | 173089 | 575.0 | MT WASHINGTON EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173179 | 173179 | 665.0 | RAMONA EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173199 | 173199 | 685.0 | RIORDAN PC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 1 | 0.74 | 0.74 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173207 | 173207 | 693.0 | ROCKDALE VAPA MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173218 | 173218 | 704.0 | ROSEWOOD UP/UD MAG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173234 | 173234 | 720.0 | SAN PASCUAL STEAM MG | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 0 | 0.00 | 0.00 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173240 | 173240 | 726.0 | SATURN ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173243 | 173243 | 729.0 | SELMA AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173297 | 173297 | 783.0 | TOLAND WAY EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 9.0 | 0 | 0.00 | -0.45 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173317 | 173317 | 803.0 | VALLEY VIEW EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173320 | 173320 | 806.0 | VAN NESS AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173336 | 173336 | 822.0 | VINE ST EEC | OPEN | green | 4 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 66.0 | 4 | 3.77 | 0.94 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173337 | 173337 | 823.0 | VINE ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173363 | 173363 | 849.0 | WEST HOLLYWOOD EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173375 | 173375 | 861.0 | WHITMAN HS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fairfax CoS | 10 | 0.11 | 0.01 | 283 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173392 | 173392 | 878.0 | WONDERLAND AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 6.0 | 1 | 0.23 | 0.23 | Hollywood CoS | 10 | 0.13 | 0.04 | 174 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173401 | 173401 | 887.0 | YORKDALE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 1 | 0.43 | 0.43 | Eagle Rock/Highland ParkCoS | 10 | 0.09 | -0.05 | 375 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172514 | 172514 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172520 | 172520 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172521 | 172521 | 7.0 | 122ND ST EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 2 | 0.34 | 0.34 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172529 | 172529 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 1 | 0.24 | 0.24 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172552 | 172552 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 65.0 | 0 | 0.00 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172553 | 172553 | 39.0 | 75TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 33.0 | 2 | 0.20 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172556 | 172556 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 54.0 | 0 | 0.00 | -0.15 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172560 | 172560 | 46.0 | 97TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 43.0 | 1 | 1.49 | 1.49 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172577 | 172577 | 63.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | 0.00 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172585 | 172585 | 71.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172605 | 172605 | 91.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172613 | 172613 | 99.0 | BARRETT EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 11.0 | 0 | 0.00 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172628 | 172628 | 114.0 | BETHUNE MS | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 46.0 | 1 | 0.09 | 0.09 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172630 | 172630 | 116.0 | BONITA ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 2.0 | 0 | 0.00 | -0.25 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172644 | 172644 | 130.0 | BROADACRES AV EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172678 | 172678 | 164.0 | CARNEGIE MS | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 1 | 0.14 | -0.44 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172679 | 172679 | 165.0 | CAROLDALE LC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172681 | 172681 | 167.0 | CARSON ACAD ED & EMP | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
172682 | 172682 | 168.0 | CARSON ACAD MED ARTS | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | 0.00 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172683 | 172683 | 169.0 | CARSON SH | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 8.0 | 2 | 0.11 | 0.05 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172684 | 172684 | 170.0 | CARSON ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | -0.15 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
172693 | 172693 | 179.0 | CATSKILL AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 48.0 | 1 | 0.10 | 0.10 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM |
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 );