ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 5647 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 10
- South Dakota 7
- Minnesota 6
- Tennessee 6
- Virginia 5
- Kentucky 4
- North Carolina 4
- Puerto Rico 4
- Indiana 3
- Kansas 3
- Texas 3
- Vermont 3
- Wisconsin 3
- Arkansas 2
- Colorado 2
- Illinois 2
- Louisiana 2
- Missouri 2
- Nebraska 2
- New York 2
- Washington 2
- Georgia 1
- Idaho 1
- Iowa 1
- Maine 1
- Maryland 1
- New Hampshire 1
- New Mexico 1
- North Dakota 1
- Ohio 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492827 | 2492827 | 2022-05-10 | Page | Virginia | 51139 | 5647 | 121 |
2485646 | 2485646 | 2022-05-08 | Coamo | Puerto Rico | 72043 | 5647 | |
2482388 | 2482388 | 2022-05-07 | Coamo | Puerto Rico | 72043 | 5647 | |
2442361 | 2442361 | 2022-04-25 | Wabasha | Minnesota | 27157 | 5647 | 16 |
2385393 | 2385393 | 2022-04-07 | Salem city | Virginia | 51775 | 5647 | 96 |
2372250 | 2372250 | 2022-04-03 | Caledonia | Vermont | 50005 | 5647 | 24 |
2368997 | 2368997 | 2022-04-02 | Caledonia | Vermont | 50005 | 5647 | 24 |
2365744 | 2365744 | 2022-04-01 | Caledonia | Vermont | 50005 | 5647 | 24 |
2347910 | 2347910 | 2022-03-27 | Dodge | Minnesota | 27039 | 5647 | 21 |
2344657 | 2344657 | 2022-03-26 | Dodge | Minnesota | 27039 | 5647 | 21 |
2341404 | 2341404 | 2022-03-25 | Dodge | Minnesota | 27039 | 5647 | 21 |
2280642 | 2280642 | 2022-03-06 | Moca | Puerto Rico | 72099 | 5647 | |
2276219 | 2276219 | 2022-03-05 | Garrett | Maryland | 24023 | 5647 | 114 |
2261399 | 2261399 | 2022-02-28 | Calhoun | Texas | 48057 | 5647 | 46 |
2235108 | 2235108 | 2022-02-20 | Juana Diaz | Puerto Rico | 72075 | 5647 | |
2213685 | 2213685 | 2022-02-14 | Grady | Georgia | 13131 | 5647 | 103 |
2214289 | 2214289 | 2022-02-14 | Johnson | Kentucky | 21115 | 5647 | 86 |
2211871 | 2211871 | 2022-02-13 | Seneca | New York | 36099 | 5647 | 89 |
2194854 | 2194854 | 2022-02-08 | Grant | Louisiana | 22043 | 5647 | 84 |
2178608 | 2178608 | 2022-02-03 | Pointe Coupee | Louisiana | 22077 | 5647 | 86 |
2167624 | 2167624 | 2022-01-30 | Kewaunee | Wisconsin | 55061 | 5647 | 53 |
2164369 | 2164369 | 2022-01-29 | Kewaunee | Wisconsin | 55061 | 5647 | 53 |
2161114 | 2161114 | 2022-01-28 | Kewaunee | Wisconsin | 55061 | 5647 | 53 |
2055241 | 2055241 | 2021-12-27 | Nicollet | Minnesota | 27103 | 5647 | 61 |
2016650 | 2016650 | 2021-12-15 | Sullivan | New Hampshire | 33019 | 5647 | 43 |
2007676 | 2007676 | 2021-12-12 | Henry | Tennessee | 47079 | 5647 | 96 |
2004425 | 2004425 | 2021-12-11 | Henry | Tennessee | 47079 | 5647 | 96 |
2001174 | 2001174 | 2021-12-10 | Henry | Tennessee | 47079 | 5647 | 96 |
1972784 | 1972784 | 2021-12-02 | Unknown | Arkansas | 5647 | 0 | |
1958422 | 1958422 | 2021-11-27 | Champaign | Ohio | 39021 | 5647 | 86 |
1915046 | 1915046 | 2021-11-14 | Lyon | Kansas | 20111 | 5647 | 93 |
1911796 | 1911796 | 2021-11-13 | Lyon | Kansas | 20111 | 5647 | 93 |
1908547 | 1908547 | 2021-11-12 | Lyon | Kansas | 20111 | 5647 | 93 |
1902291 | 1902291 | 2021-11-10 | Oxford | Maine | 23017 | 5647 | 86 |
1858066 | 1858066 | 2021-10-27 | Williamsburg | South Carolina | 45089 | 5647 | 126 |
1808269 | 1808269 | 2021-10-12 | Steele | Minnesota | 27147 | 5647 | 25 |
1771009 | 1771009 | 2021-09-30 | Ohio | West Virginia | 54069 | 5647 | 95 |
1758311 | 1758311 | 2021-09-27 | Unknown | Arkansas | 5647 | 0 | |
1759711 | 1759711 | 2021-09-27 | Platte | Missouri | 29165 | 5647 | 58 |
1740845 | 1740845 | 2021-09-21 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1737596 | 1737596 | 2021-09-20 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1734346 | 1734346 | 2021-09-19 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1731096 | 1731096 | 2021-09-18 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1727846 | 1727846 | 2021-09-17 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1724597 | 1724597 | 2021-09-16 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1725375 | 1725375 | 2021-09-16 | Henry | Virginia | 51089 | 5647 | 135 |
1721348 | 1721348 | 2021-09-15 | Ottawa | Oklahoma | 40115 | 5647 | 86 |
1691488 | 1691488 | 2021-09-06 | Phelps | Missouri | 29161 | 5647 | 165 |
1673381 | 1673381 | 2021-08-31 | Fauquier | Virginia | 51061 | 5647 | 72 |
1664925 | 1664925 | 2021-08-29 | Barren | Kentucky | 21009 | 5647 | 109 |
1665954 | 1665954 | 2021-08-29 | Morton | North Dakota | 38059 | 5647 | 102 |
1661677 | 1661677 | 2021-08-28 | Barren | Kentucky | 21009 | 5647 | 109 |
1658429 | 1658429 | 2021-08-27 | Barren | Kentucky | 21009 | 5647 | 109 |
1559339 | 1559339 | 2021-07-27 | Warren | Tennessee | 47177 | 5647 | 85 |
1535966 | 1535966 | 2021-07-20 | Pender | North Carolina | 37141 | 5647 | 69 |
1536459 | 1536459 | 2021-07-20 | Brown | South Dakota | 46013 | 5647 | 95 |
1533211 | 1533211 | 2021-07-19 | Brown | South Dakota | 46013 | 5647 | 95 |
1529964 | 1529964 | 2021-07-18 | Brown | South Dakota | 46013 | 5647 | 95 |
1526717 | 1526717 | 2021-07-17 | Brown | South Dakota | 46013 | 5647 | 95 |
1523470 | 1523470 | 2021-07-16 | Brown | South Dakota | 46013 | 5647 | 95 |
1520222 | 1520222 | 2021-07-15 | Brown | South Dakota | 46013 | 5647 | 95 |
1516974 | 1516974 | 2021-07-14 | Brown | South Dakota | 46013 | 5647 | 95 |
1475201 | 1475201 | 2021-07-01 | Summit | Utah | 49043 | 5647 | 14 |
1440500 | 1440500 | 2021-06-21 | Knox | Illinois | 17095 | 5647 | 185 |
1376883 | 1376883 | 2021-06-01 | Halifax | North Carolina | 37083 | 5647 | 112 |
1270525 | 1270525 | 2021-04-29 | Hardin | Texas | 48199 | 5647 | 110 |
1267278 | 1267278 | 2021-04-28 | Hardin | Texas | 48199 | 5647 | 110 |
1258948 | 1258948 | 2021-04-26 | Warren | Iowa | 19181 | 5647 | 87 |
1203572 | 1203572 | 2021-04-09 | Dearborn | Indiana | 18029 | 5647 | 77 |
1197068 | 1197068 | 2021-04-07 | Cass | Indiana | 18017 | 5647 | 103 |
1185215 | 1185215 | 2021-04-03 | Cayuga | New York | 36011 | 5647 | 90 |
1173890 | 1173890 | 2021-03-31 | Fremont | Colorado | 8043 | 5647 | 53 |
1172334 | 1172334 | 2021-03-30 | Lenoir | North Carolina | 37107 | 5647 | 109 |
1145010 | 1145010 | 2021-03-22 | Clinton | Illinois | 17027 | 5647 | 98 |
1141924 | 1141924 | 2021-03-21 | Shelby | Indiana | 18145 | 5647 | 103 |
1081643 | 1081643 | 2021-03-02 | Grady | Oklahoma | 40051 | 5647 | 77 |
1078397 | 1078397 | 2021-03-01 | Grady | Oklahoma | 40051 | 5647 | 76 |
1075152 | 1075152 | 2021-02-28 | Grady | Oklahoma | 40051 | 5647 | 73 |
1053334 | 1053334 | 2021-02-21 | Kitsap | Washington | 53035 | 5647 | 84 |
1050087 | 1050087 | 2021-02-20 | Kitsap | Washington | 53035 | 5647 | 84 |
1013840 | 1013840 | 2021-02-09 | Bedford | Tennessee | 47003 | 5647 | 112 |
1006822 | 1006822 | 2021-02-07 | Wilkes | North Carolina | 37193 | 5647 | 92 |
934007 | 934007 | 2021-01-16 | Madison | Idaho | 16065 | 5647 | 21 |
853996 | 853996 | 2020-12-22 | Hall | Nebraska | 31079 | 5647 | 89 |
850751 | 850751 | 2020-12-21 | Hall | Nebraska | 31079 | 5647 | 89 |
754275 | 754275 | 2020-11-21 | Putnam | Tennessee | 47141 | 5647 | 75 |
747016 | 747016 | 2020-11-19 | McKinley | New Mexico | 35031 | 5647 | 270 |
456574 | 456574 | 2020-08-21 | Loudoun | Virginia | 51107 | 5647 | 115 |
325317 | 325317 | 2020-07-12 | Arapahoe | Colorado | 8005 | 5647 | 349 |
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);