latimes-agency-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- agency
- The name of the county or city public health agency that provided the data. Guaranteed to be unique when combined with the date field.
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of confirmed coronavirus cases as of this date.
- deaths
- The cumulative number of deaths attributed to coronavirus as of this date.
- did_not_update
- Indicates if the agency did not provide an update on this date. If this is true and the case and death totals are unchanged from the previous day, this means they were holdovers. Use this flag omit these records when desired.
33,021 rows sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date | confirmed_cases | deaths ▼ | did_not_update |
---|---|---|---|---|---|---|---|---|
3 | 3 | Alpine | Alpine | 3 | 2021-09-02 | 89 | 0 | TRUE |
49 | 49 | Sierra | Sierra | 91 | 2021-09-02 | 198 | 0 | |
64 | 64 | Alpine | Alpine | 3 | 2021-09-01 | 89 | 0 | TRUE |
110 | 110 | Sierra | Sierra | 91 | 2021-09-01 | 191 | 0 | |
125 | 125 | Alpine | Alpine | 3 | 2021-08-31 | 89 | 0 | TRUE |
171 | 171 | Sierra | Sierra | 91 | 2021-08-31 | 188 | 0 | TRUE |
186 | 186 | Alpine | Alpine | 3 | 2021-08-30 | 89 | 0 | TRUE |
232 | 232 | Sierra | Sierra | 91 | 2021-08-30 | 188 | 0 | TRUE |
247 | 247 | Alpine | Alpine | 3 | 2021-08-29 | 89 | 0 | TRUE |
293 | 293 | Sierra | Sierra | 91 | 2021-08-29 | 188 | 0 | TRUE |
308 | 308 | Alpine | Alpine | 3 | 2021-08-28 | 89 | 0 | TRUE |
354 | 354 | Sierra | Sierra | 91 | 2021-08-28 | 188 | 0 | TRUE |
369 | 369 | Alpine | Alpine | 3 | 2021-08-27 | 89 | 0 | TRUE |
415 | 415 | Sierra | Sierra | 91 | 2021-08-27 | 188 | 0 | |
430 | 430 | Alpine | Alpine | 3 | 2021-08-26 | 89 | 0 | TRUE |
476 | 476 | Sierra | Sierra | 91 | 2021-08-26 | 188 | 0 | |
491 | 491 | Alpine | Alpine | 3 | 2021-08-25 | 89 | 0 | TRUE |
537 | 537 | Sierra | Sierra | 91 | 2021-08-25 | 175 | 0 | |
552 | 552 | Alpine | Alpine | 3 | 2021-08-24 | 89 | 0 | TRUE |
598 | 598 | Sierra | Sierra | 91 | 2021-08-24 | 174 | 0 | TRUE |
613 | 613 | Alpine | Alpine | 3 | 2021-08-23 | 89 | 0 | TRUE |
659 | 659 | Sierra | Sierra | 91 | 2021-08-23 | 174 | 0 | |
674 | 674 | Alpine | Alpine | 3 | 2021-08-22 | 89 | 0 | TRUE |
720 | 720 | Sierra | Sierra | 91 | 2021-08-22 | 160 | 0 | TRUE |
735 | 735 | Alpine | Alpine | 3 | 2021-08-21 | 89 | 0 | TRUE |
781 | 781 | Sierra | Sierra | 91 | 2021-08-21 | 160 | 0 | TRUE |
796 | 796 | Alpine | Alpine | 3 | 2021-08-20 | 89 | 0 | TRUE |
842 | 842 | Sierra | Sierra | 91 | 2021-08-20 | 160 | 0 | |
857 | 857 | Alpine | Alpine | 3 | 2021-08-19 | 89 | 0 | TRUE |
903 | 903 | Sierra | Sierra | 91 | 2021-08-19 | 158 | 0 | |
918 | 918 | Alpine | Alpine | 3 | 2021-08-18 | 89 | 0 | TRUE |
964 | 964 | Sierra | Sierra | 91 | 2021-08-18 | 154 | 0 | |
979 | 979 | Alpine | Alpine | 3 | 2021-08-17 | 89 | 0 | TRUE |
1025 | 1025 | Sierra | Sierra | 91 | 2021-08-17 | 154 | 0 | |
1040 | 1040 | Alpine | Alpine | 3 | 2021-08-16 | 89 | 0 | TRUE |
1086 | 1086 | Sierra | Sierra | 91 | 2021-08-16 | 152 | 0 | |
1101 | 1101 | Alpine | Alpine | 3 | 2021-08-15 | 89 | 0 | TRUE |
1147 | 1147 | Sierra | Sierra | 91 | 2021-08-15 | 150 | 0 | TRUE |
1162 | 1162 | Alpine | Alpine | 3 | 2021-08-14 | 89 | 0 | TRUE |
1208 | 1208 | Sierra | Sierra | 91 | 2021-08-14 | 150 | 0 | TRUE |
1223 | 1223 | Alpine | Alpine | 3 | 2021-08-13 | 89 | 0 | TRUE |
1269 | 1269 | Sierra | Sierra | 91 | 2021-08-13 | 150 | 0 | |
1284 | 1284 | Alpine | Alpine | 3 | 2021-08-12 | 89 | 0 | TRUE |
1330 | 1330 | Sierra | Sierra | 91 | 2021-08-12 | 150 | 0 | |
1345 | 1345 | Alpine | Alpine | 3 | 2021-08-11 | 89 | 0 | TRUE |
1391 | 1391 | Sierra | Sierra | 91 | 2021-08-11 | 146 | 0 | |
1406 | 1406 | Alpine | Alpine | 3 | 2021-08-10 | 89 | 0 | TRUE |
1452 | 1452 | Sierra | Sierra | 91 | 2021-08-10 | 143 | 0 | |
1467 | 1467 | Alpine | Alpine | 3 | 2021-08-09 | 89 | 0 | TRUE |
1513 | 1513 | Sierra | Sierra | 91 | 2021-08-09 | 140 | 0 | |
1528 | 1528 | Alpine | Alpine | 3 | 2021-08-08 | 89 | 0 | TRUE |
1574 | 1574 | Sierra | Sierra | 91 | 2021-08-08 | 138 | 0 | TRUE |
1589 | 1589 | Alpine | Alpine | 3 | 2021-08-07 | 89 | 0 | TRUE |
1635 | 1635 | Sierra | Sierra | 91 | 2021-08-07 | 138 | 0 | TRUE |
1650 | 1650 | Alpine | Alpine | 3 | 2021-08-06 | 89 | 0 | TRUE |
1696 | 1696 | Sierra | Sierra | 91 | 2021-08-06 | 138 | 0 | TRUE |
1711 | 1711 | Alpine | Alpine | 3 | 2021-08-05 | 89 | 0 | TRUE |
1757 | 1757 | Sierra | Sierra | 91 | 2021-08-05 | 138 | 0 | |
1772 | 1772 | Alpine | Alpine | 3 | 2021-08-04 | 89 | 0 | TRUE |
1818 | 1818 | Sierra | Sierra | 91 | 2021-08-04 | 137 | 0 | TRUE |
1833 | 1833 | Alpine | Alpine | 3 | 2021-08-03 | 89 | 0 | TRUE |
1879 | 1879 | Sierra | Sierra | 91 | 2021-08-03 | 137 | 0 | |
1894 | 1894 | Alpine | Alpine | 3 | 2021-08-02 | 89 | 0 | TRUE |
1940 | 1940 | Sierra | Sierra | 91 | 2021-08-02 | 133 | 0 | |
1955 | 1955 | Alpine | Alpine | 3 | 2021-08-01 | 89 | 0 | TRUE |
2001 | 2001 | Sierra | Sierra | 91 | 2021-08-01 | 131 | 0 | TRUE |
2016 | 2016 | Alpine | Alpine | 3 | 2021-07-31 | 89 | 0 | TRUE |
2062 | 2062 | Sierra | Sierra | 91 | 2021-07-31 | 131 | 0 | TRUE |
2077 | 2077 | Alpine | Alpine | 3 | 2021-07-30 | 89 | 0 | TRUE |
2123 | 2123 | Sierra | Sierra | 91 | 2021-07-30 | 131 | 0 | |
2138 | 2138 | Alpine | Alpine | 3 | 2021-07-29 | 89 | 0 | TRUE |
2184 | 2184 | Sierra | Sierra | 91 | 2021-07-29 | 129 | 0 | |
2199 | 2199 | Alpine | Alpine | 3 | 2021-07-28 | 89 | 0 | TRUE |
2245 | 2245 | Sierra | Sierra | 91 | 2021-07-28 | 126 | 0 | TRUE |
2260 | 2260 | Alpine | Alpine | 3 | 2021-07-27 | 89 | 0 | TRUE |
2306 | 2306 | Sierra | Sierra | 91 | 2021-07-27 | 126 | 0 | TRUE |
2321 | 2321 | Alpine | Alpine | 3 | 2021-07-26 | 89 | 0 | TRUE |
2367 | 2367 | Sierra | Sierra | 91 | 2021-07-26 | 126 | 0 | |
2382 | 2382 | Alpine | Alpine | 3 | 2021-07-25 | 89 | 0 | TRUE |
2428 | 2428 | Sierra | Sierra | 91 | 2021-07-25 | 125 | 0 | TRUE |
2443 | 2443 | Alpine | Alpine | 3 | 2021-07-24 | 89 | 0 | TRUE |
2489 | 2489 | Sierra | Sierra | 91 | 2021-07-24 | 125 | 0 | TRUE |
2504 | 2504 | Alpine | Alpine | 3 | 2021-07-23 | 89 | 0 | TRUE |
2550 | 2550 | Sierra | Sierra | 91 | 2021-07-23 | 125 | 0 | |
2565 | 2565 | Alpine | Alpine | 3 | 2021-07-22 | 89 | 0 | TRUE |
2611 | 2611 | Sierra | Sierra | 91 | 2021-07-22 | 124 | 0 | TRUE |
2626 | 2626 | Alpine | Alpine | 3 | 2021-07-21 | 89 | 0 | TRUE |
2672 | 2672 | Sierra | Sierra | 91 | 2021-07-21 | 124 | 0 | TRUE |
2687 | 2687 | Alpine | Alpine | 3 | 2021-07-20 | 89 | 0 | TRUE |
2733 | 2733 | Sierra | Sierra | 91 | 2021-07-20 | 124 | 0 | TRUE |
2748 | 2748 | Alpine | Alpine | 3 | 2021-07-19 | 89 | 0 | TRUE |
2794 | 2794 | Sierra | Sierra | 91 | 2021-07-19 | 124 | 0 | TRUE |
2809 | 2809 | Alpine | Alpine | 3 | 2021-07-18 | 89 | 0 | TRUE |
2855 | 2855 | Sierra | Sierra | 91 | 2021-07-18 | 124 | 0 | TRUE |
2870 | 2870 | Alpine | Alpine | 3 | 2021-07-17 | 89 | 0 | TRUE |
2916 | 2916 | Sierra | Sierra | 91 | 2021-07-17 | 124 | 0 | TRUE |
2931 | 2931 | Alpine | Alpine | 3 | 2021-07-16 | 89 | 0 | TRUE |
2977 | 2977 | Sierra | Sierra | 91 | 2021-07-16 | 124 | 0 | TRUE |
2992 | 2992 | Alpine | Alpine | 3 | 2021-07-15 | 89 | 0 | TRUE |
3038 | 3038 | Sierra | Sierra | 91 | 2021-07-15 | 124 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-agency-totals" ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );