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-11-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
208800 | 208800 | 0.0 | 107TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 2 | 2 | 0.2 | 0.20 | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208801 | 208801 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208802 | 208802 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208803 | 208803 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208804 | 208804 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208805 | 208805 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208806 | 208806 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208807 | 208807 | 7.0 | 122ND ST EL | OPEN | green | 3 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.15 | -0.29 | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208808 | 208808 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208809 | 208809 | 9.0 | 153RD ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208810 | 208810 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208811 | 208811 | 11.0 | 15TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.22 | -0.22 | San Pedro CoS | 3 | 0.03 | -0.10 | 4 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208812 | 208812 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208813 | 208813 | 13.0 | 1ST ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.12 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208814 | 208814 | 14.0 | 20TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 2 | 0.02 | -0.05 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208815 | 208815 | 15.0 | 232ND PL EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.63 | Carson CoS | 3 | 0.02 | -0.12 | 7 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208816 | 208816 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.09 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208817 | 208817 | 17.0 | 24TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.15 | -0.15 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.09 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208818 | 208818 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 2 | 0.02 | -0.05 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208819 | 208819 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 2 | 0.02 | -0.05 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208820 | 208820 | 20.0 | 2ND ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.39 | 0.39 | Boyle Heights CoS | 7 | 0.06 | -0.12 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208821 | 208821 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.09 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208822 | 208822 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208823 | 208823 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.09 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208824 | 208824 | 24.0 | 3RD ST EL | OPEN | green | 2 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.40 | Fairfax CoS | 2 | 0.02 | -0.17 | 7 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208825 | 208825 | 25.0 | 42ND ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 3 | 0.07 | -0.10 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208826 | 208826 | 26.0 | 49TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 11 | 0.1 | -0.01 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208827 | 208827 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208828 | 208828 | 28.0 | 4TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208829 | 208829 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208830 | 208830 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.08 | 2 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208831 | 208831 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208832 | 208832 | 32.0 | 59TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.38 | -0.39 | H.E.E.T. (C/D) CoS | 3 | 0.07 | -0.10 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208833 | 208833 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.08 | 2 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208834 | 208834 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 9 | 0.06 | -0.04 | 13 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208835 | 208835 | 35.0 | 66TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 9 | 0.06 | -0.04 | 13 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208836 | 208836 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.22 | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208837 | 208837 | 37.0 | 74TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 3 | 0.07 | -0.10 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208838 | 208838 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208839 | 208839 | 39.0 | 75TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208840 | 208840 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 3 | 0.03 | -0.10 | 4 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208841 | 208841 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208842 | 208842 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208843 | 208843 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208844 | 208844 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208845 | 208845 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.15 | Achievement Network CoS | 0 | 0.0 | -0.05 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208846 | 208846 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208847 | 208847 | 47.0 | 99TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208848 | 208848 | 48.0 | 9TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 2 | 0.02 | -0.05 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208849 | 208849 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | 0.00 | Reseda CoS | 2 | 0.02 | -0.18 | 10 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208850 | 208850 | 50.0 | ADAMS MS | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.12 | SO Los Angeles CoS | 2 | 0.02 | -0.05 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208851 | 208851 | 51.0 | ADDAMS HS | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.63 | 0.63 | Kennedy/NAHS/VAAS CoS | 8 | 0.05 | -0.19 | 16 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208852 | 208852 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208853 | 208853 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | 0.00 | Canoga Park/ChatsworthCoS | 6 | 0.04 | -0.28 | 17 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208854 | 208854 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 7 | 0.05 | -0.14 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208855 | 208855 | 55.0 | ALBION ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.53 | 0.53 | Lincoln Heights/El SerenoCoS | 7 | 0.05 | -0.14 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208856 | 208856 | 56.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 6 | 0.06 | -0.20 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208857 | 208857 | 57.0 | ALEXANDER SCS | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.09 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208858 | 208858 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 7 | 0.07 | -0.10 | 10 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208859 | 208859 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.17 | 0.17 | Downtown CoS | 7 | 0.07 | -0.10 | 10 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208860 | 208860 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 4 | 0.04 | -0.05 | 8 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208861 | 208861 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 2 | 1 | 0.14 | 0.00 | Monroe CoS | 7 | 0.05 | -0.11 | 18 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208862 | 208862 | 62.0 | ALTA LOMA EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208863 | 208863 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208864 | 208864 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 3 | 0.02 | -0.12 | 7 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208865 | 208865 | 65.0 | AMESTOY EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208866 | 208866 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 11 | 0.09 | -0.21 | 24 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208867 | 208867 | 67.0 | ANDASOL AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 8 | 0.05 | -0.19 | 16 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208868 | 208868 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 3 | 0.03 | -0.10 | 4 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208869 | 208869 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208870 | 208870 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 11 | 0.1 | -0.01 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208871 | 208871 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 7 | 0.05 | -0.14 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208872 | 208872 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 3 | 0.02 | -0.12 | 7 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208873 | 208873 | 73.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 6 | 0.06 | -0.20 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208874 | 208874 | 74.0 | ANTON EEC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208875 | 208875 | 75.0 | ANTON EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 6 | 0.04 | -0.15 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208876 | 208876 | 76.0 | APPERSON ST EL | OPEN | green | 2 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 3 | 1 | 0.23 | -0.70 | Sunland/Tujunga CoS | 3 | 0.06 | -0.15 | 22 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208877 | 208877 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 4 | 0.04 | -0.05 | 8 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208878 | 208878 | 78.0 | ARLETA SH | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 6 | 0.04 | -0.17 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208879 | 208879 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 3 | 0.04 | -0.21 | 6 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208880 | 208880 | 80.0 | ARMINTA ST EEC | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 4 | 1 | 1.12 | 0.00 | Sun Valley CoS | 6 | 0.04 | -0.17 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208881 | 208881 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 6 | 0.04 | -0.17 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208882 | 208882 | 82.0 | ARMSTRONG MS | OPEN | yellow | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 3 | 2 | 0.14 | -0.27 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.07 | 13 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208883 | 208883 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.80 | Eagle Rock/Highland ParkCoS | 6 | 0.06 | -0.20 | 11 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208884 | 208884 | 84.0 | ASCOT AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 11 | 0.1 | -0.01 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208885 | 208885 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 4 | 0.04 | -0.05 | 8 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208886 | 208886 | 86.0 | AUDUBON MS | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 3 | 0.07 | -0.10 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208887 | 208887 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.08 | 2 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208888 | 208888 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.08 | 2 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208889 | 208889 | 89.0 | AURORA EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.24 | 0.24 | Historic Central Avenue CoS | 11 | 0.1 | -0.01 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208890 | 208890 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208891 | 208891 | 91.0 | BACA ARTS ACAD | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 0 | 0.0 | -0.16 | Rivera CoS | 9 | 0.06 | -0.04 | 13 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208892 | 208892 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.04 | -0.04 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208893 | 208893 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208894 | 208894 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 8 | 0.05 | -0.19 | 16 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208895 | 208895 | 95.0 | BALDWIN HILLS EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.22 | 0.22 | Hamilton CoS | 2 | 0.02 | -0.08 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208896 | 208896 | 96.0 | BANCROFT MS | OPEN | green | 3 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 5 | 4 | 0.77 | 0.77 | Hollywood CoS | 7 | 0.09 | -0.09 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208897 | 208897 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 3 | 0.03 | -0.10 | 4 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208898 | 208898 | 98.0 | BANNEKER CTC | OPEN | green | 0 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 1 | 0.01 | -0.04 | 1 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 01:39AM | |||||
208899 | 208899 | 99.0 | BANNING SH | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 505 | 273 | 0.04 | -0.1 | 2022-11-25 | 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 );