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-29 sorted by cos_change
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
224067 | 224067 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224069 | 224069 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224070 | 224070 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224071 | 224071 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224082 | 224082 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224083 | 224083 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224087 | 224087 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224088 | 224088 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224089 | 224089 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224091 | 224091 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224096 | 224096 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224097 | 224097 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224098 | 224098 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224099 | 224099 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224100 | 224100 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224101 | 224101 | 35.0 | 66TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224102 | 224102 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224103 | 224103 | 37.0 | 74TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224107 | 224107 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224111 | 224111 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224115 | 224115 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224118 | 224118 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224122 | 224122 | 56.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224123 | 224123 | 57.0 | ALEXANDER SCS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224126 | 224126 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224128 | 224128 | 62.0 | ALTA LOMA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224135 | 224135 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224139 | 224139 | 73.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224142 | 224142 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224143 | 224143 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224145 | 224145 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224149 | 224149 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224151 | 224151 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224152 | 224152 | 86.0 | AUDUBON MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224153 | 224153 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224154 | 224154 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224157 | 224157 | 91.0 | BACA ARTS ACAD | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224161 | 224161 | 95.0 | BALDWIN HILLS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224168 | 224168 | 102.0 | BASSETT ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224177 | 224177 | 111.0 | BERENDO MS | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224180 | 224180 | 114.0 | BERTRAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224187 | 224187 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224188 | 224188 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224189 | 224189 | 123.0 | BRAINARD EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224195 | 224195 | 129.0 | BRIGHT EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224205 | 224205 | 139.0 | BUCHANAN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224206 | 224206 | 140.0 | BUDLONG AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224208 | 224208 | 142.0 | BURBANK MS A/T/C MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224209 | 224209 | 143.0 | BURKE HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224211 | 224211 | 145.0 | BURTON ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224212 | 224212 | 146.0 | BUSHNELL WAY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224216 | 224216 | 150.0 | CAHUENGA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224217 | 224217 | 151.0 | CALABASH CA | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224219 | 224219 | 153.0 | CALVERT CES | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224221 | 224221 | 155.0 | CANFIELD AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224238 | 224238 | 172.0 | CARSON-GORE ACADEMY | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224239 | 224239 | 173.0 | CARTHAY EL ES MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224243 | 224243 | 177.0 | CASTLE HTS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224255 | 224255 | 189.0 | CENTURY PARK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224258 | 224258 | 192.0 | CHARNOCK ROAD EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224269 | 224269 | 203.0 | CHEVIOT HILLS HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224270 | 224270 | 204.0 | CIENEGA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224271 | 224271 | 205.0 | CIMARRON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224277 | 224277 | 211.0 | CLIFFORD ST M/T MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224279 | 224279 | 213.0 | CLOVER AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224280 | 224280 | 214.0 | COCHRAN MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224285 | 224285 | 219.0 | COLISEUM ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224286 | 224286 | 220.0 | COLLINS EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224291 | 224291 | 225.0 | COMPTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224300 | 224300 | 234.0 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224301 | 224301 | 235.0 | CRENSHAW MAG STEMM | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224302 | 224302 | 236.0 | CRESCENT HTS BL EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224303 | 224303 | 237.0 | CRESCENT HTS BL EL MG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224308 | 224308 | 242.0 | DAHLIA HTS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224312 | 224312 | 246.0 | DAYTON EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224313 | 224313 | 247.0 | DAYTON HEIGHTS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224319 | 224319 | 253.0 | DELEVAN DRIVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224327 | 224327 | 261.0 | DORRIS PLACE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224328 | 224328 | 262.0 | DORSEY SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224329 | 224329 | 263.0 | DREW MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224330 | 224330 | 264.0 | DREW MS UP PBLC SRVC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224332 | 224332 | 266.0 | DYMALLY SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224333 | 224333 | 267.0 | EAGLE ROCK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224334 | 224334 | 268.0 | EAGLE ROCK HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224339 | 224339 | 273.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224342 | 224342 | 276.0 | EDISON MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224349 | 224349 | 283.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224350 | 224350 | 284.0 | ELEMENTARY CDS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224353 | 224353 | 287.0 | ELYSIAN HTS ARTS MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224354 | 224354 | 288.0 | EMELITA ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224357 | 224357 | 291.0 | ENCINO CEL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224367 | 224367 | 301.0 | EVANS CAS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224380 | 224380 | 314.0 | FLETCHER DR EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224382 | 224382 | 316.0 | FLOURNOY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224384 | 224384 | 318.0 | FOSHAY LC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224385 | 224385 | 319.0 | FRANKLIN AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224386 | 224386 | 320.0 | FRANKLIN HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224388 | 224388 | 322.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224392 | 224392 | 326.0 | FULTON COLLEGE PREP | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224394 | 224394 | 328.0 | GAL KING SCH FOR STEM | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM |
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 );