ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
361 rows where cases = 1511 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 27
- Illinois 24
- Iowa 24
- Virginia 22
- Georgia 19
- Puerto Rico 18
- Michigan 17
- Nebraska 17
- Missouri 13
- Alabama 12
- Minnesota 12
- Arkansas 11
- Kentucky 11
- Mississippi 10
- Tennessee 10
- Indiana 9
- North Carolina 9
- Colorado 7
- Kansas 7
- Louisiana 7
- Nevada 7
- West Virginia 7
- Florida 6
- Montana 5
- Ohio 5
- Wisconsin 5
- Pennsylvania 4
- Vermont 4
- Maine 3
- New Mexico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502215 | 2502215 | 2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 |
2498957 | 2498957 | 2022-05-12 | Bailey | Texas | 48017 | 1511 | 39 |
2495699 | 2495699 | 2022-05-11 | Bailey | Texas | 48017 | 1511 | 39 |
2492441 | 2492441 | 2022-05-10 | Bailey | Texas | 48017 | 1511 | 39 |
2489183 | 2489183 | 2022-05-09 | Bailey | Texas | 48017 | 1511 | 39 |
2485926 | 2485926 | 2022-05-08 | Bailey | Texas | 48017 | 1511 | 39 |
2482668 | 2482668 | 2022-05-07 | Bailey | Texas | 48017 | 1511 | 39 |
2479410 | 2479410 | 2022-05-06 | Bailey | Texas | 48017 | 1511 | 39 |
2474500 | 2474500 | 2022-05-05 | Sherman | Kansas | 20181 | 1511 | 20 |
2476152 | 2476152 | 2022-05-05 | Bailey | Texas | 48017 | 1511 | 39 |
2471243 | 2471243 | 2022-05-04 | Sherman | Kansas | 20181 | 1511 | 20 |
2471946 | 2471946 | 2022-05-04 | Clay | Nebraska | 31035 | 1511 | 24 |
2467987 | 2467987 | 2022-05-03 | Sherman | Kansas | 20181 | 1511 | 20 |
2464732 | 2464732 | 2022-05-02 | Sherman | Kansas | 20181 | 1511 | 20 |
2461476 | 2461476 | 2022-05-01 | Sherman | Kansas | 20181 | 1511 | 20 |
2458220 | 2458220 | 2022-04-30 | Sherman | Kansas | 20181 | 1511 | 20 |
2454964 | 2454964 | 2022-04-29 | Sherman | Kansas | 20181 | 1511 | 20 |
2443702 | 2443702 | 2022-04-25 | Jack | Texas | 48237 | 1511 | 28 |
2422240 | 2422240 | 2022-04-19 | Decatur | Iowa | 19053 | 1511 | 26 |
2418984 | 2418984 | 2022-04-18 | Decatur | Iowa | 19053 | 1511 | 26 |
2419846 | 2419846 | 2022-04-18 | Cedar | Nebraska | 31027 | 1511 | 14 |
2415728 | 2415728 | 2022-04-17 | Decatur | Iowa | 19053 | 1511 | 26 |
2416591 | 2416591 | 2022-04-17 | Cedar | Nebraska | 31027 | 1511 | 14 |
2412472 | 2412472 | 2022-04-16 | Decatur | Iowa | 19053 | 1511 | 26 |
2413335 | 2413335 | 2022-04-16 | Cedar | Nebraska | 31027 | 1511 | 14 |
2409216 | 2409216 | 2022-04-15 | Decatur | Iowa | 19053 | 1511 | 26 |
2410079 | 2410079 | 2022-04-15 | Cedar | Nebraska | 31027 | 1511 | 14 |
2405825 | 2405825 | 2022-04-14 | Stark | Illinois | 17175 | 1511 | 32 |
2405960 | 2405960 | 2022-04-14 | Decatur | Iowa | 19053 | 1511 | 26 |
2406823 | 2406823 | 2022-04-14 | Cedar | Nebraska | 31027 | 1511 | 14 |
2402570 | 2402570 | 2022-04-13 | Stark | Illinois | 17175 | 1511 | 32 |
2402704 | 2402704 | 2022-04-13 | Decatur | Iowa | 19053 | 1511 | 26 |
2399315 | 2399315 | 2022-04-12 | Stark | Illinois | 17175 | 1511 | 32 |
2396060 | 2396060 | 2022-04-11 | Stark | Illinois | 17175 | 1511 | 32 |
2392804 | 2392804 | 2022-04-10 | Stark | Illinois | 17175 | 1511 | 32 |
2389548 | 2389548 | 2022-04-09 | Stark | Illinois | 17175 | 1511 | 32 |
2386293 | 2386293 | 2022-04-08 | Stark | Illinois | 17175 | 1511 | 32 |
2383038 | 2383038 | 2022-04-07 | Stark | Illinois | 17175 | 1511 | 32 |
2370024 | 2370024 | 2022-04-03 | Stark | Illinois | 17175 | 1511 | 32 |
2366771 | 2366771 | 2022-04-02 | Stark | Illinois | 17175 | 1511 | 32 |
2363518 | 2363518 | 2022-04-01 | Stark | Illinois | 17175 | 1511 | 32 |
2360264 | 2360264 | 2022-03-31 | Stark | Illinois | 17175 | 1511 | 32 |
2357010 | 2357010 | 2022-03-30 | Stark | Illinois | 17175 | 1511 | 32 |
2353757 | 2353757 | 2022-03-29 | Stark | Illinois | 17175 | 1511 | 32 |
2350505 | 2350505 | 2022-03-28 | Stark | Illinois | 17175 | 1511 | 32 |
2351500 | 2351500 | 2022-03-28 | Cedar | Nebraska | 31027 | 1511 | 14 |
2331119 | 2331119 | 2022-03-22 | Decatur | Iowa | 19053 | 1511 | 25 |
2327867 | 2327867 | 2022-03-21 | Decatur | Iowa | 19053 | 1511 | 25 |
2324614 | 2324614 | 2022-03-20 | Decatur | Iowa | 19053 | 1511 | 25 |
2321360 | 2321360 | 2022-03-19 | Decatur | Iowa | 19053 | 1511 | 25 |
2318106 | 2318106 | 2022-03-18 | Decatur | Iowa | 19053 | 1511 | 25 |
2318972 | 2318972 | 2022-03-18 | Clay | Nebraska | 31035 | 1511 | 23 |
2314853 | 2314853 | 2022-03-17 | Decatur | Iowa | 19053 | 1511 | 25 |
2315719 | 2315719 | 2022-03-17 | Clay | Nebraska | 31035 | 1511 | 23 |
2311600 | 2311600 | 2022-03-16 | Decatur | Iowa | 19053 | 1511 | 25 |
2312374 | 2312374 | 2022-03-16 | Shelby | Missouri | 29205 | 1511 | 15 |
2312466 | 2312466 | 2022-03-16 | Clay | Nebraska | 31035 | 1511 | 23 |
2305961 | 2305961 | 2022-03-14 | Clay | Nebraska | 31035 | 1511 | 23 |
2240334 | 2240334 | 2022-02-22 | Owsley | Kentucky | 21189 | 1511 | 23 |
2210275 | 2210275 | 2022-02-13 | Rio Blanco | Colorado | 8103 | 1511 | 13 |
2207022 | 2207022 | 2022-02-12 | Rio Blanco | Colorado | 8103 | 1511 | 13 |
2203769 | 2203769 | 2022-02-11 | Rio Blanco | Colorado | 8103 | 1511 | 13 |
2182709 | 2182709 | 2022-02-04 | Bottineau | North Dakota | 38009 | 1511 | 24 |
2172462 | 2172462 | 2022-02-01 | Clark | Missouri | 29045 | 1511 | 28 |
2172503 | 2172503 | 2022-02-01 | Maries | Missouri | 29125 | 1511 | 28 |
2168149 | 2168149 | 2022-01-31 | Hancock | Georgia | 13141 | 1511 | 86 |
2142976 | 2142976 | 2022-01-23 | Schoolcraft | Michigan | 26153 | 1511 | 12 |
2144327 | 2144327 | 2022-01-23 | Coleman | Texas | 48083 | 1511 | 64 |
2139721 | 2139721 | 2022-01-22 | Schoolcraft | Michigan | 26153 | 1511 | 12 |
2136465 | 2136465 | 2022-01-21 | Schoolcraft | Michigan | 26153 | 1511 | 12 |
2123917 | 2123917 | 2022-01-17 | White Pine | Nevada | 32033 | 1511 | 18 |
2120665 | 2120665 | 2022-01-16 | White Pine | Nevada | 32033 | 1511 | 18 |
2117413 | 2117413 | 2022-01-15 | White Pine | Nevada | 32033 | 1511 | 18 |
2114162 | 2114162 | 2022-01-14 | White Pine | Nevada | 32033 | 1511 | 18 |
2110910 | 2110910 | 2022-01-13 | White Pine | Nevada | 32033 | 1511 | 18 |
2112130 | 2112130 | 2022-01-13 | Lunenburg | Virginia | 51111 | 1511 | 24 |
2107531 | 2107531 | 2022-01-12 | Powell | Montana | 30077 | 1511 | 26 |
2107659 | 2107659 | 2022-01-12 | White Pine | Nevada | 32033 | 1511 | 18 |
2100741 | 2100741 | 2022-01-10 | Lake | Minnesota | 27075 | 1511 | 26 |
2087403 | 2087403 | 2022-01-06 | Elliott | Kentucky | 21063 | 1511 | 14 |
2089074 | 2089074 | 2022-01-06 | Franklin | Texas | 48159 | 1511 | 37 |
2083068 | 2083068 | 2022-01-04 | Pepin | Wisconsin | 55091 | 1511 | 15 |
2076308 | 2076308 | 2022-01-02 | Buena Vista city | Virginia | 51530 | 1511 | 34 |
2072151 | 2072151 | 2022-01-01 | Pembina | North Dakota | 38067 | 1511 | 15 |
2073057 | 2073057 | 2022-01-01 | Buena Vista city | Virginia | 51530 | 1511 | 34 |
2069806 | 2069806 | 2021-12-31 | Buena Vista city | Virginia | 51530 | 1511 | 34 |
2059589 | 2059589 | 2021-12-28 | Custer | South Dakota | 46033 | 1511 | 20 |
2053431 | 2053431 | 2021-12-26 | Red River | Texas | 48387 | 1511 | 57 |
2050181 | 2050181 | 2021-12-25 | Red River | Texas | 48387 | 1511 | 57 |
2046931 | 2046931 | 2021-12-24 | Red River | Texas | 48387 | 1511 | 57 |
2043681 | 2043681 | 2021-12-23 | Red River | Texas | 48387 | 1511 | 57 |
2036050 | 2036050 | 2021-12-21 | Cheyenne | Nebraska | 31033 | 1511 | 19 |
2019944 | 2019944 | 2021-12-16 | Quay | New Mexico | 35037 | 1511 | 26 |
1996136 | 1996136 | 2021-12-09 | Switzerland | Indiana | 18155 | 1511 | 13 |
1998193 | 1998193 | 2021-12-09 | Somervell | Texas | 48425 | 1511 | 25 |
1998437 | 1998437 | 2021-12-09 | Lincoln | Washington | 53043 | 1511 | 25 |
1960971 | 1960971 | 2021-11-28 | Marshall | Minnesota | 27089 | 1511 | 22 |
1957720 | 1957720 | 2021-11-27 | Marshall | Minnesota | 27089 | 1511 | 22 |
1954469 | 1954469 | 2021-11-26 | Marshall | Minnesota | 27089 | 1511 | 22 |
1946490 | 1946490 | 2021-11-23 | Summers | West Virginia | 54089 | 1511 | 32 |
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);