ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 5488 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 7
- Iowa 7
- Kentucky 5
- Ohio 5
- Illinois 4
- Minnesota 4
- Puerto Rico 4
- North Carolina 3
- Texas 3
- Alabama 2
- California 2
- Michigan 2
- Mississippi 2
- New York 2
- West Virginia 2
- Wyoming 2
- Arkansas 1
- Delaware 1
- Florida 1
- Indiana 1
- Louisiana 1
- Missouri 1
- Montana 1
- Nebraska 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451372 | 2451372 | 2022-04-28 | Lawrence | Illinois | 17101 | 5488 | 52 |
2440068 | 2440068 | 2022-04-24 | Hatillo | Puerto Rico | 72065 | 5488 | |
2399432 | 2399432 | 2022-04-12 | Bremer | Iowa | 19017 | 5488 | 82 |
2396176 | 2396176 | 2022-04-11 | Bremer | Iowa | 19017 | 5488 | 82 |
2392921 | 2392921 | 2022-04-10 | Bremer | Iowa | 19017 | 5488 | 82 |
2389665 | 2389665 | 2022-04-09 | Bremer | Iowa | 19017 | 5488 | 82 |
2386409 | 2386409 | 2022-04-08 | Bremer | Iowa | 19017 | 5488 | 82 |
2383155 | 2383155 | 2022-04-07 | Bremer | Iowa | 19017 | 5488 | 82 |
2379900 | 2379900 | 2022-04-06 | Bremer | Iowa | 19017 | 5488 | 82 |
2339160 | 2339160 | 2022-03-24 | Cidra | Puerto Rico | 72041 | 5488 | |
2307395 | 2307395 | 2022-03-14 | Lincoln | West Virginia | 54043 | 5488 | 74 |
2280120 | 2280120 | 2022-03-06 | Essex | New York | 36031 | 5488 | 57 |
2269906 | 2269906 | 2022-03-03 | Wabasha | Minnesota | 27157 | 5488 | 16 |
2263432 | 2263432 | 2022-03-01 | Grenada | Mississippi | 28043 | 5488 | 126 |
2260181 | 2260181 | 2022-02-28 | Grenada | Mississippi | 28043 | 5488 | 126 |
2242258 | 2242258 | 2022-02-22 | Page | Virginia | 51139 | 5488 | 111 |
2233239 | 2233239 | 2022-02-20 | Pierce | Georgia | 13229 | 5488 | 119 |
2229988 | 2229988 | 2022-02-19 | Pierce | Georgia | 13229 | 5488 | 119 |
2226737 | 2226737 | 2022-02-18 | Pierce | Georgia | 13229 | 5488 | 119 |
2132017 | 2132017 | 2022-01-20 | Cleburne | Arkansas | 5023 | 5488 | 105 |
2040909 | 2040909 | 2021-12-23 | Marion | Alabama | 1093 | 5488 | 132 |
2034359 | 2034359 | 2021-12-20 | Teton | Wyoming | 56039 | 5488 | 14 |
1968840 | 1968840 | 2021-11-30 | Hopkins | Texas | 48223 | 5488 | 146 |
1951198 | 1951198 | 2021-11-25 | Freeborn | Minnesota | 27047 | 5488 | 45 |
1947947 | 1947947 | 2021-11-24 | Freeborn | Minnesota | 27047 | 5488 | 45 |
1927621 | 1927621 | 2021-11-18 | Toombs | Georgia | 13279 | 5488 | 173 |
1929328 | 1929328 | 2021-11-18 | Coos | Oregon | 41011 | 5488 | 104 |
1917872 | 1917872 | 2021-11-15 | Toombs | Georgia | 13279 | 5488 | 172 |
1919193 | 1919193 | 2021-11-15 | Allegany | New York | 36003 | 5488 | 111 |
1745825 | 1745825 | 2021-09-23 | Stephenson | Illinois | 17177 | 5488 | 108 |
1746884 | 1746884 | 2021-09-23 | Scotts Bluff | Nebraska | 31157 | 5488 | 96 |
1733184 | 1733184 | 2021-09-19 | Greenup | Kentucky | 21089 | 5488 | 68 |
1729934 | 1729934 | 2021-09-18 | Greenup | Kentucky | 21089 | 5488 | 68 |
1726684 | 1726684 | 2021-09-17 | Greenup | Kentucky | 21089 | 5488 | 68 |
1723093 | 1723093 | 2021-09-16 | Woodford | Illinois | 17203 | 5488 | 104 |
1722366 | 1722366 | 2021-09-15 | Albany | Wyoming | 56001 | 5488 | 25 |
1702436 | 1702436 | 2021-09-09 | Matagorda | Texas | 48321 | 5488 | 127 |
1696018 | 1696018 | 2021-09-07 | Waller | Texas | 48473 | 5488 | 58 |
1659003 | 1659003 | 2021-08-27 | Phelps | Missouri | 29161 | 5488 | 163 |
1558854 | 1558854 | 2021-07-27 | Sandusky | Ohio | 39143 | 5488 | 130 |
1514931 | 1514931 | 2021-07-14 | Coffee | Georgia | 13069 | 5488 | 180 |
1492888 | 1492888 | 2021-07-07 | Scott | Kentucky | 21209 | 5488 | 36 |
1354315 | 1354315 | 2021-05-25 | Huron | Ohio | 39077 | 5488 | 120 |
1350136 | 1350136 | 2021-05-24 | St. Charles | Louisiana | 22089 | 5488 | 97 |
1347699 | 1347699 | 2021-05-23 | Pender | North Carolina | 37141 | 5488 | 69 |
1344451 | 1344451 | 2021-05-22 | Pender | North Carolina | 37141 | 5488 | 69 |
1341203 | 1341203 | 2021-05-21 | Pender | North Carolina | 37141 | 5488 | 69 |
1291782 | 1291782 | 2021-05-06 | Branch | Michigan | 26023 | 5488 | 119 |
1256918 | 1256918 | 2021-04-25 | Lawrence | Ohio | 39087 | 5488 | 102 |
1253671 | 1253671 | 2021-04-24 | Lawrence | Ohio | 39087 | 5488 | 102 |
1254681 | 1254681 | 2021-04-24 | Harrison | West Virginia | 54033 | 5488 | 85 |
1201673 | 1201673 | 2021-04-08 | Belmont | Ohio | 39013 | 5488 | 158 |
1196833 | 1196833 | 2021-04-07 | Laurens | Georgia | 13175 | 5488 | 165 |
1193035 | 1193035 | 2021-04-05 | Grant | Wisconsin | 55043 | 5488 | 89 |
1105779 | 1105779 | 2021-03-10 | Gadsden | Florida | 12039 | 5488 | 88 |
1036601 | 1036601 | 2021-02-16 | Jefferson | Tennessee | 47089 | 5488 | 112 |
1026634 | 1026634 | 2021-02-13 | Caguas | Puerto Rico | 72025 | 5488 | |
1019976 | 1019976 | 2021-02-11 | Grady | Oklahoma | 40051 | 5488 | 66 |
1015622 | 1015622 | 2021-02-10 | Laurel | Kentucky | 21125 | 5488 | 22 |
998550 | 998550 | 2021-02-05 | San Benito | California | 6069 | 5488 | 55 |
944418 | 944418 | 2021-01-19 | Eaton | Michigan | 26045 | 5488 | 118 |
921797 | 921797 | 2021-01-12 | Kandiyohi | Minnesota | 27067 | 5488 | 69 |
800977 | 800977 | 2020-12-06 | DeKalb | Illinois | 17037 | 5488 | 51 |
746814 | 746814 | 2020-11-19 | Flathead | Montana | 30029 | 5488 | 27 |
718323 | 718323 | 2020-11-10 | Bayamon | Puerto Rico | 72021 | 5488 | |
527992 | 527992 | 2020-09-13 | Lee | Alabama | 1081 | 5488 | 59 |
512548 | 512548 | 2020-09-08 | St. Joseph | Indiana | 18141 | 5488 | 101 |
384995 | 384995 | 2020-07-30 | Lancaster | Pennsylvania | 42071 | 5488 | 406 |
366969 | 366969 | 2020-07-25 | Sussex | Delaware | 10005 | 5488 | 190 |
325290 | 325290 | 2020-07-12 | Sacramento | California | 6067 | 5488 | 83 |
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);