ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 30007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175813 | 2175813 | 2022-02-02 | Broadwater | Montana | 30007 | 1144 | 18 |
2172560 | 2172560 | 2022-02-01 | Broadwater | Montana | 30007 | 1143 | 18 |
2169307 | 2169307 | 2022-01-31 | Broadwater | Montana | 30007 | 1140 | 18 |
2166052 | 2166052 | 2022-01-30 | Broadwater | Montana | 30007 | 1136 | 18 |
2162797 | 2162797 | 2022-01-29 | Broadwater | Montana | 30007 | 1136 | 18 |
2159542 | 2159542 | 2022-01-28 | Broadwater | Montana | 30007 | 1136 | 18 |
2156288 | 2156288 | 2022-01-27 | Broadwater | Montana | 30007 | 1133 | 18 |
2153035 | 2153035 | 2022-01-26 | Broadwater | Montana | 30007 | 1125 | 18 |
2149783 | 2149783 | 2022-01-25 | Broadwater | Montana | 30007 | 1115 | 18 |
2146531 | 2146531 | 2022-01-24 | Broadwater | Montana | 30007 | 1104 | 18 |
2143276 | 2143276 | 2022-01-23 | Broadwater | Montana | 30007 | 1092 | 18 |
2140021 | 2140021 | 2022-01-22 | Broadwater | Montana | 30007 | 1092 | 18 |
2136765 | 2136765 | 2022-01-21 | Broadwater | Montana | 30007 | 1092 | 18 |
2133513 | 2133513 | 2022-01-20 | Broadwater | Montana | 30007 | 1086 | 18 |
2130260 | 2130260 | 2022-01-19 | Broadwater | Montana | 30007 | 1070 | 18 |
2127006 | 2127006 | 2022-01-18 | Broadwater | Montana | 30007 | 1060 | 18 |
2123754 | 2123754 | 2022-01-17 | Broadwater | Montana | 30007 | 1053 | 17 |
2120502 | 2120502 | 2022-01-16 | Broadwater | Montana | 30007 | 1053 | 17 |
2117250 | 2117250 | 2022-01-15 | Broadwater | Montana | 30007 | 1053 | 17 |
2113999 | 2113999 | 2022-01-14 | Broadwater | Montana | 30007 | 1053 | 17 |
2110747 | 2110747 | 2022-01-13 | Broadwater | Montana | 30007 | 1047 | 17 |
2107496 | 2107496 | 2022-01-12 | Broadwater | Montana | 30007 | 1044 | 17 |
2104245 | 2104245 | 2022-01-11 | Broadwater | Montana | 30007 | 1037 | 17 |
2100994 | 2100994 | 2022-01-10 | Broadwater | Montana | 30007 | 1034 | 17 |
2097743 | 2097743 | 2022-01-09 | Broadwater | Montana | 30007 | 1029 | 17 |
2094491 | 2094491 | 2022-01-08 | Broadwater | Montana | 30007 | 1029 | 17 |
2091239 | 2091239 | 2022-01-07 | Broadwater | Montana | 30007 | 1029 | 17 |
2087988 | 2087988 | 2022-01-06 | Broadwater | Montana | 30007 | 1027 | 17 |
2084736 | 2084736 | 2022-01-05 | Broadwater | Montana | 30007 | 1026 | 17 |
2081484 | 2081484 | 2022-01-04 | Broadwater | Montana | 30007 | 1022 | 17 |
2078232 | 2078232 | 2022-01-03 | Broadwater | Montana | 30007 | 1017 | 17 |
2074981 | 2074981 | 2022-01-02 | Broadwater | Montana | 30007 | 1014 | 17 |
2071730 | 2071730 | 2022-01-01 | Broadwater | Montana | 30007 | 1014 | 17 |
2068479 | 2068479 | 2021-12-31 | Broadwater | Montana | 30007 | 1014 | 17 |
2065228 | 2065228 | 2021-12-30 | Broadwater | Montana | 30007 | 1014 | 17 |
2061978 | 2061978 | 2021-12-29 | Broadwater | Montana | 30007 | 1013 | 17 |
2058729 | 2058729 | 2021-12-28 | Broadwater | Montana | 30007 | 1012 | 17 |
2055480 | 2055480 | 2021-12-27 | Broadwater | Montana | 30007 | 1012 | 17 |
2052230 | 2052230 | 2021-12-26 | Broadwater | Montana | 30007 | 1009 | 17 |
2048980 | 2048980 | 2021-12-25 | Broadwater | Montana | 30007 | 1009 | 17 |
2045730 | 2045730 | 2021-12-24 | Broadwater | Montana | 30007 | 1009 | 17 |
2042480 | 2042480 | 2021-12-23 | Broadwater | Montana | 30007 | 1009 | 17 |
2039231 | 2039231 | 2021-12-22 | Broadwater | Montana | 30007 | 1005 | 17 |
2035981 | 2035981 | 2021-12-21 | Broadwater | Montana | 30007 | 1005 | 17 |
2032731 | 2032731 | 2021-12-20 | Broadwater | Montana | 30007 | 1004 | 17 |
2029480 | 2029480 | 2021-12-19 | Broadwater | Montana | 30007 | 1002 | 17 |
2026229 | 2026229 | 2021-12-18 | Broadwater | Montana | 30007 | 1002 | 17 |
2022978 | 2022978 | 2021-12-17 | Broadwater | Montana | 30007 | 1002 | 17 |
2019727 | 2019727 | 2021-12-16 | Broadwater | Montana | 30007 | 998 | 17 |
2016477 | 2016477 | 2021-12-15 | Broadwater | Montana | 30007 | 995 | 17 |
2013226 | 2013226 | 2021-12-14 | Broadwater | Montana | 30007 | 993 | 17 |
2009975 | 2009975 | 2021-12-13 | Broadwater | Montana | 30007 | 993 | 17 |
2006724 | 2006724 | 2021-12-12 | Broadwater | Montana | 30007 | 992 | 17 |
2003473 | 2003473 | 2021-12-11 | Broadwater | Montana | 30007 | 992 | 17 |
2000223 | 2000223 | 2021-12-10 | Broadwater | Montana | 30007 | 992 | 17 |
1996972 | 1996972 | 2021-12-09 | Broadwater | Montana | 30007 | 991 | 17 |
1993721 | 1993721 | 2021-12-08 | Broadwater | Montana | 30007 | 987 | 17 |
1990470 | 1990470 | 2021-12-07 | Broadwater | Montana | 30007 | 983 | 17 |
1987220 | 1987220 | 2021-12-06 | Broadwater | Montana | 30007 | 979 | 17 |
1983970 | 1983970 | 2021-12-05 | Broadwater | Montana | 30007 | 976 | 17 |
1980720 | 1980720 | 2021-12-04 | Broadwater | Montana | 30007 | 976 | 17 |
1977470 | 1977470 | 2021-12-03 | Broadwater | Montana | 30007 | 976 | 17 |
1974220 | 1974220 | 2021-12-02 | Broadwater | Montana | 30007 | 974 | 17 |
1970971 | 1970971 | 2021-12-01 | Broadwater | Montana | 30007 | 969 | 17 |
1967721 | 1967721 | 2021-11-30 | Broadwater | Montana | 30007 | 961 | 17 |
1964469 | 1964469 | 2021-11-29 | Broadwater | Montana | 30007 | 957 | 17 |
1961218 | 1961218 | 2021-11-28 | Broadwater | Montana | 30007 | 953 | 17 |
1957967 | 1957967 | 2021-11-27 | Broadwater | Montana | 30007 | 953 | 17 |
1954716 | 1954716 | 2021-11-26 | Broadwater | Montana | 30007 | 953 | 17 |
1951465 | 1951465 | 2021-11-25 | Broadwater | Montana | 30007 | 940 | 17 |
1948214 | 1948214 | 2021-11-24 | Broadwater | Montana | 30007 | 940 | 17 |
1944963 | 1944963 | 2021-11-23 | Broadwater | Montana | 30007 | 929 | 17 |
1941712 | 1941712 | 2021-11-22 | Broadwater | Montana | 30007 | 923 | 17 |
1938462 | 1938462 | 2021-11-21 | Broadwater | Montana | 30007 | 915 | 17 |
1935212 | 1935212 | 2021-11-20 | Broadwater | Montana | 30007 | 915 | 17 |
1931962 | 1931962 | 2021-11-19 | Broadwater | Montana | 30007 | 915 | 17 |
1928711 | 1928711 | 2021-11-18 | Broadwater | Montana | 30007 | 911 | 17 |
1925461 | 1925461 | 2021-11-17 | Broadwater | Montana | 30007 | 909 | 17 |
1922212 | 1922212 | 2021-11-16 | Broadwater | Montana | 30007 | 906 | 17 |
1918962 | 1918962 | 2021-11-15 | Broadwater | Montana | 30007 | 901 | 17 |
1915712 | 1915712 | 2021-11-14 | Broadwater | Montana | 30007 | 893 | 17 |
1912462 | 1912462 | 2021-11-13 | Broadwater | Montana | 30007 | 893 | 17 |
1909212 | 1909212 | 2021-11-12 | Broadwater | Montana | 30007 | 893 | 17 |
1905963 | 1905963 | 2021-11-11 | Broadwater | Montana | 30007 | 886 | 17 |
1902714 | 1902714 | 2021-11-10 | Broadwater | Montana | 30007 | 886 | 17 |
1899464 | 1899464 | 2021-11-09 | Broadwater | Montana | 30007 | 882 | 17 |
1896214 | 1896214 | 2021-11-08 | Broadwater | Montana | 30007 | 874 | 17 |
1892964 | 1892964 | 2021-11-07 | Broadwater | Montana | 30007 | 871 | 17 |
1889714 | 1889714 | 2021-11-06 | Broadwater | Montana | 30007 | 871 | 17 |
1886464 | 1886464 | 2021-11-05 | Broadwater | Montana | 30007 | 871 | 17 |
1883215 | 1883215 | 2021-11-04 | Broadwater | Montana | 30007 | 868 | 17 |
1879966 | 1879966 | 2021-11-03 | Broadwater | Montana | 30007 | 860 | 17 |
1876717 | 1876717 | 2021-11-02 | Broadwater | Montana | 30007 | 858 | 17 |
1873468 | 1873468 | 2021-11-01 | Broadwater | Montana | 30007 | 842 | 17 |
1870219 | 1870219 | 2021-10-31 | Broadwater | Montana | 30007 | 839 | 17 |
1866970 | 1866970 | 2021-10-30 | Broadwater | Montana | 30007 | 839 | 17 |
1863721 | 1863721 | 2021-10-29 | Broadwater | Montana | 30007 | 839 | 17 |
1860472 | 1860472 | 2021-10-28 | Broadwater | Montana | 30007 | 836 | 17 |
1857223 | 1857223 | 2021-10-27 | Broadwater | Montana | 30007 | 829 | 17 |
1853974 | 1853974 | 2021-10-26 | Broadwater | Montana | 30007 | 826 | 17 |
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);