ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,786 rows where county = "Henry" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
28429 | 28429 | 2020-04-03 | Henry | Alabama | 1067 | 2 | 0 |
30786 | 30786 | 2020-04-04 | Henry | Alabama | 1067 | 2 | 0 |
33190 | 33190 | 2020-04-05 | Henry | Alabama | 1067 | 3 | 0 |
35629 | 35629 | 2020-04-06 | Henry | Alabama | 1067 | 4 | 0 |
38117 | 38117 | 2020-04-07 | Henry | Alabama | 1067 | 4 | 0 |
40659 | 40659 | 2020-04-08 | Henry | Alabama | 1067 | 5 | 0 |
43232 | 43232 | 2020-04-09 | Henry | Alabama | 1067 | 8 | 0 |
45830 | 45830 | 2020-04-10 | Henry | Alabama | 1067 | 10 | 0 |
48459 | 48459 | 2020-04-11 | Henry | Alabama | 1067 | 10 | 0 |
51121 | 51121 | 2020-04-12 | Henry | Alabama | 1067 | 11 | 0 |
53799 | 53799 | 2020-04-13 | Henry | Alabama | 1067 | 13 | 0 |
56491 | 56491 | 2020-04-14 | Henry | Alabama | 1067 | 14 | 0 |
59199 | 59199 | 2020-04-15 | Henry | Alabama | 1067 | 15 | 0 |
61917 | 61917 | 2020-04-16 | Henry | Alabama | 1067 | 15 | 0 |
64650 | 64650 | 2020-04-17 | Henry | Alabama | 1067 | 16 | 0 |
67398 | 67398 | 2020-04-18 | Henry | Alabama | 1067 | 17 | 0 |
70160 | 70160 | 2020-04-19 | Henry | Alabama | 1067 | 17 | 0 |
72929 | 72929 | 2020-04-20 | Henry | Alabama | 1067 | 18 | 0 |
75705 | 75705 | 2020-04-21 | Henry | Alabama | 1067 | 20 | 0 |
78488 | 78488 | 2020-04-22 | Henry | Alabama | 1067 | 20 | 0 |
81281 | 81281 | 2020-04-23 | Henry | Alabama | 1067 | 22 | 0 |
84082 | 84082 | 2020-04-24 | Henry | Alabama | 1067 | 22 | 1 |
86890 | 86890 | 2020-04-25 | Henry | Alabama | 1067 | 22 | 1 |
89706 | 89706 | 2020-04-26 | Henry | Alabama | 1067 | 22 | 1 |
92524 | 92524 | 2020-04-27 | Henry | Alabama | 1067 | 22 | 1 |
95354 | 95354 | 2020-04-28 | Henry | Alabama | 1067 | 22 | 1 |
98199 | 98199 | 2020-04-29 | Henry | Alabama | 1067 | 23 | 1 |
101049 | 101049 | 2020-04-30 | Henry | Alabama | 1067 | 24 | 1 |
103904 | 103904 | 2020-05-01 | Henry | Alabama | 1067 | 24 | 1 |
106769 | 106769 | 2020-05-02 | Henry | Alabama | 1067 | 26 | 1 |
109638 | 109638 | 2020-05-03 | Henry | Alabama | 1067 | 27 | 1 |
112513 | 112513 | 2020-05-04 | Henry | Alabama | 1067 | 27 | 1 |
115396 | 115396 | 2020-05-05 | Henry | Alabama | 1067 | 27 | 1 |
118355 | 118355 | 2020-05-06 | Henry | Alabama | 1067 | 27 | 1 |
121321 | 121321 | 2020-05-07 | Henry | Alabama | 1067 | 27 | 1 |
124301 | 124301 | 2020-05-08 | Henry | Alabama | 1067 | 27 | 1 |
127286 | 127286 | 2020-05-09 | Henry | Alabama | 1067 | 28 | 1 |
130276 | 130276 | 2020-05-10 | Henry | Alabama | 1067 | 28 | 1 |
133266 | 133266 | 2020-05-11 | Henry | Alabama | 1067 | 30 | 1 |
136256 | 136256 | 2020-05-12 | Henry | Alabama | 1067 | 32 | 1 |
139247 | 139247 | 2020-05-13 | Henry | Alabama | 1067 | 33 | 1 |
142243 | 142243 | 2020-05-14 | Henry | Alabama | 1067 | 35 | 1 |
145242 | 145242 | 2020-05-15 | Henry | Alabama | 1067 | 37 | 1 |
148245 | 148245 | 2020-05-16 | Henry | Alabama | 1067 | 39 | 1 |
151254 | 151254 | 2020-05-17 | Henry | Alabama | 1067 | 39 | 1 |
154266 | 154266 | 2020-05-18 | Henry | Alabama | 1067 | 40 | 1 |
157282 | 157282 | 2020-05-19 | Henry | Alabama | 1067 | 44 | 1 |
160306 | 160306 | 2020-05-20 | Henry | Alabama | 1067 | 48 | 1 |
163334 | 163334 | 2020-05-21 | Henry | Alabama | 1067 | 48 | 1 |
166366 | 166366 | 2020-05-22 | Henry | Alabama | 1067 | 50 | 1 |
169402 | 169402 | 2020-05-23 | Henry | Alabama | 1067 | 52 | 1 |
172443 | 172443 | 2020-05-24 | Henry | Alabama | 1067 | 56 | 2 |
175486 | 175486 | 2020-05-25 | Henry | Alabama | 1067 | 64 | 2 |
178531 | 178531 | 2020-05-26 | Henry | Alabama | 1067 | 69 | 2 |
181575 | 181575 | 2020-05-27 | Henry | Alabama | 1067 | 70 | 2 |
184627 | 184627 | 2020-05-28 | Henry | Alabama | 1067 | 71 | 2 |
187684 | 187684 | 2020-05-29 | Henry | Alabama | 1067 | 73 | 2 |
190748 | 190748 | 2020-05-30 | Henry | Alabama | 1067 | 74 | 2 |
193814 | 193814 | 2020-05-31 | Henry | Alabama | 1067 | 80 | 2 |
196884 | 196884 | 2020-06-01 | Henry | Alabama | 1067 | 80 | 2 |
199957 | 199957 | 2020-06-02 | Henry | Alabama | 1067 | 81 | 2 |
203033 | 203033 | 2020-06-03 | Henry | Alabama | 1067 | 81 | 2 |
206112 | 206112 | 2020-06-04 | Henry | Alabama | 1067 | 82 | 2 |
209194 | 209194 | 2020-06-05 | Henry | Alabama | 1067 | 84 | 2 |
212279 | 212279 | 2020-06-06 | Henry | Alabama | 1067 | 85 | 2 |
215366 | 215366 | 2020-06-07 | Henry | Alabama | 1067 | 88 | 2 |
218456 | 218456 | 2020-06-08 | Henry | Alabama | 1067 | 89 | 2 |
221548 | 221548 | 2020-06-09 | Henry | Alabama | 1067 | 89 | 2 |
224644 | 224644 | 2020-06-10 | Henry | Alabama | 1067 | 93 | 2 |
227745 | 227745 | 2020-06-11 | Henry | Alabama | 1067 | 94 | 2 |
230849 | 230849 | 2020-06-12 | Henry | Alabama | 1067 | 97 | 2 |
233954 | 233954 | 2020-06-13 | Henry | Alabama | 1067 | 99 | 2 |
237061 | 237061 | 2020-06-14 | Henry | Alabama | 1067 | 107 | 2 |
240169 | 240169 | 2020-06-15 | Henry | Alabama | 1067 | 108 | 2 |
243280 | 243280 | 2020-06-16 | Henry | Alabama | 1067 | 109 | 2 |
246393 | 246393 | 2020-06-17 | Henry | Alabama | 1067 | 109 | 2 |
249505 | 249505 | 2020-06-18 | Henry | Alabama | 1067 | 110 | 2 |
252620 | 252620 | 2020-06-19 | Henry | Alabama | 1067 | 111 | 2 |
255739 | 255739 | 2020-06-20 | Henry | Alabama | 1067 | 115 | 3 |
258866 | 258866 | 2020-06-21 | Henry | Alabama | 1067 | 115 | 3 |
261993 | 261993 | 2020-06-22 | Henry | Alabama | 1067 | 119 | 3 |
265122 | 265122 | 2020-06-23 | Henry | Alabama | 1067 | 121 | 3 |
268251 | 268251 | 2020-06-24 | Henry | Alabama | 1067 | 123 | 4 |
271385 | 271385 | 2020-06-25 | Henry | Alabama | 1067 | 128 | 4 |
274525 | 274525 | 2020-06-26 | Henry | Alabama | 1067 | 130 | 4 |
277673 | 277673 | 2020-06-27 | Henry | Alabama | 1067 | 132 | 4 |
280821 | 280821 | 2020-06-28 | Henry | Alabama | 1067 | 132 | 4 |
283967 | 283967 | 2020-06-29 | Henry | Alabama | 1067 | 129 | 4 |
287113 | 287113 | 2020-06-30 | Henry | Alabama | 1067 | 130 | 4 |
290263 | 290263 | 2020-07-01 | Henry | Alabama | 1067 | 131 | 4 |
293416 | 293416 | 2020-07-02 | Henry | Alabama | 1067 | 131 | 4 |
296571 | 296571 | 2020-07-03 | Henry | Alabama | 1067 | 132 | 4 |
299733 | 299733 | 2020-07-04 | Henry | Alabama | 1067 | 133 | 4 |
302897 | 302897 | 2020-07-05 | Henry | Alabama | 1067 | 135 | 4 |
306061 | 306061 | 2020-07-06 | Henry | Alabama | 1067 | 137 | 4 |
309230 | 309230 | 2020-07-07 | Henry | Alabama | 1067 | 137 | 4 |
312399 | 312399 | 2020-07-08 | Henry | Alabama | 1067 | 141 | 4 |
315574 | 315574 | 2020-07-09 | Henry | Alabama | 1067 | 144 | 4 |
318747 | 318747 | 2020-07-10 | Henry | Alabama | 1067 | 147 | 4 |
321926 | 321926 | 2020-07-11 | Henry | Alabama | 1067 | 154 | 4 |
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);