ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
175 rows where cases = 3390 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 19
- Indiana 14
- Missouri 11
- Colorado 8
- Alabama 7
- Georgia 7
- New York 7
- Virginia 7
- Arkansas 6
- Kentucky 6
- Louisiana 6
- Michigan 6
- Texas 6
- Illinois 5
- Kansas 5
- Oregon 5
- Washington 5
- North Carolina 4
- Puerto Rico 4
- Utah 4
- Wisconsin 4
- Florida 3
- Idaho 3
- Arizona 2
- Iowa 2
- Maryland 2
- Massachusetts 2
- Mississippi 2
- Nebraska 2
- Nevada 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469595 | 2469595 | 2022-05-03 | Meigs | Tennessee | 47121 | 3390 | 57 |
2466339 | 2466339 | 2022-05-02 | Meigs | Tennessee | 47121 | 3390 | 57 |
2463084 | 2463084 | 2022-05-01 | Meigs | Tennessee | 47121 | 3390 | 57 |
2459828 | 2459828 | 2022-04-30 | Meigs | Tennessee | 47121 | 3390 | 57 |
2456572 | 2456572 | 2022-04-29 | Meigs | Tennessee | 47121 | 3390 | 57 |
2453316 | 2453316 | 2022-04-28 | Meigs | Tennessee | 47121 | 3390 | 57 |
2450060 | 2450060 | 2022-04-27 | Meigs | Tennessee | 47121 | 3390 | 57 |
2446803 | 2446803 | 2022-04-26 | Meigs | Tennessee | 47121 | 3390 | 57 |
2441107 | 2441107 | 2022-04-25 | Marion | Arkansas | 5089 | 3390 | 88 |
2443548 | 2443548 | 2022-04-25 | Meigs | Tennessee | 47121 | 3390 | 57 |
2437851 | 2437851 | 2022-04-24 | Marion | Arkansas | 5089 | 3390 | 88 |
2437967 | 2437967 | 2022-04-24 | Gunnison | Colorado | 8051 | 3390 | 14 |
2440292 | 2440292 | 2022-04-24 | Meigs | Tennessee | 47121 | 3390 | 57 |
2434595 | 2434595 | 2022-04-23 | Marion | Arkansas | 5089 | 3390 | 88 |
2434711 | 2434711 | 2022-04-23 | Gunnison | Colorado | 8051 | 3390 | 14 |
2437036 | 2437036 | 2022-04-23 | Meigs | Tennessee | 47121 | 3390 | 57 |
2437300 | 2437300 | 2022-04-23 | Tyler | Texas | 48457 | 3390 | 88 |
2431455 | 2431455 | 2022-04-22 | Gunnison | Colorado | 8051 | 3390 | 14 |
2433780 | 2433780 | 2022-04-22 | Meigs | Tennessee | 47121 | 3390 | 57 |
2430524 | 2430524 | 2022-04-21 | Meigs | Tennessee | 47121 | 3390 | 57 |
2427268 | 2427268 | 2022-04-20 | Meigs | Tennessee | 47121 | 3390 | 57 |
2383588 | 2383588 | 2022-04-07 | Nantucket | Massachusetts | 25019 | 3390 | 0 |
2313175 | 2313175 | 2022-03-16 | Salinas | Puerto Rico | 72123 | 3390 | |
2286653 | 2286653 | 2022-03-08 | Schuyler | New York | 36097 | 3390 | 24 |
2283401 | 2283401 | 2022-03-07 | Schuyler | New York | 36097 | 3390 | 24 |
2280149 | 2280149 | 2022-03-06 | Schuyler | New York | 36097 | 3390 | 24 |
2269752 | 2269752 | 2022-03-03 | Benzie | Michigan | 26019 | 3390 | 64 |
2266499 | 2266499 | 2022-03-02 | Benzie | Michigan | 26019 | 3390 | 64 |
2236268 | 2236268 | 2022-02-21 | Las Animas | Colorado | 8071 | 3390 | 39 |
2233006 | 2233006 | 2022-02-20 | Grand | Colorado | 8049 | 3390 | 23 |
2229755 | 2229755 | 2022-02-19 | Grand | Colorado | 8049 | 3390 | 23 |
2226504 | 2226504 | 2022-02-18 | Grand | Colorado | 8049 | 3390 | 23 |
2215474 | 2215474 | 2022-02-14 | Hood River | Oregon | 41027 | 3390 | 41 |
2202559 | 2202559 | 2022-02-10 | Anasco | Puerto Rico | 72011 | 3390 | |
2194747 | 2194747 | 2022-02-08 | Fleming | Kentucky | 21069 | 3390 | 44 |
2167415 | 2167415 | 2022-01-30 | Giles | Virginia | 51071 | 3390 | 38 |
2164160 | 2164160 | 2022-01-29 | Giles | Virginia | 51071 | 3390 | 38 |
2160905 | 2160905 | 2022-01-28 | Giles | Virginia | 51071 | 3390 | 38 |
2154607 | 2154607 | 2022-01-26 | Lafayette | Wisconsin | 55065 | 3390 | 19 |
2148932 | 2148932 | 2022-01-25 | Pike | Indiana | 18125 | 3390 | 47 |
2108262 | 2108262 | 2022-01-12 | Morovis | Puerto Rico | 72101 | 3390 | |
2076014 | 2076014 | 2022-01-02 | Burleson | Texas | 48051 | 3390 | 61 |
2072763 | 2072763 | 2022-01-01 | Burleson | Texas | 48051 | 3390 | 61 |
2066973 | 2066973 | 2021-12-31 | Ashley | Arkansas | 5003 | 3390 | 55 |
2069512 | 2069512 | 2021-12-31 | Burleson | Texas | 48051 | 3390 | 61 |
2066261 | 2066261 | 2021-12-30 | Burleson | Texas | 48051 | 3390 | 61 |
2059725 | 2059725 | 2021-12-28 | Unicoi | Tennessee | 47171 | 3390 | 79 |
2054486 | 2054486 | 2021-12-27 | Edgar | Illinois | 17045 | 3390 | 71 |
2052111 | 2052111 | 2021-12-26 | Andrew | Missouri | 29003 | 3390 | 41 |
2048861 | 2048861 | 2021-12-25 | Andrew | Missouri | 29003 | 3390 | 41 |
2045611 | 2045611 | 2021-12-24 | Andrew | Missouri | 29003 | 3390 | 41 |
2042361 | 2042361 | 2021-12-23 | Andrew | Missouri | 29003 | 3390 | 41 |
2028636 | 2028636 | 2021-12-19 | Rush | Indiana | 18139 | 3390 | 35 |
2025385 | 2025385 | 2021-12-18 | Rush | Indiana | 18139 | 3390 | 35 |
2022134 | 2022134 | 2021-12-17 | Rush | Indiana | 18139 | 3390 | 35 |
2012306 | 2012306 | 2021-12-14 | Wayne | Illinois | 17191 | 3390 | 67 |
2014670 | 2014670 | 2021-12-14 | Adams | Washington | 53001 | 3390 | 34 |
2011419 | 2011419 | 2021-12-13 | Adams | Washington | 53001 | 3390 | 34 |
1992158 | 1992158 | 2021-12-08 | Randolph | Alabama | 1111 | 3390 | 67 |
1962953 | 1962953 | 2021-11-29 | La Paz | Arizona | 4012 | 3390 | 102 |
1946386 | 1946386 | 2021-11-23 | Scott | Virginia | 51169 | 3390 | 84 |
1937624 | 1937624 | 2021-11-21 | Starke | Indiana | 18149 | 3390 | 75 |
1934374 | 1934374 | 2021-11-20 | Starke | Indiana | 18149 | 3390 | 75 |
1931123 | 1931123 | 2021-11-19 | Starke | Indiana | 18149 | 3390 | 75 |
1918790 | 1918790 | 2021-11-15 | Jasper | Mississippi | 28061 | 3390 | 66 |
1914100 | 1914100 | 2021-11-14 | Butler | Alabama | 1013 | 3390 | 99 |
1899068 | 1899068 | 2021-11-09 | Somerset | Maryland | 24039 | 3390 | 54 |
1876672 | 1876672 | 2021-11-02 | Nodaway | Missouri | 29147 | 3390 | 34 |
1871895 | 1871895 | 2021-11-01 | Marengo | Alabama | 1091 | 3390 | 90 |
1873423 | 1873423 | 2021-11-01 | Nodaway | Missouri | 29147 | 3390 | 34 |
1868646 | 1868646 | 2021-10-31 | Marengo | Alabama | 1091 | 3390 | 90 |
1870174 | 1870174 | 2021-10-31 | Nodaway | Missouri | 29147 | 3390 | 34 |
1865397 | 1865397 | 2021-10-30 | Marengo | Alabama | 1091 | 3390 | 90 |
1866925 | 1866925 | 2021-10-30 | Nodaway | Missouri | 29147 | 3390 | 34 |
1863676 | 1863676 | 2021-10-29 | Nodaway | Missouri | 29147 | 3390 | 34 |
1860427 | 1860427 | 2021-10-28 | Nodaway | Missouri | 29147 | 3390 | 34 |
1857178 | 1857178 | 2021-10-27 | Nodaway | Missouri | 29147 | 3390 | 34 |
1833334 | 1833334 | 2021-10-20 | Lamar | Georgia | 13171 | 3390 | 89 |
1834093 | 1834093 | 2021-10-20 | Franklin | Massachusetts | 25011 | 3390 | 122 |
1808129 | 1808129 | 2021-10-12 | Clare | Michigan | 26035 | 3390 | 95 |
1804878 | 1804878 | 2021-10-11 | Clare | Michigan | 26035 | 3390 | 95 |
1801485 | 1801485 | 2021-10-10 | Wayne | Kentucky | 21231 | 3390 | 58 |
1798236 | 1798236 | 2021-10-09 | Wayne | Kentucky | 21231 | 3390 | 58 |
1794987 | 1794987 | 2021-10-08 | Wayne | Kentucky | 21231 | 3390 | 58 |
1789904 | 1789904 | 2021-10-06 | Bledsoe | Tennessee | 47007 | 3390 | 14 |
1779870 | 1779870 | 2021-10-03 | Jefferson | Oregon | 41031 | 3390 | 49 |
1776620 | 1776620 | 2021-10-02 | Jefferson | Oregon | 41031 | 3390 | 49 |
1773370 | 1773370 | 2021-10-01 | Jefferson | Oregon | 41031 | 3390 | 49 |
1769044 | 1769044 | 2021-09-30 | St. James | Louisiana | 22093 | 3390 | 68 |
1770913 | 1770913 | 2021-09-30 | Russell | Virginia | 51167 | 3390 | 49 |
1761841 | 1761841 | 2021-09-28 | Hart | Georgia | 13147 | 3390 | 61 |
1760362 | 1760362 | 2021-09-27 | Columbia | Oregon | 41009 | 3390 | 39 |
1745287 | 1745287 | 2021-09-23 | Logan | Arkansas | 5083 | 3390 | 34 |
1720361 | 1720361 | 2021-09-15 | Queen Anne's | Maryland | 24035 | 3390 | 59 |
1716838 | 1716838 | 2021-09-14 | Labette | Kansas | 20099 | 3390 | 58 |
1713592 | 1713592 | 2021-09-13 | Labette | Kansas | 20099 | 3390 | 58 |
1709982 | 1709982 | 2021-09-12 | Jefferson | Idaho | 16051 | 3390 | 33 |
1685291 | 1685291 | 2021-09-04 | Orleans | New York | 36073 | 3390 | 83 |
1667898 | 1667898 | 2021-08-30 | Greene | Indiana | 18055 | 3390 | 90 |
1624295 | 1624295 | 2021-08-16 | Scott | Tennessee | 47151 | 3390 | 48 |
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);