ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
393 rows where cases = 1168 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 36
- Texas 23
- Kentucky 22
- Missouri 22
- Puerto Rico 22
- Louisiana 21
- Virginia 18
- Kansas 15
- Minnesota 15
- Iowa 14
- Illinois 13
- Tennessee 12
- Wyoming 10
- Alabama 9
- Arkansas 9
- Indiana 9
- New York 9
- North Carolina 9
- Oregon 9
- Mississippi 8
- Nebraska 8
- Oklahoma 8
- Idaho 7
- Michigan 7
- California 6
- Colorado 6
- Nevada 6
- Montana 5
- Alaska 4
- Ohio 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467512 | 2467512 | 2022-05-03 | Schley | Georgia | 13249 | 1168 | 11 |
2464257 | 2464257 | 2022-05-02 | Schley | Georgia | 13249 | 1168 | 11 |
2465397 | 2465397 | 2022-05-02 | Pondera | Montana | 30073 | 1168 | 8 |
2461001 | 2461001 | 2022-05-01 | Schley | Georgia | 13249 | 1168 | 11 |
2457745 | 2457745 | 2022-04-30 | Schley | Georgia | 13249 | 1168 | 11 |
2454489 | 2454489 | 2022-04-29 | Schley | Georgia | 13249 | 1168 | 11 |
2451233 | 2451233 | 2022-04-28 | Schley | Georgia | 13249 | 1168 | 11 |
2453675 | 2453675 | 2022-04-28 | Charles City | Virginia | 51036 | 1168 | 27 |
2447977 | 2447977 | 2022-04-27 | Schley | Georgia | 13249 | 1168 | 11 |
2444721 | 2444721 | 2022-04-26 | Schley | Georgia | 13249 | 1168 | 11 |
2441465 | 2441465 | 2022-04-25 | Schley | Georgia | 13249 | 1168 | 11 |
2438209 | 2438209 | 2022-04-24 | Schley | Georgia | 13249 | 1168 | 11 |
2434953 | 2434953 | 2022-04-23 | Schley | Georgia | 13249 | 1168 | 11 |
2431697 | 2431697 | 2022-04-22 | Schley | Georgia | 13249 | 1168 | 11 |
2428441 | 2428441 | 2022-04-21 | Schley | Georgia | 13249 | 1168 | 11 |
2430897 | 2430897 | 2022-04-21 | Emporia city | Virginia | 51595 | 1168 | 55 |
2425185 | 2425185 | 2022-04-20 | Schley | Georgia | 13249 | 1168 | 11 |
2427641 | 2427641 | 2022-04-20 | Emporia city | Virginia | 51595 | 1168 | 55 |
2355938 | 2355938 | 2022-03-29 | Wheeler | Texas | 48483 | 1168 | 23 |
2294048 | 2294048 | 2022-03-10 | Martin | Texas | 48317 | 1168 | 26 |
2290796 | 2290796 | 2022-03-09 | Martin | Texas | 48317 | 1168 | 26 |
2188922 | 2188922 | 2022-02-06 | Jefferson | Nebraska | 31095 | 1168 | 6 |
2185669 | 2185669 | 2022-02-05 | Jefferson | Nebraska | 31095 | 1168 | 6 |
2182417 | 2182417 | 2022-02-04 | Jefferson | Nebraska | 31095 | 1168 | 6 |
2170368 | 2170368 | 2022-01-31 | Crane | Texas | 48103 | 1168 | 20 |
2148768 | 2148768 | 2022-01-25 | Alexander | Illinois | 17003 | 1168 | 13 |
2141897 | 2141897 | 2022-01-23 | Trinity | California | 6105 | 1168 | 19 |
2143908 | 2143908 | 2022-01-23 | Lake | Oregon | 41037 | 1168 | 23 |
2138642 | 2138642 | 2022-01-22 | Trinity | California | 6105 | 1168 | 19 |
2140653 | 2140653 | 2022-01-22 | Lake | Oregon | 41037 | 1168 | 23 |
2135386 | 2135386 | 2022-01-21 | Trinity | California | 6105 | 1168 | 19 |
2137397 | 2137397 | 2022-01-21 | Lake | Oregon | 41037 | 1168 | 23 |
2130168 | 2130168 | 2022-01-19 | Dade | Missouri | 29057 | 1168 | 38 |
2121236 | 2121236 | 2022-01-16 | Ceiba | Puerto Rico | 72037 | 1168 | |
2081559 | 2081559 | 2022-01-04 | Dawes | Nebraska | 31045 | 1168 | 21 |
2075961 | 2075961 | 2022-01-02 | Pickett | Tennessee | 47137 | 1168 | 28 |
2072710 | 2072710 | 2022-01-01 | Pickett | Tennessee | 47137 | 1168 | 28 |
2069459 | 2069459 | 2021-12-31 | Pickett | Tennessee | 47137 | 1168 | 28 |
2064143 | 2064143 | 2021-12-30 | Twiggs | Georgia | 13289 | 1168 | 62 |
2065970 | 2065970 | 2021-12-30 | Florida | Puerto Rico | 72054 | 1168 | |
2066208 | 2066208 | 2021-12-30 | Pickett | Tennessee | 47137 | 1168 | 28 |
2058422 | 2058422 | 2021-12-28 | Oscoda | Michigan | 26135 | 1168 | 50 |
2055173 | 2055173 | 2021-12-27 | Oscoda | Michigan | 26135 | 1168 | 50 |
2056800 | 2056800 | 2021-12-27 | Bland | Virginia | 51021 | 1168 | 18 |
2052127 | 2052127 | 2021-12-26 | Carter | Missouri | 29035 | 1168 | 18 |
2048877 | 2048877 | 2021-12-25 | Carter | Missouri | 29035 | 1168 | 18 |
2045627 | 2045627 | 2021-12-24 | Carter | Missouri | 29035 | 1168 | 18 |
2042377 | 2042377 | 2021-12-23 | Carter | Missouri | 29035 | 1168 | 18 |
2039128 | 2039128 | 2021-12-22 | Carter | Missouri | 29035 | 1168 | 18 |
2040579 | 2040579 | 2021-12-22 | Fairfax city | Virginia | 51600 | 1168 | 36 |
2030969 | 2030969 | 2021-12-19 | Calhoun | West Virginia | 54013 | 1168 | 9 |
2008613 | 2008613 | 2021-12-13 | Conejos | Colorado | 8021 | 1168 | 43 |
2003866 | 2003866 | 2021-12-11 | Bottineau | North Dakota | 38009 | 1168 | 23 |
1991576 | 1991576 | 2021-12-07 | Hansford | Texas | 48195 | 1168 | 26 |
1988325 | 1988325 | 2021-12-06 | Hansford | Texas | 48195 | 1168 | 26 |
1981498 | 1981498 | 2021-12-04 | San German | Puerto Rico | 72125 | 1168 | |
1965348 | 1965348 | 2021-11-29 | Hutchinson | South Dakota | 46067 | 1168 | 28 |
1923669 | 1923669 | 2021-11-16 | Jefferson | Washington | 53031 | 1168 | 17 |
1918854 | 1918854 | 2021-11-15 | Caldwell | Missouri | 29025 | 1168 | 20 |
1910261 | 1910261 | 2021-11-12 | Coleman | Texas | 48083 | 1168 | 54 |
1907012 | 1907012 | 2021-11-11 | Coleman | Texas | 48083 | 1168 | 54 |
1907594 | 1907594 | 2021-11-11 | Weston | Wyoming | 56045 | 1168 | 10 |
1904345 | 1904345 | 2021-11-10 | Weston | Wyoming | 56045 | 1168 | 10 |
1876343 | 1876343 | 2021-11-02 | Alcona | Michigan | 26001 | 1168 | 44 |
1873094 | 1873094 | 2021-11-01 | Alcona | Michigan | 26001 | 1168 | 44 |
1851808 | 1851808 | 2021-10-25 | Floyd | Texas | 48153 | 1168 | 38 |
1848558 | 1848558 | 2021-10-24 | Floyd | Texas | 48153 | 1168 | 38 |
1845308 | 1845308 | 2021-10-23 | Floyd | Texas | 48153 | 1168 | 38 |
1833020 | 1833020 | 2021-10-20 | Newton | Arkansas | 5101 | 1168 | 37 |
1824225 | 1824225 | 2021-10-17 | Trimble | Kentucky | 21223 | 1168 | 14 |
1820976 | 1820976 | 2021-10-16 | Trimble | Kentucky | 21223 | 1168 | 14 |
1817727 | 1817727 | 2021-10-15 | Trimble | Kentucky | 21223 | 1168 | 14 |
1813846 | 1813846 | 2021-10-14 | Lincoln | Georgia | 13181 | 1168 | 32 |
1765417 | 1765417 | 2021-09-29 | Warren | Indiana | 18171 | 1168 | 18 |
1765969 | 1765969 | 2021-09-29 | Clearwater | Minnesota | 27029 | 1168 | 18 |
1766967 | 1766967 | 2021-09-29 | Barceloneta | Puerto Rico | 72017 | 1168 | |
1761536 | 1761536 | 2021-09-28 | Monroe | Arkansas | 5095 | 1168 | 21 |
1761903 | 1761903 | 2021-09-28 | Terrell | Georgia | 13273 | 1168 | 55 |
1736923 | 1736923 | 2021-09-20 | Gentry | Missouri | 29075 | 1168 | 23 |
1728782 | 1728782 | 2021-09-17 | Summers | West Virginia | 54089 | 1168 | 27 |
1723792 | 1723792 | 2021-09-16 | Swift | Minnesota | 27151 | 1168 | 19 |
1725636 | 1725636 | 2021-09-16 | Washakie | Wyoming | 56043 | 1168 | 27 |
1719422 | 1719422 | 2021-09-15 | Lincoln | Colorado | 8073 | 1168 | 6 |
1721958 | 1721958 | 2021-09-15 | Red River | Texas | 48387 | 1168 | 43 |
1713169 | 1713169 | 2021-09-13 | Taylor | Georgia | 13269 | 1168 | 26 |
1694190 | 1694190 | 2021-09-07 | Elliott | Kentucky | 21063 | 1168 | 2 |
1671987 | 1671987 | 2021-08-31 | Oregon | Missouri | 29149 | 1168 | 7 |
1669093 | 1669093 | 2021-08-30 | Clay | North Carolina | 37043 | 1168 | 20 |
1669585 | 1669585 | 2021-08-30 | Allendale | South Carolina | 45005 | 1168 | 15 |
1670054 | 1670054 | 2021-08-30 | Grand | Utah | 49019 | 1168 | 4 |
1660275 | 1660275 | 2021-08-27 | Trinity | Texas | 48455 | 1168 | 37 |
1648156 | 1648156 | 2021-08-24 | Lanier | Georgia | 13173 | 1168 | 14 |
1643568 | 1643568 | 2021-08-22 | Orocovis | Puerto Rico | 72107 | 1168 | |
1640318 | 1640318 | 2021-08-21 | Orocovis | Puerto Rico | 72107 | 1168 | |
1625023 | 1625023 | 2021-08-17 | North Slope Borough | Alaska | 2185 | 1168 | 4 |
1622713 | 1622713 | 2021-08-16 | Carroll | Kentucky | 21041 | 1168 | 21 |
1619541 | 1619541 | 2021-08-15 | Pendleton | Kentucky | 21191 | 1168 | 4 |
1616293 | 1616293 | 2021-08-14 | Pendleton | Kentucky | 21191 | 1168 | 4 |
1613044 | 1613044 | 2021-08-13 | Pendleton | Kentucky | 21191 | 1168 | 4 |
1609274 | 1609274 | 2021-08-12 | Clearwater | Idaho | 16035 | 1168 | 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);