ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
422 rows where cases = 1373 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 59
- Texas 29
- Kentucky 26
- Georgia 22
- Kansas 19
- Missouri 18
- North Carolina 16
- Puerto Rico 16
- South Dakota 16
- Ohio 14
- Virgin Islands 12
- Virginia 12
- Arkansas 11
- Illinois 11
- Tennessee 11
- Alabama 10
- Indiana 10
- Wisconsin 9
- Colorado 7
- Michigan 7
- North Dakota 7
- Oklahoma 7
- South Carolina 7
- Wyoming 7
- Florida 6
- California 5
- Louisiana 5
- Maryland 5
- Mississippi 4
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497296 | 2497296 | 2022-05-12 | Rooks | Kansas | 20163 | 1373 | 20 |
2494038 | 2494038 | 2022-05-11 | Rooks | Kansas | 20163 | 1373 | 20 |
2490780 | 2490780 | 2022-05-10 | Rooks | Kansas | 20163 | 1373 | 20 |
2487523 | 2487523 | 2022-05-09 | Rooks | Kansas | 20163 | 1373 | 20 |
2484265 | 2484265 | 2022-05-08 | Rooks | Kansas | 20163 | 1373 | 20 |
2481007 | 2481007 | 2022-05-07 | Rooks | Kansas | 20163 | 1373 | 20 |
2477749 | 2477749 | 2022-05-06 | Rooks | Kansas | 20163 | 1373 | 20 |
2438703 | 2438703 | 2022-04-24 | Ballard | Kentucky | 21007 | 1373 | 28 |
2435447 | 2435447 | 2022-04-23 | Ballard | Kentucky | 21007 | 1373 | 28 |
2432191 | 2432191 | 2022-04-22 | Ballard | Kentucky | 21007 | 1373 | 28 |
2428935 | 2428935 | 2022-04-21 | Ballard | Kentucky | 21007 | 1373 | 28 |
2425679 | 2425679 | 2022-04-20 | Ballard | Kentucky | 21007 | 1373 | 28 |
2422423 | 2422423 | 2022-04-19 | Ballard | Kentucky | 21007 | 1373 | 28 |
2419167 | 2419167 | 2022-04-18 | Ballard | Kentucky | 21007 | 1373 | 28 |
2387990 | 2387990 | 2022-04-08 | Maunabo | Puerto Rico | 72095 | 1373 | |
2353900 | 2353900 | 2022-03-29 | Fremont | Iowa | 19071 | 1373 | 24 |
2350648 | 2350648 | 2022-03-28 | Fremont | Iowa | 19071 | 1373 | 24 |
2347395 | 2347395 | 2022-03-27 | Fremont | Iowa | 19071 | 1373 | 24 |
2344142 | 2344142 | 2022-03-26 | Fremont | Iowa | 19071 | 1373 | 24 |
2340889 | 2340889 | 2022-03-25 | Fremont | Iowa | 19071 | 1373 | 24 |
2337636 | 2337636 | 2022-03-24 | Fremont | Iowa | 19071 | 1373 | 24 |
2334382 | 2334382 | 2022-03-23 | Fremont | Iowa | 19071 | 1373 | 24 |
2331128 | 2331128 | 2022-03-22 | Fremont | Iowa | 19071 | 1373 | 24 |
2327876 | 2327876 | 2022-03-21 | Fremont | Iowa | 19071 | 1373 | 24 |
2324623 | 2324623 | 2022-03-20 | Fremont | Iowa | 19071 | 1373 | 24 |
2321369 | 2321369 | 2022-03-19 | Fremont | Iowa | 19071 | 1373 | 24 |
2318115 | 2318115 | 2022-03-18 | Fremont | Iowa | 19071 | 1373 | 24 |
2314862 | 2314862 | 2022-03-17 | Fremont | Iowa | 19071 | 1373 | 24 |
2316546 | 2316546 | 2022-03-17 | Moody | South Dakota | 46101 | 1373 | 28 |
2311609 | 2311609 | 2022-03-16 | Fremont | Iowa | 19071 | 1373 | 24 |
2313293 | 2313293 | 2022-03-16 | Moody | South Dakota | 46101 | 1373 | 28 |
2308356 | 2308356 | 2022-03-15 | Fremont | Iowa | 19071 | 1373 | 24 |
2305105 | 2305105 | 2022-03-14 | Fremont | Iowa | 19071 | 1373 | 24 |
2301853 | 2301853 | 2022-03-13 | Fremont | Iowa | 19071 | 1373 | 24 |
2303536 | 2303536 | 2022-03-13 | Moody | South Dakota | 46101 | 1373 | 28 |
2298601 | 2298601 | 2022-03-12 | Fremont | Iowa | 19071 | 1373 | 24 |
2300284 | 2300284 | 2022-03-12 | Moody | South Dakota | 46101 | 1373 | 28 |
2295349 | 2295349 | 2022-03-11 | Fremont | Iowa | 19071 | 1373 | 24 |
2297032 | 2297032 | 2022-03-11 | Moody | South Dakota | 46101 | 1373 | 28 |
2292097 | 2292097 | 2022-03-10 | Fremont | Iowa | 19071 | 1373 | 24 |
2293780 | 2293780 | 2022-03-10 | Moody | South Dakota | 46101 | 1373 | 28 |
2288845 | 2288845 | 2022-03-09 | Fremont | Iowa | 19071 | 1373 | 24 |
2290528 | 2290528 | 2022-03-09 | Moody | South Dakota | 46101 | 1373 | 28 |
2285594 | 2285594 | 2022-03-08 | Fremont | Iowa | 19071 | 1373 | 24 |
2285648 | 2285648 | 2022-03-08 | Van Buren | Iowa | 19177 | 1373 | 26 |
2287276 | 2287276 | 2022-03-08 | Moody | South Dakota | 46101 | 1373 | 28 |
2282342 | 2282342 | 2022-03-07 | Fremont | Iowa | 19071 | 1373 | 24 |
2282396 | 2282396 | 2022-03-07 | Van Buren | Iowa | 19177 | 1373 | 26 |
2279089 | 2279089 | 2022-03-06 | Fremont | Iowa | 19071 | 1373 | 24 |
2279143 | 2279143 | 2022-03-06 | Van Buren | Iowa | 19177 | 1373 | 26 |
2275836 | 2275836 | 2022-03-05 | Fremont | Iowa | 19071 | 1373 | 24 |
2275890 | 2275890 | 2022-03-05 | Van Buren | Iowa | 19177 | 1373 | 26 |
2272583 | 2272583 | 2022-03-04 | Fremont | Iowa | 19071 | 1373 | 24 |
2272637 | 2272637 | 2022-03-04 | Van Buren | Iowa | 19177 | 1373 | 26 |
2269331 | 2269331 | 2022-03-03 | Fremont | Iowa | 19071 | 1373 | 24 |
2269385 | 2269385 | 2022-03-03 | Van Buren | Iowa | 19177 | 1373 | 26 |
2266078 | 2266078 | 2022-03-02 | Fremont | Iowa | 19071 | 1373 | 24 |
2266132 | 2266132 | 2022-03-02 | Van Buren | Iowa | 19177 | 1373 | 26 |
2261269 | 2261269 | 2022-02-28 | Tripp | South Dakota | 46123 | 1373 | 23 |
2256993 | 2256993 | 2022-02-27 | Atchison | Missouri | 29005 | 1373 | 19 |
2253742 | 2253742 | 2022-02-26 | Atchison | Missouri | 29005 | 1373 | 19 |
2250491 | 2250491 | 2022-02-25 | Atchison | Missouri | 29005 | 1373 | 19 |
2247240 | 2247240 | 2022-02-24 | Atchison | Missouri | 29005 | 1373 | 19 |
2243989 | 2243989 | 2022-02-23 | Atchison | Missouri | 29005 | 1373 | 19 |
2245003 | 2245003 | 2022-02-23 | Moody | South Dakota | 46101 | 1373 | 27 |
2216754 | 2216754 | 2022-02-15 | Huerfano | Colorado | 8055 | 1373 | 28 |
2190696 | 2190696 | 2022-02-07 | Trinity | California | 6105 | 1373 | 20 |
2145072 | 2145072 | 2022-01-24 | Montgomery | Arkansas | 5097 | 1373 | 53 |
2134836 | 2134836 | 2022-01-20 | Bland | Virginia | 51021 | 1373 | 18 |
2122433 | 2122433 | 2022-01-17 | Rio Blanco | Colorado | 8103 | 1373 | 13 |
2110657 | 2110657 | 2022-01-13 | Daviess | Missouri | 29061 | 1373 | 21 |
2106503 | 2106503 | 2022-01-12 | Edwards | Illinois | 17047 | 1373 | 24 |
2103107 | 2103107 | 2022-01-11 | Lincoln | Georgia | 13181 | 1373 | 33 |
2105113 | 2105113 | 2022-01-11 | Fall River | South Dakota | 46047 | 1373 | 31 |
2101743 | 2101743 | 2022-01-10 | Hormigueros | Puerto Rico | 72067 | 1373 | |
2092323 | 2092323 | 2022-01-07 | Floyd | Texas | 48153 | 1373 | 40 |
2092461 | 2092461 | 2022-01-07 | Stephens | Texas | 48429 | 1373 | 38 |
2080413 | 2080413 | 2022-01-04 | Wilcox | Georgia | 13315 | 1373 | 62 |
2081406 | 2081406 | 2022-01-04 | Hickory | Missouri | 29085 | 1373 | 45 |
2041165 | 2041165 | 2021-12-23 | San Miguel | Colorado | 8113 | 1373 | 7 |
2033986 | 2033986 | 2021-12-20 | Winkler | Texas | 48495 | 1373 | 32 |
2030736 | 2030736 | 2021-12-19 | Winkler | Texas | 48495 | 1373 | 32 |
2027485 | 2027485 | 2021-12-18 | Winkler | Texas | 48495 | 1373 | 32 |
2019707 | 2019707 | 2021-12-16 | St. Clair | Missouri | 29185 | 1373 | 27 |
2008343 | 2008343 | 2021-12-12 | Johnson | Wyoming | 56019 | 1373 | 16 |
2005092 | 2005092 | 2021-12-11 | Johnson | Wyoming | 56019 | 1373 | 16 |
2001841 | 2001841 | 2021-12-10 | Johnson | Wyoming | 56019 | 1373 | 16 |
1998060 | 1998060 | 2021-12-09 | Franklin | Texas | 48159 | 1373 | 37 |
1998591 | 1998591 | 2021-12-09 | Johnson | Wyoming | 56019 | 1373 | 16 |
1993864 | 1993864 | 2021-12-08 | Wayne | Nebraska | 31179 | 1373 | 8 |
1984295 | 1984295 | 2021-12-05 | Graham | North Carolina | 37075 | 1373 | 28 |
1981045 | 1981045 | 2021-12-04 | Graham | North Carolina | 37075 | 1373 | 28 |
1977795 | 1977795 | 2021-12-03 | Graham | North Carolina | 37075 | 1373 | 28 |
1969661 | 1969661 | 2021-12-01 | Yuma | Colorado | 8125 | 1373 | 18 |
1969053 | 1969053 | 2021-11-30 | Charlotte | Virginia | 51037 | 1373 | 28 |
1969126 | 1969126 | 2021-11-30 | Poquoson city | Virginia | 51735 | 1373 | 22 |
1932352 | 1932352 | 2021-11-19 | Benson | North Dakota | 38005 | 1373 | 20 |
1929050 | 1929050 | 2021-11-18 | Jones | North Carolina | 37103 | 1373 | 34 |
1922551 | 1922551 | 2021-11-16 | Jones | North Carolina | 37103 | 1373 | 34 |
1917039 | 1917039 | 2021-11-14 | Buena Vista city | Virginia | 51530 | 1373 | 28 |
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);