ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
205 rows where cases = 2766 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Georgia 26
- Michigan 13
- Illinois 11
- Kansas 10
- Kentucky 9
- Ohio 9
- Iowa 8
- Missouri 7
- Tennessee 7
- Arkansas 5
- Mississippi 5
- Pennsylvania 5
- Virginia 5
- California 4
- Louisiana 4
- South Carolina 4
- South Dakota 4
- Washington 4
- Florida 3
- Indiana 3
- Nevada 3
- North Carolina 3
- Oregon 3
- Utah 3
- Arizona 2
- Colorado 2
- Nebraska 2
- New Mexico 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483725 | 2483725 | 2022-05-08 | Early | Georgia | 13099 | 2766 | 62 |
2480467 | 2480467 | 2022-05-07 | Early | Georgia | 13099 | 2766 | 62 |
2477209 | 2477209 | 2022-05-06 | Early | Georgia | 13099 | 2766 | 62 |
2473951 | 2473951 | 2022-05-05 | Early | Georgia | 13099 | 2766 | 62 |
2470694 | 2470694 | 2022-05-04 | Early | Georgia | 13099 | 2766 | 62 |
2423250 | 2423250 | 2022-04-19 | Los Alamos | New Mexico | 35028 | 2766 | 16 |
2415564 | 2415564 | 2022-04-17 | Marshall | Illinois | 17123 | 2766 | 33 |
2412308 | 2412308 | 2022-04-16 | Marshall | Illinois | 17123 | 2766 | 33 |
2409052 | 2409052 | 2022-04-15 | Marshall | Illinois | 17123 | 2766 | 33 |
2402541 | 2402541 | 2022-04-13 | Marshall | Illinois | 17123 | 2766 | 33 |
2399286 | 2399286 | 2022-04-12 | Marshall | Illinois | 17123 | 2766 | 33 |
2396031 | 2396031 | 2022-04-11 | Marshall | Illinois | 17123 | 2766 | 33 |
2361934 | 2361934 | 2022-03-31 | Comerio | Puerto Rico | 72045 | 2766 | |
2327163 | 2327163 | 2022-03-21 | Chicot | Arkansas | 5017 | 2766 | 57 |
2308005 | 2308005 | 2022-03-15 | Long | Georgia | 13183 | 2766 | 34 |
2287189 | 2287189 | 2022-03-08 | Calhoun | South Carolina | 45017 | 2766 | 60 |
2283937 | 2283937 | 2022-03-07 | Calhoun | South Carolina | 45017 | 2766 | 60 |
2274408 | 2274408 | 2022-03-04 | Callahan | Texas | 48059 | 2766 | 72 |
2271155 | 2271155 | 2022-03-03 | Callahan | Texas | 48059 | 2766 | 72 |
2173835 | 2173835 | 2022-02-01 | Juab | Utah | 49023 | 2766 | 21 |
2173838 | 2173838 | 2022-02-01 | Morgan | Utah | 49029 | 2766 | 13 |
2127707 | 2127707 | 2022-01-18 | Potter | Pennsylvania | 42105 | 2766 | 80 |
2119039 | 2119039 | 2022-01-16 | Marion | Arkansas | 5089 | 2766 | 76 |
2106923 | 2106923 | 2022-01-12 | Green | Kentucky | 21087 | 2766 | 40 |
2082495 | 2082495 | 2022-01-04 | Aransas | Texas | 48007 | 2766 | 68 |
2076814 | 2076814 | 2022-01-03 | Inyo | California | 6027 | 2766 | 49 |
2073563 | 2073563 | 2022-01-02 | Inyo | California | 6027 | 2766 | 49 |
2070312 | 2070312 | 2022-01-01 | Inyo | California | 6027 | 2766 | 49 |
2067061 | 2067061 | 2021-12-31 | Inyo | California | 6027 | 2766 | 49 |
2033346 | 2033346 | 2021-12-20 | Clatsop | Oregon | 41007 | 2766 | 35 |
2015112 | 2015112 | 2021-12-15 | Chaffee | Colorado | 8015 | 2766 | 38 |
2014564 | 2014564 | 2021-12-14 | Colonial Heights city | Virginia | 51570 | 2766 | 70 |
2008511 | 2008511 | 2021-12-13 | Madison | Arkansas | 5087 | 2766 | 43 |
1991751 | 1991751 | 2021-12-07 | San Juan | Utah | 49037 | 2766 | 43 |
1973059 | 1973059 | 2021-12-02 | Greene | Georgia | 13133 | 2766 | 73 |
1964421 | 1964421 | 2021-11-29 | Morgan | Missouri | 29141 | 2766 | 72 |
1944227 | 1944227 | 2021-11-23 | Tama | Iowa | 19171 | 2766 | 77 |
1944926 | 1944926 | 2021-11-23 | Pike | Missouri | 29163 | 2766 | 50 |
1940977 | 1940977 | 2021-11-22 | Tama | Iowa | 19171 | 2766 | 77 |
1941160 | 1941160 | 2021-11-22 | Lawrence | Kentucky | 21127 | 2766 | 43 |
1937727 | 1937727 | 2021-11-21 | Tama | Iowa | 19171 | 2766 | 77 |
1934477 | 1934477 | 2021-11-20 | Tama | Iowa | 19171 | 2766 | 77 |
1931226 | 1931226 | 2021-11-19 | Tama | Iowa | 19171 | 2766 | 77 |
1927975 | 1927975 | 2021-11-18 | Tama | Iowa | 19171 | 2766 | 77 |
1924519 | 1924519 | 2021-11-17 | Pike | Illinois | 17149 | 2766 | 61 |
1924725 | 1924725 | 2021-11-17 | Tama | Iowa | 19171 | 2766 | 77 |
1897302 | 1897302 | 2021-11-08 | Freestone | Texas | 48161 | 2766 | 69 |
1880462 | 1880462 | 2021-11-03 | Meigs | Ohio | 39105 | 2766 | 55 |
1875495 | 1875495 | 2021-11-02 | Banks | Georgia | 13011 | 2766 | 62 |
1873245 | 1873245 | 2021-11-01 | Roseau | Minnesota | 27135 | 2766 | 28 |
1874555 | 1874555 | 2021-11-01 | Freestone | Texas | 48161 | 2766 | 68 |
1867682 | 1867682 | 2021-10-30 | Wyoming | Pennsylvania | 42131 | 2766 | 63 |
1845233 | 1845233 | 2021-10-23 | Andrews | Texas | 48003 | 2766 | 53 |
1841983 | 1841983 | 2021-10-22 | Andrews | Texas | 48003 | 2766 | 53 |
1838639 | 1838639 | 2021-10-21 | Benton | Tennessee | 47005 | 2766 | 51 |
1838734 | 1838734 | 2021-10-21 | Andrews | Texas | 48003 | 2766 | 53 |
1835485 | 1835485 | 2021-10-20 | Andrews | Texas | 48003 | 2766 | 53 |
1832236 | 1832236 | 2021-10-19 | Andrews | Texas | 48003 | 2766 | 53 |
1828987 | 1828987 | 2021-10-18 | Andrews | Texas | 48003 | 2766 | 53 |
1825738 | 1825738 | 2021-10-17 | Andrews | Texas | 48003 | 2766 | 53 |
1822489 | 1822489 | 2021-10-16 | Andrews | Texas | 48003 | 2766 | 53 |
1819240 | 1819240 | 2021-10-15 | Andrews | Texas | 48003 | 2766 | 53 |
1813333 | 1813333 | 2021-10-13 | Vernon | Wisconsin | 55123 | 2766 | 55 |
1809744 | 1809744 | 2021-10-12 | Young | Texas | 48503 | 2766 | 61 |
1786618 | 1786618 | 2021-10-05 | Hughes | South Dakota | 46065 | 2766 | 43 |
1761942 | 1761942 | 2021-09-28 | Blaine | Idaho | 16013 | 2766 | 20 |
1736438 | 1736438 | 2021-09-20 | Harrison | Kentucky | 21097 | 2766 | 29 |
1737538 | 1737538 | 2021-09-20 | Wyandot | Ohio | 39175 | 2766 | 58 |
1693190 | 1693190 | 2021-09-07 | Hale | Alabama | 1065 | 2766 | 81 |
1685015 | 1685015 | 2021-09-04 | Texas | Missouri | 29215 | 2766 | 34 |
1669698 | 1669698 | 2021-08-30 | Bledsoe | Tennessee | 47007 | 2766 | 13 |
1664411 | 1664411 | 2021-08-29 | Mitchell | Georgia | 13205 | 2766 | 89 |
1664427 | 1664427 | 2021-08-29 | Putnam | Georgia | 13237 | 2766 | 64 |
1664922 | 1664922 | 2021-08-29 | Allen | Kentucky | 21003 | 2766 | 48 |
1661163 | 1661163 | 2021-08-28 | Mitchell | Georgia | 13205 | 2766 | 89 |
1661179 | 1661179 | 2021-08-28 | Putnam | Georgia | 13237 | 2766 | 64 |
1661674 | 1661674 | 2021-08-28 | Allen | Kentucky | 21003 | 2766 | 48 |
1657915 | 1657915 | 2021-08-27 | Mitchell | Georgia | 13205 | 2766 | 89 |
1657931 | 1657931 | 2021-08-27 | Putnam | Georgia | 13237 | 2766 | 64 |
1658426 | 1658426 | 2021-08-27 | Allen | Kentucky | 21003 | 2766 | 48 |
1653903 | 1653903 | 2021-08-25 | Gloucester | Virginia | 51073 | 2766 | 53 |
1648423 | 1648423 | 2021-08-24 | Jennings | Indiana | 18079 | 2766 | 54 |
1614340 | 1614340 | 2021-08-13 | Rio Grande | Puerto Rico | 72119 | 2766 | |
1610798 | 1610798 | 2021-08-12 | Holmes | Ohio | 39075 | 2766 | 102 |
1604624 | 1604624 | 2021-08-10 | Barnwell | South Carolina | 45011 | 2766 | 58 |
1566205 | 1566205 | 2021-07-29 | Hopewell city | Virginia | 51670 | 2766 | 79 |
1557647 | 1557647 | 2021-07-27 | Franklin | Kansas | 20059 | 2766 | 45 |
1554400 | 1554400 | 2021-07-26 | Franklin | Kansas | 20059 | 2766 | 45 |
1550870 | 1550870 | 2021-07-25 | Jersey | Illinois | 17083 | 2766 | 71 |
1547623 | 1547623 | 2021-07-24 | Jersey | Illinois | 17083 | 2766 | 71 |
1544376 | 1544376 | 2021-07-23 | Jersey | Illinois | 17083 | 2766 | 71 |
1541749 | 1541749 | 2021-07-22 | Dickinson | Michigan | 26043 | 2766 | 74 |
1537731 | 1537731 | 2021-07-21 | Monroe | Georgia | 13207 | 2766 | 105 |
1538502 | 1538502 | 2021-07-21 | Dickinson | Michigan | 26043 | 2766 | 74 |
1539951 | 1539951 | 2021-07-21 | Gonzales | Texas | 48177 | 2766 | 58 |
1535255 | 1535255 | 2021-07-20 | Dickinson | Michigan | 26043 | 2766 | 74 |
1522588 | 1522588 | 2021-07-16 | Randolph | Missouri | 29175 | 2766 | 31 |
1518043 | 1518043 | 2021-07-15 | Morgan | Colorado | 8087 | 2766 | 96 |
1488082 | 1488082 | 2021-07-05 | Moore | Texas | 48341 | 2766 | 73 |
1484835 | 1484835 | 2021-07-04 | Moore | Texas | 48341 | 2766 | 73 |
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);