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.
898 rows where "date" is on date 2022-10-24 sorted by cos
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192234 | 192234 | 596.0 | NOBEL CMS | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 10 | 3 | 0.13 | 0.09 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192260 | 192260 | 622.0 | OWENSMOUTH HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192296 | 192296 | 658.0 | PORTER RANCH SCHOOL | OPEN | green | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 3 | 0.2 | 0.07 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192403 | 192403 | 765.0 | STONEY POINT HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192409 | 192409 | 771.0 | SUPERIOR ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 4 | 0 | 0.0 | -0.20 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192427 | 192427 | 789.0 | TOPEKA DR CAS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.16 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191653 | 191653 | 15.0 | 232ND PL EL | OPEN | green | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 2 | 0.43 | 0.22 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191702 | 191702 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191710 | 191710 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191755 | 191755 | 117.0 | BONITA ST EL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.43 | 0.43 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191769 | 191769 | 131.0 | BROADACRES AV EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191803 | 191803 | 165.0 | CARNEGIE MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191804 | 191804 | 166.0 | CAROLDALE LC | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 2 | 0.26 | 0.13 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191806 | 191806 | 168.0 | CARSON ACAD ED & EMP | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.18 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191807 | 191807 | 169.0 | CARSON ACAD MED ARTS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191808 | 191808 | 170.0 | CARSON SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.13 | 0.00 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191809 | 191809 | 171.0 | CARSON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 0 | 0.0 | -0.28 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191818 | 191818 | 180.0 | CATSKILL AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191878 | 191878 | 240.0 | CURTISS MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191889 | 191889 | 251.0 | DEL AMO EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191896 | 191896 | 258.0 | DOLORES ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191897 | 191897 | 259.0 | DOLORES ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 1 | 0.18 | 0.18 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191898 | 191898 | 260.0 | DOMINGUEZ EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191907 | 191907 | 269.0 | EAGLE TREE CONTN HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192103 | 192103 | 465.0 | LEAPWOOD EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192308 | 192308 | 670.0 | RANCHO DOMNGZ PREP | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192433 | 192433 | 795.0 | TOWNE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192505 | 192505 | 867.0 | WHITE MS | OPEN | green | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 12 | 2 | 0.13 | -0.52 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191704 | 191704 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191754 | 191754 | 116.0 | BLYTHE ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191790 | 191790 | 152.0 | CALAHAN ST EL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 3 | 0.55 | 0.18 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191797 | 191797 | 159.0 | CANTARA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191846 | 191846 | 208.0 | CLEVELAND CHS | OPEN | green | 9 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 9 | 8 | 0.26 | 0.16 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191847 | 191847 | 209.0 | CLEVELAND EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191848 | 191848 | 210.0 | CLEVELAND INFANT CTR | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191963 | 191963 | 325.0 | FULLBRIGHT AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192117 | 192117 | 479.0 | LIMERICK AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192132 | 192132 | 494.0 | LORNE ST EL | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 3 | 0.74 | 0.49 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192182 | 192182 | 544.0 | MELVIN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192196 | 192196 | 558.0 | MILLER CTC | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 29 | 3 | 1.17 | 0.78 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192210 | 192210 | 572.0 | MOSK EL | OPEN | yellow | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192220 | 192220 | 582.0 | NAPA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192243 | 192243 | 605.0 | NORTHRIDGE EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192244 | 192244 | 606.0 | NORTHRIDGE MS | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.12 | 0.12 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192279 | 192279 | 641.0 | PEARL SH JRNLS/CMM MG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192394 | 192394 | 756.0 | STAGG ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 1 | 0.18 | 0.18 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192407 | 192407 | 769.0 | SUNNY BRAE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192410 | 192410 | 772.0 | SUTTER MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192522 | 192522 | 884.0 | WINNETKA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192523 | 192523 | 885.0 | WISDOM EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | 0.24 | Cleveland CoS | 11 | 0.16 | 0.07 | 19 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192526 | 192526 | 888.0 | WOODEN HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191696 | 191696 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191697 | 191697 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.17 | 0.17 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191746 | 191746 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191813 | 191813 | 175.0 | CASTELAR ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191814 | 191814 | 176.0 | CASTELAR ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191817 | 191817 | 179.0 | CASTRO MS | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.27 | 0.27 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191824 | 191824 | 186.0 | CDS TRI-C | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191826 | 191826 | 188.0 | CENTRAL HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191869 | 191869 | 231.0 | CORTINES SCH OF VAPA | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191886 | 191886 | 248.0 | DBM | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 0 | 0.0 | -0.11 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191890 | 191890 | 252.0 | DEL OLMO EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.17 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192104 | 192104 | 466.0 | LEE EL MED HLTH MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192124 | 192124 | 486.0 | LOGAN ACADEMY | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.23 | 0.23 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192125 | 192125 | 487.0 | LOGAN ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192230 | 192230 | 592.0 | NEWMARK HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192287 | 192287 | 649.0 | PLASENCIA EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192341 | 192341 | 703.0 | ROSEMONT AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192342 | 192342 | 704.0 | ROSEMONT AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192345 | 192345 | 707.0 | ROYBAL LC | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.08 | -0.08 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192472 | 192472 | 834.0 | VIRGIL MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.09 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191694 | 191694 | 56.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191711 | 191711 | 73.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.61 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191721 | 191721 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191777 | 191777 | 139.0 | BUCHANAN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191780 | 191780 | 142.0 | BURBANK MS A/T/C MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191784 | 191784 | 146.0 | BUSHNELL WAY EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.44 | 0.44 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191880 | 191880 | 242.0 | DAHLIA HTS EL | OPEN | yellow | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 19 | 2 | 0.48 | 0.24 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191891 | 191891 | 253.0 | DELEVAN DRIVE EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 1 | 0.19 | 0.00 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191905 | 191905 | 267.0 | EAGLE ROCK EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191906 | 191906 | 268.0 | EAGLE ROCK HS | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 4 | 2 | 0.09 | 0.00 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191958 | 191958 | 320.0 | FRANKLIN HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.06 | 0.00 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191974 | 191974 | 336.0 | GARVANZA EL T/L MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192032 | 192032 | 394.0 | HIGHLAND PARK HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192185 | 192185 | 547.0 | MERIDIAN EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192205 | 192205 | 567.0 | MONTE VISTA EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192206 | 192206 | 568.0 | MONTE VISTA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192214 | 192214 | 576.0 | MT WASHINGTON EL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.42 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192324 | 192324 | 686.0 | RIORDAN PC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192332 | 192332 | 694.0 | ROCKDALE VAPA MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192359 | 192359 | 721.0 | SAN PASCUAL STEAM MG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192423 | 192423 | 785.0 | TOLAND WAY EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.36 | 0.36 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
192533 | 192533 | 895.0 | YORKDALE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191665 | 191665 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191666 | 191666 | 28.0 | 4TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 2 | 0.58 | 0.58 | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191667 | 191667 | 29.0 | 4TH ST PC | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191701 | 191701 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191712 | 191712 | 74.0 | ANTON EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191713 | 191713 | 75.0 | ANTON EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.18 | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191747 | 191747 | 109.0 | BELVEDERE EL | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.29 | 0.00 | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM |
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 );