ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
609 rows where cases = 566 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 71
- Minnesota 58
- Texas 39
- Iowa 29
- Virginia 27
- Kentucky 26
- Georgia 25
- Puerto Rico 24
- South Dakota 19
- New Mexico 18
- Missouri 16
- Illinois 15
- North Dakota 15
- Colorado 14
- Michigan 14
- Idaho 13
- Mississippi 13
- Tennessee 13
- West Virginia 13
- California 12
- Louisiana 12
- Nebraska 12
- Alabama 9
- North Carolina 9
- Arkansas 8
- Indiana 7
- Montana 7
- New York 7
- Oklahoma 7
- Pennsylvania 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501745 | 2501745 | 2022-05-13 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2498487 | 2498487 | 2022-05-12 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2428858 | 2428858 | 2022-04-21 | Graham | Kansas | 20065 | 566 | 15 |
2425602 | 2425602 | 2022-04-20 | Graham | Kansas | 20065 | 566 | 15 |
2422346 | 2422346 | 2022-04-19 | Graham | Kansas | 20065 | 566 | 15 |
2419090 | 2419090 | 2022-04-18 | Graham | Kansas | 20065 | 566 | 15 |
2415834 | 2415834 | 2022-04-17 | Graham | Kansas | 20065 | 566 | 15 |
2417290 | 2417290 | 2022-04-17 | Maricao | Puerto Rico | 72093 | 566 | |
2412578 | 2412578 | 2022-04-16 | Graham | Kansas | 20065 | 566 | 15 |
2409322 | 2409322 | 2022-04-15 | Graham | Kansas | 20065 | 566 | 15 |
2406066 | 2406066 | 2022-04-14 | Graham | Kansas | 20065 | 566 | 15 |
2402810 | 2402810 | 2022-04-13 | Graham | Kansas | 20065 | 566 | 15 |
2399556 | 2399556 | 2022-04-12 | Graham | Kansas | 20065 | 566 | 15 |
2396300 | 2396300 | 2022-04-11 | Graham | Kansas | 20065 | 566 | 15 |
2393045 | 2393045 | 2022-04-10 | Graham | Kansas | 20065 | 566 | 15 |
2389789 | 2389789 | 2022-04-09 | Graham | Kansas | 20065 | 566 | 15 |
2386533 | 2386533 | 2022-04-08 | Graham | Kansas | 20065 | 566 | 15 |
2383279 | 2383279 | 2022-04-07 | Graham | Kansas | 20065 | 566 | 15 |
2380024 | 2380024 | 2022-04-06 | Graham | Kansas | 20065 | 566 | 15 |
2376769 | 2376769 | 2022-04-05 | Graham | Kansas | 20065 | 566 | 15 |
2373517 | 2373517 | 2022-04-04 | Graham | Kansas | 20065 | 566 | 15 |
2370264 | 2370264 | 2022-04-03 | Graham | Kansas | 20065 | 566 | 15 |
2367011 | 2367011 | 2022-04-02 | Graham | Kansas | 20065 | 566 | 15 |
2363758 | 2363758 | 2022-04-01 | Graham | Kansas | 20065 | 566 | 15 |
2360504 | 2360504 | 2022-03-31 | Graham | Kansas | 20065 | 566 | 14 |
2357250 | 2357250 | 2022-03-30 | Graham | Kansas | 20065 | 566 | 14 |
2353997 | 2353997 | 2022-03-29 | Graham | Kansas | 20065 | 566 | 14 |
2350745 | 2350745 | 2022-03-28 | Graham | Kansas | 20065 | 566 | 14 |
2347492 | 2347492 | 2022-03-27 | Graham | Kansas | 20065 | 566 | 14 |
2344239 | 2344239 | 2022-03-26 | Graham | Kansas | 20065 | 566 | 14 |
2340986 | 2340986 | 2022-03-25 | Graham | Kansas | 20065 | 566 | 14 |
2267067 | 2267067 | 2022-03-02 | De Baca | New Mexico | 35011 | 566 | 5 |
2263816 | 2263816 | 2022-03-01 | De Baca | New Mexico | 35011 | 566 | 5 |
2260565 | 2260565 | 2022-02-28 | De Baca | New Mexico | 35011 | 566 | 5 |
2257314 | 2257314 | 2022-02-27 | De Baca | New Mexico | 35011 | 566 | 5 |
2254063 | 2254063 | 2022-02-26 | De Baca | New Mexico | 35011 | 566 | 5 |
2250812 | 2250812 | 2022-02-25 | De Baca | New Mexico | 35011 | 566 | 5 |
2246661 | 2246661 | 2022-02-24 | Elk | Kansas | 20049 | 566 | 8 |
2247561 | 2247561 | 2022-02-24 | De Baca | New Mexico | 35011 | 566 | 5 |
2243410 | 2243410 | 2022-02-23 | Elk | Kansas | 20049 | 566 | 8 |
2244310 | 2244310 | 2022-02-23 | De Baca | New Mexico | 35011 | 566 | 5 |
2241059 | 2241059 | 2022-02-22 | De Baca | New Mexico | 35011 | 566 | 5 |
2237808 | 2237808 | 2022-02-21 | De Baca | New Mexico | 35011 | 566 | 5 |
2238507 | 2238507 | 2022-02-21 | Sanborn | South Dakota | 46111 | 566 | 6 |
2235256 | 2235256 | 2022-02-20 | Sanborn | South Dakota | 46111 | 566 | 6 |
2232005 | 2232005 | 2022-02-19 | Sanborn | South Dakota | 46111 | 566 | 6 |
2228754 | 2228754 | 2022-02-18 | Sanborn | South Dakota | 46111 | 566 | 6 |
2225503 | 2225503 | 2022-02-17 | Sanborn | South Dakota | 46111 | 566 | 6 |
2222252 | 2222252 | 2022-02-16 | Sanborn | South Dakota | 46111 | 566 | 6 |
2205479 | 2205479 | 2022-02-11 | Adams | North Dakota | 38001 | 566 | 9 |
2175297 | 2175297 | 2022-02-02 | Robertson | Kentucky | 21201 | 566 | 20 |
2153470 | 2153470 | 2022-01-26 | Towner | North Dakota | 38095 | 566 | 11 |
2149114 | 2149114 | 2022-01-25 | Lincoln | Kansas | 20105 | 566 | 8 |
2145862 | 2145862 | 2022-01-24 | Lincoln | Kansas | 20105 | 566 | 8 |
2126376 | 2126376 | 2022-01-18 | Smith | Kansas | 20183 | 566 | 5 |
2127905 | 2127905 | 2022-01-18 | Perkins | South Dakota | 46105 | 566 | 16 |
2123124 | 2123124 | 2022-01-17 | Smith | Kansas | 20183 | 566 | 5 |
2119872 | 2119872 | 2022-01-16 | Smith | Kansas | 20183 | 566 | 5 |
2116620 | 2116620 | 2022-01-15 | Smith | Kansas | 20183 | 566 | 5 |
2113369 | 2113369 | 2022-01-14 | Smith | Kansas | 20183 | 566 | 5 |
2102041 | 2102041 | 2022-01-10 | Cochran | Texas | 48079 | 566 | 21 |
2098790 | 2098790 | 2022-01-09 | Cochran | Texas | 48079 | 566 | 21 |
2083188 | 2083188 | 2022-01-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 566 | 1 |
2079936 | 2079936 | 2022-01-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 566 | 1 |
2081892 | 2081892 | 2022-01-04 | Hettinger | North Dakota | 38041 | 566 | 7 |
2076684 | 2076684 | 2022-01-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 566 | 1 |
2077980 | 2077980 | 2022-01-03 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2074729 | 2074729 | 2022-01-02 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2071478 | 2071478 | 2022-01-01 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2068227 | 2068227 | 2021-12-31 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2064976 | 2064976 | 2021-12-30 | Lake of the Woods | Minnesota | 27077 | 566 | 5 |
2062122 | 2062122 | 2021-12-29 | Webster | Nebraska | 31181 | 566 | 9 |
2037882 | 2037882 | 2021-12-22 | Gilpin | Colorado | 8047 | 566 | 3 |
2028826 | 2028826 | 2021-12-19 | Ness | Kansas | 20135 | 566 | 17 |
2030697 | 2030697 | 2021-12-19 | Shackelford | Texas | 48417 | 566 | 7 |
2025575 | 2025575 | 2021-12-18 | Ness | Kansas | 20135 | 566 | 17 |
2027446 | 2027446 | 2021-12-18 | Shackelford | Texas | 48417 | 566 | 7 |
2022324 | 2022324 | 2021-12-17 | Ness | Kansas | 20135 | 566 | 17 |
2018430 | 2018430 | 2021-12-16 | Unknown | Delaware | 566 | 0 | |
2020450 | 2020450 | 2021-12-16 | Arroyo | Puerto Rico | 72015 | 566 | |
2017199 | 2017199 | 2021-12-15 | Arroyo | Puerto Rico | 72015 | 566 | |
2013949 | 2013949 | 2021-12-14 | Arroyo | Puerto Rico | 72015 | 566 | |
1996327 | 1996327 | 2021-12-09 | Rawlins | Kansas | 20153 | 566 | 7 |
1997374 | 1997374 | 2021-12-09 | Eddy | North Dakota | 38027 | 566 | 6 |
1997830 | 1997830 | 2021-12-09 | Clark | South Dakota | 46025 | 566 | 5 |
1993076 | 1993076 | 2021-12-08 | Rawlins | Kansas | 20153 | 566 | 7 |
1994123 | 1994123 | 2021-12-08 | Eddy | North Dakota | 38027 | 566 | 6 |
1989831 | 1989831 | 2021-12-07 | Rush | Kansas | 20165 | 566 | 16 |
1990872 | 1990872 | 2021-12-07 | Eddy | North Dakota | 38027 | 566 | 6 |
1986581 | 1986581 | 2021-12-06 | Rush | Kansas | 20165 | 566 | 16 |
1982601 | 1982601 | 2021-12-05 | Baca | Colorado | 8009 | 566 | 6 |
1979351 | 1979351 | 2021-12-04 | Baca | Colorado | 8009 | 566 | 6 |
1976101 | 1976101 | 2021-12-03 | Baca | Colorado | 8009 | 566 | 6 |
1972852 | 1972852 | 2021-12-02 | Baca | Colorado | 8009 | 566 | 6 |
1974990 | 1974990 | 2021-12-02 | Patillas | Puerto Rico | 72109 | 566 | |
1969602 | 1969602 | 2021-12-01 | Baca | Colorado | 8009 | 566 | 6 |
1971368 | 1971368 | 2021-12-01 | Cavalier | North Dakota | 38019 | 566 | 5 |
1971741 | 1971741 | 2021-12-01 | Patillas | Puerto Rico | 72109 | 566 | |
1968491 | 1968491 | 2021-11-30 | Patillas | Puerto Rico | 72109 | 566 | |
1965240 | 1965240 | 2021-11-29 | Patillas | Puerto Rico | 72109 | 566 |
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);