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.

224,963 rows

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Queries took 85.142ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README