ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where county = "McPherson" and state = "Nebraska" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
320399 | 320399 | 2020-07-10 | McPherson | Nebraska | 31117 | 3 | 0 |
323578 | 323578 | 2020-07-11 | McPherson | Nebraska | 31117 | 3 | 0 |
326762 | 326762 | 2020-07-12 | McPherson | Nebraska | 31117 | 3 | 0 |
329949 | 329949 | 2020-07-13 | McPherson | Nebraska | 31117 | 3 | 0 |
333139 | 333139 | 2020-07-14 | McPherson | Nebraska | 31117 | 3 | 0 |
336333 | 336333 | 2020-07-15 | McPherson | Nebraska | 31117 | 3 | 0 |
339530 | 339530 | 2020-07-16 | McPherson | Nebraska | 31117 | 3 | 0 |
342727 | 342727 | 2020-07-17 | McPherson | Nebraska | 31117 | 3 | 0 |
345927 | 345927 | 2020-07-18 | McPherson | Nebraska | 31117 | 3 | 0 |
349128 | 349128 | 2020-07-19 | McPherson | Nebraska | 31117 | 3 | 0 |
352329 | 352329 | 2020-07-20 | McPherson | Nebraska | 31117 | 3 | 0 |
355532 | 355532 | 2020-07-21 | McPherson | Nebraska | 31117 | 4 | 0 |
358736 | 358736 | 2020-07-22 | McPherson | Nebraska | 31117 | 4 | 0 |
361942 | 361942 | 2020-07-23 | McPherson | Nebraska | 31117 | 4 | 0 |
365148 | 365148 | 2020-07-24 | McPherson | Nebraska | 31117 | 4 | 0 |
368357 | 368357 | 2020-07-25 | McPherson | Nebraska | 31117 | 4 | 0 |
371568 | 371568 | 2020-07-26 | McPherson | Nebraska | 31117 | 4 | 0 |
374780 | 374780 | 2020-07-27 | McPherson | Nebraska | 31117 | 4 | 0 |
377996 | 377996 | 2020-07-28 | McPherson | Nebraska | 31117 | 4 | 0 |
381214 | 381214 | 2020-07-29 | McPherson | Nebraska | 31117 | 4 | 0 |
384430 | 384430 | 2020-07-30 | McPherson | Nebraska | 31117 | 4 | 0 |
387648 | 387648 | 2020-07-31 | McPherson | Nebraska | 31117 | 4 | 0 |
390865 | 390865 | 2020-08-01 | McPherson | Nebraska | 31117 | 4 | 0 |
394082 | 394082 | 2020-08-02 | McPherson | Nebraska | 31117 | 4 | 0 |
397298 | 397298 | 2020-08-03 | McPherson | Nebraska | 31117 | 4 | 0 |
400513 | 400513 | 2020-08-04 | McPherson | Nebraska | 31117 | 4 | 0 |
403731 | 403731 | 2020-08-05 | McPherson | Nebraska | 31117 | 4 | 0 |
406950 | 406950 | 2020-08-06 | McPherson | Nebraska | 31117 | 5 | 0 |
410170 | 410170 | 2020-08-07 | McPherson | Nebraska | 31117 | 5 | 0 |
413390 | 413390 | 2020-08-08 | McPherson | Nebraska | 31117 | 5 | 0 |
416610 | 416610 | 2020-08-09 | McPherson | Nebraska | 31117 | 5 | 0 |
419831 | 419831 | 2020-08-10 | McPherson | Nebraska | 31117 | 5 | 0 |
423054 | 423054 | 2020-08-11 | McPherson | Nebraska | 31117 | 5 | 0 |
426276 | 426276 | 2020-08-12 | McPherson | Nebraska | 31117 | 5 | 0 |
429501 | 429501 | 2020-08-13 | McPherson | Nebraska | 31117 | 5 | 0 |
432728 | 432728 | 2020-08-14 | McPherson | Nebraska | 31117 | 6 | 0 |
435954 | 435954 | 2020-08-15 | McPherson | Nebraska | 31117 | 6 | 0 |
439179 | 439179 | 2020-08-16 | McPherson | Nebraska | 31117 | 6 | 0 |
442406 | 442406 | 2020-08-17 | McPherson | Nebraska | 31117 | 6 | 0 |
445633 | 445633 | 2020-08-18 | McPherson | Nebraska | 31117 | 6 | 0 |
448859 | 448859 | 2020-08-19 | McPherson | Nebraska | 31117 | 6 | 0 |
452087 | 452087 | 2020-08-20 | McPherson | Nebraska | 31117 | 6 | 0 |
455315 | 455315 | 2020-08-21 | McPherson | Nebraska | 31117 | 6 | 0 |
458543 | 458543 | 2020-08-22 | McPherson | Nebraska | 31117 | 6 | 0 |
461770 | 461770 | 2020-08-23 | McPherson | Nebraska | 31117 | 6 | 0 |
465001 | 465001 | 2020-08-24 | McPherson | Nebraska | 31117 | 6 | 0 |
468230 | 468230 | 2020-08-25 | McPherson | Nebraska | 31117 | 6 | 0 |
471461 | 471461 | 2020-08-26 | McPherson | Nebraska | 31117 | 6 | 0 |
474694 | 474694 | 2020-08-27 | McPherson | Nebraska | 31117 | 6 | 0 |
477927 | 477927 | 2020-08-28 | McPherson | Nebraska | 31117 | 6 | 0 |
481159 | 481159 | 2020-08-29 | McPherson | Nebraska | 31117 | 6 | 0 |
484394 | 484394 | 2020-08-30 | McPherson | Nebraska | 31117 | 6 | 0 |
487628 | 487628 | 2020-08-31 | McPherson | Nebraska | 31117 | 6 | 0 |
490861 | 490861 | 2020-09-01 | McPherson | Nebraska | 31117 | 6 | 0 |
494095 | 494095 | 2020-09-02 | McPherson | Nebraska | 31117 | 6 | 0 |
497328 | 497328 | 2020-09-03 | McPherson | Nebraska | 31117 | 6 | 0 |
500562 | 500562 | 2020-09-04 | McPherson | Nebraska | 31117 | 6 | 0 |
503796 | 503796 | 2020-09-05 | McPherson | Nebraska | 31117 | 6 | 0 |
507029 | 507029 | 2020-09-06 | McPherson | Nebraska | 31117 | 6 | 0 |
510262 | 510262 | 2020-09-07 | McPherson | Nebraska | 31117 | 6 | 0 |
513494 | 513494 | 2020-09-08 | McPherson | Nebraska | 31117 | 6 | 0 |
516728 | 516728 | 2020-09-09 | McPherson | Nebraska | 31117 | 6 | 0 |
519963 | 519963 | 2020-09-10 | McPherson | Nebraska | 31117 | 6 | 0 |
523200 | 523200 | 2020-09-11 | McPherson | Nebraska | 31117 | 6 | 0 |
526436 | 526436 | 2020-09-12 | McPherson | Nebraska | 31117 | 6 | 0 |
529672 | 529672 | 2020-09-13 | McPherson | Nebraska | 31117 | 6 | 0 |
532908 | 532908 | 2020-09-14 | McPherson | Nebraska | 31117 | 6 | 0 |
536143 | 536143 | 2020-09-15 | McPherson | Nebraska | 31117 | 6 | 0 |
539381 | 539381 | 2020-09-16 | McPherson | Nebraska | 31117 | 6 | 0 |
542617 | 542617 | 2020-09-17 | McPherson | Nebraska | 31117 | 6 | 0 |
545854 | 545854 | 2020-09-18 | McPherson | Nebraska | 31117 | 6 | 0 |
549092 | 549092 | 2020-09-19 | McPherson | Nebraska | 31117 | 6 | 0 |
552331 | 552331 | 2020-09-20 | McPherson | Nebraska | 31117 | 6 | 0 |
555569 | 555569 | 2020-09-21 | McPherson | Nebraska | 31117 | 6 | 0 |
558806 | 558806 | 2020-09-22 | McPherson | Nebraska | 31117 | 6 | 0 |
562043 | 562043 | 2020-09-23 | McPherson | Nebraska | 31117 | 6 | 0 |
565284 | 565284 | 2020-09-24 | McPherson | Nebraska | 31117 | 6 | 0 |
568525 | 568525 | 2020-09-25 | McPherson | Nebraska | 31117 | 6 | 0 |
571767 | 571767 | 2020-09-26 | McPherson | Nebraska | 31117 | 6 | 0 |
575010 | 575010 | 2020-09-27 | McPherson | Nebraska | 31117 | 6 | 0 |
578251 | 578251 | 2020-09-28 | McPherson | Nebraska | 31117 | 6 | 0 |
581492 | 581492 | 2020-09-29 | McPherson | Nebraska | 31117 | 6 | 0 |
584733 | 584733 | 2020-09-30 | McPherson | Nebraska | 31117 | 6 | 0 |
587973 | 587973 | 2020-10-01 | McPherson | Nebraska | 31117 | 6 | 0 |
591214 | 591214 | 2020-10-02 | McPherson | Nebraska | 31117 | 6 | 0 |
594455 | 594455 | 2020-10-03 | McPherson | Nebraska | 31117 | 6 | 0 |
597697 | 597697 | 2020-10-04 | McPherson | Nebraska | 31117 | 6 | 0 |
600941 | 600941 | 2020-10-05 | McPherson | Nebraska | 31117 | 6 | 0 |
610668 | 610668 | 2020-10-08 | McPherson | Nebraska | 31117 | 7 | 0 |
613910 | 613910 | 2020-10-09 | McPherson | Nebraska | 31117 | 7 | 0 |
617151 | 617151 | 2020-10-10 | McPherson | Nebraska | 31117 | 7 | 0 |
620393 | 620393 | 2020-10-11 | McPherson | Nebraska | 31117 | 7 | 0 |
623636 | 623636 | 2020-10-12 | McPherson | Nebraska | 31117 | 7 | 0 |
626878 | 626878 | 2020-10-13 | McPherson | Nebraska | 31117 | 7 | 0 |
630122 | 630122 | 2020-10-14 | McPherson | Nebraska | 31117 | 7 | 0 |
633367 | 633367 | 2020-10-15 | McPherson | Nebraska | 31117 | 7 | 0 |
636613 | 636613 | 2020-10-16 | McPherson | Nebraska | 31117 | 7 | 0 |
604183 | 604183 | 2020-10-06 | McPherson | Nebraska | 31117 | 8 | 0 |
607426 | 607426 | 2020-10-07 | McPherson | Nebraska | 31117 | 8 | 0 |
639859 | 639859 | 2020-10-17 | McPherson | Nebraska | 31117 | 9 | 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);