ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 6162 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Illinois 11
- Mississippi 9
- Iowa 7
- Pennsylvania 7
- Tennessee 5
- New Mexico 3
- North Carolina 3
- Puerto Rico 3
- Washington 3
- Indiana 2
- Kansas 2
- Kentucky 2
- Louisiana 2
- New Jersey 2
- New York 2
- Ohio 2
- Texas 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Idaho 1
- Michigan 1
- Nevada 1
- Oregon 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484774 | 2484774 | 2022-05-08 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2481516 | 2481516 | 2022-05-07 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2478258 | 2478258 | 2022-05-06 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2475000 | 2475000 | 2022-05-05 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2471743 | 2471743 | 2022-05-04 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2468487 | 2468487 | 2022-05-03 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2465232 | 2465232 | 2022-05-02 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2401030 | 2401030 | 2022-04-12 | San Sebastian | Puerto Rico | 72131 | 6162 | |
2397775 | 2397775 | 2022-04-11 | San Sebastian | Puerto Rico | 72131 | 6162 | |
2387478 | 2387478 | 2022-04-08 | Lewis | New York | 36049 | 6162 | 49 |
2285380 | 2285380 | 2022-03-08 | Crawford | Illinois | 17033 | 6162 | 60 |
2282128 | 2282128 | 2022-03-07 | Crawford | Illinois | 17033 | 6162 | 60 |
2256136 | 2256136 | 2022-02-27 | Jersey | Illinois | 17083 | 6162 | 86 |
2252885 | 2252885 | 2022-02-26 | Jersey | Illinois | 17083 | 6162 | 86 |
2249634 | 2249634 | 2022-02-25 | Jersey | Illinois | 17083 | 6162 | 86 |
2246383 | 2246383 | 2022-02-24 | Jersey | Illinois | 17083 | 6162 | 86 |
2224087 | 2224087 | 2022-02-17 | Rowan | Kentucky | 21205 | 6162 | 52 |
2176544 | 2176544 | 2022-02-02 | Canovanas | Puerto Rico | 72029 | 6162 | |
2147148 | 2147148 | 2022-01-24 | Columbia | Oregon | 41009 | 6162 | 67 |
2147862 | 2147862 | 2022-01-24 | Caroline | Virginia | 51033 | 6162 | 61 |
2126525 | 2126525 | 2022-01-18 | De Soto | Louisiana | 22031 | 6162 | 121 |
2012560 | 2012560 | 2021-12-14 | Lyon | Kansas | 20111 | 6162 | 98 |
2009309 | 2009309 | 2021-12-13 | Lyon | Kansas | 20111 | 6162 | 98 |
1944472 | 1944472 | 2021-11-23 | Beauregard | Louisiana | 22011 | 6162 | 124 |
1898733 | 1898733 | 2021-11-09 | Wapello | Iowa | 19179 | 6162 | 139 |
1895483 | 1895483 | 2021-11-08 | Wapello | Iowa | 19179 | 6162 | 139 |
1892233 | 1892233 | 2021-11-07 | Wapello | Iowa | 19179 | 6162 | 139 |
1888983 | 1888983 | 2021-11-06 | Wapello | Iowa | 19179 | 6162 | 139 |
1885733 | 1885733 | 2021-11-05 | Wapello | Iowa | 19179 | 6162 | 139 |
1882484 | 1882484 | 2021-11-04 | Wapello | Iowa | 19179 | 6162 | 139 |
1879235 | 1879235 | 2021-11-03 | Wapello | Iowa | 19179 | 6162 | 139 |
1872442 | 1872442 | 2021-11-01 | Nez Perce | Idaho | 16069 | 6162 | 98 |
1873941 | 1873941 | 2021-11-01 | Guernsey | Ohio | 39059 | 6162 | 73 |
1838189 | 1838189 | 2021-10-21 | Defiance | Ohio | 39039 | 6162 | 103 |
1819978 | 1819978 | 2021-10-16 | Boone | Arkansas | 5009 | 6162 | 126 |
1809489 | 1809489 | 2021-10-12 | Weakley | Tennessee | 47183 | 6162 | 87 |
1741217 | 1741217 | 2021-09-21 | Lincoln | Tennessee | 47103 | 6162 | 78 |
1737968 | 1737968 | 2021-09-20 | Lincoln | Tennessee | 47103 | 6162 | 78 |
1665753 | 1665753 | 2021-08-29 | Otero | New Mexico | 35035 | 6162 | 91 |
1662505 | 1662505 | 2021-08-28 | Otero | New Mexico | 35035 | 6162 | 91 |
1659257 | 1659257 | 2021-08-27 | Otero | New Mexico | 35035 | 6162 | 91 |
1654702 | 1654702 | 2021-08-26 | Thomas | Georgia | 13275 | 6162 | 140 |
1606211 | 1606211 | 2021-08-11 | Noble | Indiana | 18113 | 6162 | 95 |
1571985 | 1571985 | 2021-07-31 | Bradford | Pennsylvania | 42015 | 6162 | 96 |
1568737 | 1568737 | 2021-07-30 | Bradford | Pennsylvania | 42015 | 6162 | 96 |
1532551 | 1532551 | 2021-07-19 | Salem | New Jersey | 34033 | 6162 | 188 |
1513983 | 1513983 | 2021-07-13 | Hardin | Texas | 48199 | 6162 | 116 |
1490858 | 1490858 | 2021-07-06 | Union | Pennsylvania | 42119 | 6162 | 89 |
1487611 | 1487611 | 2021-07-05 | Union | Pennsylvania | 42119 | 6162 | 89 |
1484364 | 1484364 | 2021-07-04 | Union | Pennsylvania | 42119 | 6162 | 89 |
1481118 | 1481118 | 2021-07-03 | Union | Pennsylvania | 42119 | 6162 | 89 |
1454699 | 1454699 | 2021-06-25 | Jefferson | New York | 36045 | 6162 | 68 |
1359380 | 1359380 | 2021-05-27 | Ogle | Illinois | 17141 | 6162 | 91 |
1310729 | 1310729 | 2021-05-12 | Dubois | Indiana | 18037 | 6162 | 118 |
1285486 | 1285486 | 2021-05-04 | Lafayette | Mississippi | 28071 | 6162 | 118 |
1168892 | 1168892 | 2021-03-29 | Carson City | Nevada | 32510 | 6162 | 122 |
1097999 | 1097999 | 2021-03-07 | Lawrence | Pennsylvania | 42073 | 6162 | 186 |
1054530 | 1054530 | 2021-02-22 | Christian | Kentucky | 21047 | 6162 | 79 |
936027 | 936027 | 2021-01-16 | Tipton | Tennessee | 47167 | 6162 | 65 |
928856 | 928856 | 2021-01-14 | Craven | North Carolina | 37049 | 6162 | 90 |
912650 | 912650 | 2021-01-09 | Henderson | North Carolina | 37089 | 6162 | 92 |
893176 | 893176 | 2021-01-03 | Harnett | North Carolina | 37085 | 6162 | 95 |
871796 | 871796 | 2020-12-28 | Lauderdale | Alabama | 1077 | 6162 | 68 |
872449 | 872449 | 2020-12-28 | Vermilion | Illinois | 17183 | 6162 | 85 |
862623 | 862623 | 2020-12-25 | Adams | Illinois | 17001 | 6162 | 74 |
859378 | 859378 | 2020-12-24 | Adams | Illinois | 17001 | 6162 | 73 |
796463 | 796463 | 2020-12-04 | Putnam | Tennessee | 47141 | 6162 | 85 |
767609 | 767609 | 2020-11-25 | Chesapeake city | Virginia | 51550 | 6162 | 80 |
762696 | 762696 | 2020-11-24 | Jackson | Michigan | 26075 | 6162 | 111 |
735265 | 735265 | 2020-11-15 | Clark | Washington | 53011 | 6162 | 102 |
732019 | 732019 | 2020-11-14 | Clark | Washington | 53011 | 6162 | 102 |
728774 | 728774 | 2020-11-13 | Clark | Washington | 53011 | 6162 | 102 |
713424 | 713424 | 2020-11-09 | Sangamon | Illinois | 17167 | 6162 | 73 |
714179 | 714179 | 2020-11-09 | Harrison | Mississippi | 28047 | 6162 | 92 |
478975 | 478975 | 2020-08-28 | McLennan | Texas | 48309 | 6162 | 82 |
161939 | 161939 | 2020-05-20 | Mercer | New Jersey | 34021 | 6162 | 431 |
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);