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.

898 rows where "date" is on date 2022-11-09

✎ 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
201516 201516 0.0 107TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201517 201517 1.0 109TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201518 201518 2.0 10TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 3 0 0.0 0.00 MacArthur Park CoS 3 0.04 -0.04 10 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201519 201519 3.0 112TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201520 201520 4.0 112TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201521 201521 5.0 116TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201522 201522 6.0 118TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201523 201523 7.0 122ND ST EL OPEN green 3 0 Past 7 days (11/2/2022 - 11/8/2022) 6 2 0.29 0.00 Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201524 201524 8.0 135TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201525 201525 9.0 153RD ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201526 201526 10.0 156TH ST EL OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 2 2 0.5 0.50 Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201527 201527 11.0 15TH ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 3 2 0.43 0.43 San Pedro CoS 15 0.13 -0.01 47 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201528 201528 12.0 186TH ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.13 0.13 Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201529 201529 13.0 1ST ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Boyle Heights CoS 19 0.16 0.04 34 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201530 201530 14.0 20TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) SO Los Angeles CoS 3 0.03 -0.03 9 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201531 201531 15.0 232ND PL EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.21 0.21 Carson CoS 13 0.1 0.01 23 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201532 201532 16.0 24TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Manual Arts/VermontSquare CoS 12 0.11 0.0 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201533 201533 17.0 24TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Manual Arts/VermontSquare CoS 12 0.11 0.0 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201534 201534 18.0 28TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) SO Los Angeles CoS 3 0.03 -0.03 9 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201535 201535 19.0 28TH ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.17 0.00 SO Los Angeles CoS 3 0.03 -0.03 9 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201536 201536 20.0 2ND ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Boyle Heights CoS 19 0.16 0.04 34 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201537 201537 21.0 32ND ST USC PA MAG OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 2 1 0.1 -0.20 Manual Arts/VermontSquare CoS 12 0.11 0.0 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201538 201538 22.0 36TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201539 201539 23.0 37TH ST EEC OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 1.39 1.39 Manual Arts/VermontSquare CoS 12 0.11 0.0 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201540 201540 24.0 3RD ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Fairfax CoS 5 0.06 -0.01 54 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201541 201541 25.0 42ND ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) H.E.E.T. (C/D) CoS 2 0.04 -0.05 4 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201542 201542 26.0 49TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Historic Central Avenue CoS 19 0.16 0.03 27 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201543 201543 27.0 4TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201544 201544 28.0 4TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201545 201545 29.0 4TH ST PC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 3 1 0.45 0.45 East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201546 201546 30.0 52ND ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) South Mid-City CoS 6 0.08 0.03 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201547 201547 31.0 54TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201548 201548 32.0 59TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) H.E.E.T. (C/D) CoS 2 0.04 -0.05 4 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201549 201549 33.0 61ST ST EL OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 2 2 0.27 0.27 South Mid-City CoS 6 0.08 0.03 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201550 201550 34.0 66TH ST EEC OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Rivera CoS 13 0.09 0.02 17 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201551 201551 35.0 66TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Rivera CoS 13 0.09 0.02 17 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201552 201552 36.0 6TH AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201553 201553 37.0 74TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) H.E.E.T. (C/D) CoS 2 0.04 -0.05 4 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201554 201554 38.0 75TH ST EEC OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.79 0.79 Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201555 201555 39.0 75TH ST EL OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 3 3 0.34 0.34 Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201556 201556 40.0 7TH ST EL AI MAG OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) San Pedro CoS 15 0.13 -0.01 47 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201557 201557 41.0 92ND ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 2 2 0.26 0.26 Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201558 201558 42.0 93RD ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 3 0 0.0 -0.11 Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201559 201559 43.0 95TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) H.E.E.T. (W) CoS 2 0.04 0.04 3 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201560 201560 44.0 95TH ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.12 0.12 H.E.E.T. (W) CoS 2 0.04 0.04 3 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201561 201561 45.0 96TH ST EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.15 0.15 Achievement Network CoS 6 0.11 0.06 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201562 201562 46.0 97TH ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201563 201563 47.0 99TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201564 201564 48.0 9TH ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 2 0 0.0 0.00 SO Los Angeles CoS 3 0.03 -0.03 9 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201565 201565 49.0 ACAD ENRICH SCI MAG OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.29 0.29 Reseda CoS 10 0.09 -0.01 17 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201566 201566 50.0 ADAMS MS OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) SO Los Angeles CoS 3 0.03 -0.03 9 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201567 201567 51.0 ADDAMS HS OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Kennedy/NAHS/VAAS CoS 40 0.26 0.08 76 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201568 201568 52.0 AE VIRTUAL ACAD OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) - 0 0.0 0.0 0 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201569 201569 53.0 AGGELER HS OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 1.11 1.11 Canoga Park/ChatsworthCoS 24 0.15 0.05 49 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201570 201570 54.0 ALBION ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Lincoln Heights/El SerenoCoS 17 0.12 0.02 33 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201571 201571 55.0 ALBION ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Lincoln Heights/El SerenoCoS 17 0.12 0.02 33 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201572 201572 56.0 ALDAMA EL OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 3 1 0.24 -0.48 Eagle Rock/Highland ParkCoS 19 0.17 0.05 40 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201573 201573 57.0 ALEXANDER SCS OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 1 0 0.0 -0.15 Manual Arts/VermontSquare CoS 12 0.11 0.0 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201574 201574 58.0 ALEXANDRIA AVE EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Downtown CoS 13 0.12 0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201575 201575 59.0 ALEXANDRIA AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 1 0 0.0 0.00 Downtown CoS 13 0.12 0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201576 201576 60.0 ALLESANDRO EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Glassell Park/Los Feliz CoS 22 0.2 -0.01 75 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201577 201577 61.0 ALTA CALIFORNIA EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 8 1 0.14 -0.14 Monroe CoS 18 0.13 0.08 36 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201578 201578 62.0 ALTA LOMA EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201579 201579 63.0 AMANECER PC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201580 201580 64.0 AMBLER AVE EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.17 0.00 Carson CoS 13 0.1 0.01 23 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201581 201581 65.0 AMESTOY EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201582 201582 66.0 ANATOLA AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Cleveland CoS 25 0.21 -0.03 92 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201583 201583 67.0 ANDASOL AVE EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 6 2 0.39 0.39 Kennedy/NAHS/VAAS CoS 40 0.26 0.08 76 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201584 201584 70.0 ANGEL'S GATE HS OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 1.25 1.25 San Pedro CoS 15 0.13 -0.01 47 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201585 201585 68.0 ANGELES MESA EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201586 201586 69.0 ANGELOU COMMUNITY SH OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 1 0 0.0 -0.08 Historic Central Avenue CoS 19 0.16 0.03 27 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201587 201587 71.0 ANN ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Lincoln Heights/El SerenoCoS 17 0.12 0.02 33 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201588 201588 72.0 ANNALEE AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Carson CoS 13 0.1 0.01 23 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201589 201589 73.0 ANNANDALE EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.61 0.61 Eagle Rock/Highland ParkCoS 19 0.17 0.05 40 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201590 201590 74.0 ANTON EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201591 201591 75.0 ANTON EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) East Los Angeles CoS 27 0.19 0.03 78 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201592 201592 76.0 APPERSON ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Sunland/Tujunga CoS 10 0.21 0.09 44 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201593 201593 77.0 ARAGON AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Glassell Park/Los Feliz CoS 22 0.2 -0.01 75 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201594 201594 78.0 ARLETA SH OPEN green 4 0 Past 7 days (11/2/2022 - 11/8/2022) 3 3 0.23 0.08 Sun Valley CoS 22 0.14 -0.01 30 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201595 201595 79.0 ARLINGTON HTS EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) LA Mid-City CoS 15 0.19 0.1 26 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201596 201596 80.0 ARMINTA ST EEC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Sun Valley CoS 22 0.14 -0.01 30 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201597 201597 81.0 ARMINTA ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Sun Valley CoS 22 0.14 -0.01 30 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201598 201598 82.0 ARMSTRONG MS OPEN yellow 2 0 Past 7 days (11/2/2022 - 11/8/2022) 5 3 0.2 0.06 Van Nuys/Valley Glen CoS 18 0.1 -0.03 65 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201599 201599 83.0 ARROYO SECO MUS/S MAG OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 5 3 0.6 0.40 Eagle Rock/Highland ParkCoS 19 0.17 0.05 40 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201600 201600 84.0 ASCOT AVE EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 1 0 0.0 0.00 Historic Central Avenue CoS 19 0.16 0.03 27 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201601 201601 85.0 ATWATER AVE EL OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 17 2 0.52 0.26 Glassell Park/Los Feliz CoS 22 0.2 -0.01 75 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201602 201602 86.0 AUDUBON MS OPEN green 3 0 Past 7 days (11/2/2022 - 11/8/2022) 2 1 0.2 -0.59 H.E.E.T. (C/D) CoS 2 0.04 -0.05 4 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201603 201603 87.0 AUGUSTUS F HAWKINS SH - COMM… OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) South Mid-City CoS 6 0.08 0.03 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201604 201604 88.0 AUGUSTUS F HAWKINS SH - RESPO… OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) South Mid-City CoS 6 0.08 0.03 7 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201605 201605 89.0 AURORA EL OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Historic Central Avenue CoS 19 0.16 0.03 27 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201606 201606 90.0 AVALON GARDENS EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201607 201607 91.0 BACA ARTS ACAD OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 1 1 0.16 -0.16 Rivera CoS 13 0.09 0.02 17 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201608 201608 92.0 BAKEWELL PC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Fremont CoS 13 0.09 -0.01 24 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201609 201609 93.0 BALA OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) H.E.E.T. (W) CoS 2 0.04 0.04 3 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201610 201610 94.0 BALBOA EL G/HG/HA MAG OPEN green 1 0 Past 7 days (11/2/2022 - 11/8/2022) 4 1 0.14 -0.27 Kennedy/NAHS/VAAS CoS 40 0.26 0.08 76 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201611 201611 95.0 BALDWIN HILLS EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Hamilton CoS 9 0.11 0.01 19 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201612 201612 96.0 BANCROFT MS OPEN green 2 0 Past 7 days (11/2/2022 - 11/8/2022) 2 2 0.39 0.20 Hollywood CoS 8 0.1 -0.02 16 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201613 201613 97.0 BANDINI ST EL OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) San Pedro CoS 15 0.13 -0.01 47 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201614 201614 98.0 BANNEKER CTC OPEN green 0 0 Past 7 days (11/2/2022 - 11/8/2022) 0 0 0.0 (Blank) Gardena CoS 9 0.09 0.02 13 1,826 704 0.11 0.01 2022-11-09 01:38AM          
201615 201615 99.0 BANNING SH OPEN green 3 0 Past 7 days (11/2/2022 - 11/8/2022) 4 3 0.11 0.11 Wilmington CoS 12 0.12 0.1 22 1,826 704 0.11 0.01 2022-11-09 01:38AM          

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 3138.948ms · Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README