ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Custer" and state = "Idaho" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
12736 | 12736 | 2020-03-26 | Custer | Idaho | 16037 | 1 | 0 |
14411 | 14411 | 2020-03-27 | Custer | Idaho | 16037 | 1 | 0 |
16203 | 16203 | 2020-03-28 | Custer | Idaho | 16037 | 1 | 0 |
18100 | 18100 | 2020-03-29 | Custer | Idaho | 16037 | 1 | 0 |
20097 | 20097 | 2020-03-30 | Custer | Idaho | 16037 | 1 | 0 |
22188 | 22188 | 2020-03-31 | Custer | Idaho | 16037 | 2 | 0 |
24354 | 24354 | 2020-04-01 | Custer | Idaho | 16037 | 2 | 0 |
26586 | 26586 | 2020-04-02 | Custer | Idaho | 16037 | 2 | 0 |
28893 | 28893 | 2020-04-03 | Custer | Idaho | 16037 | 2 | 0 |
31255 | 31255 | 2020-04-04 | Custer | Idaho | 16037 | 2 | 0 |
33662 | 33662 | 2020-04-05 | Custer | Idaho | 16037 | 2 | 0 |
36113 | 36113 | 2020-04-06 | Custer | Idaho | 16037 | 2 | 0 |
38606 | 38606 | 2020-04-07 | Custer | Idaho | 16037 | 2 | 0 |
41150 | 41150 | 2020-04-08 | Custer | Idaho | 16037 | 2 | 0 |
43724 | 43724 | 2020-04-09 | Custer | Idaho | 16037 | 2 | 0 |
46326 | 46326 | 2020-04-10 | Custer | Idaho | 16037 | 2 | 0 |
48957 | 48957 | 2020-04-11 | Custer | Idaho | 16037 | 2 | 0 |
51619 | 51619 | 2020-04-12 | Custer | Idaho | 16037 | 2 | 0 |
54299 | 54299 | 2020-04-13 | Custer | Idaho | 16037 | 2 | 0 |
56991 | 56991 | 2020-04-14 | Custer | Idaho | 16037 | 2 | 0 |
59698 | 59698 | 2020-04-15 | Custer | Idaho | 16037 | 2 | 0 |
62418 | 62418 | 2020-04-16 | Custer | Idaho | 16037 | 2 | 0 |
65150 | 65150 | 2020-04-17 | Custer | Idaho | 16037 | 2 | 0 |
67898 | 67898 | 2020-04-18 | Custer | Idaho | 16037 | 2 | 0 |
70660 | 70660 | 2020-04-19 | Custer | Idaho | 16037 | 2 | 0 |
73429 | 73429 | 2020-04-20 | Custer | Idaho | 16037 | 2 | 0 |
76205 | 76205 | 2020-04-21 | Custer | Idaho | 16037 | 2 | 0 |
78989 | 78989 | 2020-04-22 | Custer | Idaho | 16037 | 2 | 0 |
81782 | 81782 | 2020-04-23 | Custer | Idaho | 16037 | 2 | 0 |
84582 | 84582 | 2020-04-24 | Custer | Idaho | 16037 | 2 | 0 |
87391 | 87391 | 2020-04-25 | Custer | Idaho | 16037 | 2 | 0 |
90207 | 90207 | 2020-04-26 | Custer | Idaho | 16037 | 2 | 0 |
93026 | 93026 | 2020-04-27 | Custer | Idaho | 16037 | 2 | 0 |
95858 | 95858 | 2020-04-28 | Custer | Idaho | 16037 | 2 | 0 |
98702 | 98702 | 2020-04-29 | Custer | Idaho | 16037 | 2 | 0 |
101553 | 101553 | 2020-04-30 | Custer | Idaho | 16037 | 2 | 0 |
104408 | 104408 | 2020-05-01 | Custer | Idaho | 16037 | 2 | 0 |
107273 | 107273 | 2020-05-02 | Custer | Idaho | 16037 | 2 | 0 |
110143 | 110143 | 2020-05-03 | Custer | Idaho | 16037 | 2 | 0 |
113018 | 113018 | 2020-05-04 | Custer | Idaho | 16037 | 2 | 0 |
115901 | 115901 | 2020-05-05 | Custer | Idaho | 16037 | 2 | 0 |
118861 | 118861 | 2020-05-06 | Custer | Idaho | 16037 | 2 | 0 |
121831 | 121831 | 2020-05-07 | Custer | Idaho | 16037 | 2 | 0 |
124810 | 124810 | 2020-05-08 | Custer | Idaho | 16037 | 2 | 0 |
127797 | 127797 | 2020-05-09 | Custer | Idaho | 16037 | 2 | 0 |
130788 | 130788 | 2020-05-10 | Custer | Idaho | 16037 | 2 | 0 |
133779 | 133779 | 2020-05-11 | Custer | Idaho | 16037 | 2 | 0 |
136768 | 136768 | 2020-05-12 | Custer | Idaho | 16037 | 2 | 0 |
139759 | 139759 | 2020-05-13 | Custer | Idaho | 16037 | 2 | 0 |
142755 | 142755 | 2020-05-14 | Custer | Idaho | 16037 | 2 | 0 |
145755 | 145755 | 2020-05-15 | Custer | Idaho | 16037 | 2 | 0 |
148758 | 148758 | 2020-05-16 | Custer | Idaho | 16037 | 2 | 0 |
151767 | 151767 | 2020-05-17 | Custer | Idaho | 16037 | 2 | 0 |
154779 | 154779 | 2020-05-18 | Custer | Idaho | 16037 | 2 | 0 |
157795 | 157795 | 2020-05-19 | Custer | Idaho | 16037 | 2 | 0 |
160821 | 160821 | 2020-05-20 | Custer | Idaho | 16037 | 2 | 0 |
163849 | 163849 | 2020-05-21 | Custer | Idaho | 16037 | 2 | 0 |
166882 | 166882 | 2020-05-22 | Custer | Idaho | 16037 | 2 | 0 |
169919 | 169919 | 2020-05-23 | Custer | Idaho | 16037 | 2 | 0 |
172960 | 172960 | 2020-05-24 | Custer | Idaho | 16037 | 2 | 0 |
176004 | 176004 | 2020-05-25 | Custer | Idaho | 16037 | 2 | 0 |
179048 | 179048 | 2020-05-26 | Custer | Idaho | 16037 | 2 | 0 |
182092 | 182092 | 2020-05-27 | Custer | Idaho | 16037 | 2 | 0 |
185146 | 185146 | 2020-05-28 | Custer | Idaho | 16037 | 2 | 0 |
188202 | 188202 | 2020-05-29 | Custer | Idaho | 16037 | 2 | 0 |
191267 | 191267 | 2020-05-30 | Custer | Idaho | 16037 | 2 | 0 |
194334 | 194334 | 2020-05-31 | Custer | Idaho | 16037 | 2 | 0 |
197404 | 197404 | 2020-06-01 | Custer | Idaho | 16037 | 2 | 0 |
200477 | 200477 | 2020-06-02 | Custer | Idaho | 16037 | 2 | 0 |
203553 | 203553 | 2020-06-03 | Custer | Idaho | 16037 | 2 | 0 |
206633 | 206633 | 2020-06-04 | Custer | Idaho | 16037 | 2 | 0 |
209714 | 209714 | 2020-06-05 | Custer | Idaho | 16037 | 2 | 0 |
212799 | 212799 | 2020-06-06 | Custer | Idaho | 16037 | 2 | 0 |
215886 | 215886 | 2020-06-07 | Custer | Idaho | 16037 | 2 | 0 |
218977 | 218977 | 2020-06-08 | Custer | Idaho | 16037 | 2 | 0 |
222072 | 222072 | 2020-06-09 | Custer | Idaho | 16037 | 2 | 0 |
225167 | 225167 | 2020-06-10 | Custer | Idaho | 16037 | 2 | 0 |
228269 | 228269 | 2020-06-11 | Custer | Idaho | 16037 | 2 | 0 |
231372 | 231372 | 2020-06-12 | Custer | Idaho | 16037 | 2 | 0 |
234478 | 234478 | 2020-06-13 | Custer | Idaho | 16037 | 2 | 0 |
237585 | 237585 | 2020-06-14 | Custer | Idaho | 16037 | 2 | 0 |
240693 | 240693 | 2020-06-15 | Custer | Idaho | 16037 | 2 | 0 |
243804 | 243804 | 2020-06-16 | Custer | Idaho | 16037 | 2 | 0 |
246917 | 246917 | 2020-06-17 | Custer | Idaho | 16037 | 2 | 0 |
250029 | 250029 | 2020-06-18 | Custer | Idaho | 16037 | 2 | 0 |
253144 | 253144 | 2020-06-19 | Custer | Idaho | 16037 | 2 | 0 |
256263 | 256263 | 2020-06-20 | Custer | Idaho | 16037 | 2 | 0 |
259390 | 259390 | 2020-06-21 | Custer | Idaho | 16037 | 2 | 0 |
262517 | 262517 | 2020-06-22 | Custer | Idaho | 16037 | 2 | 0 |
265645 | 265645 | 2020-06-23 | Custer | Idaho | 16037 | 2 | 0 |
268775 | 268775 | 2020-06-24 | Custer | Idaho | 16037 | 2 | 0 |
271912 | 271912 | 2020-06-25 | Custer | Idaho | 16037 | 3 | 0 |
275054 | 275054 | 2020-06-26 | Custer | Idaho | 16037 | 3 | 0 |
278202 | 278202 | 2020-06-27 | Custer | Idaho | 16037 | 3 | 0 |
281349 | 281349 | 2020-06-28 | Custer | Idaho | 16037 | 5 | 0 |
284495 | 284495 | 2020-06-29 | Custer | Idaho | 16037 | 5 | 0 |
287643 | 287643 | 2020-06-30 | Custer | Idaho | 16037 | 5 | 0 |
290793 | 290793 | 2020-07-01 | Custer | Idaho | 16037 | 5 | 0 |
293947 | 293947 | 2020-07-02 | Custer | Idaho | 16037 | 5 | 0 |
297103 | 297103 | 2020-07-03 | Custer | Idaho | 16037 | 5 | 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);