ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
231 rows where cases = 2239 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Tennessee 15
- Mississippi 13
- Texas 13
- Kansas 12
- Kentucky 12
- Pennsylvania 12
- Missouri 10
- South Carolina 10
- Virginia 9
- Alabama 8
- Arkansas 8
- Iowa 8
- Louisiana 8
- Ohio 7
- Illinois 6
- Indiana 5
- Montana 5
- North Carolina 5
- Nebraska 4
- West Virginia 4
- Wyoming 4
- Colorado 3
- Puerto Rico 3
- South Dakota 3
- Utah 3
- Wisconsin 3
- California 2
- Idaho 2
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502174 | 2502174 | 2022-05-13 | Moore | Tennessee | 47127 | 2239 | 40 |
2498916 | 2498916 | 2022-05-12 | Moore | Tennessee | 47127 | 2239 | 40 |
2495658 | 2495658 | 2022-05-11 | Moore | Tennessee | 47127 | 2239 | 40 |
2492259 | 2492259 | 2022-05-10 | McCormick | South Carolina | 45065 | 2239 | 40 |
2489001 | 2489001 | 2022-05-09 | McCormick | South Carolina | 45065 | 2239 | 40 |
2485744 | 2485744 | 2022-05-08 | McCormick | South Carolina | 45065 | 2239 | 40 |
2482486 | 2482486 | 2022-05-07 | McCormick | South Carolina | 45065 | 2239 | 40 |
2479228 | 2479228 | 2022-05-06 | McCormick | South Carolina | 45065 | 2239 | 40 |
2475970 | 2475970 | 2022-05-05 | McCormick | South Carolina | 45065 | 2239 | 40 |
2472713 | 2472713 | 2022-05-04 | McCormick | South Carolina | 45065 | 2239 | 40 |
2469457 | 2469457 | 2022-05-03 | McCormick | South Carolina | 45065 | 2239 | 40 |
2381391 | 2381391 | 2022-04-06 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2378136 | 2378136 | 2022-04-05 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2374882 | 2374882 | 2022-04-04 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2371630 | 2371630 | 2022-04-03 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2368377 | 2368377 | 2022-04-02 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2365124 | 2365124 | 2022-04-01 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2361871 | 2361871 | 2022-03-31 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2358617 | 2358617 | 2022-03-30 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2355363 | 2355363 | 2022-03-29 | Forest | Pennsylvania | 42053 | 2239 | 35 |
2355465 | 2355465 | 2022-03-29 | Sabana Grande | Puerto Rico | 72121 | 2239 | |
2337352 | 2337352 | 2022-03-24 | Wilkes | Georgia | 13317 | 2239 | 49 |
2317183 | 2317183 | 2022-03-17 | Webster | West Virginia | 54101 | 2239 | 29 |
2255062 | 2255062 | 2022-02-26 | Red River | Texas | 48387 | 2239 | 64 |
2249114 | 2249114 | 2022-02-25 | Cleveland | Arkansas | 5025 | 2239 | 35 |
2248630 | 2248630 | 2022-02-24 | Grand | Utah | 49019 | 2239 | 6 |
2226407 | 2226407 | 2022-02-18 | Scott | Arkansas | 5127 | 2239 | 38 |
2216957 | 2216957 | 2022-02-15 | Lanier | Georgia | 13173 | 2239 | 19 |
2217082 | 2217082 | 2022-02-15 | Washington | Idaho | 16087 | 2239 | 54 |
2191239 | 2191239 | 2022-02-07 | Switzerland | Indiana | 18155 | 2239 | 15 |
2183449 | 2183449 | 2022-02-04 | Jim Hogg | Texas | 48247 | 2239 | 20 |
2162790 | 2162790 | 2022-01-29 | Wayne | Missouri | 29223 | 2239 | 42 |
2134907 | 2134907 | 2022-01-20 | Nelson | Virginia | 51125 | 2239 | 25 |
2123603 | 2123603 | 2022-01-17 | Noxubee | Mississippi | 28103 | 2239 | 45 |
2120351 | 2120351 | 2022-01-16 | Noxubee | Mississippi | 28103 | 2239 | 45 |
2117099 | 2117099 | 2022-01-15 | Noxubee | Mississippi | 28103 | 2239 | 45 |
2113848 | 2113848 | 2022-01-14 | Noxubee | Mississippi | 28103 | 2239 | 45 |
2104217 | 2104217 | 2022-01-11 | Ripley | Missouri | 29181 | 2239 | 52 |
2104881 | 2104881 | 2022-01-11 | Morrow | Oregon | 41049 | 2239 | 26 |
2089077 | 2089077 | 2022-01-06 | Gaines | Texas | 48165 | 2239 | 71 |
2058956 | 2058956 | 2021-12-28 | Torrance | New Mexico | 35057 | 2239 | 34 |
2037762 | 2037762 | 2021-12-22 | Lee | Arkansas | 5077 | 2239 | 54 |
2022890 | 2022890 | 2021-12-17 | Dent | Missouri | 29065 | 2239 | 63 |
2011268 | 2011268 | 2021-12-13 | Addison | Vermont | 50001 | 2239 | 10 |
1984942 | 1984942 | 2021-12-05 | Meigs | Tennessee | 47121 | 2239 | 32 |
1985044 | 1985044 | 2021-12-05 | Eastland | Texas | 48133 | 2239 | 83 |
1981692 | 1981692 | 2021-12-04 | Meigs | Tennessee | 47121 | 2239 | 32 |
1978442 | 1978442 | 2021-12-03 | Meigs | Tennessee | 47121 | 2239 | 32 |
1973034 | 1973034 | 2021-12-02 | Dade | Georgia | 13083 | 2239 | 22 |
1962448 | 1962448 | 2021-11-28 | Terry | Texas | 48445 | 2239 | 67 |
1959197 | 1959197 | 2021-11-27 | Terry | Texas | 48445 | 2239 | 67 |
1955946 | 1955946 | 2021-11-26 | Terry | Texas | 48445 | 2239 | 67 |
1952695 | 1952695 | 2021-11-25 | Terry | Texas | 48445 | 2239 | 67 |
1949444 | 1949444 | 2021-11-24 | Terry | Texas | 48445 | 2239 | 67 |
1946193 | 1946193 | 2021-11-23 | Terry | Texas | 48445 | 2239 | 67 |
1925279 | 1925279 | 2021-11-17 | Greene | Mississippi | 28041 | 2239 | 49 |
1922030 | 1922030 | 2021-11-16 | Greene | Mississippi | 28041 | 2239 | 49 |
1901033 | 1901033 | 2021-11-09 | Lafayette | Wisconsin | 55065 | 2239 | 12 |
1893822 | 1893822 | 2021-11-07 | Clay | South Dakota | 46027 | 2239 | 18 |
1890572 | 1890572 | 2021-11-06 | Clay | South Dakota | 46027 | 2239 | 18 |
1887322 | 1887322 | 2021-11-05 | Clay | South Dakota | 46027 | 2239 | 18 |
1881240 | 1881240 | 2021-11-03 | Millard | Utah | 49027 | 2239 | 25 |
1872982 | 1872982 | 2021-11-01 | Caldwell | Louisiana | 22021 | 2239 | 39 |
1867393 | 1867393 | 2021-10-30 | Ramsey | North Dakota | 38071 | 2239 | 37 |
1856759 | 1856759 | 2021-10-27 | Madison | Louisiana | 22065 | 2239 | 52 |
1847505 | 1847505 | 2021-10-24 | Park | Montana | 30067 | 2239 | 27 |
1844255 | 1844255 | 2021-10-23 | Park | Montana | 30067 | 2239 | 27 |
1841005 | 1841005 | 2021-10-22 | Park | Montana | 30067 | 2239 | 27 |
1835799 | 1835799 | 2021-10-20 | Bristol city | Virginia | 51520 | 2239 | 47 |
1830477 | 1830477 | 2021-10-19 | O'Brien | Iowa | 19141 | 2239 | 63 |
1827228 | 1827228 | 2021-10-18 | O'Brien | Iowa | 19141 | 2239 | 63 |
1823979 | 1823979 | 2021-10-17 | O'Brien | Iowa | 19141 | 2239 | 63 |
1820730 | 1820730 | 2021-10-16 | O'Brien | Iowa | 19141 | 2239 | 63 |
1817481 | 1817481 | 2021-10-15 | O'Brien | Iowa | 19141 | 2239 | 63 |
1814233 | 1814233 | 2021-10-14 | O'Brien | Iowa | 19141 | 2239 | 63 |
1814892 | 1814892 | 2021-10-14 | Dallas | Missouri | 29059 | 2239 | 41 |
1810984 | 1810984 | 2021-10-13 | O'Brien | Iowa | 19141 | 2239 | 63 |
1811644 | 1811644 | 2021-10-13 | Dallas | Missouri | 29059 | 2239 | 41 |
1812043 | 1812043 | 2021-10-13 | Chowan | North Carolina | 37041 | 2239 | 40 |
1792104 | 1792104 | 2021-10-07 | Tallahatchie | Mississippi | 28135 | 2239 | 51 |
1781991 | 1781991 | 2021-10-04 | Washington | Kentucky | 21229 | 2239 | 44 |
1779389 | 1779389 | 2021-10-03 | York | Nebraska | 31185 | 2239 | 19 |
1776139 | 1776139 | 2021-10-02 | York | Nebraska | 31185 | 2239 | 19 |
1772889 | 1772889 | 2021-10-01 | York | Nebraska | 31185 | 2239 | 19 |
1757192 | 1757192 | 2021-09-26 | Montour | Pennsylvania | 42093 | 2239 | 68 |
1732747 | 1732747 | 2021-09-19 | Carroll | Illinois | 17015 | 2239 | 38 |
1729497 | 1729497 | 2021-09-18 | Carroll | Illinois | 17015 | 2239 | 38 |
1726247 | 1726247 | 2021-09-17 | Carroll | Illinois | 17015 | 2239 | 38 |
1718661 | 1718661 | 2021-09-14 | Leon | Texas | 48289 | 2239 | 53 |
1712787 | 1712787 | 2021-09-13 | Howard | Arkansas | 5061 | 2239 | 29 |
1709420 | 1709420 | 2021-09-12 | Crenshaw | Alabama | 1041 | 2239 | 62 |
1711773 | 1711773 | 2021-09-12 | Las Piedras | Puerto Rico | 72085 | 2239 | |
1696663 | 1696663 | 2021-09-08 | Crowley | Colorado | 8025 | 2239 | 18 |
1693415 | 1693415 | 2021-09-07 | Crowley | Colorado | 8025 | 2239 | 18 |
1662176 | 1662176 | 2021-08-28 | Benton | Missouri | 29015 | 2239 | 40 |
1656219 | 1656219 | 2021-08-26 | Rolette | North Dakota | 38079 | 2239 | 28 |
1653260 | 1653260 | 2021-08-25 | Aguada | Puerto Rico | 72003 | 2239 | |
1645035 | 1645035 | 2021-08-23 | Bond | Illinois | 17005 | 2239 | 29 |
1625940 | 1625940 | 2021-08-17 | Adair | Kentucky | 21001 | 2239 | 57 |
1622693 | 1622693 | 2021-08-16 | Adair | Kentucky | 21001 | 2239 | 57 |
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);