latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
492 rows where county = "Trinity" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases ▼ | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28009 | 28009 | 2020-05-08 | Trinity | 105 | 0 | 0 | 0 | 0 |
28067 | 28067 | 2020-05-07 | Trinity | 105 | 0 | 0 | 0 | 0 |
28125 | 28125 | 2020-05-06 | Trinity | 105 | 0 | 0 | 0 | 0 |
28183 | 28183 | 2020-05-05 | Trinity | 105 | 0 | 0 | 0 | 0 |
28241 | 28241 | 2020-05-04 | Trinity | 105 | 0 | 0 | 0 | 0 |
28299 | 28299 | 2020-05-03 | Trinity | 105 | 0 | 0 | 0 | 0 |
28357 | 28357 | 2020-05-02 | Trinity | 105 | 0 | 0 | 0 | 0 |
28415 | 28415 | 2020-05-01 | Trinity | 105 | 0 | 0 | 0 | 0 |
28473 | 28473 | 2020-04-30 | Trinity | 105 | 0 | 0 | 0 | 0 |
28531 | 28531 | 2020-04-29 | Trinity | 105 | 0 | 0 | ||
26443 | 26443 | 2020-06-04 | Trinity | 105 | 1 | 0 | 0 | 0 |
26501 | 26501 | 2020-06-03 | Trinity | 105 | 1 | 0 | 0 | 0 |
26559 | 26559 | 2020-06-02 | Trinity | 105 | 1 | 0 | 0 | 0 |
26617 | 26617 | 2020-06-01 | Trinity | 105 | 1 | 0 | 0 | 0 |
26675 | 26675 | 2020-05-31 | Trinity | 105 | 1 | 0 | 0 | 0 |
26733 | 26733 | 2020-05-30 | Trinity | 105 | 1 | 0 | 0 | 0 |
26791 | 26791 | 2020-05-29 | Trinity | 105 | 1 | 0 | 0 | 0 |
26849 | 26849 | 2020-05-28 | Trinity | 105 | 1 | 0 | 0 | 0 |
26907 | 26907 | 2020-05-27 | Trinity | 105 | 1 | 0 | 0 | 0 |
26965 | 26965 | 2020-05-26 | Trinity | 105 | 1 | 0 | 0 | 0 |
27023 | 27023 | 2020-05-25 | Trinity | 105 | 1 | 0 | 0 | 0 |
27081 | 27081 | 2020-05-24 | Trinity | 105 | 1 | 0 | 0 | 0 |
27139 | 27139 | 2020-05-23 | Trinity | 105 | 1 | 0 | 0 | 0 |
27197 | 27197 | 2020-05-22 | Trinity | 105 | 1 | 0 | 0 | 0 |
27255 | 27255 | 2020-05-21 | Trinity | 105 | 1 | 0 | 0 | 0 |
27313 | 27313 | 2020-05-20 | Trinity | 105 | 1 | 0 | 0 | 0 |
27371 | 27371 | 2020-05-19 | Trinity | 105 | 1 | 0 | 0 | 0 |
27429 | 27429 | 2020-05-18 | Trinity | 105 | 1 | 0 | 0 | 0 |
27487 | 27487 | 2020-05-17 | Trinity | 105 | 1 | 0 | 0 | 0 |
27545 | 27545 | 2020-05-16 | Trinity | 105 | 1 | 0 | 0 | 0 |
27603 | 27603 | 2020-05-15 | Trinity | 105 | 1 | 0 | 0 | 0 |
27661 | 27661 | 2020-05-14 | Trinity | 105 | 1 | 0 | 0 | 0 |
27719 | 27719 | 2020-05-13 | Trinity | 105 | 1 | 0 | 0 | 0 |
27777 | 27777 | 2020-05-12 | Trinity | 105 | 1 | 0 | 0 | 0 |
27835 | 27835 | 2020-05-11 | Trinity | 105 | 1 | 0 | 0 | 0 |
27893 | 27893 | 2020-05-10 | Trinity | 105 | 1 | 0 | 0 | 0 |
27951 | 27951 | 2020-05-09 | Trinity | 105 | 1 | 0 | 1 | 0 |
23775 | 23775 | 2020-07-20 | Trinity | 105 | 2 | 0 | 0 | 0 |
23833 | 23833 | 2020-07-19 | Trinity | 105 | 2 | 0 | 0 | 0 |
23891 | 23891 | 2020-07-18 | Trinity | 105 | 2 | 0 | 0 | 0 |
23949 | 23949 | 2020-07-17 | Trinity | 105 | 2 | 0 | 0 | 0 |
24007 | 24007 | 2020-07-16 | Trinity | 105 | 2 | 0 | 0 | 0 |
24065 | 24065 | 2020-07-15 | Trinity | 105 | 2 | 0 | 0 | 0 |
24123 | 24123 | 2020-07-14 | Trinity | 105 | 2 | 0 | 0 | 0 |
24181 | 24181 | 2020-07-13 | Trinity | 105 | 2 | 0 | 0 | 0 |
24239 | 24239 | 2020-07-12 | Trinity | 105 | 2 | 0 | 0 | 0 |
24297 | 24297 | 2020-07-11 | Trinity | 105 | 2 | 0 | 0 | 0 |
24355 | 24355 | 2020-07-10 | Trinity | 105 | 2 | 0 | 0 | 0 |
24413 | 24413 | 2020-07-09 | Trinity | 105 | 2 | 0 | 0 | 0 |
24471 | 24471 | 2020-07-08 | Trinity | 105 | 2 | 0 | 0 | 0 |
24529 | 24529 | 2020-07-07 | Trinity | 105 | 2 | 0 | 0 | 0 |
24587 | 24587 | 2020-07-06 | Trinity | 105 | 2 | 0 | 0 | 0 |
24645 | 24645 | 2020-07-05 | Trinity | 105 | 2 | 0 | 0 | 0 |
24703 | 24703 | 2020-07-04 | Trinity | 105 | 2 | 0 | 0 | 0 |
24761 | 24761 | 2020-07-03 | Trinity | 105 | 2 | 0 | 0 | 0 |
24819 | 24819 | 2020-07-02 | Trinity | 105 | 2 | 0 | 0 | 0 |
24877 | 24877 | 2020-07-01 | Trinity | 105 | 2 | 0 | 0 | 0 |
24935 | 24935 | 2020-06-30 | Trinity | 105 | 2 | 0 | 0 | 0 |
24993 | 24993 | 2020-06-29 | Trinity | 105 | 2 | 0 | 0 | 0 |
25051 | 25051 | 2020-06-28 | Trinity | 105 | 2 | 0 | 0 | 0 |
25109 | 25109 | 2020-06-27 | Trinity | 105 | 2 | 0 | 0 | 0 |
25167 | 25167 | 2020-06-26 | Trinity | 105 | 2 | 0 | 0 | 0 |
25225 | 25225 | 2020-06-25 | Trinity | 105 | 2 | 0 | 0 | 0 |
25283 | 25283 | 2020-06-24 | Trinity | 105 | 2 | 0 | 0 | 0 |
25341 | 25341 | 2020-06-23 | Trinity | 105 | 2 | 0 | 0 | 0 |
25399 | 25399 | 2020-06-22 | Trinity | 105 | 2 | 0 | 0 | 0 |
25457 | 25457 | 2020-06-21 | Trinity | 105 | 2 | 0 | 0 | 0 |
25515 | 25515 | 2020-06-20 | Trinity | 105 | 2 | 0 | 0 | 0 |
25573 | 25573 | 2020-06-19 | Trinity | 105 | 2 | 0 | 0 | 0 |
25631 | 25631 | 2020-06-18 | Trinity | 105 | 2 | 0 | 0 | 0 |
25689 | 25689 | 2020-06-17 | Trinity | 105 | 2 | 0 | 0 | 0 |
25747 | 25747 | 2020-06-16 | Trinity | 105 | 2 | 0 | 0 | 0 |
25805 | 25805 | 2020-06-15 | Trinity | 105 | 2 | 0 | 0 | 0 |
25863 | 25863 | 2020-06-14 | Trinity | 105 | 2 | 0 | 0 | 0 |
25921 | 25921 | 2020-06-13 | Trinity | 105 | 2 | 0 | 0 | 0 |
25979 | 25979 | 2020-06-12 | Trinity | 105 | 2 | 0 | 0 | 0 |
26037 | 26037 | 2020-06-11 | Trinity | 105 | 2 | 0 | 0 | 0 |
26095 | 26095 | 2020-06-10 | Trinity | 105 | 2 | 0 | 0 | 0 |
26153 | 26153 | 2020-06-09 | Trinity | 105 | 2 | 0 | 0 | 0 |
26211 | 26211 | 2020-06-08 | Trinity | 105 | 2 | 0 | 0 | 0 |
26269 | 26269 | 2020-06-07 | Trinity | 105 | 2 | 0 | 0 | 0 |
26327 | 26327 | 2020-06-06 | Trinity | 105 | 2 | 0 | 0 | 0 |
26385 | 26385 | 2020-06-05 | Trinity | 105 | 2 | 0 | 1 | 0 |
23369 | 23369 | 2020-07-27 | Trinity | 105 | 3 | 0 | 0 | 0 |
23427 | 23427 | 2020-07-26 | Trinity | 105 | 3 | 0 | 0 | 0 |
23485 | 23485 | 2020-07-25 | Trinity | 105 | 3 | 0 | 0 | 0 |
23543 | 23543 | 2020-07-24 | Trinity | 105 | 3 | 0 | 0 | 0 |
23601 | 23601 | 2020-07-23 | Trinity | 105 | 3 | 0 | 0 | 0 |
23659 | 23659 | 2020-07-22 | Trinity | 105 | 3 | 0 | 0 | 0 |
23717 | 23717 | 2020-07-21 | Trinity | 105 | 3 | 0 | 1 | 0 |
23253 | 23253 | 2020-07-29 | Trinity | 105 | 4 | 0 | 0 | 0 |
23311 | 23311 | 2020-07-28 | Trinity | 105 | 4 | 0 | 1 | 0 |
22557 | 22557 | 2020-08-10 | Trinity | 105 | 5 | 0 | 0 | 0 |
22615 | 22615 | 2020-08-09 | Trinity | 105 | 5 | 0 | 0 | 0 |
22673 | 22673 | 2020-08-08 | Trinity | 105 | 5 | 0 | 0 | 0 |
22731 | 22731 | 2020-08-07 | Trinity | 105 | 5 | 0 | 0 | 0 |
22789 | 22789 | 2020-08-06 | Trinity | 105 | 5 | 0 | 0 | 0 |
22847 | 22847 | 2020-08-05 | Trinity | 105 | 5 | 0 | 0 | 0 |
22905 | 22905 | 2020-08-04 | Trinity | 105 | 5 | 0 | 0 | 0 |
22963 | 22963 | 2020-08-03 | Trinity | 105 | 5 | 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 );