latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
522 rows where fips = 3 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, did_not_update, date (date)
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
31632 | 31632 | Alpine | Alpine | 3 | 2020-03-30 | 1 | 0 | |
31579 | 31579 | Alpine | Alpine | 3 | 2020-03-31 | 1 | 0 | TRUE |
31525 | 31525 | Alpine | Alpine | 3 | 2020-04-01 | 1 | 0 | TRUE |
31470 | 31470 | Alpine | Alpine | 3 | 2020-04-02 | 1 | 0 | TRUE |
31415 | 31415 | Alpine | Alpine | 3 | 2020-04-03 | 1 | 0 | TRUE |
31360 | 31360 | Alpine | Alpine | 3 | 2020-04-04 | 1 | 0 | TRUE |
31304 | 31304 | Alpine | Alpine | 3 | 2020-04-05 | 1 | 0 | TRUE |
31248 | 31248 | Alpine | Alpine | 3 | 2020-04-06 | 1 | 0 | |
31192 | 31192 | Alpine | Alpine | 3 | 2020-04-07 | 1 | 0 | TRUE |
31136 | 31136 | Alpine | Alpine | 3 | 2020-04-08 | 1 | 0 | |
31080 | 31080 | Alpine | Alpine | 3 | 2020-04-09 | 1 | 0 | |
31024 | 31024 | Alpine | Alpine | 3 | 2020-04-10 | 1 | 0 | |
30968 | 30968 | Alpine | Alpine | 3 | 2020-04-11 | 1 | 0 | TRUE |
30912 | 30912 | Alpine | Alpine | 3 | 2020-04-12 | 1 | 0 | TRUE |
30856 | 30856 | Alpine | Alpine | 3 | 2020-04-13 | 1 | 0 | |
30800 | 30800 | Alpine | Alpine | 3 | 2020-04-14 | 1 | 0 | TRUE |
30744 | 30744 | Alpine | Alpine | 3 | 2020-04-15 | 1 | 0 | TRUE |
30688 | 30688 | Alpine | Alpine | 3 | 2020-04-16 | 1 | 0 | |
30632 | 30632 | Alpine | Alpine | 3 | 2020-04-17 | 1 | 0 | TRUE |
30576 | 30576 | Alpine | Alpine | 3 | 2020-04-18 | 1 | 0 | TRUE |
30520 | 30520 | Alpine | Alpine | 3 | 2020-04-19 | 1 | 0 | TRUE |
30464 | 30464 | Alpine | Alpine | 3 | 2020-04-20 | 1 | 0 | |
30408 | 30408 | Alpine | Alpine | 3 | 2020-04-21 | 1 | 0 | |
30352 | 30352 | Alpine | Alpine | 3 | 2020-04-22 | 1 | 0 | TRUE |
30296 | 30296 | Alpine | Alpine | 3 | 2020-04-23 | 1 | 0 | TRUE |
30240 | 30240 | Alpine | Alpine | 3 | 2020-04-24 | 1 | 0 | TRUE |
30184 | 30184 | Alpine | Alpine | 3 | 2020-04-25 | 1 | 0 | TRUE |
30128 | 30128 | Alpine | Alpine | 3 | 2020-04-26 | 1 | 0 | TRUE |
30072 | 30072 | Alpine | Alpine | 3 | 2020-04-27 | 1 | 0 | |
30015 | 30015 | Alpine | Alpine | 3 | 2020-04-28 | 1 | 0 | TRUE |
29954 | 29954 | Alpine | Alpine | 3 | 2020-04-29 | 1 | 0 | TRUE |
29893 | 29893 | Alpine | Alpine | 3 | 2020-04-30 | 1 | 0 | TRUE |
29832 | 29832 | Alpine | Alpine | 3 | 2020-05-01 | 1 | 0 | TRUE |
29771 | 29771 | Alpine | Alpine | 3 | 2020-05-02 | 1 | 0 | TRUE |
29710 | 29710 | Alpine | Alpine | 3 | 2020-05-03 | 1 | 0 | TRUE |
29649 | 29649 | Alpine | Alpine | 3 | 2020-05-04 | 1 | 0 | TRUE |
29588 | 29588 | Alpine | Alpine | 3 | 2020-05-05 | 1 | 0 | TRUE |
29527 | 29527 | Alpine | Alpine | 3 | 2020-05-06 | 1 | 0 | TRUE |
29466 | 29466 | Alpine | Alpine | 3 | 2020-05-07 | 1 | 0 | TRUE |
29405 | 29405 | Alpine | Alpine | 3 | 2020-05-08 | 1 | 0 | TRUE |
29344 | 29344 | Alpine | Alpine | 3 | 2020-05-09 | 1 | 0 | TRUE |
29283 | 29283 | Alpine | Alpine | 3 | 2020-05-10 | 1 | 0 | TRUE |
29222 | 29222 | Alpine | Alpine | 3 | 2020-05-11 | 1 | 0 | TRUE |
29161 | 29161 | Alpine | Alpine | 3 | 2020-05-12 | 1 | 0 | TRUE |
29100 | 29100 | Alpine | Alpine | 3 | 2020-05-13 | 1 | 0 | TRUE |
29039 | 29039 | Alpine | Alpine | 3 | 2020-05-14 | 1 | 0 | TRUE |
28978 | 28978 | Alpine | Alpine | 3 | 2020-05-15 | 1 | 0 | TRUE |
28917 | 28917 | Alpine | Alpine | 3 | 2020-05-16 | 1 | 0 | TRUE |
28856 | 28856 | Alpine | Alpine | 3 | 2020-05-17 | 1 | 0 | TRUE |
28795 | 28795 | Alpine | Alpine | 3 | 2020-05-18 | 1 | 0 | TRUE |
28734 | 28734 | Alpine | Alpine | 3 | 2020-05-19 | 1 | 0 | TRUE |
28673 | 28673 | Alpine | Alpine | 3 | 2020-05-20 | 1 | 0 | |
28612 | 28612 | Alpine | Alpine | 3 | 2020-05-21 | 1 | 0 | TRUE |
28551 | 28551 | Alpine | Alpine | 3 | 2020-05-22 | 1 | 0 | |
28490 | 28490 | Alpine | Alpine | 3 | 2020-05-23 | 1 | 0 | TRUE |
28429 | 28429 | Alpine | Alpine | 3 | 2020-05-24 | 1 | 0 | TRUE |
28368 | 28368 | Alpine | Alpine | 3 | 2020-05-25 | 1 | 0 | TRUE |
28307 | 28307 | Alpine | Alpine | 3 | 2020-05-26 | 1 | 0 | TRUE |
28246 | 28246 | Alpine | Alpine | 3 | 2020-05-27 | 1 | 0 | TRUE |
28185 | 28185 | Alpine | Alpine | 3 | 2020-05-28 | 1 | 0 | TRUE |
28124 | 28124 | Alpine | Alpine | 3 | 2020-05-29 | 1 | 0 | TRUE |
28063 | 28063 | Alpine | Alpine | 3 | 2020-05-30 | 1 | 0 | TRUE |
28002 | 28002 | Alpine | Alpine | 3 | 2020-05-31 | 1 | 0 | TRUE |
27941 | 27941 | Alpine | Alpine | 3 | 2020-06-01 | 1 | 0 | TRUE |
27880 | 27880 | Alpine | Alpine | 3 | 2020-06-02 | 1 | 0 | TRUE |
27819 | 27819 | Alpine | Alpine | 3 | 2020-06-03 | 1 | 0 | TRUE |
27758 | 27758 | Alpine | Alpine | 3 | 2020-06-04 | 1 | 0 | TRUE |
27697 | 27697 | Alpine | Alpine | 3 | 2020-06-05 | 1 | 0 | |
27636 | 27636 | Alpine | Alpine | 3 | 2020-06-06 | 1 | 0 | TRUE |
27575 | 27575 | Alpine | Alpine | 3 | 2020-06-07 | 1 | 0 | TRUE |
27514 | 27514 | Alpine | Alpine | 3 | 2020-06-08 | 1 | 0 | TRUE |
27453 | 27453 | Alpine | Alpine | 3 | 2020-06-09 | 1 | 0 | TRUE |
27392 | 27392 | Alpine | Alpine | 3 | 2020-06-10 | 1 | 0 | |
27331 | 27331 | Alpine | Alpine | 3 | 2020-06-11 | 1 | 0 | TRUE |
27270 | 27270 | Alpine | Alpine | 3 | 2020-06-12 | 1 | 0 | |
27209 | 27209 | Alpine | Alpine | 3 | 2020-06-13 | 1 | 0 | TRUE |
27148 | 27148 | Alpine | Alpine | 3 | 2020-06-14 | 1 | 0 | TRUE |
27087 | 27087 | Alpine | Alpine | 3 | 2020-06-15 | 1 | 0 | TRUE |
27026 | 27026 | Alpine | Alpine | 3 | 2020-06-16 | 1 | 0 | TRUE |
26965 | 26965 | Alpine | Alpine | 3 | 2020-06-17 | 1 | 0 | TRUE |
26904 | 26904 | Alpine | Alpine | 3 | 2020-06-18 | 1 | 0 | TRUE |
26843 | 26843 | Alpine | Alpine | 3 | 2020-06-19 | 1 | 0 | TRUE |
26782 | 26782 | Alpine | Alpine | 3 | 2020-06-20 | 1 | 0 | TRUE |
26721 | 26721 | Alpine | Alpine | 3 | 2020-06-21 | 1 | 0 | TRUE |
26660 | 26660 | Alpine | Alpine | 3 | 2020-06-22 | 1 | 0 | TRUE |
26599 | 26599 | Alpine | Alpine | 3 | 2020-06-23 | 1 | 0 | TRUE |
26538 | 26538 | Alpine | Alpine | 3 | 2020-06-24 | 1 | 0 | TRUE |
26477 | 26477 | Alpine | Alpine | 3 | 2020-06-25 | 1 | 0 | TRUE |
26416 | 26416 | Alpine | Alpine | 3 | 2020-06-26 | 1 | 0 | TRUE |
26355 | 26355 | Alpine | Alpine | 3 | 2020-06-27 | 1 | 0 | TRUE |
26294 | 26294 | Alpine | Alpine | 3 | 2020-06-28 | 1 | 0 | TRUE |
26233 | 26233 | Alpine | Alpine | 3 | 2020-06-29 | |||
26172 | 26172 | Alpine | Alpine | 3 | 2020-06-30 | 1 | 0 | TRUE |
26111 | 26111 | Alpine | Alpine | 3 | 2020-07-01 | 1 | 0 | TRUE |
26050 | 26050 | Alpine | Alpine | 3 | 2020-07-02 | 1 | 0 | TRUE |
25989 | 25989 | Alpine | Alpine | 3 | 2020-07-03 | 1 | 0 | |
25928 | 25928 | Alpine | Alpine | 3 | 2020-07-04 | 1 | 0 | |
25867 | 25867 | Alpine | Alpine | 3 | 2020-07-05 | 1 | 0 | TRUE |
25806 | 25806 | Alpine | Alpine | 3 | 2020-07-06 | 1 | 0 | |
25745 | 25745 | Alpine | Alpine | 3 | 2020-07-07 | 1 | 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 );