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-06
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
214188 | 214188 | 0.0 | 107TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 4 | 0.4 | 0.40 | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214189 | 214189 | 1.0 | 109TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.26 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214190 | 214190 | 2.0 | 10TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.24 | -0.24 | MacArthur Park CoS | 19 | 0.25 | -0.12 | 35 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214191 | 214191 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214192 | 214192 | 4.0 | 112TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.48 | 0.48 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214193 | 214193 | 5.0 | 116TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214194 | 214194 | 6.0 | 118TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.18 | 0.00 | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214195 | 214195 | 7.0 | 122ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.29 | -0.15 | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214196 | 214196 | 8.0 | 135TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.30 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214197 | 214197 | 9.0 | 153RD ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.2 | -0.21 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214198 | 214198 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.25 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214199 | 214199 | 11.0 | 15TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.22 | -0.21 | San Pedro CoS | 25 | 0.21 | -0.07 | 48 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214200 | 214200 | 12.0 | 186TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 8 | 2 | 0.27 | -0.26 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214201 | 214201 | 13.0 | 1ST ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 1 | 0.22 | -0.22 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214202 | 214202 | 14.0 | 20TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.32 | 0.16 | SO Los Angeles CoS | 21 | 0.21 | -0.11 | 36 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214203 | 214203 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.21 | Carson CoS | 31 | 0.25 | -0.01 | 52 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214204 | 214204 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 49 | 0.46 | 0.03 | 67 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214205 | 214205 | 17.0 | 24TH ST EL | OPEN | green | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 5 | 0.76 | -0.30 | Manual Arts/VermontSquare CoS | 49 | 0.46 | 0.03 | 67 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214206 | 214206 | 18.0 | 28TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 21 | 0.21 | -0.11 | 36 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214207 | 214207 | 19.0 | 28TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 3 | 0.52 | 0.00 | SO Los Angeles CoS | 21 | 0.21 | -0.11 | 36 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214208 | 214208 | 20.0 | 2ND ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.78 | 0.78 | Boyle Heights CoS | 42 | 0.34 | -0.21 | 77 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214209 | 214209 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 6 | 0.61 | 0.31 | Manual Arts/VermontSquare CoS | 49 | 0.46 | 0.03 | 67 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214210 | 214210 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214211 | 214211 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 49 | 0.46 | 0.03 | 67 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214212 | 214212 | 24.0 | 3RD ST EL | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 3 | 0.4 | -0.14 | Fairfax CoS | 28 | 0.31 | -0.16 | 60 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214213 | 214213 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 11 | 0.24 | 0.13 | 15 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214214 | 214214 | 26.0 | 49TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 4 | 0.6 | 0.30 | Historic Central Avenue CoS | 48 | 0.41 | -0.12 | 82 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214215 | 214215 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214216 | 214216 | 28.0 | 4TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214217 | 214217 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214218 | 214218 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 0 | 0.0 | -0.13 | South Mid-City CoS | 13 | 0.16 | -0.12 | 34 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214219 | 214219 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214220 | 214220 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 11 | 0.24 | 0.13 | 15 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214221 | 214221 | 33.0 | 61ST ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 1 | 0.13 | -0.14 | South Mid-City CoS | 13 | 0.16 | -0.12 | 34 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214222 | 214222 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 36 | 0.25 | -0.01 | 54 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214223 | 214223 | 35.0 | 66TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 4 | 0.5 | 0.13 | Rivera CoS | 36 | 0.25 | -0.01 | 54 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214224 | 214224 | 36.0 | 6TH AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.22 | -0.22 | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214225 | 214225 | 37.0 | 74TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.46 | 0.46 | H.E.E.T. (C/D) CoS | 11 | 0.24 | 0.13 | 15 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214226 | 214226 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214227 | 214227 | 39.0 | 75TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 3 | 0.34 | 0.11 | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214228 | 214228 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.26 | 0.26 | San Pedro CoS | 25 | 0.21 | -0.07 | 48 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214229 | 214229 | 41.0 | 92ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.26 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214230 | 214230 | 42.0 | 93RD ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 8 | 3 | 0.32 | 0.21 | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214231 | 214231 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.14 | -0.02 | 11 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214232 | 214232 | 44.0 | 95TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 2 | 0.23 | -0.12 | H.E.E.T. (W) CoS | 7 | 0.14 | -0.02 | 11 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214233 | 214233 | 45.0 | 96TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.15 | -0.44 | Achievement Network CoS | 11 | 0.19 | -0.07 | 17 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214234 | 214234 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214235 | 214235 | 47.0 | 99TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 3 | 0.5 | 0.33 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214236 | 214236 | 48.0 | 9TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.58 | 0.00 | SO Los Angeles CoS | 21 | 0.21 | -0.11 | 36 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214237 | 214237 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 0 | 0.0 | -0.29 | Reseda CoS | 39 | 0.33 | -0.17 | 85 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214238 | 214238 | 50.0 | ADAMS MS | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.24 | -0.12 | SO Los Angeles CoS | 21 | 0.21 | -0.11 | 36 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214239 | 214239 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 59 | 0.38 | -0.05 | 147 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214240 | 214240 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.37 | 0.37 | - | 0 | 0.0 | 0.0 | 0 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214241 | 214241 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 44 | 0.28 | -0.13 | 110 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214242 | 214242 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 50 | 0.34 | -0.19 | 96 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214243 | 214243 | 55.0 | ALBION ST EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 1.05 | 1.05 | Lincoln Heights/El SerenoCoS | 50 | 0.34 | -0.19 | 96 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214244 | 214244 | 56.0 | ALDAMA EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.24 | 0.00 | Eagle Rock/Highland ParkCoS | 51 | 0.47 | -0.09 | 121 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214245 | 214245 | 57.0 | ALEXANDER SCS | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 6 | 3 | 0.44 | -0.15 | Manual Arts/VermontSquare CoS | 49 | 0.46 | 0.03 | 67 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214246 | 214246 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 41 | 0.38 | 0.06 | 63 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214247 | 214247 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | 0.00 | Downtown CoS | 41 | 0.38 | 0.06 | 63 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214248 | 214248 | 60.0 | ALLESANDRO EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 3 | 0.77 | 0.26 | Glassell Park/Los Feliz CoS | 33 | 0.29 | -0.19 | 69 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214249 | 214249 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.68 | Monroe CoS | 42 | 0.31 | 0.02 | 68 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214250 | 214250 | 62.0 | ALTA LOMA EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.43 | 0.43 | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214251 | 214251 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214252 | 214252 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 31 | 0.25 | -0.01 | 52 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214253 | 214253 | 65.0 | AMESTOY EL | OPEN | green | 6 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 2 | 0.25 | -0.38 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214254 | 214254 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 49 | 0.41 | -0.14 | 86 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214255 | 214255 | 67.0 | ANDASOL AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 0 | 0.0 | -0.19 | Kennedy/NAHS/VAAS CoS | 59 | 0.38 | -0.05 | 147 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214256 | 214256 | 70.0 | ANGEL'S GATE HS | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 25 | 0.21 | -0.07 | 48 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214257 | 214257 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214258 | 214258 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 9 | 5 | 0.4 | -0.24 | Historic Central Avenue CoS | 48 | 0.41 | -0.12 | 82 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214259 | 214259 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 50 | 0.34 | -0.19 | 96 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214260 | 214260 | 72.0 | ANNALEE AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.41 | 0.00 | Carson CoS | 31 | 0.25 | -0.01 | 52 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214261 | 214261 | 73.0 | ANNANDALE EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 1 | 0.61 | -1.23 | Eagle Rock/Highland ParkCoS | 51 | 0.47 | -0.09 | 121 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214262 | 214262 | 74.0 | ANTON EEC | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 3 | 2.59 | 2.59 | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214263 | 214263 | 75.0 | ANTON EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 1 | 0.18 | 0.00 | East Los Angeles CoS | 75 | 0.52 | 0.03 | 119 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214264 | 214264 | 76.0 | APPERSON ST EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 2 | 0 | 0.0 | -0.70 | Sunland/Tujunga CoS | 20 | 0.42 | -0.35 | 60 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214265 | 214265 | 77.0 | ARAGON AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 4 | 1.66 | 1.25 | Glassell Park/Los Feliz CoS | 33 | 0.29 | -0.19 | 69 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214266 | 214266 | 78.0 | ARLETA SH | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 8 | 5 | 0.38 | 0.00 | Sun Valley CoS | 49 | 0.32 | 0.02 | 91 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214267 | 214267 | 79.0 | ARLINGTON HTS EL | OPEN | green | 1 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 27 | 0.34 | 0.07 | 56 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214268 | 214268 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 49 | 0.32 | 0.02 | 91 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214269 | 214269 | 81.0 | ARMINTA ST EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 2 | 0.45 | 0.45 | Sun Valley CoS | 49 | 0.32 | 0.02 | 91 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214270 | 214270 | 82.0 | ARMSTRONG MS | OPEN | yellow | 7 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 10 | 5 | 0.34 | -0.06 | Van Nuys/Valley Glen CoS | 67 | 0.37 | -0.08 | 125 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214271 | 214271 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 1 | 0.2 | -1.00 | Eagle Rock/Highland ParkCoS | 51 | 0.47 | -0.09 | 121 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214272 | 214272 | 84.0 | ASCOT AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 8 | 5 | 0.64 | 0.38 | Historic Central Avenue CoS | 48 | 0.41 | -0.12 | 82 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214273 | 214273 | 85.0 | ATWATER AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 1 | 0.26 | -0.52 | Glassell Park/Los Feliz CoS | 33 | 0.29 | -0.19 | 69 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214274 | 214274 | 86.0 | AUDUBON MS | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 2 | 0.39 | 0.20 | H.E.E.T. (C/D) CoS | 11 | 0.24 | 0.13 | 15 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214275 | 214275 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 13 | 0.16 | -0.12 | 34 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214276 | 214276 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 13 | 0.16 | -0.12 | 34 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214277 | 214277 | 89.0 | AURORA EL | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 3 | 0.71 | -0.24 | Historic Central Avenue CoS | 48 | 0.41 | -0.12 | 82 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214278 | 214278 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214279 | 214279 | 91.0 | BACA ARTS ACAD | OPEN | green | 5 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 4 | 0.63 | 0.00 | Rivera CoS | 36 | 0.25 | -0.01 | 54 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214280 | 214280 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 35 | 0.24 | 0.02 | 61 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214281 | 214281 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 7 | 0.14 | -0.02 | 11 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214282 | 214282 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 7 | 5 | 0.68 | 0.54 | Kennedy/NAHS/VAAS CoS | 59 | 0.38 | -0.05 | 147 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214283 | 214283 | 95.0 | BALDWIN HILLS EL | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 3 | 3 | 0.67 | 0.45 | Hamilton CoS | 39 | 0.47 | -0.17 | 81 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214284 | 214284 | 96.0 | BANCROFT MS | OPEN | green | 3 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 5 | 2 | 0.38 | -0.39 | Hollywood CoS | 33 | 0.42 | -0.21 | 91 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214285 | 214285 | 97.0 | BANDINI ST EL | OPEN | green | 4 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 4 | 3 | 1.01 | 0.34 | San Pedro CoS | 25 | 0.21 | -0.07 | 48 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214286 | 214286 | 98.0 | BANNEKER CTC | OPEN | green | 2 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 1 | 0 | 0.0 | -0.69 | Gardena CoS | 21 | 0.21 | -0.14 | 39 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214287 | 214287 | 99.0 | BANNING SH | OPEN | green | 9 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 10 | 3 | 0.11 | -0.29 | Wilmington CoS | 23 | 0.23 | -0.14 | 44 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM |
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 );