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 493
- 38015 487
- 38017 487
- 38059 486
- 38069 484
- 38071 484
- 38099 481
- 38025 480
- 38031 479
- 38089 479
- 38049 478
- 38051 478
- 38003 476
- 38023 476
- 38055 476
- 38061 476
- 38085 476
- 38035 474
- 38065 474
- 38037 473
- 38053 473
- 38105 473
- 38013 472
- 38027 470
- 38087 470
- 38029 468
- 38011 466
- 38093 465
- 38077 464
- 38081 463
- …
county >30
- Ward 493
- Burleigh 487
- Cass 487
- Morton 486
- Pierce 484
- Ramsey 484
- Walsh 481
- Dunn 480
- Foster 479
- Stark 479
- McHenry 478
- McIntosh 478
- Barnes 476
- Divide 476
- McLean 476
- Mountrail 476
- Sioux 476
- Grand Forks 474
- Oliver 474
- Grant 473
- McKenzie 473
- Williams 473
- Burke 472
- Eddy 470
- Slope 470
- Emmons 468
- Bowman 466
- Stutsman 465
- Richland 464
- Sargent 463
- …
state 1
- North Dakota · 24,245 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1523007 | 1523007 | 2021-07-16 | Adams | North Dakota | 38001 | 271 | 3 |
1523008 | 1523008 | 2021-07-16 | Barnes | North Dakota | 38003 | 1425 | 32 |
1523009 | 1523009 | 2021-07-16 | Benson | North Dakota | 38005 | 1106 | 20 |
1523010 | 1523010 | 2021-07-16 | Billings | North Dakota | 38007 | 56 | 0 |
1523011 | 1523011 | 2021-07-16 | Bottineau | North Dakota | 38009 | 724 | 20 |
1523012 | 1523012 | 2021-07-16 | Bowman | North Dakota | 38011 | 408 | 5 |
1523013 | 1523013 | 2021-07-16 | Burke | North Dakota | 38013 | 251 | 3 |
1523014 | 1523014 | 2021-07-16 | Burleigh | North Dakota | 38015 | 16056 | 196 |
1523015 | 1523015 | 2021-07-16 | Cass | North Dakota | 38017 | 24822 | 212 |
1523016 | 1523016 | 2021-07-16 | Cavalier | North Dakota | 38019 | 432 | 5 |
1523017 | 1523017 | 2021-07-16 | Dickey | North Dakota | 38021 | 800 | 33 |
1523018 | 1523018 | 2021-07-16 | Divide | North Dakota | 38023 | 189 | 2 |
1523019 | 1523019 | 2021-07-16 | Dunn | North Dakota | 38025 | 406 | 7 |
1523020 | 1523020 | 2021-07-16 | Eddy | North Dakota | 38027 | 470 | 6 |
1523021 | 1523021 | 2021-07-16 | Emmons | North Dakota | 38029 | 441 | 13 |
1523022 | 1523022 | 2021-07-16 | Foster | North Dakota | 38031 | 600 | 19 |
1523023 | 1523023 | 2021-07-16 | Golden Valley | North Dakota | 38033 | 263 | 3 |
1523024 | 1523024 | 2021-07-16 | Grand Forks | North Dakota | 38035 | 10727 | 79 |
1523025 | 1523025 | 2021-07-16 | Grant | North Dakota | 38037 | 211 | 7 |
1523026 | 1523026 | 2021-07-16 | Griggs | North Dakota | 38039 | 330 | 2 |
1523027 | 1523027 | 2021-07-16 | Hettinger | North Dakota | 38041 | 333 | 4 |
1523028 | 1523028 | 2021-07-16 | Kidder | North Dakota | 38043 | 279 | 10 |
1523029 | 1523029 | 2021-07-16 | LaMoure | North Dakota | 38045 | 539 | 17 |
1523030 | 1523030 | 2021-07-16 | Logan | North Dakota | 38047 | 268 | 10 |
1523031 | 1523031 | 2021-07-16 | McHenry | North Dakota | 38049 | 662 | 23 |
1523032 | 1523032 | 2021-07-16 | McIntosh | North Dakota | 38051 | 353 | 7 |
1523033 | 1523033 | 2021-07-16 | McKenzie | North Dakota | 38053 | 1471 | 14 |
1523034 | 1523034 | 2021-07-16 | McLean | North Dakota | 38055 | 1297 | 31 |
1523035 | 1523035 | 2021-07-16 | Mercer | North Dakota | 38057 | 1173 | 11 |
1523036 | 1523036 | 2021-07-16 | Morton | North Dakota | 38059 | 5355 | 102 |
1523037 | 1523037 | 2021-07-16 | Mountrail | North Dakota | 38061 | 1394 | 18 |
1523038 | 1523038 | 2021-07-16 | Nelson | North Dakota | 38063 | 482 | 15 |
1523039 | 1523039 | 2021-07-16 | Oliver | North Dakota | 38065 | 158 | 3 |
1523040 | 1523040 | 2021-07-16 | Pembina | North Dakota | 38067 | 825 | 11 |
1523041 | 1523041 | 2021-07-16 | Pierce | North Dakota | 38069 | 552 | 25 |
1523042 | 1523042 | 2021-07-16 | Ramsey | North Dakota | 38071 | 1730 | 30 |
1523043 | 1523043 | 2021-07-16 | Ransom | North Dakota | 38073 | 700 | 17 |
1523044 | 1523044 | 2021-07-16 | Renville | North Dakota | 38075 | 323 | 14 |
1523045 | 1523045 | 2021-07-16 | Richland | North Dakota | 38077 | 2027 | 17 |
1523046 | 1523046 | 2021-07-16 | Rolette | North Dakota | 38079 | 2162 | 28 |
1523047 | 1523047 | 2021-07-16 | Sargent | North Dakota | 38081 | 502 | 7 |
1523048 | 1523048 | 2021-07-16 | Sheridan | North Dakota | 38083 | 122 | 2 |
1523049 | 1523049 | 2021-07-16 | Sioux | North Dakota | 38085 | 665 | 12 |
1523050 | 1523050 | 2021-07-16 | Slope | North Dakota | 38087 | 32 | 0 |
1523051 | 1523051 | 2021-07-16 | Stark | North Dakota | 38089 | 4985 | 52 |
1523052 | 1523052 | 2021-07-16 | Steele | North Dakota | 38091 | 195 | 2 |
1523053 | 1523053 | 2021-07-16 | Stutsman | North Dakota | 38093 | 3555 | 82 |
1523054 | 1523054 | 2021-07-16 | Towner | North Dakota | 38095 | 326 | 11 |
1523055 | 1523055 | 2021-07-16 | Traill | North Dakota | 38097 | 1054 | 18 |
1523056 | 1523056 | 2021-07-16 | Unknown | North Dakota | 31 | 31 | |
1523057 | 1523057 | 2021-07-16 | Walsh | North Dakota | 38099 | 1914 | 27 |
1523058 | 1523058 | 2021-07-16 | Ward | North Dakota | 38101 | 10034 | 201 |
1523059 | 1523059 | 2021-07-16 | Wells | North Dakota | 38103 | 459 | 8 |
1523060 | 1523060 | 2021-07-16 | Williams | North Dakota | 38105 | 5061 | 40 |
1519759 | 1519759 | 2021-07-15 | Adams | North Dakota | 38001 | 271 | 3 |
1519760 | 1519760 | 2021-07-15 | Barnes | North Dakota | 38003 | 1425 | 32 |
1519761 | 1519761 | 2021-07-15 | Benson | North Dakota | 38005 | 1104 | 20 |
1519762 | 1519762 | 2021-07-15 | Billings | North Dakota | 38007 | 55 | 0 |
1519763 | 1519763 | 2021-07-15 | Bottineau | North Dakota | 38009 | 724 | 20 |
1519764 | 1519764 | 2021-07-15 | Bowman | North Dakota | 38011 | 408 | 5 |
1519765 | 1519765 | 2021-07-15 | Burke | North Dakota | 38013 | 251 | 3 |
1519766 | 1519766 | 2021-07-15 | Burleigh | North Dakota | 38015 | 16054 | 196 |
1519767 | 1519767 | 2021-07-15 | Cass | North Dakota | 38017 | 24820 | 212 |
1519768 | 1519768 | 2021-07-15 | Cavalier | North Dakota | 38019 | 432 | 5 |
1519769 | 1519769 | 2021-07-15 | Dickey | North Dakota | 38021 | 800 | 33 |
1519770 | 1519770 | 2021-07-15 | Divide | North Dakota | 38023 | 188 | 2 |
1519771 | 1519771 | 2021-07-15 | Dunn | North Dakota | 38025 | 406 | 7 |
1519772 | 1519772 | 2021-07-15 | Eddy | North Dakota | 38027 | 470 | 6 |
1519773 | 1519773 | 2021-07-15 | Emmons | North Dakota | 38029 | 441 | 13 |
1519774 | 1519774 | 2021-07-15 | Foster | North Dakota | 38031 | 600 | 19 |
1519775 | 1519775 | 2021-07-15 | Golden Valley | North Dakota | 38033 | 263 | 3 |
1519776 | 1519776 | 2021-07-15 | Grand Forks | North Dakota | 38035 | 10726 | 79 |
1519777 | 1519777 | 2021-07-15 | Grant | North Dakota | 38037 | 211 | 7 |
1519778 | 1519778 | 2021-07-15 | Griggs | North Dakota | 38039 | 330 | 2 |
1519779 | 1519779 | 2021-07-15 | Hettinger | North Dakota | 38041 | 333 | 4 |
1519780 | 1519780 | 2021-07-15 | Kidder | North Dakota | 38043 | 279 | 10 |
1519781 | 1519781 | 2021-07-15 | LaMoure | North Dakota | 38045 | 539 | 17 |
1519782 | 1519782 | 2021-07-15 | Logan | North Dakota | 38047 | 268 | 10 |
1519783 | 1519783 | 2021-07-15 | McHenry | North Dakota | 38049 | 662 | 23 |
1519784 | 1519784 | 2021-07-15 | McIntosh | North Dakota | 38051 | 353 | 7 |
1519785 | 1519785 | 2021-07-15 | McKenzie | North Dakota | 38053 | 1470 | 14 |
1519786 | 1519786 | 2021-07-15 | McLean | North Dakota | 38055 | 1297 | 31 |
1519787 | 1519787 | 2021-07-15 | Mercer | North Dakota | 38057 | 1173 | 11 |
1519788 | 1519788 | 2021-07-15 | Morton | North Dakota | 38059 | 5353 | 102 |
1519789 | 1519789 | 2021-07-15 | Mountrail | North Dakota | 38061 | 1394 | 18 |
1519790 | 1519790 | 2021-07-15 | Nelson | North Dakota | 38063 | 482 | 15 |
1519791 | 1519791 | 2021-07-15 | Oliver | North Dakota | 38065 | 158 | 3 |
1519792 | 1519792 | 2021-07-15 | Pembina | North Dakota | 38067 | 825 | 11 |
1519793 | 1519793 | 2021-07-15 | Pierce | North Dakota | 38069 | 552 | 25 |
1519794 | 1519794 | 2021-07-15 | Ramsey | North Dakota | 38071 | 1732 | 30 |
1519795 | 1519795 | 2021-07-15 | Ransom | North Dakota | 38073 | 700 | 17 |
1519796 | 1519796 | 2021-07-15 | Renville | North Dakota | 38075 | 323 | 14 |
1519797 | 1519797 | 2021-07-15 | Richland | North Dakota | 38077 | 2027 | 17 |
1519798 | 1519798 | 2021-07-15 | Rolette | North Dakota | 38079 | 2161 | 28 |
1519799 | 1519799 | 2021-07-15 | Sargent | North Dakota | 38081 | 502 | 7 |
1519800 | 1519800 | 2021-07-15 | Sheridan | North Dakota | 38083 | 122 | 2 |
1519801 | 1519801 | 2021-07-15 | Sioux | North Dakota | 38085 | 665 | 12 |
1519802 | 1519802 | 2021-07-15 | Slope | North Dakota | 38087 | 32 | 0 |
1519803 | 1519803 | 2021-07-15 | Stark | North Dakota | 38089 | 4983 | 52 |
1519804 | 1519804 | 2021-07-15 | Steele | North Dakota | 38091 | 195 | 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);