ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where county = "Hamilton", deaths = 13 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
694991 | 694991 | 2020-11-03 | Hamilton | Nebraska | 31081 | 267 | 13 |
691749 | 691749 | 2020-11-02 | Hamilton | Nebraska | 31081 | 267 | 13 |
688504 | 688504 | 2020-11-01 | Hamilton | Nebraska | 31081 | 257 | 13 |
685260 | 685260 | 2020-10-31 | Hamilton | Nebraska | 31081 | 257 | 13 |
682017 | 682017 | 2020-10-30 | Hamilton | Nebraska | 31081 | 257 | 13 |
678773 | 678773 | 2020-10-29 | Hamilton | Nebraska | 31081 | 249 | 13 |
675531 | 675531 | 2020-10-28 | Hamilton | Nebraska | 31081 | 249 | 13 |
672288 | 672288 | 2020-10-27 | Hamilton | Nebraska | 31081 | 246 | 13 |
669046 | 669046 | 2020-10-26 | Hamilton | Nebraska | 31081 | 246 | 13 |
665802 | 665802 | 2020-10-25 | Hamilton | Nebraska | 31081 | 240 | 13 |
662557 | 662557 | 2020-10-24 | Hamilton | Nebraska | 31081 | 240 | 13 |
659313 | 659313 | 2020-10-23 | Hamilton | Nebraska | 31081 | 240 | 13 |
656068 | 656068 | 2020-10-22 | Hamilton | Nebraska | 31081 | 229 | 13 |
652823 | 652823 | 2020-10-21 | Hamilton | Nebraska | 31081 | 229 | 13 |
649578 | 649578 | 2020-10-20 | Hamilton | Nebraska | 31081 | 225 | 13 |
646334 | 646334 | 2020-10-19 | Hamilton | Nebraska | 31081 | 225 | 13 |
643088 | 643088 | 2020-10-18 | Hamilton | Nebraska | 31081 | 212 | 13 |
639840 | 639840 | 2020-10-17 | Hamilton | Nebraska | 31081 | 211 | 13 |
636594 | 636594 | 2020-10-16 | Hamilton | Nebraska | 31081 | 208 | 13 |
633348 | 633348 | 2020-10-15 | Hamilton | Nebraska | 31081 | 204 | 13 |
630103 | 630103 | 2020-10-14 | Hamilton | Nebraska | 31081 | 204 | 13 |
626859 | 626859 | 2020-10-13 | Hamilton | Nebraska | 31081 | 197 | 13 |
623617 | 623617 | 2020-10-12 | Hamilton | Nebraska | 31081 | 194 | 13 |
620374 | 620374 | 2020-10-11 | Hamilton | Nebraska | 31081 | 185 | 13 |
617132 | 617132 | 2020-10-10 | Hamilton | Nebraska | 31081 | 183 | 13 |
613891 | 613891 | 2020-10-09 | Hamilton | Nebraska | 31081 | 177 | 13 |
610649 | 610649 | 2020-10-08 | Hamilton | Nebraska | 31081 | 167 | 13 |
607407 | 607407 | 2020-10-07 | Hamilton | Nebraska | 31081 | 166 | 13 |
604164 | 604164 | 2020-10-06 | Hamilton | Nebraska | 31081 | 158 | 13 |
600922 | 600922 | 2020-10-05 | Hamilton | Nebraska | 31081 | 157 | 13 |
597678 | 597678 | 2020-10-04 | Hamilton | Nebraska | 31081 | 154 | 13 |
594437 | 594437 | 2020-10-03 | Hamilton | Nebraska | 31081 | 150 | 13 |
591196 | 591196 | 2020-10-02 | Hamilton | Nebraska | 31081 | 150 | 13 |
587955 | 587955 | 2020-10-01 | Hamilton | Nebraska | 31081 | 142 | 13 |
584715 | 584715 | 2020-09-30 | Hamilton | Nebraska | 31081 | 142 | 13 |
581474 | 581474 | 2020-09-29 | Hamilton | Nebraska | 31081 | 134 | 13 |
578233 | 578233 | 2020-09-28 | Hamilton | Nebraska | 31081 | 134 | 13 |
574992 | 574992 | 2020-09-27 | Hamilton | Nebraska | 31081 | 132 | 13 |
571749 | 571749 | 2020-09-26 | Hamilton | Nebraska | 31081 | 132 | 13 |
568507 | 568507 | 2020-09-25 | Hamilton | Nebraska | 31081 | 132 | 13 |
565266 | 565266 | 2020-09-24 | Hamilton | Nebraska | 31081 | 130 | 13 |
562025 | 562025 | 2020-09-23 | Hamilton | Nebraska | 31081 | 130 | 13 |
558788 | 558788 | 2020-09-22 | Hamilton | Nebraska | 31081 | 124 | 13 |
555551 | 555551 | 2020-09-21 | Hamilton | Nebraska | 31081 | 124 | 13 |
552313 | 552313 | 2020-09-20 | Hamilton | Nebraska | 31081 | 121 | 13 |
549074 | 549074 | 2020-09-19 | Hamilton | Nebraska | 31081 | 119 | 13 |
545836 | 545836 | 2020-09-18 | Hamilton | Nebraska | 31081 | 119 | 13 |
542599 | 542599 | 2020-09-17 | Hamilton | Nebraska | 31081 | 114 | 13 |
539363 | 539363 | 2020-09-16 | Hamilton | Nebraska | 31081 | 114 | 13 |
536125 | 536125 | 2020-09-15 | Hamilton | Nebraska | 31081 | 113 | 13 |
532890 | 532890 | 2020-09-14 | Hamilton | Nebraska | 31081 | 113 | 13 |
529654 | 529654 | 2020-09-13 | Hamilton | Nebraska | 31081 | 113 | 13 |
526418 | 526418 | 2020-09-12 | Hamilton | Nebraska | 31081 | 113 | 13 |
523182 | 523182 | 2020-09-11 | Hamilton | Nebraska | 31081 | 113 | 13 |
519945 | 519945 | 2020-09-10 | Hamilton | Nebraska | 31081 | 112 | 13 |
516710 | 516710 | 2020-09-09 | Hamilton | Nebraska | 31081 | 112 | 13 |
513476 | 513476 | 2020-09-08 | Hamilton | Nebraska | 31081 | 111 | 13 |
510244 | 510244 | 2020-09-07 | Hamilton | Nebraska | 31081 | 111 | 13 |
507011 | 507011 | 2020-09-06 | Hamilton | Nebraska | 31081 | 111 | 13 |
503778 | 503778 | 2020-09-05 | Hamilton | Nebraska | 31081 | 111 | 13 |
500544 | 500544 | 2020-09-04 | Hamilton | Nebraska | 31081 | 111 | 13 |
497310 | 497310 | 2020-09-03 | Hamilton | Nebraska | 31081 | 109 | 13 |
494077 | 494077 | 2020-09-02 | Hamilton | Nebraska | 31081 | 109 | 13 |
490843 | 490843 | 2020-09-01 | Hamilton | Nebraska | 31081 | 109 | 13 |
487610 | 487610 | 2020-08-31 | Hamilton | Nebraska | 31081 | 109 | 13 |
484376 | 484376 | 2020-08-30 | Hamilton | Nebraska | 31081 | 106 | 13 |
481141 | 481141 | 2020-08-29 | Hamilton | Nebraska | 31081 | 106 | 13 |
477909 | 477909 | 2020-08-28 | Hamilton | Nebraska | 31081 | 106 | 13 |
474676 | 474676 | 2020-08-27 | Hamilton | Nebraska | 31081 | 106 | 13 |
471444 | 471444 | 2020-08-26 | Hamilton | Nebraska | 31081 | 106 | 13 |
468214 | 468214 | 2020-08-25 | Hamilton | Nebraska | 31081 | 106 | 13 |
464985 | 464985 | 2020-08-24 | Hamilton | Nebraska | 31081 | 106 | 13 |
461754 | 461754 | 2020-08-23 | Hamilton | Nebraska | 31081 | 106 | 13 |
458527 | 458527 | 2020-08-22 | Hamilton | Nebraska | 31081 | 106 | 13 |
455299 | 455299 | 2020-08-21 | Hamilton | Nebraska | 31081 | 106 | 13 |
452071 | 452071 | 2020-08-20 | Hamilton | Nebraska | 31081 | 105 | 13 |
448843 | 448843 | 2020-08-19 | Hamilton | Nebraska | 31081 | 105 | 13 |
445617 | 445617 | 2020-08-18 | Hamilton | Nebraska | 31081 | 106 | 13 |
442391 | 442391 | 2020-08-17 | Hamilton | Nebraska | 31081 | 105 | 13 |
439164 | 439164 | 2020-08-16 | Hamilton | Nebraska | 31081 | 103 | 13 |
435939 | 435939 | 2020-08-15 | Hamilton | Nebraska | 31081 | 103 | 13 |
432713 | 432713 | 2020-08-14 | Hamilton | Nebraska | 31081 | 103 | 13 |
429486 | 429486 | 2020-08-13 | Hamilton | Nebraska | 31081 | 101 | 13 |
426261 | 426261 | 2020-08-12 | Hamilton | Nebraska | 31081 | 101 | 13 |
423039 | 423039 | 2020-08-11 | Hamilton | Nebraska | 31081 | 101 | 13 |
419816 | 419816 | 2020-08-10 | Hamilton | Nebraska | 31081 | 101 | 13 |
416595 | 416595 | 2020-08-09 | Hamilton | Nebraska | 31081 | 100 | 13 |
413375 | 413375 | 2020-08-08 | Hamilton | Nebraska | 31081 | 100 | 13 |
410155 | 410155 | 2020-08-07 | Hamilton | Nebraska | 31081 | 100 | 13 |
406935 | 406935 | 2020-08-06 | Hamilton | Nebraska | 31081 | 99 | 13 |
403716 | 403716 | 2020-08-05 | Hamilton | Nebraska | 31081 | 99 | 13 |
400498 | 400498 | 2020-08-04 | Hamilton | Nebraska | 31081 | 98 | 13 |
397283 | 397283 | 2020-08-03 | Hamilton | Nebraska | 31081 | 98 | 13 |
394067 | 394067 | 2020-08-02 | Hamilton | Nebraska | 31081 | 96 | 13 |
390850 | 390850 | 2020-08-01 | Hamilton | Nebraska | 31081 | 96 | 13 |
387633 | 387633 | 2020-07-31 | Hamilton | Nebraska | 31081 | 96 | 13 |
384415 | 384415 | 2020-07-30 | Hamilton | Nebraska | 31081 | 92 | 13 |
381199 | 381199 | 2020-07-29 | Hamilton | Nebraska | 31081 | 92 | 13 |
377981 | 377981 | 2020-07-28 | Hamilton | Nebraska | 31081 | 89 | 13 |
374765 | 374765 | 2020-07-27 | Hamilton | Nebraska | 31081 | 88 | 13 |
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);