ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5515 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 14
- Virginia 6
- Florida 5
- Kentucky 5
- Michigan 5
- Nebraska 4
- Tennessee 4
- Kansas 3
- Missouri 3
- Nevada 3
- New York 3
- Oregon 3
- Texas 3
- Indiana 2
- Ohio 2
- Pennsylvania 2
- South Carolina 2
- Arizona 1
- California 1
- Colorado 1
- Illinois 1
- Iowa 1
- Minnesota 1
- New Mexico 1
- North Carolina 1
- Oklahoma 1
- South Dakota 1
- Utah 1
- Washington 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442391 | 2442391 | 2022-04-25 | Grenada | Mississippi | 28043 | 5515 | 131 |
2439135 | 2439135 | 2022-04-24 | Grenada | Mississippi | 28043 | 5515 | 131 |
2435879 | 2435879 | 2022-04-23 | Grenada | Mississippi | 28043 | 5515 | 131 |
2432623 | 2432623 | 2022-04-22 | Grenada | Mississippi | 28043 | 5515 | 131 |
2429367 | 2429367 | 2022-04-21 | Grenada | Mississippi | 28043 | 5515 | 131 |
2426111 | 2426111 | 2022-04-20 | Grenada | Mississippi | 28043 | 5515 | 131 |
2422855 | 2422855 | 2022-04-19 | Grenada | Mississippi | 28043 | 5515 | 131 |
2419599 | 2419599 | 2022-04-18 | Grenada | Mississippi | 28043 | 5515 | 131 |
2416343 | 2416343 | 2022-04-17 | Grenada | Mississippi | 28043 | 5515 | 131 |
2413087 | 2413087 | 2022-04-16 | Grenada | Mississippi | 28043 | 5515 | 131 |
2409831 | 2409831 | 2022-04-15 | Grenada | Mississippi | 28043 | 5515 | 131 |
2406575 | 2406575 | 2022-04-14 | Grenada | Mississippi | 28043 | 5515 | 131 |
2403319 | 2403319 | 2022-04-13 | Grenada | Mississippi | 28043 | 5515 | 131 |
2400065 | 2400065 | 2022-04-12 | Grenada | Mississippi | 28043 | 5515 | 131 |
2375711 | 2375711 | 2022-04-04 | Lincoln | West Virginia | 54043 | 5515 | 78 |
2191996 | 2191996 | 2022-02-07 | Henry | Missouri | 29083 | 5515 | 74 |
2180444 | 2180444 | 2022-02-03 | Lee | Virginia | 51105 | 5515 | 75 |
2175300 | 2175300 | 2022-02-02 | Russell | Kentucky | 21207 | 5515 | 73 |
2142954 | 2142954 | 2022-01-23 | Mason | Michigan | 26105 | 5515 | 76 |
2139699 | 2139699 | 2022-01-22 | Mason | Michigan | 26105 | 5515 | 76 |
2136443 | 2136443 | 2022-01-21 | Mason | Michigan | 26105 | 5515 | 76 |
2035916 | 2035916 | 2021-12-21 | Lafayette | Missouri | 29107 | 5515 | 91 |
1997823 | 1997823 | 2021-12-09 | Brookings | South Dakota | 46011 | 5515 | 41 |
1988339 | 1988339 | 2021-12-06 | Hopkins | Texas | 48223 | 5515 | 146 |
1981006 | 1981006 | 2021-12-04 | Wyoming | New York | 36121 | 5515 | 69 |
1972517 | 1972517 | 2021-12-01 | Clark | Wisconsin | 55019 | 5515 | 87 |
1962552 | 1962552 | 2021-11-28 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1959301 | 1959301 | 2021-11-27 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1956050 | 1956050 | 2021-11-26 | Charlottesville city | Virginia | 51540 | 5515 | 62 |
1945640 | 1945640 | 2021-11-23 | Greene | Pennsylvania | 42059 | 5515 | 65 |
1937804 | 1937804 | 2021-11-21 | Montgomery | Kansas | 20125 | 5515 | 120 |
1934554 | 1934554 | 2021-11-20 | Montgomery | Kansas | 20125 | 5515 | 120 |
1931303 | 1931303 | 2021-11-19 | Montgomery | Kansas | 20125 | 5515 | 120 |
1852545 | 1852545 | 2021-10-26 | Amador | California | 6005 | 5515 | 64 |
1838672 | 1838672 | 2021-10-21 | Hardin | Tennessee | 47071 | 5515 | 81 |
1825363 | 1825363 | 2021-10-17 | Malheur | Oregon | 41045 | 5515 | 74 |
1822114 | 1822114 | 2021-10-16 | Malheur | Oregon | 41045 | 5515 | 74 |
1818865 | 1818865 | 2021-10-15 | Malheur | Oregon | 41045 | 5515 | 74 |
1788089 | 1788089 | 2021-10-06 | Clinton | Indiana | 18023 | 5515 | 74 |
1778633 | 1778633 | 2021-10-03 | Bell | Kentucky | 21013 | 5515 | 88 |
1775383 | 1775383 | 2021-10-02 | Bell | Kentucky | 21013 | 5515 | 88 |
1772133 | 1772133 | 2021-10-01 | Bell | Kentucky | 21013 | 5515 | 88 |
1756630 | 1756630 | 2021-09-26 | Scotts Bluff | Nebraska | 31157 | 5515 | 96 |
1756753 | 1756753 | 2021-09-26 | Madison | New York | 36053 | 5515 | 99 |
1753382 | 1753382 | 2021-09-25 | Scotts Bluff | Nebraska | 31157 | 5515 | 96 |
1750134 | 1750134 | 2021-09-24 | Scotts Bluff | Nebraska | 31157 | 5515 | 96 |
1714780 | 1714780 | 2021-09-13 | Shelby | Ohio | 39149 | 5515 | 98 |
1670156 | 1670156 | 2021-08-30 | James City | Virginia | 51095 | 5515 | 78 |
1647932 | 1647932 | 2021-08-24 | Broomfield | Colorado | 8014 | 5515 | 77 |
1649746 | 1649746 | 2021-08-24 | Athens | Ohio | 39009 | 5515 | 60 |
1630972 | 1630972 | 2021-08-18 | Medina | Texas | 48325 | 5515 | 118 |
1627246 | 1627246 | 2021-08-17 | Mifflin | Pennsylvania | 42087 | 5515 | 183 |
1588512 | 1588512 | 2021-08-05 | Franklin | Tennessee | 47051 | 5515 | 92 |
1538816 | 1538816 | 2021-07-21 | Pettis | Missouri | 29159 | 5515 | 78 |
1515612 | 1515612 | 2021-07-14 | Scott | Kentucky | 21209 | 5515 | 36 |
1398469 | 1398469 | 2021-06-08 | Cerro Gordo | Iowa | 19033 | 5515 | 90 |
1327918 | 1327918 | 2021-05-17 | Buffalo | Nebraska | 31019 | 5515 | 57 |
1293615 | 1293615 | 2021-05-06 | Skagit | Washington | 53057 | 5515 | 67 |
1290181 | 1290181 | 2021-05-05 | Summit | Utah | 49043 | 5515 | 12 |
1285295 | 1285295 | 2021-05-04 | Chippewa | Michigan | 26033 | 5515 | 48 |
1241196 | 1241196 | 2021-04-20 | Warren | Tennessee | 47177 | 5515 | 81 |
1231764 | 1231764 | 2021-04-17 | Albemarle | Virginia | 51003 | 5515 | 82 |
1226907 | 1226907 | 2021-04-16 | Shiawassee | Michigan | 26155 | 5515 | 90 |
1202953 | 1202953 | 2021-04-09 | Graham | Arizona | 4009 | 5515 | 77 |
1147984 | 1147984 | 2021-03-23 | Gadsden | Florida | 12039 | 5515 | 89 |
1131751 | 1131751 | 2021-03-18 | Gadsden | Florida | 12039 | 5515 | 91 |
1089925 | 1089925 | 2021-03-05 | Dearborn | Indiana | 18029 | 5515 | 72 |
1032664 | 1032664 | 2021-02-15 | Ontario | New York | 36069 | 5515 | 88 |
1026466 | 1026466 | 2021-02-13 | Grady | Oklahoma | 40051 | 5515 | 66 |
1021662 | 1021662 | 2021-02-12 | Clinton | Illinois | 17027 | 5515 | 97 |
1014924 | 1014924 | 2021-02-10 | Monroe | Florida | 12087 | 5515 | 42 |
1007406 | 1007406 | 2021-02-07 | McMinn | Tennessee | 47107 | 5515 | 84 |
987781 | 987781 | 2021-02-01 | Georgetown | South Carolina | 45043 | 5515 | 126 |
944916 | 944916 | 2021-01-19 | Carson City | Nevada | 32510 | 5515 | 91 |
941671 | 941671 | 2021-01-18 | Carson City | Nevada | 32510 | 5515 | 91 |
938426 | 938426 | 2021-01-17 | Carson City | Nevada | 32510 | 5515 | 91 |
931533 | 931533 | 2021-01-15 | Kandiyohi | Minnesota | 27067 | 5515 | 71 |
917581 | 917581 | 2021-01-11 | Walton | Florida | 12131 | 5515 | 57 |
842162 | 842162 | 2020-12-18 | Victoria | Texas | 48469 | 5515 | 111 |
766497 | 766497 | 2020-11-25 | San Juan | New Mexico | 35045 | 5515 | 225 |
588664 | 588664 | 2020-10-01 | Berkeley | South Carolina | 45015 | 5515 | 89 |
578452 | 578452 | 2020-09-28 | Cumberland | North Carolina | 37051 | 5515 | 76 |
444272 | 444272 | 2020-08-18 | Leon | Florida | 12073 | 5515 | 27 |
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);