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-06 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 |
---|---|---|---|---|---|---|---|
407223 | 407223 | 2020-08-06 | Adams | North Dakota | 38001 | 2 | 0 |
407224 | 407224 | 2020-08-06 | Barnes | North Dakota | 38003 | 37 | 0 |
407225 | 407225 | 2020-08-06 | Benson | North Dakota | 38005 | 131 | 1 |
407226 | 407226 | 2020-08-06 | Billings | North Dakota | 38007 | 2 | 0 |
407227 | 407227 | 2020-08-06 | Bottineau | North Dakota | 38009 | 18 | 0 |
407228 | 407228 | 2020-08-06 | Bowman | North Dakota | 38011 | 6 | 0 |
407229 | 407229 | 2020-08-06 | Burke | North Dakota | 38013 | 23 | 0 |
407230 | 407230 | 2020-08-06 | Burleigh | North Dakota | 38015 | 1082 | 5 |
407231 | 407231 | 2020-08-06 | Cass | North Dakota | 38017 | 2977 | 76 |
407232 | 407232 | 2020-08-06 | Cavalier | North Dakota | 38019 | 31 | 0 |
407233 | 407233 | 2020-08-06 | Dickey | North Dakota | 38021 | 12 | 0 |
407234 | 407234 | 2020-08-06 | Divide | North Dakota | 38023 | 1 | 0 |
407235 | 407235 | 2020-08-06 | Dunn | North Dakota | 38025 | 30 | 0 |
407236 | 407236 | 2020-08-06 | Eddy | North Dakota | 38027 | 17 | 0 |
407237 | 407237 | 2020-08-06 | Emmons | North Dakota | 38029 | 17 | 1 |
407238 | 407238 | 2020-08-06 | Foster | North Dakota | 38031 | 23 | 0 |
407239 | 407239 | 2020-08-06 | Golden Valley | North Dakota | 38033 | 4 | 0 |
407240 | 407240 | 2020-08-06 | Grand Forks | North Dakota | 38035 | 657 | 6 |
407241 | 407241 | 2020-08-06 | Grant | North Dakota | 38037 | 4 | 0 |
407242 | 407242 | 2020-08-06 | Griggs | North Dakota | 38039 | 31 | 1 |
407243 | 407243 | 2020-08-06 | Hettinger | North Dakota | 38041 | 6 | 0 |
407244 | 407244 | 2020-08-06 | Kidder | North Dakota | 38043 | 13 | 0 |
407245 | 407245 | 2020-08-06 | LaMoure | North Dakota | 38045 | 16 | 0 |
407246 | 407246 | 2020-08-06 | Logan | North Dakota | 38047 | 7 | 0 |
407247 | 407247 | 2020-08-06 | McHenry | North Dakota | 38049 | 16 | 1 |
407248 | 407248 | 2020-08-06 | McIntosh | North Dakota | 38051 | 27 | 2 |
407249 | 407249 | 2020-08-06 | McKenzie | North Dakota | 38053 | 85 | 1 |
407250 | 407250 | 2020-08-06 | McLean | North Dakota | 38055 | 46 | 0 |
407251 | 407251 | 2020-08-06 | Mercer | North Dakota | 38057 | 24 | 0 |
407252 | 407252 | 2020-08-06 | Morton | North Dakota | 38059 | 314 | 3 |
407253 | 407253 | 2020-08-06 | Mountrail | North Dakota | 38061 | 123 | 1 |
407254 | 407254 | 2020-08-06 | Nelson | North Dakota | 38063 | 22 | 0 |
407255 | 407255 | 2020-08-06 | Oliver | North Dakota | 38065 | 7 | 0 |
407256 | 407256 | 2020-08-06 | Pembina | North Dakota | 38067 | 28 | 0 |
407257 | 407257 | 2020-08-06 | Pierce | North Dakota | 38069 | 11 | 0 |
407258 | 407258 | 2020-08-06 | Ramsey | North Dakota | 38071 | 65 | 2 |
407259 | 407259 | 2020-08-06 | Ransom | North Dakota | 38073 | 26 | 0 |
407260 | 407260 | 2020-08-06 | Renville | North Dakota | 38075 | 8 | 0 |
407261 | 407261 | 2020-08-06 | Richland | North Dakota | 38077 | 101 | 0 |
407262 | 407262 | 2020-08-06 | Rolette | North Dakota | 38079 | 48 | 0 |
407263 | 407263 | 2020-08-06 | Sargent | North Dakota | 38081 | 10 | 0 |
407264 | 407264 | 2020-08-06 | Sheridan | North Dakota | 38083 | 6 | 0 |
407265 | 407265 | 2020-08-06 | Sioux | North Dakota | 38085 | 60 | 1 |
407266 | 407266 | 2020-08-06 | Slope | North Dakota | 38087 | 3 | 0 |
407267 | 407267 | 2020-08-06 | Stark | North Dakota | 38089 | 229 | 3 |
407268 | 407268 | 2020-08-06 | Steele | North Dakota | 38091 | 13 | 0 |
407269 | 407269 | 2020-08-06 | Stutsman | North Dakota | 38093 | 125 | 2 |
407270 | 407270 | 2020-08-06 | Towner | North Dakota | 38095 | 5 | 0 |
407271 | 407271 | 2020-08-06 | Traill | North Dakota | 38097 | 50 | 0 |
407272 | 407272 | 2020-08-06 | Unknown | North Dakota | 4 | 4 | |
407273 | 407273 | 2020-08-06 | Walsh | North Dakota | 38099 | 103 | 0 |
407274 | 407274 | 2020-08-06 | Ward | North Dakota | 38101 | 204 | 1 |
407275 | 407275 | 2020-08-06 | Wells | North Dakota | 38103 | 21 | 0 |
407276 | 407276 | 2020-08-06 | Williams | North Dakota | 38105 | 250 | 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);