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-02 sorted by cos_pos_rate
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
211546 | 211546 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211728 | 211728 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211767 | 211767 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211777 | 211777 | 283.0 | ELA OCC CTR | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 6 | 3 | 0.03 | 0.02 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211795 | 211795 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211816 | 211816 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211871 | 211871 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211992 | 211992 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212003 | 212003 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212004 | 212004 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212005 | 212005 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212006 | 212006 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212084 | 212084 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212097 | 212097 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212238 | 212238 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212297 | 212297 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212298 | 212298 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212299 | 212299 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212300 | 212300 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212301 | 212301 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212302 | 212302 | 808.0 | VA STEAM | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.07 | 0.07 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212317 | 212317 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.03 | 0.03 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212343 | 212343 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212352 | 212352 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 2 | 0.02 | 0.02 | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212374 | 212374 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211519 | 211519 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211526 | 211526 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.38 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211531 | 211531 | 37.0 | 74TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 1 | 0.23 | 0.23 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211580 | 211580 | 86.0 | AUDUBON MS | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 8 | 3 | 0.58 | 0.58 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211616 | 211616 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211729 | 211729 | 235.0 | CRENSHAW MAG STEMM | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 1 | 0.16 | 0.16 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211756 | 211756 | 262.0 | DORSEY SH | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 9 | 1 | 0.1 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211889 | 211889 | 395.0 | HILLCREST DR EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 1 | 0.16 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211912 | 211912 | 418.0 | HYDE PARK EEC | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 1.08 | 1.08 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212323 | 212323 | 829.0 | VIEW PARK CONTN HS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212388 | 212388 | 894.0 | YES ACADEMY | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 6 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212390 | 212390 | 896.0 | YOUNG HS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 9 | 0.2 | 0.13 | 37 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211727 | 211727 | 233.0 | COWAN AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211921 | 211921 | 427.0 | JOHNSON STEM ACADEMY | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211930 | 211930 | 436.0 | KENTWOOD EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211931 | 211931 | 437.0 | KENTWOOD EL | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 3 | 0.98 | 0.98 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211995 | 211995 | 501.0 | LOYOLA VILLG EL F/PAM | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212110 | 212110 | 616.0 | OPEN CHARTER MAG | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 6 | 3 | 0.66 | 0.22 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212133 | 212133 | 639.0 | PASEO DEL REY ACAD | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 0 | 0.0 | -0.54 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212145 | 212145 | 651.0 | PLAYA VISTA EL | OPEN | green | 6 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 10 | 6 | 1.14 | 0.57 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212348 | 212348 | 854.0 | WESM HLTH/SPORTS MED | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 5 | 3 | 0.39 | 0.26 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212357 | 212357 | 863.0 | WESTPORT HTS EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212377 | 212377 | 883.0 | WINDSOR HILLS EL MAG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212387 | 212387 | 893.0 | WRIGHT ENG DES MAG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 15 | 0.36 | 0.14 | 32 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211505 | 211505 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 2 | 0.43 | 0.21 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211528 | 211528 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211529 | 211529 | 35.0 | 66TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 11 | 3 | 0.37 | 0.37 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211534 | 211534 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211537 | 211537 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211538 | 211538 | 44.0 | 95TH ST EL | OPEN | green | 5 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 12 | 4 | 0.47 | 0.35 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211562 | 211562 | 70.0 | ANGEL'S GATE HS | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 1 | 1.23 | 1.23 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211585 | 211585 | 91.0 | BACA ARTS ACAD | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 8 | 5 | 0.79 | 0.63 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211587 | 211587 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 11 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211591 | 211591 | 97.0 | BANDINI ST EL | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 5 | 4 | 1.35 | 1.35 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211595 | 211595 | 101.0 | BARTON HILL EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 8 | 2 | 0.42 | 0.21 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211615 | 211615 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211642 | 211642 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211643 | 211643 | 149.0 | CABRILLO AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.25 | 0.25 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211732 | 211732 | 238.0 | CRESTWOOD ST STEAM MG | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 2 | 0.64 | 0.64 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211737 | 211737 | 243.0 | DANA MS | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 9 | 1 | 0.06 | 0.00 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211751 | 211751 | 257.0 | DODSON MS | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 21 | 3 | 0.21 | 0.14 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211757 | 211757 | 263.0 | DREW MS | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 16 | 1 | 0.13 | 0.13 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211758 | 211758 | 264.0 | DREW MS UP PBLC SRVC | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 11 | 1 | 0.33 | 0.00 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211760 | 211760 | 266.0 | DYMALLY SH | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 20 | 3 | 0.35 | 0.23 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211770 | 211770 | 276.0 | EDISON MS | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 13 | 5 | 0.51 | 0.51 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211780 | 211780 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 4 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211823 | 211823 | 329.0 | GARCETTI LA | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211846 | 211846 | 352.0 | GRAHAM EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211847 | 211847 | 353.0 | GRAHAM EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 2 | 0.3 | 0.30 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211876 | 211876 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211937 | 211937 | 443.0 | KING-DREW SH MD/S MG | OPEN | green | 9 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 26 | 9 | 0.61 | 0.54 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211943 | 211943 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
211964 | 211964 | 470.0 | LELAND ST EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 2 | 0.42 | 0.42 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212010 | 212010 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 2 | 0.62 | 0.62 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212036 | 212036 | 542.0 | MCKINLEY AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 5 | 2 | 0.32 | 0.32 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212054 | 212054 | 560.0 | MIRAMONTE EEC | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 1 | 0.85 | 0.85 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212055 | 212055 | 561.0 | MIRAMONTE EL | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 2 | 0.26 | 0.26 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212064 | 212064 | 570.0 | MOORE M/S/T ACAD | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.17 | 0.17 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212127 | 212127 | 633.0 | PARK WESTERN EEC | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 2 | 2.2 | 2.20 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212128 | 212128 | 634.0 | PARK WSTN PL EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 7 | 0 | 0.0 | 0.00 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212131 | 212131 | 637.0 | PARMELEE AVE EL | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 10 | 3 | 0.36 | 0.12 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212156 | 212156 | 662.0 | PT FERMIN EL MR/S MG | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 3 | 1 | 0.28 | 0.28 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212165 | 212165 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 5 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212182 | 212182 | 688.0 | RIVERA LC COM & TECH | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 6 | 0 | 0.0 | -0.17 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212183 | 212183 | 689.0 | RIVERA LC GD STEAM AC | OPEN | green | 2 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 9 | 2 | 0.33 | 0.33 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212184 | 212184 | 690.0 | RIVERA LC PERF ARTS | OPEN | green | 3 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 10 | 3 | 0.54 | 0.54 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212185 | 212185 | 691.0 | RIVERA LC PUB SRV | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 10 | 1 | 0.18 | 0.18 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212203 | 212203 | 709.0 | RUSSELL EL | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 8 | 1 | 0.11 | -0.54 | Rivera CoS | 46 | 0.32 | 0.23 | 200 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212216 | 212216 | 722.0 | SAN PEDRO CAS EEC | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212217 | 212217 | 723.0 | SAN PEDRO SH | OPEN | green | 7 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 57 | 7 | 0.25 | 0.21 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212248 | 212248 | 754.0 | SOUTH SHORES EL PA MG | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212274 | 212274 | 780.0 | TAPER AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 5 | 4 | 0.54 | 0.54 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212342 | 212342 | 848.0 | WASHINGTON PREP SH | OPEN | green | 1 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 1 | 1 | 0.11 | 0.11 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212350 | 212350 | 856.0 | WEST ATHENS EL | OPEN | green | 5 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 23 | 5 | 0.71 | 0.71 | H.E.E.T. (W) CoS | 13 | 0.25 | 0.23 | 69 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
212362 | 212362 | 868.0 | WHITE POINT EL | OPEN | green | 0 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 2 | 0 | 0.0 | 0.00 | San Pedro CoS | 32 | 0.27 | 0.23 | 133 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM |
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 );