ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where cases = 4528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 9
- Georgia 8
- Texas 8
- New York 7
- Indiana 6
- Puerto Rico 6
- Illinois 5
- Missouri 5
- North Carolina 5
- Washington 5
- Louisiana 4
- Ohio 4
- West Virginia 4
- Arkansas 3
- California 3
- Colorado 3
- Michigan 3
- Mississippi 3
- Montana 3
- South Carolina 3
- Kansas 2
- New Jersey 2
- Oklahoma 2
- Tennessee 2
- Alabama 1
- Florida 1
- Idaho 1
- Kentucky 1
- Maryland 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500082 | 2500082 | 2022-05-13 | Putnam | Georgia | 13237 | 4528 | 106 |
2496824 | 2496824 | 2022-05-12 | Putnam | Georgia | 13237 | 4528 | 106 |
2493566 | 2493566 | 2022-05-11 | Putnam | Georgia | 13237 | 4528 | 106 |
2490622 | 2490622 | 2022-05-10 | Crawford | Iowa | 19047 | 4528 | 54 |
2487365 | 2487365 | 2022-05-09 | Crawford | Iowa | 19047 | 4528 | 54 |
2488945 | 2488945 | 2022-05-09 | San German | Puerto Rico | 72125 | 4528 | |
2484107 | 2484107 | 2022-05-08 | Crawford | Iowa | 19047 | 4528 | 54 |
2480849 | 2480849 | 2022-05-07 | Crawford | Iowa | 19047 | 4528 | 54 |
2477591 | 2477591 | 2022-05-06 | Crawford | Iowa | 19047 | 4528 | 54 |
2474333 | 2474333 | 2022-05-05 | Crawford | Iowa | 19047 | 4528 | 54 |
2471076 | 2471076 | 2022-05-04 | Crawford | Iowa | 19047 | 4528 | 54 |
2430996 | 2430996 | 2022-04-21 | Asotin | Washington | 53003 | 4528 | 65 |
2431079 | 2431079 | 2022-04-21 | Taylor | West Virginia | 54091 | 4528 | 73 |
2427740 | 2427740 | 2022-04-20 | Asotin | Washington | 53003 | 4528 | 65 |
2362402 | 2362402 | 2022-03-31 | Robertson | Texas | 48395 | 4528 | 76 |
2333051 | 2333051 | 2022-03-22 | Jones | Texas | 48253 | 4528 | 92 |
2329798 | 2329798 | 2022-03-21 | Jones | Texas | 48253 | 4528 | 92 |
2305908 | 2305908 | 2022-03-14 | Hill | Montana | 30041 | 4528 | 71 |
2303385 | 2303385 | 2022-03-13 | Guayama | Puerto Rico | 72057 | 4528 | |
2300133 | 2300133 | 2022-03-12 | Guayama | Puerto Rico | 72057 | 4528 | |
2294075 | 2294075 | 2022-03-10 | Panola | Texas | 48365 | 4528 | 128 |
2289649 | 2289649 | 2022-03-09 | Hill | Montana | 30041 | 4528 | 71 |
2284962 | 2284962 | 2022-03-08 | Inyo | California | 6027 | 4528 | 56 |
2283145 | 2283145 | 2022-03-07 | Hill | Montana | 30041 | 4528 | 71 |
2221082 | 2221082 | 2022-02-16 | Fillmore | Minnesota | 27045 | 4528 | 22 |
2222833 | 2222833 | 2022-02-16 | Barbour | West Virginia | 54001 | 4528 | 67 |
2197575 | 2197575 | 2022-02-09 | Cass | Illinois | 17017 | 4528 | 43 |
2197731 | 2197731 | 2022-02-09 | Perry | Indiana | 18123 | 4528 | 64 |
2194477 | 2194477 | 2022-02-08 | Perry | Indiana | 18123 | 4528 | 64 |
2190060 | 2190060 | 2022-02-06 | Unknown | Texas | 4528 | 0 | |
2178725 | 2178725 | 2022-02-03 | Iosco | Michigan | 26069 | 4528 | 128 |
2175473 | 2175473 | 2022-02-02 | Iosco | Michigan | 26069 | 4528 | 128 |
2153860 | 2153860 | 2022-01-26 | Hampton | South Carolina | 45049 | 4528 | 76 |
2111837 | 2111837 | 2022-01-13 | Frio | Texas | 48163 | 4528 | 80 |
2098197 | 2098197 | 2022-01-09 | Carroll | Ohio | 39019 | 4528 | 98 |
2084616 | 2084616 | 2022-01-05 | Adair | Missouri | 29001 | 4528 | 53 |
2080553 | 2080553 | 2022-01-04 | Shelby | Illinois | 17173 | 4528 | 60 |
2075728 | 2075728 | 2022-01-02 | Gurabo | Puerto Rico | 72063 | 4528 | |
2052711 | 2052711 | 2021-12-26 | Hocking | Ohio | 39073 | 4528 | 95 |
2017266 | 2017266 | 2021-12-15 | Vega Baja | Puerto Rico | 72145 | 4528 | |
2007204 | 2007204 | 2021-12-12 | Henry | Ohio | 39069 | 4528 | 81 |
2001340 | 2001340 | 2021-12-10 | Hockley | Texas | 48219 | 4528 | 138 |
1986672 | 1986672 | 2021-12-06 | Lincoln | Kentucky | 21137 | 4528 | 105 |
1971911 | 1971911 | 2021-12-01 | Grainger | Tennessee | 47057 | 4528 | 71 |
1895371 | 1895371 | 2021-11-08 | Scott | Indiana | 18143 | 4528 | 78 |
1823529 | 1823529 | 2021-10-17 | Chattooga | Georgia | 13055 | 4528 | 99 |
1820280 | 1820280 | 2021-10-16 | Chattooga | Georgia | 13055 | 4528 | 99 |
1817031 | 1817031 | 2021-10-15 | Chattooga | Georgia | 13055 | 4528 | 99 |
1808421 | 1808421 | 2021-10-12 | Lafayette | Missouri | 29107 | 4528 | 71 |
1801784 | 1801784 | 2021-10-10 | Adams | Mississippi | 28001 | 4528 | 119 |
1798535 | 1798535 | 2021-10-09 | Adams | Mississippi | 28001 | 4528 | 119 |
1795286 | 1795286 | 2021-10-08 | Adams | Mississippi | 28001 | 4528 | 119 |
1774561 | 1774561 | 2021-10-02 | Yell | Arkansas | 5149 | 4528 | 76 |
1751525 | 1751525 | 2021-09-24 | Randolph | West Virginia | 54083 | 4528 | 28 |
1739865 | 1739865 | 2021-09-21 | Worcester | Maryland | 24047 | 4528 | 112 |
1732150 | 1732150 | 2021-09-19 | Clarke | Alabama | 1025 | 4528 | 71 |
1723998 | 1723998 | 2021-09-16 | Warren | Missouri | 29219 | 4528 | 39 |
1725512 | 1725512 | 2021-09-16 | Marshall | West Virginia | 54051 | 4528 | 92 |
1716058 | 1716058 | 2021-09-14 | Poinsett | Arkansas | 5111 | 4528 | 94 |
1676243 | 1676243 | 2021-09-01 | Macon | Tennessee | 47111 | 4528 | 80 |
1652841 | 1652841 | 2021-08-25 | Bladen | North Carolina | 37017 | 4528 | 71 |
1602940 | 1602940 | 2021-08-10 | Huntington | Indiana | 18069 | 4528 | 84 |
1559154 | 1559154 | 2021-07-27 | Dillon | South Carolina | 45033 | 4528 | 85 |
1551353 | 1551353 | 2021-07-25 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1548106 | 1548106 | 2021-07-24 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1544859 | 1544859 | 2021-07-23 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1541201 | 1541201 | 2021-07-22 | Clinton | Indiana | 18023 | 4528 | 60 |
1519702 | 1519702 | 2021-07-15 | Haywood | North Carolina | 37087 | 4528 | 99 |
1508655 | 1508655 | 2021-07-12 | Jefferson | Illinois | 17081 | 4528 | 123 |
1489716 | 1489716 | 2021-07-06 | Washington | Louisiana | 22117 | 4528 | 134 |
1454701 | 1454701 | 2021-06-25 | Livingston | New York | 36051 | 4528 | 60 |
1449785 | 1449785 | 2021-06-24 | Humboldt | California | 6023 | 4528 | 49 |
1451456 | 1451456 | 2021-06-24 | Livingston | New York | 36051 | 4528 | 60 |
1420199 | 1420199 | 2021-06-14 | Grays Harbor | Washington | 53027 | 4528 | 74 |
1416954 | 1416954 | 2021-06-13 | Grays Harbor | Washington | 53027 | 4528 | 74 |
1413708 | 1413708 | 2021-06-12 | Grays Harbor | Washington | 53027 | 4528 | 74 |
1364686 | 1364686 | 2021-05-28 | Hill | Texas | 48217 | 4528 | 109 |
1355160 | 1355160 | 2021-05-25 | Campbell | Virginia | 51031 | 4528 | 89 |
1307156 | 1307156 | 2021-05-11 | Baldwin | Georgia | 13009 | 4528 | 128 |
1245325 | 1245325 | 2021-04-22 | Broomfield | Colorado | 8014 | 4528 | 75 |
1236021 | 1236021 | 2021-04-19 | Stephenson | Illinois | 17177 | 4528 | 99 |
1237255 | 1237255 | 2021-04-19 | Chatham | North Carolina | 37037 | 4528 | 87 |
1230692 | 1230692 | 2021-04-17 | Clinton | New York | 36019 | 4528 | 32 |
1168385 | 1168385 | 2021-03-29 | Cass | Michigan | 26027 | 4528 | 68 |
1143551 | 1143551 | 2021-03-21 | Unknown | Puerto Rico | 4528 | 2096 | |
1138528 | 1138528 | 2021-03-20 | Effingham | Illinois | 17049 | 4528 | 80 |
1131972 | 1131972 | 2021-03-18 | Bingham | Idaho | 16011 | 4528 | 66 |
1110533 | 1110533 | 2021-03-11 | Cattaraugus | New York | 36009 | 4528 | 78 |
1094352 | 1094352 | 2021-03-06 | Wayne | New York | 36117 | 4528 | 65 |
1086875 | 1086875 | 2021-03-04 | Crawford | Kansas | 20037 | 4528 | 80 |
1083629 | 1083629 | 2021-03-03 | Crawford | Kansas | 20037 | 4528 | 80 |
1049293 | 1049293 | 2021-02-20 | Columbia | Pennsylvania | 42037 | 4528 | 122 |
1044004 | 1044004 | 2021-02-19 | Tehama | California | 6103 | 4528 | 51 |
1023264 | 1023264 | 2021-02-12 | Stephens | Oklahoma | 40137 | 4528 | 57 |
940176 | 940176 | 2021-01-18 | Garfield | Colorado | 8045 | 4528 | 35 |
932051 | 932051 | 2021-01-15 | Ontario | New York | 36069 | 4528 | 77 |
918003 | 918003 | 2021-01-11 | Cerro Gordo | Iowa | 19033 | 4528 | 64 |
901701 | 901701 | 2021-01-06 | Henry | Indiana | 18065 | 4528 | 61 |
872024 | 872024 | 2020-12-28 | Fremont | Colorado | 8043 | 4528 | 17 |
861983 | 861983 | 2020-12-24 | Sauk | Wisconsin | 55111 | 4528 | 31 |
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);