ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Sargent" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922481 | 922481 | 2021-01-12 | Sargent | North Dakota | 38081 | 412 | 5 |
919236 | 919236 | 2021-01-11 | Sargent | North Dakota | 38081 | 411 | 5 |
915991 | 915991 | 2021-01-10 | Sargent | North Dakota | 38081 | 411 | 5 |
912746 | 912746 | 2021-01-09 | Sargent | North Dakota | 38081 | 410 | 5 |
909501 | 909501 | 2021-01-08 | Sargent | North Dakota | 38081 | 410 | 5 |
906256 | 906256 | 2021-01-07 | Sargent | North Dakota | 38081 | 410 | 5 |
903010 | 903010 | 2021-01-06 | Sargent | North Dakota | 38081 | 409 | 5 |
899765 | 899765 | 2021-01-05 | Sargent | North Dakota | 38081 | 409 | 5 |
896520 | 896520 | 2021-01-04 | Sargent | North Dakota | 38081 | 407 | 5 |
893274 | 893274 | 2021-01-03 | Sargent | North Dakota | 38081 | 407 | 5 |
890028 | 890028 | 2021-01-02 | Sargent | North Dakota | 38081 | 408 | 5 |
886781 | 886781 | 2021-01-01 | Sargent | North Dakota | 38081 | 408 | 5 |
883536 | 883536 | 2020-12-31 | Sargent | North Dakota | 38081 | 407 | 5 |
880291 | 880291 | 2020-12-30 | Sargent | North Dakota | 38081 | 405 | 5 |
877046 | 877046 | 2020-12-29 | Sargent | North Dakota | 38081 | 403 | 5 |
873801 | 873801 | 2020-12-28 | Sargent | North Dakota | 38081 | 402 | 5 |
870556 | 870556 | 2020-12-27 | Sargent | North Dakota | 38081 | 402 | 5 |
867311 | 867311 | 2020-12-26 | Sargent | North Dakota | 38081 | 402 | 5 |
864066 | 864066 | 2020-12-25 | Sargent | North Dakota | 38081 | 402 | 5 |
860821 | 860821 | 2020-12-24 | Sargent | North Dakota | 38081 | 400 | 5 |
857576 | 857576 | 2020-12-23 | Sargent | North Dakota | 38081 | 400 | 5 |
854331 | 854331 | 2020-12-22 | Sargent | North Dakota | 38081 | 400 | 5 |
851086 | 851086 | 2020-12-21 | Sargent | North Dakota | 38081 | 399 | 5 |
847841 | 847841 | 2020-12-20 | Sargent | North Dakota | 38081 | 399 | 5 |
844596 | 844596 | 2020-12-19 | Sargent | North Dakota | 38081 | 398 | 5 |
841350 | 841350 | 2020-12-18 | Sargent | North Dakota | 38081 | 398 | 5 |
838105 | 838105 | 2020-12-17 | Sargent | North Dakota | 38081 | 400 | 5 |
834859 | 834859 | 2020-12-16 | Sargent | North Dakota | 38081 | 398 | 5 |
831613 | 831613 | 2020-12-15 | Sargent | North Dakota | 38081 | 397 | 5 |
828366 | 828366 | 2020-12-14 | Sargent | North Dakota | 38081 | 393 | 5 |
825120 | 825120 | 2020-12-13 | Sargent | North Dakota | 38081 | 390 | 5 |
821873 | 821873 | 2020-12-12 | Sargent | North Dakota | 38081 | 390 | 5 |
818627 | 818627 | 2020-12-11 | Sargent | North Dakota | 38081 | 388 | 5 |
815381 | 815381 | 2020-12-10 | Sargent | North Dakota | 38081 | 382 | 5 |
812136 | 812136 | 2020-12-09 | Sargent | North Dakota | 38081 | 379 | 5 |
808891 | 808891 | 2020-12-08 | Sargent | North Dakota | 38081 | 355 | 5 |
805646 | 805646 | 2020-12-07 | Sargent | North Dakota | 38081 | 355 | 5 |
802401 | 802401 | 2020-12-06 | Sargent | North Dakota | 38081 | 354 | 5 |
799156 | 799156 | 2020-12-05 | Sargent | North Dakota | 38081 | 351 | 5 |
795911 | 795911 | 2020-12-04 | Sargent | North Dakota | 38081 | 346 | 5 |
792666 | 792666 | 2020-12-03 | Sargent | North Dakota | 38081 | 334 | 4 |
789421 | 789421 | 2020-12-02 | Sargent | North Dakota | 38081 | 320 | 4 |
786176 | 786176 | 2020-12-01 | Sargent | North Dakota | 38081 | 318 | 4 |
782932 | 782932 | 2020-11-30 | Sargent | North Dakota | 38081 | 318 | 4 |
779686 | 779686 | 2020-11-29 | Sargent | North Dakota | 38081 | 315 | 4 |
776441 | 776441 | 2020-11-28 | Sargent | North Dakota | 38081 | 309 | 4 |
773196 | 773196 | 2020-11-27 | Sargent | North Dakota | 38081 | 305 | 4 |
769951 | 769951 | 2020-11-26 | Sargent | North Dakota | 38081 | 290 | 4 |
766705 | 766705 | 2020-11-25 | Sargent | North Dakota | 38081 | 285 | 4 |
763460 | 763460 | 2020-11-24 | Sargent | North Dakota | 38081 | 277 | 4 |
760215 | 760215 | 2020-11-23 | Sargent | North Dakota | 38081 | 270 | 4 |
756969 | 756969 | 2020-11-22 | Sargent | North Dakota | 38081 | 265 | 4 |
753722 | 753722 | 2020-11-21 | Sargent | North Dakota | 38081 | 257 | 3 |
750476 | 750476 | 2020-11-20 | Sargent | North Dakota | 38081 | 248 | 3 |
747230 | 747230 | 2020-11-19 | Sargent | North Dakota | 38081 | 239 | 3 |
743984 | 743984 | 2020-11-18 | Sargent | North Dakota | 38081 | 231 | 3 |
740737 | 740737 | 2020-11-17 | Sargent | North Dakota | 38081 | 227 | 3 |
737492 | 737492 | 2020-11-16 | Sargent | North Dakota | 38081 | 220 | 3 |
734248 | 734248 | 2020-11-15 | Sargent | North Dakota | 38081 | 220 | 3 |
731002 | 731002 | 2020-11-14 | Sargent | North Dakota | 38081 | 214 | 3 |
727758 | 727758 | 2020-11-13 | Sargent | North Dakota | 38081 | 197 | 3 |
724514 | 724514 | 2020-11-12 | Sargent | North Dakota | 38081 | 195 | 3 |
721271 | 721271 | 2020-11-11 | Sargent | North Dakota | 38081 | 188 | 3 |
718028 | 718028 | 2020-11-10 | Sargent | North Dakota | 38081 | 181 | 3 |
714785 | 714785 | 2020-11-09 | Sargent | North Dakota | 38081 | 174 | 3 |
711541 | 711541 | 2020-11-08 | Sargent | North Dakota | 38081 | 172 | 3 |
708297 | 708297 | 2020-11-07 | Sargent | North Dakota | 38081 | 167 | 3 |
705054 | 705054 | 2020-11-06 | Sargent | North Dakota | 38081 | 159 | 3 |
701811 | 701811 | 2020-11-05 | Sargent | North Dakota | 38081 | 156 | 3 |
698567 | 698567 | 2020-11-04 | Sargent | North Dakota | 38081 | 149 | 3 |
695324 | 695324 | 2020-11-03 | Sargent | North Dakota | 38081 | 144 | 3 |
692082 | 692082 | 2020-11-02 | Sargent | North Dakota | 38081 | 142 | 3 |
688838 | 688838 | 2020-11-01 | Sargent | North Dakota | 38081 | 142 | 2 |
685593 | 685593 | 2020-10-31 | Sargent | North Dakota | 38081 | 138 | 2 |
682350 | 682350 | 2020-10-30 | Sargent | North Dakota | 38081 | 134 | 2 |
679107 | 679107 | 2020-10-29 | Sargent | North Dakota | 38081 | 132 | 2 |
675864 | 675864 | 2020-10-28 | Sargent | North Dakota | 38081 | 127 | 2 |
672621 | 672621 | 2020-10-27 | Sargent | North Dakota | 38081 | 126 | 2 |
669379 | 669379 | 2020-10-26 | Sargent | North Dakota | 38081 | 129 | 2 |
666135 | 666135 | 2020-10-25 | Sargent | North Dakota | 38081 | 128 | 2 |
662890 | 662890 | 2020-10-24 | Sargent | North Dakota | 38081 | 126 | 2 |
659646 | 659646 | 2020-10-23 | Sargent | North Dakota | 38081 | 123 | 2 |
656402 | 656402 | 2020-10-22 | Sargent | North Dakota | 38081 | 121 | 2 |
653157 | 653157 | 2020-10-21 | Sargent | North Dakota | 38081 | 117 | 2 |
649912 | 649912 | 2020-10-20 | Sargent | North Dakota | 38081 | 115 | 2 |
646668 | 646668 | 2020-10-19 | Sargent | North Dakota | 38081 | 112 | 2 |
643422 | 643422 | 2020-10-18 | Sargent | North Dakota | 38081 | 112 | 2 |
640174 | 640174 | 2020-10-17 | Sargent | North Dakota | 38081 | 105 | 2 |
636928 | 636928 | 2020-10-16 | Sargent | North Dakota | 38081 | 105 | 2 |
633682 | 633682 | 2020-10-15 | Sargent | North Dakota | 38081 | 103 | 2 |
630437 | 630437 | 2020-10-14 | Sargent | North Dakota | 38081 | 103 | 1 |
627193 | 627193 | 2020-10-13 | Sargent | North Dakota | 38081 | 101 | 1 |
623951 | 623951 | 2020-10-12 | Sargent | North Dakota | 38081 | 97 | 1 |
620708 | 620708 | 2020-10-11 | Sargent | North Dakota | 38081 | 95 | 1 |
617466 | 617466 | 2020-10-10 | Sargent | North Dakota | 38081 | 94 | 1 |
614224 | 614224 | 2020-10-09 | Sargent | North Dakota | 38081 | 92 | 1 |
610983 | 610983 | 2020-10-08 | Sargent | North Dakota | 38081 | 93 | 1 |
607741 | 607741 | 2020-10-07 | Sargent | North Dakota | 38081 | 91 | 1 |
604498 | 604498 | 2020-10-06 | Sargent | North Dakota | 38081 | 86 | 1 |
601256 | 601256 | 2020-10-05 | Sargent | North Dakota | 38081 | 85 | 1 |
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);