ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where cases = 3274 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 18
- Georgia 12
- West Virginia 11
- Illinois 10
- Indiana 10
- Louisiana 10
- Texas 10
- Utah 9
- Kentucky 8
- Minnesota 7
- North Carolina 7
- Mississippi 6
- Missouri 6
- Virginia 6
- Washington 6
- Arkansas 5
- Puerto Rico 5
- South Carolina 5
- Colorado 4
- Tennessee 4
- Pennsylvania 3
- Alabama 2
- Alaska 2
- Idaho 2
- Iowa 2
- Maryland 2
- Montana 2
- New York 2
- Ohio 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502475 | 2502475 | 2022-05-13 | Millard | Utah | 49027 | 3274 | 35 |
2499217 | 2499217 | 2022-05-12 | Millard | Utah | 49027 | 3274 | 35 |
2495959 | 2495959 | 2022-05-11 | Millard | Utah | 49027 | 3274 | 35 |
2492701 | 2492701 | 2022-05-10 | Millard | Utah | 49027 | 3274 | 35 |
2489443 | 2489443 | 2022-05-09 | Millard | Utah | 49027 | 3274 | 35 |
2486185 | 2486185 | 2022-05-08 | Millard | Utah | 49027 | 3274 | 35 |
2486348 | 2486348 | 2022-05-08 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2482927 | 2482927 | 2022-05-07 | Millard | Utah | 49027 | 3274 | 35 |
2483090 | 2483090 | 2022-05-07 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2479669 | 2479669 | 2022-05-06 | Millard | Utah | 49027 | 3274 | 35 |
2479832 | 2479832 | 2022-05-06 | Westmoreland | Virginia | 51193 | 3274 | 51 |
2476411 | 2476411 | 2022-05-05 | Millard | Utah | 49027 | 3274 | 35 |
2450506 | 2450506 | 2022-04-27 | Rockbridge | Virginia | 51163 | 3274 | 80 |
2428079 | 2428079 | 2022-04-21 | Little River | Arkansas | 5081 | 3274 | 104 |
2429588 | 2429588 | 2022-04-21 | Roosevelt | Montana | 30085 | 3274 | 72 |
2426332 | 2426332 | 2022-04-20 | Roosevelt | Montana | 30085 | 3274 | 72 |
2373019 | 2373019 | 2022-04-04 | Dade | Georgia | 13083 | 3274 | 28 |
2372494 | 2372494 | 2022-04-03 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2369241 | 2369241 | 2022-04-02 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2365988 | 2365988 | 2022-04-01 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2362735 | 2362735 | 2022-03-31 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2359481 | 2359481 | 2022-03-30 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2356227 | 2356227 | 2022-03-29 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2352974 | 2352974 | 2022-03-28 | Ashland | Wisconsin | 55003 | 3274 | 36 |
2327625 | 2327625 | 2022-03-21 | Gooding | Idaho | 16047 | 3274 | 54 |
2324923 | 2324923 | 2022-03-20 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2321669 | 2321669 | 2022-03-19 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2318415 | 2318415 | 2022-03-18 | Caldwell | Louisiana | 22021 | 3274 | 53 |
2315165 | 2315165 | 2022-03-17 | Claiborne | Louisiana | 22027 | 3274 | 73 |
2311912 | 2311912 | 2022-03-16 | Claiborne | Louisiana | 22027 | 3274 | 73 |
2302835 | 2302835 | 2022-03-13 | Unknown | New Jersey | 3274 | 0 | |
2258579 | 2258579 | 2022-02-27 | Pacific | Washington | 53049 | 3274 | 51 |
2255328 | 2255328 | 2022-02-26 | Pacific | Washington | 53049 | 3274 | 51 |
2252077 | 2252077 | 2022-02-25 | Pacific | Washington | 53049 | 3274 | 51 |
2218473 | 2218473 | 2022-02-15 | Swain | North Carolina | 37173 | 3274 | 34 |
2178685 | 2178685 | 2022-02-03 | Nantucket | Massachusetts | 25019 | 3274 | 0 |
2172396 | 2172396 | 2022-02-01 | Lawrence | Mississippi | 28077 | 3274 | 46 |
2165826 | 2165826 | 2022-01-30 | Renville | Minnesota | 27129 | 3274 | 53 |
2162571 | 2162571 | 2022-01-29 | Renville | Minnesota | 27129 | 3274 | 53 |
2159316 | 2159316 | 2022-01-28 | Renville | Minnesota | 27129 | 3274 | 53 |
2149869 | 2149869 | 2022-01-25 | Gage | Nebraska | 31067 | 3274 | 37 |
2146471 | 2146471 | 2022-01-24 | Livingston | Missouri | 29117 | 3274 | 85 |
2109116 | 2109116 | 2022-01-12 | Lincoln | Wyoming | 56023 | 3274 | 27 |
2102060 | 2102060 | 2022-01-10 | DeWitt | Texas | 48123 | 3274 | 86 |
2102508 | 2102508 | 2022-01-10 | Morgan | West Virginia | 54065 | 3274 | 57 |
2095989 | 2095989 | 2022-01-08 | Hardy | West Virginia | 54031 | 3274 | 41 |
2092456 | 2092456 | 2022-01-07 | Shelby | Texas | 48419 | 3274 | 114 |
2059878 | 2059878 | 2021-12-28 | Lavaca | Texas | 48285 | 3274 | 100 |
2056629 | 2056629 | 2021-12-27 | Lavaca | Texas | 48285 | 3274 | 100 |
2051226 | 2051226 | 2021-12-26 | Clay | Illinois | 17025 | 3274 | 60 |
2047976 | 2047976 | 2021-12-25 | Clay | Illinois | 17025 | 3274 | 60 |
2044145 | 2044145 | 2021-12-24 | Henry | Alabama | 1067 | 3274 | 66 |
2044726 | 2044726 | 2021-12-24 | Clay | Illinois | 17025 | 3274 | 60 |
2041477 | 2041477 | 2021-12-23 | Clay | Illinois | 17025 | 3274 | 60 |
2019459 | 2019459 | 2021-12-16 | Fillmore | Minnesota | 27045 | 3274 | 15 |
2012007 | 2012007 | 2021-12-14 | Ben Hill | Georgia | 13017 | 3274 | 109 |
2013107 | 2013107 | 2021-12-14 | Andrew | Missouri | 29003 | 3274 | 40 |
2008756 | 2008756 | 2021-12-13 | Ben Hill | Georgia | 13017 | 3274 | 109 |
2005505 | 2005505 | 2021-12-12 | Ben Hill | Georgia | 13017 | 3274 | 109 |
2002254 | 2002254 | 2021-12-11 | Ben Hill | Georgia | 13017 | 3274 | 109 |
1999004 | 1999004 | 2021-12-10 | Ben Hill | Georgia | 13017 | 3274 | 109 |
1995644 | 1995644 | 2021-12-09 | Otero | Colorado | 8089 | 3274 | 108 |
1995753 | 1995753 | 2021-12-09 | Ben Hill | Georgia | 13017 | 3274 | 109 |
1966795 | 1966795 | 2021-11-30 | Union | Illinois | 17181 | 3274 | 54 |
1956654 | 1956654 | 2021-11-27 | Teller | Colorado | 8119 | 3274 | 41 |
1953403 | 1953403 | 2021-11-26 | Teller | Colorado | 8119 | 3274 | 41 |
1950152 | 1950152 | 2021-11-25 | Teller | Colorado | 8119 | 3274 | 41 |
1939949 | 1939949 | 2021-11-21 | Brooke | West Virginia | 54009 | 3274 | 75 |
1930271 | 1930271 | 2021-11-18 | Green Lake | Wisconsin | 55047 | 3274 | 36 |
1883004 | 1883004 | 2021-11-04 | Wabasha | Minnesota | 27157 | 3274 | 8 |
1881460 | 1881460 | 2021-11-03 | Hampshire | West Virginia | 54027 | 3274 | 49 |
1864495 | 1864495 | 2021-10-29 | Rio Grande | Puerto Rico | 72119 | 3274 | |
1820034 | 1820034 | 2021-10-16 | Randolph | Arkansas | 5121 | 3274 | 55 |
1821085 | 1821085 | 2021-10-16 | Somerset | Maryland | 24039 | 3274 | 52 |
1797002 | 1797002 | 2021-10-08 | Nicholas | West Virginia | 54067 | 3274 | 38 |
1786446 | 1786446 | 2021-10-05 | Susquehanna | Pennsylvania | 42115 | 3274 | 64 |
1778402 | 1778402 | 2021-10-03 | Spencer | Indiana | 18147 | 3274 | 37 |
1780810 | 1780810 | 2021-10-03 | Kewaunee | Wisconsin | 55061 | 3274 | 41 |
1780849 | 1780849 | 2021-10-03 | Waushara | Wisconsin | 55137 | 3274 | 48 |
1775152 | 1775152 | 2021-10-02 | Spencer | Indiana | 18147 | 3274 | 37 |
1777560 | 1777560 | 2021-10-02 | Kewaunee | Wisconsin | 55061 | 3274 | 41 |
1777599 | 1777599 | 2021-10-02 | Waushara | Wisconsin | 55137 | 3274 | 48 |
1771902 | 1771902 | 2021-10-01 | Spencer | Indiana | 18147 | 3274 | 37 |
1774310 | 1774310 | 2021-10-01 | Kewaunee | Wisconsin | 55061 | 3274 | 41 |
1774349 | 1774349 | 2021-10-01 | Waushara | Wisconsin | 55137 | 3274 | 48 |
1744600 | 1744600 | 2021-09-22 | Gray | Texas | 48179 | 3274 | 65 |
1741432 | 1741432 | 2021-09-21 | Moore | Texas | 48341 | 3274 | 79 |
1722780 | 1722780 | 2021-09-16 | Appling | Georgia | 13001 | 3274 | 84 |
1701179 | 1701179 | 2021-09-09 | Crawford | Missouri | 29055 | 3274 | 47 |
1696527 | 1696527 | 2021-09-08 | Cleburne | Arkansas | 5023 | 3274 | 84 |
1690952 | 1690952 | 2021-09-06 | Grayson | Kentucky | 21085 | 3274 | 61 |
1687702 | 1687702 | 2021-09-05 | Grayson | Kentucky | 21085 | 3274 | 61 |
1689082 | 1689082 | 2021-09-05 | Barnwell | South Carolina | 45011 | 3274 | 63 |
1684452 | 1684452 | 2021-09-04 | Grayson | Kentucky | 21085 | 3274 | 61 |
1684995 | 1684995 | 2021-09-04 | Randolph | Missouri | 29175 | 3274 | 34 |
1685832 | 1685832 | 2021-09-04 | Barnwell | South Carolina | 45011 | 3274 | 63 |
1681201 | 1681201 | 2021-09-03 | Grayson | Kentucky | 21085 | 3274 | 61 |
1682581 | 1682581 | 2021-09-03 | Barnwell | South Carolina | 45011 | 3274 | 63 |
1668259 | 1668259 | 2021-08-30 | Ohio | Kentucky | 21183 | 3274 | 59 |
1604102 | 1604102 | 2021-08-10 | Washington | New York | 36115 | 3274 | 56 |
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);