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-02 sorted by cos_pos
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198865 | 198865 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198866 | 198866 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198874 | 198874 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198915 | 198915 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199028 | 199028 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199056 | 199056 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199095 | 199095 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199105 | 199105 | 283.0 | ELA OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199108 | 199108 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199123 | 199123 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199144 | 199144 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199199 | 199199 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199204 | 199204 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199271 | 199271 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199320 | 199320 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199331 | 199331 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199332 | 199332 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199333 | 199333 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199334 | 199334 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199338 | 199338 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199412 | 199412 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199425 | 199425 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199493 | 199493 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199566 | 199566 | 744.0 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 1 | 0.02 | 0.02 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199625 | 199625 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199626 | 199626 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199627 | 199627 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199628 | 199628 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199629 | 199629 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199630 | 199630 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199645 | 199645 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199670 | 199670 | 848.0 | WASHINGTON PREP SH | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199671 | 199671 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199678 | 199678 | 856.0 | WEST ATHENS EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199680 | 199680 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.01 | 0.01 | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199702 | 199702 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199709 | 199709 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198921 | 198921 | 99.0 | BANNING SH | OPEN | green | 2 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198950 | 198950 | 128.0 | BRIDGES SCHOOL | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.08 | 0.08 | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198952 | 198952 | 130.0 | BROAD AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199006 | 199006 | 184.0 | CDS JOHNSTON | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199071 | 199071 | 249.0 | DE LA TORRE JR EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199118 | 199118 | 296.0 | ESHELMAN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 3 | 0 | 0.0 | -0.19 | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199135 | 199135 | 313.0 | FLEMING MS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199145 | 199145 | 323.0 | FRIES AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199189 | 199189 | 367.0 | GULF AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199193 | 199193 | 371.0 | HALLDALE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199198 | 199198 | 376.0 | HARBOR CITY EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199207 | 199207 | 385.0 | HAWAIIAN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199208 | 199208 | 386.0 | HAWAIIAN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 0 | 0.0 | 0.00 | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199246 | 199246 | 424.0 | ISAACS AVALON HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199312 | 199312 | 490.0 | LOMITA EL M/S/T MAG | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199371 | 199371 | 549.0 | MEYLER ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199405 | 199405 | 583.0 | NARBONNE SH | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.05 | 0.00 | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199406 | 199406 | 584.0 | NARBONNE SH HARTS LA | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 0 | 0.0 | 0.00 | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199423 | 199423 | 601.0 | NORMONT EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199424 | 199424 | 602.0 | NORMONT EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199462 | 199462 | 640.0 | PATTON HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199482 | 199482 | 660.0 | PRESIDENT AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199634 | 199634 | 812.0 | VAN DEENE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 1 | 0.01 | -0.04 | 5 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199660 | 199660 | 838.0 | VLADOVIC HARBOR TPA | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199696 | 199696 | 874.0 | WILMINGTON EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199697 | 199697 | 875.0 | WILMINGTON PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199698 | 199698 | 876.0 | WILMINGTON STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 0 | 0.0 | -0.21 | Wilmington CoS | 1 | 0.01 | -0.05 | 4 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198883 | 198883 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 2 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 7 | 1 | 0.14 | 0.00 | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198954 | 198954 | 132.0 | BROADOUS EEC | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
198955 | 198955 | 133.0 | BROADOUS EL | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199015 | 199015 | 193.0 | CHASE ST EEC | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 0 | 0.0 | -0.49 | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199016 | 199016 | 194.0 | CHASE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199020 | 199020 | 198.0 | CHAVEZ LA ARTES MAG | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199021 | 199021 | 199.0 | CHAVEZ LA ASE | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.2 | 0.20 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199022 | 199022 | 200.0 | CHAVEZ LA SJ HUM AC | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 1 | 0.2 | 0.00 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199023 | 199023 | 201.0 | CHAVEZ LA TECH PREP | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.23 | 0.00 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199038 | 199038 | 216.0 | COHASSET ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199072 | 199072 | 250.0 | DEARBORN EL CA | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199087 | 199087 | 265.0 | DYER ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199099 | 199099 | 277.0 | EINSTEIN HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199100 | 199100 | 278.0 | EL DORADO AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 1 | 1 | 0.23 | 0.00 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199126 | 199126 | 304.0 | EVERGREEN HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199166 | 199166 | 344.0 | GLEDHILL ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199167 | 199167 | 345.0 | GLEDHILL ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199185 | 199185 | 363.0 | GRIDLEY ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199190 | 199190 | 368.0 | HADDON AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199191 | 199191 | 369.0 | HADDON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 4 | 0 | 0.0 | -0.50 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199200 | 199200 | 378.0 | HARDING ST EL | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 3 | 0 | 0.0 | -0.45 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199214 | 199214 | 392.0 | HERRICK AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199226 | 199226 | 404.0 | HOLMES MS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 0 | 0.0 | -0.40 | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199233 | 199233 | 411.0 | HUBBARD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199278 | 199278 | 456.0 | LANGDON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199280 | 199280 | 458.0 | LASSEN EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199299 | 199299 | 477.0 | LIGGETT ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199384 | 199384 | 562.0 | MISSION HS | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199387 | 199387 | 565.0 | MONROE SH | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199393 | 199393 | 571.0 | MORNINGSIDE EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199431 | 199431 | 615.0 | O'MELVENY EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199436 | 199436 | 613.0 | OLIVE VISTA MS | OPEN | green | 1 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 2 | 1 | 0.09 | 0.00 | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199442 | 199442 | 620.0 | OSCEOLA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199447 | 199447 | 625.0 | PACOIMA EEC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 6 | 0.03 | -0.09 | 24 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199452 | 199452 | 630.0 | PANORAMA CITY EL | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 01:38AM | |||||
199457 | 199457 | 635.0 | PARKS LC | OPEN | green | 0 | 0 | Past 7 days (10/26/2022 - 11/1/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 4 | 0.03 | -0.04 | 16 | 1,307 | 507 | 0.08 | -0.02 | 2022-11-02 | 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 );