ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where cases = 4670 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 16
- Georgia 15
- Nebraska 7
- North Carolina 7
- South Dakota 7
- Indiana 5
- Kansas 5
- Mississippi 5
- Virginia 5
- Kentucky 4
- Missouri 4
- Texas 4
- Arkansas 3
- Florida 3
- Iowa 3
- Montana 3
- Ohio 3
- Pennsylvania 3
- South Carolina 3
- Colorado 2
- Illinois 2
- Minnesota 2
- New York 2
- Utah 2
- Alabama 1
- California 1
- Louisiana 1
- Massachusetts 1
- Michigan 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497083 | 2497083 | 2022-05-12 | Perry | Indiana | 18123 | 4670 | 69 |
2493825 | 2493825 | 2022-05-11 | Perry | Indiana | 18123 | 4670 | 69 |
2470016 | 2470016 | 2022-05-03 | New Kent | Virginia | 51127 | 4670 | 31 |
2438126 | 2438126 | 2022-04-24 | Crisp | Georgia | 13081 | 4670 | 136 |
2434870 | 2434870 | 2022-04-23 | Crisp | Georgia | 13081 | 4670 | 136 |
2431614 | 2431614 | 2022-04-22 | Crisp | Georgia | 13081 | 4670 | 136 |
2428358 | 2428358 | 2022-04-21 | Crisp | Georgia | 13081 | 4670 | 136 |
2425102 | 2425102 | 2022-04-20 | Crisp | Georgia | 13081 | 4670 | 136 |
2382779 | 2382779 | 2022-04-07 | Crisp | Georgia | 13081 | 4670 | 136 |
2379524 | 2379524 | 2022-04-06 | Crisp | Georgia | 13081 | 4670 | 136 |
2376270 | 2376270 | 2022-04-05 | Crisp | Georgia | 13081 | 4670 | 136 |
2373018 | 2373018 | 2022-04-04 | Crisp | Georgia | 13081 | 4670 | 136 |
2371722 | 2371722 | 2022-04-03 | Morovis | Puerto Rico | 72101 | 4670 | |
2320669 | 2320669 | 2022-03-19 | Drew | Arkansas | 5043 | 4670 | 68 |
2287362 | 2287362 | 2022-03-08 | Polk | Tennessee | 47139 | 4670 | 65 |
2281776 | 2281776 | 2022-03-07 | Elbert | Colorado | 8039 | 4670 | 37 |
2284110 | 2284110 | 2022-03-07 | Polk | Tennessee | 47139 | 4670 | 65 |
2280209 | 2280209 | 2022-03-06 | Hertford | North Carolina | 37091 | 4670 | 81 |
2280858 | 2280858 | 2022-03-06 | Polk | Tennessee | 47139 | 4670 | 65 |
2276956 | 2276956 | 2022-03-05 | Hertford | North Carolina | 37091 | 4670 | 81 |
2277605 | 2277605 | 2022-03-05 | Polk | Tennessee | 47139 | 4670 | 65 |
2273703 | 2273703 | 2022-03-04 | Hertford | North Carolina | 37091 | 4670 | 81 |
2274352 | 2274352 | 2022-03-04 | Polk | Tennessee | 47139 | 4670 | 65 |
2271099 | 2271099 | 2022-03-03 | Polk | Tennessee | 47139 | 4670 | 65 |
2267847 | 2267847 | 2022-03-02 | Polk | Tennessee | 47139 | 4670 | 65 |
2259844 | 2259844 | 2022-02-28 | Powell | Kentucky | 21197 | 4670 | 37 |
2261459 | 2261459 | 2022-02-28 | Gonzales | Texas | 48177 | 4670 | 95 |
2209427 | 2209427 | 2022-02-12 | Fayette | Texas | 48149 | 4670 | 99 |
2168164 | 2168164 | 2022-01-31 | Lamar | Georgia | 13171 | 4670 | 105 |
2152041 | 2152041 | 2022-01-26 | Edgar | Illinois | 17045 | 4670 | 75 |
2111574 | 2111574 | 2022-01-13 | Jasper | South Carolina | 45053 | 4670 | 82 |
2083236 | 2083236 | 2022-01-05 | Carroll | Arkansas | 5015 | 4670 | 81 |
2061951 | 2061951 | 2021-12-29 | Saline | Missouri | 29195 | 4670 | 86 |
1983990 | 1983990 | 2021-12-05 | Lake | Montana | 30047 | 4670 | 83 |
1980740 | 1980740 | 2021-12-04 | Lake | Montana | 30047 | 4670 | 83 |
1977490 | 1977490 | 2021-12-03 | Lake | Montana | 30047 | 4670 | 83 |
1969980 | 1969980 | 2021-12-01 | Fayette | Illinois | 17051 | 4670 | 73 |
1949993 | 1949993 | 2021-11-25 | Johnson | Arkansas | 5071 | 4670 | 58 |
1937933 | 1937933 | 2021-11-21 | Montgomery | Kentucky | 21173 | 4670 | 60 |
1934683 | 1934683 | 2021-11-20 | Montgomery | Kentucky | 21173 | 4670 | 60 |
1931432 | 1931432 | 2021-11-19 | Montgomery | Kentucky | 21173 | 4670 | 60 |
1884725 | 1884725 | 2021-11-04 | Mingo | West Virginia | 54059 | 4670 | 82 |
1859262 | 1859262 | 2021-10-28 | Butts | Georgia | 13035 | 4670 | 113 |
1844926 | 1844926 | 2021-10-23 | Snyder | Pennsylvania | 42109 | 4670 | 102 |
1830088 | 1830088 | 2021-10-19 | Lee | Georgia | 13177 | 4670 | 79 |
1799242 | 1799242 | 2021-10-09 | Ottawa | Ohio | 39123 | 4670 | 85 |
1771137 | 1771137 | 2021-10-01 | Clarke | Alabama | 1025 | 4670 | 80 |
1739380 | 1739380 | 2021-09-21 | Jefferson | Indiana | 18077 | 4670 | 92 |
1740615 | 1740615 | 2021-09-21 | Person | North Carolina | 37145 | 4670 | 78 |
1725062 | 1725062 | 2021-09-16 | Cooke | Texas | 48097 | 4670 | 80 |
1694116 | 1694116 | 2021-09-07 | Montgomery | Kansas | 20125 | 4670 | 95 |
1690867 | 1690867 | 2021-09-06 | Montgomery | Kansas | 20125 | 4670 | 95 |
1687617 | 1687617 | 2021-09-05 | Montgomery | Kansas | 20125 | 4670 | 95 |
1684367 | 1684367 | 2021-09-04 | Montgomery | Kansas | 20125 | 4670 | 95 |
1684992 | 1684992 | 2021-09-04 | Pulaski | Missouri | 29169 | 4670 | 65 |
1681116 | 1681116 | 2021-09-03 | Montgomery | Kansas | 20125 | 4670 | 95 |
1672288 | 1672288 | 2021-08-31 | Montgomery | New York | 36057 | 4670 | 130 |
1656261 | 1656261 | 2021-08-26 | Fulton | Ohio | 39051 | 4670 | 78 |
1645177 | 1645177 | 2021-08-23 | Knox | Indiana | 18083 | 4670 | 92 |
1633014 | 1633014 | 2021-08-19 | Polk | Missouri | 29167 | 4670 | 51 |
1613499 | 1613499 | 2021-08-13 | Laclede | Missouri | 29105 | 4670 | 96 |
1607322 | 1607322 | 2021-08-11 | Madison | New York | 36053 | 4670 | 89 |
1587315 | 1587315 | 2021-08-05 | Itasca | Minnesota | 27061 | 4670 | 68 |
1581934 | 1581934 | 2021-08-03 | Codington | South Dakota | 46029 | 4670 | 82 |
1578685 | 1578685 | 2021-08-02 | Codington | South Dakota | 46029 | 4670 | 82 |
1578752 | 1578752 | 2021-08-02 | Cocke | Tennessee | 47029 | 4670 | 102 |
1575437 | 1575437 | 2021-08-01 | Codington | South Dakota | 46029 | 4670 | 82 |
1572189 | 1572189 | 2021-07-31 | Codington | South Dakota | 46029 | 4670 | 82 |
1568941 | 1568941 | 2021-07-30 | Codington | South Dakota | 46029 | 4670 | 82 |
1565693 | 1565693 | 2021-07-29 | Codington | South Dakota | 46029 | 4670 | 82 |
1562445 | 1562445 | 2021-07-28 | Codington | South Dakota | 46029 | 4670 | 82 |
1558182 | 1558182 | 2021-07-27 | Marshall | Mississippi | 28093 | 4670 | 106 |
1498254 | 1498254 | 2021-07-08 | Albany | Wyoming | 56001 | 4670 | 17 |
1474840 | 1474840 | 2021-07-01 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1449325 | 1449325 | 2021-06-23 | Henry | Virginia | 51089 | 4670 | 124 |
1444248 | 1444248 | 2021-06-22 | Lincoln | Louisiana | 22061 | 4670 | 93 |
1445633 | 1445633 | 2021-06-22 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1442388 | 1442388 | 2021-06-21 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1438073 | 1438073 | 2021-06-20 | Panola | Mississippi | 28107 | 4670 | 110 |
1438353 | 1438353 | 2021-06-20 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1439143 | 1439143 | 2021-06-20 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1434826 | 1434826 | 2021-06-19 | Panola | Mississippi | 28107 | 4670 | 110 |
1435106 | 1435106 | 2021-06-19 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1435896 | 1435896 | 2021-06-19 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1431579 | 1431579 | 2021-06-18 | Panola | Mississippi | 28107 | 4670 | 110 |
1431859 | 1431859 | 2021-06-18 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1432649 | 1432649 | 2021-06-18 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1428614 | 1428614 | 2021-06-17 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1429403 | 1429403 | 2021-06-17 | Cheatham | Tennessee | 47021 | 4670 | 56 |
1425369 | 1425369 | 2021-06-16 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1422121 | 1422121 | 2021-06-15 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1418876 | 1418876 | 2021-06-14 | Scotts Bluff | Nebraska | 31157 | 4670 | 96 |
1410376 | 1410376 | 2021-06-11 | Henry | Virginia | 51089 | 4670 | 124 |
1396678 | 1396678 | 2021-06-07 | Bedford | Pennsylvania | 42009 | 4670 | 139 |
1371350 | 1371350 | 2021-05-30 | Wasatch | Utah | 49051 | 4670 | 22 |
1368104 | 1368104 | 2021-05-29 | Wasatch | Utah | 49051 | 4670 | 22 |
1362706 | 1362706 | 2021-05-28 | Lawrence | Indiana | 18093 | 4670 | 124 |
1355904 | 1355904 | 2021-05-26 | Effingham | Georgia | 13103 | 4670 | 69 |
1352658 | 1352658 | 2021-05-25 | Effingham | Georgia | 13103 | 4670 | 69 |
1350881 | 1350881 | 2021-05-24 | Beaufort | North Carolina | 37013 | 4670 | 95 |
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);