ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-11-27 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 54
- 38001 1
- 38003 1
- 38005 1
- 38007 1
- 38009 1
- 38011 1
- 38013 1
- 38015 1
- 38017 1
- 38019 1
- 38021 1
- 38023 1
- 38025 1
- 38027 1
- 38029 1
- 38031 1
- 38033 1
- 38035 1
- 38037 1
- 38039 1
- 38041 1
- 38043 1
- 38045 1
- 38047 1
- 38049 1
- 38051 1
- 38053 1
- 38055 1
- 38057 1
- 38059 1
- 38061 1
- 38063 1
- 38065 1
- 38067 1
- 38069 1
- 38071 1
- 38073 1
- 38075 1
- 38077 1
- 38079 1
- 38081 1
- 38083 1
- 38085 1
- 38087 1
- 38089 1
- 38091 1
- 38093 1
- 38095 1
- 38097 1
- 38099 1
- 38101 1
- 38103 1
- 38105 1
- - 1
county 54
- Adams 1
- Barnes 1
- Benson 1
- Billings 1
- Bottineau 1
- Bowman 1
- Burke 1
- Burleigh 1
- Cass 1
- Cavalier 1
- Dickey 1
- Divide 1
- Dunn 1
- Eddy 1
- Emmons 1
- Foster 1
- Golden Valley 1
- Grand Forks 1
- Grant 1
- Griggs 1
- Hettinger 1
- Kidder 1
- LaMoure 1
- Logan 1
- McHenry 1
- McIntosh 1
- McKenzie 1
- McLean 1
- Mercer 1
- Morton 1
- Mountrail 1
- Nelson 1
- Oliver 1
- Pembina 1
- Pierce 1
- Ramsey 1
- Ransom 1
- Renville 1
- Richland 1
- Rolette 1
- Sargent 1
- Sheridan 1
- Sioux 1
- Slope 1
- Stark 1
- Steele 1
- Stutsman 1
- Towner 1
- Traill 1
- Unknown 1
- Walsh 1
- Ward 1
- Wells 1
- Williams 1
state 1
- North Dakota · 54 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
773156 | 773156 | 2020-11-27 | Adams | North Dakota | 38001 | 165 | 0 |
773157 | 773157 | 2020-11-27 | Barnes | North Dakota | 38003 | 985 | 14 |
773158 | 773158 | 2020-11-27 | Benson | North Dakota | 38005 | 752 | 13 |
773159 | 773159 | 2020-11-27 | Billings | North Dakota | 38007 | 39 | 0 |
773160 | 773160 | 2020-11-27 | Bottineau | North Dakota | 38009 | 532 | 19 |
773161 | 773161 | 2020-11-27 | Bowman | North Dakota | 38011 | 185 | 3 |
773162 | 773162 | 2020-11-27 | Burke | North Dakota | 38013 | 175 | 1 |
773163 | 773163 | 2020-11-27 | Burleigh | North Dakota | 38015 | 11711 | 119 |
773164 | 773164 | 2020-11-27 | Cass | North Dakota | 38017 | 16356 | 123 |
773165 | 773165 | 2020-11-27 | Cavalier | North Dakota | 38019 | 357 | 2 |
773166 | 773166 | 2020-11-27 | Dickey | North Dakota | 38021 | 537 | 28 |
773167 | 773167 | 2020-11-27 | Divide | North Dakota | 38023 | 121 | 1 |
773168 | 773168 | 2020-11-27 | Dunn | North Dakota | 38025 | 296 | 6 |
773169 | 773169 | 2020-11-27 | Eddy | North Dakota | 38027 | 359 | 4 |
773170 | 773170 | 2020-11-27 | Emmons | North Dakota | 38029 | 349 | 9 |
773171 | 773171 | 2020-11-27 | Foster | North Dakota | 38031 | 476 | 11 |
773172 | 773172 | 2020-11-27 | Golden Valley | North Dakota | 38033 | 155 | 0 |
773173 | 773173 | 2020-11-27 | Grand Forks | North Dakota | 38035 | 8013 | 41 |
773174 | 773174 | 2020-11-27 | Grant | North Dakota | 38037 | 154 | 5 |
773175 | 773175 | 2020-11-27 | Griggs | North Dakota | 38039 | 245 | 1 |
773176 | 773176 | 2020-11-27 | Hettinger | North Dakota | 38041 | 230 | 3 |
773177 | 773177 | 2020-11-27 | Kidder | North Dakota | 38043 | 189 | 6 |
773178 | 773178 | 2020-11-27 | LaMoure | North Dakota | 38045 | 369 | 14 |
773179 | 773179 | 2020-11-27 | Logan | North Dakota | 38047 | 155 | 6 |
773180 | 773180 | 2020-11-27 | McHenry | North Dakota | 38049 | 442 | 17 |
773181 | 773181 | 2020-11-27 | McIntosh | North Dakota | 38051 | 236 | 6 |
773182 | 773182 | 2020-11-27 | McKenzie | North Dakota | 38053 | 874 | 6 |
773183 | 773183 | 2020-11-27 | McLean | North Dakota | 38055 | 965 | 14 |
773184 | 773184 | 2020-11-27 | Mercer | North Dakota | 38057 | 833 | 5 |
773185 | 773185 | 2020-11-27 | Morton | North Dakota | 38059 | 3974 | 68 |
773186 | 773186 | 2020-11-27 | Mountrail | North Dakota | 38061 | 1056 | 13 |
773187 | 773187 | 2020-11-27 | Nelson | North Dakota | 38063 | 353 | 10 |
773188 | 773188 | 2020-11-27 | Oliver | North Dakota | 38065 | 123 | 2 |
773189 | 773189 | 2020-11-27 | Pembina | North Dakota | 38067 | 606 | 5 |
773190 | 773190 | 2020-11-27 | Pierce | North Dakota | 38069 | 415 | 7 |
773191 | 773191 | 2020-11-27 | Ramsey | North Dakota | 38071 | 1118 | 8 |
773192 | 773192 | 2020-11-27 | Ransom | North Dakota | 38073 | 439 | 8 |
773193 | 773193 | 2020-11-27 | Renville | North Dakota | 38075 | 229 | 2 |
773194 | 773194 | 2020-11-27 | Richland | North Dakota | 38077 | 1112 | 11 |
773195 | 773195 | 2020-11-27 | Rolette | North Dakota | 38079 | 1367 | 14 |
773196 | 773196 | 2020-11-27 | Sargent | North Dakota | 38081 | 305 | 4 |
773197 | 773197 | 2020-11-27 | Sheridan | North Dakota | 38083 | 77 | 1 |
773198 | 773198 | 2020-11-27 | Sioux | North Dakota | 38085 | 481 | 6 |
773199 | 773199 | 2020-11-27 | Slope | North Dakota | 38087 | 19 | 0 |
773200 | 773200 | 2020-11-27 | Stark | North Dakota | 38089 | 3498 | 39 |
773201 | 773201 | 2020-11-27 | Steele | North Dakota | 38091 | 127 | 1 |
773202 | 773202 | 2020-11-27 | Stutsman | North Dakota | 38093 | 2584 | 42 |
773203 | 773203 | 2020-11-27 | Towner | North Dakota | 38095 | 205 | 9 |
773204 | 773204 | 2020-11-27 | Traill | North Dakota | 38097 | 732 | 10 |
773205 | 773205 | 2020-11-27 | Unknown | North Dakota | 6 | 6 | |
773206 | 773206 | 2020-11-27 | Walsh | North Dakota | 38099 | 1418 | 12 |
773207 | 773207 | 2020-11-27 | Ward | North Dakota | 38101 | 7466 | 127 |
773208 | 773208 | 2020-11-27 | Wells | North Dakota | 38103 | 297 | 3 |
773209 | 773209 | 2020-11-27 | Williams | North Dakota | 38105 | 2976 | 23 |
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);