ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
384 rows where cases = 1294 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 35
- Iowa 32
- Mississippi 20
- Oklahoma 20
- Virginia 20
- Georgia 19
- Kentucky 19
- Puerto Rico 14
- California 13
- Kansas 12
- Alabama 11
- North Dakota 11
- Ohio 11
- South Carolina 11
- North Carolina 10
- West Virginia 10
- Illinois 9
- Michigan 9
- Missouri 9
- Arkansas 8
- Utah 8
- Wisconsin 8
- South Dakota 7
- Oregon 6
- Colorado 5
- Florida 5
- Idaho 5
- Washington 5
- Indiana 4
- Minnesota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426857 | 2426857 | 2022-04-20 | Greer | Oklahoma | 40055 | 1294 | 36 |
2423601 | 2423601 | 2022-04-19 | Greer | Oklahoma | 40055 | 1294 | 36 |
2420344 | 2420344 | 2022-04-18 | Greer | Oklahoma | 40055 | 1294 | 36 |
2417089 | 2417089 | 2022-04-17 | Greer | Oklahoma | 40055 | 1294 | 36 |
2413833 | 2413833 | 2022-04-16 | Greer | Oklahoma | 40055 | 1294 | 36 |
2410577 | 2410577 | 2022-04-15 | Greer | Oklahoma | 40055 | 1294 | 36 |
2407321 | 2407321 | 2022-04-14 | Greer | Oklahoma | 40055 | 1294 | 36 |
2404071 | 2404071 | 2022-04-13 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2400816 | 2400816 | 2022-04-12 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2397561 | 2397561 | 2022-04-11 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2394306 | 2394306 | 2022-04-10 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2391050 | 2391050 | 2022-04-09 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2387794 | 2387794 | 2022-04-08 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2384539 | 2384539 | 2022-04-07 | Jefferson | Oklahoma | 40067 | 1294 | 28 |
2333697 | 2333697 | 2022-03-23 | Lafayette | Arkansas | 5073 | 1294 | 31 |
2330443 | 2330443 | 2022-03-22 | Lafayette | Arkansas | 5073 | 1294 | 31 |
2286792 | 2286792 | 2022-03-08 | McHenry | North Dakota | 38049 | 1294 | 31 |
2283540 | 2283540 | 2022-03-07 | McHenry | North Dakota | 38049 | 1294 | 31 |
2218983 | 2218983 | 2022-02-15 | Kingsbury | South Dakota | 46077 | 1294 | 20 |
2215758 | 2215758 | 2022-02-14 | Walworth | South Dakota | 46129 | 1294 | 23 |
2163563 | 2163563 | 2022-01-29 | Maunabo | Puerto Rico | 72095 | 1294 | |
2144180 | 2144180 | 2022-01-23 | Spink | South Dakota | 46115 | 1294 | 32 |
2140925 | 2140925 | 2022-01-22 | Spink | South Dakota | 46115 | 1294 | 32 |
2137669 | 2137669 | 2022-01-21 | Spink | South Dakota | 46115 | 1294 | 32 |
2132381 | 2132381 | 2022-01-20 | Marion | Georgia | 13197 | 1294 | 43 |
2130653 | 2130653 | 2022-01-19 | Bottineau | North Dakota | 38009 | 1294 | 24 |
2119043 | 2119043 | 2022-01-16 | Montgomery | Arkansas | 5097 | 1294 | 53 |
2115040 | 2115040 | 2022-01-14 | Carson | Texas | 48065 | 1294 | 30 |
2089249 | 2089249 | 2022-01-06 | Beaver | Utah | 49001 | 1294 | 14 |
2080143 | 2080143 | 2022-01-04 | Kit Carson | Colorado | 8063 | 1294 | 27 |
2080326 | 2080326 | 2022-01-04 | Hancock | Georgia | 13141 | 1294 | 83 |
2080738 | 2080738 | 2022-01-04 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2077104 | 2077104 | 2022-01-03 | Miller | Georgia | 13201 | 1294 | 24 |
2077486 | 2077486 | 2022-01-03 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2073853 | 2073853 | 2022-01-02 | Miller | Georgia | 13201 | 1294 | 24 |
2074235 | 2074235 | 2022-01-02 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2070602 | 2070602 | 2022-01-01 | Miller | Georgia | 13201 | 1294 | 24 |
2070984 | 2070984 | 2022-01-01 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2067351 | 2067351 | 2021-12-31 | Miller | Georgia | 13201 | 1294 | 24 |
2067733 | 2067733 | 2021-12-31 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2064482 | 2064482 | 2021-12-30 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2061232 | 2061232 | 2021-12-29 | Pocahontas | Iowa | 19151 | 1294 | 25 |
2055296 | 2055296 | 2021-12-27 | Franklin | Mississippi | 28037 | 1294 | 32 |
2055782 | 2055782 | 2021-12-27 | Camden | North Carolina | 37029 | 1294 | 9 |
2052532 | 2052532 | 2021-12-26 | Camden | North Carolina | 37029 | 1294 | 9 |
2049282 | 2049282 | 2021-12-25 | Camden | North Carolina | 37029 | 1294 | 9 |
2046032 | 2046032 | 2021-12-24 | Camden | North Carolina | 37029 | 1294 | 9 |
2042782 | 2042782 | 2021-12-23 | Camden | North Carolina | 37029 | 1294 | 9 |
2039533 | 2039533 | 2021-12-22 | Camden | North Carolina | 37029 | 1294 | 9 |
2040000 | 2040000 | 2021-12-22 | Orocovis | Puerto Rico | 72107 | 1294 | |
2033953 | 2033953 | 2021-12-20 | Stephens | Texas | 48429 | 1294 | 37 |
2030703 | 2030703 | 2021-12-19 | Stephens | Texas | 48429 | 1294 | 37 |
2026990 | 2026990 | 2021-12-18 | Luquillo | Puerto Rico | 72089 | 1294 | |
2027452 | 2027452 | 2021-12-18 | Stephens | Texas | 48429 | 1294 | 37 |
2006198 | 2006198 | 2021-12-12 | Nicholas | Kentucky | 21181 | 1294 | 27 |
2008183 | 2008183 | 2021-12-12 | Jefferson | Washington | 53031 | 1294 | 20 |
2002947 | 2002947 | 2021-12-11 | Nicholas | Kentucky | 21181 | 1294 | 27 |
2004932 | 2004932 | 2021-12-11 | Jefferson | Washington | 53031 | 1294 | 20 |
1999697 | 1999697 | 2021-12-10 | Nicholas | Kentucky | 21181 | 1294 | 27 |
2001681 | 2001681 | 2021-12-10 | Jefferson | Washington | 53031 | 1294 | 20 |
1995656 | 1995656 | 2021-12-09 | San Miguel | Colorado | 8113 | 1294 | 5 |
1998358 | 1998358 | 2021-12-09 | Manassas Park city | Virginia | 51685 | 1294 | 15 |
1995107 | 1995107 | 2021-12-08 | Manassas Park city | Virginia | 51685 | 1294 | 14 |
1991856 | 1991856 | 2021-12-07 | Manassas Park city | Virginia | 51685 | 1294 | 14 |
1963398 | 1963398 | 2021-11-29 | Wilcox | Georgia | 13315 | 1294 | 60 |
1962802 | 1962802 | 2021-11-28 | Pepin | Wisconsin | 55091 | 1294 | 10 |
1959551 | 1959551 | 2021-11-27 | Pepin | Wisconsin | 55091 | 1294 | 10 |
1956300 | 1956300 | 2021-11-26 | Pepin | Wisconsin | 55091 | 1294 | 10 |
1943892 | 1943892 | 2021-11-23 | Wilcox | Georgia | 13315 | 1294 | 60 |
1928122 | 1928122 | 2021-11-18 | Crittenden | Kentucky | 21055 | 1294 | 35 |
1930057 | 1930057 | 2021-11-18 | Essex | Virginia | 51057 | 1294 | 20 |
1917375 | 1917375 | 2021-11-15 | Greene | Alabama | 1063 | 1294 | 45 |
1914125 | 1914125 | 2021-11-14 | Greene | Alabama | 1063 | 1294 | 45 |
1910875 | 1910875 | 2021-11-13 | Greene | Alabama | 1063 | 1294 | 45 |
1904203 | 1904203 | 2021-11-10 | Clay | West Virginia | 54015 | 1294 | 20 |
1883132 | 1883132 | 2021-11-04 | Gentry | Missouri | 29075 | 1294 | 27 |
1876741 | 1876741 | 2021-11-02 | Madison | Montana | 30057 | 1294 | 11 |
1873492 | 1873492 | 2021-11-01 | Madison | Montana | 30057 | 1294 | 11 |
1860146 | 1860146 | 2021-10-28 | Mackinac | Michigan | 26097 | 1294 | 11 |
1856897 | 1856897 | 2021-10-27 | Mackinac | Michigan | 26097 | 1294 | 11 |
1854410 | 1854410 | 2021-10-26 | Traill | North Dakota | 38097 | 1294 | 20 |
1826643 | 1826643 | 2021-10-18 | Lincoln | Colorado | 8073 | 1294 | 8 |
1829020 | 1829020 | 2021-10-18 | Castro | Texas | 48069 | 1294 | 35 |
1825771 | 1825771 | 2021-10-17 | Castro | Texas | 48069 | 1294 | 35 |
1822522 | 1822522 | 2021-10-16 | Castro | Texas | 48069 | 1294 | 34 |
1816005 | 1816005 | 2021-10-14 | Blanco | Texas | 48031 | 1294 | 28 |
1806700 | 1806700 | 2021-10-11 | Lincoln | Washington | 53043 | 1294 | 18 |
1766052 | 1766052 | 2021-09-29 | Choctaw | Mississippi | 28019 | 1294 | 26 |
1767595 | 1767595 | 2021-09-29 | Floyd | Virginia | 51063 | 1294 | 24 |
1760580 | 1760580 | 2021-09-27 | McCormick | South Carolina | 45065 | 1294 | 29 |
1721544 | 1721544 | 2021-09-15 | Utuado | Puerto Rico | 72141 | 1294 | |
1718296 | 1718296 | 2021-09-14 | Utuado | Puerto Rico | 72141 | 1294 | |
1718555 | 1718555 | 2021-09-14 | Clay | Texas | 48077 | 1294 | 20 |
1718803 | 1718803 | 2021-09-14 | Caledonia | Vermont | 50005 | 1294 | 9 |
1713357 | 1713357 | 2021-09-13 | Brown | Indiana | 18013 | 1294 | 45 |
1700233 | 1700233 | 2021-09-09 | Fremont | Idaho | 16043 | 1294 | 14 |
1693210 | 1693210 | 2021-09-07 | Perry | Alabama | 1105 | 1294 | 30 |
1674155 | 1674155 | 2021-09-01 | Montgomery | Georgia | 13209 | 1294 | 25 |
1667716 | 1667716 | 2021-08-30 | Wilkinson | Georgia | 13319 | 1294 | 28 |
1669165 | 1669165 | 2021-08-30 | Washington | North Carolina | 37187 | 1294 | 32 |
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);