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.

180,761 rows

✎ View and edit SQL

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

Suggested facets: date (date)

Link rowid ▼ Unnamed: 0 school status color staff_student transmission staff_student_rate community_rate lac_rate community_schools community date time 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
1 1   102ND ST EEC OPEN   1 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
2 2   107TH ST EL OPEN   3 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
3 3   109TH ST EL OPEN   0 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
4 4   10TH ST EL OPEN   6 0 35.42 27.58 31.39 MacArthur Park Community of Schools MacArthur Park Community 2021-08-26 10:00PM                            
5 5   112TH ST EEC OPEN   0 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
6 6   112TH ST EL OPEN   1 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
7 7   116TH ST EL OPEN   3 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
8 8   118TH ST EL OPEN   5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
9 9   122ND ST EL OPEN   5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
10 10   135TH ST EL OPEN   1 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
11 11   153RD ST EL OPEN   2 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
12 12   156TH ST EL OPEN   4 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
13 13   15TH ST EL OPEN   3 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                            
14 14   186TH ST EL OPEN   3 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
15 15   1ST ST EL OPEN   2 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                            
16 16   20TH ST EL OPEN   3 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                            
17 17   232ND PL EL OPEN   4 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                            
18 18   24TH ST EEC OPEN   0 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                            
19 19   24TH ST EL OPEN   7 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                            
20 20   28TH ST EEC OPEN   0 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                            
21 21   28TH ST EL OPEN   2 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                            
22 22   2ND ST EL OPEN   3 0 23.43 52.41 31.39 Boyle Heights Community of Schools Boyle Heights Community 2021-08-26 10:00PM                            
23 23   32ND ST USC PA MAG OPEN   3 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                            
24 24   36TH ST EEC OPEN   0 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                            
25 25   37TH ST EEC OPEN   0 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                            
26 26   3RD ST EL OPEN   2 0 12.79 27.86 31.39 Fairfax Community of Schools Fairfax Community 2021-08-26 10:00PM                            
27 27   42ND ST EL OPEN   6 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                            
28 28   49TH ST EL OPEN   5 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                            
29 29   4TH ST 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                            
30 30   4TH ST 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                            
31 31   4TH ST PC OPEN   1 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                            
32 32   52ND ST 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                            
33 33   54TH ST EL OPEN   1 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                            
34 34   59TH ST EL OPEN   3 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                            
35 35   61ST ST 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                            
36 36   66TH ST EEC OPEN   0 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                            
37 37   66TH ST EL OPEN   4 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                            
38 38   6TH AVE EL OPEN   5 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                            
39 39   74TH ST EL 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                            
40 40   75TH ST EEC OPEN   0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
41 41   75TH ST EL OPEN   5 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
42 42   7TH ST EL AI MAG OPEN   1 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                            
43 43   92ND ST EL OPEN   6 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
44 44   93RD ST EL OPEN   1 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
45 45   95TH ST EEC OPEN   0 0 36.75 34.73 31.39 H.E.E.T. (W) Community of Schools Westmont/West Athens Community 2021-08-26 10:00PM                            
46 46   95TH ST EL OPEN   2 0 36.75 34.73 31.39 H.E.E.T. (W) Community of Schools Westmont/West Athens Community 2021-08-26 10:00PM                            
47 47   96TH ST EL OPEN   1 0 27.2 42.74 31.39 Achievement Network Community of Schools Watts/Green Meadows Community 2021-08-26 10:00PM                            
48 48   97TH ST EEC OPEN   0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
49 49   99TH ST EL OPEN   6 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
50 50   9TH ST EL OPEN   1 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                            
51 51   ACAD ENRICH SCI MAG OPEN   2 0 42.46 34.23 31.39 Reseda Community of Schools Reseda Community 2021-08-26 10:00PM                            
52 52   ADAMS MS OPEN   4 0 31.3 26.85 31.39 Jefferson/South Central (West) Community of Sc… Jefferson/South Central (West) Community 2021-08-26 10:00PM                            
53 53   ADDAMS HS OPEN   1 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                            
54 54   AGGELER HS OPEN   0 0 30.49 32.87 31.39 Canoga Park/Chatsworth Community of Schools Canoga Park/Chatsworth Community 2021-08-26 10:00PM                            
55 55   ALBION ST EEC 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                            
56 56   ALBION ST EL OPEN   2 0 17.02 24.9 31.39 Lincoln Heights/El Sereno Community of Sc… Lincoln Heights/El Sereno Community 2021-08-26 10:00PM                            
57 57   ALDAMA EL OPEN   1 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                            
58 58   ALEXANDER SCS OPEN   5 0 31.15 30.97 31.39 Manual Arts/Vermont Square Community of Sc… Manual Arts/Vermont Square Community 2021-08-26 10:00PM                            
59 59   ALEXANDRIA AVE EEC OPEN   0 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                            
60 60   ALEXANDRIA AVE EL OPEN   4 0 20.93 27.52 31.39 Downtown Community of Schools Downtown Community 2021-08-26 10:00PM                            
61 61   ALLESANDRO EL OPEN   3 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                            
62 62   ALTA CALIFORNIA EL OPEN   5 0 45.59 36.92 31.39 Monroe Community of Schools North Hills/Panorama City Community 2021-08-26 10:00PM                            
63 63   ALTA LOMA EL OPEN   4 0 27.47 28.96 31.39 LA Mid-City Community of Schools LA Mid-City Community 2021-08-26 10:00PM                            
64 64   AMANECER PC OPEN   2 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                            
65 65   AMBLER AVE EL OPEN   5 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                            
66 66   AMESTOY EL OPEN   5 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
67 67   ANATOLA AVE EL OPEN   3 0 31.87 32.27 31.39 Cleveland Community of Schools Northridge/Reseda Community 2021-08-26 10:00PM                            
68 68   ANDASOL AVE EL OPEN   5 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                            
69 69   ANGEL'S GATE HS OPEN   0 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                            
70 70   ANGELES MESA 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                            
71 71   ANGELOU COMMUNITY SH OPEN   4 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                            
72 72   ANN ST 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                            
73 73   ANNALEE AVE EL OPEN   3 0 56.05 32.0 31.39 Carson Community of Schools Carson Community 2021-08-26 10:00PM                            
74 74   ANNANDALE 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                            
75 75   ANTON 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                            
76 76   ANTON EL OPEN   3 0 19.92 30.53 31.39 East Los Angeles Community of Schools East Los Angeles Community 2021-08-26 10:00PM                            
77 77   APPERSON ST EL OPEN   3 0 49.46 36.32 31.39 Sunland/Tujunga Community of Schools Sunland/Tujunga Community 2021-08-26 10:00PM                            
78 78   ARAGON AVE EL OPEN   1 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                            
79 79   ARLETA SH OPEN   4 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                            
80 80   ARLINGTON HTS 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                            
81 81   ARMINTA ST EEC OPEN   0 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                            
82 82   ARMINTA ST EL OPEN   0 0 30.5 29.65 31.39 Sun Valley Community of Schools Sun Valley Community 2021-08-26 10:00PM                            
83 83   ARROYO SECO MUS/S MAG OPEN   2 0 26.55 23.38 31.39 Eagle Rock/Highland Park Community of Scho… Eagle Rock/Highland Park Community 2021-08-26 10:00PM                            
84 84   ASCOT AVE EL 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                            
85 85   ATWATER AVE EL OPEN   1 0 21.41 27.33 31.39 Glassell Park/Los Feliz Community of Schools Glassell Park/Los Feliz Community 2021-08-26 10:00PM                            
86 86   AUDUBON MS OPEN   3 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                            
87 87   AURORA EL OPEN   5 0 30.1 37.5 31.39 Historic Central Avenue Community of Schools Jefferson/South Central (East) Community 2021-08-26 10:00PM                            
88 88   AVALON GARDENS EL OPEN   0 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
89 89   BACA ARTS ACAD OPEN   5 0 33.12 37.76 31.39 Rivera Community of Schools Florence-Firestone/Watts Community 2021-08-26 10:00PM                            
90 90   BAKEWELL PC OPEN   0 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
91 91   BALA OPEN   1 0 49.08 45.08 31.39 South Mid-City Community of Schools South Mid-City Community 2021-08-26 10:00PM                            
92 92   BALBOA EL G/HG/HA MAG OPEN   7 0 60.22 34.5 31.39 Kennedy/NAHS/VAAS Community of Schools Granada Hills/Northridge Community 2021-08-26 10:00PM                            
93 93   BALDWIN HILLS EL OPEN   3 0 26.44 23.49 31.39 Hamilton Community of Schools Castle Heights Community 2021-08-26 10:00PM                            
94 94   BANCROFT MS OPEN   2 0 40.45 30.8 31.39 Hollywood Community of Schools Hollywood Community 2021-08-26 10:00PM                            
95 95   BANDINI ST EL OPEN   2 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                            
96 96   BANNEKER CTC OPEN   0 0 29.28 42.17 31.39 Gardena Community of Schools Gardena Community 2021-08-26 10:00PM                            
97 97   BANNING SH OPEN   33 0 55.08 40.32 31.39 Wilmington Community of Schools Wilmington Community 2021-08-26 10:00PM                            
98 98   BARRETT EL OPEN   3 0 37.7 40.25 31.39 Fremont Community of Schools South Los Angeles/Watts Community 2021-08-26 10:00PM                            
99 99   BARTON HILL EL OPEN   8 0 46.5 29.68 31.39 San Pedro Community of Schools San Pedro Community 2021-08-26 10:00PM                            
100 100   BASSETT ST EL OPEN   7 0 42.46 34.23 31.39 Reseda Community of Schools Reseda Community 2021-08-26 10:00PM                            

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,
   [staff_student_rate] FLOAT,
   [community_rate] FLOAT,
   [lac_rate] FLOAT,
   [community_schools] TEXT,
   [community] TEXT,
   [date] TEXT,
   [time] 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] TEXT,
   [lausd_change] FLOAT
);
Powered by Datasette · Queries took 2566.607ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README