home / la-times

Menu
  • GraphQL API

lausd-cases

Table actions
  • GraphQL API for lausd-cases

The number of coronavirus cases detected at L.A. Unified schools. Updates daily via a scraper that pulls from the district's dashboard.

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.

168,955 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid ▼ school status staff_student transmission staff_student_rate community_rate lac_rate community_schools community date time Unnamed: 0 color 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
101 101 BEACHY AVE EL OPEN 6 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
102 102 BECKFORD CES OPEN 0 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
103 103 BEETHOVEN ST EL OPEN 0 0 23.66 23.59 31.39 Venice Community of Schools Venice Community 2021-08-26 10:00PM                                
104 104 BELL SH OPEN 19 0 26.02 32.75 31.39 Bell/Cudahy/Maywood Community of Schools Bell/Cudahy/Maywood Community 2021-08-26 10:00PM                                
105 105 BELLINGHAM EL OPEN 2 0 30.98 32.61 31.39 North Hollywood/Valley Village Community of Sc… North Hollywood/Valley Village Community 2021-08-26 10:00PM                                
106 106 BELMONT SH OPEN 1 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
107 107 BELVEDERE EL OPEN 1 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
108 108 BELVEDERE MS OPEN 5 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
109 109 BERENDO MS OPEN 2 0 23.53 18.29 31.39 Kreatwn/PcoUnion Community of Schools Koreatown/Pico Union Community 2021-08-26 10:00PM                                
110 110 BERNSTEIN SH OPEN 7 0 40.45 30.8 31.39 Hollywood Community of Schools Hollywood Community 2021-08-26 10:00PM                                
111 111 BERNSTEIN SH STEM OPEN 4 0 40.45 30.8 31.39 Hollywood Community of Schools Hollywood Community 2021-08-26 10:00PM                                
112 112 BERTRAND AVE EL OPEN 6 0 42.46 34.23 31.39 Reseda Community of Schools Reseda Community 2021-08-26 10:00PM                                
113 113 BETHUNE MS OPEN 12 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
114 114 BIRMINGHAM CHS OPEN 0 0 0.0 0.0 31.39 Community of Schools Community 2021-08-26 10:00PM                                
115 115 BLYTHE ST EL OPEN 2 0 31.87 32.27 31.39 Cleveland Community of Schools Northridge/Reseda Community 2021-08-26 10:00PM                                
116 116 BONITA ST EL OPEN 4 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
117 117 BOYLE HEIGHTS HS OPEN 0 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
118 118 BOYLE HTS STEM MAG OPEN 0 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
119 119 BRADDOCK DR EL OPEN 1 0 23.66 23.59 31.39 Venice Community of Schools Venice Community 2021-08-26 10:00PM                                
120 120 BRADLEY EEC OPEN 0 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                                
121 121 BRADLEY GLBL AWR MAG OPEN 4 0 44.85 40.16 31.39 H.E.E.T. (C/D) Community of Schools Baldwin Hills/Leimert Park Community 2021-08-26 10:00PM                                
122 122 BRAINARD EL OPEN 2 0 49.46 36.32 31.39 Sunland/Tujunga Community of Schools Sunland/Tujunga Community 2021-08-26 10:00PM                                
123 123 BRAVO SH MEDICAL MAG OPEN 5 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                                
124 124 BREED ST EL OPEN 2 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
125 125 BRENTWOOD EL SCI MAG OPEN 2 0 42.8 22.53 31.39 West LA Community of Schools West LA Community 2021-08-26 10:00PM                                
126 126 BRIDGE ST EL OPEN 0 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                                
127 127 BRIDGES SCHOOL OPEN 4 0 55.08 40.32 31.39 Wilmington Community of Schools Wilmington Community 2021-08-26 10:00PM                                
128 128 BRIGHT EL OPEN 2 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
129 129 BROAD AVE EL OPEN 6 0 55.08 40.32 31.39 Wilmington Community of Schools Wilmington Community 2021-08-26 10:00PM                                
130 130 BROADACRES AV EL OPEN 5 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
131 131 BROADOUS EEC OPEN 0 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                
132 132 BROADOUS EL OPEN 5 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                
133 133 BROADWAY EL OPEN 2 0 23.66 23.59 31.39 Venice Community of Schools Venice Community 2021-08-26 10:00PM                                
134 134 BROCKTON AVE EL OPEN 1 0 42.8 22.53 31.39 West LA Community of Schools West LA Community 2021-08-26 10:00PM                                
135 135 BROOKLYN AVE EEC OPEN 0 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
136 136 BROOKLYN AVE EL OPEN 1 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                                
137 137 BRYSON AVE EL OPEN 6 0 31.97 34.54 31.39 South Gate Community of Schools South Gate Community 2021-08-26 10:00PM                                
138 138 BUCHANAN ST EL OPEN 0 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
139 139 BUDLONG AVE EL OPEN 5 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                                
140 140 BURBANK BLVD EL OPEN 2 0 30.98 32.61 31.39 North Hollywood/Valley Village Community of Sc… North Hollywood/Valley Village Community 2021-08-26 10:00PM                                
141 141 BURBANK MS A/T/C MAG OPEN 6 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
142 142 BURKE HS OPEN 1 0 35.94 27.85 31.39 Panorama City Community of Schools Panorama City Community 2021-08-26 10:00PM                                
143 143 BURROUGHS MS OPEN 18 0 12.79 27.86 31.39 Fairfax Community of Schools Fairfax Community 2021-08-26 10:00PM                                
144 144 BURTON ST EL OPEN 2 0 35.94 27.85 31.39 Panorama City Community of Schools Panorama City Community 2021-08-26 10:00PM                                
145 145 BUSHNELL WAY EL OPEN 0 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                                
146 146 BYRD MS OPEN 6 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
147 147 CABRILLO AVE EEC OPEN 0 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
148 148 CABRILLO AVE EL OPEN 10 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                                
149 149 CAHUENGA EL OPEN 3 0 23.53 18.29 31.39 Kreatwn/PcoUnion Community of Schools Koreatown/Pico Union Community 2021-08-26 10:00PM                                
150 150 CALABASH CA OPEN 9 0 41.81 33.13 31.39 Taft Community of Schools Woodland Hills Community 2021-08-26 10:00PM                                
151 151 CALAHAN ST EL OPEN 2 0 31.87 32.27 31.39 Cleveland Community of Schools Northridge/Reseda Community 2021-08-26 10:00PM                                
152 152 CALVERT CES OPEN 3 0 41.81 33.13 31.39 Taft Community of Schools Woodland Hills Community 2021-08-26 10:00PM                                
153 153 CAMELLIA AVE EL OPEN 2 0 30.98 32.61 31.39 North Hollywood/Valley Village Community of Sc… North Hollywood/Valley Village Community 2021-08-26 10:00PM                                
154 154 CANFIELD AVE EL OPEN 4 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                                
155 155 CANOGA PARK EEC OPEN 0 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
156 156 CANOGA PARK EL OPEN 3 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
157 157 CANOGA PRK SH OPEN 6 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
158 158 CANTARA ST EL OPEN 2 0 31.87 32.27 31.39 Cleveland Community of Schools Northridge/Reseda Community 2021-08-26 10:00PM                                
159 159 CANTERBURY AVE EL OPEN 9 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                                
160 160 CANYON CEL OPEN 6 0 42.8 22.53 31.39 West LA Community of Schools West LA Community 2021-08-26 10:00PM                                
161 161 CAPISTRANO AVE EL OPEN 3 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
162 162 CARDENAS EL OPEN 4 0 25.11 33.53 31.39 Van Nuys/Valley Glen Community of Schools Van Nuys/Valley Glen Community 2021-08-26 10:00PM                                
163 163 CARLSON HOSPITAL OPEN 0 0 30.98 32.61 31.39 North Hollywood/Valley Village Community of Sc… North Hollywood/Valley Village Community 2021-08-26 10:00PM                                
164 164 CARNEGIE MS OPEN 7 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
165 165 CAROLDALE LC OPEN 2 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
166 166 CARPENTER COMM CHTR OPEN 5 0 30.98 32.61 31.39 North Hollywood/Valley Village Community of Sc… North Hollywood/Valley Village Community 2021-08-26 10:00PM                                
167 167 CARSON ACAD ED & EMP OPEN 3 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
168 168 CARSON ACAD MED ARTS OPEN 3 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
169 169 CARSON SH OPEN 13 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
170 170 CARSON ST EL OPEN 8 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
171 171 CARSON-GORE ACADEMY OPEN 4 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                                
172 172 CARTHAY EL ES MAG OPEN 2 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                                
173 173 CARVER MS OPEN 2 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                                
174 174 CASTELAR ST EEC OPEN 0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
175 175 CASTELAR ST EL OPEN 0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
176 176 CASTLE HTS EL OPEN 1 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                                
177 177 CASTLEBAY LN CHTR OPEN 4 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                                
178 178 CASTRO MS OPEN 0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
179 179 CATSKILL AVE EL OPEN 3 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                                
180 180 CDS AGGELER OPEN 0 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
181 181 CDS ALONZO OPEN 0 0 40.45 30.8 31.39 Hollywood Community of Schools Hollywood Community 2021-08-26 10:00PM                                
182 182 CDS JOHNSON OPEN 0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                                
183 183 CDS JOHNSTON OPEN 2 0 66.87 22.92 31.39 Harbor City/Lomita Community of Schools Harbor City/Lomita Community 2021-08-26 10:00PM                                
184 184 CDS LONDON OPEN 1 0 25.11 33.53 31.39 Van Nuys/Valley Glen Community of Schools Van Nuys/Valley Glen Community 2021-08-26 10:00PM                                
185 185 CDS TRI-C OPEN 0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
186 186 CDS WEST HOLLYWOOD OPEN 0 0 12.79 27.86 31.39 Fairfax Community of Schools Fairfax Community 2021-08-26 10:00PM                                
187 187 CENTRAL HS OPEN 2 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                                
188 188 CENTURY PARK EL OPEN 4 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                                
189 189 CHANDLER EL OPEN 1 0 25.11 33.53 31.39 Van Nuys/Valley Glen Community of Schools Van Nuys/Valley Glen Community 2021-08-26 10:00PM                                
190 190 CHAPMAN EL OPEN 1 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                                
191 191 CHARNOCK ROAD EL OPEN 1 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                                
192 192 CHASE ST EEC OPEN 1 0 45.59 36.92 31.39 Monroe Community of Schools North Hills/Panorama City Community 2021-08-26 10:00PM                                
193 193 CHASE ST EL OPEN 2 0 45.59 36.92 31.39 Monroe Community of Schools North Hills/Panorama City Community 2021-08-26 10:00PM                                
194 194 CHATSWORTH CHS OPEN 8 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
195 195 CHATSWORTH UP/CD MAG OPEN 2 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                                
196 196 CHAVEZ EL OPEN 0 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                                
197 197 CHAVEZ LA ARTES MAG OPEN 2 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                
198 198 CHAVEZ LA ASE OPEN 4 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                
199 199 CHAVEZ LA SJ HUM AC OPEN 3 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                
200 200 CHAVEZ LA TECH PREP OPEN 5 0 40.61 41.58 31.39 San Fernando Valley/Sylmar Communit… San Fernando Valley/Sylmar Community 2021-08-26 10:00PM                                

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "lausd-cases" (
   [school] TEXT,
   [status] TEXT,
   [staff_student] INTEGER,
   [transmission] INTEGER,
   [staff_student_rate] FLOAT,
   [community_rate] FLOAT,
   [lac_rate] FLOAT,
   [community_schools] TEXT,
   [community] TEXT,
   [date] TEXT,
   [time] TEXT,
   [Unnamed: 0] FLOAT,
   [color] TEXT,
   [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] FLOAT,
   [lausd_change] FLOAT
);
Powered by Datasette · Queries took 56.193ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README