ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Madison" and fips = 51113 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177199 | 2177199 | 2022-02-02 | Madison | Virginia | 51113 | 1918 | 28 |
2173946 | 2173946 | 2022-02-01 | Madison | Virginia | 51113 | 1904 | 28 |
2170694 | 2170694 | 2022-01-31 | Madison | Virginia | 51113 | 1890 | 28 |
2167441 | 2167441 | 2022-01-30 | Madison | Virginia | 51113 | 1866 | 27 |
2164186 | 2164186 | 2022-01-29 | Madison | Virginia | 51113 | 1866 | 27 |
2160931 | 2160931 | 2022-01-28 | Madison | Virginia | 51113 | 1866 | 27 |
2157675 | 2157675 | 2022-01-27 | Madison | Virginia | 51113 | 1841 | 27 |
2154422 | 2154422 | 2022-01-26 | Madison | Virginia | 51113 | 1824 | 27 |
2151169 | 2151169 | 2022-01-25 | Madison | Virginia | 51113 | 1811 | 26 |
2147917 | 2147917 | 2022-01-24 | Madison | Virginia | 51113 | 1792 | 26 |
2144664 | 2144664 | 2022-01-23 | Madison | Virginia | 51113 | 1747 | 25 |
2141409 | 2141409 | 2022-01-22 | Madison | Virginia | 51113 | 1747 | 25 |
2138153 | 2138153 | 2022-01-21 | Madison | Virginia | 51113 | 1747 | 25 |
2134899 | 2134899 | 2022-01-20 | Madison | Virginia | 51113 | 1716 | 25 |
2131647 | 2131647 | 2022-01-19 | Madison | Virginia | 51113 | 1701 | 25 |
2128393 | 2128393 | 2022-01-18 | Madison | Virginia | 51113 | 1675 | 25 |
2125140 | 2125140 | 2022-01-17 | Madison | Virginia | 51113 | 1661 | 25 |
2121888 | 2121888 | 2022-01-16 | Madison | Virginia | 51113 | 1604 | 25 |
2118636 | 2118636 | 2022-01-15 | Madison | Virginia | 51113 | 1604 | 25 |
2115384 | 2115384 | 2022-01-14 | Madison | Virginia | 51113 | 1604 | 25 |
2112132 | 2112132 | 2022-01-13 | Madison | Virginia | 51113 | 1579 | 25 |
2108880 | 2108880 | 2022-01-12 | Madison | Virginia | 51113 | 1563 | 25 |
2105629 | 2105629 | 2022-01-11 | Madison | Virginia | 51113 | 1539 | 25 |
2102378 | 2102378 | 2022-01-10 | Madison | Virginia | 51113 | 1514 | 25 |
2099127 | 2099127 | 2022-01-09 | Madison | Virginia | 51113 | 1455 | 25 |
2095876 | 2095876 | 2022-01-08 | Madison | Virginia | 51113 | 1455 | 25 |
2092624 | 2092624 | 2022-01-07 | Madison | Virginia | 51113 | 1455 | 25 |
2089372 | 2089372 | 2022-01-06 | Madison | Virginia | 51113 | 1435 | 25 |
2086121 | 2086121 | 2022-01-05 | Madison | Virginia | 51113 | 1425 | 25 |
2082869 | 2082869 | 2022-01-04 | Madison | Virginia | 51113 | 1421 | 25 |
2079617 | 2079617 | 2022-01-03 | Madison | Virginia | 51113 | 1414 | 25 |
2076365 | 2076365 | 2022-01-02 | Madison | Virginia | 51113 | 1355 | 25 |
2073114 | 2073114 | 2022-01-01 | Madison | Virginia | 51113 | 1355 | 25 |
2069863 | 2069863 | 2021-12-31 | Madison | Virginia | 51113 | 1355 | 25 |
2066612 | 2066612 | 2021-12-30 | Madison | Virginia | 51113 | 1333 | 25 |
2063362 | 2063362 | 2021-12-29 | Madison | Virginia | 51113 | 1316 | 25 |
2060112 | 2060112 | 2021-12-28 | Madison | Virginia | 51113 | 1290 | 25 |
2056863 | 2056863 | 2021-12-27 | Madison | Virginia | 51113 | 1278 | 25 |
2053614 | 2053614 | 2021-12-26 | Madison | Virginia | 51113 | 1262 | 25 |
2050364 | 2050364 | 2021-12-25 | Madison | Virginia | 51113 | 1262 | 25 |
2047114 | 2047114 | 2021-12-24 | Madison | Virginia | 51113 | 1262 | 25 |
2043864 | 2043864 | 2021-12-23 | Madison | Virginia | 51113 | 1253 | 24 |
2040615 | 2040615 | 2021-12-22 | Madison | Virginia | 51113 | 1249 | 24 |
2037365 | 2037365 | 2021-12-21 | Madison | Virginia | 51113 | 1241 | 24 |
2034115 | 2034115 | 2021-12-20 | Madison | Virginia | 51113 | 1232 | 24 |
2030865 | 2030865 | 2021-12-19 | Madison | Virginia | 51113 | 1205 | 23 |
2027614 | 2027614 | 2021-12-18 | Madison | Virginia | 51113 | 1205 | 23 |
2024363 | 2024363 | 2021-12-17 | Madison | Virginia | 51113 | 1205 | 23 |
2021112 | 2021112 | 2021-12-16 | Madison | Virginia | 51113 | 1200 | 23 |
2017861 | 2017861 | 2021-12-15 | Madison | Virginia | 51113 | 1194 | 23 |
2014611 | 2014611 | 2021-12-14 | Madison | Virginia | 51113 | 1183 | 23 |
2011360 | 2011360 | 2021-12-13 | Madison | Virginia | 51113 | 1178 | 23 |
2008109 | 2008109 | 2021-12-12 | Madison | Virginia | 51113 | 1153 | 23 |
2004858 | 2004858 | 2021-12-11 | Madison | Virginia | 51113 | 1153 | 23 |
2001607 | 2001607 | 2021-12-10 | Madison | Virginia | 51113 | 1153 | 23 |
1998357 | 1998357 | 2021-12-09 | Madison | Virginia | 51113 | 1146 | 23 |
1995106 | 1995106 | 2021-12-08 | Madison | Virginia | 51113 | 1139 | 23 |
1991855 | 1991855 | 2021-12-07 | Madison | Virginia | 51113 | 1130 | 23 |
1988604 | 1988604 | 2021-12-06 | Madison | Virginia | 51113 | 1125 | 23 |
1985354 | 1985354 | 2021-12-05 | Madison | Virginia | 51113 | 1113 | 23 |
1982104 | 1982104 | 2021-12-04 | Madison | Virginia | 51113 | 1113 | 23 |
1978854 | 1978854 | 2021-12-03 | Madison | Virginia | 51113 | 1113 | 23 |
1975604 | 1975604 | 2021-12-02 | Madison | Virginia | 51113 | 1107 | 23 |
1972355 | 1972355 | 2021-12-01 | Madison | Virginia | 51113 | 1105 | 23 |
1969105 | 1969105 | 2021-11-30 | Madison | Virginia | 51113 | 1104 | 23 |
1965855 | 1965855 | 2021-11-29 | Madison | Virginia | 51113 | 1096 | 23 |
1962603 | 1962603 | 2021-11-28 | Madison | Virginia | 51113 | 1089 | 23 |
1959352 | 1959352 | 2021-11-27 | Madison | Virginia | 51113 | 1089 | 23 |
1956101 | 1956101 | 2021-11-26 | Madison | Virginia | 51113 | 1089 | 23 |
1952850 | 1952850 | 2021-11-25 | Madison | Virginia | 51113 | 1085 | 23 |
1949599 | 1949599 | 2021-11-24 | Madison | Virginia | 51113 | 1083 | 23 |
1946348 | 1946348 | 2021-11-23 | Madison | Virginia | 51113 | 1079 | 23 |
1943097 | 1943097 | 2021-11-22 | Madison | Virginia | 51113 | 1074 | 23 |
1939847 | 1939847 | 2021-11-21 | Madison | Virginia | 51113 | 1066 | 23 |
1936597 | 1936597 | 2021-11-20 | Madison | Virginia | 51113 | 1066 | 23 |
1933347 | 1933347 | 2021-11-19 | Madison | Virginia | 51113 | 1066 | 23 |
1930095 | 1930095 | 2021-11-18 | Madison | Virginia | 51113 | 1061 | 23 |
1926845 | 1926845 | 2021-11-17 | Madison | Virginia | 51113 | 1051 | 23 |
1923595 | 1923595 | 2021-11-16 | Madison | Virginia | 51113 | 1045 | 23 |
1920346 | 1920346 | 2021-11-15 | Madison | Virginia | 51113 | 1043 | 23 |
1917096 | 1917096 | 2021-11-14 | Madison | Virginia | 51113 | 1030 | 23 |
1913846 | 1913846 | 2021-11-13 | Madison | Virginia | 51113 | 1030 | 23 |
1910596 | 1910596 | 2021-11-12 | Madison | Virginia | 51113 | 1030 | 23 |
1907347 | 1907347 | 2021-11-11 | Madison | Virginia | 51113 | 1026 | 23 |
1904098 | 1904098 | 2021-11-10 | Madison | Virginia | 51113 | 1026 | 22 |
1900848 | 1900848 | 2021-11-09 | Madison | Virginia | 51113 | 1022 | 22 |
1897598 | 1897598 | 2021-11-08 | Madison | Virginia | 51113 | 1020 | 21 |
1894348 | 1894348 | 2021-11-07 | Madison | Virginia | 51113 | 1010 | 21 |
1891098 | 1891098 | 2021-11-06 | Madison | Virginia | 51113 | 1010 | 21 |
1887848 | 1887848 | 2021-11-05 | Madison | Virginia | 51113 | 1010 | 21 |
1884598 | 1884598 | 2021-11-04 | Madison | Virginia | 51113 | 1004 | 21 |
1881349 | 1881349 | 2021-11-03 | Madison | Virginia | 51113 | 1003 | 21 |
1878100 | 1878100 | 2021-11-02 | Madison | Virginia | 51113 | 1000 | 21 |
1874851 | 1874851 | 2021-11-01 | Madison | Virginia | 51113 | 996 | 21 |
1871602 | 1871602 | 2021-10-31 | Madison | Virginia | 51113 | 990 | 21 |
1868353 | 1868353 | 2021-10-30 | Madison | Virginia | 51113 | 990 | 21 |
1865104 | 1865104 | 2021-10-29 | Madison | Virginia | 51113 | 990 | 21 |
1861855 | 1861855 | 2021-10-28 | Madison | Virginia | 51113 | 989 | 21 |
1858606 | 1858606 | 2021-10-27 | Madison | Virginia | 51113 | 987 | 21 |
1855357 | 1855357 | 2021-10-26 | Madison | Virginia | 51113 | 988 | 21 |
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);