ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 5009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 19
- Tennessee 11
- South Carolina 9
- Georgia 7
- Ohio 7
- Virginia 7
- Mississippi 6
- Kentucky 5
- Indiana 4
- Oregon 4
- Minnesota 3
- Nebraska 3
- North Carolina 3
- Washington 3
- Wisconsin 3
- Alabama 2
- California 2
- Florida 2
- Illinois 2
- Missouri 2
- New York 2
- Oklahoma 2
- Pennsylvania 2
- Puerto Rico 2
- Arkansas 1
- Iowa 1
- Louisiana 1
- New Mexico 1
- North Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453377 | 2453377 | 2022-04-28 | Burleson | Texas | 48051 | 5009 | 66 |
2450121 | 2450121 | 2022-04-27 | Burleson | Texas | 48051 | 5009 | 66 |
2446864 | 2446864 | 2022-04-26 | Burleson | Texas | 48051 | 5009 | 66 |
2443609 | 2443609 | 2022-04-25 | Burleson | Texas | 48051 | 5009 | 66 |
2440353 | 2440353 | 2022-04-24 | Burleson | Texas | 48051 | 5009 | 66 |
2437097 | 2437097 | 2022-04-23 | Burleson | Texas | 48051 | 5009 | 66 |
2433841 | 2433841 | 2022-04-22 | Burleson | Texas | 48051 | 5009 | 66 |
2430585 | 2430585 | 2022-04-21 | Burleson | Texas | 48051 | 5009 | 66 |
2427329 | 2427329 | 2022-04-20 | Burleson | Texas | 48051 | 5009 | 66 |
2424073 | 2424073 | 2022-04-19 | Burleson | Texas | 48051 | 5009 | 66 |
2420608 | 2420608 | 2022-04-18 | Hampton | South Carolina | 45049 | 5009 | 85 |
2420817 | 2420817 | 2022-04-18 | Burleson | Texas | 48051 | 5009 | 66 |
2417352 | 2417352 | 2022-04-17 | Hampton | South Carolina | 45049 | 5009 | 85 |
2417561 | 2417561 | 2022-04-17 | Burleson | Texas | 48051 | 5009 | 66 |
2414096 | 2414096 | 2022-04-16 | Hampton | South Carolina | 45049 | 5009 | 85 |
2414305 | 2414305 | 2022-04-16 | Burleson | Texas | 48051 | 5009 | 66 |
2410840 | 2410840 | 2022-04-15 | Hampton | South Carolina | 45049 | 5009 | 85 |
2411049 | 2411049 | 2022-04-15 | Burleson | Texas | 48051 | 5009 | 66 |
2407584 | 2407584 | 2022-04-14 | Hampton | South Carolina | 45049 | 5009 | 85 |
2407793 | 2407793 | 2022-04-14 | Burleson | Texas | 48051 | 5009 | 66 |
2408168 | 2408168 | 2022-04-14 | Prince Edward | Virginia | 51147 | 5009 | 69 |
2404328 | 2404328 | 2022-04-13 | Hampton | South Carolina | 45049 | 5009 | 85 |
2404537 | 2404537 | 2022-04-13 | Burleson | Texas | 48051 | 5009 | 66 |
2401073 | 2401073 | 2022-04-12 | Hampton | South Carolina | 45049 | 5009 | 85 |
2377733 | 2377733 | 2022-04-05 | Schoharie | New York | 36095 | 5009 | 35 |
2326054 | 2326054 | 2022-03-20 | Union | Oregon | 41061 | 5009 | 74 |
2322801 | 2322801 | 2022-03-19 | Union | Oregon | 41061 | 5009 | 74 |
2319547 | 2319547 | 2022-03-18 | Union | Oregon | 41061 | 5009 | 74 |
2316293 | 2316293 | 2022-03-17 | Union | Oregon | 41061 | 5009 | 74 |
2308200 | 2308200 | 2022-03-15 | Pike | Illinois | 17149 | 5009 | 68 |
2259218 | 2259218 | 2022-02-28 | Jones | Georgia | 13169 | 5009 | 105 |
2248072 | 2248072 | 2022-02-24 | Wyoming | Pennsylvania | 42131 | 5009 | 100 |
2239725 | 2239725 | 2022-02-22 | McDuffie | Georgia | 13189 | 5009 | 93 |
2236139 | 2236139 | 2022-02-21 | Logan | Arkansas | 5083 | 5009 | 66 |
2214366 | 2214366 | 2022-02-14 | Concordia | Louisiana | 22029 | 5009 | 88 |
2192559 | 2192559 | 2022-02-07 | Holmes | Ohio | 39075 | 5009 | 172 |
2190168 | 2190168 | 2022-02-06 | Dinwiddie | Virginia | 51053 | 5009 | 64 |
2186915 | 2186915 | 2022-02-05 | Dinwiddie | Virginia | 51053 | 5009 | 64 |
2183662 | 2183662 | 2022-02-04 | Dinwiddie | Virginia | 51053 | 5009 | 64 |
2173564 | 2173564 | 2022-02-01 | Wayne | Tennessee | 47181 | 5009 | 52 |
2170312 | 2170312 | 2022-01-31 | Wayne | Tennessee | 47181 | 5009 | 52 |
2167058 | 2167058 | 2022-01-30 | Wayne | Tennessee | 47181 | 5009 | 52 |
2163803 | 2163803 | 2022-01-29 | Wayne | Tennessee | 47181 | 5009 | 52 |
2160548 | 2160548 | 2022-01-28 | Wayne | Tennessee | 47181 | 5009 | 52 |
2157292 | 2157292 | 2022-01-27 | Wayne | Tennessee | 47181 | 5009 | 52 |
2154039 | 2154039 | 2022-01-26 | Wayne | Tennessee | 47181 | 5009 | 52 |
2154185 | 2154185 | 2022-01-26 | Lampasas | Texas | 48281 | 5009 | 74 |
2146986 | 2146986 | 2022-01-24 | Carroll | Ohio | 39019 | 5009 | 101 |
2137520 | 2137520 | 2022-01-21 | Juana Diaz | Puerto Rico | 72075 | 5009 | |
2128493 | 2128493 | 2022-01-18 | Boone | West Virginia | 54005 | 5009 | 62 |
2123591 | 2123591 | 2022-01-17 | Leake | Mississippi | 28079 | 5009 | 92 |
2120339 | 2120339 | 2022-01-16 | Leake | Mississippi | 28079 | 5009 | 92 |
2117087 | 2117087 | 2022-01-15 | Leake | Mississippi | 28079 | 5009 | 92 |
2113836 | 2113836 | 2022-01-14 | Leake | Mississippi | 28079 | 5009 | 92 |
2103128 | 2103128 | 2022-01-11 | Peach | Georgia | 13225 | 5009 | 115 |
2079877 | 2079877 | 2022-01-04 | Clarke | Alabama | 1025 | 5009 | 88 |
2060399 | 2060399 | 2021-12-29 | Lawrence | Alabama | 1079 | 5009 | 136 |
2057562 | 2057562 | 2021-12-28 | Gilmer | Georgia | 13123 | 5009 | 142 |
2015092 | 2015092 | 2021-12-15 | Siskiyou | California | 6093 | 5009 | 75 |
2005589 | 2005589 | 2021-12-12 | Lumpkin | Georgia | 13187 | 5009 | 110 |
2002338 | 2002338 | 2021-12-11 | Lumpkin | Georgia | 13187 | 5009 | 110 |
1999088 | 1999088 | 2021-12-10 | Lumpkin | Georgia | 13187 | 5009 | 110 |
1986209 | 1986209 | 2021-12-06 | Bureau | Illinois | 17011 | 5009 | 112 |
1875804 | 1875804 | 2021-11-02 | Adams | Indiana | 18001 | 5009 | 79 |
1878177 | 1878177 | 2021-11-02 | Kittitas | Washington | 53037 | 5009 | 56 |
1837965 | 1837965 | 2021-10-21 | Columbia | New York | 36021 | 5009 | 111 |
1816368 | 1816368 | 2021-10-14 | Manassas city | Virginia | 51683 | 5009 | 51 |
1785143 | 1785143 | 2021-10-05 | Calloway | Kentucky | 21035 | 5009 | 60 |
1757598 | 1757598 | 2021-09-26 | Grimes | Texas | 48185 | 5009 | 97 |
1754350 | 1754350 | 2021-09-25 | Grimes | Texas | 48185 | 5009 | 97 |
1733539 | 1733539 | 2021-09-19 | Steele | Minnesota | 27147 | 5009 | 21 |
1730289 | 1730289 | 2021-09-18 | Steele | Minnesota | 27147 | 5009 | 21 |
1727039 | 1727039 | 2021-09-17 | Steele | Minnesota | 27147 | 5009 | 21 |
1714741 | 1714741 | 2021-09-13 | Highland | Ohio | 39071 | 5009 | 75 |
1699445 | 1699445 | 2021-09-08 | Shenandoah | Virginia | 51171 | 5009 | 137 |
1682548 | 1682548 | 2021-09-03 | Ponce | Puerto Rico | 72113 | 5009 | |
1641921 | 1641921 | 2021-08-22 | Huntington | Indiana | 18069 | 5009 | 86 |
1638671 | 1638671 | 2021-08-21 | Huntington | Indiana | 18069 | 5009 | 86 |
1635421 | 1635421 | 2021-08-20 | Huntington | Indiana | 18069 | 5009 | 86 |
1634635 | 1634635 | 2021-08-19 | Polk | Wisconsin | 55095 | 5009 | 68 |
1623827 | 1623827 | 2021-08-16 | Shelby | Ohio | 39149 | 5009 | 98 |
1577676 | 1577676 | 2021-08-02 | Oktibbeha | Mississippi | 28105 | 5009 | 98 |
1554943 | 1554943 | 2021-07-26 | Pearl River | Mississippi | 28109 | 5009 | 150 |
1551923 | 1551923 | 2021-07-25 | Dodge | Nebraska | 31053 | 5009 | 83 |
1548676 | 1548676 | 2021-07-24 | Dodge | Nebraska | 31053 | 5009 | 83 |
1545429 | 1545429 | 2021-07-23 | Dodge | Nebraska | 31053 | 5009 | 83 |
1488456 | 1488456 | 2021-07-05 | Douglas | Wisconsin | 55031 | 5009 | 64 |
1440942 | 1440942 | 2021-06-21 | Nelson | Kentucky | 21179 | 5009 | 61 |
1437695 | 1437695 | 2021-06-20 | Nelson | Kentucky | 21179 | 5009 | 61 |
1434448 | 1434448 | 2021-06-19 | Nelson | Kentucky | 21179 | 5009 | 61 |
1431202 | 1431202 | 2021-06-18 | Nelson | Kentucky | 21179 | 5009 | 61 |
1195253 | 1195253 | 2021-04-06 | Washington | Ohio | 39167 | 5009 | 105 |
1192142 | 1192142 | 2021-04-05 | Columbia | Pennsylvania | 42037 | 5009 | 128 |
1189164 | 1189164 | 2021-04-04 | Franklin | Tennessee | 47051 | 5009 | 87 |
1185917 | 1185917 | 2021-04-03 | Franklin | Tennessee | 47051 | 5009 | 87 |
1182670 | 1182670 | 2021-04-02 | Franklin | Tennessee | 47051 | 5009 | 87 |
1179423 | 1179423 | 2021-04-01 | Franklin | Tennessee | 47051 | 5009 | 87 |
1172410 | 1172410 | 2021-03-30 | Morton | North Dakota | 38059 | 5009 | 98 |
1152853 | 1152853 | 2021-03-24 | McDowell | North Carolina | 37111 | 5009 | 62 |
1142039 | 1142039 | 2021-03-21 | Webster | Iowa | 19187 | 5009 | 88 |
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);