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-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
212392 | 212392 | 0.0 | 107TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 2 | 0.2 | 0.20 | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212393 | 212393 | 1.0 | 109TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 1 | 0.26 | 0.26 | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212394 | 212394 | 2.0 | 10TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 2 | 0.48 | 0.48 | MacArthur Park CoS | 30 | 0.39 | 0.34 | 200 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212395 | 212395 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212396 | 212396 | 4.0 | 112TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 0.48 | 0.48 | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212397 | 212397 | 5.0 | 116TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.21 | 0.00 | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212398 | 212398 | 6.0 | 118TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 2 | 0.35 | 0.35 | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212399 | 212399 | 7.0 | 122ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 4 | 0.59 | 0.30 | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212400 | 212400 | 8.0 | 135TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 0.3 | 0.30 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212401 | 212401 | 9.0 | 153RD ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 2 | 0.41 | 0.21 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212402 | 212402 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | -0.25 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212403 | 212403 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.22 | -0.21 | San Pedro CoS | 39 | 0.33 | 0.24 | 136 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212404 | 212404 | 12.0 | 186TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 4 | 0.53 | 0.40 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212405 | 212405 | 13.0 | 1ST ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 3 | 0.66 | 0.66 | Boyle Heights CoS | 73 | 0.6 | 0.45 | 171 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212406 | 212406 | 14.0 | 20TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 2 | 0.32 | 0.32 | SO Los Angeles CoS | 33 | 0.33 | 0.19 | 88 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212407 | 212407 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 1 | 0.21 | 0.21 | Carson CoS | 41 | 0.32 | 0.24 | 134 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212408 | 212408 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 68 | 0.64 | 0.51 | 149 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212409 | 212409 | 17.0 | 24TH ST EL | OPEN | green | 6 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 18 | 9 | 1.36 | 1.06 | Manual Arts/VermontSquare CoS | 68 | 0.64 | 0.51 | 149 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212410 | 212410 | 18.0 | 28TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 2.08 | 2.08 | SO Los Angeles CoS | 33 | 0.33 | 0.19 | 88 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212411 | 212411 | 19.0 | 28TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 16 | 5 | 0.86 | 0.69 | SO Los Angeles CoS | 33 | 0.33 | 0.19 | 88 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212412 | 212412 | 20.0 | 2ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | 0.00 | Boyle Heights CoS | 73 | 0.6 | 0.45 | 171 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212413 | 212413 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 7 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 14 | 7 | 0.71 | 0.61 | Manual Arts/VermontSquare CoS | 68 | 0.64 | 0.51 | 149 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212414 | 212414 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212415 | 212415 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 68 | 0.64 | 0.51 | 149 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212416 | 212416 | 24.0 | 3RD ST EL | OPEN | green | 7 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 19 | 7 | 0.94 | 0.94 | Fairfax CoS | 48 | 0.53 | 0.36 | 210 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212417 | 212417 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 12 | 0.26 | 0.17 | 38 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212418 | 212418 | 26.0 | 49TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 6 | 0.89 | 0.89 | Historic Central Avenue CoS | 77 | 0.66 | 0.5 | 150 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212419 | 212419 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212420 | 212420 | 28.0 | 4TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 1 | 0.29 | 0.29 | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212421 | 212421 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212422 | 212422 | 30.0 | 52ND ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 0 | 0.0 | -0.13 | South Mid-City CoS | 20 | 0.25 | 0.15 | 179 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212423 | 212423 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212424 | 212424 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 1 | 0.38 | 0.00 | H.E.E.T. (C/D) CoS | 12 | 0.26 | 0.17 | 38 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212425 | 212425 | 33.0 | 61ST ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 3 | 0.4 | 0.40 | South Mid-City CoS | 20 | 0.25 | 0.15 | 179 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212426 | 212426 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | 0.00 | Rivera CoS | 49 | 0.34 | 0.23 | 196 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212427 | 212427 | 35.0 | 66TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 4 | 0.5 | 0.50 | Rivera CoS | 49 | 0.34 | 0.23 | 196 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212428 | 212428 | 36.0 | 6TH AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 1 | 0.22 | 0.00 | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212429 | 212429 | 37.0 | 74TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 0.46 | 0.46 | H.E.E.T. (C/D) CoS | 12 | 0.26 | 0.17 | 38 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212430 | 212430 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212431 | 212431 | 39.0 | 75TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 4 | 0.45 | 0.45 | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212432 | 212432 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | 0.00 | San Pedro CoS | 39 | 0.33 | 0.24 | 136 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212433 | 212433 | 41.0 | 92ND ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 2 | 0.26 | 0.26 | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212434 | 212434 | 42.0 | 93RD ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 13 | 4 | 0.42 | 0.42 | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212435 | 212435 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 14 | 0.27 | 0.25 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212436 | 212436 | 44.0 | 95TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 4 | 0.47 | 0.35 | H.E.E.T. (W) CoS | 14 | 0.27 | 0.25 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212437 | 212437 | 45.0 | 96TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 15 | 5 | 0.74 | 0.74 | Achievement Network CoS | 20 | 0.35 | 0.33 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212438 | 212438 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212439 | 212439 | 47.0 | 99TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 2 | 0.34 | 0.34 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212440 | 212440 | 48.0 | 9TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 0.58 | 0.00 | SO Los Angeles CoS | 33 | 0.33 | 0.19 | 88 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212441 | 212441 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 16 | 0 | 0.0 | -0.29 | Reseda CoS | 73 | 0.62 | 0.48 | 202 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212442 | 212442 | 50.0 | ADAMS MS | OPEN | green | 5 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 4 | 0.48 | 0.36 | SO Los Angeles CoS | 33 | 0.33 | 0.19 | 88 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212443 | 212443 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 79 | 0.51 | 0.33 | 257 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212444 | 212444 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.41 | 0.41 | - | 0 | 0.0 | 0.0 | 0 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212445 | 212445 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 79 | 0.5 | 0.34 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212446 | 212446 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 98 | 0.67 | 0.57 | 222 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212447 | 212447 | 55.0 | ALBION ST EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.53 | 0.53 | Lincoln Heights/El SerenoCoS | 98 | 0.67 | 0.57 | 222 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212448 | 212448 | 56.0 | ALDAMA EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 2 | 0.48 | 0.48 | Eagle Rock/Highland ParkCoS | 73 | 0.67 | 0.44 | 158 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212449 | 212449 | 57.0 | ALEXANDER SCS | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 6 | 0.89 | 0.74 | Manual Arts/VermontSquare CoS | 68 | 0.64 | 0.51 | 149 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212450 | 212450 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 50 | 0.47 | 0.31 | 138 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212451 | 212451 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 0 | 0.0 | -0.16 | Downtown CoS | 50 | 0.47 | 0.31 | 138 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212452 | 212452 | 60.0 | ALLESANDRO EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 5 | 5 | 1.28 | 1.28 | Glassell Park/Los Feliz CoS | 64 | 0.57 | 0.46 | 159 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212453 | 212453 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 4 | 0.55 | 0.41 | Monroe CoS | 58 | 0.43 | 0.35 | 175 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212454 | 212454 | 62.0 | ALTA LOMA EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.22 | 0.22 | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212455 | 212455 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 1 | 0 | 0.0 | 0.00 | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212456 | 212456 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 41 | 0.32 | 0.24 | 134 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212457 | 212457 | 65.0 | AMESTOY EL | OPEN | green | 5 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 10 | 5 | 0.63 | 0.50 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212458 | 212458 | 66.0 | ANATOLA AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 0 | 0.0 | -0.29 | Cleveland CoS | 76 | 0.63 | 0.43 | 184 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212459 | 212459 | 67.0 | ANDASOL AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 9 | 1 | 0.19 | 0.19 | Kennedy/NAHS/VAAS CoS | 79 | 0.51 | 0.33 | 257 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212460 | 212460 | 70.0 | ANGEL'S GATE HS | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 1.2 | 1.20 | San Pedro CoS | 39 | 0.33 | 0.24 | 136 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212461 | 212461 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 5 | 0 | 0.0 | 0.00 | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212462 | 212462 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 9 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 14 | 8 | 0.64 | 0.40 | Historic Central Avenue CoS | 77 | 0.66 | 0.5 | 150 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212463 | 212463 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 98 | 0.67 | 0.57 | 222 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212464 | 212464 | 72.0 | ANNALEE AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 1 | 0.41 | 0.41 | Carson CoS | 41 | 0.32 | 0.24 | 134 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212465 | 212465 | 73.0 | ANNANDALE EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 3 | 1.84 | 1.23 | Eagle Rock/Highland ParkCoS | 73 | 0.67 | 0.44 | 158 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212466 | 212466 | 74.0 | ANTON EEC | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 5 | 1 | 0.86 | 0.86 | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212467 | 212467 | 75.0 | ANTON EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 2 | 0.36 | 0.36 | East Los Angeles CoS | 101 | 0.71 | 0.58 | 236 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212468 | 212468 | 76.0 | APPERSON ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 3 | 0.7 | 0.70 | Sunland/Tujunga CoS | 43 | 0.89 | 0.62 | 157 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212469 | 212469 | 77.0 | ARAGON AVE EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 3 | 1.24 | 1.24 | Glassell Park/Los Feliz CoS | 64 | 0.57 | 0.46 | 159 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212470 | 212470 | 78.0 | ARLETA SH | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 10 | 7 | 0.53 | 0.38 | Sun Valley CoS | 63 | 0.41 | 0.29 | 132 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212471 | 212471 | 79.0 | ARLINGTON HTS EL | OPEN | green | 1 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 1 | 0.28 | 0.28 | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212472 | 212472 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 63 | 0.41 | 0.29 | 132 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212473 | 212473 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 5 | 0 | 0.0 | 0.00 | Sun Valley CoS | 63 | 0.41 | 0.29 | 132 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212474 | 212474 | 82.0 | ARMSTRONG MS | OPEN | yellow | 8 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 21 | 5 | 0.34 | 0.14 | Van Nuys/Valley Glen CoS | 100 | 0.55 | 0.41 | 597 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212475 | 212475 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 5 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 7 | 5 | 1.0 | 0.80 | Eagle Rock/Highland ParkCoS | 73 | 0.67 | 0.44 | 158 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212476 | 212476 | 84.0 | ASCOT AVE EL | OPEN | green | 6 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 7 | 0.9 | 0.90 | Historic Central Avenue CoS | 77 | 0.66 | 0.5 | 150 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212477 | 212477 | 85.0 | ATWATER AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 4 | 1.04 | 1.04 | Glassell Park/Los Feliz CoS | 64 | 0.57 | 0.46 | 159 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212478 | 212478 | 86.0 | AUDUBON MS | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 9 | 3 | 0.58 | 0.58 | H.E.E.T. (C/D) CoS | 12 | 0.26 | 0.17 | 38 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212479 | 212479 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 20 | 0.25 | 0.15 | 179 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212480 | 212480 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 20 | 0.25 | 0.15 | 179 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212481 | 212481 | 89.0 | AURORA EL | OPEN | green | 4 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 8 | 5 | 1.19 | 0.95 | Historic Central Avenue CoS | 77 | 0.66 | 0.5 | 150 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212482 | 212482 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212483 | 212483 | 91.0 | BACA ARTS ACAD | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 9 | 5 | 0.79 | 0.63 | Rivera CoS | 49 | 0.34 | 0.23 | 196 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212484 | 212484 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 53 | 0.37 | 0.34 | 182 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212485 | 212485 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 11 | 0 | 0.0 | 0.00 | H.E.E.T. (W) CoS | 14 | 0.27 | 0.25 | 59 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212486 | 212486 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 2 | 2 | 0.27 | 0.27 | Kennedy/NAHS/VAAS CoS | 79 | 0.51 | 0.33 | 257 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212487 | 212487 | 95.0 | BALDWIN HILLS EL | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 3 | 3 | 0.67 | 0.67 | Hamilton CoS | 63 | 0.76 | 0.53 | 136 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212488 | 212488 | 96.0 | BANCROFT MS | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 21 | 3 | 0.58 | 0.39 | Hollywood CoS | 59 | 0.75 | 0.56 | 265 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212489 | 212489 | 97.0 | BANDINI ST EL | OPEN | green | 3 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 6 | 4 | 1.35 | 1.35 | San Pedro CoS | 39 | 0.33 | 0.24 | 136 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212490 | 212490 | 98.0 | BANNEKER CTC | OPEN | green | 2 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 4 | 2 | 0.69 | 0.69 | Gardena CoS | 40 | 0.4 | 0.33 | 77 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
212491 | 212491 | 99.0 | BANNING SH | OPEN | green | 10 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 44 | 7 | 0.26 | 0.04 | Wilmington CoS | 30 | 0.3 | 0.1 | 215 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM |
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 );