ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 38069 and state = "North Dakota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
282755 | 282755 | 2020-06-28 | Pierce | North Dakota | 38069 | 4 | 0 |
285900 | 285900 | 2020-06-29 | Pierce | North Dakota | 38069 | 4 | 0 |
289050 | 289050 | 2020-06-30 | Pierce | North Dakota | 38069 | 5 | 0 |
292202 | 292202 | 2020-07-01 | Pierce | North Dakota | 38069 | 5 | 0 |
295357 | 295357 | 2020-07-02 | Pierce | North Dakota | 38069 | 5 | 0 |
298517 | 298517 | 2020-07-03 | Pierce | North Dakota | 38069 | 5 | 0 |
301680 | 301680 | 2020-07-04 | Pierce | North Dakota | 38069 | 5 | 0 |
304843 | 304843 | 2020-07-05 | Pierce | North Dakota | 38069 | 5 | 0 |
308010 | 308010 | 2020-07-06 | Pierce | North Dakota | 38069 | 5 | 0 |
311178 | 311178 | 2020-07-07 | Pierce | North Dakota | 38069 | 5 | 0 |
314350 | 314350 | 2020-07-08 | Pierce | North Dakota | 38069 | 6 | 0 |
317523 | 317523 | 2020-07-09 | Pierce | North Dakota | 38069 | 6 | 0 |
320700 | 320700 | 2020-07-10 | Pierce | North Dakota | 38069 | 7 | 0 |
323880 | 323880 | 2020-07-11 | Pierce | North Dakota | 38069 | 8 | 0 |
327065 | 327065 | 2020-07-12 | Pierce | North Dakota | 38069 | 8 | 0 |
330252 | 330252 | 2020-07-13 | Pierce | North Dakota | 38069 | 8 | 0 |
333443 | 333443 | 2020-07-14 | Pierce | North Dakota | 38069 | 8 | 0 |
336637 | 336637 | 2020-07-15 | Pierce | North Dakota | 38069 | 8 | 0 |
339833 | 339833 | 2020-07-16 | Pierce | North Dakota | 38069 | 8 | 0 |
343031 | 343031 | 2020-07-17 | Pierce | North Dakota | 38069 | 8 | 0 |
346230 | 346230 | 2020-07-18 | Pierce | North Dakota | 38069 | 8 | 0 |
349431 | 349431 | 2020-07-19 | Pierce | North Dakota | 38069 | 8 | 0 |
352634 | 352634 | 2020-07-20 | Pierce | North Dakota | 38069 | 8 | 0 |
355837 | 355837 | 2020-07-21 | Pierce | North Dakota | 38069 | 8 | 0 |
359041 | 359041 | 2020-07-22 | Pierce | North Dakota | 38069 | 8 | 0 |
362247 | 362247 | 2020-07-23 | Pierce | North Dakota | 38069 | 8 | 0 |
365453 | 365453 | 2020-07-24 | Pierce | North Dakota | 38069 | 8 | 0 |
368662 | 368662 | 2020-07-25 | Pierce | North Dakota | 38069 | 8 | 0 |
371874 | 371874 | 2020-07-26 | Pierce | North Dakota | 38069 | 8 | 0 |
375086 | 375086 | 2020-07-27 | Pierce | North Dakota | 38069 | 8 | 0 |
378303 | 378303 | 2020-07-28 | Pierce | North Dakota | 38069 | 8 | 0 |
381520 | 381520 | 2020-07-29 | Pierce | North Dakota | 38069 | 8 | 0 |
384738 | 384738 | 2020-07-30 | Pierce | North Dakota | 38069 | 8 | 0 |
387955 | 387955 | 2020-07-31 | Pierce | North Dakota | 38069 | 11 | 0 |
391172 | 391172 | 2020-08-01 | Pierce | North Dakota | 38069 | 11 | 0 |
394388 | 394388 | 2020-08-02 | Pierce | North Dakota | 38069 | 11 | 0 |
397605 | 397605 | 2020-08-03 | Pierce | North Dakota | 38069 | 11 | 0 |
400820 | 400820 | 2020-08-04 | Pierce | North Dakota | 38069 | 11 | 0 |
404038 | 404038 | 2020-08-05 | Pierce | North Dakota | 38069 | 11 | 0 |
407257 | 407257 | 2020-08-06 | Pierce | North Dakota | 38069 | 11 | 0 |
410477 | 410477 | 2020-08-07 | Pierce | North Dakota | 38069 | 11 | 0 |
413697 | 413697 | 2020-08-08 | Pierce | North Dakota | 38069 | 11 | 0 |
416918 | 416918 | 2020-08-09 | Pierce | North Dakota | 38069 | 12 | 0 |
420138 | 420138 | 2020-08-10 | Pierce | North Dakota | 38069 | 12 | 0 |
423361 | 423361 | 2020-08-11 | Pierce | North Dakota | 38069 | 12 | 0 |
426584 | 426584 | 2020-08-12 | Pierce | North Dakota | 38069 | 13 | 0 |
429809 | 429809 | 2020-08-13 | Pierce | North Dakota | 38069 | 15 | 0 |
433035 | 433035 | 2020-08-14 | Pierce | North Dakota | 38069 | 15 | 0 |
436261 | 436261 | 2020-08-15 | Pierce | North Dakota | 38069 | 16 | 0 |
439486 | 439486 | 2020-08-16 | Pierce | North Dakota | 38069 | 16 | 0 |
442713 | 442713 | 2020-08-17 | Pierce | North Dakota | 38069 | 16 | 0 |
445939 | 445939 | 2020-08-18 | Pierce | North Dakota | 38069 | 16 | 0 |
449167 | 449167 | 2020-08-19 | Pierce | North Dakota | 38069 | 18 | 0 |
452395 | 452395 | 2020-08-20 | Pierce | North Dakota | 38069 | 20 | 0 |
455623 | 455623 | 2020-08-21 | Pierce | North Dakota | 38069 | 21 | 0 |
458851 | 458851 | 2020-08-22 | Pierce | North Dakota | 38069 | 22 | 0 |
462079 | 462079 | 2020-08-23 | Pierce | North Dakota | 38069 | 22 | 0 |
465308 | 465308 | 2020-08-24 | Pierce | North Dakota | 38069 | 22 | 0 |
468536 | 468536 | 2020-08-25 | Pierce | North Dakota | 38069 | 22 | 0 |
471768 | 471768 | 2020-08-26 | Pierce | North Dakota | 38069 | 24 | 0 |
475002 | 475002 | 2020-08-27 | Pierce | North Dakota | 38069 | 24 | 0 |
478235 | 478235 | 2020-08-28 | Pierce | North Dakota | 38069 | 24 | 0 |
481468 | 481468 | 2020-08-29 | Pierce | North Dakota | 38069 | 25 | 0 |
484703 | 484703 | 2020-08-30 | Pierce | North Dakota | 38069 | 25 | 0 |
487936 | 487936 | 2020-08-31 | Pierce | North Dakota | 38069 | 25 | 0 |
491169 | 491169 | 2020-09-01 | Pierce | North Dakota | 38069 | 25 | 0 |
494403 | 494403 | 2020-09-02 | Pierce | North Dakota | 38069 | 27 | 0 |
497636 | 497636 | 2020-09-03 | Pierce | North Dakota | 38069 | 27 | 0 |
500870 | 500870 | 2020-09-04 | Pierce | North Dakota | 38069 | 28 | 0 |
504104 | 504104 | 2020-09-05 | Pierce | North Dakota | 38069 | 28 | 0 |
517037 | 517037 | 2020-09-09 | Pierce | North Dakota | 38069 | 28 | 0 |
520273 | 520273 | 2020-09-10 | Pierce | North Dakota | 38069 | 28 | 0 |
523509 | 523509 | 2020-09-11 | Pierce | North Dakota | 38069 | 28 | 0 |
526745 | 526745 | 2020-09-12 | Pierce | North Dakota | 38069 | 28 | 0 |
533217 | 533217 | 2020-09-14 | Pierce | North Dakota | 38069 | 28 | 0 |
529982 | 529982 | 2020-09-13 | Pierce | North Dakota | 38069 | 29 | 0 |
536453 | 536453 | 2020-09-15 | Pierce | North Dakota | 38069 | 29 | 0 |
507336 | 507336 | 2020-09-06 | Pierce | North Dakota | 38069 | 30 | 0 |
510569 | 510569 | 2020-09-07 | Pierce | North Dakota | 38069 | 30 | 0 |
513802 | 513802 | 2020-09-08 | Pierce | North Dakota | 38069 | 30 | 0 |
539690 | 539690 | 2020-09-16 | Pierce | North Dakota | 38069 | 30 | 0 |
542926 | 542926 | 2020-09-17 | Pierce | North Dakota | 38069 | 30 | 0 |
546163 | 546163 | 2020-09-18 | Pierce | North Dakota | 38069 | 31 | 0 |
549402 | 549402 | 2020-09-19 | Pierce | North Dakota | 38069 | 31 | 0 |
552641 | 552641 | 2020-09-20 | Pierce | North Dakota | 38069 | 31 | 0 |
555878 | 555878 | 2020-09-21 | Pierce | North Dakota | 38069 | 31 | 0 |
559115 | 559115 | 2020-09-22 | Pierce | North Dakota | 38069 | 31 | 0 |
562352 | 562352 | 2020-09-23 | Pierce | North Dakota | 38069 | 31 | 0 |
565593 | 565593 | 2020-09-24 | Pierce | North Dakota | 38069 | 31 | 0 |
568834 | 568834 | 2020-09-25 | Pierce | North Dakota | 38069 | 31 | 0 |
572076 | 572076 | 2020-09-26 | Pierce | North Dakota | 38069 | 32 | 0 |
575320 | 575320 | 2020-09-27 | Pierce | North Dakota | 38069 | 32 | 0 |
578561 | 578561 | 2020-09-28 | Pierce | North Dakota | 38069 | 33 | 0 |
581801 | 581801 | 2020-09-29 | Pierce | North Dakota | 38069 | 34 | 0 |
585042 | 585042 | 2020-09-30 | Pierce | North Dakota | 38069 | 36 | 0 |
588282 | 588282 | 2020-10-01 | Pierce | North Dakota | 38069 | 36 | 0 |
591523 | 591523 | 2020-10-02 | Pierce | North Dakota | 38069 | 36 | 0 |
594764 | 594764 | 2020-10-03 | Pierce | North Dakota | 38069 | 36 | 0 |
598007 | 598007 | 2020-10-04 | Pierce | North Dakota | 38069 | 36 | 0 |
601250 | 601250 | 2020-10-05 | Pierce | North Dakota | 38069 | 36 | 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);