ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 6005 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5228 | 5228 | 2020-03-20 | Amador | California | 6005 | 1 | 0 |
6147 | 6147 | 2020-03-21 | Amador | California | 6005 | 1 | 0 |
7181 | 7181 | 2020-03-22 | Amador | California | 6005 | 1 | 0 |
8324 | 8324 | 2020-03-23 | Amador | California | 6005 | 1 | 0 |
9564 | 9564 | 2020-03-24 | Amador | California | 6005 | 1 | 0 |
10935 | 10935 | 2020-03-25 | Amador | California | 6005 | 1 | 0 |
12480 | 12480 | 2020-03-26 | Amador | California | 6005 | 1 | 0 |
14144 | 14144 | 2020-03-27 | Amador | California | 6005 | 1 | 0 |
15925 | 15925 | 2020-03-28 | Amador | California | 6005 | 1 | 0 |
17814 | 17814 | 2020-03-29 | Amador | California | 6005 | 1 | 0 |
19791 | 19791 | 2020-03-30 | Amador | California | 6005 | 1 | 0 |
21865 | 21865 | 2020-03-31 | Amador | California | 6005 | 1 | 0 |
24023 | 24023 | 2020-04-01 | Amador | California | 6005 | 2 | 0 |
26251 | 26251 | 2020-04-02 | Amador | California | 6005 | 2 | 0 |
28550 | 28550 | 2020-04-03 | Amador | California | 6005 | 2 | 0 |
30908 | 30908 | 2020-04-04 | Amador | California | 6005 | 2 | 0 |
33314 | 33314 | 2020-04-05 | Amador | California | 6005 | 2 | 0 |
35758 | 35758 | 2020-04-06 | Amador | California | 6005 | 2 | 0 |
38247 | 38247 | 2020-04-07 | Amador | California | 6005 | 2 | 0 |
40791 | 40791 | 2020-04-08 | Amador | California | 6005 | 2 | 0 |
43363 | 43363 | 2020-04-09 | Amador | California | 6005 | 6 | 0 |
45963 | 45963 | 2020-04-10 | Amador | California | 6005 | 6 | 0 |
48593 | 48593 | 2020-04-11 | Amador | California | 6005 | 6 | 0 |
51255 | 51255 | 2020-04-12 | Amador | California | 6005 | 6 | 0 |
53934 | 53934 | 2020-04-13 | Amador | California | 6005 | 6 | 0 |
56626 | 56626 | 2020-04-14 | Amador | California | 6005 | 6 | 0 |
59334 | 59334 | 2020-04-15 | Amador | California | 6005 | 6 | 0 |
62053 | 62053 | 2020-04-16 | Amador | California | 6005 | 6 | 0 |
64786 | 64786 | 2020-04-17 | Amador | California | 6005 | 6 | 0 |
67534 | 67534 | 2020-04-18 | Amador | California | 6005 | 6 | 0 |
70296 | 70296 | 2020-04-19 | Amador | California | 6005 | 6 | 0 |
73065 | 73065 | 2020-04-20 | Amador | California | 6005 | 6 | 0 |
75841 | 75841 | 2020-04-21 | Amador | California | 6005 | 7 | 0 |
78625 | 78625 | 2020-04-22 | Amador | California | 6005 | 7 | 0 |
81419 | 81419 | 2020-04-23 | Amador | California | 6005 | 7 | 0 |
84219 | 84219 | 2020-04-24 | Amador | California | 6005 | 7 | 0 |
87027 | 87027 | 2020-04-25 | Amador | California | 6005 | 7 | 0 |
89844 | 89844 | 2020-04-26 | Amador | California | 6005 | 7 | 0 |
92662 | 92662 | 2020-04-27 | Amador | California | 6005 | 7 | 0 |
95493 | 95493 | 2020-04-28 | Amador | California | 6005 | 7 | 0 |
98338 | 98338 | 2020-04-29 | Amador | California | 6005 | 7 | 0 |
101188 | 101188 | 2020-04-30 | Amador | California | 6005 | 7 | 0 |
104043 | 104043 | 2020-05-01 | Amador | California | 6005 | 7 | 0 |
106908 | 106908 | 2020-05-02 | Amador | California | 6005 | 7 | 0 |
109777 | 109777 | 2020-05-03 | Amador | California | 6005 | 7 | 0 |
112652 | 112652 | 2020-05-04 | Amador | California | 6005 | 7 | 0 |
115535 | 115535 | 2020-05-05 | Amador | California | 6005 | 7 | 0 |
118494 | 118494 | 2020-05-06 | Amador | California | 6005 | 7 | 0 |
121461 | 121461 | 2020-05-07 | Amador | California | 6005 | 7 | 0 |
124441 | 124441 | 2020-05-08 | Amador | California | 6005 | 7 | 0 |
127426 | 127426 | 2020-05-09 | Amador | California | 6005 | 7 | 0 |
130416 | 130416 | 2020-05-10 | Amador | California | 6005 | 7 | 0 |
133406 | 133406 | 2020-05-11 | Amador | California | 6005 | 7 | 0 |
136396 | 136396 | 2020-05-12 | Amador | California | 6005 | 7 | 0 |
139387 | 139387 | 2020-05-13 | Amador | California | 6005 | 8 | 0 |
142383 | 142383 | 2020-05-14 | Amador | California | 6005 | 8 | 0 |
145382 | 145382 | 2020-05-15 | Amador | California | 6005 | 8 | 0 |
148386 | 148386 | 2020-05-16 | Amador | California | 6005 | 8 | 0 |
151395 | 151395 | 2020-05-17 | Amador | California | 6005 | 8 | 0 |
154407 | 154407 | 2020-05-18 | Amador | California | 6005 | 8 | 0 |
157423 | 157423 | 2020-05-19 | Amador | California | 6005 | 8 | 0 |
160449 | 160449 | 2020-05-20 | Amador | California | 6005 | 9 | 0 |
163477 | 163477 | 2020-05-21 | Amador | California | 6005 | 9 | 0 |
166509 | 166509 | 2020-05-22 | Amador | California | 6005 | 9 | 0 |
169545 | 169545 | 2020-05-23 | Amador | California | 6005 | 9 | 0 |
172586 | 172586 | 2020-05-24 | Amador | California | 6005 | 9 | 0 |
175630 | 175630 | 2020-05-25 | Amador | California | 6005 | 9 | 0 |
178674 | 178674 | 2020-05-26 | Amador | California | 6005 | 10 | 0 |
181718 | 181718 | 2020-05-27 | Amador | California | 6005 | 10 | 0 |
184772 | 184772 | 2020-05-28 | Amador | California | 6005 | 10 | 0 |
187828 | 187828 | 2020-05-29 | Amador | California | 6005 | 10 | 0 |
190893 | 190893 | 2020-05-30 | Amador | California | 6005 | 10 | 0 |
193960 | 193960 | 2020-05-31 | Amador | California | 6005 | 10 | 0 |
197030 | 197030 | 2020-06-01 | Amador | California | 6005 | 10 | 0 |
200103 | 200103 | 2020-06-02 | Amador | California | 6005 | 10 | 0 |
203179 | 203179 | 2020-06-03 | Amador | California | 6005 | 10 | 0 |
206259 | 206259 | 2020-06-04 | Amador | California | 6005 | 10 | 0 |
209340 | 209340 | 2020-06-05 | Amador | California | 6005 | 9 | 0 |
212425 | 212425 | 2020-06-06 | Amador | California | 6005 | 9 | 0 |
215512 | 215512 | 2020-06-07 | Amador | California | 6005 | 9 | 0 |
218603 | 218603 | 2020-06-08 | Amador | California | 6005 | 9 | 0 |
221698 | 221698 | 2020-06-09 | Amador | California | 6005 | 9 | 0 |
224793 | 224793 | 2020-06-10 | Amador | California | 6005 | 9 | 0 |
227895 | 227895 | 2020-06-11 | Amador | California | 6005 | 9 | 0 |
230998 | 230998 | 2020-06-12 | Amador | California | 6005 | 9 | 0 |
234104 | 234104 | 2020-06-13 | Amador | California | 6005 | 9 | 0 |
237211 | 237211 | 2020-06-14 | Amador | California | 6005 | 9 | 0 |
240319 | 240319 | 2020-06-15 | Amador | California | 6005 | 10 | 0 |
243430 | 243430 | 2020-06-16 | Amador | California | 6005 | 11 | 0 |
246543 | 246543 | 2020-06-17 | Amador | California | 6005 | 11 | 0 |
249655 | 249655 | 2020-06-18 | Amador | California | 6005 | 11 | 0 |
252770 | 252770 | 2020-06-19 | Amador | California | 6005 | 11 | 0 |
255889 | 255889 | 2020-06-20 | Amador | California | 6005 | 12 | 0 |
259016 | 259016 | 2020-06-21 | Amador | California | 6005 | 12 | 0 |
262143 | 262143 | 2020-06-22 | Amador | California | 6005 | 13 | 0 |
265271 | 265271 | 2020-06-23 | Amador | California | 6005 | 15 | 0 |
268401 | 268401 | 2020-06-24 | Amador | California | 6005 | 17 | 0 |
271536 | 271536 | 2020-06-25 | Amador | California | 6005 | 18 | 0 |
274676 | 274676 | 2020-06-26 | Amador | California | 6005 | 18 | 0 |
277824 | 277824 | 2020-06-27 | Amador | California | 6005 | 19 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);