ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where cases = 2422 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Virginia 18
- Kansas 14
- Illinois 13
- Minnesota 9
- Missouri 9
- Puerto Rico 9
- Georgia 8
- Montana 8
- Tennessee 8
- West Virginia 8
- Kentucky 7
- Mississippi 7
- Ohio 7
- Indiana 6
- South Dakota 6
- Alabama 5
- North Carolina 4
- Arizona 3
- Arkansas 3
- California 3
- Colorado 3
- New Mexico 3
- New York 3
- South Carolina 3
- Washington 3
- Maryland 2
- Michigan 2
- Oregon 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491562 | 2491562 | 2022-05-10 | Unknown | Nebraska | 2422 | 460 | |
2470861 | 2470861 | 2022-05-04 | Brown | Illinois | 17009 | 2422 | 21 |
2467605 | 2467605 | 2022-05-03 | Brown | Illinois | 17009 | 2422 | 21 |
2451633 | 2451633 | 2022-04-28 | Coffey | Kansas | 20031 | 2422 | 42 |
2448377 | 2448377 | 2022-04-27 | Coffey | Kansas | 20031 | 2422 | 42 |
2445121 | 2445121 | 2022-04-26 | Coffey | Kansas | 20031 | 2422 | 42 |
2441865 | 2441865 | 2022-04-25 | Coffey | Kansas | 20031 | 2422 | 42 |
2438609 | 2438609 | 2022-04-24 | Coffey | Kansas | 20031 | 2422 | 42 |
2440751 | 2440751 | 2022-04-24 | Sussex | Virginia | 51183 | 2422 | 41 |
2435353 | 2435353 | 2022-04-23 | Coffey | Kansas | 20031 | 2422 | 42 |
2437495 | 2437495 | 2022-04-23 | Sussex | Virginia | 51183 | 2422 | 41 |
2432097 | 2432097 | 2022-04-22 | Coffey | Kansas | 20031 | 2422 | 42 |
2434239 | 2434239 | 2022-04-22 | Sussex | Virginia | 51183 | 2422 | 41 |
2427482 | 2427482 | 2022-04-20 | Ochiltree | Texas | 48357 | 2422 | 48 |
2427727 | 2427727 | 2022-04-20 | Sussex | Virginia | 51183 | 2422 | 41 |
2401680 | 2401680 | 2022-04-12 | Sussex | Virginia | 51183 | 2422 | 41 |
2398425 | 2398425 | 2022-04-11 | Sussex | Virginia | 51183 | 2422 | 41 |
2378893 | 2378893 | 2022-04-05 | Sussex | Virginia | 51183 | 2422 | 40 |
2375639 | 2375639 | 2022-04-04 | Sussex | Virginia | 51183 | 2422 | 40 |
2372387 | 2372387 | 2022-04-03 | Sussex | Virginia | 51183 | 2422 | 40 |
2369134 | 2369134 | 2022-04-02 | Sussex | Virginia | 51183 | 2422 | 40 |
2365881 | 2365881 | 2022-04-01 | Sussex | Virginia | 51183 | 2422 | 40 |
2362628 | 2362628 | 2022-03-31 | Sussex | Virginia | 51183 | 2422 | 40 |
2332817 | 2332817 | 2022-03-22 | Roberts | South Dakota | 46109 | 2422 | 52 |
2329564 | 2329564 | 2022-03-21 | Roberts | South Dakota | 46109 | 2422 | 52 |
2326312 | 2326312 | 2022-03-20 | Roberts | South Dakota | 46109 | 2422 | 52 |
2323059 | 2323059 | 2022-03-19 | Roberts | South Dakota | 46109 | 2422 | 52 |
2319805 | 2319805 | 2022-03-18 | Roberts | South Dakota | 46109 | 2422 | 52 |
2317175 | 2317175 | 2022-03-17 | Ritchie | West Virginia | 54085 | 2422 | 31 |
2260330 | 2260330 | 2022-02-28 | Ralls | Missouri | 29173 | 2422 | 24 |
2244115 | 2244115 | 2022-02-23 | Deer Lodge | Montana | 30023 | 2422 | 29 |
2242092 | 2242092 | 2022-02-22 | Trinity | Texas | 48455 | 2422 | 70 |
2209105 | 2209105 | 2022-02-12 | Luquillo | Puerto Rico | 72089 | 2422 | |
2198031 | 2198031 | 2022-02-09 | Lee | Kentucky | 21129 | 2422 | 45 |
2199764 | 2199764 | 2022-02-09 | Morris | Texas | 48343 | 2422 | 64 |
2146732 | 2146732 | 2022-01-24 | Colfax | New Mexico | 35007 | 2422 | 58 |
2141837 | 2141837 | 2022-01-23 | Stone | Arkansas | 5137 | 2422 | 51 |
2120892 | 2120892 | 2022-01-16 | Barnes | North Dakota | 38003 | 2422 | 41 |
2103966 | 2103966 | 2022-01-11 | Chippewa | Minnesota | 27023 | 2422 | 43 |
2080448 | 2080448 | 2022-01-04 | Idaho | Idaho | 16049 | 2422 | 42 |
2063032 | 2063032 | 2021-12-29 | Comanche | Texas | 48093 | 2422 | 67 |
2052235 | 2052235 | 2021-12-26 | Custer | Montana | 30017 | 2422 | 41 |
2048985 | 2048985 | 2021-12-25 | Custer | Montana | 30017 | 2422 | 41 |
2045735 | 2045735 | 2021-12-24 | Custer | Montana | 30017 | 2422 | 41 |
2042485 | 2042485 | 2021-12-23 | Custer | Montana | 30017 | 2422 | 41 |
2039236 | 2039236 | 2021-12-22 | Custer | Montana | 30017 | 2422 | 41 |
2035986 | 2035986 | 2021-12-21 | Custer | Montana | 30017 | 2422 | 41 |
2029206 | 2029206 | 2021-12-19 | Cottonwood | Minnesota | 27033 | 2422 | 33 |
2029789 | 2029789 | 2021-12-19 | Chowan | North Carolina | 37041 | 2422 | 44 |
2025955 | 2025955 | 2021-12-18 | Cottonwood | Minnesota | 27033 | 2422 | 33 |
2026538 | 2026538 | 2021-12-18 | Chowan | North Carolina | 37041 | 2422 | 44 |
2022704 | 2022704 | 2021-12-17 | Cottonwood | Minnesota | 27033 | 2422 | 33 |
2023287 | 2023287 | 2021-12-17 | Chowan | North Carolina | 37041 | 2422 | 44 |
1994490 | 1994490 | 2021-12-08 | Naranjito | Puerto Rico | 72105 | 2422 | |
1990054 | 1990054 | 2021-12-07 | Washington | Maine | 23029 | 2422 | 35 |
1978955 | 1978955 | 2021-12-03 | Braxton | West Virginia | 54007 | 2422 | 25 |
1967137 | 1967137 | 2021-11-30 | Estill | Kentucky | 21065 | 2422 | 21 |
1965964 | 1965964 | 2021-11-29 | Grant | West Virginia | 54023 | 2422 | 37 |
1898104 | 1898104 | 2021-11-09 | Crowley | Colorado | 8025 | 2422 | 24 |
1875142 | 1875142 | 2021-11-02 | Macon | Alabama | 1087 | 2422 | 63 |
1869500 | 1869500 | 2021-10-31 | Atchison | Kansas | 20005 | 2422 | 25 |
1866251 | 1866251 | 2021-10-30 | Atchison | Kansas | 20005 | 2422 | 25 |
1863002 | 1863002 | 2021-10-29 | Atchison | Kansas | 20005 | 2422 | 25 |
1854738 | 1854738 | 2021-10-26 | Moca | Puerto Rico | 72099 | 2422 | |
1854905 | 1854905 | 2021-10-26 | Decatur | Tennessee | 47039 | 2422 | 44 |
1851489 | 1851489 | 2021-10-25 | Moca | Puerto Rico | 72099 | 2422 | |
1848239 | 1848239 | 2021-10-24 | Moca | Puerto Rico | 72099 | 2422 | |
1842748 | 1842748 | 2021-10-23 | Howard | Arkansas | 5061 | 2422 | 35 |
1841999 | 1841999 | 2021-10-22 | Bosque | Texas | 48035 | 2422 | 55 |
1823740 | 1823740 | 2021-10-17 | Ford | Illinois | 17053 | 2422 | 67 |
1820491 | 1820491 | 2021-10-16 | Ford | Illinois | 17053 | 2422 | 67 |
1817242 | 1817242 | 2021-10-15 | Ford | Illinois | 17053 | 2422 | 67 |
1814062 | 1814062 | 2021-10-14 | Warren | Illinois | 17187 | 2422 | 68 |
1807937 | 1807937 | 2021-10-12 | Lewis | Kentucky | 21135 | 2422 | 55 |
1793399 | 1793399 | 2021-10-07 | Madison | Texas | 48313 | 2422 | 42 |
1787456 | 1787456 | 2021-10-06 | North Slope Borough | Alaska | 2185 | 2422 | 5 |
1789486 | 1789486 | 2021-10-06 | Meigs | Ohio | 39105 | 2422 | 45 |
1755496 | 1755496 | 2021-09-26 | Clay | Illinois | 17025 | 2422 | 52 |
1752248 | 1752248 | 2021-09-25 | Clay | Illinois | 17025 | 2422 | 52 |
1748999 | 1748999 | 2021-09-24 | Clay | Illinois | 17025 | 2422 | 52 |
1744010 | 1744010 | 2021-09-22 | Paulding | Ohio | 39125 | 2422 | 43 |
1736735 | 1736735 | 2021-09-20 | Dodge | Minnesota | 27039 | 2422 | 4 |
1737913 | 1737913 | 2021-09-20 | Union | South Dakota | 46127 | 2422 | 43 |
1738016 | 1738016 | 2021-09-20 | Aransas | Texas | 48007 | 2422 | 54 |
1732742 | 1732742 | 2021-09-19 | Bond | Illinois | 17005 | 2422 | 29 |
1734766 | 1734766 | 2021-09-19 | Aransas | Texas | 48007 | 2422 | 54 |
1729492 | 1729492 | 2021-09-18 | Bond | Illinois | 17005 | 2422 | 29 |
1731256 | 1731256 | 2021-09-18 | Isabela | Puerto Rico | 72071 | 2422 | |
1726242 | 1726242 | 2021-09-17 | Bond | Illinois | 17005 | 2422 | 29 |
1727530 | 1727530 | 2021-09-17 | Seneca | New York | 36099 | 2422 | 58 |
1722453 | 1722453 | 2021-09-16 | Washington | Alabama | 1129 | 2422 | 44 |
1723869 | 1723869 | 2021-09-16 | Smith | Mississippi | 28129 | 2422 | 46 |
1717462 | 1717462 | 2021-09-14 | Morgan | Missouri | 29141 | 2422 | 57 |
1669959 | 1669959 | 2021-08-30 | Montague | Texas | 48337 | 2422 | 75 |
1665477 | 1665477 | 2021-08-29 | Livingston | Missouri | 29117 | 2422 | 56 |
1666712 | 1666712 | 2021-08-29 | Montague | Texas | 48337 | 2422 | 75 |
1663464 | 1663464 | 2021-08-28 | Montague | Texas | 48337 | 2422 | 75 |
1663824 | 1663824 | 2021-08-28 | Wyoming | West Virginia | 54109 | 2422 | 41 |
1660216 | 1660216 | 2021-08-27 | Montague | Texas | 48337 | 2422 | 74 |
1660576 | 1660576 | 2021-08-27 | Wyoming | West Virginia | 54109 | 2422 | 41 |
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);