ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 5825 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Wisconsin 13
- Oklahoma 9
- Texas 7
- Indiana 6
- California 5
- North Carolina 5
- Ohio 5
- Puerto Rico 5
- Tennessee 5
- Alabama 4
- Virginia 4
- Arkansas 3
- Kentucky 3
- Michigan 3
- Minnesota 3
- New York 3
- Pennsylvania 3
- Illinois 2
- Louisiana 2
- Mississippi 2
- Missouri 2
- New Jersey 2
- West Virginia 2
- Alaska 1
- Colorado 1
- Idaho 1
- Montana 1
- New Mexico 1
- North Dakota 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2408255 | 2408255 | 2022-04-14 | Hampshire | West Virginia | 54027 | 5825 | 71 |
2388316 | 2388316 | 2022-04-08 | Frio | Texas | 48163 | 5825 | 93 |
2379029 | 2379029 | 2022-04-05 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2359510 | 2359510 | 2022-03-30 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2356256 | 2356256 | 2022-03-29 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2353003 | 2353003 | 2022-03-28 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2349751 | 2349751 | 2022-03-27 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2346498 | 2346498 | 2022-03-26 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2343245 | 2343245 | 2022-03-25 | Kewaunee | Wisconsin | 55061 | 5825 | 59 |
2339992 | 2339992 | 2022-03-24 | Kewaunee | Wisconsin | 55061 | 5825 | 58 |
2334314 | 2334314 | 2022-03-23 | Owen | Indiana | 18119 | 5825 | 118 |
2326979 | 2326979 | 2022-03-20 | Kewaunee | Wisconsin | 55061 | 5825 | 58 |
2323726 | 2323726 | 2022-03-19 | Kewaunee | Wisconsin | 55061 | 5825 | 58 |
2320472 | 2320472 | 2022-03-18 | Kewaunee | Wisconsin | 55061 | 5825 | 58 |
2297945 | 2297945 | 2022-03-12 | Sevier | Arkansas | 5133 | 5825 | 70 |
2294693 | 2294693 | 2022-03-11 | Sevier | Arkansas | 5133 | 5825 | 70 |
2270879 | 2270879 | 2022-03-03 | Manati | Puerto Rico | 72091 | 5825 | |
2266389 | 2266389 | 2022-03-02 | Grant | Louisiana | 22043 | 5825 | 86 |
2268433 | 2268433 | 2022-03-02 | Kewaunee | Wisconsin | 55061 | 5825 | 55 |
2246488 | 2246488 | 2022-02-24 | LaGrange | Indiana | 18087 | 5825 | 102 |
2243237 | 2243237 | 2022-02-23 | LaGrange | Indiana | 18087 | 5825 | 102 |
2239986 | 2239986 | 2022-02-22 | LaGrange | Indiana | 18087 | 5825 | 100 |
2236735 | 2236735 | 2022-02-21 | LaGrange | Indiana | 18087 | 5825 | 100 |
2189167 | 2189167 | 2022-02-06 | Martin | North Carolina | 37117 | 5825 | 80 |
2185914 | 2185914 | 2022-02-05 | Martin | North Carolina | 37117 | 5825 | 80 |
2181282 | 2181282 | 2022-02-04 | Jefferson | Idaho | 16051 | 5825 | 57 |
2182662 | 2182662 | 2022-02-04 | Martin | North Carolina | 37117 | 5825 | 80 |
2163588 | 2163588 | 2022-01-29 | Vega Alta | Puerto Rico | 72143 | 5825 | |
2146744 | 2146744 | 2022-01-24 | Luna | New Mexico | 35029 | 5825 | 110 |
2134242 | 2134242 | 2022-01-20 | Canovanas | Puerto Rico | 72029 | 5825 | |
2111225 | 2111225 | 2022-01-13 | Hardin | Ohio | 39065 | 5825 | 124 |
2092926 | 2092926 | 2022-01-08 | Pike | Alabama | 1109 | 5825 | 112 |
2079642 | 2079642 | 2022-01-03 | Prince George | Virginia | 51149 | 5825 | 52 |
2016763 | 2016763 | 2021-12-15 | Wyoming | New York | 36121 | 5825 | 72 |
2007730 | 2007730 | 2021-12-12 | White | Tennessee | 47185 | 5825 | 102 |
2004479 | 2004479 | 2021-12-11 | White | Tennessee | 47185 | 5825 | 102 |
1998613 | 1998613 | 2021-12-10 | Chambers | Alabama | 1017 | 5825 | 143 |
2001228 | 2001228 | 2021-12-10 | White | Tennessee | 47185 | 5825 | 102 |
1995362 | 1995362 | 2021-12-09 | Chambers | Alabama | 1017 | 5825 | 143 |
1992783 | 1992783 | 2021-12-08 | Randolph | Illinois | 17157 | 5825 | 110 |
1981503 | 1981503 | 2021-12-04 | Toa Alta | Puerto Rico | 72135 | 5825 | |
1883925 | 1883925 | 2021-11-04 | Wayne | Pennsylvania | 42127 | 5825 | 112 |
1852469 | 1852469 | 2021-10-26 | Baxter | Arkansas | 5005 | 5825 | 177 |
1791720 | 1791720 | 2021-10-07 | Perry | Kentucky | 21193 | 5825 | 84 |
1781529 | 1781529 | 2021-10-04 | Livingston | Illinois | 17105 | 5825 | 108 |
1763447 | 1763447 | 2021-09-28 | Brown | Ohio | 39015 | 5825 | 72 |
1737455 | 1737455 | 2021-09-20 | Auglaize | Ohio | 39011 | 5825 | 88 |
1734197 | 1734197 | 2021-09-19 | Williams | North Dakota | 38105 | 5825 | 43 |
1695260 | 1695260 | 2021-09-07 | Knox | Ohio | 39083 | 5825 | 120 |
1654385 | 1654385 | 2021-08-26 | Mendocino | California | 6045 | 5825 | 60 |
1632979 | 1632979 | 2021-08-19 | Johnson | Missouri | 29101 | 5825 | 61 |
1630739 | 1630739 | 2021-08-18 | Franklin | Tennessee | 47051 | 5825 | 92 |
1594558 | 1594558 | 2021-08-07 | Jefferson | Ohio | 39081 | 5825 | 162 |
1588858 | 1588858 | 2021-08-05 | Summit | Utah | 49043 | 5825 | 15 |
1579672 | 1579672 | 2021-08-03 | Nevada | California | 6057 | 5825 | 73 |
1581861 | 1581861 | 2021-08-03 | Unknown | Puerto Rico | 5825 | 2585 | |
1552128 | 1552128 | 2021-07-25 | Wayne | New York | 36117 | 5825 | 73 |
1408723 | 1408723 | 2021-06-11 | Benton | Minnesota | 27009 | 5825 | 98 |
1339964 | 1339964 | 2021-05-21 | Henry | Indiana | 18065 | 5825 | 107 |
1329037 | 1329037 | 2021-05-17 | Navarro | Texas | 48349 | 5825 | 154 |
1329173 | 1329173 | 2021-05-17 | Augusta | Virginia | 51015 | 5825 | 71 |
1325791 | 1325791 | 2021-05-16 | Navarro | Texas | 48349 | 5825 | 154 |
1322545 | 1322545 | 2021-05-15 | Navarro | Texas | 48349 | 5825 | 154 |
1307029 | 1307029 | 2021-05-11 | Garfield | Colorado | 8045 | 5825 | 38 |
1296040 | 1296040 | 2021-05-07 | Armstrong | Pennsylvania | 42005 | 5825 | 133 |
1253890 | 1253890 | 2021-04-24 | Union | Pennsylvania | 42119 | 5825 | 86 |
1251475 | 1251475 | 2021-04-23 | Barron | Wisconsin | 55005 | 5825 | 77 |
1224192 | 1224192 | 2021-04-15 | Cayuga | New York | 36011 | 5825 | 90 |
1202744 | 1202744 | 2021-04-08 | Raleigh | West Virginia | 54081 | 5825 | 74 |
1149802 | 1149802 | 2021-03-23 | Carter | Oklahoma | 40019 | 5825 | 65 |
1146555 | 1146555 | 2021-03-22 | Carter | Oklahoma | 40019 | 5825 | 65 |
1143308 | 1143308 | 2021-03-21 | Carter | Oklahoma | 40019 | 5825 | 65 |
1140061 | 1140061 | 2021-03-20 | Carter | Oklahoma | 40019 | 5825 | 65 |
1136815 | 1136815 | 2021-03-19 | Carter | Oklahoma | 40019 | 5825 | 65 |
1133569 | 1133569 | 2021-03-18 | Carter | Oklahoma | 40019 | 5825 | 65 |
1130321 | 1130321 | 2021-03-17 | Carter | Oklahoma | 40019 | 5825 | 65 |
1127074 | 1127074 | 2021-03-16 | Carter | Oklahoma | 40019 | 5825 | 65 |
1123828 | 1123828 | 2021-03-15 | Carter | Oklahoma | 40019 | 5825 | 63 |
1096799 | 1096799 | 2021-03-07 | Pulaski | Kentucky | 21199 | 5825 | 88 |
1083795 | 1083795 | 2021-03-03 | McCracken | Kentucky | 21145 | 5825 | 71 |
1074906 | 1074906 | 2021-02-28 | Columbus | North Carolina | 37047 | 5825 | 142 |
1071660 | 1071660 | 2021-02-27 | Columbus | North Carolina | 37047 | 5825 | 142 |
1020836 | 1020836 | 2021-02-11 | Rockingham | Virginia | 51165 | 5825 | 76 |
994385 | 994385 | 2021-02-03 | Dickson | Tennessee | 47043 | 5825 | 92 |
976871 | 976871 | 2021-01-29 | Eaton | Michigan | 26045 | 5825 | 132 |
973999 | 973999 | 2021-01-28 | Lewis and Clark | Montana | 30049 | 5825 | 60 |
971832 | 971832 | 2021-01-27 | Hale | Texas | 48189 | 5825 | 143 |
967683 | 967683 | 2021-01-26 | Warren | New Jersey | 34041 | 5825 | 197 |
968587 | 968587 | 2021-01-26 | Hale | Texas | 48189 | 5825 | 141 |
917253 | 917253 | 2021-01-11 | Talladega | Alabama | 1121 | 5825 | 109 |
912150 | 912150 | 2021-01-09 | Jones | Mississippi | 28067 | 5825 | 101 |
849124 | 849124 | 2020-12-21 | Matanuska-Susitna Borough | Alaska | 2170 | 5825 | 11 |
756204 | 756204 | 2020-11-22 | Jackson | Michigan | 26075 | 5825 | 110 |
752958 | 752958 | 2020-11-21 | Jackson | Michigan | 26075 | 5825 | 110 |
746346 | 746346 | 2020-11-19 | Rapides | Louisiana | 22079 | 5825 | 180 |
665491 | 665491 | 2020-10-25 | Stearns | Minnesota | 27145 | 5825 | 43 |
627784 | 627784 | 2020-10-13 | Bell | Texas | 48027 | 5825 | 94 |
600643 | 600643 | 2020-10-05 | DeSoto | Mississippi | 28033 | 5825 | 70 |
528184 | 528184 | 2020-09-13 | Solano | California | 6095 | 5825 | 48 |
524948 | 524948 | 2020-09-12 | Solano | California | 6095 | 5825 | 48 |
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);