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 695
- 38015 688
- 38017 688
- 38059 687
- 38069 685
- 38071 685
- 38099 683
- 38025 681
- 38031 680
- 38089 680
- 38049 679
- 38051 679
- 38003 677
- 38023 677
- 38055 677
- 38061 677
- 38085 677
- 38035 675
- 38065 675
- 38105 675
- 38037 674
- 38053 674
- 38013 673
- 38027 671
- 38087 671
- 38029 669
- 38011 667
- 38093 666
- 38077 665
- 38081 664
- …
county >30
- Ward 695
- Burleigh 688
- Cass 688
- Morton 687
- Pierce 685
- Ramsey 685
- Walsh 683
- Dunn 681
- Foster 680
- Stark 680
- McHenry 679
- McIntosh 679
- Barnes 677
- Divide 677
- McLean 677
- Mountrail 677
- Sioux 677
- Grand Forks 675
- Oliver 675
- Williams 675
- Grant 674
- McKenzie 674
- Burke 673
- Eddy 671
- Slope 671
- Emmons 669
- Bowman 667
- Stutsman 666
- Richland 665
- Sargent 664
- …
state 1
- North Dakota · 35,106 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179500 | 2179500 | 2022-02-03 | Towner | North Dakota | 38095 | 598 | 12 |
2179501 | 2179501 | 2022-02-03 | Traill | North Dakota | 38097 | 2062 | 22 |
2179502 | 2179502 | 2022-02-03 | Unknown | North Dakota | 0 | 47 | |
2179503 | 2179503 | 2022-02-03 | Walsh | North Dakota | 38099 | 3194 | 34 |
2179504 | 2179504 | 2022-02-03 | Ward | North Dakota | 38101 | 19730 | 243 |
2179505 | 2179505 | 2022-02-03 | Wells | North Dakota | 38103 | 983 | 11 |
2179506 | 2179506 | 2022-02-03 | Williams | North Dakota | 38105 | 10062 | 67 |
2176202 | 2176202 | 2022-02-02 | Adams | North Dakota | 38001 | 555 | 9 |
2176203 | 2176203 | 2022-02-02 | Barnes | North Dakota | 38003 | 2803 | 44 |
2176204 | 2176204 | 2022-02-02 | Benson | North Dakota | 38005 | 1797 | 22 |
2176205 | 2176205 | 2022-02-02 | Billings | North Dakota | 38007 | 139 | 1 |
2176206 | 2176206 | 2022-02-02 | Bottineau | North Dakota | 38009 | 1492 | 24 |
2176207 | 2176207 | 2022-02-02 | Bowman | North Dakota | 38011 | 786 | 9 |
2176208 | 2176208 | 2022-02-02 | Burke | North Dakota | 38013 | 421 | 3 |
2176209 | 2176209 | 2022-02-02 | Burleigh | North Dakota | 38015 | 33092 | 290 |
2176210 | 2176210 | 2022-02-02 | Cass | North Dakota | 38017 | 55894 | 314 |
2176211 | 2176211 | 2022-02-02 | Cavalier | North Dakota | 38019 | 749 | 7 |
2176212 | 2176212 | 2022-02-02 | Dickey | North Dakota | 38021 | 1424 | 38 |
2176213 | 2176213 | 2022-02-02 | Divide | North Dakota | 38023 | 443 | 4 |
2176214 | 2176214 | 2022-02-02 | Dunn | North Dakota | 38025 | 979 | 8 |
2176215 | 2176215 | 2022-02-02 | Eddy | North Dakota | 38027 | 715 | 6 |
2176216 | 2176216 | 2022-02-02 | Emmons | North Dakota | 38029 | 699 | 17 |
2176217 | 2176217 | 2022-02-02 | Foster | North Dakota | 38031 | 930 | 20 |
2176218 | 2176218 | 2022-02-02 | Golden Valley | North Dakota | 38033 | 460 | 4 |
2176219 | 2176219 | 2022-02-02 | Grand Forks | North Dakota | 38035 | 20751 | 112 |
2176220 | 2176220 | 2022-02-02 | Grant | North Dakota | 38037 | 441 | 11 |
2176221 | 2176221 | 2022-02-02 | Griggs | North Dakota | 38039 | 552 | 2 |
2176222 | 2176222 | 2022-02-02 | Hettinger | North Dakota | 38041 | 795 | 7 |
2176223 | 2176223 | 2022-02-02 | Kidder | North Dakota | 38043 | 477 | 13 |
2176224 | 2176224 | 2022-02-02 | LaMoure | North Dakota | 38045 | 937 | 19 |
2176225 | 2176225 | 2022-02-02 | Logan | North Dakota | 38047 | 418 | 11 |
2176226 | 2176226 | 2022-02-02 | McHenry | North Dakota | 38049 | 1234 | 30 |
2176227 | 2176227 | 2022-02-02 | McIntosh | North Dakota | 38051 | 614 | 9 |
2176228 | 2176228 | 2022-02-02 | McKenzie | North Dakota | 38053 | 3120 | 24 |
2176229 | 2176229 | 2022-02-02 | McLean | North Dakota | 38055 | 2636 | 49 |
2176230 | 2176230 | 2022-02-02 | Mercer | North Dakota | 38057 | 2448 | 23 |
2176231 | 2176231 | 2022-02-02 | Morton | North Dakota | 38059 | 10625 | 138 |
2176232 | 2176232 | 2022-02-02 | Mountrail | North Dakota | 38061 | 3009 | 33 |
2176233 | 2176233 | 2022-02-02 | Nelson | North Dakota | 38063 | 722 | 17 |
2176234 | 2176234 | 2022-02-02 | Oliver | North Dakota | 38065 | 314 | 4 |
2176235 | 2176235 | 2022-02-02 | Pembina | North Dakota | 38067 | 1867 | 16 |
2176236 | 2176236 | 2022-02-02 | Pierce | North Dakota | 38069 | 1021 | 31 |
2176237 | 2176237 | 2022-02-02 | Ramsey | North Dakota | 38071 | 3305 | 48 |
2176238 | 2176238 | 2022-02-02 | Ransom | North Dakota | 38073 | 1401 | 25 |
2176239 | 2176239 | 2022-02-02 | Renville | North Dakota | 38075 | 525 | 15 |
2176240 | 2176240 | 2022-02-02 | Richland | North Dakota | 38077 | 3844 | 21 |
2176241 | 2176241 | 2022-02-02 | Rolette | North Dakota | 38079 | 5389 | 39 |
2176242 | 2176242 | 2022-02-02 | Sargent | North Dakota | 38081 | 976 | 9 |
2176243 | 2176243 | 2022-02-02 | Sheridan | North Dakota | 38083 | 272 | 6 |
2176244 | 2176244 | 2022-02-02 | Sioux | North Dakota | 38085 | 1276 | 19 |
2176245 | 2176245 | 2022-02-02 | Slope | North Dakota | 38087 | 62 | 0 |
2176246 | 2176246 | 2022-02-02 | Stark | North Dakota | 38089 | 11056 | 80 |
2176247 | 2176247 | 2022-02-02 | Steele | North Dakota | 38091 | 375 | 2 |
2176248 | 2176248 | 2022-02-02 | Stutsman | North Dakota | 38093 | 6493 | 94 |
2176249 | 2176249 | 2022-02-02 | Towner | North Dakota | 38095 | 593 | 11 |
2176250 | 2176250 | 2022-02-02 | Traill | North Dakota | 38097 | 2056 | 22 |
2176251 | 2176251 | 2022-02-02 | Unknown | North Dakota | 0 | 47 | |
2176252 | 2176252 | 2022-02-02 | Walsh | North Dakota | 38099 | 3175 | 34 |
2176253 | 2176253 | 2022-02-02 | Ward | North Dakota | 38101 | 19590 | 243 |
2176254 | 2176254 | 2022-02-02 | Wells | North Dakota | 38103 | 978 | 11 |
2176255 | 2176255 | 2022-02-02 | Williams | North Dakota | 38105 | 10020 | 67 |
2172949 | 2172949 | 2022-02-01 | Adams | North Dakota | 38001 | 555 | 9 |
2172950 | 2172950 | 2022-02-01 | Barnes | North Dakota | 38003 | 2793 | 42 |
2172951 | 2172951 | 2022-02-01 | Benson | North Dakota | 38005 | 1791 | 22 |
2172952 | 2172952 | 2022-02-01 | Billings | North Dakota | 38007 | 138 | 1 |
2172953 | 2172953 | 2022-02-01 | Bottineau | North Dakota | 38009 | 1483 | 24 |
2172954 | 2172954 | 2022-02-01 | Bowman | North Dakota | 38011 | 783 | 9 |
2172955 | 2172955 | 2022-02-01 | Burke | North Dakota | 38013 | 421 | 3 |
2172956 | 2172956 | 2022-02-01 | Burleigh | North Dakota | 38015 | 32898 | 290 |
2172957 | 2172957 | 2022-02-01 | Cass | North Dakota | 38017 | 55560 | 307 |
2172958 | 2172958 | 2022-02-01 | Cavalier | North Dakota | 38019 | 749 | 7 |
2172959 | 2172959 | 2022-02-01 | Dickey | North Dakota | 38021 | 1416 | 38 |
2172960 | 2172960 | 2022-02-01 | Divide | North Dakota | 38023 | 442 | 4 |
2172961 | 2172961 | 2022-02-01 | Dunn | North Dakota | 38025 | 976 | 8 |
2172962 | 2172962 | 2022-02-01 | Eddy | North Dakota | 38027 | 715 | 6 |
2172963 | 2172963 | 2022-02-01 | Emmons | North Dakota | 38029 | 695 | 16 |
2172964 | 2172964 | 2022-02-01 | Foster | North Dakota | 38031 | 920 | 20 |
2172965 | 2172965 | 2022-02-01 | Golden Valley | North Dakota | 38033 | 459 | 4 |
2172966 | 2172966 | 2022-02-01 | Grand Forks | North Dakota | 38035 | 20622 | 111 |
2172967 | 2172967 | 2022-02-01 | Grant | North Dakota | 38037 | 438 | 11 |
2172968 | 2172968 | 2022-02-01 | Griggs | North Dakota | 38039 | 551 | 2 |
2172969 | 2172969 | 2022-02-01 | Hettinger | North Dakota | 38041 | 790 | 7 |
2172970 | 2172970 | 2022-02-01 | Kidder | North Dakota | 38043 | 474 | 13 |
2172971 | 2172971 | 2022-02-01 | LaMoure | North Dakota | 38045 | 936 | 19 |
2172972 | 2172972 | 2022-02-01 | Logan | North Dakota | 38047 | 418 | 11 |
2172973 | 2172973 | 2022-02-01 | McHenry | North Dakota | 38049 | 1229 | 29 |
2172974 | 2172974 | 2022-02-01 | McIntosh | North Dakota | 38051 | 612 | 9 |
2172975 | 2172975 | 2022-02-01 | McKenzie | North Dakota | 38053 | 3101 | 23 |
2172976 | 2172976 | 2022-02-01 | McLean | North Dakota | 38055 | 2614 | 48 |
2172977 | 2172977 | 2022-02-01 | Mercer | North Dakota | 38057 | 2434 | 23 |
2172978 | 2172978 | 2022-02-01 | Morton | North Dakota | 38059 | 10565 | 137 |
2172979 | 2172979 | 2022-02-01 | Mountrail | North Dakota | 38061 | 3001 | 33 |
2172980 | 2172980 | 2022-02-01 | Nelson | North Dakota | 38063 | 718 | 17 |
2172981 | 2172981 | 2022-02-01 | Oliver | North Dakota | 38065 | 312 | 4 |
2172982 | 2172982 | 2022-02-01 | Pembina | North Dakota | 38067 | 1867 | 16 |
2172983 | 2172983 | 2022-02-01 | Pierce | North Dakota | 38069 | 1016 | 30 |
2172984 | 2172984 | 2022-02-01 | Ramsey | North Dakota | 38071 | 3284 | 47 |
2172985 | 2172985 | 2022-02-01 | Ransom | North Dakota | 38073 | 1381 | 24 |
2172986 | 2172986 | 2022-02-01 | Renville | North Dakota | 38075 | 522 | 15 |
2172987 | 2172987 | 2022-02-01 | Richland | North Dakota | 38077 | 3823 | 21 |
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);