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.
3 rows where pos = 299
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90482 | 90482 | 560.0 | MONROE SH | OPEN | green | 275 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 1,951 | 299 | 15.33 | -29.11 | Monroe CoS | 10,903 | 1773 | 16.26 | -44.41 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
169058 | 169058 | 102.0 | BEETHOVEN ST EL | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BEETHOVEN ST EL | 299 | 5 | 1.67 | Venice CoS | 3,823 | 57 | 1.49 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169307 | 169307 | 351.0 | GRANADA EL | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GRANADA EL | 299 | 5 | 1.67 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM |
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 );