ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
744 rows where county = "Hitchcock" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636597 | 636597 | 2020-10-16 | Hitchcock | Nebraska | 31087 | 28 | 0 |
633351 | 633351 | 2020-10-15 | Hitchcock | Nebraska | 31087 | 25 | 0 |
630106 | 630106 | 2020-10-14 | Hitchcock | Nebraska | 31087 | 25 | 0 |
626862 | 626862 | 2020-10-13 | Hitchcock | Nebraska | 31087 | 23 | 0 |
623620 | 623620 | 2020-10-12 | Hitchcock | Nebraska | 31087 | 20 | 0 |
620377 | 620377 | 2020-10-11 | Hitchcock | Nebraska | 31087 | 17 | 0 |
617135 | 617135 | 2020-10-10 | Hitchcock | Nebraska | 31087 | 17 | 0 |
613894 | 613894 | 2020-10-09 | Hitchcock | Nebraska | 31087 | 14 | 0 |
610652 | 610652 | 2020-10-08 | Hitchcock | Nebraska | 31087 | 14 | 0 |
607410 | 607410 | 2020-10-07 | Hitchcock | Nebraska | 31087 | 10 | 0 |
604167 | 604167 | 2020-10-06 | Hitchcock | Nebraska | 31087 | 11 | 0 |
600925 | 600925 | 2020-10-05 | Hitchcock | Nebraska | 31087 | 12 | 0 |
597681 | 597681 | 2020-10-04 | Hitchcock | Nebraska | 31087 | 10 | 0 |
594439 | 594439 | 2020-10-03 | Hitchcock | Nebraska | 31087 | 9 | 0 |
591198 | 591198 | 2020-10-02 | Hitchcock | Nebraska | 31087 | 8 | 0 |
587957 | 587957 | 2020-10-01 | Hitchcock | Nebraska | 31087 | 8 | 0 |
584717 | 584717 | 2020-09-30 | Hitchcock | Nebraska | 31087 | 6 | 0 |
581476 | 581476 | 2020-09-29 | Hitchcock | Nebraska | 31087 | 5 | 0 |
578235 | 578235 | 2020-09-28 | Hitchcock | Nebraska | 31087 | 4 | 0 |
574994 | 574994 | 2020-09-27 | Hitchcock | Nebraska | 31087 | 4 | 0 |
571751 | 571751 | 2020-09-26 | Hitchcock | Nebraska | 31087 | 4 | 0 |
568509 | 568509 | 2020-09-25 | Hitchcock | Nebraska | 31087 | 4 | 0 |
565268 | 565268 | 2020-09-24 | Hitchcock | Nebraska | 31087 | 4 | 0 |
562027 | 562027 | 2020-09-23 | Hitchcock | Nebraska | 31087 | 4 | 0 |
558790 | 558790 | 2020-09-22 | Hitchcock | Nebraska | 31087 | 4 | 0 |
555553 | 555553 | 2020-09-21 | Hitchcock | Nebraska | 31087 | 4 | 0 |
552315 | 552315 | 2020-09-20 | Hitchcock | Nebraska | 31087 | 4 | 0 |
549076 | 549076 | 2020-09-19 | Hitchcock | Nebraska | 31087 | 4 | 0 |
545838 | 545838 | 2020-09-18 | Hitchcock | Nebraska | 31087 | 4 | 0 |
542601 | 542601 | 2020-09-17 | Hitchcock | Nebraska | 31087 | 4 | 0 |
539365 | 539365 | 2020-09-16 | Hitchcock | Nebraska | 31087 | 3 | 0 |
536127 | 536127 | 2020-09-15 | Hitchcock | Nebraska | 31087 | 3 | 0 |
532892 | 532892 | 2020-09-14 | Hitchcock | Nebraska | 31087 | 3 | 0 |
529656 | 529656 | 2020-09-13 | Hitchcock | Nebraska | 31087 | 2 | 0 |
526420 | 526420 | 2020-09-12 | Hitchcock | Nebraska | 31087 | 2 | 0 |
523184 | 523184 | 2020-09-11 | Hitchcock | Nebraska | 31087 | 2 | 0 |
519947 | 519947 | 2020-09-10 | Hitchcock | Nebraska | 31087 | 2 | 0 |
516712 | 516712 | 2020-09-09 | Hitchcock | Nebraska | 31087 | 2 | 0 |
513478 | 513478 | 2020-09-08 | Hitchcock | Nebraska | 31087 | 2 | 0 |
510246 | 510246 | 2020-09-07 | Hitchcock | Nebraska | 31087 | 2 | 0 |
507013 | 507013 | 2020-09-06 | Hitchcock | Nebraska | 31087 | 2 | 0 |
503780 | 503780 | 2020-09-05 | Hitchcock | Nebraska | 31087 | 2 | 0 |
500546 | 500546 | 2020-09-04 | Hitchcock | Nebraska | 31087 | 2 | 0 |
497312 | 497312 | 2020-09-03 | Hitchcock | Nebraska | 31087 | 2 | 0 |
494079 | 494079 | 2020-09-02 | Hitchcock | Nebraska | 31087 | 2 | 0 |
490845 | 490845 | 2020-09-01 | Hitchcock | Nebraska | 31087 | 2 | 0 |
487612 | 487612 | 2020-08-31 | Hitchcock | Nebraska | 31087 | 2 | 0 |
484378 | 484378 | 2020-08-30 | Hitchcock | Nebraska | 31087 | 2 | 0 |
481143 | 481143 | 2020-08-29 | Hitchcock | Nebraska | 31087 | 2 | 0 |
477911 | 477911 | 2020-08-28 | Hitchcock | Nebraska | 31087 | 2 | 0 |
474678 | 474678 | 2020-08-27 | Hitchcock | Nebraska | 31087 | 2 | 0 |
471446 | 471446 | 2020-08-26 | Hitchcock | Nebraska | 31087 | 2 | 0 |
468216 | 468216 | 2020-08-25 | Hitchcock | Nebraska | 31087 | 2 | 0 |
464987 | 464987 | 2020-08-24 | Hitchcock | Nebraska | 31087 | 2 | 0 |
461756 | 461756 | 2020-08-23 | Hitchcock | Nebraska | 31087 | 2 | 0 |
458529 | 458529 | 2020-08-22 | Hitchcock | Nebraska | 31087 | 2 | 0 |
455301 | 455301 | 2020-08-21 | Hitchcock | Nebraska | 31087 | 1 | 0 |
452073 | 452073 | 2020-08-20 | Hitchcock | Nebraska | 31087 | 1 | 0 |
448845 | 448845 | 2020-08-19 | Hitchcock | Nebraska | 31087 | 1 | 0 |
445619 | 445619 | 2020-08-18 | Hitchcock | Nebraska | 31087 | 1 | 0 |
442393 | 442393 | 2020-08-17 | Hitchcock | Nebraska | 31087 | 1 | 0 |
439166 | 439166 | 2020-08-16 | Hitchcock | Nebraska | 31087 | 1 | 0 |
435941 | 435941 | 2020-08-15 | Hitchcock | Nebraska | 31087 | 1 | 0 |
432715 | 432715 | 2020-08-14 | Hitchcock | Nebraska | 31087 | 1 | 0 |
429488 | 429488 | 2020-08-13 | Hitchcock | Nebraska | 31087 | 1 | 0 |
426263 | 426263 | 2020-08-12 | Hitchcock | Nebraska | 31087 | 1 | 0 |
423041 | 423041 | 2020-08-11 | Hitchcock | Nebraska | 31087 | 1 | 0 |
419818 | 419818 | 2020-08-10 | Hitchcock | Nebraska | 31087 | 1 | 0 |
416597 | 416597 | 2020-08-09 | Hitchcock | Nebraska | 31087 | 1 | 0 |
413377 | 413377 | 2020-08-08 | Hitchcock | Nebraska | 31087 | 1 | 0 |
410157 | 410157 | 2020-08-07 | Hitchcock | Nebraska | 31087 | 2 | 0 |
406937 | 406937 | 2020-08-06 | Hitchcock | Nebraska | 31087 | 1 | 0 |
403718 | 403718 | 2020-08-05 | Hitchcock | Nebraska | 31087 | 1 | 0 |
400500 | 400500 | 2020-08-04 | Hitchcock | Nebraska | 31087 | 1 | 0 |
397285 | 397285 | 2020-08-03 | Hitchcock | Nebraska | 31087 | 1 | 0 |
394069 | 394069 | 2020-08-02 | Hitchcock | Nebraska | 31087 | 1 | 0 |
390852 | 390852 | 2020-08-01 | Hitchcock | Nebraska | 31087 | 1 | 0 |
387635 | 387635 | 2020-07-31 | Hitchcock | Nebraska | 31087 | 1 | 0 |
384417 | 384417 | 2020-07-30 | Hitchcock | Nebraska | 31087 | 1 | 0 |
381201 | 381201 | 2020-07-29 | Hitchcock | Nebraska | 31087 | 1 | 0 |
377983 | 377983 | 2020-07-28 | Hitchcock | Nebraska | 31087 | 1 | 0 |
374767 | 374767 | 2020-07-27 | Hitchcock | Nebraska | 31087 | 1 | 0 |
371555 | 371555 | 2020-07-26 | Hitchcock | Nebraska | 31087 | 1 | 0 |
368344 | 368344 | 2020-07-25 | Hitchcock | Nebraska | 31087 | 1 | 0 |
365135 | 365135 | 2020-07-24 | Hitchcock | Nebraska | 31087 | 1 | 0 |
361929 | 361929 | 2020-07-23 | Hitchcock | Nebraska | 31087 | 1 | 0 |
358723 | 358723 | 2020-07-22 | Hitchcock | Nebraska | 31087 | 1 | 0 |
355519 | 355519 | 2020-07-21 | Hitchcock | Nebraska | 31087 | 1 | 0 |
352316 | 352316 | 2020-07-20 | Hitchcock | Nebraska | 31087 | 1 | 0 |
349115 | 349115 | 2020-07-19 | Hitchcock | Nebraska | 31087 | 1 | 0 |
345914 | 345914 | 2020-07-18 | Hitchcock | Nebraska | 31087 | 1 | 0 |
342714 | 342714 | 2020-07-17 | Hitchcock | Nebraska | 31087 | 1 | 0 |
339517 | 339517 | 2020-07-16 | Hitchcock | Nebraska | 31087 | 1 | 0 |
336320 | 336320 | 2020-07-15 | Hitchcock | Nebraska | 31087 | 1 | 0 |
333126 | 333126 | 2020-07-14 | Hitchcock | Nebraska | 31087 | 1 | 0 |
329936 | 329936 | 2020-07-13 | Hitchcock | Nebraska | 31087 | 1 | 0 |
326749 | 326749 | 2020-07-12 | Hitchcock | Nebraska | 31087 | 1 | 0 |
323565 | 323565 | 2020-07-11 | Hitchcock | Nebraska | 31087 | 1 | 0 |
320386 | 320386 | 2020-07-10 | Hitchcock | Nebraska | 31087 | 1 | 0 |
317211 | 317211 | 2020-07-09 | Hitchcock | Nebraska | 31087 | 1 | 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);