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.
224,963 rows sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2022-01-28 1,316
- 2022-01-31 1,313
- 2022-08-14 898
- 2022-08-15 898
- 2022-08-16 898
- 2022-08-17 898
- 2022-08-26 898
- 2022-08-27 898
- 2022-08-28 898
- 2022-08-29 898
- 2022-08-30 898
- 2022-08-31 898
- 2022-09-01 898
- 2022-09-02 898
- 2022-10-16 898
- 2022-10-21 898
- 2022-10-22 898
- 2022-10-23 898
- 2022-10-24 898
- 2022-10-26 898
- 2022-10-27 898
- 2022-10-28 898
- 2022-10-29 898
- 2022-10-30 898
- 2022-10-31 898
- 2022-11-01 898
- 2022-11-02 898
- 2022-11-04 898
- 2022-11-06 898
- 2022-11-09 898
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
224863 | 224863 | 797.0 | TRINITY ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224862 | 224862 | 796.0 | TRINITY EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224861 | 224861 | 795.0 | TOWNE AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 2 | 0.02 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224860 | 224860 | 794.0 | TORRES RENAISSANCE | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224859 | 224859 | 793.0 | TORRES HUM/ART/TECH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224858 | 224858 | 792.0 | TORRES HS SJLA MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224857 | 224857 | 791.0 | TORRES ENG & TECH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224856 | 224856 | 790.0 | TORRES ELA PA MAG | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 1 | 0.25 | 0.25 | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224855 | 224855 | 789.0 | TOPEKA DR CAS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 2 | 0.01 | -0.18 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224854 | 224854 | 788.0 | TOPANGA EL CS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224853 | 224853 | 787.0 | TOLUCA LAKE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 1 | 0.01 | -0.14 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224852 | 224852 | 786.0 | TOLUCA LAKE EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 1 | 0.01 | -0.14 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224851 | 224851 | 785.0 | TOLAND WAY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224850 | 224850 | 784.0 | THOREAU HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224849 | 224849 | 783.0 | TELFAIR AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224848 | 224848 | 782.0 | TELFAIR AVE EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224847 | 224847 | 781.0 | TARZANA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224846 | 224846 | 780.0 | TAPER AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224845 | 224845 | 779.0 | TAFT CHS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224844 | 224844 | 778.0 | SYLVAN PARK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 2 | 0 | 0.0 | -0.51 | Van Nuys/Valley Glen CoS | 0 | 0.0 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224843 | 224843 | 777.0 | SYLVAN PARK EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 0 | 0.0 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224842 | 224842 | 776.0 | SYLMAR LDSHP ACAD | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224841 | 224841 | 775.0 | SYLMAR EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224840 | 224840 | 774.0 | SYLMAR CHS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224839 | 224839 | 773.0 | SYLMAR ACAD BH/E MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224838 | 224838 | 772.0 | SUTTER MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 2 | 0.02 | -0.08 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224837 | 224837 | 771.0 | SUPERIOR ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 2 | 0.01 | -0.18 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224836 | 224836 | 770.0 | SUNRISE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224835 | 224835 | 769.0 | SUNNY BRAE AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 2 | 0.02 | -0.08 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224834 | 224834 | 768.0 | SUNLAND EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224833 | 224833 | 767.0 | SUN VALLEY MAG ET | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224832 | 224832 | 766.0 | STRATHERN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224831 | 224831 | 765.0 | STONEY POINT HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 2 | 0.01 | -0.18 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224830 | 224830 | 764.0 | STONER AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224829 | 224829 | 763.0 | STONEHURST STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224828 | 224828 | 762.0 | STEVENSON CCP | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224827 | 224827 | 761.0 | STERRY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224826 | 224826 | 760.0 | STATE ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224825 | 224825 | 759.0 | STATE ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224824 | 224824 | 758.0 | STANFORD AVE PC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224823 | 224823 | 757.0 | STANFORD AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224822 | 224822 | 756.0 | STAGG ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 2 | 0.02 | -0.08 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224821 | 224821 | 755.0 | SOUTHEAST MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224820 | 224820 | 754.0 | SOUTH SHORES EL PA MG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224819 | 224819 | 753.0 | SOUTH PARK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 3 | 0.02 | -0.06 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224818 | 224818 | 752.0 | SOUTH GATE SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224817 | 224817 | 751.0 | SOUTH GATE MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | -0.07 | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224816 | 224816 | 750.0 | SOUTH EAST SH | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224815 | 224815 | 749.0 | SOTOMAYOR ART/SCI MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224814 | 224814 | 748.0 | SOTO ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224813 | 224813 | 747.0 | SOLIS LA | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224812 | 224812 | 746.0 | SOLANO AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224811 | 224811 | 745.0 | SOCES MAG | OPEN | yellow | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224810 | 224810 | 744.0 | SLAWSON OCC CTR | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.00 | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224809 | 224809 | 743.0 | SIERRA VISTA EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224808 | 224808 | 742.0 | SIERRA PARK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 4 | 0.03 | -0.11 | 5 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224807 | 224807 | 741.0 | SHORT AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Venice CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224806 | 224806 | 740.0 | SHIRLEY AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224805 | 224805 | 739.0 | SHERMAN OAKS EL CS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Van Nuys/Valley Glen CoS | 0 | 0.0 | -0.07 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224804 | 224804 | 738.0 | SHERIDAN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224803 | 224803 | 737.0 | SHENANDOAH ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224802 | 224802 | 736.0 | SHENANDOAH ST EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224801 | 224801 | 735.0 | SHARP AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224800 | 224800 | 734.0 | SERRANIA AVE CES | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224799 | 224799 | 733.0 | SEPULVEDA MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224798 | 224798 | 732.0 | SENDAK EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 1 | 0.01 | -0.14 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224797 | 224797 | 731.0 | SELMA AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 2 | 0.03 | -0.10 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224796 | 224796 | 730.0 | SECONDARY CDS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224795 | 224795 | 729.0 | SCIENCE AC STEM MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 1 | 0.01 | -0.14 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224794 | 224794 | 728.0 | SATURN ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fairfax CoS | 0 | 0.0 | -0.18 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224793 | 224793 | 727.0 | SATICOY EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224792 | 224792 | 726.0 | SANTEE EC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224791 | 224791 | 725.0 | SANTANA ART AC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Monroe CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224790 | 224790 | 724.0 | SAN PEDRO ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 0 | 0.0 | -0.09 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224789 | 224789 | 723.0 | SAN PEDRO SH | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224788 | 224788 | 722.0 | SAN PEDRO CAS EEC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 0 | 0.0 | -0.13 | 4 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224787 | 224787 | 721.0 | SAN PASCUAL STEAM MG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224786 | 224786 | 720.0 | SAN MIGUEL EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224785 | 224785 | 719.0 | SAN JOSE ST EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 2 | 0.01 | -0.18 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224784 | 224784 | 718.0 | SAN GABRIEL AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | South Gate CoS | 0 | 0.0 | -0.12 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224783 | 224783 | 717.0 | SAN FERNANDO SH | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224782 | 224782 | 716.0 | SAN FERNANDO MS IAM | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224781 | 224781 | 715.0 | SAN FERNANDO MS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224780 | 224780 | 714.0 | SAN FERNANDO EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224779 | 224779 | 713.0 | SAN FERNANDO EEC | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 1 | 0.68 | 0.68 | San Fernando Valley/SylmarCoS | 1 | 0.01 | -0.09 | 3 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224778 | 224778 | 712.0 | SAN ANTONIO HS | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 2 | 0.01 | -0.15 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224777 | 224777 | 711.0 | SAN ANTONIO EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 2 | 0.01 | -0.15 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224776 | 224776 | 710.0 | SALVIN SP ED CTR | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224775 | 224775 | 709.0 | RUSSELL EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | (Blank) | 0 | 0.0 | (Blank) | 0 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224774 | 224774 | 708.0 | ROYBAL-ALLARD EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Huntington Park/VernonCoS | 2 | 0.01 | -0.15 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224773 | 224773 | 707.0 | ROYBAL LC | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224772 | 224772 | 706.0 | ROWAN AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 2 | 0.01 | -0.19 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224771 | 224771 | 705.0 | ROSEWOOD UP/UD MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Fairfax CoS | 0 | 0.0 | -0.18 | 2 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224770 | 224770 | 704.0 | ROSEMONT AVE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | 0.00 | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224769 | 224769 | 703.0 | ROSEMONT AVE EEC | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224768 | 224768 | 702.0 | ROSCOMARE RD EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 0 | 0.0 | -0.10 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224767 | 224767 | 701.0 | ROSCOE EL | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224766 | 224766 | 700.0 | ROOSEVELT SH STM MAG | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224765 | 224765 | 699.0 | ROOSEVELT SH | OPEN | green | 1 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 1 | 0 | 0.0 | -0.16 | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM | |||||
224764 | 224764 | 698.0 | ROOSEVELT INFANT | OPEN | green | 0 | 0 | Past 7 days (12/21/2022 - 12/27/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 0 | 0.0 | -0.15 | 1 | 225 | 69 | 0.01 | -0.1 | 2022-12-29 | 01:42AM |
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 );