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-10-28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194375 | 194375 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194376 | 194376 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194384 | 194384 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194425 | 194425 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194538 | 194538 | 206.0 | CITY OF ANGELS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194566 | 194566 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194605 | 194605 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194615 | 194615 | 283.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194618 | 194618 | 286.0 | ELLINGTON HS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194633 | 194633 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194654 | 194654 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 3 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194709 | 194709 | 377.0 | HARBOR OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194714 | 194714 | 382.0 | HARTE PREP MS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194781 | 194781 | 449.0 | LA SALLE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194830 | 194830 | 498.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194841 | 194841 | 509.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194842 | 194842 | 510.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194843 | 194843 | 511.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194844 | 194844 | 512.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194848 | 194848 | 516.0 | MANHATTAN PLACE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | -0.32 | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194922 | 194922 | 590.0 | NEW ACAD CANOGA PARK | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194935 | 194935 | 603.0 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195003 | 195003 | 671.0 | RAYMOND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195076 | 195076 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195135 | 195135 | 803.0 | VA ARTS & ENTMT | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195136 | 195136 | 804.0 | VA BUSINESS & ENTREP | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195137 | 195137 | 805.0 | VA COMPUTER SCIENCE | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195138 | 195138 | 806.0 | VA INTSTUDIES WLD LG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195139 | 195139 | 807.0 | VA LDSRP & PUB SRVC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195140 | 195140 | 808.0 | VA STEAM | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195155 | 195155 | 823.0 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195180 | 195180 | 848.0 | WASHINGTON PREP SH | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195181 | 195181 | 849.0 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.01 | 0.00 | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195188 | 195188 | 856.0 | WEST ATHENS EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195190 | 195190 | 858.0 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195212 | 195212 | 880.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195219 | 195219 | 887.0 | WOODCREST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194362 | 194362 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194365 | 194365 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194408 | 194408 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194419 | 194419 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194420 | 194420 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194455 | 194455 | 123.0 | BRAINARD EL | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 2 | 1 | 0.54 | 0.54 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194472 | 194472 | 140.0 | BUDLONG AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194521 | 194521 | 189.0 | CENTURY PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194537 | 194537 | 205.0 | CIMARRON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194551 | 194551 | 219.0 | COLISEUM ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194552 | 194552 | 220.0 | COLLINS EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194616 | 194616 | 284.0 | ELEMENTARY CDS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194719 | 194719 | 387.0 | HAWKINS SH C/DAGS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194754 | 194754 | 422.0 | IOVINE YOUNG CTR MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194795 | 194795 | 463.0 | LAWSON ACAD A/M/S EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194849 | 194849 | 517.0 | MANN UCLA COMM SCH | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194884 | 194884 | 552.0 | MIDDLE COLLEGE HS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194905 | 194905 | 573.0 | MOUNT GLEASON MS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 7 | 0 | 0.0 | -0.12 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194906 | 194906 | 574.0 | MOUNTAIN VIEW EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194907 | 194907 | 575.0 | MT LUKENS HS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194909 | 194909 | 577.0 | MUIR MS | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 2 | 1 | 0.13 | 0.13 | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194968 | 194968 | 636.0 | PARKS/HUERTA EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194977 | 194977 | 645.0 | PINEWOOD AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194978 | 194978 | 646.0 | PINEWOOD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194980 | 194980 | 648.0 | PLAINVIEW ACADEMC CA | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195062 | 195062 | 730.0 | SECONDARY CDS | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195095 | 195095 | 763.0 | STONEHURST STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195100 | 195100 | 768.0 | SUNLAND EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | -0.27 | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195156 | 195156 | 824.0 | VERDGO HLS SH | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195192 | 195192 | 860.0 | WESTERN AV TECH MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 3 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194392 | 194392 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194409 | 194409 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194417 | 194417 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194543 | 194543 | 211.0 | CLIFFORD ST M/T MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194578 | 194578 | 246.0 | DAYTON EEC | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.94 | 0.94 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194579 | 194579 | 247.0 | DAYTON HEIGHTS EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194593 | 194593 | 261.0 | DORRIS PLACE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194619 | 194619 | 287.0 | ELYSIAN HTS ARTS MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194646 | 194646 | 314.0 | FLETCHER DR EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194651 | 194651 | 319.0 | FRANKLIN AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.22 | 0.22 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194674 | 194674 | 342.0 | GLASSELL PARK EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194675 | 194675 | 343.0 | GLASSELL PK STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194679 | 194679 | 347.0 | GLENFELIZ BLVD EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194680 | 194680 | 348.0 | GLENFELIZ BLVD EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194755 | 194755 | 423.0 | IRVING MS MME MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194757 | 194757 | 425.0 | IVANHOE EL | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.21 | 0.21 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194774 | 194774 | 442.0 | KING MS MAG FLM/MDIA | OPEN | yellow | 2 | 1 | Past 7 days (10/21/2022 - 10/27/2022) | 80 | 1 | 0.05 | -0.21 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194806 | 194806 | 474.0 | LEXINGTON AVE PC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194817 | 194817 | 485.0 | LOCKWOOD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194831 | 194831 | 499.0 | LOS FELIZ STEMM MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | -0.23 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194864 | 194864 | 532.0 | MARSHALL SH | OPEN | green | 3 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 5 | 5 | 0.23 | 0.23 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194868 | 194868 | 536.0 | MAYBERRY ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194882 | 194882 | 550.0 | MICHELTORENA ST EL | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 2 | 1 | 0.26 | 0.26 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
195081 | 195081 | 749.0 | SOTOMAYOR ART/SCI MAG | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 0 | 0.0 | 0.00 | Glassell Park/Los Feliz CoS | 10 | 0.09 | 0.03 | 93 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194366 | 194366 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 11 | 0.08 | 0.01 | 25 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194367 | 194367 | 35.0 | 66TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 11 | 0.08 | 0.01 | 25 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194410 | 194410 | 78.0 | ARLETA SH | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 11 | 0.07 | 0.02 | 22 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194412 | 194412 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 11 | 0.07 | 0.02 | 22 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194413 | 194413 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 11 | 0.07 | 0.02 | 22 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194423 | 194423 | 91.0 | BACA ARTS ACAD | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.16 | 0.16 | Rivera CoS | 11 | 0.08 | 0.01 | 25 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194435 | 194435 | 103.0 | BEACHY AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.2 | 0.20 | Sun Valley CoS | 11 | 0.07 | 0.02 | 22 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194453 | 194453 | 121.0 | BRADLEY EEC | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.95 | 0.95 | Rivera CoS | 11 | 0.08 | 0.01 | 25 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM | |||||
194479 | 194479 | 147.0 | BYRD MS | OPEN | green | 1 | 0 | Past 7 days (10/21/2022 - 10/27/2022) | 1 | 1 | 0.08 | 0.08 | Sun Valley CoS | 11 | 0.07 | 0.02 | 22 | 1,385 | 549 | 0.09 | 0.01 | 2022-10-28 | 01:31AM |
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 );