ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 5837 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Virginia 9
- Indiana 7
- Oklahoma 7
- North Carolina 6
- West Virginia 5
- Iowa 4
- Ohio 4
- Arkansas 3
- Minnesota 3
- Puerto Rico 3
- Wisconsin 3
- Illinois 2
- Kansas 2
- Missouri 2
- New York 2
- Tennessee 2
- Alabama 1
- Florida 1
- Georgia 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- Pennsylvania 1
- South Dakota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495419 | 2495419 | 2022-05-11 | Coamo | Puerto Rico | 72043 | 5837 | |
2476559 | 2476559 | 2022-05-05 | Scott | Virginia | 51169 | 5837 | 111 |
2426539 | 2426539 | 2022-04-20 | Essex | New York | 36031 | 5837 | 59 |
2424535 | 2424535 | 2022-04-19 | Hampshire | West Virginia | 54027 | 5837 | 72 |
2421279 | 2421279 | 2022-04-18 | Hampshire | West Virginia | 54027 | 5837 | 71 |
2399390 | 2399390 | 2022-04-12 | Owen | Indiana | 18119 | 5837 | 120 |
2396135 | 2396135 | 2022-04-11 | Owen | Indiana | 18119 | 5837 | 120 |
2384191 | 2384191 | 2022-04-07 | San Miguel | New Mexico | 35047 | 5837 | 55 |
2265994 | 2265994 | 2022-03-02 | LaGrange | Indiana | 18087 | 5837 | 102 |
2259236 | 2259236 | 2022-02-28 | Monroe | Georgia | 13207 | 5837 | 165 |
2261225 | 2261225 | 2022-02-28 | Davison | South Dakota | 46035 | 5837 | 78 |
2212977 | 2212977 | 2022-02-13 | Lee | Virginia | 51105 | 5837 | 76 |
2209724 | 2209724 | 2022-02-12 | Lee | Virginia | 51105 | 5837 | 76 |
2206471 | 2206471 | 2022-02-11 | Lee | Virginia | 51105 | 5837 | 76 |
2198035 | 2198035 | 2022-02-09 | Lincoln | Kentucky | 21137 | 5837 | 118 |
2152752 | 2152752 | 2022-01-26 | Brown | Minnesota | 27015 | 5837 | 69 |
2114717 | 2114717 | 2022-01-14 | Aguadilla | Puerto Rico | 72005 | 5837 | |
2109067 | 2109067 | 2022-01-12 | Lincoln | Wisconsin | 55069 | 5837 | 125 |
2099167 | 2099167 | 2022-01-09 | Smyth | Virginia | 51173 | 5837 | 140 |
2095916 | 2095916 | 2022-01-08 | Smyth | Virginia | 51173 | 5837 | 140 |
2092664 | 2092664 | 2022-01-07 | Smyth | Virginia | 51173 | 5837 | 140 |
2014786 | 2014786 | 2021-12-14 | Green | Wisconsin | 55045 | 5837 | 39 |
1981175 | 1981175 | 2021-12-04 | Champaign | Ohio | 39021 | 5837 | 87 |
1967055 | 1967055 | 2021-11-30 | Lyon | Kansas | 20111 | 5837 | 96 |
1963803 | 1963803 | 2021-11-29 | Lyon | Kansas | 20111 | 5837 | 96 |
1937634 | 1937634 | 2021-11-21 | Wabash | Indiana | 18169 | 5837 | 107 |
1939161 | 1939161 | 2021-11-21 | Pike | Pennsylvania | 42103 | 5837 | 69 |
1934384 | 1934384 | 2021-11-20 | Wabash | Indiana | 18169 | 5837 | 107 |
1931133 | 1931133 | 2021-11-19 | Wabash | Indiana | 18169 | 5837 | 107 |
1926582 | 1926582 | 2021-11-17 | Howard | Texas | 48227 | 5837 | 139 |
1859558 | 1859558 | 2021-10-28 | Woodford | Illinois | 17203 | 5837 | 105 |
1844682 | 1844682 | 2021-10-23 | Clinton | Ohio | 39027 | 5837 | 93 |
1837894 | 1837894 | 2021-10-21 | Grafton | New Hampshire | 33009 | 5837 | 30 |
1665901 | 1665901 | 2021-08-29 | Richmond | North Carolina | 37153 | 5837 | 114 |
1662653 | 1662653 | 2021-08-28 | Richmond | North Carolina | 37153 | 5837 | 114 |
1659405 | 1659405 | 2021-08-27 | Richmond | North Carolina | 37153 | 5837 | 114 |
1636229 | 1636229 | 2021-08-20 | Johnson | Missouri | 29101 | 5837 | 62 |
1585111 | 1585111 | 2021-08-04 | Unknown | Puerto Rico | 5837 | 2589 | |
1515837 | 1515837 | 2021-07-14 | Benton | Minnesota | 27009 | 5837 | 98 |
1512591 | 1512591 | 2021-07-13 | Benton | Minnesota | 27009 | 5837 | 98 |
1437492 | 1437492 | 2021-06-20 | Warren | Iowa | 19181 | 5837 | 91 |
1427754 | 1427754 | 2021-06-17 | Warren | Iowa | 19181 | 5837 | 91 |
1424509 | 1424509 | 2021-06-16 | Warren | Iowa | 19181 | 5837 | 91 |
1418016 | 1418016 | 2021-06-14 | Warren | Iowa | 19181 | 5837 | 91 |
1348838 | 1348838 | 2021-05-23 | Harrison | West Virginia | 54033 | 5837 | 77 |
1345590 | 1345590 | 2021-05-22 | Harrison | West Virginia | 54033 | 5837 | 77 |
1342342 | 1342342 | 2021-05-21 | Harrison | West Virginia | 54033 | 5837 | 77 |
1294407 | 1294407 | 2021-05-07 | Grundy | Illinois | 17063 | 5837 | 78 |
1293117 | 1293117 | 2021-05-06 | Monroe | Tennessee | 47123 | 5837 | 95 |
1289349 | 1289349 | 2021-05-05 | Belmont | Ohio | 39013 | 5837 | 167 |
1284194 | 1284194 | 2021-05-04 | Mississippi | Arkansas | 5093 | 5837 | 107 |
1271824 | 1271824 | 2021-04-30 | Shelby | Indiana | 18145 | 5837 | 106 |
1266363 | 1266363 | 2021-04-28 | Salem | New Jersey | 34033 | 5837 | 176 |
1266513 | 1266513 | 2021-04-28 | Lenoir | North Carolina | 37107 | 5837 | 112 |
1247650 | 1247650 | 2021-04-22 | Lawrence | Tennessee | 47099 | 5837 | 86 |
1218021 | 1218021 | 2021-04-13 | Grady | Oklahoma | 40051 | 5837 | 119 |
1214773 | 1214773 | 2021-04-12 | Grady | Oklahoma | 40051 | 5837 | 119 |
1211526 | 1211526 | 2021-04-11 | Grady | Oklahoma | 40051 | 5837 | 119 |
1208277 | 1208277 | 2021-04-10 | Grady | Oklahoma | 40051 | 5837 | 119 |
1205029 | 1205029 | 2021-04-09 | Grady | Oklahoma | 40051 | 5837 | 119 |
1201781 | 1201781 | 2021-04-08 | Grady | Oklahoma | 40051 | 5837 | 119 |
1198532 | 1198532 | 2021-04-07 | Grady | Oklahoma | 40051 | 5837 | 119 |
1176844 | 1176844 | 2021-03-31 | Waupaca | Wisconsin | 55135 | 5837 | 161 |
1144524 | 1144524 | 2021-03-22 | Crittenden | Arkansas | 5035 | 5837 | 95 |
1141277 | 1141277 | 2021-03-21 | Crittenden | Arkansas | 5035 | 5837 | 95 |
1052022 | 1052022 | 2021-02-21 | Carson City | Nevada | 32510 | 5837 | 114 |
1049145 | 1049145 | 2021-02-20 | Scioto | Ohio | 39145 | 5837 | 102 |
1042402 | 1042402 | 2021-02-18 | Oswego | New York | 36075 | 5837 | 89 |
943189 | 943189 | 2021-01-19 | Jackson | Alabama | 1071 | 5837 | 41 |
902168 | 902168 | 2021-01-06 | York | Maine | 23031 | 5837 | 68 |
878010 | 878010 | 2020-12-29 | Newport News city | Virginia | 51700 | 5837 | 68 |
872091 | 872091 | 2020-12-28 | Columbia | Florida | 12023 | 5837 | 117 |
836620 | 836620 | 2020-12-17 | Bannock | Idaho | 16005 | 5837 | 51 |
785256 | 785256 | 2020-12-01 | Ascension | Louisiana | 22005 | 5837 | 108 |
786131 | 786131 | 2020-12-01 | Wayne | North Carolina | 37191 | 5837 | 113 |
762938 | 762938 | 2020-11-24 | Cole | Missouri | 29051 | 5837 | 49 |
646601 | 646601 | 2020-10-19 | Pitt | North Carolina | 37147 | 5837 | 35 |
205860 | 205860 | 2020-06-03 | Prince William | Virginia | 51153 | 5837 | 109 |
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);