ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 2998 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 11
- Georgia 10
- Missouri 10
- Arkansas 9
- Florida 9
- Kentucky 9
- Oklahoma 8
- Indiana 7
- Mississippi 7
- Minnesota 6
- Texas 6
- Louisiana 5
- Ohio 5
- Tennessee 5
- Wisconsin 5
- Idaho 4
- South Carolina 4
- Alabama 3
- Puerto Rico 3
- Illinois 2
- Iowa 2
- Maryland 2
- North Carolina 2
- North Dakota 2
- Pennsylvania 2
- Utah 2
- West Virginia 2
- Alaska 1
- Colorado 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500157 | 2500157 | 2022-05-13 | Idaho | Idaho | 16049 | 2998 | 52 |
2502264 | 2502264 | 2022-05-13 | Dawson | Texas | 48115 | 2998 | 94 |
2496899 | 2496899 | 2022-05-12 | Idaho | Idaho | 16049 | 2998 | 52 |
2493641 | 2493641 | 2022-05-11 | Idaho | Idaho | 16049 | 2998 | 52 |
2475891 | 2475891 | 2022-05-05 | Lajas | Puerto Rico | 72079 | 2998 | |
2348141 | 2348141 | 2022-03-27 | Pemiscot | Missouri | 29155 | 2998 | 74 |
2344888 | 2344888 | 2022-03-26 | Pemiscot | Missouri | 29155 | 2998 | 74 |
2341635 | 2341635 | 2022-03-25 | Pemiscot | Missouri | 29155 | 2998 | 74 |
2290201 | 2290201 | 2022-03-09 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2286949 | 2286949 | 2022-03-08 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2283697 | 2283697 | 2022-03-07 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2280445 | 2280445 | 2022-03-06 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2277192 | 2277192 | 2022-03-05 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2273939 | 2273939 | 2022-03-04 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2270686 | 2270686 | 2022-03-03 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2267434 | 2267434 | 2022-03-02 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2214362 | 2214362 | 2022-02-14 | Caldwell | Louisiana | 22021 | 2998 | 46 |
2107382 | 2107382 | 2022-01-12 | Bates | Missouri | 29013 | 2998 | 67 |
2107436 | 2107436 | 2022-01-12 | Livingston | Missouri | 29117 | 2998 | 83 |
2105607 | 2105607 | 2022-01-11 | Greene | Virginia | 51079 | 2998 | 47 |
2071925 | 2071925 | 2022-01-01 | Unknown | New Jersey | 2998 | 0 | |
2063954 | 2063954 | 2021-12-30 | Gulf | Florida | 12045 | 2998 | 65 |
2060704 | 2060704 | 2021-12-29 | Gulf | Florida | 12045 | 2998 | 65 |
2061782 | 2061782 | 2021-12-29 | Calhoun | Mississippi | 28013 | 2998 | 51 |
2057455 | 2057455 | 2021-12-28 | Gulf | Florida | 12045 | 2998 | 64 |
2059155 | 2059155 | 2021-12-28 | Richland | North Dakota | 38077 | 2998 | 21 |
2054206 | 2054206 | 2021-12-27 | Gulf | Florida | 12045 | 2998 | 64 |
2050956 | 2050956 | 2021-12-26 | Gulf | Florida | 12045 | 2998 | 64 |
2047706 | 2047706 | 2021-12-25 | Gulf | Florida | 12045 | 2998 | 64 |
2044456 | 2044456 | 2021-12-24 | Gulf | Florida | 12045 | 2998 | 64 |
2039004 | 2039004 | 2021-12-22 | Redwood | Minnesota | 27127 | 2998 | 49 |
2015558 | 2015558 | 2021-12-15 | White | Illinois | 17193 | 2998 | 43 |
2011740 | 2011740 | 2021-12-14 | Drew | Arkansas | 5043 | 2998 | 56 |
2004168 | 2004168 | 2021-12-11 | Montour | Pennsylvania | 42093 | 2998 | 76 |
1995342 | 1995342 | 2021-12-08 | Lincoln | Wyoming | 56023 | 2998 | 25 |
1991661 | 1991661 | 2021-12-07 | Panola | Texas | 48365 | 2998 | 109 |
1962627 | 1962627 | 2021-11-28 | Prince Edward | Virginia | 51147 | 2998 | 52 |
1959376 | 1959376 | 2021-11-27 | Prince Edward | Virginia | 51147 | 2998 | 52 |
1956125 | 1956125 | 2021-11-26 | Prince Edward | Virginia | 51147 | 2998 | 52 |
1940234 | 1940234 | 2021-11-22 | Hempstead | Arkansas | 5057 | 2998 | 41 |
1926873 | 1926873 | 2021-11-17 | Radford city | Virginia | 51750 | 2998 | 35 |
1907762 | 1907762 | 2021-11-12 | Polk | Arkansas | 5113 | 2998 | 112 |
1894725 | 1894725 | 2021-11-08 | Cross | Arkansas | 5037 | 2998 | 65 |
1893718 | 1893718 | 2021-11-07 | Juncos | Puerto Rico | 72077 | 2998 | |
1877360 | 1877360 | 2021-11-02 | Wasco | Oregon | 41065 | 2998 | 41 |
1873895 | 1873895 | 2021-11-01 | Rolette | North Dakota | 38079 | 2998 | 33 |
1807459 | 1807459 | 2021-10-12 | Minidoka | Idaho | 16067 | 2998 | 40 |
1806806 | 1806806 | 2021-10-11 | Langlade | Wisconsin | 55067 | 2998 | 54 |
1781567 | 1781567 | 2021-10-04 | Union | Illinois | 17181 | 2998 | 51 |
1783796 | 1783796 | 2021-10-04 | Washington | Vermont | 50023 | 2998 | 18 |
1732580 | 1732580 | 2021-09-19 | Elbert | Georgia | 13105 | 2998 | 79 |
1732919 | 1732919 | 2021-09-19 | Sullivan | Indiana | 18153 | 2998 | 47 |
1729330 | 1729330 | 2021-09-18 | Elbert | Georgia | 13105 | 2998 | 79 |
1729669 | 1729669 | 2021-09-18 | Sullivan | Indiana | 18153 | 2998 | 47 |
1726080 | 1726080 | 2021-09-17 | Elbert | Georgia | 13105 | 2998 | 79 |
1726419 | 1726419 | 2021-09-17 | Sullivan | Indiana | 18153 | 2998 | 47 |
1722514 | 1722514 | 2021-09-16 | Conway | Arkansas | 5029 | 2998 | 41 |
1719076 | 1719076 | 2021-09-14 | Kewaunee | Wisconsin | 55061 | 2998 | 40 |
1715824 | 1715824 | 2021-09-13 | Jackson | Wisconsin | 55053 | 2998 | 29 |
1696879 | 1696879 | 2021-09-08 | Jones | Georgia | 13169 | 2998 | 65 |
1693905 | 1693905 | 2021-09-07 | LaGrange | Indiana | 18087 | 2998 | 75 |
1676480 | 1676480 | 2021-09-01 | Reeves | Texas | 48389 | 2998 | 46 |
1669243 | 1669243 | 2021-08-30 | Coshocton | Ohio | 39031 | 2998 | 63 |
1644211 | 1644211 | 2021-08-22 | Pulaski | Virginia | 51155 | 2998 | 70 |
1640961 | 1640961 | 2021-08-21 | Pulaski | Virginia | 51155 | 2998 | 70 |
1637711 | 1637711 | 2021-08-20 | Pulaski | Virginia | 51155 | 2998 | 70 |
1618948 | 1618948 | 2021-08-15 | Pierce | Georgia | 13229 | 2998 | 63 |
1615700 | 1615700 | 2021-08-14 | Pierce | Georgia | 13229 | 2998 | 63 |
1612451 | 1612451 | 2021-08-13 | Pierce | Georgia | 13229 | 2998 | 63 |
1602090 | 1602090 | 2021-08-09 | Preston | West Virginia | 54077 | 2998 | 47 |
1573987 | 1573987 | 2021-08-01 | Clay | Kentucky | 21051 | 2998 | 46 |
1570739 | 1570739 | 2021-07-31 | Clay | Kentucky | 21051 | 2998 | 46 |
1571213 | 1571213 | 2021-07-31 | Audrain | Missouri | 29007 | 2998 | 58 |
1567491 | 1567491 | 2021-07-30 | Clay | Kentucky | 21051 | 2998 | 46 |
1568590 | 1568590 | 2021-07-30 | Perry | Ohio | 39127 | 2998 | 50 |
1546539 | 1546539 | 2021-07-23 | Palo Pinto | Texas | 48363 | 2998 | 78 |
1543527 | 1543527 | 2021-07-22 | Smyth | Virginia | 51173 | 2998 | 95 |
1540279 | 1540279 | 2021-07-21 | Smyth | Virginia | 51173 | 2998 | 95 |
1528568 | 1528568 | 2021-07-18 | Logan | Kentucky | 21141 | 2998 | 73 |
1525321 | 1525321 | 2021-07-17 | Logan | Kentucky | 21141 | 2998 | 73 |
1522073 | 1522073 | 2021-07-16 | Logan | Kentucky | 21141 | 2998 | 73 |
1504914 | 1504914 | 2021-07-11 | Johnson | Arkansas | 5071 | 2998 | 38 |
1501668 | 1501668 | 2021-07-10 | Johnson | Arkansas | 5071 | 2998 | 38 |
1498422 | 1498422 | 2021-07-09 | Johnson | Arkansas | 5071 | 2998 | 38 |
1425152 | 1425152 | 2021-06-16 | Dunklin | Missouri | 29069 | 2998 | 50 |
1398682 | 1398682 | 2021-06-08 | Clark | Kentucky | 21049 | 2998 | 32 |
1379598 | 1379598 | 2021-06-02 | Adams | Mississippi | 28001 | 2998 | 84 |
1376158 | 1376158 | 2021-06-01 | Queen Anne's | Maryland | 24035 | 2998 | 51 |
1376353 | 1376353 | 2021-06-01 | Adams | Mississippi | 28001 | 2998 | 82 |
1372912 | 1372912 | 2021-05-31 | Queen Anne's | Maryland | 24035 | 2998 | 51 |
1373107 | 1373107 | 2021-05-31 | Adams | Mississippi | 28001 | 2998 | 82 |
1350060 | 1350060 | 2021-05-24 | Muhlenberg | Kentucky | 21177 | 2998 | 66 |
1310490 | 1310490 | 2021-05-12 | Lumpkin | Georgia | 13187 | 2998 | 74 |
1293815 | 1293815 | 2021-05-07 | Lawrence | Alabama | 1079 | 2998 | 98 |
1290569 | 1290569 | 2021-05-06 | Lawrence | Alabama | 1079 | 2998 | 98 |
1271375 | 1271375 | 2021-04-30 | Bradford | Florida | 12007 | 2998 | 56 |
1270396 | 1270396 | 2021-04-29 | Overton | Tennessee | 47133 | 2998 | 61 |
1265889 | 1265889 | 2021-04-28 | Brown | Minnesota | 27015 | 2998 | 39 |
1267149 | 1267149 | 2021-04-28 | Overton | Tennessee | 47133 | 2998 | 61 |
1264428 | 1264428 | 2021-04-27 | Logan | West Virginia | 54045 | 2998 | 91 |
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);