ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where cases = 3779 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 12
- Kentucky 11
- Missouri 10
- Texas 10
- Arkansas 9
- Minnesota 9
- Ohio 9
- Virginia 9
- Iowa 8
- Florida 7
- Michigan 6
- Tennessee 5
- Illinois 4
- Oklahoma 4
- Pennsylvania 4
- Alabama 3
- Indiana 3
- Kansas 3
- Louisiana 3
- New Mexico 3
- South Carolina 3
- Washington 3
- Montana 2
- New York 2
- North Carolina 2
- Oregon 2
- Wisconsin 2
- Arizona 1
- California 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494453 | 2494453 | 2022-05-11 | Renville | Minnesota | 27129 | 3779 | 56 |
2438712 | 2438712 | 2022-04-24 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2435456 | 2435456 | 2022-04-23 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2432200 | 2432200 | 2022-04-22 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2428944 | 2428944 | 2022-04-21 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2425688 | 2425688 | 2022-04-20 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2422432 | 2422432 | 2022-04-19 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2419176 | 2419176 | 2022-04-18 | Breathitt | Kentucky | 21025 | 3779 | 54 |
2416255 | 2416255 | 2022-04-17 | Faribault | Minnesota | 27043 | 3779 | 50 |
2412999 | 2412999 | 2022-04-16 | Faribault | Minnesota | 27043 | 3779 | 50 |
2409743 | 2409743 | 2022-04-15 | Faribault | Minnesota | 27043 | 3779 | 50 |
2352488 | 2352488 | 2022-03-28 | Colorado | Texas | 48089 | 3779 | 63 |
2349236 | 2349236 | 2022-03-27 | Colorado | Texas | 48089 | 3779 | 63 |
2345983 | 2345983 | 2022-03-26 | Colorado | Texas | 48089 | 3779 | 63 |
2342730 | 2342730 | 2022-03-25 | Colorado | Texas | 48089 | 3779 | 62 |
2291399 | 2291399 | 2022-03-10 | Franklin | Arkansas | 5047 | 3779 | 71 |
2284781 | 2284781 | 2022-03-08 | Crenshaw | Alabama | 1041 | 3779 | 95 |
2281529 | 2281529 | 2022-03-07 | Crenshaw | Alabama | 1041 | 3779 | 95 |
2283037 | 2283037 | 2022-03-07 | Dallas | Missouri | 29059 | 3779 | 70 |
2283353 | 2283353 | 2022-03-07 | Socorro | New Mexico | 35053 | 3779 | 85 |
2279784 | 2279784 | 2022-03-06 | Dallas | Missouri | 29059 | 3779 | 70 |
2276531 | 2276531 | 2022-03-05 | Dallas | Missouri | 29059 | 3779 | 70 |
2273278 | 2273278 | 2022-03-04 | Dallas | Missouri | 29059 | 3779 | 70 |
2266321 | 2266321 | 2022-03-02 | Magoffin | Kentucky | 21153 | 3779 | 41 |
2242446 | 2242446 | 2022-02-22 | Richland | Wisconsin | 55103 | 3779 | 41 |
2237554 | 2237554 | 2022-02-21 | Moniteau | Missouri | 29135 | 3779 | 52 |
2234303 | 2234303 | 2022-02-20 | Moniteau | Missouri | 29135 | 3779 | 52 |
2231052 | 2231052 | 2022-02-19 | Moniteau | Missouri | 29135 | 3779 | 52 |
2227801 | 2227801 | 2022-02-18 | Moniteau | Missouri | 29135 | 3779 | 52 |
2220756 | 2220756 | 2022-02-16 | Casey | Kentucky | 21045 | 3779 | 66 |
2222360 | 2222360 | 2022-02-16 | Andrews | Texas | 48003 | 3779 | 70 |
2217542 | 2217542 | 2022-02-15 | Knott | Kentucky | 21119 | 3779 | 55 |
2200373 | 2200373 | 2022-02-10 | Madison | Arkansas | 5087 | 3779 | 53 |
2154837 | 2154837 | 2022-01-27 | Polk | Arkansas | 5113 | 3779 | 130 |
2153415 | 2153415 | 2022-01-26 | Warren | North Carolina | 37185 | 3779 | 38 |
2132294 | 2132294 | 2022-01-20 | Ben Hill | Georgia | 13017 | 3779 | 113 |
2125421 | 2125421 | 2022-01-18 | Henry | Alabama | 1067 | 3779 | 67 |
2119434 | 2119434 | 2022-01-16 | Worth | Georgia | 13321 | 3779 | 97 |
2116182 | 2116182 | 2022-01-15 | Worth | Georgia | 13321 | 3779 | 97 |
2112931 | 2112931 | 2022-01-14 | Worth | Georgia | 13321 | 3779 | 97 |
2104198 | 2104198 | 2022-01-11 | New Madrid | Missouri | 29143 | 3779 | 72 |
2096289 | 2096289 | 2022-01-09 | Phillips | Arkansas | 5107 | 3779 | 84 |
2097383 | 2097383 | 2022-01-09 | Charlevoix | Michigan | 26029 | 3779 | 53 |
2093037 | 2093037 | 2022-01-08 | Phillips | Arkansas | 5107 | 3779 | 84 |
2094131 | 2094131 | 2022-01-08 | Charlevoix | Michigan | 26029 | 3779 | 53 |
2090879 | 2090879 | 2022-01-07 | Charlevoix | Michigan | 26029 | 3779 | 53 |
2058389 | 2058389 | 2021-12-28 | Iosco | Michigan | 26069 | 3779 | 112 |
2055140 | 2055140 | 2021-12-27 | Iosco | Michigan | 26069 | 3779 | 112 |
2012418 | 2012418 | 2021-12-14 | Carroll | Iowa | 19027 | 3779 | 56 |
2009167 | 2009167 | 2021-12-13 | Carroll | Iowa | 19027 | 3779 | 56 |
2005916 | 2005916 | 2021-12-12 | Carroll | Iowa | 19027 | 3779 | 56 |
2002665 | 2002665 | 2021-12-11 | Carroll | Iowa | 19027 | 3779 | 56 |
1999415 | 1999415 | 2021-12-10 | Carroll | Iowa | 19027 | 3779 | 56 |
1996164 | 1996164 | 2021-12-09 | Carroll | Iowa | 19027 | 3779 | 56 |
1992913 | 1992913 | 2021-12-08 | Carroll | Iowa | 19027 | 3779 | 56 |
1995093 | 1995093 | 2021-12-08 | Hopewell city | Virginia | 51670 | 3779 | 94 |
1986137 | 1986137 | 2021-12-06 | Unknown | Georgia | 3779 | 8 | |
1969760 | 1969760 | 2021-12-01 | Burke | Georgia | 13033 | 3779 | 86 |
1965406 | 1965406 | 2021-11-29 | Fentress | Tennessee | 47049 | 3779 | 69 |
1949654 | 1949654 | 2021-11-24 | Winchester city | Virginia | 51840 | 3779 | 56 |
1928360 | 1928360 | 2021-11-18 | Emmet | Michigan | 26047 | 3779 | 55 |
1853125 | 1853125 | 2021-10-26 | Posey | Indiana | 18129 | 3779 | 44 |
1837111 | 1837111 | 2021-10-21 | Allen | Kentucky | 21003 | 3779 | 68 |
1831936 | 1831936 | 2021-10-19 | Warren | Pennsylvania | 42123 | 3779 | 118 |
1823616 | 1823616 | 2021-10-17 | Pike | Georgia | 13231 | 3779 | 67 |
1820367 | 1820367 | 2021-10-16 | Pike | Georgia | 13231 | 3779 | 67 |
1817118 | 1817118 | 2021-10-15 | Pike | Georgia | 13231 | 3779 | 67 |
1813717 | 1813717 | 2021-10-14 | Holmes | Florida | 12059 | 3779 | 69 |
1810468 | 1810468 | 2021-10-13 | Holmes | Florida | 12059 | 3779 | 69 |
1807219 | 1807219 | 2021-10-12 | Holmes | Florida | 12059 | 3779 | 69 |
1809434 | 1809434 | 2021-10-12 | Haywood | Tennessee | 47075 | 3779 | 72 |
1803968 | 1803968 | 2021-10-11 | Holmes | Florida | 12059 | 3779 | 69 |
1800719 | 1800719 | 2021-10-10 | Holmes | Florida | 12059 | 3779 | 69 |
1797470 | 1797470 | 2021-10-09 | Holmes | Florida | 12059 | 3779 | 69 |
1794221 | 1794221 | 2021-10-08 | Holmes | Florida | 12059 | 3779 | 69 |
1733703 | 1733703 | 2021-09-19 | Miller | Missouri | 29131 | 3779 | 70 |
1718449 | 1718449 | 2021-09-14 | Grainger | Tennessee | 47057 | 3779 | 54 |
1694493 | 1694493 | 2021-09-07 | Carlton | Minnesota | 27017 | 3779 | 59 |
1694975 | 1694975 | 2021-09-07 | Cibola | New Mexico | 35006 | 3779 | 130 |
1633580 | 1633580 | 2021-08-19 | Williams | Ohio | 39171 | 3779 | 79 |
1620850 | 1620850 | 2021-08-15 | Vega Baja | Puerto Rico | 72145 | 3779 | |
1575084 | 1575084 | 2021-08-01 | Ottawa | Ohio | 39123 | 3779 | 81 |
1565754 | 1565754 | 2021-07-29 | Carroll | Tennessee | 47017 | 3779 | 84 |
1552658 | 1552658 | 2021-07-25 | Colleton | South Carolina | 45029 | 3779 | 133 |
1553276 | 1553276 | 2021-07-25 | Tazewell | Virginia | 51185 | 3779 | 75 |
1549411 | 1549411 | 2021-07-24 | Colleton | South Carolina | 45029 | 3779 | 133 |
1550029 | 1550029 | 2021-07-24 | Tazewell | Virginia | 51185 | 3779 | 75 |
1546164 | 1546164 | 2021-07-23 | Colleton | South Carolina | 45029 | 3779 | 133 |
1546782 | 1546782 | 2021-07-23 | Tazewell | Virginia | 51185 | 3779 | 75 |
1540287 | 1540287 | 2021-07-21 | Tazewell | Virginia | 51185 | 3779 | 75 |
1537040 | 1537040 | 2021-07-20 | Tazewell | Virginia | 51185 | 3779 | 75 |
1527105 | 1527105 | 2021-07-17 | Uvalde | Texas | 48463 | 3779 | 73 |
1508605 | 1508605 | 2021-07-12 | Nez Perce | Idaho | 16069 | 3779 | 60 |
1498580 | 1498580 | 2021-07-09 | Summit | Colorado | 8117 | 3779 | 8 |
1469463 | 1469463 | 2021-06-30 | Bryan | Georgia | 13029 | 3779 | 41 |
1402974 | 1402974 | 2021-06-09 | Clinton | Ohio | 39027 | 3779 | 66 |
1399729 | 1399729 | 2021-06-08 | Clinton | Ohio | 39027 | 3779 | 66 |
1363850 | 1363850 | 2021-05-28 | Tioga | New York | 36107 | 3779 | 62 |
1351642 | 1351642 | 2021-05-24 | Cooke | Texas | 48097 | 3779 | 72 |
1348396 | 1348396 | 2021-05-23 | Cooke | Texas | 48097 | 3779 | 72 |
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);