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 sorted by staff_student
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
193534 | 193534 | 100.0 | BARRETT 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 | |||||
193535 | 193535 | 101.0 | BARTON HILL 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 | |||||
193537 | 193537 | 103.0 | BEACHY AVE 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 | |||||
193539 | 193539 | 105.0 | BEETHOVEN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.28 | Venice CoS | 16 | 0.17 | 0.05 | 64 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193541 | 193541 | 107.0 | BELLINGHAM EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | North Hollywood/ValleyVillage CoS | 31 | 0.23 | 0.05 | 67 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193542 | 193542 | 108.0 | BELMONT SH | 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 | |||||
193544 | 193544 | 110.0 | BELVEDERE MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 0 | 0.0 | -0.85 | East Los Angeles CoS | 18 | 0.13 | -0.01 | 34 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193547 | 193547 | 113.0 | BERNSTEIN SH STEM | 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 | |||||
193548 | 193548 | 114.0 | BERTRAND AVE EL | 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 | |||||
193552 | 193552 | 118.0 | BOYLE HEIGHTS HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | 0.00 | Boyle Heights CoS | 3 | 0.02 | -0.05 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193553 | 193553 | 119.0 | BOYLE HTS STEM MAG | 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 | |||||
193556 | 193556 | 122.0 | BRADLEY GLBL AWR MAG | 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 | |||||
193559 | 193559 | 125.0 | BREED ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 1 | 0 | 0.0 | -0.30 | Boyle Heights CoS | 3 | 0.02 | -0.05 | 13 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193561 | 193561 | 127.0 | BRIDGE 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 | |||||
193562 | 193562 | 128.0 | BRIDGES SCHOOL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Wilmington CoS | 5 | 0.05 | -0.04 | 30 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193563 | 193563 | 129.0 | BRIGHT 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 | |||||
193565 | 193565 | 131.0 | BROADACRES AV 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 | |||||
193567 | 193567 | 133.0 | BROADOUS EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | San Fernando Valley/SylmarCoS | 19 | 0.11 | -0.02 | 56 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193569 | 193569 | 135.0 | BROCKTON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | West LA CoS | 16 | 0.15 | -0.05 | 66 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193570 | 193570 | 136.0 | BROOKLYN AVE 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 | |||||
193571 | 193571 | 137.0 | BROOKLYN AVE 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 | |||||
193573 | 193573 | 139.0 | BUCHANAN ST 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 | |||||
193574 | 193574 | 140.0 | BUDLONG AVE 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 | |||||
193577 | 193577 | 143.0 | BURKE HS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 3 | 0 | 0.0 | -0.73 | Panorama City CoS | 10 | 0.13 | 0.08 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193578 | 193578 | 144.0 | BURROUGHS MS | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 4 | 0 | 0.0 | -0.13 | Fairfax CoS | 7 | 0.08 | -0.04 | 28 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193579 | 193579 | 145.0 | BURTON ST EL | OPEN | green | 0 | 0 | Past 7 days (10/20/2022 - 10/26/2022) | 0 | 0 | 0.0 | (Blank) | Panorama City CoS | 10 | 0.13 | 0.08 | 20 | 1,409 | 491 | 0.08 | 0.0 | 2022-10-27 | 01:34AM | |||||
193582 | 193582 | 148.0 | CABRILLO AVE EEC | 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 |
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 );