home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

40,656 rows where state = "Montana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >30

  • 30031 792
  • 30049 792
  • 30093 792
  • 30111 792
  • 30063 791
  • 30007 786
  • 30029 786
  • 30057 786
  • 30085 786
  • 30013 784
  • 30081 784
  • 30043 781
  • 30041 780
  • 30053 779
  • 30059 779
  • 30101 779
  • 30047 778
  • 30067 778
  • 30023 776
  • 30051 774
  • 30065 774
  • 30009 773
  • 30035 771
  • 30001 770
  • 30083 766
  • 30095 765
  • 30003 764
  • 30037 763
  • 30073 759
  • 30107 750
  • …

county >30

  • Gallatin 792
  • Lewis and Clark 792
  • Silver Bow 792
  • Yellowstone 792
  • Missoula 791
  • Broadwater 786
  • Flathead 786
  • Madison 786
  • Roosevelt 786
  • Cascade 784
  • Ravalli 784
  • Jefferson 781
  • Hill 780
  • Lincoln 779
  • Meagher 779
  • Toole 779
  • Lake 778
  • Park 778
  • Deer Lodge 776
  • Liberty 774
  • Musselshell 774
  • Carbon 773
  • Glacier 771
  • Beaverhead 770
  • Richland 766
  • Stillwater 765
  • Big Horn 764
  • Golden Valley 763
  • Pondera 759
  • Wheatland 750
  • …

state 1

  • Montana · 40,656 ✖
