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.
48 rows where pos = 83
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88699 | 88699 | 551.0 | MILES AVE EL | OPEN | green | 75 | 0 | Past 7 days (1/1/2022 - 1/7/2022) | 668 | 83 | 12.43 | -37.57 | Huntington Park/VernonCoS | 9,795 | 905 | 9.24 | -39.15 | 331,213 | 26K | 7.99 | -60.73 | 2022-01-07 | 10:00PM | |||||
89155 | 89155 | 120.0 | BRAVO SH MEDICAL MAG | OPEN | green | 78 | 0 | Past 7 days (1/1/2022 - 1/7/2022) | 1,142 | 83 | 7.27 | -26.06 | Lincoln Heights/El SerenoCoS | 8,591 | 663 | 7.72 | -49.42 | 331,213 | 26K | 7.99 | -60.73 | 2022-01-08 | 10:00PM | |||||
89306 | 89306 | 271.0 | EDISON MS | OPEN | green | 79 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 693 | 83 | 11.98 | 0.00 | Rivera CoS | 9,817 | 1295 | 13.19 | -69.42 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
89399 | 89399 | 364.0 | HADDON AVE EL | OPEN | green | 76 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 594 | 83 | 13.97 | -36.03 | San FernandoValley/Sylmar CoS | 12,625 | 1625 | 12.87 | -46.85 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
89459 | 89459 | 424.0 | JORDAN SH | OPEN | green | 78 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 628 | 83 | 13.22 | -86.78 | Fremont CoS | 9,946 | 1354 | 13.61 | -56.39 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
89594 | 89594 | 559.0 | MONLUX EL | OPEN | green | 77 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 555 | 83 | 14.95 | -85.05 | Van Nuys/Valley Glen CoS | 12,602 | 1679 | 13.32 | -52.59 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
89754 | 89754 | 719.0 | SAN PEDRO ST EL | OPEN | green | 80 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 458 | 83 | 18.12 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | ||||||
90183 | 90183 | 261.0 | DYER ST EL | OPEN | green | 73 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 564 | 83 | 14.72 | -85.28 | San FernandoValley/Sylmar CoS | 14,078 | 2297 | 16.32 | -47.90 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
90228 | 90228 | 306.0 | FIGUEROA ST EL | OPEN | green | 79 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 363 | 83 | 22.87 | 22.87 | Gardena CoS | 7,895 | 1288 | 16.31 | -44.22 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
90752 | 90752 | 830.0 | WADSWORTH AVE EL | OPEN | green | 83 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 481 | 83 | 17.26 | -32.74 | (Blank) | (Bla… | (Bla… | (Bla… | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | ||||||
90823 | 90823 | 14.0 | 20TH ST EL | OPEN | green | 83 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 500 | 83 | 16.60 | -10.07 | (Blank) | (Bla… | (Bla… | (Bla… | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | ||||||
91028 | 91028 | 219.0 | COMMONWLTH AVE EL | OPEN | green | 82 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 499 | 83 | 16.63 | -16.70 | MacArthur Park CoS | 6,609 | 1166 | 17.64 | -0.91 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91067 | 91067 | 258.0 | DORSEY SH | OPEN | green | 84 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 619 | 83 | 13.41 | -2.72 | H.E.E.T. (C/D) CoS | 3,071 | 502 | 16.35 | -7.97 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91579 | 91579 | 770.0 | SYLMAR EL | OPEN | green | 78 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 437 | 83 | 18.99 | -2.44 | San FernandoValley/Sylmar CoS | 15,759 | 2416 | 15.33 | -6.01 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91613 | 91613 | 804.0 | VAN NUYS EL | OPEN | green | 80 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 455 | 83 | 18.24 | 7.13 | Van Nuys/Valley Glen CoS | 16,246 | 2362 | 14.54 | -11.00 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91657 | 91657 | 848.0 | WEST VERNON AVE EL | OPEN | green | 76 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 526 | 83 | 15.78 | -21.72 | (Blank) | (Bla… | (Bla… | (Bla… | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | ||||||
92041 | 92041 | 345.0 | GOMPERS MS | OPEN | green | 94 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 403 | 83 | 20.60 | 7.09 | Achievement NetworkCoS | 5,368 | 903 | 16.82 | 1.02 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
92042 | 92042 | 346.0 | GOMPERS MS UP MED MAG | OPEN | green | 94 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 403 | 83 | 20.60 | 7.09 | Achievement NetworkCoS | 5,368 | 903 | 16.82 | 1.02 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
92046 | 92046 | 350.0 | GRAND VW BL EL | OPEN | green | 83 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 898 | 83 | 9.24 | -10.89 | Venice CoS | 9,334 | 891 | 9.55 | -6.74 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
92407 | 92407 | 711.0 | SAN FERNANDO MS | OPEN | green | 81 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 520 | 83 | 15.96 | 8.27 | San FernandoValley/Sylmar CoS | 16,283 | 2463 | 15.13 | -2.75 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
92423 | 92423 | 727.0 | SENDAK EL | OPEN | green | 75 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 389 | 83 | 21.34 | 8.84 | North Hollywood/ValleyVillage CoS | 11,759 | 1540 | 13.10 | -3.07 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
93197 | 93197 | 614.0 | ORTHOPAEDIC HSP SH MG | OPEN | green | 93 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 524 | 83 | 15.84 | 2.99 | (Blank) | (Bla… | (Bla… | (Bla… | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | ||||||
93464 | 93464 | 881.0 | WOODLAWN AVE EL | OPEN | green | 112 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 744 | 83 | 11.16 | -8.53 | Bell/Cudahy/MaywoodCoS | 15,907 | 1851 | 11.64 | -3.57 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93759 | 93759 | 289.0 | ESCALANTE EL | OPEN | green | 100 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 677 | 83 | 12.26 | -3.59 | Bell/Cudahy/MaywoodCoS | 15,907 | 1851 | 11.64 | -3.57 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
94084 | 94084 | 614.0 | ORTHOPAEDIC HSP SH MG | OPEN | green | 93 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 524 | 83 | 15.84 | 2.99 | (Blank) | (Bla… | (Bla… | (Bla… | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | ||||||
94421 | 94421 | 64.0 | AMESTOY EL | OPEN | green | 138 | 0 | Past 7 days (1/8/2022 - 1/14/2022) | 793 | 83 | 10.47 | -6.54 | Gardena CoS | 9,813 | 1021 | 10.40 | -6.85 | 537,667 | 54K | 10.12 | -5.9 | 2022-01-15 | 10:00PM | |||||
94500 | 94500 | 143.0 | BYRD MS | OPEN | green | 123 | 0 | Past 7 days (1/8/2022 - 1/14/2022) | 1,283 | 83 | 6.47 | -8.99 | Sun Valley CoS | 15,456 | 1494 | 9.67 | -7.45 | 537,667 | 54K | 10.12 | -5.9 | 2022-01-15 | 10:00PM | |||||
94826 | 94826 | 469.0 | LIBERTY BLVD EL | OPEN | green | 103 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 574 | 83 | 14.46 | -2.46 | South Gate CoS | 16,172 | 1818 | 11.24 | -4.27 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
94958 | 94958 | 601.0 | NORTHRIDGE MS | OPEN | green | 127 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 764 | 83 | 10.86 | -6.04 | Cleveland CoS | 11,367 | 1316 | 11.58 | -5.82 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95250 | 95250 | 6.0 | 118TH ST EL | OPEN | green | 126 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 516 | 83 | 16.09 | -5.73 | Fremont CoS | 13,652 | 2048 | 15.00 | -3.64 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-16 | 10:00PM | |||||
95411 | 95411 | 167.0 | CARSON ST EL | OPEN | green | 110 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 644 | 83 | 12.89 | -3.64 | Carson CoS | 11,912 | 1420 | 11.92 | -6.35 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-16 | 10:00PM | |||||
95472 | 95472 | 228.0 | COUGHLIN EL | OPEN | green | 100 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 518 | 83 | 16.02 | -4.43 | Sun Valley CoS | 14,278 | 1569 | 10.99 | -6.30 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-16 | 10:00PM | |||||
95555 | 95555 | 311.0 | FLOURNOY EL | OPEN | green | 94 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 451 | 83 | 18.40 | 2.40 | Achievement NetworkCoS | 4,793 | 788 | 16.44 | -3.61 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95805 | 95805 | 561.0 | MONTARA AVE EL | OPEN | green | 109 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 696 | 83 | 11.93 | -5.46 | South Gate CoS | 15,211 | 1703 | 11.20 | -4.23 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95817 | 95817 | 573.0 | MULHOLLAND MS | OPEN | green | 117 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 877 | 83 | 9.46 | -5.03 | Reseda CoS | 9,867 | 1112 | 11.27 | -4.14 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95845 | 95845 | 601.0 | NORTHRIDGE MS | OPEN | green | 107 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 736 | 83 | 11.28 | -5.11 | Cleveland CoS | 10,799 | 1242 | 11.50 | -5.73 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
96120 | 96120 | 876.0 | WOODCREST EL | OPEN | green | 120 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 592 | 83 | 14.02 | -6.61 | H.E.E.T. (W) CoS | 4,009 | 558 | 13.92 | -6.70 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
96344 | 96344 | 213.0 | COLDWATER CYN EL | OPEN | green | 72 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 439 | 83 | 12.98 | -2.30 | Monroe CoS | 15,042 | 1515 | 11.02 | -5.93 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
96517 | 96517 | 386.0 | HENRY MS | OPEN | green | 89 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 975 | 83 | 8.51 | -6.52 | Kennedy/NAHS/VAASCoS | 12,369 | 1045 | 8.45 | -6.00 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
96902 | 96902 | 771.0 | SYLMAR LDSHP ACAD | OPEN | green | 89 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 742 | 83 | 11.19 | -7.08 | San FernandoValley/Sylmar CoS | 14,136 | 1491 | 10.55 | -6.61 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
97231 | 97231 | 213.0 | COLDWATER CYN EL | OPEN | green | 78 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 586 | 83 | 14.16 | -2.30 | Van Nuys/Valley Glen CoS | 15,042 | 1515 | 10.07 | -5.93 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-18 | 10:00PM | |||||
97404 | 97404 | 386.0 | HENRY MS | OPEN | green | 89 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 975 | 83 | 8.51 | -6.52 | Kennedy/NAHS/VAASCoS | 12,369 | 1045 | 8.45 | -6.00 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-18 | 10:00PM | |||||
97789 | 97789 | 771.0 | SYLMAR LDSHP ACAD | OPEN | green | 62 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 747 | 83 | 11.11 | -6.64 | San FernandoValley/Sylmar CoS | 14,755 | 1327 | 8.99 | -7.36 | 425,333 | 36K | 8.45 | -7.03 | 2022-01-18 | 10:00PM | |||||
97831 | 97831 | 813.0 | VERDGO HLS SH | OPEN | green | 91 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 1,027 | 83 | 8.08 | -8.71 | Sunland/Tujunga CoS | 3,369 | 290 | 8.61 | -5.85 | 425,333 | 36K | 8.45 | -7.03 | 2022-01-18 | 10:00PM | |||||
98158 | 98158 | 253.0 | DODSON MS | OPEN | green | 90 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 1,264 | 83 | 6.57 | -9.10 | San Pedro CoS | 9,660 | 835 | 8.64 | -7.30 | 425,333 | 36K | 8.45 | -7.03 | 2022-01-19 | 10:00PM | |||||
101455 | 101455 | 0.0 | 107TH ST EL | OPEN | yellow | 73 | 16 | Past 7 days (1/18/2022 - 1/24/2022) | 592 | 83 | 14.02 | -1.29 | Fremont CoS | 11,705 | 1179 | 10.07 | -4.83 | 455,189 | 31K | 6.84 | -3.48 | 2022-01-24 | 10:00PM | |||||
101609 | 101609 | 154.0 | CANOGA PRK SH | OPEN | green | 67 | 0 | Past 7 days (1/18/2022 - 1/24/2022) | 1,926 | 83 | 4.31 | -6.40 | Canoga Park/ChatsworthCoS | 13,978 | 774 | 5.54 | -3.50 | 455,189 | 31K | 6.84 | -3.48 | 2022-01-24 | 10:00PM | |||||
169308 | 169308 | 352.0 | GRAND VW BL EL | OPEN | green | 9 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | GRAND VW BL EL | 83 | 2 | 2.41 | Venice CoS | 3,823 | 57 | 1.49 | -0.09 | 0.01 | 255,707 | 3,522 | 1.38 | 2022-06-14 | 01:41AM |
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 );