lausd-cases
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-10-27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193434 | 193434 | 0.0 | 107TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.1 | 0.10 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193435 | 193435 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 2 | 0.04 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193436 | 193436 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | MacArthur Park CoS | 2 | 0.03 | -0.05 | 5 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193437 | 193437 | 3.0 | 112TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 1 | 1.39 | -1.39 | Achievement Network CoS | 2 | 0.04 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193438 | 193438 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 40 | 0 | 0.0 | 0.00 | Achievement Network CoS | 2 | 0.04 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193439 | 193439 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 0 | 0.0 | 0.00 | Achievement Network CoS | 2 | 0.04 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193440 | 193440 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193441 | 193441 | 7.0 | 122ND ST EL | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 2 | 0.29 | 0.14 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193442 | 193442 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193443 | 193443 | 9.0 | 153RD ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 1 | 0.21 | 0.00 | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193444 | 193444 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193445 | 193445 | 11.0 | 15TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 12 | 0.1 | 0.04 | 24 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193446 | 193446 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193447 | 193447 | 13.0 | 1ST ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 3 | 0.02 | -0.05 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193448 | 193448 | 14.0 | 20TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.07 | 8 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193449 | 193449 | 15.0 | 232ND PL EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 0 | 0.0 | -0.64 | Carson CoS | 7 | 0.06 | -0.09 | 16 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193450 | 193450 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193451 | 193451 | 17.0 | 24TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.15 | 0.00 | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193452 | 193452 | 18.0 | 28TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 1 | 1.09 | 0.00 | SO Los Angeles CoS | 4 | 0.04 | -0.07 | 8 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193453 | 193453 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.07 | 8 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193454 | 193454 | 20.0 | 2ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Boyle Heights CoS | 3 | 0.02 | -0.05 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193455 | 193455 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 1 | 0.1 | 0.00 | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193456 | 193456 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193457 | 193457 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193458 | 193458 | 24.0 | 3RD ST EL | OPEN | green | 4 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 4 | 0.54 | 0.40 | Fairfax CoS | 7 | 0.08 | -0.04 | 28 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193459 | 193459 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 4 | 0.09 | 0.09 | 6 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193460 | 193460 | 26.0 | 49TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.15 | 0.15 | Historic Central Avenue CoS | 11 | 0.1 | 0.07 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193461 | 193461 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193462 | 193462 | 28.0 | 4TH ST EL | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 0.58 | 0.29 | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193463 | 193463 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193464 | 193464 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 2 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193465 | 193465 | 31.0 | 54TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.39 | 0.39 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193466 | 193466 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 4 | 0.09 | 0.09 | 6 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193467 | 193467 | 33.0 | 61ST ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 2 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193468 | 193468 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 7 | 0.05 | -0.02 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193469 | 193469 | 35.0 | 66TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 7 | 0.05 | -0.02 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193470 | 193470 | 36.0 | 6TH AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193471 | 193471 | 37.0 | 74TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 4 | 0.09 | 0.09 | 6 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193472 | 193472 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193473 | 193473 | 39.0 | 75TH ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.11 | 0.11 | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193474 | 193474 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 4 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 10 | 6 | 1.55 | 1.55 | San Pedro CoS | 12 | 0.1 | 0.04 | 24 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193475 | 193475 | 41.0 | 92ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 2 | 0.04 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193476 | 193476 | 42.0 | 93RD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193477 | 193477 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193478 | 193478 | 44.0 | 95TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193479 | 193479 | 45.0 | 96TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 2 | 0.04 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193480 | 193480 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193481 | 193481 | 47.0 | 99TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193482 | 193482 | 48.0 | 9TH ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.07 | 8 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193483 | 193483 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Reseda CoS | 4 | 0.03 | -0.01 | 16 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193484 | 193484 | 50.0 | ADAMS MS | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 4 | 0.04 | -0.07 | 8 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193485 | 193485 | 51.0 | ADDAMS HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Kennedy/NAHS/VAAS CoS | 14 | 0.09 | -0.05 | 35 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193486 | 193486 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | - | 0 | 0.0 | 0.0 | 0 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193487 | 193487 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 15 | 0.1 | 0.01 | 42 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193488 | 193488 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 12 | 0.08 | -0.07 | 32 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193489 | 193489 | 55.0 | ALBION ST EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 1.05 | 1.05 | Lincoln Heights/El SerenoCoS | 12 | 0.08 | -0.07 | 32 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193490 | 193490 | 56.0 | ALDAMA EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 9 | 0.08 | 0.01 | 30 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193491 | 193491 | 57.0 | ALEXANDER SCS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.29 | Manual Arts/VermontSquare CoS | 8 | 0.08 | 0.01 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193492 | 193492 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 7 | 0.07 | -0.02 | 14 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193493 | 193493 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 2 | 2 | 0.33 | 0.16 | Downtown CoS | 7 | 0.07 | -0.02 | 14 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193494 | 193494 | 60.0 | ALLESANDRO EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 8 | 0.07 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193495 | 193495 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.14 | 0.14 | Monroe CoS | 8 | 0.06 | 0.03 | 29 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193496 | 193496 | 62.0 | ALTA LOMA EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.22 | 0.22 | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193497 | 193497 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193498 | 193498 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 7 | 0.06 | -0.09 | 16 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193499 | 193499 | 65.0 | AMESTOY EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193500 | 193500 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 33 | 0.27 | 0.15 | 72 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193501 | 193501 | 67.0 | ANDASOL AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.20 | Kennedy/NAHS/VAAS CoS | 14 | 0.09 | -0.05 | 35 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193502 | 193502 | 70.0 | ANGEL'S GATE HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 12 | 0.1 | 0.04 | 24 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193503 | 193503 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193504 | 193504 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 4 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 4 | 0.32 | 0.32 | Historic Central Avenue CoS | 11 | 0.1 | 0.07 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193505 | 193505 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 12 | 0.08 | -0.07 | 32 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193506 | 193506 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 7 | 0.06 | -0.09 | 16 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193507 | 193507 | 73.0 | ANNANDALE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | 0.00 | Eagle Rock/Highland ParkCoS | 9 | 0.08 | 0.01 | 30 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193508 | 193508 | 74.0 | ANTON EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193509 | 193509 | 75.0 | ANTON EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193510 | 193510 | 76.0 | APPERSON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Sunland/Tujunga CoS | 1 | 0.02 | -0.02 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193511 | 193511 | 77.0 | ARAGON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 8 | 0.07 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193512 | 193512 | 78.0 | ARLETA SH | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.0 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193513 | 193513 | 79.0 | ARLINGTON HTS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 7 | 0.09 | -0.02 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193514 | 193514 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.0 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193515 | 193515 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 8 | 0.05 | 0.0 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193516 | 193516 | 82.0 | ARMSTRONG MS | OPEN | green | 10 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 18 | 10 | 0.68 | 0.27 | Van Nuys/Valley Glen CoS | 19 | 0.1 | 0.02 | 48 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193517 | 193517 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Eagle Rock/Highland ParkCoS | 9 | 0.08 | 0.01 | 30 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193518 | 193518 | 84.0 | ASCOT AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Historic Central Avenue CoS | 11 | 0.1 | 0.07 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193519 | 193519 | 85.0 | ATWATER AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Glassell Park/Los Feliz CoS | 8 | 0.07 | -0.03 | 94 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193520 | 193520 | 86.0 | AUDUBON MS | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 2 | 0.4 | 0.40 | H.E.E.T. (C/D) CoS | 4 | 0.09 | 0.09 | 6 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193521 | 193521 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 2 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193522 | 193522 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 1 | 0.01 | 0.01 | 2 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193523 | 193523 | 89.0 | AURORA EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 1 | 0.24 | 0.24 | Historic Central Avenue CoS | 11 | 0.1 | 0.07 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193524 | 193524 | 90.0 | AVALON GARDENS EL | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193525 | 193525 | 91.0 | BACA ARTS ACAD | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 7 | 0.05 | -0.02 | 21 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193526 | 193526 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 9 | 0.06 | -0.03 | 12 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193527 | 193527 | 93.0 | BALA | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 0 | 0.0 | -0.04 | 1 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193528 | 193528 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 1 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 2 | 0.27 | 0.27 | Kennedy/NAHS/VAAS CoS | 14 | 0.09 | -0.05 | 35 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193529 | 193529 | 95.0 | BALDWIN HILLS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hamilton CoS | 4 | 0.05 | -0.07 | 11 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193530 | 193530 | 96.0 | BANCROFT MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Hollywood CoS | 4 | 0.05 | -0.07 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193531 | 193531 | 97.0 | BANDINI ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 12 | 0.1 | 0.04 | 24 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193532 | 193532 | 98.0 | BANNEKER CTC | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | 0.00 | Gardena CoS | 6 | 0.06 | -0.04 | 15 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193533 | 193533 | 99.0 | BANNING SH | OPEN | green | 2 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 2 | 0.07 | 0.03 | Wilmington CoS | 5 | 0.05 | -0.04 | 30 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM |
Advanced export
JSON shape: default, array, newline-delimited
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 );