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.
41 rows where pos = 86
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87541 | 87541 | 280.0 | ELIZABETH LC | OPEN | green | 84 | 0 | Past 7 days (12/30/2021 - 1/5/2022) | 785 | 86 | 10.96 | -89.04 | Bell/Cudahy/MaywoodCoS | 5,998 | 240 | 4.00 | -53.69 | 170,585 | 6940 | 4.07 | -63.09 | 2022-01-06 | 10:00PM | |||||
88350 | 88350 | 202.0 | CITY OF ANGELS | OPEN | green | 73 | 0 | Past 7 days (12/31/2021 - 1/6/2022) | 1,039 | 86 | 8.28 | -25.05 | (Blank) | (Bla… | (Bla… | (Bla… | 250,361 | 18K | 7.22 | -61.62 | 2022-01-07 | 10:00PM | ||||||
89792 | 89792 | 757.0 | STEVENSON CCP | OPEN | green | 71 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 893 | 86 | 9.63 | -90.37 | Boyle Heights CoS | 8,336 | 890 | 10.68 | -46.08 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-08 | 10:00PM | |||||
90033 | 90033 | 111.0 | BETHUNE MS | OPEN | green | 81 | 0 | Past 7 days (1/2/2022 - 1/8/2022) | 755 | 86 | 11.39 | 0.00 | Fremont CoS | 9,946 | 1354 | 13.61 | -56.39 | 366,626 | 46K | 12.55 | -53.77 | 2022-01-09 | 10:00PM | |||||
90412 | 90412 | 490.0 | LOS ANGELES EL | OPEN | green | 83 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 459 | 86 | 18.74 | -41.26 | Kreatwn/PcoUnion CoS | 8,775 | 1436 | 16.36 | -41.78 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
90588 | 90588 | 666.0 | RAYMOND AVE EL | OPEN | green | 82 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 401 | 86 | 21.45 | -78.55 | H.E.E.T. (W) CoS | 3,277 | 614 | 18.74 | -53.99 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
90619 | 90619 | 697.0 | ROSCOE EL | OPEN | green | 81 | 0 | Past 7 days (1/3/2022 - 1/9/2022) | 452 | 86 | 19.03 | -30.97 | Sun Valley CoS | 12,394 | 2087 | 16.84 | -51.65 | 414,198 | 62K | 14.99 | -51.26 | 2022-01-09 | 10:00PM | |||||
91439 | 91439 | 630.0 | PARKS LC | OPEN | green | 78 | 0 | Past 7 days (1/4/2022 - 1/10/2022) | 568 | 86 | 15.14 | -7.59 | Monroe CoS | 12,066 | 1806 | 14.97 | -7.20 | 457,589 | 66K | 14.32 | -7.86 | 2022-01-10 | 10:00PM | |||||
91704 | 91704 | 8.0 | 135TH ST EL | OPEN | green | 91 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 506 | 86 | 17.00 | 7.82 | Gardena CoS | 9,728 | 1369 | 14.07 | -3.13 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
91861 | 91861 | 165.0 | CARSON ACAD MED ARTS | OPEN | green | 76 | 0 | Past 7 days (1/5/2022 - 1/11/2022) | 429 | 86 | 20.05 | 0.20 | Carson CoS | 11,449 | 1949 | 17.02 | -1.88 | 484,600 | 67K | 13.75 | -2.24 | 2022-01-11 | 10:00PM | |||||
92590 | 92590 | 7.0 | 122ND ST EL | OPEN | green | 99 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 377 | 86 | 22.81 | 4.90 | Fremont CoS | 13,885 | 2155 | 15.52 | -1.76 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
92604 | 92604 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 104 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,294 | 86 | 6.65 | -9.50 | Manual Arts/VermontSquare CoS | 11,529 | 1344 | 11.66 | -4.73 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
92688 | 92688 | 105.0 | BELVEDERE EL | OPEN | green | 96 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 809 | 86 | 10.63 | -0.93 | East Los Angeles CoS | 15,372 | 1647 | 10.71 | -2.79 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
92827 | 92827 | 244.0 | DBM | OPEN | green | 101 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,301 | 86 | 6.61 | -5.33 | Downtown CoS | 11,774 | 1086 | 9.22 | -3.96 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93122 | 93122 | 539.0 | MENDEZ SH | OPEN | green | 103 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,236 | 86 | 6.96 | -4.70 | Boyle Heights CoS | 13,170 | 1606 | 12.19 | -1.97 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93276 | 93276 | 693.0 | ROMER MS | OPEN | green | 116 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,199 | 86 | 7.17 | -8.45 | North Hollywood/ValleyVillage CoS | 12,665 | 1301 | 10.27 | -3.95 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93285 | 93285 | 702.0 | ROWAN AVE EL | OPEN | green | 114 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 752 | 86 | 11.44 | -0.94 | East Los Angeles CoS | 15,372 | 1647 | 10.71 | -2.79 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93316 | 93316 | 733.0 | SHERIDAN ST EL | OPEN | green | 94 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 745 | 86 | 11.54 | 0.04 | Boyle Heights CoS | 13,170 | 1606 | 12.19 | -1.97 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-13 | 10:00PM | |||||
93477 | 93477 | 7.0 | 122ND ST EL | OPEN | green | 99 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 377 | 86 | 22.81 | 4.90 | Fremont CoS | 13,885 | 2155 | 15.52 | -1.76 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
93491 | 93491 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 104 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,294 | 86 | 6.65 | -9.50 | Manual Arts/VermontSquare CoS | 11,529 | 1344 | 11.66 | -4.73 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
93575 | 93575 | 105.0 | BELVEDERE EL | OPEN | green | 96 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 809 | 86 | 10.63 | -0.93 | East Los Angeles CoS | 15,372 | 1647 | 10.71 | -2.79 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
93714 | 93714 | 244.0 | DBM | OPEN | green | 101 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,301 | 86 | 6.61 | -5.33 | Downtown CoS | 11,774 | 1086 | 9.22 | -3.96 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
94009 | 94009 | 539.0 | MENDEZ SH | OPEN | green | 103 | 0 | Past 7 days (1/7/2022 - 1/13/2022) | 1,236 | 86 | 6.96 | -4.70 | Boyle Heights CoS | 13,170 | 1606 | 12.19 | -1.97 | 523,523 | 61K | 11.63 | -3.72 | 2022-01-14 | 10:00PM | |||||
94524 | 94524 | 167.0 | CARSON ST EL | OPEN | green | 122 | 0 | Past 7 days (1/8/2022 - 1/14/2022) | 698 | 86 | 12.32 | -5.39 | Carson CoS | 12,548 | 1452 | 11.57 | -6.70 | 537,667 | 54K | 10.12 | -5.9 | 2022-01-15 | 10:00PM | |||||
94610 | 94610 | 253.0 | DODSON MS | OPEN | green | 56 | 0 | Past 7 days (1/8/2022 - 1/14/2022) | 1,625 | 86 | 6.11 | -8.92 | Van Nuys/Valley Glen CoS | 12,456 | 1099 | 8.94 | -8.07 | 537,667 | 54K | 10.12 | -5.9 | 2022-01-15 | 10:00PM | |||||
94705 | 94705 | 348.0 | GRAHAM EL | OPEN | green | 113 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 676 | 86 | 12.72 | -6.47 | Rivera CoS | 14,120 | 2051 | 14.53 | -3.55 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95034 | 95034 | 677.0 | RFK UCLA COMM SCH | OPEN | green | 151 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 930 | 86 | 9.25 | -6.56 | Kreatwn/PcoUnion CoS | 11,147 | 1321 | 11.85 | -5.16 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95121 | 95121 | 764.0 | SUNNY BRAE AVE EL | OPEN | green | 112 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 566 | 86 | 15.19 | -3.74 | Cleveland CoS | 11,367 | 1316 | 11.58 | -5.82 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-15 | 10:00PM | |||||
95331 | 95331 | 87.0 | BACA ARTS ACAD | OPEN | green | 116 | 0 | Past 7 days (1/9/2022 - 1/15/2022) | 592 | 86 | 14.53 | -2.27 | Rivera CoS | 14,120 | 2051 | 14.53 | -3.55 | 494,110 | 55K | 11.15 | -4.86 | 2022-01-16 | 10:00PM | |||||
95536 | 95536 | 292.0 | ESPERANZA EL | OPEN | green | 126 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 549 | 86 | 15.66 | -5.69 | MacArthur Park CoS | 6,497 | 892 | 13.73 | -5.89 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95628 | 95628 | 384.0 | HAZELTINE AVE EL | OPEN | green | 115 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 630 | 86 | 13.65 | -4.82 | Van Nuys/Valley Glen CoS | 16,566 | 1852 | 11.18 | -4.51 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95702 | 95702 | 458.0 | LE CONTE MS | OPEN | green | 112 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 679 | 86 | 12.67 | -3.69 | Hollywood CoS | 7,359 | 738 | 10.03 | -6.36 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
95929 | 95929 | 685.0 | RIVERA LC GD STEAM AC | OPEN | green | 101 | 0 | Past 7 days (1/10/2022 - 1/16/2022) | 577 | 86 | 14.90 | -1.93 | Rivera CoS | 13,179 | 2001 | 15.18 | -3.22 | 465,323 | 52K | 11.25 | -4.68 | 2022-01-16 | 10:00PM | |||||
96784 | 96784 | 653.0 | PORTER RANCH SCHOOL | OPEN | green | 74 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 1,330 | 86 | 6.47 | -3.84 | Canoga Park/ChatsworthCoS | 12,415 | 1111 | 8.95 | -6.03 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
96834 | 96834 | 703.0 | ROYBAL LC | OPEN | green | 108 | 0 | Past 7 days (1/11/2022 - 1/17/2022) | 1,071 | 86 | 8.03 | -5.59 | Downtown CoS | 8,639 | 784 | 9.08 | -5.07 | 413,084 | 42K | 10.15 | -6.08 | 2022-01-17 | 10:00PM | |||||
97965 | 97965 | 60.0 | ALTA CALIFORNIA EL | OPEN | green | 94 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 600 | 86 | 14.33 | -4.37 | Monroe CoS | 9,867 | 952 | 9.65 | -6.34 | 425,333 | 36K | 8.45 | -7.03 | 2022-01-19 | 10:00PM | |||||
98226 | 98226 | 321.0 | FULTON COLLEGE PREP | OPEN | green | 90 | 0 | Past 7 days (1/12/2022 - 1/18/2022) | 954 | 86 | 9.01 | -7.84 | Panorama City CoS | 5,675 | 641 | 11.30 | -6.53 | 425,333 | 36K | 8.45 | -7.03 | 2022-01-19 | 10:00PM | |||||
99721 | 99721 | 42.0 | 93RD ST EL | OPEN | green | 133 | 0 | Past 7 days (1/15/2022 - 1/21/2022) | 743 | 86 | 11.57 | -8.37 | Fremont CoS | 10,800 | 1173 | 10.86 | -5.57 | 402,500 | 28K | 7.04 | -4.93 | 2022-01-22 | 10:00PM | |||||
100548 | 100548 | 869.0 | WILSON SH | OPEN | green | 122 | 0 | Past 7 days (1/16/2022 - 1/22/2022) | 1,104 | 86 | 7.79 | -4.62 | Lincoln Heights/El SerenoCoS | 10,085 | 771 | 7.65 | -3.81 | 391,576 | 31K | 7.84 | -3.85 | 2022-01-22 | 10:00PM | |||||
101342 | 101342 | 775.0 | TAFT CHS | OPEN | green | 85 | 0 | Past 7 days (1/18/2022 - 1/24/2022) | 1,707 | 86 | 5.04 | -4.64 | Taft CoS | 10,884 | 496 | 4.56 | -3.34 | 379,251 | 29K | 7.71 | -2.6 | 2022-01-23 | 10:00PM | |||||
169187 | 169187 | 231.0 | CRENSHAW ARTS TECH | OPEN | green | 2 | 0 | Past 7 days (6/7/2022 - 6/13/2022) | CRENSHAW ARTS TECH | 86 | 0 | 0.00 | (Blank) | (Bla… | (Bla… | (Bla… | 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 );