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.
11 rows where "date" is on date 2022-01-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102332 | 102332 | 877.0 | WOODCREST EL | OPEN | green | 46 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 490 | 67 | 13.67 | 0.90 | H.E.E.T. (W) CoS | 3,253 | 330 | 10.14 | -3.86 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102333 | 102333 | 878.0 | WOODEN HS | OPEN | green | 6 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 41 | 5 | 12.20 | 1.67 | Cleveland CoS | 9,584 | 645 | 6.73 | -2.13 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102334 | 102334 | 879.0 | WOODLAKE ECC | OPEN | green | 25 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 935 | 31 | 3.32 | -3.02 | Taft CoS | 11,931 | 454 | 3.81 | -3.57 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102335 | 102335 | 880.0 | WOODLAND HILLS ACAD | OPEN | green | 12 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 500 | 11 | 2.20 | -3.63 | Taft CoS | 11,931 | 454 | 3.81 | -3.57 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102336 | 102336 | 881.0 | WOODLAND HILLS CES | OPEN | green | 8 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 572 | 6 | 1.05 | -2.33 | Taft CoS | 11,931 | 454 | 3.81 | -3.57 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102337 | 102337 | 882.0 | WOODLAWN AVE EL | OPEN | green | 29 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 478 | 35 | 7.32 | -2.18 | Bell/Cudahy/MaywoodCoS | 12,071 | 818 | 6.78 | -3.18 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102338 | 102338 | 883.0 | WRIGHT ENG DES MAG | OPEN | green | 19 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 377 | 22 | 5.84 | -3.57 | Westchester CoS | 3,108 | 147 | 4.73 | -2.33 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102339 | 102339 | 884.0 | YES ACADEMY | OPEN | green | 30 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 75 | 7 | 9.33 | -0.73 | H.E.E.T. (C/D) CoS | 2,752 | 220 | 7.99 | -3.12 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102340 | 102340 | 885.0 | YORKDALE EL | OPEN | green | 9 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 191 | 14 | 7.33 | -7.67 | Eagle Rock/HighlandPark CoS | 10,820 | 506 | 4.68 | -3.23 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102341 | 102341 | 886.0 | YOUNG HS | OPEN | yellow | 1 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 40 | 2 | 5.00 | -18.33 | H.E.E.T. (C/D) CoS | 2,752 | 220 | 7.99 | -3.12 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM | |||||
102342 | 102342 | 887.0 | YTH OPP UNLTD ALT HS | OPEN | green | 4 | 0 | Past 7 days (1/19/2022 - 1/25/2022) | 44 | 4 | 9.09 | 1.95 | Fremont CoS | 11,311 | 1111 | 9.82 | -5.14 | 415,333 | 27K | 6.48 | -3.59 | 2022-01-25 | 10:00PM |
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 );