latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
539 rows where county = "Amador" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- …
fips 1
- 5 539
county 1
- Amador · 539 ✖
agency 1
- Amador 539
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
32106 | 32106 | Amador | Amador | 5 | 2020-03-20 | 1 | 0 | |
32145 | 32145 | Amador | Amador | 5 | 2020-03-19 | 1 | 0 | |
32183 | 32183 | Amador | Amador | 5 | 2020-03-18 | 1 | 0 | |
32221 | 32221 | Amador | Amador | 5 | 2020-03-17 | 1 | 0 | |
32258 | 32258 | Amador | Amador | 5 | 2020-03-16 | 1 | 0 | |
32293 | 32293 | Amador | Amador | 5 | 2020-03-15 | 1 | 0 | |
32327 | 32327 | Amador | Amador | 5 | 2020-03-14 | 1 | 0 | |
32359 | 32359 | Amador | Amador | 5 | 2020-03-13 | 1 | 0 | |
31580 | 31580 | Amador | Amador | 5 | 2020-03-31 | 2 | 0 | |
31633 | 31633 | Amador | Amador | 5 | 2020-03-30 | 2 | 0 | |
31684 | 31684 | Amador | Amador | 5 | 2020-03-29 | 2 | 0 | |
31734 | 31734 | Amador | Amador | 5 | 2020-03-28 | 2 | 0 | |
31784 | 31784 | Amador | Amador | 5 | 2020-03-27 | 2 | 0 | |
31834 | 31834 | Amador | Amador | 5 | 2020-03-26 | 2 | 0 | TRUE |
31881 | 31881 | Amador | Amador | 5 | 2020-03-25 | 2 | 0 | |
31928 | 31928 | Amador | Amador | 5 | 2020-03-24 | 2 | 0 | |
31973 | 31973 | Amador | Amador | 5 | 2020-03-23 | 2 | 0 | |
32018 | 32018 | Amador | Amador | 5 | 2020-03-22 | 2 | 0 | |
32063 | 32063 | Amador | Amador | 5 | 2020-03-21 | 2 | 0 | |
31137 | 31137 | Amador | Amador | 5 | 2020-04-08 | 3 | 0 | |
31193 | 31193 | Amador | Amador | 5 | 2020-04-07 | 3 | 0 | |
31249 | 31249 | Amador | Amador | 5 | 2020-04-06 | 3 | 0 | |
31305 | 31305 | Amador | Amador | 5 | 2020-04-05 | 3 | 0 | |
31361 | 31361 | Amador | Amador | 5 | 2020-04-04 | 3 | 0 | TRUE |
31416 | 31416 | Amador | Amador | 5 | 2020-04-03 | 3 | 0 | |
31471 | 31471 | Amador | Amador | 5 | 2020-04-02 | 3 | 0 | |
31526 | 31526 | Amador | Amador | 5 | 2020-04-01 | 3 | 0 | |
30465 | 30465 | Amador | Amador | 5 | 2020-04-20 | 7 | 0 | |
30521 | 30521 | Amador | Amador | 5 | 2020-04-19 | 7 | 0 | TRUE |
30577 | 30577 | Amador | Amador | 5 | 2020-04-18 | 7 | 0 | TRUE |
30633 | 30633 | Amador | Amador | 5 | 2020-04-17 | 7 | 0 | |
30689 | 30689 | Amador | Amador | 5 | 2020-04-16 | 7 | 0 | |
30745 | 30745 | Amador | Amador | 5 | 2020-04-15 | 7 | 0 | |
30801 | 30801 | Amador | Amador | 5 | 2020-04-14 | 7 | 0 | |
30857 | 30857 | Amador | Amador | 5 | 2020-04-13 | 7 | 0 | |
30913 | 30913 | Amador | Amador | 5 | 2020-04-12 | 7 | 0 | TRUE |
30969 | 30969 | Amador | Amador | 5 | 2020-04-11 | 7 | 0 | TRUE |
31025 | 31025 | Amador | Amador | 5 | 2020-04-10 | 7 | 0 | |
31081 | 31081 | Amador | Amador | 5 | 2020-04-09 | 7 | 0 | |
29223 | 29223 | Amador | Amador | 5 | 2020-05-11 | 8 | 0 | TRUE |
29284 | 29284 | Amador | Amador | 5 | 2020-05-10 | 8 | 0 | |
29345 | 29345 | Amador | Amador | 5 | 2020-05-09 | 8 | 0 | TRUE |
29406 | 29406 | Amador | Amador | 5 | 2020-05-08 | 8 | 0 | |
29467 | 29467 | Amador | Amador | 5 | 2020-05-07 | 8 | 0 | TRUE |
29528 | 29528 | Amador | Amador | 5 | 2020-05-06 | 8 | 0 | |
29589 | 29589 | Amador | Amador | 5 | 2020-05-05 | 8 | 0 | |
29650 | 29650 | Amador | Amador | 5 | 2020-05-04 | 8 | 0 | |
29711 | 29711 | Amador | Amador | 5 | 2020-05-03 | 8 | 0 | TRUE |
29772 | 29772 | Amador | Amador | 5 | 2020-05-02 | 8 | 0 | |
29833 | 29833 | Amador | Amador | 5 | 2020-05-01 | 8 | 0 | |
29894 | 29894 | Amador | Amador | 5 | 2020-04-30 | 8 | 0 | |
29955 | 29955 | Amador | Amador | 5 | 2020-04-29 | 8 | 0 | |
30016 | 30016 | Amador | Amador | 5 | 2020-04-28 | 8 | 0 | |
30073 | 30073 | Amador | Amador | 5 | 2020-04-27 | 8 | 0 | TRUE |
30129 | 30129 | Amador | Amador | 5 | 2020-04-26 | 8 | 0 | TRUE |
30185 | 30185 | Amador | Amador | 5 | 2020-04-25 | 8 | 0 | TRUE |
30241 | 30241 | Amador | Amador | 5 | 2020-04-24 | 8 | 0 | |
30297 | 30297 | Amador | Amador | 5 | 2020-04-23 | 8 | 0 | |
30353 | 30353 | Amador | Amador | 5 | 2020-04-22 | 8 | 0 | |
30409 | 30409 | Amador | Amador | 5 | 2020-04-21 | 8 | 0 | |
28857 | 28857 | Amador | Amador | 5 | 2020-05-17 | 9 | 0 | |
28918 | 28918 | Amador | Amador | 5 | 2020-05-16 | 9 | 0 | TRUE |
28979 | 28979 | Amador | Amador | 5 | 2020-05-15 | 9 | 0 | |
29040 | 29040 | Amador | Amador | 5 | 2020-05-14 | 9 | 0 | |
29101 | 29101 | Amador | Amador | 5 | 2020-05-13 | 9 | 0 | |
29162 | 29162 | Amador | Amador | 5 | 2020-05-12 | 9 | 0 | |
27149 | 27149 | Amador | Amador | 5 | 2020-06-14 | 10 | 0 | |
27210 | 27210 | Amador | Amador | 5 | 2020-06-13 | 10 | 0 | TRUE |
27271 | 27271 | Amador | Amador | 5 | 2020-06-12 | 10 | 0 | |
27332 | 27332 | Amador | Amador | 5 | 2020-06-11 | 10 | 0 | |
27393 | 27393 | Amador | Amador | 5 | 2020-06-10 | 10 | 0 | |
27454 | 27454 | Amador | Amador | 5 | 2020-06-09 | 10 | 0 | |
27515 | 27515 | Amador | Amador | 5 | 2020-06-08 | 10 | 0 | |
27576 | 27576 | Amador | Amador | 5 | 2020-06-07 | 10 | 0 | TRUE |
27637 | 27637 | Amador | Amador | 5 | 2020-06-06 | 10 | 0 | |
27698 | 27698 | Amador | Amador | 5 | 2020-06-05 | 10 | 0 | |
27759 | 27759 | Amador | Amador | 5 | 2020-06-04 | 10 | 0 | |
27820 | 27820 | Amador | Amador | 5 | 2020-06-03 | 10 | 0 | |
27881 | 27881 | Amador | Amador | 5 | 2020-06-02 | 10 | 0 | |
27942 | 27942 | Amador | Amador | 5 | 2020-06-01 | 10 | 0 | |
28003 | 28003 | Amador | Amador | 5 | 2020-05-31 | 10 | 0 | TRUE |
28064 | 28064 | Amador | Amador | 5 | 2020-05-30 | 10 | 0 | TRUE |
28125 | 28125 | Amador | Amador | 5 | 2020-05-29 | 10 | 0 | |
28186 | 28186 | Amador | Amador | 5 | 2020-05-28 | 10 | 0 | |
28247 | 28247 | Amador | Amador | 5 | 2020-05-27 | 10 | 0 | |
28308 | 28308 | Amador | Amador | 5 | 2020-05-26 | 10 | 0 | |
28369 | 28369 | Amador | Amador | 5 | 2020-05-25 | 10 | 0 | TRUE |
28430 | 28430 | Amador | Amador | 5 | 2020-05-24 | 10 | 0 | |
28491 | 28491 | Amador | Amador | 5 | 2020-05-23 | 10 | 0 | TRUE |
28552 | 28552 | Amador | Amador | 5 | 2020-05-22 | 10 | 0 | |
28613 | 28613 | Amador | Amador | 5 | 2020-05-21 | 10 | 0 | |
28674 | 28674 | Amador | Amador | 5 | 2020-05-20 | 10 | 0 | |
28735 | 28735 | Amador | Amador | 5 | 2020-05-19 | 10 | 0 | |
28796 | 28796 | Amador | Amador | 5 | 2020-05-18 | 10 | 0 | |
27088 | 27088 | Amador | Amador | 5 | 2020-06-15 | 11 | 0 | |
26844 | 26844 | Amador | Amador | 5 | 2020-06-19 | 12 | 0 | |
26905 | 26905 | Amador | Amador | 5 | 2020-06-18 | 12 | 0 | |
26966 | 26966 | Amador | Amador | 5 | 2020-06-17 | 12 | 0 | |
27027 | 27027 | Amador | Amador | 5 | 2020-06-16 | 12 | 0 | |
26722 | 26722 | Amador | Amador | 5 | 2020-06-21 | 13 | 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 );