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-08-27 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182457 | 182457 | 797.0 | TRINITY ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 33 | 0.3 | -0.12 | 47 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182456 | 182456 | 796.0 | TRINITY EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 1.52 | 1.52 | SO Los Angeles CoS | 33 | 0.3 | -0.12 | 47 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182455 | 182455 | 795.0 | TOWNE AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.29 | -0.57 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182454 | 182454 | 794.0 | TORRES RENAISSANCE | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.71 | 0.53 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182453 | 182453 | 793.0 | TORRES HUM/ART/TECH | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.7 | -0.18 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182452 | 182452 | 792.0 | TORRES HS SJLA MAG | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182451 | 182451 | 791.0 | TORRES ENG & TECH | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.80 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182450 | 182450 | 790.0 | TORRES ELA PA MAG | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.58 | 0.20 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182449 | 182449 | 789.0 | TOPEKA DR CAS | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 6 | 0.9 | -0.15 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182448 | 182448 | 788.0 | TOPANGA EL CS | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 5 | 1.72 | 1.03 | West LA CoS | 49 | 0.41 | -0.16 | 83 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182447 | 182447 | 787.0 | TOLUCA LAKE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 3 | 0.5 | -0.16 | North Hollywood/ValleyVillage CoS | 113 | 0.76 | -0.14 | 216 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182446 | 182446 | 786.0 | TOLUCA LAKE EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 1.27 | 1.27 | North Hollywood/ValleyVillage CoS | 113 | 0.76 | -0.14 | 216 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182445 | 182445 | 785.0 | TOLAND WAY EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 1.38 | 1.03 | Eagle Rock/Highland ParkCoS | 131 | 1.09 | 0.18 | 195 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182444 | 182444 | 784.0 | THOREAU HS | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -2.11 | Taft CoS | 113 | 0.67 | -0.08 | 193 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182443 | 182443 | 783.0 | TELFAIR AVE EL | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 17 | 14 | 1.94 | 1.11 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182442 | 182442 | 782.0 | TELFAIR AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182441 | 182441 | 781.0 | TARZANA EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 76 | 0.59 | 0.04 | 95 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182440 | 182440 | 780.0 | TAPER AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 0.64 | -0.13 | San Pedro CoS | 53 | 0.41 | -0.11 | 103 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182439 | 182439 | 779.0 | TAFT CHS | OPEN | green | 16 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 13 | 0.43 | -0.34 | Taft CoS | 113 | 0.67 | -0.08 | 193 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182438 | 182438 | 778.0 | SYLVAN PARK EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 5 | 0.64 | 0.64 | Van Nuys/Valley Glen CoS | 123 | 0.61 | 0.02 | 199 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182437 | 182437 | 777.0 | SYLVAN PARK EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.96 | 0.00 | Van Nuys/Valley Glen CoS | 123 | 0.61 | 0.02 | 199 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182436 | 182436 | 776.0 | SYLMAR LDSHP ACAD | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.21 | -0.52 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182435 | 182435 | 775.0 | SYLMAR EL | OPEN | green | 20 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 20 | 18 | 3.37 | 2.25 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182434 | 182434 | 774.0 | SYLMAR CHS | OPEN | green | 15 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 13 | 0.62 | -0.24 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182433 | 182433 | 773.0 | SYLMAR ACAD BH/E MAG | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.65 | 0.65 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182432 | 182432 | 772.0 | SUTTER MS | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.37 | 0.09 | Cleveland CoS | 139 | 1.04 | 0.44 | 176 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182431 | 182431 | 771.0 | SUPERIOR ST EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 3 | 0.58 | 0.58 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182430 | 182430 | 770.0 | SUNRISE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.21 | -0.22 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182429 | 182429 | 769.0 | SUNNY BRAE AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.35 | 0.18 | Cleveland CoS | 139 | 1.04 | 0.44 | 176 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182428 | 182428 | 768.0 | SUNLAND EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.27 | -0.26 | Sunland/Tujunga CoS | 57 | 1.1 | 0.6 | 105 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182427 | 182427 | 767.0 | SUN VALLEY MAG ET | OPEN | green | 11 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 9 | 0.6 | 0.20 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182426 | 182426 | 766.0 | STRATHERN ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 6 | 1.08 | -1.07 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182425 | 182425 | 765.0 | STONEY POINT HS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.63 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182424 | 182424 | 764.0 | STONER AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.84 | 0.84 | Venice CoS | 47 | 0.45 | -0.31 | 88 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182423 | 182423 | 763.0 | STONEHURST STEAM MAG | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.3 | 0.00 | Sunland/Tujunga CoS | 57 | 1.1 | 0.6 | 105 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182422 | 182422 | 762.0 | STEVENSON CCP | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 11 | 7 | 0.63 | 0.00 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182421 | 182421 | 761.0 | STERRY EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 49 | 0.41 | -0.16 | 83 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182420 | 182420 | 760.0 | STATE ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.63 | 0.21 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182419 | 182419 | 759.0 | STATE ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.9 | 0.90 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182418 | 182418 | 758.0 | STANFORD AVE PC | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.78 | -0.39 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182417 | 182417 | 757.0 | STANFORD AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.86 | 0.64 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182416 | 182416 | 756.0 | STAGG ST EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 6 | 1.05 | 0.00 | Cleveland CoS | 139 | 1.04 | 0.44 | 176 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182415 | 182415 | 755.0 | SOUTHEAST MS | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 10 | 7 | 0.52 | -0.15 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182414 | 182414 | 754.0 | SOUTH SHORES EL PA MG | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.2 | -0.58 | San Pedro CoS | 53 | 0.41 | -0.11 | 103 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182413 | 182413 | 753.0 | SOUTH PARK EL | OPEN | green | 17 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 17 | 16 | 1.49 | 1.03 | Fremont CoS | 76 | 0.49 | 0.13 | 95 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182412 | 182412 | 752.0 | SOUTH GATE SH | OPEN | green | 15 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 21 | 14 | 0.55 | -0.04 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182411 | 182411 | 751.0 | SOUTH GATE MS | OPEN | green | 15 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 26 | 16 | 1.02 | 0.00 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182410 | 182410 | 750.0 | SOUTH EAST SH | OPEN | green | 13 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 16 | 11 | 0.41 | -0.03 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182409 | 182409 | 749.0 | SOTOMAYOR ART/SCI MAG | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.54 | 0.54 | Glassell Park/Los Feliz CoS | 103 | 0.84 | 0.17 | 146 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182408 | 182408 | 748.0 | SOTO ST EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 16 | 8 | 3.11 | 0.39 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182407 | 182407 | 747.0 | SOLIS LA | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.3 | -0.60 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182406 | 182406 | 746.0 | SOLANO AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 4 | 1.77 | 0.44 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182405 | 182405 | 745.0 | SOCES MAG | OPEN | yellow | 14 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 20 | 15 | 0.67 | -0.09 | Reseda CoS | 76 | 0.59 | 0.04 | 95 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182404 | 182404 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182403 | 182403 | 743.0 | SIERRA VISTA EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 1.3 | 0.87 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182402 | 182402 | 742.0 | SIERRA PARK EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.26 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182401 | 182401 | 741.0 | SHORT AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 8 | 3 | 0.64 | -0.21 | Venice CoS | 47 | 0.45 | -0.31 | 88 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182400 | 182400 | 740.0 | SHIRLEY AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 76 | 0.59 | 0.04 | 95 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182399 | 182399 | 739.0 | SHERMAN OAKS EL CS | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 6 | 0.96 | 0.64 | Van Nuys/Valley Glen CoS | 123 | 0.61 | 0.02 | 199 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182398 | 182398 | 738.0 | SHERIDAN ST EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.43 | -0.44 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182397 | 182397 | 737.0 | SHENANDOAH ST EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 16 | 7 | 1.87 | -0.54 | Hamilton CoS | 74 | 0.8 | 0.02 | 112 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182396 | 182396 | 736.0 | SHENANDOAH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 74 | 0.8 | 0.02 | 112 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182395 | 182395 | 735.0 | SHARP AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 1 | 0.17 | 0.00 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182394 | 182394 | 734.0 | SERRANIA AVE CES | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 8 | 7 | 1.07 | 0.76 | Taft CoS | 113 | 0.67 | -0.08 | 193 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182393 | 182393 | 733.0 | SEPULVEDA MS | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 0.4 | -0.64 | Monroe CoS | 88 | 0.62 | -0.1 | 117 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182392 | 182392 | 732.0 | SENDAK EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 0.86 | 0.21 | North Hollywood/ValleyVillage CoS | 113 | 0.76 | -0.14 | 216 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182391 | 182391 | 731.0 | SELMA AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 52 | 0.6 | 0.07 | 66 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182390 | 182390 | 730.0 | SECONDARY CDS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 28 | 0.33 | 0.04 | 38 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182389 | 182389 | 729.0 | SCIENCE AC STEM MAG | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.18 | North Hollywood/ValleyVillage CoS | 113 | 0.76 | -0.14 | 216 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182388 | 182388 | 728.0 | SATURN ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 0 | 0.0 | -1.76 | Fairfax CoS | 68 | 0.67 | 0.04 | 94 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182387 | 182387 | 727.0 | SATICOY EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.48 | -0.79 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182386 | 182386 | 726.0 | SANTEE EC | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.17 | -0.13 | SO Los Angeles CoS | 33 | 0.3 | -0.12 | 47 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182385 | 182385 | 725.0 | SANTANA ART AC | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.88 | 0.66 | Monroe CoS | 88 | 0.62 | -0.1 | 117 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182384 | 182384 | 724.0 | SAN PEDRO ST EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.17 | -0.35 | SO Los Angeles CoS | 33 | 0.3 | -0.12 | 47 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182383 | 182383 | 723.0 | SAN PEDRO SH | OPEN | green | 13 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 18 | 11 | 0.31 | -0.23 | San Pedro CoS | 53 | 0.41 | -0.11 | 103 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182382 | 182382 | 722.0 | SAN PEDRO CAS EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 53 | 0.41 | -0.11 | 103 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182381 | 182381 | 721.0 | SAN PASCUAL STEAM MG | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.7 | 0.00 | Eagle Rock/Highland ParkCoS | 131 | 1.09 | 0.18 | 195 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182380 | 182380 | 720.0 | SAN MIGUEL EL | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 11 | 7 | 0.81 | -0.23 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182379 | 182379 | 719.0 | SAN JOSE ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.54 | -0.27 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182378 | 182378 | 718.0 | SAN GABRIEL AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 4 | 0.68 | 0.34 | South Gate CoS | 147 | 0.79 | 0.14 | 223 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182377 | 182377 | 717.0 | SAN FERNANDO SH | OPEN | green | 17 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 22 | 20 | 0.81 | 0.28 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182376 | 182376 | 716.0 | SAN FERNANDO MS IAM | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.5 | -0.50 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182375 | 182375 | 715.0 | SAN FERNANDO MS | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.16 | -1.14 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182374 | 182374 | 714.0 | SAN FERNANDO EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.17 | -0.50 | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182373 | 182373 | 713.0 | SAN FERNANDO EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 173 | 0.88 | 0.15 | 231 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182372 | 182372 | 712.0 | SAN ANTONIO HS | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 1.5 | 0.75 | Huntington Park/VernonCoS | 149 | 0.96 | 0.24 | 213 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182371 | 182371 | 711.0 | SAN ANTONIO EL | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 23 | 10 | 1.74 | 0.52 | Huntington Park/VernonCoS | 149 | 0.96 | 0.24 | 213 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182370 | 182370 | 710.0 | SALVIN SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 88 | 0.76 | 0.14 | 117 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182369 | 182369 | 709.0 | RUSSELL EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 3 | 0.32 | 0.00 | Rivera CoS | 80 | 0.5 | 0.09 | 107 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182368 | 182368 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 10 | 8 | 1.39 | 0.70 | Huntington Park/VernonCoS | 149 | 0.96 | 0.24 | 213 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182367 | 182367 | 707.0 | ROYBAL LC | OPEN | green | 13 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 20 | 15 | 1.05 | 0.35 | Downtown CoS | 111 | 0.94 | 0.42 | 135 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182366 | 182366 | 706.0 | ROWAN AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 4 | 0.48 | -0.37 | East Los Angeles CoS | 115 | 0.72 | 0.08 | 165 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182365 | 182365 | 705.0 | ROSEWOOD UP/UD MAG | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 0 | 0.0 | -1.00 | Fairfax CoS | 68 | 0.67 | 0.04 | 94 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182364 | 182364 | 704.0 | ROSEMONT AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 1.48 | 1.11 | Downtown CoS | 111 | 0.94 | 0.42 | 135 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182363 | 182363 | 703.0 | ROSEMONT AVE EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 111 | 0.94 | 0.42 | 135 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182362 | 182362 | 702.0 | ROSCOMARE RD EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 49 | 0.41 | -0.16 | 83 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182361 | 182361 | 701.0 | ROSCOE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 0 | 0.0 | -0.64 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182360 | 182360 | 700.0 | ROOSEVELT SH STM MAG | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.15 | -0.43 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182359 | 182359 | 699.0 | ROOSEVELT SH | OPEN | green | 22 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 26 | 22 | 0.97 | 0.48 | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182358 | 182358 | 698.0 | ROOSEVELT INFANT | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 106 | 0.8 | 0.18 | 143 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM |
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 );