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-08-27 sorted by cos_pos_rate
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181711 | 181711 | 51.0 | ADDAMS HS | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.95 | 0.48 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181727 | 181727 | 67.0 | ANDASOL AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.56 | 0.19 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181754 | 181754 | 94.0 | BALBOA EL G/HG/HA MAG | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 9 | 1.14 | -0.38 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181838 | 181838 | 178.0 | CASTLEBAY LN CHTR | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.43 | -0.29 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181904 | 181904 | 244.0 | DANUBE AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.83 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181905 | 181905 | 245.0 | DARBY AVE EL | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 7 | 1.47 | 0.21 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181939 | 181939 | 279.0 | EL ORO WAY CES | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 0 | 0.0 | -0.40 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181984 | 181984 | 324.0 | FROST MS | OPEN | green | 17 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 17 | 16 | 0.88 | 0.22 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182014 | 182014 | 354.0 | GRANADA EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.84 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182044 | 182044 | 384.0 | HASKELL EL STEAM MAG | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 10 | 7 | 1.1 | 0.31 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182051 | 182051 | 391.0 | HENRY MS | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 11 | 0.84 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182094 | 182094 | 434.0 | KENNEDY SH | OPEN | green | 19 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 26 | 16 | 0.5 | -0.19 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182106 | 182106 | 446.0 | KNOLLWOOD PREP ACAD | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.41 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182195 | 182195 | 535.0 | MAYALL ST AC A/T MAG | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 5 | 0.93 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182264 | 182264 | 604.0 | NORTHRIDGE ACAD SH | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 0 | 0.0 | -0.88 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182317 | 182317 | 657.0 | PORTER MS | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 30 | 12 | 1.01 | 0.42 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182379 | 182379 | 719.0 | SAN JOSE ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 4 | 0.54 | -0.27 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182458 | 182458 | 798.0 | TULSA ST EL | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 7 | 1.46 | 0.83 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182470 | 182470 | 810.0 | VALLEY ACAD ARTS/SCI | OPEN | green | 18 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 46 | 18 | 1.35 | 0.52 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182473 | 182473 | 813.0 | VAN GOGH CHTR | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 44 | 8 | 1.61 | 0.00 | Kennedy/NAHS/VAAS CoS | 137 | 0.78 | -0.01 | 275 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181803 | 181803 | 143.0 | BURKE HS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181805 | 181805 | 145.0 | BURTON ST EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 3 | 0.81 | 0.27 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181986 | 181986 | 326.0 | FULTON COLLEGE PREP | OPEN | green | 11 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 14 | 0.88 | 0.57 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182257 | 182257 | 597.0 | NOBLE AVE EEC | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 1.67 | 0.84 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182258 | 182258 | 598.0 | NOBLE AVE EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 14 | 7 | 0.82 | -0.47 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182270 | 182270 | 609.0 | OBAMA EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.3 | 0.15 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182291 | 182291 | 631.0 | PANORAMA SH | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 10 | 7 | 0.37 | -0.26 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182329 | 182329 | 669.0 | RANCHITO AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 0 | 0.0 | -0.39 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182469 | 182469 | 809.0 | VALERIO ST EL | OPEN | green | 11 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 8 | 0.89 | -0.11 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182497 | 182497 | 837.0 | VISTA MS | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 13 | 9 | 0.66 | -0.07 | Panorama City CoS | 52 | 0.61 | -0.02 | 76 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181714 | 181714 | 54.0 | ALBION ST EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181715 | 181715 | 55.0 | ALBION ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 2.56 | 2.05 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181731 | 181731 | 71.0 | ANN ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -2.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181738 | 181738 | 78.0 | ARLETA SH | OPEN | green | 17 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 17 | 1.05 | 0.37 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181740 | 181740 | 80.0 | ARMINTA ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 1.33 | 1.33 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181741 | 181741 | 81.0 | ARMINTA ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181763 | 181763 | 103.0 | BEACHY AVE EL | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 1.0 | 0.00 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181784 | 181784 | 124.0 | BRAVO SH MEDICAL MAG | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 19 | 12 | 0.55 | 0.04 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181807 | 181807 | 147.0 | BYRD MS | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 9 | 0.68 | 0.22 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181820 | 181820 | 160.0 | CANTERBURY AVE EL | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.42 | -0.84 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181857 | 181857 | 197.0 | CHAVEZ EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 0 | 0.0 | -1.61 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181867 | 181867 | 207.0 | CITY TERRACE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 1 | 0.22 | -0.44 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181892 | 181892 | 232.0 | COUGHLIN EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181940 | 181940 | 280.0 | EL SERENO EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181941 | 181941 | 281.0 | EL SERENO EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 5 | 1.52 | 0.61 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181942 | 181942 | 282.0 | EL SERENO MS | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 6 | 0.57 | -0.09 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181969 | 181969 | 309.0 | FARMDALE EL | OPEN | green | 8 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 7 | 1.79 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181970 | 181970 | 310.0 | FERNANGELES EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.16 | -0.32 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181998 | 181998 | 338.0 | GATES ST EEC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181999 | 181999 | 339.0 | GATES ST EL | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 13 | 10 | 1.67 | 0.67 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182006 | 182006 | 346.0 | GLEN ALTA EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.65 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182009 | 182009 | 349.0 | GLENWOOD EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 4 | 1.47 | 0.00 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182024 | 182024 | 364.0 | GRIFFIN AVE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.47 | -0.47 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182040 | 182040 | 380.0 | HARRISON ST EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 2 | 0.52 | -0.26 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182056 | 182056 | 396.0 | HILLSIDE EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 2 | 1.39 | 0.70 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182075 | 182075 | 415.0 | HUNTINGTON DR EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.81 | -0.27 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182093 | 182093 | 433.0 | KENNEDY EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 1.21 | 0.40 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182108 | 182108 | 448.0 | KORENSTEIN EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.49 | 0.00 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182119 | 182119 | 459.0 | LATONA AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 1 | 0.49 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182133 | 182133 | 473.0 | LEWIS HS | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 1.15 | 1.15 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182140 | 182140 | 480.0 | LINCOLN SH | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 18 | 8 | 0.54 | -0.21 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182153 | 182153 | 493.0 | LORETO ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182160 | 182160 | 500.0 | LOWMAN SP ED & CTC | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.4 | 0.40 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182165 | 182165 | 505.0 | MACLAY MS | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 6 | 1.34 | 0.67 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182239 | 182239 | 579.0 | MULTNOMAH ST EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 0 | 0.0 | -0.25 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182240 | 182240 | 580.0 | MURCHISON EEC | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 2.13 | 1.07 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182241 | 182241 | 581.0 | MURCHISON ST EL | OPEN | green | 9 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 9 | 2.01 | 1.12 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182253 | 182253 | 593.0 | NIGHTINGALE MS | OPEN | green | 5 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.31 | -0.63 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182286 | 182286 | 626.0 | PACOIMA MS | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 7 | 0.66 | 0.38 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182315 | 182315 | 655.0 | POLYTECHNIC SH | OPEN | green | 10 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 13 | 9 | 0.29 | -0.16 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182323 | 182323 | 663.0 | PUEBLO DE LA HS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182361 | 182361 | 701.0 | ROSCOE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 0 | 0.0 | -0.64 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182387 | 182387 | 727.0 | SATICOY EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 0.48 | -0.79 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182395 | 182395 | 735.0 | SHARP AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 1 | 0.17 | 0.00 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182402 | 182402 | 742.0 | SIERRA PARK EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.26 | 0.00 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182403 | 182403 | 743.0 | SIERRA VISTA EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 3 | 1.3 | 0.87 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182406 | 182406 | 746.0 | SOLANO AVE EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 4 | 1.77 | 0.44 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182426 | 182426 | 766.0 | STRATHERN ST EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 6 | 1.08 | -1.07 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182427 | 182427 | 767.0 | SUN VALLEY MAG ET | OPEN | green | 11 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 12 | 9 | 0.6 | 0.20 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182481 | 182481 | 821.0 | VENA AVE EL | OPEN | green | 12 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 9 | 9 | 1.64 | 0.55 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182492 | 182492 | 832.0 | VINEDALE COLLEGE PRP | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 2 | 0.73 | 0.37 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182499 | 182499 | 839.0 | VOCES MAG | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.23 | -0.69 | Sun Valley CoS | 97 | 0.58 | -0.07 | 124 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
182539 | 182539 | 879.0 | WILSON SH | OPEN | green | 14 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 15 | 11 | 0.58 | -0.15 | Lincoln Heights/El SerenoCoS | 100 | 0.64 | -0.07 | 157 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181675 | 181675 | 15.0 | 232ND PL EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 4 | 1 | 0.21 | -0.83 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181713 | 181713 | 53.0 | AGGELER HS | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181724 | 181724 | 64.0 | AMBLER AVE EL | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 4 | 0.64 | 0.00 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181732 | 181732 | 72.0 | ANNALEE AVE EL | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181764 | 181764 | 104.0 | BECKFORD CES | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 11 | 5 | 0.71 | -1.28 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181777 | 181777 | 117.0 | BONITA ST EL | OPEN | green | 2 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 3 | 0.63 | -0.21 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181791 | 181791 | 131.0 | BROADACRES AV EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 1 | 1 | 0.31 | 0.31 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181811 | 181811 | 151.0 | CALABASH CA | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 11 | 2 | 0.4 | 0.00 | Taft CoS | 113 | 0.67 | -0.08 | 193 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181813 | 181813 | 153.0 | CALVERT CES | OPEN | green | 6 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 7 | 1.82 | 1.30 | Taft CoS | 113 | 0.67 | -0.08 | 193 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181816 | 181816 | 156.0 | CANOGA PARK EEC | OPEN | green | 0 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 0 | 0 | 0.0 | (Blank) | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181817 | 181817 | 157.0 | CANOGA PARK EL | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 3 | 3 | 0.47 | 0.00 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181818 | 181818 | 158.0 | CANOGA PRK SH | OPEN | green | 7 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 14 | 8 | 0.41 | -0.15 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181822 | 181822 | 162.0 | CAPISTRANO AVE EL | OPEN | green | 1 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 5 | 1 | 0.19 | 0.00 | Canoga Park/ChatsworthCoS | 110 | 0.63 | -0.08 | 210 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181825 | 181825 | 165.0 | CARNEGIE MS | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 7 | 4 | 0.42 | -0.43 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181826 | 181826 | 166.0 | CAROLDALE LC | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 2 | 2 | 0.24 | -0.25 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181828 | 181828 | 168.0 | CARSON ACAD ED & EMP | OPEN | green | 3 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 5 | 0.74 | 0.44 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM | |||||
181829 | 181829 | 169.0 | CARSON ACAD MED ARTS | OPEN | green | 4 | 0 | Past 7 days (8/20/2022 - 8/26/2022) | 6 | 4 | 0.64 | -0.32 | Carson CoS | 60 | 0.44 | -0.08 | 86 | 5,559 | 3,792 | 0.57 | 0.04 | 2022-08-27 | 01:36AM |
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 );