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.
1,090 rows where pos = 10 sorted by cos_pos
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
86576 | 86576 | 202.0 | CITY OF ANGELS | OPEN | green | 11 | 0 | Past 7 days (12/29/2021 - 1/4/2022) | 338.0 | 10 | 2.96 | -5.37 | (Blank) | (Bla… | (Bla… | (Bla… | 93,471 | 2555 | 2.73 | -12.12 | 2022-01-05 | 10:00PM | ||||||
88053 | 88053 | 792.0 | TRINITY ST EL | OPEN | green | 9 | 0 | Past 7 days (12/31/2021 - 1/6/2022) | 132 | 10 | 7.58 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 250,361 | 18K | 7.22 | -61.62 | 2022-01-06 | 10:00PM | ||||||
88054 | 88054 | 793.0 | TULSA ST EL | OPEN | green | 9 | 0 | Past 7 days (12/31/2021 - 1/6/2022) | 201 | 10 | 7.58 | -87.06 | (Blank) | 7,390 | (Bla… | (Bla… | -67.73 | 250,361 | 18K | 7.22 | -61.62 | 2022-01-06 | 10:00PM | |||||
88166 | 88166 | 18.0 | 28TH ST EEC | OPEN | green | 10 | 0 | Past 7 days (12/31/2021 - 1/6/2022) | 67 | 10 | 14.93 | 14.93 | (Blank) | (Bla… | (Bla… | (Bla… | 250,361 | 18K | 7.22 | -61.62 | 2022-01-07 | 10:00PM | ||||||
88640 | 88640 | 492.0 | LOS ANGELES TECH CTR | OPEN | green | 11 | 0 | Past 7 days (1/1/2022 - 1/7/2022) | 113 | 10 | 8.85 | 8.85 | (Blank) | (Bla… | (Bla… | (Bla… | 331,213 | 26K | 7.99 | -60.73 | 2022-01-07 | 10:00PM | ||||||
89053 | 89053 | 18.0 | 28TH ST EEC | OPEN | green | 10 | 0 | Past 7 days (1/1/2022 - 1/7/2022) | 70 | 10 | 14.29 | 14.29 | (Blank) | (Bla… | (Bla… | (Bla… | 331,213 | 26K | 7.99 | -60.73 | 2022-01-08 | 10:00PM | ||||||
89940 | 89940 | 18.0 | 28TH ST EEC | OPEN | green | 10 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 72 | 10 | 13.89 | 13.89 | (Blank) | (Bla… | (Bla… | (Bla… | 366,626 | 46K | 12.55 | -53.77 | 2022-01-09 | 10:00PM | ||||||
92199 | 92199 | 503.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 13 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 43 | 10 | 23.26 | 6.59 | (Blank) | (Bla… | (Bla… | (Bla… | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | ||||||
95748 | 95748 | 504.0 | MAGNOLIA SCI ACAD #4 | OPEN | green | 17 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 77 | 10 | 12.99 | -9.87 | (Blank) | (Bla… | (Bla… | (Bla… | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | ||||||
97953 | 97953 | 48.0 | 9TH ST EL | OPEN | green | 25 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 204 | 10 | 4.90 | -13.33 | (Blank) | (Bla… | (Bla… | (Bla… | 425,333 | 36K | 8.45 | -7.03 | 2022-01-19 | 10:00PM | ||||||
98312 | 98312 | 407.0 | HUERTA EL | OPEN | green | 35 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 60 | 10 | 16.67 | -0.34 | (Blank) | (Bla… | (Bla… | (Bla… | 425,333 | 36K | 8.45 | -7.03 | 2022-01-19 | 10:00PM | ||||||
99297 | 99297 | 505.0 | MAGNOLIA SCI ACAD #6 | OPEN | green | 5 | 0 | Past 7 days (1/13/2022 - 1/19/2022) | 83 | 10 | 12.05 | 3.94 | (Blank) | (Bla… | (Bla… | (Bla… | 426,155 | 34K | 8.07 | -6.53 | 2022-01-20 | 10:00PM | ||||||
100052 | 100052 | 373.0 | HARBOR OCC CTR | OPEN | green | 27 | 0 | Past 7 days (1/16/2022 - 1/22/2022) | 121 | 10 | 8.26 | -6.39 | (Blank) | (Bla… | (Bla… | (Bla… | 391,576 | 31K | 7.84 | -3.85 | 2022-01-22 | 10:00PM | ||||||
100940 | 100940 | 373.0 | HARBOR OCC CTR | OPEN | green | 27 | 0 | Past 7 days (1/16/2022 - 1/22/2022) | 121 | 10 | 8.26 | -6.39 | (Blank) | (Bla… | (Bla… | (Bla… | 391,576 | 31K | 7.84 | -3.85 | 2022-01-23 | 10:00PM | ||||||
103159 | 103159 | 408.0 | HUERTA EL | OPEN | green | 37 | 0 | Past 7 days (1/22/2022 - 1/28/2022) | 235 | 10 | 4.26 | -12.79 | (Blank) | (Bla… | (Bla… | (Bla… | 352,332 | 15K | 4.23 | -4.26 | 2022-01-28 | 10:00PM | ||||||
103160 | 103160 | 408.0 | HUERTA EL | OPEN | green | 37 | 0 | Past 7 days (1/22/2022 - 1/28/2022) | 235 | 10 | 4.26 | -12.79 | (Blank) | (Bla… | (Bla… | (Bla… | 352,332 | 15K | 4.23 | -4.26 | 2022-01-28 | 10:00PM | ||||||
103351 | 103351 | 504.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 23 | 0 | Past 7 days (1/22/2022 - 1/28/2022) | 347 | 10 | 2.88 | -1.79 | (Blank) | (Bla… | (Bla… | (Bla… | 352,332 | 15K | 4.23 | -4.26 | 2022-01-28 | 10:00PM | ||||||
103352 | 103352 | 504.0 | MAGNOLIA SCI ACAD #2 | OPEN | green | 23 | 0 | Past 7 days (1/22/2022 - 1/28/2022) | 347 | 10 | 2.88 | -1.79 | (Blank) | (Bla… | (Bla… | (Bla… | 352,332 | 15K | 4.23 | -4.26 | 2022-01-28 | 10:00PM | ||||||
105309 | 105309 | 48.0 | 9TH ST EL | OPEN | green | 4 | 0 | Past 7 days (1/25/2022 - 1/31/2022) | 167 | 10 | 5.99 | -4.57 | (Blank) | (Bla… | (Bla… | (Bla… | 348,920 | 14K | 3.88 | -3.75 | 2022-01-31 | 10:00PM | ||||||
105541 | 105541 | 267.0 | EARLY COLLEGE ACAD | OPEN | green | 3 | 0 | Past 7 days (1/25/2022 - 1/31/2022) | 140 | 10 | 7.14 | -1.19 | (Blank) | (Bla… | (Bla… | (Bla… | 348,920 | 14K | 3.88 | -3.75 | 2022-01-31 | 10:00PM | ||||||
105542 | 105542 | 267.0 | EARLY COLLEGE ACAD | OPEN | green | 3 | 0 | Past 7 days (1/25/2022 - 1/31/2022) | 140 | 10 | 7.14 | -1.19 | (Blank) | (Bla… | (Bla… | (Bla… | 348,920 | 14K | 3.88 | -3.75 | 2022-01-31 | 10:00PM | ||||||
106021 | 106021 | 507.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 11 | 0 | Past 7 days (1/25/2022 - 1/31/2022) | 242 | 10 | 4.13 | -4.57 | (Blank) | (Bla… | (Bla… | (Bla… | 348,920 | 14K | 3.88 | -3.75 | 2022-01-31 | 10:00PM | ||||||
106022 | 106022 | 507.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 11 | 0 | Past 7 days (1/25/2022 - 1/31/2022) | 242 | 10 | 4.13 | -4.57 | (Blank) | (Bla… | (Bla… | (Bla… | 348,920 | 14K | 3.88 | -3.75 | 2022-01-31 | 10:00PM | ||||||
107206 | 107206 | 423.0 | JONES EL | OPEN | green | 13 | 0 | Past 7 days (1/27/2022 - 2/2/2022) | 247 | 10 | 4.05 | -11.84 | (Blank) | (Bla… | (Bla… | (Bla… | 343,565 | 12K | 3.42 | -2.75 | 2022-02-02 | 10:00PM | ||||||
107290 | 107290 | 507.0 | MAGNOLIA SCI-BELL@SR | OPEN | green | 2 | 0 | Past 7 days (1/27/2022 - 2/2/2022) | 240 | 10 | 4.17 | -18.05 | (Blank) | (Bla… | (Bla… | (Bla… | 343,565 | 12K | 3.42 | -2.75 | 2022-02-02 | 10:00PM | ||||||
107503 | 107503 | 720.0 | SAN PEDRO ST EL | OPEN | green | 17 | 0 | Past 7 days (1/28/2022 - 2/3/2022) | 356 | 10 | 2.81 | -3.63 | (Blank) | (Bla… | (Bla… | (Bla… | 346,245 | 11K | 3.17 | -2.37 | 2022-02-03 | 10:00PM | ||||||
108257 | 108257 | 586.0 | NEW ACAD CANOGA PARK | OPEN | green | 21 | 0 | Past 7 days (1/29/2022 - 2/4/2022) | 254 | 10 | 3.94 | -2.06 | (Blank) | (Bla… | (Bla… | (Bla… | 340,065 | 9544 | 2.81 | -2.18 | 2022-02-04 | 10:00PM | ||||||
108855 | 108855 | 514.0 | MAPLE PC | OPEN | green | 14 | 0 | Past 7 days (1/30/2022 - 2/5/2022) | 192 | 10 | 5.21 | -2.12 | (Blank) | (Bla… | (Bla… | (Bla… | 337,524 | 10K | 3.08 | -1.84 | 2022-02-05 | 10:00PM | ||||||
108927 | 108927 | 586.0 | NEW ACAD CANOGA PARK | OPEN | green | 15 | 0 | Past 7 days (1/30/2022 - 2/5/2022) | 251 | 10 | 3.98 | -2.47 | (Blank) | (Bla… | (Bla… | (Bla… | 337,524 | 10K | 3.08 | -1.84 | 2022-02-05 | 10:00PM | ||||||
109194 | 109194 | 848.0 | WEST VALLEY OCC CTR | OPEN | green | 1 | 0 | Past 7 days (1/30/2022 - 2/5/2022) | 258 | 10 | 0.40 | -1.95 | (Blank) | (Bla… | (Bla… | (Bla… | 337,524 | 10K | 3.08 | -1.84 | 2022-02-05 | 10:00PM | ||||||
109833 | 109833 | 599.0 | NORTH VALLEY OCC CTR | OPEN | green | 10 | 0 | Past 7 days (2/1/2022 - 2/7/2022) | 203 | 10 | 4.93 | -1.34 | (Blank) | (Bla… | (Bla… | (Bla… | 262,713 | 7296 | 2.78 | -1.89 | 2022-02-06 | 10:00PM | ||||||
111128 | 111128 | 793.0 | TRINITY ST EL | OPEN | green | 12 | 0 | Past 7 days (2/2/2022 - 2/8/2022) | 187 | 10 | 5.35 | -2.52 | (Blank) | (Bla… | (Bla… | (Bla… | 329,504 | 7320 | 2.22 | -2.16 | 2022-02-08 | 10:00PM | ||||||
111237 | 111237 | 14.0 | 20TH ST EL | OPEN | green | 4 | 0 | Past 7 days (2/7/2022 - 2/13/2022) | 378 | 10 | 2.65 | -2.34 | (Blank) | (Bla… | (Bla… | (Bla… | 324,329 | 5556 | 1.71 | -1.48 | 2022-02-13 | 10:00PM | ||||||
111631 | 111631 | 408.0 | HUERTA EL | OPEN | green | 7 | 0 | Past 7 days (2/7/2022 - 2/13/2022) | 213 | 10 | 4.69 | -1.63 | (Blank) | (Bla… | (Bla… | (Bla… | 324,329 | 5556 | 1.71 | -1.48 | 2022-02-13 | 10:00PM | ||||||
112054 | 112054 | 831.0 | WADSWORTH AVE EL | OPEN | green | 7 | 0 | Past 7 days (2/7/2022 - 2/13/2022) | 379 | 10 | 2.64 | -2.24 | (Blank) | (Bla… | (Bla… | (Bla… | 324,329 | 5556 | 1.71 | -1.48 | 2022-02-13 | 10:00PM | ||||||
112519 | 112519 | 408.0 | HUERTA EL | OPEN | green | 6 | 0 | Past 7 days (2/8/2022 - 2/14/2022) | 211 | 10 | 4.74 | -1.51 | (Blank) | (Bla… | (Bla… | (Bla… | 320,692 | 4283 | 1.34 | -1.47 | 2022-02-14 | 10:00PM | ||||||
113407 | 113407 | 408.0 | HUERTA EL | OPEN | green | 3 | 0 | Past 7 days (2/9/2022 - 2/15/2022) | 211 | 10 | 4.74 | -1.90 | (Blank) | (Bla… | (Bla… | (Bla… | 318,913 | 4018 | 1.26 | -1.28 | 2022-02-15 | 10:00PM | ||||||
162700 | 162700 | 848.0 | WEST VALLEY OCC CTR | OPEN | green | 10 | 1 | Past 7 days (4/29/2022 - 5/5/2022) | 854 | 10 | 1.17 | 0.72 | (Blank) | (Bla… | (Bla… | (Bla… | 442,412 | 2174 | 0.49 | -0.01 | 2022-05-06 | 01:28AM | ||||||
164476 | 164476 | 848.0 | WEST VALLEY OCC CTR | OPEN | green | 10 | 0 | Past 7 days (5/3/2022 - 5/9/2022) | 722 | 10 | 1.39 | 0.62 | (Blank) | (Bla… | (Bla… | (Bla… | 448,959 | 2356 | 0.52 | -0.01 | 2022-05-10 | 01:40AM | ||||||
169330 | 169330 | 374.0 | HARBOR OCC CTR | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | HARBOR OCC CTR | 10 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM | ||||||
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 | |||||
173323 | 173323 | 809.0 | VAN NUYS SH | OPEN | green | 6 | 0 | Past 7 days (6/21/2022 - 6/27/2022) | 202.0 | 10 | 0.37 | 0.30 | Van Nuys/Valley Glen CoS | 23 | 0.13 | 0.04 | 516 | 0.05 | 22,632 | 925 | 0.15 | 2022-06-28 | 02:41AM | |||||
175993 | 175993 | 809.0 | VAN NUYS SH | OPEN | green | 9 | 0 | Past 7 days (6/25/2022 - 7/1/2022) | 23.0 | 10 | 0.37 | 0.04 | Van Nuys/Valley Glen CoS | 29 | 0.16 | 0.03 | 204.0 | 0.01 | 13,006 | 944 | 0.15 | 2022-07-02 | 01:31AM | |||||
202818 | 202818 | 404.0 | HOLMES MS | OPEN | green | 9 | 0 | Past 7 days (11/3/2022 - 11/9/2022) | 12 | 10 | 1.0 | 0.80 | Monroe CoS | 21 | 0.16 | 0.1 | 40 | 1,730 | 715 | 0.11 | 0.01 | 2022-11-10 | 01:32AM | |||||
201249 | 201249 | 631.0 | PANORAMA SH | OPEN | green | 12 | 0 | Past 7 days (10/30/2022 - 11/5/2022) | 30 | 10 | 0.62 | -0.07 | Panorama City CoS | 13 | 0.17 | -0.05 | 36 | 1,582 | 581 | 0.09 | -0.01 | 2022-11-06 | 01:38AM | |||||
197657 | 197657 | 631.0 | PANORAMA SH | OPEN | green | 11 | 0 | Past 7 days (10/24/2022 - 10/30/2022) | 11 | 10 | 0.62 | 0.50 | Panorama City CoS | 15 | 0.19 | 0.13 | 19 | 1,160 | 484 | 0.08 | -0.01 | 2022-10-31 | 01:31AM | |||||
197193 | 197193 | 167.0 | CARPENTER COMM CHTR | OPEN | yellow | 7 | 3 | Past 7 days (10/24/2022 - 10/30/2022) | 44 | 10 | 1.05 | 0.52 | North Hollywood/ValleyVillage CoS | 28 | 0.21 | 0.04 | 72 | 1,160 | 484 | 0.08 | -0.01 | 2022-10-31 | 01:31AM | |||||
217634 | 217634 | 752.0 | SOUTH GATE SH | OPEN | green | 11 | 0 | Past 7 days (12/12/2022 - 12/18/2022) | 10 | 10 | 0.49 | -0.05 | South Gate CoS | 42 | 0.25 | -0.4 | 88 | 3,225 | 1,400 | 0.22 | -0.22 | 2022-12-19 | 01:30AM | |||||
203045 | 203045 | 631.0 | PANORAMA SH | OPEN | green | 9 | 0 | Past 7 days (11/3/2022 - 11/9/2022) | 33 | 10 | 0.62 | -0.25 | Panorama City CoS | 21 | 0.27 | 0.06 | 47 | 1,730 | 715 | 0.11 | 0.01 | 2022-11-10 | 01:32AM | |||||
169900 | 169900 | 56.0 | ALEXANDER SCS | OPEN | green | 8 | 0 | Past 7 days (6/9/2022 - 6/15/2022) | 441 | 10 | 1.88 | 0.75 | Manual Arts/VermontSquare CoS | 30 | 0.28 | -0.62 | 1,502 | -0.72 | 116,592 | 1,748 | 0.29 | 2022-06-16 | 01:42AM | |||||
187721 | 187721 | 673.0 | RESEDA CHARTER HS | OPEN | green | 17 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 16 | 10 | 0.51 | -0.41 | Reseda CoS | 36 | 0.28 | -0.39 | 88 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
214720 | 214720 | 532.0 | MARSHALL SH | OPEN | green | 14 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 15 | 10 | 0.46 | -0.09 | Glassell Park/Los Feliz CoS | 33 | 0.29 | -0.19 | 69 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
217255 | 217255 | 373.0 | HAMILTON SH | OPEN | green | 9 | 0 | Past 7 days (12/12/2022 - 12/18/2022) | 11 | 10 | 0.4 | 0.00 | Hamilton CoS | 25 | 0.3 | -0.1 | 37 | 3,225 | 1,400 | 0.22 | -0.22 | 2022-12-19 | 01:30AM | |||||
187903 | 187903 | 855.0 | WEST ADAMS PREP SH | OPEN | green | 10 | 0 | Past 7 days (8/26/2022 - 9/1/2022) | 12 | 10 | 0.66 | 0.13 | Kreatwn/PcoUnion CoS | 40 | 0.32 | -0.31 | 89 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
213885 | 213885 | 595.0 | NO HOLLYWD SH | OPEN | green | 13 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 15 | 10 | 0.36 | 0.10 | North Hollywood/ValleyVillage CoS | 44 | 0.32 | 0.02 | 83 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
214291 | 214291 | 103.0 | BEACHY AVE EL | OPEN | green | 9 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 12 | 10 | 1.99 | 1.99 | Sun Valley CoS | 49 | 0.32 | 0.02 | 91 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
170305 | 170305 | 461.0 | LAWRENCE MS | OPEN | green | 12 | 0 | Past 7 days (6/9/2022 - 6/15/2022) | 318 | 10 | 0.80 | -0.32 | Canoga Park/ChatsworthCoS | 50 | 0.33 | -1.07 | 3,075 | -0.72 | 116,592 | 1,748 | 0.29 | 2022-06-16 | 01:42AM | |||||
210033 | 210033 | 335.0 | GARFIELD SH | OPEN | green | 8 | 0 | Past 7 days (11/22/2022 - 11/28/2022) | 26 | 10 | 0.4 | 0.24 | East Los Angeles CoS | 47 | 0.33 | 0.23 | 179 | 7,103 | 1,720 | 0.27 | 0.18 | 2022-11-29 | 01:37AM | |||||
211058 | 211058 | 462.0 | LAWRENCE MS | OPEN | green | 10 | 0 | Past 7 days (11/23/2022 - 11/29/2022) | 22 | 10 | 0.83 | 0.66 | Canoga Park/ChatsworthCoS | 52 | 0.33 | 0.25 | 210 | 7,320 | 1,964 | 0.31 | 0.24 | 2022-11-30 | 01:37AM | |||||
211375 | 211375 | 779.0 | TAFT CHS | OPEN | green | 9 | 0 | Past 7 days (11/23/2022 - 11/29/2022) | 13 | 10 | 0.42 | 0.38 | Taft CoS | 48 | 0.33 | 0.21 | 123 | 7,320 | 1,964 | 0.31 | 0.24 | 2022-11-30 | 01:37AM | |||||
179124 | 179124 | 158.0 | CANOGA PRK SH | OPEN | green | 9 | 0 | Past 7 days (8/9/2022 - 8/15/2022) | 43 | 10 | 0.47 | 0.47 | Canoga Park/ChatsworthCoS | 60 | 0.35 | 0.31 | 226 | 8,286 | 2,194 | 0.34 | 0.25 | 2022-08-16 | 01:36AM | |||||
186321 | 186321 | 171.0 | CARSON ST EL | OPEN | green | 11 | 0 | Past 7 days (8/25/2022 - 8/31/2022) | 13 | 10 | 1.34 | 0.40 | Carson CoS | 50 | 0.36 | -0.13 | 96 | 5,731 | 2,549 | 0.38 | -0.26 | 2022-09-01 | 01:29AM | |||||
186458 | 186458 | 308.0 | FAIRFAX SH | OPEN | green | 9 | 0 | Past 7 days (8/25/2022 - 8/31/2022) | 13 | 10 | 0.44 | 0.04 | Fairfax CoS | 37 | 0.36 | -0.4 | 83 | 5,731 | 2,549 | 0.38 | -0.26 | 2022-09-01 | 01:29AM | |||||
187017 | 187017 | 867.0 | WHITE MS | OPEN | green | 10 | 0 | Past 7 days (8/25/2022 - 8/31/2022) | 15 | 10 | 0.61 | -0.18 | Carson CoS | 50 | 0.36 | -0.13 | 96 | 5,731 | 2,549 | 0.38 | -0.26 | 2022-09-01 | 01:29AM | |||||
214041 | 214041 | 751.0 | SOUTH GATE MS | OPEN | green | 9 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 19 | 10 | 0.67 | 0.27 | South Gate CoS | 61 | 0.36 | -0.02 | 121 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
183281 | 183281 | 723.0 | SAN PEDRO SH | OPEN | green | 13 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 17 | 10 | 0.29 | -0.25 | San Pedro CoS | 48 | 0.37 | -0.14 | 127 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
210178 | 210178 | 480.0 | LINCOLN SH | OPEN | green | 10 | 0 | Past 7 days (11/22/2022 - 11/28/2022) | 31 | 10 | 0.85 | 0.85 | Lincoln Heights/El SerenoCoS | 55 | 0.38 | 0.26 | 177 | 7,103 | 1,720 | 0.27 | 0.18 | 2022-11-29 | 01:37AM | |||||
214845 | 214845 | 657.0 | PORTER MS | OPEN | green | 9 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 34 | 10 | 0.9 | 0.54 | Kennedy/NAHS/VAAS CoS | 59 | 0.38 | -0.05 | 147 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
178588 | 178588 | 520.0 | MAR VISTA EL | OPEN | green | 10 | 0 | Past 7 days (8/8/2022 - 8/14/2022) | 10 | 10 | 1.59 | 1.43 | Venice CoS | 40 | 0.39 | 0.35 | 57 | 4,048 | 1,506 | 0.23 | 0.15 | 2022-08-15 | 01:37AM | |||||
181629 | 181629 | 867.0 | WHITE MS | OPEN | green | 9 | 0 | Past 7 days (8/19/2022 - 8/25/2022) | 16 | 10 | 0.61 | 0.00 | Carson CoS | 54 | 0.39 | -0.14 | 83 | 5,603 | 3,796 | 0.57 | 0.06 | 2022-08-26 | 01:30AM | |||||
183495 | 183495 | 39.0 | 75TH ST EL | OPEN | green | 7 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 16 | 10 | 1.07 | 0.43 | Fremont CoS | 61 | 0.39 | -0.01 | 112 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
183777 | 183777 | 321.0 | FREMONT SH | OPEN | green | 11 | 0 | Past 7 days (8/22/2022 - 8/28/2022) | 20 | 10 | 0.36 | -0.33 | Fremont CoS | 61 | 0.39 | -0.01 | 112 | 7,140 | 2,973 | 0.45 | -0.1 | 2022-08-29 | 01:36AM | |||||
210230 | 210230 | 532.0 | MARSHALL SH | OPEN | green | 6 | 0 | Past 7 days (11/22/2022 - 11/28/2022) | 15 | 10 | 0.46 | 0.46 | Glassell Park/Los Feliz CoS | 44 | 0.39 | 0.34 | 137 | 7,103 | 1,720 | 0.27 | 0.18 | 2022-11-29 | 01:37AM | |||||
179804 | 179804 | 838.0 | VLADOVIC HARBOR TPA | OPEN | green | 10 | 0 | Past 7 days (8/9/2022 - 8/15/2022) | 32 | 10 | 1.67 | 1.00 | Wilmington CoS | 43 | 0.4 | 0.31 | 478 | 8,286 | 2,194 | 0.34 | 0.25 | 2022-08-16 | 01:36AM | |||||
184611 | 184611 | 257.0 | DODSON MS | OPEN | green | 15 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 81 | 10 | 0.64 | -0.63 | San Pedro CoS | 52 | 0.4 | -0.1 | 145 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
212019 | 212019 | 525.0 | MARK TWAIN MS | OPEN | yellow | 9 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 26 | 10 | 1.03 | 1.03 | Venice CoS | 38 | 0.4 | 0.29 | 132 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
213868 | 213868 | 578.0 | MULHOLLAND MS | OPEN | green | 13 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 15 | 10 | 0.87 | 0.35 | Reseda CoS | 47 | 0.4 | -0.02 | 85 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
213997 | 213997 | 707.0 | ROYBAL LC | OPEN | green | 12 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 17 | 10 | 0.79 | 0.47 | Downtown CoS | 43 | 0.4 | 0.15 | 69 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
214035 | 214035 | 745.0 | SOCES MAG | OPEN | yellow | 17 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 16 | 10 | 0.52 | -0.16 | Reseda CoS | 47 | 0.4 | -0.02 | 85 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
217316 | 217316 | 434.0 | KENNEDY SH | OPEN | yellow | 11 | 0 | Past 7 days (12/12/2022 - 12/18/2022) | 16 | 10 | 0.41 | -0.41 | Kennedy/NAHS/VAAS CoS | 62 | 0.4 | -0.4 | 164 | 3,225 | 1,400 | 0.22 | -0.22 | 2022-12-19 | 01:30AM | |||||
179473 | 179473 | 507.0 | MADISON MS | OPEN | green | 9 | 0 | Past 7 days (8/9/2022 - 8/15/2022) | 17 | 10 | 0.63 | 0.63 | Van Nuys/Valley Glen CoS | 81 | 0.41 | 0.33 | 344 | 8,286 | 2,194 | 0.34 | 0.25 | 2022-08-16 | 01:36AM | |||||
183425 | 183425 | 867.0 | WHITE MS | OPEN | green | 10 | 0 | Past 7 days (8/21/2022 - 8/27/2022) | 15 | 10 | 0.61 | 0.00 | Carson CoS | 57 | 0.41 | -0.03 | 88 | 6,087 | 3,563 | 0.53 | -0.01 | 2022-08-28 | 01:29AM | |||||
184816 | 184816 | 462.0 | LAWRENCE MS | OPEN | green | 11 | 0 | Past 7 days (8/23/2022 - 8/29/2022) | 16 | 10 | 0.74 | 0.37 | Canoga Park/ChatsworthCoS | 72 | 0.41 | -0.34 | 220 | 6,719 | 2,851 | 0.43 | -0.17 | 2022-08-30 | 01:36AM | |||||
212889 | 212889 | 497.0 | LOS ANGELES SH | OPEN | green | 10 | 0 | Past 7 days (11/27/2022 - 12/3/2022) | 37 | 10 | 0.78 | 0.70 | LA Mid-City CoS | 33 | 0.41 | 0.3 | 120 | 8,445 | 2,802 | 0.45 | 0.33 | 2022-12-04 | 01:38AM | |||||
214396 | 214396 | 208.0 | CLEVELAND CHS | OPEN | green | 22 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 12 | 10 | 0.33 | -0.30 | Cleveland CoS | 49 | 0.41 | -0.14 | 86 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
214944 | 214944 | 756.0 | STAGG ST EL | OPEN | green | 10 | 0 | Past 7 days (11/29/2022 - 12/5/2022) | 12 | 10 | 1.8 | 1.26 | Cleveland CoS | 49 | 0.41 | -0.14 | 86 | 4,122 | 1,922 | 0.31 | -0.05 | 2022-12-06 | 01:39AM | |||||
180285 | 180285 | 421.0 | INTERNATIONAL ST LC | OPEN | green | 11 | 0 | Past 7 days (8/10/2022 - 8/16/2022) | 20 | 10 | 0.87 | 0.78 | South Gate CoS | 77 | 0.42 | 0.3 | 330 | 8,433 | 2,458 | 0.38 | 0.28 | 2022-08-17 | 01:37AM | |||||
180688 | 180688 | 824.0 | VERDGO HLS SH | OPEN | green | 10 | 0 | Past 7 days (8/10/2022 - 8/16/2022) | 94 | 10 | 0.62 | 0.50 | Sunland/Tujunga CoS | 21 | 0.42 | 0.28 | 160 | 8,433 | 2,458 | 0.38 | 0.28 | 2022-08-17 | 01:37AM | |||||
211038 | 211038 | 442.0 | KING MS MAG FLM/MDIA | OPEN | green | 10 | 0 | Past 7 days (11/23/2022 - 11/29/2022) | 43 | 10 | 0.53 | 0.42 | Glassell Park/Los Feliz CoS | 47 | 0.42 | 0.35 | 140 | 7,320 | 1,964 | 0.31 | 0.24 | 2022-11-30 | 01:37AM | |||||
211128 | 211128 | 532.0 | MARSHALL SH | OPEN | green | 7 | 0 | Past 7 days (11/23/2022 - 11/29/2022) | 15 | 10 | 0.46 | 0.41 | Glassell Park/Los Feliz CoS | 47 | 0.42 | 0.35 | 140 | 7,320 | 1,964 | 0.31 | 0.24 | 2022-11-30 | 01:37AM | |||||
212166 | 212166 | 672.0 | REED MS | OPEN | green | 9 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 20 | 10 | 0.63 | 0.57 | North Hollywood/ValleyVillage CoS | 58 | 0.42 | 0.33 | 144 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM | |||||
213949 | 213949 | 659.0 | PORTOLA CM | OPEN | green | 12 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 11 | 10 | 0.63 | 0.32 | Taft CoS | 62 | 0.42 | 0.16 | 103 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
214046 | 214046 | 756.0 | STAGG ST EL | OPEN | green | 11 | 0 | Past 7 days (11/28/2022 - 12/4/2022) | 13 | 10 | 1.8 | 1.26 | Cleveland CoS | 51 | 0.42 | -0.07 | 88 | 4,210 | 2,143 | 0.34 | 0.06 | 2022-12-05 | 01:35AM | |||||
180371 | 180371 | 507.0 | MADISON MS | OPEN | green | 9 | 0 | Past 7 days (8/10/2022 - 8/16/2022) | 18 | 10 | 0.64 | 0.64 | Van Nuys/Valley Glen CoS | 85 | 0.43 | 0.34 | 345 | 8,433 | 2,458 | 0.38 | 0.28 | 2022-08-17 | 01:37AM | |||||
187523 | 187523 | 475.0 | LIBERTY BLVD EL | OPEN | green | 13 | 1 | Past 7 days (8/26/2022 - 9/1/2022) | 18 | 10 | 1.73 | -1.56 | South Gate CoS | 81 | 0.43 | -0.5 | 202 | 5,269 | 2,346 | 0.35 | -0.29 | 2022-09-02 | 01:29AM | |||||
216142 | 216142 | 158.0 | CANOGA PRK SH | OPEN | green | 11 | 0 | Past 7 days (12/1/2022 - 12/7/2022) | 17 | 10 | 0.61 | 0.24 | Canoga Park/ChatsworthCoS | 68 | 0.43 | -0.15 | 179 | 5,650 | 2,506 | 0.4 | -0.07 | 2022-12-08 | 01:39AM | |||||
216580 | 216580 | 596.0 | NOBEL CMS | OPEN | yellow | 14 | 0 | Past 7 days (12/1/2022 - 12/7/2022) | 42 | 10 | 0.43 | -0.12 | Canoga Park/ChatsworthCoS | 68 | 0.43 | -0.15 | 179 | 5,650 | 2,506 | 0.4 | -0.07 | 2022-12-08 | 01:39AM | |||||
182527 | 182527 | 867.0 | WHITE MS | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 10 | 0.61 | -0.12 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
211091 | 211091 | 495.0 | LOS ANGELES ACAD MS | OPEN | green | 10 | 0 | Past 7 days (11/23/2022 - 11/29/2022) | 20 | 10 | 0.9 | 0.90 | Historic Central Avenue CoS | 51 | 0.44 | 0.31 | 113 | 7,320 | 1,964 | 0.31 | 0.24 | 2022-11-30 | 01:37AM | |||||
212328 | 212328 | 834.0 | VIRGIL MS | OPEN | green | 11 | 0 | Past 7 days (11/25/2022 - 12/1/2022) | 35 | 10 | 0.88 | 0.70 | Downtown CoS | 47 | 0.44 | 0.36 | 157 | 8,629 | 2,662 | 0.43 | 0.37 | 2022-12-02 | 01:32AM |
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 );