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.
888 rows where "date" is on date 2022-06-14 sorted by cos_change
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169159 | 169159 | 203.0 | CITY OF ANGELS | OPEN | green | 9 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CITY OF ANGELS | 145 | 7 | 4.83 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169187 | 169187 | 231.0 | CRENSHAW ARTS TECH | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CRENSHAW ARTS TECH | 86 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169226 | 169226 | 270.0 | EAST VALLEY SKLS CTR | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | EAST VALLEY SKLS CTR | (Bla… | (Bla… | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||||
169236 | 169236 | 280.0 | ELA OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ELA OCC CTR | 143 | 1 | 0.70 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169254 | 169254 | 298.0 | EVANS CAS | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | EVANS CAS | 92 | 4 | 4.35 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169275 | 169275 | 319.0 | FRIEDMAN OCC CTR | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | FRIEDMAN OCC CTR | 102 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169330 | 169330 | 374.0 | HARBOR OCC CTR | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HARBOR OCC CTR | 10 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169375 | 169375 | 419.0 | IOVINE YOUNG CTR MAG | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | IOVINE YOUNG CTR MAG | (Bla… | (Bla… | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||||
169451 | 169451 | 495.0 | LOS ANGELES TECH CTR | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | LOS ANGELES TECH CTR | 20 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169462 | 169462 | 506.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MAGNOLIA SCI ACAD #2 | (Bla… | (Bla… | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||||
169463 | 169463 | 507.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MAGNOLIA SCI ACAD #4 | (Bla… | (Bla… | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||||
169464 | 169464 | 508.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MAGNOLIA SCI ACAD #6 | 61 | 4 | 6.56 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169465 | 169465 | 509.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MAGNOLIA SCI-BELL@SR | 245 | 4 | 1.63 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169543 | 169543 | 587.0 | NEW ACAD CANOGA PARK | OPEN | green | 7 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NEW ACAD CANOGA PA… | 289 | 7 | 2.42 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169556 | 169556 | 600.0 | NORTH VALLEY OCC CTR | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NORTH VALLEY OCC CTR | 196 | 3 | 1.53 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169696 | 169696 | 740.0 | SLAWSON OCC CTR | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | SLAWSON OCC CTR | 134 | 1 | 0.75 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169769 | 169769 | 813.0 | VENICE SKILLS CENTER | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VENICE SKILLS CENTER | 9 | 1 | 11.11 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169795 | 169795 | 839.0 | WATERS EMP PREP CTR | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | WATERS EMP PREP CTR | 247 | 5 | 2.02 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169804 | 169804 | 848.0 | WEST VALLEY OCC CTR | OPEN | green | 6 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | WEST VALLEY OCC CTR | 237 | 5 | 2.11 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169826 | 169826 | 870.0 | WILSON-LINCOLN CAS | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | WILSON-LINCOLN CAS | (Bla… | (Bla… | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||||
169011 | 169011 | 55.0 | ALDAMA EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ALDAMA EL | 324 | 1 | 0.31 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169028 | 169028 | 72.0 | ANNANDALE EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ANNANDALE EL | 103 | 1 | 0.97 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169038 | 169038 | 82.0 | ARROYO SECO MUS/S MAG | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ARROYO SECO MUS/S … | 416 | 6 | 1.44 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169049 | 169049 | 93.0 | BANCROFT MS | OPEN | green | 6 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BANCROFT MS | 421 | 7 | 1.66 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169065 | 169065 | 109.0 | BERNSTEIN SH | OPEN | green | 8 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BERNSTEIN SH | 402 | 8 | 1.99 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169066 | 169066 | 110.0 | BERNSTEIN SH STEM | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BERNSTEIN SH STEM | 343 | 5 | 1.46 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169092 | 169092 | 136.0 | BUCHANAN ST EL | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BUCHANAN ST EL | 2 | 0 | 0.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169095 | 169095 | 139.0 | BURBANK MS A/T/C MAG | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BURBANK MS A/T/C MAG | 15 | 1 | 6.67 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169099 | 169099 | 143.0 | BUSHNELL WAY EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BUSHNELL WAY EL | 180 | 1 | 0.56 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169135 | 169135 | 179.0 | CDS ALONZO | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CDS ALONZO | 28 | 0 | 0.00 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169155 | 169155 | 199.0 | CHEREMOYA AVE EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CHEREMOYA AVE EL | 224 | 3 | 1.34 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169195 | 169195 | 239.0 | DAHLIA HTS EL | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | DAHLIA HTS EL | 300 | 3 | 1.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169206 | 169206 | 250.0 | DELEVAN DRIVE EL | OPEN | green | 7 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | DELEVAN DRIVE EL | 389 | 6 | 1.54 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169220 | 169220 | 264.0 | EAGLE ROCK EL | OPEN | green | 11 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | EAGLE ROCK EL | 582 | 12 | 2.06 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169221 | 169221 | 265.0 | EAGLE ROCK HS | OPEN | green | 13 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | EAGLE ROCK HS | 587 | 13 | 2.21 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169273 | 169273 | 317.0 | FRANKLIN HS | OPEN | green | 8 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | FRANKLIN HS | 301 | 5 | 1.66 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169287 | 169287 | 331.0 | GARDNER ST EL | OPEN | green | 9 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GARDNER ST EL | 347 | 9 | 2.59 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169289 | 169289 | 333.0 | GARVANZA EL T/L MAG | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GARVANZA EL T/L MAG | 4 | 1 | 25.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169309 | 169309 | 353.0 | GRANT EEC | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GRANT EEC | 2 | 0 | 0.00 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169310 | 169310 | 354.0 | GRANT EL | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GRANT EL | 26 | 1 | 3.85 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169336 | 169336 | 380.0 | HARVARD EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HARVARD EL | 262 | 1 | 0.38 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169347 | 169347 | 391.0 | HIGHLAND PARK HS | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HIGHLAND PARK HS | 26 | 0 | 0.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169353 | 169353 | 397.0 | HOLLYWOOD EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HOLLYWOOD EL | 194 | 1 | 0.52 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169354 | 169354 | 398.0 | HOLLYWOOD SH | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HOLLYWOOD SH | 226 | 1 | 0.44 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169397 | 169397 | 441.0 | KINGSLEY EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | KINGSLEY EL | 5 | 2 | 40.00 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169417 | 169417 | 461.0 | LE CONTE MS | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | LE CONTE MS | 212 | 4 | 1.89 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169500 | 169500 | 544.0 | MERIDIAN EEC | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MERIDIAN EEC | 61 | 0 | 0.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169520 | 169520 | 564.0 | MONTE VISTA EEC | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MONTE VISTA EEC | 92 | 0 | 0.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169521 | 169521 | 565.0 | MONTE VISTA ST EL | OPEN | green | 6 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MONTE VISTA ST EL | 334 | 6 | 1.80 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169529 | 169529 | 573.0 | MT WASHINGTON EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MT WASHINGTON EL | 371 | 2 | 0.54 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169619 | 169619 | 663.0 | RAMONA EL | OPEN | green | 8 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | RAMONA EL | (Bla… | (Bla… | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169639 | 169639 | 683.0 | RIORDAN PC | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | RIORDAN PC | 121 | 3 | 2.48 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169647 | 169647 | 691.0 | ROCKDALE VAPA MAG | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ROCKDALE VAPA MAG | 18 | 2 | 11.11 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169674 | 169674 | 718.0 | SAN PASCUAL STEAM MG | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | SAN PASCUAL STEAM MG | 182 | 1 | 0.55 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169683 | 169683 | 727.0 | SELMA AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | SELMA AVE EL | (Bla… | (Bla… | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169737 | 169737 | 781.0 | TOLAND WAY EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | TOLAND WAY EL | 343 | 3 | 0.87 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169757 | 169757 | 801.0 | VALLEY VIEW EL | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VALLEY VIEW EL | 147 | 0 | 0.00 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169760 | 169760 | 804.0 | VAN NESS AVE EL | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VAN NESS AVE EL | 182 | 0 | 0.00 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169776 | 169776 | 820.0 | VINE ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VINE ST EEC | 85 | 1 | 1.18 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169777 | 169777 | 821.0 | VINE ST EL | OPEN | green | 9 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VINE ST EL | 286 | 9 | 3.15 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169832 | 169832 | 876.0 | WONDERLAND AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | WONDERLAND AVE EL | 13 | 1 | 7.69 | Hollywood CoS | 3,405 | 53 | 1.56 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169841 | 169841 | 885.0 | YORKDALE EL | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | YORKDALE EL | 172 | 0 | 0.00 | Eagle Rock/HighlandPark CoS | 4,923 | 67 | 1.36 | -0.03 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169137 | 169137 | 181.0 | CDS JOHNSTON | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CDS JOHNSTON | 26 | 0 | 0.00 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169249 | 169249 | 293.0 | ESHELMAN AVE EL | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ESHELMAN AVE EL | 388 | 5 | 1.29 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169266 | 169266 | 310.0 | FLEMING MS | OPEN | green | 11 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | FLEMING MS | 923 | 13 | 1.41 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169324 | 169324 | 368.0 | HALLDALE EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HALLDALE EL | 272 | 2 | 0.74 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169329 | 169329 | 373.0 | HARBOR CITY EL | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HARBOR CITY EL | 373 | 3 | 0.80 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169443 | 169443 | 487.0 | LOMITA EL M/S/T MAG | OPEN | yellow | 11 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | LOMITA EL M/S/T MAG | 623 | 11 | 1.77 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169502 | 169502 | 546.0 | MEYLER ST EL | OPEN | green | 9 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MEYLER ST EL | 546 | 9 | 1.65 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169536 | 169536 | 580.0 | NARBONNE SH | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NARBONNE SH | 59 | 4 | 6.78 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169537 | 169537 | 581.0 | NARBONNE SH HARTS LA | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NARBONNE SH HARTS LA | (Bla… | (Bla… | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169554 | 169554 | 598.0 | NORMONT EEC | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NORMONT EEC | 92 | 0 | 0.00 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169555 | 169555 | 599.0 | NORMONT EL | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NORMONT EL | 270 | 4 | 1.48 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169593 | 169593 | 637.0 | PATTON HS | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | PATTON HS | (Bla… | (Bla… | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
169613 | 169613 | 657.0 | PRESIDENT AVE EL | OPEN | yellow | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | PRESIDENT AVE EL | 252 | 4 | 1.59 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169758 | 169758 | 802.0 | VAN DEENE AVE EL | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VAN DEENE AVE EL | 284 | 7 | 2.46 | Harbor City/Lomita CoS | 4,108 | 62 | 1.51 | -0.05 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169007 | 169007 | 51.0 | ADDAMS HS | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ADDAMS HS | 41 | 1 | 2.44 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169022 | 169022 | 66.0 | ANDASOL AVE EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | ANDASOL AVE EL | 292 | 5 | 1.71 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169047 | 169047 | 91.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 18 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BALBOA EL G/HG/HA M… | 563 | 17 | 3.02 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169131 | 169131 | 175.0 | CASTLEBAY LN CHTR | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CASTLEBAY LN CHTR | 233 | 5 | 2.15 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169197 | 169197 | 241.0 | DANUBE AVE EL | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | DANUBE AVE EL | 284 | 0 | 0.00 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169198 | 169198 | 242.0 | DARBY AVE EL | OPEN | green | 8 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | DARBY AVE EL | 374 | 9 | 2.41 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169232 | 169232 | 276.0 | EL ORO WAY CES | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | EL ORO WAY CES | 182 | 3 | 1.65 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169277 | 169277 | 321.0 | FROST MS | OPEN | green | 20 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | FROST MS | 1,175 | 20 | 1.70 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169307 | 169307 | 351.0 | GRANADA EL | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GRANADA EL | 299 | 5 | 1.67 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169337 | 169337 | 381.0 | HASKELL EL STEAM MAG | OPEN | green | 7 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HASKELL EL STEAM MAG | 455 | 7 | 1.54 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169344 | 169344 | 388.0 | HENRY MS | OPEN | green | 19 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HENRY MS | 867 | 19 | 2.19 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169387 | 169387 | 431.0 | KENNEDY SH | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | KENNEDY SH | 218 | 1 | 0.46 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169399 | 169399 | 443.0 | KNOLLWOOD PREP ACAD | OPEN | green | 1 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | KNOLLWOOD PREP ACAD | 89 | 1 | 1.12 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169488 | 169488 | 532.0 | MAYALL ST AC A/T MAG | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | MAYALL ST AC A/T MAG | 539 | 6 | 1.11 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169557 | 169557 | 601.0 | NORTHRIDGE ACAD SH | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | NORTHRIDGE ACAD SH | 28 | 2 | 7.14 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169610 | 169610 | 654.0 | PORTER MS | OPEN | green | 13 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | PORTER MS | 21 | 2 | 9.52 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169672 | 169672 | 716.0 | SAN JOSE ST EL | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | SAN JOSE ST EL | 531 | 5 | 0.94 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169750 | 169750 | 794.0 | TULSA ST EL | OPEN | green | 4 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | TULSA ST EL | 310 | 3 | 0.97 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169756 | 169756 | 800.0 | VALLEY ACAD ARTS/SCI | OPEN | green | 7 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VALLEY ACAD ARTS/SCI | 711 | 6 | 0.84 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169759 | 169759 | 803.0 | VAN GOGH CHTR | OPEN | green | 6 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | VAN GOGH CHTR | 371 | 5 | 1.35 | Kennedy/NAHS/VAASCoS | 7,583 | 122 | 1.61 | -0.06 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169058 | 169058 | 102.0 | BEETHOVEN ST EL | OPEN | green | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BEETHOVEN ST EL | 299 | 5 | 1.67 | Venice CoS | 3,823 | 57 | 1.49 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169073 | 169073 | 117.0 | BRADDOCK DR EL | OPEN | yellow | 5 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BRADDOCK DR EL | 12 | 2 | 16.67 | Venice CoS | 3,823 | 57 | 1.49 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169085 | 169085 | 129.0 | BROADOUS EEC | OPEN | green | 0 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BROADOUS EEC | 123 | 0 | 0.00 | San FernandoValley/Sylmar CoS | 10,308 | 115 | 1.12 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | |||||
169086 | 169086 | 130.0 | BROADOUS EL | OPEN | green | 3 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | BROADOUS EL | 413 | 3 | 0.73 | San FernandoValley/Sylmar CoS | 10,308 | 115 | 1.12 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM |
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 );