ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

56 rows where date = "2021-05-28" and state = "Montana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Montana · 56 ✖
Link rowid date ▲ county state fips cases deaths
1363569 1363569 2021-05-28 Beaverhead Montana 30001 910 11
1363570 1363570 2021-05-28 Big Horn Montana 30003 2568 76
1363571 1363571 2021-05-28 Blaine Montana 30005 794 24
1363572 1363572 2021-05-28 Broadwater Montana 30007 507 5
1363573 1363573 2021-05-28 Carbon Montana 30009 884 16
1363574 1363574 2021-05-28 Carter Montana 30011 151 5
1363575 1363575 2021-05-28 Cascade Montana 30013 9243 170
1363576 1363576 2021-05-28 Chouteau Montana 30015 509 6
1363577 1363577 2021-05-28 Custer Montana 30017 1195 18
1363578 1363578 2021-05-28 Daniels Montana 30019 197 8
1363579 1363579 2021-05-28 Dawson Montana 30021 1100 30
1363580 1363580 2021-05-28 Deer Lodge Montana 30023 1117 15
1363581 1363581 2021-05-28 Fallon Montana 30025 286 2
1363582 1363582 2021-05-28 Fergus Montana 30027 1120 31
1363583 1363583 2021-05-28 Flathead Montana 30029 12142 96
1363584 1363584 2021-05-28 Gallatin Montana 30031 14908 63
1363585 1363585 2021-05-28 Garfield Montana 30033 80 2
1363586 1363586 2021-05-28 Glacier Montana 30035 1541 42
1363587 1363587 2021-05-28 Golden Valley Montana 30037 57 2
1363588 1363588 2021-05-28 Granite Montana 30039 201 2
1363589 1363589 2021-05-28 Hill Montana 30041 1999 45
1363590 1363590 2021-05-28 Jefferson Montana 30043 1097 8
1363591 1363591 2021-05-28 Judith Basin Montana 30045 91 1
1363592 1363592 2021-05-28 Lake Montana 30047 2110 36
1363593 1363593 2021-05-28 Lewis and Clark Montana 30049 6960 88
1363594 1363594 2021-05-28 Liberty Montana 30051 117 1
1363595 1363595 2021-05-28 Lincoln Montana 30053 1630 17
1363596 1363596 2021-05-28 Madison Montana 30057 786 8
1363597 1363597 2021-05-28 McCone Montana 30055 183 1
1363598 1363598 2021-05-28 Meagher Montana 30059 151 7
1363599 1363599 2021-05-28 Mineral Montana 30061 263 0
1363600 1363600 2021-05-28 Missoula Montana 30063 9199 94
1363601 1363601 2021-05-28 Musselshell Montana 30065 355 12
1363602 1363602 2021-05-28 Park Montana 30067 1425 20
1363603 1363603 2021-05-28 Petroleum Montana 30069 12 1
1363604 1363604 2021-05-28 Phillips Montana 30071 524 16
1363605 1363605 2021-05-28 Pondera Montana 30073 500 4
1363606 1363606 2021-05-28 Powder River Montana 30075 125 6
1363607 1363607 2021-05-28 Powell Montana 30077 928 10
1363608 1363608 2021-05-28 Prairie Montana 30079 141 2
1363609 1363609 2021-05-28 Ravalli Montana 30081 3150 45
1363610 1363610 2021-05-28 Richland Montana 30083 1242 17
1363611 1363611 2021-05-28 Roosevelt Montana 30085 1658 54
1363612 1363612 2021-05-28 Rosebud Montana 30087 1229 50
1363613 1363613 2021-05-28 Sanders Montana 30089 647 15
1363614 1363614 2021-05-28 Sheridan Montana 30091 424 5
1363615 1363615 2021-05-28 Silver Bow Montana 30093 4112 86
1363616 1363616 2021-05-28 Stillwater Montana 30095 727 14
1363617 1363617 2021-05-28 Sweet Grass Montana 30097 402 7
1363618 1363618 2021-05-28 Teton Montana 30099 502 6
1363619 1363619 2021-05-28 Toole Montana 30101 722 11
1363620 1363620 2021-05-28 Treasure Montana 30103 55 1
1363621 1363621 2021-05-28 Valley Montana 30105 901 18
1363622 1363622 2021-05-28 Wheatland Montana 30107 180 8
1363623 1363623 2021-05-28 Wibaux Montana 30109 121 6
1363624 1363624 2021-05-28 Yellowstone Montana 30111 17644 268

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);