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-09 sorted by cos_tests
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201568 | 201568 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201722 | 201722 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201750 | 201750 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201789 | 201789 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201799 | 201799 | 283.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201817 | 201817 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201838 | 201838 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201893 | 201893 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202014 | 202014 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202025 | 202025 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202026 | 202026 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202027 | 202027 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202028 | 202028 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202106 | 202106 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202119 | 202119 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202260 | 202260 | 744.0 | SLAWSON OCC CTR | OPEN | green | 3 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 4 | 4 | 0.06 | 0.04 | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202319 | 202319 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202320 | 202320 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202321 | 202321 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202322 | 202322 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202323 | 202323 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202324 | 202324 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202339 | 202339 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202365 | 202365 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | -0.01 | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202374 | 202374 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202396 | 202396 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201565 | 201565 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.29 | 0.29 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201592 | 201592 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201618 | 201618 | 102.0 | BASSETT ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201630 | 201630 | 114.0 | BERTRAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201639 | 201639 | 123.0 | BRAINARD EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 2 | 1.08 | 1.08 | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201804 | 201804 | 288.0 | EMELITA ST EL | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | -0.60 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201846 | 201846 | 330.0 | GARDEN GROVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201856 | 201856 | 340.0 | GAULT ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201878 | 201878 | 362.0 | GREY HS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201909 | 201909 | 393.0 | HESBY OAKS LEAD CHTR | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 2 | 0.37 | 0.19 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201936 | 201936 | 420.0 | INDEPENDENCE HS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201968 | 201968 | 452.0 | LAKE BALBOA CP K-12 | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201985 | 201985 | 469.0 | LEICHMAN CPTC | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 1 | 0.42 | 0.00 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201987 | 201987 | 471.0 | LEMAY ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 1 | 1.08 | 1.08 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201988 | 201988 | 472.0 | LEMAY ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | -0.48 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202004 | 202004 | 488.0 | LOKRANTZ SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202089 | 202089 | 573.0 | MOUNT GLEASON MS | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 28 | 2 | 0.24 | 0.00 | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202090 | 202090 | 574.0 | MOUNTAIN VIEW EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202091 | 202091 | 575.0 | MT LUKENS HS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202094 | 202094 | 578.0 | MULHOLLAND MS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202107 | 202107 | 591.0 | NEWCASTLE EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 1 | 0.26 | 0.00 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202161 | 202161 | 645.0 | PINEWOOD AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202162 | 202162 | 646.0 | PINEWOOD AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202164 | 202164 | 648.0 | PLAINVIEW ACADEMC CA | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202189 | 202189 | 673.0 | RESEDA CHARTER HS | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 2 | 0.13 | 0.13 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202190 | 202190 | 674.0 | RESEDA EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | 0.00 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202256 | 202256 | 740.0 | SHIRLEY AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202261 | 202261 | 745.0 | SOCES MAG | OPEN | yellow | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.05 | 0.00 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202279 | 202279 | 763.0 | STONEHURST STEAM MAG | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 11 | 4 | 1.25 | 0.62 | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202284 | 202284 | 768.0 | SUNLAND EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202297 | 202297 | 781.0 | TARZANA EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202334 | 202334 | 818.0 | VANALDEN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202335 | 202335 | 819.0 | VANALDEN AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.22 | -0.66 | Reseda CoS | 10 | 0.09 | -0.01 | 17 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202340 | 202340 | 824.0 | VERDGO HLS SH | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 2 | 0.15 | 0.08 | Sunland/Tujunga CoS | 10 | 0.21 | 0.09 | 44 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201621 | 201621 | 105.0 | BEETHOVEN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201636 | 201636 | 120.0 | BRADDOCK DR EL | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 6 | 2 | 0.31 | -0.30 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201650 | 201650 | 134.0 | BROADWAY EL | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 19 | 2 | 0.36 | 0.36 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201731 | 201731 | 215.0 | COEUR D ALENE AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201831 | 201831 | 315.0 | FLORENCE AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201843 | 201843 | 327.0 | GAGE MS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201871 | 201871 | 355.0 | GRAND VW BL EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201918 | 201918 | 402.0 | HOLMES AVE EEC | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.08 | (Blank) | Hollywood CoS | 11 | 0.08 | -0.02 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201919 | 201919 | 403.0 | HOLMES AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201926 | 201926 | 410.0 | HOPE ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 0 | 0.0 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201932 | 201932 | 416.0 | HUNTNGTN PK EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 1 | 0.25 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201933 | 201933 | 417.0 | HUNTNGTN PK SH | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 2 | 0.12 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
201994 | 201994 | 478.0 | LILLIAN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202036 | 202036 | 520.0 | MAR VISTA EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 1 | 0.17 | 0.17 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202038 | 202038 | 522.0 | MARINA DEL REY MS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202039 | 202039 | 523.0 | MARINA EEC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202041 | 202041 | 525.0 | MARK TWAIN MS | OPEN | yellow | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.1 | 0.00 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202045 | 202045 | 529.0 | MARQUEZ SH HPIAM | OPEN | green | 3 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 3 | 0.38 | 0.25 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202046 | 202046 | 530.0 | MARQUEZ SH LIBRA | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202047 | 202047 | 531.0 | MARQUEZ SH SOC JUS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202057 | 202057 | 541.0 | MCBRIDE SP ED CTR | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 1 | 0.48 | 0.00 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202069 | 202069 | 553.0 | MIDDLETON ST EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 15 | 1 | 0.14 | 0.14 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202070 | 202070 | 554.0 | MIDDLETON ST PC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202072 | 202072 | 556.0 | MILES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202073 | 202073 | 557.0 | MILES AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202110 | 202110 | 594.0 | NIMITZ MS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202140 | 202140 | 624.0 | PACIFIC BLVD SCHOOL | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 2 | 0.45 | 0.45 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202160 | 202160 | 644.0 | PHOENIX HS | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202166 | 202166 | 650.0 | PLAYA DEL REY EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 2 | 0 | 0.0 | -0.32 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202224 | 202224 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202227 | 202227 | 711.0 | SAN ANTONIO EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.18 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202228 | 202228 | 712.0 | SAN ANTONIO HS | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 1 | 1 | 0.88 | 0.88 | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202257 | 202257 | 741.0 | SHORT AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202280 | 202280 | 764.0 | STONER AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 7 | 0 | 0.0 | -0.30 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202338 | 202338 | 822.0 | VENICE SH | OPEN | green | 2 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 7 | 3 | 0.13 | 0.04 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202342 | 202342 | 826.0 | VERNON CITY EL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202358 | 202358 | 842.0 | WALGROVE AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 3 | 1 | 0.36 | 0.36 | Venice CoS | 11 | 0.12 | -0.02 | 52 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202359 | 202359 | 843.0 | WALNUT PARK EL | OPEN | green | 1 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202360 | 202360 | 844.0 | WALNUT PARK MS SJ/SL | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM | |||||
202361 | 202361 | 845.0 | WALNUT PARK MS STEM | OPEN | green | 0 | 0 | Past 7 days (11/2/2022 - 11/8/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | 0.03 | 28 | 1,826 | 704 | 0.11 | 0.01 | 2022-11-09 | 01:38AM |
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 );