ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "Russell", deaths = 6 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
619768 | 619768 | 2020-10-11 | Russell | Kentucky | 21207 | 305 | 6 |
616526 | 616526 | 2020-10-10 | Russell | Kentucky | 21207 | 302 | 6 |
613285 | 613285 | 2020-10-09 | Russell | Kentucky | 21207 | 301 | 6 |
610043 | 610043 | 2020-10-08 | Russell | Kentucky | 21207 | 298 | 6 |
606801 | 606801 | 2020-10-07 | Russell | Kentucky | 21207 | 296 | 6 |
603559 | 603559 | 2020-10-06 | Russell | Kentucky | 21207 | 287 | 6 |
600316 | 600316 | 2020-10-05 | Russell | Kentucky | 21207 | 285 | 6 |
597074 | 597074 | 2020-10-04 | Russell | Kentucky | 21207 | 282 | 6 |
593832 | 593832 | 2020-10-03 | Russell | Kentucky | 21207 | 281 | 6 |
590591 | 590591 | 2020-10-02 | Russell | Kentucky | 21207 | 278 | 6 |
587350 | 587350 | 2020-10-01 | Russell | Kentucky | 21207 | 272 | 6 |
584110 | 584110 | 2020-09-30 | Russell | Kentucky | 21207 | 269 | 6 |
580870 | 580870 | 2020-09-29 | Russell | Kentucky | 21207 | 268 | 6 |
577629 | 577629 | 2020-09-28 | Russell | Kentucky | 21207 | 261 | 6 |
574387 | 574387 | 2020-09-27 | Russell | Kentucky | 21207 | 259 | 6 |
571144 | 571144 | 2020-09-26 | Russell | Kentucky | 21207 | 258 | 6 |
567902 | 567902 | 2020-09-25 | Russell | Kentucky | 21207 | 258 | 6 |
564662 | 564662 | 2020-09-24 | Russell | Kentucky | 21207 | 258 | 6 |
561422 | 561422 | 2020-09-23 | Russell | Kentucky | 21207 | 258 | 6 |
558186 | 558186 | 2020-09-22 | Russell | Kentucky | 21207 | 254 | 6 |
554949 | 554949 | 2020-09-21 | Russell | Kentucky | 21207 | 250 | 6 |
551710 | 551710 | 2020-09-20 | Russell | Kentucky | 21207 | 249 | 6 |
548471 | 548471 | 2020-09-19 | Russell | Kentucky | 21207 | 248 | 6 |
545233 | 545233 | 2020-09-18 | Russell | Kentucky | 21207 | 247 | 6 |
541997 | 541997 | 2020-09-17 | Russell | Kentucky | 21207 | 245 | 6 |
538761 | 538761 | 2020-09-16 | Russell | Kentucky | 21207 | 242 | 6 |
535524 | 535524 | 2020-09-15 | Russell | Kentucky | 21207 | 240 | 6 |
532289 | 532289 | 2020-09-14 | Russell | Kentucky | 21207 | 237 | 6 |
529052 | 529052 | 2020-09-13 | Russell | Kentucky | 21207 | 234 | 6 |
525816 | 525816 | 2020-09-12 | Russell | Kentucky | 21207 | 233 | 6 |
522580 | 522580 | 2020-09-11 | Russell | Kentucky | 21207 | 229 | 6 |
519343 | 519343 | 2020-09-10 | Russell | Kentucky | 21207 | 225 | 6 |
516108 | 516108 | 2020-09-09 | Russell | Kentucky | 21207 | 220 | 6 |
512875 | 512875 | 2020-09-08 | Russell | Kentucky | 21207 | 214 | 6 |
509643 | 509643 | 2020-09-07 | Russell | Kentucky | 21207 | 208 | 6 |
506410 | 506410 | 2020-09-06 | Russell | Kentucky | 21207 | 206 | 6 |
503176 | 503176 | 2020-09-05 | Russell | Kentucky | 21207 | 205 | 6 |
499943 | 499943 | 2020-09-04 | Russell | Kentucky | 21207 | 205 | 6 |
496709 | 496709 | 2020-09-03 | Russell | Kentucky | 21207 | 201 | 6 |
493476 | 493476 | 2020-09-02 | Russell | Kentucky | 21207 | 198 | 6 |
490242 | 490242 | 2020-09-01 | Russell | Kentucky | 21207 | 195 | 6 |
487009 | 487009 | 2020-08-31 | Russell | Kentucky | 21207 | 189 | 6 |
483774 | 483774 | 2020-08-30 | Russell | Kentucky | 21207 | 180 | 6 |
480540 | 480540 | 2020-08-29 | Russell | Kentucky | 21207 | 179 | 6 |
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);