ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
223 rows where cases = 2547 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 18
- Kentucky 15
- Texas 13
- Oklahoma 11
- Tennessee 11
- Virginia 11
- Arkansas 9
- Puerto Rico 9
- Montana 8
- Ohio 8
- West Virginia 8
- Idaho 7
- Mississippi 7
- Alabama 6
- Georgia 6
- Kansas 6
- Louisiana 6
- Indiana 5
- Michigan 5
- Minnesota 5
- Nebraska 5
- Illinois 4
- North Dakota 4
- Oregon 4
- Virgin Islands 4
- Alaska 3
- New York 3
- Wisconsin 3
- California 2
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498715 | 2498715 | 2022-05-12 | Rincon | Puerto Rico | 72117 | 2547 | |
2473762 | 2473762 | 2022-05-05 | Bent | Colorado | 8011 | 2547 | 47 |
2468416 | 2468416 | 2022-05-03 | Yellow Medicine | Minnesota | 27173 | 2547 | 29 |
2459879 | 2459879 | 2022-04-30 | Blanco | Texas | 48031 | 2547 | 34 |
2456623 | 2456623 | 2022-04-29 | Blanco | Texas | 48031 | 2547 | 34 |
2453736 | 2453736 | 2022-04-28 | Nelson | Virginia | 51125 | 2547 | 35 |
2399343 | 2399343 | 2022-04-12 | Crawford | Indiana | 18025 | 2547 | 40 |
2396088 | 2396088 | 2022-04-11 | Crawford | Indiana | 18025 | 2547 | 40 |
2350533 | 2350533 | 2022-03-28 | Crawford | Indiana | 18025 | 2547 | 38 |
2348190 | 2348190 | 2022-03-27 | Deer Lodge | Montana | 30023 | 2547 | 28 |
2344937 | 2344937 | 2022-03-26 | Deer Lodge | Montana | 30023 | 2547 | 28 |
2341684 | 2341684 | 2022-03-25 | Deer Lodge | Montana | 30023 | 2547 | 28 |
2338431 | 2338431 | 2022-03-24 | Deer Lodge | Montana | 30023 | 2547 | 28 |
2335082 | 2335082 | 2022-03-23 | Douglas | Missouri | 29067 | 2547 | 79 |
2335120 | 2335120 | 2022-03-23 | Montgomery | Missouri | 29139 | 2547 | 57 |
2331250 | 2331250 | 2022-03-22 | Marshall | Kansas | 20117 | 2547 | 42 |
2333274 | 2333274 | 2022-03-22 | Galax city | Virginia | 51640 | 2547 | 76 |
2327998 | 2327998 | 2022-03-21 | Marshall | Kansas | 20117 | 2547 | 42 |
2330021 | 2330021 | 2022-03-21 | Galax city | Virginia | 51640 | 2547 | 76 |
2291430 | 2291430 | 2022-03-10 | Pike | Arkansas | 5109 | 2547 | 41 |
2288178 | 2288178 | 2022-03-09 | Pike | Arkansas | 5109 | 2547 | 41 |
2284927 | 2284927 | 2022-03-08 | Pike | Arkansas | 5109 | 2547 | 40 |
2278422 | 2278422 | 2022-03-06 | Pike | Arkansas | 5109 | 2547 | 40 |
2280292 | 2280292 | 2022-03-06 | Mercer | North Dakota | 38057 | 2547 | 24 |
2275169 | 2275169 | 2022-03-05 | Pike | Arkansas | 5109 | 2547 | 40 |
2260167 | 2260167 | 2022-02-28 | Carroll | Mississippi | 28015 | 2547 | 50 |
2159427 | 2159427 | 2022-01-28 | Barton | Missouri | 29011 | 2547 | 44 |
2153325 | 2153325 | 2022-01-26 | Alleghany | North Carolina | 37005 | 2547 | 11 |
2132211 | 2132211 | 2022-01-20 | Unknown | Connecticut | 2547 | 5 | |
2134982 | 2134982 | 2022-01-20 | Pacific | Washington | 53049 | 2547 | 43 |
2130113 | 2130113 | 2022-01-19 | Perry | Mississippi | 28111 | 2547 | 57 |
2122044 | 2122044 | 2022-01-16 | Bayfield | Wisconsin | 55007 | 2547 | 35 |
2118792 | 2118792 | 2022-01-15 | Bayfield | Wisconsin | 55007 | 2547 | 35 |
2115540 | 2115540 | 2022-01-14 | Bayfield | Wisconsin | 55007 | 2547 | 35 |
2108550 | 2108550 | 2022-01-12 | Comanche | Texas | 48093 | 2547 | 67 |
2102706 | 2102706 | 2022-01-11 | Kusilvak Census Area | Alaska | 2158 | 2547 | 9 |
2099455 | 2099455 | 2022-01-10 | Kusilvak Census Area | Alaska | 2158 | 2547 | 9 |
2098245 | 2098245 | 2022-01-09 | Morgan | Ohio | 39115 | 2547 | 47 |
2088002 | 2088002 | 2022-01-06 | Glacier | Montana | 30035 | 2547 | 63 |
2082798 | 2082798 | 2022-01-04 | Alleghany | Virginia | 51005 | 2547 | 88 |
2052730 | 2052730 | 2021-12-26 | Monroe | Ohio | 39111 | 2547 | 64 |
2035260 | 2035260 | 2021-12-21 | Allen | Kansas | 20001 | 2547 | 26 |
2032010 | 2032010 | 2021-12-20 | Allen | Kansas | 20001 | 2547 | 26 |
2032241 | 2032241 | 2021-12-20 | Bienville | Louisiana | 22013 | 2547 | 100 |
2033169 | 2033169 | 2021-12-20 | Walsh | North Dakota | 38099 | 2547 | 33 |
2029919 | 2029919 | 2021-12-19 | Walsh | North Dakota | 38099 | 2547 | 33 |
2018776 | 2018776 | 2021-12-16 | Mercer | Illinois | 17131 | 2547 | 37 |
2019636 | 2019636 | 2021-12-16 | Dallas | Missouri | 29059 | 2547 | 57 |
2008394 | 2008394 | 2021-12-13 | Lamar | Alabama | 1075 | 2547 | 55 |
2009432 | 2009432 | 2021-12-13 | Magoffin | Kentucky | 21153 | 2547 | 34 |
2005143 | 2005143 | 2021-12-12 | Lamar | Alabama | 1075 | 2547 | 55 |
2001892 | 2001892 | 2021-12-11 | Lamar | Alabama | 1075 | 2547 | 55 |
1992723 | 1992723 | 2021-12-08 | De Witt | Illinois | 17039 | 2547 | 38 |
1969367 | 1969367 | 2021-12-01 | Cleburne | Alabama | 1029 | 2547 | 60 |
1968016 | 1968016 | 2021-11-30 | Bertie | North Carolina | 37015 | 2547 | 53 |
1944390 | 1944390 | 2021-11-23 | Green | Kentucky | 21087 | 2547 | 36 |
1897910 | 1897910 | 2021-11-09 | Washington | Alabama | 1129 | 2547 | 52 |
1886427 | 1886427 | 2021-11-05 | Pike | Missouri | 29163 | 2547 | 38 |
1869701 | 1869701 | 2021-10-31 | Powell | Kentucky | 21197 | 2547 | 22 |
1866452 | 1866452 | 2021-10-30 | Powell | Kentucky | 21197 | 2547 | 22 |
1863203 | 1863203 | 2021-10-29 | Powell | Kentucky | 21197 | 2547 | 22 |
1855684 | 1855684 | 2021-10-27 | Kodiak Island Borough | Alaska | 2150 | 2547 | 8 |
1855998 | 1855998 | 2021-10-27 | Bacon | Georgia | 13005 | 2547 | 61 |
1829352 | 1829352 | 2021-10-18 | King George | Virginia | 51099 | 2547 | 22 |
1824168 | 1824168 | 2021-10-17 | Jackson | Kentucky | 21109 | 2547 | 49 |
1820919 | 1820919 | 2021-10-16 | Jackson | Kentucky | 21109 | 2547 | 49 |
1817670 | 1817670 | 2021-10-15 | Jackson | Kentucky | 21109 | 2547 | 49 |
1814923 | 1814923 | 2021-10-14 | Livingston | Missouri | 29117 | 2547 | 62 |
1815479 | 1815479 | 2021-10-14 | Meigs | Ohio | 39105 | 2547 | 47 |
1811675 | 1811675 | 2021-10-13 | Livingston | Missouri | 29117 | 2547 | 62 |
1813216 | 1813216 | 2021-10-13 | Barbour | West Virginia | 54001 | 2547 | 43 |
1793741 | 1793741 | 2021-10-07 | Lincoln | West Virginia | 54043 | 2547 | 39 |
1786286 | 1786286 | 2021-10-05 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1783037 | 1783037 | 2021-10-04 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1779788 | 1779788 | 2021-10-03 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1776538 | 1776538 | 2021-10-02 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1773288 | 1773288 | 2021-10-01 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1770000 | 1770000 | 2021-09-30 | Paulding | Ohio | 39125 | 2547 | 43 |
1770038 | 1770038 | 2021-09-30 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1766789 | 1766789 | 2021-09-29 | Choctaw | Oklahoma | 40023 | 2547 | 41 |
1767752 | 1767752 | 2021-09-29 | McDowell | West Virginia | 54047 | 2547 | 39 |
1742007 | 1742007 | 2021-09-22 | Clay | Arkansas | 5021 | 2547 | 57 |
1736497 | 1736497 | 2021-09-20 | Spencer | Kentucky | 21215 | 2547 | 27 |
1735062 | 1735062 | 2021-09-19 | St. Croix | Virgin Islands | 78010 | 2547 | 22 |
1731812 | 1731812 | 2021-09-18 | St. Croix | Virgin Islands | 78010 | 2547 | 22 |
1728562 | 1728562 | 2021-09-17 | St. Croix | Virgin Islands | 78010 | 2547 | 22 |
1725313 | 1725313 | 2021-09-16 | St. Croix | Virgin Islands | 78010 | 2547 | 22 |
1714066 | 1714066 | 2021-09-13 | Calhoun | Mississippi | 28013 | 2547 | 38 |
1712003 | 1712003 | 2021-09-12 | Sequatchie | Tennessee | 47153 | 2547 | 30 |
1708756 | 1708756 | 2021-09-11 | Sequatchie | Tennessee | 47153 | 2547 | 30 |
1705509 | 1705509 | 2021-09-10 | Sequatchie | Tennessee | 47153 | 2547 | 30 |
1697927 | 1697927 | 2021-09-08 | Clinton | Missouri | 29049 | 2547 | 71 |
1696130 | 1696130 | 2021-09-07 | Fredericksburg city | Virginia | 51630 | 2547 | 25 |
1679870 | 1679870 | 2021-09-02 | Dinwiddie | Virginia | 51053 | 2547 | 46 |
1671494 | 1671494 | 2021-08-31 | McCreary | Kentucky | 21147 | 2547 | 34 |
1664510 | 1664510 | 2021-08-29 | Minidoka | Idaho | 16067 | 2547 | 34 |
1661262 | 1661262 | 2021-08-28 | Minidoka | Idaho | 16067 | 2547 | 34 |
1657561 | 1657561 | 2021-08-27 | Grant | Arkansas | 5053 | 2547 | 44 |
1657563 | 1657563 | 2021-08-27 | Hempstead | Arkansas | 5057 | 2547 | 21 |
1658014 | 1658014 | 2021-08-27 | Minidoka | Idaho | 16067 | 2547 | 34 |
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);