ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Union" and state = "New Mexico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
397411 | 397411 | 2020-08-03 | Union | New Mexico | 35059 | 28 | 0 |
400626 | 400626 | 2020-08-04 | Union | New Mexico | 35059 | 29 | 0 |
403844 | 403844 | 2020-08-05 | Union | New Mexico | 35059 | 29 | 2 |
407063 | 407063 | 2020-08-06 | Union | New Mexico | 35059 | 29 | 2 |
410283 | 410283 | 2020-08-07 | Union | New Mexico | 35059 | 30 | 2 |
413503 | 413503 | 2020-08-08 | Union | New Mexico | 35059 | 30 | 2 |
416724 | 416724 | 2020-08-09 | Union | New Mexico | 35059 | 31 | 2 |
419944 | 419944 | 2020-08-10 | Union | New Mexico | 35059 | 31 | 2 |
423167 | 423167 | 2020-08-11 | Union | New Mexico | 35059 | 31 | 2 |
426390 | 426390 | 2020-08-12 | Union | New Mexico | 35059 | 31 | 2 |
429614 | 429614 | 2020-08-13 | Union | New Mexico | 35059 | 31 | 2 |
432841 | 432841 | 2020-08-14 | Union | New Mexico | 35059 | 31 | 2 |
436067 | 436067 | 2020-08-15 | Union | New Mexico | 35059 | 31 | 2 |
439292 | 439292 | 2020-08-16 | Union | New Mexico | 35059 | 31 | 2 |
442519 | 442519 | 2020-08-17 | Union | New Mexico | 35059 | 31 | 2 |
445745 | 445745 | 2020-08-18 | Union | New Mexico | 35059 | 31 | 2 |
448972 | 448972 | 2020-08-19 | Union | New Mexico | 35059 | 32 | 2 |
452201 | 452201 | 2020-08-20 | Union | New Mexico | 35059 | 32 | 2 |
455429 | 455429 | 2020-08-21 | Union | New Mexico | 35059 | 32 | 2 |
458656 | 458656 | 2020-08-22 | Union | New Mexico | 35059 | 30 | 2 |
461884 | 461884 | 2020-08-23 | Union | New Mexico | 35059 | 32 | 2 |
465114 | 465114 | 2020-08-24 | Union | New Mexico | 35059 | 32 | 2 |
468342 | 468342 | 2020-08-25 | Union | New Mexico | 35059 | 32 | 2 |
471574 | 471574 | 2020-08-26 | Union | New Mexico | 35059 | 32 | 2 |
474808 | 474808 | 2020-08-27 | Union | New Mexico | 35059 | 32 | 2 |
478041 | 478041 | 2020-08-28 | Union | New Mexico | 35059 | 32 | 2 |
481273 | 481273 | 2020-08-29 | Union | New Mexico | 35059 | 32 | 2 |
484508 | 484508 | 2020-08-30 | Union | New Mexico | 35059 | 32 | 2 |
487742 | 487742 | 2020-08-31 | Union | New Mexico | 35059 | 32 | 2 |
490975 | 490975 | 2020-09-01 | Union | New Mexico | 35059 | 32 | 2 |
494209 | 494209 | 2020-09-02 | Union | New Mexico | 35059 | 32 | 2 |
497442 | 497442 | 2020-09-03 | Union | New Mexico | 35059 | 32 | 2 |
500676 | 500676 | 2020-09-04 | Union | New Mexico | 35059 | 32 | 2 |
503910 | 503910 | 2020-09-05 | Union | New Mexico | 35059 | 32 | 2 |
507142 | 507142 | 2020-09-06 | Union | New Mexico | 35059 | 32 | 2 |
510375 | 510375 | 2020-09-07 | Union | New Mexico | 35059 | 32 | 2 |
513608 | 513608 | 2020-09-08 | Union | New Mexico | 35059 | 32 | 2 |
516842 | 516842 | 2020-09-09 | Union | New Mexico | 35059 | 32 | 2 |
520078 | 520078 | 2020-09-10 | Union | New Mexico | 35059 | 32 | 2 |
523315 | 523315 | 2020-09-11 | Union | New Mexico | 35059 | 32 | 2 |
526551 | 526551 | 2020-09-12 | Union | New Mexico | 35059 | 32 | 2 |
529787 | 529787 | 2020-09-13 | Union | New Mexico | 35059 | 32 | 2 |
533023 | 533023 | 2020-09-14 | Union | New Mexico | 35059 | 32 | 2 |
536258 | 536258 | 2020-09-15 | Union | New Mexico | 35059 | 32 | 2 |
539495 | 539495 | 2020-09-16 | Union | New Mexico | 35059 | 32 | 2 |
542732 | 542732 | 2020-09-17 | Union | New Mexico | 35059 | 32 | 2 |
545969 | 545969 | 2020-09-18 | Union | New Mexico | 35059 | 32 | 2 |
549207 | 549207 | 2020-09-19 | Union | New Mexico | 35059 | 32 | 2 |
552446 | 552446 | 2020-09-20 | Union | New Mexico | 35059 | 32 | 2 |
555684 | 555684 | 2020-09-21 | Union | New Mexico | 35059 | 32 | 2 |
558921 | 558921 | 2020-09-22 | Union | New Mexico | 35059 | 32 | 2 |
562158 | 562158 | 2020-09-23 | Union | New Mexico | 35059 | 32 | 2 |
565399 | 565399 | 2020-09-24 | Union | New Mexico | 35059 | 32 | 2 |
568640 | 568640 | 2020-09-25 | Union | New Mexico | 35059 | 32 | 2 |
571882 | 571882 | 2020-09-26 | Union | New Mexico | 35059 | 32 | 2 |
575125 | 575125 | 2020-09-27 | Union | New Mexico | 35059 | 32 | 2 |
578366 | 578366 | 2020-09-28 | Union | New Mexico | 35059 | 32 | 2 |
581607 | 581607 | 2020-09-29 | Union | New Mexico | 35059 | 32 | 2 |
584848 | 584848 | 2020-09-30 | Union | New Mexico | 35059 | 32 | 2 |
588088 | 588088 | 2020-10-01 | Union | New Mexico | 35059 | 32 | 2 |
591329 | 591329 | 2020-10-02 | Union | New Mexico | 35059 | 32 | 2 |
594570 | 594570 | 2020-10-03 | Union | New Mexico | 35059 | 32 | 2 |
597812 | 597812 | 2020-10-04 | Union | New Mexico | 35059 | 32 | 2 |
601056 | 601056 | 2020-10-05 | Union | New Mexico | 35059 | 33 | 2 |
604298 | 604298 | 2020-10-06 | Union | New Mexico | 35059 | 33 | 2 |
607541 | 607541 | 2020-10-07 | Union | New Mexico | 35059 | 34 | 2 |
610783 | 610783 | 2020-10-08 | Union | New Mexico | 35059 | 39 | 2 |
614024 | 614024 | 2020-10-09 | Union | New Mexico | 35059 | 42 | 2 |
617266 | 617266 | 2020-10-10 | Union | New Mexico | 35059 | 42 | 2 |
620508 | 620508 | 2020-10-11 | Union | New Mexico | 35059 | 42 | 2 |
623751 | 623751 | 2020-10-12 | Union | New Mexico | 35059 | 42 | 2 |
626993 | 626993 | 2020-10-13 | Union | New Mexico | 35059 | 42 | 2 |
630237 | 630237 | 2020-10-14 | Union | New Mexico | 35059 | 42 | 2 |
633482 | 633482 | 2020-10-15 | Union | New Mexico | 35059 | 42 | 2 |
636728 | 636728 | 2020-10-16 | Union | New Mexico | 35059 | 43 | 2 |
639974 | 639974 | 2020-10-17 | Union | New Mexico | 35059 | 43 | 2 |
643222 | 643222 | 2020-10-18 | Union | New Mexico | 35059 | 43 | 2 |
646468 | 646468 | 2020-10-19 | Union | New Mexico | 35059 | 43 | 2 |
649712 | 649712 | 2020-10-20 | Union | New Mexico | 35059 | 44 | 2 |
652957 | 652957 | 2020-10-21 | Union | New Mexico | 35059 | 44 | 2 |
656202 | 656202 | 2020-10-22 | Union | New Mexico | 35059 | 44 | 2 |
659446 | 659446 | 2020-10-23 | Union | New Mexico | 35059 | 44 | 2 |
662690 | 662690 | 2020-10-24 | Union | New Mexico | 35059 | 44 | 2 |
665935 | 665935 | 2020-10-25 | Union | New Mexico | 35059 | 44 | 2 |
669179 | 669179 | 2020-10-26 | Union | New Mexico | 35059 | 44 | 2 |
672421 | 672421 | 2020-10-27 | Union | New Mexico | 35059 | 44 | 2 |
675664 | 675664 | 2020-10-28 | Union | New Mexico | 35059 | 45 | 2 |
678907 | 678907 | 2020-10-29 | Union | New Mexico | 35059 | 46 | 2 |
682150 | 682150 | 2020-10-30 | Union | New Mexico | 35059 | 46 | 2 |
685393 | 685393 | 2020-10-31 | Union | New Mexico | 35059 | 46 | 2 |
688638 | 688638 | 2020-11-01 | Union | New Mexico | 35059 | 50 | 2 |
691882 | 691882 | 2020-11-02 | Union | New Mexico | 35059 | 50 | 2 |
695124 | 695124 | 2020-11-03 | Union | New Mexico | 35059 | 55 | 2 |
698367 | 698367 | 2020-11-04 | Union | New Mexico | 35059 | 55 | 2 |
701611 | 701611 | 2020-11-05 | Union | New Mexico | 35059 | 56 | 2 |
704854 | 704854 | 2020-11-06 | Union | New Mexico | 35059 | 56 | 2 |
708097 | 708097 | 2020-11-07 | Union | New Mexico | 35059 | 57 | 2 |
711341 | 711341 | 2020-11-08 | Union | New Mexico | 35059 | 57 | 2 |
714585 | 714585 | 2020-11-09 | Union | New Mexico | 35059 | 57 | 2 |
717828 | 717828 | 2020-11-10 | Union | New Mexico | 35059 | 60 | 2 |
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);