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 = 9 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98822 | 98822 | 30.0 | 52ND ST EL | OPEN | yellow | 68 | 9 | Past 7 days (1/13/2022 - 1/19/2022) | 540 | 28 | 5.19 | -10.91 | South Mid-City CoS | 5,738 | 606 | 10.56 | -6.02 | 426,155 | 34K | 8.07 | -6.53 | 2022-01-20 | 10:00PM | |||||
104769 | 104769 | 58.0 | ALEXANDRIA AVE EL | OPEN | yellow | 19 | 9 | Past 7 days (1/25/2022 - 1/31/2022) | 27 | 3 | 11.11 | 2.72 | Downtown CoS | 5,573 | 239 | 4.29 | -3.42 | 276,745 | 13K | 4.6 | -3.01 | 2022-01-30 | 10:00PM | |||||
143469 | 143469 | 265.0 | EAGLE ROCK HS | OPEN | yellow | 20 | 9 | Past 7 days (3/31/2022 - 4/6/2022) | 2,377 | 12 | 0.50 | -1.13 | Eagle Rock/HighlandPark CoS | 6,932 | 24 | 0.35 | 0.12 | 343,519 | 581 | 0.17 | -0.02 | 2022-04-06 | 10:00PM | |||||
144357 | 144357 | 265.0 | EAGLE ROCK HS | OPEN | yellow | 21 | 9 | Past 7 days (4/1/2022 - 4/7/2022) | 1,585 | 11 | 0.69 | -0.23 | Eagle Rock/HighlandPark CoS | 7,124 | 25 | 0.35 | 0.10 | 343,631 | 606 | 0.18 | -0.01 | 2022-04-07 | 10:00PM | |||||
181334 | 181334 | 572.0 | MOSK EL | OPEN | green | 40 | 9 | Past 7 days (8/19/2022 - 8/25/2022) | 44 | 38 | 6.3 | 4.81 | Cleveland CoS | 141 | 1.06 | 0.54 | 178 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM |
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 );