latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
539 rows where fips = 5 sorted by new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
18911 | 18911 | 2020-10-11 | Amador | 5 | 267 | 15 | 0 | 0 |
18969 | 18969 | 2020-10-10 | Amador | 5 | 267 | 15 | 0 | 0 |
19201 | 19201 | 2020-10-06 | Amador | 5 | 264 | 15 | 0 | 0 |
19317 | 19317 | 2020-10-04 | Amador | 5 | 259 | 15 | 0 | 0 |
19375 | 19375 | 2020-10-03 | Amador | 5 | 259 | 15 | 0 | 0 |
19433 | 19433 | 2020-10-02 | Amador | 5 | 259 | 15 | 0 | 0 |
19549 | 19549 | 2020-09-30 | Amador | 5 | 257 | 15 | 0 | 0 |
19607 | 19607 | 2020-09-29 | Amador | 5 | 257 | 15 | 0 | 0 |
19723 | 19723 | 2020-09-27 | Amador | 5 | 254 | 15 | 0 | 0 |
19781 | 19781 | 2020-09-26 | Amador | 5 | 254 | 15 | 0 | 0 |
19955 | 19955 | 2020-09-23 | Amador | 5 | 252 | 15 | 0 | 0 |
20129 | 20129 | 2020-09-20 | Amador | 5 | 249 | 15 | 0 | 0 |
20187 | 20187 | 2020-09-19 | Amador | 5 | 249 | 15 | 0 | 0 |
20303 | 20303 | 2020-09-17 | Amador | 5 | 248 | 15 | 0 | 0 |
20593 | 20593 | 2020-09-12 | Amador | 5 | 242 | 15 | 0 | 0 |
20709 | 20709 | 2020-09-10 | Amador | 5 | 241 | 15 | 0 | 0 |
20825 | 20825 | 2020-09-08 | Amador | 5 | 239 | 15 | 0 | 0 |
20941 | 20941 | 2020-09-06 | Amador | 5 | 237 | 15 | 0 | 0 |
20999 | 20999 | 2020-09-05 | Amador | 5 | 237 | 15 | 0 | 0 |
21057 | 21057 | 2020-09-04 | Amador | 5 | 237 | 15 | 0 | 0 |
21115 | 21115 | 2020-09-03 | Amador | 5 | 237 | 15 | 0 | 0 |
21173 | 21173 | 2020-09-02 | Amador | 5 | 237 | 15 | 0 | 0 |
21347 | 21347 | 2020-08-30 | Amador | 5 | 234 | 13 | 0 | 0 |
21405 | 21405 | 2020-08-29 | Amador | 5 | 234 | 13 | 0 | 0 |
21753 | 21753 | 2020-08-23 | Amador | 5 | 221 | 13 | 0 | 0 |
21811 | 21811 | 2020-08-22 | Amador | 5 | 221 | 13 | 0 | 0 |
22217 | 22217 | 2020-08-15 | Amador | 5 | 208 | 11 | 0 | 0 |
22623 | 22623 | 2020-08-08 | Amador | 5 | 164 | 2 | 0 | 0 |
22971 | 22971 | 2020-08-02 | Amador | 5 | 126 | 0 | 0 | 0 |
23841 | 23841 | 2020-07-18 | Amador | 5 | 51 | 0 | 0 | 0 |
24131 | 24131 | 2020-07-13 | Amador | 5 | 40 | 0 | 0 | 0 |
24189 | 24189 | 2020-07-12 | Amador | 5 | 40 | 0 | 0 | 0 |
24537 | 24537 | 2020-07-06 | Amador | 5 | 33 | 0 | 0 | 0 |
24653 | 24653 | 2020-07-04 | Amador | 5 | 31 | 0 | 0 | 0 |
24885 | 24885 | 2020-06-30 | Amador | 5 | 22 | 0 | 0 | 0 |
25059 | 25059 | 2020-06-27 | Amador | 5 | 20 | 0 | 0 | 0 |
25117 | 25117 | 2020-06-26 | Amador | 5 | 20 | 0 | 0 | 0 |
25407 | 25407 | 2020-06-21 | Amador | 5 | 13 | 0 | 0 | 0 |
25523 | 25523 | 2020-06-19 | Amador | 5 | 12 | 0 | 0 | 0 |
25581 | 25581 | 2020-06-18 | Amador | 5 | 12 | 0 | 0 | 0 |
25639 | 25639 | 2020-06-17 | Amador | 5 | 12 | 0 | 0 | 0 |
25813 | 25813 | 2020-06-14 | Amador | 5 | 10 | 0 | 0 | 0 |
25871 | 25871 | 2020-06-13 | Amador | 5 | 10 | 0 | 0 | 0 |
25929 | 25929 | 2020-06-12 | Amador | 5 | 10 | 0 | 0 | 0 |
25987 | 25987 | 2020-06-11 | Amador | 5 | 10 | 0 | 0 | 0 |
26045 | 26045 | 2020-06-10 | Amador | 5 | 10 | 0 | 0 | 0 |
26103 | 26103 | 2020-06-09 | Amador | 5 | 10 | 0 | 0 | 0 |
26161 | 26161 | 2020-06-08 | Amador | 5 | 10 | 0 | 0 | 0 |
26219 | 26219 | 2020-06-07 | Amador | 5 | 10 | 0 | 0 | 0 |
26277 | 26277 | 2020-06-06 | Amador | 5 | 10 | 0 | 0 | 0 |
26335 | 26335 | 2020-06-05 | Amador | 5 | 10 | 0 | 0 | 0 |
26393 | 26393 | 2020-06-04 | Amador | 5 | 10 | 0 | 0 | 0 |
26451 | 26451 | 2020-06-03 | Amador | 5 | 10 | 0 | 0 | 0 |
26509 | 26509 | 2020-06-02 | Amador | 5 | 10 | 0 | 0 | 0 |
26567 | 26567 | 2020-06-01 | Amador | 5 | 10 | 0 | 0 | 0 |
26625 | 26625 | 2020-05-31 | Amador | 5 | 10 | 0 | 0 | 0 |
26683 | 26683 | 2020-05-30 | Amador | 5 | 10 | 0 | 0 | 0 |
26741 | 26741 | 2020-05-29 | Amador | 5 | 10 | 0 | 0 | 0 |
26799 | 26799 | 2020-05-28 | Amador | 5 | 10 | 0 | 0 | 0 |
26857 | 26857 | 2020-05-27 | Amador | 5 | 10 | 0 | 0 | 0 |
26915 | 26915 | 2020-05-26 | Amador | 5 | 10 | 0 | 0 | 0 |
26973 | 26973 | 2020-05-25 | Amador | 5 | 10 | 0 | 0 | 0 |
27031 | 27031 | 2020-05-24 | Amador | 5 | 10 | 0 | 0 | 0 |
27089 | 27089 | 2020-05-23 | Amador | 5 | 10 | 0 | 0 | 0 |
27147 | 27147 | 2020-05-22 | Amador | 5 | 10 | 0 | 0 | 0 |
27205 | 27205 | 2020-05-21 | Amador | 5 | 10 | 0 | 0 | 0 |
27263 | 27263 | 2020-05-20 | Amador | 5 | 10 | 0 | 0 | 0 |
27321 | 27321 | 2020-05-19 | Amador | 5 | 10 | 0 | 0 | 0 |
27437 | 27437 | 2020-05-17 | Amador | 5 | 9 | 0 | 0 | 0 |
27495 | 27495 | 2020-05-16 | Amador | 5 | 9 | 0 | 0 | 0 |
27553 | 27553 | 2020-05-15 | Amador | 5 | 9 | 0 | 0 | 0 |
27611 | 27611 | 2020-05-14 | Amador | 5 | 9 | 0 | 0 | 0 |
27669 | 27669 | 2020-05-13 | Amador | 5 | 9 | 0 | 0 | 0 |
27785 | 27785 | 2020-05-11 | Amador | 5 | 8 | 0 | 0 | 0 |
27843 | 27843 | 2020-05-10 | Amador | 5 | 8 | 0 | 0 | 0 |
27901 | 27901 | 2020-05-09 | Amador | 5 | 8 | 0 | 0 | 0 |
27959 | 27959 | 2020-05-08 | Amador | 5 | 8 | 0 | 0 | 0 |
28017 | 28017 | 2020-05-07 | Amador | 5 | 8 | 0 | 0 | 0 |
28075 | 28075 | 2020-05-06 | Amador | 5 | 8 | 0 | 0 | 0 |
28133 | 28133 | 2020-05-05 | Amador | 5 | 8 | 0 | 0 | 0 |
28191 | 28191 | 2020-05-04 | Amador | 5 | 8 | 0 | 0 | 0 |
28249 | 28249 | 2020-05-03 | Amador | 5 | 8 | 0 | 0 | 0 |
28307 | 28307 | 2020-05-02 | Amador | 5 | 8 | 0 | 0 | 0 |
28365 | 28365 | 2020-05-01 | Amador | 5 | 8 | 0 | 0 | 0 |
28423 | 28423 | 2020-04-30 | Amador | 5 | 8 | 0 | 0 | 0 |
28481 | 28481 | 2020-04-29 | Amador | 5 | 8 | 0 | 0 | 0 |
28539 | 28539 | 2020-04-28 | Amador | 5 | 8 | 0 | 0 | 0 |
28593 | 28593 | 2020-04-27 | Amador | 5 | 8 | 0 | 0 | 0 |
28646 | 28646 | 2020-04-26 | Amador | 5 | 8 | 0 | 0 | 0 |
28699 | 28699 | 2020-04-25 | Amador | 5 | 8 | 0 | 0 | 0 |
28752 | 28752 | 2020-04-24 | Amador | 5 | 8 | 0 | 0 | 0 |
28805 | 28805 | 2020-04-23 | Amador | 5 | 8 | 0 | 0 | 0 |
28858 | 28858 | 2020-04-22 | Amador | 5 | 8 | 0 | 0 | 0 |
28964 | 28964 | 2020-04-20 | Amador | 5 | 7 | 0 | 0 | 0 |
29017 | 29017 | 2020-04-19 | Amador | 5 | 7 | 0 | 0 | 0 |
29070 | 29070 | 2020-04-18 | Amador | 5 | 7 | 0 | 0 | 0 |
29123 | 29123 | 2020-04-17 | Amador | 5 | 7 | 0 | 0 | 0 |
29176 | 29176 | 2020-04-16 | Amador | 5 | 7 | 0 | 0 | 0 |
29229 | 29229 | 2020-04-15 | Amador | 5 | 7 | 0 | 0 | 0 |
29282 | 29282 | 2020-04-14 | Amador | 5 | 7 | 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 );