ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and fips = 21051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635910 | 635910 | 2020-10-16 | Clay | Kentucky | 21051 | 418 | 6 |
632664 | 632664 | 2020-10-15 | Clay | Kentucky | 21051 | 408 | 6 |
629420 | 629420 | 2020-10-14 | Clay | Kentucky | 21051 | 389 | 6 |
626176 | 626176 | 2020-10-13 | Clay | Kentucky | 21051 | 382 | 6 |
622934 | 622934 | 2020-10-12 | Clay | Kentucky | 21051 | 371 | 6 |
619690 | 619690 | 2020-10-11 | Clay | Kentucky | 21051 | 366 | 6 |
616448 | 616448 | 2020-10-10 | Clay | Kentucky | 21051 | 362 | 6 |
613207 | 613207 | 2020-10-09 | Clay | Kentucky | 21051 | 361 | 6 |
609965 | 609965 | 2020-10-08 | Clay | Kentucky | 21051 | 355 | 6 |
606723 | 606723 | 2020-10-07 | Clay | Kentucky | 21051 | 352 | 6 |
603481 | 603481 | 2020-10-06 | Clay | Kentucky | 21051 | 352 | 6 |
600238 | 600238 | 2020-10-05 | Clay | Kentucky | 21051 | 347 | 6 |
596996 | 596996 | 2020-10-04 | Clay | Kentucky | 21051 | 343 | 6 |
593754 | 593754 | 2020-10-03 | Clay | Kentucky | 21051 | 343 | 6 |
590513 | 590513 | 2020-10-02 | Clay | Kentucky | 21051 | 340 | 6 |
587272 | 587272 | 2020-10-01 | Clay | Kentucky | 21051 | 335 | 6 |
584032 | 584032 | 2020-09-30 | Clay | Kentucky | 21051 | 330 | 6 |
580792 | 580792 | 2020-09-29 | Clay | Kentucky | 21051 | 328 | 6 |
577551 | 577551 | 2020-09-28 | Clay | Kentucky | 21051 | 326 | 6 |
574309 | 574309 | 2020-09-27 | Clay | Kentucky | 21051 | 324 | 6 |
571066 | 571066 | 2020-09-26 | Clay | Kentucky | 21051 | 324 | 6 |
567824 | 567824 | 2020-09-25 | Clay | Kentucky | 21051 | 317 | 6 |
564584 | 564584 | 2020-09-24 | Clay | Kentucky | 21051 | 306 | 6 |
561344 | 561344 | 2020-09-23 | Clay | Kentucky | 21051 | 305 | 6 |
558108 | 558108 | 2020-09-22 | Clay | Kentucky | 21051 | 303 | 6 |
554871 | 554871 | 2020-09-21 | Clay | Kentucky | 21051 | 291 | 6 |
551632 | 551632 | 2020-09-20 | Clay | Kentucky | 21051 | 290 | 6 |
548393 | 548393 | 2020-09-19 | Clay | Kentucky | 21051 | 289 | 6 |
545155 | 545155 | 2020-09-18 | Clay | Kentucky | 21051 | 271 | 6 |
541919 | 541919 | 2020-09-17 | Clay | Kentucky | 21051 | 269 | 6 |
538683 | 538683 | 2020-09-16 | Clay | Kentucky | 21051 | 268 | 6 |
535446 | 535446 | 2020-09-15 | Clay | Kentucky | 21051 | 263 | 6 |
532211 | 532211 | 2020-09-14 | Clay | Kentucky | 21051 | 261 | 6 |
528974 | 528974 | 2020-09-13 | Clay | Kentucky | 21051 | 257 | 6 |
525738 | 525738 | 2020-09-12 | Clay | Kentucky | 21051 | 237 | 6 |
522502 | 522502 | 2020-09-11 | Clay | Kentucky | 21051 | 237 | 6 |
519265 | 519265 | 2020-09-10 | Clay | Kentucky | 21051 | 237 | 6 |
516030 | 516030 | 2020-09-09 | Clay | Kentucky | 21051 | 233 | 6 |
512797 | 512797 | 2020-09-08 | Clay | Kentucky | 21051 | 226 | 6 |
509565 | 509565 | 2020-09-07 | Clay | Kentucky | 21051 | 226 | 6 |
506332 | 506332 | 2020-09-06 | Clay | Kentucky | 21051 | 226 | 6 |
503098 | 503098 | 2020-09-05 | Clay | Kentucky | 21051 | 227 | 6 |
499865 | 499865 | 2020-09-04 | Clay | Kentucky | 21051 | 225 | 6 |
496631 | 496631 | 2020-09-03 | Clay | Kentucky | 21051 | 225 | 6 |
493398 | 493398 | 2020-09-02 | Clay | Kentucky | 21051 | 221 | 6 |
490164 | 490164 | 2020-09-01 | Clay | Kentucky | 21051 | 221 | 6 |
486931 | 486931 | 2020-08-31 | Clay | Kentucky | 21051 | 214 | 6 |
483696 | 483696 | 2020-08-30 | Clay | Kentucky | 21051 | 214 | 6 |
480462 | 480462 | 2020-08-29 | Clay | Kentucky | 21051 | 205 | 6 |
477229 | 477229 | 2020-08-28 | Clay | Kentucky | 21051 | 205 | 6 |
473996 | 473996 | 2020-08-27 | Clay | Kentucky | 21051 | 201 | 6 |
470764 | 470764 | 2020-08-26 | Clay | Kentucky | 21051 | 199 | 6 |
467535 | 467535 | 2020-08-25 | Clay | Kentucky | 21051 | 197 | 6 |
464306 | 464306 | 2020-08-24 | Clay | Kentucky | 21051 | 197 | 6 |
461075 | 461075 | 2020-08-23 | Clay | Kentucky | 21051 | 196 | 6 |
457848 | 457848 | 2020-08-22 | Clay | Kentucky | 21051 | 196 | 6 |
454620 | 454620 | 2020-08-21 | Clay | Kentucky | 21051 | 195 | 6 |
451392 | 451392 | 2020-08-20 | Clay | Kentucky | 21051 | 192 | 6 |
448164 | 448164 | 2020-08-19 | Clay | Kentucky | 21051 | 191 | 5 |
444937 | 444937 | 2020-08-18 | Clay | Kentucky | 21051 | 191 | 5 |
441711 | 441711 | 2020-08-17 | Clay | Kentucky | 21051 | 190 | 5 |
438484 | 438484 | 2020-08-16 | Clay | Kentucky | 21051 | 185 | 5 |
435259 | 435259 | 2020-08-15 | Clay | Kentucky | 21051 | 185 | 5 |
432034 | 432034 | 2020-08-14 | Clay | Kentucky | 21051 | 184 | 5 |
428806 | 428806 | 2020-08-13 | Clay | Kentucky | 21051 | 181 | 5 |
425582 | 425582 | 2020-08-12 | Clay | Kentucky | 21051 | 159 | 5 |
422361 | 422361 | 2020-08-11 | Clay | Kentucky | 21051 | 157 | 5 |
419139 | 419139 | 2020-08-10 | Clay | Kentucky | 21051 | 152 | 5 |
415918 | 415918 | 2020-08-09 | Clay | Kentucky | 21051 | 152 | 5 |
412698 | 412698 | 2020-08-08 | Clay | Kentucky | 21051 | 150 | 5 |
409478 | 409478 | 2020-08-07 | Clay | Kentucky | 21051 | 149 | 5 |
406258 | 406258 | 2020-08-06 | Clay | Kentucky | 21051 | 148 | 5 |
403040 | 403040 | 2020-08-05 | Clay | Kentucky | 21051 | 145 | 5 |
399823 | 399823 | 2020-08-04 | Clay | Kentucky | 21051 | 144 | 5 |
396608 | 396608 | 2020-08-03 | Clay | Kentucky | 21051 | 143 | 5 |
393392 | 393392 | 2020-08-02 | Clay | Kentucky | 21051 | 143 | 5 |
390175 | 390175 | 2020-08-01 | Clay | Kentucky | 21051 | 142 | 5 |
386958 | 386958 | 2020-07-31 | Clay | Kentucky | 21051 | 142 | 5 |
383740 | 383740 | 2020-07-30 | Clay | Kentucky | 21051 | 141 | 5 |
380523 | 380523 | 2020-07-29 | Clay | Kentucky | 21051 | 139 | 5 |
377306 | 377306 | 2020-07-28 | Clay | Kentucky | 21051 | 136 | 4 |
374091 | 374091 | 2020-07-27 | Clay | Kentucky | 21051 | 134 | 4 |
370879 | 370879 | 2020-07-26 | Clay | Kentucky | 21051 | 134 | 4 |
367669 | 367669 | 2020-07-25 | Clay | Kentucky | 21051 | 132 | 4 |
364462 | 364462 | 2020-07-24 | Clay | Kentucky | 21051 | 131 | 4 |
361255 | 361255 | 2020-07-23 | Clay | Kentucky | 21051 | 126 | 4 |
358050 | 358050 | 2020-07-22 | Clay | Kentucky | 21051 | 121 | 4 |
354847 | 354847 | 2020-07-21 | Clay | Kentucky | 21051 | 119 | 4 |
351645 | 351645 | 2020-07-20 | Clay | Kentucky | 21051 | 115 | 4 |
348445 | 348445 | 2020-07-19 | Clay | Kentucky | 21051 | 114 | 4 |
345244 | 345244 | 2020-07-18 | Clay | Kentucky | 21051 | 111 | 4 |
342044 | 342044 | 2020-07-17 | Clay | Kentucky | 21051 | 105 | 4 |
338848 | 338848 | 2020-07-16 | Clay | Kentucky | 21051 | 98 | 4 |
335652 | 335652 | 2020-07-15 | Clay | Kentucky | 21051 | 97 | 4 |
332459 | 332459 | 2020-07-14 | Clay | Kentucky | 21051 | 88 | 4 |
329272 | 329272 | 2020-07-13 | Clay | Kentucky | 21051 | 85 | 4 |
326086 | 326086 | 2020-07-12 | Clay | Kentucky | 21051 | 82 | 4 |
322903 | 322903 | 2020-07-11 | Clay | Kentucky | 21051 | 82 | 4 |
319724 | 319724 | 2020-07-10 | Clay | Kentucky | 21051 | 81 | 4 |
316549 | 316549 | 2020-07-09 | Clay | Kentucky | 21051 | 80 | 3 |
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);