ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where cases = 2683 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Virginia 15
- Georgia 14
- Iowa 14
- Illinois 10
- Indiana 9
- Kentucky 9
- Louisiana 9
- North Carolina 9
- Oklahoma 9
- Mississippi 8
- Missouri 8
- Alabama 7
- Puerto Rico 7
- Tennessee 6
- Washington 6
- Ohio 4
- Oregon 4
- Wisconsin 4
- Arkansas 3
- Maine 3
- Massachusetts 3
- Michigan 3
- South Dakota 3
- Florida 2
- Maryland 2
- Minnesota 2
- Nebraska 2
- New York 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502514 | 2502514 | 2022-05-13 | Amelia | Virginia | 51007 | 2683 | 61 |
2486469 | 2486469 | 2022-05-08 | Forest | Wisconsin | 55041 | 2683 | 52 |
2483211 | 2483211 | 2022-05-07 | Forest | Wisconsin | 55041 | 2683 | 52 |
2479146 | 2479146 | 2022-05-06 | Jayuya | Puerto Rico | 72073 | 2683 | |
2479953 | 2479953 | 2022-05-06 | Forest | Wisconsin | 55041 | 2683 | 52 |
2470896 | 2470896 | 2022-05-04 | Jasper | Illinois | 17079 | 2683 | 32 |
2467640 | 2467640 | 2022-05-03 | Jasper | Illinois | 17079 | 2683 | 32 |
2464385 | 2464385 | 2022-05-02 | Jasper | Illinois | 17079 | 2683 | 32 |
2338395 | 2338395 | 2022-03-24 | Ripley | Missouri | 29181 | 2683 | 61 |
2335141 | 2335141 | 2022-03-23 | Ripley | Missouri | 29181 | 2683 | 61 |
2313790 | 2313790 | 2022-03-16 | Nelson | Virginia | 51125 | 2683 | 32 |
2287773 | 2287773 | 2022-03-08 | Nelson | Virginia | 51125 | 2683 | 32 |
2246874 | 2246874 | 2022-02-24 | Catahoula | Louisiana | 22025 | 2683 | 55 |
2240117 | 2240117 | 2022-02-22 | Shelby | Iowa | 19165 | 2683 | 49 |
2236866 | 2236866 | 2022-02-21 | Shelby | Iowa | 19165 | 2683 | 49 |
2237184 | 2237184 | 2022-02-21 | Piscataquis | Maine | 23021 | 2683 | 27 |
2233615 | 2233615 | 2022-02-20 | Shelby | Iowa | 19165 | 2683 | 49 |
2230364 | 2230364 | 2022-02-19 | Shelby | Iowa | 19165 | 2683 | 49 |
2227113 | 2227113 | 2022-02-18 | Shelby | Iowa | 19165 | 2683 | 49 |
2223862 | 2223862 | 2022-02-17 | Shelby | Iowa | 19165 | 2683 | 49 |
2220611 | 2220611 | 2022-02-16 | Shelby | Iowa | 19165 | 2683 | 49 |
2212984 | 2212984 | 2022-02-13 | Manassas Park city | Virginia | 51685 | 2683 | 16 |
2209731 | 2209731 | 2022-02-12 | Manassas Park city | Virginia | 51685 | 2683 | 16 |
2206478 | 2206478 | 2022-02-11 | Manassas Park city | Virginia | 51685 | 2683 | 16 |
2203298 | 2203298 | 2022-02-10 | Jefferson | Washington | 53031 | 2683 | 24 |
2197446 | 2197446 | 2022-02-09 | Long | Georgia | 13183 | 2683 | 31 |
2200044 | 2200044 | 2022-02-09 | Jefferson | Washington | 53031 | 2683 | 24 |
2187643 | 2187643 | 2022-02-06 | Early | Georgia | 13099 | 2683 | 59 |
2184390 | 2184390 | 2022-02-05 | Early | Georgia | 13099 | 2683 | 59 |
2181138 | 2181138 | 2022-02-04 | Early | Georgia | 13099 | 2683 | 59 |
2143151 | 2143151 | 2022-01-23 | Webster | Mississippi | 28155 | 2683 | 51 |
2139896 | 2139896 | 2022-01-22 | Webster | Mississippi | 28155 | 2683 | 51 |
2136640 | 2136640 | 2022-01-21 | Webster | Mississippi | 28155 | 2683 | 51 |
2099778 | 2099778 | 2022-01-10 | Bleckley | Georgia | 13023 | 2683 | 86 |
2096822 | 2096822 | 2022-01-09 | Washington | Illinois | 17189 | 2683 | 37 |
2093570 | 2093570 | 2022-01-08 | Washington | Illinois | 17189 | 2683 | 37 |
2090318 | 2090318 | 2022-01-07 | Washington | Illinois | 17189 | 2683 | 37 |
2083181 | 2083181 | 2022-01-05 | Washington | Alabama | 1129 | 2683 | 51 |
2085761 | 2085761 | 2022-01-05 | Bosque | Texas | 48035 | 2683 | 59 |
2077631 | 2077631 | 2022-01-03 | Butler | Kentucky | 21031 | 2683 | 44 |
2058129 | 2058129 | 2021-12-28 | Caldwell | Kentucky | 21033 | 2683 | 53 |
2055056 | 2055056 | 2021-12-27 | Lincoln | Maine | 23015 | 2683 | 11 |
2036155 | 2036155 | 2021-12-21 | Unknown | New Hampshire | 2683 | 18 | |
2031506 | 2031506 | 2021-12-20 | Bacon | Georgia | 13005 | 2683 | 64 |
2033084 | 2033084 | 2021-12-20 | Northampton | North Carolina | 37131 | 2683 | 66 |
2019295 | 2019295 | 2021-12-16 | Winn | Louisiana | 22127 | 2683 | 58 |
2007340 | 2007340 | 2021-12-12 | Clatsop | Oregon | 41007 | 2683 | 35 |
2008124 | 2008124 | 2021-12-12 | Nottoway | Virginia | 51135 | 2683 | 70 |
2004089 | 2004089 | 2021-12-11 | Clatsop | Oregon | 41007 | 2683 | 35 |
2004873 | 2004873 | 2021-12-11 | Nottoway | Virginia | 51135 | 2683 | 70 |
2000838 | 2000838 | 2021-12-10 | Clatsop | Oregon | 41007 | 2683 | 35 |
2001622 | 2001622 | 2021-12-10 | Nottoway | Virginia | 51135 | 2683 | 70 |
1992612 | 1992612 | 2021-12-08 | Rabun | Georgia | 13241 | 2683 | 76 |
1991301 | 1991301 | 2021-12-07 | Lee | South Carolina | 45061 | 2683 | 79 |
1974306 | 1974306 | 2021-12-02 | Gage | Nebraska | 31067 | 2683 | 30 |
1931958 | 1931958 | 2021-11-19 | Wright | Missouri | 29229 | 2683 | 63 |
1921795 | 1921795 | 2021-11-16 | Waldo | Maine | 23027 | 2683 | 34 |
1922803 | 1922803 | 2021-11-16 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1919554 | 1919554 | 2021-11-15 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1916304 | 1916304 | 2021-11-14 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1913054 | 1913054 | 2021-11-13 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1909804 | 1909804 | 2021-11-12 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1906555 | 1906555 | 2021-11-11 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1903306 | 1903306 | 2021-11-10 | Pawnee | Oklahoma | 40117 | 2683 | 66 |
1881291 | 1881291 | 2021-11-03 | Buckingham | Virginia | 51029 | 2683 | 38 |
1875709 | 1875709 | 2021-11-02 | Cass | Illinois | 17017 | 2683 | 40 |
1875775 | 1875775 | 2021-11-02 | Pike | Illinois | 17149 | 2683 | 61 |
1872616 | 1872616 | 2021-11-01 | Perry | Indiana | 18123 | 2683 | 55 |
1819984 | 1819984 | 2021-10-16 | Clay | Arkansas | 5021 | 2683 | 66 |
1812009 | 1812009 | 2021-10-13 | Seneca | New York | 36099 | 2683 | 62 |
1805742 | 1805742 | 2021-10-11 | Paulding | Ohio | 39125 | 2683 | 44 |
1801517 | 1801517 | 2021-10-10 | LaSalle | Louisiana | 22059 | 2683 | 45 |
1798268 | 1798268 | 2021-10-09 | LaSalle | Louisiana | 22059 | 2683 | 45 |
1795019 | 1795019 | 2021-10-08 | LaSalle | Louisiana | 22059 | 2683 | 45 |
1782826 | 1782826 | 2021-10-04 | Hertford | North Carolina | 37091 | 2683 | 69 |
1765842 | 1765842 | 2021-09-29 | Garrett | Maryland | 24023 | 2683 | 71 |
1723598 | 1723598 | 2021-09-16 | Caroline | Maryland | 24011 | 2683 | 38 |
1721389 | 1721389 | 2021-09-15 | Lincoln | Oregon | 41041 | 2683 | 29 |
1722113 | 1722113 | 2021-09-15 | Fredericksburg city | Virginia | 51630 | 2683 | 25 |
1712775 | 1712775 | 2021-09-13 | Cross | Arkansas | 5037 | 2683 | 58 |
1699443 | 1699443 | 2021-09-08 | Salem city | Virginia | 51775 | 2683 | 51 |
1693646 | 1693646 | 2021-09-07 | Meriwether | Georgia | 13199 | 2683 | 93 |
1675089 | 1675089 | 2021-09-01 | Clay | Mississippi | 28025 | 2683 | 64 |
1665023 | 1665023 | 2021-08-29 | Rowan | Kentucky | 21205 | 2683 | 22 |
1660721 | 1660721 | 2021-08-28 | Monroe | Alabama | 1099 | 2683 | 42 |
1661775 | 1661775 | 2021-08-28 | Rowan | Kentucky | 21205 | 2683 | 22 |
1658527 | 1658527 | 2021-08-27 | Rowan | Kentucky | 21205 | 2683 | 22 |
1656579 | 1656579 | 2021-08-26 | Vega Alta | Puerto Rico | 72143 | 2683 | |
1652422 | 1652422 | 2021-08-25 | Winston | Mississippi | 28159 | 2683 | 88 |
1642720 | 1642720 | 2021-08-22 | Henry | Missouri | 29083 | 2683 | 41 |
1643144 | 1643144 | 2021-08-22 | Martin | North Carolina | 37117 | 2683 | 50 |
1643948 | 1643948 | 2021-08-22 | Lampasas | Texas | 48281 | 2683 | 39 |
1639894 | 1639894 | 2021-08-21 | Martin | North Carolina | 37117 | 2683 | 50 |
1640698 | 1640698 | 2021-08-21 | Lampasas | Texas | 48281 | 2683 | 39 |
1636644 | 1636644 | 2021-08-20 | Martin | North Carolina | 37117 | 2683 | 50 |
1623623 | 1623623 | 2021-08-16 | Dare | North Carolina | 37055 | 2683 | 10 |
1619677 | 1619677 | 2021-08-15 | Franklin | Massachusetts | 25011 | 2683 | 114 |
1621536 | 1621536 | 2021-08-15 | Stevens | Washington | 53065 | 2683 | 32 |
1616429 | 1616429 | 2021-08-14 | Franklin | Massachusetts | 25011 | 2683 | 114 |
1618288 | 1618288 | 2021-08-14 | Stevens | Washington | 53065 | 2683 | 32 |
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);