ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4877 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 25
- Oklahoma 9
- North Carolina 7
- Idaho 6
- Ohio 6
- Alabama 5
- Arkansas 5
- Louisiana 5
- Kentucky 4
- Minnesota 4
- Iowa 3
- Michigan 3
- Missouri 3
- Pennsylvania 3
- Tennessee 3
- Texas 3
- Virginia 3
- Colorado 2
- Mississippi 2
- New York 2
- North Dakota 2
- Oregon 2
- Puerto Rico 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- California 1
- Illinois 1
- Indiana 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467533 | 2467533 | 2022-05-03 | Union | Georgia | 13291 | 4877 | 158 |
2464278 | 2464278 | 2022-05-02 | Union | Georgia | 13291 | 4877 | 158 |
2461022 | 2461022 | 2022-05-01 | Union | Georgia | 13291 | 4877 | 158 |
2457766 | 2457766 | 2022-04-30 | Union | Georgia | 13291 | 4877 | 158 |
2454510 | 2454510 | 2022-04-29 | Union | Georgia | 13291 | 4877 | 158 |
2451254 | 2451254 | 2022-04-28 | Union | Georgia | 13291 | 4877 | 158 |
2447998 | 2447998 | 2022-04-27 | Union | Georgia | 13291 | 4877 | 158 |
2438230 | 2438230 | 2022-04-24 | Union | Georgia | 13291 | 4877 | 155 |
2434974 | 2434974 | 2022-04-23 | Union | Georgia | 13291 | 4877 | 155 |
2431718 | 2431718 | 2022-04-22 | Union | Georgia | 13291 | 4877 | 155 |
2428462 | 2428462 | 2022-04-21 | Union | Georgia | 13291 | 4877 | 155 |
2425206 | 2425206 | 2022-04-20 | Union | Georgia | 13291 | 4877 | 155 |
2404086 | 2404086 | 2022-04-13 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2399089 | 2399089 | 2022-04-12 | Hart | Georgia | 13147 | 4877 | 94 |
2400831 | 2400831 | 2022-04-12 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2397576 | 2397576 | 2022-04-11 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2394321 | 2394321 | 2022-04-10 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2391065 | 2391065 | 2022-04-09 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2387809 | 2387809 | 2022-04-08 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2384554 | 2384554 | 2022-04-07 | McIntosh | Oklahoma | 40091 | 4877 | 124 |
2379557 | 2379557 | 2022-04-06 | Hart | Georgia | 13147 | 4877 | 92 |
2376303 | 2376303 | 2022-04-05 | Hart | Georgia | 13147 | 4877 | 91 |
2356014 | 2356014 | 2022-03-29 | Buchanan | Virginia | 51027 | 4877 | 112 |
2314493 | 2314493 | 2022-03-17 | Hart | Georgia | 13147 | 4877 | 89 |
2217791 | 2217791 | 2022-02-15 | Osceola | Michigan | 26133 | 4877 | 71 |
2214540 | 2214540 | 2022-02-14 | Osceola | Michigan | 26133 | 4877 | 71 |
2202483 | 2202483 | 2022-02-10 | Wasco | Oregon | 41065 | 4877 | 53 |
2186785 | 2186785 | 2022-02-05 | Scurry | Texas | 48415 | 4877 | 95 |
2130715 | 2130715 | 2022-01-19 | Carroll | Ohio | 39019 | 4877 | 100 |
2131014 | 2131014 | 2022-01-19 | Juana Diaz | Puerto Rico | 72075 | 4877 | |
2100019 | 2100019 | 2022-01-10 | Jersey | Illinois | 17083 | 4877 | 77 |
2089650 | 2089650 | 2022-01-07 | Geneva | Alabama | 1061 | 4877 | 138 |
2079172 | 2079172 | 2022-01-03 | Grainger | Tennessee | 47057 | 4877 | 91 |
2061892 | 2061892 | 2021-12-29 | Dunklin | Missouri | 29069 | 4877 | 93 |
2055787 | 2055787 | 2021-12-27 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2052537 | 2052537 | 2021-12-26 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2049287 | 2049287 | 2021-12-25 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2046037 | 2046037 | 2021-12-24 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2042787 | 2042787 | 2021-12-23 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2039538 | 2039538 | 2021-12-22 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2030778 | 2030778 | 2021-12-19 | Franklin | Vermont | 50011 | 4877 | 54 |
2024623 | 2024623 | 2021-12-18 | Clarke | Alabama | 1025 | 4877 | 87 |
2024797 | 2024797 | 2021-12-18 | Yell | Arkansas | 5149 | 4877 | 87 |
2020699 | 2020699 | 2021-12-16 | McNairy | Tennessee | 47109 | 4877 | 78 |
1998644 | 1998644 | 2021-12-10 | Lawrence | Alabama | 1079 | 4877 | 130 |
1974046 | 1974046 | 2021-12-02 | Itawamba | Mississippi | 28057 | 4877 | 107 |
1960117 | 1960117 | 2021-11-28 | Stephens | Georgia | 13257 | 4877 | 120 |
1956866 | 1956866 | 2021-11-27 | Stephens | Georgia | 13257 | 4877 | 120 |
1953615 | 1953615 | 2021-11-26 | Stephens | Georgia | 13257 | 4877 | 120 |
1954964 | 1954964 | 2021-11-26 | Greene | New York | 36039 | 4877 | 88 |
1950364 | 1950364 | 2021-11-25 | Stephens | Georgia | 13257 | 4877 | 120 |
1947113 | 1947113 | 2021-11-24 | Stephens | Georgia | 13257 | 4877 | 120 |
1943523 | 1943523 | 2021-11-23 | St. Francis | Arkansas | 5123 | 4877 | 69 |
1902432 | 1902432 | 2021-11-10 | Carlton | Minnesota | 27017 | 4877 | 69 |
1878652 | 1878652 | 2021-11-03 | Summit | Colorado | 8117 | 4877 | 11 |
1874130 | 1874130 | 2021-11-01 | Clarion | Pennsylvania | 42031 | 4877 | 124 |
1870881 | 1870881 | 2021-10-31 | Clarion | Pennsylvania | 42031 | 4877 | 124 |
1861148 | 1861148 | 2021-10-28 | Greene | Pennsylvania | 42059 | 4877 | 55 |
1748156 | 1748156 | 2021-09-23 | Petersburg city | Virginia | 51730 | 4877 | 97 |
1717454 | 1717454 | 2021-09-14 | Marion | Missouri | 29127 | 4877 | 58 |
1714017 | 1714017 | 2021-09-13 | McLeod | Minnesota | 27085 | 4877 | 62 |
1629597 | 1629597 | 2021-08-18 | Winona | Minnesota | 27169 | 4877 | 52 |
1605398 | 1605398 | 2021-08-10 | Monroe | Wisconsin | 55081 | 4877 | 51 |
1581594 | 1581594 | 2021-08-03 | Shelby | Ohio | 39149 | 4877 | 98 |
1579034 | 1579034 | 2021-08-02 | Rusk | Texas | 48401 | 4877 | 112 |
1579326 | 1579326 | 2021-08-02 | Jefferson | West Virginia | 54037 | 4877 | 60 |
1554001 | 1554001 | 2021-07-26 | Thomas | Georgia | 13275 | 4877 | 128 |
1551408 | 1551408 | 2021-07-25 | Washington | Louisiana | 22117 | 4877 | 139 |
1548161 | 1548161 | 2021-07-24 | Washington | Louisiana | 22117 | 4877 | 139 |
1544914 | 1544914 | 2021-07-23 | Washington | Louisiana | 22117 | 4877 | 139 |
1536237 | 1536237 | 2021-07-20 | Klamath | Oregon | 41035 | 4877 | 79 |
1528551 | 1528551 | 2021-07-18 | Hopkins | Kentucky | 21107 | 4877 | 151 |
1525304 | 1525304 | 2021-07-17 | Hopkins | Kentucky | 21107 | 4877 | 151 |
1522056 | 1522056 | 2021-07-16 | Hopkins | Kentucky | 21107 | 4877 | 151 |
1448454 | 1448454 | 2021-06-23 | Mercer | Ohio | 39107 | 4877 | 85 |
1440414 | 1440414 | 2021-06-21 | Bingham | Idaho | 16011 | 4877 | 76 |
1439005 | 1439005 | 2021-06-20 | Toa Baja | Puerto Rico | 72137 | 4877 | |
1421239 | 1421239 | 2021-06-15 | Muscatine | Iowa | 19139 | 4877 | 106 |
1414445 | 1414445 | 2021-06-13 | Bingham | Idaho | 16011 | 4877 | 76 |
1414748 | 1414748 | 2021-06-13 | Muscatine | Iowa | 19139 | 4877 | 106 |
1411200 | 1411200 | 2021-06-12 | Bingham | Idaho | 16011 | 4877 | 76 |
1407955 | 1407955 | 2021-06-11 | Bingham | Idaho | 16011 | 4877 | 76 |
1404709 | 1404709 | 2021-06-10 | Bingham | Idaho | 16011 | 4877 | 76 |
1394972 | 1394972 | 2021-06-07 | Bingham | Idaho | 16011 | 4877 | 76 |
1351019 | 1351019 | 2021-05-24 | Stark | North Dakota | 38089 | 4877 | 51 |
1323017 | 1323017 | 2021-05-16 | Dale | Alabama | 1045 | 4877 | 113 |
1271576 | 1271576 | 2021-04-30 | Tift | Georgia | 13277 | 4877 | 125 |
1266388 | 1266388 | 2021-04-28 | Otero | New Mexico | 35035 | 4877 | 74 |
1255824 | 1255824 | 2021-04-25 | Boyd | Kentucky | 21019 | 4877 | 73 |
1254704 | 1254704 | 2021-04-24 | Putnam | West Virginia | 54079 | 4877 | 100 |
1235570 | 1235570 | 2021-04-19 | Tehama | California | 6103 | 4877 | 52 |
1221880 | 1221880 | 2021-04-14 | Medina | Texas | 48325 | 4877 | 103 |
1188461 | 1188461 | 2021-04-04 | Cattaraugus | New York | 36009 | 4877 | 79 |
1133542 | 1133542 | 2021-03-18 | Sandusky | Ohio | 39143 | 4877 | 115 |
1100117 | 1100117 | 2021-03-08 | St. Martin | Louisiana | 22099 | 4877 | 112 |
1094675 | 1094675 | 2021-03-06 | Washington | Oklahoma | 40147 | 4877 | 89 |
1082699 | 1082699 | 2021-03-02 | Fremont | Wyoming | 56013 | 4877 | 82 |
1012523 | 1012523 | 2021-02-09 | Cecil | Maryland | 24015 | 4877 | 113 |
1013346 | 1013346 | 2021-02-09 | Morton | North Dakota | 38059 | 4877 | 93 |
1008525 | 1008525 | 2021-02-08 | Habersham | Georgia | 13137 | 4877 | 128 |
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);