ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Henry" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
14435 | 14435 | 2020-03-27 | Henry | Illinois | 17073 | 1 | 0 |
16230 | 16230 | 2020-03-28 | Henry | Illinois | 17073 | 2 | 0 |
18129 | 18129 | 2020-03-29 | Henry | Illinois | 17073 | 2 | 0 |
20131 | 20131 | 2020-03-30 | Henry | Illinois | 17073 | 2 | 0 |
22223 | 22223 | 2020-03-31 | Henry | Illinois | 17073 | 2 | 0 |
24391 | 24391 | 2020-04-01 | Henry | Illinois | 17073 | 3 | 0 |
26624 | 26624 | 2020-04-02 | Henry | Illinois | 17073 | 4 | 0 |
28933 | 28933 | 2020-04-03 | Henry | Illinois | 17073 | 7 | 0 |
31295 | 31295 | 2020-04-04 | Henry | Illinois | 17073 | 7 | 0 |
33705 | 33705 | 2020-04-05 | Henry | Illinois | 17073 | 8 | 0 |
36156 | 36156 | 2020-04-06 | Henry | Illinois | 17073 | 10 | 0 |
38651 | 38651 | 2020-04-07 | Henry | Illinois | 17073 | 13 | 0 |
41196 | 41196 | 2020-04-08 | Henry | Illinois | 17073 | 16 | 0 |
43770 | 43770 | 2020-04-09 | Henry | Illinois | 17073 | 18 | 0 |
46374 | 46374 | 2020-04-10 | Henry | Illinois | 17073 | 21 | 0 |
49005 | 49005 | 2020-04-11 | Henry | Illinois | 17073 | 22 | 0 |
51667 | 51667 | 2020-04-12 | Henry | Illinois | 17073 | 22 | 0 |
54347 | 54347 | 2020-04-13 | Henry | Illinois | 17073 | 23 | 0 |
57040 | 57040 | 2020-04-14 | Henry | Illinois | 17073 | 23 | 0 |
59747 | 59747 | 2020-04-15 | Henry | Illinois | 17073 | 25 | 0 |
62468 | 62468 | 2020-04-16 | Henry | Illinois | 17073 | 25 | 0 |
65201 | 65201 | 2020-04-17 | Henry | Illinois | 17073 | 28 | 0 |
67950 | 67950 | 2020-04-18 | Henry | Illinois | 17073 | 30 | 0 |
70712 | 70712 | 2020-04-19 | Henry | Illinois | 17073 | 30 | 0 |
73482 | 73482 | 2020-04-20 | Henry | Illinois | 17073 | 30 | 0 |
76259 | 76259 | 2020-04-21 | Henry | Illinois | 17073 | 31 | 0 |
79043 | 79043 | 2020-04-22 | Henry | Illinois | 17073 | 32 | 0 |
81836 | 81836 | 2020-04-23 | Henry | Illinois | 17073 | 33 | 0 |
84636 | 84636 | 2020-04-24 | Henry | Illinois | 17073 | 36 | 0 |
87446 | 87446 | 2020-04-25 | Henry | Illinois | 17073 | 36 | 0 |
90262 | 90262 | 2020-04-26 | Henry | Illinois | 17073 | 36 | 0 |
93081 | 93081 | 2020-04-27 | Henry | Illinois | 17073 | 36 | 0 |
95913 | 95913 | 2020-04-28 | Henry | Illinois | 17073 | 38 | 0 |
98757 | 98757 | 2020-04-29 | Henry | Illinois | 17073 | 39 | 0 |
101608 | 101608 | 2020-04-30 | Henry | Illinois | 17073 | 45 | 0 |
104464 | 104464 | 2020-05-01 | Henry | Illinois | 17073 | 49 | 0 |
107329 | 107329 | 2020-05-02 | Henry | Illinois | 17073 | 50 | 0 |
110199 | 110199 | 2020-05-03 | Henry | Illinois | 17073 | 50 | 0 |
113074 | 113074 | 2020-05-04 | Henry | Illinois | 17073 | 53 | 0 |
115957 | 115957 | 2020-05-05 | Henry | Illinois | 17073 | 53 | 0 |
118917 | 118917 | 2020-05-06 | Henry | Illinois | 17073 | 54 | 0 |
121887 | 121887 | 2020-05-07 | Henry | Illinois | 17073 | 55 | 0 |
124866 | 124866 | 2020-05-08 | Henry | Illinois | 17073 | 59 | 0 |
127853 | 127853 | 2020-05-09 | Henry | Illinois | 17073 | 58 | 0 |
130844 | 130844 | 2020-05-10 | Henry | Illinois | 17073 | 58 | 0 |
133835 | 133835 | 2020-05-11 | Henry | Illinois | 17073 | 58 | 0 |
136824 | 136824 | 2020-05-12 | Henry | Illinois | 17073 | 60 | 0 |
139816 | 139816 | 2020-05-13 | Henry | Illinois | 17073 | 61 | 0 |
142812 | 142812 | 2020-05-14 | Henry | Illinois | 17073 | 62 | 0 |
145812 | 145812 | 2020-05-15 | Henry | Illinois | 17073 | 64 | 0 |
148815 | 148815 | 2020-05-16 | Henry | Illinois | 17073 | 64 | 0 |
151824 | 151824 | 2020-05-17 | Henry | Illinois | 17073 | 64 | 0 |
154836 | 154836 | 2020-05-18 | Henry | Illinois | 17073 | 65 | 0 |
157852 | 157852 | 2020-05-19 | Henry | Illinois | 17073 | 65 | 0 |
160878 | 160878 | 2020-05-20 | Henry | Illinois | 17073 | 64 | 0 |
163906 | 163906 | 2020-05-21 | Henry | Illinois | 17073 | 65 | 0 |
166939 | 166939 | 2020-05-22 | Henry | Illinois | 17073 | 65 | 0 |
169976 | 169976 | 2020-05-23 | Henry | Illinois | 17073 | 66 | 0 |
173017 | 173017 | 2020-05-24 | Henry | Illinois | 17073 | 66 | 0 |
176061 | 176061 | 2020-05-25 | Henry | Illinois | 17073 | 67 | 0 |
179105 | 179105 | 2020-05-26 | Henry | Illinois | 17073 | 67 | 0 |
182149 | 182149 | 2020-05-27 | Henry | Illinois | 17073 | 67 | 0 |
185203 | 185203 | 2020-05-28 | Henry | Illinois | 17073 | 67 | 0 |
188261 | 188261 | 2020-05-29 | Henry | Illinois | 17073 | 68 | 0 |
191326 | 191326 | 2020-05-30 | Henry | Illinois | 17073 | 69 | 0 |
194393 | 194393 | 2020-05-31 | Henry | Illinois | 17073 | 69 | 0 |
197463 | 197463 | 2020-06-01 | Henry | Illinois | 17073 | 69 | 0 |
200536 | 200536 | 2020-06-02 | Henry | Illinois | 17073 | 69 | 0 |
203612 | 203612 | 2020-06-03 | Henry | Illinois | 17073 | 70 | 0 |
206692 | 206692 | 2020-06-04 | Henry | Illinois | 17073 | 70 | 0 |
209773 | 209773 | 2020-06-05 | Henry | Illinois | 17073 | 70 | 0 |
212858 | 212858 | 2020-06-06 | Henry | Illinois | 17073 | 70 | 0 |
215945 | 215945 | 2020-06-07 | Henry | Illinois | 17073 | 70 | 0 |
219036 | 219036 | 2020-06-08 | Henry | Illinois | 17073 | 71 | 0 |
222131 | 222131 | 2020-06-09 | Henry | Illinois | 17073 | 71 | 0 |
225226 | 225226 | 2020-06-10 | Henry | Illinois | 17073 | 71 | 0 |
228328 | 228328 | 2020-06-11 | Henry | Illinois | 17073 | 72 | 0 |
231431 | 231431 | 2020-06-12 | Henry | Illinois | 17073 | 72 | 1 |
234537 | 234537 | 2020-06-13 | Henry | Illinois | 17073 | 72 | 1 |
237644 | 237644 | 2020-06-14 | Henry | Illinois | 17073 | 72 | 1 |
240752 | 240752 | 2020-06-15 | Henry | Illinois | 17073 | 72 | 1 |
243863 | 243863 | 2020-06-16 | Henry | Illinois | 17073 | 72 | 1 |
246976 | 246976 | 2020-06-17 | Henry | Illinois | 17073 | 71 | 1 |
250088 | 250088 | 2020-06-18 | Henry | Illinois | 17073 | 72 | 1 |
253203 | 253203 | 2020-06-19 | Henry | Illinois | 17073 | 73 | 1 |
256323 | 256323 | 2020-06-20 | Henry | Illinois | 17073 | 74 | 1 |
259449 | 259449 | 2020-06-21 | Henry | Illinois | 17073 | 74 | 1 |
262576 | 262576 | 2020-06-22 | Henry | Illinois | 17073 | 75 | 1 |
265704 | 265704 | 2020-06-23 | Henry | Illinois | 17073 | 76 | 1 |
268834 | 268834 | 2020-06-24 | Henry | Illinois | 17073 | 77 | 1 |
271971 | 271971 | 2020-06-25 | Henry | Illinois | 17073 | 78 | 1 |
275113 | 275113 | 2020-06-26 | Henry | Illinois | 17073 | 78 | 1 |
278261 | 278261 | 2020-06-27 | Henry | Illinois | 17073 | 79 | 1 |
281409 | 281409 | 2020-06-28 | Henry | Illinois | 17073 | 83 | 1 |
284554 | 284554 | 2020-06-29 | Henry | Illinois | 17073 | 86 | 1 |
287703 | 287703 | 2020-06-30 | Henry | Illinois | 17073 | 84 | 1 |
290853 | 290853 | 2020-07-01 | Henry | Illinois | 17073 | 88 | 1 |
294007 | 294007 | 2020-07-02 | Henry | Illinois | 17073 | 90 | 1 |
297164 | 297164 | 2020-07-03 | Henry | Illinois | 17073 | 93 | 1 |
300326 | 300326 | 2020-07-04 | Henry | Illinois | 17073 | 95 | 1 |
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);