ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40,656 rows where state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 57
- 30031 459
- 30049 459
- 30093 459
- 30111 459
- 30063 458
- 30007 453
- 30029 453
- 30057 453
- 30085 453
- 30013 451
- 30081 451
- 30043 448
- 30041 447
- 30053 446
- 30059 446
- 30101 446
- 30047 445
- 30067 445
- 30023 443
- 30051 441
- 30065 441
- 30009 440
- 30035 438
- 30001 437
- 30083 433
- 30095 432
- 30003 431
- 30037 430
- 30073 426
- 30107 417
- 30087 378
- 30017 368
- 30027 362
- 30105 362
- 30021 360
- 30103 356
- 30039 355
- 30099 348
- 30091 347
- 30025 338
- 30033 337
- 30089 336
- 30109 336
- 30097 335
- 30005 334
- 30055 330
- 30015 329
- 30045 328
- 30075 327
- 30019 325
- 30077 321
- 30079 315
- 30071 314
- 30061 308
- 30011 264
- 30069 253
- - 2
county 57
- Gallatin 459
- Lewis and Clark 459
- Silver Bow 459
- Yellowstone 459
- Missoula 458
- Broadwater 453
- Flathead 453
- Madison 453
- Roosevelt 453
- Cascade 451
- Ravalli 451
- Jefferson 448
- Hill 447
- Lincoln 446
- Meagher 446
- Toole 446
- Lake 445
- Park 445
- Deer Lodge 443
- Liberty 441
- Musselshell 441
- Carbon 440
- Glacier 438
- Beaverhead 437
- Richland 433
- Stillwater 432
- Big Horn 431
- Golden Valley 430
- Pondera 426
- Wheatland 417
- Rosebud 378
- Custer 368
- Fergus 362
- Valley 362
- Dawson 360
- Treasure 356
- Granite 355
- Teton 348
- Sheridan 347
- Fallon 338
- Garfield 337
- Sanders 336
- Wibaux 336
- Sweet Grass 335
- Blaine 334
- McCone 330
- Chouteau 329
- Judith Basin 328
- Powder River 327
- Daniels 325
- Powell 321
- Prairie 315
- Phillips 314
- Mineral 308
- Carter 264
- Petroleum 253
- Unknown 2
state 1
- Montana · 22,008 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418742 | 1418742 | 2021-06-14 | Beaverhead | Montana | 30001 | 921 | 11 |
1418743 | 1418743 | 2021-06-14 | Big Horn | Montana | 30003 | 2581 | 76 |
1418744 | 1418744 | 2021-06-14 | Blaine | Montana | 30005 | 808 | 24 |
1418745 | 1418745 | 2021-06-14 | Broadwater | Montana | 30007 | 513 | 5 |
1418746 | 1418746 | 2021-06-14 | Carbon | Montana | 30009 | 898 | 17 |
1418747 | 1418747 | 2021-06-14 | Carter | Montana | 30011 | 151 | 5 |
1418748 | 1418748 | 2021-06-14 | Cascade | Montana | 30013 | 9376 | 183 |
1418749 | 1418749 | 2021-06-14 | Chouteau | Montana | 30015 | 516 | 7 |
1418750 | 1418750 | 2021-06-14 | Custer | Montana | 30017 | 1206 | 18 |
1418751 | 1418751 | 2021-06-14 | Daniels | Montana | 30019 | 197 | 8 |
1418752 | 1418752 | 2021-06-14 | Dawson | Montana | 30021 | 1102 | 29 |
1418753 | 1418753 | 2021-06-14 | Deer Lodge | Montana | 30023 | 1121 | 15 |
1418754 | 1418754 | 2021-06-14 | Fallon | Montana | 30025 | 288 | 2 |
1418755 | 1418755 | 2021-06-14 | Fergus | Montana | 30027 | 1126 | 31 |
1418756 | 1418756 | 2021-06-14 | Flathead | Montana | 30029 | 12318 | 100 |
1418757 | 1418757 | 2021-06-14 | Gallatin | Montana | 30031 | 14996 | 63 |
1418758 | 1418758 | 2021-06-14 | Garfield | Montana | 30033 | 80 | 2 |
1418759 | 1418759 | 2021-06-14 | Glacier | Montana | 30035 | 1546 | 42 |
1418760 | 1418760 | 2021-06-14 | Golden Valley | Montana | 30037 | 57 | 2 |
1418761 | 1418761 | 2021-06-14 | Granite | Montana | 30039 | 204 | 2 |
1418762 | 1418762 | 2021-06-14 | Hill | Montana | 30041 | 2027 | 45 |
1418763 | 1418763 | 2021-06-14 | Jefferson | Montana | 30043 | 1109 | 8 |
1418764 | 1418764 | 2021-06-14 | Judith Basin | Montana | 30045 | 91 | 1 |
1418765 | 1418765 | 2021-06-14 | Lake | Montana | 30047 | 2128 | 36 |
1418766 | 1418766 | 2021-06-14 | Lewis and Clark | Montana | 30049 | 7016 | 89 |
1418767 | 1418767 | 2021-06-14 | Liberty | Montana | 30051 | 119 | 1 |
1418768 | 1418768 | 2021-06-14 | Lincoln | Montana | 30053 | 1632 | 18 |
1418769 | 1418769 | 2021-06-14 | Madison | Montana | 30057 | 790 | 8 |
1418770 | 1418770 | 2021-06-14 | McCone | Montana | 30055 | 183 | 1 |
1418771 | 1418771 | 2021-06-14 | Meagher | Montana | 30059 | 152 | 7 |
1418772 | 1418772 | 2021-06-14 | Mineral | Montana | 30061 | 279 | 1 |
1418773 | 1418773 | 2021-06-14 | Missoula | Montana | 30063 | 9304 | 95 |
1418774 | 1418774 | 2021-06-14 | Musselshell | Montana | 30065 | 367 | 14 |
1418775 | 1418775 | 2021-06-14 | Park | Montana | 30067 | 1451 | 20 |
1418776 | 1418776 | 2021-06-14 | Petroleum | Montana | 30069 | 12 | 1 |
1418777 | 1418777 | 2021-06-14 | Phillips | Montana | 30071 | 524 | 16 |
1418778 | 1418778 | 2021-06-14 | Pondera | Montana | 30073 | 507 | 4 |
1418779 | 1418779 | 2021-06-14 | Powder River | Montana | 30075 | 126 | 6 |
1418780 | 1418780 | 2021-06-14 | Powell | Montana | 30077 | 935 | 11 |
1418781 | 1418781 | 2021-06-14 | Prairie | Montana | 30079 | 141 | 2 |
1418782 | 1418782 | 2021-06-14 | Ravalli | Montana | 30081 | 3232 | 46 |
1418783 | 1418783 | 2021-06-14 | Richland | Montana | 30083 | 1245 | 18 |
1418784 | 1418784 | 2021-06-14 | Roosevelt | Montana | 30085 | 1667 | 55 |
1418785 | 1418785 | 2021-06-14 | Rosebud | Montana | 30087 | 1230 | 50 |
1418786 | 1418786 | 2021-06-14 | Sanders | Montana | 30089 | 665 | 15 |
1418787 | 1418787 | 2021-06-14 | Sheridan | Montana | 30091 | 424 | 5 |
1418788 | 1418788 | 2021-06-14 | Silver Bow | Montana | 30093 | 4136 | 86 |
1418789 | 1418789 | 2021-06-14 | Stillwater | Montana | 30095 | 745 | 14 |
1418790 | 1418790 | 2021-06-14 | Sweet Grass | Montana | 30097 | 403 | 7 |
1418791 | 1418791 | 2021-06-14 | Teton | Montana | 30099 | 506 | 6 |
1418792 | 1418792 | 2021-06-14 | Toole | Montana | 30101 | 723 | 11 |
1418793 | 1418793 | 2021-06-14 | Treasure | Montana | 30103 | 55 | 1 |
1418794 | 1418794 | 2021-06-14 | Valley | Montana | 30105 | 902 | 18 |
1418795 | 1418795 | 2021-06-14 | Wheatland | Montana | 30107 | 180 | 8 |
1418796 | 1418796 | 2021-06-14 | Wibaux | Montana | 30109 | 121 | 6 |
1418797 | 1418797 | 2021-06-14 | Yellowstone | Montana | 30111 | 17827 | 271 |
1415497 | 1415497 | 2021-06-13 | Beaverhead | Montana | 30001 | 921 | 11 |
1415498 | 1415498 | 2021-06-13 | Big Horn | Montana | 30003 | 2581 | 76 |
1415499 | 1415499 | 2021-06-13 | Blaine | Montana | 30005 | 808 | 24 |
1415500 | 1415500 | 2021-06-13 | Broadwater | Montana | 30007 | 512 | 5 |
1415501 | 1415501 | 2021-06-13 | Carbon | Montana | 30009 | 898 | 17 |
1415502 | 1415502 | 2021-06-13 | Carter | Montana | 30011 | 151 | 5 |
1415503 | 1415503 | 2021-06-13 | Cascade | Montana | 30013 | 9357 | 184 |
1415504 | 1415504 | 2021-06-13 | Chouteau | Montana | 30015 | 516 | 7 |
1415505 | 1415505 | 2021-06-13 | Custer | Montana | 30017 | 1205 | 18 |
1415506 | 1415506 | 2021-06-13 | Daniels | Montana | 30019 | 197 | 8 |
1415507 | 1415507 | 2021-06-13 | Dawson | Montana | 30021 | 1099 | 29 |
1415508 | 1415508 | 2021-06-13 | Deer Lodge | Montana | 30023 | 1121 | 15 |
1415509 | 1415509 | 2021-06-13 | Fallon | Montana | 30025 | 288 | 2 |
1415510 | 1415510 | 2021-06-13 | Fergus | Montana | 30027 | 1126 | 31 |
1415511 | 1415511 | 2021-06-13 | Flathead | Montana | 30029 | 12316 | 98 |
1415512 | 1415512 | 2021-06-13 | Gallatin | Montana | 30031 | 14992 | 63 |
1415513 | 1415513 | 2021-06-13 | Garfield | Montana | 30033 | 80 | 2 |
1415514 | 1415514 | 2021-06-13 | Glacier | Montana | 30035 | 1545 | 42 |
1415515 | 1415515 | 2021-06-13 | Golden Valley | Montana | 30037 | 57 | 2 |
1415516 | 1415516 | 2021-06-13 | Granite | Montana | 30039 | 203 | 2 |
1415517 | 1415517 | 2021-06-13 | Hill | Montana | 30041 | 2026 | 45 |
1415518 | 1415518 | 2021-06-13 | Jefferson | Montana | 30043 | 1109 | 8 |
1415519 | 1415519 | 2021-06-13 | Judith Basin | Montana | 30045 | 91 | 1 |
1415520 | 1415520 | 2021-06-13 | Lake | Montana | 30047 | 2128 | 36 |
1415521 | 1415521 | 2021-06-13 | Lewis and Clark | Montana | 30049 | 7010 | 89 |
1415522 | 1415522 | 2021-06-13 | Liberty | Montana | 30051 | 119 | 1 |
1415523 | 1415523 | 2021-06-13 | Lincoln | Montana | 30053 | 1631 | 18 |
1415524 | 1415524 | 2021-06-13 | Madison | Montana | 30057 | 789 | 8 |
1415525 | 1415525 | 2021-06-13 | McCone | Montana | 30055 | 183 | 1 |
1415526 | 1415526 | 2021-06-13 | Meagher | Montana | 30059 | 152 | 7 |
1415527 | 1415527 | 2021-06-13 | Mineral | Montana | 30061 | 278 | 1 |
1415528 | 1415528 | 2021-06-13 | Missoula | Montana | 30063 | 9296 | 95 |
1415529 | 1415529 | 2021-06-13 | Musselshell | Montana | 30065 | 370 | 13 |
1415530 | 1415530 | 2021-06-13 | Park | Montana | 30067 | 1451 | 20 |
1415531 | 1415531 | 2021-06-13 | Petroleum | Montana | 30069 | 12 | 1 |
1415532 | 1415532 | 2021-06-13 | Phillips | Montana | 30071 | 524 | 16 |
1415533 | 1415533 | 2021-06-13 | Pondera | Montana | 30073 | 507 | 4 |
1415534 | 1415534 | 2021-06-13 | Powder River | Montana | 30075 | 126 | 6 |
1415535 | 1415535 | 2021-06-13 | Powell | Montana | 30077 | 931 | 11 |
1415536 | 1415536 | 2021-06-13 | Prairie | Montana | 30079 | 141 | 2 |
1415537 | 1415537 | 2021-06-13 | Ravalli | Montana | 30081 | 3224 | 46 |
1415538 | 1415538 | 2021-06-13 | Richland | Montana | 30083 | 1244 | 18 |
1415539 | 1415539 | 2021-06-13 | Roosevelt | Montana | 30085 | 1667 | 55 |
1415540 | 1415540 | 2021-06-13 | Rosebud | Montana | 30087 | 1229 | 50 |
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);