ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
654 rows where county = "Powell" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 278 ✖
- 10 30
- 2 24
- 1865 20
- 1871 14
- 929 13
- 1864 11
- 12 10
- 941 10
- 935 9
- 889 8
- 1868 8
- 909 7
- 915 7
- 920 7
- 944 7
- 892 6
- 924 6
- 936 6
- 1438 6
- 1460 6
- 15 5
- 788 5
- 888 5
- 890 5
- 893 5
- 931 5
- 948 5
- 1854 5
- 1863 5
- 1867 5
- 318 4
- 885 4
- 902 4
- 928 4
- 943 4
- 980 4
- 1074 4
- 1227 4
- 1457 4
- 1464 4
- 1473 4
- 1493 4
- 1534 4
- 1844 4
- 89 3
- 774 3
- 781 3
- 786 3
- 794 3
- 846 3
- 894 3
- 911 3
- 916 3
- 918 3
- 922 3
- 942 3
- 946 3
- 959 3
- 1021 3
- 1042 3
- 1101 3
- 1140 3
- 1166 3
- 1186 3
- 1249 3
- 1310 3
- 1365 3
- 1392 3
- 1416 3
- 1429 3
- 1448 3
- 1625 3
- 1720 3
- 1771 3
- 1834 3
- 1860 3
- 27 2
- 37 2
- 80 2
- 110 2
- 316 2
- 390 2
- 393 2
- 724 2
- 725 2
- 748 2
- 764 2
- 771 2
- 782 2
- 818 2
- 834 2
- 851 2
- 862 2
- 867 2
- 870 2
- 874 2
- 876 2
- 879 2
- 910 2
- 912 2
- 913 2
- 921 2
- 923 2
- 930 2
- 940 2
- 1409 2
- 1426 2
- 1456 2
- 1459 2
- 1746 2
- 1838 2
- 1 1
- 3 1
- 8 1
- 17 1
- 19 1
- 21 1
- 23 1
- 28 1
- 33 1
- 43 1
- 98 1
- 112 1
- 137 1
- 168 1
- 182 1
- 183 1
- 193 1
- 198 1
- 210 1
- 220 1
- 291 1
- 313 1
- 373 1
- 391 1
- 394 1
- 425 1
- 436 1
- 445 1
- 587 1
- 620 1
- 652 1
- 672 1
- 689 1
- 705 1
- 706 1
- 711 1
- 719 1
- 720 1
- 727 1
- 732 1
- 756 1
- 797 1
- 809 1
- 814 1
- 825 1
- 826 1
- 829 1
- 832 1
- 835 1
- 836 1
- 850 1
- 858 1
- 859 1
- 861 1
- 872 1
- 873 1
- 880 1
- 881 1
- 883 1
- 884 1
- 891 1
- 895 1
- 896 1
- 898 1
- 901 1
- 903 1
- 919 1
- 937 1
- 950 1
- 952 1
- 957 1
- 961 1
- 967 1
- 975 1
- 992 1
- 1010 1
- 1013 1
- 1015 1
- 1030 1
- 1033 1
- 1035 1
- 1038 1
- 1050 1
- 1054 1
- 1061 1
- 1065 1
- 1079 1
- 1086 1
- 1093 1
- 1103 1
- 1112 1
- 1122 1
- 1124 1
- 1143 1
- 1148 1
- 1150 1
- 1160 1
- 1171 1
- 1177 1
- 1178 1
- 1181 1
- 1202 1
- 1210 1
- 1213 1
- 1220 1
- 1233 1
- 1236 1
- 1242 1
- 1272 1
- 1281 1
- 1290 1
- 1304 1
- 1324 1
- 1347 1
- 1358 1
- 1362 1
- 1377 1
- 1383 1
- 1386 1
- 1390 1
- 1399 1
- 1404 1
- 1417 1
- 1420 1
- 1431 1
- 1434 1
- 1439 1
- 1441 1
- 1446 1
- 1451 1
- 1458 1
- 1462 1
- 1465 1
- 1467 1
- 1469 1
- 1476 1
- 1477 1
- 1482 1
- 1492 1
- 1501 1
- 1511 1
- 1521 1
- 1554 1
- 1574 1
- 1603 1
- 1643 1
- 1669 1
- 1676 1
- 1692 1
- 1741 1
- 1756 1
- 1787 1
- 1792 1
- 1814 1
- 1830 1
- 1837 1
- 1846 1
- 1849 1
- 1853 1
- 1855 1
- 1857 1
- 1858 1
- 1861 1
- 1866 1
- 1869 1
- 1870 1
- 1872 1
state 1
- Montana · 654 ✖
fips 1
- 30077 654
county 1
- Powell · 654 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501231 | 2501231 | 2022-05-13 | Powell | Montana | 30077 | 1869 | 29 |
2497973 | 2497973 | 2022-05-12 | Powell | Montana | 30077 | 1868 | 29 |
2494715 | 2494715 | 2022-05-11 | Powell | Montana | 30077 | 1868 | 29 |
2491457 | 2491457 | 2022-05-10 | Powell | Montana | 30077 | 1868 | 29 |
2488199 | 2488199 | 2022-05-09 | Powell | Montana | 30077 | 1868 | 29 |
2484942 | 2484942 | 2022-05-08 | Powell | Montana | 30077 | 1868 | 29 |
2481684 | 2481684 | 2022-05-07 | Powell | Montana | 30077 | 1868 | 29 |
2478426 | 2478426 | 2022-05-06 | Powell | Montana | 30077 | 1868 | 29 |
2475168 | 2475168 | 2022-05-05 | Powell | Montana | 30077 | 1872 | 29 |
2471911 | 2471911 | 2022-05-04 | Powell | Montana | 30077 | 1871 | 29 |
2468655 | 2468655 | 2022-05-03 | Powell | Montana | 30077 | 1871 | 29 |
2465399 | 2465399 | 2022-05-02 | Powell | Montana | 30077 | 1871 | 29 |
2462144 | 2462144 | 2022-05-01 | Powell | Montana | 30077 | 1871 | 29 |
2458888 | 2458888 | 2022-04-30 | Powell | Montana | 30077 | 1871 | 29 |
2455632 | 2455632 | 2022-04-29 | Powell | Montana | 30077 | 1871 | 29 |
2452376 | 2452376 | 2022-04-28 | Powell | Montana | 30077 | 1871 | 29 |
2449120 | 2449120 | 2022-04-27 | Powell | Montana | 30077 | 1871 | 29 |
2445863 | 2445863 | 2022-04-26 | Powell | Montana | 30077 | 1871 | 29 |
2442608 | 2442608 | 2022-04-25 | Powell | Montana | 30077 | 1871 | 29 |
2439352 | 2439352 | 2022-04-24 | Powell | Montana | 30077 | 1871 | 28 |
2436096 | 2436096 | 2022-04-23 | Powell | Montana | 30077 | 1871 | 28 |
2432840 | 2432840 | 2022-04-22 | Powell | Montana | 30077 | 1871 | 28 |
2429584 | 2429584 | 2022-04-21 | Powell | Montana | 30077 | 1871 | 28 |
2426328 | 2426328 | 2022-04-20 | Powell | Montana | 30077 | 1870 | 28 |
2423072 | 2423072 | 2022-04-19 | Powell | Montana | 30077 | 1868 | 28 |
2419815 | 2419815 | 2022-04-18 | Powell | Montana | 30077 | 1867 | 28 |
2416560 | 2416560 | 2022-04-17 | Powell | Montana | 30077 | 1867 | 28 |
2413304 | 2413304 | 2022-04-16 | Powell | Montana | 30077 | 1867 | 28 |
2410048 | 2410048 | 2022-04-15 | Powell | Montana | 30077 | 1867 | 28 |
2406792 | 2406792 | 2022-04-14 | Powell | Montana | 30077 | 1867 | 28 |
2403536 | 2403536 | 2022-04-13 | Powell | Montana | 30077 | 1866 | 28 |
2400281 | 2400281 | 2022-04-12 | Powell | Montana | 30077 | 1865 | 28 |
2397026 | 2397026 | 2022-04-11 | Powell | Montana | 30077 | 1865 | 28 |
2393771 | 2393771 | 2022-04-10 | Powell | Montana | 30077 | 1865 | 28 |
2390515 | 2390515 | 2022-04-09 | Powell | Montana | 30077 | 1865 | 28 |
2387259 | 2387259 | 2022-04-08 | Powell | Montana | 30077 | 1865 | 28 |
2384004 | 2384004 | 2022-04-07 | Powell | Montana | 30077 | 1865 | 28 |
2380749 | 2380749 | 2022-04-06 | Powell | Montana | 30077 | 1865 | 28 |
2377494 | 2377494 | 2022-04-05 | Powell | Montana | 30077 | 1865 | 28 |
2374241 | 2374241 | 2022-04-04 | Powell | Montana | 30077 | 1865 | 28 |
2370989 | 2370989 | 2022-04-03 | Powell | Montana | 30077 | 1865 | 28 |
2367736 | 2367736 | 2022-04-02 | Powell | Montana | 30077 | 1865 | 28 |
2364483 | 2364483 | 2022-04-01 | Powell | Montana | 30077 | 1865 | 28 |
2361229 | 2361229 | 2022-03-31 | Powell | Montana | 30077 | 1865 | 28 |
2357975 | 2357975 | 2022-03-30 | Powell | Montana | 30077 | 1865 | 28 |
2354722 | 2354722 | 2022-03-29 | Powell | Montana | 30077 | 1865 | 28 |
2351469 | 2351469 | 2022-03-28 | Powell | Montana | 30077 | 1865 | 28 |
2348217 | 2348217 | 2022-03-27 | Powell | Montana | 30077 | 1865 | 28 |
2344964 | 2344964 | 2022-03-26 | Powell | Montana | 30077 | 1865 | 28 |
2341711 | 2341711 | 2022-03-25 | Powell | Montana | 30077 | 1865 | 28 |
2338458 | 2338458 | 2022-03-24 | Powell | Montana | 30077 | 1865 | 28 |
2335204 | 2335204 | 2022-03-23 | Powell | Montana | 30077 | 1864 | 28 |
2331950 | 2331950 | 2022-03-22 | Powell | Montana | 30077 | 1864 | 28 |
2328697 | 2328697 | 2022-03-21 | Powell | Montana | 30077 | 1864 | 28 |
2325445 | 2325445 | 2022-03-20 | Powell | Montana | 30077 | 1864 | 28 |
2322191 | 2322191 | 2022-03-19 | Powell | Montana | 30077 | 1864 | 28 |
2318937 | 2318937 | 2022-03-18 | Powell | Montana | 30077 | 1864 | 28 |
2315684 | 2315684 | 2022-03-17 | Powell | Montana | 30077 | 1864 | 28 |
2312431 | 2312431 | 2022-03-16 | Powell | Montana | 30077 | 1864 | 28 |
2309178 | 2309178 | 2022-03-15 | Powell | Montana | 30077 | 1863 | 28 |
2305926 | 2305926 | 2022-03-14 | Powell | Montana | 30077 | 1863 | 28 |
2302675 | 2302675 | 2022-03-13 | Powell | Montana | 30077 | 1863 | 28 |
2299423 | 2299423 | 2022-03-12 | Powell | Montana | 30077 | 1863 | 28 |
2296171 | 2296171 | 2022-03-11 | Powell | Montana | 30077 | 1863 | 28 |
2292919 | 2292919 | 2022-03-10 | Powell | Montana | 30077 | 1864 | 28 |
2289667 | 2289667 | 2022-03-09 | Powell | Montana | 30077 | 1864 | 28 |
2286415 | 2286415 | 2022-03-08 | Powell | Montana | 30077 | 1864 | 28 |
2283163 | 2283163 | 2022-03-07 | Powell | Montana | 30077 | 1861 | 28 |
2279910 | 2279910 | 2022-03-06 | Powell | Montana | 30077 | 1860 | 28 |
2276657 | 2276657 | 2022-03-05 | Powell | Montana | 30077 | 1860 | 28 |
2273404 | 2273404 | 2022-03-04 | Powell | Montana | 30077 | 1860 | 28 |
2270152 | 2270152 | 2022-03-03 | Powell | Montana | 30077 | 1858 | 28 |
2266899 | 2266899 | 2022-03-02 | Powell | Montana | 30077 | 1857 | 28 |
2263648 | 2263648 | 2022-03-01 | Powell | Montana | 30077 | 1855 | 28 |
2260397 | 2260397 | 2022-02-28 | Powell | Montana | 30077 | 1854 | 28 |
2257146 | 2257146 | 2022-02-27 | Powell | Montana | 30077 | 1854 | 28 |
2253895 | 2253895 | 2022-02-26 | Powell | Montana | 30077 | 1854 | 28 |
2250644 | 2250644 | 2022-02-25 | Powell | Montana | 30077 | 1854 | 28 |
2247393 | 2247393 | 2022-02-24 | Powell | Montana | 30077 | 1854 | 28 |
2244142 | 2244142 | 2022-02-23 | Powell | Montana | 30077 | 1853 | 28 |
2240891 | 2240891 | 2022-02-22 | Powell | Montana | 30077 | 1849 | 28 |
2237640 | 2237640 | 2022-02-21 | Powell | Montana | 30077 | 1844 | 27 |
2234389 | 2234389 | 2022-02-20 | Powell | Montana | 30077 | 1844 | 27 |
2231138 | 2231138 | 2022-02-19 | Powell | Montana | 30077 | 1844 | 27 |
2227887 | 2227887 | 2022-02-18 | Powell | Montana | 30077 | 1844 | 27 |
2224636 | 2224636 | 2022-02-17 | Powell | Montana | 30077 | 1846 | 27 |
2221385 | 2221385 | 2022-02-16 | Powell | Montana | 30077 | 1838 | 27 |
2218134 | 2218134 | 2022-02-15 | Powell | Montana | 30077 | 1838 | 27 |
2214883 | 2214883 | 2022-02-14 | Powell | Montana | 30077 | 1837 | 27 |
2211631 | 2211631 | 2022-02-13 | Powell | Montana | 30077 | 1834 | 27 |
2208378 | 2208378 | 2022-02-12 | Powell | Montana | 30077 | 1834 | 27 |
2205125 | 2205125 | 2022-02-11 | Powell | Montana | 30077 | 1834 | 27 |
2201872 | 2201872 | 2022-02-10 | Powell | Montana | 30077 | 1830 | 27 |
2198618 | 2198618 | 2022-02-09 | Powell | Montana | 30077 | 1814 | 27 |
2195364 | 2195364 | 2022-02-08 | Powell | Montana | 30077 | 1792 | 27 |
2192110 | 2192110 | 2022-02-07 | Powell | Montana | 30077 | 1787 | 27 |
2188857 | 2188857 | 2022-02-06 | Powell | Montana | 30077 | 1771 | 27 |
2185604 | 2185604 | 2022-02-05 | Powell | Montana | 30077 | 1771 | 27 |
2182352 | 2182352 | 2022-02-04 | Powell | Montana | 30077 | 1771 | 27 |
2179100 | 2179100 | 2022-02-03 | Powell | Montana | 30077 | 1756 | 27 |
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);