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.
4,458 rows where lausd_change = "0.15" sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172514 | 172514 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 0 | 0.00 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173404 | 173404 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 2.0 | 0 | 0.00 | 0.00 | Fremont CoS | 13 | 0.09 | 0.01 | 320.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174294 | 174294 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 2.0 | 0 | 0.00 | 0.00 | Fremont CoS | 13 | 0.09 | 0.02 | 312.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175184 | 175184 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 2.0 | 0 | 0.00 | 0.00 | Fremont CoS | 11 | 0.08 | 0.01 | 279.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178068 | 178068 | 0.0 | 107TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 25 | 0.17 | 0.11 | 187 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172515 | 172515 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 8.0 | 0 | 0.00 | -0.62 | Achievement Network CoS | 12 | 0.22 | 0.15 | 181 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173405 | 173405 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 6.0 | 0 | 0.00 | -0.41 | Achievement Network CoS | 9 | 0.16 | 0.03 | 155.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174295 | 174295 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 5.0 | 0 | 0.00 | -0.21 | Achievement Network CoS | 6 | 0.11 | -0.05 | 150.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175185 | 175185 | 1.0 | 109TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 2.0 | 0 | 0.00 | -0.21 | Achievement Network CoS | 6 | 0.11 | -0.09 | 141.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178069 | 178069 | 1.0 | 109TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 1 | 1 | 0.26 | 0.26 | Achievement Network CoS | 8 | 0.13 | 0.06 | 13 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172516 | 172516 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 1.0 | 0 | 0.00 | 0.00 | MacArthur Park CoS | 8 | 0.1 | 0.01 | 246 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173406 | 173406 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 2.0 | 0 | 0.00 | 0.00 | MacArthur Park CoS | 7 | 0.09 | -0.02 | 146.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174296 | 174296 | 2.0 | 10TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 2.0 | 0 | 0.00 | 0.00 | MacArthur Park CoS | 7 | 0.09 | -0.02 | 141.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175186 | 175186 | 2.0 | 10TH ST EL | OPEN | green | 3 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 5.0 | 3 | 0.70 | 0.70 | MacArthur Park CoS | 8 | 0.1 | 0.0 | 139.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178070 | 178070 | 2.0 | 10TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 1 | 0 | 0.0 | -0.46 | MacArthur Park CoS | 10 | 0.12 | -0.02 | 38 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172517 | 172517 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 45.0 | 0 | 0.00 | 0.00 | Achievement Network CoS | 12 | 0.22 | 0.15 | 181 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173407 | 173407 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 44.0 | 0 | 0.00 | 0.00 | Achievement Network CoS | 9 | 0.16 | 0.03 | 155.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174297 | 174297 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 44.0 | 0 | 0.00 | 0.00 | Achievement Network CoS | 6 | 0.11 | -0.05 | 150.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175187 | 175187 | 3.0 | 112TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 48.0 | 2 | 2.63 | 2.63 | Achievement Network CoS | 6 | 0.11 | -0.09 | 141.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178071 | 178071 | 3.0 | 112TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 1 | 0 | 0.0 | 0.00 | Achievement Network CoS | 8 | 0.13 | 0.06 | 13 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172518 | 172518 | 4.0 | 112TH ST EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 2 | 0.39 | 0.39 | Achievement Network CoS | 12 | 0.22 | 0.15 | 181 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173408 | 173408 | 4.0 | 112TH ST EL | OPEN | green | 1 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 4.0 | 2 | 0.39 | 0.39 | Achievement Network CoS | 9 | 0.16 | 0.03 | 155.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174298 | 174298 | 4.0 | 112TH ST EL | OPEN | green | 1 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 2.0 | 0 | 0.00 | -0.40 | Achievement Network CoS | 6 | 0.11 | -0.05 | 150.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175188 | 175188 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 3.0 | 0 | 0.00 | -0.40 | Achievement Network CoS | 6 | 0.11 | -0.09 | 141.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178072 | 178072 | 4.0 | 112TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 8 | 0.13 | 0.06 | 13 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172519 | 172519 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Achievement Network CoS | 12 | 0.22 | 0.15 | 181 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173409 | 173409 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | (Blank) | (Blank) | (Blank) | Achievement Network CoS | 9 | 0.16 | 0.03 | 155.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | ||||||
174299 | 174299 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | (Blank) | (Blank) | (Blank) | Achievement Network CoS | 6 | 0.11 | -0.05 | 150.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | ||||||
175189 | 175189 | 5.0 | 116TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | (Blank) | (Blank) | (Blank) | Achievement Network CoS | 6 | 0.11 | -0.09 | 141.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | ||||||
178073 | 178073 | 5.0 | 116TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Achievement Network CoS | 8 | 0.13 | 0.06 | 13 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172520 | 172520 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173410 | 173410 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 13 | 0.09 | 0.01 | 320.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | ||||||
174300 | 174300 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 13 | 0.09 | 0.02 | 312.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | ||||||
175190 | 175190 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | (Blank) | (Blank) | (Blank) | Fremont CoS | 11 | 0.08 | 0.01 | 279.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | ||||||
178074 | 178074 | 6.0 | 118TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 25 | 0.17 | 0.11 | 187 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172521 | 172521 | 7.0 | 122ND ST EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 3.0 | 2 | 0.34 | 0.34 | Fremont CoS | 11 | 0.08 | 0.01 | 430 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173411 | 173411 | 7.0 | 122ND ST EL | OPEN | green | 1 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 4.0 | 2 | 0.34 | 0.34 | Fremont CoS | 13 | 0.09 | 0.01 | 320.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174301 | 174301 | 7.0 | 122ND ST EL | OPEN | green | 1 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 4.0 | 2 | 0.34 | 0.34 | Fremont CoS | 13 | 0.09 | 0.02 | 312.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175191 | 175191 | 7.0 | 122ND ST EL | OPEN | green | 1 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 1.0 | 0 | 0.00 | -0.34 | Fremont CoS | 11 | 0.08 | 0.01 | 279.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178075 | 178075 | 7.0 | 122ND ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Fremont CoS | 25 | 0.17 | 0.11 | 187 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172522 | 172522 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 17.0 | 0 | 0.00 | -0.24 | Gardena CoS | 13 | 0.13 | 0.04 | 298 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173412 | 173412 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 11.0 | 0 | 0.00 | -0.24 | Gardena CoS | 8 | 0.08 | -0.07 | 232.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174302 | 174302 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 6.0 | 0 | 0.00 | -0.12 | Gardena CoS | 10 | 0.1 | -0.05 | 201.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175192 | 175192 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 5.0 | 0 | 0.00 | 0.00 | Gardena CoS | 9 | 0.09 | -0.03 | 169.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178076 | 178076 | 8.0 | 135TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 22 | 0.21 | 0.18 | 120 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172523 | 172523 | 9.0 | 153RD ST EL | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 20.0 | 3 | 0.29 | 0.29 | Gardena CoS | 13 | 0.13 | 0.04 | 298 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173413 | 173413 | 9.0 | 153RD ST EL | OPEN | green | 2 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 15.0 | 2 | 0.19 | 0.09 | Gardena CoS | 8 | 0.08 | -0.07 | 232.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174303 | 174303 | 9.0 | 153RD ST EL | OPEN | green | 2 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 13.0 | 2 | 0.19 | 0.09 | Gardena CoS | 10 | 0.1 | -0.05 | 201.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175193 | 175193 | 9.0 | 153RD ST EL | OPEN | green | 3 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 7.0 | 2 | 0.20 | 0.00 | Gardena CoS | 9 | 0.09 | -0.03 | 169.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178077 | 178077 | 9.0 | 153RD ST EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 22 | 0.21 | 0.18 | 120 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172524 | 172524 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | (Blank) | (Blank) | (Blank) | Gardena CoS | 13 | 0.13 | 0.04 | 298 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | ||||||
173414 | 173414 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | (Blank) | (Blank) | (Blank) | Gardena CoS | 8 | 0.08 | -0.07 | 232.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | ||||||
174304 | 174304 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | (Blank) | (Blank) | (Blank) | Gardena CoS | 10 | 0.1 | -0.05 | 201.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | ||||||
175194 | 175194 | 10.0 | 156TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | (Blank) | (Blank) | (Blank) | Gardena CoS | 9 | 0.09 | -0.03 | 169.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | ||||||
178078 | 178078 | 10.0 | 156TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 4 | 2 | 0.49 | 0.49 | Gardena CoS | 22 | 0.21 | 0.18 | 120 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172525 | 172525 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 13.0 | 2 | 0.22 | 0.22 | San Pedro CoS | 21 | 0.18 | 0.04 | 261 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173415 | 173415 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 6.0 | 3 | 0.33 | 0.33 | San Pedro CoS | 26 | 0.22 | 0.11 | 259.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174305 | 174305 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 4.0 | 3 | 0.35 | 0.23 | San Pedro CoS | 20 | 0.17 | 0.02 | 174.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175195 | 175195 | 11.0 | 15TH ST EL | OPEN | green | 4 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 6.0 | 4 | 0.48 | 0.24 | San Pedro CoS | 18 | 0.16 | -0.03 | 163.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178079 | 178079 | 11.0 | 15TH ST EL | OPEN | green | 2 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 4 | 2 | 0.45 | 0.45 | San Pedro CoS | 34 | 0.27 | 0.26 | 61 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172526 | 172526 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 0 | 0.00 | 0.00 | Gardena CoS | 13 | 0.13 | 0.04 | 298 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173416 | 173416 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 4.0 | 0 | 0.00 | 0.00 | Gardena CoS | 8 | 0.08 | -0.07 | 232.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174306 | 174306 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 2.0 | 0 | 0.00 | 0.00 | Gardena CoS | 10 | 0.1 | -0.05 | 201.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175196 | 175196 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 1.0 | 0 | 0.00 | 0.00 | Gardena CoS | 9 | 0.09 | -0.03 | 169.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178080 | 178080 | 12.0 | 186TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Gardena CoS | 22 | 0.21 | 0.18 | 120 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172527 | 172527 | 13.0 | 1ST ST EL | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 24.0 | 5 | 0.74 | 0.74 | Boyle Heights CoS | 26 | 0.22 | 0.1 | 334 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173417 | 173417 | 13.0 | 1ST ST EL | OPEN | green | 2 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 7.0 | 3 | 0.44 | 0.14 | Boyle Heights CoS | 22 | 0.18 | 0.01 | 201.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174307 | 174307 | 13.0 | 1ST ST EL | OPEN | green | 2 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 7.0 | 3 | 0.45 | 0.15 | Boyle Heights CoS | 20 | 0.17 | 0.04 | 286.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175197 | 175197 | 13.0 | 1ST ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 4.0 | 0 | 0.00 | -0.76 | Boyle Heights CoS | 9 | 0.07 | -0.15 | 161.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178081 | 178081 | 13.0 | 1ST ST EL | OPEN | green | 2 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 5 | 2 | 0.43 | 0.43 | Boyle Heights CoS | 25 | 0.19 | 0.13 | 49 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172528 | 172528 | 14.0 | 20TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 55.0 | 3 | 0.49 | 0.00 | SO Los Angeles CoS | 12 | 0.12 | 0.01 | 331 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173418 | 173418 | 14.0 | 20TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 12.0 | 2 | 0.32 | -0.33 | SO Los Angeles CoS | 12 | 0.12 | 0.03 | 261.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174308 | 174308 | 14.0 | 20TH ST EL | OPEN | green | 2 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 11.0 | 2 | 0.32 | -0.33 | SO Los Angeles CoS | 17 | 0.17 | 0.06 | 277.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175198 | 175198 | 14.0 | 20TH ST EL | OPEN | green | 1 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 11.0 | 2 | 0.33 | 0.00 | SO Los Angeles CoS | 16 | 0.16 | 0.05 | 267.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178082 | 178082 | 14.0 | 20TH ST EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 2 | 1 | 0.17 | 0.17 | SO Los Angeles CoS | 22 | 0.21 | 0.16 | 46 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172529 | 172529 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 5.0 | 1 | 0.24 | 0.24 | Carson CoS | 11 | 0.09 | -0.01 | 279 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173419 | 173419 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 5.0 | 1 | 0.24 | 0.24 | Carson CoS | 11 | 0.09 | 0.0 | 147.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174309 | 174309 | 15.0 | 232ND PL EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 5.0 | 1 | 0.24 | 0.24 | Carson CoS | 13 | 0.11 | 0.04 | 141.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175199 | 175199 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 4.0 | 1 | 0.24 | 0.00 | Carson CoS | 15 | 0.12 | 0.04 | 134.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178083 | 178083 | 15.0 | 232ND PL EL | OPEN | green | 1 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 2 | 1 | 0.21 | 0.21 | Carson CoS | 30 | 0.22 | 0.16 | 39 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172530 | 172530 | 16.0 | 24TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 63.0 | 1 | 1.00 | -1.00 | Manual Arts/VermontSquare CoS | 19 | 0.18 | 0.08 | 694 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173420 | 173420 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 59.0 | 1 | 1.00 | 0.00 | Manual Arts/VermontSquare CoS | 16 | 0.15 | 0.05 | 547.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174310 | 174310 | 16.0 | 24TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 59.0 | 2 | 2.00 | 1.00 | Manual Arts/VermontSquare CoS | 17 | 0.16 | 0.06 | 321.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175200 | 175200 | 16.0 | 24TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 58.0 | 1 | 1.00 | -1.00 | Manual Arts/VermontSquare CoS | 20 | 0.19 | 0.05 | 277.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178084 | 178084 | 16.0 | 24TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 25 | 0.22 | 0.17 | 55 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172531 | 172531 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 16.0 | 0 | 0.00 | 0.00 | Manual Arts/VermontSquare CoS | 19 | 0.18 | 0.08 | 694 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173421 | 173421 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 4.0 | 0 | 0.00 | 0.00 | Manual Arts/VermontSquare CoS | 16 | 0.15 | 0.05 | 547.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174311 | 174311 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 2.0 | 0 | 0.00 | 0.00 | Manual Arts/VermontSquare CoS | 17 | 0.16 | 0.06 | 321.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175201 | 175201 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 1.0 | 0 | 0.00 | 0.00 | Manual Arts/VermontSquare CoS | 20 | 0.19 | 0.05 | 277.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178085 | 178085 | 17.0 | 24TH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 0 | 0 | 0.0 | (Blank) | Manual Arts/VermontSquare CoS | 25 | 0.22 | 0.17 | 55 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172532 | 172532 | 18.0 | 28TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 66.0 | 1 | 1.09 | 1.09 | SO Los Angeles CoS | 12 | 0.12 | 0.01 | 331 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173422 | 173422 | 18.0 | 28TH ST EEC | OPEN | green | 1 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 66.0 | 1 | 1.09 | 1.09 | SO Los Angeles CoS | 12 | 0.12 | 0.03 | 261.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174312 | 174312 | 18.0 | 28TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 71.0 | 1 | 1.09 | 0.00 | SO Los Angeles CoS | 17 | 0.17 | 0.06 | 277.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175202 | 175202 | 18.0 | 28TH ST EEC | OPEN | green | 2 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 71.0 | 1 | 1.08 | 0.00 | SO Los Angeles CoS | 16 | 0.16 | 0.05 | 267.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178086 | 178086 | 18.0 | 28TH ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 1 | 0 | 0.0 | -1.23 | SO Los Angeles CoS | 22 | 0.21 | 0.16 | 46 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
172533 | 172533 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 4.0 | 0 | 0.00 | 0.00 | SO Los Angeles CoS | 12 | 0.12 | 0.01 | 331 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
173423 | 173423 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/22/2022 - 6/28/2022) | 2.0 | 0 | 0.00 | 0.00 | SO Los Angeles CoS | 12 | 0.12 | 0.03 | 261.0 | 0.03 | 16,344 | 890 | 0.15 | 2022-06-29 | 02:54AM | |||||
174313 | 174313 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/23/2022 - 6/29/2022) | 3.0 | 0 | 0.00 | 0.00 | SO Los Angeles CoS | 17 | 0.17 | 0.06 | 277.0 | 0.02 | 14,877 | 915 | 0.15 | 2022-06-30 | 01:33AM | |||||
175203 | 175203 | 19.0 | 28TH ST EL | OPEN | green | 0 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 4.0 | 0 | 0.00 | 0.00 | SO Los Angeles CoS | 16 | 0.16 | 0.05 | 267.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
178087 | 178087 | 19.0 | 28TH ST EL | OPEN | green | 3 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 3 | 3 | 0.52 | 0.52 | SO Los Angeles CoS | 22 | 0.21 | 0.16 | 46 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM |
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 );