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.
891 rows where "date" is on date 2021-09-02 sorted by staff_student_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6365 | 6365 | BIRMINGHAM CHS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6456 | 6456 | CITY OF ANGELS | OPEN | 8 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6484 | 6484 | CRENSHAW ARTS TECH | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6532 | 6532 | ELA OCC CTR | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 0.0 | 18.91 | 24.4 | Community of Schools | Lincoln Heights/El Sereno Community | ||||||||||||||||
6550 | 6550 | EVANS CAS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6571 | 6571 | FRIEDMAN OCC CTR | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6604 | 6604 | GRANADA HILLS CHT | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6627 | 6627 | HARBOR OCC CTR | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6747 | 6747 | LOS ANGELES TECH CTR | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6758 | 6758 | MAGNOLIA SCI ACAD #2 | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6759 | 6759 | MAGNOLIA SCI ACAD #4 | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6760 | 6760 | MAGNOLIA SCI-BELL@SR | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6839 | 6839 | NEW ACAD CANOGA PARK | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6852 | 6852 | NORTH VALLEY OCC CTR | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6877 | 6877 | PALISADES CHS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6923 | 6923 | REGIONAL SH IDTE MAG | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6975 | 6975 | SANTA MONICA BLVD CO | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6995 | 6995 | SLAWSON OCC CTR | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
7068 | 7068 | VENICE SKILLS CENTER | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
7094 | 7094 | WATERS EMP PREP CTR | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
7103 | 7103 | WEST VALLEY OCC CTR | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
7104 | 7104 | WEST VERNON AVE EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 0.0 | 22.03 | 24.4 | Jefferson/South Central (West) Community of Sc… | Jefferson/South Central (West) Community | ||||||||||||||||
7125 | 7125 | WILSON-LINCOLN CAS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
6280 | 6280 | 4TH ST EEC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6281 | 6281 | 4TH ST EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6282 | 6282 | 4TH ST PC | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6315 | 6315 | AMANECER PC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6326 | 6326 | ANTON EEC | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6327 | 6327 | ANTON EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6358 | 6358 | BELVEDERE EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6359 | 6359 | BELVEDERE MS | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6386 | 6386 | BROOKLYN AVE EEC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6387 | 6387 | BROOKLYN AVE EL | OPEN | 4 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6523 | 6523 | EASTMAN AVE EEC | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6524 | 6524 | EASTMAN AVE EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6566 | 6566 | FORD BLVD EL | OPEN | 8 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6584 | 6584 | GARFIELD SH | OPEN | 10 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6616 | 6616 | GRIFFITH MS STEAM MG | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6622 | 6622 | HAMASAKI MED/SCI MAG | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6664 | 6664 | HUMPHREYS AVE EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6704 | 6704 | LANE EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6769 | 6769 | MARIANNA AVE EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6818 | 6818 | MONTEREY HS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6893 | 6893 | PEREZ SP ED CTR | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6917 | 6917 | RAMONA HS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6918 | 6918 | RAMONA INFANT | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6957 | 6957 | ROWAN AVE EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6998 | 6998 | SOLIS LA | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
7041 | 7041 | TORRES ELA PA MAG | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
7042 | 7042 | TORRES ENG & TECH | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
7043 | 7043 | TORRES HS SJLA MAG | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
7044 | 7044 | TORRES HUM/ART/TECH | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
7045 | 7045 | TORRES RENAISSANCE | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 13.26 | 24.49 | 24.4 | East Los Angeles Community of Schools | East Los Angeles Community | ||||||||||||||||
6277 | 6277 | 3RD ST EL | OPEN | 5 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6394 | 6394 | BURROUGHS MS | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6437 | 6437 | CDS WEST HOLLYWOOD | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6557 | 6557 | FAIRFAX SH | OPEN | 6 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6625 | 6625 | HANCOCK PARK EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6699 | 6699 | LACES MAG | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6709 | 6709 | LAUREL CACT MAG | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6710 | 6710 | LAUREL EEC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6781 | 6781 | MARVIN EEC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6782 | 6782 | MARVIN EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6791 | 6791 | MELROSE AVE EL M/S MG | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6799 | 6799 | MID-CITY PSES MAG | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6956 | 6956 | ROSEWOOD UP/UD MAG | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6979 | 6979 | SATURN ST EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
7102 | 7102 | WEST HOLLYWOOD EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.34 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
6376 | 6376 | BRENTWOOD EL SCI MAG | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6385 | 6385 | BROCKTON AVE EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6411 | 6411 | CANYON CEL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6474 | 6474 | COMMUNITY EL MAG CS | OPEN | 9 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6538 | 6538 | EMERSON CC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6556 | 6556 | FAIRBURN AVE EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6684 | 6684 | KENTER CANYON EC | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6776 | 6776 | MARQUEZ CHARTER | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6876 | 6876 | PALISADES CEL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6926 | 6926 | REVERE CMS | OPEN | 6 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6933 | 6933 | RICHLAND AVE EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6953 | 6953 | ROSCOMARE RD EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7012 | 7012 | STERRY EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7039 | 7039 | TOPANGA EL CS | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7052 | 7052 | UNIVERSITY HS CHARTER | OPEN | 4 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7091 | 7091 | WARNER AVE EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7095 | 7095 | WEBSTER MS | OPEN | 4 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
7110 | 7110 | WESTWOOD CEL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.37 | 15.93 | 24.4 | West LA Community of Schools | West LA Community | ||||||||||||||||
6261 | 6261 | 135TH ST EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6262 | 6262 | 153RD ST EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6263 | 6263 | 156TH ST EL | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6265 | 6265 | 186TH ST EL | OPEN | 4 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6300 | 6300 | 99TH ST EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6317 | 6317 | AMESTOY EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6339 | 6339 | AVALON GARDENS EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6347 | 6347 | BANNEKER CTC | OPEN | 1 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6441 | 6441 | CHAPMAN EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6505 | 6505 | DENKER AVE EL | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6560 | 6560 | FIGUEROA ST EL | OPEN | 2 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6580 | 6580 | GARDENA EEC | OPEN | 3 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6581 | 6581 | GARDENA EL | OPEN | 0 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community | ||||||||||||||||
6582 | 6582 | GARDENA SH | OPEN | 7 | 0 | 2021-09-02 | 10:00PM | 15.83 | 35.64 | 24.4 | Gardena Community of Schools | Gardena Community |
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 );