ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
687 rows where fips = 38041 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 |
---|---|---|---|---|---|---|---|
276448 | 276448 | 2020-06-26 | Hettinger | North Dakota | 38041 | 1 | 0 |
279596 | 279596 | 2020-06-27 | Hettinger | North Dakota | 38041 | 1 | 0 |
282742 | 282742 | 2020-06-28 | Hettinger | North Dakota | 38041 | 1 | 0 |
285887 | 285887 | 2020-06-29 | Hettinger | North Dakota | 38041 | 1 | 0 |
289037 | 289037 | 2020-06-30 | Hettinger | North Dakota | 38041 | 1 | 0 |
292189 | 292189 | 2020-07-01 | Hettinger | North Dakota | 38041 | 1 | 0 |
295344 | 295344 | 2020-07-02 | Hettinger | North Dakota | 38041 | 1 | 0 |
298504 | 298504 | 2020-07-03 | Hettinger | North Dakota | 38041 | 1 | 0 |
301667 | 301667 | 2020-07-04 | Hettinger | North Dakota | 38041 | 1 | 0 |
304830 | 304830 | 2020-07-05 | Hettinger | North Dakota | 38041 | 1 | 0 |
307997 | 307997 | 2020-07-06 | Hettinger | North Dakota | 38041 | 1 | 0 |
311165 | 311165 | 2020-07-07 | Hettinger | North Dakota | 38041 | 1 | 0 |
314336 | 314336 | 2020-07-08 | Hettinger | North Dakota | 38041 | 1 | 0 |
317510 | 317510 | 2020-07-09 | Hettinger | North Dakota | 38041 | 1 | 0 |
320687 | 320687 | 2020-07-10 | Hettinger | North Dakota | 38041 | 1 | 0 |
323867 | 323867 | 2020-07-11 | Hettinger | North Dakota | 38041 | 1 | 0 |
327051 | 327051 | 2020-07-12 | Hettinger | North Dakota | 38041 | 1 | 0 |
330238 | 330238 | 2020-07-13 | Hettinger | North Dakota | 38041 | 1 | 0 |
333429 | 333429 | 2020-07-14 | Hettinger | North Dakota | 38041 | 1 | 0 |
336623 | 336623 | 2020-07-15 | Hettinger | North Dakota | 38041 | 2 | 0 |
339819 | 339819 | 2020-07-16 | Hettinger | North Dakota | 38041 | 2 | 0 |
343017 | 343017 | 2020-07-17 | Hettinger | North Dakota | 38041 | 2 | 0 |
346216 | 346216 | 2020-07-18 | Hettinger | North Dakota | 38041 | 6 | 0 |
349417 | 349417 | 2020-07-19 | Hettinger | North Dakota | 38041 | 6 | 0 |
352620 | 352620 | 2020-07-20 | Hettinger | North Dakota | 38041 | 6 | 0 |
355823 | 355823 | 2020-07-21 | Hettinger | North Dakota | 38041 | 6 | 0 |
359027 | 359027 | 2020-07-22 | Hettinger | North Dakota | 38041 | 6 | 0 |
362233 | 362233 | 2020-07-23 | Hettinger | North Dakota | 38041 | 6 | 0 |
365439 | 365439 | 2020-07-24 | Hettinger | North Dakota | 38041 | 6 | 0 |
368648 | 368648 | 2020-07-25 | Hettinger | North Dakota | 38041 | 6 | 0 |
371860 | 371860 | 2020-07-26 | Hettinger | North Dakota | 38041 | 6 | 0 |
375072 | 375072 | 2020-07-27 | Hettinger | North Dakota | 38041 | 6 | 0 |
378289 | 378289 | 2020-07-28 | Hettinger | North Dakota | 38041 | 6 | 0 |
381506 | 381506 | 2020-07-29 | Hettinger | North Dakota | 38041 | 6 | 0 |
384724 | 384724 | 2020-07-30 | Hettinger | North Dakota | 38041 | 6 | 0 |
387941 | 387941 | 2020-07-31 | Hettinger | North Dakota | 38041 | 6 | 0 |
391158 | 391158 | 2020-08-01 | Hettinger | North Dakota | 38041 | 6 | 0 |
394374 | 394374 | 2020-08-02 | Hettinger | North Dakota | 38041 | 6 | 0 |
397591 | 397591 | 2020-08-03 | Hettinger | North Dakota | 38041 | 6 | 0 |
400806 | 400806 | 2020-08-04 | Hettinger | North Dakota | 38041 | 6 | 0 |
404024 | 404024 | 2020-08-05 | Hettinger | North Dakota | 38041 | 6 | 0 |
407243 | 407243 | 2020-08-06 | Hettinger | North Dakota | 38041 | 6 | 0 |
410463 | 410463 | 2020-08-07 | Hettinger | North Dakota | 38041 | 6 | 0 |
413683 | 413683 | 2020-08-08 | Hettinger | North Dakota | 38041 | 6 | 0 |
416904 | 416904 | 2020-08-09 | Hettinger | North Dakota | 38041 | 6 | 0 |
420124 | 420124 | 2020-08-10 | Hettinger | North Dakota | 38041 | 6 | 0 |
423347 | 423347 | 2020-08-11 | Hettinger | North Dakota | 38041 | 6 | 0 |
426570 | 426570 | 2020-08-12 | Hettinger | North Dakota | 38041 | 6 | 0 |
429795 | 429795 | 2020-08-13 | Hettinger | North Dakota | 38041 | 6 | 0 |
433021 | 433021 | 2020-08-14 | Hettinger | North Dakota | 38041 | 7 | 0 |
436247 | 436247 | 2020-08-15 | Hettinger | North Dakota | 38041 | 7 | 0 |
439472 | 439472 | 2020-08-16 | Hettinger | North Dakota | 38041 | 7 | 0 |
442699 | 442699 | 2020-08-17 | Hettinger | North Dakota | 38041 | 8 | 0 |
445925 | 445925 | 2020-08-18 | Hettinger | North Dakota | 38041 | 8 | 0 |
449153 | 449153 | 2020-08-19 | Hettinger | North Dakota | 38041 | 8 | 0 |
452381 | 452381 | 2020-08-20 | Hettinger | North Dakota | 38041 | 10 | 0 |
455609 | 455609 | 2020-08-21 | Hettinger | North Dakota | 38041 | 10 | 0 |
458837 | 458837 | 2020-08-22 | Hettinger | North Dakota | 38041 | 12 | 0 |
462065 | 462065 | 2020-08-23 | Hettinger | North Dakota | 38041 | 12 | 0 |
465294 | 465294 | 2020-08-24 | Hettinger | North Dakota | 38041 | 12 | 0 |
468522 | 468522 | 2020-08-25 | Hettinger | North Dakota | 38041 | 12 | 0 |
471754 | 471754 | 2020-08-26 | Hettinger | North Dakota | 38041 | 14 | 0 |
474988 | 474988 | 2020-08-27 | Hettinger | North Dakota | 38041 | 15 | 0 |
478221 | 478221 | 2020-08-28 | Hettinger | North Dakota | 38041 | 18 | 0 |
481454 | 481454 | 2020-08-29 | Hettinger | North Dakota | 38041 | 21 | 0 |
484689 | 484689 | 2020-08-30 | Hettinger | North Dakota | 38041 | 23 | 0 |
487922 | 487922 | 2020-08-31 | Hettinger | North Dakota | 38041 | 24 | 0 |
491155 | 491155 | 2020-09-01 | Hettinger | North Dakota | 38041 | 25 | 0 |
494389 | 494389 | 2020-09-02 | Hettinger | North Dakota | 38041 | 28 | 0 |
497622 | 497622 | 2020-09-03 | Hettinger | North Dakota | 38041 | 28 | 0 |
500856 | 500856 | 2020-09-04 | Hettinger | North Dakota | 38041 | 30 | 0 |
504090 | 504090 | 2020-09-05 | Hettinger | North Dakota | 38041 | 30 | 0 |
507322 | 507322 | 2020-09-06 | Hettinger | North Dakota | 38041 | 32 | 0 |
510555 | 510555 | 2020-09-07 | Hettinger | North Dakota | 38041 | 33 | 0 |
513788 | 513788 | 2020-09-08 | Hettinger | North Dakota | 38041 | 34 | 0 |
517023 | 517023 | 2020-09-09 | Hettinger | North Dakota | 38041 | 35 | 0 |
520259 | 520259 | 2020-09-10 | Hettinger | North Dakota | 38041 | 37 | 0 |
523495 | 523495 | 2020-09-11 | Hettinger | North Dakota | 38041 | 38 | 0 |
526731 | 526731 | 2020-09-12 | Hettinger | North Dakota | 38041 | 42 | 0 |
529968 | 529968 | 2020-09-13 | Hettinger | North Dakota | 38041 | 44 | 0 |
533203 | 533203 | 2020-09-14 | Hettinger | North Dakota | 38041 | 46 | 0 |
536439 | 536439 | 2020-09-15 | Hettinger | North Dakota | 38041 | 46 | 0 |
539676 | 539676 | 2020-09-16 | Hettinger | North Dakota | 38041 | 50 | 0 |
542912 | 542912 | 2020-09-17 | Hettinger | North Dakota | 38041 | 51 | 0 |
546149 | 546149 | 2020-09-18 | Hettinger | North Dakota | 38041 | 51 | 0 |
549388 | 549388 | 2020-09-19 | Hettinger | North Dakota | 38041 | 54 | 0 |
552627 | 552627 | 2020-09-20 | Hettinger | North Dakota | 38041 | 55 | 0 |
555864 | 555864 | 2020-09-21 | Hettinger | North Dakota | 38041 | 55 | 0 |
559101 | 559101 | 2020-09-22 | Hettinger | North Dakota | 38041 | 55 | 0 |
562338 | 562338 | 2020-09-23 | Hettinger | North Dakota | 38041 | 55 | 0 |
565579 | 565579 | 2020-09-24 | Hettinger | North Dakota | 38041 | 56 | 0 |
568820 | 568820 | 2020-09-25 | Hettinger | North Dakota | 38041 | 59 | 0 |
572062 | 572062 | 2020-09-26 | Hettinger | North Dakota | 38041 | 63 | 0 |
575306 | 575306 | 2020-09-27 | Hettinger | North Dakota | 38041 | 64 | 0 |
578547 | 578547 | 2020-09-28 | Hettinger | North Dakota | 38041 | 64 | 0 |
581787 | 581787 | 2020-09-29 | Hettinger | North Dakota | 38041 | 64 | 0 |
585028 | 585028 | 2020-09-30 | Hettinger | North Dakota | 38041 | 65 | 0 |
588268 | 588268 | 2020-10-01 | Hettinger | North Dakota | 38041 | 67 | 0 |
591509 | 591509 | 2020-10-02 | Hettinger | North Dakota | 38041 | 67 | 0 |
594750 | 594750 | 2020-10-03 | Hettinger | North Dakota | 38041 | 69 | 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);