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.
893 rows where "date" is on date 2021-08-31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4579 | 4579 | BIRMINGHAM CHS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4670 | 4670 | CITY OF ANGELS | OPEN | 10 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4698 | 4698 | CRENSHAW ARTS TECH | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4746 | 4746 | ELA OCC CTR | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4764 | 4764 | EVANS CAS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4785 | 4785 | FRIEDMAN OCC CTR | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4818 | 4818 | GRANADA HILLS CHT | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4841 | 4841 | HARBOR OCC CTR | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4963 | 4963 | LOS ANGELES TECH CTR | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4974 | 4974 | MAGNOLIA SCI ACAD #2 | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4975 | 4975 | MAGNOLIA SCI ACAD #4 | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4976 | 4976 | MAGNOLIA SCI-BELL@SR | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5055 | 5055 | NEW ACAD CANOGA PARK | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5068 | 5068 | NORTH VALLEY OCC CTR | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5093 | 5093 | PALISADES CHS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5139 | 5139 | REGIONAL SH IDTE MAG | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5191 | 5191 | SANTA MONICA BLVD CO | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5211 | 5211 | SLAWSON OCC CTR | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5284 | 5284 | VENICE SKILLS CENTER | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5310 | 5310 | WATERS EMP PREP CTR | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5319 | 5319 | WEST VALLEY OCC CTR | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
5341 | 5341 | WILSON-LINCOLN CAS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 0.0 | 0.0 | 24.4 | Community of Schools | Community | ||||||||||||||||
4510 | 4510 | 95TH ST EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4511 | 4511 | 95TH ST EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4749 | 4749 | ELLINGTON HS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4846 | 4846 | HARTE PREP MS | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4914 | 4914 | LA SALLE AVE EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4980 | 4980 | MANHATTAN PLACE EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
5137 | 5137 | RAYMOND AVE EL | OPEN | 4 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
5309 | 5309 | WASHINGTON PREP SH | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
5317 | 5317 | WEST ATHENS EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
5348 | 5348 | WOODCREST EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 16.07 | 24.28 | 24.4 | H.E.E.T. (W) Community of Schools | Westmont/West Athens Community | ||||||||||||||||
4516 | 4516 | ACAD ENRICH SCI MAG | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4565 | 4565 | BASSETT ST EL | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4577 | 4577 | BERTRAND AVE EL | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4751 | 4751 | EMELITA ST EL | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4793 | 4793 | GARDEN GROVE EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4803 | 4803 | GAULT ST EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4826 | 4826 | GREY HS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4859 | 4859 | HESBY OAKS LEAD CHTR | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4886 | 4886 | INDEPENDENCE HS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4917 | 4917 | LAKE BALBOA CP K-12 | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4934 | 4934 | LEICHMAN CPTC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4936 | 4936 | LEMAY ST EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4937 | 4937 | LEMAY ST EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4953 | 4953 | LOKRANTZ SP ED CTR | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5043 | 5043 | MULHOLLAND MS | OPEN | 6 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5056 | 5056 | NEWCASTLE EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5140 | 5140 | RESEDA CHARTER HS | OPEN | 9 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5141 | 5141 | RESEDA EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5207 | 5207 | SHIRLEY AVE EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5212 | 5212 | SOCES MAG | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5248 | 5248 | TARZANA EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5279 | 5279 | VANALDEN AVE EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
5280 | 5280 | VANALDEN AVE EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 18.2 | 32.41 | 24.4 | Reseda Community of Schools | Reseda Community | ||||||||||||||||
4491 | 4491 | 3RD ST EL | OPEN | 5 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4608 | 4608 | BURROUGHS MS | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4651 | 4651 | CDS WEST HOLLYWOOD | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4771 | 4771 | FAIRFAX SH | OPEN | 7 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4839 | 4839 | HANCOCK PARK EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4915 | 4915 | LACES MAG | OPEN | 4 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4925 | 4925 | LAUREL CACT MAG | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4926 | 4926 | LAUREL EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4997 | 4997 | MARVIN EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4998 | 4998 | MARVIN EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5007 | 5007 | MELROSE AVE EL M/S MG | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5015 | 5015 | MID-CITY PSES MAG | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5172 | 5172 | ROSEWOOD UP/UD MAG | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5195 | 5195 | SATURN ST EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5318 | 5318 | WEST HOLLYWOOD EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
5330 | 5330 | WHITMAN HS | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 19.18 | 18.02 | 24.4 | Fairfax Community of Schools | Fairfax Community | ||||||||||||||||
4524 | 4524 | ALEXANDRIA AVE EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4525 | 4525 | ALEXANDRIA AVE EL | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4571 | 4571 | BELMONT SH | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4639 | 4639 | CASTELAR ST EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4640 | 4640 | CASTELAR ST EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4643 | 4643 | CASTRO MS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4650 | 4650 | CDS TRI-C | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4652 | 4652 | CENTRAL HS | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4695 | 4695 | CORTINES SCH OF VAPA | OPEN | 3 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4712 | 4712 | DBM | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4716 | 4716 | DEL OLMO EL | OPEN | 6 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4931 | 4931 | LEE EL MED HLTH MAG | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4951 | 4951 | LOGAN ACADEMY | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4952 | 4952 | LOGAN ST EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5057 | 5057 | NEWMARK HS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5115 | 5115 | PLASENCIA EL | OPEN | 5 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5170 | 5170 | ROSEMONT AVE EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5171 | 5171 | ROSEMONT AVE EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5174 | 5174 | ROYBAL LC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
5295 | 5295 | VIRGIL MS | OPEN | 5 | 0 | 2021-08-31 | 10:00PM | 20.9 | 19.33 | 24.4 | Downtown Community of Schools | Downtown Community | ||||||||||||||||
4568 | 4568 | BEETHOVEN ST EL | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4584 | 4584 | BRADDOCK DR EL | OPEN | 5 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4598 | 4598 | BROADWAY EL | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4679 | 4679 | COEUR D ALENE AVE EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4819 | 4819 | GRAND VW BL EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4984 | 4984 | MAR VISTA EL | OPEN | 1 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4986 | 4986 | MARINA DEL REY MS | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4987 | 4987 | MARINA EEC | OPEN | 0 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice Community | ||||||||||||||||
4989 | 4989 | MARK TWAIN MS | OPEN | 2 | 0 | 2021-08-31 | 10:00PM | 21.19 | 18.03 | 24.4 | Venice Community of Schools | Venice 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 );