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-11-01 sorted by tests descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198010 | 198010 | 86.0 | AUDUBON MS | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 2 | 0.4 | 0.00 | H.E.E.T. (C/D) CoS | 3 | 0.07 | 0.00 | 13 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198051 | 198051 | 127.0 | BRIDGE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 0 | 0.0 | 0.00 | Boyle Heights CoS | 6 | 0.05 | 0.01 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198139 | 198139 | 215.0 | COEUR D ALENE AVE EL | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 4 | 0.86 | 0.00 | Venice CoS | 12 | 0.13 | -0.07 | 34 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198181 | 198181 | 257.0 | DODSON MS | OPEN | green | 6 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 8 | 0.57 | 0.43 | San Pedro CoS | 17 | 0.15 | 0.06 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198404 | 198404 | 480.0 | LINCOLN SH | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 4 | 0.34 | -0.59 | Lincoln Heights/El SerenoCoS | 11 | 0.08 | -0.08 | 27 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198520 | 198520 | 596.0 | NOBEL CMS | OPEN | yellow | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 9 | 2 | 0.08 | -0.17 | Canoga Park/ChatsworthCoS | 12 | 0.08 | -0.05 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197964 | 197964 | 40.0 | 7TH ST EL AI MAG | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 4 | 1.03 | 0.00 | San Pedro CoS | 17 | 0.15 | 0.06 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198355 | 198355 | 431.0 | JUSTICE ST ACAD CHTR | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 1 | 0.23 | -0.24 | Taft CoS | 15 | 0.1 | -0.04 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198359 | 198359 | 435.0 | KENTER CANYON EC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 1 | 0.19 | -0.20 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198445 | 198445 | 521.0 | MARIANNA AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 2 | 0.56 | 0.56 | East Los Angeles CoS | 17 | 0.12 | -0.01 | 30 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198485 | 198485 | 561.0 | MIRAMONTE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 0 | 0.0 | -0.13 | Rivera CoS | 8 | 0.06 | 0.01 | 19 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198813 | 198813 | 889.0 | WOODLAKE ECC | OPEN | yellow | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 8 | 2 | 0.3 | 0.30 | Taft CoS | 15 | 0.1 | -0.04 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198148 | 198148 | 224.0 | COMMUNITY EL MAG CS | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 7 | 3 | 0.62 | 0.00 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198259 | 198259 | 335.0 | GARFIELD SH | OPEN | green | 5 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 7 | 4 | 0.16 | 0.00 | East Los Angeles CoS | 17 | 0.12 | -0.01 | 30 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198596 | 198596 | 672.0 | REED MS | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 7 | 3 | 0.19 | -0.12 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | -0.08 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198746 | 198746 | 822.0 | VENICE SH | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 7 | 4 | 0.17 | 0.00 | Venice CoS | 12 | 0.13 | -0.07 | 34 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198755 | 198755 | 831.0 | VINE ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 7 | 0 | 0.0 | 0.00 | Hollywood CoS | 6 | 0.08 | -0.01 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197985 | 197985 | 61.0 | ALTA CALIFORNIA EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 1 | 0.14 | 0.00 | Monroe CoS | 7 | 0.05 | 0.00 | 16 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198349 | 198349 | 425.0 | IVANHOE EL | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 4 | 0.85 | 0.64 | Glassell Park/Los Feliz CoS | 16 | 0.14 | 0.06 | 37 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198456 | 198456 | 532.0 | MARSHALL SH | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 3 | 0.14 | -0.04 | Glassell Park/Los Feliz CoS | 16 | 0.14 | 0.06 | 37 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198579 | 198579 | 655.0 | POLYTECHNIC SH | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 3 | 0.12 | 0.08 | Sun Valley CoS | 12 | 0.08 | 0.02 | 20 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198631 | 198631 | 707.0 | ROYBAL LC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 3 | 0.24 | 0.16 | Downtown CoS | 10 | 0.09 | 0.05 | 21 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198722 | 198722 | 798.0 | TULSA ST EL | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 6 | 1.3 | 0.87 | Kennedy/NAHS/VAAS CoS | 20 | 0.13 | 0.01 | 31 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198774 | 198774 | 850.0 | WEBSTER MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 6 | 1 | 0.2 | -0.39 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198146 | 198146 | 222.0 | COLUMBUS MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 1 | 0.13 | -0.26 | Canoga Park/ChatsworthCoS | 12 | 0.08 | -0.05 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198294 | 198294 | 370.0 | HALE CA | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 2 | 0.1 | 0.00 | Taft CoS | 15 | 0.1 | -0.04 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198304 | 198304 | 380.0 | HARRISON ST EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 0 | 0.0 | -0.28 | Lincoln Heights/El SerenoCoS | 11 | 0.08 | -0.08 | 27 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198314 | 198314 | 390.0 | HELIOTROPE AVE EL | OPEN | green | 5 | 5 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 1 | 0.17 | -1.05 | Bell/Cudahy/Maywood CoS | 22 | 0.14 | 0.02 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198419 | 198419 | 495.0 | LOS ANGELES ACAD MS | OPEN | green | 5 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 5 | 0.45 | 0.27 | Historic Central Avenue CoS | 11 | 0.1 | 0.00 | 16 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198474 | 198474 | 550.0 | MICHELTORENA ST EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 1 | 0.26 | 0.00 | Glassell Park/Los Feliz CoS | 16 | 0.14 | 0.06 | 37 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198519 | 198519 | 595.0 | NO HOLLYWD SH | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 4 | 0.15 | 0.11 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | -0.08 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198618 | 198618 | 694.0 | ROCKDALE VAPA MAG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 0 | 0.0 | 0.00 | Eagle Rock/Highland ParkCoS | 11 | 0.1 | 0.04 | 33 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198675 | 198675 | 751.0 | SOUTH GATE MS | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 4 | 0.27 | 0.20 | South Gate CoS | 17 | 0.1 | 0.01 | 25 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198733 | 198733 | 809.0 | VALERIO ST EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 1 | 0.11 | -0.23 | Panorama City CoS | 16 | 0.21 | 0.11 | 23 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198743 | 198743 | 819.0 | VANALDEN AVE EL | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 4 | 0.88 | 0.66 | Reseda CoS | 12 | 0.1 | 0.05 | 17 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198751 | 198751 | 827.0 | VICTORIA AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 2 | 0.55 | 0.55 | South Gate CoS | 17 | 0.1 | 0.01 | 25 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198777 | 198777 | 853.0 | WELBY WAY CEL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 5 | 1 | 0.12 | -0.37 | Taft CoS | 15 | 0.1 | -0.04 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197948 | 197948 | 24.0 | 3RD ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.14 | -0.40 | Fairfax CoS | 5 | 0.06 | -0.05 | 14 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198020 | 198020 | 96.0 | BANCROFT MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.19 | 0.19 | Hollywood CoS | 6 | 0.08 | -0.01 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198030 | 198030 | 106.0 | BELL SH | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 4 | 0.15 | 0.15 | Bell/Cudahy/Maywood CoS | 22 | 0.14 | 0.02 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198076 | 198076 | 152.0 | CALAHAN ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 0 | 0.0 | -0.91 | Cleveland CoS | 30 | 0.25 | 0.01 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198248 | 198248 | 324.0 | FROST MS | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 3 | 0.19 | 0.06 | Kennedy/NAHS/VAAS CoS | 20 | 0.13 | 0.01 | 31 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198272 | 198272 | 348.0 | GLENFELIZ BLVD EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.41 | 0.41 | Glassell Park/Los Feliz CoS | 16 | 0.14 | 0.06 | 37 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198305 | 198305 | 381.0 | HART ST EL | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 4 | 0.48 | 0.48 | Canoga Park/ChatsworthCoS | 12 | 0.08 | -0.05 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198325 | 198325 | 401.0 | HOLLYWOOD SH | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.08 | 0.00 | Hollywood CoS | 6 | 0.08 | -0.01 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198345 | 198345 | 421.0 | INTERNATIONAL ST LC | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 3 | 0.3 | 0.20 | South Gate CoS | 17 | 0.1 | 0.01 | 25 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198394 | 198394 | 470.0 | LELAND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 0 | 0.0 | 0.00 | San Pedro CoS | 17 | 0.15 | 0.06 | 28 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198444 | 198444 | 520.0 | MAR VISTA EL | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.17 | -0.16 | Venice CoS | 12 | 0.13 | -0.07 | 34 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198482 | 198482 | 558.0 | MILLER CTC | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 0 | 0.0 | -1.18 | Cleveland CoS | 30 | 0.25 | 0.01 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198635 | 198635 | 711.0 | SAN ANTONIO EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 2 | 0.36 | 0.18 | Huntington Park/VernonCoS | 6 | 0.04 | -0.04 | 11 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198724 | 198724 | 800.0 | UNION AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 2 | 0.21 | 0.21 | MacArthur Park CoS | 4 | 0.05 | -0.03 | 6 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198741 | 198741 | 817.0 | VAN NUYS SH | OPEN | green | 5 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 4 | 0.16 | 0.12 | Van Nuys/Valley Glen CoS | 16 | 0.09 | -0.01 | 38 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198758 | 198758 | 834.0 | VIRGIL MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 2 | 0.17 | 0.17 | Downtown CoS | 10 | 0.09 | 0.05 | 21 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198770 | 198770 | 846.0 | WARNER AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 3 | 0.47 | 0.31 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198779 | 198779 | 855.0 | WEST ADAMS PREP SH | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 3 | 0.24 | 0.16 | Kreatwn/PcoUnion CoS | 12 | 0.11 | 0.04 | 20 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198789 | 198789 | 865.0 | WESTWOOD CEL | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 3 | 0.43 | 0.14 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198791 | 198791 | 867.0 | WHITE MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 4 | 1 | 0.06 | -0.20 | Carson CoS | 5 | 0.04 | -0.04 | 12 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198091 | 198091 | 167.0 | CARPENTER COMM CHTR | OPEN | yellow | 5 | 1 | Past 7 days (10/25/2022 - 10/31/2022) | 31 | 5 | 0.53 | -0.63 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | -0.08 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197931 | 197931 | 7.0 | 122ND ST EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.15 | -0.14 | Fremont CoS | 12 | 0.08 | 0.01 | 15 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197945 | 197945 | 21.0 | 32ND ST USC PA MAG | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.3 | 0.10 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198018 | 198018 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.27 | 0.14 | Kennedy/NAHS/VAAS CoS | 20 | 0.13 | 0.01 | 31 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198039 | 198039 | 115.0 | BETHUNE MS | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.31 | 0.21 | Fremont CoS | 12 | 0.08 | 0.01 | 15 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198054 | 198054 | 130.0 | BROAD AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.16 | Wilmington CoS | 1 | 0.01 | -0.06 | 8 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198085 | 198085 | 161.0 | CANYON CEL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.46 | West LA CoS | 18 | 0.17 | -0.05 | 52 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198095 | 198095 | 171.0 | CARSON ST EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.14 | 0.14 | Carson CoS | 5 | 0.04 | -0.04 | 12 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198100 | 198100 | 176.0 | CASTELAR ST EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.31 | 0.31 | Downtown CoS | 10 | 0.09 | 0.05 | 21 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198124 | 198124 | 200.0 | CHAVEZ LA SJ HUM AC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.2 | -0.40 | San Fernando Valley/SylmarCoS | 8 | 0.04 | -0.10 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198131 | 198131 | 207.0 | CITY TERRACE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.23 | -0.22 | Lincoln Heights/El SerenoCoS | 11 | 0.08 | -0.08 | 27 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198166 | 198166 | 242.0 | DAHLIA HTS EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.24 | -0.24 | Eagle Rock/Highland ParkCoS | 11 | 0.1 | 0.04 | 33 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198230 | 198230 | 306.0 | FAIR AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.29 | 0.29 | North Hollywood/ValleyVillage CoS | 19 | 0.14 | -0.08 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198241 | 198241 | 317.0 | FORD BLVD EL | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.31 | 0.31 | East Los Angeles CoS | 17 | 0.12 | -0.01 | 30 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198252 | 198252 | 328.0 | GAL KING SCH FOR STEM | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.12 | 0.00 | LA Mid-City CoS | 8 | 0.1 | 0.01 | 14 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198278 | 198278 | 354.0 | GRANADA EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.22 | -0.44 | Kennedy/NAHS/VAAS CoS | 20 | 0.13 | 0.01 | 31 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198293 | 198293 | 369.0 | HADDON AVE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.50 | San Fernando Valley/SylmarCoS | 8 | 0.04 | -0.10 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198297 | 198297 | 373.0 | HAMILTON SH | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.08 | -0.04 | Hamilton CoS | 7 | 0.08 | 0.01 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198396 | 198396 | 472.0 | LEMAY ST EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.72 | 0.72 | Reseda CoS | 12 | 0.1 | 0.05 | 17 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198418 | 198418 | 494.0 | LORNE ST EL | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.74 | 0.24 | Cleveland CoS | 30 | 0.25 | 0.01 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198449 | 198449 | 525.0 | MARK TWAIN MS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.31 | Venice CoS | 12 | 0.13 | -0.07 | 34 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198497 | 198497 | 573.0 | MOUNT GLEASON MS | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | 0.00 | Sunland/Tujunga CoS | 2 | 0.04 | 0.04 | 7 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198536 | 198536 | 611.0 | OCHOA LC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.15 | 0.15 | Bell/Cudahy/Maywood CoS | 22 | 0.14 | 0.02 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198562 | 198562 | 638.0 | PARTHENIA AC ART TEC | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.39 | 0.39 | Monroe CoS | 7 | 0.05 | 0.00 | 16 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198563 | 198563 | 639.0 | PASEO DEL REY ACAD | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -2.14 | Westchester CoS | 2 | 0.05 | -0.10 | 6 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198577 | 198577 | 653.0 | POINDEXTER LAMOTTE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.19 | 0.00 | Manual Arts/VermontSquare CoS | 6 | 0.06 | -0.03 | 10 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198581 | 198581 | 657.0 | PORTER MS | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.18 | -0.09 | Kennedy/NAHS/VAAS CoS | 20 | 0.13 | 0.01 | 31 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198600 | 198600 | 676.0 | RFK AMBSDR GLBL EDU | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.27 | 0.00 | Kreatwn/PcoUnion CoS | 12 | 0.11 | 0.04 | 20 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198605 | 198605 | 681.0 | RFK UCLA COMM SCH | OPEN | green | 3 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 3 | 0.28 | 0.19 | Kreatwn/PcoUnion CoS | 12 | 0.11 | 0.04 | 20 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198623 | 198623 | 699.0 | ROOSEVELT SH | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.11 | Boyle Heights CoS | 6 | 0.05 | 0.01 | 22 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198625 | 198625 | 701.0 | ROSCOE EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | 0.00 | Sun Valley CoS | 12 | 0.08 | 0.02 | 20 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198630 | 198630 | 706.0 | ROWAN AVE EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.26 | 0.13 | East Los Angeles CoS | 17 | 0.12 | -0.01 | 30 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198645 | 198645 | 721.0 | SAN PASCUAL STEAM MG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 1 | 0.38 | 0.38 | Eagle Rock/Highland ParkCoS | 11 | 0.1 | 0.04 | 33 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198740 | 198740 | 816.0 | VAN NUYS MS | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.2 | 0.10 | Van Nuys/Valley Glen CoS | 16 | 0.09 | -0.01 | 38 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198797 | 198797 | 873.0 | WILLOW EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 2 | 0.38 | 0.19 | South Gate CoS | 17 | 0.1 | 0.01 | 25 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198800 | 198800 | 876.0 | WILMINGTON STEAM MAG | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.28 | Wilmington CoS | 1 | 0.01 | -0.06 | 8 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198814 | 198814 | 890.0 | WOODLAND HILLS ACAD | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 3 | 0 | 0.0 | -0.29 | Taft CoS | 15 | 0.1 | -0.04 | 57 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198132 | 198132 | 208.0 | CLEVELAND CHS | OPEN | green | 24 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 27 | 22 | 0.72 | 0.23 | Cleveland CoS | 30 | 0.25 | 0.01 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
198209 | 198209 | 285.0 | ELIZABETH LC | OPEN | green | 4 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 26 | 8 | 0.51 | 0.45 | Bell/Cudahy/Maywood CoS | 22 | 0.14 | 0.02 | 48 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197924 | 197924 | 0.0 | 107TH ST EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 2 | 0.2 | 0.10 | Fremont CoS | 12 | 0.08 | 0.01 | 15 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197949 | 197949 | 25.0 | 42ND ST EL | OPEN | green | 0 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 0 | 0.0 | 0.00 | H.E.E.T. (C/D) CoS | 3 | 0.07 | 0.00 | 13 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197950 | 197950 | 26.0 | 49TH ST EL | OPEN | green | 2 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 2 | 0.3 | 0.15 | Historic Central Avenue CoS | 11 | 0.1 | 0.00 | 16 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM | |||||
197960 | 197960 | 36.0 | 6TH AVE EL | OPEN | green | 1 | 0 | Past 7 days (10/25/2022 - 10/31/2022) | 2 | 1 | 0.22 | 0.22 | LA Mid-City CoS | 8 | 0.1 | 0.01 | 14 | 1,048 | 487 | 0.08 | -0.01 | 2022-11-01 | 01:31AM |
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 );