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 581
- 38015 574
- 38017 574
- 38059 573
- 38069 571
- 38071 571
- 38099 569
- 38025 567
- 38089 567
- 38031 566
- 38049 565
- 38051 565
- 38085 564
- 38003 563
- 38023 563
- 38055 563
- 38061 563
- 38035 561
- 38065 561
- 38105 561
- 38037 560
- 38053 560
- 38013 559
- 38087 558
- 38027 557
- 38029 555
- 38011 553
- 38093 553
- 38077 552
- 38081 551
- …
county >30
- Ward 581
- Burleigh 574
- Cass 574
- Morton 573
- Pierce 571
- Ramsey 571
- Walsh 569
- Dunn 567
- Stark 567
- Foster 566
- McHenry 565
- McIntosh 565
- Sioux 564
- Barnes 563
- Divide 563
- McLean 563
- Mountrail 563
- Grand Forks 561
- Oliver 561
- Williams 561
- Grant 560
- McKenzie 560
- Burke 559
- Slope 558
- Eddy 557
- Emmons 555
- Bowman 553
- Stutsman 553
- Richland 552
- Sargent 551
- …
state 1
- North Dakota · 28,959 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808912 | 1808912 | 2021-10-12 | Richland | North Dakota | 38077 | 2410 | 19 |
1808913 | 1808913 | 2021-10-12 | Rolette | North Dakota | 38079 | 2701 | 31 |
1808914 | 1808914 | 2021-10-12 | Sargent | North Dakota | 38081 | 579 | 7 |
1808915 | 1808915 | 2021-10-12 | Sheridan | North Dakota | 38083 | 146 | 3 |
1808916 | 1808916 | 2021-10-12 | Sioux | North Dakota | 38085 | 841 | 14 |
1808917 | 1808917 | 2021-10-12 | Slope | North Dakota | 38087 | 41 | 0 |
1808918 | 1808918 | 2021-10-12 | Stark | North Dakota | 38089 | 7082 | 60 |
1808919 | 1808919 | 2021-10-12 | Steele | North Dakota | 38091 | 242 | 2 |
1808920 | 1808920 | 2021-10-12 | Stutsman | North Dakota | 38093 | 4223 | 82 |
1808921 | 1808921 | 2021-10-12 | Towner | North Dakota | 38095 | 373 | 11 |
1808922 | 1808922 | 2021-10-12 | Traill | North Dakota | 38097 | 1232 | 19 |
1808923 | 1808923 | 2021-10-12 | Unknown | North Dakota | 34 | 34 | |
1808924 | 1808924 | 2021-10-12 | Walsh | North Dakota | 38099 | 2177 | 28 |
1808925 | 1808925 | 2021-10-12 | Ward | North Dakota | 38101 | 12359 | 212 |
1808926 | 1808926 | 2021-10-12 | Wells | North Dakota | 38103 | 551 | 9 |
1808927 | 1808927 | 2021-10-12 | Williams | North Dakota | 38105 | 6448 | 47 |
1805623 | 1805623 | 2021-10-11 | Adams | North Dakota | 38001 | 352 | 4 |
1805624 | 1805624 | 2021-10-11 | Barnes | North Dakota | 38003 | 1721 | 33 |
1805625 | 1805625 | 2021-10-11 | Benson | North Dakota | 38005 | 1250 | 20 |
1805626 | 1805626 | 2021-10-11 | Billings | North Dakota | 38007 | 88 | 0 |
1805627 | 1805627 | 2021-10-11 | Bottineau | North Dakota | 38009 | 928 | 20 |
1805628 | 1805628 | 2021-10-11 | Bowman | North Dakota | 38011 | 525 | 7 |
1805629 | 1805629 | 2021-10-11 | Burke | North Dakota | 38013 | 289 | 3 |
1805630 | 1805630 | 2021-10-11 | Burleigh | North Dakota | 38015 | 21142 | 221 |
1805631 | 1805631 | 2021-10-11 | Cass | North Dakota | 38017 | 30146 | 229 |
1805632 | 1805632 | 2021-10-11 | Cavalier | North Dakota | 38019 | 519 | 5 |
1805633 | 1805633 | 2021-10-11 | Dickey | North Dakota | 38021 | 931 | 33 |
1805634 | 1805634 | 2021-10-11 | Divide | North Dakota | 38023 | 254 | 2 |
1805635 | 1805635 | 2021-10-11 | Dunn | North Dakota | 38025 | 642 | 7 |
1805636 | 1805636 | 2021-10-11 | Eddy | North Dakota | 38027 | 506 | 6 |
1805637 | 1805637 | 2021-10-11 | Emmons | North Dakota | 38029 | 531 | 14 |
1805638 | 1805638 | 2021-10-11 | Foster | North Dakota | 38031 | 635 | 19 |
1805639 | 1805639 | 2021-10-11 | Golden Valley | North Dakota | 38033 | 323 | 4 |
1805640 | 1805640 | 2021-10-11 | Grand Forks | North Dakota | 38035 | 12416 | 82 |
1805641 | 1805641 | 2021-10-11 | Grant | North Dakota | 38037 | 295 | 7 |
1805642 | 1805642 | 2021-10-11 | Griggs | North Dakota | 38039 | 361 | 2 |
1805643 | 1805643 | 2021-10-11 | Hettinger | North Dakota | 38041 | 445 | 5 |
1805644 | 1805644 | 2021-10-11 | Kidder | North Dakota | 38043 | 346 | 10 |
1805645 | 1805645 | 2021-10-11 | LaMoure | North Dakota | 38045 | 643 | 17 |
1805646 | 1805646 | 2021-10-11 | Logan | North Dakota | 38047 | 315 | 10 |
1805647 | 1805647 | 2021-10-11 | McHenry | North Dakota | 38049 | 813 | 23 |
1805648 | 1805648 | 2021-10-11 | McIntosh | North Dakota | 38051 | 438 | 8 |
1805649 | 1805649 | 2021-10-11 | McKenzie | North Dakota | 38053 | 2180 | 17 |
1805650 | 1805650 | 2021-10-11 | McLean | North Dakota | 38055 | 1665 | 33 |
1805651 | 1805651 | 2021-10-11 | Mercer | North Dakota | 38057 | 1618 | 12 |
1805652 | 1805652 | 2021-10-11 | Morton | North Dakota | 38059 | 6976 | 105 |
1805653 | 1805653 | 2021-10-11 | Mountrail | North Dakota | 38061 | 1795 | 23 |
1805654 | 1805654 | 2021-10-11 | Nelson | North Dakota | 38063 | 533 | 16 |
1805655 | 1805655 | 2021-10-11 | Oliver | North Dakota | 38065 | 194 | 3 |
1805656 | 1805656 | 2021-10-11 | Pembina | North Dakota | 38067 | 1123 | 11 |
1805657 | 1805657 | 2021-10-11 | Pierce | North Dakota | 38069 | 732 | 27 |
1805658 | 1805658 | 2021-10-11 | Ramsey | North Dakota | 38071 | 2082 | 33 |
1805659 | 1805659 | 2021-10-11 | Ransom | North Dakota | 38073 | 898 | 18 |
1805660 | 1805660 | 2021-10-11 | Renville | North Dakota | 38075 | 357 | 14 |
1805661 | 1805661 | 2021-10-11 | Richland | North Dakota | 38077 | 2393 | 19 |
1805662 | 1805662 | 2021-10-11 | Rolette | North Dakota | 38079 | 2693 | 31 |
1805663 | 1805663 | 2021-10-11 | Sargent | North Dakota | 38081 | 575 | 7 |
1805664 | 1805664 | 2021-10-11 | Sheridan | North Dakota | 38083 | 144 | 3 |
1805665 | 1805665 | 2021-10-11 | Sioux | North Dakota | 38085 | 837 | 14 |
1805666 | 1805666 | 2021-10-11 | Slope | North Dakota | 38087 | 41 | 0 |
1805667 | 1805667 | 2021-10-11 | Stark | North Dakota | 38089 | 7019 | 59 |
1805668 | 1805668 | 2021-10-11 | Steele | North Dakota | 38091 | 240 | 2 |
1805669 | 1805669 | 2021-10-11 | Stutsman | North Dakota | 38093 | 4206 | 82 |
1805670 | 1805670 | 2021-10-11 | Towner | North Dakota | 38095 | 373 | 11 |
1805671 | 1805671 | 2021-10-11 | Traill | North Dakota | 38097 | 1228 | 18 |
1805672 | 1805672 | 2021-10-11 | Unknown | North Dakota | 34 | 34 | |
1805673 | 1805673 | 2021-10-11 | Walsh | North Dakota | 38099 | 2171 | 28 |
1805674 | 1805674 | 2021-10-11 | Ward | North Dakota | 38101 | 12298 | 210 |
1805675 | 1805675 | 2021-10-11 | Wells | North Dakota | 38103 | 546 | 9 |
1805676 | 1805676 | 2021-10-11 | Williams | North Dakota | 38105 | 6410 | 46 |
1802374 | 1802374 | 2021-10-10 | Adams | North Dakota | 38001 | 352 | 4 |
1802375 | 1802375 | 2021-10-10 | Barnes | North Dakota | 38003 | 1718 | 33 |
1802376 | 1802376 | 2021-10-10 | Benson | North Dakota | 38005 | 1247 | 20 |
1802377 | 1802377 | 2021-10-10 | Billings | North Dakota | 38007 | 88 | 0 |
1802378 | 1802378 | 2021-10-10 | Bottineau | North Dakota | 38009 | 926 | 20 |
1802379 | 1802379 | 2021-10-10 | Bowman | North Dakota | 38011 | 525 | 7 |
1802380 | 1802380 | 2021-10-10 | Burke | North Dakota | 38013 | 288 | 3 |
1802381 | 1802381 | 2021-10-10 | Burleigh | North Dakota | 38015 | 21104 | 221 |
1802382 | 1802382 | 2021-10-10 | Cass | North Dakota | 38017 | 30086 | 229 |
1802383 | 1802383 | 2021-10-10 | Cavalier | North Dakota | 38019 | 519 | 5 |
1802384 | 1802384 | 2021-10-10 | Dickey | North Dakota | 38021 | 931 | 33 |
1802385 | 1802385 | 2021-10-10 | Divide | North Dakota | 38023 | 254 | 2 |
1802386 | 1802386 | 2021-10-10 | Dunn | North Dakota | 38025 | 642 | 7 |
1802387 | 1802387 | 2021-10-10 | Eddy | North Dakota | 38027 | 506 | 6 |
1802388 | 1802388 | 2021-10-10 | Emmons | North Dakota | 38029 | 531 | 14 |
1802389 | 1802389 | 2021-10-10 | Foster | North Dakota | 38031 | 635 | 19 |
1802390 | 1802390 | 2021-10-10 | Golden Valley | North Dakota | 38033 | 322 | 4 |
1802391 | 1802391 | 2021-10-10 | Grand Forks | North Dakota | 38035 | 12407 | 82 |
1802392 | 1802392 | 2021-10-10 | Grant | North Dakota | 38037 | 294 | 7 |
1802393 | 1802393 | 2021-10-10 | Griggs | North Dakota | 38039 | 361 | 2 |
1802394 | 1802394 | 2021-10-10 | Hettinger | North Dakota | 38041 | 444 | 5 |
1802395 | 1802395 | 2021-10-10 | Kidder | North Dakota | 38043 | 345 | 10 |
1802396 | 1802396 | 2021-10-10 | LaMoure | North Dakota | 38045 | 643 | 17 |
1802397 | 1802397 | 2021-10-10 | Logan | North Dakota | 38047 | 314 | 10 |
1802398 | 1802398 | 2021-10-10 | McHenry | North Dakota | 38049 | 813 | 23 |
1802399 | 1802399 | 2021-10-10 | McIntosh | North Dakota | 38051 | 438 | 8 |
1802400 | 1802400 | 2021-10-10 | McKenzie | North Dakota | 38053 | 2176 | 17 |
1802401 | 1802401 | 2021-10-10 | McLean | North Dakota | 38055 | 1657 | 33 |
1802402 | 1802402 | 2021-10-10 | Mercer | North Dakota | 38057 | 1616 | 12 |
1802403 | 1802403 | 2021-10-10 | Morton | North Dakota | 38059 | 6951 | 105 |
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);