ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 38051 and state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13451 | 13451 | 2020-03-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
15188 | 15188 | 2020-03-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
17024 | 17024 | 2020-03-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
18958 | 18958 | 2020-03-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
21000 | 21000 | 2020-03-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
23130 | 23130 | 2020-03-31 | McIntosh | North Dakota | 38051 | 1 | 0 |
25325 | 25325 | 2020-04-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
27591 | 27591 | 2020-04-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
29919 | 29919 | 2020-04-03 | McIntosh | North Dakota | 38051 | 1 | 0 |
32307 | 32307 | 2020-04-04 | McIntosh | North Dakota | 38051 | 1 | 0 |
34740 | 34740 | 2020-04-05 | McIntosh | North Dakota | 38051 | 1 | 0 |
37209 | 37209 | 2020-04-06 | McIntosh | North Dakota | 38051 | 1 | 0 |
39726 | 39726 | 2020-04-07 | McIntosh | North Dakota | 38051 | 1 | 0 |
42283 | 42283 | 2020-04-08 | McIntosh | North Dakota | 38051 | 1 | 0 |
44867 | 44867 | 2020-04-09 | McIntosh | North Dakota | 38051 | 1 | 0 |
47480 | 47480 | 2020-04-10 | McIntosh | North Dakota | 38051 | 1 | 0 |
50135 | 50135 | 2020-04-11 | McIntosh | North Dakota | 38051 | 1 | 0 |
52808 | 52808 | 2020-04-12 | McIntosh | North Dakota | 38051 | 1 | 0 |
55492 | 55492 | 2020-04-13 | McIntosh | North Dakota | 38051 | 1 | 0 |
58193 | 58193 | 2020-04-14 | McIntosh | North Dakota | 38051 | 1 | 0 |
60907 | 60907 | 2020-04-15 | McIntosh | North Dakota | 38051 | 1 | 0 |
63633 | 63633 | 2020-04-16 | McIntosh | North Dakota | 38051 | 1 | 0 |
66376 | 66376 | 2020-04-17 | McIntosh | North Dakota | 38051 | 1 | 0 |
69133 | 69133 | 2020-04-18 | McIntosh | North Dakota | 38051 | 1 | 0 |
71899 | 71899 | 2020-04-19 | McIntosh | North Dakota | 38051 | 1 | 0 |
74674 | 74674 | 2020-04-20 | McIntosh | North Dakota | 38051 | 1 | 0 |
77455 | 77455 | 2020-04-21 | McIntosh | North Dakota | 38051 | 1 | 0 |
80244 | 80244 | 2020-04-22 | McIntosh | North Dakota | 38051 | 1 | 0 |
83043 | 83043 | 2020-04-23 | McIntosh | North Dakota | 38051 | 1 | 0 |
85847 | 85847 | 2020-04-24 | McIntosh | North Dakota | 38051 | 1 | 0 |
88660 | 88660 | 2020-04-25 | McIntosh | North Dakota | 38051 | 1 | 0 |
91475 | 91475 | 2020-04-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
94301 | 94301 | 2020-04-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
97138 | 97138 | 2020-04-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
99987 | 99987 | 2020-04-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
102840 | 102840 | 2020-04-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
105702 | 105702 | 2020-05-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
108569 | 108569 | 2020-05-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
111443 | 111443 | 2020-05-03 | McIntosh | North Dakota | 38051 | 1 | 0 |
114324 | 114324 | 2020-05-04 | McIntosh | North Dakota | 38051 | 1 | 0 |
117204 | 117204 | 2020-05-05 | McIntosh | North Dakota | 38051 | 1 | 0 |
120165 | 120165 | 2020-05-06 | McIntosh | North Dakota | 38051 | 1 | 0 |
123141 | 123141 | 2020-05-07 | McIntosh | North Dakota | 38051 | 1 | 0 |
126124 | 126124 | 2020-05-08 | McIntosh | North Dakota | 38051 | 1 | 0 |
129113 | 129113 | 2020-05-09 | McIntosh | North Dakota | 38051 | 1 | 0 |
132102 | 132102 | 2020-05-10 | McIntosh | North Dakota | 38051 | 1 | 0 |
135093 | 135093 | 2020-05-11 | McIntosh | North Dakota | 38051 | 1 | 0 |
138083 | 138083 | 2020-05-12 | McIntosh | North Dakota | 38051 | 1 | 0 |
141079 | 141079 | 2020-05-13 | McIntosh | North Dakota | 38051 | 1 | 0 |
144074 | 144074 | 2020-05-14 | McIntosh | North Dakota | 38051 | 1 | 0 |
147075 | 147075 | 2020-05-15 | McIntosh | North Dakota | 38051 | 1 | 0 |
150082 | 150082 | 2020-05-16 | McIntosh | North Dakota | 38051 | 1 | 0 |
153092 | 153092 | 2020-05-17 | McIntosh | North Dakota | 38051 | 1 | 0 |
156109 | 156109 | 2020-05-18 | McIntosh | North Dakota | 38051 | 1 | 0 |
159129 | 159129 | 2020-05-19 | McIntosh | North Dakota | 38051 | 1 | 0 |
162156 | 162156 | 2020-05-20 | McIntosh | North Dakota | 38051 | 1 | 0 |
165185 | 165185 | 2020-05-21 | McIntosh | North Dakota | 38051 | 1 | 0 |
168221 | 168221 | 2020-05-22 | McIntosh | North Dakota | 38051 | 1 | 0 |
171260 | 171260 | 2020-05-23 | McIntosh | North Dakota | 38051 | 1 | 0 |
174302 | 174302 | 2020-05-24 | McIntosh | North Dakota | 38051 | 1 | 0 |
177346 | 177346 | 2020-05-25 | McIntosh | North Dakota | 38051 | 1 | 0 |
180389 | 180389 | 2020-05-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
183437 | 183437 | 2020-05-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
186494 | 186494 | 2020-05-28 | McIntosh | North Dakota | 38051 | 1 | 0 |
189554 | 189554 | 2020-05-29 | McIntosh | North Dakota | 38051 | 1 | 0 |
192618 | 192618 | 2020-05-30 | McIntosh | North Dakota | 38051 | 1 | 0 |
195688 | 195688 | 2020-05-31 | McIntosh | North Dakota | 38051 | 1 | 0 |
198761 | 198761 | 2020-06-01 | McIntosh | North Dakota | 38051 | 1 | 0 |
201836 | 201836 | 2020-06-02 | McIntosh | North Dakota | 38051 | 1 | 0 |
204913 | 204913 | 2020-06-03 | McIntosh | North Dakota | 38051 | 1 | 0 |
207994 | 207994 | 2020-06-04 | McIntosh | North Dakota | 38051 | 1 | 0 |
211076 | 211076 | 2020-06-05 | McIntosh | North Dakota | 38051 | 1 | 0 |
214161 | 214161 | 2020-06-06 | McIntosh | North Dakota | 38051 | 1 | 0 |
217251 | 217251 | 2020-06-07 | McIntosh | North Dakota | 38051 | 1 | 0 |
220343 | 220343 | 2020-06-08 | McIntosh | North Dakota | 38051 | 1 | 0 |
223438 | 223438 | 2020-06-09 | McIntosh | North Dakota | 38051 | 1 | 0 |
226538 | 226538 | 2020-06-10 | McIntosh | North Dakota | 38051 | 1 | 0 |
229642 | 229642 | 2020-06-11 | McIntosh | North Dakota | 38051 | 1 | 0 |
232747 | 232747 | 2020-06-12 | McIntosh | North Dakota | 38051 | 1 | 0 |
235852 | 235852 | 2020-06-13 | McIntosh | North Dakota | 38051 | 1 | 0 |
238960 | 238960 | 2020-06-14 | McIntosh | North Dakota | 38051 | 1 | 0 |
242069 | 242069 | 2020-06-15 | McIntosh | North Dakota | 38051 | 1 | 0 |
245181 | 245181 | 2020-06-16 | McIntosh | North Dakota | 38051 | 1 | 0 |
248294 | 248294 | 2020-06-17 | McIntosh | North Dakota | 38051 | 1 | 0 |
251409 | 251409 | 2020-06-18 | McIntosh | North Dakota | 38051 | 1 | 0 |
254524 | 254524 | 2020-06-19 | McIntosh | North Dakota | 38051 | 1 | 0 |
257649 | 257649 | 2020-06-20 | McIntosh | North Dakota | 38051 | 1 | 0 |
260776 | 260776 | 2020-06-21 | McIntosh | North Dakota | 38051 | 1 | 0 |
263904 | 263904 | 2020-06-22 | McIntosh | North Dakota | 38051 | 1 | 0 |
267032 | 267032 | 2020-06-23 | McIntosh | North Dakota | 38051 | 1 | 0 |
270166 | 270166 | 2020-06-24 | McIntosh | North Dakota | 38051 | 1 | 0 |
273305 | 273305 | 2020-06-25 | McIntosh | North Dakota | 38051 | 1 | 0 |
276452 | 276452 | 2020-06-26 | McIntosh | North Dakota | 38051 | 1 | 0 |
279600 | 279600 | 2020-06-27 | McIntosh | North Dakota | 38051 | 1 | 0 |
282746 | 282746 | 2020-06-28 | McIntosh | North Dakota | 38051 | 2 | 0 |
285891 | 285891 | 2020-06-29 | McIntosh | North Dakota | 38051 | 2 | 0 |
289041 | 289041 | 2020-06-30 | McIntosh | North Dakota | 38051 | 2 | 0 |
292193 | 292193 | 2020-07-01 | McIntosh | North Dakota | 38051 | 2 | 0 |
295348 | 295348 | 2020-07-02 | McIntosh | North Dakota | 38051 | 2 | 0 |
298508 | 298508 | 2020-07-03 | McIntosh | North Dakota | 38051 | 2 | 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);