ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 6051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Missouri 8
- Texas 8
- Ohio 6
- Oregon 6
- Virginia 4
- California 3
- Georgia 3
- New Hampshire 3
- Tennessee 3
- Illinois 2
- Michigan 2
- Mississippi 2
- North Carolina 2
- Pennsylvania 2
- West Virginia 2
- Wisconsin 2
- Arkansas 1
- Connecticut 1
- Florida 1
- Idaho 1
- Maryland 1
- Puerto Rico 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462064 | 2462064 | 2022-05-01 | Nodaway | Missouri | 29147 | 6051 | 44 |
2458808 | 2458808 | 2022-04-30 | Nodaway | Missouri | 29147 | 6051 | 44 |
2455552 | 2455552 | 2022-04-29 | Nodaway | Missouri | 29147 | 6051 | 44 |
2452296 | 2452296 | 2022-04-28 | Nodaway | Missouri | 29147 | 6051 | 44 |
2449040 | 2449040 | 2022-04-27 | Nodaway | Missouri | 29147 | 6051 | 44 |
2445783 | 2445783 | 2022-04-26 | Nodaway | Missouri | 29147 | 6051 | 44 |
2424639 | 2424639 | 2022-04-19 | Vernon | Wisconsin | 55123 | 6051 | 96 |
2377806 | 2377806 | 2022-04-05 | Martin | North Carolina | 37117 | 6051 | 89 |
2374553 | 2374553 | 2022-04-04 | Martin | North Carolina | 37117 | 6051 | 89 |
2375597 | 2375597 | 2022-04-04 | Mecklenburg | Virginia | 51117 | 6051 | 116 |
2347025 | 2347025 | 2022-03-27 | Harris | Georgia | 13145 | 6051 | 110 |
2343772 | 2343772 | 2022-03-26 | Harris | Georgia | 13145 | 6051 | 110 |
2340519 | 2340519 | 2022-03-25 | Harris | Georgia | 13145 | 6051 | 110 |
2327628 | 2327628 | 2022-03-21 | Jerome | Idaho | 16053 | 6051 | 64 |
2313179 | 2313179 | 2022-03-16 | San Sebastian | Puerto Rico | 72131 | 6051 | |
2271246 | 2271246 | 2022-03-03 | Jasper | Texas | 48241 | 6051 | 181 |
2267994 | 2267994 | 2022-03-02 | Jasper | Texas | 48241 | 6051 | 180 |
2251707 | 2251707 | 2022-02-25 | Gray | Texas | 48179 | 6051 | 122 |
2170846 | 2170846 | 2022-01-31 | Wyoming | West Virginia | 54109 | 6051 | 83 |
2087954 | 2087954 | 2022-01-06 | Pulaski | Missouri | 29169 | 6051 | 101 |
2078866 | 2078866 | 2022-01-03 | Malheur | Oregon | 41045 | 6051 | 94 |
2079197 | 2079197 | 2022-01-03 | Macon | Tennessee | 47111 | 6051 | 118 |
2062965 | 2062965 | 2021-12-29 | Scott | Tennessee | 47151 | 6051 | 89 |
1989032 | 1989032 | 2021-12-07 | Union | Arkansas | 5139 | 6051 | 144 |
1991911 | 1991911 | 2021-12-07 | Wise | Virginia | 51195 | 6051 | 132 |
1961831 | 1961831 | 2021-11-28 | Benton | Oregon | 41003 | 6051 | 37 |
1958580 | 1958580 | 2021-11-27 | Benton | Oregon | 41003 | 6051 | 37 |
1955329 | 1955329 | 2021-11-26 | Benton | Oregon | 41003 | 6051 | 37 |
1952078 | 1952078 | 2021-11-25 | Benton | Oregon | 41003 | 6051 | 37 |
1948827 | 1948827 | 2021-11-24 | Benton | Oregon | 41003 | 6051 | 37 |
1944888 | 1944888 | 2021-11-23 | Howell | Missouri | 29091 | 6051 | 167 |
1893130 | 1893130 | 2021-11-07 | Cheshire | New Hampshire | 33005 | 6051 | 51 |
1889880 | 1889880 | 2021-11-06 | Cheshire | New Hampshire | 33005 | 6051 | 51 |
1886630 | 1886630 | 2021-11-05 | Cheshire | New Hampshire | 33005 | 6051 | 51 |
1851194 | 1851194 | 2021-10-25 | Fulton | Ohio | 39051 | 6051 | 96 |
1848990 | 1848990 | 2021-10-24 | Ohio | West Virginia | 54069 | 6051 | 103 |
1831935 | 1831935 | 2021-10-19 | Venango | Pennsylvania | 42121 | 6051 | 130 |
1789441 | 1789441 | 2021-10-06 | Brown | Ohio | 39015 | 6051 | 77 |
1753697 | 1753697 | 2021-09-25 | Ashland | Ohio | 39005 | 6051 | 115 |
1722130 | 1722130 | 2021-09-15 | James City | Virginia | 51095 | 6051 | 85 |
1685556 | 1685556 | 2021-09-04 | Washington | Ohio | 39167 | 6051 | 111 |
1682225 | 1682225 | 2021-09-03 | Athens | Ohio | 39009 | 6051 | 61 |
1602440 | 1602440 | 2021-08-10 | Tehama | California | 6103 | 6051 | 66 |
1465289 | 1465289 | 2021-06-28 | Hardin | Texas | 48199 | 6051 | 114 |
1462044 | 1462044 | 2021-06-27 | Hardin | Texas | 48199 | 6051 | 114 |
1458799 | 1458799 | 2021-06-26 | Hardin | Texas | 48199 | 6051 | 114 |
1452309 | 1452309 | 2021-06-24 | Hardin | Texas | 48199 | 6051 | 114 |
1444318 | 1444318 | 2021-06-22 | St. Mary's | Maryland | 24037 | 6051 | 132 |
1406723 | 1406723 | 2021-06-10 | Lawrence | Tennessee | 47099 | 6051 | 92 |
1318824 | 1318824 | 2021-05-14 | Union | Pennsylvania | 42119 | 6051 | 86 |
1314573 | 1314573 | 2021-05-13 | St. Joseph | Michigan | 26149 | 6051 | 95 |
1196600 | 1196600 | 2021-04-07 | Yuba | California | 6115 | 6051 | 43 |
1173999 | 1173999 | 2021-03-31 | Putnam | Florida | 12107 | 6051 | 135 |
1144132 | 1144132 | 2021-03-21 | Harrisonburg city | Virginia | 51660 | 6051 | 94 |
1132697 | 1132697 | 2021-03-18 | Lapeer | Michigan | 26087 | 6051 | 134 |
1098859 | 1098859 | 2021-03-07 | Calumet | Wisconsin | 55015 | 6051 | 47 |
1090664 | 1090664 | 2021-03-05 | Lowndes | Mississippi | 28087 | 6051 | 140 |
1088677 | 1088677 | 2021-03-04 | Hale | Texas | 48189 | 6051 | 152 |
1075066 | 1075066 | 2021-02-28 | Geauga | Ohio | 39055 | 6051 | 128 |
865504 | 865504 | 2020-12-26 | Sutter | California | 6101 | 6051 | 46 |
856133 | 856133 | 2020-12-23 | Adams | Illinois | 17001 | 6051 | 72 |
781203 | 781203 | 2020-11-30 | New London | Connecticut | 9011 | 6051 | 175 |
707691 | 707691 | 2020-11-07 | Harrison | Mississippi | 28047 | 6051 | 92 |
689211 | 689211 | 2020-11-01 | Anderson | South Carolina | 45007 | 6051 | 209 |
228390 | 228390 | 2020-06-11 | Will | Illinois | 17197 | 6051 | 297 |
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);