ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 3086 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 17
- Virginia 12
- Texas 10
- Indiana 9
- Missouri 8
- Arkansas 7
- Georgia 7
- Iowa 7
- Kentucky 6
- North Carolina 5
- Puerto Rico 5
- Wisconsin 5
- Alabama 4
- Maryland 4
- Mississippi 4
- Ohio 4
- Oklahoma 4
- Pennsylvania 4
- Tennessee 4
- Utah 4
- Illinois 3
- Michigan 3
- Oregon 3
- West Virginia 3
- California 2
- Kansas 2
- New York 2
- South Carolina 2
- Arizona 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500345 | 2500345 | 2022-05-13 | Pulaski | Indiana | 18131 | 3086 | 86 |
2484506 | 2484506 | 2022-05-08 | Kent | Maryland | 24029 | 3086 | 66 |
2481248 | 2481248 | 2022-05-07 | Kent | Maryland | 24029 | 3086 | 66 |
2477990 | 2477990 | 2022-05-06 | Kent | Maryland | 24029 | 3086 | 66 |
2231827 | 2231827 | 2022-02-19 | Barceloneta | Puerto Rico | 72017 | 3086 | |
2213017 | 2213017 | 2022-02-13 | Rockbridge | Virginia | 51163 | 3086 | 73 |
2209764 | 2209764 | 2022-02-12 | Rockbridge | Virginia | 51163 | 3086 | 73 |
2206511 | 2206511 | 2022-02-11 | Rockbridge | Virginia | 51163 | 3086 | 73 |
2200126 | 2200126 | 2022-02-09 | Bayfield | Wisconsin | 55007 | 3086 | 38 |
2160672 | 2160672 | 2022-01-28 | Jackson | Texas | 48239 | 3086 | 55 |
2122920 | 2122920 | 2022-01-17 | Tipton | Indiana | 18159 | 3086 | 78 |
2099519 | 2099519 | 2022-01-10 | Izard | Arkansas | 5065 | 3086 | 58 |
2083727 | 2083727 | 2022-01-05 | Carroll | Illinois | 17015 | 3086 | 43 |
2070244 | 2070244 | 2022-01-01 | Drew | Arkansas | 5043 | 3086 | 57 |
2057928 | 2057928 | 2021-12-28 | Clay | Iowa | 19041 | 3086 | 38 |
2054679 | 2054679 | 2021-12-27 | Clay | Iowa | 19041 | 3086 | 38 |
2051429 | 2051429 | 2021-12-26 | Clay | Iowa | 19041 | 3086 | 38 |
2048179 | 2048179 | 2021-12-25 | Clay | Iowa | 19041 | 3086 | 38 |
2044929 | 2044929 | 2021-12-24 | Clay | Iowa | 19041 | 3086 | 38 |
2041680 | 2041680 | 2021-12-23 | Clay | Iowa | 19041 | 3086 | 38 |
2038430 | 2038430 | 2021-12-22 | Clay | Iowa | 19041 | 3086 | 38 |
2030889 | 2030889 | 2021-12-19 | Prince Edward | Virginia | 51147 | 3086 | 53 |
2027638 | 2027638 | 2021-12-18 | Prince Edward | Virginia | 51147 | 3086 | 53 |
2024387 | 2024387 | 2021-12-17 | Prince Edward | Virginia | 51147 | 3086 | 53 |
2014988 | 2014988 | 2021-12-15 | Cross | Arkansas | 5037 | 3086 | 69 |
2014709 | 2014709 | 2021-12-14 | Barbour | West Virginia | 54001 | 3086 | 53 |
2006195 | 2006195 | 2021-12-12 | Morgan | Kentucky | 21175 | 3086 | 16 |
2002944 | 2002944 | 2021-12-11 | Morgan | Kentucky | 21175 | 3086 | 16 |
1999694 | 1999694 | 2021-12-10 | Morgan | Kentucky | 21175 | 3086 | 16 |
1944262 | 1944262 | 2021-11-23 | Dickinson | Kansas | 20041 | 3086 | 62 |
1941012 | 1941012 | 2021-11-22 | Dickinson | Kansas | 20041 | 3086 | 62 |
1939730 | 1939730 | 2021-11-21 | Duchesne | Utah | 49013 | 3086 | 19 |
1936480 | 1936480 | 2021-11-20 | Duchesne | Utah | 49013 | 3086 | 19 |
1933230 | 1933230 | 2021-11-19 | Duchesne | Utah | 49013 | 3086 | 19 |
1912451 | 1912451 | 2021-11-13 | Texas | Missouri | 29215 | 3086 | 43 |
1886891 | 1886891 | 2021-11-05 | Rolette | North Dakota | 38079 | 3086 | 35 |
1879956 | 1879956 | 2021-11-03 | Vernon | Missouri | 29217 | 3086 | 65 |
1880583 | 1880583 | 2021-11-03 | Crook | Oregon | 41013 | 3086 | 52 |
1880694 | 1880694 | 2021-11-03 | Canovanas | Puerto Rico | 72029 | 3086 | |
1874196 | 1874196 | 2021-11-01 | Canovanas | Puerto Rico | 72029 | 3086 | |
1874291 | 1874291 | 2021-11-01 | Hampton | South Carolina | 45049 | 3086 | 74 |
1874643 | 1874643 | 2021-11-01 | Montague | Texas | 48337 | 3086 | 94 |
1874823 | 1874823 | 2021-11-01 | Fredericksburg city | Virginia | 51630 | 3086 | 26 |
1875064 | 1875064 | 2021-11-01 | Taylor | Wisconsin | 55119 | 3086 | 46 |
1870947 | 1870947 | 2021-10-31 | Canovanas | Puerto Rico | 72029 | 3086 | |
1871394 | 1871394 | 2021-10-31 | Montague | Texas | 48337 | 3086 | 93 |
1867698 | 1867698 | 2021-10-30 | Canovanas | Puerto Rico | 72029 | 3086 | |
1868145 | 1868145 | 2021-10-30 | Montague | Texas | 48337 | 3086 | 93 |
1832797 | 1832797 | 2021-10-19 | Langlade | Wisconsin | 55067 | 3086 | 54 |
1814376 | 1814376 | 2021-10-14 | Bourbon | Kentucky | 21017 | 3086 | 32 |
1810881 | 1810881 | 2021-10-13 | Owen | Indiana | 18119 | 3086 | 69 |
1800401 | 1800401 | 2021-10-10 | Henry | Alabama | 1067 | 3086 | 63 |
1789970 | 1789970 | 2021-10-06 | Polk | Tennessee | 47139 | 3086 | 27 |
1790432 | 1790432 | 2021-10-06 | Adams | Washington | 53001 | 3086 | 27 |
1778055 | 1778055 | 2021-10-03 | Crisp | Georgia | 13081 | 3086 | 105 |
1774805 | 1774805 | 2021-10-02 | Crisp | Georgia | 13081 | 3086 | 105 |
1771555 | 1771555 | 2021-10-01 | Crisp | Georgia | 13081 | 3086 | 105 |
1735176 | 1735176 | 2021-09-19 | Russell | Virginia | 51167 | 3086 | 44 |
1731926 | 1731926 | 2021-09-18 | Russell | Virginia | 51167 | 3086 | 44 |
1728676 | 1728676 | 2021-09-17 | Russell | Virginia | 51167 | 3086 | 44 |
1696403 | 1696403 | 2021-09-07 | Uinta | Wyoming | 56041 | 3086 | 16 |
1673665 | 1673665 | 2021-09-01 | Barbour | Alabama | 1005 | 3086 | 65 |
1673814 | 1673814 | 2021-09-01 | Logan | Arkansas | 5083 | 3086 | 32 |
1675654 | 1675654 | 2021-09-01 | Transylvania | North Carolina | 37175 | 3086 | 36 |
1646939 | 1646939 | 2021-08-23 | Meade | South Dakota | 46093 | 3086 | 31 |
1637366 | 1637366 | 2021-08-20 | Deaf Smith | Texas | 48117 | 3086 | 68 |
1634116 | 1634116 | 2021-08-19 | Deaf Smith | Texas | 48117 | 3086 | 68 |
1620569 | 1620569 | 2021-08-15 | Perry | Ohio | 39127 | 3086 | 50 |
1585641 | 1585641 | 2021-08-04 | Amherst | Virginia | 51009 | 3086 | 40 |
1550945 | 1550945 | 2021-07-25 | Daviess | Indiana | 18027 | 3086 | 102 |
1551561 | 1551561 | 2021-07-25 | Brown | Minnesota | 27015 | 3086 | 40 |
1551789 | 1551789 | 2021-07-25 | McDonald | Missouri | 29119 | 3086 | 40 |
1547698 | 1547698 | 2021-07-24 | Daviess | Indiana | 18027 | 3086 | 102 |
1548314 | 1548314 | 2021-07-24 | Brown | Minnesota | 27015 | 3086 | 40 |
1548542 | 1548542 | 2021-07-24 | McDonald | Missouri | 29119 | 3086 | 40 |
1544451 | 1544451 | 2021-07-23 | Daviess | Indiana | 18027 | 3086 | 102 |
1545067 | 1545067 | 2021-07-23 | Brown | Minnesota | 27015 | 3086 | 40 |
1545295 | 1545295 | 2021-07-23 | McDonald | Missouri | 29119 | 3086 | 40 |
1541203 | 1541203 | 2021-07-22 | Daviess | Indiana | 18027 | 3086 | 102 |
1541819 | 1541819 | 2021-07-22 | Brown | Minnesota | 27015 | 3086 | 40 |
1538572 | 1538572 | 2021-07-21 | Brown | Minnesota | 27015 | 3086 | 40 |
1535325 | 1535325 | 2021-07-20 | Brown | Minnesota | 27015 | 3086 | 40 |
1532077 | 1532077 | 2021-07-19 | Brown | Minnesota | 27015 | 3086 | 40 |
1528830 | 1528830 | 2021-07-18 | Brown | Minnesota | 27015 | 3086 | 40 |
1525583 | 1525583 | 2021-07-17 | Brown | Minnesota | 27015 | 3086 | 40 |
1522336 | 1522336 | 2021-07-16 | Brown | Minnesota | 27015 | 3086 | 40 |
1519087 | 1519087 | 2021-07-15 | Brown | Minnesota | 27015 | 3086 | 40 |
1515532 | 1515532 | 2021-07-14 | Clark | Kentucky | 21049 | 3086 | 32 |
1515840 | 1515840 | 2021-07-14 | Brown | Minnesota | 27015 | 3086 | 40 |
1512594 | 1512594 | 2021-07-13 | Brown | Minnesota | 27015 | 3086 | 40 |
1509347 | 1509347 | 2021-07-12 | Brown | Minnesota | 27015 | 3086 | 40 |
1467343 | 1467343 | 2021-06-29 | Dunklin | Missouri | 29069 | 3086 | 50 |
1460737 | 1460737 | 2021-06-27 | Adams | Mississippi | 28001 | 3086 | 86 |
1457492 | 1457492 | 2021-06-26 | Adams | Mississippi | 28001 | 3086 | 86 |
1453284 | 1453284 | 2021-06-25 | Gilmer | Georgia | 13123 | 3086 | 89 |
1454247 | 1454247 | 2021-06-25 | Adams | Mississippi | 28001 | 3086 | 86 |
1397278 | 1397278 | 2021-06-07 | Willacy | Texas | 48489 | 3086 | 89 |
1394031 | 1394031 | 2021-06-06 | Willacy | Texas | 48489 | 3086 | 89 |
1381469 | 1381469 | 2021-06-03 | Lawrence | Alabama | 1079 | 3086 | 100 |
1369086 | 1369086 | 2021-05-30 | Iroquois | Illinois | 17075 | 3086 | 69 |
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);