ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 3432 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 12
- North Carolina 11
- Indiana 10
- Georgia 9
- Missouri 9
- Illinois 7
- Michigan 7
- Puerto Rico 6
- Texas 6
- Kentucky 5
- South Carolina 5
- Alabama 4
- Kansas 4
- Louisiana 4
- California 3
- New Mexico 3
- Ohio 3
- Washington 3
- Wisconsin 3
- Wyoming 3
- Mississippi 2
- South Dakota 2
- Virginia 2
- West Virginia 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Idaho 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476562 | 2476562 | 2022-05-05 | Southampton | Virginia | 51175 | 3432 | 92 |
2425369 | 2425369 | 2022-04-20 | Washington | Illinois | 17189 | 3432 | 41 |
2418857 | 2418857 | 2022-04-18 | Washington | Illinois | 17189 | 3432 | 41 |
2415601 | 2415601 | 2022-04-17 | Washington | Illinois | 17189 | 3432 | 41 |
2412345 | 2412345 | 2022-04-16 | Washington | Illinois | 17189 | 3432 | 41 |
2409089 | 2409089 | 2022-04-15 | Washington | Illinois | 17189 | 3432 | 41 |
2371733 | 2371733 | 2022-04-03 | Salinas | Puerto Rico | 72123 | 3432 | |
2351048 | 2351048 | 2022-03-28 | Dukes | Massachusetts | 25007 | 3432 | 0 |
2294427 | 2294427 | 2022-03-10 | Buffalo | Wisconsin | 55011 | 3432 | 12 |
2281780 | 2281780 | 2022-03-07 | Grand | Colorado | 8049 | 3432 | 23 |
2281339 | 2281339 | 2022-03-06 | Klickitat | Washington | 53039 | 3432 | 43 |
2278086 | 2278086 | 2022-03-05 | Klickitat | Washington | 53039 | 3432 | 43 |
2274833 | 2274833 | 2022-03-04 | Klickitat | Washington | 53039 | 3432 | 43 |
2266268 | 2266268 | 2022-03-02 | Carroll | Kentucky | 21041 | 3432 | 42 |
2263017 | 2263017 | 2022-03-01 | Carroll | Kentucky | 21041 | 3432 | 42 |
2231824 | 2231824 | 2022-02-19 | Anasco | Puerto Rico | 72011 | 3432 | |
2224343 | 2224343 | 2022-02-17 | Kanabec | Minnesota | 27065 | 3432 | 54 |
2190440 | 2190440 | 2022-02-06 | Goshen | Wyoming | 56015 | 3432 | 53 |
2187187 | 2187187 | 2022-02-05 | Goshen | Wyoming | 56015 | 3432 | 53 |
2183934 | 2183934 | 2022-02-04 | Goshen | Wyoming | 56015 | 3432 | 53 |
2174979 | 2174979 | 2022-02-02 | Tipton | Indiana | 18159 | 3432 | 81 |
2176588 | 2176588 | 2022-02-02 | Quebradillas | Puerto Rico | 72115 | 3432 | |
2176867 | 2176867 | 2022-02-02 | Colorado | Texas | 48089 | 3432 | 57 |
2165199 | 2165199 | 2022-01-30 | Parke | Indiana | 18121 | 3432 | 42 |
2161944 | 2161944 | 2022-01-29 | Parke | Indiana | 18121 | 3432 | 42 |
2158689 | 2158689 | 2022-01-28 | Parke | Indiana | 18121 | 3432 | 42 |
2124843 | 2124843 | 2022-01-17 | Freestone | Texas | 48161 | 3432 | 76 |
2104399 | 2104399 | 2022-01-11 | Humboldt | Nevada | 32013 | 3432 | 45 |
2105226 | 2105226 | 2022-01-11 | Polk | Tennessee | 47139 | 3432 | 50 |
2101975 | 2101975 | 2022-01-10 | Polk | Tennessee | 47139 | 3432 | 50 |
2098724 | 2098724 | 2022-01-09 | Polk | Tennessee | 47139 | 3432 | 50 |
2095472 | 2095472 | 2022-01-08 | Polk | Tennessee | 47139 | 3432 | 50 |
2092220 | 2092220 | 2022-01-07 | Polk | Tennessee | 47139 | 3432 | 50 |
2087678 | 2087678 | 2022-01-06 | Ogemaw | Michigan | 26129 | 3432 | 83 |
2088968 | 2088968 | 2022-01-06 | Polk | Tennessee | 47139 | 3432 | 50 |
2084426 | 2084426 | 2022-01-05 | Ogemaw | Michigan | 26129 | 3432 | 83 |
2085717 | 2085717 | 2022-01-05 | Polk | Tennessee | 47139 | 3432 | 50 |
2082465 | 2082465 | 2022-01-04 | Polk | Tennessee | 47139 | 3432 | 50 |
2057072 | 2057072 | 2021-12-27 | Sawyer | Wisconsin | 55113 | 3432 | 47 |
2031555 | 2031555 | 2021-12-20 | Elbert | Georgia | 13105 | 3432 | 93 |
2018154 | 2018154 | 2021-12-16 | Marengo | Alabama | 1091 | 3432 | 93 |
2016466 | 2016466 | 2021-12-15 | Texas | Missouri | 29215 | 3432 | 68 |
2005869 | 2005869 | 2021-12-12 | Orange | Indiana | 18117 | 3432 | 79 |
2002618 | 2002618 | 2021-12-11 | Orange | Indiana | 18117 | 3432 | 79 |
1999368 | 1999368 | 2021-12-10 | Orange | Indiana | 18117 | 3432 | 79 |
1994599 | 1994599 | 2021-12-08 | Hughes | South Dakota | 46065 | 3432 | 50 |
1995224 | 1995224 | 2021-12-08 | Lewis | West Virginia | 54041 | 3432 | 60 |
1975954 | 1975954 | 2021-12-03 | La Paz | Arizona | 4012 | 3432 | 102 |
1969844 | 1969844 | 2021-12-01 | Mitchell | Georgia | 13205 | 3432 | 101 |
1925667 | 1925667 | 2021-11-17 | Grant | New Mexico | 35017 | 3432 | 54 |
1882072 | 1882072 | 2021-11-04 | Lamar | Georgia | 13171 | 3432 | 92 |
1874856 | 1874856 | 2021-11-01 | Mecklenburg | Virginia | 51117 | 3432 | 84 |
1819246 | 1819246 | 2021-10-15 | Austin | Texas | 48015 | 3432 | 51 |
1816079 | 1816079 | 2021-10-14 | Gray | Texas | 48179 | 3432 | 75 |
1810021 | 1810021 | 2021-10-12 | Wyoming | West Virginia | 54109 | 3432 | 56 |
1781362 | 1781362 | 2021-10-04 | McDuffie | Georgia | 13189 | 3432 | 68 |
1783119 | 1783119 | 2021-10-04 | Jefferson | Oregon | 41031 | 3432 | 49 |
1768822 | 1768822 | 2021-09-30 | Labette | Kansas | 20099 | 3432 | 59 |
1770429 | 1770429 | 2021-09-30 | Fentress | Tennessee | 47049 | 3432 | 59 |
1765573 | 1765573 | 2021-09-29 | Labette | Kansas | 20099 | 3432 | 59 |
1766113 | 1766113 | 2021-09-29 | Tishomingo | Mississippi | 28141 | 3432 | 89 |
1748387 | 1748387 | 2021-09-24 | Barbour | Alabama | 1005 | 3432 | 70 |
1746722 | 1746722 | 2021-09-23 | Randolph | Missouri | 29175 | 3432 | 36 |
1734131 | 1734131 | 2021-09-19 | Transylvania | North Carolina | 37175 | 3432 | 37 |
1730881 | 1730881 | 2021-09-18 | Transylvania | North Carolina | 37175 | 3432 | 37 |
1727631 | 1727631 | 2021-09-17 | Transylvania | North Carolina | 37175 | 3432 | 37 |
1700423 | 1700423 | 2021-09-09 | Posey | Indiana | 18129 | 3432 | 38 |
1691205 | 1691205 | 2021-09-06 | Mecosta | Michigan | 26107 | 3432 | 39 |
1687955 | 1687955 | 2021-09-05 | Mecosta | Michigan | 26107 | 3432 | 39 |
1684705 | 1684705 | 2021-09-04 | Mecosta | Michigan | 26107 | 3432 | 39 |
1681454 | 1681454 | 2021-09-03 | Mecosta | Michigan | 26107 | 3432 | 39 |
1682439 | 1682439 | 2021-09-03 | Clarion | Pennsylvania | 42031 | 3432 | 99 |
1672922 | 1672922 | 2021-08-31 | Meade | South Dakota | 46093 | 3432 | 32 |
1651555 | 1651555 | 2021-08-25 | Fayette | Illinois | 17051 | 3432 | 59 |
1645594 | 1645594 | 2021-08-23 | Richland | Louisiana | 22083 | 3432 | 62 |
1626372 | 1626372 | 2021-08-17 | George | Mississippi | 28039 | 3432 | 57 |
1561470 | 1561470 | 2021-07-28 | Barry | Missouri | 29009 | 3432 | 50 |
1561521 | 1561521 | 2021-07-28 | Lafayette | Missouri | 29107 | 3432 | 58 |
1558551 | 1558551 | 2021-07-27 | Luna | New Mexico | 35029 | 3432 | 92 |
1555304 | 1555304 | 2021-07-26 | Luna | New Mexico | 35029 | 3432 | 92 |
1555440 | 1555440 | 2021-07-26 | Montgomery | North Carolina | 37123 | 3432 | 97 |
1537804 | 1537804 | 2021-07-21 | Bonner | Idaho | 16017 | 3432 | 46 |
1402971 | 1402971 | 2021-06-09 | Champaign | Ohio | 39021 | 3432 | 58 |
1393137 | 1393137 | 2021-06-06 | Pasquotank | North Carolina | 37139 | 3432 | 84 |
1389892 | 1389892 | 2021-06-05 | Pasquotank | North Carolina | 37139 | 3432 | 84 |
1386647 | 1386647 | 2021-06-04 | Pasquotank | North Carolina | 37139 | 3432 | 84 |
1361113 | 1361113 | 2021-05-27 | Vega Baja | Puerto Rico | 72145 | 3432 | |
1357867 | 1357867 | 2021-05-26 | Vega Baja | Puerto Rico | 72145 | 3432 | |
1354621 | 1354621 | 2021-05-25 | Vega Baja | Puerto Rico | 72145 | 3432 | |
1334587 | 1334587 | 2021-05-19 | Chenango | New York | 36017 | 3432 | 76 |
1335162 | 1335162 | 2021-05-19 | Clarendon | South Carolina | 45027 | 3432 | 114 |
1331915 | 1331915 | 2021-05-18 | Clarendon | South Carolina | 45027 | 3432 | 113 |
1328668 | 1328668 | 2021-05-17 | Clarendon | South Carolina | 45027 | 3432 | 113 |
1325140 | 1325140 | 2021-05-16 | Williams | Ohio | 39171 | 3432 | 75 |
1311018 | 1311018 | 2021-05-12 | Boyle | Kentucky | 21021 | 3432 | 70 |
1287642 | 1287642 | 2021-05-05 | Levy | Florida | 12075 | 3432 | 54 |
1258597 | 1258597 | 2021-04-26 | Upson | Georgia | 13293 | 3432 | 126 |
1255350 | 1255350 | 2021-04-25 | Upson | Georgia | 13293 | 3432 | 126 |
1252103 | 1252103 | 2021-04-24 | Upson | Georgia | 13293 | 3432 | 126 |
1227142 | 1227142 | 2021-04-16 | Lawrence | Missouri | 29109 | 3432 | 80 |
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);