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-12-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
222295 | 222295 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222302 | 222302 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222307 | 222307 | 37.0 | 74TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222313 | 222313 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222314 | 222314 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222322 | 222322 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222356 | 222356 | 86.0 | AUDUBON MS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222363 | 222363 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222392 | 222392 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222504 | 222504 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222505 | 222505 | 235.0 | CRENSHAW MAG STEMM | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222532 | 222532 | 262.0 | DORSEY SH | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222543 | 222543 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222553 | 222553 | 283.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222556 | 222556 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222571 | 222571 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222592 | 222592 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.01 | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222647 | 222647 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 2 | 0 | 0.0 | -0.06 | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222652 | 222652 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222665 | 222665 | 395.0 | HILLCREST DR EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222688 | 222688 | 418.0 | HYDE PARK EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222719 | 222719 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222768 | 222768 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222779 | 222779 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222780 | 222780 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222781 | 222781 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222782 | 222782 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222786 | 222786 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222860 | 222860 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222873 | 222873 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222941 | 222941 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223014 | 223014 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.06 | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223073 | 223073 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223074 | 223074 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223075 | 223075 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223076 | 223076 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223077 | 223077 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.09 | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223078 | 223078 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223093 | 223093 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223099 | 223099 | 829.0 | VIEW PARK CONTN HS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223118 | 223118 | 848.0 | WASHINGTON PREP SH | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223119 | 223119 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223126 | 223126 | 856.0 | WEST ATHENS EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223128 | 223128 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223150 | 223150 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223157 | 223157 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223164 | 223164 | 894.0 | YES ACADEMY | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223166 | 223166 | 896.0 | YOUNG HS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222271 | 222271 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222273 | 222273 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222274 | 222274 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222275 | 222275 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222286 | 222286 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222287 | 222287 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222291 | 222291 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222293 | 222293 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222311 | 222311 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222315 | 222315 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222327 | 222327 | 57.0 | ALEXANDER SCS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222495 | 222495 | 225.0 | COMPTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222586 | 222586 | 316.0 | FLOURNOY EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222588 | 222588 | 318.0 | FOSHAY LC | OPEN | green | 1 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.27 | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222620 | 222620 | 350.0 | GOMPERS MS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.74 | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222621 | 222621 | 351.0 | GOMPERS MS UP MED MAG | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222699 | 222699 | 429.0 | JONES PC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222711 | 222711 | 441.0 | KING JR EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222717 | 222717 | 447.0 | KNOX EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222752 | 222752 | 482.0 | LOCKE EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222753 | 222753 | 483.0 | LOCKE INFANT | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222774 | 222774 | 504.0 | MACK EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222788 | 222788 | 518.0 | MANUAL ARTS SH | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222816 | 222816 | 546.0 | MENLO AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222869 | 222869 | 599.0 | NORMANDIE AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222870 | 222870 | 600.0 | NORMANDIE AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222877 | 222877 | 607.0 | NORWOOD ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222881 | 222881 | 610.0 | OBAMA GLBL PREP ACAD | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222923 | 222923 | 653.0 | POINDEXTER LAMOTTE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222980 | 222980 | 710.0 | SALVIN SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223095 | 223095 | 825.0 | VERMONT AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223121 | 223121 | 851.0 | WEEMES EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223122 | 223122 | 852.0 | WEIGAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
223140 | 223140 | 870.0 | WIDNEY CPTC | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 0 | 0.0 | -0.21 | 1 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222348 | 222348 | 78.0 | ARLETA SH | OPEN | yellow | 1 | 1 | Past 7 days (12/17/2022 - 12/23/2022) | 2 | 0 | 0.0 | -0.84 | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222350 | 222350 | 80.0 | ARMINTA ST EEC | OPEN | green | 1 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 1 | 1.1 | 1.10 | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222351 | 222351 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222373 | 222373 | 103.0 | BEACHY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222408 | 222408 | 138.0 | BRYSON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222417 | 222417 | 147.0 | BYRD MS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222430 | 222430 | 160.0 | CANTERBURY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222502 | 222502 | 232.0 | COUGHLIN EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222580 | 222580 | 310.0 | FERNANGELES EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222619 | 222619 | 349.0 | GLENWOOD EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -1.48 | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222689 | 222689 | 419.0 | INDEPENDENCE EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.39 | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222691 | 222691 | 421.0 | INTERNATIONAL ST LC | OPEN | green | 1 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 1 | 0.1 | -1.00 | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222718 | 222718 | 448.0 | KORENSTEIN EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -1.22 | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222737 | 222737 | 467.0 | LEGACY SH STEAM | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 1 | 0 | 0.0 | -0.66 | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222738 | 222738 | 468.0 | LEGACY SH VAPA | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222743 | 222743 | 473.0 | LEWIS HS | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222745 | 222745 | 475.0 | LIBERTY BLVD EL | OPEN | green | 0 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 6 | 0.04 | -0.33 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 01:36AM | |||||
222770 | 222770 | 500.0 | LOWMAN SP ED & CTC | OPEN | green | 1 | 0 | Past 7 days (12/17/2022 - 12/23/2022) | 2 | 0 | 0.0 | -3.18 | Sun Valley CoS | 2 | 0.01 | -0.48 | 10 | 654 | 192 | 0.03 | -0.29 | 2022-12-26 | 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 );