ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 3402 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- New York 12
- Minnesota 10
- Tennessee 9
- Georgia 8
- Mississippi 8
- Michigan 7
- Washington 7
- Wisconsin 7
- Colorado 5
- Illinois 5
- Indiana 5
- Kansas 5
- Kentucky 5
- Louisiana 5
- Missouri 5
- Ohio 5
- Puerto Rico 5
- Alabama 4
- California 4
- Arkansas 3
- Montana 3
- North Carolina 3
- Virginia 3
- West Virginia 3
- Florida 2
- Idaho 2
- Maryland 2
- Oklahoma 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490072 | 2490072 | 2022-05-10 | Gunnison | Colorado | 8051 | 3402 | 14 |
2492967 | 2492967 | 2022-05-10 | Bayfield | Wisconsin | 55007 | 3402 | 41 |
2486815 | 2486815 | 2022-05-09 | Gunnison | Colorado | 8051 | 3402 | 14 |
2489404 | 2489404 | 2022-05-09 | Tyler | Texas | 48457 | 3402 | 88 |
2486146 | 2486146 | 2022-05-08 | Tyler | Texas | 48457 | 3402 | 88 |
2482888 | 2482888 | 2022-05-07 | Tyler | Texas | 48457 | 3402 | 88 |
2479630 | 2479630 | 2022-05-06 | Tyler | Texas | 48457 | 3402 | 88 |
2406376 | 2406376 | 2022-04-14 | Nantucket | Massachusetts | 25019 | 3402 | 0 |
2327003 | 2327003 | 2022-03-20 | Rusk | Wisconsin | 55107 | 3402 | 54 |
2323750 | 2323750 | 2022-03-19 | Rusk | Wisconsin | 55107 | 3402 | 54 |
2320496 | 2320496 | 2022-03-18 | Rusk | Wisconsin | 55107 | 3402 | 54 |
2308777 | 2308777 | 2022-03-15 | Benzie | Michigan | 26019 | 3402 | 65 |
2305526 | 2305526 | 2022-03-14 | Benzie | Michigan | 26019 | 3402 | 65 |
2302913 | 2302913 | 2022-03-13 | Schuyler | New York | 36097 | 3402 | 25 |
2265650 | 2265650 | 2022-03-02 | Brooks | Georgia | 13027 | 3402 | 82 |
2262399 | 2262399 | 2022-03-01 | Brooks | Georgia | 13027 | 3402 | 82 |
2242759 | 2242759 | 2022-02-23 | Grand | Colorado | 8049 | 3402 | 23 |
2242770 | 2242770 | 2022-02-23 | Las Animas | Colorado | 8071 | 3402 | 39 |
2231882 | 2231882 | 2022-02-19 | San German | Puerto Rico | 72125 | 3402 | |
2221851 | 2221851 | 2022-02-16 | Monroe | Ohio | 39111 | 3402 | 72 |
2219562 | 2219562 | 2022-02-15 | Klickitat | Washington | 53039 | 3402 | 40 |
2216312 | 2216312 | 2022-02-14 | Klickitat | Washington | 53039 | 3402 | 40 |
2211338 | 2211338 | 2022-02-13 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2208085 | 2208085 | 2022-02-12 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2209065 | 2209065 | 2022-02-12 | Anasco | Puerto Rico | 72011 | 3402 | |
2204832 | 2204832 | 2022-02-11 | Kanabec | Minnesota | 27065 | 3402 | 54 |
2197545 | 2197545 | 2022-02-09 | Gem | Idaho | 16045 | 3402 | 77 |
2188492 | 2188492 | 2022-02-06 | Leelanau | Michigan | 26089 | 3402 | 47 |
2185239 | 2185239 | 2022-02-05 | Leelanau | Michigan | 26089 | 3402 | 47 |
2181987 | 2181987 | 2022-02-04 | Leelanau | Michigan | 26089 | 3402 | 47 |
2179151 | 2179151 | 2022-02-03 | Gage | Nebraska | 31067 | 3402 | 37 |
2143162 | 2143162 | 2022-01-23 | Bates | Missouri | 29013 | 3402 | 70 |
2100051 | 2100051 | 2022-01-10 | Piatt | Illinois | 17147 | 3402 | 23 |
2096837 | 2096837 | 2022-01-09 | Carroll | Indiana | 18015 | 3402 | 49 |
2093585 | 2093585 | 2022-01-08 | Carroll | Indiana | 18015 | 3402 | 49 |
2090333 | 2090333 | 2022-01-07 | Carroll | Indiana | 18015 | 3402 | 49 |
2074499 | 2074499 | 2022-01-02 | Concordia | Louisiana | 22029 | 3402 | 80 |
2071248 | 2071248 | 2022-01-01 | Concordia | Louisiana | 22029 | 3402 | 80 |
2067997 | 2067997 | 2021-12-31 | Concordia | Louisiana | 22029 | 3402 | 80 |
2064746 | 2064746 | 2021-12-30 | Concordia | Louisiana | 22029 | 3402 | 80 |
2030924 | 2030924 | 2021-12-19 | Adams | Washington | 53001 | 3402 | 34 |
2030984 | 2030984 | 2021-12-19 | Lincoln | West Virginia | 54043 | 3402 | 54 |
2027673 | 2027673 | 2021-12-18 | Adams | Washington | 53001 | 3402 | 34 |
2024422 | 2024422 | 2021-12-17 | Adams | Washington | 53001 | 3402 | 34 |
1998660 | 1998660 | 2021-12-10 | Randolph | Alabama | 1111 | 3402 | 67 |
1988972 | 1988972 | 2021-12-07 | Clark | Arkansas | 5019 | 3402 | 63 |
1978151 | 1978151 | 2021-12-03 | Juniata | Pennsylvania | 42067 | 3402 | 128 |
1968461 | 1968461 | 2021-11-30 | Dorado | Puerto Rico | 72051 | 3402 | |
1965210 | 1965210 | 2021-11-29 | Dorado | Puerto Rico | 72051 | 3402 | |
1965398 | 1965398 | 2021-11-29 | Crockett | Tennessee | 47033 | 3402 | 63 |
1961958 | 1961958 | 2021-11-28 | Dorado | Puerto Rico | 72051 | 3402 | |
1944961 | 1944961 | 2021-11-23 | Big Horn | Montana | 30003 | 3402 | 83 |
1927264 | 1927264 | 2021-11-18 | Randolph | Arkansas | 5121 | 3402 | 63 |
1928709 | 1928709 | 2021-11-18 | Big Horn | Montana | 30003 | 3402 | 82 |
1923967 | 1923967 | 2021-11-17 | Columbia | Arkansas | 5027 | 3402 | 74 |
1923555 | 1923555 | 2021-11-16 | Dinwiddie | Virginia | 51053 | 3402 | 58 |
1910707 | 1910707 | 2021-11-12 | Hampshire | West Virginia | 54027 | 3402 | 49 |
1896747 | 1896747 | 2021-11-08 | Wyandot | Ohio | 39175 | 3402 | 64 |
1891998 | 1891998 | 2021-11-07 | Lawrence | Illinois | 17101 | 3402 | 44 |
1888748 | 1888748 | 2021-11-06 | Lawrence | Illinois | 17101 | 3402 | 44 |
1884891 | 1884891 | 2021-11-05 | Marengo | Alabama | 1091 | 3402 | 91 |
1885498 | 1885498 | 2021-11-05 | Lawrence | Illinois | 17101 | 3402 | 44 |
1875593 | 1875593 | 2021-11-02 | Morgan | Georgia | 13211 | 3402 | 42 |
1876508 | 1876508 | 2021-11-02 | Waseca | Minnesota | 27161 | 3402 | 31 |
1816160 | 1816160 | 2021-10-14 | Moore | Texas | 48341 | 3402 | 84 |
1745395 | 1745395 | 2021-09-23 | Delta | Colorado | 8029 | 3402 | 79 |
1743411 | 1743411 | 2021-09-22 | Crawford | Missouri | 29055 | 3402 | 51 |
1716968 | 1716968 | 2021-09-14 | Marion | Kentucky | 21155 | 3402 | 40 |
1710835 | 1710835 | 2021-09-12 | Grenada | Mississippi | 28043 | 3402 | 97 |
1707588 | 1707588 | 2021-09-11 | Grenada | Mississippi | 28043 | 3402 | 97 |
1704341 | 1704341 | 2021-09-10 | Grenada | Mississippi | 28043 | 3402 | 97 |
1701739 | 1701739 | 2021-09-09 | Fayette | Ohio | 39047 | 3402 | 51 |
1695039 | 1695039 | 2021-09-07 | Orleans | New York | 36073 | 3402 | 83 |
1679967 | 1679967 | 2021-09-02 | Wythe | Virginia | 51197 | 3402 | 86 |
1673895 | 1673895 | 2021-09-01 | Siskiyou | California | 6093 | 3402 | 41 |
1645480 | 1645480 | 2021-08-23 | Harlan | Kentucky | 21095 | 3402 | 94 |
1643770 | 1643770 | 2021-08-22 | McNairy | Tennessee | 47109 | 3402 | 57 |
1640520 | 1640520 | 2021-08-21 | McNairy | Tennessee | 47109 | 3402 | 57 |
1637270 | 1637270 | 2021-08-20 | McNairy | Tennessee | 47109 | 3402 | 57 |
1631911 | 1631911 | 2021-08-19 | Lee | Georgia | 13177 | 3402 | 62 |
1623255 | 1623255 | 2021-08-16 | Miller | Missouri | 29131 | 3402 | 64 |
1618484 | 1618484 | 2021-08-15 | Lawrence | Alabama | 1079 | 3402 | 100 |
1609338 | 1609338 | 2021-08-12 | Iroquois | Illinois | 17075 | 3402 | 70 |
1611847 | 1611847 | 2021-08-12 | Wayne | West Virginia | 54099 | 3402 | 46 |
1599960 | 1599960 | 2021-08-09 | Bell | Kentucky | 21013 | 3402 | 58 |
1587342 | 1587342 | 2021-08-05 | Pine | Minnesota | 27115 | 3402 | 23 |
1585002 | 1585002 | 2021-08-04 | Greene | Pennsylvania | 42059 | 3402 | 42 |
1560763 | 1560763 | 2021-07-28 | White | Indiana | 18181 | 3402 | 55 |
1496510 | 1496510 | 2021-07-08 | Sunflower | Mississippi | 28133 | 3402 | 93 |
1474869 | 1474869 | 2021-07-01 | Henry | Tennessee | 47079 | 3402 | 76 |
1429675 | 1429675 | 2021-06-17 | Polk | Texas | 48373 | 3402 | 120 |
1426430 | 1426430 | 2021-06-16 | Polk | Texas | 48373 | 3402 | 120 |
1423183 | 1423183 | 2021-06-15 | Polk | Texas | 48373 | 3402 | 120 |
1419937 | 1419937 | 2021-06-14 | Polk | Texas | 48373 | 3402 | 120 |
1415747 | 1415747 | 2021-06-13 | Greene | New York | 36039 | 3402 | 79 |
1416692 | 1416692 | 2021-06-13 | Polk | Texas | 48373 | 3402 | 120 |
1412501 | 1412501 | 2021-06-12 | Greene | New York | 36039 | 3402 | 79 |
1413446 | 1413446 | 2021-06-12 | Polk | Texas | 48373 | 3402 | 120 |
1409256 | 1409256 | 2021-06-11 | Greene | New York | 36039 | 3402 | 79 |
1406011 | 1406011 | 2021-06-10 | Greene | New York | 36039 | 3402 | 79 |
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);