ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 3104 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 18
- Indiana 13
- Illinois 10
- Texas 8
- Georgia 7
- Missouri 7
- Virginia 7
- Arkansas 6
- Mississippi 6
- Kentucky 5
- Puerto Rico 5
- Colorado 4
- Minnesota 4
- New York 4
- North Carolina 4
- Oklahoma 4
- South Carolina 4
- California 3
- Iowa 3
- Michigan 3
- Ohio 3
- Oregon 3
- Florida 2
- Louisiana 2
- North Dakota 2
- Pennsylvania 2
- Utah 2
- Idaho 1
- Maryland 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494449 | 2494449 | 2022-05-11 | Pope | Minnesota | 27121 | 3104 | 17 |
2337022 | 2337022 | 2022-03-24 | Plumas | California | 6063 | 3104 | 13 |
2259213 | 2259213 | 2022-02-28 | Jasper | Georgia | 13159 | 3104 | 68 |
2216193 | 2216193 | 2022-02-14 | Dickenson | Virginia | 51051 | 3104 | 40 |
2206146 | 2206146 | 2022-02-11 | Comanche | Texas | 48093 | 3104 | 75 |
2198531 | 2198531 | 2022-02-09 | Mississippi | Missouri | 29133 | 3104 | 56 |
2164715 | 2164715 | 2022-01-30 | Las Animas | Colorado | 8071 | 3104 | 38 |
2158204 | 2158204 | 2022-01-28 | Las Animas | Colorado | 8071 | 3104 | 38 |
2159981 | 2159981 | 2022-01-28 | Walsh | North Dakota | 38099 | 3104 | 34 |
2142355 | 2142355 | 2022-01-23 | Washington | Illinois | 17189 | 3104 | 37 |
2139100 | 2139100 | 2022-01-22 | Washington | Illinois | 17189 | 3104 | 37 |
2135844 | 2135844 | 2022-01-21 | Washington | Illinois | 17189 | 3104 | 37 |
2115292 | 2115292 | 2022-01-14 | Addison | Vermont | 50001 | 3104 | 10 |
2070279 | 2070279 | 2022-01-01 | Polk | Arkansas | 5113 | 3104 | 129 |
2072495 | 2072495 | 2022-01-01 | Moca | Puerto Rico | 72099 | 3104 | |
2069244 | 2069244 | 2021-12-31 | Moca | Puerto Rico | 72099 | 3104 | |
2031602 | 2031602 | 2021-12-20 | Meriwether | Georgia | 13199 | 3104 | 121 |
2015948 | 2015948 | 2021-12-15 | Morgan | Kentucky | 21175 | 3104 | 16 |
1997287 | 1997287 | 2021-12-09 | Currituck | North Carolina | 37053 | 3104 | 27 |
1997690 | 1997690 | 2021-12-09 | Aguadilla | Puerto Rico | 72005 | 3104 | |
1946773 | 1946773 | 2021-11-24 | Sharp | Arkansas | 5135 | 3104 | 70 |
1926208 | 1926208 | 2021-11-17 | Gurabo | Puerto Rico | 72063 | 3104 | |
1922958 | 1922958 | 2021-11-16 | Gurabo | Puerto Rico | 72063 | 3104 | |
1892044 | 1892044 | 2021-11-07 | Wayne | Illinois | 17191 | 3104 | 65 |
1888794 | 1888794 | 2021-11-06 | Wayne | Illinois | 17191 | 3104 | 65 |
1885544 | 1885544 | 2021-11-05 | Wayne | Illinois | 17191 | 3104 | 65 |
1881141 | 1881141 | 2021-11-03 | Montague | Texas | 48337 | 3104 | 94 |
1861736 | 1861736 | 2021-10-28 | Carbon | Utah | 49007 | 3104 | 30 |
1853652 | 1853652 | 2021-10-26 | Mason | Michigan | 26105 | 3104 | 47 |
1850403 | 1850403 | 2021-10-25 | Mason | Michigan | 26105 | 3104 | 47 |
1826764 | 1826764 | 2021-10-18 | Brantley | Georgia | 13025 | 3104 | 80 |
1823876 | 1823876 | 2021-10-17 | Owen | Indiana | 18119 | 3104 | 71 |
1825726 | 1825726 | 2021-10-17 | Unicoi | Tennessee | 47171 | 3104 | 64 |
1820627 | 1820627 | 2021-10-16 | Owen | Indiana | 18119 | 3104 | 71 |
1822477 | 1822477 | 2021-10-16 | Unicoi | Tennessee | 47171 | 3104 | 64 |
1817378 | 1817378 | 2021-10-15 | Owen | Indiana | 18119 | 3104 | 71 |
1819228 | 1819228 | 2021-10-15 | Unicoi | Tennessee | 47171 | 3104 | 64 |
1814469 | 1814469 | 2021-10-14 | Rockcastle | Kentucky | 21203 | 3104 | 28 |
1802981 | 1802981 | 2021-10-10 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1799732 | 1799732 | 2021-10-09 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1796483 | 1796483 | 2021-10-08 | Trousdale | Tennessee | 47169 | 3104 | 25 |
1766166 | 1766166 | 2021-09-29 | Henry | Missouri | 29083 | 3104 | 49 |
1764028 | 1764028 | 2021-09-28 | Burleson | Texas | 48051 | 3104 | 56 |
1748533 | 1748533 | 2021-09-24 | Lawrence | Arkansas | 5075 | 3104 | 50 |
1751217 | 1751217 | 2021-09-24 | Scurry | Texas | 48415 | 3104 | 75 |
1747080 | 1747080 | 2021-09-23 | Greene | North Carolina | 37079 | 3104 | 53 |
1737824 | 1737824 | 2021-09-20 | Fairfield | South Carolina | 45039 | 3104 | 88 |
1734382 | 1734382 | 2021-09-19 | Jefferson | Oregon | 41031 | 3104 | 46 |
1731132 | 1731132 | 2021-09-18 | Jefferson | Oregon | 41031 | 3104 | 46 |
1727882 | 1727882 | 2021-09-17 | Jefferson | Oregon | 41031 | 3104 | 46 |
1727964 | 1727964 | 2021-09-17 | Warren | Pennsylvania | 42123 | 3104 | 112 |
1720208 | 1720208 | 2021-09-15 | Letcher | Kentucky | 21133 | 3104 | 53 |
1708250 | 1708250 | 2021-09-11 | Holmes | Ohio | 39075 | 3104 | 103 |
1679704 | 1679704 | 2021-09-02 | Moore | Texas | 48341 | 3104 | 77 |
1630937 | 1630937 | 2021-08-18 | Karnes | Texas | 48255 | 3104 | 37 |
1625458 | 1625458 | 2021-08-17 | Sumter | Georgia | 13261 | 3104 | 107 |
1619176 | 1619176 | 2021-08-15 | Greene | Indiana | 18055 | 3104 | 89 |
1615928 | 1615928 | 2021-08-14 | Greene | Indiana | 18055 | 3104 | 89 |
1612679 | 1612679 | 2021-08-13 | Greene | Indiana | 18055 | 3104 | 89 |
1604822 | 1604822 | 2021-08-10 | Wayne | Tennessee | 47181 | 3104 | 36 |
1597135 | 1597135 | 2021-08-08 | Covington | Mississippi | 28031 | 3104 | 84 |
1598637 | 1598637 | 2021-08-08 | Amherst | Virginia | 51009 | 3104 | 40 |
1592652 | 1592652 | 2021-08-07 | Glenn | California | 6021 | 3104 | 27 |
1593886 | 1593886 | 2021-08-07 | Covington | Mississippi | 28031 | 3104 | 84 |
1595388 | 1595388 | 2021-08-07 | Amherst | Virginia | 51009 | 3104 | 40 |
1589403 | 1589403 | 2021-08-06 | Glenn | California | 6021 | 3104 | 27 |
1590637 | 1590637 | 2021-08-06 | Covington | Mississippi | 28031 | 3104 | 84 |
1592139 | 1592139 | 2021-08-06 | Amherst | Virginia | 51009 | 3104 | 40 |
1576926 | 1576926 | 2021-08-02 | Daviess | Indiana | 18027 | 3104 | 102 |
1561533 | 1561533 | 2021-07-28 | Miller | Missouri | 29131 | 3104 | 62 |
1553958 | 1553958 | 2021-07-26 | Lumpkin | Georgia | 13187 | 3104 | 82 |
1554638 | 1554638 | 2021-07-26 | Sabine | Louisiana | 22085 | 3104 | 64 |
1483543 | 1483543 | 2021-07-04 | Barry | Missouri | 29009 | 3104 | 47 |
1410259 | 1410259 | 2021-06-11 | Willacy | Texas | 48489 | 3104 | 89 |
1382803 | 1382803 | 2021-06-03 | Mille Lacs | Minnesota | 27095 | 3104 | 54 |
1350522 | 1350522 | 2021-05-24 | Lafayette | Missouri | 29107 | 3104 | 57 |
1347276 | 1347276 | 2021-05-23 | Lafayette | Missouri | 29107 | 3104 | 57 |
1337880 | 1337880 | 2021-05-20 | Washington | New York | 36115 | 3104 | 55 |
1316933 | 1316933 | 2021-05-14 | Dawson | Georgia | 13085 | 3104 | 45 |
1303003 | 1303003 | 2021-05-09 | Hopkins | Texas | 48223 | 3104 | 109 |
1298130 | 1298130 | 2021-05-08 | Taylor | Kentucky | 21217 | 3104 | 47 |
1276755 | 1276755 | 2021-05-01 | Union | South Carolina | 45087 | 3104 | 84 |
1267611 | 1267611 | 2021-04-28 | Wise | Virginia | 51195 | 3104 | 96 |
1261825 | 1261825 | 2021-04-27 | Stephens | Georgia | 13257 | 3104 | 81 |
1258855 | 1258855 | 2021-04-26 | White | Indiana | 18181 | 3104 | 55 |
1257354 | 1257354 | 2021-04-25 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1254107 | 1254107 | 2021-04-24 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1250860 | 1250860 | 2021-04-23 | Claiborne | Tennessee | 47025 | 3104 | 73 |
1237186 | 1237186 | 2021-04-19 | Chenango | New York | 36017 | 3104 | 74 |
1207578 | 1207578 | 2021-04-10 | Scott | Mississippi | 28123 | 3104 | 72 |
1200728 | 1200728 | 2021-04-08 | Allen | Louisiana | 22003 | 3104 | 91 |
1187237 | 1187237 | 2021-04-04 | Fayette | Illinois | 17051 | 3104 | 57 |
1182188 | 1182188 | 2021-04-02 | Champaign | Ohio | 39021 | 3104 | 53 |
1177435 | 1177435 | 2021-04-01 | Bonner | Idaho | 16017 | 3104 | 39 |
1154810 | 1154810 | 2021-03-25 | Perry | Illinois | 17145 | 3104 | 68 |
1141778 | 1141778 | 2021-03-21 | Fulton | Illinois | 17057 | 3104 | 57 |
1138069 | 1138069 | 2021-03-20 | Poinsett | Arkansas | 5111 | 3104 | 76 |
1127491 | 1127491 | 2021-03-16 | Lauderdale | Tennessee | 47097 | 3104 | 44 |
1124245 | 1124245 | 2021-03-15 | Lauderdale | Tennessee | 47097 | 3104 | 44 |
1120999 | 1120999 | 2021-03-14 | Lauderdale | Tennessee | 47097 | 3104 | 44 |
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);