ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
663 rows where county = "McCone" and state = "Montana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
352256 | 352256 | 2020-07-20 | McCone | Montana | 30055 | 1 | 0 |
355459 | 355459 | 2020-07-21 | McCone | Montana | 30055 | 1 | 0 |
358663 | 358663 | 2020-07-22 | McCone | Montana | 30055 | 1 | 0 |
361868 | 361868 | 2020-07-23 | McCone | Montana | 30055 | 1 | 0 |
365075 | 365075 | 2020-07-24 | McCone | Montana | 30055 | 1 | 0 |
368284 | 368284 | 2020-07-25 | McCone | Montana | 30055 | 1 | 0 |
371495 | 371495 | 2020-07-26 | McCone | Montana | 30055 | 1 | 0 |
374707 | 374707 | 2020-07-27 | McCone | Montana | 30055 | 1 | 0 |
377922 | 377922 | 2020-07-28 | McCone | Montana | 30055 | 1 | 0 |
381139 | 381139 | 2020-07-29 | McCone | Montana | 30055 | 1 | 0 |
384355 | 384355 | 2020-07-30 | McCone | Montana | 30055 | 1 | 0 |
387573 | 387573 | 2020-07-31 | McCone | Montana | 30055 | 1 | 0 |
390790 | 390790 | 2020-08-01 | McCone | Montana | 30055 | 1 | 0 |
394007 | 394007 | 2020-08-02 | McCone | Montana | 30055 | 1 | 0 |
397223 | 397223 | 2020-08-03 | McCone | Montana | 30055 | 1 | 0 |
400437 | 400437 | 2020-08-04 | McCone | Montana | 30055 | 2 | 0 |
403654 | 403654 | 2020-08-05 | McCone | Montana | 30055 | 2 | 0 |
406872 | 406872 | 2020-08-06 | McCone | Montana | 30055 | 3 | 0 |
410092 | 410092 | 2020-08-07 | McCone | Montana | 30055 | 3 | 0 |
413312 | 413312 | 2020-08-08 | McCone | Montana | 30055 | 3 | 0 |
416532 | 416532 | 2020-08-09 | McCone | Montana | 30055 | 3 | 0 |
419753 | 419753 | 2020-08-10 | McCone | Montana | 30055 | 3 | 0 |
422975 | 422975 | 2020-08-11 | McCone | Montana | 30055 | 5 | 0 |
426197 | 426197 | 2020-08-12 | McCone | Montana | 30055 | 5 | 0 |
429421 | 429421 | 2020-08-13 | McCone | Montana | 30055 | 5 | 0 |
432648 | 432648 | 2020-08-14 | McCone | Montana | 30055 | 5 | 0 |
435874 | 435874 | 2020-08-15 | McCone | Montana | 30055 | 5 | 0 |
439099 | 439099 | 2020-08-16 | McCone | Montana | 30055 | 5 | 0 |
442326 | 442326 | 2020-08-17 | McCone | Montana | 30055 | 5 | 0 |
445552 | 445552 | 2020-08-18 | McCone | Montana | 30055 | 5 | 0 |
448778 | 448778 | 2020-08-19 | McCone | Montana | 30055 | 5 | 0 |
452006 | 452006 | 2020-08-20 | McCone | Montana | 30055 | 5 | 0 |
455234 | 455234 | 2020-08-21 | McCone | Montana | 30055 | 5 | 0 |
458462 | 458462 | 2020-08-22 | McCone | Montana | 30055 | 5 | 0 |
461689 | 461689 | 2020-08-23 | McCone | Montana | 30055 | 5 | 0 |
464920 | 464920 | 2020-08-24 | McCone | Montana | 30055 | 5 | 0 |
468149 | 468149 | 2020-08-25 | McCone | Montana | 30055 | 7 | 0 |
471379 | 471379 | 2020-08-26 | McCone | Montana | 30055 | 8 | 0 |
474611 | 474611 | 2020-08-27 | McCone | Montana | 30055 | 8 | 0 |
477844 | 477844 | 2020-08-28 | McCone | Montana | 30055 | 8 | 0 |
481076 | 481076 | 2020-08-29 | McCone | Montana | 30055 | 11 | 0 |
484311 | 484311 | 2020-08-30 | McCone | Montana | 30055 | 12 | 0 |
487545 | 487545 | 2020-08-31 | McCone | Montana | 30055 | 12 | 0 |
490778 | 490778 | 2020-09-01 | McCone | Montana | 30055 | 14 | 0 |
494012 | 494012 | 2020-09-02 | McCone | Montana | 30055 | 14 | 0 |
497245 | 497245 | 2020-09-03 | McCone | Montana | 30055 | 14 | 0 |
500479 | 500479 | 2020-09-04 | McCone | Montana | 30055 | 14 | 0 |
503713 | 503713 | 2020-09-05 | McCone | Montana | 30055 | 14 | 0 |
506946 | 506946 | 2020-09-06 | McCone | Montana | 30055 | 14 | 0 |
510179 | 510179 | 2020-09-07 | McCone | Montana | 30055 | 14 | 0 |
513411 | 513411 | 2020-09-08 | McCone | Montana | 30055 | 14 | 0 |
516645 | 516645 | 2020-09-09 | McCone | Montana | 30055 | 14 | 0 |
519880 | 519880 | 2020-09-10 | McCone | Montana | 30055 | 14 | 0 |
523117 | 523117 | 2020-09-11 | McCone | Montana | 30055 | 14 | 0 |
526353 | 526353 | 2020-09-12 | McCone | Montana | 30055 | 15 | 0 |
529589 | 529589 | 2020-09-13 | McCone | Montana | 30055 | 15 | 0 |
532825 | 532825 | 2020-09-14 | McCone | Montana | 30055 | 15 | 0 |
536060 | 536060 | 2020-09-15 | McCone | Montana | 30055 | 19 | 0 |
539297 | 539297 | 2020-09-16 | McCone | Montana | 30055 | 19 | 0 |
542533 | 542533 | 2020-09-17 | McCone | Montana | 30055 | 19 | 0 |
545770 | 545770 | 2020-09-18 | McCone | Montana | 30055 | 19 | 0 |
549008 | 549008 | 2020-09-19 | McCone | Montana | 30055 | 19 | 0 |
552247 | 552247 | 2020-09-20 | McCone | Montana | 30055 | 19 | 0 |
555485 | 555485 | 2020-09-21 | McCone | Montana | 30055 | 19 | 0 |
558722 | 558722 | 2020-09-22 | McCone | Montana | 30055 | 19 | 0 |
561959 | 561959 | 2020-09-23 | McCone | Montana | 30055 | 19 | 0 |
565200 | 565200 | 2020-09-24 | McCone | Montana | 30055 | 19 | 0 |
568440 | 568440 | 2020-09-25 | McCone | Montana | 30055 | 19 | 0 |
571682 | 571682 | 2020-09-26 | McCone | Montana | 30055 | 19 | 0 |
574925 | 574925 | 2020-09-27 | McCone | Montana | 30055 | 19 | 0 |
578166 | 578166 | 2020-09-28 | McCone | Montana | 30055 | 23 | 0 |
581407 | 581407 | 2020-09-29 | McCone | Montana | 30055 | 23 | 0 |
584648 | 584648 | 2020-09-30 | McCone | Montana | 30055 | 23 | 0 |
587888 | 587888 | 2020-10-01 | McCone | Montana | 30055 | 23 | 0 |
591129 | 591129 | 2020-10-02 | McCone | Montana | 30055 | 25 | 0 |
594370 | 594370 | 2020-10-03 | McCone | Montana | 30055 | 27 | 0 |
597611 | 597611 | 2020-10-04 | McCone | Montana | 30055 | 27 | 0 |
600854 | 600854 | 2020-10-05 | McCone | Montana | 30055 | 27 | 0 |
604096 | 604096 | 2020-10-06 | McCone | Montana | 30055 | 27 | 0 |
607339 | 607339 | 2020-10-07 | McCone | Montana | 30055 | 27 | 0 |
610581 | 610581 | 2020-10-08 | McCone | Montana | 30055 | 27 | 0 |
613823 | 613823 | 2020-10-09 | McCone | Montana | 30055 | 29 | 0 |
617064 | 617064 | 2020-10-10 | McCone | Montana | 30055 | 31 | 0 |
620306 | 620306 | 2020-10-11 | McCone | Montana | 30055 | 35 | 0 |
623549 | 623549 | 2020-10-12 | McCone | Montana | 30055 | 35 | 0 |
626791 | 626791 | 2020-10-13 | McCone | Montana | 30055 | 35 | 0 |
630035 | 630035 | 2020-10-14 | McCone | Montana | 30055 | 36 | 0 |
633280 | 633280 | 2020-10-15 | McCone | Montana | 30055 | 36 | 0 |
636526 | 636526 | 2020-10-16 | McCone | Montana | 30055 | 39 | 0 |
639772 | 639772 | 2020-10-17 | McCone | Montana | 30055 | 45 | 0 |
643020 | 643020 | 2020-10-18 | McCone | Montana | 30055 | 46 | 0 |
646266 | 646266 | 2020-10-19 | McCone | Montana | 30055 | 48 | 0 |
649510 | 649510 | 2020-10-20 | McCone | Montana | 30055 | 48 | 0 |
652755 | 652755 | 2020-10-21 | McCone | Montana | 30055 | 52 | 0 |
656000 | 656000 | 2020-10-22 | McCone | Montana | 30055 | 58 | 0 |
659245 | 659245 | 2020-10-23 | McCone | Montana | 30055 | 59 | 0 |
662489 | 662489 | 2020-10-24 | McCone | Montana | 30055 | 61 | 0 |
665734 | 665734 | 2020-10-25 | McCone | Montana | 30055 | 61 | 0 |
668978 | 668978 | 2020-10-26 | McCone | Montana | 30055 | 61 | 0 |
672220 | 672220 | 2020-10-27 | McCone | Montana | 30055 | 61 | 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);