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.
2,694 rows where lausd_pos_rate = "0.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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207902 | 207902 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207903 | 207903 | 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-24 | 01:35AM | |||||
207904 | 207904 | 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-24 | 01:35AM | |||||
207905 | 207905 | 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-24 | 01:35AM | |||||
207906 | 207906 | 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-24 | 01:35AM | |||||
207907 | 207907 | 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-24 | 01:35AM | |||||
207908 | 207908 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207909 | 207909 | 7.0 | 122ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.15 | -0.29 | Fremont CoS | 5 | 0.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207910 | 207910 | 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-24 | 01:35AM | |||||
207911 | 207911 | 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-24 | 01:35AM | |||||
207912 | 207912 | 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-24 | 01:35AM | |||||
207913 | 207913 | 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-24 | 01:35AM | |||||
207914 | 207914 | 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-24 | 01:35AM | |||||
207915 | 207915 | 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-24 | 01:35AM | |||||
207916 | 207916 | 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.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207917 | 207917 | 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-24 | 01:35AM | |||||
207918 | 207918 | 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-24 | 01:35AM | |||||
207919 | 207919 | 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-24 | 01:35AM | |||||
207920 | 207920 | 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.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207921 | 207921 | 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.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207922 | 207922 | 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-24 | 01:35AM | |||||
207923 | 207923 | 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-24 | 01:35AM | |||||
207924 | 207924 | 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-24 | 01:35AM | |||||
207925 | 207925 | 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-24 | 01:35AM | |||||
207926 | 207926 | 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-24 | 01:35AM | |||||
207927 | 207927 | 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.06 | -0.11 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207928 | 207928 | 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.09 | -0.02 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207929 | 207929 | 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-24 | 01:35AM | |||||
207930 | 207930 | 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-24 | 01:35AM | |||||
207931 | 207931 | 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-24 | 01:35AM | |||||
207932 | 207932 | 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-24 | 01:35AM | |||||
207933 | 207933 | 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-24 | 01:35AM | |||||
207934 | 207934 | 32.0 | 59TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.39 | -0.38 | H.E.E.T. (C/D) CoS | 3 | 0.06 | -0.11 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207935 | 207935 | 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-24 | 01:35AM | |||||
207936 | 207936 | 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-24 | 01:35AM | |||||
207937 | 207937 | 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-24 | 01:35AM | |||||
207938 | 207938 | 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-24 | 01:35AM | |||||
207939 | 207939 | 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.06 | -0.11 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207940 | 207940 | 38.0 | 75TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 5 | 0.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207941 | 207941 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207942 | 207942 | 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-24 | 01:35AM | |||||
207943 | 207943 | 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-24 | 01:35AM | |||||
207944 | 207944 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207945 | 207945 | 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-24 | 01:35AM | |||||
207946 | 207946 | 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-24 | 01:35AM | |||||
207947 | 207947 | 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-24 | 01:35AM | |||||
207948 | 207948 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207949 | 207949 | 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-24 | 01:35AM | |||||
207950 | 207950 | 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.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207951 | 207951 | 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-24 | 01:35AM | |||||
207952 | 207952 | 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.06 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207953 | 207953 | 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-24 | 01:35AM | |||||
207954 | 207954 | 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-24 | 01:35AM | |||||
207955 | 207955 | 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-24 | 01:35AM | |||||
207956 | 207956 | 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-24 | 01:35AM | |||||
207957 | 207957 | 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-24 | 01:35AM | |||||
207958 | 207958 | 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-24 | 01:35AM | |||||
207959 | 207959 | 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-24 | 01:35AM | |||||
207960 | 207960 | 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-24 | 01:35AM | |||||
207961 | 207961 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 1 | 1 | 0.16 | 0.16 | Downtown CoS | 7 | 0.07 | -0.10 | 10 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207962 | 207962 | 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-24 | 01:35AM | |||||
207963 | 207963 | 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-24 | 01:35AM | |||||
207964 | 207964 | 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-24 | 01:35AM | |||||
207965 | 207965 | 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-24 | 01:35AM | |||||
207966 | 207966 | 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-24 | 01:35AM | |||||
207967 | 207967 | 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-24 | 01:35AM | |||||
207968 | 207968 | 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-24 | 01:35AM | |||||
207969 | 207969 | 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-24 | 01:35AM | |||||
207970 | 207970 | 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-24 | 01:35AM | |||||
207971 | 207971 | 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-24 | 01:35AM | |||||
207972 | 207972 | 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.09 | -0.02 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207973 | 207973 | 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-24 | 01:35AM | |||||
207974 | 207974 | 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-24 | 01:35AM | |||||
207975 | 207975 | 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-24 | 01:35AM | |||||
207976 | 207976 | 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-24 | 01:35AM | |||||
207977 | 207977 | 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-24 | 01:35AM | |||||
207978 | 207978 | 76.0 | APPERSON ST EL | OPEN | green | 2 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 3 | 1 | 0.23 | -0.71 | Sunland/Tujunga CoS | 3 | 0.06 | -0.15 | 22 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207979 | 207979 | 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-24 | 01:35AM | |||||
207980 | 207980 | 78.0 | ARLETA SH | OPEN | green | 2 | 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-24 | 01:35AM | |||||
207981 | 207981 | 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-24 | 01:35AM | |||||
207982 | 207982 | 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-24 | 01:35AM | |||||
207983 | 207983 | 81.0 | ARMINTA ST EL | 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-24 | 01:35AM | |||||
207984 | 207984 | 82.0 | ARMSTRONG MS | OPEN | yellow | 3 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 3 | 2 | 0.14 | -0.27 | Van Nuys/Valley Glen CoS | 8 | 0.04 | -0.08 | 12 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207985 | 207985 | 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-24 | 01:35AM | |||||
207986 | 207986 | 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.09 | -0.02 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207987 | 207987 | 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-24 | 01:35AM | |||||
207988 | 207988 | 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.06 | -0.11 | 3 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207989 | 207989 | 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-24 | 01:35AM | |||||
207990 | 207990 | 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-24 | 01:35AM | |||||
207991 | 207991 | 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.09 | -0.02 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207992 | 207992 | 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-24 | 01:35AM | |||||
207993 | 207993 | 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-24 | 01:35AM | |||||
207994 | 207994 | 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.03 | -0.05 | 5 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207995 | 207995 | 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-24 | 01:35AM | |||||
207996 | 207996 | 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-24 | 01:35AM | |||||
207997 | 207997 | 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-24 | 01:35AM | |||||
207998 | 207998 | 96.0 | BANCROFT MS | OPEN | green | 3 | 0 | Past 7 days (11/17/2022 - 11/23/2022) | 5 | 4 | 0.76 | 0.76 | Hollywood CoS | 7 | 0.09 | -0.09 | 14 | 505 | 273 | 0.04 | -0.1 | 2022-11-24 | 01:35AM | |||||
207999 | 207999 | 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-24 | 01:35AM | |||||
208000 | 208000 | 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-24 | 01:35AM | |||||
208001 | 208001 | 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-24 | 01:35AM |
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 );