ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 5797 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 8
- Kentucky 7
- Puerto Rico 7
- Missouri 5
- Colorado 4
- New York 4
- Tennessee 4
- Virginia 4
- Arkansas 3
- Minnesota 3
- Mississippi 3
- North Carolina 3
- Pennsylvania 3
- California 2
- Illinois 2
- Alabama 1
- Delaware 1
- Georgia 1
- Indiana 1
- Iowa 1
- Kansas 1
- Louisiana 1
- Maine 1
- Maryland 1
- Ohio 1
- Oregon 1
- South Carolina 1
- South Dakota 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475119 | 2475119 | 2022-05-05 | Stone | Missouri | 29209 | 5797 | 122 |
2462838 | 2462838 | 2022-05-01 | Cabo Rojo | Puerto Rico | 72023 | 5797 | |
2415989 | 2415989 | 2022-04-17 | Meade | Kentucky | 21163 | 5797 | 65 |
2412733 | 2412733 | 2022-04-16 | Meade | Kentucky | 21163 | 5797 | 65 |
2409477 | 2409477 | 2022-04-15 | Meade | Kentucky | 21163 | 5797 | 65 |
2406221 | 2406221 | 2022-04-14 | Meade | Kentucky | 21163 | 5797 | 65 |
2402965 | 2402965 | 2022-04-13 | Meade | Kentucky | 21163 | 5797 | 65 |
2399711 | 2399711 | 2022-04-12 | Meade | Kentucky | 21163 | 5797 | 65 |
2396455 | 2396455 | 2022-04-11 | Meade | Kentucky | 21163 | 5797 | 65 |
2381470 | 2381470 | 2022-04-06 | Juana Diaz | Puerto Rico | 72075 | 5797 | |
2296410 | 2296410 | 2022-03-11 | Seneca | New York | 36099 | 5797 | 89 |
2266620 | 2266620 | 2022-03-02 | Meeker | Minnesota | 27093 | 5797 | 74 |
2263196 | 2263196 | 2022-03-01 | Waldo | Maine | 23027 | 5797 | 52 |
2215711 | 2215711 | 2022-02-14 | Davison | South Dakota | 46035 | 5797 | 78 |
2169254 | 2169254 | 2022-01-31 | Miller | Missouri | 29131 | 5797 | 105 |
2161209 | 2161209 | 2022-01-29 | Geneva | Alabama | 1061 | 5797 | 142 |
2128828 | 2128828 | 2022-01-19 | Yell | Arkansas | 5149 | 5797 | 92 |
2126132 | 2126132 | 2022-01-18 | Jennings | Indiana | 18079 | 5797 | 82 |
2112054 | 2112054 | 2022-01-13 | Windsor | Vermont | 50027 | 5797 | 46 |
2036277 | 2036277 | 2021-12-21 | Bladen | North Carolina | 37017 | 5797 | 96 |
2032697 | 2032697 | 2021-12-20 | Pulaski | Missouri | 29169 | 5797 | 97 |
2017249 | 2017249 | 2021-12-15 | Ponce | Puerto Rico | 72113 | 5797 | |
2013999 | 2013999 | 2021-12-14 | Ponce | Puerto Rico | 72113 | 5797 | |
2014013 | 2014013 | 2021-12-14 | Unknown | Puerto Rico | 5797 | 3276 | |
1962001 | 1962001 | 2021-11-28 | Toa Alta | Puerto Rico | 72135 | 5797 | |
1958750 | 1958750 | 2021-11-27 | Toa Alta | Puerto Rico | 72135 | 5797 | |
1926385 | 1926385 | 2021-11-17 | Claiborne | Tennessee | 47025 | 5797 | 115 |
1921092 | 1921092 | 2021-11-16 | Oconee | Georgia | 13219 | 5797 | 81 |
1918761 | 1918761 | 2021-11-15 | Alcorn | Mississippi | 28003 | 5797 | 105 |
1899054 | 1899054 | 2021-11-09 | Calvert | Maryland | 24009 | 5797 | 101 |
1899389 | 1899389 | 2021-11-09 | Howell | Missouri | 29091 | 5797 | 78 |
1880599 | 1880599 | 2021-11-03 | Malheur | Oregon | 41045 | 5797 | 82 |
1880932 | 1880932 | 2021-11-03 | Marion | Tennessee | 47115 | 5797 | 54 |
1868781 | 1868781 | 2021-10-31 | Union | Arkansas | 5139 | 5797 | 138 |
1851961 | 1851961 | 2021-10-25 | Upshur | Texas | 48459 | 5797 | 139 |
1848711 | 1848711 | 2021-10-24 | Upshur | Texas | 48459 | 5797 | 139 |
1839470 | 1839470 | 2021-10-22 | Baxter | Arkansas | 5005 | 5797 | 176 |
1795452 | 1795452 | 2021-10-08 | Platte | Missouri | 29165 | 5797 | 59 |
1785476 | 1785476 | 2021-10-05 | Goodhue | Minnesota | 27049 | 5797 | 82 |
1764337 | 1764337 | 2021-09-28 | Danville city | Virginia | 51590 | 5797 | 167 |
1746262 | 1746262 | 2021-09-23 | Beauregard | Louisiana | 22011 | 5797 | 113 |
1709651 | 1709651 | 2021-09-12 | Broomfield | Colorado | 8014 | 5797 | 77 |
1706404 | 1706404 | 2021-09-11 | Broomfield | Colorado | 8014 | 5797 | 77 |
1703156 | 1703156 | 2021-09-10 | Broomfield | Colorado | 8014 | 5797 | 77 |
1692876 | 1692876 | 2021-09-06 | Fauquier | Virginia | 51061 | 5797 | 72 |
1669090 | 1669090 | 2021-08-30 | Chatham | North Carolina | 37037 | 5797 | 91 |
1652417 | 1652417 | 2021-08-25 | Warren | Mississippi | 28149 | 5797 | 139 |
1632899 | 1632899 | 2021-08-19 | Oktibbeha | Mississippi | 28105 | 5797 | 102 |
1634230 | 1634230 | 2021-08-19 | Nacogdoches | Texas | 48347 | 5797 | 178 |
1584810 | 1584810 | 2021-08-04 | Jefferson | Ohio | 39081 | 5797 | 162 |
1565192 | 1565192 | 2021-07-29 | Pender | North Carolina | 37141 | 5797 | 69 |
1534229 | 1534229 | 2021-07-20 | Tehama | California | 6103 | 5797 | 65 |
1500926 | 1500926 | 2021-07-09 | Caldwell | Texas | 48055 | 5797 | 100 |
1480696 | 1480696 | 2021-07-03 | Wayne | New York | 36117 | 5797 | 71 |
1477449 | 1477449 | 2021-07-02 | Wayne | New York | 36117 | 5797 | 71 |
1472918 | 1472918 | 2021-07-01 | Clinton | Illinois | 17027 | 5797 | 100 |
1343363 | 1343363 | 2021-05-22 | Warren | Iowa | 19181 | 5797 | 90 |
1338610 | 1338610 | 2021-05-20 | Atascosa | Texas | 48013 | 5797 | 150 |
1284669 | 1284669 | 2021-05-04 | Grundy | Illinois | 17063 | 5797 | 75 |
1285375 | 1285375 | 2021-05-04 | Chisago | Minnesota | 27025 | 5797 | 51 |
1267144 | 1267144 | 2021-04-28 | Monroe | Tennessee | 47123 | 5797 | 95 |
1244589 | 1244589 | 2021-04-21 | Lamar | Texas | 48277 | 5797 | 154 |
1241342 | 1241342 | 2021-04-20 | Lamar | Texas | 48277 | 5797 | 154 |
1238095 | 1238095 | 2021-04-19 | Lamar | Texas | 48277 | 5797 | 154 |
1120315 | 1120315 | 2021-03-14 | St. Lawrence | New York | 36089 | 5797 | 92 |
1102413 | 1102413 | 2021-03-09 | San Benito | California | 6069 | 5797 | 61 |
1081997 | 1081997 | 2021-03-02 | Bedford | Tennessee | 47003 | 5797 | 120 |
936423 | 936423 | 2021-01-16 | Montgomery | Virginia | 51121 | 5797 | 49 |
877304 | 877304 | 2020-12-29 | Lycoming | Pennsylvania | 42081 | 5797 | 116 |
874063 | 874063 | 2020-12-28 | Monroe | Pennsylvania | 42089 | 5797 | 193 |
836978 | 836978 | 2020-12-17 | Douglas | Kansas | 20045 | 5797 | 31 |
702201 | 702201 | 2020-11-05 | Florence | South Carolina | 45041 | 5797 | 204 |
680558 | 680558 | 2020-10-30 | Boulder | Colorado | 8013 | 5797 | 86 |
556786 | 556786 | 2020-09-21 | Chesterfield | Virginia | 51041 | 5797 | 91 |
328572 | 328572 | 2020-07-13 | New Castle | Delaware | 10003 | 5797 | 249 |
150346 | 150346 | 2020-05-16 | Montgomery | Pennsylvania | 42091 | 5797 | 614 |
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);