ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
294 rows where cases = 2009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 29
- Texas 19
- Virginia 17
- Arkansas 16
- Minnesota 14
- Tennessee 14
- West Virginia 14
- Missouri 13
- Illinois 12
- Iowa 12
- North Carolina 12
- Kansas 10
- Oklahoma 10
- Pennsylvania 10
- Michigan 9
- Puerto Rico 8
- Alabama 7
- South Carolina 7
- Kentucky 6
- Mississippi 6
- North Dakota 5
- Ohio 5
- Wisconsin 5
- Florida 4
- Maryland 4
- Idaho 3
- Indiana 3
- Louisiana 3
- New York 3
- South Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453671 | 2453671 | 2022-04-28 | Buena Vista city | Virginia | 51530 | 2009 | 43 |
2450415 | 2450415 | 2022-04-27 | Buena Vista city | Virginia | 51530 | 2009 | 43 |
2447158 | 2447158 | 2022-04-26 | Buena Vista city | Virginia | 51530 | 2009 | 43 |
2438243 | 2438243 | 2022-04-24 | Wilcox | Georgia | 13315 | 2009 | 70 |
2434987 | 2434987 | 2022-04-23 | Wilcox | Georgia | 13315 | 2009 | 70 |
2431731 | 2431731 | 2022-04-22 | Wilcox | Georgia | 13315 | 2009 | 70 |
2428475 | 2428475 | 2022-04-21 | Wilcox | Georgia | 13315 | 2009 | 70 |
2425219 | 2425219 | 2022-04-20 | Wilcox | Georgia | 13315 | 2009 | 70 |
2421963 | 2421963 | 2022-04-19 | Wilcox | Georgia | 13315 | 2009 | 69 |
2418707 | 2418707 | 2022-04-18 | Wilcox | Georgia | 13315 | 2009 | 69 |
2415451 | 2415451 | 2022-04-17 | Wilcox | Georgia | 13315 | 2009 | 69 |
2412195 | 2412195 | 2022-04-16 | Wilcox | Georgia | 13315 | 2009 | 69 |
2408939 | 2408939 | 2022-04-15 | Wilcox | Georgia | 13315 | 2009 | 69 |
2405683 | 2405683 | 2022-04-14 | Wilcox | Georgia | 13315 | 2009 | 69 |
2378981 | 2378981 | 2022-04-05 | Pocahontas | West Virginia | 54075 | 2009 | 28 |
2375727 | 2375727 | 2022-04-04 | Pocahontas | West Virginia | 54075 | 2009 | 28 |
2372475 | 2372475 | 2022-04-03 | Pocahontas | West Virginia | 54075 | 2009 | 28 |
2369222 | 2369222 | 2022-04-02 | Pocahontas | West Virginia | 54075 | 2009 | 28 |
2365969 | 2365969 | 2022-04-01 | Pocahontas | West Virginia | 54075 | 2009 | 28 |
2316396 | 2316396 | 2022-03-17 | Guayanilla | Puerto Rico | 72059 | 2009 | |
2269422 | 2269422 | 2022-03-03 | Ellsworth | Kansas | 20053 | 2009 | 31 |
2266169 | 2266169 | 2022-03-02 | Ellsworth | Kansas | 20053 | 2009 | 31 |
2263569 | 2263569 | 2022-03-01 | Oregon | Missouri | 29149 | 2009 | 32 |
2260318 | 2260318 | 2022-02-28 | Oregon | Missouri | 29149 | 2009 | 31 |
2260363 | 2260363 | 2022-02-28 | Carbon | Montana | 30009 | 2009 | 28 |
2237358 | 2237358 | 2022-02-21 | Marshall | Minnesota | 27089 | 2009 | 23 |
2233158 | 2233158 | 2022-02-20 | Clinch | Georgia | 13065 | 2009 | 37 |
2234107 | 2234107 | 2022-02-20 | Marshall | Minnesota | 27089 | 2009 | 23 |
2229907 | 2229907 | 2022-02-19 | Clinch | Georgia | 13065 | 2009 | 37 |
2230856 | 2230856 | 2022-02-19 | Marshall | Minnesota | 27089 | 2009 | 23 |
2226656 | 2226656 | 2022-02-18 | Clinch | Georgia | 13065 | 2009 | 37 |
2227605 | 2227605 | 2022-02-18 | Marshall | Minnesota | 27089 | 2009 | 23 |
2196377 | 2196377 | 2022-02-08 | Clay | Texas | 48077 | 2009 | 27 |
2174091 | 2174091 | 2022-02-01 | Tyler | West Virginia | 54095 | 2009 | 27 |
2159453 | 2159453 | 2022-01-28 | DeKalb | Missouri | 29063 | 2009 | 40 |
2156724 | 2156724 | 2022-01-27 | Traill | North Dakota | 38097 | 2009 | 22 |
2157123 | 2157123 | 2022-01-27 | McCormick | South Carolina | 45065 | 2009 | 34 |
2152837 | 2152837 | 2022-01-26 | Benton | Mississippi | 28009 | 2009 | 43 |
2132942 | 2132942 | 2022-01-20 | Hancock | Kentucky | 21091 | 2009 | 19 |
2128414 | 2128414 | 2022-01-18 | Poquoson city | Virginia | 51735 | 2009 | 24 |
2121855 | 2121855 | 2022-01-16 | Floyd | Virginia | 51063 | 2009 | 33 |
2118603 | 2118603 | 2022-01-15 | Floyd | Virginia | 51063 | 2009 | 33 |
2115351 | 2115351 | 2022-01-14 | Floyd | Virginia | 51063 | 2009 | 33 |
2104213 | 2104213 | 2022-01-11 | Ralls | Missouri | 29173 | 2009 | 19 |
2102551 | 2102551 | 2022-01-10 | Forest | Wisconsin | 55041 | 2009 | 43 |
2096189 | 2096189 | 2022-01-09 | Wilcox | Alabama | 1131 | 2009 | 38 |
2083759 | 2083759 | 2022-01-05 | Jasper | Illinois | 17079 | 2009 | 25 |
2084585 | 2084585 | 2022-01-05 | Noxubee | Mississippi | 28103 | 2009 | 44 |
2079883 | 2079883 | 2022-01-04 | Coosa | Alabama | 1037 | 2009 | 48 |
2080305 | 2080305 | 2022-01-04 | Early | Georgia | 13099 | 2009 | 58 |
2078169 | 2078169 | 2022-01-03 | Lewis | Missouri | 29111 | 2009 | 30 |
2061775 | 2061775 | 2021-12-29 | Yellow Medicine | Minnesota | 27173 | 2009 | 25 |
2058118 | 2058118 | 2021-12-28 | Bath | Kentucky | 21011 | 2009 | 34 |
2034542 | 2034542 | 2021-12-21 | Stone | Arkansas | 5137 | 2009 | 47 |
2033367 | 2033367 | 2021-12-20 | Morrow | Oregon | 41049 | 2009 | 25 |
2011049 | 2011049 | 2021-12-13 | Duval | Texas | 48131 | 2009 | 60 |
2007798 | 2007798 | 2021-12-12 | Duval | Texas | 48131 | 2009 | 60 |
2004547 | 2004547 | 2021-12-11 | Duval | Texas | 48131 | 2009 | 60 |
2001296 | 2001296 | 2021-12-10 | Duval | Texas | 48131 | 2009 | 60 |
1963924 | 1963924 | 2021-11-29 | Lyon | Kentucky | 21143 | 2009 | 26 |
1953214 | 1953214 | 2021-11-26 | Bradley | Arkansas | 5011 | 2009 | 41 |
1942086 | 1942086 | 2021-11-22 | Swain | North Carolina | 37173 | 2009 | 28 |
1938877 | 1938877 | 2021-11-21 | McLean | North Dakota | 38055 | 2009 | 43 |
1935627 | 1935627 | 2021-11-20 | McLean | North Dakota | 38055 | 2009 | 43 |
1935630 | 1935630 | 2021-11-20 | Mountrail | North Dakota | 38061 | 2009 | 29 |
1876065 | 1876065 | 2021-11-02 | Osage | Kansas | 20139 | 2009 | 37 |
1872816 | 1872816 | 2021-11-01 | Osage | Kansas | 20139 | 2009 | 37 |
1855583 | 1855583 | 2021-10-26 | Big Horn | Wyoming | 56003 | 2009 | 53 |
1847979 | 1847979 | 2021-10-24 | Noble | Ohio | 39121 | 2009 | 47 |
1830285 | 1830285 | 2021-10-19 | Piatt | Illinois | 17147 | 2009 | 20 |
1832186 | 1832186 | 2021-10-19 | Lake | Tennessee | 47095 | 2009 | 31 |
1827036 | 1827036 | 2021-10-18 | Piatt | Illinois | 17147 | 2009 | 20 |
1803470 | 1803470 | 2021-10-10 | Braxton | West Virginia | 54007 | 2009 | 15 |
1785473 | 1785473 | 2021-10-05 | Faribault | Minnesota | 27043 | 2009 | 26 |
1766035 | 1766035 | 2021-09-29 | Wadena | Minnesota | 27159 | 2009 | 27 |
1761415 | 1761415 | 2021-09-28 | Lamar | Alabama | 1075 | 2009 | 43 |
1763987 | 1763987 | 2021-09-28 | Stewart | Tennessee | 47161 | 2009 | 30 |
1758762 | 1758762 | 2021-09-27 | Greene | Illinois | 17061 | 2009 | 52 |
1755514 | 1755514 | 2021-09-26 | Greene | Illinois | 17061 | 2009 | 52 |
1752266 | 1752266 | 2021-09-25 | Greene | Illinois | 17061 | 2009 | 52 |
1749017 | 1749017 | 2021-09-24 | Greene | Illinois | 17061 | 2009 | 52 |
1745767 | 1745767 | 2021-09-23 | Greene | Illinois | 17061 | 2009 | 52 |
1742581 | 1742581 | 2021-09-22 | Wabash | Illinois | 17185 | 2009 | 18 |
1734559 | 1734559 | 2021-09-19 | Bamberg | South Carolina | 45009 | 2009 | 61 |
1731309 | 1731309 | 2021-09-18 | Bamberg | South Carolina | 45009 | 2009 | 61 |
1728059 | 1728059 | 2021-09-17 | Bamberg | South Carolina | 45009 | 2009 | 61 |
1719907 | 1719907 | 2021-09-15 | Pike | Indiana | 18125 | 2009 | 38 |
1707655 | 1707655 | 2021-09-11 | Bates | Missouri | 29013 | 2009 | 38 |
1694732 | 1694732 | 2021-09-07 | Osage | Missouri | 29151 | 2009 | 19 |
1695632 | 1695632 | 2021-09-07 | Clay | South Dakota | 46027 | 2009 | 15 |
1676430 | 1676430 | 2021-09-01 | Leon | Texas | 48289 | 2009 | 49 |
1643741 | 1643741 | 2021-08-22 | Grundy | Tennessee | 47061 | 2009 | 35 |
1640491 | 1640491 | 2021-08-21 | Grundy | Tennessee | 47061 | 2009 | 35 |
1637241 | 1637241 | 2021-08-20 | Grundy | Tennessee | 47061 | 2009 | 35 |
1630155 | 1630155 | 2021-08-18 | Northampton | North Carolina | 37131 | 2009 | 62 |
1622819 | 1622819 | 2021-08-16 | Bienville | Louisiana | 22013 | 2009 | 85 |
1605907 | 1605907 | 2021-08-11 | Greene | Georgia | 13133 | 2009 | 64 |
1607829 | 1607829 | 2021-08-11 | Manati | Puerto Rico | 72091 | 2009 | |
1602752 | 1602752 | 2021-08-10 | Worth | Georgia | 13321 | 2009 | 69 |
1601335 | 1601335 | 2021-08-09 | Moca | Puerto Rico | 72099 | 2009 |
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);