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-12-23 sorted by tests
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219577 | 219577 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219578 | 219578 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | MacArthur Park CoS | 4 | 0.05 | -0.29 | 6 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219579 | 219579 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219580 | 219580 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219581 | 219581 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219582 | 219582 | 6.0 | 118TH ST EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.21 | 29 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219583 | 219583 | 7.0 | 122ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.21 | 29 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219584 | 219584 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219585 | 219585 | 9.0 | 153RD ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219586 | 219586 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219587 | 219587 | 11.0 | 15TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 2 | 0.02 | -0.37 | 10 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219588 | 219588 | 12.0 | 186TH ST EL | OPEN | green | 4 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219591 | 219591 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 3 | 0.02 | -0.37 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219592 | 219592 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 1 | 0.01 | -0.22 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219593 | 219593 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 1 | 0.01 | -0.22 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219597 | 219597 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 1 | 0.01 | -0.22 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219598 | 219598 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219599 | 219599 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 1 | 0.01 | -0.22 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219601 | 219601 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219602 | 219602 | 26.0 | 49TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.22 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219604 | 219604 | 28.0 | 4TH ST EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 12 | 0.08 | -0.45 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219606 | 219606 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.25 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219607 | 219607 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219608 | 219608 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219609 | 219609 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.25 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219610 | 219610 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 1 | 0.01 | -0.23 | 5 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219612 | 219612 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219613 | 219613 | 37.0 | 74TH ST EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219617 | 219617 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219618 | 219618 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.21 | 29 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219619 | 219619 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219620 | 219620 | 44.0 | 95TH ST EL | OPEN | green | 3 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219621 | 219621 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 0 | 0.0 | -0.09 | 1 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219623 | 219623 | 47.0 | 99TH ST EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219627 | 219627 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 3 | 0.02 | -0.61 | 12 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219628 | 219628 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219629 | 219629 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 5 | 0.03 | -0.53 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219630 | 219630 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 6 | 0.04 | -0.52 | 17 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219631 | 219631 | 55.0 | ALBION ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 6 | 0.04 | -0.52 | 17 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219633 | 219633 | 57.0 | ALEXANDER SCS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 1 | 0.01 | -0.22 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219634 | 219634 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 5 | 0.05 | -0.27 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219635 | 219635 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 5 | 0.05 | -0.27 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219636 | 219636 | 60.0 | ALLESANDRO EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 1 | 0.01 | -0.41 | 7 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219638 | 219638 | 62.0 | ALTA LOMA EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219639 | 219639 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 12 | 0.08 | -0.45 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219641 | 219641 | 65.0 | AMESTOY EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219642 | 219642 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 3 | 0.02 | -0.32 | 4 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219644 | 219644 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 2 | 0.02 | -0.37 | 10 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219645 | 219645 | 68.0 | ANGELES MESA EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219646 | 219646 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.22 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219647 | 219647 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 6 | 0.04 | -0.52 | 17 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219648 | 219648 | 72.0 | ANNALEE AVE EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 3 | 0.02 | -0.37 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219649 | 219649 | 73.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 5 | 0.05 | -0.32 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219652 | 219652 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.27 | 4 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219653 | 219653 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 1 | 0.01 | -0.41 | 7 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219655 | 219655 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 0 | 0.0 | -0.26 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219657 | 219657 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 5 | 0.03 | -0.49 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219658 | 219658 | 82.0 | ARMSTRONG MS | OPEN | yellow | 2 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 3 | 0.02 | -0.40 | 13 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219660 | 219660 | 84.0 | ASCOT AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.22 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219661 | 219661 | 85.0 | ATWATER AVE EL | OPEN | green | 2 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 1 | 0.01 | -0.41 | 7 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219662 | 219662 | 86.0 | AUDUBON MS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219663 | 219663 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.25 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219664 | 219664 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.25 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219665 | 219665 | 89.0 | AURORA EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.22 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219666 | 219666 | 90.0 | AVALON GARDENS EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219668 | 219668 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.21 | 29 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219669 | 219669 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219670 | 219670 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 3 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 3 | 0.02 | -0.61 | 12 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219671 | 219671 | 95.0 | BALDWIN HILLS EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 2 | 0.02 | -0.41 | 3 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219672 | 219672 | 96.0 | BANCROFT MS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 6 | 0.08 | -0.46 | 13 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219673 | 219673 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 2 | 0.02 | -0.37 | 10 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219674 | 219674 | 98.0 | BANNEKER CTC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 2 | 0.02 | -0.30 | 2 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219675 | 219675 | 99.0 | BANNING SH | OPEN | green | 3 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 3 | 0.03 | -0.33 | 6 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219677 | 219677 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 2 | 0.02 | -0.37 | 10 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219678 | 219678 | 102.0 | BASSETT ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 4 | 0.03 | -0.34 | 6 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219679 | 219679 | 103.0 | BEACHY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 5 | 0.03 | -0.49 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219681 | 219681 | 105.0 | BEETHOVEN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 2 | 0.02 | -0.34 | 5 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219682 | 219682 | 106.0 | BELL SH | OPEN | green | 4 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Bell/Cudahy/Maywood CoS | 6 | 0.04 | -0.43 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219683 | 219683 | 107.0 | BELLINGHAM EL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 7 | 0.05 | -0.37 | 12 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219684 | 219684 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 5 | 0.05 | -0.27 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219685 | 219685 | 109.0 | BELVEDERE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 12 | 0.08 | -0.45 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219686 | 219686 | 110.0 | BELVEDERE MS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 12 | 0.08 | -0.45 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219688 | 219688 | 112.0 | BERNSTEIN SH | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 6 | 0.08 | -0.46 | 13 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219689 | 219689 | 113.0 | BERNSTEIN SH STEM | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 6 | 0.08 | -0.46 | 13 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219690 | 219690 | 114.0 | BERTRAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 4 | 0.03 | -0.34 | 6 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219694 | 219694 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.36 | 15 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219695 | 219695 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.36 | 15 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219697 | 219697 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 1 | 0.01 | -0.23 | 5 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219698 | 219698 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219699 | 219699 | 123.0 | BRAINARD EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.27 | 4 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219701 | 219701 | 125.0 | BREED ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.36 | 15 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219702 | 219702 | 126.0 | BRENTWOOD EL SCI MAG | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 3 | 0.03 | -0.28 | 9 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219703 | 219703 | 127.0 | BRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.36 | 15 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219704 | 219704 | 128.0 | BRIDGES SCHOOL | OPEN | green | 1 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 3 | 0.03 | -0.33 | 6 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219707 | 219707 | 131.0 | BROADACRES AV EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 3 | 0.02 | -0.37 | 8 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219708 | 219708 | 132.0 | BROADOUS EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 7 | 0.04 | -0.40 | 12 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219709 | 219709 | 133.0 | BROADOUS EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 7 | 0.04 | -0.40 | 12 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219710 | 219710 | 134.0 | BROADWAY EL | OPEN | green | 2 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 2 | 0.02 | -0.34 | 5 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219711 | 219711 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 3 | 0.03 | -0.28 | 9 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM | |||||
219712 | 219712 | 136.0 | BROOKLYN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/16/2022 - 12/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 12 | 0.08 | -0.45 | 14 | 792 | 263 | 0.04 | -0.31 | 2022-12-23 | 01:31AM |
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 );