ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where date = "2020-06-09" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
223419 | 223419 | 2020-06-09 | Barnes | North Dakota | 38003 | 9 | 0 |
223420 | 223420 | 2020-06-09 | Benson | North Dakota | 38005 | 3 | 0 |
223421 | 223421 | 2020-06-09 | Bottineau | North Dakota | 38009 | 4 | 0 |
223422 | 223422 | 2020-06-09 | Bowman | North Dakota | 38011 | 1 | 0 |
223423 | 223423 | 2020-06-09 | Burke | North Dakota | 38013 | 5 | 0 |
223424 | 223424 | 2020-06-09 | Burleigh | North Dakota | 38015 | 144 | 0 |
223425 | 223425 | 2020-06-09 | Cass | North Dakota | 38017 | 1930 | 60 |
223426 | 223426 | 2020-06-09 | Dickey | North Dakota | 38021 | 1 | 0 |
223427 | 223427 | 2020-06-09 | Divide | North Dakota | 38023 | 1 | 0 |
223428 | 223428 | 2020-06-09 | Dunn | North Dakota | 38025 | 11 | 0 |
223429 | 223429 | 2020-06-09 | Eddy | North Dakota | 38027 | 5 | 0 |
223430 | 223430 | 2020-06-09 | Emmons | North Dakota | 38029 | 4 | 1 |
223431 | 223431 | 2020-06-09 | Foster | North Dakota | 38031 | 1 | 0 |
223432 | 223432 | 2020-06-09 | Grand Forks | North Dakota | 38035 | 339 | 4 |
223433 | 223433 | 2020-06-09 | Grant | North Dakota | 38037 | 2 | 0 |
223434 | 223434 | 2020-06-09 | Griggs | North Dakota | 38039 | 1 | 0 |
223435 | 223435 | 2020-06-09 | Kidder | North Dakota | 38043 | 1 | 0 |
223436 | 223436 | 2020-06-09 | LaMoure | North Dakota | 38045 | 1 | 0 |
223437 | 223437 | 2020-06-09 | McHenry | North Dakota | 38049 | 2 | 1 |
223438 | 223438 | 2020-06-09 | McIntosh | North Dakota | 38051 | 1 | 0 |
223439 | 223439 | 2020-06-09 | McKenzie | North Dakota | 38053 | 18 | 0 |
223440 | 223440 | 2020-06-09 | McLean | North Dakota | 38055 | 8 | 0 |
223441 | 223441 | 2020-06-09 | Mercer | North Dakota | 38057 | 6 | 0 |
223442 | 223442 | 2020-06-09 | Morton | North Dakota | 38059 | 60 | 2 |
223443 | 223443 | 2020-06-09 | Mountrail | North Dakota | 38061 | 43 | 0 |
223444 | 223444 | 2020-06-09 | Nelson | North Dakota | 38063 | 1 | 0 |
223445 | 223445 | 2020-06-09 | Oliver | North Dakota | 38065 | 1 | 0 |
223446 | 223446 | 2020-06-09 | Pembina | North Dakota | 38067 | 6 | 0 |
223447 | 223447 | 2020-06-09 | Pierce | North Dakota | 38069 | 3 | 0 |
223448 | 223448 | 2020-06-09 | Ramsey | North Dakota | 38071 | 8 | 1 |
223449 | 223449 | 2020-06-09 | Ransom | North Dakota | 38073 | 11 | 0 |
223450 | 223450 | 2020-06-09 | Renville | North Dakota | 38075 | 3 | 0 |
223451 | 223451 | 2020-06-09 | Richland | North Dakota | 38077 | 30 | 0 |
223452 | 223452 | 2020-06-09 | Rolette | North Dakota | 38079 | 7 | 0 |
223453 | 223453 | 2020-06-09 | Sargent | North Dakota | 38081 | 4 | 0 |
223454 | 223454 | 2020-06-09 | Sheridan | North Dakota | 38083 | 1 | 0 |
223455 | 223455 | 2020-06-09 | Sioux | North Dakota | 38085 | 2 | 0 |
223456 | 223456 | 2020-06-09 | Slope | North Dakota | 38087 | 3 | 0 |
223457 | 223457 | 2020-06-09 | Stark | North Dakota | 38089 | 63 | 2 |
223458 | 223458 | 2020-06-09 | Steele | North Dakota | 38091 | 1 | 0 |
223459 | 223459 | 2020-06-09 | Stutsman | North Dakota | 38093 | 49 | 0 |
223460 | 223460 | 2020-06-09 | Traill | North Dakota | 38097 | 14 | 0 |
223461 | 223461 | 2020-06-09 | Unknown | North Dakota | 3 | 3 | |
223462 | 223462 | 2020-06-09 | Walsh | North Dakota | 38099 | 16 | 0 |
223463 | 223463 | 2020-06-09 | Ward | North Dakota | 38101 | 44 | 1 |
223464 | 223464 | 2020-06-09 | Wells | North Dakota | 38103 | 8 | 0 |
223465 | 223465 | 2020-06-09 | Williams | North Dakota | 38105 | 25 | 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);