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 2021-01-07 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
906216 | 906216 | 2021-01-07 | Adams | North Dakota | 38001 | 195 | 2 |
906217 | 906217 | 2021-01-07 | Barnes | North Dakota | 38003 | 1265 | 29 |
906218 | 906218 | 2021-01-07 | Benson | North Dakota | 38005 | 1002 | 17 |
906219 | 906219 | 2021-01-07 | Billings | North Dakota | 38007 | 50 | 0 |
906220 | 906220 | 2021-01-07 | Bottineau | North Dakota | 38009 | 618 | 20 |
906221 | 906221 | 2021-01-07 | Bowman | North Dakota | 38011 | 312 | 4 |
906222 | 906222 | 2021-01-07 | Burke | North Dakota | 38013 | 201 | 1 |
906223 | 906223 | 2021-01-07 | Burleigh | North Dakota | 38015 | 13818 | 179 |
906224 | 906224 | 2021-01-07 | Cass | North Dakota | 38017 | 20260 | 174 |
906225 | 906225 | 2021-01-07 | Cavalier | North Dakota | 38019 | 410 | 4 |
906226 | 906226 | 2021-01-07 | Dickey | North Dakota | 38021 | 702 | 32 |
906227 | 906227 | 2021-01-07 | Divide | North Dakota | 38023 | 141 | 2 |
906228 | 906228 | 2021-01-07 | Dunn | North Dakota | 38025 | 359 | 7 |
906229 | 906229 | 2021-01-07 | Eddy | North Dakota | 38027 | 416 | 6 |
906230 | 906230 | 2021-01-07 | Emmons | North Dakota | 38029 | 391 | 10 |
906231 | 906231 | 2021-01-07 | Foster | North Dakota | 38031 | 533 | 19 |
906232 | 906232 | 2021-01-07 | Golden Valley | North Dakota | 38033 | 206 | 0 |
906233 | 906233 | 2021-01-07 | Grand Forks | North Dakota | 38035 | 9360 | 68 |
906234 | 906234 | 2021-01-07 | Grant | North Dakota | 38037 | 175 | 7 |
906235 | 906235 | 2021-01-07 | Griggs | North Dakota | 38039 | 307 | 2 |
906236 | 906236 | 2021-01-07 | Hettinger | North Dakota | 38041 | 274 | 4 |
906237 | 906237 | 2021-01-07 | Kidder | North Dakota | 38043 | 249 | 9 |
906238 | 906238 | 2021-01-07 | LaMoure | North Dakota | 38045 | 492 | 16 |
906239 | 906239 | 2021-01-07 | Logan | North Dakota | 38047 | 218 | 8 |
906240 | 906240 | 2021-01-07 | McHenry | North Dakota | 38049 | 544 | 19 |
906241 | 906241 | 2021-01-07 | McIntosh | North Dakota | 38051 | 318 | 7 |
906242 | 906242 | 2021-01-07 | McKenzie | North Dakota | 38053 | 1061 | 11 |
906243 | 906243 | 2021-01-07 | McLean | North Dakota | 38055 | 1139 | 28 |
906244 | 906244 | 2021-01-07 | Mercer | North Dakota | 38057 | 1022 | 9 |
906245 | 906245 | 2021-01-07 | Morton | North Dakota | 38059 | 4696 | 91 |
906246 | 906246 | 2021-01-07 | Mountrail | North Dakota | 38061 | 1221 | 15 |
906247 | 906247 | 2021-01-07 | Nelson | North Dakota | 38063 | 423 | 12 |
906248 | 906248 | 2021-01-07 | Oliver | North Dakota | 38065 | 149 | 2 |
906249 | 906249 | 2021-01-07 | Pembina | North Dakota | 38067 | 703 | 10 |
906250 | 906250 | 2021-01-07 | Pierce | North Dakota | 38069 | 498 | 22 |
906251 | 906251 | 2021-01-07 | Ramsey | North Dakota | 38071 | 1503 | 28 |
906252 | 906252 | 2021-01-07 | Ransom | North Dakota | 38073 | 574 | 12 |
906253 | 906253 | 2021-01-07 | Renville | North Dakota | 38075 | 281 | 12 |
906254 | 906254 | 2021-01-07 | Richland | North Dakota | 38077 | 1584 | 15 |
906255 | 906255 | 2021-01-07 | Rolette | North Dakota | 38079 | 1974 | 24 |
906256 | 906256 | 2021-01-07 | Sargent | North Dakota | 38081 | 410 | 5 |
906257 | 906257 | 2021-01-07 | Sheridan | North Dakota | 38083 | 99 | 2 |
906258 | 906258 | 2021-01-07 | Sioux | North Dakota | 38085 | 621 | 11 |
906259 | 906259 | 2021-01-07 | Slope | North Dakota | 38087 | 30 | 0 |
906260 | 906260 | 2021-01-07 | Stark | North Dakota | 38089 | 4134 | 47 |
906261 | 906261 | 2021-01-07 | Steele | North Dakota | 38091 | 167 | 2 |
906262 | 906262 | 2021-01-07 | Stutsman | North Dakota | 38093 | 3180 | 70 |
906263 | 906263 | 2021-01-07 | Towner | North Dakota | 38095 | 279 | 10 |
906264 | 906264 | 2021-01-07 | Traill | North Dakota | 38097 | 922 | 17 |
906265 | 906265 | 2021-01-07 | Unknown | North Dakota | 7 | 7 | |
906266 | 906266 | 2021-01-07 | Walsh | North Dakota | 38099 | 1656 | 22 |
906267 | 906267 | 2021-01-07 | Ward | North Dakota | 38101 | 8569 | 177 |
906268 | 906268 | 2021-01-07 | Wells | North Dakota | 38103 | 408 | 8 |
906269 | 906269 | 2021-01-07 | Williams | North Dakota | 38105 | 4037 | 33 |
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);