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 = 224
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
92011 | 92011 | 315.0 | FRANKLIN HS | OPEN | green | 24 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 1,261 | 224 | 7.16 | -0.42 | Eagle Rock/Highland ParkCoS | 10,616 | 1248 | 11.76 | -2.97 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
169034 | 169034 | 78.0 | ARLINGTON HTS EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ARLINGTON HTS EL | 224 | 1 | 0.45 | LA Mid-City CoS | 4,765 | 73 | 1.53 | -0.17 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169155 | 169155 | 199.0 | CHEREMOYA AVE EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CHEREMOYA AVE EL | 224 | 3 | 1.34 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 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 );