ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Madison" and fips = 48313 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176976 | 2176976 | 2022-02-02 | Madison | Texas | 48313 | 3572 | 49 |
2173722 | 2173722 | 2022-02-01 | Madison | Texas | 48313 | 3559 | 49 |
2170470 | 2170470 | 2022-01-31 | Madison | Texas | 48313 | 3549 | 49 |
2167216 | 2167216 | 2022-01-30 | Madison | Texas | 48313 | 3543 | 49 |
2163961 | 2163961 | 2022-01-29 | Madison | Texas | 48313 | 3542 | 49 |
2160706 | 2160706 | 2022-01-28 | Madison | Texas | 48313 | 3524 | 49 |
2157450 | 2157450 | 2022-01-27 | Madison | Texas | 48313 | 3490 | 49 |
2154197 | 2154197 | 2022-01-26 | Madison | Texas | 48313 | 3467 | 49 |
2150945 | 2150945 | 2022-01-25 | Madison | Texas | 48313 | 3454 | 49 |
2147693 | 2147693 | 2022-01-24 | Madison | Texas | 48313 | 3448 | 49 |
2144439 | 2144439 | 2022-01-23 | Madison | Texas | 48313 | 3441 | 49 |
2141184 | 2141184 | 2022-01-22 | Madison | Texas | 48313 | 3424 | 49 |
2137928 | 2137928 | 2022-01-21 | Madison | Texas | 48313 | 3400 | 49 |
2134674 | 2134674 | 2022-01-20 | Madison | Texas | 48313 | 3386 | 49 |
2131422 | 2131422 | 2022-01-19 | Madison | Texas | 48313 | 3360 | 49 |
2128168 | 2128168 | 2022-01-18 | Madison | Texas | 48313 | 3351 | 48 |
2124916 | 2124916 | 2022-01-17 | Madison | Texas | 48313 | 3345 | 48 |
2121664 | 2121664 | 2022-01-16 | Madison | Texas | 48313 | 3333 | 48 |
2118412 | 2118412 | 2022-01-15 | Madison | Texas | 48313 | 3327 | 48 |
2115161 | 2115161 | 2022-01-14 | Madison | Texas | 48313 | 3302 | 47 |
2111909 | 2111909 | 2022-01-13 | Madison | Texas | 48313 | 3009 | 47 |
2108657 | 2108657 | 2022-01-12 | Madison | Texas | 48313 | 2976 | 47 |
2105406 | 2105406 | 2022-01-11 | Madison | Texas | 48313 | 2828 | 47 |
2102155 | 2102155 | 2022-01-10 | Madison | Texas | 48313 | 2806 | 46 |
2098904 | 2098904 | 2022-01-09 | Madison | Texas | 48313 | 2800 | 46 |
2095652 | 2095652 | 2022-01-08 | Madison | Texas | 48313 | 2791 | 46 |
2092400 | 2092400 | 2022-01-07 | Madison | Texas | 48313 | 2768 | 46 |
2089148 | 2089148 | 2022-01-06 | Madison | Texas | 48313 | 2748 | 46 |
2085897 | 2085897 | 2022-01-05 | Madison | Texas | 48313 | 2720 | 46 |
2082645 | 2082645 | 2022-01-04 | Madison | Texas | 48313 | 2687 | 46 |
2079393 | 2079393 | 2022-01-03 | Madison | Texas | 48313 | 2674 | 46 |
2076142 | 2076142 | 2022-01-02 | Madison | Texas | 48313 | 2613 | 46 |
2072891 | 2072891 | 2022-01-01 | Madison | Texas | 48313 | 2613 | 46 |
2069640 | 2069640 | 2021-12-31 | Madison | Texas | 48313 | 2613 | 46 |
2066389 | 2066389 | 2021-12-30 | Madison | Texas | 48313 | 2613 | 46 |
2063139 | 2063139 | 2021-12-29 | Madison | Texas | 48313 | 2602 | 46 |
2059889 | 2059889 | 2021-12-28 | Madison | Texas | 48313 | 2600 | 46 |
2056640 | 2056640 | 2021-12-27 | Madison | Texas | 48313 | 2577 | 46 |
2053391 | 2053391 | 2021-12-26 | Madison | Texas | 48313 | 2568 | 46 |
2050141 | 2050141 | 2021-12-25 | Madison | Texas | 48313 | 2568 | 46 |
2046891 | 2046891 | 2021-12-24 | Madison | Texas | 48313 | 2568 | 46 |
2043641 | 2043641 | 2021-12-23 | Madison | Texas | 48313 | 2568 | 46 |
2040392 | 2040392 | 2021-12-22 | Madison | Texas | 48313 | 2561 | 46 |
2037142 | 2037142 | 2021-12-21 | Madison | Texas | 48313 | 2559 | 46 |
2033892 | 2033892 | 2021-12-20 | Madison | Texas | 48313 | 2555 | 46 |
2030642 | 2030642 | 2021-12-19 | Madison | Texas | 48313 | 2553 | 46 |
2027391 | 2027391 | 2021-12-18 | Madison | Texas | 48313 | 2551 | 46 |
2024140 | 2024140 | 2021-12-17 | Madison | Texas | 48313 | 2545 | 46 |
2020889 | 2020889 | 2021-12-16 | Madison | Texas | 48313 | 2543 | 46 |
2017638 | 2017638 | 2021-12-15 | Madison | Texas | 48313 | 2542 | 46 |
2014388 | 2014388 | 2021-12-14 | Madison | Texas | 48313 | 2539 | 46 |
2011137 | 2011137 | 2021-12-13 | Madison | Texas | 48313 | 2538 | 46 |
2007886 | 2007886 | 2021-12-12 | Madison | Texas | 48313 | 2538 | 46 |
2004635 | 2004635 | 2021-12-11 | Madison | Texas | 48313 | 2537 | 46 |
2001384 | 2001384 | 2021-12-10 | Madison | Texas | 48313 | 2533 | 46 |
1998134 | 1998134 | 2021-12-09 | Madison | Texas | 48313 | 2530 | 46 |
1994883 | 1994883 | 2021-12-08 | Madison | Texas | 48313 | 2529 | 45 |
1991632 | 1991632 | 2021-12-07 | Madison | Texas | 48313 | 2528 | 45 |
1988381 | 1988381 | 2021-12-06 | Madison | Texas | 48313 | 2525 | 45 |
1985131 | 1985131 | 2021-12-05 | Madison | Texas | 48313 | 2525 | 45 |
1981881 | 1981881 | 2021-12-04 | Madison | Texas | 48313 | 2525 | 45 |
1978631 | 1978631 | 2021-12-03 | Madison | Texas | 48313 | 2525 | 45 |
1975381 | 1975381 | 2021-12-02 | Madison | Texas | 48313 | 2520 | 45 |
1972132 | 1972132 | 2021-12-01 | Madison | Texas | 48313 | 2519 | 45 |
1968882 | 1968882 | 2021-11-30 | Madison | Texas | 48313 | 2518 | 45 |
1965631 | 1965631 | 2021-11-29 | Madison | Texas | 48313 | 2517 | 45 |
1962379 | 1962379 | 2021-11-28 | Madison | Texas | 48313 | 2514 | 45 |
1959128 | 1959128 | 2021-11-27 | Madison | Texas | 48313 | 2514 | 45 |
1955877 | 1955877 | 2021-11-26 | Madison | Texas | 48313 | 2514 | 45 |
1952626 | 1952626 | 2021-11-25 | Madison | Texas | 48313 | 2514 | 45 |
1949375 | 1949375 | 2021-11-24 | Madison | Texas | 48313 | 2514 | 45 |
1946124 | 1946124 | 2021-11-23 | Madison | Texas | 48313 | 2510 | 45 |
1942873 | 1942873 | 2021-11-22 | Madison | Texas | 48313 | 2509 | 45 |
1939623 | 1939623 | 2021-11-21 | Madison | Texas | 48313 | 2507 | 45 |
1936373 | 1936373 | 2021-11-20 | Madison | Texas | 48313 | 2507 | 45 |
1933123 | 1933123 | 2021-11-19 | Madison | Texas | 48313 | 2502 | 45 |
1929872 | 1929872 | 2021-11-18 | Madison | Texas | 48313 | 2502 | 45 |
1926622 | 1926622 | 2021-11-17 | Madison | Texas | 48313 | 2507 | 45 |
1923372 | 1923372 | 2021-11-16 | Madison | Texas | 48313 | 2508 | 45 |
1920123 | 1920123 | 2021-11-15 | Madison | Texas | 48313 | 2499 | 44 |
1916873 | 1916873 | 2021-11-14 | Madison | Texas | 48313 | 2499 | 44 |
1913623 | 1913623 | 2021-11-13 | Madison | Texas | 48313 | 2491 | 44 |
1910373 | 1910373 | 2021-11-12 | Madison | Texas | 48313 | 2491 | 44 |
1907124 | 1907124 | 2021-11-11 | Madison | Texas | 48313 | 2491 | 44 |
1903875 | 1903875 | 2021-11-10 | Madison | Texas | 48313 | 2490 | 44 |
1900625 | 1900625 | 2021-11-09 | Madison | Texas | 48313 | 2490 | 44 |
1897375 | 1897375 | 2021-11-08 | Madison | Texas | 48313 | 2493 | 44 |
1894125 | 1894125 | 2021-11-07 | Madison | Texas | 48313 | 2492 | 44 |
1890875 | 1890875 | 2021-11-06 | Madison | Texas | 48313 | 2492 | 44 |
1887625 | 1887625 | 2021-11-05 | Madison | Texas | 48313 | 2491 | 43 |
1884375 | 1884375 | 2021-11-04 | Madison | Texas | 48313 | 2491 | 43 |
1881126 | 1881126 | 2021-11-03 | Madison | Texas | 48313 | 2490 | 43 |
1877877 | 1877877 | 2021-11-02 | Madison | Texas | 48313 | 2488 | 43 |
1874628 | 1874628 | 2021-11-01 | Madison | Texas | 48313 | 2486 | 43 |
1871379 | 1871379 | 2021-10-31 | Madison | Texas | 48313 | 2483 | 43 |
1868130 | 1868130 | 2021-10-30 | Madison | Texas | 48313 | 2483 | 43 |
1864881 | 1864881 | 2021-10-29 | Madison | Texas | 48313 | 2482 | 43 |
1861632 | 1861632 | 2021-10-28 | Madison | Texas | 48313 | 2477 | 43 |
1858383 | 1858383 | 2021-10-27 | Madison | Texas | 48313 | 2477 | 43 |
1855134 | 1855134 | 2021-10-26 | Madison | Texas | 48313 | 2477 | 43 |
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);