ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 6491 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Michigan 9
- Florida 8
- Texas 8
- Kansas 7
- Virginia 7
- North Carolina 6
- Georgia 4
- New York 4
- Tennessee 4
- Washington 4
- Alabama 3
- Minnesota 3
- Ohio 3
- Colorado 2
- Illinois 2
- Indiana 2
- Louisiana 2
- Missouri 2
- New Jersey 2
- Puerto Rico 2
- Wisconsin 2
- Delaware 1
- Idaho 1
- Kentucky 1
- Mississippi 1
- Nevada 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496347 | 2496347 | 2022-05-12 | Geneva | Alabama | 1061 | 6491 | 164 |
2493033 | 2493033 | 2022-05-10 | Waushara | Wisconsin | 55137 | 6491 | 87 |
2470554 | 2470554 | 2022-05-04 | Routt | Colorado | 8107 | 6491 | 25 |
2428830 | 2428830 | 2022-04-21 | Barton | Kansas | 20009 | 6491 | 96 |
2425574 | 2425574 | 2022-04-20 | Barton | Kansas | 20009 | 6491 | 96 |
2422318 | 2422318 | 2022-04-19 | Barton | Kansas | 20009 | 6491 | 96 |
2419062 | 2419062 | 2022-04-18 | Barton | Kansas | 20009 | 6491 | 96 |
2415806 | 2415806 | 2022-04-17 | Barton | Kansas | 20009 | 6491 | 96 |
2412550 | 2412550 | 2022-04-16 | Barton | Kansas | 20009 | 6491 | 96 |
2409294 | 2409294 | 2022-04-15 | Barton | Kansas | 20009 | 6491 | 96 |
2280167 | 2280167 | 2022-03-06 | Anson | North Carolina | 37007 | 6491 | 96 |
2276914 | 2276914 | 2022-03-05 | Anson | North Carolina | 37007 | 6491 | 96 |
2273661 | 2273661 | 2022-03-04 | Anson | North Carolina | 37007 | 6491 | 96 |
2248461 | 2248461 | 2022-02-24 | Hale | Texas | 48189 | 6491 | 237 |
2240007 | 2240007 | 2022-02-22 | Posey | Indiana | 18129 | 6491 | 54 |
2225342 | 2225342 | 2022-02-17 | Dorado | Puerto Rico | 72051 | 6491 | |
2194972 | 2194972 | 2022-02-08 | Clare | Michigan | 26035 | 6491 | 149 |
2191718 | 2191718 | 2022-02-07 | Clare | Michigan | 26035 | 6491 | 149 |
2179224 | 2179224 | 2022-02-03 | Nye | Nevada | 32023 | 6491 | 214 |
2118026 | 2118026 | 2022-01-15 | Rio Grande | Puerto Rico | 72119 | 6491 | |
2099223 | 2099223 | 2022-01-09 | Whitman | Washington | 53075 | 6491 | 83 |
2095972 | 2095972 | 2022-01-08 | Whitman | Washington | 53075 | 6491 | 83 |
2092720 | 2092720 | 2022-01-07 | Whitman | Washington | 53075 | 6491 | 83 |
2053891 | 2053891 | 2021-12-27 | Franklin | Alabama | 1059 | 6491 | 110 |
2055405 | 2055405 | 2021-12-27 | Howell | Missouri | 29091 | 6491 | 174 |
2041251 | 2041251 | 2021-12-23 | Wakulla | Florida | 12129 | 6491 | 106 |
2038001 | 2038001 | 2021-12-22 | Wakulla | Florida | 12129 | 6491 | 106 |
2034751 | 2034751 | 2021-12-21 | Wakulla | Florida | 12129 | 6491 | 106 |
2031501 | 2031501 | 2021-12-20 | Wakulla | Florida | 12129 | 6491 | 106 |
2028250 | 2028250 | 2021-12-19 | Wakulla | Florida | 12129 | 6491 | 106 |
2024999 | 2024999 | 2021-12-18 | Wakulla | Florida | 12129 | 6491 | 106 |
2021748 | 2021748 | 2021-12-17 | Wakulla | Florida | 12129 | 6491 | 106 |
2016990 | 2016990 | 2021-12-15 | Putnam | Ohio | 39137 | 6491 | 123 |
2008949 | 2008949 | 2021-12-13 | Nez Perce | Idaho | 16069 | 6491 | 107 |
1989238 | 1989238 | 2021-12-07 | Unknown | Florida | 6491 | 708 | |
1972313 | 1972313 | 2021-12-01 | Danville city | Virginia | 51590 | 6491 | 198 |
1922584 | 1922584 | 2021-11-16 | Stokes | North Carolina | 37169 | 6491 | 116 |
1923022 | 1923022 | 2021-11-16 | Chester | South Carolina | 45023 | 6491 | 118 |
1886925 | 1886925 | 2021-11-05 | Crawford | Ohio | 39033 | 6491 | 141 |
1873757 | 1873757 | 2021-11-01 | Alexander | North Carolina | 37003 | 6491 | 117 |
1871587 | 1871587 | 2021-10-31 | Henry | Virginia | 51089 | 6491 | 155 |
1868338 | 1868338 | 2021-10-30 | Henry | Virginia | 51089 | 6491 | 155 |
1865089 | 1865089 | 2021-10-29 | Henry | Virginia | 51089 | 6491 | 155 |
1834190 | 1834190 | 2021-10-20 | Beltrami | Minnesota | 27007 | 6491 | 78 |
1834757 | 1834757 | 2021-10-20 | Tompkins | New York | 36109 | 6491 | 59 |
1802435 | 1802435 | 2021-10-10 | Auglaize | Ohio | 39011 | 6491 | 89 |
1795379 | 1795379 | 2021-10-08 | Butler | Missouri | 29023 | 6491 | 70 |
1746598 | 1746598 | 2021-09-23 | Monroe | Mississippi | 28095 | 6491 | 161 |
1747785 | 1747785 | 2021-09-23 | Brown | Texas | 48049 | 6491 | 166 |
1744535 | 1744535 | 2021-09-22 | Brown | Texas | 48049 | 6491 | 166 |
1741176 | 1741176 | 2021-09-21 | Cheatham | Tennessee | 47021 | 6491 | 60 |
1741286 | 1741286 | 2021-09-21 | Brown | Texas | 48049 | 6491 | 166 |
1737927 | 1737927 | 2021-09-20 | Cheatham | Tennessee | 47021 | 6491 | 60 |
1738037 | 1738037 | 2021-09-20 | Brown | Texas | 48049 | 6491 | 166 |
1734787 | 1734787 | 2021-09-19 | Brown | Texas | 48049 | 6491 | 166 |
1731537 | 1731537 | 2021-09-18 | Brown | Texas | 48049 | 6491 | 166 |
1728287 | 1728287 | 2021-09-17 | Brown | Texas | 48049 | 6491 | 166 |
1690387 | 1690387 | 2021-09-06 | Liberty | Georgia | 13179 | 6491 | 76 |
1687137 | 1687137 | 2021-09-05 | Liberty | Georgia | 13179 | 6491 | 76 |
1683887 | 1683887 | 2021-09-04 | Liberty | Georgia | 13179 | 6491 | 76 |
1680636 | 1680636 | 2021-09-03 | Liberty | Georgia | 13179 | 6491 | 76 |
1671465 | 1671465 | 2021-08-31 | Henderson | Kentucky | 21101 | 6491 | 86 |
1651561 | 1651561 | 2021-08-25 | Grundy | Illinois | 17063 | 6491 | 84 |
1583879 | 1583879 | 2021-08-04 | St. Mary | Louisiana | 22101 | 6491 | 151 |
1564535 | 1564535 | 2021-07-29 | Shiawassee | Michigan | 26155 | 6491 | 110 |
1561287 | 1561287 | 2021-07-28 | Shiawassee | Michigan | 26155 | 6491 | 110 |
1558039 | 1558039 | 2021-07-27 | Shiawassee | Michigan | 26155 | 6491 | 110 |
1521019 | 1521019 | 2021-07-16 | Colbert | Alabama | 1033 | 6491 | 141 |
1513187 | 1513187 | 2021-07-13 | Columbus | North Carolina | 37047 | 6491 | 153 |
1429931 | 1429931 | 2021-06-17 | Cowlitz | Washington | 53015 | 6491 | 86 |
1342211 | 1342211 | 2021-05-21 | Harrisonburg city | Virginia | 51660 | 6491 | 94 |
1335893 | 1335893 | 2021-05-19 | Calumet | Wisconsin | 55015 | 6491 | 56 |
1295134 | 1295134 | 2021-05-07 | Kandiyohi | Minnesota | 27067 | 6491 | 82 |
1270331 | 1270331 | 2021-04-29 | Bedford | Tennessee | 47003 | 6491 | 129 |
1168462 | 1168462 | 2021-03-29 | Blue Earth | Minnesota | 27013 | 6491 | 38 |
1169678 | 1169678 | 2021-03-29 | Dickson | Tennessee | 47043 | 6491 | 107 |
1100798 | 1100798 | 2021-03-08 | Chemung | New York | 36015 | 6491 | 131 |
1024017 | 1024017 | 2021-02-12 | Frederick | Virginia | 51069 | 6491 | 47 |
1016370 | 1016370 | 2021-02-10 | Warren | New Jersey | 34041 | 6491 | 207 |
943885 | 943885 | 2021-01-19 | Hancock | Indiana | 18059 | 6491 | 102 |
937908 | 937908 | 2021-01-17 | Allegan | Michigan | 26005 | 6491 | 92 |
934663 | 934663 | 2021-01-16 | Allegan | Michigan | 26005 | 6491 | 92 |
767690 | 767690 | 2020-11-25 | Richmond city | Virginia | 51760 | 6491 | 81 |
711374 | 711374 | 2020-11-08 | Onondaga | New York | 36067 | 6491 | 188 |
665359 | 665359 | 2020-10-25 | Genesee | Michigan | 26049 | 6491 | 333 |
662114 | 662114 | 2020-10-24 | Genesee | Michigan | 26049 | 6491 | 333 |
625807 | 625807 | 2020-10-13 | Madison | Illinois | 17119 | 6491 | 149 |
627020 | 627020 | 2020-10-13 | Monroe | New York | 36055 | 6491 | 260 |
624786 | 624786 | 2020-10-12 | Davis | Utah | 49011 | 6491 | 37 |
525033 | 525033 | 2020-09-12 | Sussex | Delaware | 10005 | 6491 | 197 |
415142 | 415142 | 2020-08-09 | Adams | Colorado | 8001 | 6491 | 176 |
177128 | 177128 | 2020-05-25 | Mercer | New Jersey | 34021 | 6491 | 450 |
116424 | 116424 | 2020-05-05 | Jefferson | Louisiana | 22051 | 6491 | 381 |
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);