ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Madison" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- …
state 1
- Florida · 673 ✖
fips 1
- 12079 673
county 1
- Madison · 673 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174556 | 2174556 | 2022-02-02 | Madison | Florida | 12079 | 5315 | 69 |
2171303 | 2171303 | 2022-02-01 | Madison | Florida | 12079 | 5315 | 69 |
2168050 | 2168050 | 2022-01-31 | Madison | Florida | 12079 | 5315 | 69 |
2164795 | 2164795 | 2022-01-30 | Madison | Florida | 12079 | 5315 | 69 |
2161540 | 2161540 | 2022-01-29 | Madison | Florida | 12079 | 5315 | 69 |
2158284 | 2158284 | 2022-01-28 | Madison | Florida | 12079 | 5315 | 69 |
2155031 | 2155031 | 2022-01-27 | Madison | Florida | 12079 | 4855 | 69 |
2151778 | 2151778 | 2022-01-26 | Madison | Florida | 12079 | 4855 | 69 |
2148526 | 2148526 | 2022-01-25 | Madison | Florida | 12079 | 4855 | 69 |
2145274 | 2145274 | 2022-01-24 | Madison | Florida | 12079 | 4855 | 69 |
2142019 | 2142019 | 2022-01-23 | Madison | Florida | 12079 | 4855 | 69 |
2138764 | 2138764 | 2022-01-22 | Madison | Florida | 12079 | 4855 | 69 |
2135508 | 2135508 | 2022-01-21 | Madison | Florida | 12079 | 4855 | 69 |
2132256 | 2132256 | 2022-01-20 | Madison | Florida | 12079 | 4442 | 69 |
2129003 | 2129003 | 2022-01-19 | Madison | Florida | 12079 | 4442 | 69 |
2125749 | 2125749 | 2022-01-18 | Madison | Florida | 12079 | 4442 | 69 |
2122497 | 2122497 | 2022-01-17 | Madison | Florida | 12079 | 4442 | 69 |
2119245 | 2119245 | 2022-01-16 | Madison | Florida | 12079 | 4442 | 69 |
2115993 | 2115993 | 2022-01-15 | Madison | Florida | 12079 | 4442 | 69 |
2112742 | 2112742 | 2022-01-14 | Madison | Florida | 12079 | 4442 | 69 |
2109490 | 2109490 | 2022-01-13 | Madison | Florida | 12079 | 4015 | 69 |
2106239 | 2106239 | 2022-01-12 | Madison | Florida | 12079 | 4015 | 69 |
2102988 | 2102988 | 2022-01-11 | Madison | Florida | 12079 | 4015 | 69 |
2099737 | 2099737 | 2022-01-10 | Madison | Florida | 12079 | 4015 | 69 |
2096486 | 2096486 | 2022-01-09 | Madison | Florida | 12079 | 4015 | 69 |
2093234 | 2093234 | 2022-01-08 | Madison | Florida | 12079 | 4015 | 69 |
2089982 | 2089982 | 2022-01-07 | Madison | Florida | 12079 | 4015 | 69 |
2086731 | 2086731 | 2022-01-06 | Madison | Florida | 12079 | 3803 | 69 |
2083479 | 2083479 | 2022-01-05 | Madison | Florida | 12079 | 3803 | 69 |
2080227 | 2080227 | 2022-01-04 | Madison | Florida | 12079 | 3803 | 68 |
2076975 | 2076975 | 2022-01-03 | Madison | Florida | 12079 | 3803 | 68 |
2073724 | 2073724 | 2022-01-02 | Madison | Florida | 12079 | 3803 | 68 |
2070473 | 2070473 | 2022-01-01 | Madison | Florida | 12079 | 3803 | 68 |
2067222 | 2067222 | 2021-12-31 | Madison | Florida | 12079 | 3803 | 68 |
2063971 | 2063971 | 2021-12-30 | Madison | Florida | 12079 | 3685 | 68 |
2060721 | 2060721 | 2021-12-29 | Madison | Florida | 12079 | 3685 | 68 |
2057472 | 2057472 | 2021-12-28 | Madison | Florida | 12079 | 3685 | 60 |
2054223 | 2054223 | 2021-12-27 | Madison | Florida | 12079 | 3685 | 60 |
2050973 | 2050973 | 2021-12-26 | Madison | Florida | 12079 | 3685 | 60 |
2047723 | 2047723 | 2021-12-25 | Madison | Florida | 12079 | 3685 | 60 |
2044473 | 2044473 | 2021-12-24 | Madison | Florida | 12079 | 3685 | 60 |
2041224 | 2041224 | 2021-12-23 | Madison | Florida | 12079 | 3670 | 60 |
2037974 | 2037974 | 2021-12-22 | Madison | Florida | 12079 | 3670 | 60 |
2034724 | 2034724 | 2021-12-21 | Madison | Florida | 12079 | 3670 | 60 |
2031474 | 2031474 | 2021-12-20 | Madison | Florida | 12079 | 3670 | 60 |
2028223 | 2028223 | 2021-12-19 | Madison | Florida | 12079 | 3670 | 60 |
2024972 | 2024972 | 2021-12-18 | Madison | Florida | 12079 | 3670 | 60 |
2021721 | 2021721 | 2021-12-17 | Madison | Florida | 12079 | 3670 | 60 |
2018470 | 2018470 | 2021-12-16 | Madison | Florida | 12079 | 3662 | 60 |
2015220 | 2015220 | 2021-12-15 | Madison | Florida | 12079 | 3662 | 60 |
2011969 | 2011969 | 2021-12-14 | Madison | Florida | 12079 | 3662 | 60 |
2008718 | 2008718 | 2021-12-13 | Madison | Florida | 12079 | 3662 | 60 |
2005467 | 2005467 | 2021-12-12 | Madison | Florida | 12079 | 3662 | 60 |
2002216 | 2002216 | 2021-12-11 | Madison | Florida | 12079 | 3662 | 60 |
1998966 | 1998966 | 2021-12-10 | Madison | Florida | 12079 | 3662 | 60 |
1995715 | 1995715 | 2021-12-09 | Madison | Florida | 12079 | 3654 | 60 |
1992464 | 1992464 | 2021-12-08 | Madison | Florida | 12079 | 3654 | 60 |
1989213 | 1989213 | 2021-12-07 | Madison | Florida | 12079 | 3654 | 59 |
1985963 | 1985963 | 2021-12-06 | Madison | Florida | 12079 | 3654 | 59 |
1982713 | 1982713 | 2021-12-05 | Madison | Florida | 12079 | 3654 | 59 |
1979463 | 1979463 | 2021-12-04 | Madison | Florida | 12079 | 3654 | 59 |
1976213 | 1976213 | 2021-12-03 | Madison | Florida | 12079 | 3654 | 59 |
1972964 | 1972964 | 2021-12-02 | Madison | Florida | 12079 | 3644 | 59 |
1969714 | 1969714 | 2021-12-01 | Madison | Florida | 12079 | 3644 | 59 |
1966464 | 1966464 | 2021-11-30 | Madison | Florida | 12079 | 3644 | 59 |
1963212 | 1963212 | 2021-11-29 | Madison | Florida | 12079 | 3633 | 59 |
1959961 | 1959961 | 2021-11-28 | Madison | Florida | 12079 | 3633 | 59 |
1956710 | 1956710 | 2021-11-27 | Madison | Florida | 12079 | 3633 | 59 |
1953459 | 1953459 | 2021-11-26 | Madison | Florida | 12079 | 3633 | 59 |
1950208 | 1950208 | 2021-11-25 | Madison | Florida | 12079 | 3633 | 59 |
1946957 | 1946957 | 2021-11-24 | Madison | Florida | 12079 | 3633 | 59 |
1943706 | 1943706 | 2021-11-23 | Madison | Florida | 12079 | 3633 | 59 |
1940456 | 1940456 | 2021-11-22 | Madison | Florida | 12079 | 3633 | 59 |
1937206 | 1937206 | 2021-11-21 | Madison | Florida | 12079 | 3633 | 59 |
1933956 | 1933956 | 2021-11-20 | Madison | Florida | 12079 | 3633 | 59 |
1930704 | 1930704 | 2021-11-19 | Madison | Florida | 12079 | 3633 | 59 |
1927454 | 1927454 | 2021-11-18 | Madison | Florida | 12079 | 3603 | 59 |
1924204 | 1924204 | 2021-11-17 | Madison | Florida | 12079 | 3603 | 59 |
1920955 | 1920955 | 2021-11-16 | Madison | Florida | 12079 | 3603 | 59 |
1917705 | 1917705 | 2021-11-15 | Madison | Florida | 12079 | 3603 | 59 |
1914455 | 1914455 | 2021-11-14 | Madison | Florida | 12079 | 3603 | 58 |
1911205 | 1911205 | 2021-11-13 | Madison | Florida | 12079 | 3603 | 58 |
1907956 | 1907956 | 2021-11-12 | Madison | Florida | 12079 | 3603 | 58 |
1904707 | 1904707 | 2021-11-11 | Madison | Florida | 12079 | 3588 | 58 |
1901457 | 1901457 | 2021-11-10 | Madison | Florida | 12079 | 3588 | 58 |
1898207 | 1898207 | 2021-11-09 | Madison | Florida | 12079 | 3588 | 58 |
1894957 | 1894957 | 2021-11-08 | Madison | Florida | 12079 | 3588 | 58 |
1891707 | 1891707 | 2021-11-07 | Madison | Florida | 12079 | 3588 | 54 |
1888457 | 1888457 | 2021-11-06 | Madison | Florida | 12079 | 3588 | 54 |
1885207 | 1885207 | 2021-11-05 | Madison | Florida | 12079 | 3588 | 54 |
1881958 | 1881958 | 2021-11-04 | Madison | Florida | 12079 | 3583 | 54 |
1878709 | 1878709 | 2021-11-03 | Madison | Florida | 12079 | 3583 | 54 |
1875460 | 1875460 | 2021-11-02 | Madison | Florida | 12079 | 3583 | 54 |
1872211 | 1872211 | 2021-11-01 | Madison | Florida | 12079 | 3583 | 54 |
1868962 | 1868962 | 2021-10-31 | Madison | Florida | 12079 | 3583 | 54 |
1865713 | 1865713 | 2021-10-30 | Madison | Florida | 12079 | 3583 | 54 |
1862464 | 1862464 | 2021-10-29 | Madison | Florida | 12079 | 3583 | 54 |
1859215 | 1859215 | 2021-10-28 | Madison | Florida | 12079 | 3584 | 54 |
1855966 | 1855966 | 2021-10-27 | Madison | Florida | 12079 | 3584 | 54 |
1852717 | 1852717 | 2021-10-26 | Madison | Florida | 12079 | 3584 | 54 |
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);