ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where cases = 2233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Mississippi 14
- Kentucky 12
- Virginia 11
- Colorado 10
- Texas 10
- Arkansas 8
- Indiana 8
- Iowa 8
- North Carolina 8
- Oklahoma 8
- Idaho 7
- Louisiana 6
- Missouri 6
- North Dakota 6
- Ohio 6
- Minnesota 5
- Pennsylvania 5
- West Virginia 5
- Alabama 4
- New York 4
- Puerto Rico 4
- Tennessee 4
- Michigan 3
- California 2
- Illinois 2
- New Mexico 2
- South Carolina 2
- South Dakota 2
- Utah 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501092 | 2501092 | 2022-05-13 | Carroll | Missouri | 29033 | 2233 | 44 |
2324093 | 2324093 | 2022-03-20 | San Miguel | Colorado | 8113 | 2233 | 8 |
2325216 | 2325216 | 2022-03-20 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2320839 | 2320839 | 2022-03-19 | San Miguel | Colorado | 8113 | 2233 | 8 |
2321962 | 2321962 | 2022-03-19 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2317585 | 2317585 | 2022-03-18 | San Miguel | Colorado | 8113 | 2233 | 8 |
2318708 | 2318708 | 2022-03-18 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2314332 | 2314332 | 2022-03-17 | San Miguel | Colorado | 8113 | 2233 | 8 |
2315455 | 2315455 | 2022-03-17 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2312202 | 2312202 | 2022-03-16 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2308949 | 2308949 | 2022-03-15 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2305698 | 2305698 | 2022-03-14 | Choctaw | Mississippi | 28019 | 2233 | 33 |
2301569 | 2301569 | 2022-03-13 | Wilkes | Georgia | 13317 | 2233 | 49 |
2304173 | 2304173 | 2022-03-13 | Webster | West Virginia | 54101 | 2233 | 29 |
2298317 | 2298317 | 2022-03-12 | Wilkes | Georgia | 13317 | 2233 | 49 |
2300921 | 2300921 | 2022-03-12 | Webster | West Virginia | 54101 | 2233 | 29 |
2295065 | 2295065 | 2022-03-11 | Wilkes | Georgia | 13317 | 2233 | 49 |
2297669 | 2297669 | 2022-03-11 | Webster | West Virginia | 54101 | 2233 | 29 |
2266279 | 2266279 | 2022-03-02 | Elliott | Kentucky | 21063 | 2233 | 16 |
2256011 | 2256011 | 2022-02-27 | Stewart | Georgia | 13259 | 2233 | 31 |
2252760 | 2252760 | 2022-02-26 | Stewart | Georgia | 13259 | 2233 | 31 |
2249509 | 2249509 | 2022-02-25 | Stewart | Georgia | 13259 | 2233 | 31 |
2213831 | 2213831 | 2022-02-14 | Washington | Idaho | 16087 | 2233 | 54 |
2201639 | 2201639 | 2022-02-10 | Benton | Mississippi | 28009 | 2233 | 46 |
2193707 | 2193707 | 2022-02-07 | Washakie | Wyoming | 56043 | 2233 | 41 |
2190229 | 2190229 | 2022-02-06 | Poquoson city | Virginia | 51735 | 2233 | 26 |
2186976 | 2186976 | 2022-02-05 | Poquoson city | Virginia | 51735 | 2233 | 26 |
2183723 | 2183723 | 2022-02-04 | Poquoson city | Virginia | 51735 | 2233 | 26 |
2153920 | 2153920 | 2022-01-26 | Lake | South Dakota | 46079 | 2233 | 26 |
2149696 | 2149696 | 2022-01-25 | Douglas | Missouri | 29067 | 2233 | 68 |
2128072 | 2128072 | 2022-01-18 | Dawson | Texas | 48115 | 2233 | 83 |
2104535 | 2104535 | 2022-01-11 | Alleghany | North Carolina | 37005 | 2233 | 10 |
2105036 | 2105036 | 2022-01-11 | Villalba | Puerto Rico | 72149 | 2233 | |
2086967 | 2086967 | 2022-01-06 | Shoshone | Idaho | 16079 | 2233 | 68 |
2072119 | 2072119 | 2022-01-01 | Barnes | North Dakota | 38003 | 2233 | 40 |
2058411 | 2058411 | 2021-12-28 | Missaukee | Michigan | 26113 | 2233 | 46 |
2055162 | 2055162 | 2021-12-27 | Missaukee | Michigan | 26113 | 2233 | 46 |
2051626 | 2051626 | 2021-12-26 | Breathitt | Kentucky | 21025 | 2233 | 47 |
2048376 | 2048376 | 2021-12-25 | Breathitt | Kentucky | 21025 | 2233 | 47 |
2045126 | 2045126 | 2021-12-24 | Breathitt | Kentucky | 21025 | 2233 | 47 |
2041877 | 2041877 | 2021-12-23 | Breathitt | Kentucky | 21025 | 2233 | 47 |
2038627 | 2038627 | 2021-12-22 | Breathitt | Kentucky | 21025 | 2233 | 47 |
2031262 | 2031262 | 2021-12-20 | Lee | Arkansas | 5077 | 2233 | 54 |
2029250 | 2029250 | 2021-12-19 | Pope | Minnesota | 27121 | 2233 | 12 |
2025999 | 2025999 | 2021-12-18 | Pope | Minnesota | 27121 | 2233 | 12 |
2022748 | 2022748 | 2021-12-17 | Pope | Minnesota | 27121 | 2233 | 12 |
2012422 | 2012422 | 2021-12-14 | Cherokee | Iowa | 19035 | 2233 | 47 |
2009171 | 2009171 | 2021-12-13 | Cherokee | Iowa | 19035 | 2233 | 47 |
2005920 | 2005920 | 2021-12-12 | Cherokee | Iowa | 19035 | 2233 | 47 |
2002669 | 2002669 | 2021-12-11 | Cherokee | Iowa | 19035 | 2233 | 47 |
1999419 | 1999419 | 2021-12-10 | Cherokee | Iowa | 19035 | 2233 | 47 |
1996168 | 1996168 | 2021-12-09 | Cherokee | Iowa | 19035 | 2233 | 47 |
1992917 | 1992917 | 2021-12-08 | Cherokee | Iowa | 19035 | 2233 | 47 |
1994070 | 1994070 | 2021-12-08 | Mitchell | North Carolina | 37121 | 2233 | 24 |
1988580 | 1988580 | 2021-12-06 | Goochland | Virginia | 51075 | 2233 | 31 |
1972884 | 1972884 | 2021-12-02 | Las Animas | Colorado | 8071 | 2233 | 27 |
1924342 | 1924342 | 2021-11-17 | Oglethorpe | Georgia | 13221 | 2233 | 43 |
1922160 | 1922160 | 2021-11-16 | Mississippi | Missouri | 29133 | 2233 | 45 |
1917614 | 1917614 | 2021-11-15 | Grand | Colorado | 8049 | 2233 | 16 |
1900949 | 1900949 | 2021-11-09 | Braxton | West Virginia | 54007 | 2233 | 22 |
1864144 | 1864144 | 2021-10-29 | Ramsey | North Dakota | 38071 | 2233 | 37 |
1857898 | 1857898 | 2021-10-27 | Fulton | Pennsylvania | 42057 | 2233 | 31 |
1847011 | 1847011 | 2021-10-24 | Madison | Louisiana | 22065 | 2233 | 52 |
1843761 | 1843761 | 2021-10-23 | Madison | Louisiana | 22065 | 2233 | 52 |
1839394 | 1839394 | 2021-10-22 | Lamar | Alabama | 1075 | 2233 | 47 |
1840511 | 1840511 | 2021-10-22 | Madison | Louisiana | 22065 | 2233 | 52 |
1805543 | 1805543 | 2021-10-11 | Chowan | North Carolina | 37041 | 2233 | 40 |
1788855 | 1788855 | 2021-10-06 | Tallahatchie | Mississippi | 28135 | 2233 | 51 |
1787238 | 1787238 | 2021-10-05 | Hardy | West Virginia | 54031 | 2233 | 27 |
1747179 | 1747179 | 2021-09-23 | Richland | North Dakota | 38077 | 2233 | 19 |
1737901 | 1737901 | 2021-09-20 | Oglala Lakota | South Dakota | 46102 | 2233 | 51 |
1708526 | 1708526 | 2021-09-11 | Las Piedras | Puerto Rico | 72085 | 2233 | |
1693300 | 1693300 | 2021-09-07 | Izard | Arkansas | 5065 | 2233 | 53 |
1686916 | 1686916 | 2021-09-05 | Crowley | Colorado | 8025 | 2233 | 18 |
1683666 | 1683666 | 2021-09-04 | Crowley | Colorado | 8025 | 2233 | 18 |
1680415 | 1680415 | 2021-09-03 | Crowley | Colorado | 8025 | 2233 | 18 |
1672242 | 1672242 | 2021-08-31 | Lincoln | New Mexico | 35027 | 2233 | 22 |
1668801 | 1668801 | 2021-08-30 | Hill | Montana | 30041 | 2233 | 47 |
1670382 | 1670382 | 2021-08-30 | Vernon | Wisconsin | 55123 | 2233 | 47 |
1655959 | 1655959 | 2021-08-26 | Coos | New Hampshire | 33007 | 2233 | 45 |
1644903 | 1644903 | 2021-08-23 | Jefferson | Georgia | 13163 | 2233 | 69 |
1634003 | 1634003 | 2021-08-19 | Humphreys | Tennessee | 47085 | 2233 | 32 |
1634046 | 1634046 | 2021-08-19 | Unicoi | Tennessee | 47171 | 2233 | 51 |
1627133 | 1627133 | 2021-08-17 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1623886 | 1623886 | 2021-08-16 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1620639 | 1620639 | 2021-08-15 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1617391 | 1617391 | 2021-08-14 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1614143 | 1614143 | 2021-08-13 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1610894 | 1610894 | 2021-08-12 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1607646 | 1607646 | 2021-08-11 | Marshall | Oklahoma | 40095 | 2233 | 23 |
1587025 | 1587025 | 2021-08-05 | Letcher | Kentucky | 21133 | 2233 | 47 |
1585042 | 1585042 | 2021-08-04 | Aguadilla | Puerto Rico | 72005 | 2233 | |
1576608 | 1576608 | 2021-08-02 | Ben Hill | Georgia | 13017 | 2233 | 84 |
1579085 | 1579085 | 2021-08-02 | Young | Texas | 48503 | 2233 | 45 |
1579170 | 1579170 | 2021-08-02 | Dinwiddie | Virginia | 51053 | 2233 | 46 |
1573741 | 1573741 | 2021-08-01 | Sullivan | Indiana | 18153 | 2233 | 43 |
1575837 | 1575837 | 2021-08-01 | Young | Texas | 48503 | 2233 | 45 |
1570493 | 1570493 | 2021-07-31 | Sullivan | Indiana | 18153 | 2233 | 43 |
1572589 | 1572589 | 2021-07-31 | Young | Texas | 48503 | 2233 | 45 |
1567245 | 1567245 | 2021-07-30 | Sullivan | Indiana | 18153 | 2233 | 43 |
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);