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-11-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197967 | 197967 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197968 | 197968 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197976 | 197976 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198017 | 198017 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198130 | 198130 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198158 | 198158 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198197 | 198197 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198207 | 198207 | 283.0 | ELA OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198210 | 198210 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198225 | 198225 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198246 | 198246 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198301 | 198301 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198306 | 198306 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198373 | 198373 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198422 | 198422 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198433 | 198433 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198434 | 198434 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198435 | 198435 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198436 | 198436 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198440 | 198440 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198514 | 198514 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198527 | 198527 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198595 | 198595 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198668 | 198668 | 744.0 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 1 | 0.02 | 0.02 | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198727 | 198727 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198728 | 198728 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198729 | 198729 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198730 | 198730 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198731 | 198731 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198732 | 198732 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198747 | 198747 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198772 | 198772 | 848.0 | WASHINGTON PREP SH | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198773 | 198773 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198780 | 198780 | 856.0 | WEST ATHENS EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198782 | 198782 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198804 | 198804 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198811 | 198811 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197940 | 197940 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197941 | 197941 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197945 | 197945 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.3 | 0.10 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197947 | 197947 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197981 | 197981 | 57.0 | ALEXANDER SCS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 1 | 0.15 | 0.15 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198019 | 198019 | 95.0 | BALDWIN HILLS EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198079 | 198079 | 155.0 | CANFIELD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198097 | 198097 | 173.0 | CARTHAY EL ES MAG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198101 | 198101 | 177.0 | CASTLE HTS EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.18 | 0.18 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198116 | 198116 | 192.0 | CHARNOCK ROAD EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198127 | 198127 | 203.0 | CHEVIOT HILLS HS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198137 | 198137 | 213.0 | CLOVER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198160 | 198160 | 236.0 | CRESCENT HTS BL EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198161 | 198161 | 237.0 | CRESCENT HTS BL EL MG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 0 | 0.0 | 0.00 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198242 | 198242 | 318.0 | FOSHAY LC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198297 | 198297 | 373.0 | HAMILTON SH | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.08 | -0.04 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198353 | 198353 | 429.0 | JONES PC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198365 | 198365 | 441.0 | KING JR EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198428 | 198428 | 504.0 | MACK EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198442 | 198442 | 518.0 | MANUAL ARTS SH | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198451 | 198451 | 527.0 | MARLTON SCHOOL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.5 | 0.50 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198470 | 198470 | 546.0 | MENLO AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.17 | 0.00 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198523 | 198523 | 599.0 | NORMANDIE AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198524 | 198524 | 600.0 | NORMANDIE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198531 | 198531 | 607.0 | NORWOOD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198535 | 198535 | 610.0 | OBAMA GLBL PREP ACAD | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198545 | 198545 | 621.0 | OVERLAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198552 | 198552 | 628.0 | PALMS EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198553 | 198553 | 629.0 | PALMS MS | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 2 | 0.15 | 0.08 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198577 | 198577 | 653.0 | POINDEXTER LAMOTTE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.19 | 0.00 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198634 | 198634 | 710.0 | SALVIN SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 0 | 0.0 | -0.85 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198660 | 198660 | 736.0 | SHENANDOAH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 1 | 1.43 | 0.00 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198661 | 198661 | 737.0 | SHENANDOAH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198749 | 198749 | 825.0 | VERMONT AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198775 | 198775 | 851.0 | WEEMES EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198794 | 198794 | 870.0 | WIDNEY CPTC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198239 | 198239 | 315.0 | FLORENCE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198251 | 198251 | 327.0 | GAGE MS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198326 | 198326 | 402.0 | HOLMES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198327 | 198327 | 403.0 | HOLMES AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198334 | 198334 | 410.0 | HOPE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198340 | 198340 | 416.0 | HUNTNGTN PK EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.25 | 0.25 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198341 | 198341 | 417.0 | HUNTNGTN PK SH | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.06 | 0.06 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198402 | 198402 | 478.0 | LILLIAN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198453 | 198453 | 529.0 | MARQUEZ SH HPIAM | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.12 | 0.00 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198454 | 198454 | 530.0 | MARQUEZ SH LIBRA | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 1 | 0.15 | 0.15 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198455 | 198455 | 531.0 | MARQUEZ SH SOC JUS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198477 | 198477 | 553.0 | MIDDLETON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198478 | 198478 | 554.0 | MIDDLETON ST PC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198480 | 198480 | 556.0 | MILES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198481 | 198481 | 557.0 | MILES AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 0 | 0.0 | -0.31 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198518 | 198518 | 594.0 | NIMITZ MS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198548 | 198548 | 624.0 | PACIFIC BLVD SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198632 | 198632 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198635 | 198635 | 711.0 | SAN ANTONIO EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 2 | 0.36 | 0.18 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198636 | 198636 | 712.0 | SAN ANTONIO HS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198750 | 198750 | 826.0 | VERNON CITY EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198767 | 198767 | 843.0 | WALNUT PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 0 | 0.0 | -0.28 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198768 | 198768 | 844.0 | WALNUT PARK MS SJ/SL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198769 | 198769 | 845.0 | WALNUT PARK MS STEM | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 1 | 0 | 0.0 | -0.26 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197939 | 197939 | 15.0 | 232ND PL EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 5 | 0.04 | -0.04 | 12 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197988 | 197988 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 5 | 0.04 | -0.04 | 12 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197996 | 197996 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 5 | 0.04 | -0.04 | 12 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM |
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 );