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-12-07
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
215086 | 215086 | 0.0 | 107TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 3 | 0.3 | 0.20 | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215087 | 215087 | 1.0 | 109TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 3 | 0.77 | 0.51 | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215088 | 215088 | 2.0 | 10TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.24 | -0.24 | MacArthur Park CoS | 24 | 0.32 | -0.09 | 40 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215089 | 215089 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215090 | 215090 | 4.0 | 112TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215091 | 215091 | 5.0 | 116TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215092 | 215092 | 6.0 | 118TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.18 | 0.00 | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215093 | 215093 | 7.0 | 122ND ST EL | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.15 | -0.58 | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215094 | 215094 | 8.0 | 135TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.15 | -0.15 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215095 | 215095 | 9.0 | 153RD ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 0.41 | 0.00 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215096 | 215096 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 0 | 0.0 | -0.25 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215097 | 215097 | 11.0 | 15TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.22 | -0.21 | San Pedro CoS | 36 | 0.31 | 0.0 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215098 | 215098 | 12.0 | 186TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 9 | 2 | 0.26 | -0.40 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215099 | 215099 | 13.0 | 1ST ST EL | OPEN | green | 6 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 3 | 0.66 | -0.22 | Boyle Heights CoS | 58 | 0.47 | -0.17 | 106 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215100 | 215100 | 14.0 | 20TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 3 | 0.49 | 0.33 | SO Los Angeles CoS | 27 | 0.27 | -0.11 | 41 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215101 | 215101 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.21 | 0.00 | Carson CoS | 42 | 0.33 | 0.0 | 62 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215102 | 215102 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 48 | 0.45 | -0.06 | 76 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215103 | 215103 | 17.0 | 24TH ST EL | OPEN | green | 7 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 3 | 0.46 | -0.75 | Manual Arts/VermontSquare CoS | 48 | 0.45 | -0.06 | 76 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215104 | 215104 | 18.0 | 28TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | SO Los Angeles CoS | 27 | 0.27 | -0.11 | 41 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215105 | 215105 | 19.0 | 28TH ST EL | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 2 | 0.34 | -0.52 | SO Los Angeles CoS | 27 | 0.27 | -0.11 | 41 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215106 | 215106 | 20.0 | 2ND ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 0.77 | 0.77 | Boyle Heights CoS | 58 | 0.47 | -0.17 | 106 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215107 | 215107 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 6 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 5 | 0.51 | 0.00 | Manual Arts/VermontSquare CoS | 48 | 0.45 | -0.06 | 76 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215108 | 215108 | 22.0 | 36TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215109 | 215109 | 23.0 | 37TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 48 | 0.45 | -0.06 | 76 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215110 | 215110 | 24.0 | 3RD ST EL | OPEN | green | 6 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 3 | 0.4 | -0.14 | Fairfax CoS | 33 | 0.36 | -0.15 | 69 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215111 | 215111 | 25.0 | 42ND ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.4 | 0.40 | H.E.E.T. (C/D) CoS | 13 | 0.28 | 0.19 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215112 | 215112 | 26.0 | 49TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 4 | 0.59 | 0.29 | Historic Central Avenue CoS | 61 | 0.53 | -0.09 | 104 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215113 | 215113 | 27.0 | 4TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215114 | 215114 | 28.0 | 4TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.29 | 0.00 | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215115 | 215115 | 29.0 | 4TH ST PC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215116 | 215116 | 30.0 | 52ND ST EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 0 | 0.0 | -0.13 | South Mid-City CoS | 18 | 0.23 | -0.07 | 36 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215117 | 215117 | 31.0 | 54TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215118 | 215118 | 32.0 | 59TH ST EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (C/D) CoS | 13 | 0.28 | 0.19 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215119 | 215119 | 33.0 | 61ST ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 3 | 0.4 | 0.13 | South Mid-City CoS | 18 | 0.23 | -0.07 | 36 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215120 | 215120 | 34.0 | 66TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Rivera CoS | 49 | 0.34 | 0.03 | 36 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215121 | 215121 | 35.0 | 66TH ST EL | OPEN | green | 4 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 4 | 0.49 | 0.12 | Rivera CoS | 49 | 0.34 | 0.03 | 72 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215122 | 215122 | 36.0 | 6TH AVE EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.22 | -0.22 | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215123 | 215123 | 37.0 | 74TH ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 2 | 0.46 | 0.46 | H.E.E.T. (C/D) CoS | 13 | 0.28 | 0.19 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215124 | 215124 | 38.0 | 75TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215125 | 215125 | 39.0 | 75TH ST EL | OPEN | green | 7 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 6 | 0.68 | 0.45 | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215126 | 215126 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 0.52 | 0.52 | San Pedro CoS | 36 | 0.31 | 0.0 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215127 | 215127 | 41.0 | 92ND ST EL | OPEN | green | 4 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 0.26 | 0.00 | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215128 | 215128 | 42.0 | 93RD ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 2 | 0.21 | -0.11 | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215129 | 215129 | 43.0 | 95TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | H.E.E.T. (W) CoS | 6 | 0.12 | -0.07 | 11 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215130 | 215130 | 44.0 | 95TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 2 | 0.23 | -0.12 | H.E.E.T. (W) CoS | 6 | 0.12 | -0.07 | 11 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215131 | 215131 | 45.0 | 96TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 1 | 0.15 | -0.44 | Achievement Network CoS | 11 | 0.19 | -0.13 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215132 | 215132 | 46.0 | 97TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215133 | 215133 | 47.0 | 99TH ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 3 | 0.5 | 0.17 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215134 | 215134 | 48.0 | 9TH ST EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.29 | -0.58 | SO Los Angeles CoS | 27 | 0.27 | -0.11 | 41 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215135 | 215135 | 49.0 | ACAD ENRICH SCI MAG | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 2 | 0.58 | 0.29 | Reseda CoS | 55 | 0.47 | -0.07 | 104 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215136 | 215136 | 50.0 | ADAMS MS | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 5 | 2 | 0.58 | 0.12 | Reseda CoS | 27 | 0.27 | -0.07 | 41 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215137 | 215137 | 51.0 | ADDAMS HS | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.62 | 0.00 | Kennedy/NAHS/VAAS CoS | 90 | 0.58 | 0.04 | 286 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215138 | 215138 | 52.0 | AE VIRTUAL ACAD | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.36 | 0.36 | - | 0 | 0.0 | 0.0 | 0 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215139 | 215139 | 53.0 | AGGELER HS | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 2.06 | 2.06 | Canoga Park/ChatsworthCoS | 57 | 0.36 | -0.13 | 153 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215140 | 215140 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 66 | 0.45 | -0.17 | 118 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215141 | 215141 | 55.0 | ALBION ST EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.53 | 0.00 | Lincoln Heights/El SerenoCoS | 66 | 0.45 | -0.17 | 118 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215142 | 215142 | 56.0 | ALDAMA EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 2 | 0.48 | 0.24 | Eagle Rock/Highland ParkCoS | 59 | 0.54 | -0.09 | 144 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215143 | 215143 | 57.0 | ALEXANDER SCS | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 3 | 0.44 | -0.15 | Manual Arts/VermontSquare CoS | 48 | 0.45 | -0.06 | 76 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215144 | 215144 | 58.0 | ALEXANDRIA AVE EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Downtown CoS | 46 | 0.43 | 0.05 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215145 | 215145 | 59.0 | ALEXANDRIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 0 | 0.0 | 0.00 | Downtown CoS | 46 | 0.43 | 0.05 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215146 | 215146 | 60.0 | ALLESANDRO EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 1 | 0.26 | -0.76 | Glassell Park/Los Feliz CoS | 43 | 0.38 | -0.2 | 77 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215147 | 215147 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 0 | 0.0 | -0.68 | Monroe CoS | 60 | 0.44 | 0.11 | 96 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215148 | 215148 | 62.0 | ALTA LOMA EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 2 | 0.43 | 0.43 | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215149 | 215149 | 63.0 | AMANECER PC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215150 | 215150 | 64.0 | AMBLER AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 42 | 0.33 | 0.0 | 62 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215151 | 215151 | 65.0 | AMESTOY EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 2 | 0.25 | -0.38 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215152 | 215152 | 66.0 | ANATOLA AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Cleveland CoS | 60 | 0.5 | -0.11 | 103 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215153 | 215153 | 67.0 | ANDASOL AVE EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 0 | 0.0 | -0.19 | Kennedy/NAHS/VAAS CoS | 90 | 0.58 | 0.04 | 286 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215154 | 215154 | 70.0 | ANGEL'S GATE HS | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | San Pedro CoS | 36 | 0.31 | 0.0 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215155 | 215155 | 68.0 | ANGELES MESA EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215156 | 215156 | 69.0 | ANGELOU COMMUNITY SH | OPEN | green | 7 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 13 | 8 | 0.63 | -0.08 | Historic Central Avenue CoS | 61 | 0.53 | -0.09 | 104 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215157 | 215157 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 66 | 0.45 | -0.17 | 118 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215158 | 215158 | 72.0 | ANNALEE AVE EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.41 | 0.00 | Carson CoS | 42 | 0.33 | 0.0 | 62 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215159 | 215159 | 73.0 | ANNANDALE EL | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.61 | -1.22 | Eagle Rock/Highland ParkCoS | 59 | 0.54 | -0.09 | 144 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215160 | 215160 | 74.0 | ANTON EEC | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 2 | 1.72 | 0.86 | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215161 | 215161 | 75.0 | ANTON EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 1 | 0.18 | 0.00 | East Los Angeles CoS | 85 | 0.59 | 0.02 | 141 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215162 | 215162 | 76.0 | APPERSON ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 2 | 0 | 0.0 | -0.70 | Sunland/Tujunga CoS | 22 | 0.46 | -0.41 | 77 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215163 | 215163 | 77.0 | ARAGON AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 3 | 1.24 | 0.41 | Glassell Park/Los Feliz CoS | 43 | 0.38 | -0.2 | 77 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215164 | 215164 | 78.0 | ARLETA SH | OPEN | green | 9 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 12 | 10 | 0.76 | 0.38 | Sun Valley CoS | 75 | 0.49 | 0.14 | 123 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215165 | 215165 | 79.0 | ARLINGTON HTS EL | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | LA Mid-City CoS | 28 | 0.35 | 0.03 | 61 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215166 | 215166 | 80.0 | ARMINTA ST EEC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 75 | 0.49 | 0.14 | 123 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215167 | 215167 | 81.0 | ARMINTA ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 3 | 0.68 | 0.68 | Sun Valley CoS | 75 | 0.49 | 0.14 | 123 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215168 | 215168 | 82.0 | ARMSTRONG MS | OPEN | yellow | 9 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 12 | 8 | 0.54 | 0.07 | Van Nuys/Valley Glen CoS | 87 | 0.48 | -0.05 | 151 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215169 | 215169 | 83.0 | ARROYO SECO MUS/S MAG | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 4 | 1 | 0.2 | -1.00 | Eagle Rock/Highland ParkCoS | 59 | 0.54 | -0.09 | 144 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215170 | 215170 | 84.0 | ASCOT AVE EL | OPEN | green | 4 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 9 | 5 | 0.64 | 0.26 | Historic Central Avenue CoS | 61 | 0.53 | -0.09 | 104 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215171 | 215171 | 85.0 | ATWATER AVE EL | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 4 | 1.04 | 0.26 | Glassell Park/Los Feliz CoS | 43 | 0.38 | -0.2 | 77 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215172 | 215172 | 86.0 | AUDUBON MS | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 3 | 2 | 0.39 | 0.20 | H.E.E.T. (C/D) CoS | 13 | 0.28 | 0.19 | 18 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215173 | 215173 | 87.0 | AUGUSTUS F HAWKINS SH - COMM… | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 18 | 0.23 | -0.07 | 36 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215174 | 215174 | 88.0 | AUGUSTUS F HAWKINS SH - RESPO… | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | South Mid-City CoS | 18 | 0.23 | -0.07 | 36 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215175 | 215175 | 89.0 | AURORA EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 3 | 0.71 | -0.48 | Historic Central Avenue CoS | 61 | 0.53 | -0.09 | 104 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215176 | 215176 | 90.0 | AVALON GARDENS EL | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215177 | 215177 | 91.0 | BACA ARTS ACAD | OPEN | green | 7 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 6 | 0.95 | 0.16 | Rivera CoS | 49 | 0.34 | 0.03 | 72 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215178 | 215178 | 92.0 | BAKEWELL PC | OPEN | green | 0 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 36 | 0.25 | -0.05 | 70 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215179 | 215179 | 93.0 | BALA | OPEN | green | 1 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 1 | 0.94 | 0.94 | H.E.E.T. (W) CoS | 6 | 0.12 | -0.07 | 11 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215180 | 215180 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 7 | 5 | 0.68 | 0.54 | Kennedy/NAHS/VAAS CoS | 90 | 0.58 | 0.04 | 286 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215181 | 215181 | 95.0 | BALDWIN HILLS EL | OPEN | green | 4 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 5 | 1.12 | 0.90 | Hamilton CoS | 45 | 0.54 | -0.16 | 88 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215182 | 215182 | 96.0 | BANCROFT MS | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 4 | 0.77 | 0.00 | Hollywood CoS | 44 | 0.56 | -0.09 | 130 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215183 | 215183 | 97.0 | BANDINI ST EL | OPEN | green | 3 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 6 | 4 | 1.35 | 0.68 | San Pedro CoS | 36 | 0.31 | 0.0 | 66 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215184 | 215184 | 98.0 | BANNEKER CTC | OPEN | green | 2 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 1 | 0 | 0.0 | -0.69 | Gardena CoS | 32 | 0.32 | -0.05 | 54 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM | |||||
215185 | 215185 | 99.0 | BANNING SH | OPEN | green | 5 | 0 | Past 7 days (11/30/2022 - 12/6/2022) | 8 | 2 | 0.07 | -0.37 | Wilmington CoS | 29 | 0.29 | -0.11 | 58 | 5,212 | 2,393 | 0.38 | -0.04 | 2022-12-07 | 01:36AM |
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 );