ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "McIntosh" 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 |
---|---|---|---|---|---|---|---|
922466 | 922466 | 2021-01-12 | McIntosh | North Dakota | 38051 | 316 | 7 |
919221 | 919221 | 2021-01-11 | McIntosh | North Dakota | 38051 | 319 | 7 |
915976 | 915976 | 2021-01-10 | McIntosh | North Dakota | 38051 | 319 | 7 |
912731 | 912731 | 2021-01-09 | McIntosh | North Dakota | 38051 | 318 | 7 |
909486 | 909486 | 2021-01-08 | McIntosh | North Dakota | 38051 | 318 | 7 |
906241 | 906241 | 2021-01-07 | McIntosh | North Dakota | 38051 | 318 | 7 |
902995 | 902995 | 2021-01-06 | McIntosh | North Dakota | 38051 | 314 | 7 |
899750 | 899750 | 2021-01-05 | McIntosh | North Dakota | 38051 | 313 | 7 |
896505 | 896505 | 2021-01-04 | McIntosh | North Dakota | 38051 | 313 | 7 |
893259 | 893259 | 2021-01-03 | McIntosh | North Dakota | 38051 | 313 | 7 |
890013 | 890013 | 2021-01-02 | McIntosh | North Dakota | 38051 | 313 | 7 |
886766 | 886766 | 2021-01-01 | McIntosh | North Dakota | 38051 | 313 | 7 |
883521 | 883521 | 2020-12-31 | McIntosh | North Dakota | 38051 | 312 | 7 |
880276 | 880276 | 2020-12-30 | McIntosh | North Dakota | 38051 | 312 | 7 |
877031 | 877031 | 2020-12-29 | McIntosh | North Dakota | 38051 | 312 | 7 |
873786 | 873786 | 2020-12-28 | McIntosh | North Dakota | 38051 | 311 | 7 |
870541 | 870541 | 2020-12-27 | McIntosh | North Dakota | 38051 | 310 | 7 |
867296 | 867296 | 2020-12-26 | McIntosh | North Dakota | 38051 | 309 | 7 |
864051 | 864051 | 2020-12-25 | McIntosh | North Dakota | 38051 | 308 | 7 |
860806 | 860806 | 2020-12-24 | McIntosh | North Dakota | 38051 | 308 | 7 |
857561 | 857561 | 2020-12-23 | McIntosh | North Dakota | 38051 | 308 | 7 |
854316 | 854316 | 2020-12-22 | McIntosh | North Dakota | 38051 | 308 | 7 |
851071 | 851071 | 2020-12-21 | McIntosh | North Dakota | 38051 | 308 | 7 |
847826 | 847826 | 2020-12-20 | McIntosh | North Dakota | 38051 | 306 | 7 |
844581 | 844581 | 2020-12-19 | McIntosh | North Dakota | 38051 | 305 | 7 |
841335 | 841335 | 2020-12-18 | McIntosh | North Dakota | 38051 | 304 | 7 |
838090 | 838090 | 2020-12-17 | McIntosh | North Dakota | 38051 | 301 | 7 |
834844 | 834844 | 2020-12-16 | McIntosh | North Dakota | 38051 | 300 | 7 |
831598 | 831598 | 2020-12-15 | McIntosh | North Dakota | 38051 | 300 | 7 |
828351 | 828351 | 2020-12-14 | McIntosh | North Dakota | 38051 | 297 | 7 |
825105 | 825105 | 2020-12-13 | McIntosh | North Dakota | 38051 | 297 | 7 |
821858 | 821858 | 2020-12-12 | McIntosh | North Dakota | 38051 | 297 | 7 |
818612 | 818612 | 2020-12-11 | McIntosh | North Dakota | 38051 | 294 | 7 |
815366 | 815366 | 2020-12-10 | McIntosh | North Dakota | 38051 | 294 | 7 |
812121 | 812121 | 2020-12-09 | McIntosh | North Dakota | 38051 | 292 | 7 |
808876 | 808876 | 2020-12-08 | McIntosh | North Dakota | 38051 | 248 | 7 |
805631 | 805631 | 2020-12-07 | McIntosh | North Dakota | 38051 | 248 | 7 |
802386 | 802386 | 2020-12-06 | McIntosh | North Dakota | 38051 | 248 | 7 |
799141 | 799141 | 2020-12-05 | McIntosh | North Dakota | 38051 | 248 | 7 |
795896 | 795896 | 2020-12-04 | McIntosh | North Dakota | 38051 | 246 | 7 |
792651 | 792651 | 2020-12-03 | McIntosh | North Dakota | 38051 | 244 | 7 |
789406 | 789406 | 2020-12-02 | McIntosh | North Dakota | 38051 | 243 | 7 |
786161 | 786161 | 2020-12-01 | McIntosh | North Dakota | 38051 | 240 | 7 |
782917 | 782917 | 2020-11-30 | McIntosh | North Dakota | 38051 | 240 | 7 |
779671 | 779671 | 2020-11-29 | McIntosh | North Dakota | 38051 | 237 | 7 |
776426 | 776426 | 2020-11-28 | McIntosh | North Dakota | 38051 | 236 | 7 |
773181 | 773181 | 2020-11-27 | McIntosh | North Dakota | 38051 | 236 | 6 |
769936 | 769936 | 2020-11-26 | McIntosh | North Dakota | 38051 | 235 | 6 |
766690 | 766690 | 2020-11-25 | McIntosh | North Dakota | 38051 | 235 | 6 |
763445 | 763445 | 2020-11-24 | McIntosh | North Dakota | 38051 | 232 | 6 |
760200 | 760200 | 2020-11-23 | McIntosh | North Dakota | 38051 | 232 | 6 |
756954 | 756954 | 2020-11-22 | McIntosh | North Dakota | 38051 | 231 | 6 |
753707 | 753707 | 2020-11-21 | McIntosh | North Dakota | 38051 | 230 | 6 |
750461 | 750461 | 2020-11-20 | McIntosh | North Dakota | 38051 | 226 | 6 |
747215 | 747215 | 2020-11-19 | McIntosh | North Dakota | 38051 | 220 | 6 |
743969 | 743969 | 2020-11-18 | McIntosh | North Dakota | 38051 | 220 | 5 |
740722 | 740722 | 2020-11-17 | McIntosh | North Dakota | 38051 | 218 | 5 |
737477 | 737477 | 2020-11-16 | McIntosh | North Dakota | 38051 | 216 | 5 |
734233 | 734233 | 2020-11-15 | McIntosh | North Dakota | 38051 | 210 | 5 |
730987 | 730987 | 2020-11-14 | McIntosh | North Dakota | 38051 | 210 | 5 |
727743 | 727743 | 2020-11-13 | McIntosh | North Dakota | 38051 | 197 | 5 |
724499 | 724499 | 2020-11-12 | McIntosh | North Dakota | 38051 | 194 | 5 |
721256 | 721256 | 2020-11-11 | McIntosh | North Dakota | 38051 | 188 | 5 |
718013 | 718013 | 2020-11-10 | McIntosh | North Dakota | 38051 | 188 | 5 |
714770 | 714770 | 2020-11-09 | McIntosh | North Dakota | 38051 | 188 | 5 |
711526 | 711526 | 2020-11-08 | McIntosh | North Dakota | 38051 | 186 | 5 |
708282 | 708282 | 2020-11-07 | McIntosh | North Dakota | 38051 | 185 | 5 |
705039 | 705039 | 2020-11-06 | McIntosh | North Dakota | 38051 | 183 | 5 |
701796 | 701796 | 2020-11-05 | McIntosh | North Dakota | 38051 | 182 | 5 |
698552 | 698552 | 2020-11-04 | McIntosh | North Dakota | 38051 | 180 | 5 |
695309 | 695309 | 2020-11-03 | McIntosh | North Dakota | 38051 | 180 | 5 |
692067 | 692067 | 2020-11-02 | McIntosh | North Dakota | 38051 | 179 | 5 |
688823 | 688823 | 2020-11-01 | McIntosh | North Dakota | 38051 | 176 | 5 |
685578 | 685578 | 2020-10-31 | McIntosh | North Dakota | 38051 | 174 | 5 |
682335 | 682335 | 2020-10-30 | McIntosh | North Dakota | 38051 | 174 | 5 |
679092 | 679092 | 2020-10-29 | McIntosh | North Dakota | 38051 | 170 | 5 |
675849 | 675849 | 2020-10-28 | McIntosh | North Dakota | 38051 | 169 | 5 |
672606 | 672606 | 2020-10-27 | McIntosh | North Dakota | 38051 | 169 | 5 |
669364 | 669364 | 2020-10-26 | McIntosh | North Dakota | 38051 | 167 | 4 |
666120 | 666120 | 2020-10-25 | McIntosh | North Dakota | 38051 | 166 | 4 |
662875 | 662875 | 2020-10-24 | McIntosh | North Dakota | 38051 | 166 | 4 |
659631 | 659631 | 2020-10-23 | McIntosh | North Dakota | 38051 | 167 | 4 |
656387 | 656387 | 2020-10-22 | McIntosh | North Dakota | 38051 | 161 | 4 |
653142 | 653142 | 2020-10-21 | McIntosh | North Dakota | 38051 | 159 | 4 |
649897 | 649897 | 2020-10-20 | McIntosh | North Dakota | 38051 | 151 | 4 |
646653 | 646653 | 2020-10-19 | McIntosh | North Dakota | 38051 | 145 | 4 |
643407 | 643407 | 2020-10-18 | McIntosh | North Dakota | 38051 | 142 | 4 |
640159 | 640159 | 2020-10-17 | McIntosh | North Dakota | 38051 | 141 | 4 |
636913 | 636913 | 2020-10-16 | McIntosh | North Dakota | 38051 | 138 | 4 |
633667 | 633667 | 2020-10-15 | McIntosh | North Dakota | 38051 | 138 | 4 |
630422 | 630422 | 2020-10-14 | McIntosh | North Dakota | 38051 | 129 | 4 |
627178 | 627178 | 2020-10-13 | McIntosh | North Dakota | 38051 | 122 | 3 |
623936 | 623936 | 2020-10-12 | McIntosh | North Dakota | 38051 | 119 | 3 |
620693 | 620693 | 2020-10-11 | McIntosh | North Dakota | 38051 | 117 | 3 |
617451 | 617451 | 2020-10-10 | McIntosh | North Dakota | 38051 | 112 | 3 |
614209 | 614209 | 2020-10-09 | McIntosh | North Dakota | 38051 | 108 | 3 |
610968 | 610968 | 2020-10-08 | McIntosh | North Dakota | 38051 | 102 | 3 |
607726 | 607726 | 2020-10-07 | McIntosh | North Dakota | 38051 | 101 | 3 |
604483 | 604483 | 2020-10-06 | McIntosh | North Dakota | 38051 | 92 | 3 |
601241 | 601241 | 2020-10-05 | McIntosh | North Dakota | 38051 | 88 | 3 |
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);