ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
264 rows where cases = 2066 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- West Virginia 20
- Tennessee 19
- Iowa 16
- Missouri 16
- Georgia 14
- Michigan 13
- Puerto Rico 12
- Arkansas 11
- Kentucky 11
- Illinois 10
- Louisiana 9
- Minnesota 8
- Mississippi 7
- Colorado 6
- Indiana 6
- North Carolina 6
- Virginia 5
- Alaska 4
- Nebraska 4
- Pennsylvania 4
- South Dakota 4
- Alabama 3
- Kansas 3
- North Dakota 3
- Oregon 3
- Wisconsin 3
- Montana 2
- Nevada 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476657 | 2476657 | 2022-05-05 | Pocahontas | West Virginia | 54075 | 2066 | 32 |
2463630 | 2463630 | 2022-05-01 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2460374 | 2460374 | 2022-04-30 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2457118 | 2457118 | 2022-04-29 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2453862 | 2453862 | 2022-04-28 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2449086 | 2449086 | 2022-04-27 | Carbon | Montana | 30009 | 2066 | 28 |
2445524 | 2445524 | 2022-04-26 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2442268 | 2442268 | 2022-04-25 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2439012 | 2439012 | 2022-04-24 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2435756 | 2435756 | 2022-04-23 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2432500 | 2432500 | 2022-04-22 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2429244 | 2429244 | 2022-04-21 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2425988 | 2425988 | 2022-04-20 | Presque Isle | Michigan | 26141 | 2066 | 58 |
2423036 | 2423036 | 2022-04-19 | Blaine | Montana | 30005 | 2066 | 32 |
2420554 | 2420554 | 2022-04-18 | Patillas | Puerto Rico | 72109 | 2066 | |
2405022 | 2405022 | 2022-04-13 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2401767 | 2401767 | 2022-04-12 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2395257 | 2395257 | 2022-04-10 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2392001 | 2392001 | 2022-04-09 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2388745 | 2388745 | 2022-04-08 | Pleasants | West Virginia | 54073 | 2066 | 36 |
2380460 | 2380460 | 2022-04-06 | Lake | Minnesota | 27075 | 2066 | 28 |
2377205 | 2377205 | 2022-04-05 | Lake | Minnesota | 27075 | 2066 | 28 |
2255904 | 2255904 | 2022-02-27 | Candler | Georgia | 13043 | 2066 | 91 |
2258604 | 2258604 | 2022-02-27 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2252653 | 2252653 | 2022-02-26 | Candler | Georgia | 13043 | 2066 | 91 |
2255353 | 2255353 | 2022-02-26 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2249402 | 2249402 | 2022-02-25 | Candler | Georgia | 13043 | 2066 | 91 |
2252102 | 2252102 | 2022-02-25 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2248851 | 2248851 | 2022-02-24 | Gilmer | West Virginia | 54021 | 2066 | 18 |
2223996 | 2223996 | 2022-02-17 | Bracken | Kentucky | 21023 | 2066 | 23 |
2222438 | 2222438 | 2022-02-16 | Franklin | Texas | 48159 | 2066 | 38 |
2214828 | 2214828 | 2022-02-14 | St. Clair | Missouri | 29185 | 2066 | 31 |
2201332 | 2201332 | 2022-02-10 | Trimble | Kentucky | 21223 | 2066 | 35 |
2193606 | 2193606 | 2022-02-07 | Tyler | West Virginia | 54095 | 2066 | 27 |
2185495 | 2185495 | 2022-02-05 | Iron | Missouri | 29093 | 2066 | 35 |
2183092 | 2183092 | 2022-02-04 | Rincon | Puerto Rico | 72117 | 2066 | |
2179015 | 2179015 | 2022-02-03 | Monroe | Missouri | 29137 | 2066 | 38 |
2175906 | 2175906 | 2022-02-02 | Hamilton | Nebraska | 31081 | 2066 | 22 |
2171576 | 2171576 | 2022-02-01 | Hamilton | Illinois | 17065 | 2066 | 31 |
2173332 | 2173332 | 2022-02-01 | Penuelas | Puerto Rico | 72111 | 2066 | |
2170080 | 2170080 | 2022-01-31 | Penuelas | Puerto Rico | 72111 | 2066 | |
2156184 | 2156184 | 2022-01-27 | Carroll | Missouri | 29033 | 2066 | 41 |
2150458 | 2150458 | 2022-01-25 | Forest | Pennsylvania | 42053 | 2066 | 34 |
2144550 | 2144550 | 2022-01-23 | Grand | Utah | 49019 | 2066 | 6 |
2134536 | 2134536 | 2022-01-20 | Blanco | Texas | 48031 | 2066 | 28 |
2125876 | 2125876 | 2022-01-18 | McIntosh | Georgia | 13191 | 2066 | 33 |
2073611 | 2073611 | 2022-01-02 | Archuleta | Colorado | 8007 | 2066 | 9 |
2070360 | 2070360 | 2022-01-01 | Archuleta | Colorado | 8007 | 2066 | 9 |
2067109 | 2067109 | 2021-12-31 | Archuleta | Colorado | 8007 | 2066 | 9 |
2055379 | 2055379 | 2021-12-27 | Cedar | Missouri | 29039 | 2066 | 42 |
2012487 | 2012487 | 2021-12-14 | Shelby | Iowa | 19165 | 2066 | 43 |
2009236 | 2009236 | 2021-12-13 | Shelby | Iowa | 19165 | 2066 | 43 |
2005985 | 2005985 | 2021-12-12 | Shelby | Iowa | 19165 | 2066 | 43 |
2002734 | 2002734 | 2021-12-11 | Shelby | Iowa | 19165 | 2066 | 43 |
1999484 | 1999484 | 2021-12-10 | Shelby | Iowa | 19165 | 2066 | 43 |
1996233 | 1996233 | 2021-12-09 | Shelby | Iowa | 19165 | 2066 | 43 |
1992982 | 1992982 | 2021-12-08 | Shelby | Iowa | 19165 | 2066 | 43 |
1986688 | 1986688 | 2021-12-06 | Metcalfe | Kentucky | 21169 | 2066 | 48 |
1981759 | 1981759 | 2021-12-04 | Camp | Texas | 48063 | 2066 | 67 |
1945695 | 1945695 | 2021-11-23 | Cayey | Puerto Rico | 72035 | 2066 | |
1942444 | 1942444 | 2021-11-22 | Cayey | Puerto Rico | 72035 | 2066 | |
1939194 | 1939194 | 2021-11-21 | Cayey | Puerto Rico | 72035 | 2066 | |
1905055 | 1905055 | 2021-11-11 | Blackford | Indiana | 18009 | 2066 | 45 |
1875731 | 1875731 | 2021-11-02 | Greene | Illinois | 17061 | 2066 | 53 |
1873268 | 1873268 | 2021-11-01 | Amite | Mississippi | 28005 | 2066 | 56 |
1873816 | 1873816 | 2021-11-01 | Mitchell | North Carolina | 37121 | 2066 | 21 |
1874079 | 1874079 | 2021-11-01 | Baker | Oregon | 41001 | 2066 | 29 |
1868681 | 1868681 | 2021-10-31 | Kusilvak Census Area | Alaska | 2158 | 2066 | 8 |
1865432 | 1865432 | 2021-10-30 | Kusilvak Census Area | Alaska | 2158 | 2066 | 8 |
1862183 | 1862183 | 2021-10-29 | Kusilvak Census Area | Alaska | 2158 | 2066 | 8 |
1856272 | 1856272 | 2021-10-27 | Mercer | Illinois | 17131 | 2066 | 37 |
1838680 | 1838680 | 2021-10-21 | Jackson | Tennessee | 47087 | 2066 | 40 |
1835431 | 1835431 | 2021-10-20 | Jackson | Tennessee | 47087 | 2066 | 40 |
1800517 | 1800517 | 2021-10-10 | Lee | Arkansas | 5077 | 2066 | 48 |
1797268 | 1797268 | 2021-10-09 | Lee | Arkansas | 5077 | 2066 | 48 |
1785152 | 1785152 | 2021-10-05 | Clinton | Kentucky | 21053 | 2066 | 33 |
1781536 | 1781536 | 2021-10-04 | Mason | Illinois | 17125 | 2066 | 52 |
1761533 | 1761533 | 2021-09-28 | Marion | Arkansas | 5089 | 2066 | 55 |
1760800 | 1760800 | 2021-09-27 | Comanche | Texas | 48093 | 2066 | 58 |
1755579 | 1755579 | 2021-09-26 | Washington | Illinois | 17189 | 2066 | 33 |
1756272 | 1756272 | 2021-09-26 | Redwood | Minnesota | 27127 | 2066 | 42 |
1757552 | 1757552 | 2021-09-26 | Comanche | Texas | 48093 | 2066 | 58 |
1752331 | 1752331 | 2021-09-25 | Washington | Illinois | 17189 | 2066 | 33 |
1753024 | 1753024 | 2021-09-25 | Redwood | Minnesota | 27127 | 2066 | 42 |
1754304 | 1754304 | 2021-09-25 | Comanche | Texas | 48093 | 2066 | 58 |
1749082 | 1749082 | 2021-09-24 | Washington | Illinois | 17189 | 2066 | 33 |
1749776 | 1749776 | 2021-09-24 | Redwood | Minnesota | 27127 | 2066 | 42 |
1736963 | 1736963 | 2021-09-20 | Osage | Missouri | 29151 | 2066 | 20 |
1730422 | 1730422 | 2021-09-18 | Gasconade | Missouri | 29073 | 2066 | 48 |
1730463 | 1730463 | 2021-09-18 | Osage | Missouri | 29151 | 2066 | 20 |
1723173 | 1723173 | 2021-09-16 | Tipton | Indiana | 18159 | 2066 | 56 |
1714700 | 1714700 | 2021-09-13 | Walsh | North Dakota | 38099 | 2066 | 27 |
1711454 | 1711454 | 2021-09-12 | Walsh | North Dakota | 38099 | 2066 | 27 |
1697458 | 1697458 | 2021-09-08 | Henry | Kentucky | 21103 | 2066 | 21 |
1694198 | 1694198 | 2021-09-07 | Garrard | Kentucky | 21079 | 2066 | 37 |
1678871 | 1678871 | 2021-09-02 | Madison | North Carolina | 37115 | 2066 | 44 |
1673643 | 1673643 | 2021-08-31 | Carbon | Wyoming | 56007 | 2066 | 31 |
1669623 | 1669623 | 2021-08-30 | Saluda | South Carolina | 45081 | 2066 | 49 |
1653238 | 1653238 | 2021-08-25 | Montour | Pennsylvania | 42093 | 2066 | 67 |
1645059 | 1645059 | 2021-08-23 | Ford | Illinois | 17053 | 2066 | 60 |
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);