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)

Suggested facets: date (date)

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