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.
890 rows where "date" is on date 2022-06-24 sorted by cos_pos_rate
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
171650 | 171650 | 26.0 | 49TH ST EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 10.0 | 0 | 0.00 | -0.17 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171693 | 171693 | 68.0 | ANGELOU COMMUNITY SH | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 101.0 | 2 | 0.17 | 0.08 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171707 | 171707 | 83.0 | ASCOT AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 3.0 | 1 | 0.14 | -0.28 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171712 | 171712 | 88.0 | AURORA EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 6.0 | 0 | 0.00 | 0.00 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171755 | 171755 | 131.0 | BROADOUS EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 65.0 | 1 | 1.10 | 1.10 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171756 | 171756 | 132.0 | BROADOUS EL | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 2 | 0.44 | 0.44 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171797 | 171797 | 173.0 | CARVER MS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 14.0 | 0 | 0.00 | -0.26 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171821 | 171821 | 197.0 | CHAVEZ LA ARTES MAG | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171822 | 171822 | 198.0 | CHAVEZ LA ASE | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171823 | 171823 | 199.0 | CHAVEZ LA SJ HUM AC | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171824 | 171824 | 200.0 | CHAVEZ LA TECH PREP | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 37.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171888 | 171888 | 264.0 | DYER ST EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171901 | 171901 | 277.0 | EL DORADO AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 69.0 | 0 | 0.00 | -0.18 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171921 | 171921 | 297.0 | ESTRELLA EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 81.0 | 2 | 1.38 | 0.00 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171922 | 171922 | 298.0 | ESTRELLA EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 7.0 | 1 | 0.20 | 0.20 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171927 | 171927 | 303.0 | EVERGREEN HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171986 | 171986 | 362.0 | GRIDLEY ST EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 64.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171991 | 171991 | 367.0 | HADDON AVE EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 101.0 | 1 | 0.74 | 0.74 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171992 | 171992 | 368.0 | HADDON AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 10.0 | 0 | 0.00 | -0.39 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172001 | 172001 | 377.0 | HARDING ST EL | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 6.0 | 2 | 0.28 | -0.14 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172002 | 172002 | 378.0 | HARMONY EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 8.0 | 0 | 0.00 | -0.16 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172015 | 172015 | 391.0 | HERRICK AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | -0.70 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172028 | 172028 | 404.0 | HOOPER AVE EEC | OPEN | green | 3 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 62.0 | 4 | 3.05 | 3.05 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172029 | 172029 | 405.0 | HOOPER AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 23.0 | 2 | 0.16 | 0.00 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172030 | 172030 | 406.0 | HOOPER AVE PC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 1 | 0.52 | 0.52 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172034 | 172034 | 410.0 | HUBBARD ST EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172049 | 172049 | 425.0 | JEFFERSON SH | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 152.0 | 1 | 0.10 | 0.00 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172118 | 172118 | 494.0 | LOS ANGELES ACAD MS | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 28.0 | 1 | 0.09 | -0.09 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172136 | 172136 | 512.0 | MAIN ST EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 41.0 | 1 | 0.11 | 0.11 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172185 | 172185 | 561.0 | MISSION HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172194 | 172194 | 570.0 | MORNINGSIDE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172208 | 172208 | 584.0 | NAVA COLLEGE PREP | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 8.0 | 0 | 0.00 | -0.21 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172209 | 172209 | 585.0 | NAVA LEARNING ACADEMY | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 1 | 0.14 | -0.28 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172212 | 172212 | 588.0 | NEVIN AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172232 | 172232 | 614.0 | O'MELVENY EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | -0.22 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172237 | 172237 | 612.0 | OLIVE VISTA MS | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 9.0 | 1 | 0.09 | -0.10 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172243 | 172243 | 619.0 | OSCEOLA ST EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172248 | 172248 | 624.0 | PACOIMA EEC | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 5.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172306 | 172306 | 682.0 | RIDE EL SMART ACAD | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | 0.00 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172316 | 172316 | 692.0 | ROBERTI EEC | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 62.0 | 2 | 2.50 | 1.25 | Historic Central Avenue CoS | 19 | 0.16 | -0.01 | 615.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172336 | 172336 | 712.0 | SAN FERNANDO EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 103.0 | 1 | 0.78 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172337 | 172337 | 713.0 | SAN FERNANDO EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 42.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172338 | 172338 | 714.0 | SAN FERNANDO MS | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 39.0 | 2 | 0.29 | 0.29 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172339 | 172339 | 715.0 | SAN FERNANDO MS IAM | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172340 | 172340 | 716.0 | SAN FERNANDO SH | OPEN | green | 3 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 22.0 | 5 | 0.22 | 0.13 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172395 | 172395 | 771.0 | SYLMAR ACAD BH/E MAG | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172396 | 172396 | 772.0 | SYLMAR CHS | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 132.0 | 1 | 0.06 | 0.00 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172397 | 172397 | 773.0 | SYLMAR EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 13.0 | 1 | 0.22 | 0.22 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172398 | 172398 | 774.0 | SYLMAR LDSHP ACAD | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | -0.12 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172404 | 172404 | 780.0 | TELFAIR AVE EEC | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172405 | 172405 | 781.0 | TELFAIR AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | -0.16 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172436 | 172436 | 812.0 | VAUGHN EEC | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 81.0 | 2 | 1.80 | 1.80 | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172452 | 172452 | 828.0 | VISTA DEL VALLE ACAD | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.01 | 819.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171699 | 171699 | 75.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 11.0 | 0 | 0.00 | 0.00 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171705 | 171705 | 81.0 | ARMSTRONG MS | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 3.0 | 0 | 0.00 | -0.14 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171746 | 171746 | 122.0 | BRAINARD EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 7.0 | 0 | 0.00 | -0.70 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171786 | 171786 | 162.0 | CARDENAS EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 5.0 | 0 | 0.00 | 0.00 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171807 | 171807 | 183.0 | CDS JOHNSTON | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171808 | 171808 | 184.0 | CDS LONDON | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171813 | 171813 | 189.0 | CHANDLER EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 0 | 0.00 | 0.00 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171840 | 171840 | 216.0 | COLDWATER CYN EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | 0.00 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171844 | 171844 | 220.0 | COLUMBUS AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 7.0 | 1 | 0.17 | 0.17 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171879 | 171879 | 255.0 | DIXIE CYN CC | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 4.0 | 0 | 0.00 | -0.15 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171915 | 171915 | 291.0 | ERWIN EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 34.0 | 0 | 0.00 | -0.11 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171919 | 171919 | 295.0 | ESHELMAN AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 3.0 | 1 | 0.22 | 0.22 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171936 | 171936 | 312.0 | FLEMING MS | OPEN | green | 3 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 16.0 | 5 | 0.44 | 0.17 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171981 | 171981 | 357.0 | GRANT SH | OPEN | green | 3 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 8.0 | 3 | 0.14 | 0.09 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
171994 | 171994 | 370.0 | HALLDALE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
171999 | 171999 | 375.0 | HARBOR CITY EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 1 | 0.23 | 0.23 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172012 | 172012 | 388.0 | HAZELTINE AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 64.0 | 1 | 0.10 | 0.10 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172061 | 172061 | 437.0 | KESTER AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 5.0 | 1 | 0.12 | -0.11 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172068 | 172068 | 444.0 | KITTRIDGE ST EL | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 13.0 | 3 | 0.29 | 0.10 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172113 | 172113 | 489.0 | LOMITA EL M/S/T MAG | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172114 | 172114 | 490.0 | LONDON HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172130 | 172130 | 506.0 | MADISON MS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | 0.00 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172172 | 172172 | 548.0 | MEYLER ST EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 26.0 | 2 | 0.24 | 0.00 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172187 | 172187 | 563.0 | MONLUX EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 20.0 | 0 | 0.00 | -0.49 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172196 | 172196 | 572.0 | MOUNT GLEASON MS | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 10.0 | 1 | 0.13 | 0.13 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172197 | 172197 | 573.0 | MOUNTAIN VIEW EL | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 28.0 | 2 | 0.28 | 0.14 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172198 | 172198 | 574.0 | MT LUKENS HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172206 | 172206 | 582.0 | NARBONNE SH | OPEN | green | 4 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 37.0 | 2 | 0.10 | -0.10 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172207 | 172207 | 583.0 | NARBONNE SH HARTS LA | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | -0.32 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172224 | 172224 | 600.0 | NORMONT EEC | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 56.0 | 0 | 0.00 | 0.00 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172225 | 172225 | 601.0 | NORMONT EL | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 1 | 0.32 | 0.32 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172263 | 172263 | 639.0 | PATTON HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172268 | 172268 | 644.0 | PINEWOOD AVE EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 82.0 | 1 | 0.88 | 0.88 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172269 | 172269 | 645.0 | PINEWOOD AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 1 | 0.53 | 0.53 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172271 | 172271 | 647.0 | PLAINVIEW ACADEMC CA | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172283 | 172283 | 659.0 | PRESIDENT AVE EL | OPEN | yellow | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 22.0 | 0 | 0.00 | -0.47 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172315 | 172315 | 691.0 | RIVERSIDE DR CS | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | -0.83 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172319 | 172319 | 695.0 | ROGERS HS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | 0.00 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172361 | 172361 | 737.0 | SHERMAN OAKS EL CS | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172385 | 172385 | 761.0 | STONEHURST STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | (Blank) | (Blank) | (Blank) | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | ||||||
172390 | 172390 | 766.0 | SUNLAND EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 17.0 | 0 | 0.00 | 0.00 | Sunland/Tujunga CoS | 5 | 0.11 | -0.02 | 217.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172399 | 172399 | 775.0 | SYLVAN PARK EEC | OPEN | green | 1 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 82.0 | 0 | 0.00 | -1.60 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172400 | 172400 | 776.0 | SYLVAN PARK EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 2.0 | 0 | 0.00 | -0.13 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172428 | 172428 | 804.0 | VAN DEENE AVE EL | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 3.0 | 2 | 0.62 | 0.62 | Harbor City/Lomita CoS | 14 | 0.18 | -0.02 | 168.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172431 | 172431 | 807.0 | VAN NUYS EL | OPEN | green | 0 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 1.0 | 0 | 0.00 | -0.61 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172432 | 172432 | 808.0 | VAN NUYS MS | OPEN | green | 2 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 39.0 | 2 | 0.19 | 0.19 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM | |||||
172433 | 172433 | 809.0 | VAN NUYS SH | OPEN | green | 6 | 0 | Past 7 days (6/17/2022 - 6/23/2022) | 240.0 | 7 | 0.26 | 0.22 | Van Nuys/Valley Glen CoS | 18 | 0.1 | -0.02 | 538.0 | -0.09 | 19,803 | 649 | 0.11 | 2022-06-24 | 01:38AM |
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 );