Link rowid date ▲ county state fips cases deaths
2501193 2501193 2022-05-13 Beaverhead Montana 30001 2137 30
2501194 2501194 2022-05-13 Big Horn Montana 30003 4980 96
2501195 2501195 2022-05-13 Blaine Montana 30005 2077 32
2501196 2501196 2022-05-13 Broadwater Montana 30007 1283 21
2501197 2501197 2022-05-13 Carbon Montana 30009 2080 28
2501198 2501198 2022-05-13 Carter Montana 30011 252 5
2501199 2501199 2022-05-13 Cascade Montana 30013 25246 341
2501200 2501200 2022-05-13 Chouteau Montana 30015 991 14
2501201 2501201 2022-05-13 Custer Montana 30017 3062 48
2501202 2501202 2022-05-13 Daniels Montana 30019 386 9
2501203 2501203 2022-05-13 Dawson Montana 30021 2357 58
2501204 2501204 2022-05-13 Deer Lodge Montana 30023 2563 29
2501205 2501205 2022-05-13 Fallon Montana 30025 680 10
2501206 2501206 2022-05-13 Fergus Montana 30027 2515 56
2501207 2501207 2022-05-13 Flathead Montana 30029 29318 281
2501208 2501208 2022-05-13 Gallatin Montana 30031 34972 122
2501209 2501209 2022-05-13 Garfield Montana 30033 225 3
2501210 2501210 2022-05-13 Glacier Montana 30035 3978 74
2501211 2501211 2022-05-13 Golden Valley Montana 30037 150 5
2501212 2501212 2022-05-13 Granite Montana 30039 537 9
2501213 2501213 2022-05-13 Hill Montana 30041 4574 73
2501214 2501214 2022-05-13 Jefferson Montana 30043 2601 23
2501215 2501215 2022-05-13 Judith Basin Montana 30045 225 1
2501216 2501216 2022-05-13 Lake Montana 30047 6634 100
2501217 2501217 2022-05-13 Lewis and Clark Montana 30049 17709 185
2501218 2501218 2022-05-13 Liberty Montana 30051 398 4
2501219 2501219 2022-05-13 Lincoln Montana 30053 4787 89
2501220 2501220 2022-05-13 Madison Montana 30057 1819 20
2501221 2501221 2022-05-13 McCone Montana 30055 383 9
2501222 2501222 2022-05-13 Meagher Montana 30059 412 10
2501223 2501223 2022-05-13 Mineral Montana 30061 1100 17
2501224 2501224 2022-05-13 Missoula Montana 30063 27678 209
2501225 2501225 2022-05-13 Musselshell Montana 30065 917 31
2501226 2501226 2022-05-13 Park Montana 30067 4260 35
2501227 2501227 2022-05-13 Petroleum Montana 30069 35 1
2501228 2501228 2022-05-13 Phillips Montana 30071 1060 28
2501229 2501229 2022-05-13 Pondera Montana 30073 1183 8
2501230 2501230 2022-05-13 Powder River Montana 30075 343 10
2501231 2501231 2022-05-13 Powell Montana 30077 1869 29
2501232 2501232 2022-05-13 Prairie Montana 30079 263 3
2501233 2501233 2022-05-13 Ravalli Montana 30081 7089 164
2501234 2501234 2022-05-13 Richland Montana 30083 2646 35
2501235 2501235 2022-05-13 Roosevelt Montana 30085 3279 74
2501236 2501236 2022-05-13 Rosebud Montana 30087 2633 60
2501237 2501237 2022-05-13 Sanders Montana 30089 2164 47
2501238 2501238 2022-05-13 Sheridan Montana 30091 698 11
2501239 2501239 2022-05-13 Silver Bow Montana 30093 8511 130
2501240 2501240 2022-05-13 Stillwater Montana 30095 1538 32
2501241 2501241 2022-05-13 Sweet Grass Montana 30097 785 13
2501242 2501242 2022-05-13 Teton Montana 30099 1290 24
2501243 2501243 2022-05-13 Toole Montana 30101 1249 24
2501244 2501244 2022-05-13 Treasure Montana 30103 133 1
2501245 2501245 2022-05-13 Valley Montana 30105 1705 37
2501246 2501246 2022-05-13 Wheatland Montana 30107 386 14
2501247 2501247 2022-05-13 Wibaux Montana 30109 204 8
2501248 2501248 2022-05-13 Yellowstone Montana 30111 43099 551
2497935 2497935 2022-05-12 Beaverhead Montana 30001 2136 30
2497936 2497936 2022-05-12 Big Horn Montana 30003 4976 95
2497937 2497937 2022-05-12 Blaine Montana 30005 2073 32
2497938 2497938 2022-05-12 Broadwater Montana 30007 1282 21
2497939 2497939 2022-05-12 Carbon Montana 30009 2076 28
2497940 2497940 2022-05-12 Carter Montana 30011 252 5
2497941 2497941 2022-05-12 Cascade Montana 30013 25219 341
2497942 2497942 2022-05-12 Chouteau Montana 30015 991 14
2497943 2497943 2022-05-12 Custer Montana 30017 3060 48
2497944 2497944 2022-05-12 Daniels Montana 30019 386 9
2497945 2497945 2022-05-12 Dawson Montana 30021 2355 58
2497946 2497946 2022-05-12 Deer Lodge Montana 30023 2560 29
2497947 2497947 2022-05-12 Fallon Montana 30025 679 10
2497948 2497948 2022-05-12 Fergus Montana 30027 2512 56
2497949 2497949 2022-05-12 Flathead Montana 30029 29253 281
2497950 2497950 2022-05-12 Gallatin Montana 30031 34927 122
2497951 2497951 2022-05-12 Garfield Montana 30033 225 3
2497952 2497952 2022-05-12 Glacier Montana 30035 3961 74
2497953 2497953 2022-05-12 Golden Valley Montana 30037 150 5
2497954 2497954 2022-05-12 Granite Montana 30039 536 9
2497955 2497955 2022-05-12 Hill Montana 30041 4570 73
2497956 2497956 2022-05-12 Jefferson Montana 30043 2598 23
2497957 2497957 2022-05-12 Judith Basin Montana 30045 225 1
2497958 2497958 2022-05-12 Lake Montana 30047 6621 100
2497959 2497959 2022-05-12 Lewis and Clark Montana 30049 17686 185
2497960 2497960 2022-05-12 Liberty Montana 30051 398 4
2497961 2497961 2022-05-12 Lincoln Montana 30053 4784 89
2497962 2497962 2022-05-12 Madison Montana 30057 1818 20
2497963 2497963 2022-05-12 McCone Montana 30055 383 9
2497964 2497964 2022-05-12 Meagher Montana 30059 409 10
2497965 2497965 2022-05-12 Mineral Montana 30061 1100 17
2497966 2497966 2022-05-12 Missoula Montana 30063 27597 209
2497967 2497967 2022-05-12 Musselshell Montana 30065 916 31
2497968 2497968 2022-05-12 Park Montana 30067 4232 35
2497969 2497969 2022-05-12 Petroleum Montana 30069 35 1
2497970 2497970 2022-05-12 Phillips Montana 30071 1060 28
2497971 2497971 2022-05-12 Pondera Montana 30073 1178 8
2497972 2497972 2022-05-12 Powder River Montana 30075 343 10
2497973 2497973 2022-05-12 Powell Montana 30077 1868 29
2497974 2497974 2022-05-12 Prairie Montana 30079 263 3
2497975 2497975 2022-05-12 Ravalli Montana 30081 7082 164
2497976 2497976 2022-05-12 Richland Montana 30083 2645 33
2497977 2497977 2022-05-12 Roosevelt Montana 30085 3279 74
2497978 2497978 2022-05-12 Rosebud Montana 30087 2633 60

Next page

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);
Powered by Datasette · Queries took 356.805ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette