ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Union" and fips = 35059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919036 | 919036 | 2021-01-11 | Union | New Mexico | 35059 | 367 | 7 |
915791 | 915791 | 2021-01-10 | Union | New Mexico | 35059 | 366 | 7 |
912546 | 912546 | 2021-01-09 | Union | New Mexico | 35059 | 366 | 7 |
909301 | 909301 | 2021-01-08 | Union | New Mexico | 35059 | 364 | 7 |
906055 | 906055 | 2021-01-07 | Union | New Mexico | 35059 | 363 | 7 |
902810 | 902810 | 2021-01-06 | Union | New Mexico | 35059 | 358 | 7 |
899565 | 899565 | 2021-01-05 | Union | New Mexico | 35059 | 358 | 7 |
896320 | 896320 | 2021-01-04 | Union | New Mexico | 35059 | 356 | 7 |
893073 | 893073 | 2021-01-03 | Union | New Mexico | 35059 | 355 | 7 |
889827 | 889827 | 2021-01-02 | Union | New Mexico | 35059 | 353 | 7 |
886581 | 886581 | 2021-01-01 | Union | New Mexico | 35059 | 354 | 7 |
883336 | 883336 | 2020-12-31 | Union | New Mexico | 35059 | 354 | 7 |
880091 | 880091 | 2020-12-30 | Union | New Mexico | 35059 | 354 | 7 |
876846 | 876846 | 2020-12-29 | Union | New Mexico | 35059 | 352 | 7 |
873601 | 873601 | 2020-12-28 | Union | New Mexico | 35059 | 352 | 7 |
870356 | 870356 | 2020-12-27 | Union | New Mexico | 35059 | 352 | 7 |
867111 | 867111 | 2020-12-26 | Union | New Mexico | 35059 | 350 | 7 |
863866 | 863866 | 2020-12-25 | Union | New Mexico | 35059 | 348 | 7 |
860621 | 860621 | 2020-12-24 | Union | New Mexico | 35059 | 345 | 7 |
857376 | 857376 | 2020-12-23 | Union | New Mexico | 35059 | 345 | 7 |
854131 | 854131 | 2020-12-22 | Union | New Mexico | 35059 | 344 | 7 |
850886 | 850886 | 2020-12-21 | Union | New Mexico | 35059 | 344 | 7 |
847641 | 847641 | 2020-12-20 | Union | New Mexico | 35059 | 343 | 7 |
844395 | 844395 | 2020-12-19 | Union | New Mexico | 35059 | 338 | 7 |
841150 | 841150 | 2020-12-18 | Union | New Mexico | 35059 | 337 | 7 |
837905 | 837905 | 2020-12-17 | Union | New Mexico | 35059 | 333 | 7 |
834659 | 834659 | 2020-12-16 | Union | New Mexico | 35059 | 330 | 7 |
831412 | 831412 | 2020-12-15 | Union | New Mexico | 35059 | 325 | 7 |
828166 | 828166 | 2020-12-14 | Union | New Mexico | 35059 | 321 | 7 |
824919 | 824919 | 2020-12-13 | Union | New Mexico | 35059 | 316 | 7 |
821673 | 821673 | 2020-12-12 | Union | New Mexico | 35059 | 316 | 7 |
818427 | 818427 | 2020-12-11 | Union | New Mexico | 35059 | 315 | 7 |
815181 | 815181 | 2020-12-10 | Union | New Mexico | 35059 | 303 | 7 |
811936 | 811936 | 2020-12-09 | Union | New Mexico | 35059 | 287 | 7 |
808691 | 808691 | 2020-12-08 | Union | New Mexico | 35059 | 270 | 7 |
805446 | 805446 | 2020-12-07 | Union | New Mexico | 35059 | 268 | 5 |
802201 | 802201 | 2020-12-06 | Union | New Mexico | 35059 | 267 | 5 |
798956 | 798956 | 2020-12-05 | Union | New Mexico | 35059 | 267 | 5 |
795711 | 795711 | 2020-12-04 | Union | New Mexico | 35059 | 261 | 5 |
792466 | 792466 | 2020-12-03 | Union | New Mexico | 35059 | 251 | 5 |
789221 | 789221 | 2020-12-02 | Union | New Mexico | 35059 | 247 | 4 |
785976 | 785976 | 2020-12-01 | Union | New Mexico | 35059 | 225 | 4 |
782732 | 782732 | 2020-11-30 | Union | New Mexico | 35059 | 227 | 4 |
779486 | 779486 | 2020-11-29 | Union | New Mexico | 35059 | 224 | 4 |
776241 | 776241 | 2020-11-28 | Union | New Mexico | 35059 | 219 | 4 |
772996 | 772996 | 2020-11-27 | Union | New Mexico | 35059 | 215 | 4 |
769751 | 769751 | 2020-11-26 | Union | New Mexico | 35059 | 213 | 4 |
766505 | 766505 | 2020-11-25 | Union | New Mexico | 35059 | 201 | 4 |
763260 | 763260 | 2020-11-24 | Union | New Mexico | 35059 | 199 | 4 |
760015 | 760015 | 2020-11-23 | Union | New Mexico | 35059 | 190 | 2 |
756769 | 756769 | 2020-11-22 | Union | New Mexico | 35059 | 180 | 2 |
753522 | 753522 | 2020-11-21 | Union | New Mexico | 35059 | 170 | 2 |
750276 | 750276 | 2020-11-20 | Union | New Mexico | 35059 | 169 | 2 |
747030 | 747030 | 2020-11-19 | Union | New Mexico | 35059 | 151 | 2 |
743784 | 743784 | 2020-11-18 | Union | New Mexico | 35059 | 71 | 2 |
740537 | 740537 | 2020-11-17 | Union | New Mexico | 35059 | 71 | 2 |
737292 | 737292 | 2020-11-16 | Union | New Mexico | 35059 | 68 | 2 |
734047 | 734047 | 2020-11-15 | Union | New Mexico | 35059 | 65 | 2 |
730802 | 730802 | 2020-11-14 | Union | New Mexico | 35059 | 64 | 2 |
727558 | 727558 | 2020-11-13 | Union | New Mexico | 35059 | 62 | 2 |
724314 | 724314 | 2020-11-12 | Union | New Mexico | 35059 | 60 | 2 |
721071 | 721071 | 2020-11-11 | Union | New Mexico | 35059 | 60 | 2 |
717828 | 717828 | 2020-11-10 | Union | New Mexico | 35059 | 60 | 2 |
714585 | 714585 | 2020-11-09 | Union | New Mexico | 35059 | 57 | 2 |
711341 | 711341 | 2020-11-08 | Union | New Mexico | 35059 | 57 | 2 |
708097 | 708097 | 2020-11-07 | Union | New Mexico | 35059 | 57 | 2 |
704854 | 704854 | 2020-11-06 | Union | New Mexico | 35059 | 56 | 2 |
701611 | 701611 | 2020-11-05 | Union | New Mexico | 35059 | 56 | 2 |
698367 | 698367 | 2020-11-04 | Union | New Mexico | 35059 | 55 | 2 |
695124 | 695124 | 2020-11-03 | Union | New Mexico | 35059 | 55 | 2 |
691882 | 691882 | 2020-11-02 | Union | New Mexico | 35059 | 50 | 2 |
688638 | 688638 | 2020-11-01 | Union | New Mexico | 35059 | 50 | 2 |
685393 | 685393 | 2020-10-31 | Union | New Mexico | 35059 | 46 | 2 |
682150 | 682150 | 2020-10-30 | Union | New Mexico | 35059 | 46 | 2 |
678907 | 678907 | 2020-10-29 | Union | New Mexico | 35059 | 46 | 2 |
675664 | 675664 | 2020-10-28 | Union | New Mexico | 35059 | 45 | 2 |
672421 | 672421 | 2020-10-27 | Union | New Mexico | 35059 | 44 | 2 |
669179 | 669179 | 2020-10-26 | Union | New Mexico | 35059 | 44 | 2 |
665935 | 665935 | 2020-10-25 | Union | New Mexico | 35059 | 44 | 2 |
662690 | 662690 | 2020-10-24 | Union | New Mexico | 35059 | 44 | 2 |
659446 | 659446 | 2020-10-23 | Union | New Mexico | 35059 | 44 | 2 |
656202 | 656202 | 2020-10-22 | Union | New Mexico | 35059 | 44 | 2 |
652957 | 652957 | 2020-10-21 | Union | New Mexico | 35059 | 44 | 2 |
649712 | 649712 | 2020-10-20 | Union | New Mexico | 35059 | 44 | 2 |
646468 | 646468 | 2020-10-19 | Union | New Mexico | 35059 | 43 | 2 |
643222 | 643222 | 2020-10-18 | Union | New Mexico | 35059 | 43 | 2 |
639974 | 639974 | 2020-10-17 | Union | New Mexico | 35059 | 43 | 2 |
636728 | 636728 | 2020-10-16 | Union | New Mexico | 35059 | 43 | 2 |
633482 | 633482 | 2020-10-15 | Union | New Mexico | 35059 | 42 | 2 |
630237 | 630237 | 2020-10-14 | Union | New Mexico | 35059 | 42 | 2 |
626993 | 626993 | 2020-10-13 | Union | New Mexico | 35059 | 42 | 2 |
623751 | 623751 | 2020-10-12 | Union | New Mexico | 35059 | 42 | 2 |
620508 | 620508 | 2020-10-11 | Union | New Mexico | 35059 | 42 | 2 |
617266 | 617266 | 2020-10-10 | Union | New Mexico | 35059 | 42 | 2 |
614024 | 614024 | 2020-10-09 | Union | New Mexico | 35059 | 42 | 2 |
610783 | 610783 | 2020-10-08 | Union | New Mexico | 35059 | 39 | 2 |
607541 | 607541 | 2020-10-07 | Union | New Mexico | 35059 | 34 | 2 |
604298 | 604298 | 2020-10-06 | Union | New Mexico | 35059 | 33 | 2 |
601056 | 601056 | 2020-10-05 | Union | New Mexico | 35059 | 33 | 2 |
597812 | 597812 | 2020-10-04 | Union | New Mexico | 35059 | 32 | 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);