ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where cases = 2426 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Georgia 15
- Puerto Rico 12
- Virginia 12
- North Carolina 11
- Alabama 10
- Florida 9
- Indiana 9
- Missouri 9
- Illinois 8
- Minnesota 8
- Ohio 7
- Oklahoma 7
- Kentucky 6
- Arkansas 5
- Mississippi 5
- Kansas 4
- Louisiana 4
- Tennessee 4
- Maryland 3
- Michigan 3
- New York 3
- Pennsylvania 3
- South Carolina 3
- Washington 3
- Colorado 2
- Nebraska 2
- South Dakota 2
- Wisconsin 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487150 | 2487150 | 2022-05-09 | Brown | Illinois | 17009 | 2426 | 21 |
2475910 | 2475910 | 2022-05-05 | Rincon | Puerto Rico | 72117 | 2426 | |
2302559 | 2302559 | 2022-03-13 | Grundy | Missouri | 29079 | 2426 | 66 |
2299307 | 2299307 | 2022-03-12 | Grundy | Missouri | 29079 | 2426 | 66 |
2296055 | 2296055 | 2022-03-11 | Grundy | Missouri | 29079 | 2426 | 66 |
2292803 | 2292803 | 2022-03-10 | Grundy | Missouri | 29079 | 2426 | 66 |
2246658 | 2246658 | 2022-02-24 | Doniphan | Kansas | 20043 | 2426 | 32 |
2243407 | 2243407 | 2022-02-23 | Doniphan | Kansas | 20043 | 2426 | 32 |
2240285 | 2240285 | 2022-02-22 | Hancock | Kentucky | 21091 | 2426 | 20 |
2217987 | 2217987 | 2022-02-15 | Bollinger | Missouri | 29017 | 2426 | 35 |
2206271 | 2206271 | 2022-02-11 | Morris | Texas | 48343 | 2426 | 65 |
2193431 | 2193431 | 2022-02-07 | Franklin city | Virginia | 51620 | 2426 | 44 |
2189557 | 2189557 | 2022-02-06 | Ciales | Puerto Rico | 72039 | 2426 | |
2170724 | 2170724 | 2022-01-31 | Richmond | Virginia | 51159 | 2426 | 17 |
2145048 | 2145048 | 2022-01-24 | Fulton | Arkansas | 5049 | 2426 | 80 |
2132334 | 2132334 | 2022-01-20 | Early | Georgia | 13099 | 2426 | 58 |
2125405 | 2125405 | 2022-01-18 | Conecuh | Alabama | 1035 | 2426 | 63 |
2076035 | 2076035 | 2022-01-02 | Comanche | Texas | 48093 | 2426 | 67 |
2072784 | 2072784 | 2022-01-01 | Comanche | Texas | 48093 | 2426 | 67 |
2069533 | 2069533 | 2021-12-31 | Comanche | Texas | 48093 | 2426 | 67 |
2066282 | 2066282 | 2021-12-30 | Comanche | Texas | 48093 | 2426 | 67 |
2010744 | 2010744 | 2021-12-13 | Naranjito | Puerto Rico | 72105 | 2426 | |
2005768 | 2005768 | 2021-12-12 | Massac | Illinois | 17127 | 2426 | 58 |
2007493 | 2007493 | 2021-12-12 | Naranjito | Puerto Rico | 72105 | 2426 | |
2002517 | 2002517 | 2021-12-11 | Massac | Illinois | 17127 | 2426 | 58 |
2003974 | 2003974 | 2021-12-11 | Monroe | Ohio | 39111 | 2426 | 62 |
1999267 | 1999267 | 2021-12-10 | Massac | Illinois | 17127 | 2426 | 58 |
1985328 | 1985328 | 2021-12-05 | Giles | Virginia | 51071 | 2426 | 33 |
1982078 | 1982078 | 2021-12-04 | Giles | Virginia | 51071 | 2426 | 33 |
1978828 | 1978828 | 2021-12-03 | Giles | Virginia | 51071 | 2426 | 33 |
1971103 | 1971103 | 2021-12-01 | Seward | Nebraska | 31159 | 2426 | 38 |
1965721 | 1965721 | 2021-11-29 | Wilbarger | Texas | 48487 | 2426 | 67 |
1922358 | 1922358 | 2021-11-16 | York | Nebraska | 31185 | 2426 | 19 |
1914498 | 1914498 | 2021-11-14 | Brooks | Georgia | 13027 | 2426 | 71 |
1911248 | 1911248 | 2021-11-13 | Brooks | Georgia | 13027 | 2426 | 71 |
1907999 | 1907999 | 2021-11-12 | Brooks | Georgia | 13027 | 2426 | 71 |
1909992 | 1909992 | 2021-11-12 | San Lorenzo | Puerto Rico | 72129 | 2426 | |
1906743 | 1906743 | 2021-11-11 | San Lorenzo | Puerto Rico | 72129 | 2426 | |
1886736 | 1886736 | 2021-11-05 | Schoharie | New York | 36095 | 2426 | 23 |
1880730 | 1880730 | 2021-11-03 | Moca | Puerto Rico | 72099 | 2426 | |
1877481 | 1877481 | 2021-11-02 | Moca | Puerto Rico | 72099 | 2426 | |
1874232 | 1874232 | 2021-11-01 | Moca | Puerto Rico | 72099 | 2426 | |
1874363 | 1874363 | 2021-11-01 | Oglala Lakota | South Dakota | 46102 | 2426 | 53 |
1852497 | 1852497 | 2021-10-26 | Howard | Arkansas | 5061 | 2426 | 35 |
1848499 | 1848499 | 2021-10-24 | Bosque | Texas | 48035 | 2426 | 55 |
1845249 | 1845249 | 2021-10-23 | Bosque | Texas | 48035 | 2426 | 55 |
1841690 | 1841690 | 2021-10-22 | Aguada | Puerto Rico | 72003 | 2426 | |
1838441 | 1838441 | 2021-10-21 | Aguada | Puerto Rico | 72003 | 2426 | |
1835192 | 1835192 | 2021-10-20 | Aguada | Puerto Rico | 72003 | 2426 | |
1822174 | 1822174 | 2021-10-16 | Montour | Pennsylvania | 42093 | 2426 | 70 |
1816218 | 1816218 | 2021-10-14 | Tyler | Texas | 48457 | 2426 | 68 |
1812970 | 1812970 | 2021-10-13 | Tyler | Texas | 48457 | 2426 | 68 |
1809637 | 1809637 | 2021-10-12 | Leon | Texas | 48289 | 2426 | 62 |
1809721 | 1809721 | 2021-10-12 | Tyler | Texas | 48457 | 2426 | 67 |
1787115 | 1787115 | 2021-10-05 | King George | Virginia | 51099 | 2426 | 22 |
1758523 | 1758523 | 2021-09-27 | Bacon | Georgia | 13005 | 2426 | 51 |
1756462 | 1756462 | 2021-09-26 | Pike | Missouri | 29163 | 2426 | 33 |
1753214 | 1753214 | 2021-09-25 | Pike | Missouri | 29163 | 2426 | 33 |
1736100 | 1736100 | 2021-09-20 | Carroll | Indiana | 18015 | 2426 | 29 |
1725702 | 1725702 | 2021-09-17 | Washington | Alabama | 1129 | 2426 | 45 |
1720754 | 1720754 | 2021-09-15 | Wright | Missouri | 29229 | 2426 | 44 |
1721699 | 1721699 | 2021-09-15 | Grundy | Tennessee | 47061 | 2426 | 36 |
1718045 | 1718045 | 2021-09-14 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1714797 | 1714797 | 2021-09-13 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1711551 | 1711551 | 2021-09-12 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1707375 | 1707375 | 2021-09-11 | Talbot | Maryland | 24041 | 2426 | 49 |
1708304 | 1708304 | 2021-09-11 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1705057 | 1705057 | 2021-09-10 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1701807 | 1701807 | 2021-09-09 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1698558 | 1698558 | 2021-09-08 | Atoka | Oklahoma | 40005 | 2426 | 29 |
1693833 | 1693833 | 2021-09-07 | Pike | Illinois | 17149 | 2426 | 58 |
1671971 | 1671971 | 2021-08-31 | Livingston | Missouri | 29117 | 2426 | 58 |
1650642 | 1650642 | 2021-08-24 | Dinwiddie | Virginia | 51053 | 2426 | 46 |
1642553 | 1642553 | 2021-08-22 | Martin | Minnesota | 27091 | 2426 | 33 |
1637960 | 1637960 | 2021-08-21 | Fayette | Alabama | 1057 | 2426 | 65 |
1639303 | 1639303 | 2021-08-21 | Martin | Minnesota | 27091 | 2426 | 33 |
1636053 | 1636053 | 2021-08-20 | Martin | Minnesota | 27091 | 2426 | 33 |
1632803 | 1632803 | 2021-08-19 | Martin | Minnesota | 27091 | 2426 | 33 |
1629253 | 1629253 | 2021-08-18 | Letcher | Kentucky | 21133 | 2426 | 49 |
1620353 | 1620353 | 2021-08-15 | Ashe | North Carolina | 37009 | 2426 | 45 |
1617105 | 1617105 | 2021-08-14 | Ashe | North Carolina | 37009 | 2426 | 45 |
1613857 | 1613857 | 2021-08-13 | Ashe | North Carolina | 37009 | 2426 | 45 |
1609044 | 1609044 | 2021-08-12 | Gulf | Florida | 12045 | 2426 | 45 |
1605795 | 1605795 | 2021-08-11 | Gulf | Florida | 12045 | 2426 | 45 |
1602546 | 1602546 | 2021-08-10 | Gulf | Florida | 12045 | 2426 | 45 |
1599297 | 1599297 | 2021-08-09 | Gulf | Florida | 12045 | 2426 | 45 |
1596048 | 1596048 | 2021-08-08 | Gulf | Florida | 12045 | 2426 | 45 |
1596481 | 1596481 | 2021-08-08 | Spencer | Indiana | 18147 | 2426 | 31 |
1592799 | 1592799 | 2021-08-07 | Gulf | Florida | 12045 | 2426 | 45 |
1593232 | 1593232 | 2021-08-07 | Spencer | Indiana | 18147 | 2426 | 31 |
1589550 | 1589550 | 2021-08-06 | Gulf | Florida | 12045 | 2426 | 45 |
1589983 | 1589983 | 2021-08-06 | Spencer | Indiana | 18147 | 2426 | 31 |
1587438 | 1587438 | 2021-08-05 | Stone | Mississippi | 28131 | 2426 | 38 |
1579185 | 1579185 | 2021-08-02 | Gloucester | Virginia | 51073 | 2426 | 52 |
1541561 | 1541561 | 2021-07-22 | Marion | Kentucky | 21155 | 2426 | 38 |
1539230 | 1539230 | 2021-07-21 | Transylvania | North Carolina | 37175 | 2426 | 33 |
1537083 | 1537083 | 2021-07-20 | Stevens | Washington | 53065 | 2426 | 32 |
1506710 | 1506710 | 2021-07-11 | Greene | North Carolina | 37079 | 2426 | 47 |
1507819 | 1507819 | 2021-07-11 | Waynesboro city | Virginia | 51820 | 2426 | 38 |
1503464 | 1503464 | 2021-07-10 | Greene | North Carolina | 37079 | 2426 | 47 |
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);