ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 4572 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 9
- Texas 9
- Florida 8
- Mississippi 8
- Iowa 7
- Georgia 6
- Louisiana 6
- Puerto Rico 6
- Arkansas 5
- Michigan 5
- Missouri 5
- Ohio 5
- Kentucky 4
- Nebraska 4
- Indiana 3
- Minnesota 3
- New York 3
- Pennsylvania 3
- Tennessee 3
- Wyoming 3
- North Carolina 2
- North Dakota 2
- Alaska 1
- California 1
- Idaho 1
- Illinois 1
- Massachusetts 1
- New Hampshire 1
- Oregon 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473545 | 2473545 | 2022-05-05 | Henry | Alabama | 1067 | 4572 | 76 |
2475867 | 2475867 | 2022-05-05 | Catano | Puerto Rico | 72033 | 4572 | |
2470288 | 2470288 | 2022-05-04 | Henry | Alabama | 1067 | 4572 | 76 |
2463777 | 2463777 | 2022-05-02 | Henry | Alabama | 1067 | 4572 | 75 |
2460521 | 2460521 | 2022-05-01 | Henry | Alabama | 1067 | 4572 | 75 |
2457265 | 2457265 | 2022-04-30 | Henry | Alabama | 1067 | 4572 | 75 |
2454009 | 2454009 | 2022-04-29 | Henry | Alabama | 1067 | 4572 | 75 |
2450753 | 2450753 | 2022-04-28 | Henry | Alabama | 1067 | 4572 | 75 |
2447497 | 2447497 | 2022-04-27 | Henry | Alabama | 1067 | 4572 | 75 |
2445970 | 2445970 | 2022-04-26 | Washington | Nebraska | 31177 | 4572 | 43 |
2332532 | 2332532 | 2022-03-22 | Clatsop | Oregon | 41007 | 4572 | 41 |
2329854 | 2329854 | 2022-03-21 | Panola | Texas | 48365 | 4572 | 129 |
2326602 | 2326602 | 2022-03-20 | Panola | Texas | 48365 | 4572 | 129 |
2323349 | 2323349 | 2022-03-19 | Panola | Texas | 48365 | 4572 | 129 |
2308783 | 2308783 | 2022-03-15 | Cheboygan | Michigan | 26031 | 4572 | 102 |
2305532 | 2305532 | 2022-03-14 | Cheboygan | Michigan | 26031 | 4572 | 102 |
2302280 | 2302280 | 2022-03-13 | Cheboygan | Michigan | 26031 | 4572 | 101 |
2299028 | 2299028 | 2022-03-12 | Cheboygan | Michigan | 26031 | 4572 | 101 |
2295776 | 2295776 | 2022-03-11 | Cheboygan | Michigan | 26031 | 4572 | 101 |
2262840 | 2262840 | 2022-03-01 | Jackson | Iowa | 19097 | 4572 | 67 |
2258921 | 2258921 | 2022-02-28 | Sharp | Arkansas | 5135 | 4572 | 98 |
2259589 | 2259589 | 2022-02-28 | Jackson | Iowa | 19097 | 4572 | 67 |
2255670 | 2255670 | 2022-02-27 | Sharp | Arkansas | 5135 | 4572 | 98 |
2256338 | 2256338 | 2022-02-27 | Jackson | Iowa | 19097 | 4572 | 67 |
2253087 | 2253087 | 2022-02-26 | Jackson | Iowa | 19097 | 4572 | 67 |
2254589 | 2254589 | 2022-02-26 | Camuy | Puerto Rico | 72027 | 4572 | |
2249836 | 2249836 | 2022-02-25 | Jackson | Iowa | 19097 | 4572 | 67 |
2246585 | 2246585 | 2022-02-24 | Jackson | Iowa | 19097 | 4572 | 67 |
2248971 | 2248971 | 2022-02-24 | Carbon | Wyoming | 56007 | 4572 | 50 |
2243334 | 2243334 | 2022-02-23 | Jackson | Iowa | 19097 | 4572 | 67 |
2214271 | 2214271 | 2022-02-14 | Garrard | Kentucky | 21079 | 4572 | 67 |
2194261 | 2194261 | 2022-02-08 | Worth | Georgia | 13321 | 4572 | 104 |
2190586 | 2190586 | 2022-02-07 | Cross | Arkansas | 5037 | 4572 | 75 |
2174586 | 2174586 | 2022-02-02 | Appling | Georgia | 13001 | 4572 | 113 |
2172513 | 2172513 | 2022-02-01 | New Madrid | Missouri | 29143 | 4572 | 73 |
2149753 | 2149753 | 2022-01-25 | Ray | Missouri | 29177 | 4572 | 81 |
2132330 | 2132330 | 2022-01-20 | Dodge | Georgia | 13091 | 4572 | 137 |
2129087 | 2129087 | 2022-01-19 | Fannin | Georgia | 13111 | 4572 | 122 |
2123602 | 2123602 | 2022-01-17 | Newton | Mississippi | 28101 | 4572 | 85 |
2123675 | 2123675 | 2022-01-17 | Henry | Missouri | 29083 | 4572 | 66 |
2120350 | 2120350 | 2022-01-16 | Newton | Mississippi | 28101 | 4572 | 85 |
2120423 | 2120423 | 2022-01-16 | Henry | Missouri | 29083 | 4572 | 66 |
2117098 | 2117098 | 2022-01-15 | Newton | Mississippi | 28101 | 4572 | 85 |
2117171 | 2117171 | 2022-01-15 | Henry | Missouri | 29083 | 4572 | 66 |
2113847 | 2113847 | 2022-01-14 | Newton | Mississippi | 28101 | 4572 | 85 |
2110823 | 2110823 | 2022-01-13 | Dawson | Nebraska | 31047 | 4572 | 37 |
2111480 | 2111480 | 2022-01-13 | Cayey | Puerto Rico | 72035 | 4572 | |
2034946 | 2034946 | 2021-12-21 | Jefferson | Idaho | 16051 | 4572 | 53 |
2037310 | 2037310 | 2021-12-21 | Caroline | Virginia | 51033 | 4572 | 56 |
2032898 | 2032898 | 2021-12-20 | Coos | New Hampshire | 33007 | 4572 | 79 |
1899231 | 1899231 | 2021-11-09 | Pine | Minnesota | 27115 | 4572 | 37 |
1900249 | 1900249 | 2021-11-09 | Trujillo Alto | Puerto Rico | 72139 | 4572 | |
1896999 | 1896999 | 2021-11-08 | Trujillo Alto | Puerto Rico | 72139 | 4572 | |
1868640 | 1868640 | 2021-10-31 | Lawrence | Alabama | 1079 | 4572 | 118 |
1836492 | 1836492 | 2021-10-21 | Taylor | Florida | 12123 | 4572 | 77 |
1833243 | 1833243 | 2021-10-20 | Taylor | Florida | 12123 | 4572 | 77 |
1829994 | 1829994 | 2021-10-19 | Taylor | Florida | 12123 | 4572 | 77 |
1826745 | 1826745 | 2021-10-18 | Taylor | Florida | 12123 | 4572 | 77 |
1823496 | 1823496 | 2021-10-17 | Taylor | Florida | 12123 | 4572 | 77 |
1820247 | 1820247 | 2021-10-16 | Taylor | Florida | 12123 | 4572 | 77 |
1816998 | 1816998 | 2021-10-15 | Taylor | Florida | 12123 | 4572 | 77 |
1811809 | 1811809 | 2021-10-13 | Dakota | Nebraska | 31043 | 4572 | 82 |
1806424 | 1806424 | 2021-10-11 | Palo Pinto | Texas | 48363 | 4572 | 109 |
1800554 | 1800554 | 2021-10-10 | Yell | Arkansas | 5149 | 4572 | 77 |
1801510 | 1801510 | 2021-10-10 | Franklin | Louisiana | 22041 | 4572 | 136 |
1803174 | 1803174 | 2021-10-10 | Palo Pinto | Texas | 48363 | 4572 | 109 |
1798261 | 1798261 | 2021-10-09 | Franklin | Louisiana | 22041 | 4572 | 136 |
1799925 | 1799925 | 2021-10-09 | Palo Pinto | Texas | 48363 | 4572 | 109 |
1795012 | 1795012 | 2021-10-08 | Franklin | Louisiana | 22041 | 4572 | 136 |
1770471 | 1770471 | 2021-09-30 | Overton | Tennessee | 47133 | 4572 | 77 |
1744490 | 1744490 | 2021-09-22 | Scott | Tennessee | 47151 | 4572 | 54 |
1699725 | 1699725 | 2021-09-09 | Bethel Census Area | Alaska | 2050 | 4572 | 23 |
1699651 | 1699651 | 2021-09-08 | Teton | Wyoming | 56039 | 4572 | 11 |
1633821 | 1633821 | 2021-08-19 | Ponce | Puerto Rico | 72113 | 4572 | |
1620531 | 1620531 | 2021-08-15 | Fulton | Ohio | 39051 | 4572 | 77 |
1601818 | 1601818 | 2021-08-09 | Wharton | Texas | 48481 | 4572 | 122 |
1594520 | 1594520 | 2021-08-07 | Ashland | Ohio | 39005 | 4572 | 98 |
1587422 | 1587422 | 2021-08-05 | Neshoba | Mississippi | 28099 | 4572 | 181 |
1580602 | 1580602 | 2021-08-03 | Iberville | Louisiana | 22047 | 4572 | 102 |
1573695 | 1573695 | 2021-08-01 | Harrison | Indiana | 18061 | 4572 | 79 |
1570447 | 1570447 | 2021-07-31 | Harrison | Indiana | 18061 | 4572 | 79 |
1567199 | 1567199 | 2021-07-30 | Harrison | Indiana | 18061 | 4572 | 79 |
1539186 | 1539186 | 2021-07-21 | Haywood | North Carolina | 37087 | 4572 | 99 |
1496899 | 1496899 | 2021-07-08 | Madison | New York | 36053 | 4572 | 89 |
1493652 | 1493652 | 2021-07-07 | Madison | New York | 36053 | 4572 | 89 |
1441952 | 1441952 | 2021-06-21 | Knox | Ohio | 39083 | 4572 | 112 |
1438707 | 1438707 | 2021-06-20 | Knox | Ohio | 39083 | 4572 | 112 |
1425082 | 1425082 | 2021-06-16 | Marshall | Mississippi | 28093 | 4572 | 105 |
1421834 | 1421834 | 2021-06-15 | Marshall | Mississippi | 28093 | 4572 | 105 |
1418589 | 1418589 | 2021-06-14 | Marshall | Mississippi | 28093 | 4572 | 105 |
1395767 | 1395767 | 2021-06-07 | Itasca | Minnesota | 27061 | 4572 | 61 |
1362351 | 1362351 | 2021-05-28 | Baldwin | Georgia | 13009 | 4572 | 132 |
1351238 | 1351238 | 2021-05-24 | Bedford | Pennsylvania | 42009 | 4572 | 138 |
1272425 | 1272425 | 2021-04-30 | Mower | Minnesota | 27099 | 4572 | 32 |
1241483 | 1241483 | 2021-04-20 | Wasatch | Utah | 49051 | 4572 | 21 |
1220145 | 1220145 | 2021-04-14 | Henderson | Kentucky | 21101 | 4572 | 74 |
1208839 | 1208839 | 2021-04-10 | Howard | Texas | 48227 | 4572 | 100 |
1198406 | 1198406 | 2021-04-07 | Stark | North Dakota | 38089 | 4572 | 50 |
1174742 | 1174742 | 2021-03-31 | Whitley | Kentucky | 21235 | 4572 | 47 |
1168234 | 1168234 | 2021-03-29 | Scott | Kentucky | 21209 | 4572 | 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);