ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
234 rows where cases = 2203 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 40
- Texas 24
- Georgia 18
- Missouri 16
- Kentucky 15
- Virginia 15
- Mississippi 13
- Illinois 10
- West Virginia 9
- Indiana 8
- Iowa 8
- Arizona 7
- Idaho 6
- North Carolina 6
- Michigan 5
- New York 5
- Pennsylvania 5
- Puerto Rico 5
- Tennessee 5
- Wisconsin 5
- Arkansas 4
- Colorado 4
- Nebraska 4
- Ohio 4
- Alabama 3
- Florida 3
- Maryland 3
- Oregon 3
- South Carolina 3
- Utah 3
- Minnesota 2
- Montana 2
- Oklahoma 2
- South Dakota 2
- California 1
- Louisiana 1
- Maine 1
- New Hampshire 1
- North Dakota 1
- Vermont 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485922 | 2485922 | 2022-05-08 | Archer | Texas | 48009 | 2203 | 28 |
2447361 | 2447361 | 2022-04-26 | Tyler | West Virginia | 54095 | 2203 | 32 |
2444105 | 2444105 | 2022-04-25 | Tyler | West Virginia | 54095 | 2203 | 31 |
2440849 | 2440849 | 2022-04-24 | Tyler | West Virginia | 54095 | 2203 | 31 |
2436809 | 2436809 | 2022-04-23 | Guayanilla | Puerto Rico | 72059 | 2203 | |
2437593 | 2437593 | 2022-04-23 | Tyler | West Virginia | 54095 | 2203 | 31 |
2434337 | 2434337 | 2022-04-22 | Tyler | West Virginia | 54095 | 2203 | 31 |
2431081 | 2431081 | 2022-04-21 | Tyler | West Virginia | 54095 | 2203 | 31 |
2424127 | 2424127 | 2022-04-19 | Franklin | Texas | 48159 | 2203 | 42 |
2376251 | 2376251 | 2022-04-05 | Candler | Georgia | 13043 | 2203 | 94 |
2372999 | 2372999 | 2022-04-04 | Candler | Georgia | 13043 | 2203 | 95 |
2354598 | 2354598 | 2022-03-29 | DeKalb | Missouri | 29063 | 2203 | 45 |
2351345 | 2351345 | 2022-03-28 | DeKalb | Missouri | 29063 | 2203 | 45 |
2348093 | 2348093 | 2022-03-27 | DeKalb | Missouri | 29063 | 2203 | 45 |
2344840 | 2344840 | 2022-03-26 | DeKalb | Missouri | 29063 | 2203 | 45 |
2341587 | 2341587 | 2022-03-25 | DeKalb | Missouri | 29063 | 2203 | 45 |
2339140 | 2339140 | 2022-03-24 | Adjuntas | Puerto Rico | 72001 | 2203 | |
2335886 | 2335886 | 2022-03-23 | Adjuntas | Puerto Rico | 72001 | 2203 | |
2331161 | 2331161 | 2022-03-22 | Montgomery | Iowa | 19137 | 2203 | 52 |
2331546 | 2331546 | 2022-03-22 | Baraga | Michigan | 26013 | 2203 | 54 |
2327606 | 2327606 | 2022-03-21 | Benewah | Idaho | 16009 | 2203 | 40 |
2327909 | 2327909 | 2022-03-21 | Montgomery | Iowa | 19137 | 2203 | 52 |
2328294 | 2328294 | 2022-03-21 | Baraga | Michigan | 26013 | 2203 | 54 |
2324656 | 2324656 | 2022-03-20 | Montgomery | Iowa | 19137 | 2203 | 52 |
2321402 | 2321402 | 2022-03-19 | Montgomery | Iowa | 19137 | 2203 | 52 |
2318148 | 2318148 | 2022-03-18 | Montgomery | Iowa | 19137 | 2203 | 52 |
2314895 | 2314895 | 2022-03-17 | Montgomery | Iowa | 19137 | 2203 | 52 |
2311642 | 2311642 | 2022-03-16 | Montgomery | Iowa | 19137 | 2203 | 52 |
2284862 | 2284862 | 2022-03-08 | Greenlee | Arizona | 4011 | 2203 | 32 |
2281610 | 2281610 | 2022-03-07 | Greenlee | Arizona | 4011 | 2203 | 32 |
2278357 | 2278357 | 2022-03-06 | Greenlee | Arizona | 4011 | 2203 | 32 |
2275104 | 2275104 | 2022-03-05 | Greenlee | Arizona | 4011 | 2203 | 32 |
2271851 | 2271851 | 2022-03-04 | Greenlee | Arizona | 4011 | 2203 | 32 |
2268599 | 2268599 | 2022-03-03 | Greenlee | Arizona | 4011 | 2203 | 32 |
2265346 | 2265346 | 2022-03-02 | Greenlee | Arizona | 4011 | 2203 | 32 |
2240752 | 2240752 | 2022-02-22 | Carroll | Missouri | 29033 | 2203 | 42 |
2218774 | 2218774 | 2022-02-15 | Forest | Pennsylvania | 42053 | 2203 | 34 |
2219446 | 2219446 | 2022-02-15 | Essex | Virginia | 51057 | 2203 | 24 |
2201622 | 2201622 | 2022-02-10 | Swift | Minnesota | 27151 | 2203 | 31 |
2187677 | 2187677 | 2022-02-06 | Johnson | Georgia | 13167 | 2203 | 66 |
2184424 | 2184424 | 2022-02-05 | Johnson | Georgia | 13167 | 2203 | 66 |
2181172 | 2181172 | 2022-02-04 | Johnson | Georgia | 13167 | 2203 | 66 |
2177996 | 2177996 | 2022-02-03 | Wilkes | Georgia | 13317 | 2203 | 43 |
2156227 | 2156227 | 2022-01-27 | Linn | Missouri | 29115 | 2203 | 59 |
2151905 | 2151905 | 2022-01-26 | McIntosh | Georgia | 13191 | 2203 | 35 |
2147416 | 2147416 | 2022-01-24 | Lake | South Dakota | 46079 | 2203 | 26 |
2142375 | 2142375 | 2022-01-23 | Crawford | Indiana | 18025 | 2203 | 33 |
2139120 | 2139120 | 2022-01-22 | Crawford | Indiana | 18025 | 2203 | 33 |
2135864 | 2135864 | 2022-01-21 | Crawford | Indiana | 18025 | 2203 | 33 |
2122777 | 2122777 | 2022-01-17 | Jasper | Illinois | 17079 | 2203 | 26 |
2119525 | 2119525 | 2022-01-16 | Jasper | Illinois | 17079 | 2203 | 26 |
2116273 | 2116273 | 2022-01-15 | Jasper | Illinois | 17079 | 2203 | 26 |
2113022 | 2113022 | 2022-01-14 | Jasper | Illinois | 17079 | 2203 | 26 |
2106638 | 2106638 | 2022-01-12 | Newton | Indiana | 18111 | 2203 | 61 |
2079532 | 2079532 | 2022-01-03 | Orange | Vermont | 50017 | 2203 | 9 |
2074834 | 2074834 | 2022-01-02 | Perry | Mississippi | 28111 | 2203 | 57 |
2071583 | 2071583 | 2022-01-01 | Perry | Mississippi | 28111 | 2203 | 57 |
2067012 | 2067012 | 2021-12-31 | Little River | Arkansas | 5081 | 2203 | 84 |
2068332 | 2068332 | 2021-12-31 | Perry | Mississippi | 28111 | 2203 | 57 |
2065081 | 2065081 | 2021-12-30 | Perry | Mississippi | 28111 | 2203 | 57 |
2036713 | 2036713 | 2021-12-21 | Cayey | Puerto Rico | 72035 | 2203 | |
2028459 | 2028459 | 2021-12-19 | Shoshone | Idaho | 16079 | 2203 | 66 |
2030571 | 2030571 | 2021-12-19 | Gaines | Texas | 48165 | 2203 | 67 |
2025208 | 2025208 | 2021-12-18 | Shoshone | Idaho | 16079 | 2203 | 66 |
2027320 | 2027320 | 2021-12-18 | Gaines | Texas | 48165 | 2203 | 67 |
2021957 | 2021957 | 2021-12-17 | Shoshone | Idaho | 16079 | 2203 | 66 |
2020146 | 2020146 | 2021-12-16 | Mountrail | North Dakota | 38061 | 2203 | 32 |
2010149 | 2010149 | 2021-12-13 | Unknown | New Hampshire | 2203 | 13 | |
2007350 | 2007350 | 2021-12-12 | Hood River | Oregon | 41027 | 2203 | 37 |
2004099 | 2004099 | 2021-12-11 | Hood River | Oregon | 41027 | 2203 | 37 |
2000848 | 2000848 | 2021-12-10 | Hood River | Oregon | 41027 | 2203 | 37 |
1984962 | 1984962 | 2021-12-05 | Stewart | Tennessee | 47161 | 2203 | 37 |
1981712 | 1981712 | 2021-12-04 | Stewart | Tennessee | 47161 | 2203 | 37 |
1977975 | 1977975 | 2021-12-03 | Noble | Ohio | 39121 | 2203 | 49 |
1978462 | 1978462 | 2021-12-03 | Stewart | Tennessee | 47161 | 2203 | 37 |
1975580 | 1975580 | 2021-12-02 | Goochland | Virginia | 51075 | 2203 | 31 |
1946037 | 1946037 | 2021-11-23 | Eastland | Texas | 48133 | 2203 | 81 |
1946351 | 1946351 | 2021-11-23 | Martinsville city | Virginia | 51690 | 2203 | 91 |
1921261 | 1921261 | 2021-11-16 | Mercer | Illinois | 17131 | 2203 | 37 |
1914755 | 1914755 | 2021-11-14 | Mason | Illinois | 17125 | 2203 | 54 |
1917226 | 1917226 | 2021-11-14 | Morgan | West Virginia | 54065 | 2203 | 47 |
1911505 | 1911505 | 2021-11-13 | Mason | Illinois | 17125 | 2203 | 54 |
1908256 | 1908256 | 2021-11-12 | Mason | Illinois | 17125 | 2203 | 54 |
1905920 | 1905920 | 2021-11-11 | Osage | Missouri | 29151 | 2203 | 23 |
1902289 | 1902289 | 2021-11-10 | Knox | Maine | 23013 | 2203 | 13 |
1902671 | 1902671 | 2021-11-10 | Osage | Missouri | 29151 | 2203 | 23 |
1896085 | 1896085 | 2021-11-08 | Walthall | Mississippi | 28147 | 2203 | 64 |
1876731 | 1876731 | 2021-11-02 | Glacier | Montana | 30035 | 2203 | 53 |
1872512 | 1872512 | 2021-11-01 | Massac | Illinois | 17127 | 2203 | 54 |
1849001 | 1849001 | 2021-10-24 | Taylor | West Virginia | 54091 | 2203 | 38 |
1837756 | 1837756 | 2021-10-21 | Park | Montana | 30067 | 2203 | 27 |
1838985 | 1838985 | 2021-10-21 | Zapata | Texas | 48505 | 2203 | 45 |
1782402 | 1782402 | 2021-10-04 | Dallas | Missouri | 29059 | 2203 | 40 |
1769856 | 1769856 | 2021-09-30 | Polk | North Carolina | 37149 | 2203 | 42 |
1765644 | 1765644 | 2021-09-29 | Butler | Kentucky | 21031 | 2203 | 29 |
1762447 | 1762447 | 2021-09-28 | Lewis | Kentucky | 21135 | 2203 | 52 |
1748178 | 1748178 | 2021-09-23 | Southampton | Virginia | 51175 | 2203 | 59 |
1733256 | 1733256 | 2021-09-19 | Webster | Kentucky | 21233 | 2203 | 31 |
1730006 | 1730006 | 2021-09-18 | Webster | Kentucky | 21233 | 2203 | 31 |
1726756 | 1726756 | 2021-09-17 | Webster | Kentucky | 21233 | 2203 | 31 |
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);