ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
668 rows where fips = 30097 and state = "Montana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
336275 | 336275 | 2020-07-15 | Sweet Grass | Montana | 30097 | 1 | 0 |
339472 | 339472 | 2020-07-16 | Sweet Grass | Montana | 30097 | 1 | 0 |
342668 | 342668 | 2020-07-17 | Sweet Grass | Montana | 30097 | 2 | 0 |
345868 | 345868 | 2020-07-18 | Sweet Grass | Montana | 30097 | 2 | 0 |
349069 | 349069 | 2020-07-19 | Sweet Grass | Montana | 30097 | 2 | 0 |
352270 | 352270 | 2020-07-20 | Sweet Grass | Montana | 30097 | 2 | 0 |
355473 | 355473 | 2020-07-21 | Sweet Grass | Montana | 30097 | 3 | 0 |
358677 | 358677 | 2020-07-22 | Sweet Grass | Montana | 30097 | 4 | 1 |
361883 | 361883 | 2020-07-23 | Sweet Grass | Montana | 30097 | 4 | 1 |
365090 | 365090 | 2020-07-24 | Sweet Grass | Montana | 30097 | 4 | 1 |
368299 | 368299 | 2020-07-25 | Sweet Grass | Montana | 30097 | 4 | 1 |
371510 | 371510 | 2020-07-26 | Sweet Grass | Montana | 30097 | 4 | 1 |
374722 | 374722 | 2020-07-27 | Sweet Grass | Montana | 30097 | 4 | 1 |
377937 | 377937 | 2020-07-28 | Sweet Grass | Montana | 30097 | 4 | 1 |
381155 | 381155 | 2020-07-29 | Sweet Grass | Montana | 30097 | 4 | 1 |
384371 | 384371 | 2020-07-30 | Sweet Grass | Montana | 30097 | 4 | 1 |
387589 | 387589 | 2020-07-31 | Sweet Grass | Montana | 30097 | 4 | 1 |
390806 | 390806 | 2020-08-01 | Sweet Grass | Montana | 30097 | 4 | 1 |
394023 | 394023 | 2020-08-02 | Sweet Grass | Montana | 30097 | 4 | 1 |
397239 | 397239 | 2020-08-03 | Sweet Grass | Montana | 30097 | 4 | 1 |
400454 | 400454 | 2020-08-04 | Sweet Grass | Montana | 30097 | 4 | 1 |
403672 | 403672 | 2020-08-05 | Sweet Grass | Montana | 30097 | 5 | 1 |
406890 | 406890 | 2020-08-06 | Sweet Grass | Montana | 30097 | 5 | 1 |
410110 | 410110 | 2020-08-07 | Sweet Grass | Montana | 30097 | 5 | 1 |
413330 | 413330 | 2020-08-08 | Sweet Grass | Montana | 30097 | 5 | 1 |
416550 | 416550 | 2020-08-09 | Sweet Grass | Montana | 30097 | 5 | 1 |
419771 | 419771 | 2020-08-10 | Sweet Grass | Montana | 30097 | 5 | 1 |
422994 | 422994 | 2020-08-11 | Sweet Grass | Montana | 30097 | 5 | 1 |
426216 | 426216 | 2020-08-12 | Sweet Grass | Montana | 30097 | 5 | 1 |
429440 | 429440 | 2020-08-13 | Sweet Grass | Montana | 30097 | 5 | 1 |
432667 | 432667 | 2020-08-14 | Sweet Grass | Montana | 30097 | 5 | 1 |
435893 | 435893 | 2020-08-15 | Sweet Grass | Montana | 30097 | 5 | 1 |
439118 | 439118 | 2020-08-16 | Sweet Grass | Montana | 30097 | 6 | 1 |
442345 | 442345 | 2020-08-17 | Sweet Grass | Montana | 30097 | 6 | 1 |
445571 | 445571 | 2020-08-18 | Sweet Grass | Montana | 30097 | 7 | 1 |
448797 | 448797 | 2020-08-19 | Sweet Grass | Montana | 30097 | 7 | 1 |
452025 | 452025 | 2020-08-20 | Sweet Grass | Montana | 30097 | 8 | 1 |
455253 | 455253 | 2020-08-21 | Sweet Grass | Montana | 30097 | 8 | 1 |
458481 | 458481 | 2020-08-22 | Sweet Grass | Montana | 30097 | 8 | 1 |
461708 | 461708 | 2020-08-23 | Sweet Grass | Montana | 30097 | 9 | 1 |
464939 | 464939 | 2020-08-24 | Sweet Grass | Montana | 30097 | 8 | 1 |
468168 | 468168 | 2020-08-25 | Sweet Grass | Montana | 30097 | 9 | 1 |
471398 | 471398 | 2020-08-26 | Sweet Grass | Montana | 30097 | 9 | 1 |
474630 | 474630 | 2020-08-27 | Sweet Grass | Montana | 30097 | 10 | 1 |
477863 | 477863 | 2020-08-28 | Sweet Grass | Montana | 30097 | 10 | 1 |
481095 | 481095 | 2020-08-29 | Sweet Grass | Montana | 30097 | 12 | 1 |
484330 | 484330 | 2020-08-30 | Sweet Grass | Montana | 30097 | 14 | 1 |
487564 | 487564 | 2020-08-31 | Sweet Grass | Montana | 30097 | 19 | 1 |
490797 | 490797 | 2020-09-01 | Sweet Grass | Montana | 30097 | 19 | 1 |
494031 | 494031 | 2020-09-02 | Sweet Grass | Montana | 30097 | 28 | 1 |
497264 | 497264 | 2020-09-03 | Sweet Grass | Montana | 30097 | 29 | 1 |
500498 | 500498 | 2020-09-04 | Sweet Grass | Montana | 30097 | 30 | 1 |
503732 | 503732 | 2020-09-05 | Sweet Grass | Montana | 30097 | 34 | 1 |
506965 | 506965 | 2020-09-06 | Sweet Grass | Montana | 30097 | 34 | 1 |
510198 | 510198 | 2020-09-07 | Sweet Grass | Montana | 30097 | 34 | 1 |
513430 | 513430 | 2020-09-08 | Sweet Grass | Montana | 30097 | 34 | 1 |
516664 | 516664 | 2020-09-09 | Sweet Grass | Montana | 30097 | 35 | 1 |
519899 | 519899 | 2020-09-10 | Sweet Grass | Montana | 30097 | 35 | 1 |
523136 | 523136 | 2020-09-11 | Sweet Grass | Montana | 30097 | 36 | 1 |
526372 | 526372 | 2020-09-12 | Sweet Grass | Montana | 30097 | 36 | 1 |
529608 | 529608 | 2020-09-13 | Sweet Grass | Montana | 30097 | 36 | 1 |
532844 | 532844 | 2020-09-14 | Sweet Grass | Montana | 30097 | 37 | 1 |
536079 | 536079 | 2020-09-15 | Sweet Grass | Montana | 30097 | 37 | 1 |
539316 | 539316 | 2020-09-16 | Sweet Grass | Montana | 30097 | 37 | 1 |
542552 | 542552 | 2020-09-17 | Sweet Grass | Montana | 30097 | 37 | 1 |
545789 | 545789 | 2020-09-18 | Sweet Grass | Montana | 30097 | 37 | 1 |
549027 | 549027 | 2020-09-19 | Sweet Grass | Montana | 30097 | 37 | 1 |
552266 | 552266 | 2020-09-20 | Sweet Grass | Montana | 30097 | 37 | 1 |
555504 | 555504 | 2020-09-21 | Sweet Grass | Montana | 30097 | 37 | 1 |
558741 | 558741 | 2020-09-22 | Sweet Grass | Montana | 30097 | 38 | 1 |
561978 | 561978 | 2020-09-23 | Sweet Grass | Montana | 30097 | 40 | 1 |
565219 | 565219 | 2020-09-24 | Sweet Grass | Montana | 30097 | 42 | 1 |
568459 | 568459 | 2020-09-25 | Sweet Grass | Montana | 30097 | 43 | 1 |
571701 | 571701 | 2020-09-26 | Sweet Grass | Montana | 30097 | 43 | 1 |
574944 | 574944 | 2020-09-27 | Sweet Grass | Montana | 30097 | 43 | 1 |
578185 | 578185 | 2020-09-28 | Sweet Grass | Montana | 30097 | 45 | 1 |
581426 | 581426 | 2020-09-29 | Sweet Grass | Montana | 30097 | 47 | 1 |
584667 | 584667 | 2020-09-30 | Sweet Grass | Montana | 30097 | 47 | 1 |
587907 | 587907 | 2020-10-01 | Sweet Grass | Montana | 30097 | 47 | 2 |
591148 | 591148 | 2020-10-02 | Sweet Grass | Montana | 30097 | 48 | 2 |
594389 | 594389 | 2020-10-03 | Sweet Grass | Montana | 30097 | 51 | 2 |
597630 | 597630 | 2020-10-04 | Sweet Grass | Montana | 30097 | 51 | 2 |
600874 | 600874 | 2020-10-05 | Sweet Grass | Montana | 30097 | 52 | 2 |
604116 | 604116 | 2020-10-06 | Sweet Grass | Montana | 30097 | 52 | 2 |
607359 | 607359 | 2020-10-07 | Sweet Grass | Montana | 30097 | 52 | 2 |
610601 | 610601 | 2020-10-08 | Sweet Grass | Montana | 30097 | 52 | 2 |
613843 | 613843 | 2020-10-09 | Sweet Grass | Montana | 30097 | 52 | 2 |
617084 | 617084 | 2020-10-10 | Sweet Grass | Montana | 30097 | 54 | 2 |
620326 | 620326 | 2020-10-11 | Sweet Grass | Montana | 30097 | 54 | 2 |
623569 | 623569 | 2020-10-12 | Sweet Grass | Montana | 30097 | 56 | 2 |
626811 | 626811 | 2020-10-13 | Sweet Grass | Montana | 30097 | 56 | 2 |
630055 | 630055 | 2020-10-14 | Sweet Grass | Montana | 30097 | 57 | 2 |
633300 | 633300 | 2020-10-15 | Sweet Grass | Montana | 30097 | 58 | 2 |
636546 | 636546 | 2020-10-16 | Sweet Grass | Montana | 30097 | 58 | 2 |
639792 | 639792 | 2020-10-17 | Sweet Grass | Montana | 30097 | 58 | 2 |
643040 | 643040 | 2020-10-18 | Sweet Grass | Montana | 30097 | 58 | 2 |
646286 | 646286 | 2020-10-19 | Sweet Grass | Montana | 30097 | 61 | 2 |
649530 | 649530 | 2020-10-20 | Sweet Grass | Montana | 30097 | 61 | 2 |
652775 | 652775 | 2020-10-21 | Sweet Grass | Montana | 30097 | 62 | 2 |
656020 | 656020 | 2020-10-22 | Sweet Grass | Montana | 30097 | 63 | 2 |
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);