ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where cases = 1516 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 36
- Iowa 33
- Kansas 28
- Nebraska 23
- Illinois 18
- Puerto Rico 18
- Louisiana 17
- Texas 17
- Oklahoma 16
- Colorado 14
- Kentucky 14
- Indiana 11
- Alabama 10
- Florida 10
- Michigan 10
- Ohio 10
- Tennessee 10
- Virginia 10
- Wyoming 10
- Arkansas 9
- Missouri 9
- West Virginia 9
- South Carolina 7
- South Dakota 7
- Montana 6
- Idaho 5
- New Mexico 5
- New York 5
- Wisconsin 5
- Minnesota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490625 | 2490625 | 2022-05-10 | Decatur | Iowa | 19053 | 1516 | 26 |
2487368 | 2487368 | 2022-05-09 | Decatur | Iowa | 19053 | 1516 | 26 |
2484110 | 2484110 | 2022-05-08 | Decatur | Iowa | 19053 | 1516 | 26 |
2480852 | 2480852 | 2022-05-07 | Decatur | Iowa | 19053 | 1516 | 26 |
2482778 | 2482778 | 2022-05-07 | Jack | Texas | 48237 | 1516 | 28 |
2477594 | 2477594 | 2022-05-06 | Decatur | Iowa | 19053 | 1516 | 26 |
2474336 | 2474336 | 2022-05-05 | Decatur | Iowa | 19053 | 1516 | 26 |
2471079 | 2471079 | 2022-05-04 | Decatur | Iowa | 19053 | 1516 | 26 |
2468690 | 2468690 | 2022-05-03 | Clay | Nebraska | 31035 | 1516 | 24 |
2465434 | 2465434 | 2022-05-02 | Clay | Nebraska | 31035 | 1516 | 24 |
2462179 | 2462179 | 2022-05-01 | Clay | Nebraska | 31035 | 1516 | 24 |
2458923 | 2458923 | 2022-04-30 | Clay | Nebraska | 31035 | 1516 | 24 |
2455667 | 2455667 | 2022-04-29 | Clay | Nebraska | 31035 | 1516 | 24 |
2452411 | 2452411 | 2022-04-28 | Clay | Nebraska | 31035 | 1516 | 24 |
2449155 | 2449155 | 2022-04-27 | Clay | Nebraska | 31035 | 1516 | 24 |
2444694 | 2444694 | 2022-04-26 | Marion | Georgia | 13197 | 1516 | 50 |
2445898 | 2445898 | 2022-04-26 | Clay | Nebraska | 31035 | 1516 | 24 |
2441438 | 2441438 | 2022-04-25 | Marion | Georgia | 13197 | 1516 | 50 |
2442643 | 2442643 | 2022-04-25 | Clay | Nebraska | 31035 | 1516 | 24 |
2438182 | 2438182 | 2022-04-24 | Marion | Georgia | 13197 | 1516 | 50 |
2439387 | 2439387 | 2022-04-24 | Clay | Nebraska | 31035 | 1516 | 24 |
2434926 | 2434926 | 2022-04-23 | Marion | Georgia | 13197 | 1516 | 50 |
2436131 | 2436131 | 2022-04-23 | Clay | Nebraska | 31035 | 1516 | 24 |
2431670 | 2431670 | 2022-04-22 | Marion | Georgia | 13197 | 1516 | 50 |
2432875 | 2432875 | 2022-04-22 | Clay | Nebraska | 31035 | 1516 | 24 |
2428414 | 2428414 | 2022-04-21 | Marion | Georgia | 13197 | 1516 | 50 |
2429619 | 2429619 | 2022-04-21 | Clay | Nebraska | 31035 | 1516 | 24 |
2425158 | 2425158 | 2022-04-20 | Marion | Georgia | 13197 | 1516 | 50 |
2426363 | 2426363 | 2022-04-20 | Clay | Nebraska | 31035 | 1516 | 24 |
2421902 | 2421902 | 2022-04-19 | Marion | Georgia | 13197 | 1516 | 50 |
2423107 | 2423107 | 2022-04-19 | Clay | Nebraska | 31035 | 1516 | 24 |
2418646 | 2418646 | 2022-04-18 | Marion | Georgia | 13197 | 1516 | 50 |
2415390 | 2415390 | 2022-04-17 | Marion | Georgia | 13197 | 1516 | 50 |
2412134 | 2412134 | 2022-04-16 | Marion | Georgia | 13197 | 1516 | 50 |
2408878 | 2408878 | 2022-04-15 | Marion | Georgia | 13197 | 1516 | 50 |
2405622 | 2405622 | 2022-04-14 | Marion | Georgia | 13197 | 1516 | 50 |
2402367 | 2402367 | 2022-04-13 | Marion | Georgia | 13197 | 1516 | 50 |
2343469 | 2343469 | 2022-03-26 | Montgomery | Arkansas | 5097 | 1516 | 57 |
2330551 | 2330551 | 2022-03-22 | Clear Creek | Colorado | 8019 | 1516 | 12 |
2291873 | 2291873 | 2022-03-10 | Calhoun | Illinois | 17013 | 1516 | 8 |
2288621 | 2288621 | 2022-03-09 | Calhoun | Illinois | 17013 | 1516 | 8 |
2285370 | 2285370 | 2022-03-08 | Calhoun | Illinois | 17013 | 1516 | 8 |
2282118 | 2282118 | 2022-03-07 | Calhoun | Illinois | 17013 | 1516 | 8 |
2189214 | 2189214 | 2022-02-06 | Bottineau | North Dakota | 38009 | 1516 | 24 |
2185961 | 2185961 | 2022-02-05 | Bottineau | North Dakota | 38009 | 1516 | 24 |
2171402 | 2171402 | 2022-02-01 | Hancock | Georgia | 13141 | 1516 | 86 |
2161435 | 2161435 | 2022-01-29 | Conejos | Colorado | 8021 | 1516 | 49 |
2159452 | 2159452 | 2022-01-28 | Daviess | Missouri | 29061 | 1516 | 24 |
2154926 | 2154926 | 2022-01-27 | Conejos | Colorado | 8021 | 1516 | 49 |
2153084 | 2153084 | 2022-01-26 | Valley | Montana | 30105 | 1516 | 33 |
2151047 | 2151047 | 2022-01-25 | Beaver | Utah | 49001 | 1516 | 14 |
2143263 | 2143263 | 2022-01-23 | Sullivan | Missouri | 29211 | 1516 | 19 |
2134381 | 2134381 | 2022-01-20 | Fall River | South Dakota | 46047 | 1516 | 34 |
2126632 | 2126632 | 2022-01-18 | Alcona | Michigan | 26001 | 1516 | 60 |
2123380 | 2123380 | 2022-01-17 | Alcona | Michigan | 26001 | 1516 | 60 |
2120128 | 2120128 | 2022-01-16 | Alcona | Michigan | 26001 | 1516 | 60 |
2121608 | 2121608 | 2022-01-16 | Hansford | Texas | 48195 | 1516 | 27 |
2116876 | 2116876 | 2022-01-15 | Alcona | Michigan | 26001 | 1516 | 60 |
2118356 | 2118356 | 2022-01-15 | Hansford | Texas | 48195 | 1516 | 27 |
2118769 | 2118769 | 2022-01-15 | Pendleton | West Virginia | 54071 | 1516 | 16 |
2113625 | 2113625 | 2022-01-14 | Alcona | Michigan | 26001 | 1516 | 60 |
2107568 | 2107568 | 2022-01-12 | Cuming | Nebraska | 31039 | 1516 | 15 |
2101765 | 2101765 | 2022-01-10 | Penuelas | Puerto Rico | 72111 | 1516 | |
2087314 | 2087314 | 2022-01-06 | Kingman | Kansas | 20095 | 1516 | 24 |
2083218 | 2083218 | 2022-01-05 | Greenlee | Arizona | 4011 | 1516 | 27 |
2084062 | 2084062 | 2022-01-05 | Kingman | Kansas | 20095 | 1516 | 24 |
2077734 | 2077734 | 2022-01-03 | Wolfe | Kentucky | 21237 | 1516 | 14 |
2074525 | 2074525 | 2022-01-02 | Red River | Louisiana | 22081 | 1516 | 49 |
2071274 | 2071274 | 2022-01-01 | Red River | Louisiana | 22081 | 1516 | 49 |
2068023 | 2068023 | 2021-12-31 | Red River | Louisiana | 22081 | 1516 | 49 |
2064772 | 2064772 | 2021-12-30 | Red River | Louisiana | 22081 | 1516 | 49 |
2054496 | 2054496 | 2021-12-27 | Hamilton | Illinois | 17065 | 1516 | 27 |
2051797 | 2051797 | 2021-12-26 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2048547 | 2048547 | 2021-12-25 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2045297 | 2045297 | 2021-12-24 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2042048 | 2042048 | 2021-12-23 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2038798 | 2038798 | 2021-12-22 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2035548 | 2035548 | 2021-12-21 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2032298 | 2032298 | 2021-12-20 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2029047 | 2029047 | 2021-12-19 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2025796 | 2025796 | 2021-12-18 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2022545 | 2022545 | 2021-12-17 | West Feliciana | Louisiana | 22125 | 1516 | 41 |
2012072 | 2012072 | 2021-12-14 | Heard | Georgia | 13149 | 1516 | 42 |
2009925 | 2009925 | 2021-12-13 | Monroe | Missouri | 29137 | 1516 | 32 |
2006674 | 2006674 | 2021-12-12 | Monroe | Missouri | 29137 | 1516 | 32 |
2006821 | 2006821 | 2021-12-12 | Holt | Nebraska | 31089 | 1516 | 16 |
2003423 | 2003423 | 2021-12-11 | Monroe | Missouri | 29137 | 1516 | 32 |
2003570 | 2003570 | 2021-12-11 | Holt | Nebraska | 31089 | 1516 | 16 |
2000320 | 2000320 | 2021-12-10 | Holt | Nebraska | 31089 | 1516 | 16 |
1984737 | 1984737 | 2021-12-05 | Naguabo | Puerto Rico | 72103 | 1516 | |
1981487 | 1981487 | 2021-12-04 | Naguabo | Puerto Rico | 72103 | 1516 | |
1978237 | 1978237 | 2021-12-03 | Naguabo | Puerto Rico | 72103 | 1516 | |
1974987 | 1974987 | 2021-12-02 | Naguabo | Puerto Rico | 72103 | 1516 | |
1971738 | 1971738 | 2021-12-01 | Naguabo | Puerto Rico | 72103 | 1516 | |
1968488 | 1968488 | 2021-11-30 | Naguabo | Puerto Rico | 72103 | 1516 | |
1965237 | 1965237 | 2021-11-29 | Naguabo | Puerto Rico | 72103 | 1516 | |
1961985 | 1961985 | 2021-11-28 | Naguabo | Puerto Rico | 72103 | 1516 | |
1958734 | 1958734 | 2021-11-27 | Naguabo | Puerto Rico | 72103 | 1516 | |
1955483 | 1955483 | 2021-11-26 | Naguabo | Puerto Rico | 72103 | 1516 | |
1952232 | 1952232 | 2021-11-25 | Naguabo | Puerto Rico | 72103 | 1516 |
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);