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.
5 rows where transmission = 12 sorted by lac_rate
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102659 | 102659 | 58.0 | ALEXANDRIA AVE EL | OPEN | yellow | 26 | 12 | Past 7 days (1/22/2022 - 1/28/2022) | 429 | 26 | 6.06 | -4.00 | Downtown CoS | 7,059 | 312 | 4.42 | -3.58 | 352,332 | 15K | 4.23 | -4.26 | 2022-01-28 | 10:00PM | |||||
103975 | 103975 | 58.0 | ALEXANDRIA AVE EL | OPEN | yellow | 26 | 12 | Past 7 days (1/23/2022 - 1/29/2022) | 430 | 27 | 6.28 | -3.98 | Downtown CoS | 7,007 | 332 | 4.74 | -3.20 | 348,629 | 16K | 4.69 | -3.49 | 2022-01-29 | 10:00PM | |||||
140804 | 140804 | 265.0 | EAGLE ROCK HS | OPEN | green | 14 | 12 | Past 7 days (3/27/2022 - 4/2/2022) | 1,528 | 14 | 0.92 | 0.58 | Eagle Rock/HighlandPark CoS | 7,145 | 19 | 0.27 | 0.13 | 307,287 | 551 | 0.18 | 0.0 | 2022-04-02 | 10:00PM | |||||
141693 | 141693 | 265.0 | EAGLE ROCK HS | OPEN | green | 14 | 12 | Past 7 days (3/28/2022 - 4/3/2022) | 1,525 | 13 | 0.85 | 0.44 | Eagle Rock/HighlandPark CoS | 7,142 | 19 | 0.27 | 0.11 | 307,223 | 547 | 0.18 | 0.0 | 2022-04-03 | 10:00PM | |||||
162222 | 162222 | 370.0 | HAMILTON SH | OPEN | green | 41 | 12 | Past 7 days (4/29/2022 - 5/5/2022) | 2,068 | 46 | 2.22 | 1.29 | Hamilton CoS | 7,224 | 89 | 1.23 | 0.21 | 442,412 | 2174 | 0.49 | -0.01 | 2022-05-06 | 01:28AM |
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 );