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-11-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207319 | 207319 | 315.0 | FLORENCE AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207331 | 207331 | 327.0 | GAGE MS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 0 | 0.0 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207406 | 207406 | 402.0 | HOLMES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207407 | 207407 | 403.0 | HOLMES AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207414 | 207414 | 410.0 | HOPE ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 3 | 0 | 0.0 | 0.00 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207420 | 207420 | 416.0 | HUNTNGTN PK EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207421 | 207421 | 417.0 | HUNTNGTN PK SH | OPEN | green | 4 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 3 | 3 | 0.18 | 0.06 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207482 | 207482 | 478.0 | LILLIAN ST EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.25 | 0.25 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207533 | 207533 | 529.0 | MARQUEZ SH HPIAM | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 2 | 0.25 | 0.25 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207534 | 207534 | 530.0 | MARQUEZ SH LIBRA | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207535 | 207535 | 531.0 | MARQUEZ SH SOC JUS | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.15 | 0.15 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207557 | 207557 | 553.0 | MIDDLETON ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207558 | 207558 | 554.0 | MIDDLETON ST PC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207560 | 207560 | 556.0 | MILES AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207561 | 207561 | 557.0 | MILES AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207598 | 207598 | 594.0 | NIMITZ MS | OPEN | green | 4 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 2 | 0.15 | -0.23 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207628 | 207628 | 624.0 | PACIFIC BLVD SCHOOL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207712 | 207712 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.18 | 0.18 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207715 | 207715 | 711.0 | SAN ANTONIO EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 0 | 0.0 | -0.36 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207716 | 207716 | 712.0 | SAN ANTONIO HS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207830 | 207830 | 826.0 | VERNON CITY EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207847 | 207847 | 843.0 | WALNUT PARK EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207848 | 207848 | 844.0 | WALNUT PARK MS SJ/SL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.23 | 0.23 | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207849 | 207849 | 845.0 | WALNUT PARK MS STEM | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 11 | 0.08 | -0.01 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207004 | 207004 | 0.0 | 107TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 2 | 0.2 | 0.20 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207005 | 207005 | 1.0 | 109TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.2 | (Blank) | Fremont CoS | 0 | 0.0 | -0.02 | 1 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207010 | 207010 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207011 | 207011 | 7.0 | 122ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.0 | -0.14 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207018 | 207018 | 14.0 | 20TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.16 | 0.16 | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207022 | 207022 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207023 | 207023 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207042 | 207042 | 38.0 | 75TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.76 | 0.00 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207043 | 207043 | 39.0 | 75TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207046 | 207046 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207050 | 207050 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207052 | 207052 | 48.0 | 9TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207054 | 207054 | 50.0 | ADAMS MS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 0 | 0.0 | -0.12 | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207096 | 207096 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207104 | 207104 | 100.0 | BARRETT EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207119 | 207119 | 115.0 | BETHUNE MS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207187 | 207187 | 183.0 | CDS JOHNSON | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207216 | 207216 | 212.0 | CLINTON MS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207276 | 207276 | 272.0 | EAST VALLEY SH | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 6 | 0.04 | -0.02 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207325 | 207325 | 321.0 | FREMONT SH | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.04 | 0.00 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207363 | 207363 | 359.0 | GRAPE ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207369 | 207369 | 365.0 | GRIFFITH JOYNER EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207413 | 207413 | 409.0 | HOPE HS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207416 | 207416 | 412.0 | HUERTA EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207432 | 207432 | 428.0 | JONES EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207434 | 207434 | 430.0 | JORDAN SH | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207436 | 207436 | 432.0 | KAHLO HS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207485 | 207485 | 481.0 | LIZARRAGA EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207519 | 207519 | 515.0 | MANCHESTER AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.16 | 0.16 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207523 | 207523 | 519.0 | MAPLE PC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207530 | 207530 | 526.0 | MARKHAM MS | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207559 | 207559 | 555.0 | MIKES EEC | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 1.14 | 1.14 | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207563 | 207563 | 559.0 | MILLER EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207623 | 207623 | 619.0 | ORTHOPAEDIC HSP SH MG | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207688 | 207688 | 684.0 | RILEY HS CYESIS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207691 | 207691 | 687.0 | RITTER EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207728 | 207728 | 724.0 | SAN PEDRO ST EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.19 | 0.19 | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207730 | 207730 | 726.0 | SANTEE EC | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.05 | 0.05 | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207757 | 207757 | 753.0 | SOUTH PARK EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207800 | 207800 | 796.0 | TRINITY EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207801 | 207801 | 797.0 | TRINITY ST EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207844 | 207844 | 840.0 | WADSWORTH AVE EEC | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 1.01 | 1.01 | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207845 | 207845 | 841.0 | WADSWORTH AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207851 | 207851 | 847.0 | WASHINGTON PC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207863 | 207863 | 859.0 | WEST VERNON AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.02 | 5 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207901 | 207901 | 897.0 | YTH OPP UNLTD ALT HS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.02 | 7 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207038 | 207038 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207039 | 207039 | 35.0 | 66TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207095 | 207095 | 91.0 | BACA ARTS ACAD | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 0 | 0.0 | -0.16 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207125 | 207125 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207268 | 207268 | 264.0 | DREW MS UP PBLC SRVC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 2 | 0.0 | -0.34 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207280 | 207280 | 276.0 | EDISON MS | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.1 | 0.10 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207333 | 207333 | 329.0 | GARCETTI LA | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207356 | 207356 | 352.0 | GRAHAM EEC | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207357 | 207357 | 353.0 | GRAHAM EL | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207447 | 207447 | 443.0 | KING-DREW SH MD/S MG | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207546 | 207546 | 542.0 | MCKINLEY AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207564 | 207564 | 560.0 | MIRAMONTE EEC | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 0 | 0.0 | -0.86 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207565 | 207565 | 561.0 | MIRAMONTE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207574 | 207574 | 570.0 | MOORE M/S/T ACAD | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207641 | 207641 | 637.0 | PARMELEE AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 2 | 2 | 0.24 | 0.24 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207692 | 207692 | 688.0 | RIVERA LC COM & TECH | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207693 | 207693 | 689.0 | RIVERA LC GD STEAM AC | OPEN | green | 1 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207694 | 207694 | 690.0 | RIVERA LC PERF ARTS | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207695 | 207695 | 691.0 | RIVERA LC PUB SRV | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207713 | 207713 | 709.0 | RUSSELL EL | OPEN | green | 2 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 6 | 5 | 0.54 | 0.32 | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207889 | 207889 | 885.0 | WISDOM EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 10 | 0.07 | -0.03 | 16 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207064 | 207064 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207081 | 207081 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207089 | 207089 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 1 | 0.26 | 0.00 | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207215 | 207215 | 211.0 | CLIFFORD ST M/T MAG | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207251 | 207251 | 247.0 | DAYTON HEIGHTS EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207252 | 207252 | 248.0 | DBM | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 1 | 0 | 0.0 | -0.21 | Glassell Park/Los Feliz CoS | 7 | 0.07 | -0.04 | 11 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207291 | 207291 | 287.0 | ELYSIAN HTS ARTS MAG | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207318 | 207318 | 314.0 | FLETCHER DR EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM | |||||
207323 | 207323 | 319.0 | FRANKLIN AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/16/2022 - 11/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 5 | 0.04 | -0.04 | 9 | 716 | 356 | 0.06 | -0.08 | 2022-11-23 | 01:39AM |
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 );