ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 6332 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 14
- Georgia 7
- Minnesota 6
- Louisiana 5
- Michigan 5
- North Carolina 5
- Illinois 3
- Puerto Rico 3
- Tennessee 3
- Kansas 2
- New York 2
- South Carolina 2
- Alabama 1
- Arkansas 1
- California 1
- Colorado 1
- Indiana 1
- Maryland 1
- Mississippi 1
- New Mexico 1
- Ohio 1
- Oregon 1
- South Dakota 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430306 | 2430306 | 2022-04-21 | Juncos | Puerto Rico | 72077 | 6332 | |
2425838 | 2425838 | 2022-04-20 | Sabine | Louisiana | 22085 | 6332 | 111 |
2422582 | 2422582 | 2022-04-19 | Sabine | Louisiana | 22085 | 6332 | 110 |
2333849 | 2333849 | 2022-03-23 | Routt | Colorado | 8107 | 6332 | 24 |
2198300 | 2198300 | 2022-02-09 | Brown | Minnesota | 27015 | 6332 | 72 |
2156595 | 2156595 | 2022-01-27 | Cherokee | North Carolina | 37039 | 6332 | 91 |
2142186 | 2142186 | 2022-01-23 | Toombs | Georgia | 13279 | 6332 | 177 |
2142285 | 2142285 | 2022-01-23 | Fayette | Illinois | 17051 | 6332 | 89 |
2138931 | 2138931 | 2022-01-22 | Toombs | Georgia | 13279 | 6332 | 177 |
2139030 | 2139030 | 2022-01-22 | Fayette | Illinois | 17051 | 6332 | 89 |
2135675 | 2135675 | 2022-01-21 | Toombs | Georgia | 13279 | 6332 | 177 |
2135774 | 2135774 | 2022-01-21 | Fayette | Illinois | 17051 | 6332 | 89 |
2131008 | 2131008 | 2022-01-19 | Gurabo | Puerto Rico | 72063 | 6332 | |
2115510 | 2115510 | 2022-01-14 | Mineral | West Virginia | 54057 | 6332 | 139 |
2102540 | 2102540 | 2022-01-10 | Clark | Wisconsin | 55019 | 6332 | 109 |
2055249 | 2055249 | 2021-12-27 | Polk | Minnesota | 27119 | 6332 | 91 |
2010589 | 2010589 | 2021-12-13 | Benton | Oregon | 41003 | 6332 | 41 |
1991046 | 1991046 | 2021-12-07 | Logan | Oklahoma | 40083 | 6332 | 121 |
1987795 | 1987795 | 2021-12-06 | Logan | Oklahoma | 40083 | 6332 | 121 |
1984545 | 1984545 | 2021-12-05 | Logan | Oklahoma | 40083 | 6332 | 121 |
1981295 | 1981295 | 2021-12-04 | Logan | Oklahoma | 40083 | 6332 | 121 |
1978045 | 1978045 | 2021-12-03 | Logan | Oklahoma | 40083 | 6332 | 121 |
1973517 | 1973517 | 2021-12-02 | Cowley | Kansas | 20035 | 6332 | 128 |
1974795 | 1974795 | 2021-12-02 | Logan | Oklahoma | 40083 | 6332 | 115 |
1970267 | 1970267 | 2021-12-01 | Cowley | Kansas | 20035 | 6332 | 128 |
1971546 | 1971546 | 2021-12-01 | Logan | Oklahoma | 40083 | 6332 | 115 |
1963622 | 1963622 | 2021-11-29 | Putnam | Indiana | 18133 | 6332 | 85 |
1927498 | 1927498 | 2021-11-18 | Bryan | Georgia | 13029 | 6332 | 72 |
1920709 | 1920709 | 2021-11-16 | Boone | Arkansas | 5009 | 6332 | 130 |
1920999 | 1920999 | 2021-11-16 | Bryan | Georgia | 13029 | 6332 | 72 |
1905515 | 1905515 | 2021-11-11 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1902265 | 1902265 | 2021-11-10 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1899015 | 1899015 | 2021-11-09 | St. John the Baptist | Louisiana | 22095 | 6332 | 171 |
1857026 | 1857026 | 2021-10-27 | Bolivar | Mississippi | 28011 | 6332 | 150 |
1828789 | 1828789 | 2021-10-18 | Chester | South Carolina | 45023 | 6332 | 109 |
1824443 | 1824443 | 2021-10-17 | Beltrami | Minnesota | 27007 | 6332 | 76 |
1821194 | 1821194 | 2021-10-16 | Beltrami | Minnesota | 27007 | 6332 | 76 |
1817945 | 1817945 | 2021-10-15 | Beltrami | Minnesota | 27007 | 6332 | 76 |
1740844 | 1740844 | 2021-09-21 | Osage | Oklahoma | 40113 | 6332 | 106 |
1737595 | 1737595 | 2021-09-20 | Osage | Oklahoma | 40113 | 6332 | 106 |
1734345 | 1734345 | 2021-09-19 | Osage | Oklahoma | 40113 | 6332 | 106 |
1731095 | 1731095 | 2021-09-18 | Osage | Oklahoma | 40113 | 6332 | 106 |
1727845 | 1727845 | 2021-09-17 | Osage | Oklahoma | 40113 | 6332 | 106 |
1724596 | 1724596 | 2021-09-16 | Osage | Oklahoma | 40113 | 6332 | 106 |
1721347 | 1721347 | 2021-09-15 | Osage | Oklahoma | 40113 | 6332 | 106 |
1672777 | 1672777 | 2021-08-31 | Guaynabo | Puerto Rico | 72061 | 6332 | |
1665883 | 1665883 | 2021-08-29 | McDowell | North Carolina | 37111 | 6332 | 66 |
1662635 | 1662635 | 2021-08-28 | McDowell | North Carolina | 37111 | 6332 | 66 |
1659387 | 1659387 | 2021-08-27 | McDowell | North Carolina | 37111 | 6332 | 66 |
1584046 | 1584046 | 2021-08-04 | Chisago | Minnesota | 27025 | 6332 | 55 |
1447551 | 1447551 | 2021-06-23 | Cecil | Maryland | 24015 | 6332 | 152 |
1437884 | 1437884 | 2021-06-20 | Isabella | Michigan | 26073 | 6332 | 99 |
1434637 | 1434637 | 2021-06-19 | Isabella | Michigan | 26073 | 6332 | 99 |
1431390 | 1431390 | 2021-06-18 | Isabella | Michigan | 26073 | 6332 | 99 |
1428145 | 1428145 | 2021-06-17 | Isabella | Michigan | 26073 | 6332 | 99 |
1402751 | 1402751 | 2021-06-09 | Cayuga | New York | 36011 | 6332 | 92 |
1397476 | 1397476 | 2021-06-07 | Cowlitz | Washington | 53015 | 6332 | 93 |
1335997 | 1335997 | 2021-05-20 | Colbert | Alabama | 1033 | 6332 | 135 |
1258474 | 1258474 | 2021-04-26 | Catoosa | Georgia | 13047 | 6332 | 69 |
1259956 | 1259956 | 2021-04-26 | Sullivan | New York | 36105 | 6332 | 71 |
1253700 | 1253700 | 2021-04-24 | Scioto | Ohio | 39145 | 6332 | 101 |
1211888 | 1211888 | 2021-04-11 | Carter | Tennessee | 47019 | 6332 | 156 |
1208639 | 1208639 | 2021-04-10 | Carter | Tennessee | 47019 | 6332 | 156 |
1205391 | 1205391 | 2021-04-09 | Carter | Tennessee | 47019 | 6332 | 156 |
1045611 | 1045611 | 2021-02-19 | Valencia | New Mexico | 35061 | 6332 | 91 |
972136 | 972136 | 2021-01-27 | Portsmouth city | Virginia | 51740 | 6332 | 96 |
956582 | 956582 | 2021-01-23 | Fayette | Georgia | 13113 | 6332 | 104 |
841806 | 841806 | 2020-12-18 | Lincoln | South Dakota | 46083 | 6332 | 58 |
769160 | 769160 | 2020-11-26 | Berrien | Michigan | 26021 | 6332 | 113 |
705427 | 705427 | 2020-11-06 | Anderson | South Carolina | 45007 | 6332 | 208 |
692015 | 692015 | 2020-11-02 | Pitt | North Carolina | 37147 | 6332 | 41 |
334875 | 334875 | 2020-07-15 | Tulare | California | 6107 | 6332 | 153 |
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);