ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40,499 rows where state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 38101 794
- 38015 788
- 38017 788
- 38059 787
- 38069 785
- 38071 785
- 38099 782
- 38025 781
- 38031 780
- 38089 780
- 38049 779
- 38051 779
- 38003 777
- 38023 777
- 38055 777
- 38061 777
- 38085 777
- 38035 775
- 38065 775
- 38037 774
- 38053 774
- 38105 774
- 38013 773
- 38027 771
- 38087 771
- 38029 769
- 38011 767
- 38093 766
- 38077 765
- 38081 764
- …
county >30
- Ward 794
- Burleigh 788
- Cass 788
- Morton 787
- Pierce 785
- Ramsey 785
- Walsh 782
- Dunn 781
- Foster 780
- Stark 780
- McHenry 779
- McIntosh 779
- Barnes 777
- Divide 777
- McLean 777
- Mountrail 777
- Sioux 777
- Grand Forks 775
- Oliver 775
- Grant 774
- McKenzie 774
- Williams 774
- Burke 773
- Eddy 771
- Slope 771
- Emmons 769
- Bowman 767
- Stutsman 766
- Richland 765
- Sargent 764
- …
state 1
- North Dakota · 40,399 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
701771 | 701771 | 2020-11-05 | Adams | North Dakota | 38001 | 109 | 0 |
705014 | 705014 | 2020-11-06 | Adams | North Dakota | 38001 | 109 | 0 |
708257 | 708257 | 2020-11-07 | Adams | North Dakota | 38001 | 114 | 0 |
711501 | 711501 | 2020-11-08 | Adams | North Dakota | 38001 | 115 | 0 |
714745 | 714745 | 2020-11-09 | Adams | North Dakota | 38001 | 116 | 0 |
717988 | 717988 | 2020-11-10 | Adams | North Dakota | 38001 | 119 | 0 |
721231 | 721231 | 2020-11-11 | Adams | North Dakota | 38001 | 119 | 0 |
724474 | 724474 | 2020-11-12 | Adams | North Dakota | 38001 | 123 | 0 |
727718 | 727718 | 2020-11-13 | Adams | North Dakota | 38001 | 124 | 0 |
730962 | 730962 | 2020-11-14 | Adams | North Dakota | 38001 | 129 | 0 |
734208 | 734208 | 2020-11-15 | Adams | North Dakota | 38001 | 130 | 0 |
737452 | 737452 | 2020-11-16 | Adams | North Dakota | 38001 | 132 | 0 |
740697 | 740697 | 2020-11-17 | Adams | North Dakota | 38001 | 135 | 0 |
743944 | 743944 | 2020-11-18 | Adams | North Dakota | 38001 | 143 | 0 |
747190 | 747190 | 2020-11-19 | Adams | North Dakota | 38001 | 146 | 0 |
750436 | 750436 | 2020-11-20 | Adams | North Dakota | 38001 | 149 | 0 |
753682 | 753682 | 2020-11-21 | Adams | North Dakota | 38001 | 155 | 0 |
756929 | 756929 | 2020-11-22 | Adams | North Dakota | 38001 | 157 | 0 |
760175 | 760175 | 2020-11-23 | Adams | North Dakota | 38001 | 157 | 0 |
763420 | 763420 | 2020-11-24 | Adams | North Dakota | 38001 | 158 | 0 |
766665 | 766665 | 2020-11-25 | Adams | North Dakota | 38001 | 160 | 0 |
769911 | 769911 | 2020-11-26 | Adams | North Dakota | 38001 | 162 | 0 |
773156 | 773156 | 2020-11-27 | Adams | North Dakota | 38001 | 165 | 0 |
776401 | 776401 | 2020-11-28 | Adams | North Dakota | 38001 | 169 | 0 |
779646 | 779646 | 2020-11-29 | Adams | North Dakota | 38001 | 173 | 0 |
782892 | 782892 | 2020-11-30 | Adams | North Dakota | 38001 | 175 | 0 |
786136 | 786136 | 2020-12-01 | Adams | North Dakota | 38001 | 177 | 0 |
789381 | 789381 | 2020-12-02 | Adams | North Dakota | 38001 | 177 | 0 |
792626 | 792626 | 2020-12-03 | Adams | North Dakota | 38001 | 183 | 0 |
795871 | 795871 | 2020-12-04 | Adams | North Dakota | 38001 | 182 | 0 |
799116 | 799116 | 2020-12-05 | Adams | North Dakota | 38001 | 183 | 0 |
802361 | 802361 | 2020-12-06 | Adams | North Dakota | 38001 | 184 | 0 |
805606 | 805606 | 2020-12-07 | Adams | North Dakota | 38001 | 187 | 0 |
808851 | 808851 | 2020-12-08 | Adams | North Dakota | 38001 | 187 | 0 |
812096 | 812096 | 2020-12-09 | Adams | North Dakota | 38001 | 187 | 0 |
815341 | 815341 | 2020-12-10 | Adams | North Dakota | 38001 | 188 | 0 |
818587 | 818587 | 2020-12-11 | Adams | North Dakota | 38001 | 188 | 0 |
821833 | 821833 | 2020-12-12 | Adams | North Dakota | 38001 | 189 | 0 |
825080 | 825080 | 2020-12-13 | Adams | North Dakota | 38001 | 190 | 0 |
828326 | 828326 | 2020-12-14 | Adams | North Dakota | 38001 | 190 | 1 |
831573 | 831573 | 2020-12-15 | Adams | North Dakota | 38001 | 190 | 1 |
834819 | 834819 | 2020-12-16 | Adams | North Dakota | 38001 | 189 | 2 |
838065 | 838065 | 2020-12-17 | Adams | North Dakota | 38001 | 190 | 2 |
841310 | 841310 | 2020-12-18 | Adams | North Dakota | 38001 | 194 | 2 |
844556 | 844556 | 2020-12-19 | Adams | North Dakota | 38001 | 194 | 2 |
847801 | 847801 | 2020-12-20 | Adams | North Dakota | 38001 | 194 | 2 |
851046 | 851046 | 2020-12-21 | Adams | North Dakota | 38001 | 194 | 2 |
854291 | 854291 | 2020-12-22 | Adams | North Dakota | 38001 | 190 | 2 |
857536 | 857536 | 2020-12-23 | Adams | North Dakota | 38001 | 190 | 2 |
860781 | 860781 | 2020-12-24 | Adams | North Dakota | 38001 | 190 | 2 |
864026 | 864026 | 2020-12-25 | Adams | North Dakota | 38001 | 190 | 2 |
867271 | 867271 | 2020-12-26 | Adams | North Dakota | 38001 | 190 | 2 |
870516 | 870516 | 2020-12-27 | Adams | North Dakota | 38001 | 190 | 2 |
873761 | 873761 | 2020-12-28 | Adams | North Dakota | 38001 | 190 | 2 |
877006 | 877006 | 2020-12-29 | Adams | North Dakota | 38001 | 190 | 2 |
880251 | 880251 | 2020-12-30 | Adams | North Dakota | 38001 | 190 | 2 |
883496 | 883496 | 2020-12-31 | Adams | North Dakota | 38001 | 190 | 2 |
886741 | 886741 | 2021-01-01 | Adams | North Dakota | 38001 | 190 | 2 |
889988 | 889988 | 2021-01-02 | Adams | North Dakota | 38001 | 190 | 2 |
893234 | 893234 | 2021-01-03 | Adams | North Dakota | 38001 | 190 | 2 |
896480 | 896480 | 2021-01-04 | Adams | North Dakota | 38001 | 192 | 2 |
899725 | 899725 | 2021-01-05 | Adams | North Dakota | 38001 | 192 | 2 |
902970 | 902970 | 2021-01-06 | Adams | North Dakota | 38001 | 193 | 2 |
906216 | 906216 | 2021-01-07 | Adams | North Dakota | 38001 | 195 | 2 |
909461 | 909461 | 2021-01-08 | Adams | North Dakota | 38001 | 198 | 2 |
912706 | 912706 | 2021-01-09 | Adams | North Dakota | 38001 | 203 | 2 |
915951 | 915951 | 2021-01-10 | Adams | North Dakota | 38001 | 209 | 2 |
919196 | 919196 | 2021-01-11 | Adams | North Dakota | 38001 | 212 | 2 |
922441 | 922441 | 2021-01-12 | Adams | North Dakota | 38001 | 212 | 2 |
925687 | 925687 | 2021-01-13 | Adams | North Dakota | 38001 | 216 | 2 |
928932 | 928932 | 2021-01-14 | Adams | North Dakota | 38001 | 220 | 2 |
932177 | 932177 | 2021-01-15 | Adams | North Dakota | 38001 | 223 | 2 |
935422 | 935422 | 2021-01-16 | Adams | North Dakota | 38001 | 229 | 2 |
938667 | 938667 | 2021-01-17 | Adams | North Dakota | 38001 | 235 | 2 |
941912 | 941912 | 2021-01-18 | Adams | North Dakota | 38001 | 235 | 2 |
945159 | 945159 | 2021-01-19 | Adams | North Dakota | 38001 | 240 | 2 |
948405 | 948405 | 2021-01-20 | Adams | North Dakota | 38001 | 241 | 2 |
951650 | 951650 | 2021-01-21 | Adams | North Dakota | 38001 | 244 | 2 |
954895 | 954895 | 2021-01-22 | Adams | North Dakota | 38001 | 247 | 2 |
958141 | 958141 | 2021-01-23 | Adams | North Dakota | 38001 | 252 | 2 |
961386 | 961386 | 2021-01-24 | Adams | North Dakota | 38001 | 252 | 2 |
964631 | 964631 | 2021-01-25 | Adams | North Dakota | 38001 | 254 | 2 |
967875 | 967875 | 2021-01-26 | Adams | North Dakota | 38001 | 254 | 2 |
971120 | 971120 | 2021-01-27 | Adams | North Dakota | 38001 | 254 | 2 |
974365 | 974365 | 2021-01-28 | Adams | North Dakota | 38001 | 257 | 2 |
977610 | 977610 | 2021-01-29 | Adams | North Dakota | 38001 | 258 | 2 |
980856 | 980856 | 2021-01-30 | Adams | North Dakota | 38001 | 259 | 2 |
984103 | 984103 | 2021-01-31 | Adams | North Dakota | 38001 | 259 | 2 |
987350 | 987350 | 2021-02-01 | Adams | North Dakota | 38001 | 259 | 2 |
990596 | 990596 | 2021-02-02 | Adams | North Dakota | 38001 | 258 | 2 |
993842 | 993842 | 2021-02-03 | Adams | North Dakota | 38001 | 261 | 2 |
997088 | 997088 | 2021-02-04 | Adams | North Dakota | 38001 | 261 | 2 |
1000334 | 1000334 | 2021-02-05 | Adams | North Dakota | 38001 | 263 | 2 |
1003580 | 1003580 | 2021-02-06 | Adams | North Dakota | 38001 | 264 | 2 |
1006826 | 1006826 | 2021-02-07 | Adams | North Dakota | 38001 | 264 | 2 |
1010072 | 1010072 | 2021-02-08 | Adams | North Dakota | 38001 | 264 | 2 |
1013317 | 1013317 | 2021-02-09 | Adams | North Dakota | 38001 | 264 | 2 |
1016562 | 1016562 | 2021-02-10 | Adams | North Dakota | 38001 | 263 | 2 |
1019807 | 1019807 | 2021-02-11 | Adams | North Dakota | 38001 | 263 | 2 |
1023052 | 1023052 | 2021-02-12 | Adams | North Dakota | 38001 | 264 | 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);