ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
660 rows where cases = 667 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 75
- Puerto Rico 60
- Texas 52
- Virginia 44
- South Dakota 37
- Iowa 33
- Kentucky 32
- Missouri 28
- West Virginia 24
- Michigan 20
- Georgia 18
- Arkansas 15
- Colorado 15
- Illinois 14
- Nebraska 13
- Minnesota 12
- Indiana 11
- Massachusetts 11
- Mississippi 11
- North Carolina 11
- Ohio 10
- New Mexico 8
- Oklahoma 8
- Tennessee 8
- Wyoming 8
- Alabama 7
- Idaho 7
- Louisiana 7
- Utah 7
- Washington 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500521 | 2500521 | 2022-05-13 | Kiowa | Kansas | 20097 | 667 | 7 |
2406082 | 2406082 | 2022-04-14 | Kiowa | Kansas | 20097 | 667 | 7 |
2402826 | 2402826 | 2022-04-13 | Kiowa | Kansas | 20097 | 667 | 7 |
2399572 | 2399572 | 2022-04-12 | Kiowa | Kansas | 20097 | 667 | 7 |
2396316 | 2396316 | 2022-04-11 | Kiowa | Kansas | 20097 | 667 | 7 |
2393061 | 2393061 | 2022-04-10 | Kiowa | Kansas | 20097 | 667 | 7 |
2389805 | 2389805 | 2022-04-09 | Kiowa | Kansas | 20097 | 667 | 7 |
2386549 | 2386549 | 2022-04-08 | Kiowa | Kansas | 20097 | 667 | 7 |
2383295 | 2383295 | 2022-04-07 | Kiowa | Kansas | 20097 | 667 | 7 |
2380040 | 2380040 | 2022-04-06 | Kiowa | Kansas | 20097 | 667 | 7 |
2376785 | 2376785 | 2022-04-05 | Kiowa | Kansas | 20097 | 667 | 7 |
2373533 | 2373533 | 2022-04-04 | Kiowa | Kansas | 20097 | 667 | 7 |
2370280 | 2370280 | 2022-04-03 | Kiowa | Kansas | 20097 | 667 | 7 |
2367027 | 2367027 | 2022-04-02 | Kiowa | Kansas | 20097 | 667 | 7 |
2363774 | 2363774 | 2022-04-01 | Kiowa | Kansas | 20097 | 667 | 7 |
2360520 | 2360520 | 2022-03-31 | Kiowa | Kansas | 20097 | 667 | 7 |
2357266 | 2357266 | 2022-03-30 | Kiowa | Kansas | 20097 | 667 | 7 |
2354013 | 2354013 | 2022-03-29 | Kiowa | Kansas | 20097 | 667 | 7 |
2350761 | 2350761 | 2022-03-28 | Kiowa | Kansas | 20097 | 667 | 7 |
2347508 | 2347508 | 2022-03-27 | Kiowa | Kansas | 20097 | 667 | 7 |
2344255 | 2344255 | 2022-03-26 | Kiowa | Kansas | 20097 | 667 | 7 |
2341002 | 2341002 | 2022-03-25 | Kiowa | Kansas | 20097 | 667 | 7 |
2307781 | 2307781 | 2022-03-15 | Costilla | Colorado | 8023 | 667 | 15 |
2310056 | 2310056 | 2022-03-15 | Ziebach | South Dakota | 46137 | 667 | 11 |
2304530 | 2304530 | 2022-03-14 | Costilla | Colorado | 8023 | 667 | 15 |
2301278 | 2301278 | 2022-03-13 | Costilla | Colorado | 8023 | 667 | 15 |
2298026 | 2298026 | 2022-03-12 | Costilla | Colorado | 8023 | 667 | 15 |
2294774 | 2294774 | 2022-03-11 | Costilla | Colorado | 8023 | 667 | 15 |
2285707 | 2285707 | 2022-03-08 | Kiowa | Kansas | 20097 | 667 | 7 |
2282455 | 2282455 | 2022-03-07 | Kiowa | Kansas | 20097 | 667 | 7 |
2279202 | 2279202 | 2022-03-06 | Kiowa | Kansas | 20097 | 667 | 7 |
2275949 | 2275949 | 2022-03-05 | Kiowa | Kansas | 20097 | 667 | 7 |
2272696 | 2272696 | 2022-03-04 | Kiowa | Kansas | 20097 | 667 | 7 |
2269444 | 2269444 | 2022-03-03 | Kiowa | Kansas | 20097 | 667 | 7 |
2266191 | 2266191 | 2022-03-02 | Kiowa | Kansas | 20097 | 667 | 7 |
2262940 | 2262940 | 2022-03-01 | Kiowa | Kansas | 20097 | 667 | 7 |
2259689 | 2259689 | 2022-02-28 | Kiowa | Kansas | 20097 | 667 | 7 |
2256438 | 2256438 | 2022-02-27 | Kiowa | Kansas | 20097 | 667 | 7 |
2253187 | 2253187 | 2022-02-26 | Kiowa | Kansas | 20097 | 667 | 7 |
2249936 | 2249936 | 2022-02-25 | Kiowa | Kansas | 20097 | 667 | 7 |
2246685 | 2246685 | 2022-02-24 | Kiowa | Kansas | 20097 | 667 | 7 |
2243434 | 2243434 | 2022-02-23 | Kiowa | Kansas | 20097 | 667 | 7 |
2240183 | 2240183 | 2022-02-22 | Kiowa | Kansas | 20097 | 667 | 7 |
2236932 | 2236932 | 2022-02-21 | Kiowa | Kansas | 20097 | 667 | 7 |
2233681 | 2233681 | 2022-02-20 | Kiowa | Kansas | 20097 | 667 | 7 |
2230430 | 2230430 | 2022-02-19 | Kiowa | Kansas | 20097 | 667 | 7 |
2227179 | 2227179 | 2022-02-18 | Kiowa | Kansas | 20097 | 667 | 7 |
2217386 | 2217386 | 2022-02-15 | Chase | Kansas | 20017 | 667 | 9 |
2214135 | 2214135 | 2022-02-14 | Chase | Kansas | 20017 | 667 | 9 |
2211571 | 2211571 | 2022-02-13 | Scotland | Missouri | 29199 | 667 | 17 |
2208318 | 2208318 | 2022-02-12 | Scotland | Missouri | 29199 | 667 | 17 |
2205065 | 2205065 | 2022-02-11 | Scotland | Missouri | 29199 | 667 | 17 |
2201812 | 2201812 | 2022-02-10 | Scotland | Missouri | 29199 | 667 | 17 |
2201846 | 2201846 | 2022-02-10 | Fallon | Montana | 30025 | 667 | 10 |
2175787 | 2175787 | 2022-02-02 | Schuyler | Missouri | 29197 | 667 | 24 |
2173427 | 2173427 | 2022-02-01 | Douglas | South Dakota | 46043 | 667 | 15 |
2149924 | 2149924 | 2022-01-25 | Valley | Nebraska | 31175 | 667 | 5 |
2145162 | 2145162 | 2022-01-24 | Baca | Colorado | 8009 | 667 | 8 |
2134677 | 2134677 | 2022-01-20 | Mason | Texas | 48319 | 667 | 9 |
2124612 | 2124612 | 2022-01-17 | Clark | South Dakota | 46025 | 667 | 6 |
2121360 | 2121360 | 2022-01-16 | Clark | South Dakota | 46025 | 667 | 6 |
2118108 | 2118108 | 2022-01-15 | Clark | South Dakota | 46025 | 667 | 6 |
2114857 | 2114857 | 2022-01-14 | Clark | South Dakota | 46025 | 667 | 6 |
2110115 | 2110115 | 2022-01-13 | Sheridan | Kansas | 20179 | 667 | 17 |
2106864 | 2106864 | 2022-01-12 | Sheridan | Kansas | 20179 | 667 | 17 |
2103533 | 2103533 | 2022-01-11 | Chautauqua | Kansas | 20019 | 667 | 16 |
2100282 | 2100282 | 2022-01-10 | Chautauqua | Kansas | 20019 | 667 | 16 |
2091898 | 2091898 | 2022-01-07 | Cameron | Pennsylvania | 42023 | 667 | 13 |
2051512 | 2051512 | 2021-12-26 | Barber | Kansas | 20007 | 667 | 7 |
2048262 | 2048262 | 2021-12-25 | Barber | Kansas | 20007 | 667 | 7 |
2045012 | 2045012 | 2021-12-24 | Barber | Kansas | 20007 | 667 | 7 |
2041763 | 2041763 | 2021-12-23 | Barber | Kansas | 20007 | 667 | 7 |
2038513 | 2038513 | 2021-12-22 | Barber | Kansas | 20007 | 667 | 7 |
2017890 | 2017890 | 2021-12-15 | Rappahannock | Virginia | 51157 | 667 | 6 |
2013159 | 2013159 | 2021-12-14 | Knox | Missouri | 29103 | 667 | 8 |
1992782 | 1992782 | 2021-12-08 | Putnam | Illinois | 17155 | 667 | 6 |
1977863 | 1977863 | 2021-12-03 | Bowman | North Dakota | 38011 | 667 | 8 |
1974664 | 1974664 | 2021-12-02 | Unknown | Northern Mariana Islands | 667 | 0 | |
1962595 | 1962595 | 2021-11-28 | King and Queen | Virginia | 51097 | 667 | 8 |
1959344 | 1959344 | 2021-11-27 | King and Queen | Virginia | 51097 | 667 | 8 |
1956093 | 1956093 | 2021-11-26 | King and Queen | Virginia | 51097 | 667 | 8 |
1928114 | 1928114 | 2021-11-18 | Carlisle | Kentucky | 21039 | 667 | 12 |
1924864 | 1924864 | 2021-11-17 | Carlisle | Kentucky | 21039 | 667 | 12 |
1925578 | 1925578 | 2021-11-17 | Nuckolls | Nebraska | 31129 | 667 | 12 |
1877449 | 1877449 | 2021-11-02 | Ceiba | Puerto Rico | 72037 | 667 | |
1874200 | 1874200 | 2021-11-01 | Ceiba | Puerto Rico | 72037 | 667 | |
1874331 | 1874331 | 2021-11-01 | Deuel | South Dakota | 46039 | 667 | 11 |
1870951 | 1870951 | 2021-10-31 | Ceiba | Puerto Rico | 72037 | 667 | |
1867702 | 1867702 | 2021-10-30 | Ceiba | Puerto Rico | 72037 | 667 | |
1864453 | 1864453 | 2021-10-29 | Ceiba | Puerto Rico | 72037 | 667 | |
1861204 | 1861204 | 2021-10-28 | Ceiba | Puerto Rico | 72037 | 667 | |
1857633 | 1857633 | 2021-10-27 | LaMoure | North Dakota | 38045 | 667 | 17 |
1857955 | 1857955 | 2021-10-27 | Ceiba | Puerto Rico | 72037 | 667 | |
1858082 | 1858082 | 2021-10-27 | Corson | South Dakota | 46031 | 667 | 13 |
1854706 | 1854706 | 2021-10-26 | Ceiba | Puerto Rico | 72037 | 667 | |
1851457 | 1851457 | 2021-10-25 | Ceiba | Puerto Rico | 72037 | 667 | |
1848207 | 1848207 | 2021-10-24 | Ceiba | Puerto Rico | 72037 | 667 | |
1844957 | 1844957 | 2021-10-23 | Ceiba | Puerto Rico | 72037 | 667 | |
1841707 | 1841707 | 2021-10-22 | Ceiba | Puerto Rico | 72037 | 667 | |
1802700 | 1802700 | 2021-10-10 | Adjuntas | Puerto Rico | 72001 | 667 |
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);