ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where "date" is on date 2020-07-08 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 |
---|---|---|---|---|---|---|---|
314318 | 314318 | 2020-07-08 | Barnes | North Dakota | 38003 | 23 | 0 |
314319 | 314319 | 2020-07-08 | Benson | North Dakota | 38005 | 9 | 0 |
314320 | 314320 | 2020-07-08 | Billings | North Dakota | 38007 | 1 | 0 |
314321 | 314321 | 2020-07-08 | Bottineau | North Dakota | 38009 | 5 | 0 |
314322 | 314322 | 2020-07-08 | Bowman | North Dakota | 38011 | 1 | 0 |
314323 | 314323 | 2020-07-08 | Burke | North Dakota | 38013 | 6 | 0 |
314324 | 314324 | 2020-07-08 | Burleigh | North Dakota | 38015 | 363 | 0 |
314325 | 314325 | 2020-07-08 | Cass | North Dakota | 38017 | 2373 | 70 |
314326 | 314326 | 2020-07-08 | Cavalier | North Dakota | 38019 | 6 | 0 |
314327 | 314327 | 2020-07-08 | Dickey | North Dakota | 38021 | 4 | 0 |
314328 | 314328 | 2020-07-08 | Divide | North Dakota | 38023 | 1 | 0 |
314329 | 314329 | 2020-07-08 | Dunn | North Dakota | 38025 | 15 | 0 |
314330 | 314330 | 2020-07-08 | Eddy | North Dakota | 38027 | 5 | 0 |
314331 | 314331 | 2020-07-08 | Emmons | North Dakota | 38029 | 4 | 1 |
314332 | 314332 | 2020-07-08 | Foster | North Dakota | 38031 | 4 | 0 |
314333 | 314333 | 2020-07-08 | Grand Forks | North Dakota | 38035 | 411 | 4 |
314334 | 314334 | 2020-07-08 | Grant | North Dakota | 38037 | 3 | 0 |
314335 | 314335 | 2020-07-08 | Griggs | North Dakota | 38039 | 2 | 0 |
314336 | 314336 | 2020-07-08 | Hettinger | North Dakota | 38041 | 1 | 0 |
314337 | 314337 | 2020-07-08 | Kidder | North Dakota | 38043 | 2 | 0 |
314338 | 314338 | 2020-07-08 | LaMoure | North Dakota | 38045 | 13 | 0 |
314339 | 314339 | 2020-07-08 | Logan | North Dakota | 38047 | 1 | 0 |
314340 | 314340 | 2020-07-08 | McHenry | North Dakota | 38049 | 6 | 1 |
314341 | 314341 | 2020-07-08 | McIntosh | North Dakota | 38051 | 3 | 0 |
314342 | 314342 | 2020-07-08 | McKenzie | North Dakota | 38053 | 29 | 0 |
314343 | 314343 | 2020-07-08 | McLean | North Dakota | 38055 | 11 | 0 |
314344 | 314344 | 2020-07-08 | Mercer | North Dakota | 38057 | 7 | 0 |
314345 | 314345 | 2020-07-08 | Morton | North Dakota | 38059 | 116 | 2 |
314346 | 314346 | 2020-07-08 | Mountrail | North Dakota | 38061 | 54 | 0 |
314347 | 314347 | 2020-07-08 | Nelson | North Dakota | 38063 | 2 | 0 |
314348 | 314348 | 2020-07-08 | Oliver | North Dakota | 38065 | 2 | 0 |
314349 | 314349 | 2020-07-08 | Pembina | North Dakota | 38067 | 13 | 0 |
314350 | 314350 | 2020-07-08 | Pierce | North Dakota | 38069 | 6 | 0 |
314351 | 314351 | 2020-07-08 | Ramsey | North Dakota | 38071 | 18 | 1 |
314352 | 314352 | 2020-07-08 | Ransom | North Dakota | 38073 | 19 | 0 |
314353 | 314353 | 2020-07-08 | Renville | North Dakota | 38075 | 5 | 0 |
314354 | 314354 | 2020-07-08 | Richland | North Dakota | 38077 | 43 | 0 |
314355 | 314355 | 2020-07-08 | Rolette | North Dakota | 38079 | 11 | 0 |
314356 | 314356 | 2020-07-08 | Sargent | North Dakota | 38081 | 7 | 0 |
314357 | 314357 | 2020-07-08 | Sheridan | North Dakota | 38083 | 2 | 0 |
314358 | 314358 | 2020-07-08 | Sioux | North Dakota | 38085 | 29 | 0 |
314359 | 314359 | 2020-07-08 | Slope | North Dakota | 38087 | 3 | 0 |
314360 | 314360 | 2020-07-08 | Stark | North Dakota | 38089 | 83 | 3 |
314361 | 314361 | 2020-07-08 | Steele | North Dakota | 38091 | 3 | 0 |
314362 | 314362 | 2020-07-08 | Stutsman | North Dakota | 38093 | 65 | 2 |
314363 | 314363 | 2020-07-08 | Towner | North Dakota | 38095 | 1 | 0 |
314364 | 314364 | 2020-07-08 | Traill | North Dakota | 38097 | 22 | 0 |
314365 | 314365 | 2020-07-08 | Unknown | North Dakota | 4 | 4 | |
314366 | 314366 | 2020-07-08 | Walsh | North Dakota | 38099 | 31 | 0 |
314367 | 314367 | 2020-07-08 | Ward | North Dakota | 38101 | 65 | 1 |
314368 | 314368 | 2020-07-08 | Wells | North Dakota | 38103 | 9 | 0 |
314369 | 314369 | 2020-07-08 | Williams | North Dakota | 38105 | 53 | 0 |
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);