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-28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
223169 | 223169 | 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-28 | 01:40AM | |||||
223171 | 223171 | 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-28 | 01:40AM | |||||
223172 | 223172 | 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-28 | 01:40AM | |||||
223173 | 223173 | 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-28 | 01:40AM | |||||
223179 | 223179 | 11.0 | 15TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223181 | 223181 | 13.0 | 1ST ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223182 | 223182 | 14.0 | 20TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223184 | 223184 | 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-28 | 01:40AM | |||||
223185 | 223185 | 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-28 | 01:40AM | |||||
223186 | 223186 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | -2.02 | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223187 | 223187 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223188 | 223188 | 20.0 | 2ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223189 | 223189 | 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-28 | 01:40AM | |||||
223190 | 223190 | 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-28 | 01:40AM | |||||
223191 | 223191 | 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-28 | 01:40AM | |||||
223192 | 223192 | 24.0 | 3RD ST EL | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fairfax CoS | 0 | 0.0 | -0.18 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223193 | 223193 | 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-28 | 01:40AM | |||||
223198 | 223198 | 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-28 | 01:40AM | |||||
223199 | 223199 | 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-28 | 01:40AM | |||||
223200 | 223200 | 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-28 | 01:40AM | |||||
223201 | 223201 | 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-28 | 01:40AM | |||||
223202 | 223202 | 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-28 | 01:40AM | |||||
223203 | 223203 | 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-28 | 01:40AM | |||||
223204 | 223204 | 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-28 | 01:40AM | |||||
223205 | 223205 | 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-28 | 01:40AM | |||||
223208 | 223208 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223209 | 223209 | 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-28 | 01:40AM | |||||
223213 | 223213 | 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-28 | 01:40AM | |||||
223216 | 223216 | 48.0 | 9TH ST EL | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223217 | 223217 | 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-28 | 01:40AM | |||||
223218 | 223218 | 50.0 | ADAMS MS | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223220 | 223220 | 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-28 | 01:40AM | |||||
223224 | 223224 | 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-28 | 01:40AM | |||||
223225 | 223225 | 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-28 | 01:40AM | |||||
223226 | 223226 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223227 | 223227 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223228 | 223228 | 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-28 | 01:40AM | |||||
223229 | 223229 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223230 | 223230 | 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-28 | 01:40AM | |||||
223236 | 223236 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223237 | 223237 | 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-28 | 01:40AM | |||||
223241 | 223241 | 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-28 | 01:40AM | |||||
223244 | 223244 | 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-28 | 01:40AM | |||||
223245 | 223245 | 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-28 | 01:40AM | |||||
223246 | 223246 | 78.0 | ARLETA SH | OPEN | yellow | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | -0.23 | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223247 | 223247 | 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-28 | 01:40AM | |||||
223248 | 223248 | 80.0 | ARMINTA ST EEC | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223249 | 223249 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223250 | 223250 | 82.0 | ARMSTRONG MS | OPEN | yellow | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 0 | 0.0 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223251 | 223251 | 83.0 | ARROYO SECO MUS/S MAG | 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-28 | 01:40AM | |||||
223253 | 223253 | 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-28 | 01:40AM | |||||
223254 | 223254 | 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-28 | 01:40AM | |||||
223255 | 223255 | 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-28 | 01:40AM | |||||
223256 | 223256 | 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-28 | 01:40AM | |||||
223259 | 223259 | 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-28 | 01:40AM | |||||
223263 | 223263 | 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-28 | 01:40AM | |||||
223265 | 223265 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223269 | 223269 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223270 | 223270 | 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-28 | 01:40AM | |||||
223271 | 223271 | 103.0 | BEACHY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223273 | 223273 | 105.0 | BEETHOVEN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223276 | 223276 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223279 | 223279 | 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-28 | 01:40AM | |||||
223282 | 223282 | 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-28 | 01:40AM | |||||
223286 | 223286 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223287 | 223287 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223288 | 223288 | 120.0 | BRADDOCK DR EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223289 | 223289 | 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-28 | 01:40AM | |||||
223290 | 223290 | 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-28 | 01:40AM | |||||
223291 | 223291 | 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-28 | 01:40AM | |||||
223293 | 223293 | 125.0 | BREED ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223294 | 223294 | 126.0 | BRENTWOOD EL SCI MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223295 | 223295 | 127.0 | BRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223297 | 223297 | 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-28 | 01:40AM | |||||
223302 | 223302 | 134.0 | BROADWAY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223303 | 223303 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223306 | 223306 | 138.0 | BRYSON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223307 | 223307 | 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-28 | 01:40AM | |||||
223308 | 223308 | 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-28 | 01:40AM | |||||
223310 | 223310 | 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-28 | 01:40AM | |||||
223311 | 223311 | 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-28 | 01:40AM | |||||
223312 | 223312 | 144.0 | BURROUGHS MS | OPEN | green | 2 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fairfax CoS | 0 | 0.0 | -0.18 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223313 | 223313 | 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-28 | 01:40AM | |||||
223314 | 223314 | 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-28 | 01:40AM | |||||
223315 | 223315 | 147.0 | BYRD MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223316 | 223316 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223317 | 223317 | 149.0 | CABRILLO AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223318 | 223318 | 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-28 | 01:40AM | |||||
223319 | 223319 | 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-28 | 01:40AM | |||||
223321 | 223321 | 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-28 | 01:40AM | |||||
223323 | 223323 | 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-28 | 01:40AM | |||||
223328 | 223328 | 160.0 | CANTERBURY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223329 | 223329 | 161.0 | CANYON CEL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223331 | 223331 | 163.0 | CARDENAS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 0 | 0.0 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223340 | 223340 | 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-28 | 01:40AM | |||||
223341 | 223341 | 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-28 | 01:40AM | |||||
223343 | 223343 | 175.0 | CASTELAR ST EEC | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223344 | 223344 | 176.0 | CASTELAR ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223345 | 223345 | 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-28 | 01:40AM | |||||
223347 | 223347 | 179.0 | CASTRO MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM |
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 );