ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 4309 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Mississippi 13
- Michigan 9
- Tennessee 9
- Virginia 9
- Illinois 8
- Georgia 7
- North Carolina 6
- Arkansas 5
- Ohio 5
- Colorado 4
- Oregon 4
- Texas 4
- Indiana 3
- Kentucky 3
- New Hampshire 3
- New York 3
- Alabama 2
- California 2
- Florida 2
- Idaho 2
- Iowa 2
- Louisiana 2
- Minnesota 2
- Missouri 2
- Pennsylvania 2
- Washington 2
- West Virginia 2
- Maine 1
- New Jersey 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493349 | 2493349 | 2022-05-11 | Otero | Colorado | 8089 | 4309 | 130 |
2490091 | 2490091 | 2022-05-10 | Otero | Colorado | 8089 | 4309 | 130 |
2486834 | 2486834 | 2022-05-09 | Otero | Colorado | 8089 | 4309 | 130 |
2391275 | 2391275 | 2022-04-09 | Yabucoa | Puerto Rico | 72151 | 4309 | |
2373836 | 2373836 | 2022-04-04 | Antrim | Michigan | 26009 | 4309 | 64 |
2370583 | 2370583 | 2022-04-03 | Antrim | Michigan | 26009 | 4309 | 64 |
2367330 | 2367330 | 2022-04-02 | Antrim | Michigan | 26009 | 4309 | 64 |
2364077 | 2364077 | 2022-04-01 | Antrim | Michigan | 26009 | 4309 | 64 |
2360777 | 2360777 | 2022-03-31 | Washington | Maine | 23029 | 4309 | 52 |
2350436 | 2350436 | 2022-03-28 | De Witt | Illinois | 17039 | 4309 | 44 |
2239913 | 2239913 | 2022-02-22 | Piatt | Illinois | 17147 | 4309 | 27 |
2198406 | 2198406 | 2022-02-09 | Holmes | Mississippi | 28051 | 4309 | 101 |
2196328 | 2196328 | 2022-02-08 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2193074 | 2193074 | 2022-02-07 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2189820 | 2189820 | 2022-02-06 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2186567 | 2186567 | 2022-02-05 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2183315 | 2183315 | 2022-02-04 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2183800 | 2183800 | 2022-02-04 | Barbour | West Virginia | 54001 | 4309 | 63 |
2180063 | 2180063 | 2022-02-03 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2176812 | 2176812 | 2022-02-02 | Unicoi | Tennessee | 47171 | 4309 | 86 |
2171449 | 2171449 | 2022-02-01 | Putnam | Georgia | 13237 | 4309 | 92 |
2171983 | 2171983 | 2022-02-01 | Garrard | Kentucky | 21079 | 4309 | 64 |
2147213 | 2147213 | 2022-01-24 | Juniata | Pennsylvania | 42067 | 4309 | 159 |
2129266 | 2129266 | 2022-01-19 | Edgar | Illinois | 17045 | 4309 | 75 |
2129323 | 2129323 | 2022-01-19 | Richland | Illinois | 17159 | 4309 | 77 |
2122610 | 2122610 | 2022-01-17 | Jones | Georgia | 13169 | 4309 | 99 |
2070234 | 2070234 | 2022-01-01 | Cleburne | Arkansas | 5023 | 4309 | 101 |
2056838 | 2056838 | 2021-12-27 | Gloucester | Virginia | 51073 | 4309 | 83 |
2028457 | 2028457 | 2021-12-19 | Payette | Idaho | 16075 | 4309 | 72 |
2025206 | 2025206 | 2021-12-18 | Payette | Idaho | 16075 | 4309 | 72 |
2019610 | 2019610 | 2021-12-16 | Audrain | Missouri | 29007 | 4309 | 81 |
2010603 | 2010603 | 2021-12-13 | Jefferson | Oregon | 41031 | 4309 | 69 |
1922025 | 1922025 | 2021-11-16 | Covington | Mississippi | 28031 | 4309 | 95 |
1899277 | 1899277 | 2021-11-09 | Covington | Mississippi | 28031 | 4309 | 95 |
1892777 | 1892777 | 2021-11-07 | Covington | Mississippi | 28031 | 4309 | 95 |
1889527 | 1889527 | 2021-11-06 | Covington | Mississippi | 28031 | 4309 | 95 |
1886277 | 1886277 | 2021-11-05 | Covington | Mississippi | 28031 | 4309 | 95 |
1883028 | 1883028 | 2021-11-04 | Covington | Mississippi | 28031 | 4309 | 95 |
1855117 | 1855117 | 2021-10-26 | Kleberg | Texas | 48273 | 4309 | 126 |
1839396 | 1839396 | 2021-10-22 | Lawrence | Alabama | 1079 | 4309 | 117 |
1818518 | 1818518 | 2021-10-15 | Wyoming | New York | 36121 | 4309 | 57 |
1761611 | 1761611 | 2021-09-28 | Siskiyou | California | 6093 | 4309 | 51 |
1744964 | 1744964 | 2021-09-22 | Kittitas | Washington | 53037 | 4309 | 47 |
1740121 | 1740121 | 2021-09-21 | Tate | Mississippi | 28137 | 4309 | 101 |
1736804 | 1736804 | 2021-09-20 | Adams | Mississippi | 28001 | 4309 | 114 |
1719423 | 1719423 | 2021-09-15 | Logan | Colorado | 8075 | 4309 | 72 |
1709020 | 1709020 | 2021-09-11 | Willacy | Texas | 48489 | 4309 | 100 |
1706027 | 1706027 | 2021-09-10 | Marshall | West Virginia | 54051 | 4309 | 91 |
1701111 | 1701111 | 2021-09-09 | Leflore | Mississippi | 28083 | 4309 | 138 |
1698635 | 1698635 | 2021-09-08 | Benton | Oregon | 41003 | 4309 | 23 |
1691183 | 1691183 | 2021-09-06 | Huron | Michigan | 26063 | 4309 | 86 |
1687933 | 1687933 | 2021-09-05 | Huron | Michigan | 26063 | 4309 | 86 |
1684683 | 1684683 | 2021-09-04 | Huron | Michigan | 26063 | 4309 | 86 |
1681432 | 1681432 | 2021-09-03 | Huron | Michigan | 26063 | 4309 | 86 |
1675041 | 1675041 | 2021-09-01 | Nobles | Minnesota | 27105 | 4309 | 50 |
1631975 | 1631975 | 2021-08-19 | Wayne | Georgia | 13305 | 4309 | 93 |
1628838 | 1628838 | 2021-08-18 | Lee | Illinois | 17103 | 4309 | 94 |
1622818 | 1622818 | 2021-08-16 | Beauregard | Louisiana | 22011 | 4309 | 84 |
1620513 | 1620513 | 2021-08-15 | Brown | Ohio | 39015 | 4309 | 63 |
1611255 | 1611255 | 2021-08-12 | Giles | Tennessee | 47055 | 4309 | 100 |
1597486 | 1597486 | 2021-08-08 | Belknap | New Hampshire | 33001 | 4309 | 101 |
1594237 | 1594237 | 2021-08-07 | Belknap | New Hampshire | 33001 | 4309 | 101 |
1590988 | 1590988 | 2021-08-06 | Belknap | New Hampshire | 33001 | 4309 | 101 |
1581331 | 1581331 | 2021-08-03 | Montgomery | New York | 36057 | 4309 | 128 |
1561431 | 1561431 | 2021-07-28 | Monroe | Mississippi | 28095 | 4309 | 137 |
1511376 | 1511376 | 2021-07-13 | Boone | Arkansas | 5009 | 4309 | 80 |
1503132 | 1503132 | 2021-07-10 | Webster | Missouri | 29225 | 4309 | 59 |
1493254 | 1493254 | 2021-07-07 | Pontotoc | Mississippi | 28115 | 4309 | 73 |
1485080 | 1485080 | 2021-07-04 | Shenandoah | Virginia | 51171 | 4309 | 134 |
1444468 | 1444468 | 2021-06-22 | McLeod | Minnesota | 27085 | 4309 | 61 |
1420129 | 1420129 | 2021-06-14 | Manassas city | Virginia | 51683 | 4309 | 47 |
1416884 | 1416884 | 2021-06-13 | Manassas city | Virginia | 51683 | 4309 | 47 |
1411680 | 1411680 | 2021-06-12 | Graves | Kentucky | 21083 | 4309 | 96 |
1413638 | 1413638 | 2021-06-12 | Manassas city | Virginia | 51683 | 4309 | 47 |
1410393 | 1410393 | 2021-06-11 | Manassas city | Virginia | 51683 | 4309 | 47 |
1396490 | 1396490 | 2021-06-07 | Defiance | Ohio | 39039 | 4309 | 98 |
1393243 | 1393243 | 2021-06-06 | Defiance | Ohio | 39039 | 4309 | 98 |
1389998 | 1389998 | 2021-06-05 | Defiance | Ohio | 39039 | 4309 | 98 |
1371448 | 1371448 | 2021-05-30 | Manassas city | Virginia | 51683 | 4309 | 47 |
1345224 | 1345224 | 2021-05-22 | Jim Wells | Texas | 48249 | 4309 | 103 |
1338109 | 1338109 | 2021-05-20 | Putnam | Ohio | 39137 | 4309 | 101 |
1332582 | 1332582 | 2021-05-18 | Whitman | Washington | 53075 | 4309 | 48 |
1326958 | 1326958 | 2021-05-17 | DeKalb | Indiana | 18033 | 4309 | 88 |
1290685 | 1290685 | 2021-05-06 | Miller | Arkansas | 5091 | 4309 | 38 |
1287038 | 1287038 | 2021-05-04 | Manassas city | Virginia | 51683 | 4309 | 47 |
1256720 | 1256720 | 2021-04-25 | Alexander | North Carolina | 37003 | 4309 | 83 |
1253473 | 1253473 | 2021-04-24 | Alexander | North Carolina | 37003 | 4309 | 83 |
1250226 | 1250226 | 2021-04-23 | Alexander | North Carolina | 37003 | 4309 | 83 |
1244405 | 1244405 | 2021-04-21 | Lincoln | Tennessee | 47103 | 4309 | 63 |
1237203 | 1237203 | 2021-04-19 | Madison | New York | 36053 | 4309 | 86 |
1228893 | 1228893 | 2021-04-17 | Russell | Alabama | 1113 | 4309 | 39 |
1226255 | 1226255 | 2021-04-16 | Monroe | Illinois | 17133 | 4309 | 90 |
1216473 | 1216473 | 2021-04-13 | Franklin | Illinois | 17055 | 4309 | 82 |
1207107 | 1207107 | 2021-04-10 | Barren | Kentucky | 21009 | 4309 | 86 |
1147381 | 1147381 | 2021-03-22 | Henry | Virginia | 51089 | 4309 | 120 |
1119076 | 1119076 | 2021-03-14 | Livingston | Illinois | 17105 | 4309 | 91 |
1107348 | 1107348 | 2021-03-10 | Beaufort | North Carolina | 37013 | 4309 | 83 |
1080740 | 1080740 | 2021-03-02 | Grand Traverse | Michigan | 26055 | 4309 | 70 |
1073325 | 1073325 | 2021-02-28 | Hendry | Florida | 12051 | 4309 | 73 |
1019739 | 1019739 | 2021-02-11 | Edgecombe | North Carolina | 37065 | 4309 | 92 |
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);