ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
239 rows where cases = 2124 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 18
- Texas 18
- Virginia 14
- Kentucky 13
- Georgia 12
- Puerto Rico 12
- Minnesota 10
- Missouri 10
- South Dakota 10
- Colorado 9
- Oklahoma 8
- Iowa 7
- Louisiana 7
- Mississippi 7
- Indiana 6
- Wisconsin 6
- Alabama 5
- Illinois 5
- Michigan 5
- North Carolina 5
- Utah 5
- North Dakota 4
- Pennsylvania 4
- West Virginia 4
- Kansas 3
- Nebraska 3
- New Hampshire 3
- New York 3
- Ohio 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499997 | 2499997 | 2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 |
2496739 | 2496739 | 2022-05-12 | Clinch | Georgia | 13065 | 2124 | 42 |
2493481 | 2493481 | 2022-05-11 | Clinch | Georgia | 13065 | 2124 | 42 |
2489975 | 2489975 | 2022-05-10 | Searcy | Arkansas | 5129 | 2124 | 48 |
2453093 | 2453093 | 2022-04-28 | Hormigueros | Puerto Rico | 72067 | 2124 | |
2423785 | 2423785 | 2022-04-19 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2420529 | 2420529 | 2022-04-18 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2417273 | 2417273 | 2022-04-17 | Guayanilla | Puerto Rico | 72059 | 2124 | |
2331912 | 2331912 | 2022-03-22 | Beaverhead | Montana | 30001 | 2124 | 28 |
2282852 | 2282852 | 2022-03-07 | Clearwater | Minnesota | 27029 | 2124 | 30 |
2280651 | 2280651 | 2022-03-06 | Rincon | Puerto Rico | 72117 | 2124 | |
2256852 | 2256852 | 2022-02-27 | Jackson | Minnesota | 27063 | 2124 | 17 |
2253601 | 2253601 | 2022-02-26 | Jackson | Minnesota | 27063 | 2124 | 17 |
2250350 | 2250350 | 2022-02-25 | Jackson | Minnesota | 27063 | 2124 | 17 |
2248755 | 2248755 | 2022-02-24 | Northampton | Virginia | 51131 | 2124 | 61 |
2240767 | 2240767 | 2022-02-22 | DeKalb | Missouri | 29063 | 2124 | 43 |
2242013 | 2242013 | 2022-02-22 | Live Oak | Texas | 48297 | 2124 | 40 |
2231819 | 2231819 | 2022-02-19 | Adjuntas | Puerto Rico | 72001 | 2124 | |
2222748 | 2222748 | 2022-02-16 | Northumberland | Virginia | 51133 | 2124 | 42 |
2213748 | 2213748 | 2022-02-14 | Stewart | Georgia | 13259 | 2124 | 31 |
2201669 | 2201669 | 2022-02-10 | Kemper | Mississippi | 28069 | 2124 | 45 |
2201977 | 2201977 | 2022-02-10 | Unknown | Nebraska | 2124 | 376 | |
2202177 | 2202177 | 2022-02-10 | Jones | North Carolina | 37103 | 2124 | 38 |
2198676 | 2198676 | 2022-02-09 | Hamilton | Nebraska | 31081 | 2124 | 22 |
2186341 | 2186341 | 2022-02-05 | Penuelas | Puerto Rico | 72111 | 2124 | |
2186771 | 2186771 | 2022-02-05 | Red River | Texas | 48387 | 2124 | 61 |
2166729 | 2166729 | 2022-01-30 | Forest | Pennsylvania | 42053 | 2124 | 34 |
2154078 | 2154078 | 2022-01-26 | Castro | Texas | 48069 | 2124 | 45 |
2150826 | 2150826 | 2022-01-25 | Castro | Texas | 48069 | 2124 | 45 |
2147574 | 2147574 | 2022-01-24 | Castro | Texas | 48069 | 2124 | 45 |
2136716 | 2136716 | 2022-01-21 | Montgomery | Missouri | 29139 | 2124 | 38 |
2127592 | 2127592 | 2022-01-18 | Noble | Oklahoma | 40103 | 2124 | 33 |
2124340 | 2124340 | 2022-01-17 | Noble | Oklahoma | 40103 | 2124 | 33 |
2121088 | 2121088 | 2022-01-16 | Noble | Oklahoma | 40103 | 2124 | 33 |
2117836 | 2117836 | 2022-01-15 | Noble | Oklahoma | 40103 | 2124 | 33 |
2114585 | 2114585 | 2022-01-14 | Noble | Oklahoma | 40103 | 2124 | 33 |
2111333 | 2111333 | 2022-01-13 | Noble | Oklahoma | 40103 | 2124 | 33 |
2108081 | 2108081 | 2022-01-12 | Noble | Oklahoma | 40103 | 2124 | 33 |
2108910 | 2108910 | 2022-01-12 | Richmond | Virginia | 51159 | 2124 | 17 |
2060631 | 2060631 | 2021-12-29 | Gunnison | Colorado | 8051 | 2124 | 13 |
2032531 | 2032531 | 2021-12-20 | Amite | Mississippi | 28005 | 2124 | 57 |
2020582 | 2020582 | 2021-12-16 | Butte | South Dakota | 46019 | 2124 | 36 |
2012840 | 2012840 | 2021-12-14 | Dukes | Massachusetts | 25007 | 2124 | 0 |
1997260 | 1997260 | 2021-12-09 | Yates | New York | 36123 | 2124 | 34 |
1994137 | 1994137 | 2021-12-08 | McLean | North Dakota | 38055 | 2124 | 46 |
1966254 | 1966254 | 2021-11-30 | Little River | Arkansas | 5081 | 2124 | 81 |
1967386 | 1967386 | 2021-11-30 | Kalkaska | Michigan | 26079 | 2124 | 40 |
1963002 | 1963002 | 2021-11-29 | Little River | Arkansas | 5081 | 2124 | 81 |
1964134 | 1964134 | 2021-11-29 | Kalkaska | Michigan | 26079 | 2124 | 40 |
1959751 | 1959751 | 2021-11-28 | Little River | Arkansas | 5081 | 2124 | 81 |
1943323 | 1943323 | 2021-11-22 | Big Horn | Wyoming | 56003 | 2124 | 56 |
1925314 | 1925314 | 2021-11-17 | Perry | Mississippi | 28111 | 2124 | 56 |
1905689 | 1905689 | 2021-11-11 | Cottonwood | Minnesota | 27033 | 2124 | 29 |
1907505 | 1907505 | 2021-11-11 | Buffalo | Wisconsin | 55011 | 2124 | 8 |
1871531 | 1871531 | 2021-10-31 | Alleghany | Virginia | 51005 | 2124 | 77 |
1868282 | 1868282 | 2021-10-30 | Alleghany | Virginia | 51005 | 2124 | 77 |
1865033 | 1865033 | 2021-10-29 | Alleghany | Virginia | 51005 | 2124 | 77 |
1842467 | 1842467 | 2021-10-22 | Grant | West Virginia | 54023 | 2124 | 33 |
1837562 | 1837562 | 2021-10-21 | Lawrence | Mississippi | 28077 | 2124 | 40 |
1837683 | 1837683 | 2021-10-21 | Osage | Missouri | 29151 | 2124 | 23 |
1839000 | 1839000 | 2021-10-21 | Millard | Utah | 49027 | 2124 | 25 |
1834313 | 1834313 | 2021-10-20 | Lawrence | Mississippi | 28077 | 2124 | 40 |
1834434 | 1834434 | 2021-10-20 | Osage | Missouri | 29151 | 2124 | 23 |
1835751 | 1835751 | 2021-10-20 | Millard | Utah | 49027 | 2124 | 25 |
1825153 | 1825153 | 2021-10-17 | Ramsey | North Dakota | 38071 | 2124 | 33 |
1807530 | 1807530 | 2021-10-12 | Massac | Illinois | 17127 | 2124 | 49 |
1791121 | 1791121 | 2021-10-07 | Oglethorpe | Georgia | 13221 | 2124 | 38 |
1788017 | 1788017 | 2021-10-06 | Jo Daviess | Illinois | 17085 | 2124 | 30 |
1785948 | 1785948 | 2021-10-05 | Grant | New Mexico | 35017 | 2124 | 48 |
1778643 | 1778643 | 2021-10-03 | Caldwell | Kentucky | 21033 | 2124 | 45 |
1775393 | 1775393 | 2021-10-02 | Caldwell | Kentucky | 21033 | 2124 | 45 |
1772143 | 1772143 | 2021-10-01 | Caldwell | Kentucky | 21033 | 2124 | 45 |
1751253 | 1751253 | 2021-09-24 | Wilbarger | Texas | 48487 | 2124 | 56 |
1745806 | 1745806 | 2021-09-23 | Moultrie | Illinois | 17139 | 2124 | 39 |
1748004 | 1748004 | 2021-09-23 | Wilbarger | Texas | 48487 | 2124 | 56 |
1698716 | 1698716 | 2021-09-08 | Montour | Pennsylvania | 42093 | 2124 | 67 |
1688185 | 1688185 | 2021-09-05 | Dallas | Missouri | 29059 | 2124 | 38 |
1688784 | 1688784 | 2021-09-05 | Paulding | Ohio | 39125 | 2124 | 42 |
1684935 | 1684935 | 2021-09-04 | Dallas | Missouri | 29059 | 2124 | 38 |
1663001 | 1663001 | 2021-08-28 | Wyoming | Pennsylvania | 42131 | 2124 | 54 |
1657190 | 1657190 | 2021-08-26 | Nottoway | Virginia | 51135 | 2124 | 55 |
1641472 | 1641472 | 2021-08-22 | Otero | Colorado | 8089 | 2124 | 68 |
1638222 | 1638222 | 2021-08-21 | Otero | Colorado | 8089 | 2124 | 68 |
1640310 | 1640310 | 2021-08-21 | Manati | Puerto Rico | 72091 | 2124 | |
1634972 | 1634972 | 2021-08-20 | Otero | Colorado | 8089 | 2124 | 68 |
1628329 | 1628329 | 2021-08-18 | Izard | Arkansas | 5065 | 2124 | 48 |
1621621 | 1621621 | 2021-08-15 | Green Lake | Wisconsin | 55047 | 2124 | 25 |
1618373 | 1618373 | 2021-08-14 | Green Lake | Wisconsin | 55047 | 2124 | 25 |
1612125 | 1612125 | 2021-08-13 | Sharp | Arkansas | 5135 | 2124 | 53 |
1615125 | 1615125 | 2021-08-13 | Green Lake | Wisconsin | 55047 | 2124 | 25 |
1604587 | 1604587 | 2021-08-10 | Naranjito | Puerto Rico | 72105 | 2124 | |
1600380 | 1600380 | 2021-08-09 | Clay | Mississippi | 28025 | 2124 | 55 |
1597489 | 1597489 | 2021-08-08 | Coos | New Hampshire | 33007 | 2124 | 45 |
1594240 | 1594240 | 2021-08-07 | Coos | New Hampshire | 33007 | 2124 | 45 |
1590991 | 1590991 | 2021-08-06 | Coos | New Hampshire | 33007 | 2124 | 45 |
1588313 | 1588313 | 2021-08-05 | Corozal | Puerto Rico | 72047 | 2124 | |
1581691 | 1581691 | 2021-08-03 | Columbia | Oregon | 41009 | 2124 | 32 |
1582612 | 1582612 | 2021-08-03 | Wyoming | West Virginia | 54109 | 2124 | 41 |
1576346 | 1576346 | 2021-08-02 | Grant | Arkansas | 5053 | 2124 | 39 |
1563381 | 1563381 | 2021-07-29 | Phillips | Arkansas | 5107 | 2124 | 46 |
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);