ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 6404 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Mississippi 24
- Kentucky 11
- Iowa 10
- Tennessee 9
- Florida 7
- Louisiana 5
- Pennsylvania 5
- Texas 5
- Michigan 3
- Ohio 3
- Virginia 3
- Arkansas 2
- Indiana 2
- Missouri 2
- North Carolina 2
- Colorado 1
- Georgia 1
- Idaho 1
- Minnesota 1
- Montana 1
- New Jersey 1
- New Mexico 1
- New York 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Virgin Islands 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500383 | 2500383 | 2022-05-13 | Buena Vista | Iowa | 19021 | 6404 | 58 |
2497125 | 2497125 | 2022-05-12 | Buena Vista | Iowa | 19021 | 6404 | 58 |
2493867 | 2493867 | 2022-05-11 | Buena Vista | Iowa | 19021 | 6404 | 58 |
2467807 | 2467807 | 2022-05-03 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2464552 | 2464552 | 2022-05-02 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2461296 | 2461296 | 2022-05-01 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2458040 | 2458040 | 2022-04-30 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2454784 | 2454784 | 2022-04-29 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2451528 | 2451528 | 2022-04-28 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2448272 | 2448272 | 2022-04-27 | Buena Vista | Iowa | 19021 | 6404 | 57 |
2442409 | 2442409 | 2022-04-25 | Leake | Mississippi | 28079 | 6404 | 120 |
2439153 | 2439153 | 2022-04-24 | Leake | Mississippi | 28079 | 6404 | 120 |
2435897 | 2435897 | 2022-04-23 | Leake | Mississippi | 28079 | 6404 | 120 |
2432641 | 2432641 | 2022-04-22 | Leake | Mississippi | 28079 | 6404 | 120 |
2429385 | 2429385 | 2022-04-21 | Leake | Mississippi | 28079 | 6404 | 120 |
2426129 | 2426129 | 2022-04-20 | Leake | Mississippi | 28079 | 6404 | 120 |
2422873 | 2422873 | 2022-04-19 | Leake | Mississippi | 28079 | 6404 | 120 |
2419617 | 2419617 | 2022-04-18 | Leake | Mississippi | 28079 | 6404 | 120 |
2370440 | 2370440 | 2022-04-03 | Russell | Kentucky | 21207 | 6404 | 86 |
2367187 | 2367187 | 2022-04-02 | Russell | Kentucky | 21207 | 6404 | 86 |
2363934 | 2363934 | 2022-04-01 | Russell | Kentucky | 21207 | 6404 | 86 |
2360680 | 2360680 | 2022-03-31 | Russell | Kentucky | 21207 | 6404 | 86 |
2357426 | 2357426 | 2022-03-30 | Russell | Kentucky | 21207 | 6404 | 86 |
2354173 | 2354173 | 2022-03-29 | Russell | Kentucky | 21207 | 6404 | 86 |
2350921 | 2350921 | 2022-03-28 | Russell | Kentucky | 21207 | 6404 | 86 |
2328203 | 2328203 | 2022-03-21 | Plaquemines | Louisiana | 22075 | 6404 | 45 |
2324950 | 2324950 | 2022-03-20 | Plaquemines | Louisiana | 22075 | 6404 | 45 |
2321696 | 2321696 | 2022-03-19 | Plaquemines | Louisiana | 22075 | 6404 | 45 |
2318442 | 2318442 | 2022-03-18 | Plaquemines | Louisiana | 22075 | 6404 | 45 |
2315189 | 2315189 | 2022-03-17 | Plaquemines | Louisiana | 22075 | 6404 | 45 |
2291387 | 2291387 | 2022-03-10 | Cleburne | Arkansas | 5023 | 6404 | 125 |
2282877 | 2282877 | 2022-03-07 | Le Sueur | Minnesota | 27079 | 6404 | 49 |
2248110 | 2248110 | 2022-02-24 | Isabela | Puerto Rico | 72071 | 6404 | |
2237416 | 2237416 | 2022-02-21 | Coahoma | Mississippi | 28027 | 6404 | 119 |
2234165 | 2234165 | 2022-02-20 | Coahoma | Mississippi | 28027 | 6404 | 119 |
2230914 | 2230914 | 2022-02-19 | Coahoma | Mississippi | 28027 | 6404 | 119 |
2227663 | 2227663 | 2022-02-18 | Coahoma | Mississippi | 28027 | 6404 | 119 |
2211274 | 2211274 | 2022-02-13 | Mason | Michigan | 26105 | 6404 | 82 |
2208021 | 2208021 | 2022-02-12 | Mason | Michigan | 26105 | 6404 | 82 |
2204768 | 2204768 | 2022-02-11 | Mason | Michigan | 26105 | 6404 | 82 |
2196309 | 2196309 | 2022-02-08 | Overton | Tennessee | 47133 | 6404 | 118 |
2193055 | 2193055 | 2022-02-07 | Overton | Tennessee | 47133 | 6404 | 118 |
2189801 | 2189801 | 2022-02-06 | Overton | Tennessee | 47133 | 6404 | 118 |
2186548 | 2186548 | 2022-02-05 | Overton | Tennessee | 47133 | 6404 | 118 |
2183296 | 2183296 | 2022-02-04 | Overton | Tennessee | 47133 | 6404 | 118 |
2180044 | 2180044 | 2022-02-03 | Overton | Tennessee | 47133 | 6404 | 118 |
2176793 | 2176793 | 2022-02-02 | Overton | Tennessee | 47133 | 6404 | 118 |
2110587 | 2110587 | 2022-01-13 | Lincoln | Mississippi | 28085 | 6404 | 139 |
2112057 | 2112057 | 2022-01-13 | St. Thomas | Virgin Islands | 78030 | 6404 | 48 |
2097133 | 2097133 | 2022-01-09 | Bell | Kentucky | 21013 | 6404 | 121 |
2093881 | 2093881 | 2022-01-08 | Bell | Kentucky | 21013 | 6404 | 121 |
2094951 | 2094951 | 2022-01-08 | Coshocton | Ohio | 39031 | 6404 | 136 |
2090629 | 2090629 | 2022-01-07 | Bell | Kentucky | 21013 | 6404 | 121 |
2079792 | 2079792 | 2022-01-03 | Green | Wisconsin | 55045 | 6404 | 45 |
2017909 | 2017909 | 2021-12-15 | Tazewell | Virginia | 51185 | 6404 | 120 |
2011721 | 2011721 | 2021-12-14 | Baxter | Arkansas | 5005 | 6404 | 195 |
1988459 | 1988459 | 2021-12-06 | Uvalde | Texas | 48463 | 6404 | 118 |
1973195 | 1973195 | 2021-12-02 | Nez Perce | Idaho | 16069 | 6404 | 105 |
1971502 | 1971502 | 2021-12-01 | Williams | Ohio | 39171 | 6404 | 99 |
1905766 | 1905766 | 2021-11-11 | Bolivar | Mississippi | 28011 | 6404 | 151 |
1902517 | 1902517 | 2021-11-10 | Bolivar | Mississippi | 28011 | 6404 | 151 |
1881985 | 1881985 | 2021-11-04 | Wakulla | Florida | 12129 | 6404 | 103 |
1878736 | 1878736 | 2021-11-03 | Wakulla | Florida | 12129 | 6404 | 103 |
1879106 | 1879106 | 2021-11-03 | Montgomery | Indiana | 18107 | 6404 | 116 |
1875487 | 1875487 | 2021-11-02 | Wakulla | Florida | 12129 | 6404 | 103 |
1872238 | 1872238 | 2021-11-01 | Wakulla | Florida | 12129 | 6404 | 103 |
1868989 | 1868989 | 2021-10-31 | Wakulla | Florida | 12129 | 6404 | 103 |
1865740 | 1865740 | 2021-10-30 | Wakulla | Florida | 12129 | 6404 | 103 |
1862491 | 1862491 | 2021-10-29 | Wakulla | Florida | 12129 | 6404 | 103 |
1838015 | 1838015 | 2021-10-21 | Alexander | North Carolina | 37003 | 6404 | 115 |
1782384 | 1782384 | 2021-10-04 | Butler | Missouri | 29023 | 6404 | 69 |
1776684 | 1776684 | 2021-10-02 | Mifflin | Pennsylvania | 42087 | 6404 | 185 |
1733603 | 1733603 | 2021-09-19 | Neshoba | Mississippi | 28099 | 6404 | 201 |
1734925 | 1734925 | 2021-09-19 | Medina | Texas | 48325 | 6404 | 138 |
1730353 | 1730353 | 2021-09-18 | Neshoba | Mississippi | 28099 | 6404 | 201 |
1731675 | 1731675 | 2021-09-18 | Medina | Texas | 48325 | 6404 | 139 |
1727103 | 1727103 | 2021-09-17 | Neshoba | Mississippi | 28099 | 6404 | 201 |
1728425 | 1728425 | 2021-09-17 | Medina | Texas | 48325 | 6404 | 139 |
1725176 | 1725176 | 2021-09-16 | Medina | Texas | 48325 | 6404 | 139 |
1714192 | 1714192 | 2021-09-13 | Johnson | Missouri | 29101 | 6404 | 66 |
1692181 | 1692181 | 2021-09-06 | Bradford | Pennsylvania | 42015 | 6404 | 100 |
1678377 | 1678377 | 2021-09-02 | Oktibbeha | Mississippi | 28105 | 6404 | 112 |
1648392 | 1648392 | 2021-08-24 | Cass | Indiana | 18017 | 6404 | 116 |
1617004 | 1617004 | 2021-08-14 | Salem | New Jersey | 34033 | 6404 | 191 |
1585824 | 1585824 | 2021-08-04 | Harrison | West Virginia | 54033 | 6404 | 82 |
1511525 | 1511525 | 2021-07-13 | Eagle | Colorado | 8037 | 6404 | 23 |
1507043 | 1507043 | 2021-07-11 | Carbon | Pennsylvania | 42025 | 6404 | 176 |
1503797 | 1503797 | 2021-07-10 | Carbon | Pennsylvania | 42025 | 6404 | 176 |
1486739 | 1486739 | 2021-07-05 | Lamar | Mississippi | 28073 | 6404 | 88 |
1483493 | 1483493 | 2021-07-04 | Lamar | Mississippi | 28073 | 6404 | 88 |
1480247 | 1480247 | 2021-07-03 | Lamar | Mississippi | 28073 | 6404 | 88 |
1477000 | 1477000 | 2021-07-02 | Lamar | Mississippi | 28073 | 6404 | 88 |
1284450 | 1284450 | 2021-05-04 | Catoosa | Georgia | 13047 | 6404 | 70 |
1218383 | 1218383 | 2021-04-13 | Carter | Tennessee | 47019 | 6404 | 156 |
1203917 | 1203917 | 2021-04-09 | Laurel | Kentucky | 21125 | 6404 | 65 |
1196144 | 1196144 | 2021-04-06 | Rockingham | Virginia | 51165 | 6404 | 103 |
1182209 | 1182209 | 2021-04-02 | Hancock | Ohio | 39063 | 6404 | 122 |
1143031 | 1143031 | 2021-03-21 | Oswego | New York | 36075 | 6404 | 89 |
1140339 | 1140339 | 2021-03-20 | Georgetown | South Carolina | 45043 | 6404 | 136 |
1094090 | 1094090 | 2021-03-06 | Lewis and Clark | Montana | 30049 | 6404 | 68 |
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);