ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 3983 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 10
- Kansas 9
- Indiana 8
- Oklahoma 8
- Tennessee 7
- Utah 7
- Illinois 6
- Minnesota 6
- Mississippi 6
- Georgia 5
- Missouri 5
- Alabama 4
- Kentucky 4
- North Carolina 4
- Puerto Rico 4
- Virginia 4
- Arkansas 3
- Michigan 3
- New York 3
- North Dakota 3
- Ohio 3
- Pennsylvania 3
- Idaho 2
- South Carolina 2
- South Dakota 2
- West Virginia 2
- California 1
- Colorado 1
- Louisiana 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466086 | 2466086 | 2022-05-02 | Aibonito | Puerto Rico | 72009 | 3983 | |
2450368 | 2450368 | 2022-04-27 | San Juan | Utah | 49037 | 3983 | 48 |
2447111 | 2447111 | 2022-04-26 | San Juan | Utah | 49037 | 3983 | 48 |
2443856 | 2443856 | 2022-04-25 | San Juan | Utah | 49037 | 3983 | 48 |
2440600 | 2440600 | 2022-04-24 | San Juan | Utah | 49037 | 3983 | 48 |
2437344 | 2437344 | 2022-04-23 | San Juan | Utah | 49037 | 3983 | 48 |
2434088 | 2434088 | 2022-04-22 | San Juan | Utah | 49037 | 3983 | 48 |
2430832 | 2430832 | 2022-04-21 | San Juan | Utah | 49037 | 3983 | 48 |
2405106 | 2405106 | 2022-04-13 | Washburn | Wisconsin | 55129 | 3983 | 46 |
2395099 | 2395099 | 2022-04-10 | Goochland | Virginia | 51075 | 3983 | 51 |
2391843 | 2391843 | 2022-04-09 | Goochland | Virginia | 51075 | 3983 | 51 |
2388587 | 2388587 | 2022-04-08 | Goochland | Virginia | 51075 | 3983 | 51 |
2248267 | 2248267 | 2022-02-24 | Union | South Dakota | 46127 | 3983 | 49 |
2221776 | 2221776 | 2022-02-16 | Richland | North Dakota | 38077 | 3983 | 21 |
2201715 | 2201715 | 2022-02-10 | Yalobusha | Mississippi | 28161 | 3983 | 51 |
2199316 | 2199316 | 2022-02-09 | Catano | Puerto Rico | 72033 | 3983 | |
2195216 | 2195216 | 2022-02-08 | Benton | Missouri | 29015 | 3983 | 88 |
2091971 | 2091971 | 2022-01-07 | Cayey | Puerto Rico | 72035 | 3983 | |
2083268 | 2083268 | 2022-01-05 | Lincoln | Arkansas | 5079 | 3983 | 59 |
2083736 | 2083736 | 2022-01-05 | Crawford | Illinois | 17033 | 3983 | 51 |
2035270 | 2035270 | 2021-12-21 | Cherokee | Kansas | 20021 | 3983 | 78 |
2037476 | 2037476 | 2021-12-21 | Hampshire | West Virginia | 54027 | 3983 | 55 |
2032020 | 2032020 | 2021-12-20 | Cherokee | Kansas | 20021 | 3983 | 78 |
2019575 | 2019575 | 2021-12-16 | Newton | Mississippi | 28101 | 3983 | 83 |
2017282 | 2017282 | 2021-12-15 | Barnwell | South Carolina | 45011 | 3983 | 88 |
1995258 | 1995258 | 2021-12-08 | Wyoming | West Virginia | 54109 | 3983 | 72 |
1984927 | 1984927 | 2021-12-05 | Johnson | Tennessee | 47091 | 3983 | 53 |
1981677 | 1981677 | 2021-12-04 | Johnson | Tennessee | 47091 | 3983 | 53 |
1978427 | 1978427 | 2021-12-03 | Johnson | Tennessee | 47091 | 3983 | 53 |
1970356 | 1970356 | 2021-12-01 | Allen | Kentucky | 21003 | 3983 | 75 |
1960369 | 1960369 | 2021-11-28 | Posey | Indiana | 18129 | 3983 | 44 |
1957118 | 1957118 | 2021-11-27 | Posey | Indiana | 18129 | 3983 | 44 |
1953867 | 1953867 | 2021-11-26 | Posey | Indiana | 18129 | 3983 | 44 |
1950616 | 1950616 | 2021-11-25 | Posey | Indiana | 18129 | 3983 | 44 |
1947365 | 1947365 | 2021-11-24 | Posey | Indiana | 18129 | 3983 | 44 |
1945574 | 1945574 | 2021-11-23 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1942323 | 1942323 | 2021-11-22 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1939073 | 1939073 | 2021-11-21 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1935823 | 1935823 | 2021-11-20 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1932573 | 1932573 | 2021-11-19 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1929322 | 1929322 | 2021-11-18 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1926072 | 1926072 | 2021-11-17 | Woodward | Oklahoma | 40153 | 3983 | 51 |
1919253 | 1919253 | 2021-11-15 | Anson | North Carolina | 37007 | 3983 | 82 |
1891522 | 1891522 | 2021-11-07 | Sevier | Arkansas | 5133 | 3983 | 53 |
1882046 | 1882046 | 2021-11-04 | Franklin | Georgia | 13119 | 3983 | 82 |
1836703 | 1836703 | 2021-10-21 | Payette | Idaho | 16075 | 3983 | 58 |
1831173 | 1831173 | 2021-10-19 | McDonald | Missouri | 29119 | 3983 | 58 |
1827924 | 1827924 | 2021-10-18 | McDonald | Missouri | 29119 | 3983 | 58 |
1816117 | 1816117 | 2021-10-14 | Karnes | Texas | 48255 | 3983 | 54 |
1782960 | 1782960 | 2021-10-04 | Fayette | Ohio | 39047 | 3983 | 56 |
1758845 | 1758845 | 2021-09-27 | Clay | Indiana | 18021 | 3983 | 58 |
1753760 | 1753760 | 2021-09-25 | Pike | Ohio | 39131 | 3983 | 45 |
1714769 | 1714769 | 2021-09-13 | Perry | Ohio | 39127 | 3983 | 50 |
1700328 | 1700328 | 2021-09-09 | Perry | Illinois | 17145 | 3983 | 78 |
1699462 | 1699462 | 2021-09-08 | Wise | Virginia | 51195 | 3983 | 111 |
1675105 | 1675105 | 2021-09-01 | Itawamba | Mississippi | 28057 | 3983 | 85 |
1676202 | 1676202 | 2021-09-01 | Claiborne | Tennessee | 47025 | 3983 | 80 |
1646769 | 1646769 | 2021-08-23 | Arecibo | Puerto Rico | 72013 | 3983 | |
1647015 | 1647015 | 2021-08-23 | Marion | Tennessee | 47115 | 3983 | 51 |
1632368 | 1632368 | 2021-08-19 | Harvey | Kansas | 20079 | 3983 | 73 |
1632659 | 1632659 | 2021-08-19 | Worcester | Maryland | 24047 | 3983 | 107 |
1633746 | 1633746 | 2021-08-19 | Perry | Pennsylvania | 42099 | 3983 | 101 |
1628210 | 1628210 | 2021-08-18 | Dallas | Alabama | 1047 | 3983 | 165 |
1629121 | 1629121 | 2021-08-18 | Harvey | Kansas | 20079 | 3983 | 73 |
1601626 | 1601626 | 2021-08-09 | Cooke | Texas | 48097 | 3983 | 72 |
1598378 | 1598378 | 2021-08-08 | Cooke | Texas | 48097 | 3983 | 72 |
1595129 | 1595129 | 2021-08-07 | Cooke | Texas | 48097 | 3983 | 72 |
1519306 | 1519306 | 2021-07-15 | Lawrence | Missouri | 29109 | 3983 | 89 |
1470457 | 1470457 | 2021-06-30 | Steele | Minnesota | 27147 | 3983 | 18 |
1467212 | 1467212 | 2021-06-29 | Steele | Minnesota | 27147 | 3983 | 18 |
1463967 | 1463967 | 2021-06-28 | Steele | Minnesota | 27147 | 3983 | 18 |
1460722 | 1460722 | 2021-06-27 | Steele | Minnesota | 27147 | 3983 | 18 |
1440506 | 1440506 | 2021-06-21 | Logan | Illinois | 17107 | 3983 | 77 |
1378211 | 1378211 | 2021-06-02 | Escambia | Alabama | 1053 | 3983 | 77 |
1349709 | 1349709 | 2021-05-24 | Huntington | Indiana | 18069 | 3983 | 82 |
1340211 | 1340211 | 2021-05-21 | Seward | Kansas | 20175 | 3983 | 41 |
1336964 | 1336964 | 2021-05-20 | Seward | Kansas | 20175 | 3983 | 41 |
1338304 | 1338304 | 2021-05-20 | Venango | Pennsylvania | 42121 | 3983 | 95 |
1334190 | 1334190 | 2021-05-19 | Lincoln | Mississippi | 28085 | 3983 | 111 |
1326523 | 1326523 | 2021-05-17 | Logan | Colorado | 8075 | 3983 | 67 |
1311863 | 1311863 | 2021-05-12 | Columbia | New York | 36021 | 3983 | 101 |
1305841 | 1305841 | 2021-05-10 | Wayne | Pennsylvania | 42127 | 3983 | 80 |
1294191 | 1294191 | 2021-05-07 | Chattahoochee | Georgia | 13053 | 3983 | 15 |
1290945 | 1290945 | 2021-05-06 | Chattahoochee | Georgia | 13053 | 3983 | 15 |
1262345 | 1262345 | 2021-04-27 | Franklin | Kentucky | 21073 | 3983 | 46 |
1246448 | 1246448 | 2021-04-22 | Morrison | Minnesota | 27097 | 3983 | 59 |
1239231 | 1239231 | 2021-04-20 | Lee | Illinois | 17103 | 3983 | 90 |
1192940 | 1192940 | 2021-04-05 | Lewis | Washington | 53041 | 3983 | 55 |
1153424 | 1153424 | 2021-03-24 | Campbell | Tennessee | 47013 | 3983 | 59 |
1116523 | 1116523 | 2021-03-13 | Douglas | Minnesota | 27041 | 3983 | 70 |
1061459 | 1061459 | 2021-02-24 | Marshall | Mississippi | 28093 | 3983 | 92 |
1062191 | 1062191 | 2021-02-24 | Mayes | Oklahoma | 40097 | 3983 | 37 |
1051538 | 1051538 | 2021-02-21 | Isabella | Michigan | 26073 | 3983 | 73 |
1048291 | 1048291 | 2021-02-20 | Isabella | Michigan | 26073 | 3983 | 73 |
1043275 | 1043275 | 2021-02-18 | Kerr | Texas | 48265 | 3983 | 79 |
1040030 | 1040030 | 2021-02-17 | Kerr | Texas | 48265 | 3983 | 79 |
1034760 | 1034760 | 2021-02-16 | Gibson | Indiana | 18051 | 3983 | 84 |
1036785 | 1036785 | 2021-02-16 | Kerr | Texas | 48265 | 3983 | 79 |
1031452 | 1031452 | 2021-02-15 | Monroe | Illinois | 17133 | 3983 | 80 |
1033212 | 1033212 | 2021-02-15 | Chesterfield | South Carolina | 45025 | 3983 | 91 |
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);