ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
442 rows where cases = 1355 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 36
- Texas 36
- Kentucky 31
- Virginia 28
- Georgia 22
- Indiana 19
- Missouri 19
- Puerto Rico 18
- South Carolina 15
- Mississippi 14
- West Virginia 14
- Arkansas 12
- Illinois 12
- Kansas 11
- Minnesota 11
- Michigan 10
- Alabama 9
- Nebraska 9
- Wisconsin 9
- Louisiana 8
- New Mexico 8
- Tennessee 8
- North Carolina 7
- Oklahoma 7
- Utah 7
- Maryland 6
- South Dakota 6
- Colorado 5
- Florida 5
- North Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502474 | 2502474 | 2022-05-13 | Kane | Utah | 49025 | 1355 | 15 |
2498013 | 2498013 | 2022-05-12 | Dawes | Nebraska | 31045 | 1355 | 21 |
2499216 | 2499216 | 2022-05-12 | Kane | Utah | 49025 | 1355 | 15 |
2494755 | 2494755 | 2022-05-11 | Dawes | Nebraska | 31045 | 1355 | 21 |
2495958 | 2495958 | 2022-05-11 | Kane | Utah | 49025 | 1355 | 15 |
2492700 | 2492700 | 2022-05-10 | Kane | Utah | 49025 | 1355 | 15 |
2489442 | 2489442 | 2022-05-09 | Kane | Utah | 49025 | 1355 | 15 |
2404614 | 2404614 | 2022-04-13 | Hartley | Texas | 48205 | 1355 | 3 |
2401359 | 2401359 | 2022-04-12 | Hartley | Texas | 48205 | 1355 | 3 |
2398104 | 2398104 | 2022-04-11 | Hartley | Texas | 48205 | 1355 | 3 |
2394849 | 2394849 | 2022-04-10 | Hartley | Texas | 48205 | 1355 | 3 |
2391593 | 2391593 | 2022-04-09 | Hartley | Texas | 48205 | 1355 | 3 |
2388337 | 2388337 | 2022-04-08 | Hartley | Texas | 48205 | 1355 | 3 |
2385082 | 2385082 | 2022-04-07 | Hartley | Texas | 48205 | 1355 | 3 |
2381827 | 2381827 | 2022-04-06 | Hartley | Texas | 48205 | 1355 | 3 |
2378572 | 2378572 | 2022-04-05 | Hartley | Texas | 48205 | 1355 | 3 |
2375318 | 2375318 | 2022-04-04 | Hartley | Texas | 48205 | 1355 | 3 |
2372066 | 2372066 | 2022-04-03 | Hartley | Texas | 48205 | 1355 | 3 |
2368813 | 2368813 | 2022-04-02 | Hartley | Texas | 48205 | 1355 | 3 |
2365560 | 2365560 | 2022-04-01 | Hartley | Texas | 48205 | 1355 | 3 |
2362307 | 2362307 | 2022-03-31 | Hartley | Texas | 48205 | 1355 | 3 |
2342411 | 2342411 | 2022-03-25 | Ceiba | Puerto Rico | 72037 | 1355 | |
2339158 | 2339158 | 2022-03-24 | Ceiba | Puerto Rico | 72037 | 1355 | |
2335904 | 2335904 | 2022-03-23 | Ceiba | Puerto Rico | 72037 | 1355 | |
2332650 | 2332650 | 2022-03-22 | Ceiba | Puerto Rico | 72037 | 1355 | |
2329397 | 2329397 | 2022-03-21 | Ceiba | Puerto Rico | 72037 | 1355 | |
2325485 | 2325485 | 2022-03-20 | Dawes | Nebraska | 31045 | 1355 | 21 |
2326145 | 2326145 | 2022-03-20 | Ceiba | Puerto Rico | 72037 | 1355 | |
2322231 | 2322231 | 2022-03-19 | Dawes | Nebraska | 31045 | 1355 | 21 |
2318977 | 2318977 | 2022-03-18 | Dawes | Nebraska | 31045 | 1355 | 21 |
2314439 | 2314439 | 2022-03-17 | Calhoun | Georgia | 13037 | 1355 | 22 |
2315724 | 2315724 | 2022-03-17 | Dawes | Nebraska | 31045 | 1355 | 21 |
2305966 | 2305966 | 2022-03-14 | Dawes | Nebraska | 31045 | 1355 | 21 |
2285732 | 2285732 | 2022-03-08 | Phillips | Kansas | 20147 | 1355 | 29 |
2282480 | 2282480 | 2022-03-07 | Phillips | Kansas | 20147 | 1355 | 29 |
2279227 | 2279227 | 2022-03-06 | Phillips | Kansas | 20147 | 1355 | 29 |
2275974 | 2275974 | 2022-03-05 | Phillips | Kansas | 20147 | 1355 | 29 |
2272721 | 2272721 | 2022-03-04 | Phillips | Kansas | 20147 | 1355 | 29 |
2266939 | 2266939 | 2022-03-02 | Dawes | Nebraska | 31045 | 1355 | 21 |
2264796 | 2264796 | 2022-03-01 | Newton | Texas | 48351 | 1355 | 59 |
2255902 | 2255902 | 2022-02-27 | Calhoun | Georgia | 13037 | 1355 | 22 |
2252651 | 2252651 | 2022-02-26 | Calhoun | Georgia | 13037 | 1355 | 22 |
2249400 | 2249400 | 2022-02-25 | Calhoun | Georgia | 13037 | 1355 | 22 |
2217313 | 2217313 | 2022-02-15 | Fremont | Iowa | 19071 | 1355 | 21 |
2214062 | 2214062 | 2022-02-14 | Fremont | Iowa | 19071 | 1355 | 21 |
2210810 | 2210810 | 2022-02-13 | Fremont | Iowa | 19071 | 1355 | 21 |
2207557 | 2207557 | 2022-02-12 | Fremont | Iowa | 19071 | 1355 | 21 |
2204304 | 2204304 | 2022-02-11 | Fremont | Iowa | 19071 | 1355 | 21 |
2201051 | 2201051 | 2022-02-10 | Fremont | Iowa | 19071 | 1355 | 21 |
2197509 | 2197509 | 2022-02-09 | Wheeler | Georgia | 13309 | 1355 | 38 |
2197797 | 2197797 | 2022-02-09 | Fremont | Iowa | 19071 | 1355 | 21 |
2172295 | 2172295 | 2022-02-01 | Grant | Minnesota | 27051 | 1355 | 12 |
2165196 | 2165196 | 2022-01-30 | Ohio | Indiana | 18115 | 1355 | 17 |
2161941 | 2161941 | 2022-01-29 | Ohio | Indiana | 18115 | 1355 | 17 |
2158686 | 2158686 | 2022-01-28 | Ohio | Indiana | 18115 | 1355 | 17 |
2153101 | 2153101 | 2022-01-26 | Cedar | Nebraska | 31027 | 1355 | 11 |
2136743 | 2136743 | 2022-01-21 | Shelby | Missouri | 29205 | 1355 | 13 |
2132150 | 2132150 | 2022-01-20 | Clear Creek | Colorado | 8019 | 1355 | 10 |
2094401 | 2094401 | 2022-01-08 | Daviess | Missouri | 29061 | 1355 | 18 |
2080699 | 2080699 | 2022-01-04 | Greene | Iowa | 19073 | 1355 | 18 |
2077447 | 2077447 | 2022-01-03 | Greene | Iowa | 19073 | 1355 | 18 |
2074196 | 2074196 | 2022-01-02 | Greene | Iowa | 19073 | 1355 | 18 |
2076365 | 2076365 | 2022-01-02 | Madison | Virginia | 51113 | 1355 | 25 |
2070945 | 2070945 | 2022-01-01 | Greene | Iowa | 19073 | 1355 | 18 |
2073114 | 2073114 | 2022-01-01 | Madison | Virginia | 51113 | 1355 | 25 |
2067030 | 2067030 | 2021-12-31 | Prairie | Arkansas | 5117 | 1355 | 31 |
2067694 | 2067694 | 2021-12-31 | Greene | Iowa | 19073 | 1355 | 18 |
2069863 | 2069863 | 2021-12-31 | Madison | Virginia | 51113 | 1355 | 25 |
2064443 | 2064443 | 2021-12-30 | Greene | Iowa | 19073 | 1355 | 18 |
2061193 | 2061193 | 2021-12-29 | Greene | Iowa | 19073 | 1355 | 18 |
2063497 | 2063497 | 2021-12-29 | Pocahontas | West Virginia | 54075 | 1355 | 22 |
2056479 | 2056479 | 2021-12-27 | Van Buren | Tennessee | 47175 | 1355 | 43 |
2036926 | 2036926 | 2021-12-21 | Hancock | Tennessee | 47067 | 1355 | 21 |
2014331 | 2014331 | 2021-12-14 | Hamilton | Texas | 48193 | 1355 | 29 |
1998319 | 1998319 | 2021-12-09 | Essex | Virginia | 51057 | 1355 | 20 |
1994977 | 1994977 | 2021-12-08 | Winkler | Texas | 48495 | 1355 | 32 |
1990217 | 1990217 | 2021-12-07 | Lake | Minnesota | 27075 | 1355 | 24 |
1953199 | 1953199 | 2021-11-26 | Greenlee | Arizona | 4011 | 1355 | 20 |
1925460 | 1925460 | 2021-11-17 | Blaine | Montana | 30005 | 1355 | 27 |
1923013 | 1923013 | 2021-11-16 | Allendale | South Carolina | 45005 | 1355 | 21 |
1919764 | 1919764 | 2021-11-15 | Allendale | South Carolina | 45005 | 1355 | 21 |
1920004 | 1920004 | 2021-11-15 | Castro | Texas | 48069 | 1355 | 38 |
1916514 | 1916514 | 2021-11-14 | Allendale | South Carolina | 45005 | 1355 | 21 |
1916754 | 1916754 | 2021-11-14 | Castro | Texas | 48069 | 1355 | 38 |
1913264 | 1913264 | 2021-11-13 | Allendale | South Carolina | 45005 | 1355 | 21 |
1913504 | 1913504 | 2021-11-13 | Castro | Texas | 48069 | 1355 | 38 |
1910014 | 1910014 | 2021-11-12 | Allendale | South Carolina | 45005 | 1355 | 21 |
1904119 | 1904119 | 2021-11-10 | Poquoson city | Virginia | 51735 | 1355 | 22 |
1899271 | 1899271 | 2021-11-09 | Choctaw | Mississippi | 28019 | 1355 | 27 |
1900791 | 1900791 | 2021-11-09 | Buena Vista city | Virginia | 51530 | 1355 | 27 |
1900869 | 1900869 | 2021-11-09 | Poquoson city | Virginia | 51735 | 1355 | 22 |
1893127 | 1893127 | 2021-11-07 | White Pine | Nevada | 32033 | 1355 | 12 |
1889877 | 1889877 | 2021-11-06 | White Pine | Nevada | 32033 | 1355 | 12 |
1886627 | 1886627 | 2021-11-05 | White Pine | Nevada | 32033 | 1355 | 12 |
1880402 | 1880402 | 2021-11-03 | Traill | North Dakota | 38097 | 1355 | 21 |
1871554 | 1871554 | 2021-10-31 | Clarke | Virginia | 51043 | 1355 | 25 |
1868269 | 1868269 | 2021-10-30 | Orange | Vermont | 50017 | 1355 | 5 |
1868305 | 1868305 | 2021-10-30 | Clarke | Virginia | 51043 | 1355 | 25 |
1865056 | 1865056 | 2021-10-29 | Clarke | Virginia | 51043 | 1355 | 25 |
1859170 | 1859170 | 2021-10-28 | Unknown | Connecticut | 1355 | 5 |
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);