ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 6109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Alaska 7
- North Carolina 7
- Oklahoma 7
- Rhode Island 7
- Arkansas 6
- Texas 6
- Indiana 4
- Mississippi 3
- Wisconsin 3
- Colorado 2
- Kansas 2
- Michigan 2
- Tennessee 2
- Virginia 2
- Alabama 1
- Florida 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- Nebraska 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453943 | 2453943 | 2022-04-28 | Vernon | Wisconsin | 55123 | 6109 | 97 |
2441070 | 2441070 | 2022-04-25 | Carroll | Arkansas | 5015 | 6109 | 102 |
2427685 | 2427685 | 2022-04-20 | Mecklenburg | Virginia | 51117 | 6109 | 119 |
2421498 | 2421498 | 2022-04-19 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2421560 | 2421560 | 2022-04-19 | Jackson | Arkansas | 5067 | 6109 | 62 |
2418242 | 2418242 | 2022-04-18 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2414986 | 2414986 | 2022-04-17 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2411730 | 2411730 | 2022-04-16 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2408474 | 2408474 | 2022-04-15 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2405218 | 2405218 | 2022-04-14 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2401963 | 2401963 | 2022-04-13 | Nome Census Area | Alaska | 2180 | 6109 | 5 |
2402141 | 2402141 | 2022-04-13 | Delta | Colorado | 8029 | 6109 | 134 |
2335545 | 2335545 | 2022-03-23 | Transylvania | North Carolina | 37175 | 6109 | 69 |
2150886 | 2150886 | 2022-01-25 | Hale | Texas | 48189 | 6109 | 219 |
2062898 | 2062898 | 2021-12-29 | Carroll | Tennessee | 47017 | 6109 | 127 |
2059015 | 2059015 | 2021-12-28 | Wyoming | New York | 36121 | 6109 | 74 |
2031294 | 2031294 | 2021-12-20 | Unknown | Arkansas | 6109 | 0 | |
2011788 | 2011788 | 2021-12-14 | Union | Arkansas | 5139 | 6109 | 146 |
2011496 | 2011496 | 2021-12-13 | Preston | West Virginia | 54077 | 6109 | 109 |
1997095 | 1997095 | 2021-12-09 | Platte | Nebraska | 31141 | 6109 | 60 |
1946128 | 1946128 | 2021-11-23 | Matagorda | Texas | 48321 | 6109 | 160 |
1927797 | 1927797 | 2021-11-18 | Woodford | Illinois | 17203 | 6109 | 105 |
1918124 | 1918124 | 2021-11-15 | Steuben | Indiana | 18151 | 6109 | 83 |
1881626 | 1881626 | 2021-11-04 | Franklin | Alabama | 1059 | 6109 | 106 |
1779533 | 1779533 | 2021-10-03 | Alexander | North Carolina | 37003 | 6109 | 111 |
1776283 | 1776283 | 2021-10-02 | Alexander | North Carolina | 37003 | 6109 | 111 |
1773033 | 1773033 | 2021-10-01 | Alexander | North Carolina | 37003 | 6109 | 111 |
1765366 | 1765366 | 2021-09-29 | Huntington | Indiana | 18069 | 6109 | 99 |
1655994 | 1655994 | 2021-08-26 | Curry | New Mexico | 35009 | 6109 | 89 |
1625863 | 1625863 | 2021-08-17 | Ford | Kansas | 20057 | 6109 | 82 |
1622616 | 1622616 | 2021-08-16 | Ford | Kansas | 20057 | 6109 | 82 |
1585865 | 1585865 | 2021-08-04 | Barron | Wisconsin | 55005 | 6109 | 86 |
1541664 | 1541664 | 2021-07-22 | Vermilion | Louisiana | 22113 | 6109 | 127 |
1494359 | 1494359 | 2021-07-07 | Lawrence | Tennessee | 47099 | 6109 | 94 |
1491258 | 1491258 | 2021-07-06 | Hardin | Texas | 48199 | 6109 | 116 |
1488011 | 1488011 | 2021-07-05 | Hardin | Texas | 48199 | 6109 | 116 |
1484764 | 1484764 | 2021-07-04 | Hardin | Texas | 48199 | 6109 | 116 |
1481518 | 1481518 | 2021-07-03 | Hardin | Texas | 48199 | 6109 | 116 |
1440120 | 1440120 | 2021-06-21 | Garfield | Colorado | 8045 | 6109 | 46 |
1393120 | 1393120 | 2021-06-06 | Lee | North Carolina | 37105 | 6109 | 81 |
1389875 | 1389875 | 2021-06-05 | Lee | North Carolina | 37105 | 6109 | 81 |
1386630 | 1386630 | 2021-06-04 | Lee | North Carolina | 37105 | 6109 | 81 |
1353555 | 1353555 | 2021-05-25 | Chisago | Minnesota | 27025 | 6109 | 52 |
1331642 | 1331642 | 2021-05-18 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1328395 | 1328395 | 2021-05-17 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1325149 | 1325149 | 2021-05-16 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1321903 | 1321903 | 2021-05-15 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1318657 | 1318657 | 2021-05-14 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1315409 | 1315409 | 2021-05-13 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1312163 | 1312163 | 2021-05-12 | Bryan | Oklahoma | 40013 | 6109 | 72 |
1290667 | 1290667 | 2021-05-06 | Greene | Arkansas | 5055 | 6109 | 76 |
1287421 | 1287421 | 2021-05-05 | Greene | Arkansas | 5055 | 6109 | 75 |
1256264 | 1256264 | 2021-04-25 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1252289 | 1252289 | 2021-04-24 | Dubois | Indiana | 18037 | 6109 | 118 |
1253017 | 1253017 | 2021-04-24 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1249770 | 1249770 | 2021-04-23 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1225941 | 1225941 | 2021-04-16 | Jackson | Florida | 12063 | 6109 | 156 |
1132474 | 1132474 | 2021-03-18 | Laurel | Kentucky | 21125 | 6109 | 46 |
1131322 | 1131322 | 2021-03-17 | Calumet | Wisconsin | 55015 | 6109 | 49 |
1092240 | 1092240 | 2021-03-05 | Rockingham | Virginia | 51165 | 6109 | 95 |
1059187 | 1059187 | 2021-02-23 | Georgetown | South Carolina | 45043 | 6109 | 132 |
1041786 | 1041786 | 2021-02-18 | Eaton | Michigan | 26045 | 6109 | 147 |
934142 | 934142 | 2021-01-16 | Floyd | Indiana | 18043 | 6109 | 110 |
809256 | 809256 | 2020-12-08 | Kent | Rhode Island | 44003 | 6109 | 145 |
806011 | 806011 | 2020-12-07 | Kent | Rhode Island | 44003 | 6109 | 145 |
802766 | 802766 | 2020-12-06 | Kent | Rhode Island | 44003 | 6109 | 145 |
799521 | 799521 | 2020-12-05 | Kent | Rhode Island | 44003 | 6109 | 145 |
796276 | 796276 | 2020-12-04 | Kent | Rhode Island | 44003 | 6109 | 145 |
793031 | 793031 | 2020-12-03 | Kent | Rhode Island | 44003 | 6109 | 145 |
789786 | 789786 | 2020-12-02 | Kent | Rhode Island | 44003 | 6109 | 145 |
640430 | 640430 | 2020-10-17 | Lehigh | Pennsylvania | 42077 | 6109 | 361 |
71307 | 71307 | 2020-04-19 | Oakland | Michigan | 26125 | 6109 | 471 |
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);