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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 38101 674
- 38015 668
- 38017 668
- 38059 667
- 38069 665
- 38071 665
- 38099 662
- 38025 661
- 38031 660
- 38089 660
- 38049 659
- 38051 659
- 38003 657
- 38023 657
- 38055 657
- 38061 657
- 38085 657
- 38035 655
- 38065 655
- 38037 654
- 38053 654
- 38105 654
- 38013 653
- 38027 651
- 38087 651
- 38029 649
- 38011 647
- 38093 646
- 38077 645
- 38081 644
- …
county >30
- Ward 674
- Burleigh 668
- Cass 668
- Morton 667
- Pierce 665
- Ramsey 665
- Walsh 662
- Dunn 661
- Foster 660
- Stark 660
- McHenry 659
- McIntosh 659
- Barnes 657
- Divide 657
- McLean 657
- Mountrail 657
- Sioux 657
- Grand Forks 655
- Oliver 655
- Grant 654
- McKenzie 654
- Williams 654
- Burke 653
- Eddy 651
- Slope 651
- Emmons 649
- Bowman 647
- Stutsman 646
- Richland 645
- Sargent 644
- …
state 1
- North Dakota · 34,019 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111136 | 2111136 | 2022-01-13 | Adams | North Dakota | 38001 | 483 | 9 |
2111137 | 2111137 | 2022-01-13 | Barnes | North Dakota | 38003 | 2373 | 41 |
2111138 | 2111138 | 2022-01-13 | Benson | North Dakota | 38005 | 1548 | 22 |
2111139 | 2111139 | 2022-01-13 | Billings | North Dakota | 38007 | 124 | 1 |
2111140 | 2111140 | 2022-01-13 | Bottineau | North Dakota | 38009 | 1236 | 24 |
2111141 | 2111141 | 2022-01-13 | Bowman | North Dakota | 38011 | 698 | 9 |
2111142 | 2111142 | 2022-01-13 | Burke | North Dakota | 38013 | 376 | 3 |
2111143 | 2111143 | 2022-01-13 | Burleigh | North Dakota | 38015 | 27804 | 286 |
2111144 | 2111144 | 2022-01-13 | Cass | North Dakota | 38017 | 45554 | 293 |
2111145 | 2111145 | 2022-01-13 | Cavalier | North Dakota | 38019 | 632 | 7 |
2111146 | 2111146 | 2022-01-13 | Dickey | North Dakota | 38021 | 1238 | 38 |
2111147 | 2111147 | 2022-01-13 | Divide | North Dakota | 38023 | 360 | 3 |
2111148 | 2111148 | 2022-01-13 | Dunn | North Dakota | 38025 | 893 | 8 |
2111149 | 2111149 | 2022-01-13 | Eddy | North Dakota | 38027 | 649 | 6 |
2111150 | 2111150 | 2022-01-13 | Emmons | North Dakota | 38029 | 631 | 16 |
2111151 | 2111151 | 2022-01-13 | Foster | North Dakota | 38031 | 801 | 20 |
2111152 | 2111152 | 2022-01-13 | Golden Valley | North Dakota | 38033 | 400 | 4 |
2111153 | 2111153 | 2022-01-13 | Grand Forks | North Dakota | 38035 | 16714 | 106 |
2111154 | 2111154 | 2022-01-13 | Grant | North Dakota | 38037 | 421 | 11 |
2111155 | 2111155 | 2022-01-13 | Griggs | North Dakota | 38039 | 499 | 2 |
2111156 | 2111156 | 2022-01-13 | Hettinger | North Dakota | 38041 | 599 | 7 |
2111157 | 2111157 | 2022-01-13 | Kidder | North Dakota | 38043 | 422 | 13 |
2111158 | 2111158 | 2022-01-13 | LaMoure | North Dakota | 38045 | 831 | 18 |
2111159 | 2111159 | 2022-01-13 | Logan | North Dakota | 38047 | 370 | 11 |
2111160 | 2111160 | 2022-01-13 | McHenry | North Dakota | 38049 | 1117 | 28 |
2111161 | 2111161 | 2022-01-13 | McIntosh | North Dakota | 38051 | 570 | 9 |
2111162 | 2111162 | 2022-01-13 | McKenzie | North Dakota | 38053 | 2847 | 23 |
2111163 | 2111163 | 2022-01-13 | McLean | North Dakota | 38055 | 2305 | 47 |
2111164 | 2111164 | 2022-01-13 | Mercer | North Dakota | 38057 | 2083 | 22 |
2111165 | 2111165 | 2022-01-13 | Morton | North Dakota | 38059 | 9207 | 133 |
2111166 | 2111166 | 2022-01-13 | Mountrail | North Dakota | 38061 | 2490 | 32 |
2111167 | 2111167 | 2022-01-13 | Nelson | North Dakota | 38063 | 637 | 17 |
2111168 | 2111168 | 2022-01-13 | Oliver | North Dakota | 38065 | 274 | 4 |
2111169 | 2111169 | 2022-01-13 | Pembina | North Dakota | 38067 | 1608 | 16 |
2111170 | 2111170 | 2022-01-13 | Pierce | North Dakota | 38069 | 914 | 29 |
2111171 | 2111171 | 2022-01-13 | Ramsey | North Dakota | 38071 | 2811 | 47 |
2111172 | 2111172 | 2022-01-13 | Ransom | North Dakota | 38073 | 1151 | 23 |
2111173 | 2111173 | 2022-01-13 | Renville | North Dakota | 38075 | 477 | 15 |
2111174 | 2111174 | 2022-01-13 | Richland | North Dakota | 38077 | 3214 | 21 |
2111175 | 2111175 | 2022-01-13 | Rolette | North Dakota | 38079 | 4348 | 36 |
2111176 | 2111176 | 2022-01-13 | Sargent | North Dakota | 38081 | 826 | 9 |
2111177 | 2111177 | 2022-01-13 | Sheridan | North Dakota | 38083 | 243 | 6 |
2111178 | 2111178 | 2022-01-13 | Sioux | North Dakota | 38085 | 1090 | 18 |
2111179 | 2111179 | 2022-01-13 | Slope | North Dakota | 38087 | 56 | 0 |
2111180 | 2111180 | 2022-01-13 | Stark | North Dakota | 38089 | 9538 | 80 |
2111181 | 2111181 | 2022-01-13 | Steele | North Dakota | 38091 | 319 | 2 |
2111182 | 2111182 | 2022-01-13 | Stutsman | North Dakota | 38093 | 5481 | 92 |
2111183 | 2111183 | 2022-01-13 | Towner | North Dakota | 38095 | 513 | 11 |
2111184 | 2111184 | 2022-01-13 | Traill | North Dakota | 38097 | 1767 | 21 |
2111185 | 2111185 | 2022-01-13 | Unknown | North Dakota | 45 | 45 | |
2111186 | 2111186 | 2022-01-13 | Walsh | North Dakota | 38099 | 2710 | 34 |
2111187 | 2111187 | 2022-01-13 | Ward | North Dakota | 38101 | 16339 | 235 |
2111188 | 2111188 | 2022-01-13 | Wells | North Dakota | 38103 | 897 | 11 |
2111189 | 2111189 | 2022-01-13 | Williams | North Dakota | 38105 | 8656 | 64 |
2107884 | 2107884 | 2022-01-12 | Adams | North Dakota | 38001 | 482 | 9 |
2107885 | 2107885 | 2022-01-12 | Barnes | North Dakota | 38003 | 2347 | 41 |
2107886 | 2107886 | 2022-01-12 | Benson | North Dakota | 38005 | 1536 | 22 |
2107887 | 2107887 | 2022-01-12 | Billings | North Dakota | 38007 | 122 | 1 |
2107888 | 2107888 | 2022-01-12 | Bottineau | North Dakota | 38009 | 1233 | 24 |
2107889 | 2107889 | 2022-01-12 | Bowman | North Dakota | 38011 | 696 | 9 |
2107890 | 2107890 | 2022-01-12 | Burke | North Dakota | 38013 | 374 | 3 |
2107891 | 2107891 | 2022-01-12 | Burleigh | North Dakota | 38015 | 27435 | 286 |
2107892 | 2107892 | 2022-01-12 | Cass | North Dakota | 38017 | 44596 | 292 |
2107893 | 2107893 | 2022-01-12 | Cavalier | North Dakota | 38019 | 628 | 7 |
2107894 | 2107894 | 2022-01-12 | Dickey | North Dakota | 38021 | 1231 | 38 |
2107895 | 2107895 | 2022-01-12 | Divide | North Dakota | 38023 | 355 | 3 |
2107896 | 2107896 | 2022-01-12 | Dunn | North Dakota | 38025 | 887 | 8 |
2107897 | 2107897 | 2022-01-12 | Eddy | North Dakota | 38027 | 644 | 6 |
2107898 | 2107898 | 2022-01-12 | Emmons | North Dakota | 38029 | 627 | 16 |
2107899 | 2107899 | 2022-01-12 | Foster | North Dakota | 38031 | 792 | 19 |
2107900 | 2107900 | 2022-01-12 | Golden Valley | North Dakota | 38033 | 399 | 4 |
2107901 | 2107901 | 2022-01-12 | Grand Forks | North Dakota | 38035 | 16446 | 106 |
2107902 | 2107902 | 2022-01-12 | Grant | North Dakota | 38037 | 419 | 11 |
2107903 | 2107903 | 2022-01-12 | Griggs | North Dakota | 38039 | 492 | 2 |
2107904 | 2107904 | 2022-01-12 | Hettinger | North Dakota | 38041 | 595 | 7 |
2107905 | 2107905 | 2022-01-12 | Kidder | North Dakota | 38043 | 420 | 13 |
2107906 | 2107906 | 2022-01-12 | LaMoure | North Dakota | 38045 | 821 | 18 |
2107907 | 2107907 | 2022-01-12 | Logan | North Dakota | 38047 | 368 | 11 |
2107908 | 2107908 | 2022-01-12 | McHenry | North Dakota | 38049 | 1107 | 28 |
2107909 | 2107909 | 2022-01-12 | McIntosh | North Dakota | 38051 | 565 | 9 |
2107910 | 2107910 | 2022-01-12 | McKenzie | North Dakota | 38053 | 2834 | 23 |
2107911 | 2107911 | 2022-01-12 | McLean | North Dakota | 38055 | 2293 | 47 |
2107912 | 2107912 | 2022-01-12 | Mercer | North Dakota | 38057 | 2065 | 22 |
2107913 | 2107913 | 2022-01-12 | Morton | North Dakota | 38059 | 9103 | 133 |
2107914 | 2107914 | 2022-01-12 | Mountrail | North Dakota | 38061 | 2450 | 32 |
2107915 | 2107915 | 2022-01-12 | Nelson | North Dakota | 38063 | 631 | 17 |
2107916 | 2107916 | 2022-01-12 | Oliver | North Dakota | 38065 | 270 | 4 |
2107917 | 2107917 | 2022-01-12 | Pembina | North Dakota | 38067 | 1588 | 16 |
2107918 | 2107918 | 2022-01-12 | Pierce | North Dakota | 38069 | 905 | 29 |
2107919 | 2107919 | 2022-01-12 | Ramsey | North Dakota | 38071 | 2782 | 47 |
2107920 | 2107920 | 2022-01-12 | Ransom | North Dakota | 38073 | 1140 | 23 |
2107921 | 2107921 | 2022-01-12 | Renville | North Dakota | 38075 | 473 | 15 |
2107922 | 2107922 | 2022-01-12 | Richland | North Dakota | 38077 | 3172 | 21 |
2107923 | 2107923 | 2022-01-12 | Rolette | North Dakota | 38079 | 4270 | 36 |
2107924 | 2107924 | 2022-01-12 | Sargent | North Dakota | 38081 | 816 | 9 |
2107925 | 2107925 | 2022-01-12 | Sheridan | North Dakota | 38083 | 243 | 6 |
2107926 | 2107926 | 2022-01-12 | Sioux | North Dakota | 38085 | 1079 | 18 |
2107927 | 2107927 | 2022-01-12 | Slope | North Dakota | 38087 | 56 | 0 |
2107928 | 2107928 | 2022-01-12 | Stark | North Dakota | 38089 | 9459 | 80 |
2107929 | 2107929 | 2022-01-12 | Steele | North Dakota | 38091 | 313 | 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);