latimes-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- 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 case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases ▼ | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
15372 | 15372 | 2020-12-11 | Alpine | 3 | 0 | 0 | -63 | 0 |
23341 | 23341 | 2020-07-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
23399 | 23399 | 2020-07-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
23457 | 23457 | 2020-07-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
23515 | 23515 | 2020-07-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
23573 | 23573 | 2020-07-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
23631 | 23631 | 2020-07-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
23689 | 23689 | 2020-07-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
23747 | 23747 | 2020-07-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
23805 | 23805 | 2020-07-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
23863 | 23863 | 2020-07-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
23921 | 23921 | 2020-07-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
23979 | 23979 | 2020-07-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
24037 | 24037 | 2020-07-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
24095 | 24095 | 2020-07-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
24153 | 24153 | 2020-07-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
24211 | 24211 | 2020-07-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
24269 | 24269 | 2020-07-11 | Modoc | 49 | 0 | 0 | 0 | 0 |
24327 | 24327 | 2020-07-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
24385 | 24385 | 2020-07-09 | Modoc | 49 | 0 | 0 | 0 | 0 |
24443 | 24443 | 2020-07-08 | Modoc | 49 | 0 | 0 | 0 | 0 |
24501 | 24501 | 2020-07-07 | Modoc | 49 | 0 | 0 | 0 | 0 |
24559 | 24559 | 2020-07-06 | Modoc | 49 | 0 | 0 | 0 | 0 |
24617 | 24617 | 2020-07-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
24675 | 24675 | 2020-07-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
24733 | 24733 | 2020-07-03 | Modoc | 49 | 0 | 0 | 0 | 0 |
24791 | 24791 | 2020-07-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
24849 | 24849 | 2020-07-01 | Modoc | 49 | 0 | 0 | 0 | 0 |
24907 | 24907 | 2020-06-30 | Modoc | 49 | 0 | 0 | 0 | 0 |
24942 | 24942 | 2020-06-29 | Alpine | 3 | 0 | 0 | -1 | 0 |
24965 | 24965 | 2020-06-29 | Modoc | 49 | 0 | 0 | 0 | 0 |
25023 | 25023 | 2020-06-28 | Modoc | 49 | 0 | 0 | 0 | 0 |
25081 | 25081 | 2020-06-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
25139 | 25139 | 2020-06-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
25197 | 25197 | 2020-06-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
25255 | 25255 | 2020-06-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
25313 | 25313 | 2020-06-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
25371 | 25371 | 2020-06-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
25429 | 25429 | 2020-06-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
25487 | 25487 | 2020-06-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
25545 | 25545 | 2020-06-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
25603 | 25603 | 2020-06-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
25661 | 25661 | 2020-06-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
25719 | 25719 | 2020-06-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
25777 | 25777 | 2020-06-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
25835 | 25835 | 2020-06-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
25893 | 25893 | 2020-06-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
25951 | 25951 | 2020-06-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
26009 | 26009 | 2020-06-11 | Modoc | 49 | 0 | 0 | 0 | 0 |
26067 | 26067 | 2020-06-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
26125 | 26125 | 2020-06-09 | Modoc | 49 | 0 | 0 | 0 | 0 |
26183 | 26183 | 2020-06-08 | Modoc | 49 | 0 | 0 | 0 | 0 |
26241 | 26241 | 2020-06-07 | Modoc | 49 | 0 | 0 | 0 | 0 |
26299 | 26299 | 2020-06-06 | Modoc | 49 | 0 | 0 | 0 | 0 |
26357 | 26357 | 2020-06-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
26415 | 26415 | 2020-06-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
26473 | 26473 | 2020-06-03 | Modoc | 49 | 0 | 0 | 0 | 0 |
26531 | 26531 | 2020-06-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
26589 | 26589 | 2020-06-01 | Modoc | 49 | 0 | 0 | 0 | 0 |
26647 | 26647 | 2020-05-31 | Modoc | 49 | 0 | 0 | 0 | 0 |
26705 | 26705 | 2020-05-30 | Modoc | 49 | 0 | 0 | 0 | 0 |
26763 | 26763 | 2020-05-29 | Modoc | 49 | 0 | 0 | 0 | 0 |
26821 | 26821 | 2020-05-28 | Modoc | 49 | 0 | 0 | 0 | 0 |
26879 | 26879 | 2020-05-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
26937 | 26937 | 2020-05-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
26995 | 26995 | 2020-05-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
27053 | 27053 | 2020-05-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
27111 | 27111 | 2020-05-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
27169 | 27169 | 2020-05-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
27220 | 27220 | 2020-05-21 | Lassen | 35 | 0 | 0 | 0 | 0 |
27227 | 27227 | 2020-05-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
27248 | 27248 | 2020-05-21 | Sierra | 91 | 0 | 0 | 0 | 0 |
27278 | 27278 | 2020-05-20 | Lassen | 35 | 0 | 0 | 0 | 0 |
27285 | 27285 | 2020-05-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
27306 | 27306 | 2020-05-20 | Sierra | 91 | 0 | 0 | 0 | 0 |
27336 | 27336 | 2020-05-19 | Lassen | 35 | 0 | 0 | 0 | 0 |
27343 | 27343 | 2020-05-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
27364 | 27364 | 2020-05-19 | Sierra | 91 | 0 | 0 | 0 | 0 |
27394 | 27394 | 2020-05-18 | Lassen | 35 | 0 | 0 | 0 | 0 |
27401 | 27401 | 2020-05-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
27422 | 27422 | 2020-05-18 | Sierra | 91 | 0 | 0 | 0 | 0 |
27452 | 27452 | 2020-05-17 | Lassen | 35 | 0 | 0 | 0 | 0 |
27459 | 27459 | 2020-05-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
27480 | 27480 | 2020-05-17 | Sierra | 91 | 0 | 0 | 0 | 0 |
27510 | 27510 | 2020-05-16 | Lassen | 35 | 0 | 0 | 0 | 0 |
27517 | 27517 | 2020-05-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
27538 | 27538 | 2020-05-16 | Sierra | 91 | 0 | 0 | 0 | 0 |
27568 | 27568 | 2020-05-15 | Lassen | 35 | 0 | 0 | 0 | 0 |
27575 | 27575 | 2020-05-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
27596 | 27596 | 2020-05-15 | Sierra | 91 | 0 | 0 | 0 | 0 |
27626 | 27626 | 2020-05-14 | Lassen | 35 | 0 | 0 | 0 | 0 |
27633 | 27633 | 2020-05-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
27654 | 27654 | 2020-05-14 | Sierra | 91 | 0 | 0 | 0 | 0 |
27684 | 27684 | 2020-05-13 | Lassen | 35 | 0 | 0 | 0 | 0 |
27691 | 27691 | 2020-05-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
27712 | 27712 | 2020-05-13 | Sierra | 91 | 0 | 0 | 0 | 0 |
27742 | 27742 | 2020-05-12 | Lassen | 35 | 0 | 0 | 0 | 0 |
27749 | 27749 | 2020-05-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
27770 | 27770 | 2020-05-12 | Sierra | 91 | 0 | 0 | 0 | 0 |
27800 | 27800 | 2020-05-11 | Lassen | 35 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );