ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
424 rows where cases = 1242 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 60
- Georgia 27
- Michigan 22
- Montana 21
- Virginia 20
- Kentucky 17
- Alabama 16
- Nebraska 16
- Oklahoma 16
- South Dakota 16
- Colorado 14
- Mississippi 14
- Kansas 11
- Missouri 11
- Minnesota 10
- Iowa 9
- Puerto Rico 9
- Illinois 8
- Indiana 8
- North Carolina 8
- North Dakota 8
- Alaska 7
- California 7
- Ohio 7
- Arkansas 6
- West Virginia 6
- Washington 5
- Wisconsin 5
- Idaho 4
- Louisiana 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502413 | 2502413 | 2022-05-13 | San Saba | Texas | 48411 | 1242 | 35 |
2499155 | 2499155 | 2022-05-12 | San Saba | Texas | 48411 | 1242 | 35 |
2495897 | 2495897 | 2022-05-11 | San Saba | Texas | 48411 | 1242 | 35 |
2424249 | 2424249 | 2022-04-19 | Sabine | Texas | 48403 | 1242 | 89 |
2420993 | 2420993 | 2022-04-18 | Sabine | Texas | 48403 | 1242 | 89 |
2417737 | 2417737 | 2022-04-17 | Sabine | Texas | 48403 | 1242 | 89 |
2414481 | 2414481 | 2022-04-16 | Sabine | Texas | 48403 | 1242 | 89 |
2411225 | 2411225 | 2022-04-15 | Sabine | Texas | 48403 | 1242 | 89 |
2407969 | 2407969 | 2022-04-14 | Sabine | Texas | 48403 | 1242 | 89 |
2404713 | 2404713 | 2022-04-13 | Sabine | Texas | 48403 | 1242 | 89 |
2400360 | 2400360 | 2022-04-12 | Morrill | Nebraska | 31123 | 1242 | 18 |
2401458 | 2401458 | 2022-04-12 | Sabine | Texas | 48403 | 1242 | 88 |
2397105 | 2397105 | 2022-04-11 | Morrill | Nebraska | 31123 | 1242 | 18 |
2398203 | 2398203 | 2022-04-11 | Sabine | Texas | 48403 | 1242 | 88 |
2393850 | 2393850 | 2022-04-10 | Morrill | Nebraska | 31123 | 1242 | 18 |
2394948 | 2394948 | 2022-04-10 | Sabine | Texas | 48403 | 1242 | 88 |
2390594 | 2390594 | 2022-04-09 | Morrill | Nebraska | 31123 | 1242 | 18 |
2387338 | 2387338 | 2022-04-08 | Morrill | Nebraska | 31123 | 1242 | 18 |
2384083 | 2384083 | 2022-04-07 | Morrill | Nebraska | 31123 | 1242 | 18 |
2380828 | 2380828 | 2022-04-06 | Morrill | Nebraska | 31123 | 1242 | 18 |
2377573 | 2377573 | 2022-04-05 | Morrill | Nebraska | 31123 | 1242 | 18 |
2374320 | 2374320 | 2022-04-04 | Morrill | Nebraska | 31123 | 1242 | 18 |
2375466 | 2375466 | 2022-04-04 | Yoakum | Texas | 48501 | 1242 | 41 |
2371068 | 2371068 | 2022-04-03 | Morrill | Nebraska | 31123 | 1242 | 18 |
2372214 | 2372214 | 2022-04-03 | Yoakum | Texas | 48501 | 1242 | 41 |
2367815 | 2367815 | 2022-04-02 | Morrill | Nebraska | 31123 | 1242 | 18 |
2368961 | 2368961 | 2022-04-02 | Yoakum | Texas | 48501 | 1242 | 41 |
2364562 | 2364562 | 2022-04-01 | Morrill | Nebraska | 31123 | 1242 | 18 |
2365708 | 2365708 | 2022-04-01 | Yoakum | Texas | 48501 | 1242 | 41 |
2361308 | 2361308 | 2022-03-31 | Morrill | Nebraska | 31123 | 1242 | 18 |
2338537 | 2338537 | 2022-03-24 | Morrill | Nebraska | 31123 | 1242 | 18 |
2310237 | 2310237 | 2022-03-15 | Garza | Texas | 48169 | 1242 | 27 |
2260362 | 2260362 | 2022-02-28 | Broadwater | Montana | 30007 | 1242 | 18 |
2257111 | 2257111 | 2022-02-27 | Broadwater | Montana | 30007 | 1242 | 18 |
2253860 | 2253860 | 2022-02-26 | Broadwater | Montana | 30007 | 1242 | 18 |
2250609 | 2250609 | 2022-02-25 | Broadwater | Montana | 30007 | 1242 | 18 |
2209512 | 2209512 | 2022-02-12 | McCulloch | Texas | 48307 | 1242 | 44 |
2202898 | 2202898 | 2022-02-10 | Crane | Texas | 48103 | 1242 | 21 |
2182729 | 2182729 | 2022-02-04 | McHenry | North Dakota | 38049 | 1242 | 30 |
2159973 | 2159973 | 2022-01-28 | Sioux | North Dakota | 38085 | 1242 | 19 |
2151656 | 2151656 | 2022-01-26 | Trinity | California | 6105 | 1242 | 19 |
2140786 | 2140786 | 2022-01-22 | Maunabo | Puerto Rico | 72095 | 1242 | |
2123824 | 2123824 | 2022-01-17 | Clay | Nebraska | 31035 | 1242 | 17 |
2113977 | 2113977 | 2022-01-14 | Shelby | Missouri | 29205 | 1242 | 13 |
2102786 | 2102786 | 2022-01-11 | Montgomery | Arkansas | 5097 | 1242 | 53 |
2053021 | 2053021 | 2021-12-26 | Villalba | Puerto Rico | 72149 | 1242 | |
2041142 | 2041142 | 2021-12-23 | Lake | Colorado | 8065 | 1242 | 2 |
2034640 | 2034640 | 2021-12-21 | Kit Carson | Colorado | 8063 | 1242 | 25 |
2031593 | 2031593 | 2021-12-20 | Lincoln | Georgia | 13181 | 1242 | 33 |
2006518 | 2006518 | 2021-12-12 | Wilkin | Minnesota | 27167 | 1242 | 16 |
2003267 | 2003267 | 2021-12-11 | Wilkin | Minnesota | 27167 | 1242 | 16 |
2000017 | 2000017 | 2021-12-10 | Wilkin | Minnesota | 27167 | 1242 | 16 |
1952863 | 1952863 | 2021-11-25 | Northumberland | Virginia | 51133 | 1242 | 36 |
1941108 | 1941108 | 2021-11-22 | Bracken | Kentucky | 21023 | 1242 | 13 |
1941187 | 1941187 | 2021-11-22 | Nicholas | Kentucky | 21181 | 1242 | 22 |
1937965 | 1937965 | 2021-11-21 | Wolfe | Kentucky | 21237 | 1242 | 12 |
1934715 | 1934715 | 2021-11-20 | Wolfe | Kentucky | 21237 | 1242 | 12 |
1931464 | 1931464 | 2021-11-19 | Wolfe | Kentucky | 21237 | 1242 | 12 |
1927618 | 1927618 | 2021-11-18 | Terrell | Georgia | 13273 | 1242 | 57 |
1924368 | 1924368 | 2021-11-17 | Terrell | Georgia | 13273 | 1242 | 57 |
1917869 | 1917869 | 2021-11-15 | Terrell | Georgia | 13273 | 1242 | 57 |
1903777 | 1903777 | 2021-11-10 | Dallam | Texas | 48111 | 1242 | 30 |
1903972 | 1903972 | 2021-11-10 | Yoakum | Texas | 48501 | 1242 | 33 |
1900527 | 1900527 | 2021-11-09 | Dallam | Texas | 48111 | 1242 | 30 |
1900722 | 1900722 | 2021-11-09 | Yoakum | Texas | 48501 | 1242 | 33 |
1897472 | 1897472 | 2021-11-08 | Yoakum | Texas | 48501 | 1242 | 33 |
1894222 | 1894222 | 2021-11-07 | Yoakum | Texas | 48501 | 1242 | 33 |
1890972 | 1890972 | 2021-11-06 | Yoakum | Texas | 48501 | 1242 | 33 |
1887722 | 1887722 | 2021-11-05 | Yoakum | Texas | 48501 | 1242 | 33 |
1884472 | 1884472 | 2021-11-04 | Yoakum | Texas | 48501 | 1242 | 32 |
1878878 | 1878878 | 2021-11-03 | Treutlen | Georgia | 13283 | 1242 | 53 |
1881223 | 1881223 | 2021-11-03 | Yoakum | Texas | 48501 | 1242 | 32 |
1875629 | 1875629 | 2021-11-02 | Treutlen | Georgia | 13283 | 1242 | 52 |
1872380 | 1872380 | 2021-11-01 | Treutlen | Georgia | 13283 | 1242 | 52 |
1869131 | 1869131 | 2021-10-31 | Treutlen | Georgia | 13283 | 1242 | 52 |
1865882 | 1865882 | 2021-10-30 | Treutlen | Georgia | 13283 | 1242 | 52 |
1862633 | 1862633 | 2021-10-29 | Treutlen | Georgia | 13283 | 1242 | 52 |
1859384 | 1859384 | 2021-10-28 | Treutlen | Georgia | 13283 | 1242 | 52 |
1855913 | 1855913 | 2021-10-27 | Yuma | Colorado | 8125 | 1242 | 18 |
1858222 | 1858222 | 2021-10-27 | Van Buren | Tennessee | 47175 | 1242 | 27 |
1858234 | 1858234 | 2021-10-27 | Archer | Texas | 48009 | 1242 | 19 |
1835776 | 1835776 | 2021-10-20 | Orange | Vermont | 50017 | 1242 | 5 |
1831012 | 1831012 | 2021-10-19 | Stevens | Minnesota | 27149 | 1242 | 11 |
1831987 | 1831987 | 2021-10-19 | Luquillo | Puerto Rico | 72089 | 1242 | |
1828738 | 1828738 | 2021-10-18 | Luquillo | Puerto Rico | 72089 | 1242 | |
1824375 | 1824375 | 2021-10-17 | Crawford | Michigan | 26039 | 1242 | 16 |
1821126 | 1821126 | 2021-10-16 | Crawford | Michigan | 26039 | 1242 | 16 |
1817877 | 1817877 | 2021-10-15 | Crawford | Michigan | 26039 | 1242 | 16 |
1815018 | 1815018 | 2021-10-14 | Powell | Montana | 30077 | 1242 | 14 |
1787665 | 1787665 | 2021-10-06 | Park | Colorado | 8093 | 1242 | 7 |
1789380 | 1789380 | 2021-10-06 | Benson | North Dakota | 38005 | 1242 | 20 |
1787146 | 1787146 | 2021-10-05 | Poquoson city | Virginia | 51735 | 1242 | 18 |
1778939 | 1778939 | 2021-10-03 | Presque Isle | Michigan | 26141 | 1242 | 35 |
1775689 | 1775689 | 2021-10-02 | Presque Isle | Michigan | 26141 | 1242 | 35 |
1772439 | 1772439 | 2021-10-01 | Presque Isle | Michigan | 26141 | 1242 | 35 |
1767960 | 1767960 | 2021-09-30 | Northwest Arctic Borough | Alaska | 2188 | 1242 | 4 |
1770516 | 1770516 | 2021-09-30 | Blanco | Texas | 48031 | 1242 | 27 |
1764331 | 1764331 | 2021-09-28 | Clarke | Virginia | 51043 | 1242 | 22 |
1759664 | 1759664 | 2021-09-27 | Gentry | Missouri | 29075 | 1242 | 24 |
1761015 | 1761015 | 2021-09-27 | Emery | Utah | 49015 | 1242 | 14 |
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);