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-08-28 sorted by lausd_tests
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182558 | 182558 | 0.0 | 107TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.18 | -0.19 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182559 | 182559 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 0 | 0.0 | -0.89 | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182560 | 182560 | 2.0 | 10TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.23 | -0.22 | MacArthur Park CoS | 33 | 0.4 | 0.0 | 39 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182561 | 182561 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182562 | 182562 | 4.0 | 112TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 4 | 0.89 | 0.45 | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182563 | 182563 | 5.0 | 116TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.38 | 0.19 | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182564 | 182564 | 6.0 | 118TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 1 | 0.17 | -0.66 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182565 | 182565 | 7.0 | 122ND ST EL | OPEN | green | 7 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 10 | 6 | 0.8 | 0.40 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182566 | 182566 | 8.0 | 135TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 5 | 0.71 | 0.00 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182567 | 182567 | 9.0 | 153RD ST EL | OPEN | green | 7 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 6 | 1.16 | 0.77 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182568 | 182568 | 10.0 | 156TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.46 | 0.00 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182569 | 182569 | 11.0 | 15TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.64 | 0.21 | San Pedro CoS | 48 | 0.37 | -0.14 | 127 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182570 | 182570 | 12.0 | 186TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 3 | 0.37 | 0.12 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182571 | 182571 | 13.0 | 1ST ST EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 4 | 3 | 0.61 | 0.00 | Boyle Heights CoS | 99 | 0.75 | 0.07 | 186 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182572 | 182572 | 14.0 | 20TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.31 | -0.31 | SO Los Angeles CoS | 31 | 0.28 | -0.13 | 50 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182573 | 182573 | 15.0 | 232ND PL EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 1 | 0.21 | -0.83 | Carson CoS | 57 | 0.41 | -0.03 | 88 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182574 | 182574 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 0 | 0.0 | -2.17 | Manual Arts/VermontSquare CoS | 80 | 0.69 | 0.07 | 109 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182575 | 182575 | 17.0 | 24TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.3 | 0.30 | Manual Arts/VermontSquare CoS | 80 | 0.69 | 0.07 | 109 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182576 | 182576 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 31 | 0.28 | -0.13 | 50 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182577 | 182577 | 19.0 | 28TH ST EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 10 | 4 | 0.64 | -0.32 | SO Los Angeles CoS | 31 | 0.28 | -0.13 | 50 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182578 | 182578 | 20.0 | 2ND ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.37 | 0.37 | Boyle Heights CoS | 99 | 0.75 | 0.07 | 186 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182579 | 182579 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 19 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 15 | 14 | 1.3 | 0.19 | Manual Arts/VermontSquare CoS | 80 | 0.69 | 0.07 | 109 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182580 | 182580 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182581 | 182581 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 80 | 0.69 | 0.07 | 109 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182582 | 182582 | 24.0 | 3RD ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 4 | 4 | 0.51 | -0.25 | Fairfax CoS | 60 | 0.59 | -0.03 | 86 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182583 | 182583 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 15 | 0.29 | 0.03 | 19 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182584 | 182584 | 26.0 | 49TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.14 | -0.14 | Historic Central Avenue CoS | 72 | 0.56 | 0.06 | 159 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182585 | 182585 | 27.0 | 4TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 1.16 | 0.00 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182586 | 182586 | 28.0 | 4TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182587 | 182587 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182588 | 182588 | 30.0 | 52ND ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.26 | 0.13 | South Mid-City CoS | 26 | 0.3 | 0.01 | 34 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182589 | 182589 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182590 | 182590 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 15 | 0.29 | 0.03 | 19 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182591 | 182591 | 33.0 | 61ST ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 0 | 0.0 | -0.27 | South Mid-City CoS | 26 | 0.3 | 0.01 | 34 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182592 | 182592 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 79 | 0.49 | 0.08 | 104 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182593 | 182593 | 35.0 | 66TH ST EL | OPEN | green | 5 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 4 | 0.48 | 0.24 | Rivera CoS | 79 | 0.49 | 0.08 | 104 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182594 | 182594 | 36.0 | 6TH AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.41 | -0.21 | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182595 | 182595 | 37.0 | 74TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.22 | 0.22 | H.E.E.T. (C/D) CoS | 15 | 0.29 | 0.03 | 19 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182596 | 182596 | 38.0 | 75TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 2.04 | 2.04 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182597 | 182597 | 39.0 | 75TH ST EL | OPEN | green | 10 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 15 | 12 | 1.29 | 0.86 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182598 | 182598 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.25 | -0.25 | San Pedro CoS | 48 | 0.37 | -0.14 | 127 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182599 | 182599 | 41.0 | 92ND ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.24 | -0.48 | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182600 | 182600 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 7 | 0 | 0.0 | -0.46 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182601 | 182601 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 8 | 0.14 | -0.07 | 10 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182602 | 182602 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 8 | 0.14 | -0.07 | 10 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182603 | 182603 | 45.0 | 96TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.29 | 0.00 | Achievement Network CoS | 25 | 0.41 | -0.1 | 31 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182604 | 182604 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182605 | 182605 | 47.0 | 99TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.32 | 0.00 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182606 | 182606 | 48.0 | 9TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.31 | 0.00 | SO Los Angeles CoS | 31 | 0.28 | -0.13 | 50 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182607 | 182607 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 75 | 0.58 | 0.09 | 105 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182608 | 182608 | 50.0 | ADAMS MS | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.35 | -0.12 | SO Los Angeles CoS | 31 | 0.28 | -0.13 | 50 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182609 | 182609 | 51.0 | ADDAMS HS | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.95 | 0.48 | Kennedy/NAHS/VAAS CoS | 128 | 0.73 | 0.0 | 295 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182610 | 182610 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182611 | 182611 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 97 | 0.56 | -0.17 | 203 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182612 | 182612 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 98 | 0.63 | -0.05 | 175 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182613 | 182613 | 55.0 | ALBION ST EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 7 | 5 | 2.55 | 2.04 | Lincoln Heights/El SerenoCoS | 98 | 0.63 | -0.05 | 175 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182614 | 182614 | 56.0 | ALDAMA EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.46 | -0.22 | Eagle Rock/Highland ParkCoS | 118 | 0.98 | 0.01 | 203 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182615 | 182615 | 57.0 | ALEXANDER SCS | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 5 | 4 | 0.57 | 0.00 | Manual Arts/VermontSquare CoS | 80 | 0.69 | 0.07 | 109 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182616 | 182616 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 0 | 0.0 | -1.33 | Downtown CoS | 113 | 0.95 | 0.41 | 147 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182617 | 182617 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.48 | 0.32 | Downtown CoS | 113 | 0.95 | 0.41 | 147 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182618 | 182618 | 60.0 | ALLESANDRO EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.25 | 0.00 | Glassell Park/Los Feliz CoS | 93 | 0.76 | 0.07 | 144 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182619 | 182619 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 2 | 2 | 0.26 | 0.26 | Monroe CoS | 83 | 0.58 | -0.15 | 116 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182620 | 182620 | 62.0 | ALTA LOMA EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 0 | 0.0 | -0.42 | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182621 | 182621 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 0 | 0.0 | -0.64 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182622 | 182622 | 64.0 | AMBLER AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 5 | 4 | 0.64 | 0.16 | Carson CoS | 57 | 0.41 | -0.03 | 88 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182623 | 182623 | 65.0 | AMESTOY EL | OPEN | green | 8 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 10 | 7 | 0.84 | 0.00 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182624 | 182624 | 66.0 | ANATOLA AVE EL | OPEN | green | 6 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 6 | 1.64 | 1.37 | Cleveland CoS | 133 | 1.0 | 0.37 | 202 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182625 | 182625 | 67.0 | ANDASOL AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.56 | 0.00 | Kennedy/NAHS/VAAS CoS | 128 | 0.73 | 0.0 | 295 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182626 | 182626 | 70.0 | ANGEL'S GATE HS | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 1.27 | 1.27 | San Pedro CoS | 48 | 0.37 | -0.14 | 127 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182627 | 182627 | 68.0 | ANGELES MESA EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.26 | 0.00 | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182628 | 182628 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 6 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 11 | 7 | 0.47 | -0.13 | Historic Central Avenue CoS | 72 | 0.56 | 0.06 | 159 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182629 | 182629 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 98 | 0.63 | -0.05 | 175 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182630 | 182630 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 57 | 0.41 | -0.03 | 88 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182631 | 182631 | 73.0 | ANNANDALE EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.59 | 0.00 | Eagle Rock/Highland ParkCoS | 118 | 0.98 | 0.01 | 203 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182632 | 182632 | 74.0 | ANTON EEC | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182633 | 182633 | 75.0 | ANTON EL | OPEN | green | 9 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 17 | 11 | 1.85 | 0.67 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 169 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182634 | 182634 | 76.0 | APPERSON ST EL | OPEN | green | 2 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 2 | 0.46 | 0.00 | Sunland/Tujunga CoS | 59 | 1.14 | 0.73 | 295 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182635 | 182635 | 77.0 | ARAGON AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.4 | 0.40 | Glassell Park/Los Feliz CoS | 93 | 0.76 | 0.07 | 144 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182636 | 182636 | 78.0 | ARLETA SH | OPEN | green | 15 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 15 | 12 | 0.74 | -0.25 | Sun Valley CoS | 95 | 0.57 | -0.04 | 130 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182637 | 182637 | 79.0 | ARLINGTON HTS EL | OPEN | green | 5 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 5 | 5 | 1.34 | 1.34 | LA Mid-City CoS | 33 | 0.37 | -0.07 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182638 | 182638 | 80.0 | ARMINTA ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 1.39 | 1.39 | Sun Valley CoS | 95 | 0.57 | -0.04 | 130 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182639 | 182639 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 95 | 0.57 | -0.04 | 130 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182640 | 182640 | 82.0 | ARMSTRONG MS | OPEN | green | 12 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 41 | 12 | 0.72 | -0.36 | Van Nuys/Valley Glen CoS | 118 | 0.58 | 0.05 | 197 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182641 | 182641 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 7 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 11 | 7 | 1.35 | -0.19 | Eagle Rock/Highland ParkCoS | 118 | 0.98 | 0.01 | 203 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182642 | 182642 | 84.0 | ASCOT AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 6 | 0.73 | 0.61 | Historic Central Avenue CoS | 72 | 0.56 | 0.06 | 159 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182643 | 182643 | 85.0 | ATWATER AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 5 | 3 | 0.75 | -0.26 | Glassell Park/Los Feliz CoS | 93 | 0.76 | 0.07 | 144 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182644 | 182644 | 86.0 | AUDUBON MS | OPEN | green | 6 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 6 | 4 | 0.75 | 0.00 | H.E.E.T. (C/D) CoS | 15 | 0.29 | 0.03 | 19 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182645 | 182645 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | 0.01 | 34 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182646 | 182646 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 26 | 0.3 | 0.01 | 34 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182647 | 182647 | 89.0 | AURORA EL | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.23 | 0.23 | Historic Central Avenue CoS | 72 | 0.56 | 0.06 | 159 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182648 | 182648 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182649 | 182649 | 91.0 | BACA ARTS ACAD | OPEN | green | 4 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 8 | 5 | 0.75 | 0.60 | Rivera CoS | 79 | 0.49 | 0.08 | 104 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182650 | 182650 | 92.0 | BAKEWELL PC | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 1.41 | 1.41 | Fremont CoS | 74 | 0.47 | 0.09 | 102 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182651 | 182651 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 8 | 0.14 | -0.07 | 10 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182652 | 182652 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 7 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 16 | 9 | 1.14 | -0.25 | Kennedy/NAHS/VAAS CoS | 128 | 0.73 | 0.0 | 295 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182653 | 182653 | 95.0 | BALDWIN HILLS EL | OPEN | green | 5 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.64 | 0.22 | Hamilton CoS | 64 | 0.69 | -0.19 | 108 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182654 | 182654 | 96.0 | BANCROFT MS | OPEN | green | 1 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 1 | 1 | 0.18 | 0.18 | Hollywood CoS | 46 | 0.53 | 0.0 | 65 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182655 | 182655 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 48 | 0.37 | -0.14 | 127 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182656 | 182656 | 98.0 | BANNEKER CTC | OPEN | green | 3 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 3 | 3 | 0.98 | 0.32 | Gardena CoS | 56 | 0.51 | 0.06 | 71 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
182657 | 182657 | 99.0 | BANNING SH | OPEN | green | 24 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 32 | 22 | 0.64 | 0.17 | Wilmington CoS | 53 | 0.49 | -0.04 | 101 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM |
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 );