ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
188 rows where cases = 2765 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Indiana 13
- North Carolina 13
- Missouri 12
- Kansas 11
- Kentucky 11
- Tennessee 11
- Texas 11
- Florida 8
- Puerto Rico 6
- Alabama 5
- Arkansas 5
- Illinois 5
- Michigan 5
- Minnesota 5
- Colorado 4
- Louisiana 4
- Ohio 4
- Pennsylvania 4
- Wisconsin 4
- Iowa 3
- Nebraska 3
- North Dakota 3
- South Carolina 3
- South Dakota 3
- California 2
- Mississippi 2
- Oregon 2
- Virginia 2
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500014 | 2500014 | 2022-05-13 | Early | Georgia | 13099 | 2765 | 62 |
2496756 | 2496756 | 2022-05-12 | Early | Georgia | 13099 | 2765 | 62 |
2493498 | 2493498 | 2022-05-11 | Early | Georgia | 13099 | 2765 | 62 |
2491783 | 2491783 | 2022-05-10 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2488525 | 2488525 | 2022-05-09 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2485268 | 2485268 | 2022-05-08 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2482010 | 2482010 | 2022-05-07 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2478752 | 2478752 | 2022-05-06 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2474877 | 2474877 | 2022-05-05 | Koochiching | Minnesota | 27071 | 2765 | 37 |
2475494 | 2475494 | 2022-05-05 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2472237 | 2472237 | 2022-05-04 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2467438 | 2467438 | 2022-05-03 | Early | Georgia | 13099 | 2765 | 62 |
2464183 | 2464183 | 2022-05-02 | Early | Georgia | 13099 | 2765 | 62 |
2460927 | 2460927 | 2022-05-01 | Early | Georgia | 13099 | 2765 | 62 |
2457671 | 2457671 | 2022-04-30 | Early | Georgia | 13099 | 2765 | 62 |
2454415 | 2454415 | 2022-04-29 | Early | Georgia | 13099 | 2765 | 62 |
2451159 | 2451159 | 2022-04-28 | Early | Georgia | 13099 | 2765 | 62 |
2453078 | 2453078 | 2022-04-28 | Ciales | Puerto Rico | 72039 | 2765 | |
2447903 | 2447903 | 2022-04-27 | Early | Georgia | 13099 | 2765 | 62 |
2311069 | 2311069 | 2022-03-16 | Park | Colorado | 8093 | 2765 | 20 |
2307816 | 2307816 | 2022-03-15 | Park | Colorado | 8093 | 2765 | 20 |
2291620 | 2291620 | 2022-03-10 | Lafayette | Florida | 12067 | 2765 | 56 |
2288368 | 2288368 | 2022-03-09 | Lafayette | Florida | 12067 | 2765 | 56 |
2285117 | 2285117 | 2022-03-08 | Lafayette | Florida | 12067 | 2765 | 55 |
2281865 | 2281865 | 2022-03-07 | Lafayette | Florida | 12067 | 2765 | 55 |
2278612 | 2278612 | 2022-03-06 | Lafayette | Florida | 12067 | 2765 | 55 |
2275359 | 2275359 | 2022-03-05 | Lafayette | Florida | 12067 | 2765 | 55 |
2272106 | 2272106 | 2022-03-04 | Lafayette | Florida | 12067 | 2765 | 55 |
2267903 | 2267903 | 2022-03-02 | Callahan | Texas | 48059 | 2765 | 72 |
2225847 | 2225847 | 2022-02-17 | Ward | Texas | 48475 | 2765 | 42 |
2194896 | 2194896 | 2022-02-08 | West Feliciana | Louisiana | 22125 | 2765 | 42 |
2178775 | 2178775 | 2022-02-03 | Aitkin | Minnesota | 27001 | 2765 | 59 |
2170959 | 2170959 | 2022-02-01 | Conecuh | Alabama | 1035 | 2765 | 63 |
2106544 | 2106544 | 2022-01-12 | Menard | Illinois | 17129 | 2765 | 19 |
2101356 | 2101356 | 2022-01-10 | Polk | North Carolina | 37149 | 2765 | 49 |
2101494 | 2101494 | 2022-01-10 | Monroe | Ohio | 39111 | 2765 | 67 |
2091653 | 2091653 | 2022-01-07 | McKenzie | North Dakota | 38053 | 2765 | 23 |
2083160 | 2083160 | 2022-01-05 | Macon | Alabama | 1087 | 2765 | 69 |
2084882 | 2084882 | 2022-01-05 | York | Nebraska | 31185 | 2765 | 19 |
2085997 | 2085997 | 2022-01-05 | Zavala | Texas | 48507 | 2765 | 56 |
2031733 | 2031733 | 2021-12-20 | De Witt | Illinois | 17039 | 2765 | 39 |
1969323 | 1969323 | 2021-11-30 | Washburn | Wisconsin | 55129 | 2765 | 29 |
1960700 | 1960700 | 2021-11-28 | Powell | Kentucky | 21197 | 2765 | 24 |
1957449 | 1957449 | 2021-11-27 | Powell | Kentucky | 21197 | 2765 | 24 |
1954198 | 1954198 | 2021-11-26 | Powell | Kentucky | 21197 | 2765 | 24 |
1950947 | 1950947 | 2021-11-25 | Powell | Kentucky | 21197 | 2765 | 24 |
1951238 | 1951238 | 2021-11-25 | Redwood | Minnesota | 27127 | 2765 | 45 |
1947696 | 1947696 | 2021-11-24 | Powell | Kentucky | 21197 | 2765 | 24 |
1947987 | 1947987 | 2021-11-24 | Redwood | Minnesota | 27127 | 2765 | 45 |
1940882 | 1940882 | 2021-11-22 | Vermillion | Indiana | 18165 | 2765 | 57 |
1932388 | 1932388 | 2021-11-19 | Richland | North Dakota | 38077 | 2765 | 21 |
1914806 | 1914806 | 2021-11-14 | Carroll | Indiana | 18015 | 2765 | 39 |
1911556 | 1911556 | 2021-11-13 | Carroll | Indiana | 18015 | 2765 | 39 |
1908307 | 1908307 | 2021-11-12 | Carroll | Indiana | 18015 | 2765 | 39 |
1899161 | 1899161 | 2021-11-09 | Roscommon | Michigan | 26143 | 2765 | 67 |
1895911 | 1895911 | 2021-11-08 | Roscommon | Michigan | 26143 | 2765 | 67 |
1881053 | 1881053 | 2021-11-03 | Freestone | Texas | 48161 | 2765 | 68 |
1877804 | 1877804 | 2021-11-02 | Freestone | Texas | 48161 | 2765 | 68 |
1870125 | 1870125 | 2021-10-31 | Cooper | Missouri | 29053 | 2765 | 33 |
1871306 | 1871306 | 2021-10-31 | Freestone | Texas | 48161 | 2765 | 68 |
1868057 | 1868057 | 2021-10-30 | Freestone | Texas | 48161 | 2765 | 68 |
1854318 | 1854318 | 2021-10-26 | Madison | North Carolina | 37115 | 2765 | 61 |
1851069 | 1851069 | 2021-10-25 | Madison | North Carolina | 37115 | 2765 | 61 |
1837079 | 1837079 | 2021-10-21 | Pottawatomie | Kansas | 20149 | 2765 | 41 |
1833830 | 1833830 | 2021-10-20 | Pottawatomie | Kansas | 20149 | 2765 | 41 |
1830651 | 1830651 | 2021-10-19 | Garrard | Kentucky | 21079 | 2765 | 46 |
1815316 | 1815316 | 2021-10-14 | Hertford | North Carolina | 37091 | 2765 | 70 |
1815901 | 1815901 | 2021-10-14 | Cannon | Tennessee | 47015 | 2765 | 39 |
1726229 | 1726229 | 2021-09-17 | Minidoka | Idaho | 16067 | 2765 | 35 |
1671472 | 1671472 | 2021-08-31 | Johnson | Kentucky | 21115 | 2765 | 38 |
1669399 | 1669399 | 2021-08-30 | Columbia | Oregon | 41009 | 2765 | 34 |
1670211 | 1670211 | 2021-08-30 | Staunton city | Virginia | 51790 | 2765 | 72 |
1670240 | 1670240 | 2021-08-30 | Island | Washington | 53029 | 2765 | 34 |
1665458 | 1665458 | 2021-08-29 | Henry | Missouri | 29083 | 2765 | 42 |
1656508 | 1656508 | 2021-08-26 | Aguadilla | Puerto Rico | 72005 | 2765 | |
1644867 | 1644867 | 2021-08-23 | Dodge | Georgia | 13091 | 2765 | 112 |
1641373 | 1641373 | 2021-08-22 | Calaveras | California | 6009 | 2765 | 61 |
1643504 | 1643504 | 2021-08-22 | Susquehanna | Pennsylvania | 42115 | 2765 | 62 |
1628338 | 1628338 | 2021-08-18 | Logan | Arkansas | 5083 | 2765 | 27 |
1630549 | 1630549 | 2021-08-18 | Gurabo | Puerto Rico | 72063 | 2765 | |
1622859 | 1622859 | 2021-08-16 | St. James | Louisiana | 22093 | 2765 | 55 |
1621037 | 1621037 | 2021-08-15 | Morgan | Tennessee | 47129 | 2765 | 39 |
1617789 | 1617789 | 2021-08-14 | Morgan | Tennessee | 47129 | 2765 | 39 |
1614541 | 1614541 | 2021-08-13 | Morgan | Tennessee | 47129 | 2765 | 39 |
1583792 | 1583792 | 2021-08-04 | Mercer | Kentucky | 21167 | 2765 | 53 |
1568822 | 1568822 | 2021-07-30 | Dorado | Puerto Rico | 72051 | 2765 | |
1562535 | 1562535 | 2021-07-28 | Haywood | Tennessee | 47075 | 2765 | 62 |
1535451 | 1535451 | 2021-07-20 | Marion | Mississippi | 28091 | 2765 | 80 |
1531491 | 1531491 | 2021-07-19 | LaGrange | Indiana | 18087 | 2765 | 74 |
1505536 | 1505536 | 2021-07-11 | Posey | Indiana | 18129 | 2765 | 35 |
1502290 | 1502290 | 2021-07-10 | Posey | Indiana | 18129 | 2765 | 35 |
1499044 | 1499044 | 2021-07-09 | Posey | Indiana | 18129 | 2765 | 35 |
1495797 | 1495797 | 2021-07-08 | Posey | Indiana | 18129 | 2765 | 35 |
1496593 | 1496593 | 2021-07-08 | Miller | Missouri | 29131 | 2765 | 57 |
1490138 | 1490138 | 2021-07-06 | Stone | Missouri | 29209 | 2765 | 49 |
1460268 | 1460268 | 2021-06-27 | Labette | Kansas | 20099 | 2765 | 50 |
1457023 | 1457023 | 2021-06-26 | Labette | Kansas | 20099 | 2765 | 50 |
1453778 | 1453778 | 2021-06-25 | Labette | Kansas | 20099 | 2765 | 50 |
1455529 | 1455529 | 2021-06-25 | Fayette | Texas | 48149 | 2765 | 67 |
1452284 | 1452284 | 2021-06-24 | Fayette | Texas | 48149 | 2765 | 67 |
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);