ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 5090 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 5
- Georgia 5
- Oregon 5
- Puerto Rico 5
- Tennessee 5
- Arkansas 4
- Indiana 4
- Ohio 4
- Iowa 3
- Kansas 3
- Kentucky 3
- Mississippi 3
- New York 3
- California 2
- Illinois 2
- Louisiana 2
- Missouri 2
- Texas 2
- West Virginia 2
- Wisconsin 2
- Wyoming 2
- Arizona 1
- Maine 1
- Maryland 1
- Michigan 1
- Minnesota 1
- New Mexico 1
- North Carolina 1
- Pennsylvania 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486599 | 2486599 | 2022-05-09 | Randolph | Alabama | 1111 | 5090 | 75 |
2420054 | 2420054 | 2022-04-18 | Schoharie | New York | 36095 | 5090 | 36 |
2399764 | 2399764 | 2022-04-12 | Concordia | Louisiana | 22029 | 5090 | 89 |
2396508 | 2396508 | 2022-04-11 | Concordia | Louisiana | 22029 | 5090 | 89 |
2392637 | 2392637 | 2022-04-10 | Tattnall | Georgia | 13267 | 5090 | 131 |
2389381 | 2389381 | 2022-04-09 | Tattnall | Georgia | 13267 | 5090 | 131 |
2386126 | 2386126 | 2022-04-08 | Tattnall | Georgia | 13267 | 5090 | 131 |
2382871 | 2382871 | 2022-04-07 | Tattnall | Georgia | 13267 | 5090 | 131 |
2368451 | 2368451 | 2022-04-02 | Hatillo | Puerto Rico | 72065 | 5090 | |
2314142 | 2314142 | 2022-03-17 | Ashley | Arkansas | 5003 | 5090 | 64 |
2306536 | 2306536 | 2022-03-14 | Wasco | Oregon | 41065 | 5090 | 57 |
2286863 | 2286863 | 2022-03-08 | Holmes | Ohio | 39075 | 5090 | 180 |
2278265 | 2278265 | 2022-03-06 | Cherokee | Alabama | 1019 | 5090 | 79 |
2280359 | 2280359 | 2022-03-06 | Holmes | Ohio | 39075 | 5090 | 180 |
2275012 | 2275012 | 2022-03-05 | Cherokee | Alabama | 1019 | 5090 | 79 |
2271759 | 2271759 | 2022-03-04 | Cherokee | Alabama | 1019 | 5090 | 79 |
2268507 | 2268507 | 2022-03-03 | Cherokee | Alabama | 1019 | 5090 | 79 |
2246364 | 2246364 | 2022-02-24 | Edgar | Illinois | 17045 | 5090 | 77 |
2214725 | 2214725 | 2022-02-14 | Winston | Mississippi | 28159 | 5090 | 100 |
2215607 | 2215607 | 2022-02-14 | Las Piedras | Puerto Rico | 72085 | 5090 | |
2216358 | 2216358 | 2022-02-14 | McDowell | West Virginia | 54047 | 5090 | 60 |
2212356 | 2212356 | 2022-02-13 | Las Piedras | Puerto Rico | 72085 | 5090 | |
2165161 | 2165161 | 2022-01-30 | Fountain | Indiana | 18045 | 5090 | 88 |
2161906 | 2161906 | 2022-01-29 | Fountain | Indiana | 18045 | 5090 | 88 |
2158651 | 2158651 | 2022-01-28 | Fountain | Indiana | 18045 | 5090 | 88 |
2133858 | 2133858 | 2022-01-20 | Martin | North Carolina | 37117 | 5090 | 77 |
2091979 | 2091979 | 2022-01-07 | Dorado | Puerto Rico | 72051 | 5090 | |
2077981 | 2077981 | 2022-01-03 | Le Sueur | Minnesota | 27079 | 5090 | 42 |
1927020 | 1927020 | 2021-11-17 | Green | Wisconsin | 55045 | 5090 | 35 |
1905573 | 1905573 | 2021-11-11 | Worcester | Maryland | 24047 | 5090 | 123 |
1886747 | 1886747 | 2021-11-05 | Washington | New York | 36115 | 5090 | 71 |
1874853 | 1874853 | 2021-11-01 | Manassas city | Virginia | 51683 | 5090 | 53 |
1869673 | 1869673 | 2021-10-31 | Logan | Kentucky | 21141 | 5090 | 81 |
1866424 | 1866424 | 2021-10-30 | Logan | Kentucky | 21141 | 5090 | 81 |
1863175 | 1863175 | 2021-10-29 | Logan | Kentucky | 21141 | 5090 | 81 |
1845744 | 1845744 | 2021-10-23 | Preston | West Virginia | 54077 | 5090 | 82 |
1802598 | 1802598 | 2021-10-10 | Benton | Oregon | 41003 | 5090 | 30 |
1799349 | 1799349 | 2021-10-09 | Benton | Oregon | 41003 | 5090 | 30 |
1796100 | 1796100 | 2021-10-08 | Benton | Oregon | 41003 | 5090 | 30 |
1733090 | 1733090 | 2021-09-19 | Lyon | Kansas | 20111 | 5090 | 90 |
1729840 | 1729840 | 2021-09-18 | Lyon | Kansas | 20111 | 5090 | 90 |
1726590 | 1726590 | 2021-09-17 | Lyon | Kansas | 20111 | 5090 | 90 |
1695029 | 1695029 | 2021-09-07 | Madison | New York | 36053 | 5090 | 91 |
1692444 | 1692444 | 2021-09-06 | Campbell | Tennessee | 47013 | 5090 | 66 |
1689195 | 1689195 | 2021-09-05 | Campbell | Tennessee | 47013 | 5090 | 66 |
1685945 | 1685945 | 2021-09-04 | Campbell | Tennessee | 47013 | 5090 | 66 |
1682694 | 1682694 | 2021-09-03 | Campbell | Tennessee | 47013 | 5090 | 66 |
1673196 | 1673196 | 2021-08-31 | Matagorda | Texas | 48321 | 5090 | 119 |
1649795 | 1649795 | 2021-08-24 | Mercer | Ohio | 39107 | 5090 | 86 |
1641385 | 1641385 | 2021-08-22 | Lake | California | 6033 | 5090 | 69 |
1625052 | 1625052 | 2021-08-17 | Baxter | Arkansas | 5005 | 5090 | 137 |
1615353 | 1615353 | 2021-08-14 | Miller | Arkansas | 5091 | 5090 | 38 |
1605447 | 1605447 | 2021-08-10 | Sweetwater | Wyoming | 56037 | 5090 | 45 |
1597298 | 1597298 | 2021-08-08 | Scott | Missouri | 29201 | 5090 | 89 |
1417868 | 1417868 | 2021-06-14 | Jackson | Indiana | 18071 | 5090 | 75 |
1388158 | 1388158 | 2021-06-05 | Tehama | California | 6103 | 5090 | 63 |
1358631 | 1358631 | 2021-05-26 | Dunn | Wisconsin | 55033 | 5090 | 32 |
1334982 | 1334982 | 2021-05-19 | Linn | Oregon | 41043 | 5090 | 70 |
1306065 | 1306065 | 2021-05-10 | Fayette | Tennessee | 47047 | 5090 | 76 |
1263615 | 1263615 | 2021-04-27 | Mifflin | Pennsylvania | 42087 | 5090 | 176 |
1249210 | 1249210 | 2021-04-23 | Webster | Iowa | 19187 | 5090 | 92 |
1240724 | 1240724 | 2021-04-20 | Washington | Ohio | 39167 | 5090 | 108 |
1227991 | 1227991 | 2021-04-16 | Unknown | Puerto Rico | 5090 | 2185 | |
1210929 | 1210929 | 2021-04-11 | Pettis | Missouri | 29159 | 5090 | 78 |
1199589 | 1199589 | 2021-04-07 | Fremont | Wyoming | 56013 | 5090 | 82 |
1192739 | 1192739 | 2021-04-05 | Box Elder | Utah | 49003 | 5090 | 50 |
1158196 | 1158196 | 2021-03-26 | Cerro Gordo | Iowa | 19033 | 5090 | 85 |
1139090 | 1139090 | 2021-03-20 | Androscoggin | Maine | 23001 | 5090 | 57 |
1132228 | 1132228 | 2021-03-18 | Clinton | Iowa | 19045 | 5090 | 87 |
1090467 | 1090467 | 2021-03-05 | Clinton | Michigan | 26037 | 5090 | 71 |
1055971 | 1055971 | 2021-02-22 | Brown | South Dakota | 46013 | 5090 | 85 |
1025783 | 1025783 | 2021-02-13 | Washington | Mississippi | 28151 | 5090 | 126 |
933556 | 933556 | 2021-01-16 | Greene | Arkansas | 5055 | 5090 | 59 |
921895 | 921895 | 2021-01-12 | Lowndes | Mississippi | 28087 | 5090 | 102 |
872457 | 872457 | 2020-12-28 | Williamson | Illinois | 17199 | 5090 | 106 |
838881 | 838881 | 2020-12-17 | Rockwall | Texas | 48397 | 5090 | 45 |
779480 | 779480 | 2020-11-29 | Sandoval | New Mexico | 35043 | 5090 | 80 |
671027 | 671027 | 2020-10-27 | Forsyth | Georgia | 13117 | 5090 | 53 |
667434 | 667434 | 2020-10-26 | Coconino | Arizona | 4005 | 5090 | 147 |
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);