ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
727 rows where fips = 38091 and state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
153111 | 153111 | 2020-05-17 | Steele | North Dakota | 38091 | 1 | 0 |
156128 | 156128 | 2020-05-18 | Steele | North Dakota | 38091 | 1 | 0 |
159148 | 159148 | 2020-05-19 | Steele | North Dakota | 38091 | 1 | 0 |
162175 | 162175 | 2020-05-20 | Steele | North Dakota | 38091 | 1 | 0 |
165204 | 165204 | 2020-05-21 | Steele | North Dakota | 38091 | 1 | 0 |
168240 | 168240 | 2020-05-22 | Steele | North Dakota | 38091 | 1 | 0 |
171279 | 171279 | 2020-05-23 | Steele | North Dakota | 38091 | 1 | 0 |
174321 | 174321 | 2020-05-24 | Steele | North Dakota | 38091 | 1 | 0 |
177365 | 177365 | 2020-05-25 | Steele | North Dakota | 38091 | 1 | 0 |
180408 | 180408 | 2020-05-26 | Steele | North Dakota | 38091 | 1 | 0 |
183456 | 183456 | 2020-05-27 | Steele | North Dakota | 38091 | 1 | 0 |
186513 | 186513 | 2020-05-28 | Steele | North Dakota | 38091 | 1 | 0 |
189573 | 189573 | 2020-05-29 | Steele | North Dakota | 38091 | 1 | 0 |
192637 | 192637 | 2020-05-30 | Steele | North Dakota | 38091 | 1 | 0 |
195707 | 195707 | 2020-05-31 | Steele | North Dakota | 38091 | 1 | 0 |
198780 | 198780 | 2020-06-01 | Steele | North Dakota | 38091 | 1 | 0 |
201855 | 201855 | 2020-06-02 | Steele | North Dakota | 38091 | 1 | 0 |
204932 | 204932 | 2020-06-03 | Steele | North Dakota | 38091 | 1 | 0 |
208013 | 208013 | 2020-06-04 | Steele | North Dakota | 38091 | 1 | 0 |
211095 | 211095 | 2020-06-05 | Steele | North Dakota | 38091 | 1 | 0 |
214181 | 214181 | 2020-06-06 | Steele | North Dakota | 38091 | 1 | 0 |
217271 | 217271 | 2020-06-07 | Steele | North Dakota | 38091 | 1 | 0 |
220363 | 220363 | 2020-06-08 | Steele | North Dakota | 38091 | 1 | 0 |
223458 | 223458 | 2020-06-09 | Steele | North Dakota | 38091 | 1 | 0 |
226558 | 226558 | 2020-06-10 | Steele | North Dakota | 38091 | 1 | 0 |
229662 | 229662 | 2020-06-11 | Steele | North Dakota | 38091 | 1 | 0 |
232767 | 232767 | 2020-06-12 | Steele | North Dakota | 38091 | 1 | 0 |
235872 | 235872 | 2020-06-13 | Steele | North Dakota | 38091 | 1 | 0 |
238980 | 238980 | 2020-06-14 | Steele | North Dakota | 38091 | 1 | 0 |
242089 | 242089 | 2020-06-15 | Steele | North Dakota | 38091 | 1 | 0 |
245201 | 245201 | 2020-06-16 | Steele | North Dakota | 38091 | 1 | 0 |
248314 | 248314 | 2020-06-17 | Steele | North Dakota | 38091 | 1 | 0 |
251429 | 251429 | 2020-06-18 | Steele | North Dakota | 38091 | 1 | 0 |
254544 | 254544 | 2020-06-19 | Steele | North Dakota | 38091 | 1 | 0 |
257669 | 257669 | 2020-06-20 | Steele | North Dakota | 38091 | 1 | 0 |
260796 | 260796 | 2020-06-21 | Steele | North Dakota | 38091 | 1 | 0 |
263924 | 263924 | 2020-06-22 | Steele | North Dakota | 38091 | 1 | 0 |
267052 | 267052 | 2020-06-23 | Steele | North Dakota | 38091 | 1 | 0 |
270186 | 270186 | 2020-06-24 | Steele | North Dakota | 38091 | 1 | 0 |
273325 | 273325 | 2020-06-25 | Steele | North Dakota | 38091 | 1 | 0 |
276472 | 276472 | 2020-06-26 | Steele | North Dakota | 38091 | 1 | 0 |
279620 | 279620 | 2020-06-27 | Steele | North Dakota | 38091 | 1 | 0 |
282766 | 282766 | 2020-06-28 | Steele | North Dakota | 38091 | 1 | 0 |
285911 | 285911 | 2020-06-29 | Steele | North Dakota | 38091 | 1 | 0 |
289061 | 289061 | 2020-06-30 | Steele | North Dakota | 38091 | 1 | 0 |
292213 | 292213 | 2020-07-01 | Steele | North Dakota | 38091 | 2 | 0 |
295368 | 295368 | 2020-07-02 | Steele | North Dakota | 38091 | 2 | 0 |
298528 | 298528 | 2020-07-03 | Steele | North Dakota | 38091 | 2 | 0 |
301691 | 301691 | 2020-07-04 | Steele | North Dakota | 38091 | 2 | 0 |
304854 | 304854 | 2020-07-05 | Steele | North Dakota | 38091 | 2 | 0 |
308021 | 308021 | 2020-07-06 | Steele | North Dakota | 38091 | 3 | 0 |
311189 | 311189 | 2020-07-07 | Steele | North Dakota | 38091 | 3 | 0 |
314361 | 314361 | 2020-07-08 | Steele | North Dakota | 38091 | 3 | 0 |
317534 | 317534 | 2020-07-09 | Steele | North Dakota | 38091 | 3 | 0 |
320711 | 320711 | 2020-07-10 | Steele | North Dakota | 38091 | 4 | 0 |
323891 | 323891 | 2020-07-11 | Steele | North Dakota | 38091 | 4 | 0 |
327076 | 327076 | 2020-07-12 | Steele | North Dakota | 38091 | 4 | 0 |
330263 | 330263 | 2020-07-13 | Steele | North Dakota | 38091 | 4 | 0 |
333454 | 333454 | 2020-07-14 | Steele | North Dakota | 38091 | 4 | 0 |
336648 | 336648 | 2020-07-15 | Steele | North Dakota | 38091 | 4 | 0 |
339844 | 339844 | 2020-07-16 | Steele | North Dakota | 38091 | 4 | 0 |
343042 | 343042 | 2020-07-17 | Steele | North Dakota | 38091 | 4 | 0 |
346241 | 346241 | 2020-07-18 | Steele | North Dakota | 38091 | 5 | 0 |
349442 | 349442 | 2020-07-19 | Steele | North Dakota | 38091 | 6 | 0 |
352645 | 352645 | 2020-07-20 | Steele | North Dakota | 38091 | 6 | 0 |
355848 | 355848 | 2020-07-21 | Steele | North Dakota | 38091 | 6 | 0 |
359052 | 359052 | 2020-07-22 | Steele | North Dakota | 38091 | 6 | 0 |
362258 | 362258 | 2020-07-23 | Steele | North Dakota | 38091 | 6 | 0 |
365464 | 365464 | 2020-07-24 | Steele | North Dakota | 38091 | 7 | 0 |
368673 | 368673 | 2020-07-25 | Steele | North Dakota | 38091 | 8 | 0 |
371885 | 371885 | 2020-07-26 | Steele | North Dakota | 38091 | 11 | 0 |
375097 | 375097 | 2020-07-27 | Steele | North Dakota | 38091 | 10 | 0 |
378314 | 378314 | 2020-07-28 | Steele | North Dakota | 38091 | 10 | 0 |
381531 | 381531 | 2020-07-29 | Steele | North Dakota | 38091 | 10 | 0 |
384749 | 384749 | 2020-07-30 | Steele | North Dakota | 38091 | 10 | 0 |
387966 | 387966 | 2020-07-31 | Steele | North Dakota | 38091 | 10 | 0 |
391183 | 391183 | 2020-08-01 | Steele | North Dakota | 38091 | 10 | 0 |
394399 | 394399 | 2020-08-02 | Steele | North Dakota | 38091 | 10 | 0 |
397616 | 397616 | 2020-08-03 | Steele | North Dakota | 38091 | 11 | 0 |
400831 | 400831 | 2020-08-04 | Steele | North Dakota | 38091 | 13 | 0 |
404049 | 404049 | 2020-08-05 | Steele | North Dakota | 38091 | 13 | 0 |
407268 | 407268 | 2020-08-06 | Steele | North Dakota | 38091 | 13 | 0 |
410488 | 410488 | 2020-08-07 | Steele | North Dakota | 38091 | 14 | 0 |
413708 | 413708 | 2020-08-08 | Steele | North Dakota | 38091 | 14 | 0 |
416929 | 416929 | 2020-08-09 | Steele | North Dakota | 38091 | 14 | 0 |
420149 | 420149 | 2020-08-10 | Steele | North Dakota | 38091 | 14 | 0 |
423372 | 423372 | 2020-08-11 | Steele | North Dakota | 38091 | 15 | 0 |
426595 | 426595 | 2020-08-12 | Steele | North Dakota | 38091 | 15 | 0 |
429820 | 429820 | 2020-08-13 | Steele | North Dakota | 38091 | 15 | 0 |
433046 | 433046 | 2020-08-14 | Steele | North Dakota | 38091 | 16 | 0 |
436272 | 436272 | 2020-08-15 | Steele | North Dakota | 38091 | 16 | 0 |
439497 | 439497 | 2020-08-16 | Steele | North Dakota | 38091 | 16 | 0 |
442724 | 442724 | 2020-08-17 | Steele | North Dakota | 38091 | 16 | 0 |
445950 | 445950 | 2020-08-18 | Steele | North Dakota | 38091 | 16 | 0 |
449178 | 449178 | 2020-08-19 | Steele | North Dakota | 38091 | 16 | 0 |
452406 | 452406 | 2020-08-20 | Steele | North Dakota | 38091 | 16 | 0 |
455634 | 455634 | 2020-08-21 | Steele | North Dakota | 38091 | 17 | 0 |
458862 | 458862 | 2020-08-22 | Steele | North Dakota | 38091 | 17 | 0 |
462090 | 462090 | 2020-08-23 | Steele | North Dakota | 38091 | 17 | 0 |
465319 | 465319 | 2020-08-24 | Steele | North Dakota | 38091 | 17 | 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);