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.
15 rows where pos = 144
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88798 | 88798 | 650.0 | POLYTECHNIC SH | OPEN | green | 124 | 0 | Past 7 days (1/1/2022 - 1/7/2022) | 1,792 | 144 | 8.04 | -54.46 | Sun Valley CoS | 10,405 | 862 | 8.28 | -63.51 | 331,213 | 26K | 7.99 | -60.73 | 2022-01-07 | 10:00PM | |||||
89672 | 89672 | 637.0 | PEARY MS | OPEN | green | 137 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 1,010 | 144 | 14.26 | -35.74 | Gardena CoS | 7,106 | 955 | 13.44 | -44.89 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
90359 | 90359 | 437.0 | KING-DREW SH MD/S MG | OPEN | green | 129 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 1,002 | 144 | 14.37 | -52.30 | Rivera CoS | 10,998 | 1834 | 16.68 | -58.32 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
91486 | 91486 | 677.0 | RFK UCLA COMM SCH | OPEN | green | 132 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 974 | 144 | 14.78 | -10.22 | Kreatwn/PcoUnion CoS | 9,989 | 1518 | 15.20 | -8.03 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91632 | 91632 | 823.0 | VIRGIL MS | OPEN | green | 137 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 1,134 | 144 | 12.70 | -7.30 | Downtown CoS | 8,889 | 1098 | 12.35 | -3.17 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
92289 | 92289 | 593.0 | NOBLE AVE EL | OPEN | green | 136 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 697 | 144 | 20.66 | 4.91 | Panorama City CoS | 6,650 | 1134 | 17.05 | 2.20 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
94216 | 94216 | 746.0 | SOUTH GATE MS | OPEN | green | 187 | 0 | Past 7 days (1/8/2022 - 1/14/2022) | 1,677 | 144 | 8.59 | -3.60 | South Gate CoS | 17,578 | 1825 | 10.38 | -5.11 | 537,667 | 54K | 10.12 | -5.9 | 2022-01-14 | 10:00PM | |||||
94831 | 94831 | 474.0 | LINCOLN SH | OPEN | green | 189 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 1,162 | 144 | 12.39 | -3.04 | Lincoln Heights/El SerenoCoS | 13,124 | 1440 | 10.97 | -4.72 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95231 | 95231 | 874.0 | WISDOM EL | OPEN | green | 177 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 786 | 144 | 18.32 | 0.37 | Rivera CoS | 14,120 | 2051 | 14.53 | -3.55 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95326 | 95326 | 82.0 | ASCOT AVE EL | OPEN | green | 174 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 794 | 144 | 18.14 | -2.32 | Historic Central AvenueCoS | 10,606 | 1514 | 14.27 | -3.48 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-16 | 10:00PM | |||||
96395 | 96395 | 264.0 | EAGLE ROCK HS | OPEN | green | 148 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 1,944 | 144 | 7.41 | -4.80 | Eagle Rock/Highland ParkCoS | 9,176 | 706 | 7.69 | -5.90 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
96396 | 96396 | 265.0 | EAGLE TREE CONTN HS | OPEN | green | 148 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 1,944 | 144 | 7.41 | -10.00 | Eagle Rock/Highland ParkCoS | 9,989 | 706 | 7.69 | -9.37 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
96879 | 96879 | 748.0 | SOUTH PARK EL | OPEN | green | 141 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 831 | 144 | 17.33 | -0.50 | Fremont CoS | 11,401 | 1699 | 14.90 | -4.95 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
97282 | 97282 | 264.0 | EAGLE ROCK HS | OPEN | green | 148 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 1,944 | 144 | 7.41 | -4.80 | Eagle Rock/HighlandPark CoS | 9,176 | 706 | 7.69 | -5.90 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-18 | 10:00PM | |||||
169172 | 169172 | 216.0 | COLISEUM ST EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | COLISEUM ST EL | 144 | 1 | 0.69 | South Mid-City CoS | 2,567 | 38 | 1.48 | 0.30 | 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 );