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 pos_rate
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
223168 | 223168 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
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 | |||||
223170 | 223170 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | MacArthur Park CoS | 1 | 0.01 | -0.10 | 1 | 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 | |||||
223174 | 223174 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223175 | 223175 | 7.0 | 122ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223176 | 223176 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223177 | 223177 | 9.0 | 153RD ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223178 | 223178 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 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 | |||||
223180 | 223180 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 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 | |||||
223183 | 223183 | 15.0 | 232ND PL EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 2 | 0.02 | -0.09 | 3 | 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 | |||||
223194 | 223194 | 26.0 | 49TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 1 | 0.01 | -0.03 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223195 | 223195 | 27.0 | 4TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223196 | 223196 | 28.0 | 4TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223197 | 223197 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 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 | |||||
223207 | 223207 | 39.0 | 75TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 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 | |||||
223210 | 223210 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223211 | 223211 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223212 | 223212 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.12 | 1 | 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 | |||||
223215 | 223215 | 47.0 | 99TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 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 | |||||
223219 | 223219 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 2 | 0.01 | -0.18 | 3 | 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 | |||||
223221 | 223221 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 2 | 0.01 | -0.18 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223222 | 223222 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223223 | 223223 | 55.0 | ALBION ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 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 | |||||
223231 | 223231 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223232 | 223232 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 2 | 0.02 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223233 | 223233 | 65.0 | AMESTOY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223234 | 223234 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 2 | 0.02 | -0.08 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223235 | 223235 | 67.0 | ANDASOL AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | 0.00 | Kennedy/NAHS/VAAS CoS | 2 | 0.01 | -0.18 | 3 | 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 | |||||
223238 | 223238 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 1 | 0.01 | -0.03 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223239 | 223239 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223240 | 223240 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 2 | 0.02 | -0.09 | 3 | 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 | |||||
223243 | 223243 | 75.0 | ANTON EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 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 | |||||
223252 | 223252 | 84.0 | ASCOT AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 1 | 0.01 | -0.03 | 1 | 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 | |||||
223257 | 223257 | 89.0 | AURORA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 1 | 0.01 | -0.03 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223258 | 223258 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 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 | |||||
223260 | 223260 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223261 | 223261 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223262 | 223262 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 2 | 0.01 | -0.18 | 3 | 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 | |||||
223264 | 223264 | 96.0 | BANCROFT MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 2 | 0.03 | -0.10 | 2 | 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 | |||||
223266 | 223266 | 98.0 | BANNEKER CTC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.09 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223267 | 223267 | 99.0 | BANNING SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 1 | 0.01 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-28 | 01:40AM | |||||
223268 | 223268 | 100.0 | BARRETT EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 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 |
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 );