ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 5340 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 9
- Tennessee 6
- Georgia 5
- Michigan 5
- Idaho 4
- Pennsylvania 4
- New York 3
- Ohio 3
- Alabama 2
- Arkansas 2
- Connecticut 2
- Illinois 2
- Kentucky 2
- Nebraska 2
- North Carolina 2
- North Dakota 2
- Oklahoma 2
- West Virginia 2
- Colorado 1
- Florida 1
- Hawaii 1
- Indiana 1
- Maine 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- New Mexico 1
- South Carolina 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473382 | 2473382 | 2022-05-04 | Lewis | West Virginia | 54041 | 5340 | 86 |
2445404 | 2445404 | 2022-04-26 | Lincoln | Maine | 23015 | 5340 | 35 |
2426520 | 2426520 | 2022-04-20 | Taos | New Mexico | 35055 | 5340 | 90 |
2301145 | 2301145 | 2022-03-13 | Columbia | Arkansas | 5027 | 5340 | 90 |
2297893 | 2297893 | 2022-03-12 | Columbia | Arkansas | 5027 | 5340 | 90 |
2291957 | 2291957 | 2022-03-10 | Union | Illinois | 17181 | 5340 | 67 |
2256077 | 2256077 | 2022-02-27 | Jerome | Idaho | 16053 | 5340 | 63 |
2252826 | 2252826 | 2022-02-26 | Jerome | Idaho | 16053 | 5340 | 63 |
2249575 | 2249575 | 2022-02-25 | Jerome | Idaho | 16053 | 5340 | 63 |
2246304 | 2246304 | 2022-02-24 | Blaine | Idaho | 16013 | 5340 | 30 |
2225737 | 2225737 | 2022-02-17 | Karnes | Texas | 48255 | 5340 | 64 |
2217888 | 2217888 | 2022-02-15 | Wabasha | Minnesota | 27157 | 5340 | 16 |
2199674 | 2199674 | 2022-02-09 | Frio | Texas | 48163 | 5340 | 84 |
2195864 | 2195864 | 2022-02-08 | Wyandot | Ohio | 39175 | 5340 | 98 |
2169155 | 2169155 | 2022-01-31 | Newton | Mississippi | 28101 | 5340 | 89 |
2098177 | 2098177 | 2022-01-09 | Stutsman | North Dakota | 38093 | 5340 | 92 |
2000932 | 2000932 | 2021-12-10 | Warren | Pennsylvania | 42123 | 5340 | 165 |
1989924 | 1989924 | 2021-12-07 | Logan | Kentucky | 21141 | 5340 | 93 |
1991965 | 1991965 | 2021-12-07 | Greenbrier | West Virginia | 54025 | 5340 | 110 |
1962238 | 1962238 | 2021-11-28 | Bee | Texas | 48025 | 5340 | 133 |
1958987 | 1958987 | 2021-11-27 | Bee | Texas | 48025 | 5340 | 133 |
1955736 | 1955736 | 2021-11-26 | Bee | Texas | 48025 | 5340 | 133 |
1952485 | 1952485 | 2021-11-25 | Bee | Texas | 48025 | 5340 | 133 |
1949234 | 1949234 | 2021-11-24 | Bee | Texas | 48025 | 5340 | 133 |
1936232 | 1936232 | 2021-11-20 | Bee | Texas | 48025 | 5340 | 132 |
1922451 | 1922451 | 2021-11-16 | Columbia | New York | 36021 | 5340 | 113 |
1886430 | 1886430 | 2021-11-05 | Pulaski | Missouri | 29169 | 5340 | 79 |
1876840 | 1876840 | 2021-11-02 | Platte | Nebraska | 31141 | 5340 | 56 |
1873591 | 1873591 | 2021-11-01 | Platte | Nebraska | 31141 | 5340 | 56 |
1853368 | 1853368 | 2021-10-26 | Boyle | Kentucky | 21021 | 5340 | 79 |
1848173 | 1848173 | 2021-10-24 | Pike | Pennsylvania | 42103 | 5340 | 61 |
1765129 | 1765129 | 2021-09-29 | Pickens | Georgia | 13227 | 5340 | 103 |
1719830 | 1719830 | 2021-09-15 | Stephenson | Illinois | 17177 | 5340 | 107 |
1643725 | 1643725 | 2021-08-22 | Cocke | Tennessee | 47029 | 5340 | 102 |
1640475 | 1640475 | 2021-08-21 | Cocke | Tennessee | 47029 | 5340 | 102 |
1637225 | 1637225 | 2021-08-20 | Cocke | Tennessee | 47029 | 5340 | 102 |
1608952 | 1608952 | 2021-08-12 | Broomfield | Colorado | 8014 | 5340 | 77 |
1469021 | 1469021 | 2021-06-29 | Shawano | Wisconsin | 55115 | 5340 | 85 |
1422407 | 1422407 | 2021-06-15 | Morton | North Dakota | 38059 | 5340 | 101 |
1372117 | 1372117 | 2021-05-31 | Coffee | Georgia | 13069 | 5340 | 172 |
1368872 | 1368872 | 2021-05-30 | Coffee | Georgia | 13069 | 5340 | 172 |
1365626 | 1365626 | 2021-05-29 | Coffee | Georgia | 13069 | 5340 | 172 |
1324249 | 1324249 | 2021-05-16 | Cass | Michigan | 26027 | 5340 | 76 |
1321003 | 1321003 | 2021-05-15 | Cass | Michigan | 26027 | 5340 | 76 |
1318365 | 1318365 | 2021-05-14 | Genesee | New York | 36037 | 5340 | 123 |
1303898 | 1303898 | 2021-05-10 | Suwannee | Florida | 12121 | 5340 | 139 |
1211901 | 1211901 | 2021-04-11 | Dyer | Tennessee | 47045 | 5340 | 104 |
1208652 | 1208652 | 2021-04-10 | Dyer | Tennessee | 47045 | 5340 | 104 |
1205404 | 1205404 | 2021-04-09 | Dyer | Tennessee | 47045 | 5340 | 104 |
1172443 | 1172443 | 2021-03-30 | Belmont | Ohio | 39013 | 5340 | 158 |
1172671 | 1172671 | 2021-03-30 | Indiana | Pennsylvania | 42063 | 5340 | 161 |
1148967 | 1148967 | 2021-03-23 | Van Buren | Michigan | 26159 | 5340 | 98 |
1134673 | 1134673 | 2021-03-19 | Coffee | Alabama | 1031 | 5340 | 107 |
1131425 | 1131425 | 2021-03-18 | Coffee | Alabama | 1031 | 5340 | 105 |
1052217 | 1052217 | 2021-02-21 | Lenoir | North Carolina | 37107 | 5340 | 104 |
1039434 | 1039434 | 2021-02-17 | Cherokee | Oklahoma | 40021 | 5340 | 39 |
990746 | 990746 | 2021-02-02 | Bryan | Oklahoma | 40013 | 5340 | 45 |
920212 | 920212 | 2021-01-11 | Portsmouth city | Virginia | 51740 | 5340 | 87 |
891546 | 891546 | 2021-01-03 | Windham | Connecticut | 9015 | 5340 | 83 |
888299 | 888299 | 2021-01-02 | Windham | Connecticut | 9015 | 5340 | 83 |
890434 | 890434 | 2021-01-02 | Oconee | South Carolina | 45073 | 5340 | 62 |
847119 | 847119 | 2020-12-20 | Unknown | Michigan | 5340 | 24 | |
843873 | 843873 | 2020-12-19 | Unknown | Michigan | 5340 | 24 | |
838135 | 838135 | 2020-12-17 | Columbiana | Ohio | 39029 | 5340 | 113 |
646482 | 646482 | 2020-10-19 | Dutchess | New York | 36027 | 5340 | 163 |
627130 | 627130 | 2020-10-13 | Robeson | North Carolina | 37155 | 5340 | 85 |
491639 | 491639 | 2020-09-01 | Minnehaha | South Dakota | 46099 | 5340 | 70 |
475688 | 475688 | 2020-08-27 | Hays | Texas | 48209 | 5340 | 55 |
466911 | 466911 | 2020-08-25 | Bibb | Georgia | 13021 | 5340 | 106 |
450922 | 450922 | 2020-08-20 | Honolulu | Hawaii | 15003 | 5340 | 37 |
423132 | 423132 | 2020-08-11 | Somerset | New Jersey | 34035 | 5340 | 562 |
226771 | 226771 | 2020-06-10 | Bucks | Pennsylvania | 42017 | 5340 | 534 |
199577 | 199577 | 2020-06-01 | Salt Lake | Utah | 49035 | 5340 | 74 |
98869 | 98869 | 2020-04-29 | Marion | Indiana | 18097 | 5340 | 329 |
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);