ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where cases = 101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state 48
- Texas 110
- Kansas 84
- Illinois 81
- Nebraska 78
- Kentucky 69
- Georgia 65
- Virginia 59
- Montana 52
- Oklahoma 48
- Puerto Rico 47
- Iowa 43
- New York 41
- Minnesota 39
- North Carolina 37
- North Dakota 37
- Washington 37
- Indiana 36
- Missouri 36
- Ohio 34
- Colorado 33
- Arkansas 31
- South Dakota 31
- Michigan 30
- Tennessee 29
- West Virginia 27
- Wisconsin 27
- Pennsylvania 26
- Vermont 26
- Alaska 24
- Mississippi 22
- California 21
- Florida 20
- New Mexico 20
- Utah 20
- South Carolina 18
- Idaho 17
- Alabama 16
- Louisiana 16
- Maine 16
- Oregon 14
- Wyoming 11
- Maryland 8
- New Hampshire 8
- Arizona 3
- Nevada 3
- Delaware 2
- Hawaii 2
- Massachusetts 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465502 | 2465502 | 2022-05-02 | Thomas | Nebraska | 31171 | 101 | 1 |
2462247 | 2462247 | 2022-05-01 | Thomas | Nebraska | 31171 | 101 | 1 |
2458991 | 2458991 | 2022-04-30 | Thomas | Nebraska | 31171 | 101 | 1 |
2455735 | 2455735 | 2022-04-29 | Thomas | Nebraska | 31171 | 101 | 1 |
2452479 | 2452479 | 2022-04-28 | Thomas | Nebraska | 31171 | 101 | 1 |
2449223 | 2449223 | 2022-04-27 | Thomas | Nebraska | 31171 | 101 | 1 |
2445966 | 2445966 | 2022-04-26 | Thomas | Nebraska | 31171 | 101 | 1 |
2442711 | 2442711 | 2022-04-25 | Thomas | Nebraska | 31171 | 101 | 1 |
2439455 | 2439455 | 2022-04-24 | Thomas | Nebraska | 31171 | 101 | 1 |
2436199 | 2436199 | 2022-04-23 | Thomas | Nebraska | 31171 | 101 | 1 |
2432943 | 2432943 | 2022-04-22 | Thomas | Nebraska | 31171 | 101 | 1 |
2237700 | 2237700 | 2022-02-21 | Hayes | Nebraska | 31085 | 101 | 0 |
2214943 | 2214943 | 2022-02-14 | Hayes | Nebraska | 31085 | 101 | 0 |
2188912 | 2188912 | 2022-02-06 | Grant | Nebraska | 31075 | 101 | 5 |
2185659 | 2185659 | 2022-02-05 | Grant | Nebraska | 31075 | 101 | 5 |
2182407 | 2182407 | 2022-02-04 | Grant | Nebraska | 31075 | 101 | 5 |
2179155 | 2179155 | 2022-02-03 | Grant | Nebraska | 31075 | 101 | 5 |
2175903 | 2175903 | 2022-02-02 | Grant | Nebraska | 31075 | 101 | 5 |
2151991 | 2151991 | 2022-01-26 | Clark | Idaho | 16033 | 101 | 0 |
2148253 | 2148253 | 2022-01-25 | Skagway Municipality | Alaska | 2230 | 101 | 0 |
2145001 | 2145001 | 2022-01-24 | Skagway Municipality | Alaska | 2230 | 101 | 0 |
2143374 | 2143374 | 2022-01-23 | Hooker | Nebraska | 31091 | 101 | 3 |
2140119 | 2140119 | 2022-01-22 | Hooker | Nebraska | 31091 | 101 | 3 |
2136863 | 2136863 | 2022-01-21 | Hooker | Nebraska | 31091 | 101 | 3 |
2133617 | 2133617 | 2022-01-20 | Keya Paha | Nebraska | 31103 | 101 | 0 |
2127104 | 2127104 | 2022-01-18 | Hooker | Nebraska | 31091 | 101 | 3 |
2123852 | 2123852 | 2022-01-17 | Hooker | Nebraska | 31091 | 101 | 3 |
2113266 | 2113266 | 2022-01-14 | Unknown | Iowa | 101 | 0 | |
2110014 | 2110014 | 2022-01-13 | Unknown | Iowa | 101 | 0 | |
2106763 | 2106763 | 2022-01-12 | Unknown | Iowa | 101 | 0 | |
1941760 | 1941760 | 2021-11-22 | Treasure | Montana | 30103 | 101 | 1 |
1938510 | 1938510 | 2021-11-21 | Treasure | Montana | 30103 | 101 | 1 |
1935260 | 1935260 | 2021-11-20 | Treasure | Montana | 30103 | 101 | 1 |
1932010 | 1932010 | 2021-11-19 | Treasure | Montana | 30103 | 101 | 1 |
1933166 | 1933166 | 2021-11-19 | Roberts | Texas | 48393 | 101 | 1 |
1928759 | 1928759 | 2021-11-18 | Treasure | Montana | 30103 | 101 | 1 |
1929915 | 1929915 | 2021-11-18 | Roberts | Texas | 48393 | 101 | 1 |
1926665 | 1926665 | 2021-11-17 | Roberts | Texas | 48393 | 101 | 1 |
1890105 | 1890105 | 2021-11-06 | Billings | North Dakota | 38007 | 101 | 0 |
1886855 | 1886855 | 2021-11-05 | Billings | North Dakota | 38007 | 101 | 0 |
1823386 | 1823386 | 2021-10-17 | Jackson | Colorado | 8057 | 101 | 0 |
1820137 | 1820137 | 2021-10-16 | Jackson | Colorado | 8057 | 101 | 0 |
1816888 | 1816888 | 2021-10-15 | Jackson | Colorado | 8057 | 101 | 0 |
1813640 | 1813640 | 2021-10-14 | Jackson | Colorado | 8057 | 101 | 0 |
1810391 | 1810391 | 2021-10-13 | Jackson | Colorado | 8057 | 101 | 0 |
1813000 | 1813000 | 2021-10-13 | Daggett | Utah | 49009 | 101 | 0 |
1809751 | 1809751 | 2021-10-12 | Daggett | Utah | 49009 | 101 | 0 |
1800642 | 1800642 | 2021-10-10 | Jackson | Colorado | 8057 | 101 | 0 |
1797393 | 1797393 | 2021-10-09 | Jackson | Colorado | 8057 | 101 | 0 |
1794144 | 1794144 | 2021-10-08 | Jackson | Colorado | 8057 | 101 | 0 |
1784694 | 1784694 | 2021-10-05 | Camas | Idaho | 16025 | 101 | 1 |
1768064 | 1768064 | 2021-09-30 | Alpine | California | 6003 | 101 | 0 |
1764815 | 1764815 | 2021-09-29 | Alpine | California | 6003 | 101 | 0 |
1761566 | 1761566 | 2021-09-28 | Alpine | California | 6003 | 101 | 0 |
1758318 | 1758318 | 2021-09-27 | Alpine | California | 6003 | 101 | 0 |
1760975 | 1760975 | 2021-09-27 | Terrell | Texas | 48443 | 101 | 3 |
1755070 | 1755070 | 2021-09-26 | Alpine | California | 6003 | 101 | 0 |
1757727 | 1757727 | 2021-09-26 | Terrell | Texas | 48443 | 101 | 3 |
1751822 | 1751822 | 2021-09-25 | Alpine | California | 6003 | 101 | 0 |
1754479 | 1754479 | 2021-09-25 | Terrell | Texas | 48443 | 101 | 3 |
1748573 | 1748573 | 2021-09-24 | Alpine | California | 6003 | 101 | 0 |
1751231 | 1751231 | 2021-09-24 | Terrell | Texas | 48443 | 101 | 3 |
1675292 | 1675292 | 2021-09-01 | Garfield | Montana | 30033 | 101 | 3 |
1672044 | 1672044 | 2021-08-31 | Garfield | Montana | 30033 | 101 | 3 |
1668797 | 1668797 | 2021-08-30 | Garfield | Montana | 30033 | 101 | 3 |
1665550 | 1665550 | 2021-08-29 | Garfield | Montana | 30033 | 101 | 3 |
1662302 | 1662302 | 2021-08-28 | Garfield | Montana | 30033 | 101 | 3 |
1659054 | 1659054 | 2021-08-27 | Garfield | Montana | 30033 | 101 | 3 |
1653420 | 1653420 | 2021-08-25 | Harding | South Dakota | 46063 | 101 | 1 |
1644664 | 1644664 | 2021-08-23 | Sierra | California | 6091 | 101 | 0 |
1633068 | 1633068 | 2021-08-19 | Judith Basin | Montana | 30045 | 101 | 1 |
1628462 | 1628462 | 2021-08-18 | Kiowa | Colorado | 8061 | 101 | 3 |
1629821 | 1629821 | 2021-08-18 | Judith Basin | Montana | 30045 | 101 | 1 |
1587773 | 1587773 | 2021-08-05 | Catron | New Mexico | 35003 | 101 | 6 |
1584522 | 1584522 | 2021-08-04 | Catron | New Mexico | 35003 | 101 | 6 |
1579742 | 1579742 | 2021-08-03 | Mineral | Colorado | 8079 | 101 | 1 |
1581273 | 1581273 | 2021-08-03 | Catron | New Mexico | 35003 | 101 | 6 |
1566111 | 1566111 | 2021-07-29 | Piute | Utah | 49031 | 101 | 2 |
1300341 | 1300341 | 2021-05-09 | Denali Borough | Alaska | 2068 | 101 | 0 |
1297094 | 1297094 | 2021-05-08 | Denali Borough | Alaska | 2068 | 101 | 0 |
1293848 | 1293848 | 2021-05-07 | Denali Borough | Alaska | 2068 | 101 | 0 |
1290602 | 1290602 | 2021-05-06 | Denali Borough | Alaska | 2068 | 101 | 0 |
1290616 | 1290616 | 2021-05-06 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 101 | 1 |
1287356 | 1287356 | 2021-05-05 | Denali Borough | Alaska | 2068 | 101 | 0 |
1284110 | 1284110 | 2021-05-04 | Denali Borough | Alaska | 2068 | 101 | 0 |
1285730 | 1285730 | 2021-05-04 | Deuel | Nebraska | 31049 | 101 | 2 |
1280863 | 1280863 | 2021-05-03 | Denali Borough | Alaska | 2068 | 101 | 0 |
1282484 | 1282484 | 2021-05-03 | Deuel | Nebraska | 31049 | 101 | 2 |
1277616 | 1277616 | 2021-05-02 | Denali Borough | Alaska | 2068 | 101 | 0 |
1279237 | 1279237 | 2021-05-02 | Deuel | Nebraska | 31049 | 101 | 2 |
1274369 | 1274369 | 2021-05-01 | Denali Borough | Alaska | 2068 | 101 | 0 |
1275990 | 1275990 | 2021-05-01 | Deuel | Nebraska | 31049 | 101 | 2 |
1271122 | 1271122 | 2021-04-30 | Denali Borough | Alaska | 2068 | 101 | 0 |
1272743 | 1272743 | 2021-04-30 | Deuel | Nebraska | 31049 | 101 | 2 |
1269496 | 1269496 | 2021-04-29 | Deuel | Nebraska | 31049 | 101 | 2 |
1263002 | 1263002 | 2021-04-27 | Deuel | Nebraska | 31049 | 101 | 2 |
1259755 | 1259755 | 2021-04-26 | Deuel | Nebraska | 31049 | 101 | 2 |
1256508 | 1256508 | 2021-04-25 | Deuel | Nebraska | 31049 | 101 | 2 |
1253261 | 1253261 | 2021-04-24 | Deuel | Nebraska | 31049 | 101 | 2 |
1250014 | 1250014 | 2021-04-23 | Deuel | Nebraska | 31049 | 101 | 2 |
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);