ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union" and fips = 21225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635997 | 635997 | 2020-10-16 | Union | Kentucky | 21225 | 462 | 6 |
632751 | 632751 | 2020-10-15 | Union | Kentucky | 21225 | 448 | 6 |
629507 | 629507 | 2020-10-14 | Union | Kentucky | 21225 | 441 | 5 |
626263 | 626263 | 2020-10-13 | Union | Kentucky | 21225 | 433 | 5 |
623021 | 623021 | 2020-10-12 | Union | Kentucky | 21225 | 429 | 5 |
619777 | 619777 | 2020-10-11 | Union | Kentucky | 21225 | 424 | 5 |
616535 | 616535 | 2020-10-10 | Union | Kentucky | 21225 | 417 | 5 |
613294 | 613294 | 2020-10-09 | Union | Kentucky | 21225 | 406 | 3 |
610052 | 610052 | 2020-10-08 | Union | Kentucky | 21225 | 399 | 3 |
606810 | 606810 | 2020-10-07 | Union | Kentucky | 21225 | 392 | 3 |
603568 | 603568 | 2020-10-06 | Union | Kentucky | 21225 | 388 | 3 |
600325 | 600325 | 2020-10-05 | Union | Kentucky | 21225 | 383 | 3 |
597083 | 597083 | 2020-10-04 | Union | Kentucky | 21225 | 379 | 3 |
593841 | 593841 | 2020-10-03 | Union | Kentucky | 21225 | 376 | 3 |
590600 | 590600 | 2020-10-02 | Union | Kentucky | 21225 | 362 | 3 |
587359 | 587359 | 2020-10-01 | Union | Kentucky | 21225 | 355 | 3 |
584119 | 584119 | 2020-09-30 | Union | Kentucky | 21225 | 350 | 3 |
580879 | 580879 | 2020-09-29 | Union | Kentucky | 21225 | 347 | 3 |
577638 | 577638 | 2020-09-28 | Union | Kentucky | 21225 | 336 | 3 |
574396 | 574396 | 2020-09-27 | Union | Kentucky | 21225 | 330 | 3 |
571153 | 571153 | 2020-09-26 | Union | Kentucky | 21225 | 327 | 3 |
567911 | 567911 | 2020-09-25 | Union | Kentucky | 21225 | 318 | 3 |
564671 | 564671 | 2020-09-24 | Union | Kentucky | 21225 | 310 | 2 |
561431 | 561431 | 2020-09-23 | Union | Kentucky | 21225 | 306 | 2 |
558195 | 558195 | 2020-09-22 | Union | Kentucky | 21225 | 300 | 2 |
554958 | 554958 | 2020-09-21 | Union | Kentucky | 21225 | 290 | 2 |
551719 | 551719 | 2020-09-20 | Union | Kentucky | 21225 | 289 | 2 |
548480 | 548480 | 2020-09-19 | Union | Kentucky | 21225 | 285 | 2 |
545242 | 545242 | 2020-09-18 | Union | Kentucky | 21225 | 254 | 2 |
542006 | 542006 | 2020-09-17 | Union | Kentucky | 21225 | 235 | 2 |
538770 | 538770 | 2020-09-16 | Union | Kentucky | 21225 | 219 | 2 |
535533 | 535533 | 2020-09-15 | Union | Kentucky | 21225 | 216 | 1 |
532298 | 532298 | 2020-09-14 | Union | Kentucky | 21225 | 213 | 1 |
529061 | 529061 | 2020-09-13 | Union | Kentucky | 21225 | 210 | 1 |
525825 | 525825 | 2020-09-12 | Union | Kentucky | 21225 | 202 | 1 |
522589 | 522589 | 2020-09-11 | Union | Kentucky | 21225 | 195 | 1 |
519352 | 519352 | 2020-09-10 | Union | Kentucky | 21225 | 188 | 1 |
516117 | 516117 | 2020-09-09 | Union | Kentucky | 21225 | 182 | 1 |
512884 | 512884 | 2020-09-08 | Union | Kentucky | 21225 | 172 | 1 |
509652 | 509652 | 2020-09-07 | Union | Kentucky | 21225 | 169 | 1 |
506419 | 506419 | 2020-09-06 | Union | Kentucky | 21225 | 160 | 1 |
503185 | 503185 | 2020-09-05 | Union | Kentucky | 21225 | 157 | 1 |
499952 | 499952 | 2020-09-04 | Union | Kentucky | 21225 | 148 | 1 |
496718 | 496718 | 2020-09-03 | Union | Kentucky | 21225 | 133 | 1 |
493485 | 493485 | 2020-09-02 | Union | Kentucky | 21225 | 115 | 1 |
490251 | 490251 | 2020-09-01 | Union | Kentucky | 21225 | 113 | 1 |
487018 | 487018 | 2020-08-31 | Union | Kentucky | 21225 | 107 | 1 |
483783 | 483783 | 2020-08-30 | Union | Kentucky | 21225 | 100 | 1 |
480549 | 480549 | 2020-08-29 | Union | Kentucky | 21225 | 100 | 1 |
477316 | 477316 | 2020-08-28 | Union | Kentucky | 21225 | 97 | 1 |
474083 | 474083 | 2020-08-27 | Union | Kentucky | 21225 | 94 | 1 |
470851 | 470851 | 2020-08-26 | Union | Kentucky | 21225 | 86 | 1 |
467622 | 467622 | 2020-08-25 | Union | Kentucky | 21225 | 84 | 0 |
464393 | 464393 | 2020-08-24 | Union | Kentucky | 21225 | 81 | 0 |
461162 | 461162 | 2020-08-23 | Union | Kentucky | 21225 | 79 | 0 |
457935 | 457935 | 2020-08-22 | Union | Kentucky | 21225 | 79 | 0 |
454707 | 454707 | 2020-08-21 | Union | Kentucky | 21225 | 77 | 0 |
451479 | 451479 | 2020-08-20 | Union | Kentucky | 21225 | 77 | 0 |
448251 | 448251 | 2020-08-19 | Union | Kentucky | 21225 | 76 | 0 |
445024 | 445024 | 2020-08-18 | Union | Kentucky | 21225 | 76 | 0 |
441798 | 441798 | 2020-08-17 | Union | Kentucky | 21225 | 76 | 0 |
438571 | 438571 | 2020-08-16 | Union | Kentucky | 21225 | 73 | 0 |
435346 | 435346 | 2020-08-15 | Union | Kentucky | 21225 | 73 | 0 |
432121 | 432121 | 2020-08-14 | Union | Kentucky | 21225 | 73 | 0 |
428893 | 428893 | 2020-08-13 | Union | Kentucky | 21225 | 70 | 0 |
425669 | 425669 | 2020-08-12 | Union | Kentucky | 21225 | 70 | 0 |
422448 | 422448 | 2020-08-11 | Union | Kentucky | 21225 | 67 | 0 |
419226 | 419226 | 2020-08-10 | Union | Kentucky | 21225 | 65 | 0 |
416005 | 416005 | 2020-08-09 | Union | Kentucky | 21225 | 65 | 0 |
412785 | 412785 | 2020-08-08 | Union | Kentucky | 21225 | 65 | 0 |
409565 | 409565 | 2020-08-07 | Union | Kentucky | 21225 | 65 | 0 |
406345 | 406345 | 2020-08-06 | Union | Kentucky | 21225 | 62 | 0 |
403127 | 403127 | 2020-08-05 | Union | Kentucky | 21225 | 58 | 0 |
399910 | 399910 | 2020-08-04 | Union | Kentucky | 21225 | 57 | 0 |
396695 | 396695 | 2020-08-03 | Union | Kentucky | 21225 | 56 | 0 |
393479 | 393479 | 2020-08-02 | Union | Kentucky | 21225 | 55 | 0 |
390262 | 390262 | 2020-08-01 | Union | Kentucky | 21225 | 55 | 0 |
387045 | 387045 | 2020-07-31 | Union | Kentucky | 21225 | 53 | 0 |
383827 | 383827 | 2020-07-30 | Union | Kentucky | 21225 | 52 | 0 |
380610 | 380610 | 2020-07-29 | Union | Kentucky | 21225 | 50 | 0 |
377393 | 377393 | 2020-07-28 | Union | Kentucky | 21225 | 50 | 0 |
374178 | 374178 | 2020-07-27 | Union | Kentucky | 21225 | 49 | 0 |
370966 | 370966 | 2020-07-26 | Union | Kentucky | 21225 | 46 | 0 |
367756 | 367756 | 2020-07-25 | Union | Kentucky | 21225 | 45 | 0 |
364549 | 364549 | 2020-07-24 | Union | Kentucky | 21225 | 44 | 0 |
361342 | 361342 | 2020-07-23 | Union | Kentucky | 21225 | 42 | 0 |
358137 | 358137 | 2020-07-22 | Union | Kentucky | 21225 | 40 | 0 |
354934 | 354934 | 2020-07-21 | Union | Kentucky | 21225 | 40 | 0 |
351732 | 351732 | 2020-07-20 | Union | Kentucky | 21225 | 37 | 0 |
348532 | 348532 | 2020-07-19 | Union | Kentucky | 21225 | 37 | 0 |
345331 | 345331 | 2020-07-18 | Union | Kentucky | 21225 | 34 | 0 |
342131 | 342131 | 2020-07-17 | Union | Kentucky | 21225 | 34 | 0 |
338935 | 338935 | 2020-07-16 | Union | Kentucky | 21225 | 33 | 0 |
335739 | 335739 | 2020-07-15 | Union | Kentucky | 21225 | 33 | 0 |
332546 | 332546 | 2020-07-14 | Union | Kentucky | 21225 | 32 | 0 |
329359 | 329359 | 2020-07-13 | Union | Kentucky | 21225 | 32 | 0 |
326173 | 326173 | 2020-07-12 | Union | Kentucky | 21225 | 32 | 0 |
322990 | 322990 | 2020-07-11 | Union | Kentucky | 21225 | 31 | 0 |
319811 | 319811 | 2020-07-10 | Union | Kentucky | 21225 | 30 | 0 |
316636 | 316636 | 2020-07-09 | Union | Kentucky | 21225 | 30 | 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);