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 265
- 38015 259
- 38017 259
- 38059 258
- 38069 256
- 38071 256
- 38099 253
- 38025 252
- 38031 251
- 38089 251
- 38049 250
- 38051 250
- 38003 248
- 38023 248
- 38055 248
- 38061 248
- 38085 248
- 38035 246
- 38065 246
- 38037 245
- 38053 245
- 38105 245
- 38013 244
- 38027 242
- 38087 242
- 38029 240
- 38011 238
- 38093 237
- 38077 236
- 38081 235
- …
county >30
- Ward 265
- Burleigh 259
- Cass 259
- Morton 258
- Pierce 256
- Ramsey 256
- Walsh 253
- Dunn 252
- Foster 251
- Stark 251
- McHenry 250
- McIntosh 250
- Barnes 248
- Divide 248
- McLean 248
- Mountrail 248
- Sioux 248
- Grand Forks 246
- Oliver 246
- Grant 245
- McKenzie 245
- Williams 245
- Burke 244
- Eddy 242
- Slope 242
- Emmons 240
- Bowman 238
- Stutsman 237
- Richland 236
- Sargent 235
- …
state 1
- North Dakota · 11,934 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782892 | 782892 | 2020-11-30 | Adams | North Dakota | 38001 | 175 | 0 |
782893 | 782893 | 2020-11-30 | Barnes | North Dakota | 38003 | 1034 | 14 |
782894 | 782894 | 2020-11-30 | Benson | North Dakota | 38005 | 779 | 14 |
782895 | 782895 | 2020-11-30 | Billings | North Dakota | 38007 | 41 | 0 |
782896 | 782896 | 2020-11-30 | Bottineau | North Dakota | 38009 | 551 | 19 |
782897 | 782897 | 2020-11-30 | Bowman | North Dakota | 38011 | 188 | 3 |
782898 | 782898 | 2020-11-30 | Burke | North Dakota | 38013 | 179 | 1 |
782899 | 782899 | 2020-11-30 | Burleigh | North Dakota | 38015 | 12007 | 121 |
782900 | 782900 | 2020-11-30 | Cass | North Dakota | 38017 | 16788 | 126 |
782901 | 782901 | 2020-11-30 | Cavalier | North Dakota | 38019 | 375 | 2 |
782902 | 782902 | 2020-11-30 | Dickey | North Dakota | 38021 | 543 | 28 |
782903 | 782903 | 2020-11-30 | Divide | North Dakota | 38023 | 126 | 1 |
782904 | 782904 | 2020-11-30 | Dunn | North Dakota | 38025 | 303 | 6 |
782905 | 782905 | 2020-11-30 | Eddy | North Dakota | 38027 | 362 | 4 |
782906 | 782906 | 2020-11-30 | Emmons | North Dakota | 38029 | 351 | 9 |
782907 | 782907 | 2020-11-30 | Foster | North Dakota | 38031 | 495 | 13 |
782908 | 782908 | 2020-11-30 | Golden Valley | North Dakota | 38033 | 161 | 0 |
782909 | 782909 | 2020-11-30 | Grand Forks | North Dakota | 38035 | 8170 | 44 |
782910 | 782910 | 2020-11-30 | Grant | North Dakota | 38037 | 154 | 5 |
782911 | 782911 | 2020-11-30 | Griggs | North Dakota | 38039 | 253 | 1 |
782912 | 782912 | 2020-11-30 | Hettinger | North Dakota | 38041 | 240 | 3 |
782913 | 782913 | 2020-11-30 | Kidder | North Dakota | 38043 | 209 | 6 |
782914 | 782914 | 2020-11-30 | LaMoure | North Dakota | 38045 | 377 | 15 |
782915 | 782915 | 2020-11-30 | Logan | North Dakota | 38047 | 159 | 6 |
782916 | 782916 | 2020-11-30 | McHenry | North Dakota | 38049 | 457 | 17 |
782917 | 782917 | 2020-11-30 | McIntosh | North Dakota | 38051 | 240 | 7 |
782918 | 782918 | 2020-11-30 | McKenzie | North Dakota | 38053 | 883 | 7 |
782919 | 782919 | 2020-11-30 | McLean | North Dakota | 38055 | 994 | 15 |
782920 | 782920 | 2020-11-30 | Mercer | North Dakota | 38057 | 871 | 5 |
782921 | 782921 | 2020-11-30 | Morton | North Dakota | 38059 | 4056 | 69 |
782922 | 782922 | 2020-11-30 | Mountrail | North Dakota | 38061 | 1066 | 13 |
782923 | 782923 | 2020-11-30 | Nelson | North Dakota | 38063 | 359 | 10 |
782924 | 782924 | 2020-11-30 | Oliver | North Dakota | 38065 | 126 | 2 |
782925 | 782925 | 2020-11-30 | Pembina | North Dakota | 38067 | 626 | 6 |
782926 | 782926 | 2020-11-30 | Pierce | North Dakota | 38069 | 426 | 7 |
782927 | 782927 | 2020-11-30 | Ramsey | North Dakota | 38071 | 1167 | 8 |
782928 | 782928 | 2020-11-30 | Ransom | North Dakota | 38073 | 454 | 8 |
782929 | 782929 | 2020-11-30 | Renville | North Dakota | 38075 | 250 | 2 |
782930 | 782930 | 2020-11-30 | Richland | North Dakota | 38077 | 1157 | 11 |
782931 | 782931 | 2020-11-30 | Rolette | North Dakota | 38079 | 1437 | 15 |
782932 | 782932 | 2020-11-30 | Sargent | North Dakota | 38081 | 318 | 4 |
782933 | 782933 | 2020-11-30 | Sheridan | North Dakota | 38083 | 78 | 1 |
782934 | 782934 | 2020-11-30 | Sioux | North Dakota | 38085 | 497 | 7 |
782935 | 782935 | 2020-11-30 | Slope | North Dakota | 38087 | 19 | 0 |
782936 | 782936 | 2020-11-30 | Stark | North Dakota | 38089 | 3612 | 39 |
782937 | 782937 | 2020-11-30 | Steele | North Dakota | 38091 | 134 | 1 |
782938 | 782938 | 2020-11-30 | Stutsman | North Dakota | 38093 | 2624 | 42 |
782939 | 782939 | 2020-11-30 | Towner | North Dakota | 38095 | 215 | 9 |
782940 | 782940 | 2020-11-30 | Traill | North Dakota | 38097 | 747 | 10 |
782941 | 782941 | 2020-11-30 | Unknown | North Dakota | 6 | 6 | |
782942 | 782942 | 2020-11-30 | Walsh | North Dakota | 38099 | 1449 | 14 |
782943 | 782943 | 2020-11-30 | Ward | North Dakota | 38101 | 7623 | 131 |
782944 | 782944 | 2020-11-30 | Wells | North Dakota | 38103 | 307 | 3 |
782945 | 782945 | 2020-11-30 | Williams | North Dakota | 38105 | 3040 | 23 |
779646 | 779646 | 2020-11-29 | Adams | North Dakota | 38001 | 173 | 0 |
779647 | 779647 | 2020-11-29 | Barnes | North Dakota | 38003 | 1029 | 14 |
779648 | 779648 | 2020-11-29 | Benson | North Dakota | 38005 | 769 | 14 |
779649 | 779649 | 2020-11-29 | Billings | North Dakota | 38007 | 41 | 0 |
779650 | 779650 | 2020-11-29 | Bottineau | North Dakota | 38009 | 540 | 19 |
779651 | 779651 | 2020-11-29 | Bowman | North Dakota | 38011 | 187 | 3 |
779652 | 779652 | 2020-11-29 | Burke | North Dakota | 38013 | 179 | 1 |
779653 | 779653 | 2020-11-29 | Burleigh | North Dakota | 38015 | 11933 | 121 |
779654 | 779654 | 2020-11-29 | Cass | North Dakota | 38017 | 16600 | 126 |
779655 | 779655 | 2020-11-29 | Cavalier | North Dakota | 38019 | 369 | 2 |
779656 | 779656 | 2020-11-29 | Dickey | North Dakota | 38021 | 542 | 28 |
779657 | 779657 | 2020-11-29 | Divide | North Dakota | 38023 | 126 | 1 |
779658 | 779658 | 2020-11-29 | Dunn | North Dakota | 38025 | 299 | 6 |
779659 | 779659 | 2020-11-29 | Eddy | North Dakota | 38027 | 360 | 4 |
779660 | 779660 | 2020-11-29 | Emmons | North Dakota | 38029 | 351 | 9 |
779661 | 779661 | 2020-11-29 | Foster | North Dakota | 38031 | 493 | 12 |
779662 | 779662 | 2020-11-29 | Golden Valley | North Dakota | 38033 | 159 | 0 |
779663 | 779663 | 2020-11-29 | Grand Forks | North Dakota | 38035 | 8144 | 43 |
779664 | 779664 | 2020-11-29 | Grant | North Dakota | 38037 | 154 | 5 |
779665 | 779665 | 2020-11-29 | Griggs | North Dakota | 38039 | 251 | 1 |
779666 | 779666 | 2020-11-29 | Hettinger | North Dakota | 38041 | 239 | 3 |
779667 | 779667 | 2020-11-29 | Kidder | North Dakota | 38043 | 205 | 6 |
779668 | 779668 | 2020-11-29 | LaMoure | North Dakota | 38045 | 376 | 15 |
779669 | 779669 | 2020-11-29 | Logan | North Dakota | 38047 | 158 | 6 |
779670 | 779670 | 2020-11-29 | McHenry | North Dakota | 38049 | 456 | 17 |
779671 | 779671 | 2020-11-29 | McIntosh | North Dakota | 38051 | 237 | 7 |
779672 | 779672 | 2020-11-29 | McKenzie | North Dakota | 38053 | 881 | 7 |
779673 | 779673 | 2020-11-29 | McLean | North Dakota | 38055 | 983 | 15 |
779674 | 779674 | 2020-11-29 | Mercer | North Dakota | 38057 | 865 | 5 |
779675 | 779675 | 2020-11-29 | Morton | North Dakota | 38059 | 4021 | 68 |
779676 | 779676 | 2020-11-29 | Mountrail | North Dakota | 38061 | 1065 | 13 |
779677 | 779677 | 2020-11-29 | Nelson | North Dakota | 38063 | 357 | 10 |
779678 | 779678 | 2020-11-29 | Oliver | North Dakota | 38065 | 125 | 2 |
779679 | 779679 | 2020-11-29 | Pembina | North Dakota | 38067 | 619 | 5 |
779680 | 779680 | 2020-11-29 | Pierce | North Dakota | 38069 | 424 | 7 |
779681 | 779681 | 2020-11-29 | Ramsey | North Dakota | 38071 | 1131 | 8 |
779682 | 779682 | 2020-11-29 | Ransom | North Dakota | 38073 | 447 | 8 |
779683 | 779683 | 2020-11-29 | Renville | North Dakota | 38075 | 247 | 2 |
779684 | 779684 | 2020-11-29 | Richland | North Dakota | 38077 | 1137 | 11 |
779685 | 779685 | 2020-11-29 | Rolette | North Dakota | 38079 | 1425 | 15 |
779686 | 779686 | 2020-11-29 | Sargent | North Dakota | 38081 | 315 | 4 |
779687 | 779687 | 2020-11-29 | Sheridan | North Dakota | 38083 | 78 | 1 |
779688 | 779688 | 2020-11-29 | Sioux | North Dakota | 38085 | 495 | 6 |
779689 | 779689 | 2020-11-29 | Slope | North Dakota | 38087 | 19 | 0 |
779690 | 779690 | 2020-11-29 | Stark | North Dakota | 38089 | 3582 | 39 |
779691 | 779691 | 2020-11-29 | Steele | North Dakota | 38091 | 132 | 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);