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.
6,237 rows where lac_rate = "15.24" sorted by community
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15275 | 15275 | BIRMINGHAM CHS | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15366 | 15366 | CITY OF ANGELS | OPEN | green | 4 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15394 | 15394 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15442 | 15442 | ELA OCC CTR | OPEN | green | 1 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15460 | 15460 | EVANS CAS | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15481 | 15481 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15514 | 15514 | GRANADA HILLS CHT | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15537 | 15537 | HARBOR OCC CTR | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15657 | 15657 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15668 | 15668 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15669 | 15669 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15670 | 15670 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15749 | 15749 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15762 | 15762 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15787 | 15787 | PALISADES CHS | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15833 | 15833 | REGIONAL SH IDTE MAG | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15885 | 15885 | SANTA MONICA BLVD CO | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15905 | 15905 | SLAWSON OCC CTR | OPEN | green | 2 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
15978 | 15978 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16004 | 16004 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16013 | 16013 | WEST VALLEY OCC CTR | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16035 | 16035 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | 2021-09-13 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16166 | 16166 | BIRMINGHAM CHS | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16257 | 16257 | CITY OF ANGELS | OPEN | green | 3 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16285 | 16285 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16333 | 16333 | ELA OCC CTR | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16351 | 16351 | EVANS CAS | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16372 | 16372 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16405 | 16405 | GRANADA HILLS CHT | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16428 | 16428 | HARBOR OCC CTR | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16548 | 16548 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16559 | 16559 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16560 | 16560 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16561 | 16561 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16640 | 16640 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16653 | 16653 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16678 | 16678 | PALISADES CHS | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16724 | 16724 | REGIONAL SH IDTE MAG | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16776 | 16776 | SANTA MONICA BLVD CO | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16796 | 16796 | SLAWSON OCC CTR | OPEN | green | 2 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16869 | 16869 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16895 | 16895 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16904 | 16904 | WEST VALLEY OCC CTR | OPEN | green | 1 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
16926 | 16926 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | 2021-09-14 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17057 | 17057 | BIRMINGHAM CHS | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17148 | 17148 | CITY OF ANGELS | OPEN | green | 3 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17176 | 17176 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17224 | 17224 | ELA OCC CTR | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17242 | 17242 | EVANS CAS | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17263 | 17263 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17296 | 17296 | GRANADA HILLS CHT | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17319 | 17319 | HARBOR OCC CTR | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17439 | 17439 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17450 | 17450 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17451 | 17451 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17452 | 17452 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17531 | 17531 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17544 | 17544 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17569 | 17569 | PALISADES CHS | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17615 | 17615 | REGIONAL SH IDTE MAG | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17667 | 17667 | SANTA MONICA BLVD CO | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17687 | 17687 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17760 | 17760 | VENICE SKILLS CENTER | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17786 | 17786 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17795 | 17795 | WEST VALLEY OCC CTR | OPEN | green | 2 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17817 | 17817 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | 2021-09-15 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
17948 | 17948 | BIRMINGHAM CHS | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18039 | 18039 | CITY OF ANGELS | OPEN | green | 3 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18067 | 18067 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18115 | 18115 | ELA OCC CTR | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18133 | 18133 | EVANS CAS | OPEN | green | 1 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18154 | 18154 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18187 | 18187 | GRANADA HILLS CHT | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18210 | 18210 | HARBOR OCC CTR | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18330 | 18330 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18341 | 18341 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18342 | 18342 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18343 | 18343 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18422 | 18422 | NEW ACAD CANOGA PARK | OPEN | green | 1 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18435 | 18435 | NORTH VALLEY OCC CTR | OPEN | green | 1 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18460 | 18460 | PALISADES CHS | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18506 | 18506 | REGIONAL SH IDTE MAG | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18558 | 18558 | SANTA MONICA BLVD CO | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18578 | 18578 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18651 | 18651 | VENICE SKILLS CENTER | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18677 | 18677 | WATERS EMP PREP CTR | OPEN | green | 1 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18686 | 18686 | WEST VALLEY OCC CTR | OPEN | green | 2 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18708 | 18708 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | 2021-09-16 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18839 | 18839 | BIRMINGHAM CHS | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18930 | 18930 | CITY OF ANGELS | OPEN | green | 3 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
18958 | 18958 | CRENSHAW ARTS TECH | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19006 | 19006 | ELA OCC CTR | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19024 | 19024 | EVANS CAS | OPEN | green | 1 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19045 | 19045 | FRIEDMAN OCC CTR | OPEN | green | 3 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19078 | 19078 | GRANADA HILLS CHT | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19101 | 19101 | HARBOR OCC CTR | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19221 | 19221 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19232 | 19232 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19233 | 19233 | MAGNOLIA SCI ACAD #4 | OPEN | green | 1 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community | |||||||||||||||
19234 | 19234 | MAGNOLIA SCI-BELL@SR | OPEN | green | 0 | 0 | 2021-09-17 | 10:00PM | 0.0 | 0.0 | 15.24 | Community of Schools | Community |
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 );