ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,526 rows where county = "Hickman" 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 |
---|---|---|---|---|---|---|---|
76616 | 76616 | 2020-04-21 | Hickman | Kentucky | 21105 | 1 | 0 |
79401 | 79401 | 2020-04-22 | Hickman | Kentucky | 21105 | 1 | 0 |
82198 | 82198 | 2020-04-23 | Hickman | Kentucky | 21105 | 2 | 0 |
85001 | 85001 | 2020-04-24 | Hickman | Kentucky | 21105 | 2 | 0 |
87810 | 87810 | 2020-04-25 | Hickman | Kentucky | 21105 | 2 | 0 |
90626 | 90626 | 2020-04-26 | Hickman | Kentucky | 21105 | 2 | 0 |
93447 | 93447 | 2020-04-27 | Hickman | Kentucky | 21105 | 2 | 0 |
96280 | 96280 | 2020-04-28 | Hickman | Kentucky | 21105 | 1 | 0 |
99126 | 99126 | 2020-04-29 | Hickman | Kentucky | 21105 | 1 | 0 |
101978 | 101978 | 2020-04-30 | Hickman | Kentucky | 21105 | 1 | 0 |
104839 | 104839 | 2020-05-01 | Hickman | Kentucky | 21105 | 1 | 0 |
107704 | 107704 | 2020-05-02 | Hickman | Kentucky | 21105 | 1 | 0 |
110575 | 110575 | 2020-05-03 | Hickman | Kentucky | 21105 | 1 | 0 |
113452 | 113452 | 2020-05-04 | Hickman | Kentucky | 21105 | 4 | 0 |
116334 | 116334 | 2020-05-05 | Hickman | Kentucky | 21105 | 5 | 0 |
119295 | 119295 | 2020-05-06 | Hickman | Kentucky | 21105 | 5 | 0 |
122266 | 122266 | 2020-05-07 | Hickman | Kentucky | 21105 | 5 | 0 |
125248 | 125248 | 2020-05-08 | Hickman | Kentucky | 21105 | 5 | 0 |
128236 | 128236 | 2020-05-09 | Hickman | Kentucky | 21105 | 5 | 0 |
131226 | 131226 | 2020-05-10 | Hickman | Kentucky | 21105 | 5 | 0 |
134217 | 134217 | 2020-05-11 | Hickman | Kentucky | 21105 | 5 | 0 |
137207 | 137207 | 2020-05-12 | Hickman | Kentucky | 21105 | 5 | 0 |
140200 | 140200 | 2020-05-13 | Hickman | Kentucky | 21105 | 5 | 0 |
143196 | 143196 | 2020-05-14 | Hickman | Kentucky | 21105 | 5 | 0 |
146196 | 146196 | 2020-05-15 | Hickman | Kentucky | 21105 | 5 | 0 |
149200 | 149200 | 2020-05-16 | Hickman | Kentucky | 21105 | 5 | 0 |
152211 | 152211 | 2020-05-17 | Hickman | Kentucky | 21105 | 5 | 0 |
155225 | 155225 | 2020-05-18 | Hickman | Kentucky | 21105 | 5 | 0 |
158242 | 158242 | 2020-05-19 | Hickman | Kentucky | 21105 | 5 | 0 |
161268 | 161268 | 2020-05-20 | Hickman | Kentucky | 21105 | 5 | 0 |
164297 | 164297 | 2020-05-21 | Hickman | Kentucky | 21105 | 5 | 0 |
167333 | 167333 | 2020-05-22 | Hickman | Kentucky | 21105 | 5 | 0 |
170371 | 170371 | 2020-05-23 | Hickman | Kentucky | 21105 | 5 | 0 |
173412 | 173412 | 2020-05-24 | Hickman | Kentucky | 21105 | 5 | 0 |
176456 | 176456 | 2020-05-25 | Hickman | Kentucky | 21105 | 5 | 0 |
179500 | 179500 | 2020-05-26 | Hickman | Kentucky | 21105 | 5 | 0 |
182545 | 182545 | 2020-05-27 | Hickman | Kentucky | 21105 | 5 | 0 |
185599 | 185599 | 2020-05-28 | Hickman | Kentucky | 21105 | 5 | 0 |
188657 | 188657 | 2020-05-29 | Hickman | Kentucky | 21105 | 5 | 0 |
191721 | 191721 | 2020-05-30 | Hickman | Kentucky | 21105 | 5 | 0 |
194789 | 194789 | 2020-05-31 | Hickman | Kentucky | 21105 | 5 | 0 |
197860 | 197860 | 2020-06-01 | Hickman | Kentucky | 21105 | 5 | 0 |
200932 | 200932 | 2020-06-02 | Hickman | Kentucky | 21105 | 5 | 0 |
204009 | 204009 | 2020-06-03 | Hickman | Kentucky | 21105 | 5 | 0 |
207090 | 207090 | 2020-06-04 | Hickman | Kentucky | 21105 | 5 | 0 |
210171 | 210171 | 2020-06-05 | Hickman | Kentucky | 21105 | 5 | 0 |
213256 | 213256 | 2020-06-06 | Hickman | Kentucky | 21105 | 5 | 0 |
216343 | 216343 | 2020-06-07 | Hickman | Kentucky | 21105 | 5 | 0 |
219435 | 219435 | 2020-06-08 | Hickman | Kentucky | 21105 | 5 | 0 |
222530 | 222530 | 2020-06-09 | Hickman | Kentucky | 21105 | 5 | 0 |
225626 | 225626 | 2020-06-10 | Hickman | Kentucky | 21105 | 5 | 0 |
228728 | 228728 | 2020-06-11 | Hickman | Kentucky | 21105 | 5 | 0 |
231832 | 231832 | 2020-06-12 | Hickman | Kentucky | 21105 | 5 | 0 |
234937 | 234937 | 2020-06-13 | Hickman | Kentucky | 21105 | 5 | 0 |
238044 | 238044 | 2020-06-14 | Hickman | Kentucky | 21105 | 5 | 0 |
241153 | 241153 | 2020-06-15 | Hickman | Kentucky | 21105 | 5 | 0 |
244264 | 244264 | 2020-06-16 | Hickman | Kentucky | 21105 | 5 | 0 |
247377 | 247377 | 2020-06-17 | Hickman | Kentucky | 21105 | 5 | 0 |
250489 | 250489 | 2020-06-18 | Hickman | Kentucky | 21105 | 5 | 0 |
253604 | 253604 | 2020-06-19 | Hickman | Kentucky | 21105 | 5 | 0 |
256724 | 256724 | 2020-06-20 | Hickman | Kentucky | 21105 | 5 | 0 |
259850 | 259850 | 2020-06-21 | Hickman | Kentucky | 21105 | 5 | 0 |
262979 | 262979 | 2020-06-22 | Hickman | Kentucky | 21105 | 5 | 0 |
266106 | 266106 | 2020-06-23 | Hickman | Kentucky | 21105 | 5 | 0 |
269239 | 269239 | 2020-06-24 | Hickman | Kentucky | 21105 | 5 | 0 |
272375 | 272375 | 2020-06-25 | Hickman | Kentucky | 21105 | 5 | 0 |
275518 | 275518 | 2020-06-26 | Hickman | Kentucky | 21105 | 5 | 0 |
278666 | 278666 | 2020-06-27 | Hickman | Kentucky | 21105 | 5 | 0 |
281814 | 281814 | 2020-06-28 | Hickman | Kentucky | 21105 | 5 | 0 |
284960 | 284960 | 2020-06-29 | Hickman | Kentucky | 21105 | 5 | 0 |
288109 | 288109 | 2020-06-30 | Hickman | Kentucky | 21105 | 5 | 0 |
291259 | 291259 | 2020-07-01 | Hickman | Kentucky | 21105 | 5 | 0 |
294413 | 294413 | 2020-07-02 | Hickman | Kentucky | 21105 | 5 | 0 |
297571 | 297571 | 2020-07-03 | Hickman | Kentucky | 21105 | 5 | 0 |
300733 | 300733 | 2020-07-04 | Hickman | Kentucky | 21105 | 5 | 0 |
303897 | 303897 | 2020-07-05 | Hickman | Kentucky | 21105 | 5 | 0 |
307064 | 307064 | 2020-07-06 | Hickman | Kentucky | 21105 | 7 | 0 |
310232 | 310232 | 2020-07-07 | Hickman | Kentucky | 21105 | 7 | 0 |
313402 | 313402 | 2020-07-08 | Hickman | Kentucky | 21105 | 7 | 0 |
316576 | 316576 | 2020-07-09 | Hickman | Kentucky | 21105 | 7 | 0 |
319751 | 319751 | 2020-07-10 | Hickman | Kentucky | 21105 | 7 | 0 |
322930 | 322930 | 2020-07-11 | Hickman | Kentucky | 21105 | 7 | 0 |
326113 | 326113 | 2020-07-12 | Hickman | Kentucky | 21105 | 7 | 0 |
329299 | 329299 | 2020-07-13 | Hickman | Kentucky | 21105 | 7 | 0 |
332486 | 332486 | 2020-07-14 | Hickman | Kentucky | 21105 | 7 | 0 |
335679 | 335679 | 2020-07-15 | Hickman | Kentucky | 21105 | 8 | 0 |
338875 | 338875 | 2020-07-16 | Hickman | Kentucky | 21105 | 10 | 0 |
342071 | 342071 | 2020-07-17 | Hickman | Kentucky | 21105 | 12 | 0 |
345271 | 345271 | 2020-07-18 | Hickman | Kentucky | 21105 | 12 | 0 |
348472 | 348472 | 2020-07-19 | Hickman | Kentucky | 21105 | 14 | 0 |
351672 | 351672 | 2020-07-20 | Hickman | Kentucky | 21105 | 14 | 0 |
354874 | 354874 | 2020-07-21 | Hickman | Kentucky | 21105 | 16 | 0 |
358077 | 358077 | 2020-07-22 | Hickman | Kentucky | 21105 | 16 | 0 |
361282 | 361282 | 2020-07-23 | Hickman | Kentucky | 21105 | 16 | 0 |
364489 | 364489 | 2020-07-24 | Hickman | Kentucky | 21105 | 16 | 0 |
367696 | 367696 | 2020-07-25 | Hickman | Kentucky | 21105 | 16 | 0 |
370906 | 370906 | 2020-07-26 | Hickman | Kentucky | 21105 | 16 | 0 |
374118 | 374118 | 2020-07-27 | Hickman | Kentucky | 21105 | 16 | 0 |
377333 | 377333 | 2020-07-28 | Hickman | Kentucky | 21105 | 19 | 0 |
380550 | 380550 | 2020-07-29 | Hickman | Kentucky | 21105 | 20 | 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);