ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,232 rows where county = "Butler" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
county 1
- Butler · 4,871 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947404 | 1947404 | 2021-11-24 | Butler | Iowa | 19023 | 2334 | 44 |
1947500 | 1947500 | 2021-11-24 | Butler | Kansas | 20015 | 11646 | 140 |
1947613 | 1947613 | 2021-11-24 | Butler | Kentucky | 21031 | 2462 | 40 |
1948105 | 1948105 | 2021-11-24 | Butler | Missouri | 29023 | 7016 | 126 |
1948278 | 1948278 | 2021-11-24 | Butler | Nebraska | 31023 | 1266 | 12 |
1948667 | 1948667 | 2021-11-24 | Butler | Ohio | 39017 | 55231 | 794 |
1948871 | 1948871 | 2021-11-24 | Butler | Pennsylvania | 42019 | 28231 | 543 |
1943351 | 1943351 | 2021-11-23 | Butler | Alabama | 1013 | 3430 | 100 |
1944153 | 1944153 | 2021-11-23 | Butler | Iowa | 19023 | 2270 | 42 |
1944249 | 1944249 | 2021-11-23 | Butler | Kansas | 20015 | 11554 | 139 |
1944362 | 1944362 | 2021-11-23 | Butler | Kentucky | 21031 | 2454 | 40 |
1944854 | 1944854 | 2021-11-23 | Butler | Missouri | 29023 | 7002 | 126 |
1945027 | 1945027 | 2021-11-23 | Butler | Nebraska | 31023 | 1261 | 12 |
1945416 | 1945416 | 2021-11-23 | Butler | Ohio | 39017 | 55043 | 794 |
1945620 | 1945620 | 2021-11-23 | Butler | Pennsylvania | 42019 | 28064 | 543 |
1940101 | 1940101 | 2021-11-22 | Butler | Alabama | 1013 | 3426 | 100 |
1940903 | 1940903 | 2021-11-22 | Butler | Iowa | 19023 | 2270 | 42 |
1940999 | 1940999 | 2021-11-22 | Butler | Kansas | 20015 | 11554 | 139 |
1941112 | 1941112 | 2021-11-22 | Butler | Kentucky | 21031 | 2449 | 40 |
1941603 | 1941603 | 2021-11-22 | Butler | Missouri | 29023 | 6991 | 126 |
1941776 | 1941776 | 2021-11-22 | Butler | Nebraska | 31023 | 1261 | 12 |
1942165 | 1942165 | 2021-11-22 | Butler | Ohio | 39017 | 54887 | 794 |
1942369 | 1942369 | 2021-11-22 | Butler | Pennsylvania | 42019 | 28007 | 541 |
1936851 | 1936851 | 2021-11-21 | Butler | Alabama | 1013 | 3422 | 100 |
1937653 | 1937653 | 2021-11-21 | Butler | Iowa | 19023 | 2270 | 42 |
1937749 | 1937749 | 2021-11-21 | Butler | Kansas | 20015 | 11504 | 139 |
1937862 | 1937862 | 2021-11-21 | Butler | Kentucky | 21031 | 2433 | 40 |
1938353 | 1938353 | 2021-11-21 | Butler | Missouri | 29023 | 6990 | 127 |
1938526 | 1938526 | 2021-11-21 | Butler | Nebraska | 31023 | 1254 | 12 |
1938915 | 1938915 | 2021-11-21 | Butler | Ohio | 39017 | 54776 | 794 |
1939119 | 1939119 | 2021-11-21 | Butler | Pennsylvania | 42019 | 27882 | 541 |
1933601 | 1933601 | 2021-11-20 | Butler | Alabama | 1013 | 3419 | 100 |
1934403 | 1934403 | 2021-11-20 | Butler | Iowa | 19023 | 2270 | 42 |
1934499 | 1934499 | 2021-11-20 | Butler | Kansas | 20015 | 11504 | 139 |
1934612 | 1934612 | 2021-11-20 | Butler | Kentucky | 21031 | 2433 | 40 |
1935103 | 1935103 | 2021-11-20 | Butler | Missouri | 29023 | 6989 | 127 |
1935276 | 1935276 | 2021-11-20 | Butler | Nebraska | 31023 | 1254 | 12 |
1935665 | 1935665 | 2021-11-20 | Butler | Ohio | 39017 | 54693 | 794 |
1935869 | 1935869 | 2021-11-20 | Butler | Pennsylvania | 42019 | 27731 | 541 |
1930349 | 1930349 | 2021-11-19 | Butler | Alabama | 1013 | 3409 | 100 |
1931152 | 1931152 | 2021-11-19 | Butler | Iowa | 19023 | 2270 | 42 |
1931248 | 1931248 | 2021-11-19 | Butler | Kansas | 20015 | 11504 | 139 |
1931361 | 1931361 | 2021-11-19 | Butler | Kentucky | 21031 | 2433 | 40 |
1931853 | 1931853 | 2021-11-19 | Butler | Missouri | 29023 | 6974 | 127 |
1932026 | 1932026 | 2021-11-19 | Butler | Nebraska | 31023 | 1254 | 12 |
1932415 | 1932415 | 2021-11-19 | Butler | Ohio | 39017 | 54531 | 794 |
1932619 | 1932619 | 2021-11-19 | Butler | Pennsylvania | 42019 | 27553 | 538 |
1927099 | 1927099 | 2021-11-18 | Butler | Alabama | 1013 | 3404 | 100 |
1927901 | 1927901 | 2021-11-18 | Butler | Iowa | 19023 | 2270 | 42 |
1927997 | 1927997 | 2021-11-18 | Butler | Kansas | 20015 | 11446 | 139 |
1928110 | 1928110 | 2021-11-18 | Butler | Kentucky | 21031 | 2430 | 40 |
1928602 | 1928602 | 2021-11-18 | Butler | Missouri | 29023 | 6967 | 126 |
1928775 | 1928775 | 2021-11-18 | Butler | Nebraska | 31023 | 1253 | 12 |
1929164 | 1929164 | 2021-11-18 | Butler | Ohio | 39017 | 54354 | 783 |
1929368 | 1929368 | 2021-11-18 | Butler | Pennsylvania | 42019 | 27374 | 536 |
1923849 | 1923849 | 2021-11-17 | Butler | Alabama | 1013 | 3398 | 100 |
1924651 | 1924651 | 2021-11-17 | Butler | Iowa | 19023 | 2270 | 42 |
1924747 | 1924747 | 2021-11-17 | Butler | Kansas | 20015 | 11446 | 139 |
1924860 | 1924860 | 2021-11-17 | Butler | Kentucky | 21031 | 2424 | 40 |
1925352 | 1925352 | 2021-11-17 | Butler | Missouri | 29023 | 6872 | 72 |
1925525 | 1925525 | 2021-11-17 | Butler | Nebraska | 31023 | 1251 | 12 |
1925914 | 1925914 | 2021-11-17 | Butler | Ohio | 39017 | 54204 | 783 |
1926118 | 1926118 | 2021-11-17 | Butler | Pennsylvania | 42019 | 27226 | 535 |
1920600 | 1920600 | 2021-11-16 | Butler | Alabama | 1013 | 3393 | 100 |
1921402 | 1921402 | 2021-11-16 | Butler | Iowa | 19023 | 2202 | 41 |
1921498 | 1921498 | 2021-11-16 | Butler | Kansas | 20015 | 11374 | 139 |
1921611 | 1921611 | 2021-11-16 | Butler | Kentucky | 21031 | 2408 | 40 |
1922103 | 1922103 | 2021-11-16 | Butler | Missouri | 29023 | 6866 | 72 |
1922276 | 1922276 | 2021-11-16 | Butler | Nebraska | 31023 | 1241 | 12 |
1922664 | 1922664 | 2021-11-16 | Butler | Ohio | 39017 | 54022 | 783 |
1922868 | 1922868 | 2021-11-16 | Butler | Pennsylvania | 42019 | 27114 | 528 |
1917350 | 1917350 | 2021-11-15 | Butler | Alabama | 1013 | 3391 | 99 |
1918152 | 1918152 | 2021-11-15 | Butler | Iowa | 19023 | 2202 | 41 |
1918248 | 1918248 | 2021-11-15 | Butler | Kansas | 20015 | 11374 | 139 |
1918361 | 1918361 | 2021-11-15 | Butler | Kentucky | 21031 | 2397 | 40 |
1918853 | 1918853 | 2021-11-15 | Butler | Missouri | 29023 | 6849 | 72 |
1919026 | 1919026 | 2021-11-15 | Butler | Nebraska | 31023 | 1234 | 12 |
1919415 | 1919415 | 2021-11-15 | Butler | Ohio | 39017 | 53841 | 778 |
1919619 | 1919619 | 2021-11-15 | Butler | Pennsylvania | 42019 | 26968 | 527 |
1914100 | 1914100 | 2021-11-14 | Butler | Alabama | 1013 | 3390 | 99 |
1914902 | 1914902 | 2021-11-14 | Butler | Iowa | 19023 | 2202 | 41 |
1914998 | 1914998 | 2021-11-14 | Butler | Kansas | 20015 | 11330 | 139 |
1915111 | 1915111 | 2021-11-14 | Butler | Kentucky | 21031 | 2384 | 40 |
1915603 | 1915603 | 2021-11-14 | Butler | Missouri | 29023 | 6842 | 72 |
1915776 | 1915776 | 2021-11-14 | Butler | Nebraska | 31023 | 1218 | 12 |
1916165 | 1916165 | 2021-11-14 | Butler | Ohio | 39017 | 53773 | 778 |
1916369 | 1916369 | 2021-11-14 | Butler | Pennsylvania | 42019 | 26894 | 527 |
1910850 | 1910850 | 2021-11-13 | Butler | Alabama | 1013 | 3387 | 99 |
1911652 | 1911652 | 2021-11-13 | Butler | Iowa | 19023 | 2202 | 41 |
1911748 | 1911748 | 2021-11-13 | Butler | Kansas | 20015 | 11330 | 139 |
1911861 | 1911861 | 2021-11-13 | Butler | Kentucky | 21031 | 2384 | 40 |
1912353 | 1912353 | 2021-11-13 | Butler | Missouri | 29023 | 6841 | 72 |
1912526 | 1912526 | 2021-11-13 | Butler | Nebraska | 31023 | 1218 | 12 |
1912915 | 1912915 | 2021-11-13 | Butler | Ohio | 39017 | 53666 | 778 |
1913119 | 1913119 | 2021-11-13 | Butler | Pennsylvania | 42019 | 26813 | 527 |
1907601 | 1907601 | 2021-11-12 | Butler | Alabama | 1013 | 3387 | 99 |
1908403 | 1908403 | 2021-11-12 | Butler | Iowa | 19023 | 2202 | 41 |
1908499 | 1908499 | 2021-11-12 | Butler | Kansas | 20015 | 11330 | 139 |
1908612 | 1908612 | 2021-11-12 | Butler | Kentucky | 21031 | 2384 | 40 |
1909103 | 1909103 | 2021-11-12 | Butler | Missouri | 29023 | 6835 | 72 |
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);