ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where cases = 2504 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 16
- Nevada 14
- Georgia 13
- Kentucky 13
- Texas 11
- Iowa 10
- Alabama 9
- Florida 9
- Louisiana 9
- Arkansas 8
- Missouri 8
- Virginia 8
- Minnesota 7
- North Carolina 6
- California 5
- Ohio 5
- Tennessee 5
- Washington 5
- Illinois 4
- New York 4
- Puerto Rico 4
- West Virginia 4
- Indiana 3
- Kansas 3
- South Carolina 3
- Idaho 2
- Michigan 2
- Nebraska 2
- Oklahoma 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463580 | 2463580 | 2022-05-01 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2460324 | 2460324 | 2022-04-30 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2457068 | 2457068 | 2022-04-29 | Pend Oreille | Washington | 53051 | 2504 | 36 |
2445982 | 2445982 | 2022-04-26 | Humboldt | Nevada | 32013 | 2504 | 54 |
2442727 | 2442727 | 2022-04-25 | Humboldt | Nevada | 32013 | 2504 | 54 |
2439471 | 2439471 | 2022-04-24 | Humboldt | Nevada | 32013 | 2504 | 54 |
2436215 | 2436215 | 2022-04-23 | Humboldt | Nevada | 32013 | 2504 | 54 |
2432959 | 2432959 | 2022-04-22 | Humboldt | Nevada | 32013 | 2504 | 54 |
2429703 | 2429703 | 2022-04-21 | Humboldt | Nevada | 32013 | 2504 | 54 |
2426447 | 2426447 | 2022-04-20 | Humboldt | Nevada | 32013 | 2504 | 54 |
2423191 | 2423191 | 2022-04-19 | Humboldt | Nevada | 32013 | 2504 | 54 |
2419934 | 2419934 | 2022-04-18 | Humboldt | Nevada | 32013 | 2504 | 54 |
2416679 | 2416679 | 2022-04-17 | Humboldt | Nevada | 32013 | 2504 | 54 |
2413423 | 2413423 | 2022-04-16 | Humboldt | Nevada | 32013 | 2504 | 54 |
2410167 | 2410167 | 2022-04-15 | Humboldt | Nevada | 32013 | 2504 | 54 |
2406911 | 2406911 | 2022-04-14 | Humboldt | Nevada | 32013 | 2504 | 54 |
2403655 | 2403655 | 2022-04-13 | Humboldt | Nevada | 32013 | 2504 | 54 |
2370455 | 2370455 | 2022-04-03 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2367202 | 2367202 | 2022-04-02 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2363949 | 2363949 | 2022-04-01 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2360695 | 2360695 | 2022-03-31 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2357441 | 2357441 | 2022-03-30 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2354188 | 2354188 | 2022-03-29 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2350936 | 2350936 | 2022-03-28 | Wolfe | Kentucky | 21237 | 2504 | 20 |
2317446 | 2317446 | 2022-03-18 | Perry | Arkansas | 5105 | 2504 | 36 |
2279396 | 2279396 | 2022-03-06 | East Carroll | Louisiana | 22035 | 2504 | 35 |
2276143 | 2276143 | 2022-03-05 | East Carroll | Louisiana | 22035 | 2504 | 35 |
2272890 | 2272890 | 2022-03-04 | East Carroll | Louisiana | 22035 | 2504 | 35 |
2271141 | 2271141 | 2022-03-03 | Blanco | Texas | 48031 | 2504 | 33 |
2243976 | 2243976 | 2022-02-23 | Tunica | Mississippi | 28143 | 2504 | 44 |
2224514 | 2224514 | 2022-02-17 | Douglas | Missouri | 29067 | 2504 | 72 |
2219897 | 2219897 | 2022-02-16 | Pike | Arkansas | 5109 | 2504 | 39 |
2217013 | 2217013 | 2022-02-15 | Turner | Georgia | 13287 | 2504 | 53 |
2191217 | 2191217 | 2022-02-07 | Newton | Indiana | 18111 | 2504 | 65 |
2128761 | 2128761 | 2022-01-19 | Chicot | Arkansas | 5017 | 2504 | 49 |
2106027 | 2106027 | 2022-01-12 | Lee | Arkansas | 5077 | 2504 | 55 |
2077311 | 2077311 | 2022-01-03 | Washington | Illinois | 17189 | 2504 | 37 |
2039147 | 2039147 | 2021-12-22 | Gasconade | Missouri | 29073 | 2504 | 86 |
2036343 | 2036343 | 2021-12-21 | Polk | North Carolina | 37149 | 2504 | 49 |
2036749 | 2036749 | 2021-12-21 | Naranjito | Puerto Rico | 72105 | 2504 | |
2032609 | 2032609 | 2021-12-20 | Yalobusha | Mississippi | 28161 | 2504 | 47 |
2030498 | 2030498 | 2021-12-19 | Bandera | Texas | 48019 | 2504 | 64 |
2027247 | 2027247 | 2021-12-18 | Bandera | Texas | 48019 | 2504 | 64 |
2018463 | 2018463 | 2021-12-16 | Jefferson | Florida | 12065 | 2504 | 36 |
2015213 | 2015213 | 2021-12-15 | Jefferson | Florida | 12065 | 2504 | 36 |
2011962 | 2011962 | 2021-12-14 | Jefferson | Florida | 12065 | 2504 | 36 |
2008711 | 2008711 | 2021-12-13 | Jefferson | Florida | 12065 | 2504 | 36 |
2005460 | 2005460 | 2021-12-12 | Jefferson | Florida | 12065 | 2504 | 36 |
2002209 | 2002209 | 2021-12-11 | Jefferson | Florida | 12065 | 2504 | 36 |
1998959 | 1998959 | 2021-12-10 | Jefferson | Florida | 12065 | 2504 | 36 |
1990851 | 1990851 | 2021-12-07 | Warren | North Carolina | 37185 | 2504 | 33 |
1973666 | 1973666 | 2021-12-02 | Larue | Kentucky | 21123 | 2504 | 53 |
1968617 | 1968617 | 2021-11-30 | Oglala Lakota | South Dakota | 46102 | 2504 | 54 |
1937045 | 1937045 | 2021-11-21 | Inyo | California | 6027 | 2504 | 44 |
1933795 | 1933795 | 2021-11-20 | Inyo | California | 6027 | 2504 | 44 |
1930543 | 1930543 | 2021-11-19 | Inyo | California | 6027 | 2504 | 44 |
1921203 | 1921203 | 2021-11-16 | Carroll | Illinois | 17015 | 2504 | 41 |
1921712 | 1921712 | 2021-11-16 | Webster | Kentucky | 21233 | 2504 | 38 |
1892248 | 1892248 | 2021-11-07 | Bourbon | Kansas | 20011 | 2504 | 43 |
1894461 | 1894461 | 2021-11-07 | Hardy | West Virginia | 54031 | 2504 | 31 |
1888998 | 1888998 | 2021-11-06 | Bourbon | Kansas | 20011 | 2504 | 43 |
1885748 | 1885748 | 2021-11-05 | Bourbon | Kansas | 20011 | 2504 | 43 |
1836617 | 1836617 | 2021-10-21 | Rabun | Georgia | 13241 | 2504 | 62 |
1828940 | 1828940 | 2021-10-18 | Lewis | Tennessee | 47101 | 2504 | 37 |
1829239 | 1829239 | 2021-10-18 | Zavala | Texas | 48507 | 2504 | 53 |
1803681 | 1803681 | 2021-10-11 | Washington | Alabama | 1129 | 2504 | 50 |
1800432 | 1800432 | 2021-10-10 | Washington | Alabama | 1129 | 2504 | 50 |
1782846 | 1782846 | 2021-10-04 | Northampton | North Carolina | 37131 | 2504 | 62 |
1775989 | 1775989 | 2021-10-02 | Wright | Missouri | 29229 | 2504 | 46 |
1769443 | 1769443 | 2021-09-30 | Moniteau | Missouri | 29135 | 2504 | 38 |
1770504 | 1770504 | 2021-09-30 | Aransas | Texas | 48007 | 2504 | 58 |
1767570 | 1767570 | 2021-09-29 | Buckingham | Virginia | 51029 | 2504 | 35 |
1736154 | 1736154 | 2021-09-20 | Perry | Indiana | 18123 | 2504 | 54 |
1721211 | 1721211 | 2021-09-15 | Carroll | Ohio | 39019 | 2504 | 51 |
1717729 | 1717729 | 2021-09-14 | Roosevelt | New Mexico | 35041 | 2504 | 65 |
1713650 | 1713650 | 2021-09-13 | Anderson | Kentucky | 21005 | 2504 | 31 |
1691280 | 1691280 | 2021-09-06 | Martin | Minnesota | 27091 | 2504 | 33 |
1688030 | 1688030 | 2021-09-05 | Martin | Minnesota | 27091 | 2504 | 33 |
1684780 | 1684780 | 2021-09-04 | Martin | Minnesota | 27091 | 2504 | 33 |
1681529 | 1681529 | 2021-09-03 | Martin | Minnesota | 27091 | 2504 | 33 |
1676785 | 1676785 | 2021-09-01 | Mason | West Virginia | 54053 | 2504 | 40 |
1672336 | 1672336 | 2021-08-31 | Caswell | North Carolina | 37033 | 2504 | 31 |
1667296 | 1667296 | 2021-08-30 | Cross | Arkansas | 5037 | 2504 | 58 |
1655486 | 1655486 | 2021-08-26 | Otsego | Michigan | 26137 | 2504 | 41 |
1652127 | 1652127 | 2021-08-25 | Somerset | Maine | 23025 | 2504 | 35 |
1644874 | 1644874 | 2021-08-23 | Elbert | Georgia | 13105 | 2504 | 74 |
1628357 | 1628357 | 2021-08-18 | Randolph | Arkansas | 5121 | 2504 | 50 |
1627483 | 1627483 | 2021-08-17 | Crockett | Tennessee | 47033 | 2504 | 52 |
1602006 | 1602006 | 2021-08-09 | Waynesboro city | Virginia | 51820 | 2504 | 39 |
1587125 | 1587125 | 2021-08-05 | St. James | Louisiana | 22093 | 2504 | 52 |
1579961 | 1579961 | 2021-08-03 | Pike | Georgia | 13231 | 2504 | 44 |
1537363 | 1537363 | 2021-07-21 | Columbia | Arkansas | 5027 | 2504 | 58 |
1534816 | 1534816 | 2021-07-20 | Dickinson | Iowa | 19059 | 2504 | 45 |
1531569 | 1531569 | 2021-07-19 | Dickinson | Iowa | 19059 | 2504 | 45 |
1533393 | 1533393 | 2021-07-19 | Burleson | Texas | 48051 | 2504 | 48 |
1528322 | 1528322 | 2021-07-18 | Dickinson | Iowa | 19059 | 2504 | 45 |
1530146 | 1530146 | 2021-07-18 | Burleson | Texas | 48051 | 2504 | 48 |
1525075 | 1525075 | 2021-07-17 | Dickinson | Iowa | 19059 | 2504 | 45 |
1526899 | 1526899 | 2021-07-17 | Burleson | Texas | 48051 | 2504 | 48 |
1521827 | 1521827 | 2021-07-16 | Dickinson | Iowa | 19059 | 2504 | 45 |
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);