ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4367 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 10
- Illinois 9
- Kentucky 9
- Georgia 7
- Texas 7
- Missouri 6
- Arkansas 5
- Indiana 5
- Mississippi 5
- Tennessee 5
- Alabama 4
- Ohio 4
- Virginia 4
- North Carolina 3
- Puerto Rico 3
- Colorado 2
- New York 2
- Oklahoma 2
- Pennsylvania 2
- West Virginia 2
- Wisconsin 2
- California 1
- Idaho 1
- Iowa 1
- Maryland 1
- Michigan 1
- New Mexico 1
- South Carolina 1
- South Dakota 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502734 | 2502734 | 2022-05-13 | Wetzel | West Virginia | 54103 | 4367 | 86 |
2330931 | 2330931 | 2022-03-22 | Hancock | Illinois | 17067 | 4367 | 57 |
2324937 | 2324937 | 2022-03-20 | Jackson | Louisiana | 22049 | 4367 | 74 |
2321683 | 2321683 | 2022-03-19 | Jackson | Louisiana | 22049 | 4367 | 74 |
2318429 | 2318429 | 2022-03-18 | Jackson | Louisiana | 22049 | 4367 | 74 |
2311452 | 2311452 | 2022-03-16 | Piatt | Illinois | 17147 | 4367 | 29 |
2308199 | 2308199 | 2022-03-15 | Piatt | Illinois | 17147 | 4367 | 29 |
2297354 | 2297354 | 2022-03-11 | Shelby | Texas | 48419 | 4367 | 127 |
2294208 | 2294208 | 2022-03-10 | Bristol city | Virginia | 51520 | 4367 | 72 |
2268636 | 2268636 | 2022-03-03 | Grant | Arkansas | 5053 | 4367 | 58 |
2265383 | 2265383 | 2022-03-02 | Grant | Arkansas | 5053 | 4367 | 58 |
2236615 | 2236615 | 2022-02-21 | Ford | Illinois | 17053 | 4367 | 71 |
2233364 | 2233364 | 2022-02-20 | Ford | Illinois | 17053 | 4367 | 71 |
2230113 | 2230113 | 2022-02-19 | Ford | Illinois | 17053 | 4367 | 71 |
2226862 | 2226862 | 2022-02-18 | Ford | Illinois | 17053 | 4367 | 71 |
2186311 | 2186311 | 2022-02-05 | Fajardo | Puerto Rico | 72053 | 4367 | |
2178869 | 2178869 | 2022-02-03 | Calhoun | Mississippi | 28013 | 4367 | 56 |
2180459 | 2180459 | 2022-02-03 | New Kent | Virginia | 51127 | 4367 | 29 |
2169108 | 2169108 | 2022-01-31 | Attala | Mississippi | 28007 | 4367 | 94 |
2148470 | 2148470 | 2022-01-25 | Teller | Colorado | 8119 | 4367 | 54 |
2142767 | 2142767 | 2022-01-23 | Spencer | Kentucky | 21215 | 4367 | 44 |
2139512 | 2139512 | 2022-01-22 | Spencer | Kentucky | 21215 | 4367 | 44 |
2136256 | 2136256 | 2022-01-21 | Spencer | Kentucky | 21215 | 4367 | 44 |
2105874 | 2105874 | 2022-01-11 | Uinta | Wyoming | 56041 | 4367 | 34 |
2052216 | 2052216 | 2021-12-26 | Stone | Missouri | 29209 | 4367 | 100 |
2048966 | 2048966 | 2021-12-25 | Stone | Missouri | 29209 | 4367 | 100 |
2045716 | 2045716 | 2021-12-24 | Stone | Missouri | 29209 | 4367 | 100 |
2042466 | 2042466 | 2021-12-23 | Stone | Missouri | 29209 | 4367 | 100 |
2016792 | 2016792 | 2021-12-15 | Dare | North Carolina | 37055 | 4367 | 15 |
2005609 | 2005609 | 2021-12-12 | Pierce | Georgia | 13229 | 4367 | 106 |
2002358 | 2002358 | 2021-12-11 | Pierce | Georgia | 13229 | 4367 | 106 |
1999108 | 1999108 | 2021-12-10 | Pierce | Georgia | 13229 | 4367 | 106 |
1988855 | 1988855 | 2021-12-07 | Bibb | Alabama | 1007 | 4367 | 95 |
1966680 | 1966680 | 2021-11-30 | Elmore | Idaho | 16039 | 4367 | 51 |
1938988 | 1938988 | 2021-11-21 | Van Wert | Ohio | 39161 | 4367 | 87 |
1906634 | 1906634 | 2021-11-11 | Elk | Pennsylvania | 42047 | 4367 | 64 |
1860386 | 1860386 | 2021-10-28 | Dunklin | Missouri | 29069 | 4367 | 61 |
1856647 | 1856647 | 2021-10-27 | Grant | Kentucky | 21081 | 4367 | 39 |
1836305 | 1836305 | 2021-10-21 | Glenn | California | 6021 | 4367 | 42 |
1811614 | 1811614 | 2021-10-13 | Yazoo | Mississippi | 28163 | 4367 | 86 |
1809526 | 1809526 | 2021-10-12 | Cass | Texas | 48067 | 4367 | 136 |
1782367 | 1782367 | 2021-10-04 | Wayne | Mississippi | 28153 | 4367 | 71 |
1778780 | 1778780 | 2021-10-03 | Morehouse | Louisiana | 22067 | 4367 | 110 |
1780032 | 1780032 | 2021-10-03 | Vega Baja | Puerto Rico | 72145 | 4367 | |
1775530 | 1775530 | 2021-10-02 | Morehouse | Louisiana | 22067 | 4367 | 110 |
1772280 | 1772280 | 2021-10-01 | Morehouse | Louisiana | 22067 | 4367 | 110 |
1761795 | 1761795 | 2021-09-28 | Chattooga | Georgia | 13055 | 4367 | 89 |
1745281 | 1745281 | 2021-09-23 | Johnson | Arkansas | 5071 | 4367 | 56 |
1747705 | 1747705 | 2021-09-23 | Hickman | Tennessee | 47081 | 4367 | 65 |
1721478 | 1721478 | 2021-09-15 | Arecibo | Puerto Rico | 72013 | 4367 | |
1700777 | 1700777 | 2021-09-09 | Allen | Louisiana | 22003 | 4367 | 102 |
1701554 | 1701554 | 2021-09-09 | Warren | New York | 36113 | 4367 | 76 |
1693335 | 1693335 | 2021-09-07 | St. Francis | Arkansas | 5123 | 4367 | 53 |
1668174 | 1668174 | 2021-08-30 | Bell | Kentucky | 21013 | 4367 | 62 |
1650534 | 1650534 | 2021-08-24 | Upshur | Texas | 48459 | 4367 | 82 |
1625694 | 1625694 | 2021-08-17 | Miami | Indiana | 18103 | 4367 | 75 |
1607324 | 1607324 | 2021-08-11 | Montgomery | New York | 36057 | 4367 | 128 |
1605058 | 1605058 | 2021-08-10 | Uvalde | Texas | 48463 | 4367 | 75 |
1559854 | 1559854 | 2021-07-27 | Ohio | West Virginia | 54069 | 4367 | 87 |
1555902 | 1555902 | 2021-07-26 | Chester | South Carolina | 45023 | 4367 | 78 |
1556339 | 1556339 | 2021-07-26 | Wharton | Texas | 48481 | 4367 | 120 |
1530774 | 1530774 | 2021-07-19 | Franklin | Alabama | 1059 | 4367 | 81 |
1532215 | 1532215 | 2021-07-19 | Pontotoc | Mississippi | 28115 | 4367 | 73 |
1460365 | 1460365 | 2021-06-27 | Graves | Kentucky | 21083 | 4367 | 96 |
1461384 | 1461384 | 2021-06-27 | Ashland | Ohio | 39005 | 4367 | 97 |
1457120 | 1457120 | 2021-06-26 | Graves | Kentucky | 21083 | 4367 | 96 |
1458139 | 1458139 | 2021-06-26 | Ashland | Ohio | 39005 | 4367 | 97 |
1453875 | 1453875 | 2021-06-25 | Graves | Kentucky | 21083 | 4367 | 96 |
1450629 | 1450629 | 2021-06-24 | Graves | Kentucky | 21083 | 4367 | 96 |
1419875 | 1419875 | 2021-06-14 | Jim Wells | Texas | 48249 | 4367 | 106 |
1416630 | 1416630 | 2021-06-13 | Jim Wells | Texas | 48249 | 4367 | 106 |
1378902 | 1378902 | 2021-06-02 | DeKalb | Indiana | 18033 | 4367 | 88 |
1323728 | 1323728 | 2021-05-16 | Harrison | Indiana | 18061 | 4367 | 74 |
1320482 | 1320482 | 2021-05-15 | Harrison | Indiana | 18061 | 4367 | 74 |
1317230 | 1317230 | 2021-05-14 | Gibson | Indiana | 18051 | 4367 | 95 |
1315832 | 1315832 | 2021-05-13 | Lincoln | Tennessee | 47103 | 4367 | 63 |
1301448 | 1301448 | 2021-05-09 | Washington | Louisiana | 22117 | 4367 | 131 |
1298201 | 1298201 | 2021-05-08 | Washington | Louisiana | 22117 | 4367 | 131 |
1294955 | 1294955 | 2021-05-07 | Washington | Louisiana | 22117 | 4367 | 131 |
1224816 | 1224816 | 2021-04-15 | Codington | South Dakota | 46029 | 4367 | 80 |
1209091 | 1209091 | 2021-04-10 | James City | Virginia | 51095 | 4367 | 70 |
1200263 | 1200263 | 2021-04-08 | Marion | Illinois | 17121 | 4367 | 120 |
1190682 | 1190682 | 2021-04-05 | Des Moines | Iowa | 19057 | 4367 | 64 |
1168408 | 1168408 | 2021-03-29 | Isabella | Michigan | 26073 | 4367 | 77 |
1135052 | 1135052 | 2021-03-19 | Baldwin | Georgia | 13009 | 4367 | 119 |
1122111 | 1122111 | 2021-03-15 | Effingham | Georgia | 13103 | 4367 | 64 |
1085307 | 1085307 | 2021-03-03 | Obion | Tennessee | 47131 | 4367 | 95 |
1079422 | 1079422 | 2021-03-01 | Pierce | Wisconsin | 55093 | 4367 | 39 |
1059944 | 1059944 | 2021-02-23 | Monroe | Wisconsin | 55081 | 4367 | 32 |
995106 | 995106 | 2021-02-04 | Dale | Alabama | 1045 | 4367 | 102 |
984650 | 984650 | 2021-01-31 | Franklin | Tennessee | 47051 | 4367 | 70 |
941456 | 941456 | 2021-01-18 | Joplin | Missouri | 4367 | 88 | |
935575 | 935575 | 2021-01-16 | Carter | Oklahoma | 40019 | 4367 | 20 |
906366 | 906366 | 2021-01-07 | Bryan | Oklahoma | 40013 | 4367 | 39 |
880862 | 880862 | 2020-12-30 | Warren | Tennessee | 47177 | 4367 | 41 |
855537 | 855537 | 2020-12-23 | Blount | Alabama | 1009 | 4367 | 57 |
819588 | 819588 | 2020-12-11 | Montgomery | Virginia | 51121 | 4367 | 28 |
813941 | 813941 | 2020-12-10 | Boone | Illinois | 17007 | 4367 | 48 |
789501 | 789501 | 2020-12-02 | Pickaway | Ohio | 39129 | 4367 | 49 |
758344 | 758344 | 2020-11-23 | Saline | Arkansas | 5125 | 4367 | 54 |
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);