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 54
- 38101 461
- 38015 455
- 38017 455
- 38059 454
- 38069 452
- 38071 452
- 38099 449
- 38025 448
- 38031 447
- 38089 447
- 38049 446
- 38051 446
- 38003 444
- 38023 444
- 38055 444
- 38061 444
- 38085 444
- 38035 442
- 38065 442
- 38037 441
- 38053 441
- 38105 441
- 38013 440
- 38027 438
- 38087 438
- 38029 436
- 38011 434
- 38093 433
- 38077 432
- 38081 431
- 38079 430
- 38063 422
- 38103 419
- 38067 416
- 38073 415
- 38075 410
- 38057 406
- 38005 404
- 38097 404
- 38091 394
- 38009 392
- 38039 389
- - 384
- 38021 378
- 38045 374
- 38083 374
- 38043 371
- 38007 360
- 38019 360
- 38041 354
- 38095 343
- 38047 339
- 38033 336
- 38001 322
county 54
- Ward 461
- Burleigh 455
- Cass 455
- Morton 454
- Pierce 452
- Ramsey 452
- Walsh 449
- Dunn 448
- Foster 447
- Stark 447
- McHenry 446
- McIntosh 446
- Barnes 444
- Divide 444
- McLean 444
- Mountrail 444
- Sioux 444
- Grand Forks 442
- Oliver 442
- Grant 441
- McKenzie 441
- Williams 441
- Burke 440
- Eddy 438
- Slope 438
- Emmons 436
- Bowman 434
- Stutsman 433
- Richland 432
- Sargent 431
- Rolette 430
- Nelson 422
- Wells 419
- Pembina 416
- Ransom 415
- Renville 410
- Mercer 406
- Benson 404
- Traill 404
- Steele 394
- Bottineau 392
- Griggs 389
- Unknown 384
- Dickey 378
- LaMoure 374
- Sheridan 374
- Kidder 371
- Billings 360
- Cavalier 360
- Hettinger 354
- Towner 343
- Logan 339
- Golden Valley 336
- Adams 322
state 1
- North Dakota · 22,517 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419132 | 1419132 | 2021-06-14 | Adams | North Dakota | 38001 | 270 | 3 |
1419133 | 1419133 | 2021-06-14 | Barnes | North Dakota | 38003 | 1423 | 31 |
1419134 | 1419134 | 2021-06-14 | Benson | North Dakota | 38005 | 1101 | 19 |
1419135 | 1419135 | 2021-06-14 | Billings | North Dakota | 38007 | 54 | 0 |
1419136 | 1419136 | 2021-06-14 | Bottineau | North Dakota | 38009 | 724 | 20 |
1419137 | 1419137 | 2021-06-14 | Bowman | North Dakota | 38011 | 404 | 5 |
1419138 | 1419138 | 2021-06-14 | Burke | North Dakota | 38013 | 248 | 3 |
1419139 | 1419139 | 2021-06-14 | Burleigh | North Dakota | 38015 | 15996 | 193 |
1419140 | 1419140 | 2021-06-14 | Cass | North Dakota | 38017 | 24735 | 209 |
1419141 | 1419141 | 2021-06-14 | Cavalier | North Dakota | 38019 | 432 | 5 |
1419142 | 1419142 | 2021-06-14 | Dickey | North Dakota | 38021 | 799 | 33 |
1419143 | 1419143 | 2021-06-14 | Divide | North Dakota | 38023 | 187 | 2 |
1419144 | 1419144 | 2021-06-14 | Dunn | North Dakota | 38025 | 394 | 7 |
1419145 | 1419145 | 2021-06-14 | Eddy | North Dakota | 38027 | 471 | 6 |
1419146 | 1419146 | 2021-06-14 | Emmons | North Dakota | 38029 | 438 | 13 |
1419147 | 1419147 | 2021-06-14 | Foster | North Dakota | 38031 | 600 | 19 |
1419148 | 1419148 | 2021-06-14 | Golden Valley | North Dakota | 38033 | 261 | 3 |
1419149 | 1419149 | 2021-06-14 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1419150 | 1419150 | 2021-06-14 | Grant | North Dakota | 38037 | 211 | 7 |
1419151 | 1419151 | 2021-06-14 | Griggs | North Dakota | 38039 | 330 | 2 |
1419152 | 1419152 | 2021-06-14 | Hettinger | North Dakota | 38041 | 332 | 4 |
1419153 | 1419153 | 2021-06-14 | Kidder | North Dakota | 38043 | 275 | 10 |
1419154 | 1419154 | 2021-06-14 | LaMoure | North Dakota | 38045 | 536 | 17 |
1419155 | 1419155 | 2021-06-14 | Logan | North Dakota | 38047 | 265 | 10 |
1419156 | 1419156 | 2021-06-14 | McHenry | North Dakota | 38049 | 654 | 23 |
1419157 | 1419157 | 2021-06-14 | McIntosh | North Dakota | 38051 | 353 | 7 |
1419158 | 1419158 | 2021-06-14 | McKenzie | North Dakota | 38053 | 1440 | 13 |
1419159 | 1419159 | 2021-06-14 | McLean | North Dakota | 38055 | 1290 | 30 |
1419160 | 1419160 | 2021-06-14 | Mercer | North Dakota | 38057 | 1162 | 10 |
1419161 | 1419161 | 2021-06-14 | Morton | North Dakota | 38059 | 5339 | 101 |
1419162 | 1419162 | 2021-06-14 | Mountrail | North Dakota | 38061 | 1373 | 18 |
1419163 | 1419163 | 2021-06-14 | Nelson | North Dakota | 38063 | 479 | 15 |
1419164 | 1419164 | 2021-06-14 | Oliver | North Dakota | 38065 | 158 | 3 |
1419165 | 1419165 | 2021-06-14 | Pembina | North Dakota | 38067 | 822 | 11 |
1419166 | 1419166 | 2021-06-14 | Pierce | North Dakota | 38069 | 550 | 25 |
1419167 | 1419167 | 2021-06-14 | Ramsey | North Dakota | 38071 | 1728 | 30 |
1419168 | 1419168 | 2021-06-14 | Ransom | North Dakota | 38073 | 700 | 17 |
1419169 | 1419169 | 2021-06-14 | Renville | North Dakota | 38075 | 322 | 14 |
1419170 | 1419170 | 2021-06-14 | Richland | North Dakota | 38077 | 2027 | 17 |
1419171 | 1419171 | 2021-06-14 | Rolette | North Dakota | 38079 | 2160 | 28 |
1419172 | 1419172 | 2021-06-14 | Sargent | North Dakota | 38081 | 501 | 7 |
1419173 | 1419173 | 2021-06-14 | Sheridan | North Dakota | 38083 | 122 | 2 |
1419174 | 1419174 | 2021-06-14 | Sioux | North Dakota | 38085 | 664 | 12 |
1419175 | 1419175 | 2021-06-14 | Slope | North Dakota | 38087 | 32 | 0 |
1419176 | 1419176 | 2021-06-14 | Stark | North Dakota | 38089 | 4932 | 51 |
1419177 | 1419177 | 2021-06-14 | Steele | North Dakota | 38091 | 193 | 2 |
1419178 | 1419178 | 2021-06-14 | Stutsman | North Dakota | 38093 | 3542 | 81 |
1419179 | 1419179 | 2021-06-14 | Towner | North Dakota | 38095 | 327 | 11 |
1419180 | 1419180 | 2021-06-14 | Traill | North Dakota | 38097 | 1052 | 18 |
1419181 | 1419181 | 2021-06-14 | Unknown | North Dakota | 31 | 31 | |
1419182 | 1419182 | 2021-06-14 | Walsh | North Dakota | 38099 | 1913 | 27 |
1419183 | 1419183 | 2021-06-14 | Ward | North Dakota | 38101 | 9952 | 199 |
1419184 | 1419184 | 2021-06-14 | Wells | North Dakota | 38103 | 458 | 8 |
1419185 | 1419185 | 2021-06-14 | Williams | North Dakota | 38105 | 5005 | 40 |
1415887 | 1415887 | 2021-06-13 | Adams | North Dakota | 38001 | 270 | 3 |
1415888 | 1415888 | 2021-06-13 | Barnes | North Dakota | 38003 | 1423 | 31 |
1415889 | 1415889 | 2021-06-13 | Benson | North Dakota | 38005 | 1101 | 19 |
1415890 | 1415890 | 2021-06-13 | Billings | North Dakota | 38007 | 54 | 0 |
1415891 | 1415891 | 2021-06-13 | Bottineau | North Dakota | 38009 | 724 | 20 |
1415892 | 1415892 | 2021-06-13 | Bowman | North Dakota | 38011 | 404 | 5 |
1415893 | 1415893 | 2021-06-13 | Burke | North Dakota | 38013 | 248 | 3 |
1415894 | 1415894 | 2021-06-13 | Burleigh | North Dakota | 38015 | 15994 | 193 |
1415895 | 1415895 | 2021-06-13 | Cass | North Dakota | 38017 | 24733 | 209 |
1415896 | 1415896 | 2021-06-13 | Cavalier | North Dakota | 38019 | 432 | 5 |
1415897 | 1415897 | 2021-06-13 | Dickey | North Dakota | 38021 | 799 | 33 |
1415898 | 1415898 | 2021-06-13 | Divide | North Dakota | 38023 | 187 | 2 |
1415899 | 1415899 | 2021-06-13 | Dunn | North Dakota | 38025 | 394 | 7 |
1415900 | 1415900 | 2021-06-13 | Eddy | North Dakota | 38027 | 471 | 6 |
1415901 | 1415901 | 2021-06-13 | Emmons | North Dakota | 38029 | 438 | 13 |
1415902 | 1415902 | 2021-06-13 | Foster | North Dakota | 38031 | 600 | 19 |
1415903 | 1415903 | 2021-06-13 | Golden Valley | North Dakota | 38033 | 261 | 3 |
1415904 | 1415904 | 2021-06-13 | Grand Forks | North Dakota | 38035 | 10704 | 79 |
1415905 | 1415905 | 2021-06-13 | Grant | North Dakota | 38037 | 211 | 7 |
1415906 | 1415906 | 2021-06-13 | Griggs | North Dakota | 38039 | 330 | 2 |
1415907 | 1415907 | 2021-06-13 | Hettinger | North Dakota | 38041 | 332 | 4 |
1415908 | 1415908 | 2021-06-13 | Kidder | North Dakota | 38043 | 275 | 10 |
1415909 | 1415909 | 2021-06-13 | LaMoure | North Dakota | 38045 | 536 | 17 |
1415910 | 1415910 | 2021-06-13 | Logan | North Dakota | 38047 | 265 | 10 |
1415911 | 1415911 | 2021-06-13 | McHenry | North Dakota | 38049 | 654 | 23 |
1415912 | 1415912 | 2021-06-13 | McIntosh | North Dakota | 38051 | 353 | 7 |
1415913 | 1415913 | 2021-06-13 | McKenzie | North Dakota | 38053 | 1440 | 13 |
1415914 | 1415914 | 2021-06-13 | McLean | North Dakota | 38055 | 1289 | 30 |
1415915 | 1415915 | 2021-06-13 | Mercer | North Dakota | 38057 | 1162 | 10 |
1415916 | 1415916 | 2021-06-13 | Morton | North Dakota | 38059 | 5339 | 101 |
1415917 | 1415917 | 2021-06-13 | Mountrail | North Dakota | 38061 | 1373 | 18 |
1415918 | 1415918 | 2021-06-13 | Nelson | North Dakota | 38063 | 479 | 15 |
1415919 | 1415919 | 2021-06-13 | Oliver | North Dakota | 38065 | 158 | 3 |
1415920 | 1415920 | 2021-06-13 | Pembina | North Dakota | 38067 | 822 | 11 |
1415921 | 1415921 | 2021-06-13 | Pierce | North Dakota | 38069 | 550 | 25 |
1415922 | 1415922 | 2021-06-13 | Ramsey | North Dakota | 38071 | 1728 | 30 |
1415923 | 1415923 | 2021-06-13 | Ransom | North Dakota | 38073 | 700 | 17 |
1415924 | 1415924 | 2021-06-13 | Renville | North Dakota | 38075 | 322 | 14 |
1415925 | 1415925 | 2021-06-13 | Richland | North Dakota | 38077 | 2027 | 17 |
1415926 | 1415926 | 2021-06-13 | Rolette | North Dakota | 38079 | 2160 | 28 |
1415927 | 1415927 | 2021-06-13 | Sargent | North Dakota | 38081 | 501 | 7 |
1415928 | 1415928 | 2021-06-13 | Sheridan | North Dakota | 38083 | 122 | 2 |
1415929 | 1415929 | 2021-06-13 | Sioux | North Dakota | 38085 | 664 | 12 |
1415930 | 1415930 | 2021-06-13 | Slope | North Dakota | 38087 | 32 | 0 |
1415931 | 1415931 | 2021-06-13 | Stark | North Dakota | 38089 | 4931 | 51 |
1415932 | 1415932 | 2021-06-13 | Steele | North Dakota | 38091 | 193 | 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);