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 220
- 38015 214
- 38017 214
- 38059 213
- 38069 211
- 38071 211
- 38099 208
- 38025 207
- 38031 206
- 38089 206
- 38049 205
- 38051 205
- 38003 203
- 38023 203
- 38055 203
- 38061 203
- 38085 203
- 38035 201
- 38065 201
- 38037 200
- 38053 200
- 38105 200
- 38013 199
- 38027 197
- 38087 197
- 38029 195
- 38011 193
- 38093 192
- 38077 191
- 38081 190
- …
county >30
- Ward 220
- Burleigh 214
- Cass 214
- Morton 213
- Pierce 211
- Ramsey 211
- Walsh 208
- Dunn 207
- Foster 206
- Stark 206
- McHenry 205
- McIntosh 205
- Barnes 203
- Divide 203
- McLean 203
- Mountrail 203
- Sioux 203
- Grand Forks 201
- Oliver 201
- Grant 200
- McKenzie 200
- Williams 200
- Burke 199
- Eddy 197
- Slope 197
- Emmons 195
- Bowman 193
- Stutsman 192
- Richland 191
- Sargent 190
- …
state 1
- North Dakota · 9,504 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636888 | 636888 | 2020-10-16 | Adams | North Dakota | 38001 | 49 | 0 |
636889 | 636889 | 2020-10-16 | Barnes | North Dakota | 38003 | 280 | 1 |
636890 | 636890 | 2020-10-16 | Benson | North Dakota | 38005 | 439 | 8 |
636891 | 636891 | 2020-10-16 | Billings | North Dakota | 38007 | 31 | 0 |
636892 | 636892 | 2020-10-16 | Bottineau | North Dakota | 38009 | 171 | 16 |
636893 | 636893 | 2020-10-16 | Bowman | North Dakota | 38011 | 94 | 2 |
636894 | 636894 | 2020-10-16 | Burke | North Dakota | 38013 | 45 | 1 |
636895 | 636895 | 2020-10-16 | Burleigh | North Dakota | 38015 | 5211 | 68 |
636896 | 636896 | 2020-10-16 | Cass | North Dakota | 38017 | 7231 | 79 |
636897 | 636897 | 2020-10-16 | Cavalier | North Dakota | 38019 | 59 | 1 |
636898 | 636898 | 2020-10-16 | Dickey | North Dakota | 38021 | 193 | 0 |
636899 | 636899 | 2020-10-16 | Divide | North Dakota | 38023 | 37 | 1 |
636900 | 636900 | 2020-10-16 | Dunn | North Dakota | 38025 | 188 | 4 |
636901 | 636901 | 2020-10-16 | Eddy | North Dakota | 38027 | 145 | 3 |
636902 | 636902 | 2020-10-16 | Emmons | North Dakota | 38029 | 259 | 7 |
636903 | 636903 | 2020-10-16 | Foster | North Dakota | 38031 | 124 | 1 |
636904 | 636904 | 2020-10-16 | Golden Valley | North Dakota | 38033 | 100 | 0 |
636905 | 636905 | 2020-10-16 | Grand Forks | North Dakota | 38035 | 2930 | 15 |
636906 | 636906 | 2020-10-16 | Grant | North Dakota | 38037 | 55 | 1 |
636907 | 636907 | 2020-10-16 | Griggs | North Dakota | 38039 | 67 | 1 |
636908 | 636908 | 2020-10-16 | Hettinger | North Dakota | 38041 | 91 | 1 |
636909 | 636909 | 2020-10-16 | Kidder | North Dakota | 38043 | 72 | 1 |
636910 | 636910 | 2020-10-16 | LaMoure | North Dakota | 38045 | 156 | 3 |
636911 | 636911 | 2020-10-16 | Logan | North Dakota | 38047 | 103 | 0 |
636912 | 636912 | 2020-10-16 | McHenry | North Dakota | 38049 | 134 | 11 |
636913 | 636913 | 2020-10-16 | McIntosh | North Dakota | 38051 | 138 | 4 |
636914 | 636914 | 2020-10-16 | McKenzie | North Dakota | 38053 | 400 | 3 |
636915 | 636915 | 2020-10-16 | McLean | North Dakota | 38055 | 411 | 6 |
636916 | 636916 | 2020-10-16 | Mercer | North Dakota | 38057 | 337 | 3 |
636917 | 636917 | 2020-10-16 | Morton | North Dakota | 38059 | 1824 | 46 |
636918 | 636918 | 2020-10-16 | Mountrail | North Dakota | 38061 | 390 | 6 |
636919 | 636919 | 2020-10-16 | Nelson | North Dakota | 38063 | 138 | 3 |
636920 | 636920 | 2020-10-16 | Oliver | North Dakota | 38065 | 60 | 0 |
636921 | 636921 | 2020-10-16 | Pembina | North Dakota | 38067 | 157 | 0 |
636922 | 636922 | 2020-10-16 | Pierce | North Dakota | 38069 | 45 | 0 |
636923 | 636923 | 2020-10-16 | Ramsey | North Dakota | 38071 | 383 | 3 |
636924 | 636924 | 2020-10-16 | Ransom | North Dakota | 38073 | 119 | 0 |
636925 | 636925 | 2020-10-16 | Renville | North Dakota | 38075 | 94 | 2 |
636926 | 636926 | 2020-10-16 | Richland | North Dakota | 38077 | 319 | 2 |
636927 | 636927 | 2020-10-16 | Rolette | North Dakota | 38079 | 270 | 7 |
636928 | 636928 | 2020-10-16 | Sargent | North Dakota | 38081 | 105 | 2 |
636929 | 636929 | 2020-10-16 | Sheridan | North Dakota | 38083 | 28 | 1 |
636930 | 636930 | 2020-10-16 | Sioux | North Dakota | 38085 | 216 | 3 |
636931 | 636931 | 2020-10-16 | Slope | North Dakota | 38087 | 12 | 0 |
636932 | 636932 | 2020-10-16 | Stark | North Dakota | 38089 | 2131 | 28 |
636933 | 636933 | 2020-10-16 | Steele | North Dakota | 38091 | 31 | 0 |
636934 | 636934 | 2020-10-16 | Stutsman | North Dakota | 38093 | 668 | 4 |
636935 | 636935 | 2020-10-16 | Towner | North Dakota | 38095 | 67 | 1 |
636936 | 636936 | 2020-10-16 | Traill | North Dakota | 38097 | 187 | 2 |
636937 | 636937 | 2020-10-16 | Unknown | North Dakota | 5 | 5 | |
636938 | 636938 | 2020-10-16 | Walsh | North Dakota | 38099 | 306 | 2 |
636939 | 636939 | 2020-10-16 | Ward | North Dakota | 38101 | 1801 | 24 |
636940 | 636940 | 2020-10-16 | Wells | North Dakota | 38103 | 66 | 0 |
636941 | 636941 | 2020-10-16 | Williams | North Dakota | 38105 | 1550 | 11 |
633642 | 633642 | 2020-10-15 | Adams | North Dakota | 38001 | 49 | 0 |
633643 | 633643 | 2020-10-15 | Barnes | North Dakota | 38003 | 276 | 1 |
633644 | 633644 | 2020-10-15 | Benson | North Dakota | 38005 | 424 | 8 |
633645 | 633645 | 2020-10-15 | Billings | North Dakota | 38007 | 30 | 0 |
633646 | 633646 | 2020-10-15 | Bottineau | North Dakota | 38009 | 168 | 14 |
633647 | 633647 | 2020-10-15 | Bowman | North Dakota | 38011 | 92 | 2 |
633648 | 633648 | 2020-10-15 | Burke | North Dakota | 38013 | 45 | 1 |
633649 | 633649 | 2020-10-15 | Burleigh | North Dakota | 38015 | 5105 | 64 |
633650 | 633650 | 2020-10-15 | Cass | North Dakota | 38017 | 7011 | 78 |
633651 | 633651 | 2020-10-15 | Cavalier | North Dakota | 38019 | 59 | 1 |
633652 | 633652 | 2020-10-15 | Dickey | North Dakota | 38021 | 193 | 0 |
633653 | 633653 | 2020-10-15 | Divide | North Dakota | 38023 | 34 | 1 |
633654 | 633654 | 2020-10-15 | Dunn | North Dakota | 38025 | 185 | 4 |
633655 | 633655 | 2020-10-15 | Eddy | North Dakota | 38027 | 142 | 3 |
633656 | 633656 | 2020-10-15 | Emmons | North Dakota | 38029 | 260 | 7 |
633657 | 633657 | 2020-10-15 | Foster | North Dakota | 38031 | 121 | 1 |
633658 | 633658 | 2020-10-15 | Golden Valley | North Dakota | 38033 | 100 | 0 |
633659 | 633659 | 2020-10-15 | Grand Forks | North Dakota | 38035 | 2817 | 14 |
633660 | 633660 | 2020-10-15 | Grant | North Dakota | 38037 | 54 | 1 |
633661 | 633661 | 2020-10-15 | Griggs | North Dakota | 38039 | 66 | 1 |
633662 | 633662 | 2020-10-15 | Hettinger | North Dakota | 38041 | 89 | 1 |
633663 | 633663 | 2020-10-15 | Kidder | North Dakota | 38043 | 71 | 1 |
633664 | 633664 | 2020-10-15 | LaMoure | North Dakota | 38045 | 154 | 3 |
633665 | 633665 | 2020-10-15 | Logan | North Dakota | 38047 | 102 | 0 |
633666 | 633666 | 2020-10-15 | McHenry | North Dakota | 38049 | 126 | 9 |
633667 | 633667 | 2020-10-15 | McIntosh | North Dakota | 38051 | 138 | 4 |
633668 | 633668 | 2020-10-15 | McKenzie | North Dakota | 38053 | 388 | 3 |
633669 | 633669 | 2020-10-15 | McLean | North Dakota | 38055 | 398 | 5 |
633670 | 633670 | 2020-10-15 | Mercer | North Dakota | 38057 | 321 | 3 |
633671 | 633671 | 2020-10-15 | Morton | North Dakota | 38059 | 1796 | 45 |
633672 | 633672 | 2020-10-15 | Mountrail | North Dakota | 38061 | 377 | 6 |
633673 | 633673 | 2020-10-15 | Nelson | North Dakota | 38063 | 136 | 3 |
633674 | 633674 | 2020-10-15 | Oliver | North Dakota | 38065 | 56 | 0 |
633675 | 633675 | 2020-10-15 | Pembina | North Dakota | 38067 | 151 | 0 |
633676 | 633676 | 2020-10-15 | Pierce | North Dakota | 38069 | 44 | 0 |
633677 | 633677 | 2020-10-15 | Ramsey | North Dakota | 38071 | 361 | 3 |
633678 | 633678 | 2020-10-15 | Ransom | North Dakota | 38073 | 114 | 0 |
633679 | 633679 | 2020-10-15 | Renville | North Dakota | 38075 | 94 | 2 |
633680 | 633680 | 2020-10-15 | Richland | North Dakota | 38077 | 307 | 2 |
633681 | 633681 | 2020-10-15 | Rolette | North Dakota | 38079 | 264 | 7 |
633682 | 633682 | 2020-10-15 | Sargent | North Dakota | 38081 | 103 | 2 |
633683 | 633683 | 2020-10-15 | Sheridan | North Dakota | 38083 | 25 | 1 |
633684 | 633684 | 2020-10-15 | Sioux | North Dakota | 38085 | 211 | 3 |
633685 | 633685 | 2020-10-15 | Slope | North Dakota | 38087 | 11 | 0 |
633686 | 633686 | 2020-10-15 | Stark | North Dakota | 38089 | 2105 | 25 |
633687 | 633687 | 2020-10-15 | Steele | North Dakota | 38091 | 31 | 0 |
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);