ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where county = "Hardin" and state = "Illinois" 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 |
---|---|---|---|---|---|---|---|
76257 | 76257 | 2020-04-21 | Hardin | Illinois | 17069 | 1 | 0 |
79041 | 79041 | 2020-04-22 | Hardin | Illinois | 17069 | 1 | 0 |
81834 | 81834 | 2020-04-23 | Hardin | Illinois | 17069 | 1 | 0 |
84634 | 84634 | 2020-04-24 | Hardin | Illinois | 17069 | 1 | 0 |
87444 | 87444 | 2020-04-25 | Hardin | Illinois | 17069 | 1 | 0 |
90260 | 90260 | 2020-04-26 | Hardin | Illinois | 17069 | 1 | 0 |
93079 | 93079 | 2020-04-27 | Hardin | Illinois | 17069 | 1 | 0 |
95911 | 95911 | 2020-04-28 | Hardin | Illinois | 17069 | 1 | 0 |
98755 | 98755 | 2020-04-29 | Hardin | Illinois | 17069 | 1 | 0 |
101606 | 101606 | 2020-04-30 | Hardin | Illinois | 17069 | 1 | 0 |
104462 | 104462 | 2020-05-01 | Hardin | Illinois | 17069 | 1 | 0 |
107327 | 107327 | 2020-05-02 | Hardin | Illinois | 17069 | 1 | 0 |
110197 | 110197 | 2020-05-03 | Hardin | Illinois | 17069 | 1 | 0 |
113072 | 113072 | 2020-05-04 | Hardin | Illinois | 17069 | 1 | 0 |
115955 | 115955 | 2020-05-05 | Hardin | Illinois | 17069 | 1 | 0 |
118915 | 118915 | 2020-05-06 | Hardin | Illinois | 17069 | 1 | 0 |
121885 | 121885 | 2020-05-07 | Hardin | Illinois | 17069 | 1 | 0 |
124864 | 124864 | 2020-05-08 | Hardin | Illinois | 17069 | 1 | 0 |
127851 | 127851 | 2020-05-09 | Hardin | Illinois | 17069 | 1 | 0 |
130842 | 130842 | 2020-05-10 | Hardin | Illinois | 17069 | 1 | 0 |
133833 | 133833 | 2020-05-11 | Hardin | Illinois | 17069 | 1 | 0 |
136822 | 136822 | 2020-05-12 | Hardin | Illinois | 17069 | 1 | 0 |
139814 | 139814 | 2020-05-13 | Hardin | Illinois | 17069 | 1 | 0 |
142810 | 142810 | 2020-05-14 | Hardin | Illinois | 17069 | 1 | 0 |
145810 | 145810 | 2020-05-15 | Hardin | Illinois | 17069 | 1 | 0 |
148813 | 148813 | 2020-05-16 | Hardin | Illinois | 17069 | 1 | 0 |
151822 | 151822 | 2020-05-17 | Hardin | Illinois | 17069 | 1 | 0 |
154834 | 154834 | 2020-05-18 | Hardin | Illinois | 17069 | 1 | 0 |
157850 | 157850 | 2020-05-19 | Hardin | Illinois | 17069 | 1 | 0 |
160876 | 160876 | 2020-05-20 | Hardin | Illinois | 17069 | 1 | 0 |
163904 | 163904 | 2020-05-21 | Hardin | Illinois | 17069 | 1 | 0 |
166937 | 166937 | 2020-05-22 | Hardin | Illinois | 17069 | 1 | 0 |
169974 | 169974 | 2020-05-23 | Hardin | Illinois | 17069 | 1 | 0 |
173015 | 173015 | 2020-05-24 | Hardin | Illinois | 17069 | 1 | 0 |
176059 | 176059 | 2020-05-25 | Hardin | Illinois | 17069 | 1 | 0 |
179103 | 179103 | 2020-05-26 | Hardin | Illinois | 17069 | 1 | 0 |
182147 | 182147 | 2020-05-27 | Hardin | Illinois | 17069 | 1 | 0 |
185201 | 185201 | 2020-05-28 | Hardin | Illinois | 17069 | 1 | 0 |
188259 | 188259 | 2020-05-29 | Hardin | Illinois | 17069 | 1 | 0 |
191324 | 191324 | 2020-05-30 | Hardin | Illinois | 17069 | 1 | 0 |
194391 | 194391 | 2020-05-31 | Hardin | Illinois | 17069 | 1 | 0 |
197461 | 197461 | 2020-06-01 | Hardin | Illinois | 17069 | 1 | 0 |
200534 | 200534 | 2020-06-02 | Hardin | Illinois | 17069 | 1 | 0 |
203610 | 203610 | 2020-06-03 | Hardin | Illinois | 17069 | 1 | 0 |
206690 | 206690 | 2020-06-04 | Hardin | Illinois | 17069 | 1 | 0 |
209771 | 209771 | 2020-06-05 | Hardin | Illinois | 17069 | 1 | 0 |
212856 | 212856 | 2020-06-06 | Hardin | Illinois | 17069 | 1 | 0 |
215943 | 215943 | 2020-06-07 | Hardin | Illinois | 17069 | 1 | 0 |
219034 | 219034 | 2020-06-08 | Hardin | Illinois | 17069 | 1 | 0 |
222129 | 222129 | 2020-06-09 | Hardin | Illinois | 17069 | 1 | 0 |
225224 | 225224 | 2020-06-10 | Hardin | Illinois | 17069 | 1 | 0 |
228326 | 228326 | 2020-06-11 | Hardin | Illinois | 17069 | 1 | 0 |
231429 | 231429 | 2020-06-12 | Hardin | Illinois | 17069 | 1 | 0 |
234535 | 234535 | 2020-06-13 | Hardin | Illinois | 17069 | 1 | 0 |
237642 | 237642 | 2020-06-14 | Hardin | Illinois | 17069 | 1 | 0 |
240750 | 240750 | 2020-06-15 | Hardin | Illinois | 17069 | 1 | 0 |
243861 | 243861 | 2020-06-16 | Hardin | Illinois | 17069 | 1 | 0 |
246974 | 246974 | 2020-06-17 | Hardin | Illinois | 17069 | 1 | 0 |
250086 | 250086 | 2020-06-18 | Hardin | Illinois | 17069 | 1 | 0 |
253201 | 253201 | 2020-06-19 | Hardin | Illinois | 17069 | 1 | 0 |
256321 | 256321 | 2020-06-20 | Hardin | Illinois | 17069 | 1 | 0 |
259447 | 259447 | 2020-06-21 | Hardin | Illinois | 17069 | 1 | 0 |
262574 | 262574 | 2020-06-22 | Hardin | Illinois | 17069 | 1 | 0 |
265702 | 265702 | 2020-06-23 | Hardin | Illinois | 17069 | 1 | 0 |
268832 | 268832 | 2020-06-24 | Hardin | Illinois | 17069 | 1 | 0 |
271969 | 271969 | 2020-06-25 | Hardin | Illinois | 17069 | 1 | 0 |
275111 | 275111 | 2020-06-26 | Hardin | Illinois | 17069 | 1 | 0 |
278259 | 278259 | 2020-06-27 | Hardin | Illinois | 17069 | 1 | 0 |
281407 | 281407 | 2020-06-28 | Hardin | Illinois | 17069 | 1 | 0 |
284552 | 284552 | 2020-06-29 | Hardin | Illinois | 17069 | 1 | 0 |
287701 | 287701 | 2020-06-30 | Hardin | Illinois | 17069 | 1 | 0 |
290851 | 290851 | 2020-07-01 | Hardin | Illinois | 17069 | 1 | 0 |
294005 | 294005 | 2020-07-02 | Hardin | Illinois | 17069 | 1 | 0 |
297162 | 297162 | 2020-07-03 | Hardin | Illinois | 17069 | 1 | 0 |
300324 | 300324 | 2020-07-04 | Hardin | Illinois | 17069 | 1 | 0 |
303488 | 303488 | 2020-07-05 | Hardin | Illinois | 17069 | 1 | 0 |
306653 | 306653 | 2020-07-06 | Hardin | Illinois | 17069 | 1 | 0 |
309821 | 309821 | 2020-07-07 | Hardin | Illinois | 17069 | 1 | 0 |
312991 | 312991 | 2020-07-08 | Hardin | Illinois | 17069 | 1 | 0 |
316165 | 316165 | 2020-07-09 | Hardin | Illinois | 17069 | 1 | 0 |
319338 | 319338 | 2020-07-10 | Hardin | Illinois | 17069 | 2 | 0 |
322517 | 322517 | 2020-07-11 | Hardin | Illinois | 17069 | 2 | 0 |
325698 | 325698 | 2020-07-12 | Hardin | Illinois | 17069 | 1 | 0 |
328884 | 328884 | 2020-07-13 | Hardin | Illinois | 17069 | 1 | 0 |
332071 | 332071 | 2020-07-14 | Hardin | Illinois | 17069 | 1 | 0 |
335264 | 335264 | 2020-07-15 | Hardin | Illinois | 17069 | 2 | 0 |
338460 | 338460 | 2020-07-16 | Hardin | Illinois | 17069 | 3 | 0 |
341656 | 341656 | 2020-07-17 | Hardin | Illinois | 17069 | 5 | 0 |
344856 | 344856 | 2020-07-18 | Hardin | Illinois | 17069 | 5 | 0 |
348057 | 348057 | 2020-07-19 | Hardin | Illinois | 17069 | 5 | 0 |
351257 | 351257 | 2020-07-20 | Hardin | Illinois | 17069 | 6 | 0 |
354459 | 354459 | 2020-07-21 | Hardin | Illinois | 17069 | 7 | 0 |
357661 | 357661 | 2020-07-22 | Hardin | Illinois | 17069 | 9 | 0 |
360866 | 360866 | 2020-07-23 | Hardin | Illinois | 17069 | 9 | 0 |
364073 | 364073 | 2020-07-24 | Hardin | Illinois | 17069 | 9 | 0 |
367280 | 367280 | 2020-07-25 | Hardin | Illinois | 17069 | 9 | 0 |
370490 | 370490 | 2020-07-26 | Hardin | Illinois | 17069 | 14 | 0 |
373702 | 373702 | 2020-07-27 | Hardin | Illinois | 17069 | 16 | 0 |
376917 | 376917 | 2020-07-28 | Hardin | Illinois | 17069 | 16 | 0 |
380134 | 380134 | 2020-07-29 | Hardin | Illinois | 17069 | 16 | 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);