ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3620 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 11
- Wisconsin 11
- Alabama 9
- Georgia 9
- Michigan 9
- Florida 8
- Oklahoma 8
- Minnesota 7
- North Dakota 7
- Arkansas 6
- Nebraska 6
- Texas 6
- Kentucky 5
- New York 5
- Louisiana 4
- Maryland 4
- Mississippi 4
- Missouri 4
- Ohio 4
- Pennsylvania 4
- Puerto Rico 3
- South Dakota 3
- Virginia 3
- Illinois 2
- Indiana 2
- Iowa 2
- Kansas 2
- Oregon 2
- Washington 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468289 | 2468289 | 2022-05-03 | Leelanau | Michigan | 26089 | 3620 | 54 |
2465034 | 2465034 | 2022-05-02 | Leelanau | Michigan | 26089 | 3620 | 54 |
2461778 | 2461778 | 2022-05-01 | Leelanau | Michigan | 26089 | 3620 | 54 |
2461874 | 2461874 | 2022-05-01 | Pennington | Minnesota | 27113 | 3620 | 41 |
2458522 | 2458522 | 2022-04-30 | Leelanau | Michigan | 26089 | 3620 | 54 |
2458618 | 2458618 | 2022-04-30 | Pennington | Minnesota | 27113 | 3620 | 41 |
2455266 | 2455266 | 2022-04-29 | Leelanau | Michigan | 26089 | 3620 | 54 |
2455362 | 2455362 | 2022-04-29 | Pennington | Minnesota | 27113 | 3620 | 41 |
2452010 | 2452010 | 2022-04-28 | Leelanau | Michigan | 26089 | 3620 | 54 |
2452766 | 2452766 | 2022-04-28 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2448754 | 2448754 | 2022-04-27 | Leelanau | Michigan | 26089 | 3620 | 54 |
2449510 | 2449510 | 2022-04-27 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2446253 | 2446253 | 2022-04-26 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2442998 | 2442998 | 2022-04-25 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2439742 | 2439742 | 2022-04-24 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2436336 | 2436336 | 2022-04-23 | Schuyler | New York | 36097 | 3620 | 25 |
2436486 | 2436486 | 2022-04-23 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2433230 | 2433230 | 2022-04-22 | Ramsey | North Dakota | 38071 | 3620 | 57 |
2430329 | 2430329 | 2022-04-21 | Salinas | Puerto Rico | 72123 | 3620 | |
2347747 | 2347747 | 2022-03-27 | West Carroll | Louisiana | 22123 | 3620 | 65 |
2344494 | 2344494 | 2022-03-26 | West Carroll | Louisiana | 22123 | 3620 | 65 |
2341241 | 2341241 | 2022-03-25 | West Carroll | Louisiana | 22123 | 3620 | 65 |
2326981 | 2326981 | 2022-03-20 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2323728 | 2323728 | 2022-03-19 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2320474 | 2320474 | 2022-03-18 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2317220 | 2317220 | 2022-03-17 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2293658 | 2293658 | 2022-03-10 | Quebradillas | Puerto Rico | 72115 | 3620 | |
2265826 | 2265826 | 2022-03-02 | Gem | Idaho | 16045 | 3620 | 78 |
2244253 | 2244253 | 2022-02-23 | York | Nebraska | 31185 | 3620 | 19 |
2236496 | 2236496 | 2022-02-21 | Rabun | Georgia | 13241 | 3620 | 90 |
2237751 | 2237751 | 2022-02-21 | York | Nebraska | 31185 | 3620 | 19 |
2224747 | 2224747 | 2022-02-17 | York | Nebraska | 31185 | 3620 | 19 |
2192438 | 2192438 | 2022-02-07 | Polk | North Carolina | 37149 | 3620 | 49 |
2167709 | 2167709 | 2022-01-31 | Crenshaw | Alabama | 1041 | 3620 | 82 |
2157936 | 2157936 | 2022-01-28 | Clay | Alabama | 1027 | 3620 | 71 |
2154683 | 2154683 | 2022-01-27 | Clay | Alabama | 1027 | 3620 | 71 |
2151430 | 2151430 | 2022-01-26 | Clay | Alabama | 1027 | 3620 | 71 |
2148178 | 2148178 | 2022-01-25 | Clay | Alabama | 1027 | 3620 | 71 |
2144926 | 2144926 | 2022-01-24 | Clay | Alabama | 1027 | 3620 | 71 |
2139973 | 2139973 | 2022-01-22 | Morgan | Missouri | 29141 | 3620 | 84 |
2115769 | 2115769 | 2022-01-15 | Grant | Arkansas | 5053 | 3620 | 52 |
2106506 | 2106506 | 2022-01-12 | Ford | Illinois | 17053 | 3620 | 69 |
2080640 | 2080640 | 2022-01-04 | Rush | Indiana | 18139 | 3620 | 36 |
2054417 | 2054417 | 2021-12-27 | Kauai | Hawaii | 15007 | 3620 | 18 |
2056784 | 2056784 | 2021-12-27 | Windham | Vermont | 50025 | 3620 | 29 |
2040327 | 2040327 | 2021-12-22 | Gonzales | Texas | 48177 | 3620 | 87 |
2028970 | 2028970 | 2021-12-19 | Simpson | Kentucky | 21213 | 3620 | 69 |
2025719 | 2025719 | 2021-12-18 | Simpson | Kentucky | 21213 | 3620 | 69 |
2022468 | 2022468 | 2021-12-17 | Simpson | Kentucky | 21213 | 3620 | 69 |
2017158 | 2017158 | 2021-12-15 | Juniata | Pennsylvania | 42067 | 3620 | 139 |
2012095 | 2012095 | 2021-12-14 | McDuffie | Georgia | 13189 | 3620 | 78 |
2011573 | 2011573 | 2021-12-13 | Taylor | Wisconsin | 55119 | 3620 | 50 |
2006854 | 2006854 | 2021-12-12 | Saunders | Nebraska | 31155 | 3620 | 23 |
2003603 | 2003603 | 2021-12-11 | Saunders | Nebraska | 31155 | 3620 | 23 |
2000353 | 2000353 | 2021-12-10 | Saunders | Nebraska | 31155 | 3620 | 23 |
1992867 | 1992867 | 2021-12-08 | Owen | Indiana | 18119 | 3620 | 80 |
1947598 | 1947598 | 2021-11-24 | Adair | Kentucky | 21001 | 3620 | 86 |
1929726 | 1929726 | 2021-11-18 | Austin | Texas | 48015 | 3620 | 56 |
1897848 | 1897848 | 2021-11-09 | Barbour | Alabama | 1005 | 3620 | 79 |
1875534 | 1875534 | 2021-11-02 | Dodge | Georgia | 13091 | 3620 | 126 |
1873331 | 1873331 | 2021-11-01 | Stone | Mississippi | 28131 | 3620 | 64 |
1860379 | 1860379 | 2021-10-28 | Crawford | Missouri | 29055 | 3620 | 57 |
1862038 | 1862038 | 2021-10-28 | Kewaunee | Wisconsin | 55061 | 3620 | 41 |
1855757 | 1855757 | 2021-10-27 | Logan | Arkansas | 5083 | 3620 | 46 |
1847820 | 1847820 | 2021-10-24 | Martin | North Carolina | 37117 | 3620 | 70 |
1848384 | 1848384 | 2021-10-24 | Yankton | South Dakota | 46135 | 3620 | 38 |
1844570 | 1844570 | 2021-10-23 | Martin | North Carolina | 37117 | 3620 | 70 |
1845134 | 1845134 | 2021-10-23 | Yankton | South Dakota | 46135 | 3620 | 38 |
1841320 | 1841320 | 2021-10-22 | Martin | North Carolina | 37117 | 3620 | 70 |
1841884 | 1841884 | 2021-10-22 | Yankton | South Dakota | 46135 | 3620 | 38 |
1787105 | 1787105 | 2021-10-05 | Halifax | Virginia | 51083 | 3620 | 99 |
1778846 | 1778846 | 2021-10-03 | Queen Anne's | Maryland | 24035 | 3620 | 64 |
1774525 | 1774525 | 2021-10-02 | Lincoln | Arkansas | 5079 | 3620 | 55 |
1747229 | 1747229 | 2021-09-23 | Hardin | Ohio | 39065 | 3620 | 69 |
1739141 | 1739141 | 2021-09-21 | Pike | Georgia | 13231 | 3620 | 54 |
1734215 | 1734215 | 2021-09-19 | Coshocton | Ohio | 39031 | 3620 | 66 |
1726851 | 1726851 | 2021-09-17 | Dorchester | Maryland | 24019 | 3620 | 70 |
1678294 | 1678294 | 2021-09-02 | Pine | Minnesota | 27115 | 3620 | 23 |
1670831 | 1670831 | 2021-08-31 | Chattooga | Georgia | 13055 | 3620 | 77 |
1654693 | 1654693 | 2021-08-26 | Stephens | Georgia | 13257 | 3620 | 81 |
1654075 | 1654075 | 2021-08-25 | Wayne | West Virginia | 54099 | 3620 | 48 |
1634826 | 1634826 | 2021-08-20 | Jackson | Arkansas | 5067 | 3620 | 40 |
1619940 | 1619940 | 2021-08-15 | Yazoo | Mississippi | 28163 | 3620 | 79 |
1616692 | 1616692 | 2021-08-14 | Yazoo | Mississippi | 28163 | 3620 | 79 |
1613444 | 1613444 | 2021-08-13 | Yazoo | Mississippi | 28163 | 3620 | 79 |
1613796 | 1613796 | 2021-08-13 | Allegany | New York | 36003 | 3620 | 87 |
1610673 | 1610673 | 2021-08-12 | Pasquotank | North Carolina | 37139 | 3620 | 87 |
1602248 | 1602248 | 2021-08-10 | Marion | Alabama | 1093 | 3620 | 107 |
1594064 | 1594064 | 2021-08-07 | Warren | Missouri | 29219 | 3620 | 39 |
1581232 | 1581232 | 2021-08-03 | Lyon | Nevada | 32019 | 3620 | 69 |
1565120 | 1565120 | 2021-07-29 | Wyoming | New York | 36121 | 3620 | 53 |
1561872 | 1561872 | 2021-07-28 | Wyoming | New York | 36121 | 3620 | 53 |
1513356 | 1513356 | 2021-07-13 | Highland | Ohio | 39071 | 3620 | 68 |
1472663 | 1472663 | 2021-07-01 | Levy | Florida | 12075 | 3620 | 56 |
1469417 | 1469417 | 2021-06-30 | Levy | Florida | 12075 | 3620 | 56 |
1466172 | 1466172 | 2021-06-29 | Levy | Florida | 12075 | 3620 | 56 |
1462927 | 1462927 | 2021-06-28 | Levy | Florida | 12075 | 3620 | 56 |
1459682 | 1459682 | 2021-06-27 | Levy | Florida | 12075 | 3620 | 56 |
1456437 | 1456437 | 2021-06-26 | Levy | Florida | 12075 | 3620 | 56 |
1453192 | 1453192 | 2021-06-25 | Levy | Florida | 12075 | 3620 | 56 |
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);