ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 5024 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 9
- Kentucky 8
- Texas 8
- North Carolina 7
- Oklahoma 7
- Illinois 6
- Georgia 4
- Indiana 4
- New Mexico 4
- Oregon 4
- South Carolina 4
- West Virginia 4
- Colorado 3
- Idaho 3
- Mississippi 3
- Puerto Rico 3
- Iowa 2
- Michigan 2
- Minnesota 2
- Utah 2
- Virginia 2
- Alabama 1
- Arkansas 1
- California 1
- Florida 1
- Missouri 1
- Montana 1
- New Hampshire 1
- New York 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502023 | 2502023 | 2022-05-13 | Hampton | South Carolina | 45049 | 5024 | 86 |
2498765 | 2498765 | 2022-05-12 | Hampton | South Carolina | 45049 | 5024 | 86 |
2495507 | 2495507 | 2022-05-11 | Hampton | South Carolina | 45049 | 5024 | 86 |
2447205 | 2447205 | 2022-04-26 | King George | Virginia | 51099 | 5024 | 39 |
2436830 | 2436830 | 2022-04-23 | Morovis | Puerto Rico | 72101 | 5024 | |
2420425 | 2420425 | 2022-04-18 | Union | Oregon | 41061 | 5024 | 78 |
2417170 | 2417170 | 2022-04-17 | Union | Oregon | 41061 | 5024 | 78 |
2413914 | 2413914 | 2022-04-16 | Union | Oregon | 41061 | 5024 | 78 |
2410658 | 2410658 | 2022-04-15 | Union | Oregon | 41061 | 5024 | 78 |
2382922 | 2382922 | 2022-04-07 | Cassia | Idaho | 16031 | 5024 | 52 |
2379667 | 2379667 | 2022-04-06 | Cassia | Idaho | 16031 | 5024 | 52 |
2347578 | 2347578 | 2022-03-27 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2344325 | 2344325 | 2022-03-26 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2341072 | 2341072 | 2022-03-25 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2337819 | 2337819 | 2022-03-24 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2334565 | 2334565 | 2022-03-23 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2331311 | 2331311 | 2022-03-22 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2328059 | 2328059 | 2022-03-21 | Breckinridge | Kentucky | 21027 | 5024 | 75 |
2306640 | 2306640 | 2022-03-14 | Hatillo | Puerto Rico | 72065 | 5024 | |
2219254 | 2219254 | 2022-02-15 | Limestone | Texas | 48293 | 5024 | 118 |
2191052 | 2191052 | 2022-02-07 | Payette | Idaho | 16075 | 5024 | 78 |
2145374 | 2145374 | 2022-01-24 | Haralson | Georgia | 13143 | 5024 | 142 |
2074046 | 2074046 | 2022-01-02 | Saline | Illinois | 17165 | 5024 | 90 |
2070795 | 2070795 | 2022-01-01 | Saline | Illinois | 17165 | 5024 | 90 |
2067544 | 2067544 | 2021-12-31 | Saline | Illinois | 17165 | 5024 | 90 |
2064293 | 2064293 | 2021-12-30 | Saline | Illinois | 17165 | 5024 | 90 |
2032557 | 2032557 | 2021-12-20 | Itawamba | Mississippi | 28057 | 5024 | 108 |
2032931 | 2032931 | 2021-12-20 | Cibola | New Mexico | 35006 | 5024 | 154 |
1990939 | 1990939 | 2021-12-07 | Fayette | Ohio | 39047 | 5024 | 72 |
1968295 | 1968295 | 2021-11-30 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1965044 | 1965044 | 2021-11-29 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1961792 | 1961792 | 2021-11-28 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1958541 | 1958541 | 2021-11-27 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1955219 | 1955219 | 2021-11-26 | Morrow | Ohio | 39117 | 5024 | 64 |
1955290 | 1955290 | 2021-11-26 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1952039 | 1952039 | 2021-11-25 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1948788 | 1948788 | 2021-11-24 | Lincoln | Oklahoma | 40081 | 5024 | 112 |
1904650 | 1904650 | 2021-11-11 | Summit | Colorado | 8117 | 5024 | 11 |
1895976 | 1895976 | 2021-11-08 | Nobles | Minnesota | 27105 | 5024 | 53 |
1878402 | 1878402 | 2021-11-03 | Pike | Alabama | 1109 | 5024 | 107 |
1776506 | 1776506 | 2021-10-02 | Putnam | Ohio | 39137 | 5024 | 108 |
1766411 | 1766411 | 2021-09-29 | Cheshire | New Hampshire | 33005 | 5024 | 45 |
1763039 | 1763039 | 2021-09-28 | Silver Bow | Montana | 30093 | 5024 | 96 |
1760846 | 1760846 | 2021-09-27 | Grimes | Texas | 48185 | 5024 | 97 |
1755662 | 1755662 | 2021-09-26 | Steuben | Indiana | 18151 | 5024 | 70 |
1752414 | 1752414 | 2021-09-25 | Steuben | Indiana | 18151 | 5024 | 70 |
1749165 | 1749165 | 2021-09-24 | Steuben | Indiana | 18151 | 5024 | 70 |
1749947 | 1749947 | 2021-09-24 | Marion | Missouri | 29127 | 5024 | 58 |
1737864 | 1737864 | 2021-09-20 | Codington | South Dakota | 46029 | 5024 | 82 |
1699835 | 1699835 | 2021-09-09 | Unknown | Arkansas | 5024 | 0 | |
1700182 | 1700182 | 2021-09-09 | Toombs | Georgia | 13279 | 5024 | 139 |
1674378 | 1674378 | 2021-09-01 | Clinton | Indiana | 18023 | 5024 | 65 |
1649092 | 1649092 | 2021-08-24 | Winona | Minnesota | 27169 | 5024 | 52 |
1644305 | 1644305 | 2021-08-22 | Marion | West Virginia | 54049 | 5024 | 56 |
1641055 | 1641055 | 2021-08-21 | Marion | West Virginia | 54049 | 5024 | 56 |
1637805 | 1637805 | 2021-08-20 | Marion | West Virginia | 54049 | 5024 | 56 |
1627074 | 1627074 | 2021-08-17 | Shelby | Ohio | 39149 | 5024 | 98 |
1602411 | 1602411 | 2021-08-10 | Mendocino | California | 6045 | 5024 | 54 |
1581859 | 1581859 | 2021-08-03 | Toa Baja | Puerto Rico | 72137 | 5024 | |
1579080 | 1579080 | 2021-08-02 | Wilson | Texas | 48493 | 5024 | 72 |
1575832 | 1575832 | 2021-08-01 | Wilson | Texas | 48493 | 5024 | 72 |
1572584 | 1572584 | 2021-07-31 | Wilson | Texas | 48493 | 5024 | 72 |
1508553 | 1508553 | 2021-07-12 | Ware | Georgia | 13299 | 5024 | 182 |
1487286 | 1487286 | 2021-07-05 | Watauga | North Carolina | 37189 | 5024 | 33 |
1484040 | 1484040 | 2021-07-04 | Watauga | North Carolina | 37189 | 5024 | 33 |
1480794 | 1480794 | 2021-07-03 | Watauga | North Carolina | 37189 | 5024 | 33 |
1477547 | 1477547 | 2021-07-02 | Watauga | North Carolina | 37189 | 5024 | 33 |
1478599 | 1478599 | 2021-07-02 | Washington | Virginia | 51191 | 5024 | 111 |
1464565 | 1464565 | 2021-06-28 | Watauga | North Carolina | 37189 | 5024 | 33 |
1454897 | 1454897 | 2021-06-25 | Auglaize | Ohio | 39011 | 5024 | 87 |
1451652 | 1451652 | 2021-06-24 | Auglaize | Ohio | 39011 | 5024 | 87 |
1448406 | 1448406 | 2021-06-23 | Auglaize | Ohio | 39011 | 5024 | 87 |
1442575 | 1442575 | 2021-06-21 | Harrison | Texas | 48203 | 5024 | 110 |
1436083 | 1436083 | 2021-06-19 | Harrison | Texas | 48203 | 5024 | 110 |
1333371 | 1333371 | 2021-05-19 | Henry | Illinois | 17073 | 5024 | 96 |
1333839 | 1333839 | 2021-05-19 | Scott | Kentucky | 21209 | 5024 | 33 |
1324826 | 1324826 | 2021-05-16 | Otero | New Mexico | 35035 | 5024 | 75 |
1321580 | 1321580 | 2021-05-15 | Otero | New Mexico | 35035 | 5024 | 75 |
1318334 | 1318334 | 2021-05-14 | Otero | New Mexico | 35035 | 5024 | 75 |
1319696 | 1319696 | 2021-05-14 | Oconto | Wisconsin | 55083 | 5024 | 64 |
1313893 | 1313893 | 2021-05-13 | Jackson | Illinois | 17077 | 5024 | 75 |
1312301 | 1312301 | 2021-05-12 | Huntingdon | Pennsylvania | 42061 | 5024 | 129 |
1263228 | 1263228 | 2021-04-27 | Carteret | North Carolina | 37031 | 5024 | 51 |
1234150 | 1234150 | 2021-04-18 | Athens | Ohio | 39009 | 5024 | 56 |
1210630 | 1210630 | 2021-04-11 | Isabella | Michigan | 26073 | 5024 | 80 |
1206980 | 1206980 | 2021-04-10 | Sioux | Iowa | 19167 | 5024 | 73 |
1207381 | 1207381 | 2021-04-10 | Isabella | Michigan | 26073 | 5024 | 80 |
1192413 | 1192413 | 2021-04-05 | Franklin | Tennessee | 47051 | 5024 | 87 |
1151780 | 1151780 | 2021-03-24 | Webster | Iowa | 19187 | 5024 | 88 |
1146495 | 1146495 | 2021-03-22 | Huron | Ohio | 39077 | 5024 | 110 |
1123537 | 1123537 | 2021-03-15 | Jefferson | New York | 36045 | 5024 | 63 |
1023676 | 1023676 | 2021-02-12 | Atascosa | Texas | 48013 | 5024 | 127 |
980342 | 980342 | 2021-01-30 | Washington | Mississippi | 28151 | 5024 | 125 |
955334 | 955334 | 2021-01-22 | Laurens | South Carolina | 45059 | 5024 | 108 |
946766 | 946766 | 2021-01-20 | Monroe | Florida | 12087 | 5024 | 37 |
847714 | 847714 | 2020-12-20 | Caldwell | North Carolina | 37027 | 5024 | 27 |
751549 | 751549 | 2020-11-20 | Kanawha | West Virginia | 54039 | 5024 | 133 |
694725 | 694725 | 2020-11-03 | Jackson | Mississippi | 28059 | 5024 | 99 |
679964 | 679964 | 2020-10-29 | Washington | Utah | 49053 | 5024 | 46 |
606004 | 606004 | 2020-10-07 | Weld | Colorado | 8123 | 5024 | 151 |
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);