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-06 sorted by cos
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
214240 | 214240 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.37 | 0.37 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214422 | 214422 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214461 | 214461 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214471 | 214471 | 283.0 | ELA OCC CTR | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.02 | -0.02 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214489 | 214489 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214510 | 214510 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214565 | 214565 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214686 | 214686 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214697 | 214697 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214698 | 214698 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214699 | 214699 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214700 | 214700 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214778 | 214778 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214791 | 214791 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214932 | 214932 | 744.0 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214992 | 214992 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.08 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214993 | 214993 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214994 | 214994 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.0 | 0.08 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214995 | 214995 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.09 | 0.09 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214996 | 214996 | 808.0 | VA STEAM | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.09 | -0.07 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215011 | 215011 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215037 | 215037 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215046 | 215046 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.01 | -0.02 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215068 | 215068 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214189 | 214189 | 1.0 | 109TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.26 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214191 | 214191 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214192 | 214192 | 4.0 | 112TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.48 | 0.48 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214193 | 214193 | 5.0 | 116TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214229 | 214229 | 41.0 | 92ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.26 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214233 | 214233 | 45.0 | 96TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.15 | -0.44 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214413 | 214413 | 225.0 | COMPTON AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.33 | 0.33 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214504 | 214504 | 316.0 | FLOURNOY EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.39 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214538 | 214538 | 350.0 | GOMPERS MS | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.19 | -0.18 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214539 | 214539 | 351.0 | GOMPERS MS UP MED MAG | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.49 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214635 | 214635 | 447.0 | KNOX EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214670 | 214670 | 482.0 | LOCKE EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214671 | 214671 | 483.0 | LOCKE INFANT | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215040 | 215040 | 852.0 | WEIGAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.24 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214294 | 214294 | 106.0 | BELL SH | OPEN | green | 10 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 4 | 0.16 | -0.23 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214418 | 214418 | 230.0 | CORONA AVE EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 2 | 0.27 | -0.14 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214473 | 214473 | 285.0 | ELIZABETH LC | OPEN | green | 8 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 24 | 8 | 0.51 | 0.13 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214481 | 214481 | 293.0 | ESCALANTE EEC | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214482 | 214482 | 294.0 | ESCALANTE EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 2 | 0.36 | -0.53 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214483 | 214483 | 295.0 | ESCUTIA PC | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.36 | 0.36 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214500 | 214500 | 312.0 | FISHBURN AVE EL | OPEN | green | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 6 | 1.2 | 0.80 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214578 | 214578 | 390.0 | HELIOTROPE AVE EL | OPEN | green | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 9 | 5 | 0.87 | 0.17 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214601 | 214601 | 413.0 | HUGHES EL | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 4 | 0.61 | 0.30 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214677 | 214677 | 489.0 | LOMA VISTA EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 3 | 0.47 | 0.15 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214691 | 214691 | 503.0 | MACES MAG | OPEN | green | 8 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 13 | 8 | 0.63 | 0.00 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214725 | 214725 | 537.0 | MAYWOOD ACADEMY SH | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 3 | 0.25 | -0.25 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214726 | 214726 | 538.0 | MAYWOOD EL | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 9 | 6 | 1.11 | 0.37 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214796 | 214796 | 608.0 | NUEVA VISTA EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 0 | 0.0 | -0.26 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214800 | 214800 | 611.0 | OCHOA LC | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 2 | 0.15 | 0.15 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214805 | 214805 | 617.0 | ORCHARD ACADEMIES 2B | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.51 | -0.26 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214806 | 214806 | 618.0 | ORCHARD ACADEMIES 2C | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.23 | -0.45 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214820 | 214820 | 632.0 | PARK AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 0 | 0.0 | -0.52 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
215080 | 215080 | 892.0 | WOODLAWN AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.14 | 0.14 | Bell/Cudahy/Maywood CoS | 58 | 0.38 | -0.03 | 109 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214201 | 214201 | 13.0 | 1ST ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 1 | 0.22 | -0.22 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214208 | 214208 | 20.0 | 2ND ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.78 | 0.78 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214306 | 214306 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 1 | 1.82 | 0.00 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214307 | 214307 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -1.86 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214313 | 214313 | 125.0 | BREED ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.3 | 0.30 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214315 | 214315 | 127.0 | BRIDGE ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.84 | 0.84 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214429 | 214429 | 241.0 | DACOTAH EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214442 | 214442 | 254.0 | DENA EL | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 3 | 0.66 | -0.21 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214488 | 214488 | 300.0 | EUCLID AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 9 | 5 | 0.68 | 0.13 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214490 | 214490 | 302.0 | EVERGREEN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214491 | 214491 | 303.0 | EVERGREEN AVE EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.32 | 0.00 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214525 | 214525 | 337.0 | GARZA PC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214587 | 214587 | 399.0 | HOLLENBECK MS | OPEN | green | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 2 | 0.18 | -0.63 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214680 | 214680 | 492.0 | LORENA ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214702 | 214702 | 514.0 | MALABAR ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.18 | 0.18 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214733 | 214733 | 545.0 | MENDEZ SH | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 3 | 0.29 | -0.09 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214736 | 214736 | 548.0 | METROPOLITAN HS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214886 | 214886 | 698.0 | ROOSEVELT INFANT | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214887 | 214887 | 699.0 | ROOSEVELT SH | OPEN | green | 10 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 15 | 7 | 0.37 | -0.16 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214888 | 214888 | 700.0 | ROOSEVELT SH STM MAG | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 1 | 0.17 | -0.53 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214926 | 214926 | 738.0 | SHERIDAN ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.3 | 0.30 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214936 | 214936 | 748.0 | SOTO ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.75 | -0.38 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214950 | 214950 | 762.0 | STEVENSON CCP | OPEN | green | 10 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 3 | 0.29 | -0.69 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214958 | 214958 | 770.0 | SUNRISE EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214990 | 214990 | 802.0 | UTAH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 4 | 0.85 | -0.21 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214991 | 214991 | 803.0 | VA ARTS & ENTMT | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 4 | 0.85 | 0.08 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214241 | 214241 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214292 | 214292 | 104.0 | BECKFORD CES | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 0 | 0.0 | -0.15 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214344 | 214344 | 156.0 | CANOGA PARK EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214345 | 214345 | 157.0 | CANOGA PARK EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.32 | 0.16 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214346 | 214346 | 158.0 | CANOGA PRK SH | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 10 | 5 | 0.3 | 0.12 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214350 | 214350 | 162.0 | CAPISTRANO AVE EL | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 4 | 0.81 | 0.61 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214369 | 214369 | 181.0 | CDS AGGELER | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214383 | 214383 | 195.0 | CHATSWORTH CHS | OPEN | green | 11 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 15 | 8 | 0.44 | -0.05 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214384 | 214384 | 196.0 | CHATSWORTH UP/CD MAG | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214410 | 214410 | 222.0 | COLUMBUS MS | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 1 | 0.13 | -0.90 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214478 | 214478 | 290.0 | ENADIA WAY | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 0 | 0.0 | 0.00 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214529 | 214529 | 341.0 | GERMAIN ACAD AA | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.29 | -0.30 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214562 | 214562 | 374.0 | HAMLIN CA | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 4 | 1.03 | 0.51 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214569 | 214569 | 381.0 | HART ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.24 | 0.00 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214650 | 214650 | 462.0 | LAWRENCE MS | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 8 | 0 | 0.0 | -0.99 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214776 | 214776 | 588.0 | NEVADA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.22 | 0.22 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214784 | 214784 | 596.0 | NOBEL CMS | OPEN | yellow | 11 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 26 | 9 | 0.38 | 0.08 | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM |
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 );