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-08-15 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 |
---|---|---|---|---|---|---|---|
436227 | 436227 | 2020-08-15 | Adams | North Dakota | 38001 | 3 | 0 |
436228 | 436228 | 2020-08-15 | Barnes | North Dakota | 38003 | 43 | 0 |
436229 | 436229 | 2020-08-15 | Benson | North Dakota | 38005 | 165 | 2 |
436230 | 436230 | 2020-08-15 | Billings | North Dakota | 38007 | 3 | 0 |
436231 | 436231 | 2020-08-15 | Bottineau | North Dakota | 38009 | 22 | 0 |
436232 | 436232 | 2020-08-15 | Bowman | North Dakota | 38011 | 11 | 0 |
436233 | 436233 | 2020-08-15 | Burke | North Dakota | 38013 | 23 | 0 |
436234 | 436234 | 2020-08-15 | Burleigh | North Dakota | 38015 | 1344 | 8 |
436235 | 436235 | 2020-08-15 | Cass | North Dakota | 38017 | 3117 | 76 |
436236 | 436236 | 2020-08-15 | Cavalier | North Dakota | 38019 | 31 | 0 |
436237 | 436237 | 2020-08-15 | Dickey | North Dakota | 38021 | 14 | 0 |
436238 | 436238 | 2020-08-15 | Divide | North Dakota | 38023 | 4 | 0 |
436239 | 436239 | 2020-08-15 | Dunn | North Dakota | 38025 | 31 | 0 |
436240 | 436240 | 2020-08-15 | Eddy | North Dakota | 38027 | 19 | 0 |
436241 | 436241 | 2020-08-15 | Emmons | North Dakota | 38029 | 23 | 1 |
436242 | 436242 | 2020-08-15 | Foster | North Dakota | 38031 | 26 | 0 |
436243 | 436243 | 2020-08-15 | Golden Valley | North Dakota | 38033 | 11 | 0 |
436244 | 436244 | 2020-08-15 | Grand Forks | North Dakota | 38035 | 775 | 8 |
436245 | 436245 | 2020-08-15 | Grant | North Dakota | 38037 | 4 | 0 |
436246 | 436246 | 2020-08-15 | Griggs | North Dakota | 38039 | 37 | 1 |
436247 | 436247 | 2020-08-15 | Hettinger | North Dakota | 38041 | 7 | 0 |
436248 | 436248 | 2020-08-15 | Kidder | North Dakota | 38043 | 22 | 0 |
436249 | 436249 | 2020-08-15 | LaMoure | North Dakota | 38045 | 16 | 0 |
436250 | 436250 | 2020-08-15 | Logan | North Dakota | 38047 | 7 | 0 |
436251 | 436251 | 2020-08-15 | McHenry | North Dakota | 38049 | 21 | 1 |
436252 | 436252 | 2020-08-15 | McIntosh | North Dakota | 38051 | 41 | 2 |
436253 | 436253 | 2020-08-15 | McKenzie | North Dakota | 38053 | 92 | 2 |
436254 | 436254 | 2020-08-15 | McLean | North Dakota | 38055 | 98 | 0 |
436255 | 436255 | 2020-08-15 | Mercer | North Dakota | 38057 | 34 | 0 |
436256 | 436256 | 2020-08-15 | Morton | North Dakota | 38059 | 440 | 4 |
436257 | 436257 | 2020-08-15 | Mountrail | North Dakota | 38061 | 151 | 1 |
436258 | 436258 | 2020-08-15 | Nelson | North Dakota | 38063 | 27 | 0 |
436259 | 436259 | 2020-08-15 | Oliver | North Dakota | 38065 | 7 | 0 |
436260 | 436260 | 2020-08-15 | Pembina | North Dakota | 38067 | 27 | 0 |
436261 | 436261 | 2020-08-15 | Pierce | North Dakota | 38069 | 16 | 0 |
436262 | 436262 | 2020-08-15 | Ramsey | North Dakota | 38071 | 85 | 2 |
436263 | 436263 | 2020-08-15 | Ransom | North Dakota | 38073 | 28 | 0 |
436264 | 436264 | 2020-08-15 | Renville | North Dakota | 38075 | 10 | 0 |
436265 | 436265 | 2020-08-15 | Richland | North Dakota | 38077 | 115 | 1 |
436266 | 436266 | 2020-08-15 | Rolette | North Dakota | 38079 | 88 | 0 |
436267 | 436267 | 2020-08-15 | Sargent | North Dakota | 38081 | 10 | 0 |
436268 | 436268 | 2020-08-15 | Sheridan | North Dakota | 38083 | 9 | 0 |
436269 | 436269 | 2020-08-15 | Sioux | North Dakota | 38085 | 93 | 1 |
436270 | 436270 | 2020-08-15 | Slope | North Dakota | 38087 | 4 | 0 |
436271 | 436271 | 2020-08-15 | Stark | North Dakota | 38089 | 375 | 5 |
436272 | 436272 | 2020-08-15 | Steele | North Dakota | 38091 | 16 | 0 |
436273 | 436273 | 2020-08-15 | Stutsman | North Dakota | 38093 | 130 | 3 |
436274 | 436274 | 2020-08-15 | Towner | North Dakota | 38095 | 5 | 0 |
436275 | 436275 | 2020-08-15 | Traill | North Dakota | 38097 | 62 | 0 |
436276 | 436276 | 2020-08-15 | Unknown | North Dakota | 4 | 4 | |
436277 | 436277 | 2020-08-15 | Walsh | North Dakota | 38099 | 114 | 0 |
436278 | 436278 | 2020-08-15 | Ward | North Dakota | 38101 | 263 | 1 |
436279 | 436279 | 2020-08-15 | Wells | North Dakota | 38103 | 24 | 0 |
436280 | 436280 | 2020-08-15 | Williams | North Dakota | 38105 | 301 | 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);