ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 6083 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Oklahoma 8
- Iowa 7
- North Carolina 7
- Texas 7
- Georgia 6
- Kentucky 6
- Missouri 6
- Minnesota 5
- Colorado 4
- Ohio 4
- Pennsylvania 3
- Tennessee 3
- Wyoming 3
- California 2
- Florida 2
- Indiana 2
- Maryland 2
- New York 2
- Puerto Rico 2
- Virginia 2
- Arkansas 1
- Illinois 1
- Louisiana 1
- Mississippi 1
- Nebraska 1
- Oregon 1
- South Carolina 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467461 | 2467461 | 2022-05-03 | Harris | Georgia | 13145 | 6083 | 112 |
2468967 | 2468967 | 2022-05-03 | Martin | North Carolina | 37117 | 6083 | 89 |
2464206 | 2464206 | 2022-05-02 | Harris | Georgia | 13145 | 6083 | 112 |
2465711 | 2465711 | 2022-05-02 | Martin | North Carolina | 37117 | 6083 | 89 |
2462456 | 2462456 | 2022-05-01 | Martin | North Carolina | 37117 | 6083 | 89 |
2459200 | 2459200 | 2022-04-30 | Martin | North Carolina | 37117 | 6083 | 89 |
2455944 | 2455944 | 2022-04-29 | Martin | North Carolina | 37117 | 6083 | 89 |
2452688 | 2452688 | 2022-04-28 | Martin | North Carolina | 37117 | 6083 | 89 |
2449432 | 2449432 | 2022-04-27 | Martin | North Carolina | 37117 | 6083 | 89 |
2384726 | 2384726 | 2022-04-07 | Juncos | Puerto Rico | 72077 | 6083 | |
2325395 | 2325395 | 2022-03-20 | Stoddard | Missouri | 29207 | 6083 | 127 |
2322141 | 2322141 | 2022-03-19 | Stoddard | Missouri | 29207 | 6083 | 127 |
2322875 | 2322875 | 2022-03-19 | Aguada | Puerto Rico | 72003 | 6083 | |
2318887 | 2318887 | 2022-03-18 | Stoddard | Missouri | 29207 | 6083 | 127 |
2223282 | 2223282 | 2022-02-17 | Routt | Colorado | 8107 | 6083 | 24 |
2179118 | 2179118 | 2022-02-03 | Adams | Nebraska | 31001 | 6083 | 69 |
2168810 | 2168810 | 2022-01-31 | Woodford | Kentucky | 21239 | 6083 | 40 |
2157702 | 2157702 | 2022-01-27 | Pulaski | Virginia | 51155 | 6083 | 111 |
2123159 | 2123159 | 2022-01-17 | Carter | Kentucky | 21043 | 6083 | 86 |
2119907 | 2119907 | 2022-01-16 | Carter | Kentucky | 21043 | 6083 | 86 |
2116655 | 2116655 | 2022-01-15 | Carter | Kentucky | 21043 | 6083 | 86 |
2113404 | 2113404 | 2022-01-14 | Carter | Kentucky | 21043 | 6083 | 86 |
2098843 | 2098843 | 2022-01-09 | Grimes | Texas | 48185 | 6083 | 110 |
2058583 | 2058583 | 2021-12-28 | Pike | Mississippi | 28113 | 6083 | 158 |
2004994 | 2004994 | 2021-12-11 | Preston | West Virginia | 54077 | 6083 | 108 |
1998785 | 1998785 | 2021-12-10 | Union | Arkansas | 5139 | 6083 | 144 |
1965083 | 1965083 | 2021-11-29 | Benton | Oregon | 41003 | 6083 | 38 |
1941424 | 1941424 | 2021-11-22 | Becker | Minnesota | 27005 | 6083 | 71 |
1899428 | 1899428 | 2021-11-09 | Platte | Missouri | 29165 | 6083 | 62 |
1826338 | 1826338 | 2021-10-17 | Albany | Wyoming | 56001 | 6083 | 31 |
1823089 | 1823089 | 2021-10-16 | Albany | Wyoming | 56001 | 6083 | 31 |
1819840 | 1819840 | 2021-10-15 | Albany | Wyoming | 56001 | 6083 | 31 |
1784984 | 1784984 | 2021-10-05 | Marshall | Iowa | 19127 | 6083 | 82 |
1781735 | 1781735 | 2021-10-04 | Marshall | Iowa | 19127 | 6083 | 82 |
1778485 | 1778485 | 2021-10-03 | Marshall | Iowa | 19127 | 6083 | 82 |
1775235 | 1775235 | 2021-10-02 | Marshall | Iowa | 19127 | 6083 | 82 |
1771985 | 1771985 | 2021-10-01 | Marshall | Iowa | 19127 | 6083 | 82 |
1768736 | 1768736 | 2021-09-30 | Marshall | Iowa | 19127 | 6083 | 82 |
1765487 | 1765487 | 2021-09-29 | Marshall | Iowa | 19127 | 6083 | 82 |
1753145 | 1753145 | 2021-09-25 | Camden | Missouri | 29029 | 6083 | 120 |
1718027 | 1718027 | 2021-09-14 | Seneca | Ohio | 39147 | 6083 | 135 |
1672585 | 1672585 | 2021-08-31 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1673163 | 1673163 | 2021-08-31 | Jim Wells | Texas | 48249 | 6083 | 126 |
1669337 | 1669337 | 2021-08-30 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1665251 | 1665251 | 2021-08-29 | Benton | Minnesota | 27009 | 6083 | 98 |
1666090 | 1666090 | 2021-08-29 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1662003 | 1662003 | 2021-08-28 | Benton | Minnesota | 27009 | 6083 | 98 |
1662522 | 1662522 | 2021-08-28 | Cattaraugus | New York | 36009 | 6083 | 94 |
1662842 | 1662842 | 2021-08-28 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1658755 | 1658755 | 2021-08-27 | Benton | Minnesota | 27009 | 6083 | 98 |
1659594 | 1659594 | 2021-08-27 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1656345 | 1656345 | 2021-08-26 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1653098 | 1653098 | 2021-08-25 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1564388 | 1564388 | 2021-07-29 | St. Mary | Louisiana | 22101 | 6083 | 147 |
1541261 | 1541261 | 2021-07-22 | Shelby | Indiana | 18145 | 6083 | 108 |
1534703 | 1534703 | 2021-07-20 | Cass | Indiana | 18017 | 6083 | 113 |
1512482 | 1512482 | 2021-07-13 | St. Mary's | Maryland | 24037 | 6083 | 132 |
1509235 | 1509235 | 2021-07-12 | St. Mary's | Maryland | 24037 | 6083 | 132 |
1414104 | 1414104 | 2021-06-13 | San Benito | California | 6069 | 6083 | 63 |
1351709 | 1351709 | 2021-05-24 | Hunt | Texas | 48231 | 6083 | 172 |
1352036 | 1352036 | 2021-05-24 | Cowlitz | Washington | 53015 | 6083 | 91 |
1274563 | 1274563 | 2021-05-01 | Fremont | Colorado | 8043 | 6083 | 55 |
1260685 | 1260685 | 2021-04-26 | Anderson | Texas | 48001 | 6083 | 118 |
1257438 | 1257438 | 2021-04-25 | Anderson | Texas | 48001 | 6083 | 118 |
1254191 | 1254191 | 2021-04-24 | Anderson | Texas | 48001 | 6083 | 118 |
1216089 | 1216089 | 2021-04-13 | Yuba | California | 6115 | 6083 | 43 |
1193461 | 1193461 | 2021-04-06 | Jackson | Florida | 12063 | 6083 | 156 |
1181478 | 1181478 | 2021-04-02 | Kandiyohi | Minnesota | 27067 | 6083 | 79 |
1148723 | 1148723 | 2021-03-23 | McCracken | Kentucky | 21145 | 6083 | 112 |
1143686 | 1143686 | 2021-03-21 | Carter | Tennessee | 47019 | 6083 | 155 |
1140439 | 1140439 | 2021-03-20 | Carter | Tennessee | 47019 | 6083 | 155 |
1137193 | 1137193 | 2021-03-19 | Carter | Tennessee | 47019 | 6083 | 155 |
1117268 | 1117268 | 2021-03-13 | Hancock | Ohio | 39063 | 6083 | 121 |
1084803 | 1084803 | 2021-03-03 | Geauga | Ohio | 39055 | 6083 | 136 |
1062128 | 1062128 | 2021-02-24 | Ross | Ohio | 39141 | 6083 | 136 |
1015070 | 1015070 | 2021-02-10 | Rockdale | Georgia | 13247 | 6083 | 121 |
990444 | 990444 | 2021-02-02 | Chemung | New York | 36015 | 6083 | 118 |
963081 | 963081 | 2021-01-25 | Gordon | Georgia | 13129 | 6083 | 81 |
951963 | 951963 | 2021-01-21 | Somerset | Pennsylvania | 42111 | 6083 | 153 |
943599 | 943599 | 2021-01-19 | Fayette | Georgia | 13113 | 6083 | 93 |
922608 | 922608 | 2021-01-12 | Garfield | Oklahoma | 40047 | 6083 | 47 |
888479 | 888479 | 2021-01-02 | Newton | Georgia | 13217 | 6083 | 127 |
858244 | 858244 | 2020-12-23 | Grayson | Texas | 48181 | 6083 | 147 |
838376 | 838376 | 2020-12-17 | Schuylkill | Pennsylvania | 42107 | 6083 | 217 |
744950 | 744950 | 2020-11-18 | Norfolk city | Virginia | 51710 | 6083 | 87 |
692455 | 692455 | 2020-11-02 | Anderson | South Carolina | 45007 | 6083 | 209 |
687045 | 687045 | 2020-11-01 | Boulder | Colorado | 8013 | 6083 | 88 |
677396 | 677396 | 2020-10-29 | Clay | Florida | 12019 | 6083 | 127 |
615400 | 615400 | 2020-10-09 | Winnebago | Wisconsin | 55139 | 6083 | 40 |
599868 | 599868 | 2020-10-05 | Madison | Illinois | 17119 | 6083 | 147 |
513314 | 513314 | 2020-09-08 | Jackson | Missouri | 29095 | 6083 | 84 |
486172 | 486172 | 2020-08-31 | El Paso | Colorado | 8041 | 6083 | 153 |
327294 | 327294 | 2020-07-12 | Bucks | Pennsylvania | 42017 | 6083 | 572 |
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);