ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 7267 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Mississippi 9
- Oklahoma 8
- Tennessee 6
- Indiana 5
- North Carolina 5
- Minnesota 4
- Virgin Islands 4
- Arkansas 3
- Illinois 3
- Massachusetts 3
- Missouri 3
- Texas 3
- Virginia 3
- Georgia 2
- New York 2
- California 1
- Delaware 1
- Maine 1
- Maryland 1
- Michigan 1
- Montana 1
- Oregon 1
- Vermont 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417837 | 2417837 | 2022-04-17 | St. Thomas | Virgin Islands | 78030 | 7267 | 59 |
2414581 | 2414581 | 2022-04-16 | St. Thomas | Virgin Islands | 78030 | 7267 | 59 |
2411325 | 2411325 | 2022-04-15 | St. Thomas | Virgin Islands | 78030 | 7267 | 59 |
2408069 | 2408069 | 2022-04-14 | St. Thomas | Virgin Islands | 78030 | 7267 | 59 |
2372328 | 2372328 | 2022-04-03 | Isle of Wight | Virginia | 51093 | 7267 | 111 |
2369075 | 2369075 | 2022-04-02 | Isle of Wight | Virginia | 51093 | 7267 | 111 |
2365822 | 2365822 | 2022-04-01 | Isle of Wight | Virginia | 51093 | 7267 | 111 |
2345987 | 2345987 | 2022-03-26 | Cooke | Texas | 48097 | 7267 | 131 |
2214674 | 2214674 | 2022-02-14 | Itawamba | Mississippi | 28057 | 7267 | 136 |
2155869 | 2155869 | 2022-01-27 | Somerset | Maine | 23025 | 7267 | 80 |
2152804 | 2152804 | 2022-01-26 | Polk | Minnesota | 27119 | 7267 | 93 |
2054658 | 2054658 | 2021-12-27 | Whitley | Indiana | 18183 | 7267 | 68 |
2032576 | 2032576 | 2021-12-20 | Monroe | Mississippi | 28095 | 7267 | 181 |
2011116 | 2011116 | 2021-12-13 | Kerr | Texas | 48265 | 7267 | 141 |
2006574 | 2006574 | 2021-12-12 | Oktibbeha | Mississippi | 28105 | 7267 | 139 |
2003323 | 2003323 | 2021-12-11 | Oktibbeha | Mississippi | 28105 | 7267 | 139 |
2000073 | 2000073 | 2021-12-10 | Oktibbeha | Mississippi | 28105 | 7267 | 139 |
1938826 | 1938826 | 2021-11-21 | Richmond | North Carolina | 37153 | 7267 | 144 |
1935576 | 1935576 | 2021-11-20 | Richmond | North Carolina | 37153 | 7267 | 144 |
1932326 | 1932326 | 2021-11-19 | Richmond | North Carolina | 37153 | 7267 | 144 |
1921253 | 1921253 | 2021-11-16 | Marion | Illinois | 17121 | 7267 | 154 |
1813995 | 1813995 | 2021-10-14 | Franklin | Illinois | 17055 | 7267 | 125 |
1808200 | 1808200 | 2021-10-12 | Benton | Minnesota | 27009 | 7267 | 104 |
1809087 | 1809087 | 2021-10-12 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1805837 | 1805837 | 2021-10-11 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1806269 | 1806269 | 2021-10-11 | Burnet | Texas | 48053 | 7267 | 112 |
1802587 | 1802587 | 2021-10-10 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1799338 | 1799338 | 2021-10-09 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1796089 | 1796089 | 2021-10-08 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1792840 | 1792840 | 2021-10-07 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1789591 | 1789591 | 2021-10-06 | Stephens | Oklahoma | 40137 | 7267 | 120 |
1747082 | 1747082 | 2021-09-23 | Halifax | North Carolina | 37083 | 7267 | 129 |
1665149 | 1665149 | 2021-08-29 | Berkshire | Massachusetts | 25003 | 7267 | 303 |
1661901 | 1661901 | 2021-08-28 | Berkshire | Massachusetts | 25003 | 7267 | 303 |
1658653 | 1658653 | 2021-08-27 | Berkshire | Massachusetts | 25003 | 7267 | 303 |
1655519 | 1655519 | 2021-08-26 | Crow Wing | Minnesota | 27035 | 7267 | 100 |
1643783 | 1643783 | 2021-08-22 | Roane | Tennessee | 47145 | 7267 | 119 |
1640533 | 1640533 | 2021-08-21 | Roane | Tennessee | 47145 | 7267 | 119 |
1637283 | 1637283 | 2021-08-20 | Roane | Tennessee | 47145 | 7267 | 119 |
1587596 | 1587596 | 2021-08-05 | Lewis and Clark | Montana | 30049 | 7267 | 93 |
1482169 | 1482169 | 2021-07-04 | Crawford | Arkansas | 5033 | 7267 | 120 |
1478922 | 1478922 | 2021-07-03 | Crawford | Arkansas | 5033 | 7267 | 120 |
1475676 | 1475676 | 2021-07-02 | Crawford | Arkansas | 5033 | 7267 | 120 |
1460774 | 1460774 | 2021-06-27 | Lauderdale | Mississippi | 28075 | 7267 | 242 |
1457529 | 1457529 | 2021-06-26 | Lauderdale | Mississippi | 28075 | 7267 | 242 |
1454284 | 1454284 | 2021-06-25 | Lauderdale | Mississippi | 28075 | 7267 | 242 |
1308639 | 1308639 | 2021-05-11 | Ontario | New York | 36069 | 7267 | 92 |
1285918 | 1285918 | 2021-05-04 | Oswego | New York | 36075 | 7267 | 90 |
1277498 | 1277498 | 2021-05-01 | Portage | Wisconsin | 55097 | 7267 | 72 |
1272382 | 1272382 | 2021-04-30 | Blue Earth | Minnesota | 27013 | 7267 | 41 |
1270713 | 1270713 | 2021-04-29 | Chittenden | Vermont | 50007 | 7267 | 101 |
1262760 | 1262760 | 2021-04-27 | Lauderdale | Mississippi | 28075 | 7267 | 240 |
1257425 | 1257425 | 2021-04-25 | Tipton | Tennessee | 47167 | 7267 | 104 |
1252268 | 1252268 | 2021-04-24 | Williamson | Illinois | 17199 | 7267 | 138 |
1254178 | 1254178 | 2021-04-24 | Tipton | Tennessee | 47167 | 7267 | 104 |
1250931 | 1250931 | 2021-04-23 | Tipton | Tennessee | 47167 | 7267 | 104 |
1242556 | 1242556 | 2021-04-21 | Grant | Indiana | 18053 | 7267 | 177 |
1084231 | 1084231 | 2021-03-03 | Cass | Missouri | 29037 | 7267 | 91 |
1037982 | 1037982 | 2021-02-17 | Bartholomew | Indiana | 18005 | 7267 | 151 |
1016729 | 1016729 | 2021-02-10 | Garfield | Oklahoma | 40047 | 7267 | 64 |
971356 | 971356 | 2021-01-27 | Jackson | Oregon | 41029 | 7267 | 98 |
960980 | 960980 | 2021-01-24 | St. Francois | Missouri | 29187 | 7267 | 81 |
940376 | 940376 | 2021-01-18 | Jackson | Georgia | 13157 | 7267 | 88 |
915479 | 915479 | 2021-01-10 | Franklin | Missouri | 29071 | 7267 | 116 |
840018 | 840018 | 2020-12-18 | Clark | Indiana | 18019 | 7267 | 107 |
827072 | 827072 | 2020-12-14 | Madison | Indiana | 18095 | 7267 | 153 |
813563 | 813563 | 2020-12-10 | San Luis Obispo | California | 6079 | 7267 | 45 |
768404 | 768404 | 2020-11-26 | Muscogee | Georgia | 13215 | 7267 | 189 |
622228 | 622228 | 2020-10-12 | Sussex | Delaware | 10005 | 7267 | 211 |
523406 | 523406 | 2020-09-11 | Durham | North Carolina | 37063 | 7267 | 87 |
272527 | 272527 | 2020-06-25 | Baltimore city | Maryland | 24510 | 7267 | 327 |
102224 | 102224 | 2020-04-30 | Oakland | Michigan | 26125 | 7267 | 696 |
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);