ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 5375 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Tennessee 8
- Georgia 6
- Texas 6
- Minnesota 5
- Mississippi 5
- South Carolina 5
- North Carolina 4
- Utah 4
- Alabama 3
- Kansas 3
- Ohio 3
- Arizona 2
- Illinois 2
- Indiana 2
- New Mexico 2
- Puerto Rico 2
- Vermont 2
- Virginia 2
- Arkansas 1
- Colorado 1
- Delaware 1
- Florida 1
- Kentucky 1
- New Jersey 1
- New York 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401342 | 2401342 | 2022-04-12 | Gillespie | Texas | 48171 | 5375 | 109 |
2288740 | 2288740 | 2022-03-09 | Fountain | Indiana | 18045 | 5375 | 99 |
2285489 | 2285489 | 2022-03-08 | Fountain | Indiana | 18045 | 5375 | 98 |
2256974 | 2256974 | 2022-02-27 | Stone | Mississippi | 28131 | 5375 | 70 |
2253723 | 2253723 | 2022-02-26 | Stone | Mississippi | 28131 | 5375 | 70 |
2250472 | 2250472 | 2022-02-25 | Stone | Mississippi | 28131 | 5375 | 70 |
2225337 | 2225337 | 2022-02-17 | Cidra | Puerto Rico | 72041 | 5375 | |
2203144 | 2203144 | 2022-02-10 | Windham | Vermont | 50025 | 5375 | 33 |
2197468 | 2197468 | 2022-02-09 | Pierce | Georgia | 13229 | 5375 | 113 |
2196733 | 2196733 | 2022-02-08 | Page | Virginia | 51139 | 5375 | 103 |
2191894 | 2191894 | 2022-02-07 | Grenada | Mississippi | 28043 | 5375 | 122 |
2124573 | 2124573 | 2022-01-17 | Edgefield | South Carolina | 45037 | 5375 | 60 |
2125362 | 2125362 | 2022-01-17 | Waushara | Wisconsin | 55137 | 5375 | 75 |
2121321 | 2121321 | 2022-01-16 | Edgefield | South Carolina | 45037 | 5375 | 60 |
2118069 | 2118069 | 2022-01-15 | Edgefield | South Carolina | 45037 | 5375 | 60 |
2114818 | 2114818 | 2022-01-14 | Edgefield | South Carolina | 45037 | 5375 | 60 |
2102638 | 2102638 | 2022-01-11 | Clarke | Alabama | 1025 | 5375 | 89 |
2088830 | 2088830 | 2022-01-06 | Union | South Carolina | 45087 | 5375 | 115 |
2029242 | 2029242 | 2021-12-19 | Nobles | Minnesota | 27105 | 5375 | 55 |
2030581 | 2030581 | 2021-12-19 | Grimes | Texas | 48185 | 5375 | 109 |
2025991 | 2025991 | 2021-12-18 | Nobles | Minnesota | 27105 | 5375 | 55 |
2022740 | 2022740 | 2021-12-17 | Nobles | Minnesota | 27105 | 5375 | 55 |
1930389 | 1930389 | 2021-11-19 | Marion | Alabama | 1093 | 5375 | 129 |
1891220 | 1891220 | 2021-11-06 | Marshall | West Virginia | 54051 | 5375 | 116 |
1874748 | 1874748 | 2021-11-01 | Sanpete | Utah | 49039 | 5375 | 39 |
1869560 | 1869560 | 2021-10-31 | Montgomery | Kansas | 20125 | 5375 | 114 |
1871499 | 1871499 | 2021-10-31 | Sanpete | Utah | 49039 | 5375 | 39 |
1866311 | 1866311 | 2021-10-30 | Montgomery | Kansas | 20125 | 5375 | 114 |
1868250 | 1868250 | 2021-10-30 | Sanpete | Utah | 49039 | 5375 | 39 |
1863062 | 1863062 | 2021-10-29 | Montgomery | Kansas | 20125 | 5375 | 114 |
1865001 | 1865001 | 2021-10-29 | Sanpete | Utah | 49039 | 5375 | 39 |
1850437 | 1850437 | 2021-10-25 | Becker | Minnesota | 27005 | 5375 | 62 |
1813894 | 1813894 | 2021-10-14 | Toombs | Georgia | 13279 | 5375 | 164 |
1786253 | 1786253 | 2021-10-05 | Preble | Ohio | 39135 | 5375 | 117 |
1757448 | 1757448 | 2021-09-26 | Henderson | Tennessee | 47077 | 5375 | 90 |
1754200 | 1754200 | 2021-09-25 | Henderson | Tennessee | 47077 | 5375 | 90 |
1750952 | 1750952 | 2021-09-24 | Henderson | Tennessee | 47077 | 5375 | 90 |
1721130 | 1721130 | 2021-09-15 | Stokes | North Carolina | 37169 | 5375 | 88 |
1633833 | 1633833 | 2021-08-19 | Toa Baja | Puerto Rico | 72137 | 5375 | |
1585359 | 1585359 | 2021-08-04 | Burnet | Texas | 48053 | 5375 | 73 |
1555437 | 1555437 | 2021-07-26 | McDowell | North Carolina | 37111 | 5375 | 63 |
1552781 | 1552781 | 2021-07-25 | Franklin | Tennessee | 47051 | 5375 | 92 |
1549534 | 1549534 | 2021-07-24 | Franklin | Tennessee | 47051 | 5375 | 92 |
1546287 | 1546287 | 2021-07-23 | Franklin | Tennessee | 47051 | 5375 | 92 |
1539071 | 1539071 | 2021-07-21 | Otero | New Mexico | 35035 | 5375 | 86 |
1453257 | 1453257 | 2021-06-25 | Coffee | Georgia | 13069 | 5375 | 178 |
1349354 | 1349354 | 2021-05-24 | Suwannee | Florida | 12121 | 5375 | 138 |
1266654 | 1266654 | 2021-04-28 | Huron | Ohio | 39077 | 5375 | 117 |
1190957 | 1190957 | 2021-04-05 | Pike | Kentucky | 21195 | 5375 | 84 |
1127826 | 1127826 | 2021-03-16 | Chittenden | Vermont | 50007 | 5375 | 93 |
1109189 | 1109189 | 2021-03-11 | Polk | Georgia | 13233 | 5375 | 83 |
1078852 | 1078852 | 2021-03-01 | Atascosa | Texas | 48013 | 5375 | 138 |
1075607 | 1075607 | 2021-02-28 | Atascosa | Texas | 48013 | 5375 | 138 |
1040788 | 1040788 | 2021-02-18 | Fremont | Colorado | 8043 | 5375 | 46 |
1039168 | 1039168 | 2021-02-17 | Steuben | New York | 36101 | 5375 | 137 |
998486 | 998486 | 2021-02-05 | Mississippi | Arkansas | 5093 | 5375 | 110 |
1000908 | 1000908 | 2021-02-05 | Loudon | Tennessee | 47105 | 5375 | 61 |
968469 | 968469 | 2021-01-26 | Roane | Tennessee | 47145 | 5375 | 85 |
959117 | 959117 | 2021-01-23 | Hanover | Virginia | 51085 | 5375 | 95 |
955658 | 955658 | 2021-01-22 | Liberty | Texas | 48291 | 5375 | 120 |
943851 | 943851 | 2021-01-19 | Whiteside | Illinois | 17195 | 5375 | 173 |
892661 | 892661 | 2021-01-03 | Forrest | Mississippi | 28035 | 5375 | 104 |
795682 | 795682 | 2020-12-04 | Chaves | New Mexico | 35005 | 5375 | 48 |
769821 | 769821 | 2020-11-26 | Buncombe | North Carolina | 37021 | 5375 | 136 |
766575 | 766575 | 2020-11-25 | Buncombe | North Carolina | 37021 | 5375 | 136 |
745876 | 745876 | 2020-11-19 | Tazewell | Illinois | 17179 | 5375 | 81 |
705152 | 705152 | 2020-11-06 | Warren | Ohio | 39165 | 5375 | 70 |
697006 | 697006 | 2020-11-04 | Lowndes | Georgia | 13185 | 5375 | 119 |
683648 | 683648 | 2020-10-31 | Coconino | Arizona | 4005 | 5375 | 149 |
483072 | 483072 | 2020-08-30 | Bibb | Georgia | 13021 | 5375 | 119 |
467853 | 467853 | 2020-08-25 | Dakota | Minnesota | 27037 | 5375 | 110 |
436032 | 436032 | 2020-08-15 | Somerset | New Jersey | 34035 | 5375 | 565 |
418223 | 418223 | 2020-08-10 | Navajo | Arizona | 4017 | 5375 | 200 |
357350 | 357350 | 2020-07-22 | Sussex | Delaware | 10005 | 5375 | 179 |
334687 | 334687 | 2020-07-15 | Mobile | Alabama | 1097 | 5375 | 162 |
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);