ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 4361 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Illinois 19
- Texas 13
- Mississippi 10
- North Carolina 10
- Ohio 7
- Georgia 6
- Indiana 6
- Puerto Rico 6
- Missouri 5
- Pennsylvania 5
- Louisiana 4
- Nebraska 4
- New Mexico 3
- New York 3
- Utah 3
- Virginia 3
- Wisconsin 3
- Arizona 2
- Arkansas 2
- California 2
- Kansas 2
- Kentucky 2
- Oregon 2
- West Virginia 2
- Alabama 1
- Delaware 1
- Iowa 1
- Maine 1
- North Dakota 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449819 | 2449819 | 2022-04-27 | Catano | Puerto Rico | 72033 | 4361 | |
2450356 | 2450356 | 2022-04-27 | Duchesne | Utah | 49013 | 4361 | 26 |
2447099 | 2447099 | 2022-04-26 | Duchesne | Utah | 49013 | 4361 | 26 |
2443844 | 2443844 | 2022-04-25 | Duchesne | Utah | 49013 | 4361 | 26 |
2301656 | 2301656 | 2022-03-13 | Hancock | Illinois | 17067 | 4361 | 57 |
2298404 | 2298404 | 2022-03-12 | Hancock | Illinois | 17067 | 4361 | 57 |
2295152 | 2295152 | 2022-03-11 | Hancock | Illinois | 17067 | 4361 | 57 |
2288688 | 2288688 | 2022-03-09 | Piatt | Illinois | 17147 | 4361 | 29 |
2285397 | 2285397 | 2022-03-08 | Hancock | Illinois | 17067 | 4361 | 55 |
2282145 | 2282145 | 2022-03-07 | Hancock | Illinois | 17067 | 4361 | 55 |
2246642 | 2246642 | 2022-02-24 | Bourbon | Kansas | 20011 | 4361 | 46 |
2243391 | 2243391 | 2022-02-23 | Bourbon | Kansas | 20011 | 4361 | 46 |
2224743 | 2224743 | 2022-02-17 | Washington | Nebraska | 31177 | 4361 | 34 |
2202454 | 2202454 | 2022-02-10 | Clatsop | Oregon | 41007 | 4361 | 38 |
2183059 | 2183059 | 2022-02-04 | Fajardo | Puerto Rico | 72053 | 4361 | |
2173914 | 2173914 | 2022-02-01 | Fluvanna | Virginia | 51065 | 4361 | 33 |
2167821 | 2167821 | 2022-01-31 | Drew | Arkansas | 5043 | 4361 | 58 |
2159114 | 2159114 | 2022-01-28 | Franklin | Maine | 23007 | 4361 | 47 |
2128606 | 2128606 | 2022-01-18 | Taylor | Wisconsin | 55119 | 4361 | 62 |
2107841 | 2107841 | 2022-01-12 | Martin | North Carolina | 37117 | 4361 | 77 |
2104064 | 2104064 | 2022-01-11 | Grenada | Mississippi | 28043 | 4361 | 112 |
2101755 | 2101755 | 2022-01-10 | Manati | Puerto Rico | 72091 | 4361 | |
2081775 | 2081775 | 2022-01-04 | Anson | North Carolina | 37007 | 4361 | 86 |
2035864 | 2035864 | 2021-12-21 | Audrain | Missouri | 29007 | 4361 | 82 |
2003420 | 2003420 | 2021-12-11 | Miller | Missouri | 29131 | 4361 | 100 |
1993534 | 1993534 | 2021-12-08 | Covington | Mississippi | 28031 | 4361 | 95 |
1945016 | 1945016 | 2021-11-23 | Adams | Nebraska | 31001 | 4361 | 54 |
1938008 | 1938008 | 2021-11-21 | Richland | Louisiana | 22083 | 4361 | 79 |
1934758 | 1934758 | 2021-11-20 | Richland | Louisiana | 22083 | 4361 | 79 |
1930461 | 1930461 | 2021-11-19 | Carroll | Arkansas | 5015 | 4361 | 75 |
1931507 | 1931507 | 2021-11-19 | Richland | Louisiana | 22083 | 4361 | 79 |
1892140 | 1892140 | 2021-11-07 | Wells | Indiana | 18179 | 4361 | 92 |
1888890 | 1888890 | 2021-11-06 | Wells | Indiana | 18179 | 4361 | 92 |
1885640 | 1885640 | 2021-11-05 | Wells | Indiana | 18179 | 4361 | 92 |
1870419 | 1870419 | 2021-10-31 | Cibola | New Mexico | 35006 | 4361 | 141 |
1867170 | 1867170 | 2021-10-30 | Cibola | New Mexico | 35006 | 4361 | 141 |
1863921 | 1863921 | 2021-10-29 | Cibola | New Mexico | 35006 | 4361 | 141 |
1859481 | 1859481 | 2021-10-28 | Fayette | Illinois | 17051 | 4361 | 67 |
1856675 | 1856675 | 2021-10-27 | Lincoln | Kentucky | 21137 | 4361 | 89 |
1846540 | 1846540 | 2021-10-24 | Saline | Illinois | 17165 | 4361 | 85 |
1843290 | 1843290 | 2021-10-23 | Saline | Illinois | 17165 | 4361 | 85 |
1840040 | 1840040 | 2021-10-22 | Saline | Illinois | 17165 | 4361 | 85 |
1804224 | 1804224 | 2021-10-11 | Bureau | Illinois | 17011 | 4361 | 102 |
1800975 | 1800975 | 2021-10-10 | Bureau | Illinois | 17011 | 4361 | 102 |
1803495 | 1803495 | 2021-10-10 | Mineral | West Virginia | 54057 | 4361 | 106 |
1797726 | 1797726 | 2021-10-09 | Bureau | Illinois | 17011 | 4361 | 102 |
1794477 | 1794477 | 2021-10-08 | Bureau | Illinois | 17011 | 4361 | 102 |
1791229 | 1791229 | 2021-10-07 | Bureau | Illinois | 17011 | 4361 | 102 |
1773532 | 1773532 | 2021-10-01 | Vega Baja | Puerto Rico | 72145 | 4361 | |
1770282 | 1770282 | 2021-09-30 | Vega Baja | Puerto Rico | 72145 | 4361 | |
1733582 | 1733582 | 2021-09-19 | Itawamba | Mississippi | 28057 | 4361 | 98 |
1733623 | 1733623 | 2021-09-19 | Tippah | Mississippi | 28139 | 4361 | 80 |
1730332 | 1730332 | 2021-09-18 | Itawamba | Mississippi | 28057 | 4361 | 98 |
1730373 | 1730373 | 2021-09-18 | Tippah | Mississippi | 28139 | 4361 | 80 |
1727082 | 1727082 | 2021-09-17 | Itawamba | Mississippi | 28057 | 4361 | 98 |
1727123 | 1727123 | 2021-09-17 | Tippah | Mississippi | 28139 | 4361 | 80 |
1700139 | 1700139 | 2021-09-09 | Madison | Georgia | 13195 | 4361 | 61 |
1641812 | 1641812 | 2021-08-22 | Fulton | Illinois | 17057 | 4361 | 69 |
1638121 | 1638121 | 2021-08-21 | Amador | California | 6005 | 4361 | 50 |
1638562 | 1638562 | 2021-08-21 | Fulton | Illinois | 17057 | 4361 | 69 |
1635312 | 1635312 | 2021-08-20 | Fulton | Illinois | 17057 | 4361 | 69 |
1618943 | 1618943 | 2021-08-15 | Oconee | Georgia | 13219 | 4361 | 74 |
1615695 | 1615695 | 2021-08-14 | Oconee | Georgia | 13219 | 4361 | 74 |
1612446 | 1612446 | 2021-08-13 | Oconee | Georgia | 13219 | 4361 | 74 |
1604075 | 1604075 | 2021-08-10 | Montgomery | New York | 36057 | 4361 | 128 |
1600536 | 1600536 | 2021-08-09 | Pulaski | Missouri | 29169 | 4361 | 59 |
1577671 | 1577671 | 2021-08-02 | Monroe | Mississippi | 28095 | 4361 | 137 |
1568595 | 1568595 | 2021-07-30 | Putnam | Ohio | 39137 | 4361 | 104 |
1564799 | 1564799 | 2021-07-29 | Polk | Missouri | 29167 | 4361 | 48 |
1561551 | 1561551 | 2021-07-28 | Polk | Missouri | 29167 | 4361 | 47 |
1556256 | 1556256 | 2021-07-26 | Matagorda | Texas | 48321 | 4361 | 115 |
1556335 | 1556335 | 2021-07-26 | Waller | Texas | 48473 | 4361 | 52 |
1532824 | 1532824 | 2021-07-19 | Defiance | Ohio | 39039 | 4361 | 99 |
1529577 | 1529577 | 2021-07-18 | Defiance | Ohio | 39039 | 4361 | 99 |
1483938 | 1483938 | 2021-07-04 | Tompkins | New York | 36109 | 4361 | 52 |
1480692 | 1480692 | 2021-07-03 | Tompkins | New York | 36109 | 4361 | 52 |
1474950 | 1474950 | 2021-07-01 | Brown | Texas | 48049 | 4361 | 140 |
1471704 | 1471704 | 2021-06-30 | Brown | Texas | 48049 | 4361 | 140 |
1468459 | 1468459 | 2021-06-29 | Brown | Texas | 48049 | 4361 | 140 |
1465214 | 1465214 | 2021-06-28 | Brown | Texas | 48049 | 4361 | 140 |
1461969 | 1461969 | 2021-06-27 | Brown | Texas | 48049 | 4361 | 140 |
1458724 | 1458724 | 2021-06-26 | Brown | Texas | 48049 | 4361 | 140 |
1455479 | 1455479 | 2021-06-25 | Brown | Texas | 48049 | 4361 | 140 |
1451649 | 1451649 | 2021-06-24 | Ashland | Ohio | 39005 | 4361 | 97 |
1307495 | 1307495 | 2021-05-11 | Harrison | Indiana | 18061 | 4361 | 74 |
1305623 | 1305623 | 2021-05-10 | Madison | Ohio | 39097 | 4361 | 61 |
1290240 | 1290240 | 2021-05-05 | Danville city | Virginia | 51590 | 4361 | 135 |
1285217 | 1285217 | 2021-05-04 | Washington | Louisiana | 22117 | 4361 | 131 |
1260310 | 1260310 | 2021-04-26 | Linn | Oregon | 41043 | 4361 | 64 |
1241695 | 1241695 | 2021-04-20 | Jefferson | West Virginia | 54037 | 4361 | 49 |
1232611 | 1232611 | 2021-04-18 | Thomas | Georgia | 13275 | 4361 | 123 |
1234084 | 1234084 | 2021-04-18 | Watauga | North Carolina | 37189 | 4361 | 30 |
1230836 | 1230836 | 2021-04-17 | Watauga | North Carolina | 37189 | 4361 | 30 |
1227588 | 1227588 | 2021-04-16 | Watauga | North Carolina | 37189 | 4361 | 30 |
1199113 | 1199113 | 2021-04-07 | Kerr | Texas | 48265 | 4361 | 84 |
1193323 | 1193323 | 2021-04-06 | Nevada | California | 6057 | 4361 | 75 |
1168186 | 1168186 | 2021-03-29 | Jessamine | Kentucky | 21113 | 4361 | 60 |
1126826 | 1126826 | 2021-03-16 | Beaufort | North Carolina | 37013 | 4361 | 87 |
1110152 | 1110152 | 2021-03-11 | Panola | Mississippi | 28107 | 4361 | 99 |
1107865 | 1107865 | 2021-03-10 | Chesterfield | South Carolina | 45025 | 4361 | 98 |
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);