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-24 sorted by community_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191738 | 191738 | 100.0 | BARRETT EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.08 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191739 | 191739 | 101.0 | BARTON HILL EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 11 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191740 | 191740 | 102.0 | BASSETT ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.14 | 0.14 | Reseda CoS | 4 | 0.03 | 0.0 | 16 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191741 | 191741 | 103.0 | BEACHY AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 5 | 0.03 | -0.01 | 14 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191742 | 191742 | 104.0 | BECKFORD CES | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 0 | 0.0 | 0.00 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191743 | 191743 | 105.0 | BEETHOVEN ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.28 | 0.00 | Venice CoS | 10 | 0.11 | -0.02 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191744 | 191744 | 106.0 | BELL SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Bell/Cudahy/Maywood CoS | 10 | 0.07 | -0.04 | 20 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191745 | 191745 | 107.0 | BELLINGHAM EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 19 | 0.14 | 0.0 | 61 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191746 | 191746 | 108.0 | BELMONT SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191747 | 191747 | 109.0 | BELVEDERE EL | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.29 | 0.00 | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191748 | 191748 | 110.0 | BELVEDERE MS | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 5 | 1 | 0.12 | -0.61 | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191749 | 191749 | 111.0 | BERENDO MS | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.29 | 0.29 | Kreatwn/PcoUnion CoS | 5 | 0.04 | -0.02 | 11 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191750 | 191750 | 112.0 | BERNSTEIN SH | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.25 | 0.25 | Hollywood CoS | 5 | 0.06 | -0.11 | 13 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191751 | 191751 | 113.0 | BERNSTEIN SH STEM | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.15 | Hollywood CoS | 5 | 0.06 | -0.11 | 13 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191752 | 191752 | 114.0 | BERTRAND AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 4 | 0.03 | 0.0 | 16 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191753 | 191753 | 115.0 | BETHUNE MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.08 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191754 | 191754 | 116.0 | BLYTHE ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191755 | 191755 | 117.0 | BONITA ST EL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.43 | 0.43 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191756 | 191756 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 14 | 0 | 0.0 | -6.98 | Boyle Heights CoS | 4 | 0.03 | -0.08 | 39 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191757 | 191757 | 119.0 | BOYLE HTS STEM MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 4 | 0.03 | -0.08 | 39 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191758 | 191758 | 120.0 | BRADDOCK DR EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 6 | 0 | 0.0 | -0.61 | Venice CoS | 10 | 0.11 | -0.02 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191759 | 191759 | 121.0 | BRADLEY EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 11 | 0.08 | 0.05 | 19 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191760 | 191760 | 122.0 | BRADLEY GLBL AWR MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 1 | 0.02 | 0.02 | 2 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191761 | 191761 | 123.0 | BRAINARD EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 1 | 0.02 | -0.04 | 21 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191762 | 191762 | 124.0 | BRAVO SH MEDICAL MAG | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 5 | 4 | 0.23 | 0.00 | Lincoln Heights/El SerenoCoS | 17 | 0.12 | -0.01 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191763 | 191763 | 125.0 | BREED ST EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.3 | 0.00 | Boyle Heights CoS | 4 | 0.03 | -0.08 | 39 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191764 | 191764 | 126.0 | BRENTWOOD EL SCI MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 16 | 0.15 | 0.02 | 65 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191765 | 191765 | 127.0 | BRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 4 | 0.03 | -0.08 | 39 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191766 | 191766 | 128.0 | BRIDGES SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 5 | 0.05 | -0.03 | 17 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191767 | 191767 | 129.0 | BRIGHT EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 6 | 0.07 | -0.02 | 18 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191768 | 191768 | 130.0 | BROAD AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.17 | 0.17 | Wilmington CoS | 5 | 0.05 | -0.03 | 17 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191769 | 191769 | 131.0 | BROADACRES AV EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191770 | 191770 | 132.0 | BROADOUS EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 21 | 0.12 | 0.02 | 86 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191771 | 191771 | 133.0 | BROADOUS EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | San Fernando Valley/SylmarCoS | 21 | 0.12 | 0.02 | 86 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191772 | 191772 | 134.0 | BROADWAY EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 15 | 1 | 0.18 | 0.18 | Venice CoS | 10 | 0.11 | -0.02 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191773 | 191773 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 16 | 0.15 | 0.02 | 65 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191774 | 191774 | 136.0 | BROOKLYN AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191775 | 191775 | 137.0 | BROOKLYN AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 9 | 0.06 | -0.05 | 27 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191776 | 191776 | 138.0 | BRYSON AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.12 | 0.12 | South Gate CoS | 15 | 0.09 | 0.01 | 17 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191777 | 191777 | 139.0 | BUCHANAN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191778 | 191778 | 140.0 | BUDLONG AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.01 | 1 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191779 | 191779 | 141.0 | BURBANK BLVD EL | OPEN | green | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 4 | 3 | 0.73 | 0.73 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | 0.0 | 61 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191780 | 191780 | 142.0 | BURBANK MS A/T/C MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191781 | 191781 | 143.0 | BURKE HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 0 | 0.0 | -0.75 | Panorama City CoS | 4 | 0.05 | 0.02 | 16 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191782 | 191782 | 144.0 | BURROUGHS MS | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 1 | 0.07 | 0.00 | Fairfax CoS | 9 | 0.1 | -0.03 | 45 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191783 | 191783 | 145.0 | BURTON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Panorama City CoS | 4 | 0.05 | 0.02 | 16 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191784 | 191784 | 146.0 | BUSHNELL WAY EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.44 | 0.44 | Eagle Rock/Highland ParkCoS | 8 | 0.07 | -0.03 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191785 | 191785 | 147.0 | BYRD MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 5 | 0.03 | -0.01 | 14 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191786 | 191786 | 148.0 | CABRILLO AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 11 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191787 | 191787 | 149.0 | CABRILLO AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 9 | 0.08 | 0.05 | 11 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191788 | 191788 | 150.0 | CAHUENGA EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Kreatwn/PcoUnion CoS | 5 | 0.04 | -0.02 | 11 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191789 | 191789 | 151.0 | CALABASH CA | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.09 | 0.01 | 150 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191790 | 191790 | 152.0 | CALAHAN ST EL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 3 | 0.55 | 0.18 | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191791 | 191791 | 153.0 | CALVERT CES | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Taft CoS | 14 | 0.09 | 0.01 | 150 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191792 | 191792 | 154.0 | CAMELLIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 19 | 0.14 | 0.0 | 61 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191793 | 191793 | 155.0 | CANFIELD AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.26 | 0.26 | Hamilton CoS | 7 | 0.08 | -0.04 | 12 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191794 | 191794 | 156.0 | CANOGA PARK EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191795 | 191795 | 157.0 | CANOGA PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.16 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191796 | 191796 | 158.0 | CANOGA PRK SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191797 | 191797 | 159.0 | CANTARA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 19 | 0.16 | 0.07 | 47 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191798 | 191798 | 160.0 | CANTERBURY AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 5 | 0 | 0.0 | 0.00 | Sun Valley CoS | 5 | 0.03 | -0.01 | 14 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191799 | 191799 | 161.0 | CANYON CEL | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 1 | 0.23 | -0.69 | West LA CoS | 16 | 0.15 | 0.02 | 65 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191800 | 191800 | 162.0 | CAPISTRANO AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191801 | 191801 | 163.0 | CARDENAS EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 14 | 0.08 | -0.02 | 51 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191802 | 191802 | 164.0 | CARLSON HOSPITAL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 19 | 0.14 | 0.0 | 61 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191803 | 191803 | 165.0 | CARNEGIE MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191804 | 191804 | 166.0 | CAROLDALE LC | OPEN | green | 2 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 2 | 0.26 | 0.13 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191805 | 191805 | 167.0 | CARPENTER COMM CHTR | OPEN | green | 3 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 32 | 2 | 0.21 | -0.21 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | 0.0 | 61 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191806 | 191806 | 168.0 | CARSON ACAD ED & EMP | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.18 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191807 | 191807 | 169.0 | CARSON ACAD MED ARTS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191808 | 191808 | 170.0 | CARSON SH | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.13 | 0.00 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191809 | 191809 | 171.0 | CARSON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 3 | 0 | 0.0 | -0.28 | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191810 | 191810 | 172.0 | CARSON-GORE ACADEMY | OPEN | green | 4 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 9 | 4 | 0.88 | 0.00 | LA Mid-City CoS | 6 | 0.07 | -0.02 | 18 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191811 | 191811 | 173.0 | CARTHAY EL ES MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | -0.04 | 12 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191812 | 191812 | 174.0 | CARVER MS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 4 | 0.03 | -0.03 | 14 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191813 | 191813 | 175.0 | CASTELAR ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191814 | 191814 | 176.0 | CASTELAR ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191815 | 191815 | 177.0 | CASTLE HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | -0.04 | 12 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191816 | 191816 | 178.0 | CASTLEBAY LN CHTR | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 0 | 0.0 | -0.46 | Kennedy/NAHS/VAAS CoS | 17 | 0.11 | -0.01 | 57 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191817 | 191817 | 179.0 | CASTRO MS | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 1 | 0.27 | 0.27 | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191818 | 191818 | 180.0 | CATSKILL AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 11 | 0.09 | -0.06 | 30 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191819 | 191819 | 181.0 | CDS AGGELER | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191820 | 191820 | 182.0 | CDS ALONZO | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 5 | 0.06 | -0.11 | 13 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191821 | 191821 | 183.0 | CDS JOHNSON | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 7 | 0.05 | -0.08 | 34 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191822 | 191822 | 184.0 | CDS JOHNSTON | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Harbor City/Lomita CoS | 5 | 0.06 | 0.01 | 9 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191823 | 191823 | 185.0 | CDS LONDON | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 14 | 0.08 | -0.02 | 51 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191824 | 191824 | 186.0 | CDS TRI-C | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191825 | 191825 | 187.0 | CDS WEST HOLLYWOOD | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Fairfax CoS | 9 | 0.1 | -0.03 | 45 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191826 | 191826 | 188.0 | CENTRAL HS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 4 | 0.04 | -0.04 | 8 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191827 | 191827 | 189.0 | CENTURY PARK EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 0 | 0.0 | -0.01 | 1 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191828 | 191828 | 190.0 | CHANDLER EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | -0.22 | Van Nuys/Valley Glen CoS | 14 | 0.08 | -0.02 | 51 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191829 | 191829 | 191.0 | CHAPMAN EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 4 | 1 | 0.24 | 0.00 | Gardena CoS | 9 | 0.09 | 0.01 | 12 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191830 | 191830 | 192.0 | CHARNOCK ROAD EL | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 7 | 0.08 | -0.04 | 12 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191831 | 191831 | 193.0 | CHASE ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 5 | 0.04 | 0.01 | 19 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191832 | 191832 | 194.0 | CHASE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 5 | 0.04 | 0.01 | 19 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191833 | 191833 | 195.0 | CHATSWORTH CHS | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 1 | 0 | 0.0 | 0.00 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191834 | 191834 | 196.0 | CHATSWORTH UP/CD MAG | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 4 | 1 | 0.24 | -0.24 | Canoga Park/ChatsworthCoS | 13 | 0.08 | -0.02 | 56 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191835 | 191835 | 197.0 | CHAVEZ EL | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 0 | 0.0 | -0.40 | Lincoln Heights/El SerenoCoS | 17 | 0.12 | -0.01 | 31 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191836 | 191836 | 198.0 | CHAVEZ LA ARTES MAG | OPEN | green | 1 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 2 | 2 | 0.55 | 0.27 | San Fernando Valley/SylmarCoS | 21 | 0.12 | 0.02 | 86 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM | |||||
191837 | 191837 | 199.0 | CHAVEZ LA ASE | OPEN | green | 0 | 0 | Past 7 days (10/17/2022 - 10/23/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 21 | 0.12 | 0.02 | 86 | 1,482 | 409 | 0.07 | -0.01 | 2022-10-24 | 01:34AM |
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 );