ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Huntington" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14490 | 14490 | 2020-03-27 | Huntington | Indiana | 18069 | 1 | 0 |
16288 | 16288 | 2020-03-28 | Huntington | Indiana | 18069 | 1 | 0 |
18191 | 18191 | 2020-03-29 | Huntington | Indiana | 18069 | 1 | 0 |
20197 | 20197 | 2020-03-30 | Huntington | Indiana | 18069 | 2 | 0 |
22291 | 22291 | 2020-03-31 | Huntington | Indiana | 18069 | 2 | 0 |
24461 | 24461 | 2020-04-01 | Huntington | Indiana | 18069 | 2 | 0 |
26700 | 26700 | 2020-04-02 | Huntington | Indiana | 18069 | 3 | 1 |
29010 | 29010 | 2020-04-03 | Huntington | Indiana | 18069 | 3 | 1 |
31376 | 31376 | 2020-04-04 | Huntington | Indiana | 18069 | 5 | 1 |
33787 | 33787 | 2020-04-05 | Huntington | Indiana | 18069 | 4 | 1 |
36240 | 36240 | 2020-04-06 | Huntington | Indiana | 18069 | 4 | 1 |
38738 | 38738 | 2020-04-07 | Huntington | Indiana | 18069 | 6 | 1 |
41284 | 41284 | 2020-04-08 | Huntington | Indiana | 18069 | 6 | 1 |
43860 | 43860 | 2020-04-09 | Huntington | Indiana | 18069 | 6 | 1 |
46464 | 46464 | 2020-04-10 | Huntington | Indiana | 18069 | 6 | 1 |
49098 | 49098 | 2020-04-11 | Huntington | Indiana | 18069 | 6 | 1 |
51761 | 51761 | 2020-04-12 | Huntington | Indiana | 18069 | 7 | 1 |
54442 | 54442 | 2020-04-13 | Huntington | Indiana | 18069 | 6 | 1 |
57135 | 57135 | 2020-04-14 | Huntington | Indiana | 18069 | 6 | 1 |
59843 | 59843 | 2020-04-15 | Huntington | Indiana | 18069 | 6 | 1 |
62564 | 62564 | 2020-04-16 | Huntington | Indiana | 18069 | 6 | 1 |
65298 | 65298 | 2020-04-17 | Huntington | Indiana | 18069 | 6 | 1 |
68047 | 68047 | 2020-04-18 | Huntington | Indiana | 18069 | 6 | 1 |
70809 | 70809 | 2020-04-19 | Huntington | Indiana | 18069 | 6 | 1 |
73580 | 73580 | 2020-04-20 | Huntington | Indiana | 18069 | 6 | 1 |
76357 | 76357 | 2020-04-21 | Huntington | Indiana | 18069 | 6 | 1 |
79141 | 79141 | 2020-04-22 | Huntington | Indiana | 18069 | 6 | 2 |
81934 | 81934 | 2020-04-23 | Huntington | Indiana | 18069 | 6 | 2 |
84734 | 84734 | 2020-04-24 | Huntington | Indiana | 18069 | 6 | 2 |
87544 | 87544 | 2020-04-25 | Huntington | Indiana | 18069 | 6 | 2 |
90360 | 90360 | 2020-04-26 | Huntington | Indiana | 18069 | 7 | 2 |
93179 | 93179 | 2020-04-27 | Huntington | Indiana | 18069 | 9 | 2 |
96011 | 96011 | 2020-04-28 | Huntington | Indiana | 18069 | 9 | 2 |
98855 | 98855 | 2020-04-29 | Huntington | Indiana | 18069 | 9 | 2 |
101706 | 101706 | 2020-04-30 | Huntington | Indiana | 18069 | 9 | 2 |
104562 | 104562 | 2020-05-01 | Huntington | Indiana | 18069 | 9 | 2 |
107427 | 107427 | 2020-05-02 | Huntington | Indiana | 18069 | 10 | 2 |
110297 | 110297 | 2020-05-03 | Huntington | Indiana | 18069 | 11 | 2 |
113172 | 113172 | 2020-05-04 | Huntington | Indiana | 18069 | 11 | 2 |
116055 | 116055 | 2020-05-05 | Huntington | Indiana | 18069 | 11 | 2 |
119015 | 119015 | 2020-05-06 | Huntington | Indiana | 18069 | 12 | 2 |
121985 | 121985 | 2020-05-07 | Huntington | Indiana | 18069 | 12 | 2 |
124965 | 124965 | 2020-05-08 | Huntington | Indiana | 18069 | 13 | 2 |
127952 | 127952 | 2020-05-09 | Huntington | Indiana | 18069 | 13 | 2 |
130943 | 130943 | 2020-05-10 | Huntington | Indiana | 18069 | 14 | 2 |
133933 | 133933 | 2020-05-11 | Huntington | Indiana | 18069 | 14 | 2 |
136922 | 136922 | 2020-05-12 | Huntington | Indiana | 18069 | 17 | 2 |
139914 | 139914 | 2020-05-13 | Huntington | Indiana | 18069 | 17 | 2 |
142910 | 142910 | 2020-05-14 | Huntington | Indiana | 18069 | 18 | 2 |
145910 | 145910 | 2020-05-15 | Huntington | Indiana | 18069 | 19 | 2 |
148914 | 148914 | 2020-05-16 | Huntington | Indiana | 18069 | 20 | 2 |
151923 | 151923 | 2020-05-17 | Huntington | Indiana | 18069 | 21 | 2 |
154935 | 154935 | 2020-05-18 | Huntington | Indiana | 18069 | 21 | 2 |
157951 | 157951 | 2020-05-19 | Huntington | Indiana | 18069 | 20 | 2 |
160977 | 160977 | 2020-05-20 | Huntington | Indiana | 18069 | 20 | 2 |
164005 | 164005 | 2020-05-21 | Huntington | Indiana | 18069 | 20 | 2 |
167038 | 167038 | 2020-05-22 | Huntington | Indiana | 18069 | 20 | 2 |
170075 | 170075 | 2020-05-23 | Huntington | Indiana | 18069 | 22 | 2 |
173116 | 173116 | 2020-05-24 | Huntington | Indiana | 18069 | 22 | 2 |
176160 | 176160 | 2020-05-25 | Huntington | Indiana | 18069 | 26 | 2 |
179204 | 179204 | 2020-05-26 | Huntington | Indiana | 18069 | 26 | 2 |
182248 | 182248 | 2020-05-27 | Huntington | Indiana | 18069 | 26 | 2 |
185302 | 185302 | 2020-05-28 | Huntington | Indiana | 18069 | 26 | 2 |
188360 | 188360 | 2020-05-29 | Huntington | Indiana | 18069 | 27 | 2 |
191425 | 191425 | 2020-05-30 | Huntington | Indiana | 18069 | 27 | 2 |
194492 | 194492 | 2020-05-31 | Huntington | Indiana | 18069 | 28 | 2 |
197562 | 197562 | 2020-06-01 | Huntington | Indiana | 18069 | 28 | 2 |
200635 | 200635 | 2020-06-02 | Huntington | Indiana | 18069 | 28 | 2 |
203711 | 203711 | 2020-06-03 | Huntington | Indiana | 18069 | 34 | 2 |
206791 | 206791 | 2020-06-04 | Huntington | Indiana | 18069 | 38 | 2 |
209872 | 209872 | 2020-06-05 | Huntington | Indiana | 18069 | 38 | 2 |
212957 | 212957 | 2020-06-06 | Huntington | Indiana | 18069 | 39 | 2 |
216044 | 216044 | 2020-06-07 | Huntington | Indiana | 18069 | 42 | 2 |
219136 | 219136 | 2020-06-08 | Huntington | Indiana | 18069 | 44 | 2 |
222231 | 222231 | 2020-06-09 | Huntington | Indiana | 18069 | 46 | 2 |
225326 | 225326 | 2020-06-10 | Huntington | Indiana | 18069 | 49 | 2 |
228428 | 228428 | 2020-06-11 | Huntington | Indiana | 18069 | 49 | 2 |
231531 | 231531 | 2020-06-12 | Huntington | Indiana | 18069 | 49 | 2 |
234637 | 234637 | 2020-06-13 | Huntington | Indiana | 18069 | 51 | 2 |
237744 | 237744 | 2020-06-14 | Huntington | Indiana | 18069 | 51 | 2 |
240852 | 240852 | 2020-06-15 | Huntington | Indiana | 18069 | 52 | 2 |
243963 | 243963 | 2020-06-16 | Huntington | Indiana | 18069 | 55 | 2 |
247076 | 247076 | 2020-06-17 | Huntington | Indiana | 18069 | 55 | 2 |
250188 | 250188 | 2020-06-18 | Huntington | Indiana | 18069 | 57 | 2 |
253303 | 253303 | 2020-06-19 | Huntington | Indiana | 18069 | 58 | 2 |
256423 | 256423 | 2020-06-20 | Huntington | Indiana | 18069 | 57 | 2 |
259549 | 259549 | 2020-06-21 | Huntington | Indiana | 18069 | 60 | 2 |
262676 | 262676 | 2020-06-22 | Huntington | Indiana | 18069 | 61 | 2 |
265804 | 265804 | 2020-06-23 | Huntington | Indiana | 18069 | 62 | 2 |
268934 | 268934 | 2020-06-24 | Huntington | Indiana | 18069 | 63 | 2 |
272071 | 272071 | 2020-06-25 | Huntington | Indiana | 18069 | 64 | 2 |
275213 | 275213 | 2020-06-26 | Huntington | Indiana | 18069 | 65 | 2 |
278361 | 278361 | 2020-06-27 | Huntington | Indiana | 18069 | 66 | 2 |
281509 | 281509 | 2020-06-28 | Huntington | Indiana | 18069 | 67 | 2 |
284654 | 284654 | 2020-06-29 | Huntington | Indiana | 18069 | 70 | 2 |
287803 | 287803 | 2020-06-30 | Huntington | Indiana | 18069 | 70 | 2 |
290953 | 290953 | 2020-07-01 | Huntington | Indiana | 18069 | 70 | 2 |
294107 | 294107 | 2020-07-02 | Huntington | Indiana | 18069 | 70 | 2 |
297265 | 297265 | 2020-07-03 | Huntington | Indiana | 18069 | 71 | 2 |
300427 | 300427 | 2020-07-04 | Huntington | Indiana | 18069 | 74 | 2 |
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);