ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where cases = 2413 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 18
- Missouri 11
- Texas 11
- Ohio 10
- Indiana 9
- Kentucky 9
- Oklahoma 9
- South Dakota 9
- Georgia 8
- Louisiana 8
- South Carolina 8
- Alabama 7
- Mississippi 7
- Puerto Rico 7
- Illinois 6
- Kansas 6
- Arkansas 5
- Michigan 5
- Minnesota 5
- Wisconsin 5
- Pennsylvania 4
- Tennessee 4
- California 3
- Colorado 3
- Maryland 3
- New York 3
- North Carolina 3
- Utah 3
- West Virginia 3
- Florida 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492857 | 2492857 | 2022-05-10 | Sussex | Virginia | 51183 | 2413 | 42 |
2440096 | 2440096 | 2022-04-24 | Sabana Grande | Puerto Rico | 72121 | 2413 | |
2337716 | 2337716 | 2022-03-24 | Coffey | Kansas | 20031 | 2413 | 41 |
2334462 | 2334462 | 2022-03-23 | Coffey | Kansas | 20031 | 2413 | 41 |
2333348 | 2333348 | 2022-03-22 | Sussex | Virginia | 51183 | 2413 | 40 |
2330095 | 2330095 | 2022-03-21 | Sussex | Virginia | 51183 | 2413 | 40 |
2326843 | 2326843 | 2022-03-20 | Sussex | Virginia | 51183 | 2413 | 40 |
2323590 | 2323590 | 2022-03-19 | Sussex | Virginia | 51183 | 2413 | 40 |
2320336 | 2320336 | 2022-03-18 | Sussex | Virginia | 51183 | 2413 | 40 |
2317082 | 2317082 | 2022-03-17 | Sussex | Virginia | 51183 | 2413 | 40 |
2264513 | 2264513 | 2022-03-01 | Roberts | South Dakota | 46109 | 2413 | 49 |
2261263 | 2261263 | 2022-02-28 | Roberts | South Dakota | 46109 | 2413 | 49 |
2245008 | 2245008 | 2022-02-23 | Roberts | South Dakota | 46109 | 2413 | 49 |
2235110 | 2235110 | 2022-02-20 | Lajas | Puerto Rico | 72079 | 2413 | |
2221390 | 2221390 | 2022-02-16 | Rosebud | Montana | 30087 | 2413 | 58 |
2195896 | 2195896 | 2022-02-08 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2192642 | 2192642 | 2022-02-07 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2189388 | 2189388 | 2022-02-06 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2186135 | 2186135 | 2022-02-05 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2182883 | 2182883 | 2022-02-04 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2179631 | 2179631 | 2022-02-03 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2176380 | 2176380 | 2022-02-02 | Hughes | Oklahoma | 40063 | 2413 | 49 |
2165713 | 2165713 | 2022-01-30 | Iron | Michigan | 26071 | 2413 | 74 |
2162458 | 2162458 | 2022-01-29 | Iron | Michigan | 26071 | 2413 | 74 |
2159203 | 2159203 | 2022-01-28 | Iron | Michigan | 26071 | 2413 | 74 |
2117640 | 2117640 | 2022-01-15 | Barnes | North Dakota | 38003 | 2413 | 41 |
2092538 | 2092538 | 2022-01-07 | Lamoille | Vermont | 50015 | 2413 | 11 |
2089601 | 2089601 | 2022-01-06 | Converse | Wyoming | 56009 | 2413 | 49 |
2084250 | 2084250 | 2022-01-05 | Caldwell | Louisiana | 22021 | 2413 | 42 |
2024793 | 2024793 | 2021-12-18 | Van Buren | Arkansas | 5141 | 2413 | 44 |
2008087 | 2008087 | 2021-12-12 | Greene | Virginia | 51079 | 2413 | 45 |
2004836 | 2004836 | 2021-12-11 | Greene | Virginia | 51079 | 2413 | 45 |
2001585 | 2001585 | 2021-12-10 | Greene | Virginia | 51079 | 2413 | 45 |
1996016 | 1996016 | 2021-12-09 | Massac | Illinois | 17127 | 2413 | 57 |
1975705 | 1975705 | 2021-12-02 | Braxton | West Virginia | 54007 | 2413 | 25 |
1940052 | 1940052 | 2021-11-21 | Richland | Wisconsin | 55103 | 2413 | 29 |
1936802 | 1936802 | 2021-11-20 | Richland | Wisconsin | 55103 | 2413 | 29 |
1933552 | 1933552 | 2021-11-19 | Richland | Wisconsin | 55103 | 2413 | 29 |
1883199 | 1883199 | 2021-11-04 | Ste. Genevieve | Missouri | 29186 | 2413 | 29 |
1883994 | 1883994 | 2021-11-04 | San Lorenzo | Puerto Rico | 72129 | 2413 | |
1859753 | 1859753 | 2021-10-28 | Atchison | Kansas | 20005 | 2413 | 25 |
1856504 | 1856504 | 2021-10-27 | Atchison | Kansas | 20005 | 2413 | 25 |
1858502 | 1858502 | 2021-10-27 | San Juan | Utah | 49037 | 2413 | 41 |
1854869 | 1854869 | 2021-10-26 | Oglala Lakota | South Dakota | 46102 | 2413 | 53 |
1850515 | 1850515 | 2021-10-25 | Wadena | Minnesota | 27159 | 2413 | 29 |
1825754 | 1825754 | 2021-10-17 | Bosque | Texas | 48035 | 2413 | 55 |
1822505 | 1822505 | 2021-10-16 | Bosque | Texas | 48035 | 2413 | 55 |
1818925 | 1818925 | 2021-10-15 | Montour | Pennsylvania | 42093 | 2413 | 70 |
1819256 | 1819256 | 2021-10-15 | Bosque | Texas | 48035 | 2413 | 55 |
1816007 | 1816007 | 2021-10-14 | Bosque | Texas | 48035 | 2413 | 54 |
1807496 | 1807496 | 2021-10-12 | Ford | Illinois | 17053 | 2413 | 66 |
1802701 | 1802701 | 2021-10-10 | Aguada | Puerto Rico | 72003 | 2413 | |
1799452 | 1799452 | 2021-10-09 | Aguada | Puerto Rico | 72003 | 2413 | |
1796639 | 1796639 | 2021-10-08 | Leon | Texas | 48289 | 2413 | 62 |
1784144 | 1784144 | 2021-10-05 | Crenshaw | Alabama | 1041 | 2413 | 73 |
1783728 | 1783728 | 2021-10-04 | Tyler | Texas | 48457 | 2413 | 65 |
1771139 | 1771139 | 2021-10-01 | Cleburne | Alabama | 1029 | 2413 | 53 |
1770231 | 1770231 | 2021-09-30 | Corozal | Puerto Rico | 72047 | 2413 | |
1756010 | 1756010 | 2021-09-26 | Bienville | Louisiana | 22013 | 2413 | 91 |
1752762 | 1752762 | 2021-09-25 | Bienville | Louisiana | 22013 | 2413 | 91 |
1754515 | 1754515 | 2021-09-25 | Carbon | Utah | 49007 | 2413 | 22 |
1749513 | 1749513 | 2021-09-24 | Bienville | Louisiana | 22013 | 2413 | 91 |
1732850 | 1732850 | 2021-09-19 | Carroll | Indiana | 18015 | 2413 | 29 |
1734663 | 1734663 | 2021-09-19 | Union | South Dakota | 46127 | 2413 | 43 |
1729600 | 1729600 | 2021-09-18 | Carroll | Indiana | 18015 | 2413 | 29 |
1731413 | 1731413 | 2021-09-18 | Union | South Dakota | 46127 | 2413 | 43 |
1726350 | 1726350 | 2021-09-17 | Carroll | Indiana | 18015 | 2413 | 29 |
1728163 | 1728163 | 2021-09-17 | Union | South Dakota | 46127 | 2413 | 43 |
1717107 | 1717107 | 2021-09-14 | Garrett | Maryland | 24023 | 2413 | 69 |
1700757 | 1700757 | 2021-09-09 | Rockcastle | Kentucky | 21203 | 2413 | 25 |
1697147 | 1697147 | 2021-09-08 | Jay | Indiana | 18075 | 2413 | 37 |
1642703 | 1642703 | 2021-08-22 | Clinton | Missouri | 29049 | 2413 | 70 |
1609175 | 1609175 | 2021-08-12 | Lamar | Georgia | 13171 | 2413 | 59 |
1598986 | 1598986 | 2021-08-09 | Hale | Alabama | 1065 | 2413 | 79 |
1580048 | 1580048 | 2021-08-03 | Minidoka | Idaho | 16067 | 2413 | 34 |
1566519 | 1566519 | 2021-07-30 | Pickens | Alabama | 1107 | 2413 | 62 |
1563271 | 1563271 | 2021-07-29 | Pickens | Alabama | 1107 | 2413 | 62 |
1532735 | 1532735 | 2021-07-19 | Transylvania | North Carolina | 37175 | 2413 | 33 |
1517598 | 1517598 | 2021-07-14 | Stevens | Washington | 53065 | 2413 | 32 |
1508665 | 1508665 | 2021-07-12 | Lawrence | Illinois | 17101 | 2413 | 36 |
1486358 | 1486358 | 2021-07-05 | Lincoln | Kentucky | 21137 | 2413 | 59 |
1487375 | 1487375 | 2021-07-05 | Gallia | Ohio | 39053 | 2413 | 50 |
1482166 | 1482166 | 2021-07-04 | Columbia | Arkansas | 5027 | 2413 | 57 |
1483112 | 1483112 | 2021-07-04 | Lincoln | Kentucky | 21137 | 2413 | 59 |
1484128 | 1484128 | 2021-07-04 | Gallia | Ohio | 39053 | 2413 | 50 |
1478919 | 1478919 | 2021-07-03 | Columbia | Arkansas | 5027 | 2413 | 57 |
1479865 | 1479865 | 2021-07-03 | Lincoln | Kentucky | 21137 | 2413 | 59 |
1480882 | 1480882 | 2021-07-03 | Gallia | Ohio | 39053 | 2413 | 50 |
1475673 | 1475673 | 2021-07-02 | Columbia | Arkansas | 5027 | 2413 | 57 |
1476619 | 1476619 | 2021-07-02 | Lincoln | Kentucky | 21137 | 2413 | 59 |
1474389 | 1474389 | 2021-07-01 | Gallia | Ohio | 39053 | 2413 | 50 |
1471143 | 1471143 | 2021-06-30 | Gallia | Ohio | 39053 | 2413 | 50 |
1467898 | 1467898 | 2021-06-29 | Gallia | Ohio | 39053 | 2413 | 50 |
1426055 | 1426055 | 2021-06-16 | Fairfield | South Carolina | 45039 | 2413 | 83 |
1380617 | 1380617 | 2021-06-02 | Fairfield | South Carolina | 45039 | 2413 | 83 |
1375383 | 1375383 | 2021-06-01 | Fannin | Georgia | 13111 | 2413 | 74 |
1377372 | 1377372 | 2021-06-01 | Fairfield | South Carolina | 45039 | 2413 | 83 |
1374126 | 1374126 | 2021-05-31 | Fairfield | South Carolina | 45039 | 2413 | 83 |
1364080 | 1364080 | 2021-05-28 | Pike | Ohio | 39131 | 2413 | 34 |
1337157 | 1337157 | 2021-05-20 | Union | Louisiana | 22111 | 2413 | 78 |
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);