ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
234 rows where cases = 2729 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Texas 16
- Missouri 15
- North Dakota 14
- Wisconsin 13
- Louisiana 11
- Indiana 10
- Virginia 10
- Minnesota 9
- Ohio 8
- Tennessee 8
- Alabama 7
- California 7
- Mississippi 7
- Florida 6
- Kansas 6
- Illinois 5
- Puerto Rico 5
- Idaho 4
- Iowa 4
- Kentucky 4
- New Hampshire 4
- North Carolina 4
- Oklahoma 4
- South Carolina 4
- South Dakota 4
- West Virginia 4
- Arkansas 3
- Maryland 3
- Colorado 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498355 | 2498355 | 2022-05-12 | McLean | North Dakota | 38055 | 2729 | 49 |
2495097 | 2495097 | 2022-05-11 | McLean | North Dakota | 38055 | 2729 | 49 |
2491839 | 2491839 | 2022-05-10 | McLean | North Dakota | 38055 | 2729 | 49 |
2488581 | 2488581 | 2022-05-09 | McLean | North Dakota | 38055 | 2729 | 49 |
2485324 | 2485324 | 2022-05-08 | McLean | North Dakota | 38055 | 2729 | 49 |
2482066 | 2482066 | 2022-05-07 | McLean | North Dakota | 38055 | 2729 | 49 |
2478808 | 2478808 | 2022-05-06 | McLean | North Dakota | 38055 | 2729 | 49 |
2475550 | 2475550 | 2022-05-05 | McLean | North Dakota | 38055 | 2729 | 49 |
2472293 | 2472293 | 2022-05-04 | McLean | North Dakota | 38055 | 2729 | 49 |
2469037 | 2469037 | 2022-05-03 | McLean | North Dakota | 38055 | 2729 | 49 |
2465781 | 2465781 | 2022-05-02 | McLean | North Dakota | 38055 | 2729 | 49 |
2462526 | 2462526 | 2022-05-01 | McLean | North Dakota | 38055 | 2729 | 49 |
2459270 | 2459270 | 2022-04-30 | McLean | North Dakota | 38055 | 2729 | 49 |
2456014 | 2456014 | 2022-04-29 | McLean | North Dakota | 38055 | 2729 | 49 |
2347160 | 2347160 | 2022-03-27 | Shoshone | Idaho | 16079 | 2729 | 75 |
2343907 | 2343907 | 2022-03-26 | Shoshone | Idaho | 16079 | 2729 | 75 |
2340654 | 2340654 | 2022-03-25 | Shoshone | Idaho | 16079 | 2729 | 75 |
2337401 | 2337401 | 2022-03-24 | Shoshone | Idaho | 16079 | 2729 | 75 |
2293739 | 2293739 | 2022-03-10 | Butte | South Dakota | 46019 | 2729 | 44 |
2290487 | 2290487 | 2022-03-09 | Butte | South Dakota | 46019 | 2729 | 44 |
2286739 | 2286739 | 2022-03-08 | Perquimans | North Carolina | 37143 | 2729 | 18 |
2287235 | 2287235 | 2022-03-08 | Butte | South Dakota | 46019 | 2729 | 44 |
2248885 | 2248885 | 2022-02-24 | Summers | West Virginia | 54089 | 2729 | 47 |
2244845 | 2244845 | 2022-02-23 | Comerio | Puerto Rico | 72045 | 2729 | |
2241594 | 2241594 | 2022-02-22 | Comerio | Puerto Rico | 72045 | 2729 | |
2238343 | 2238343 | 2022-02-21 | Comerio | Puerto Rico | 72045 | 2729 | |
2233175 | 2233175 | 2022-02-20 | Early | Georgia | 13099 | 2729 | 60 |
2235092 | 2235092 | 2022-02-20 | Comerio | Puerto Rico | 72045 | 2729 | |
2229924 | 2229924 | 2022-02-19 | Early | Georgia | 13099 | 2729 | 60 |
2226673 | 2226673 | 2022-02-18 | Early | Georgia | 13099 | 2729 | 60 |
2219174 | 2219174 | 2022-02-15 | Eastland | Texas | 48133 | 2729 | 102 |
2211481 | 2211481 | 2022-02-13 | Barton | Missouri | 29011 | 2729 | 46 |
2208228 | 2208228 | 2022-02-12 | Barton | Missouri | 29011 | 2729 | 46 |
2204975 | 2204975 | 2022-02-11 | Barton | Missouri | 29011 | 2729 | 46 |
2201722 | 2201722 | 2022-02-10 | Barton | Missouri | 29011 | 2729 | 46 |
2164652 | 2164652 | 2022-01-30 | Plumas | California | 6063 | 2729 | 12 |
2161397 | 2161397 | 2022-01-29 | Plumas | California | 6063 | 2729 | 12 |
2158141 | 2158141 | 2022-01-28 | Plumas | California | 6063 | 2729 | 12 |
2128854 | 2128854 | 2022-01-19 | Mono | California | 6051 | 2729 | 4 |
2123290 | 2123290 | 2022-01-17 | Madison | Louisiana | 22065 | 2729 | 55 |
2120038 | 2120038 | 2022-01-16 | Madison | Louisiana | 22065 | 2729 | 55 |
2116786 | 2116786 | 2022-01-15 | Madison | Louisiana | 22065 | 2729 | 55 |
2113535 | 2113535 | 2022-01-14 | Madison | Louisiana | 22065 | 2729 | 55 |
2097509 | 2097509 | 2022-01-09 | Pennington | Minnesota | 27113 | 2729 | 33 |
2094257 | 2094257 | 2022-01-08 | Pennington | Minnesota | 27113 | 2729 | 33 |
2091005 | 2091005 | 2022-01-07 | Pennington | Minnesota | 27113 | 2729 | 33 |
2085816 | 2085816 | 2022-01-05 | Falls | Texas | 48145 | 2729 | 52 |
2058713 | 2058713 | 2021-12-28 | Ste. Genevieve | Missouri | 29186 | 2729 | 34 |
2033561 | 2033561 | 2021-12-20 | Lee | South Carolina | 45061 | 2729 | 80 |
2029342 | 2029342 | 2021-12-19 | Smith | Mississippi | 28129 | 2729 | 52 |
2026091 | 2026091 | 2021-12-18 | Smith | Mississippi | 28129 | 2729 | 52 |
2022840 | 2022840 | 2021-12-17 | Smith | Mississippi | 28129 | 2729 | 52 |
2016417 | 2016417 | 2021-12-15 | Livingston | Missouri | 29117 | 2729 | 79 |
2004631 | 2004631 | 2021-12-11 | Llano | Texas | 48299 | 2729 | 80 |
1991808 | 1991808 | 2021-12-07 | Colonial Heights city | Virginia | 51570 | 2729 | 70 |
1982217 | 1982217 | 2021-12-04 | Hardy | West Virginia | 54031 | 2729 | 35 |
1941485 | 1941485 | 2021-11-22 | Redwood | Minnesota | 27127 | 2729 | 45 |
1943039 | 1943039 | 2021-11-22 | Buckingham | Virginia | 51029 | 2729 | 38 |
1939996 | 1939996 | 2021-11-21 | Wetzel | West Virginia | 54103 | 2729 | 58 |
1927703 | 1927703 | 2021-11-18 | Cass | Illinois | 17017 | 2729 | 40 |
1924457 | 1924457 | 2021-11-17 | Clay | Illinois | 17025 | 2729 | 59 |
1915150 | 1915150 | 2021-11-14 | Jackson | Kentucky | 21109 | 2729 | 51 |
1911900 | 1911900 | 2021-11-13 | Jackson | Kentucky | 21109 | 2729 | 51 |
1908651 | 1908651 | 2021-11-12 | Jackson | Kentucky | 21109 | 2729 | 51 |
1905112 | 1905112 | 2021-11-11 | Perry | Indiana | 18123 | 2729 | 55 |
1902504 | 1902504 | 2021-11-10 | Wadena | Minnesota | 27159 | 2729 | 33 |
1869996 | 1869996 | 2021-10-31 | Roseau | Minnesota | 27135 | 2729 | 28 |
1870393 | 1870393 | 2021-10-31 | Unknown | New Hampshire | 2729 | 22 | |
1870715 | 1870715 | 2021-10-31 | Meigs | Ohio | 39105 | 2729 | 55 |
1866747 | 1866747 | 2021-10-30 | Roseau | Minnesota | 27135 | 2729 | 28 |
1867144 | 1867144 | 2021-10-30 | Unknown | New Hampshire | 2729 | 22 | |
1863498 | 1863498 | 2021-10-29 | Roseau | Minnesota | 27135 | 2729 | 28 |
1863895 | 1863895 | 2021-10-29 | Unknown | New Hampshire | 2729 | 22 | |
1855871 | 1855871 | 2021-10-27 | Elbert | Colorado | 8039 | 2729 | 24 |
1835920 | 1835920 | 2021-10-20 | Asotin | Washington | 53003 | 2729 | 50 |
1791731 | 1791731 | 2021-10-07 | Spencer | Kentucky | 21215 | 2729 | 31 |
1788519 | 1788519 | 2021-10-06 | Jackson | Louisiana | 22049 | 2729 | 61 |
1789163 | 1789163 | 2021-10-06 | Sullivan | New Hampshire | 33019 | 2729 | 31 |
1785546 | 1785546 | 2021-10-05 | Calhoun | Mississippi | 28013 | 2729 | 45 |
1694418 | 1694418 | 2021-09-07 | Clare | Michigan | 26035 | 2729 | 89 |
1692350 | 1692350 | 2021-09-06 | Hampton | South Carolina | 45049 | 2729 | 64 |
1686692 | 1686692 | 2021-09-05 | Henry | Alabama | 1067 | 2729 | 48 |
1689713 | 1689713 | 2021-09-05 | Waynesboro city | Virginia | 51820 | 2729 | 39 |
1686463 | 1686463 | 2021-09-04 | Waynesboro city | Virginia | 51820 | 2729 | 39 |
1683212 | 1683212 | 2021-09-03 | Waynesboro city | Virginia | 51820 | 2729 | 39 |
1670606 | 1670606 | 2021-08-31 | Colusa | California | 6011 | 2729 | 18 |
1653540 | 1653540 | 2021-08-25 | Trousdale | Tennessee | 47169 | 2729 | 22 |
1650293 | 1650293 | 2021-08-24 | Trousdale | Tennessee | 47169 | 2729 | 22 |
1647145 | 1647145 | 2021-08-23 | Gray | Texas | 48179 | 2729 | 60 |
1643896 | 1643896 | 2021-08-22 | Gray | Texas | 48179 | 2729 | 60 |
1640646 | 1640646 | 2021-08-21 | Gray | Texas | 48179 | 2729 | 59 |
1628690 | 1628690 | 2021-08-18 | Pike | Georgia | 13231 | 2729 | 46 |
1618890 | 1618890 | 2021-08-15 | Fannin | Georgia | 13111 | 2729 | 75 |
1615642 | 1615642 | 2021-08-14 | Fannin | Georgia | 13111 | 2729 | 75 |
1612393 | 1612393 | 2021-08-13 | Fannin | Georgia | 13111 | 2729 | 75 |
1569175 | 1569175 | 2021-07-30 | Gillespie | Texas | 48171 | 2729 | 53 |
1563899 | 1563899 | 2021-07-29 | Saline | Illinois | 17165 | 2729 | 73 |
1558798 | 1558798 | 2021-07-27 | Coshocton | Ohio | 39031 | 2729 | 61 |
1553506 | 1553506 | 2021-07-26 | Geneva | Alabama | 1061 | 2729 | 83 |
1553407 | 1553407 | 2021-07-25 | Jackson | Wisconsin | 55053 | 2729 | 29 |
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);