ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where cases = 2188 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 22
- Georgia 19
- Virginia 18
- Iowa 16
- Kansas 15
- Texas 15
- Alabama 10
- Illinois 9
- Missouri 9
- Nebraska 9
- Colorado 8
- Ohio 8
- Puerto Rico 8
- Indiana 7
- Mississippi 7
- West Virginia 7
- Arkansas 6
- Washington 6
- Louisiana 5
- Pennsylvania 5
- South Carolina 5
- Minnesota 4
- Montana 4
- Alaska 3
- Florida 3
- Maryland 3
- North Carolina 3
- Oregon 3
- Tennessee 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499735 | 2499735 | 2022-05-13 | Nevada | Arkansas | 5099 | 2188 | 46 |
2462249 | 2462249 | 2022-05-01 | Unknown | Nebraska | 2188 | 459 | |
2458993 | 2458993 | 2022-04-30 | Unknown | Nebraska | 2188 | 459 | |
2455737 | 2455737 | 2022-04-29 | Unknown | Nebraska | 2188 | 459 | |
2331841 | 2331841 | 2022-03-22 | Iron | Missouri | 29093 | 2188 | 43 |
2309860 | 2309860 | 2022-03-15 | Adjuntas | Puerto Rico | 72001 | 2188 | |
2304105 | 2304105 | 2022-03-13 | Lincoln | Washington | 53043 | 2188 | 27 |
2304170 | 2304170 | 2022-03-13 | Tyler | West Virginia | 54095 | 2188 | 31 |
2300853 | 2300853 | 2022-03-12 | Lincoln | Washington | 53043 | 2188 | 27 |
2300918 | 2300918 | 2022-03-12 | Tyler | West Virginia | 54095 | 2188 | 31 |
2297601 | 2297601 | 2022-03-11 | Lincoln | Washington | 53043 | 2188 | 27 |
2297666 | 2297666 | 2022-03-11 | Tyler | West Virginia | 54095 | 2188 | 31 |
2267637 | 2267637 | 2022-03-02 | Penuelas | Puerto Rico | 72111 | 2188 | |
2262082 | 2262082 | 2022-03-01 | Sitka City and Borough | Alaska | 2220 | 2188 | 5 |
2258831 | 2258831 | 2022-02-28 | Sitka City and Borough | Alaska | 2220 | 2188 | 5 |
2218876 | 2218876 | 2022-02-15 | Sabana Grande | Puerto Rico | 72121 | 2188 | |
2215625 | 2215625 | 2022-02-14 | Sabana Grande | Puerto Rico | 72121 | 2188 | |
2216050 | 2216050 | 2022-02-14 | Red River | Texas | 48387 | 2188 | 63 |
2197514 | 2197514 | 2022-02-09 | Wilkinson | Georgia | 13319 | 2188 | 51 |
2173603 | 2173603 | 2022-02-01 | Castro | Texas | 48069 | 2188 | 45 |
2170351 | 2170351 | 2022-01-31 | Castro | Texas | 48069 | 2188 | 45 |
2165529 | 2165529 | 2022-01-30 | Owen | Kentucky | 21187 | 2188 | 30 |
2162274 | 2162274 | 2022-01-29 | Owen | Kentucky | 21187 | 2188 | 30 |
2159019 | 2159019 | 2022-01-28 | Owen | Kentucky | 21187 | 2188 | 30 |
2155106 | 2155106 | 2022-01-27 | Dooly | Georgia | 13093 | 2188 | 63 |
2154389 | 2154389 | 2022-01-26 | Floyd | Virginia | 51063 | 2188 | 33 |
2147274 | 2147274 | 2022-01-24 | Florida | Puerto Rico | 72054 | 2188 | |
2126342 | 2126342 | 2022-01-18 | Marshall | Kansas | 20117 | 2188 | 37 |
2123090 | 2123090 | 2022-01-17 | Marshall | Kansas | 20117 | 2188 | 37 |
2119838 | 2119838 | 2022-01-16 | Marshall | Kansas | 20117 | 2188 | 37 |
2116586 | 2116586 | 2022-01-15 | Marshall | Kansas | 20117 | 2188 | 37 |
2113335 | 2113335 | 2022-01-14 | Marshall | Kansas | 20117 | 2188 | 37 |
2061937 | 2061937 | 2021-12-29 | Pemiscot | Missouri | 29155 | 2188 | 59 |
2051690 | 2051690 | 2021-12-26 | Martin | Kentucky | 21159 | 2188 | 39 |
2048440 | 2048440 | 2021-12-25 | Martin | Kentucky | 21159 | 2188 | 39 |
2045190 | 2045190 | 2021-12-24 | Martin | Kentucky | 21159 | 2188 | 39 |
2041941 | 2041941 | 2021-12-23 | Martin | Kentucky | 21159 | 2188 | 39 |
2038691 | 2038691 | 2021-12-22 | Martin | Kentucky | 21159 | 2188 | 39 |
2012622 | 2012622 | 2021-12-14 | Breathitt | Kentucky | 21025 | 2188 | 43 |
2007529 | 2007529 | 2021-12-12 | Bamberg | South Carolina | 45009 | 2188 | 64 |
2004278 | 2004278 | 2021-12-11 | Bamberg | South Carolina | 45009 | 2188 | 64 |
2001027 | 2001027 | 2021-12-10 | Bamberg | South Carolina | 45009 | 2188 | 64 |
1990105 | 1990105 | 2021-12-07 | Benzie | Michigan | 26019 | 2188 | 44 |
1986855 | 1986855 | 2021-12-06 | Benzie | Michigan | 26019 | 2188 | 44 |
1973700 | 1973700 | 2021-12-02 | Pendleton | Kentucky | 21191 | 2188 | 25 |
1943425 | 1943425 | 2021-11-23 | Kusilvak Census Area | Alaska | 2158 | 2188 | 9 |
1938188 | 1938188 | 2021-11-21 | Cottonwood | Minnesota | 27033 | 2188 | 32 |
1934938 | 1934938 | 2021-11-20 | Cottonwood | Minnesota | 27033 | 2188 | 32 |
1935953 | 1935953 | 2021-11-20 | Fajardo | Puerto Rico | 72053 | 2188 | |
1931688 | 1931688 | 2021-11-19 | Cottonwood | Minnesota | 27033 | 2188 | 32 |
1910286 | 1910286 | 2021-11-12 | Eastland | Texas | 48133 | 2188 | 81 |
1907037 | 1907037 | 2021-11-11 | Eastland | Texas | 48133 | 2188 | 80 |
1899039 | 1899039 | 2021-11-09 | Knox | Maine | 23013 | 2188 | 13 |
1891616 | 1891616 | 2021-11-07 | Grand | Colorado | 8049 | 2188 | 16 |
1891777 | 1891777 | 2021-11-07 | Dade | Georgia | 13083 | 2188 | 21 |
1892041 | 1892041 | 2021-11-07 | Wabash | Illinois | 17185 | 2188 | 22 |
1888366 | 1888366 | 2021-11-06 | Grand | Colorado | 8049 | 2188 | 16 |
1888527 | 1888527 | 2021-11-06 | Dade | Georgia | 13083 | 2188 | 21 |
1888791 | 1888791 | 2021-11-06 | Wabash | Illinois | 17185 | 2188 | 22 |
1885116 | 1885116 | 2021-11-05 | Grand | Colorado | 8049 | 2188 | 16 |
1885277 | 1885277 | 2021-11-05 | Dade | Georgia | 13083 | 2188 | 21 |
1885541 | 1885541 | 2021-11-05 | Wabash | Illinois | 17185 | 2188 | 22 |
1882028 | 1882028 | 2021-11-04 | Dade | Georgia | 13083 | 2188 | 21 |
1882292 | 1882292 | 2021-11-04 | Wabash | Illinois | 17185 | 2188 | 22 |
1875917 | 1875917 | 2021-11-02 | Clayton | Iowa | 19043 | 2188 | 58 |
1872668 | 1872668 | 2021-11-01 | Clayton | Iowa | 19043 | 2188 | 58 |
1869419 | 1869419 | 2021-10-31 | Clayton | Iowa | 19043 | 2188 | 58 |
1866170 | 1866170 | 2021-10-30 | Clayton | Iowa | 19043 | 2188 | 58 |
1862921 | 1862921 | 2021-10-29 | Clayton | Iowa | 19043 | 2188 | 58 |
1859672 | 1859672 | 2021-10-28 | Clayton | Iowa | 19043 | 2188 | 58 |
1856423 | 1856423 | 2021-10-27 | Clayton | Iowa | 19043 | 2188 | 58 |
1856680 | 1856680 | 2021-10-27 | Magoffin | Kentucky | 21153 | 2188 | 20 |
1847898 | 1847898 | 2021-10-24 | Ramsey | North Dakota | 38071 | 2188 | 35 |
1844648 | 1844648 | 2021-10-23 | Ramsey | North Dakota | 38071 | 2188 | 35 |
1839087 | 1839087 | 2021-10-21 | Greene | Virginia | 51079 | 2188 | 35 |
1829647 | 1829647 | 2021-10-19 | Lamar | Alabama | 1075 | 2188 | 46 |
1793561 | 1793561 | 2021-10-07 | Bristol city | Virginia | 51520 | 2188 | 45 |
1790249 | 1790249 | 2021-10-06 | Zapata | Texas | 48505 | 2188 | 43 |
1790382 | 1790382 | 2021-10-06 | New Kent | Virginia | 51127 | 2188 | 21 |
1781399 | 1781399 | 2021-10-04 | Telfair | Georgia | 13271 | 2188 | 65 |
1778039 | 1778039 | 2021-10-03 | Charlton | Georgia | 13049 | 2188 | 52 |
1778392 | 1778392 | 2021-10-03 | Pike | Indiana | 18125 | 2188 | 41 |
1774789 | 1774789 | 2021-10-02 | Charlton | Georgia | 13049 | 2188 | 52 |
1775142 | 1775142 | 2021-10-02 | Pike | Indiana | 18125 | 2188 | 41 |
1771539 | 1771539 | 2021-10-01 | Charlton | Georgia | 13049 | 2188 | 52 |
1771892 | 1771892 | 2021-10-01 | Pike | Indiana | 18125 | 2188 | 41 |
1762905 | 1762905 | 2021-09-28 | Dallas | Missouri | 29059 | 2188 | 40 |
1755998 | 1755998 | 2021-09-26 | Washington | Kentucky | 21229 | 2188 | 42 |
1752750 | 1752750 | 2021-09-25 | Washington | Kentucky | 21229 | 2188 | 42 |
1749501 | 1749501 | 2021-09-24 | Washington | Kentucky | 21229 | 2188 | 42 |
1746618 | 1746618 | 2021-09-23 | Tallahatchie | Mississippi | 28135 | 2188 | 50 |
1735130 | 1735130 | 2021-09-19 | King George | Virginia | 51099 | 2188 | 21 |
1731880 | 1731880 | 2021-09-18 | King George | Virginia | 51099 | 2188 | 21 |
1727949 | 1727949 | 2021-09-17 | Montour | Pennsylvania | 42093 | 2188 | 67 |
1728630 | 1728630 | 2021-09-17 | King George | Virginia | 51099 | 2188 | 21 |
1700278 | 1700278 | 2021-09-09 | Edgar | Illinois | 17045 | 2188 | 63 |
1700428 | 1700428 | 2021-09-09 | Rush | Indiana | 18139 | 2188 | 28 |
1700768 | 1700768 | 2021-09-09 | Union | Kentucky | 21225 | 2188 | 21 |
1692878 | 1692878 | 2021-09-06 | Fluvanna | Virginia | 51065 | 2188 | 22 |
1679468 | 1679468 | 2021-09-02 | Grundy | Tennessee | 47061 | 2188 | 36 |
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);