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-22 sorted by cos descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189941 | 189941 | 99.0 | BANNING SH | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 1 | 0.04 | -0.03 | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189970 | 189970 | 128.0 | BRIDGES SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189972 | 189972 | 130.0 | BROAD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190091 | 190091 | 249.0 | DE LA TORRE JR EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190165 | 190165 | 323.0 | FRIES AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190209 | 190209 | 367.0 | GULF AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190227 | 190227 | 385.0 | HAWAIIAN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 0 | 0.0 | 0.00 | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190228 | 190228 | 386.0 | HAWAIIAN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190266 | 190266 | 424.0 | ISAACS AVALON HS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190680 | 190680 | 838.0 | VLADOVIC HARBOR TPA | OPEN | green | 3 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 21 | 3 | 0.61 | 0.21 | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190716 | 190716 | 874.0 | WILMINGTON EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190717 | 190717 | 875.0 | WILMINGTON PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190718 | 190718 | 876.0 | WILMINGTON STEAM MAG | OPEN | green | 3 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 4 | 3 | 0.22 | 0.22 | Wilmington CoS | 7 | 0.07 | 0.01 | 28 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190075 | 190075 | 233.0 | COWAN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190269 | 190269 | 427.0 | JOHNSON STEM ACADEMY | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190278 | 190278 | 436.0 | KENTWOOD EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190279 | 190279 | 437.0 | KENTWOOD EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190343 | 190343 | 501.0 | LOYOLA VILLG EL F/PAM | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190458 | 190458 | 616.0 | OPEN CHARTER MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190481 | 190481 | 639.0 | PASEO DEL REY ACAD | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190493 | 190493 | 651.0 | PLAYA VISTA EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 5 | 0 | 0.0 | -0.39 | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190696 | 190696 | 854.0 | WESM HLTH/SPORTS MED | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.13 | 0.13 | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190705 | 190705 | 863.0 | WESTPORT HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190725 | 190725 | 883.0 | WINDSOR HILLS EL MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190735 | 190735 | 893.0 | WRIGHT ENG DES MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Westchester CoS | 1 | 0.02 | -0.03 | 6 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189968 | 189968 | 126.0 | BRENTWOOD EL SCI MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189977 | 189977 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190003 | 190003 | 161.0 | CANYON CEL | OPEN | green | 3 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 4 | 3 | 0.7 | 0.23 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190066 | 190066 | 224.0 | COMMUNITY EL MAG CS | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 26 | 3 | 0.62 | 0.62 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190131 | 190131 | 289.0 | EMERSON CC | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 2 | 0.36 | 0.36 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190149 | 190149 | 307.0 | FAIRBURN AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 1 | 0.21 | 0.21 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190277 | 190277 | 435.0 | KENTER CANYON EC | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 15 | 2 | 0.39 | 0.00 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190370 | 190370 | 528.0 | MARQUEZ CHARTER | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190469 | 190469 | 627.0 | PALISADES CEL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 6 | 0 | 0.0 | -0.64 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190517 | 190517 | 675.0 | REVERE CMS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 3 | 1 | 0.05 | -0.05 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190524 | 190524 | 682.0 | RICHLAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190544 | 190544 | 702.0 | ROSCOMARE RD EL | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 2 | 0.43 | 0.00 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190603 | 190603 | 761.0 | STERRY EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190630 | 190630 | 788.0 | TOPANGA EL CS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.38 | 0.38 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190643 | 190643 | 801.0 | UNIVERSITY HS CHARTER | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190688 | 190688 | 846.0 | WARNER AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.16 | 0.16 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190692 | 190692 | 850.0 | WEBSTER MS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.2 | 0.20 | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190707 | 190707 | 865.0 | WESTWOOD CEL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 17 | 0.16 | 0.05 | 63 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189947 | 189947 | 105.0 | BEETHOVEN ST EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.28 | -0.28 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189962 | 189962 | 120.0 | BRADDOCK DR EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 6 | 0 | 0.0 | -0.77 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189976 | 189976 | 134.0 | BROADWAY EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.18 | 0.18 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190057 | 190057 | 215.0 | COEUR D ALENE AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 6 | 3 | 0.65 | 0.21 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190197 | 190197 | 355.0 | GRAND VW BL EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190362 | 190362 | 520.0 | MAR VISTA EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190364 | 190364 | 522.0 | MARINA DEL REY MS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190365 | 190365 | 523.0 | MARINA EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190367 | 190367 | 525.0 | MARK TWAIN MS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.1 | 0.00 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190383 | 190383 | 541.0 | MCBRIDE SP ED CTR | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190486 | 190486 | 644.0 | PHOENIX HS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190492 | 190492 | 650.0 | PLAYA DEL REY EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190583 | 190583 | 741.0 | SHORT AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 0 | 0.0 | -0.46 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190606 | 190606 | 764.0 | STONER AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.3 | 0.30 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190664 | 190664 | 822.0 | VENICE SH | OPEN | green | 3 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 3 | 3 | 0.13 | 0.09 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190684 | 190684 | 842.0 | WALGROVE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 0 | 0.0 | 0.00 | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190703 | 190703 | 861.0 | WESTMINSTER AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190704 | 190704 | 862.0 | WESTMINSTER MTES MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190706 | 190706 | 864.0 | WESTSIDE GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 10 | 0.11 | -0.05 | 21 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189924 | 189924 | 82.0 | ARMSTRONG MS | OPEN | green | 5 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 6 | 4 | 0.27 | -0.07 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190005 | 190005 | 163.0 | CARDENAS EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190027 | 190027 | 185.0 | CDS LONDON | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190032 | 190032 | 190.0 | CHANDLER EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 7 | 0 | 0.0 | -0.23 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190059 | 190059 | 217.0 | COLDWATER CYN EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190063 | 190063 | 221.0 | COLUMBUS AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190098 | 190098 | 256.0 | DIXIE CYN CC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190134 | 190134 | 292.0 | ERWIN EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190200 | 190200 | 358.0 | GRANT SH | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 1 | 0.05 | -0.10 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190231 | 190231 | 389.0 | HAZELTINE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190280 | 190280 | 438.0 | KESTER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 4 | 0 | 0.0 | -0.11 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190287 | 190287 | 445.0 | KITTRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190333 | 190333 | 491.0 | LONDON HS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190349 | 190349 | 507.0 | MADISON MS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.07 | -0.07 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190406 | 190406 | 564.0 | MONLUX EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 1 | 0.14 | 0.14 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190534 | 190534 | 692.0 | RIVERSIDE DR CS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190538 | 190538 | 696.0 | ROGERS HS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190581 | 190581 | 739.0 | SHERMAN OAKS EL CS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 0 | 0.0 | -0.18 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190619 | 190619 | 777.0 | SYLVAN PARK EEC | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190620 | 190620 | 778.0 | SYLVAN PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190657 | 190657 | 815.0 | VAN NUYS EL | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 1 | 0.19 | 0.00 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190658 | 190658 | 816.0 | VAN NUYS MS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 29 | 1 | 0.1 | 0.10 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190659 | 190659 | 817.0 | VAN NUYS SH | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 1 | 0 | 0.0 | -0.04 | Van Nuys/Valley Glen CoS | 9 | 0.05 | -0.04 | 54 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189993 | 189993 | 151.0 | CALABASH CA | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
189995 | 189995 | 153.0 | CALVERT CES | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190133 | 190133 | 291.0 | ENCINO CEL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190212 | 190212 | 370.0 | HALE CA | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 2 | 1 | 0.05 | 0.00 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190230 | 190230 | 388.0 | HAYNES CES | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190273 | 190273 | 431.0 | JUSTICE ST ACAD CHTR | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 16 | 0 | 0.0 | 0.00 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190296 | 190296 | 454.0 | LANAI RD EL | OPEN | green | 4 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 5 | 3 | 0.53 | 0.35 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190326 | 190326 | 484.0 | LOCKHURST DR CEL | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190429 | 190429 | 587.0 | NESTLE AVE CHARTER | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190498 | 190498 | 656.0 | POMELO COMMUNITY CS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190501 | 190501 | 659.0 | PORTOLA CM | OPEN | green | 3 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 3 | 3 | 0.19 | 0.13 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190576 | 190576 | 734.0 | SERRANIA AVE CES | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190621 | 190621 | 779.0 | TAFT CHS | OPEN | green | 1 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 3 | 1 | 0.04 | 0.00 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190626 | 190626 | 784.0 | THOREAU HS | OPEN | green | 0 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM | |||||
190695 | 190695 | 853.0 | WELBY WAY CEL | OPEN | green | 2 | 0 | Past 7 days (10/15/2022 - 10/21/2022) | 3 | 2 | 0.24 | 0.24 | Taft CoS | 14 | 0.1 | 0.02 | 147 | 1,559 | 450 | 0.07 | -0.01 | 2022-10-22 | 01:32AM |
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 );