ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where deaths = 0, fips = 38057 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
581795 | 581795 | 2020-09-29 | Mercer | North Dakota | 38057 | 156 | 0 |
578555 | 578555 | 2020-09-28 | Mercer | North Dakota | 38057 | 147 | 0 |
575314 | 575314 | 2020-09-27 | Mercer | North Dakota | 38057 | 144 | 0 |
572070 | 572070 | 2020-09-26 | Mercer | North Dakota | 38057 | 143 | 0 |
568828 | 568828 | 2020-09-25 | Mercer | North Dakota | 38057 | 140 | 0 |
565587 | 565587 | 2020-09-24 | Mercer | North Dakota | 38057 | 134 | 0 |
562346 | 562346 | 2020-09-23 | Mercer | North Dakota | 38057 | 125 | 0 |
559109 | 559109 | 2020-09-22 | Mercer | North Dakota | 38057 | 120 | 0 |
555872 | 555872 | 2020-09-21 | Mercer | North Dakota | 38057 | 115 | 0 |
552635 | 552635 | 2020-09-20 | Mercer | North Dakota | 38057 | 108 | 0 |
549396 | 549396 | 2020-09-19 | Mercer | North Dakota | 38057 | 107 | 0 |
546157 | 546157 | 2020-09-18 | Mercer | North Dakota | 38057 | 101 | 0 |
542920 | 542920 | 2020-09-17 | Mercer | North Dakota | 38057 | 96 | 0 |
539684 | 539684 | 2020-09-16 | Mercer | North Dakota | 38057 | 92 | 0 |
536447 | 536447 | 2020-09-15 | Mercer | North Dakota | 38057 | 84 | 0 |
533211 | 533211 | 2020-09-14 | Mercer | North Dakota | 38057 | 79 | 0 |
529976 | 529976 | 2020-09-13 | Mercer | North Dakota | 38057 | 74 | 0 |
526739 | 526739 | 2020-09-12 | Mercer | North Dakota | 38057 | 71 | 0 |
523503 | 523503 | 2020-09-11 | Mercer | North Dakota | 38057 | 61 | 0 |
520267 | 520267 | 2020-09-10 | Mercer | North Dakota | 38057 | 60 | 0 |
517031 | 517031 | 2020-09-09 | Mercer | North Dakota | 38057 | 50 | 0 |
513796 | 513796 | 2020-09-08 | Mercer | North Dakota | 38057 | 51 | 0 |
510563 | 510563 | 2020-09-07 | Mercer | North Dakota | 38057 | 49 | 0 |
507330 | 507330 | 2020-09-06 | Mercer | North Dakota | 38057 | 48 | 0 |
504098 | 504098 | 2020-09-05 | Mercer | North Dakota | 38057 | 46 | 0 |
500864 | 500864 | 2020-09-04 | Mercer | North Dakota | 38057 | 45 | 0 |
497630 | 497630 | 2020-09-03 | Mercer | North Dakota | 38057 | 44 | 0 |
494397 | 494397 | 2020-09-02 | Mercer | North Dakota | 38057 | 40 | 0 |
491163 | 491163 | 2020-09-01 | Mercer | North Dakota | 38057 | 38 | 0 |
487930 | 487930 | 2020-08-31 | Mercer | North Dakota | 38057 | 38 | 0 |
484697 | 484697 | 2020-08-30 | Mercer | North Dakota | 38057 | 38 | 0 |
481462 | 481462 | 2020-08-29 | Mercer | North Dakota | 38057 | 38 | 0 |
478229 | 478229 | 2020-08-28 | Mercer | North Dakota | 38057 | 39 | 0 |
474996 | 474996 | 2020-08-27 | Mercer | North Dakota | 38057 | 38 | 0 |
471762 | 471762 | 2020-08-26 | Mercer | North Dakota | 38057 | 39 | 0 |
468530 | 468530 | 2020-08-25 | Mercer | North Dakota | 38057 | 37 | 0 |
465302 | 465302 | 2020-08-24 | Mercer | North Dakota | 38057 | 37 | 0 |
462073 | 462073 | 2020-08-23 | Mercer | North Dakota | 38057 | 37 | 0 |
458845 | 458845 | 2020-08-22 | Mercer | North Dakota | 38057 | 37 | 0 |
455617 | 455617 | 2020-08-21 | Mercer | North Dakota | 38057 | 35 | 0 |
452389 | 452389 | 2020-08-20 | Mercer | North Dakota | 38057 | 34 | 0 |
449161 | 449161 | 2020-08-19 | Mercer | North Dakota | 38057 | 34 | 0 |
445933 | 445933 | 2020-08-18 | Mercer | North Dakota | 38057 | 34 | 0 |
442707 | 442707 | 2020-08-17 | Mercer | North Dakota | 38057 | 34 | 0 |
439480 | 439480 | 2020-08-16 | Mercer | North Dakota | 38057 | 34 | 0 |
436255 | 436255 | 2020-08-15 | Mercer | North Dakota | 38057 | 34 | 0 |
433029 | 433029 | 2020-08-14 | Mercer | North Dakota | 38057 | 34 | 0 |
429803 | 429803 | 2020-08-13 | Mercer | North Dakota | 38057 | 32 | 0 |
426578 | 426578 | 2020-08-12 | Mercer | North Dakota | 38057 | 31 | 0 |
423355 | 423355 | 2020-08-11 | Mercer | North Dakota | 38057 | 32 | 0 |
420132 | 420132 | 2020-08-10 | Mercer | North Dakota | 38057 | 29 | 0 |
416912 | 416912 | 2020-08-09 | Mercer | North Dakota | 38057 | 29 | 0 |
413691 | 413691 | 2020-08-08 | Mercer | North Dakota | 38057 | 28 | 0 |
410471 | 410471 | 2020-08-07 | Mercer | North Dakota | 38057 | 26 | 0 |
407251 | 407251 | 2020-08-06 | Mercer | North Dakota | 38057 | 24 | 0 |
404032 | 404032 | 2020-08-05 | Mercer | North Dakota | 38057 | 24 | 0 |
400814 | 400814 | 2020-08-04 | Mercer | North Dakota | 38057 | 23 | 0 |
397599 | 397599 | 2020-08-03 | Mercer | North Dakota | 38057 | 23 | 0 |
394382 | 394382 | 2020-08-02 | Mercer | North Dakota | 38057 | 23 | 0 |
391166 | 391166 | 2020-08-01 | Mercer | North Dakota | 38057 | 23 | 0 |
387949 | 387949 | 2020-07-31 | Mercer | North Dakota | 38057 | 23 | 0 |
384732 | 384732 | 2020-07-30 | Mercer | North Dakota | 38057 | 20 | 0 |
381514 | 381514 | 2020-07-29 | Mercer | North Dakota | 38057 | 20 | 0 |
378297 | 378297 | 2020-07-28 | Mercer | North Dakota | 38057 | 20 | 0 |
375080 | 375080 | 2020-07-27 | Mercer | North Dakota | 38057 | 19 | 0 |
371868 | 371868 | 2020-07-26 | Mercer | North Dakota | 38057 | 18 | 0 |
368656 | 368656 | 2020-07-25 | Mercer | North Dakota | 38057 | 18 | 0 |
365447 | 365447 | 2020-07-24 | Mercer | North Dakota | 38057 | 18 | 0 |
362241 | 362241 | 2020-07-23 | Mercer | North Dakota | 38057 | 14 | 0 |
359035 | 359035 | 2020-07-22 | Mercer | North Dakota | 38057 | 14 | 0 |
355831 | 355831 | 2020-07-21 | Mercer | North Dakota | 38057 | 13 | 0 |
352628 | 352628 | 2020-07-20 | Mercer | North Dakota | 38057 | 12 | 0 |
349425 | 349425 | 2020-07-19 | Mercer | North Dakota | 38057 | 12 | 0 |
346224 | 346224 | 2020-07-18 | Mercer | North Dakota | 38057 | 12 | 0 |
343025 | 343025 | 2020-07-17 | Mercer | North Dakota | 38057 | 12 | 0 |
339827 | 339827 | 2020-07-16 | Mercer | North Dakota | 38057 | 9 | 0 |
336631 | 336631 | 2020-07-15 | Mercer | North Dakota | 38057 | 9 | 0 |
333437 | 333437 | 2020-07-14 | Mercer | North Dakota | 38057 | 9 | 0 |
330246 | 330246 | 2020-07-13 | Mercer | North Dakota | 38057 | 9 | 0 |
327059 | 327059 | 2020-07-12 | Mercer | North Dakota | 38057 | 9 | 0 |
323874 | 323874 | 2020-07-11 | Mercer | North Dakota | 38057 | 9 | 0 |
320694 | 320694 | 2020-07-10 | Mercer | North Dakota | 38057 | 8 | 0 |
317517 | 317517 | 2020-07-09 | Mercer | North Dakota | 38057 | 7 | 0 |
314344 | 314344 | 2020-07-08 | Mercer | North Dakota | 38057 | 7 | 0 |
311172 | 311172 | 2020-07-07 | Mercer | North Dakota | 38057 | 7 | 0 |
308004 | 308004 | 2020-07-06 | Mercer | North Dakota | 38057 | 7 | 0 |
304837 | 304837 | 2020-07-05 | Mercer | North Dakota | 38057 | 7 | 0 |
301674 | 301674 | 2020-07-04 | Mercer | North Dakota | 38057 | 7 | 0 |
298511 | 298511 | 2020-07-03 | Mercer | North Dakota | 38057 | 7 | 0 |
295351 | 295351 | 2020-07-02 | Mercer | North Dakota | 38057 | 7 | 0 |
292196 | 292196 | 2020-07-01 | Mercer | North Dakota | 38057 | 7 | 0 |
289044 | 289044 | 2020-06-30 | Mercer | North Dakota | 38057 | 6 | 0 |
285894 | 285894 | 2020-06-29 | Mercer | North Dakota | 38057 | 6 | 0 |
282749 | 282749 | 2020-06-28 | Mercer | North Dakota | 38057 | 6 | 0 |
279603 | 279603 | 2020-06-27 | Mercer | North Dakota | 38057 | 6 | 0 |
276455 | 276455 | 2020-06-26 | Mercer | North Dakota | 38057 | 6 | 0 |
273308 | 273308 | 2020-06-25 | Mercer | North Dakota | 38057 | 6 | 0 |
270169 | 270169 | 2020-06-24 | Mercer | North Dakota | 38057 | 6 | 0 |
267035 | 267035 | 2020-06-23 | Mercer | North Dakota | 38057 | 6 | 0 |
263907 | 263907 | 2020-06-22 | Mercer | North Dakota | 38057 | 6 | 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);