ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
726 rows where county = "Bell" and state = "Kentucky" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
155181 | 155181 | 2020-05-18 | Bell | Kentucky | 21013 | 1 | 0 |
158198 | 158198 | 2020-05-19 | Bell | Kentucky | 21013 | 1 | 0 |
161223 | 161223 | 2020-05-20 | Bell | Kentucky | 21013 | 1 | 0 |
164252 | 164252 | 2020-05-21 | Bell | Kentucky | 21013 | 1 | 0 |
167288 | 167288 | 2020-05-22 | Bell | Kentucky | 21013 | 1 | 0 |
170326 | 170326 | 2020-05-23 | Bell | Kentucky | 21013 | 1 | 0 |
173367 | 173367 | 2020-05-24 | Bell | Kentucky | 21013 | 1 | 0 |
176411 | 176411 | 2020-05-25 | Bell | Kentucky | 21013 | 1 | 0 |
179455 | 179455 | 2020-05-26 | Bell | Kentucky | 21013 | 1 | 0 |
182500 | 182500 | 2020-05-27 | Bell | Kentucky | 21013 | 1 | 0 |
185554 | 185554 | 2020-05-28 | Bell | Kentucky | 21013 | 1 | 0 |
188612 | 188612 | 2020-05-29 | Bell | Kentucky | 21013 | 1 | 0 |
191676 | 191676 | 2020-05-30 | Bell | Kentucky | 21013 | 1 | 0 |
194744 | 194744 | 2020-05-31 | Bell | Kentucky | 21013 | 1 | 0 |
197815 | 197815 | 2020-06-01 | Bell | Kentucky | 21013 | 1 | 0 |
200886 | 200886 | 2020-06-02 | Bell | Kentucky | 21013 | 1 | 0 |
203963 | 203963 | 2020-06-03 | Bell | Kentucky | 21013 | 1 | 0 |
207044 | 207044 | 2020-06-04 | Bell | Kentucky | 21013 | 2 | 0 |
210125 | 210125 | 2020-06-05 | Bell | Kentucky | 21013 | 2 | 0 |
213210 | 213210 | 2020-06-06 | Bell | Kentucky | 21013 | 2 | 0 |
216297 | 216297 | 2020-06-07 | Bell | Kentucky | 21013 | 2 | 0 |
219389 | 219389 | 2020-06-08 | Bell | Kentucky | 21013 | 2 | 0 |
222484 | 222484 | 2020-06-09 | Bell | Kentucky | 21013 | 3 | 0 |
225580 | 225580 | 2020-06-10 | Bell | Kentucky | 21013 | 3 | 0 |
228682 | 228682 | 2020-06-11 | Bell | Kentucky | 21013 | 3 | 0 |
231786 | 231786 | 2020-06-12 | Bell | Kentucky | 21013 | 3 | 0 |
234891 | 234891 | 2020-06-13 | Bell | Kentucky | 21013 | 4 | 0 |
237998 | 237998 | 2020-06-14 | Bell | Kentucky | 21013 | 4 | 0 |
241107 | 241107 | 2020-06-15 | Bell | Kentucky | 21013 | 4 | 0 |
244218 | 244218 | 2020-06-16 | Bell | Kentucky | 21013 | 4 | 0 |
247331 | 247331 | 2020-06-17 | Bell | Kentucky | 21013 | 4 | 0 |
250443 | 250443 | 2020-06-18 | Bell | Kentucky | 21013 | 4 | 0 |
253558 | 253558 | 2020-06-19 | Bell | Kentucky | 21013 | 4 | 0 |
256678 | 256678 | 2020-06-20 | Bell | Kentucky | 21013 | 4 | 0 |
259804 | 259804 | 2020-06-21 | Bell | Kentucky | 21013 | 5 | 0 |
262933 | 262933 | 2020-06-22 | Bell | Kentucky | 21013 | 5 | 0 |
266060 | 266060 | 2020-06-23 | Bell | Kentucky | 21013 | 6 | 0 |
269193 | 269193 | 2020-06-24 | Bell | Kentucky | 21013 | 6 | 0 |
272329 | 272329 | 2020-06-25 | Bell | Kentucky | 21013 | 6 | 0 |
275472 | 275472 | 2020-06-26 | Bell | Kentucky | 21013 | 7 | 0 |
278620 | 278620 | 2020-06-27 | Bell | Kentucky | 21013 | 8 | 0 |
281768 | 281768 | 2020-06-28 | Bell | Kentucky | 21013 | 8 | 0 |
284914 | 284914 | 2020-06-29 | Bell | Kentucky | 21013 | 8 | 0 |
288063 | 288063 | 2020-06-30 | Bell | Kentucky | 21013 | 8 | 0 |
291213 | 291213 | 2020-07-01 | Bell | Kentucky | 21013 | 8 | 0 |
294367 | 294367 | 2020-07-02 | Bell | Kentucky | 21013 | 9 | 0 |
297525 | 297525 | 2020-07-03 | Bell | Kentucky | 21013 | 13 | 0 |
300687 | 300687 | 2020-07-04 | Bell | Kentucky | 21013 | 13 | 0 |
303851 | 303851 | 2020-07-05 | Bell | Kentucky | 21013 | 13 | 0 |
307018 | 307018 | 2020-07-06 | Bell | Kentucky | 21013 | 21 | 0 |
310186 | 310186 | 2020-07-07 | Bell | Kentucky | 21013 | 43 | 0 |
313356 | 313356 | 2020-07-08 | Bell | Kentucky | 21013 | 57 | 0 |
316530 | 316530 | 2020-07-09 | Bell | Kentucky | 21013 | 69 | 0 |
319705 | 319705 | 2020-07-10 | Bell | Kentucky | 21013 | 74 | 0 |
322884 | 322884 | 2020-07-11 | Bell | Kentucky | 21013 | 92 | 0 |
326067 | 326067 | 2020-07-12 | Bell | Kentucky | 21013 | 103 | 0 |
329253 | 329253 | 2020-07-13 | Bell | Kentucky | 21013 | 105 | 0 |
332440 | 332440 | 2020-07-14 | Bell | Kentucky | 21013 | 114 | 0 |
335633 | 335633 | 2020-07-15 | Bell | Kentucky | 21013 | 121 | 0 |
338829 | 338829 | 2020-07-16 | Bell | Kentucky | 21013 | 132 | 0 |
342025 | 342025 | 2020-07-17 | Bell | Kentucky | 21013 | 141 | 1 |
345225 | 345225 | 2020-07-18 | Bell | Kentucky | 21013 | 154 | 1 |
348426 | 348426 | 2020-07-19 | Bell | Kentucky | 21013 | 159 | 1 |
351626 | 351626 | 2020-07-20 | Bell | Kentucky | 21013 | 160 | 1 |
354828 | 354828 | 2020-07-21 | Bell | Kentucky | 21013 | 166 | 1 |
358031 | 358031 | 2020-07-22 | Bell | Kentucky | 21013 | 174 | 1 |
361236 | 361236 | 2020-07-23 | Bell | Kentucky | 21013 | 191 | 1 |
364443 | 364443 | 2020-07-24 | Bell | Kentucky | 21013 | 213 | 1 |
367650 | 367650 | 2020-07-25 | Bell | Kentucky | 21013 | 221 | 1 |
370860 | 370860 | 2020-07-26 | Bell | Kentucky | 21013 | 230 | 1 |
374072 | 374072 | 2020-07-27 | Bell | Kentucky | 21013 | 234 | 2 |
377287 | 377287 | 2020-07-28 | Bell | Kentucky | 21013 | 239 | 2 |
380504 | 380504 | 2020-07-29 | Bell | Kentucky | 21013 | 260 | 2 |
383721 | 383721 | 2020-07-30 | Bell | Kentucky | 21013 | 262 | 2 |
386939 | 386939 | 2020-07-31 | Bell | Kentucky | 21013 | 267 | 2 |
390156 | 390156 | 2020-08-01 | Bell | Kentucky | 21013 | 270 | 2 |
393373 | 393373 | 2020-08-02 | Bell | Kentucky | 21013 | 274 | 2 |
396589 | 396589 | 2020-08-03 | Bell | Kentucky | 21013 | 281 | 2 |
399804 | 399804 | 2020-08-04 | Bell | Kentucky | 21013 | 285 | 2 |
403021 | 403021 | 2020-08-05 | Bell | Kentucky | 21013 | 287 | 2 |
406239 | 406239 | 2020-08-06 | Bell | Kentucky | 21013 | 298 | 3 |
409459 | 409459 | 2020-08-07 | Bell | Kentucky | 21013 | 303 | 3 |
412679 | 412679 | 2020-08-08 | Bell | Kentucky | 21013 | 312 | 4 |
415899 | 415899 | 2020-08-09 | Bell | Kentucky | 21013 | 312 | 4 |
419120 | 419120 | 2020-08-10 | Bell | Kentucky | 21013 | 312 | 4 |
422342 | 422342 | 2020-08-11 | Bell | Kentucky | 21013 | 318 | 4 |
425563 | 425563 | 2020-08-12 | Bell | Kentucky | 21013 | 324 | 4 |
428787 | 428787 | 2020-08-13 | Bell | Kentucky | 21013 | 327 | 4 |
432015 | 432015 | 2020-08-14 | Bell | Kentucky | 21013 | 336 | 5 |
435240 | 435240 | 2020-08-15 | Bell | Kentucky | 21013 | 338 | 5 |
438465 | 438465 | 2020-08-16 | Bell | Kentucky | 21013 | 338 | 5 |
441692 | 441692 | 2020-08-17 | Bell | Kentucky | 21013 | 350 | 5 |
444918 | 444918 | 2020-08-18 | Bell | Kentucky | 21013 | 351 | 5 |
448145 | 448145 | 2020-08-19 | Bell | Kentucky | 21013 | 354 | 5 |
451373 | 451373 | 2020-08-20 | Bell | Kentucky | 21013 | 357 | 5 |
454601 | 454601 | 2020-08-21 | Bell | Kentucky | 21013 | 364 | 5 |
457829 | 457829 | 2020-08-22 | Bell | Kentucky | 21013 | 367 | 6 |
461056 | 461056 | 2020-08-23 | Bell | Kentucky | 21013 | 367 | 6 |
464287 | 464287 | 2020-08-24 | Bell | Kentucky | 21013 | 368 | 6 |
467516 | 467516 | 2020-08-25 | Bell | Kentucky | 21013 | 371 | 7 |
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);