ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
286 rows where cases = 2183 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 27
- Arkansas 23
- Texas 21
- Tennessee 18
- Puerto Rico 17
- Iowa 16
- Virginia 14
- Georgia 13
- Missouri 12
- North Carolina 11
- Colorado 9
- Wisconsin 9
- Mississippi 7
- Utah 7
- Indiana 6
- Ohio 6
- Illinois 5
- West Virginia 5
- Wyoming 5
- Kansas 4
- Louisiana 4
- New York 4
- North Dakota 4
- Pennsylvania 4
- Washington 4
- Michigan 3
- Minnesota 3
- Nebraska 3
- South Dakota 3
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502596 | 2502596 | 2022-05-13 | Northampton | Virginia | 51131 | 2183 | 65 |
2483568 | 2483568 | 2022-05-08 | Lincoln | Colorado | 8073 | 2183 | 9 |
2484301 | 2484301 | 2022-05-08 | Bracken | Kentucky | 21023 | 2183 | 26 |
2480310 | 2480310 | 2022-05-07 | Lincoln | Colorado | 8073 | 2183 | 9 |
2481043 | 2481043 | 2022-05-07 | Bracken | Kentucky | 21023 | 2183 | 26 |
2477052 | 2477052 | 2022-05-06 | Lincoln | Colorado | 8073 | 2183 | 9 |
2477785 | 2477785 | 2022-05-06 | Bracken | Kentucky | 21023 | 2183 | 26 |
2473794 | 2473794 | 2022-05-05 | Lincoln | Colorado | 8073 | 2183 | 9 |
2474527 | 2474527 | 2022-05-05 | Bracken | Kentucky | 21023 | 2183 | 26 |
2470537 | 2470537 | 2022-05-04 | Lincoln | Colorado | 8073 | 2183 | 9 |
2471270 | 2471270 | 2022-05-04 | Bracken | Kentucky | 21023 | 2183 | 26 |
2467281 | 2467281 | 2022-05-03 | Lincoln | Colorado | 8073 | 2183 | 9 |
2468014 | 2468014 | 2022-05-03 | Bracken | Kentucky | 21023 | 2183 | 26 |
2464026 | 2464026 | 2022-05-02 | Lincoln | Colorado | 8073 | 2183 | 9 |
2464759 | 2464759 | 2022-05-02 | Bracken | Kentucky | 21023 | 2183 | 26 |
2461940 | 2461940 | 2022-05-01 | Kemper | Mississippi | 28069 | 2183 | 48 |
2458684 | 2458684 | 2022-04-30 | Kemper | Mississippi | 28069 | 2183 | 48 |
2455428 | 2455428 | 2022-04-29 | Kemper | Mississippi | 28069 | 2183 | 48 |
2452172 | 2452172 | 2022-04-28 | Kemper | Mississippi | 28069 | 2183 | 48 |
2448916 | 2448916 | 2022-04-27 | Kemper | Mississippi | 28069 | 2183 | 48 |
2444619 | 2444619 | 2022-04-26 | Candler | Georgia | 13043 | 2183 | 96 |
2445660 | 2445660 | 2022-04-26 | Kemper | Mississippi | 28069 | 2183 | 48 |
2441363 | 2441363 | 2022-04-25 | Candler | Georgia | 13043 | 2183 | 96 |
2414046 | 2414046 | 2022-04-16 | Rincon | Puerto Rico | 72117 | 2183 | |
2410790 | 2410790 | 2022-04-15 | Rincon | Puerto Rico | 72117 | 2183 | |
2407534 | 2407534 | 2022-04-14 | Rincon | Puerto Rico | 72117 | 2183 | |
2398786 | 2398786 | 2022-04-12 | Nevada | Arkansas | 5099 | 2183 | 45 |
2395531 | 2395531 | 2022-04-11 | Nevada | Arkansas | 5099 | 2183 | 45 |
2392275 | 2392275 | 2022-04-10 | Nevada | Arkansas | 5099 | 2183 | 45 |
2389019 | 2389019 | 2022-04-09 | Nevada | Arkansas | 5099 | 2183 | 45 |
2385764 | 2385764 | 2022-04-08 | Nevada | Arkansas | 5099 | 2183 | 45 |
2382509 | 2382509 | 2022-04-07 | Nevada | Arkansas | 5099 | 2183 | 45 |
2379254 | 2379254 | 2022-04-06 | Nevada | Arkansas | 5099 | 2183 | 45 |
2376000 | 2376000 | 2022-04-05 | Nevada | Arkansas | 5099 | 2183 | 45 |
2372748 | 2372748 | 2022-04-04 | Nevada | Arkansas | 5099 | 2183 | 45 |
2369495 | 2369495 | 2022-04-03 | Nevada | Arkansas | 5099 | 2183 | 45 |
2366242 | 2366242 | 2022-04-02 | Nevada | Arkansas | 5099 | 2183 | 45 |
2362989 | 2362989 | 2022-04-01 | Nevada | Arkansas | 5099 | 2183 | 45 |
2359735 | 2359735 | 2022-03-31 | Nevada | Arkansas | 5099 | 2183 | 45 |
2347593 | 2347593 | 2022-03-27 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2344340 | 2344340 | 2022-03-26 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2341087 | 2341087 | 2022-03-25 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2337834 | 2337834 | 2022-03-24 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2334580 | 2334580 | 2022-03-23 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2331326 | 2331326 | 2022-03-22 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2328074 | 2328074 | 2022-03-21 | Cumberland | Kentucky | 21057 | 2183 | 29 |
2325336 | 2325336 | 2022-03-20 | Iron | Missouri | 29093 | 2183 | 42 |
2322082 | 2322082 | 2022-03-19 | Iron | Missouri | 29093 | 2183 | 42 |
2318828 | 2318828 | 2022-03-18 | Iron | Missouri | 29093 | 2183 | 42 |
2316086 | 2316086 | 2022-03-17 | Traill | North Dakota | 38097 | 2183 | 26 |
2312833 | 2312833 | 2022-03-16 | Traill | North Dakota | 38097 | 2183 | 26 |
2299824 | 2299824 | 2022-03-12 | Traill | North Dakota | 38097 | 2183 | 26 |
2300104 | 2300104 | 2022-03-12 | Adjuntas | Puerto Rico | 72001 | 2183 | |
2287845 | 2287845 | 2022-03-08 | Lincoln | Washington | 53043 | 2183 | 27 |
2284593 | 2284593 | 2022-03-07 | Lincoln | Washington | 53043 | 2183 | 27 |
2262860 | 2262860 | 2022-03-01 | Montgomery | Iowa | 19137 | 2183 | 52 |
2259609 | 2259609 | 2022-02-28 | Montgomery | Iowa | 19137 | 2183 | 52 |
2256358 | 2256358 | 2022-02-27 | Montgomery | Iowa | 19137 | 2183 | 52 |
2256743 | 2256743 | 2022-02-27 | Baraga | Michigan | 26013 | 2183 | 54 |
2253107 | 2253107 | 2022-02-26 | Montgomery | Iowa | 19137 | 2183 | 52 |
2253492 | 2253492 | 2022-02-26 | Baraga | Michigan | 26013 | 2183 | 54 |
2249856 | 2249856 | 2022-02-25 | Montgomery | Iowa | 19137 | 2183 | 52 |
2250241 | 2250241 | 2022-02-25 | Baraga | Michigan | 26013 | 2183 | 54 |
2251381 | 2251381 | 2022-02-25 | Penuelas | Puerto Rico | 72111 | 2183 | |
2246605 | 2246605 | 2022-02-24 | Montgomery | Iowa | 19137 | 2183 | 52 |
2248130 | 2248130 | 2022-02-24 | Penuelas | Puerto Rico | 72111 | 2183 | |
2243354 | 2243354 | 2022-02-23 | Montgomery | Iowa | 19137 | 2183 | 52 |
2239813 | 2239813 | 2022-02-22 | Clearwater | Idaho | 16035 | 2183 | 31 |
2229586 | 2229586 | 2022-02-19 | Greenlee | Arizona | 4011 | 2183 | 31 |
2220852 | 2220852 | 2022-02-16 | Wolfe | Kentucky | 21237 | 2183 | 18 |
2203186 | 2203186 | 2022-02-10 | Essex | Virginia | 51057 | 2183 | 24 |
2198704 | 2198704 | 2022-02-09 | Phelps | Nebraska | 31137 | 2183 | 12 |
2180872 | 2180872 | 2022-02-04 | Scott | Arkansas | 5127 | 2183 | 36 |
2177086 | 2177086 | 2022-02-02 | Grand | Utah | 49019 | 2183 | 6 |
2165971 | 2165971 | 2022-01-30 | Grundy | Missouri | 29079 | 2183 | 61 |
2145401 | 2145401 | 2022-01-24 | McIntosh | Georgia | 13191 | 2183 | 35 |
2146470 | 2146470 | 2022-01-24 | Linn | Missouri | 29115 | 2183 | 59 |
2144020 | 2144020 | 2022-01-23 | Florida | Puerto Rico | 72054 | 2183 | |
2144162 | 2144162 | 2022-01-23 | Lake | South Dakota | 46079 | 2183 | 26 |
2140907 | 2140907 | 2022-01-22 | Lake | South Dakota | 46079 | 2183 | 26 |
2141293 | 2141293 | 2022-01-22 | Emery | Utah | 49015 | 2183 | 25 |
2137651 | 2137651 | 2022-01-21 | Lake | South Dakota | 46079 | 2183 | 26 |
2130057 | 2130057 | 2022-01-19 | Yellow Medicine | Minnesota | 27173 | 2183 | 26 |
2124990 | 2124990 | 2022-01-17 | Trinity | Texas | 48455 | 2183 | 65 |
2063761 | 2063761 | 2021-12-30 | Little River | Arkansas | 5081 | 2183 | 84 |
2060338 | 2060338 | 2021-12-28 | Big Horn | Wyoming | 56003 | 2183 | 58 |
2055895 | 2055895 | 2021-12-27 | McLean | North Dakota | 38055 | 2183 | 47 |
2031021 | 2031021 | 2021-12-19 | Bayfield | Wisconsin | 55007 | 2183 | 31 |
2027770 | 2027770 | 2021-12-18 | Bayfield | Wisconsin | 55007 | 2183 | 31 |
2024519 | 2024519 | 2021-12-17 | Bayfield | Wisconsin | 55007 | 2183 | 31 |
1959749 | 1959749 | 2021-11-28 | Lee | Arkansas | 5077 | 2183 | 52 |
1962210 | 1962210 | 2021-11-28 | Stewart | Tennessee | 47161 | 2183 | 35 |
1956498 | 1956498 | 2021-11-27 | Lee | Arkansas | 5077 | 2183 | 52 |
1958959 | 1958959 | 2021-11-27 | Stewart | Tennessee | 47161 | 2183 | 35 |
1955708 | 1955708 | 2021-11-26 | Stewart | Tennessee | 47161 | 2183 | 35 |
1952457 | 1952457 | 2021-11-25 | Stewart | Tennessee | 47161 | 2183 | 35 |
1949206 | 1949206 | 2021-11-24 | Stewart | Tennessee | 47161 | 2183 | 35 |
1945955 | 1945955 | 2021-11-23 | Stewart | Tennessee | 47161 | 2183 | 35 |
1927003 | 1927003 | 2021-11-17 | Buffalo | Wisconsin | 55011 | 2183 | 8 |
1916453 | 1916453 | 2021-11-14 | Fajardo | Puerto Rico | 72053 | 2183 |
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);