ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where cases = 2564 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 18
- Texas 13
- New York 11
- Puerto Rico 10
- Alabama 9
- Illinois 9
- Indiana 9
- Mississippi 9
- Virginia 9
- Georgia 8
- Missouri 8
- Oklahoma 8
- Kentucky 6
- Michigan 6
- South Carolina 6
- Kansas 5
- Nebraska 5
- North Carolina 5
- California 4
- Minnesota 4
- Pennsylvania 4
- Tennessee 4
- Montana 3
- New Jersey 3
- Ohio 3
- Colorado 2
- Florida 2
- Louisiana 2
- North Dakota 2
- Arkansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469974 | 2469974 | 2022-05-03 | Floyd | Virginia | 51063 | 2564 | 49 |
2466718 | 2466718 | 2022-05-02 | Floyd | Virginia | 51063 | 2564 | 49 |
2433568 | 2433568 | 2022-04-22 | Luquillo | Puerto Rico | 72089 | 2564 | |
2430966 | 2430966 | 2022-04-21 | Richmond | Virginia | 51159 | 2564 | 25 |
2392875 | 2392875 | 2022-04-10 | Newton | Indiana | 18111 | 2564 | 68 |
2394521 | 2394521 | 2022-04-10 | Santa Isabel | Puerto Rico | 72133 | 2564 | |
2389619 | 2389619 | 2022-04-09 | Newton | Indiana | 18111 | 2564 | 68 |
2386364 | 2386364 | 2022-04-08 | Newton | Indiana | 18111 | 2564 | 68 |
2304332 | 2304332 | 2022-03-14 | Sumter | Alabama | 1119 | 2564 | 49 |
2301080 | 2301080 | 2022-03-13 | Sumter | Alabama | 1119 | 2564 | 49 |
2297828 | 2297828 | 2022-03-12 | Sumter | Alabama | 1119 | 2564 | 49 |
2294576 | 2294576 | 2022-03-11 | Sumter | Alabama | 1119 | 2564 | 49 |
2283166 | 2283166 | 2022-03-07 | Richland | Montana | 30083 | 2564 | 31 |
2246035 | 2246035 | 2022-02-24 | Prowers | Colorado | 8099 | 2564 | 47 |
2237961 | 2237961 | 2022-02-21 | Pamlico | North Carolina | 37137 | 2564 | 27 |
2195400 | 2195400 | 2022-02-08 | Colfax | Nebraska | 31037 | 2564 | 26 |
2190971 | 2190971 | 2022-02-07 | Screven | Georgia | 13251 | 2564 | 62 |
2172015 | 2172015 | 2022-02-01 | Lyon | Kentucky | 21143 | 2564 | 32 |
2157097 | 2157097 | 2022-01-27 | Calhoun | South Carolina | 45017 | 2564 | 54 |
2157535 | 2157535 | 2022-01-27 | Ward | Texas | 48475 | 2564 | 39 |
2147571 | 2147571 | 2022-01-24 | Camp | Texas | 48063 | 2564 | 70 |
2126280 | 2126280 | 2022-01-18 | Winnebago | Iowa | 19189 | 2564 | 41 |
2123028 | 2123028 | 2022-01-17 | Winnebago | Iowa | 19189 | 2564 | 41 |
2119776 | 2119776 | 2022-01-16 | Winnebago | Iowa | 19189 | 2564 | 41 |
2116524 | 2116524 | 2022-01-15 | Winnebago | Iowa | 19189 | 2564 | 41 |
2117669 | 2117669 | 2022-01-15 | Mountrail | North Dakota | 38061 | 2564 | 32 |
2113273 | 2113273 | 2022-01-14 | Winnebago | Iowa | 19189 | 2564 | 41 |
2110021 | 2110021 | 2022-01-13 | Winnebago | Iowa | 19189 | 2564 | 41 |
2106770 | 2106770 | 2022-01-12 | Winnebago | Iowa | 19189 | 2564 | 41 |
2103488 | 2103488 | 2022-01-11 | Mills | Iowa | 19129 | 2564 | 31 |
2105632 | 2105632 | 2022-01-11 | Martinsville city | Virginia | 51690 | 2564 | 100 |
2100237 | 2100237 | 2022-01-10 | Mills | Iowa | 19129 | 2564 | 31 |
2096986 | 2096986 | 2022-01-09 | Mills | Iowa | 19129 | 2564 | 31 |
2097861 | 2097861 | 2022-01-09 | Otoe | Nebraska | 31131 | 2564 | 16 |
2093734 | 2093734 | 2022-01-08 | Mills | Iowa | 19129 | 2564 | 31 |
2094609 | 2094609 | 2022-01-08 | Otoe | Nebraska | 31131 | 2564 | 16 |
2090482 | 2090482 | 2022-01-07 | Mills | Iowa | 19129 | 2564 | 31 |
2091357 | 2091357 | 2022-01-07 | Otoe | Nebraska | 31131 | 2564 | 16 |
2087231 | 2087231 | 2022-01-06 | Mills | Iowa | 19129 | 2564 | 31 |
2087853 | 2087853 | 2022-01-06 | Tallahatchie | Mississippi | 28135 | 2564 | 53 |
2083979 | 2083979 | 2022-01-05 | Mills | Iowa | 19129 | 2564 | 31 |
2035024 | 2035024 | 2021-12-21 | Mason | Illinois | 17125 | 2564 | 54 |
2035557 | 2035557 | 2021-12-21 | Lincoln | Maine | 23015 | 2564 | 11 |
2028801 | 2028801 | 2021-12-19 | Jackson | Kansas | 20085 | 2564 | 20 |
2025550 | 2025550 | 2021-12-18 | Jackson | Kansas | 20085 | 2564 | 20 |
2022299 | 2022299 | 2021-12-17 | Jackson | Kansas | 20085 | 2564 | 20 |
2014550 | 2014550 | 2021-12-14 | Bristol city | Virginia | 51520 | 2564 | 50 |
2004255 | 2004255 | 2021-12-11 | San Sebastian | Puerto Rico | 72131 | 2564 | |
2001004 | 2001004 | 2021-12-10 | San Sebastian | Puerto Rico | 72131 | 2564 | |
1996119 | 1996119 | 2021-12-09 | Parke | Indiana | 18121 | 2564 | 33 |
1996470 | 1996470 | 2021-12-09 | Washington | Kentucky | 21229 | 2564 | 49 |
1991732 | 1991732 | 2021-12-07 | Zavala | Texas | 48507 | 2564 | 56 |
1946660 | 1946660 | 2021-11-24 | Washington | Alabama | 1129 | 2564 | 52 |
1899550 | 1899550 | 2021-11-09 | Gage | Nebraska | 31067 | 2564 | 27 |
1895987 | 1895987 | 2021-11-08 | Redwood | Minnesota | 27127 | 2564 | 44 |
1897044 | 1897044 | 2021-11-08 | Lee | South Carolina | 45061 | 2564 | 75 |
1880805 | 1880805 | 2021-11-03 | Saluda | South Carolina | 45081 | 2564 | 55 |
1874307 | 1874307 | 2021-11-01 | Saluda | South Carolina | 45081 | 2564 | 55 |
1863661 | 1863661 | 2021-10-29 | Livingston | Missouri | 29117 | 2564 | 62 |
1857649 | 1857649 | 2021-10-27 | Richland | North Dakota | 38077 | 2564 | 20 |
1808263 | 1808263 | 2021-10-12 | Roseau | Minnesota | 27135 | 2564 | 24 |
1809077 | 1809077 | 2021-10-12 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1805827 | 1805827 | 2021-10-11 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1802577 | 1802577 | 2021-10-10 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1799328 | 1799328 | 2021-10-09 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1799747 | 1799747 | 2021-10-09 | Aransas | Texas | 48007 | 2564 | 60 |
1796079 | 1796079 | 2021-10-08 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1792830 | 1792830 | 2021-10-07 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1789581 | 1789581 | 2021-10-06 | Pawnee | Oklahoma | 40117 | 2564 | 60 |
1790315 | 1790315 | 2021-10-06 | Buckingham | Virginia | 51029 | 2564 | 36 |
1728466 | 1728466 | 2021-09-17 | San Jacinto | Texas | 48407 | 2564 | 54 |
1655258 | 1655258 | 2021-08-26 | Meade | Kentucky | 21163 | 2564 | 27 |
1629679 | 1629679 | 2021-08-18 | Winston | Mississippi | 28159 | 2564 | 86 |
1622199 | 1622199 | 2021-08-16 | Putnam | Georgia | 13237 | 2564 | 64 |
1619862 | 1619862 | 2021-08-15 | Attala | Mississippi | 28007 | 2564 | 75 |
1616614 | 1616614 | 2021-08-14 | Attala | Mississippi | 28007 | 2564 | 75 |
1613366 | 1613366 | 2021-08-13 | Attala | Mississippi | 28007 | 2564 | 75 |
1614714 | 1614714 | 2021-08-13 | Lampasas | Texas | 48281 | 2564 | 38 |
1611531 | 1611531 | 2021-08-12 | Scurry | Texas | 48415 | 2564 | 62 |
1591948 | 1591948 | 2021-08-06 | Hutchinson | Texas | 48233 | 2564 | 72 |
1578859 | 1578859 | 2021-08-02 | Burleson | Texas | 48051 | 2564 | 48 |
1563341 | 1563341 | 2021-07-29 | Columbia | Arkansas | 5027 | 2564 | 58 |
1546100 | 1546100 | 2021-07-23 | Humacao | Puerto Rico | 72069 | 2564 | |
1537285 | 1537285 | 2021-07-21 | Marengo | Alabama | 1091 | 2564 | 67 |
1517099 | 1517099 | 2021-07-14 | Morgan | Tennessee | 47129 | 2564 | 37 |
1510606 | 1510606 | 2021-07-12 | Morgan | Tennessee | 47129 | 2564 | 37 |
1497409 | 1497409 | 2021-07-08 | Mayaguez | Puerto Rico | 72097 | 2564 | |
1493643 | 1493643 | 2021-07-07 | Franklin | New York | 36033 | 2564 | 12 |
1494162 | 1494162 | 2021-07-07 | Mayaguez | Puerto Rico | 72097 | 2564 | |
1490137 | 1490137 | 2021-07-06 | Stoddard | Missouri | 29207 | 2564 | 42 |
1490396 | 1490396 | 2021-07-06 | Franklin | New York | 36033 | 2564 | 12 |
1490915 | 1490915 | 2021-07-06 | Mayaguez | Puerto Rico | 72097 | 2564 | |
1486890 | 1486890 | 2021-07-05 | Stoddard | Missouri | 29207 | 2564 | 42 |
1487149 | 1487149 | 2021-07-05 | Franklin | New York | 36033 | 2564 | 12 |
1483903 | 1483903 | 2021-07-04 | Franklin | New York | 36033 | 2564 | 12 |
1480657 | 1480657 | 2021-07-03 | Franklin | New York | 36033 | 2564 | 12 |
1477410 | 1477410 | 2021-07-02 | Franklin | New York | 36033 | 2564 | 12 |
1474164 | 1474164 | 2021-07-01 | Franklin | New York | 36033 | 2564 | 12 |
1470918 | 1470918 | 2021-06-30 | Franklin | New York | 36033 | 2564 | 12 |
1467673 | 1467673 | 2021-06-29 | Franklin | New York | 36033 | 2564 | 12 |
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);