ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 91 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 14
county 14
- Judith Basin 40
- Garfield 7
- Powder River 5
- Madison 4
- Carbon 2
- Lincoln 2
- Meagher 2
- Teton 2
- Custer 1
- Golden Valley 1
- Hill 1
- Phillips 1
- Sheridan 1
- Yellowstone 1
state 1
- Montana · 70 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850740 | 1850740 | 2021-10-25 | Golden Valley | Montana | 30037 | 91 | 3 |
1649310 | 1649310 | 2021-08-24 | Garfield | Montana | 30033 | 91 | 3 |
1646061 | 1646061 | 2021-08-23 | Garfield | Montana | 30033 | 91 | 3 |
1642812 | 1642812 | 2021-08-22 | Garfield | Montana | 30033 | 91 | 3 |
1639562 | 1639562 | 2021-08-21 | Garfield | Montana | 30033 | 91 | 3 |
1636312 | 1636312 | 2021-08-20 | Garfield | Montana | 30033 | 91 | 3 |
1633062 | 1633062 | 2021-08-19 | Garfield | Montana | 30033 | 91 | 2 |
1629815 | 1629815 | 2021-08-18 | Garfield | Montana | 30033 | 91 | 2 |
1425257 | 1425257 | 2021-06-16 | Judith Basin | Montana | 30045 | 91 | 1 |
1422009 | 1422009 | 2021-06-15 | Judith Basin | Montana | 30045 | 91 | 1 |
1418764 | 1418764 | 2021-06-14 | Judith Basin | Montana | 30045 | 91 | 1 |
1415519 | 1415519 | 2021-06-13 | Judith Basin | Montana | 30045 | 91 | 1 |
1412273 | 1412273 | 2021-06-12 | Judith Basin | Montana | 30045 | 91 | 1 |
1409028 | 1409028 | 2021-06-11 | Judith Basin | Montana | 30045 | 91 | 1 |
1405783 | 1405783 | 2021-06-10 | Judith Basin | Montana | 30045 | 91 | 1 |
1402537 | 1402537 | 2021-06-09 | Judith Basin | Montana | 30045 | 91 | 1 |
1399292 | 1399292 | 2021-06-08 | Judith Basin | Montana | 30045 | 91 | 1 |
1396046 | 1396046 | 2021-06-07 | Judith Basin | Montana | 30045 | 91 | 1 |
1392800 | 1392800 | 2021-06-06 | Judith Basin | Montana | 30045 | 91 | 1 |
1389555 | 1389555 | 2021-06-05 | Judith Basin | Montana | 30045 | 91 | 1 |
1386310 | 1386310 | 2021-06-04 | Judith Basin | Montana | 30045 | 91 | 1 |
1383065 | 1383065 | 2021-06-03 | Judith Basin | Montana | 30045 | 91 | 1 |
1379819 | 1379819 | 2021-06-02 | Judith Basin | Montana | 30045 | 91 | 1 |
1376574 | 1376574 | 2021-06-01 | Judith Basin | Montana | 30045 | 91 | 1 |
1373328 | 1373328 | 2021-05-31 | Judith Basin | Montana | 30045 | 91 | 1 |
1370083 | 1370083 | 2021-05-30 | Judith Basin | Montana | 30045 | 91 | 1 |
1366837 | 1366837 | 2021-05-29 | Judith Basin | Montana | 30045 | 91 | 1 |
1363591 | 1363591 | 2021-05-28 | Judith Basin | Montana | 30045 | 91 | 1 |
1360344 | 1360344 | 2021-05-27 | Judith Basin | Montana | 30045 | 91 | 1 |
1357098 | 1357098 | 2021-05-26 | Judith Basin | Montana | 30045 | 91 | 1 |
1353852 | 1353852 | 2021-05-25 | Judith Basin | Montana | 30045 | 91 | 1 |
1350606 | 1350606 | 2021-05-24 | Judith Basin | Montana | 30045 | 91 | 1 |
1347360 | 1347360 | 2021-05-23 | Judith Basin | Montana | 30045 | 91 | 1 |
1344112 | 1344112 | 2021-05-22 | Judith Basin | Montana | 30045 | 91 | 1 |
1340864 | 1340864 | 2021-05-21 | Judith Basin | Montana | 30045 | 91 | 1 |
1337616 | 1337616 | 2021-05-20 | Judith Basin | Montana | 30045 | 91 | 1 |
1334369 | 1334369 | 2021-05-19 | Judith Basin | Montana | 30045 | 91 | 1 |
1331122 | 1331122 | 2021-05-18 | Judith Basin | Montana | 30045 | 91 | 1 |
1327875 | 1327875 | 2021-05-17 | Judith Basin | Montana | 30045 | 91 | 1 |
1324629 | 1324629 | 2021-05-16 | Judith Basin | Montana | 30045 | 91 | 1 |
1321383 | 1321383 | 2021-05-15 | Judith Basin | Montana | 30045 | 91 | 1 |
1318137 | 1318137 | 2021-05-14 | Judith Basin | Montana | 30045 | 91 | 1 |
1314889 | 1314889 | 2021-05-13 | Judith Basin | Montana | 30045 | 91 | 1 |
1311643 | 1311643 | 2021-05-12 | Judith Basin | Montana | 30045 | 91 | 1 |
1308396 | 1308396 | 2021-05-11 | Judith Basin | Montana | 30045 | 91 | 1 |
1305150 | 1305150 | 2021-05-10 | Judith Basin | Montana | 30045 | 91 | 1 |
1301904 | 1301904 | 2021-05-09 | Judith Basin | Montana | 30045 | 91 | 1 |
1298656 | 1298656 | 2021-05-08 | Judith Basin | Montana | 30045 | 91 | 1 |
827973 | 827973 | 2020-12-14 | Powder River | Montana | 30075 | 91 | 5 |
824726 | 824726 | 2020-12-13 | Powder River | Montana | 30075 | 91 | 5 |
821480 | 821480 | 2020-12-12 | Powder River | Montana | 30075 | 91 | 5 |
818234 | 818234 | 2020-12-11 | Powder River | Montana | 30075 | 91 | 5 |
814988 | 814988 | 2020-12-10 | Powder River | Montana | 30075 | 91 | 5 |
698167 | 698167 | 2020-11-04 | Meagher | Montana | 30059 | 91 | 5 |
694924 | 694924 | 2020-11-03 | Meagher | Montana | 30059 | 91 | 5 |
691698 | 691698 | 2020-11-02 | Sheridan | Montana | 30091 | 91 | 0 |
685213 | 685213 | 2020-10-31 | Teton | Montana | 30099 | 91 | 1 |
681970 | 681970 | 2020-10-30 | Teton | Montana | 30099 | 91 | 0 |
542513 | 542513 | 2020-09-17 | Custer | Montana | 30017 | 91 | 2 |
500456 | 500456 | 2020-09-04 | Carbon | Montana | 30009 | 91 | 0 |
500477 | 500477 | 2020-09-04 | Lincoln | Montana | 30053 | 91 | 2 |
497222 | 497222 | 2020-09-03 | Carbon | Montana | 30009 | 91 | 0 |
497243 | 497243 | 2020-09-03 | Lincoln | Montana | 30053 | 91 | 2 |
494004 | 494004 | 2020-09-02 | Hill | Montana | 30041 | 91 | 2 |
471378 | 471378 | 2020-08-26 | Madison | Montana | 30057 | 91 | 1 |
468148 | 468148 | 2020-08-25 | Madison | Montana | 30057 | 91 | 1 |
464919 | 464919 | 2020-08-24 | Madison | Montana | 30057 | 91 | 1 |
461688 | 461688 | 2020-08-23 | Madison | Montana | 30057 | 91 | 1 |
435880 | 435880 | 2020-08-15 | Phillips | Montana | 30071 | 91 | 0 |
192293 | 192293 | 2020-05-30 | Yellowstone | Montana | 30111 | 91 | 3 |
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);