lausd-cases
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- school
- The name of the school.
- status
- Whether the school is open or closed.
- staff_student
- The current number of active cases among staff and students.
- transmission
- The number of school-linked cases.
- staff_student_rate
- The seven-day average of active cases per 100,000 students in this school's community of schools.
- community_rate
- The seven-day average of active cases per 100,000 residents in the school's surrounding community.
- lac_rate
- The seven-day average of active cases per 100,000 residents in Los Angeles County.
- community_schools
- The name of the community of schools that this school belongs to.
- community
- The name of the community where the school is located within.
- date
- The last updated date listed on the district's dashboard.
- time
- The last updated time listed on the district's dashboard.
898 rows where "date" is on date 2022-10-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190740 | 190740 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190741 | 190741 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 4 | 0.07 | 0.03 | 125 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190746 | 190746 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190747 | 190747 | 7.0 | 122ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190748 | 190748 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 10 | 0.1 | 0.03 | 13 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190750 | 190750 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 10 | 0.1 | 0.03 | 13 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190752 | 190752 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 10 | 0.1 | 0.03 | 13 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190753 | 190753 | 13.0 | 1ST ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.04 | 50 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190754 | 190754 | 14.0 | 20TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 7 | 0.07 | 0.01 | 30 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190756 | 190756 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 14 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190759 | 190759 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 7 | 0.07 | 0.01 | 30 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190760 | 190760 | 20.0 | 2ND ST EL | OPEN | green | 1 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.04 | 50 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190762 | 190762 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190763 | 190763 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 14 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190765 | 190765 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 0 | 0.0 | -0.02 | 1 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190766 | 190766 | 26.0 | 49TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.02 | 17 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190767 | 190767 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 15 | 0.1 | 0.02 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190770 | 190770 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.03 | 4 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190771 | 190771 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190772 | 190772 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 0 | 0.0 | -0.02 | 1 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190773 | 190773 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.03 | 4 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190774 | 190774 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 14 | 0.1 | 0.07 | 23 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190776 | 190776 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190777 | 190777 | 37.0 | 74TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 0 | 0.0 | -0.02 | 1 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190778 | 190778 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190779 | 190779 | 39.0 | 75TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190781 | 190781 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 4 | 0.07 | 0.03 | 125 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190782 | 190782 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190783 | 190783 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.08 | 2 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190784 | 190784 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.08 | 2 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190785 | 190785 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 4 | 0.07 | 0.03 | 125 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190786 | 190786 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190787 | 190787 | 47.0 | 99TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 10 | 0.1 | 0.03 | 13 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190791 | 190791 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 19 | 0.12 | 0.0 | 90 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190792 | 190792 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190793 | 190793 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 15 | 0.1 | 0.02 | 60 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190794 | 190794 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 17 | 0.12 | -0.02 | 31 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190796 | 190796 | 56.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 7 | 0.06 | -0.05 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190798 | 190798 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 5 | 0.05 | -0.03 | 7 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190800 | 190800 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 7 | 0.06 | -0.05 | 83 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190801 | 190801 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 5 | 0.04 | 0.0 | 16 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190803 | 190803 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 15 | 0.1 | 0.02 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190806 | 190806 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 17 | 0.14 | 0.07 | 58 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190808 | 190808 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 12 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190809 | 190809 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190810 | 190810 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.02 | 17 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190811 | 190811 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 17 | 0.12 | -0.02 | 31 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190812 | 190812 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 14 | 0.11 | -0.04 | 42 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190814 | 190814 | 74.0 | ANTON EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 15 | 0.1 | 0.02 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190816 | 190816 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 2 | 0.04 | -0.04 | 29 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190817 | 190817 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 7 | 0.06 | -0.05 | 83 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190818 | 190818 | 78.0 | ARLETA SH | OPEN | green | 1 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190819 | 190819 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190820 | 190820 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190821 | 190821 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190825 | 190825 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 7 | 0.06 | -0.05 | 83 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190826 | 190826 | 86.0 | AUDUBON MS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 0 | 0.0 | -0.02 | 1 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190827 | 190827 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.03 | 4 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190828 | 190828 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.03 | 4 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190829 | 190829 | 89.0 | AURORA EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.02 | 17 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190831 | 190831 | 91.0 | BACA ARTS ACAD | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 14 | 0.1 | 0.07 | 23 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190832 | 190832 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190833 | 190833 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 1 | 0.02 | -0.08 | 2 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190835 | 190835 | 95.0 | BALDWIN HILLS EL | OPEN | green | 1 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.13 | (Blank) | Hamilton CoS | 10 | 0.12 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190836 | 190836 | 96.0 | BANCROFT MS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 7 | 0.09 | -0.09 | 24 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190838 | 190838 | 98.0 | BANNEKER CTC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 10 | 0.1 | 0.03 | 13 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190840 | 190840 | 100.0 | BARRETT EL | OPEN | green | 2 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190841 | 190841 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 12 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190843 | 190843 | 103.0 | BEACHY AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190847 | 190847 | 107.0 | BELLINGHAM EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 21 | 0.15 | 0.03 | 68 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190848 | 190848 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 5 | 0.05 | -0.03 | 7 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190854 | 190854 | 114.0 | BERTRAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 3 | 0.03 | -0.02 | 14 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190855 | 190855 | 115.0 | BETHUNE MS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 6 | 0.04 | -0.09 | 32 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190856 | 190856 | 116.0 | BLYTHE ST EL | OPEN | green | 1 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 17 | 0.14 | 0.07 | 58 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190859 | 190859 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.04 | 50 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190861 | 190861 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 14 | 0.1 | 0.07 | 23 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190862 | 190862 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 0 | 0.0 | -0.02 | 1 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190866 | 190866 | 126.0 | BRENTWOOD EL SCI MAG | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 13 | 0.12 | -0.03 | 63 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190867 | 190867 | 127.0 | BRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 7 | 0.06 | -0.04 | 50 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190868 | 190868 | 128.0 | BRIDGES SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 6 | 0.06 | -0.01 | 30 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190869 | 190869 | 129.0 | BRIGHT EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 9 | 0.11 | 0.04 | 21 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190870 | 190870 | 130.0 | BROAD AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 6 | 0.06 | -0.01 | 30 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190871 | 190871 | 131.0 | BROADACRES AV EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 14 | 0.11 | -0.04 | 42 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190872 | 190872 | 132.0 | BROADOUS EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 20 | 0.11 | 0.0 | 81 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190875 | 190875 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 13 | 0.12 | -0.03 | 63 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190876 | 190876 | 136.0 | BROOKLYN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 15 | 0.1 | 0.02 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190877 | 190877 | 137.0 | BROOKLYN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 15 | 0.1 | 0.02 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190880 | 190880 | 140.0 | BUDLONG AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.03 | 4 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190882 | 190882 | 142.0 | BURBANK MS A/T/C MAG | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 7 | 0.06 | -0.05 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190885 | 190885 | 145.0 | BURTON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Panorama City CoS | 6 | 0.08 | 0.08 | 18 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190886 | 190886 | 146.0 | BUSHNELL WAY EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 7 | 0.06 | -0.05 | 35 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190887 | 190887 | 147.0 | BYRD MS | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.01 | 15 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190888 | 190888 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 12 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190889 | 190889 | 149.0 | CABRILLO AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 12 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190890 | 190890 | 150.0 | CAHUENGA EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 5 | 0.04 | -0.04 | 12 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190891 | 190891 | 151.0 | CALABASH CA | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.09 | 0.02 | 149 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190893 | 190893 | 153.0 | CALVERT CES | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.09 | 0.02 | 149 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190894 | 190894 | 154.0 | CAMELLIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 21 | 0.15 | 0.03 | 68 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190896 | 190896 | 156.0 | CANOGA PARK EEC | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 15 | 0.1 | 0.02 | 60 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM | |||||
190898 | 190898 | 158.0 | CANOGA PRK SH | OPEN | green | 0 | 0 | Past 7 days (10/16/2022 - 10/22/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 15 | 0.1 | 0.02 | 60 | 1,633 | 454 | 0.07 | -0.01 | 2022-10-23 | 01:32AM |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "lausd-cases" ( [Unnamed: 0] FLOAT, [school] TEXT, [status] TEXT, [color] TEXT, [staff_student] INTEGER, [transmission] INTEGER, [testing_period] TEXT, [tests] TEXT, [pos] TEXT, [pos_rate] TEXT, [change] TEXT, [cos] TEXT, [cos_tests] TEXT, [cos_pos] TEXT, [cos_pos_rate] TEXT, [cos_change] TEXT, [lausd_tests] TEXT, [lausd_pos] TEXT, [lausd_pos_rate] TEXT, [lausd_change] FLOAT, [date] TEXT, [time] TEXT, [staff_student_rate] FLOAT, [community_rate] FLOAT, [lac_rate] FLOAT, [community_schools] TEXT, [community] TEXT );