ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
228 rows where cases = 2123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Virginia 17
- Arkansas 16
- Texas 16
- Mississippi 14
- Missouri 11
- Indiana 10
- Iowa 9
- Kansas 9
- Kentucky 9
- North Carolina 8
- Tennessee 8
- Colorado 7
- Washington 7
- Minnesota 6
- Illinois 5
- Louisiana 5
- Nebraska 5
- Alabama 3
- Montana 3
- New York 3
- North Dakota 3
- Ohio 3
- Puerto Rico 3
- Utah 3
- Wisconsin 3
- California 2
- Florida 2
- Maryland 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491168 | 2491168 | 2022-05-10 | Lake | Minnesota | 27075 | 2123 | 28 |
2486718 | 2486718 | 2022-05-09 | Searcy | Arkansas | 5129 | 2123 | 48 |
2483460 | 2483460 | 2022-05-08 | Searcy | Arkansas | 5129 | 2123 | 48 |
2480202 | 2480202 | 2022-05-07 | Searcy | Arkansas | 5129 | 2123 | 48 |
2476944 | 2476944 | 2022-05-06 | Searcy | Arkansas | 5129 | 2123 | 48 |
2474411 | 2474411 | 2022-05-05 | Anderson | Kansas | 20003 | 2123 | 29 |
2471154 | 2471154 | 2022-05-04 | Anderson | Kansas | 20003 | 2123 | 29 |
2467898 | 2467898 | 2022-05-03 | Anderson | Kansas | 20003 | 2123 | 29 |
2464643 | 2464643 | 2022-05-02 | Anderson | Kansas | 20003 | 2123 | 29 |
2461387 | 2461387 | 2022-05-01 | Anderson | Kansas | 20003 | 2123 | 29 |
2458131 | 2458131 | 2022-04-30 | Anderson | Kansas | 20003 | 2123 | 29 |
2454875 | 2454875 | 2022-04-29 | Anderson | Kansas | 20003 | 2123 | 29 |
2359986 | 2359986 | 2022-03-31 | Candler | Georgia | 13043 | 2123 | 94 |
2355701 | 2355701 | 2022-03-29 | Archer | Texas | 48009 | 2123 | 28 |
2352448 | 2352448 | 2022-03-28 | Archer | Texas | 48009 | 2123 | 28 |
2349196 | 2349196 | 2022-03-27 | Archer | Texas | 48009 | 2123 | 28 |
2345943 | 2345943 | 2022-03-26 | Archer | Texas | 48009 | 2123 | 28 |
2328659 | 2328659 | 2022-03-21 | Beaverhead | Montana | 30001 | 2123 | 28 |
2287468 | 2287468 | 2022-03-08 | Franklin | Texas | 48159 | 2123 | 40 |
2266781 | 2266781 | 2022-03-02 | Gentry | Missouri | 29075 | 2123 | 30 |
2259774 | 2259774 | 2022-02-28 | Cumberland | Kentucky | 21057 | 2123 | 28 |
2260459 | 2260459 | 2022-02-28 | Holt | Nebraska | 31089 | 2123 | 18 |
2247099 | 2247099 | 2022-02-24 | Jackson | Minnesota | 27063 | 2123 | 17 |
2245504 | 2245504 | 2022-02-23 | Northampton | Virginia | 51131 | 2123 | 57 |
2242253 | 2242253 | 2022-02-22 | Northampton | Virginia | 51131 | 2123 | 56 |
2238762 | 2238762 | 2022-02-21 | Live Oak | Texas | 48297 | 2123 | 40 |
2239002 | 2239002 | 2022-02-21 | Northampton | Virginia | 51131 | 2123 | 56 |
2225999 | 2225999 | 2022-02-17 | Northumberland | Virginia | 51133 | 2123 | 42 |
2221158 | 2221158 | 2022-02-16 | Claiborne | Mississippi | 28021 | 2123 | 46 |
2217907 | 2217907 | 2022-02-15 | Claiborne | Mississippi | 28021 | 2123 | 46 |
2219497 | 2219497 | 2022-02-15 | Northumberland | Virginia | 51133 | 2123 | 42 |
2172619 | 2172619 | 2022-02-01 | Box Butte | Nebraska | 31013 | 2123 | 16 |
2169366 | 2169366 | 2022-01-31 | Box Butte | Nebraska | 31013 | 2123 | 16 |
2149197 | 2149197 | 2022-01-25 | Edmonson | Kentucky | 21061 | 2123 | 35 |
2146052 | 2146052 | 2022-01-24 | East Carroll | Louisiana | 22035 | 2123 | 35 |
2129839 | 2129839 | 2022-01-19 | Piscataquis | Maine | 23021 | 2123 | 23 |
2119365 | 2119365 | 2022-01-16 | Long | Georgia | 13183 | 2123 | 29 |
2116113 | 2116113 | 2022-01-15 | Long | Georgia | 13183 | 2123 | 29 |
2112862 | 2112862 | 2022-01-14 | Long | Georgia | 13183 | 2123 | 29 |
2084807 | 2084807 | 2022-01-05 | Colfax | Nebraska | 31037 | 2123 | 23 |
2077687 | 2077687 | 2022-01-03 | Lyon | Kentucky | 21143 | 2123 | 29 |
2075737 | 2075737 | 2022-01-02 | Lares | Puerto Rico | 72081 | 2123 | |
2032703 | 2032703 | 2021-12-20 | Ripley | Missouri | 29181 | 2123 | 50 |
2029280 | 2029280 | 2021-12-19 | Amite | Mississippi | 28005 | 2123 | 57 |
2026029 | 2026029 | 2021-12-18 | Amite | Mississippi | 28005 | 2123 | 57 |
2022778 | 2022778 | 2021-12-17 | Amite | Mississippi | 28005 | 2123 | 57 |
2000612 | 2000612 | 2021-12-10 | Barnes | North Dakota | 38003 | 2123 | 39 |
1980679 | 1980679 | 2021-12-04 | Pemiscot | Missouri | 29155 | 2123 | 57 |
1966700 | 1966700 | 2021-11-30 | Shoshone | Idaho | 16079 | 2123 | 63 |
1956500 | 1956500 | 2021-11-27 | Little River | Arkansas | 5081 | 2123 | 81 |
1943626 | 1943626 | 2021-11-23 | Las Animas | Colorado | 8071 | 2123 | 27 |
1929351 | 1929351 | 2021-11-18 | Tillamook | Oregon | 41057 | 2123 | 42 |
1922065 | 1922065 | 2021-11-16 | Perry | Mississippi | 28111 | 2123 | 56 |
1894325 | 1894325 | 2021-11-07 | Grayson | Virginia | 51077 | 2123 | 46 |
1891075 | 1891075 | 2021-11-06 | Grayson | Virginia | 51077 | 2123 | 46 |
1887825 | 1887825 | 2021-11-05 | Grayson | Virginia | 51077 | 2123 | 46 |
1846326 | 1846326 | 2021-10-24 | Jasper | Georgia | 13159 | 2123 | 58 |
1843076 | 1843076 | 2021-10-23 | Jasper | Georgia | 13159 | 2123 | 58 |
1839826 | 1839826 | 2021-10-22 | Jasper | Georgia | 13159 | 2123 | 58 |
1826631 | 1826631 | 2021-10-18 | Grand | Colorado | 8049 | 2123 | 15 |
1825405 | 1825405 | 2021-10-17 | Fulton | Pennsylvania | 42057 | 2123 | 26 |
1821904 | 1821904 | 2021-10-16 | Ramsey | North Dakota | 38071 | 2123 | 33 |
1809343 | 1809343 | 2021-10-12 | Clay | South Dakota | 46027 | 2123 | 18 |
1809539 | 1809539 | 2021-10-12 | Comanche | Texas | 48093 | 2123 | 60 |
1788938 | 1788938 | 2021-10-06 | Mississippi | Missouri | 29133 | 2123 | 38 |
1762465 | 1762465 | 2021-09-28 | Monroe | Kentucky | 21171 | 2123 | 55 |
1761071 | 1761071 | 2021-09-27 | Buchanan | Virginia | 51027 | 2123 | 48 |
1739282 | 1739282 | 2021-09-21 | Johnson | Illinois | 17087 | 2123 | 30 |
1740995 | 1740995 | 2021-09-21 | Fajardo | Puerto Rico | 72053 | 2123 | |
1737623 | 1737623 | 2021-09-20 | Crook | Oregon | 41013 | 2123 | 38 |
1677214 | 1677214 | 2021-09-02 | Teller | Colorado | 8119 | 2123 | 19 |
1670568 | 1670568 | 2021-08-31 | Madison | Arkansas | 5087 | 2123 | 32 |
1651609 | 1651609 | 2021-08-25 | Richland | Illinois | 17159 | 2123 | 56 |
1650835 | 1650835 | 2021-08-24 | Adams | Wisconsin | 55001 | 2123 | 21 |
1647205 | 1647205 | 2021-08-23 | Llano | Texas | 48299 | 2123 | 56 |
1630929 | 1630929 | 2021-08-18 | Jackson | Texas | 48239 | 2123 | 33 |
1626518 | 1626518 | 2021-08-17 | Pike | Missouri | 29163 | 2123 | 29 |
1607017 | 1607017 | 2021-08-11 | Moniteau | Missouri | 29135 | 2123 | 33 |
1604643 | 1604643 | 2021-08-10 | Hampton | South Carolina | 45049 | 2123 | 53 |
1598539 | 1598539 | 2021-08-08 | Shelby | Texas | 48419 | 2123 | 74 |
1584543 | 1584543 | 2021-08-04 | Roosevelt | New Mexico | 35041 | 2123 | 59 |
1560458 | 1560458 | 2021-07-28 | Meriwether | Georgia | 13199 | 2123 | 92 |
1563093 | 1563093 | 2021-07-28 | Mason | West Virginia | 54053 | 2123 | 37 |
1548567 | 1548567 | 2021-07-24 | Ray | Missouri | 29177 | 2123 | 34 |
1543846 | 1543846 | 2021-07-23 | Ashley | Arkansas | 5003 | 2123 | 37 |
1535158 | 1535158 | 2021-07-20 | St. James | Louisiana | 22093 | 2123 | 52 |
1529017 | 1529017 | 2021-07-18 | Clinton | Missouri | 29049 | 2123 | 65 |
1517893 | 1517893 | 2021-07-15 | Hempstead | Arkansas | 5057 | 2123 | 20 |
1511548 | 1511548 | 2021-07-13 | Montezuma | Colorado | 8083 | 2123 | 27 |
1508301 | 1508301 | 2021-07-12 | Montezuma | Colorado | 8083 | 2123 | 27 |
1455623 | 1455623 | 2021-06-25 | Montague | Texas | 48337 | 2123 | 73 |
1450468 | 1450468 | 2021-06-24 | Tama | Iowa | 19171 | 2123 | 71 |
1447223 | 1447223 | 2021-06-23 | Tama | Iowa | 19171 | 2123 | 71 |
1447898 | 1447898 | 2021-06-23 | Livingston | Missouri | 29117 | 2123 | 46 |
1446112 | 1446112 | 2021-06-22 | Page | Virginia | 51139 | 2123 | 59 |
1399293 | 1399293 | 2021-06-08 | Lake | Montana | 30047 | 2123 | 36 |
1396047 | 1396047 | 2021-06-07 | Lake | Montana | 30047 | 2123 | 36 |
1362067 | 1362067 | 2021-05-28 | Arkansas | Arkansas | 5001 | 2123 | 37 |
1352183 | 1352183 | 2021-05-24 | Taylor | Wisconsin | 55119 | 2123 | 32 |
1340797 | 1340797 | 2021-05-21 | New Madrid | Missouri | 29143 | 2123 | 44 |
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);