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-26 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180814 | 180814 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180968 | 180968 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 0 | 0.0 | -0.09 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180996 | 180996 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181035 | 181035 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181045 | 181045 | 283.0 | ELA OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 3 | 0.04 | -0.01 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181063 | 181063 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181084 | 181084 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 0.01 | -0.02 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181139 | 181139 | 377.0 | HARBOR OCC CTR | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181260 | 181260 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181271 | 181271 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181272 | 181272 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181273 | 181273 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181274 | 181274 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.17 | 0.17 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181352 | 181352 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.21 | 0.21 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181365 | 181365 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181506 | 181506 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181565 | 181565 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181566 | 181566 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181567 | 181567 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.08 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181568 | 181568 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181569 | 181569 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181570 | 181570 | 808.0 | VA STEAM | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 3 | 3 | 0.22 | 0.22 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181585 | 181585 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181611 | 181611 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 3 | 3 | 0.04 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181620 | 181620 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 7 | 3 | 0.03 | -0.06 | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181642 | 181642 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180805 | 180805 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180806 | 180806 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180855 | 180855 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181048 | 181048 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 0 | 0.0 | -1.45 | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181144 | 181144 | 382.0 | HARTE PREP MS | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.18 | 0.00 | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181211 | 181211 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181278 | 181278 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 4 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 0.3 | -0.90 | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181433 | 181433 | 671.0 | RAYMOND AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 4 | 0.55 | 0.19 | Carson CoS | 7 | 0.13 | -0.14 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181610 | 181610 | 848.0 | WASHINGTON PREP SH | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.09 | -0.10 | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181618 | 181618 | 856.0 | WEST ATHENS EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181649 | 181649 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 0 | 0.0 | -0.26 | H.E.E.T. (W) CoS | 7 | 0.13 | -0.16 | 10 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180773 | 180773 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 2 | 0.43 | 0.00 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180802 | 180802 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.5 | 0.00 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180830 | 180830 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180859 | 180859 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180863 | 180863 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180910 | 180910 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 1.35 | 0.00 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180911 | 180911 | 149.0 | CABRILLO AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 3 | 0.71 | 0.47 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181000 | 181000 | 238.0 | CRESTWOOD ST STEAM MG | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.59 | -0.29 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181005 | 181005 | 243.0 | DANA MS | OPEN | green | 4 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 1 | 0.06 | -0.48 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181019 | 181019 | 257.0 | DODSON MS | OPEN | green | 16 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 41 | 15 | 0.96 | 0.19 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181232 | 181232 | 470.0 | LELAND ST EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 0.2 | 0.00 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181395 | 181395 | 633.0 | PARK WESTERN EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181396 | 181396 | 634.0 | PARK WSTN PL EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 1 | 0.16 | -1.09 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181424 | 181424 | 662.0 | PT FERMIN EL MR/S MG | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 0 | 0.0 | -0.26 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181484 | 181484 | 722.0 | SAN PEDRO CAS EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181485 | 181485 | 723.0 | SAN PEDRO SH | OPEN | green | 17 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 17 | 12 | 0.34 | -0.17 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181516 | 181516 | 754.0 | SOUTH SHORES EL PA MG | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 0.2 | -0.58 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181542 | 181542 | 780.0 | TAPER AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 8 | 6 | 0.77 | 0.00 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181630 | 181630 | 868.0 | WHITE POINT EL | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 5 | 1.29 | 1.29 | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181634 | 181634 | 872.0 | WILLENBERG SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 52 | 0.41 | -0.13 | 101 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180857 | 180857 | 95.0 | BALDWIN HILLS EL | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 5 | 1.07 | 1.07 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180917 | 180917 | 155.0 | CANFIELD AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 3 | 1 | 0.23 | -0.23 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180935 | 180935 | 173.0 | CARTHAY EL ES MAG | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.52 | 0.26 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180939 | 180939 | 177.0 | CASTLE HTS EL | OPEN | green | 10 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 12 | 9 | 1.53 | -0.68 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180954 | 180954 | 192.0 | CHARNOCK ROAD EL | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.59 | 0.59 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180965 | 180965 | 203.0 | CHEVIOT HILLS HS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180975 | 180975 | 213.0 | CLOVER AVE EL | OPEN | green | 9 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 24 | 9 | 1.67 | 0.37 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180998 | 180998 | 236.0 | CRESCENT HTS BL EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180999 | 180999 | 237.0 | CRESCENT HTS BL EL MG | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181135 | 181135 | 373.0 | HAMILTON SH | OPEN | green | 21 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 24 | 18 | 0.58 | 0.03 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181289 | 181289 | 527.0 | MARLTON SCHOOL | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181383 | 181383 | 621.0 | OVERLAND AVE EL | OPEN | green | 7 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 4 | 0.72 | 0.00 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181390 | 181390 | 628.0 | PALMS EL | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 4 | 1.28 | 0.96 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181391 | 181391 | 629.0 | PALMS MS | OPEN | green | 14 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 17 | 13 | 0.88 | 0.34 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181498 | 181498 | 736.0 | SHENANDOAH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181499 | 181499 | 737.0 | SHENANDOAH ST EL | OPEN | green | 8 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 18 | 9 | 2.41 | 0.54 | Hamilton CoS | 76 | 0.82 | 0.16 | 116 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180778 | 180778 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 0 | 0.0 | -2.17 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180779 | 180779 | 17.0 | 24TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.15 | 0.15 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180783 | 180783 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 17 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 14 | 13 | 1.2 | 0.18 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180785 | 180785 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180819 | 180819 | 57.0 | ALEXANDER SCS | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 8 | 4 | 0.57 | -0.57 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180823 | 180823 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 1 | 1 | 0.13 | 0.13 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180955 | 180955 | 193.0 | CHASE ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180956 | 180956 | 194.0 | CHASE ST EL | OPEN | green | 7 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 5 | 0.86 | -0.34 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
180978 | 180978 | 216.0 | COHASSET ST EL | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 1 | 0.17 | -0.99 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181012 | 181012 | 250.0 | DEARBORN EL CA | OPEN | green | 9 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 6 | 0.98 | -0.17 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181039 | 181039 | 277.0 | EINSTEIN HS | OPEN | green | 0 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181080 | 181080 | 318.0 | FOSHAY LC | OPEN | green | 13 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 21 | 15 | 0.71 | 0.19 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181106 | 181106 | 344.0 | GLEDHILL ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 1 | 1.23 | -2.47 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181107 | 181107 | 345.0 | GLEDHILL ST EL | OPEN | green | 3 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 3 | 0.78 | 0.26 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181166 | 181166 | 404.0 | HOLMES MS | OPEN | green | 10 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 10 | 8 | 0.68 | 0.17 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181191 | 181191 | 429.0 | JONES PC | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 2 | 1.45 | -2.17 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181203 | 181203 | 441.0 | KING JR EL | OPEN | green | 2 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 2 | 2 | 0.45 | -0.68 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181218 | 181218 | 456.0 | LANGDON AVE EL | OPEN | green | 18 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 18 | 17 | 2.62 | 1.08 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181220 | 181220 | 458.0 | LASSEN EL | OPEN | green | 7 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 4 | 0.82 | -0.20 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181239 | 181239 | 477.0 | LIGGETT ST EL | OPEN | green | 4 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 8 | 4 | 0.63 | -0.62 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181266 | 181266 | 504.0 | MACK EL | OPEN | green | 4 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 4 | 4 | 1.09 | 0.55 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181280 | 181280 | 518.0 | MANUAL ARTS SH | OPEN | green | 6 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 4 | 0.27 | -0.26 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181308 | 181308 | 546.0 | MENLO AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 5 | 5 | 0.86 | 0.34 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181327 | 181327 | 565.0 | MONROE SH | OPEN | green | 12 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 13 | 11 | 0.41 | 0.22 | Monroe CoS | 89 | 0.62 | -0.07 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181361 | 181361 | 599.0 | NORMANDIE AVE EEC | OPEN | green | 1 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181362 | 181362 | 600.0 | NORMANDIE AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 6 | 4 | 0.53 | 0.27 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
181369 | 181369 | 607.0 | NORWOOD ST EL | OPEN | green | 8 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 10 | 9 | 2.09 | 1.62 | Manual Arts/VermontSquare CoS | 87 | 0.75 | 0.15 | 117 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM |
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 );