ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where cases = 2963 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 15
- Arkansas 14
- Kentucky 13
- Tennessee 12
- Mississippi 11
- Georgia 10
- Iowa 8
- Virginia 8
- Louisiana 7
- Missouri 7
- North Dakota 7
- Texas 7
- Michigan 6
- Pennsylvania 6
- Alabama 5
- Indiana 5
- Ohio 5
- Oregon 5
- Illinois 4
- Minnesota 4
- Puerto Rico 4
- New York 3
- North Carolina 3
- West Virginia 3
- Wisconsin 3
- Maryland 2
- South Carolina 2
- Wyoming 2
- Colorado 1
- Delaware 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501041 | 2501041 | 2022-05-13 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2497783 | 2497783 | 2022-05-12 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2494525 | 2494525 | 2022-05-11 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2491267 | 2491267 | 2022-05-10 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2488010 | 2488010 | 2022-05-09 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2446467 | 2446467 | 2022-04-26 | Morrow | Oregon | 41049 | 2963 | 34 |
2405154 | 2405154 | 2022-04-14 | Coosa | Alabama | 1037 | 2963 | 58 |
2361585 | 2361585 | 2022-03-31 | Barnes | North Dakota | 38003 | 2963 | 47 |
2358331 | 2358331 | 2022-03-30 | Barnes | North Dakota | 38003 | 2963 | 47 |
2355077 | 2355077 | 2022-03-29 | Barnes | North Dakota | 38003 | 2963 | 47 |
2351824 | 2351824 | 2022-03-28 | Barnes | North Dakota | 38003 | 2963 | 47 |
2348572 | 2348572 | 2022-03-27 | Barnes | North Dakota | 38003 | 2963 | 47 |
2345319 | 2345319 | 2022-03-26 | Barnes | North Dakota | 38003 | 2963 | 47 |
2342066 | 2342066 | 2022-03-25 | Barnes | North Dakota | 38003 | 2963 | 47 |
2311063 | 2311063 | 2022-03-16 | Moffat | Colorado | 8081 | 2963 | 51 |
2308935 | 2308935 | 2022-03-15 | Watonwan | Minnesota | 27165 | 2963 | 23 |
2241433 | 2241433 | 2022-02-22 | Love | Oklahoma | 40085 | 2963 | 35 |
2241442 | 2241442 | 2022-02-22 | Noble | Oklahoma | 40103 | 2963 | 36 |
2238182 | 2238182 | 2022-02-21 | Love | Oklahoma | 40085 | 2963 | 35 |
2238191 | 2238191 | 2022-02-21 | Noble | Oklahoma | 40103 | 2963 | 36 |
2234931 | 2234931 | 2022-02-20 | Love | Oklahoma | 40085 | 2963 | 35 |
2234940 | 2234940 | 2022-02-20 | Noble | Oklahoma | 40103 | 2963 | 36 |
2229601 | 2229601 | 2022-02-19 | Bradley | Arkansas | 5011 | 2963 | 44 |
2231680 | 2231680 | 2022-02-19 | Love | Oklahoma | 40085 | 2963 | 35 |
2231689 | 2231689 | 2022-02-19 | Noble | Oklahoma | 40103 | 2963 | 36 |
2228429 | 2228429 | 2022-02-18 | Love | Oklahoma | 40085 | 2963 | 35 |
2228438 | 2228438 | 2022-02-18 | Noble | Oklahoma | 40103 | 2963 | 36 |
2225178 | 2225178 | 2022-02-17 | Love | Oklahoma | 40085 | 2963 | 35 |
2225187 | 2225187 | 2022-02-17 | Noble | Oklahoma | 40103 | 2963 | 36 |
2221927 | 2221927 | 2022-02-16 | Love | Oklahoma | 40085 | 2963 | 35 |
2221936 | 2221936 | 2022-02-16 | Noble | Oklahoma | 40103 | 2963 | 36 |
2203603 | 2203603 | 2022-02-11 | Desha | Arkansas | 5041 | 2963 | 37 |
2203365 | 2203365 | 2022-02-10 | Roane | West Virginia | 54087 | 2963 | 33 |
2156420 | 2156420 | 2022-01-27 | Seward | Nebraska | 31159 | 2963 | 40 |
2147319 | 2147319 | 2022-01-24 | Utuado | Puerto Rico | 72141 | 2963 | |
2140501 | 2140501 | 2022-01-22 | Harrison | Ohio | 39067 | 2963 | 62 |
2099885 | 2099885 | 2022-01-10 | Rabun | Georgia | 13241 | 2963 | 82 |
2085351 | 2085351 | 2022-01-05 | Clatsop | Oregon | 41007 | 2963 | 36 |
2063731 | 2063731 | 2021-12-30 | Clay | Arkansas | 5021 | 2963 | 77 |
2065993 | 2065993 | 2021-12-30 | Moca | Puerto Rico | 72099 | 2963 | |
2059647 | 2059647 | 2021-12-28 | Cannon | Tennessee | 47015 | 2963 | 50 |
2060065 | 2060065 | 2021-12-28 | Colonial Heights city | Virginia | 51570 | 2963 | 71 |
2039118 | 2039118 | 2021-12-22 | Benton | Missouri | 29015 | 2963 | 72 |
2022930 | 2022930 | 2021-12-17 | Morgan | Missouri | 29141 | 2963 | 75 |
2004483 | 2004483 | 2021-12-11 | Andrews | Texas | 48003 | 2963 | 65 |
1998742 | 1998742 | 2021-12-10 | Grant | Arkansas | 5053 | 2963 | 51 |
1972188 | 1972188 | 2021-12-01 | Shelby | Texas | 48419 | 2963 | 113 |
1944190 | 1944190 | 2021-11-23 | Jackson | Iowa | 19097 | 2963 | 47 |
1940940 | 1940940 | 2021-11-22 | Jackson | Iowa | 19097 | 2963 | 47 |
1937690 | 1937690 | 2021-11-21 | Jackson | Iowa | 19097 | 2963 | 47 |
1934440 | 1934440 | 2021-11-20 | Jackson | Iowa | 19097 | 2963 | 47 |
1931189 | 1931189 | 2021-11-19 | Jackson | Iowa | 19097 | 2963 | 47 |
1927938 | 1927938 | 2021-11-18 | Jackson | Iowa | 19097 | 2963 | 47 |
1924688 | 1924688 | 2021-11-17 | Jackson | Iowa | 19097 | 2963 | 47 |
1900872 | 1900872 | 2021-11-09 | Prince Edward | Virginia | 51147 | 2963 | 52 |
1897622 | 1897622 | 2021-11-08 | Prince Edward | Virginia | 51147 | 2963 | 52 |
1852485 | 1852485 | 2021-10-26 | Cross | Arkansas | 5037 | 2963 | 64 |
1854591 | 1854591 | 2021-10-26 | Crook | Oregon | 41013 | 2963 | 46 |
1849236 | 1849236 | 2021-10-25 | Cross | Arkansas | 5037 | 2963 | 64 |
1845986 | 1845986 | 2021-10-24 | Cross | Arkansas | 5037 | 2963 | 64 |
1842122 | 1842122 | 2021-10-22 | Lamb | Texas | 48279 | 2963 | 88 |
1838873 | 1838873 | 2021-10-21 | Lamb | Texas | 48279 | 2963 | 88 |
1803480 | 1803480 | 2021-10-10 | Hampshire | West Virginia | 54027 | 2963 | 46 |
1791890 | 1791890 | 2021-10-07 | Gladwin | Michigan | 26051 | 2963 | 66 |
1787382 | 1787382 | 2021-10-06 | Cherokee | Alabama | 1019 | 2963 | 57 |
1788641 | 1788641 | 2021-10-06 | Gladwin | Michigan | 26051 | 2963 | 66 |
1775642 | 1775642 | 2021-10-02 | Emmet | Michigan | 26047 | 2963 | 47 |
1772392 | 1772392 | 2021-10-01 | Emmet | Michigan | 26047 | 2963 | 47 |
1757934 | 1757934 | 2021-09-26 | Waynesboro city | Virginia | 51820 | 2963 | 40 |
1754686 | 1754686 | 2021-09-25 | Waynesboro city | Virginia | 51820 | 2963 | 40 |
1751438 | 1751438 | 2021-09-24 | Waynesboro city | Virginia | 51820 | 2963 | 40 |
1744987 | 1744987 | 2021-09-22 | Boone | West Virginia | 54005 | 2963 | 38 |
1732568 | 1732568 | 2021-09-19 | Crisp | Georgia | 13081 | 2963 | 98 |
1733140 | 1733140 | 2021-09-19 | Adair | Kentucky | 21001 | 2963 | 64 |
1729318 | 1729318 | 2021-09-18 | Crisp | Georgia | 13081 | 2963 | 98 |
1729890 | 1729890 | 2021-09-18 | Adair | Kentucky | 21001 | 2963 | 64 |
1726068 | 1726068 | 2021-09-17 | Crisp | Georgia | 13081 | 2963 | 98 |
1716017 | 1716017 | 2021-09-14 | Conway | Arkansas | 5029 | 2963 | 41 |
1718226 | 1718226 | 2021-09-14 | Aguadilla | Puerto Rico | 72005 | 2963 | |
1714787 | 1714787 | 2021-09-13 | Van Wert | Ohio | 39161 | 2963 | 68 |
1715543 | 1715543 | 2021-09-13 | Sevier | Utah | 49041 | 2963 | 16 |
1710021 | 1710021 | 2021-09-12 | Douglas | Illinois | 17041 | 2963 | 42 |
1706774 | 1706774 | 2021-09-11 | Douglas | Illinois | 17041 | 2963 | 42 |
1703024 | 1703024 | 2021-09-10 | Clark | Arkansas | 5019 | 2963 | 49 |
1703526 | 1703526 | 2021-09-10 | Douglas | Illinois | 17041 | 2963 | 42 |
1700161 | 1700161 | 2021-09-09 | Putnam | Georgia | 13237 | 2963 | 67 |
1695401 | 1695401 | 2021-09-07 | Jefferson | Oregon | 41031 | 2963 | 45 |
1690911 | 1690911 | 2021-09-06 | Allen | Kentucky | 21003 | 2963 | 48 |
1687661 | 1687661 | 2021-09-05 | Allen | Kentucky | 21003 | 2963 | 48 |
1684411 | 1684411 | 2021-09-04 | Allen | Kentucky | 21003 | 2963 | 48 |
1681160 | 1681160 | 2021-09-03 | Allen | Kentucky | 21003 | 2963 | 48 |
1664044 | 1664044 | 2021-08-29 | Columbia | Arkansas | 5027 | 2963 | 61 |
1646719 | 1646719 | 2021-08-23 | Elk | Pennsylvania | 42047 | 2963 | 42 |
1633989 | 1633989 | 2021-08-19 | Grainger | Tennessee | 47057 | 2963 | 51 |
1617281 | 1617281 | 2021-08-14 | Fayette | Ohio | 39047 | 2963 | 50 |
1609149 | 1609149 | 2021-08-12 | Franklin | Georgia | 13119 | 2963 | 57 |
1601501 | 1601501 | 2021-08-09 | DeKalb | Tennessee | 47041 | 2963 | 57 |
1585636 | 1585636 | 2021-08-04 | Accomack | Virginia | 51001 | 2963 | 46 |
1577306 | 1577306 | 2021-08-02 | Perry | Kentucky | 21193 | 2963 | 66 |
1561469 | 1561469 | 2021-07-28 | Audrain | Missouri | 29007 | 2963 | 58 |
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);