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-10 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
420104 | 420104 | 2020-08-10 | Adams | North Dakota | 38001 | 3 | 0 |
420105 | 420105 | 2020-08-10 | Barnes | North Dakota | 38003 | 39 | 0 |
420106 | 420106 | 2020-08-10 | Benson | North Dakota | 38005 | 137 | 2 |
420107 | 420107 | 2020-08-10 | Billings | North Dakota | 38007 | 2 | 0 |
420108 | 420108 | 2020-08-10 | Bottineau | North Dakota | 38009 | 19 | 0 |
420109 | 420109 | 2020-08-10 | Bowman | North Dakota | 38011 | 8 | 0 |
420110 | 420110 | 2020-08-10 | Burke | North Dakota | 38013 | 23 | 0 |
420111 | 420111 | 2020-08-10 | Burleigh | North Dakota | 38015 | 1201 | 6 |
420112 | 420112 | 2020-08-10 | Cass | North Dakota | 38017 | 3046 | 76 |
420113 | 420113 | 2020-08-10 | Cavalier | North Dakota | 38019 | 31 | 0 |
420114 | 420114 | 2020-08-10 | Dickey | North Dakota | 38021 | 13 | 0 |
420115 | 420115 | 2020-08-10 | Divide | North Dakota | 38023 | 2 | 0 |
420116 | 420116 | 2020-08-10 | Dunn | North Dakota | 38025 | 30 | 0 |
420117 | 420117 | 2020-08-10 | Eddy | North Dakota | 38027 | 18 | 0 |
420118 | 420118 | 2020-08-10 | Emmons | North Dakota | 38029 | 17 | 1 |
420119 | 420119 | 2020-08-10 | Foster | North Dakota | 38031 | 26 | 0 |
420120 | 420120 | 2020-08-10 | Golden Valley | North Dakota | 38033 | 5 | 0 |
420121 | 420121 | 2020-08-10 | Grand Forks | North Dakota | 38035 | 683 | 6 |
420122 | 420122 | 2020-08-10 | Grant | North Dakota | 38037 | 4 | 0 |
420123 | 420123 | 2020-08-10 | Griggs | North Dakota | 38039 | 34 | 1 |
420124 | 420124 | 2020-08-10 | Hettinger | North Dakota | 38041 | 6 | 0 |
420125 | 420125 | 2020-08-10 | Kidder | North Dakota | 38043 | 18 | 0 |
420126 | 420126 | 2020-08-10 | LaMoure | North Dakota | 38045 | 16 | 0 |
420127 | 420127 | 2020-08-10 | Logan | North Dakota | 38047 | 7 | 0 |
420128 | 420128 | 2020-08-10 | McHenry | North Dakota | 38049 | 17 | 1 |
420129 | 420129 | 2020-08-10 | McIntosh | North Dakota | 38051 | 37 | 2 |
420130 | 420130 | 2020-08-10 | McKenzie | North Dakota | 38053 | 90 | 1 |
420131 | 420131 | 2020-08-10 | McLean | North Dakota | 38055 | 72 | 0 |
420132 | 420132 | 2020-08-10 | Mercer | North Dakota | 38057 | 29 | 0 |
420133 | 420133 | 2020-08-10 | Morton | North Dakota | 38059 | 383 | 3 |
420134 | 420134 | 2020-08-10 | Mountrail | North Dakota | 38061 | 135 | 1 |
420135 | 420135 | 2020-08-10 | Nelson | North Dakota | 38063 | 26 | 0 |
420136 | 420136 | 2020-08-10 | Oliver | North Dakota | 38065 | 7 | 0 |
420137 | 420137 | 2020-08-10 | Pembina | North Dakota | 38067 | 27 | 0 |
420138 | 420138 | 2020-08-10 | Pierce | North Dakota | 38069 | 12 | 0 |
420139 | 420139 | 2020-08-10 | Ramsey | North Dakota | 38071 | 70 | 2 |
420140 | 420140 | 2020-08-10 | Ransom | North Dakota | 38073 | 28 | 0 |
420141 | 420141 | 2020-08-10 | Renville | North Dakota | 38075 | 9 | 0 |
420142 | 420142 | 2020-08-10 | Richland | North Dakota | 38077 | 109 | 1 |
420143 | 420143 | 2020-08-10 | Rolette | North Dakota | 38079 | 73 | 0 |
420144 | 420144 | 2020-08-10 | Sargent | North Dakota | 38081 | 10 | 0 |
420145 | 420145 | 2020-08-10 | Sheridan | North Dakota | 38083 | 9 | 0 |
420146 | 420146 | 2020-08-10 | Sioux | North Dakota | 38085 | 83 | 1 |
420147 | 420147 | 2020-08-10 | Slope | North Dakota | 38087 | 3 | 0 |
420148 | 420148 | 2020-08-10 | Stark | North Dakota | 38089 | 264 | 3 |
420149 | 420149 | 2020-08-10 | Steele | North Dakota | 38091 | 14 | 0 |
420150 | 420150 | 2020-08-10 | Stutsman | North Dakota | 38093 | 127 | 3 |
420151 | 420151 | 2020-08-10 | Towner | North Dakota | 38095 | 5 | 0 |
420152 | 420152 | 2020-08-10 | Traill | North Dakota | 38097 | 55 | 0 |
420153 | 420153 | 2020-08-10 | Unknown | North Dakota | 4 | 4 | |
420154 | 420154 | 2020-08-10 | Walsh | North Dakota | 38099 | 104 | 0 |
420155 | 420155 | 2020-08-10 | Ward | North Dakota | 38101 | 234 | 1 |
420156 | 420156 | 2020-08-10 | Wells | North Dakota | 38103 | 21 | 0 |
420157 | 420157 | 2020-08-10 | Williams | North Dakota | 38105 | 272 | 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);