ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 3975 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 12
- Mississippi 9
- Virginia 9
- Indiana 8
- Louisiana 8
- Minnesota 6
- South Carolina 6
- Texas 6
- Arkansas 5
- Kentucky 4
- Missouri 4
- North Carolina 4
- Ohio 4
- Tennessee 4
- Alaska 3
- Georgia 3
- Kansas 3
- New York 3
- Pennsylvania 3
- Utah 3
- West Virginia 3
- Idaho 2
- New Mexico 2
- Oklahoma 2
- Alabama 1
- California 1
- Michigan 1
- New Hampshire 1
- Oregon 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499729 | 2499729 | 2022-05-13 | Madison | Arkansas | 5087 | 3975 | 61 |
2496471 | 2496471 | 2022-05-12 | Madison | Arkansas | 5087 | 3975 | 61 |
2421146 | 2421146 | 2022-04-18 | Greene | Virginia | 51079 | 3975 | 61 |
2385332 | 2385332 | 2022-04-07 | Goochland | Virginia | 51075 | 3975 | 51 |
2385574 | 2385574 | 2022-04-07 | Washburn | Wisconsin | 55129 | 3975 | 46 |
2359223 | 2359223 | 2022-03-30 | San Juan | Utah | 49037 | 3975 | 48 |
2355969 | 2355969 | 2022-03-29 | San Juan | Utah | 49037 | 3975 | 48 |
2352716 | 2352716 | 2022-03-28 | San Juan | Utah | 49037 | 3975 | 48 |
2294284 | 2294284 | 2022-03-10 | Nottoway | Virginia | 51135 | 3975 | 85 |
2285429 | 2285429 | 2022-03-08 | Mercer | Illinois | 17131 | 3975 | 47 |
2287743 | 2287743 | 2022-03-08 | Greene | Virginia | 51079 | 3975 | 60 |
2282177 | 2282177 | 2022-03-07 | Mercer | Illinois | 17131 | 3975 | 47 |
2281238 | 2281238 | 2022-03-06 | Grayson | Virginia | 51077 | 3975 | 77 |
2277985 | 2277985 | 2022-03-05 | Grayson | Virginia | 51077 | 3975 | 77 |
2274732 | 2274732 | 2022-03-04 | Grayson | Virginia | 51077 | 3975 | 77 |
2262639 | 2262639 | 2022-03-01 | Jo Daviess | Illinois | 17085 | 3975 | 38 |
2259388 | 2259388 | 2022-02-28 | Jo Daviess | Illinois | 17085 | 3975 | 38 |
2235380 | 2235380 | 2022-02-20 | Bosque | Texas | 48035 | 3975 | 67 |
2232129 | 2232129 | 2022-02-19 | Bosque | Texas | 48035 | 3975 | 67 |
2177529 | 2177529 | 2022-02-03 | Nome Census Area | Alaska | 2180 | 3975 | 3 |
2174276 | 2174276 | 2022-02-02 | Nome Census Area | Alaska | 2180 | 3975 | 3 |
2167571 | 2167571 | 2022-01-30 | Morgan | West Virginia | 54065 | 3975 | 58 |
2162760 | 2162760 | 2022-01-29 | Pike | Missouri | 29163 | 3975 | 56 |
2145533 | 2145533 | 2022-01-24 | De Witt | Illinois | 17039 | 3975 | 40 |
2132034 | 2132034 | 2022-01-20 | Hempstead | Arkansas | 5057 | 3975 | 51 |
2127649 | 2127649 | 2022-01-18 | Union | Oregon | 41061 | 3975 | 65 |
2109753 | 2109753 | 2022-01-13 | Edgar | Illinois | 17045 | 3975 | 75 |
1996820 | 1996820 | 2021-12-09 | Newton | Mississippi | 28101 | 3975 | 82 |
1993475 | 1993475 | 2021-12-08 | Martin | Minnesota | 27091 | 3975 | 46 |
1966676 | 1966676 | 2021-11-30 | Cassia | Idaho | 16031 | 3975 | 43 |
1949615 | 1949615 | 2021-11-24 | Orange | Virginia | 51137 | 3975 | 61 |
1935095 | 1935095 | 2021-11-20 | Audrain | Missouri | 29007 | 3975 | 79 |
1925003 | 1925003 | 2021-11-17 | Pointe Coupee | Louisiana | 22077 | 3975 | 84 |
1923840 | 1923840 | 2021-11-16 | Uinta | Wyoming | 56041 | 3975 | 30 |
1916027 | 1916027 | 2021-11-14 | Dare | North Carolina | 37055 | 3975 | 14 |
1912777 | 1912777 | 2021-11-13 | Dare | North Carolina | 37055 | 3975 | 14 |
1913977 | 1913977 | 2021-11-13 | Nicholas | West Virginia | 54067 | 3975 | 54 |
1909527 | 1909527 | 2021-11-12 | Dare | North Carolina | 37055 | 3975 | 14 |
1895664 | 1895664 | 2021-11-08 | Letcher | Kentucky | 21133 | 3975 | 70 |
1871717 | 1871717 | 2021-10-31 | Jackson | West Virginia | 54035 | 3975 | 86 |
1854187 | 1854187 | 2021-10-26 | Luna | New Mexico | 35029 | 3975 | 94 |
1854682 | 1854682 | 2021-10-26 | Warren | Pennsylvania | 42123 | 3975 | 124 |
1762099 | 1762099 | 2021-09-28 | Decatur | Indiana | 18031 | 3975 | 103 |
1762173 | 1762173 | 2021-09-28 | White | Indiana | 18181 | 3975 | 59 |
1756336 | 1756336 | 2021-09-26 | Leake | Mississippi | 28079 | 3975 | 86 |
1753088 | 1753088 | 2021-09-25 | Leake | Mississippi | 28079 | 3975 | 86 |
1749840 | 1749840 | 2021-09-24 | Leake | Mississippi | 28079 | 3975 | 86 |
1731182 | 1731182 | 2021-09-18 | Greene | Pennsylvania | 42059 | 3975 | 47 |
1717353 | 1717353 | 2021-09-14 | Marion | Mississippi | 28091 | 3975 | 97 |
1710541 | 1710541 | 2021-09-12 | Franklin | Louisiana | 22041 | 3975 | 129 |
1707294 | 1707294 | 2021-09-11 | Franklin | Louisiana | 22041 | 3975 | 129 |
1704046 | 1704046 | 2021-09-10 | Franklin | Louisiana | 22041 | 3975 | 129 |
1698687 | 1698687 | 2021-09-08 | Clinton | Pennsylvania | 42035 | 3975 | 69 |
1688142 | 1688142 | 2021-09-05 | Tate | Mississippi | 28137 | 3975 | 93 |
1684892 | 1684892 | 2021-09-04 | Tate | Mississippi | 28137 | 3975 | 93 |
1681641 | 1681641 | 2021-09-03 | Tate | Mississippi | 28137 | 3975 | 93 |
1614350 | 1614350 | 2021-08-13 | Trujillo Alto | Puerto Rico | 72139 | 3975 | |
1595882 | 1595882 | 2021-08-08 | St. Francis | Arkansas | 5123 | 3975 | 46 |
1598136 | 1598136 | 2021-08-08 | Colleton | South Carolina | 45029 | 3975 | 135 |
1594887 | 1594887 | 2021-08-07 | Colleton | South Carolina | 45029 | 3975 | 135 |
1591638 | 1591638 | 2021-08-06 | Colleton | South Carolina | 45029 | 3975 | 135 |
1577992 | 1577992 | 2021-08-02 | Cheshire | New Hampshire | 33005 | 3975 | 35 |
1573572 | 1573572 | 2021-08-01 | Christian | Illinois | 17021 | 3975 | 93 |
1570324 | 1570324 | 2021-07-31 | Christian | Illinois | 17021 | 3975 | 93 |
1567076 | 1567076 | 2021-07-30 | Christian | Illinois | 17021 | 3975 | 93 |
1412037 | 1412037 | 2021-06-12 | Steele | Minnesota | 27147 | 3975 | 16 |
1408792 | 1408792 | 2021-06-11 | Steele | Minnesota | 27147 | 3975 | 16 |
1339966 | 1339966 | 2021-05-21 | Huntington | Indiana | 18069 | 3975 | 82 |
1326650 | 1326650 | 2021-05-17 | Camden | Georgia | 13039 | 3975 | 37 |
1328307 | 1328307 | 2021-05-17 | Brown | Ohio | 39015 | 3975 | 57 |
1320543 | 1320543 | 2021-05-15 | Whitley | Indiana | 18183 | 3975 | 39 |
1314237 | 1314237 | 2021-05-13 | Seward | Kansas | 20175 | 3975 | 41 |
1302345 | 1302345 | 2021-05-09 | Crawford | Ohio | 39033 | 3975 | 107 |
1299097 | 1299097 | 2021-05-08 | Crawford | Ohio | 39033 | 3975 | 107 |
1270357 | 1270357 | 2021-04-29 | Giles | Tennessee | 47055 | 3975 | 99 |
1242324 | 1242324 | 2021-04-21 | Oconee | Georgia | 13219 | 3975 | 70 |
1243201 | 1243201 | 2021-04-21 | Morrison | Minnesota | 27097 | 3975 | 59 |
1231697 | 1231697 | 2021-04-17 | Waller | Texas | 48473 | 3975 | 46 |
1225768 | 1225768 | 2021-04-16 | Union | Arkansas | 5139 | 3975 | 112 |
1228538 | 1228538 | 2021-04-16 | Charlottesville city | Virginia | 51540 | 3975 | 55 |
1217225 | 1217225 | 2021-04-13 | Nobles | Minnesota | 27105 | 3975 | 48 |
1189038 | 1189038 | 2021-04-04 | Chester | South Carolina | 45023 | 3975 | 71 |
1185791 | 1185791 | 2021-04-03 | Chester | South Carolina | 45023 | 3975 | 71 |
1167846 | 1167846 | 2021-03-29 | DeKalb | Indiana | 18033 | 3975 | 84 |
1165062 | 1165062 | 2021-03-28 | Webster | Louisiana | 22119 | 3975 | 107 |
1161814 | 1161814 | 2021-03-27 | Webster | Louisiana | 22119 | 3975 | 107 |
1158566 | 1158566 | 2021-03-26 | Webster | Louisiana | 22119 | 3975 | 107 |
1110031 | 1110031 | 2021-03-11 | Douglas | Minnesota | 27041 | 3975 | 70 |
1110171 | 1110171 | 2021-03-11 | Union | Mississippi | 28145 | 3975 | 74 |
1100001 | 1100001 | 2021-03-08 | Hopkins | Kentucky | 21107 | 3975 | 128 |
1089921 | 1089921 | 2021-03-05 | Clinton | Indiana | 18023 | 3975 | 58 |
1086640 | 1086640 | 2021-03-04 | Randolph | Illinois | 17157 | 3975 | 85 |
1085409 | 1085409 | 2021-03-03 | Erath | Texas | 48143 | 3975 | 67 |
1079547 | 1079547 | 2021-03-02 | Kenai Peninsula Borough | Alaska | 2122 | 3975 | 19 |
1075519 | 1075519 | 2021-02-28 | Cocke | Tennessee | 47029 | 3975 | 93 |
1057757 | 1057757 | 2021-02-23 | Barren | Kentucky | 21009 | 3975 | 71 |
1035089 | 1035089 | 2021-02-16 | Jessamine | Kentucky | 21113 | 3975 | 49 |
1018754 | 1018754 | 2021-02-11 | Lyon | Kansas | 20111 | 3975 | 75 |
1015509 | 1015509 | 2021-02-10 | Lyon | Kansas | 20111 | 3975 | 75 |
1013223 | 1013223 | 2021-02-09 | Beaufort | North Carolina | 37013 | 3975 | 76 |
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);