ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18043 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109855 | 2109855 | 2022-01-13 | Floyd | Indiana | 18043 | 14815 | 260 |
2106604 | 2106604 | 2022-01-12 | Floyd | Indiana | 18043 | 14607 | 259 |
2103353 | 2103353 | 2022-01-11 | Floyd | Indiana | 18043 | 14456 | 258 |
2100102 | 2100102 | 2022-01-10 | Floyd | Indiana | 18043 | 14382 | 253 |
2096851 | 2096851 | 2022-01-09 | Floyd | Indiana | 18043 | 13952 | 252 |
2093599 | 2093599 | 2022-01-08 | Floyd | Indiana | 18043 | 13952 | 252 |
2090347 | 2090347 | 2022-01-07 | Floyd | Indiana | 18043 | 13952 | 252 |
2087096 | 2087096 | 2022-01-06 | Floyd | Indiana | 18043 | 13790 | 252 |
2083844 | 2083844 | 2022-01-05 | Floyd | Indiana | 18043 | 13599 | 250 |
2080592 | 2080592 | 2022-01-04 | Floyd | Indiana | 18043 | 13456 | 250 |
2077340 | 2077340 | 2022-01-03 | Floyd | Indiana | 18043 | 13405 | 250 |
2074089 | 2074089 | 2022-01-02 | Floyd | Indiana | 18043 | 13116 | 249 |
2070838 | 2070838 | 2022-01-01 | Floyd | Indiana | 18043 | 13116 | 249 |
2067587 | 2067587 | 2021-12-31 | Floyd | Indiana | 18043 | 13116 | 249 |
2064336 | 2064336 | 2021-12-30 | Floyd | Indiana | 18043 | 13116 | 249 |
2061086 | 2061086 | 2021-12-29 | Floyd | Indiana | 18043 | 12982 | 247 |
2057837 | 2057837 | 2021-12-28 | Floyd | Indiana | 18043 | 12883 | 245 |
2054588 | 2054588 | 2021-12-27 | Floyd | Indiana | 18043 | 12821 | 245 |
2051338 | 2051338 | 2021-12-26 | Floyd | Indiana | 18043 | 12678 | 244 |
2048088 | 2048088 | 2021-12-25 | Floyd | Indiana | 18043 | 12678 | 244 |
2044838 | 2044838 | 2021-12-24 | Floyd | Indiana | 18043 | 12678 | 244 |
2041589 | 2041589 | 2021-12-23 | Floyd | Indiana | 18043 | 12678 | 244 |
2038339 | 2038339 | 2021-12-22 | Floyd | Indiana | 18043 | 12678 | 244 |
2035089 | 2035089 | 2021-12-21 | Floyd | Indiana | 18043 | 12627 | 244 |
2031839 | 2031839 | 2021-12-20 | Floyd | Indiana | 18043 | 12606 | 243 |
2028588 | 2028588 | 2021-12-19 | Floyd | Indiana | 18043 | 12525 | 243 |
2025337 | 2025337 | 2021-12-18 | Floyd | Indiana | 18043 | 12525 | 243 |
2022086 | 2022086 | 2021-12-17 | Floyd | Indiana | 18043 | 12525 | 243 |
2018835 | 2018835 | 2021-12-16 | Floyd | Indiana | 18043 | 12496 | 243 |
2015585 | 2015585 | 2021-12-15 | Floyd | Indiana | 18043 | 12451 | 242 |
2012334 | 2012334 | 2021-12-14 | Floyd | Indiana | 18043 | 12398 | 241 |
2009083 | 2009083 | 2021-12-13 | Floyd | Indiana | 18043 | 12362 | 241 |
2005832 | 2005832 | 2021-12-12 | Floyd | Indiana | 18043 | 12295 | 241 |
2002581 | 2002581 | 2021-12-11 | Floyd | Indiana | 18043 | 12295 | 241 |
1999331 | 1999331 | 2021-12-10 | Floyd | Indiana | 18043 | 12295 | 241 |
1996080 | 1996080 | 2021-12-09 | Floyd | Indiana | 18043 | 12244 | 238 |
1992829 | 1992829 | 2021-12-08 | Floyd | Indiana | 18043 | 12190 | 237 |
1989578 | 1989578 | 2021-12-07 | Floyd | Indiana | 18043 | 12148 | 236 |
1986328 | 1986328 | 2021-12-06 | Floyd | Indiana | 18043 | 12110 | 235 |
1983078 | 1983078 | 2021-12-05 | Floyd | Indiana | 18043 | 12025 | 235 |
1979828 | 1979828 | 2021-12-04 | Floyd | Indiana | 18043 | 12025 | 235 |
1976578 | 1976578 | 2021-12-03 | Floyd | Indiana | 18043 | 12025 | 235 |
1973329 | 1973329 | 2021-12-02 | Floyd | Indiana | 18043 | 11982 | 235 |
1970079 | 1970079 | 2021-12-01 | Floyd | Indiana | 18043 | 11953 | 235 |
1966829 | 1966829 | 2021-11-30 | Floyd | Indiana | 18043 | 11915 | 235 |
1963577 | 1963577 | 2021-11-29 | Floyd | Indiana | 18043 | 11883 | 234 |
1960326 | 1960326 | 2021-11-28 | Floyd | Indiana | 18043 | 11806 | 234 |
1957075 | 1957075 | 2021-11-27 | Floyd | Indiana | 18043 | 11806 | 234 |
1953824 | 1953824 | 2021-11-26 | Floyd | Indiana | 18043 | 11806 | 234 |
1950573 | 1950573 | 2021-11-25 | Floyd | Indiana | 18043 | 11806 | 234 |
1947322 | 1947322 | 2021-11-24 | Floyd | Indiana | 18043 | 11806 | 234 |
1944071 | 1944071 | 2021-11-23 | Floyd | Indiana | 18043 | 11778 | 234 |
1940821 | 1940821 | 2021-11-22 | Floyd | Indiana | 18043 | 11752 | 234 |
1937571 | 1937571 | 2021-11-21 | Floyd | Indiana | 18043 | 11686 | 234 |
1934321 | 1934321 | 2021-11-20 | Floyd | Indiana | 18043 | 11686 | 234 |
1931070 | 1931070 | 2021-11-19 | Floyd | Indiana | 18043 | 11686 | 234 |
1927819 | 1927819 | 2021-11-18 | Floyd | Indiana | 18043 | 11653 | 234 |
1924569 | 1924569 | 2021-11-17 | Floyd | Indiana | 18043 | 11620 | 234 |
1921320 | 1921320 | 2021-11-16 | Floyd | Indiana | 18043 | 11597 | 234 |
1918070 | 1918070 | 2021-11-15 | Floyd | Indiana | 18043 | 11559 | 233 |
1914820 | 1914820 | 2021-11-14 | Floyd | Indiana | 18043 | 11511 | 233 |
1911570 | 1911570 | 2021-11-13 | Floyd | Indiana | 18043 | 11511 | 233 |
1908321 | 1908321 | 2021-11-12 | Floyd | Indiana | 18043 | 11511 | 233 |
1905072 | 1905072 | 2021-11-11 | Floyd | Indiana | 18043 | 11488 | 232 |
1901822 | 1901822 | 2021-11-10 | Floyd | Indiana | 18043 | 11405 | 232 |
1898572 | 1898572 | 2021-11-09 | Floyd | Indiana | 18043 | 11388 | 231 |
1895322 | 1895322 | 2021-11-08 | Floyd | Indiana | 18043 | 11364 | 231 |
1892072 | 1892072 | 2021-11-07 | Floyd | Indiana | 18043 | 11318 | 229 |
1888822 | 1888822 | 2021-11-06 | Floyd | Indiana | 18043 | 11318 | 229 |
1885572 | 1885572 | 2021-11-05 | Floyd | Indiana | 18043 | 11318 | 229 |
1882323 | 1882323 | 2021-11-04 | Floyd | Indiana | 18043 | 11298 | 228 |
1879074 | 1879074 | 2021-11-03 | Floyd | Indiana | 18043 | 11281 | 228 |
1875825 | 1875825 | 2021-11-02 | Floyd | Indiana | 18043 | 11273 | 227 |
1872576 | 1872576 | 2021-11-01 | Floyd | Indiana | 18043 | 11259 | 226 |
1869327 | 1869327 | 2021-10-31 | Floyd | Indiana | 18043 | 11238 | 225 |
1866078 | 1866078 | 2021-10-30 | Floyd | Indiana | 18043 | 11238 | 225 |
1862829 | 1862829 | 2021-10-29 | Floyd | Indiana | 18043 | 11238 | 225 |
1859580 | 1859580 | 2021-10-28 | Floyd | Indiana | 18043 | 11233 | 225 |
1856331 | 1856331 | 2021-10-27 | Floyd | Indiana | 18043 | 11212 | 225 |
1853082 | 1853082 | 2021-10-26 | Floyd | Indiana | 18043 | 11161 | 223 |
1849833 | 1849833 | 2021-10-25 | Floyd | Indiana | 18043 | 11150 | 222 |
1846583 | 1846583 | 2021-10-24 | Floyd | Indiana | 18043 | 11119 | 221 |
1843333 | 1843333 | 2021-10-23 | Floyd | Indiana | 18043 | 11119 | 221 |
1840083 | 1840083 | 2021-10-22 | Floyd | Indiana | 18043 | 11119 | 221 |
1836834 | 1836834 | 2021-10-21 | Floyd | Indiana | 18043 | 11093 | 221 |
1833585 | 1833585 | 2021-10-20 | Floyd | Indiana | 18043 | 11070 | 220 |
1830336 | 1830336 | 2021-10-19 | Floyd | Indiana | 18043 | 11051 | 220 |
1827087 | 1827087 | 2021-10-18 | Floyd | Indiana | 18043 | 11024 | 220 |
1823838 | 1823838 | 2021-10-17 | Floyd | Indiana | 18043 | 10994 | 220 |
1820589 | 1820589 | 2021-10-16 | Floyd | Indiana | 18043 | 10994 | 220 |
1817340 | 1817340 | 2021-10-15 | Floyd | Indiana | 18043 | 10994 | 220 |
1814092 | 1814092 | 2021-10-14 | Floyd | Indiana | 18043 | 10977 | 220 |
1810843 | 1810843 | 2021-10-13 | Floyd | Indiana | 18043 | 10949 | 220 |
1807594 | 1807594 | 2021-10-12 | Floyd | Indiana | 18043 | 10919 | 220 |
1804343 | 1804343 | 2021-10-11 | Floyd | Indiana | 18043 | 10916 | 220 |
1801094 | 1801094 | 2021-10-10 | Floyd | Indiana | 18043 | 10875 | 220 |
1797845 | 1797845 | 2021-10-09 | Floyd | Indiana | 18043 | 10875 | 220 |
1794596 | 1794596 | 2021-10-08 | Floyd | Indiana | 18043 | 10875 | 220 |
1791348 | 1791348 | 2021-10-07 | Floyd | Indiana | 18043 | 10847 | 220 |
1788099 | 1788099 | 2021-10-06 | Floyd | Indiana | 18043 | 10823 | 219 |
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);