ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
359 rows where cases = 1345 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 51
- Iowa 32
- Nebraska 20
- Texas 17
- Puerto Rico 15
- Wisconsin 15
- Illinois 14
- Kentucky 13
- Michigan 13
- Minnesota 13
- Missouri 13
- North Carolina 11
- Arkansas 10
- South Dakota 9
- Montana 8
- Virginia 8
- Louisiana 7
- South Carolina 7
- West Virginia 7
- Wyoming 7
- Georgia 6
- Alabama 5
- Florida 5
- Mississippi 5
- Ohio 5
- Tennessee 5
- Oregon 4
- Washington 4
- Idaho 3
- Oklahoma 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400309 | 2400309 | 2022-04-12 | Burt | Nebraska | 31021 | 1345 | 16 |
2397054 | 2397054 | 2022-04-11 | Burt | Nebraska | 31021 | 1345 | 16 |
2398608 | 2398608 | 2022-04-11 | Crook | Wyoming | 56011 | 1345 | 28 |
2393799 | 2393799 | 2022-04-10 | Burt | Nebraska | 31021 | 1345 | 16 |
2395353 | 2395353 | 2022-04-10 | Crook | Wyoming | 56011 | 1345 | 28 |
2390543 | 2390543 | 2022-04-09 | Burt | Nebraska | 31021 | 1345 | 16 |
2392097 | 2392097 | 2022-04-09 | Crook | Wyoming | 56011 | 1345 | 28 |
2387287 | 2387287 | 2022-04-08 | Burt | Nebraska | 31021 | 1345 | 16 |
2388841 | 2388841 | 2022-04-08 | Crook | Wyoming | 56011 | 1345 | 28 |
2383325 | 2383325 | 2022-04-07 | Republic | Kansas | 20157 | 1345 | 16 |
2384032 | 2384032 | 2022-04-07 | Burt | Nebraska | 31021 | 1345 | 16 |
2380070 | 2380070 | 2022-04-06 | Republic | Kansas | 20157 | 1345 | 16 |
2380777 | 2380777 | 2022-04-06 | Burt | Nebraska | 31021 | 1345 | 16 |
2376815 | 2376815 | 2022-04-05 | Republic | Kansas | 20157 | 1345 | 16 |
2377522 | 2377522 | 2022-04-05 | Burt | Nebraska | 31021 | 1345 | 16 |
2373563 | 2373563 | 2022-04-04 | Republic | Kansas | 20157 | 1345 | 16 |
2374269 | 2374269 | 2022-04-04 | Burt | Nebraska | 31021 | 1345 | 16 |
2370310 | 2370310 | 2022-04-03 | Republic | Kansas | 20157 | 1345 | 16 |
2367057 | 2367057 | 2022-04-02 | Republic | Kansas | 20157 | 1345 | 16 |
2363804 | 2363804 | 2022-04-01 | Republic | Kansas | 20157 | 1345 | 16 |
2360550 | 2360550 | 2022-03-31 | Republic | Kansas | 20157 | 1345 | 16 |
2357296 | 2357296 | 2022-03-30 | Republic | Kansas | 20157 | 1345 | 16 |
2354043 | 2354043 | 2022-03-29 | Republic | Kansas | 20157 | 1345 | 16 |
2350791 | 2350791 | 2022-03-28 | Republic | Kansas | 20157 | 1345 | 16 |
2347538 | 2347538 | 2022-03-27 | Republic | Kansas | 20157 | 1345 | 16 |
2344285 | 2344285 | 2022-03-26 | Republic | Kansas | 20157 | 1345 | 16 |
2341032 | 2341032 | 2022-03-25 | Republic | Kansas | 20157 | 1345 | 16 |
2337779 | 2337779 | 2022-03-24 | Republic | Kansas | 20157 | 1345 | 16 |
2334525 | 2334525 | 2022-03-23 | Republic | Kansas | 20157 | 1345 | 16 |
2331271 | 2331271 | 2022-03-22 | Republic | Kansas | 20157 | 1345 | 16 |
2328019 | 2328019 | 2022-03-21 | Republic | Kansas | 20157 | 1345 | 16 |
2324766 | 2324766 | 2022-03-20 | Republic | Kansas | 20157 | 1345 | 16 |
2321512 | 2321512 | 2022-03-19 | Republic | Kansas | 20157 | 1345 | 16 |
2318258 | 2318258 | 2022-03-18 | Republic | Kansas | 20157 | 1345 | 16 |
2315005 | 2315005 | 2022-03-17 | Republic | Kansas | 20157 | 1345 | 15 |
2311752 | 2311752 | 2022-03-16 | Republic | Kansas | 20157 | 1345 | 15 |
2296900 | 2296900 | 2022-03-11 | Maunabo | Puerto Rico | 72095 | 1345 | |
2292240 | 2292240 | 2022-03-10 | Republic | Kansas | 20157 | 1345 | 14 |
2293648 | 2293648 | 2022-03-10 | Maunabo | Puerto Rico | 72095 | 1345 | |
2288988 | 2288988 | 2022-03-09 | Republic | Kansas | 20157 | 1345 | 14 |
2285737 | 2285737 | 2022-03-08 | Republic | Kansas | 20157 | 1345 | 14 |
2282485 | 2282485 | 2022-03-07 | Republic | Kansas | 20157 | 1345 | 14 |
2279232 | 2279232 | 2022-03-06 | Republic | Kansas | 20157 | 1345 | 14 |
2275979 | 2275979 | 2022-03-05 | Republic | Kansas | 20157 | 1345 | 14 |
2272726 | 2272726 | 2022-03-04 | Republic | Kansas | 20157 | 1345 | 14 |
2246718 | 2246718 | 2022-02-24 | Rooks | Kansas | 20163 | 1345 | 20 |
2243467 | 2243467 | 2022-02-23 | Rooks | Kansas | 20163 | 1345 | 20 |
2223953 | 2223953 | 2022-02-17 | Phillips | Kansas | 20147 | 1345 | 29 |
2224067 | 2224067 | 2022-02-17 | Menifee | Kentucky | 21165 | 1345 | 30 |
2225232 | 2225232 | 2022-02-17 | Lake | Oregon | 41037 | 1345 | 23 |
2220702 | 2220702 | 2022-02-16 | Phillips | Kansas | 20147 | 1345 | 29 |
2217981 | 2217981 | 2022-02-15 | Atchison | Missouri | 29005 | 1345 | 19 |
2200628 | 2200628 | 2022-02-10 | Calhoun | Georgia | 13037 | 1345 | 22 |
2197374 | 2197374 | 2022-02-09 | Calhoun | Georgia | 13037 | 1345 | 22 |
2177687 | 2177687 | 2022-02-03 | Trinity | California | 6105 | 1345 | 20 |
2177203 | 2177203 | 2022-02-02 | Mathews | Virginia | 51115 | 1345 | 24 |
2177349 | 2177349 | 2022-02-02 | Wirt | West Virginia | 54105 | 1345 | 19 |
2173463 | 2173463 | 2022-02-01 | Spink | South Dakota | 46115 | 1345 | 32 |
2165392 | 2165392 | 2022-01-30 | Mitchell | Kansas | 20123 | 1345 | 18 |
2162137 | 2162137 | 2022-01-29 | Mitchell | Kansas | 20123 | 1345 | 18 |
2158882 | 2158882 | 2022-01-28 | Mitchell | Kansas | 20123 | 1345 | 18 |
2146647 | 2146647 | 2022-01-24 | Nemaha | Nebraska | 31127 | 1345 | 18 |
2122669 | 2122669 | 2022-01-17 | Twiggs | Georgia | 13289 | 1345 | 62 |
2063771 | 2063771 | 2021-12-30 | Newton | Arkansas | 5101 | 1345 | 43 |
2052949 | 2052949 | 2021-12-26 | Aibonito | Puerto Rico | 72009 | 1345 | |
1992054 | 1992054 | 2021-12-07 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1986967 | 1986967 | 2021-12-06 | Lake | Minnesota | 27075 | 1345 | 24 |
1988566 | 1988566 | 2021-12-06 | Essex | Virginia | 51057 | 1345 | 20 |
1988803 | 1988803 | 2021-12-06 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1985553 | 1985553 | 2021-12-05 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1982303 | 1982303 | 2021-12-04 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1979053 | 1979053 | 2021-12-03 | Pepin | Wisconsin | 55091 | 1345 | 10 |
1970382 | 1970382 | 2021-12-01 | Crittenden | Kentucky | 21055 | 1345 | 37 |
1966089 | 1966089 | 2021-11-29 | Johnson | Wyoming | 56019 | 1345 | 16 |
1930200 | 1930200 | 2021-11-18 | Clay | West Virginia | 54015 | 1345 | 21 |
1922211 | 1922211 | 2021-11-16 | Blaine | Montana | 30005 | 1345 | 27 |
1918961 | 1918961 | 2021-11-15 | Blaine | Montana | 30005 | 1345 | 27 |
1918986 | 1918986 | 2021-11-15 | Madison | Montana | 30057 | 1345 | 13 |
1915736 | 1915736 | 2021-11-14 | Madison | Montana | 30057 | 1345 | 13 |
1912486 | 1912486 | 2021-11-13 | Madison | Montana | 30057 | 1345 | 13 |
1909236 | 1909236 | 2021-11-12 | Madison | Montana | 30057 | 1345 | 13 |
1905276 | 1905276 | 2021-11-11 | Grant | Kansas | 20067 | 1345 | 30 |
1902026 | 1902026 | 2021-11-10 | Grant | Kansas | 20067 | 1345 | 30 |
1903801 | 1903801 | 2021-11-10 | Franklin | Texas | 48159 | 1345 | 36 |
1900551 | 1900551 | 2021-11-09 | Franklin | Texas | 48159 | 1345 | 36 |
1897301 | 1897301 | 2021-11-08 | Franklin | Texas | 48159 | 1345 | 36 |
1894051 | 1894051 | 2021-11-07 | Franklin | Texas | 48159 | 1345 | 36 |
1890801 | 1890801 | 2021-11-06 | Franklin | Texas | 48159 | 1345 | 36 |
1886420 | 1886420 | 2021-11-05 | Oregon | Missouri | 29149 | 1345 | 11 |
1876501 | 1876501 | 2021-11-02 | Stevens | Minnesota | 27149 | 1345 | 11 |
1870340 | 1870340 | 2021-10-31 | Phelps | Nebraska | 31137 | 1345 | 10 |
1857030 | 1857030 | 2021-10-27 | Choctaw | Mississippi | 28019 | 1345 | 27 |
1854834 | 1854834 | 2021-10-26 | Custer | South Dakota | 46033 | 1345 | 15 |
1849741 | 1849741 | 2021-10-25 | Hamilton | Illinois | 17065 | 1345 | 25 |
1847228 | 1847228 | 2021-10-24 | Marshall | Minnesota | 27089 | 1345 | 20 |
1848276 | 1848276 | 2021-10-24 | Allendale | South Carolina | 45005 | 1345 | 21 |
1843978 | 1843978 | 2021-10-23 | Marshall | Minnesota | 27089 | 1345 | 20 |
1845026 | 1845026 | 2021-10-23 | Allendale | South Carolina | 45005 | 1345 | 21 |
1840728 | 1840728 | 2021-10-22 | Marshall | Minnesota | 27089 | 1345 | 20 |
1841776 | 1841776 | 2021-10-22 | Allendale | South Carolina | 45005 | 1345 | 21 |
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);