ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 4712 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 22
- Oklahoma 8
- Texas 8
- North Carolina 7
- Georgia 6
- Indiana 6
- Wyoming 5
- Kentucky 4
- Michigan 4
- Missouri 4
- Colorado 3
- Idaho 3
- Illinois 3
- New York 3
- South Dakota 3
- Arkansas 2
- Minnesota 2
- Nebraska 2
- Puerto Rico 2
- Tennessee 2
- West Virginia 2
- Wisconsin 2
- California 1
- Mississippi 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- South Carolina 1
- Utah 1
- Vermont 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427032 | 2427032 | 2022-04-20 | Coamo | Puerto Rico | 72043 | 4712 | |
2404228 | 2404228 | 2022-04-13 | Barranquitas | Puerto Rico | 72019 | 4712 | |
2351768 | 2351768 | 2022-03-28 | Hertford | North Carolina | 37091 | 4712 | 81 |
2348516 | 2348516 | 2022-03-27 | Hertford | North Carolina | 37091 | 4712 | 81 |
2345263 | 2345263 | 2022-03-26 | Hertford | North Carolina | 37091 | 4712 | 81 |
2342010 | 2342010 | 2022-03-25 | Hertford | North Carolina | 37091 | 4712 | 81 |
2333816 | 2333816 | 2022-03-23 | Elbert | Colorado | 8039 | 4712 | 37 |
2323255 | 2323255 | 2022-03-19 | Gonzales | Texas | 48177 | 4712 | 96 |
2285541 | 2285541 | 2022-03-08 | Starke | Indiana | 18149 | 4712 | 94 |
2268348 | 2268348 | 2022-03-02 | Barbour | West Virginia | 54001 | 4712 | 74 |
2243103 | 2243103 | 2022-02-23 | Clay | Illinois | 17025 | 4712 | 70 |
2198713 | 2198713 | 2022-02-09 | Saunders | Nebraska | 31155 | 4712 | 26 |
2195459 | 2195459 | 2022-02-08 | Saunders | Nebraska | 31155 | 4712 | 26 |
2178705 | 2178705 | 2022-02-03 | Charlevoix | Michigan | 26029 | 4712 | 55 |
2175453 | 2175453 | 2022-02-02 | Charlevoix | Michigan | 26029 | 4712 | 55 |
2154251 | 2154251 | 2022-01-26 | Scurry | Texas | 48415 | 4712 | 95 |
2151129 | 2151129 | 2022-01-25 | Dinwiddie | Virginia | 51053 | 4712 | 63 |
2126193 | 2126193 | 2022-01-18 | Bremer | Iowa | 19017 | 4712 | 75 |
2126237 | 2126237 | 2022-01-18 | Jones | Iowa | 19105 | 4712 | 68 |
2122941 | 2122941 | 2022-01-17 | Bremer | Iowa | 19017 | 4712 | 75 |
2122985 | 2122985 | 2022-01-17 | Jones | Iowa | 19105 | 4712 | 68 |
2119689 | 2119689 | 2022-01-16 | Bremer | Iowa | 19017 | 4712 | 75 |
2119733 | 2119733 | 2022-01-16 | Jones | Iowa | 19105 | 4712 | 68 |
2116437 | 2116437 | 2022-01-15 | Bremer | Iowa | 19017 | 4712 | 75 |
2116481 | 2116481 | 2022-01-15 | Jones | Iowa | 19105 | 4712 | 68 |
2113186 | 2113186 | 2022-01-14 | Bremer | Iowa | 19017 | 4712 | 75 |
2113230 | 2113230 | 2022-01-14 | Jones | Iowa | 19105 | 4712 | 68 |
2109934 | 2109934 | 2022-01-13 | Bremer | Iowa | 19017 | 4712 | 75 |
2109978 | 2109978 | 2022-01-13 | Jones | Iowa | 19105 | 4712 | 68 |
2112255 | 2112255 | 2022-01-13 | Mason | West Virginia | 54053 | 4712 | 73 |
2106683 | 2106683 | 2022-01-12 | Bremer | Iowa | 19017 | 4712 | 75 |
2106727 | 2106727 | 2022-01-12 | Jones | Iowa | 19105 | 4712 | 68 |
2096894 | 2096894 | 2022-01-09 | Posey | Indiana | 18129 | 4712 | 46 |
2093642 | 2093642 | 2022-01-08 | Posey | Indiana | 18129 | 4712 | 46 |
2090390 | 2090390 | 2022-01-07 | Posey | Indiana | 18129 | 4712 | 46 |
1973242 | 1973242 | 2021-12-02 | Iroquois | Illinois | 17075 | 4712 | 85 |
1950433 | 1950433 | 2021-11-25 | Latah | Idaho | 16057 | 4712 | 40 |
1947182 | 1947182 | 2021-11-24 | Latah | Idaho | 16057 | 4712 | 40 |
1944433 | 1944433 | 2021-11-23 | Montgomery | Kentucky | 21173 | 4712 | 61 |
1904532 | 1904532 | 2021-11-11 | Yell | Arkansas | 5149 | 4712 | 80 |
1898717 | 1898717 | 2021-11-09 | Plymouth | Iowa | 19149 | 4712 | 88 |
1895467 | 1895467 | 2021-11-08 | Plymouth | Iowa | 19149 | 4712 | 88 |
1892217 | 1892217 | 2021-11-07 | Plymouth | Iowa | 19149 | 4712 | 88 |
1888967 | 1888967 | 2021-11-06 | Plymouth | Iowa | 19149 | 4712 | 88 |
1885717 | 1885717 | 2021-11-05 | Plymouth | Iowa | 19149 | 4712 | 88 |
1882468 | 1882468 | 2021-11-04 | Plymouth | Iowa | 19149 | 4712 | 88 |
1879219 | 1879219 | 2021-11-03 | Plymouth | Iowa | 19149 | 4712 | 88 |
1878275 | 1878275 | 2021-11-02 | Green | Wisconsin | 55045 | 4712 | 33 |
1872301 | 1872301 | 2021-11-01 | Gilmer | Georgia | 13123 | 4712 | 135 |
1692626 | 1692626 | 2021-09-06 | Grimes | Texas | 48185 | 4712 | 79 |
1669253 | 1669253 | 2021-08-30 | Fulton | Ohio | 39051 | 4712 | 79 |
1649550 | 1649550 | 2021-08-24 | Livingston | New York | 36051 | 4712 | 60 |
1620920 | 1620920 | 2021-08-15 | Codington | South Dakota | 46029 | 4712 | 82 |
1617672 | 1617672 | 2021-08-14 | Codington | South Dakota | 46029 | 4712 | 82 |
1614424 | 1614424 | 2021-08-13 | Codington | South Dakota | 46029 | 4712 | 82 |
1614644 | 1614644 | 2021-08-13 | Erath | Texas | 48143 | 4712 | 71 |
1599710 | 1599710 | 2021-08-09 | Montgomery | Indiana | 18107 | 4712 | 94 |
1582191 | 1582191 | 2021-08-03 | Hill | Texas | 48217 | 4712 | 111 |
1558332 | 1558332 | 2021-07-27 | Webster | Missouri | 29225 | 4712 | 62 |
1543712 | 1543712 | 2021-07-22 | Albany | Wyoming | 56001 | 4712 | 18 |
1463622 | 1463622 | 2021-06-28 | Hopkins | Kentucky | 21107 | 4712 | 149 |
1460698 | 1460698 | 2021-06-27 | Mower | Minnesota | 27099 | 4712 | 33 |
1449583 | 1449583 | 2021-06-23 | Sweetwater | Wyoming | 56037 | 4712 | 40 |
1445265 | 1445265 | 2021-06-22 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1442020 | 1442020 | 2021-06-21 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1443040 | 1443040 | 2021-06-21 | Marinette | Wisconsin | 55075 | 4712 | 73 |
1438775 | 1438775 | 2021-06-20 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1435528 | 1435528 | 2021-06-19 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1432281 | 1432281 | 2021-06-18 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1429035 | 1429035 | 2021-06-17 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1425790 | 1425790 | 2021-06-16 | Delaware | Oklahoma | 40041 | 4712 | 94 |
1350951 | 1350951 | 2021-05-24 | Richmond | North Carolina | 37153 | 4712 | 96 |
1340574 | 1340574 | 2021-05-21 | Douglas | Minnesota | 27041 | 4712 | 78 |
1270452 | 1270452 | 2021-04-29 | Burnet | Texas | 48053 | 4712 | 63 |
1198808 | 1198808 | 2021-04-07 | Newberry | South Carolina | 45071 | 4712 | 97 |
1191452 | 1191452 | 2021-04-05 | Scott | Missouri | 29201 | 4712 | 83 |
1188204 | 1188204 | 2021-04-04 | Scott | Missouri | 29201 | 4712 | 83 |
1159234 | 1159234 | 2021-03-26 | Cattaraugus | New York | 36009 | 4712 | 79 |
1144376 | 1144376 | 2021-03-21 | Campbell | Wyoming | 56005 | 4712 | 59 |
1138642 | 1138642 | 2021-03-20 | Jackson | Indiana | 18071 | 4712 | 68 |
1141129 | 1141129 | 2021-03-20 | Campbell | Wyoming | 56005 | 4712 | 59 |
1135748 | 1135748 | 2021-03-19 | Nelson | Kentucky | 21179 | 4712 | 49 |
1137883 | 1137883 | 2021-03-19 | Campbell | Wyoming | 56005 | 4712 | 59 |
1086488 | 1086488 | 2021-03-04 | Tift | Georgia | 13277 | 4712 | 120 |
1062219 | 1062219 | 2021-02-24 | Washington | Oklahoma | 40147 | 4712 | 84 |
1056415 | 1056415 | 2021-02-22 | Chittenden | Vermont | 50007 | 4712 | 85 |
1038155 | 1038155 | 2021-02-17 | Sioux | Iowa | 19167 | 4712 | 67 |
1027170 | 1027170 | 2021-02-13 | Box Elder | Utah | 49003 | 4712 | 41 |
1009959 | 1009959 | 2021-02-08 | St. Lawrence | New York | 36089 | 4712 | 73 |
969621 | 969621 | 2021-01-27 | Polk | Georgia | 13233 | 4712 | 63 |
971072 | 971072 | 2021-01-27 | Lee | North Carolina | 37105 | 4712 | 56 |
966140 | 966140 | 2021-01-26 | Garfield | Colorado | 8045 | 4712 | 36 |
963275 | 963275 | 2021-01-25 | Knox | Illinois | 17095 | 4712 | 147 |
962014 | 962014 | 2021-01-24 | Bastrop | Texas | 48021 | 4712 | 58 |
958769 | 958769 | 2021-01-23 | Bastrop | Texas | 48021 | 4712 | 58 |
937087 | 937087 | 2021-01-17 | Coffee | Georgia | 13069 | 4712 | 110 |
923926 | 923926 | 2021-01-13 | Yuba | California | 6115 | 4712 | 26 |
921516 | 921516 | 2021-01-12 | McCracken | Kentucky | 21145 | 4712 | 46 |
917704 | 917704 | 2021-01-11 | Rockdale | Georgia | 13247 | 4712 | 83 |
910830 | 910830 | 2021-01-09 | Crittenden | Arkansas | 5035 | 4712 | 77 |
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);