ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 3076 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 14
- Georgia 12
- Alabama 11
- Mississippi 10
- Texas 10
- Puerto Rico 9
- Iowa 8
- Minnesota 8
- Tennessee 8
- California 7
- Illinois 7
- Arkansas 6
- Kentucky 6
- Michigan 6
- Missouri 5
- Indiana 4
- Wisconsin 4
- New Mexico 3
- South Carolina 3
- Washington 3
- Arizona 2
- New York 2
- North Carolina 2
- Ohio 2
- Oklahoma 2
- Virginia 2
- Wyoming 2
- Colorado 1
- Idaho 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444978 | 2444978 | 2022-04-26 | Pulaski | Indiana | 18131 | 3076 | 86 |
2441722 | 2441722 | 2022-04-25 | Pulaski | Indiana | 18131 | 3076 | 86 |
2428268 | 2428268 | 2022-04-21 | Franklin | Florida | 12037 | 3076 | 52 |
2425012 | 2425012 | 2022-04-20 | Franklin | Florida | 12037 | 3076 | 52 |
2421756 | 2421756 | 2022-04-19 | Franklin | Florida | 12037 | 3076 | 52 |
2418500 | 2418500 | 2022-04-18 | Franklin | Florida | 12037 | 3076 | 52 |
2415244 | 2415244 | 2022-04-17 | Franklin | Florida | 12037 | 3076 | 52 |
2411988 | 2411988 | 2022-04-16 | Franklin | Florida | 12037 | 3076 | 52 |
2408732 | 2408732 | 2022-04-15 | Franklin | Florida | 12037 | 3076 | 52 |
2405476 | 2405476 | 2022-04-14 | Franklin | Florida | 12037 | 3076 | 52 |
2402221 | 2402221 | 2022-04-13 | Franklin | Florida | 12037 | 3076 | 52 |
2398966 | 2398966 | 2022-04-12 | Franklin | Florida | 12037 | 3076 | 52 |
2399150 | 2399150 | 2022-04-12 | Telfair | Georgia | 13271 | 3076 | 84 |
2395711 | 2395711 | 2022-04-11 | Franklin | Florida | 12037 | 3076 | 52 |
2395785 | 2395785 | 2022-04-11 | Charlton | Georgia | 13049 | 3076 | 63 |
2395895 | 2395895 | 2022-04-11 | Telfair | Georgia | 13271 | 3076 | 83 |
2392455 | 2392455 | 2022-04-10 | Franklin | Florida | 12037 | 3076 | 52 |
2389199 | 2389199 | 2022-04-09 | Franklin | Florida | 12037 | 3076 | 52 |
2385944 | 2385944 | 2022-04-08 | Franklin | Florida | 12037 | 3076 | 52 |
2382873 | 2382873 | 2022-04-07 | Telfair | Georgia | 13271 | 3076 | 83 |
2239450 | 2239450 | 2022-02-22 | Mono | California | 6051 | 3076 | 5 |
2224061 | 2224061 | 2022-02-17 | Martin | Kentucky | 21159 | 3076 | 44 |
2200199 | 2200199 | 2022-02-09 | Converse | Wyoming | 56009 | 3076 | 50 |
2186643 | 2186643 | 2022-02-05 | Duval | Texas | 48131 | 3076 | 64 |
2176317 | 2176317 | 2022-02-02 | Morgan | Ohio | 39115 | 3076 | 49 |
2157416 | 2157416 | 2022-01-27 | Jackson | Texas | 48239 | 3076 | 55 |
2148983 | 2148983 | 2022-01-25 | Clayton | Iowa | 19043 | 3076 | 68 |
2151146 | 2151146 | 2022-01-25 | Grayson | Virginia | 51077 | 3076 | 67 |
2145731 | 2145731 | 2022-01-24 | Clayton | Iowa | 19043 | 3076 | 68 |
2142476 | 2142476 | 2022-01-23 | Clayton | Iowa | 19043 | 3076 | 68 |
2139221 | 2139221 | 2022-01-22 | Clayton | Iowa | 19043 | 3076 | 68 |
2135965 | 2135965 | 2022-01-21 | Clayton | Iowa | 19043 | 3076 | 68 |
2132713 | 2132713 | 2022-01-20 | Clayton | Iowa | 19043 | 3076 | 68 |
2129460 | 2129460 | 2022-01-19 | Clayton | Iowa | 19043 | 3076 | 68 |
2111588 | 2111588 | 2022-01-13 | Saluda | South Carolina | 45081 | 3076 | 62 |
2070249 | 2070249 | 2022-01-01 | Grant | Arkansas | 5053 | 3076 | 52 |
2063580 | 2063580 | 2021-12-29 | Washburn | Wisconsin | 55129 | 3076 | 34 |
2052906 | 2052906 | 2021-12-26 | Fulton | Pennsylvania | 42057 | 3076 | 45 |
2023733 | 2023733 | 2021-12-17 | Juncos | Puerto Rico | 72077 | 3076 | |
2017829 | 2017829 | 2021-12-15 | Fluvanna | Virginia | 51065 | 3076 | 29 |
1999806 | 1999806 | 2021-12-10 | Waldo | Maine | 23027 | 3076 | 36 |
1971113 | 1971113 | 2021-12-01 | Washington | Nebraska | 31177 | 3076 | 29 |
1969282 | 1969282 | 2021-11-30 | Iowa | Wisconsin | 55049 | 3076 | 18 |
1951242 | 1951242 | 2021-11-25 | Roseau | Minnesota | 27135 | 3076 | 31 |
1947991 | 1947991 | 2021-11-24 | Roseau | Minnesota | 27135 | 3076 | 31 |
1941616 | 1941616 | 2021-11-22 | Clinton | Missouri | 29049 | 3076 | 93 |
1938366 | 1938366 | 2021-11-21 | Clinton | Missouri | 29049 | 3076 | 94 |
1922928 | 1922928 | 2021-11-16 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1919679 | 1919679 | 2021-11-15 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1916429 | 1916429 | 2021-11-14 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1913179 | 1913179 | 2021-11-13 | Aguadilla | Puerto Rico | 72005 | 3076 | |
1860164 | 1860164 | 2021-10-28 | Osceola | Michigan | 26133 | 3076 | 41 |
1856915 | 1856915 | 2021-10-27 | Osceola | Michigan | 26133 | 3076 | 41 |
1857012 | 1857012 | 2021-10-27 | Wabasha | Minnesota | 27157 | 3076 | 8 |
1849299 | 1849299 | 2021-10-25 | Colusa | California | 6011 | 3076 | 18 |
1846049 | 1846049 | 2021-10-24 | Colusa | California | 6011 | 3076 | 18 |
1842799 | 1842799 | 2021-10-23 | Colusa | California | 6011 | 3076 | 18 |
1839549 | 1839549 | 2021-10-22 | Colusa | California | 6011 | 3076 | 18 |
1838454 | 1838454 | 2021-10-21 | Canovanas | Puerto Rico | 72029 | 3076 | |
1834287 | 1834287 | 2021-10-20 | Clay | Mississippi | 28025 | 3076 | 76 |
1835205 | 1835205 | 2021-10-20 | Canovanas | Puerto Rico | 72029 | 3076 | |
1805768 | 1805768 | 2021-10-11 | Wyandot | Ohio | 39175 | 3076 | 61 |
1783488 | 1783488 | 2021-10-04 | Trousdale | Tennessee | 47169 | 3076 | 24 |
1764752 | 1764752 | 2021-09-29 | Conway | Arkansas | 5029 | 3076 | 42 |
1765057 | 1765057 | 2021-09-29 | Crisp | Georgia | 13081 | 3076 | 105 |
1755504 | 1755504 | 2021-09-26 | Douglas | Illinois | 17041 | 3076 | 42 |
1756420 | 1756420 | 2021-09-26 | Henry | Missouri | 29083 | 3076 | 48 |
1752256 | 1752256 | 2021-09-25 | Douglas | Illinois | 17041 | 3076 | 42 |
1752855 | 1752855 | 2021-09-25 | Somerset | Maryland | 24039 | 3076 | 46 |
1748556 | 1748556 | 2021-09-24 | Randolph | Arkansas | 5121 | 3076 | 51 |
1749007 | 1749007 | 2021-09-24 | Douglas | Illinois | 17041 | 3076 | 42 |
1746706 | 1746706 | 2021-09-23 | New Madrid | Missouri | 29143 | 3076 | 51 |
1722395 | 1722395 | 2021-09-16 | Butler | Alabama | 1013 | 3076 | 79 |
1717338 | 1717338 | 2021-09-14 | Jasper | Mississippi | 28061 | 3076 | 61 |
1689954 | 1689954 | 2021-09-06 | Marengo | Alabama | 1091 | 3076 | 74 |
1679619 | 1679619 | 2021-09-02 | Gillespie | Texas | 48171 | 3076 | 61 |
1674305 | 1674305 | 2021-09-01 | Jersey | Illinois | 17083 | 3076 | 71 |
1670814 | 1670814 | 2021-08-31 | Berrien | Georgia | 13019 | 3076 | 53 |
1673506 | 1673506 | 2021-08-31 | Stevens | Washington | 53065 | 3076 | 36 |
1643539 | 1643539 | 2021-08-22 | Dorado | Puerto Rico | 72051 | 3076 | |
1625511 | 1625511 | 2021-08-17 | Cassia | Idaho | 16031 | 3076 | 28 |
1610065 | 1610065 | 2021-08-12 | Le Sueur | Minnesota | 27079 | 3076 | 28 |
1606182 | 1606182 | 2021-08-11 | Greene | Indiana | 18055 | 3076 | 89 |
1602232 | 1602232 | 2021-08-10 | Geneva | Alabama | 1061 | 3076 | 86 |
1604771 | 1604771 | 2021-08-10 | Hickman | Tennessee | 47081 | 3076 | 48 |
1597178 | 1597178 | 2021-08-08 | Prentiss | Mississippi | 28117 | 3076 | 63 |
1593929 | 1593929 | 2021-08-07 | Prentiss | Mississippi | 28117 | 3076 | 63 |
1590680 | 1590680 | 2021-08-06 | Prentiss | Mississippi | 28117 | 3076 | 63 |
1576406 | 1576406 | 2021-08-02 | Glenn | California | 6021 | 3076 | 27 |
1538666 | 1538666 | 2021-07-21 | Coahoma | Mississippi | 28027 | 3076 | 85 |
1531227 | 1531227 | 2021-07-19 | Lumpkin | Georgia | 13187 | 3076 | 82 |
1463657 | 1463657 | 2021-06-28 | Muhlenberg | Kentucky | 21177 | 3076 | 67 |
1414418 | 1414418 | 2021-06-13 | Unknown | Georgia | 3076 | 5 | |
1386008 | 1386008 | 2021-06-04 | Brown | Minnesota | 27015 | 3076 | 40 |
1384296 | 1384296 | 2021-06-03 | Willacy | Texas | 48489 | 3076 | 89 |
1376272 | 1376272 | 2021-06-01 | Brown | Minnesota | 27015 | 3076 | 40 |
1371733 | 1371733 | 2021-05-31 | Lawrence | Alabama | 1079 | 3076 | 100 |
1368487 | 1368487 | 2021-05-30 | Lawrence | Alabama | 1079 | 3076 | 100 |
1365241 | 1365241 | 2021-05-29 | Lawrence | Alabama | 1079 | 3076 | 100 |
1361995 | 1361995 | 2021-05-28 | Lawrence | Alabama | 1079 | 3076 | 100 |
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);