ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 5037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 8
- Alabama 7
- Iowa 7
- Kentucky 7
- Oklahoma 7
- Texas 7
- Illinois 6
- Missouri 5
- Idaho 4
- Indiana 4
- Michigan 4
- Oregon 4
- West Virginia 4
- Georgia 3
- New York 3
- North Dakota 3
- Ohio 3
- Arkansas 2
- Pennsylvania 2
- Arizona 1
- California 1
- Colorado 1
- Florida 1
- Louisiana 1
- Maine 1
- Massachusetts 1
- Mississippi 1
- New Hampshire 1
- New Mexico 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492458 | 2492458 | 2022-05-10 | Burleson | Texas | 48051 | 5037 | 66 |
2463486 | 2463486 | 2022-05-01 | King George | Virginia | 51099 | 5037 | 39 |
2460230 | 2460230 | 2022-04-30 | King George | Virginia | 51099 | 5037 | 39 |
2456974 | 2456974 | 2022-04-29 | King George | Virginia | 51099 | 5037 | 39 |
2425348 | 2425348 | 2022-04-20 | Pike | Illinois | 17149 | 5037 | 70 |
2418836 | 2418836 | 2022-04-18 | Pike | Illinois | 17149 | 5037 | 70 |
2370438 | 2370438 | 2022-04-03 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2367185 | 2367185 | 2022-04-02 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2363932 | 2363932 | 2022-04-01 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2360678 | 2360678 | 2022-03-31 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2357424 | 2357424 | 2022-03-30 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2357519 | 2357519 | 2022-03-30 | Sagadahoc | Maine | 23023 | 5037 | 29 |
2354171 | 2354171 | 2022-03-29 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2350919 | 2350919 | 2022-03-28 | Rockcastle | Kentucky | 21203 | 5037 | 56 |
2347136 | 2347136 | 2022-03-27 | Cassia | Idaho | 16031 | 5037 | 52 |
2343883 | 2343883 | 2022-03-26 | Cassia | Idaho | 16031 | 5037 | 52 |
2340630 | 2340630 | 2022-03-25 | Cassia | Idaho | 16031 | 5037 | 52 |
2335919 | 2335919 | 2022-03-23 | Hatillo | Puerto Rico | 72065 | 5037 | |
2302630 | 2302630 | 2022-03-13 | Vernon | Missouri | 29217 | 5037 | 103 |
2299378 | 2299378 | 2022-03-12 | Vernon | Missouri | 29217 | 5037 | 103 |
2296126 | 2296126 | 2022-03-11 | Vernon | Missouri | 29217 | 5037 | 103 |
2292874 | 2292874 | 2022-03-10 | Vernon | Missouri | 29217 | 5037 | 102 |
2289622 | 2289622 | 2022-03-09 | Vernon | Missouri | 29217 | 5037 | 102 |
2281515 | 2281515 | 2022-03-07 | Butler | Alabama | 1013 | 5037 | 123 |
2278262 | 2278262 | 2022-03-06 | Butler | Alabama | 1013 | 5037 | 122 |
2275009 | 2275009 | 2022-03-05 | Butler | Alabama | 1013 | 5037 | 122 |
2271756 | 2271756 | 2022-03-04 | Butler | Alabama | 1013 | 5037 | 122 |
2268504 | 2268504 | 2022-03-03 | Butler | Alabama | 1013 | 5037 | 120 |
2265251 | 2265251 | 2022-03-02 | Butler | Alabama | 1013 | 5037 | 119 |
2262001 | 2262001 | 2022-03-01 | Butler | Alabama | 1013 | 5037 | 119 |
2262147 | 2262147 | 2022-03-01 | Logan | Arkansas | 5083 | 5037 | 70 |
2261007 | 2261007 | 2022-02-28 | Wasco | Oregon | 41065 | 5037 | 53 |
2226104 | 2226104 | 2022-02-17 | Lewis | West Virginia | 54041 | 5037 | 76 |
2215331 | 2215331 | 2022-02-14 | Holmes | Ohio | 39075 | 5037 | 172 |
2206827 | 2206827 | 2022-02-12 | La Paz | Arizona | 4012 | 5037 | 127 |
2193580 | 2193580 | 2022-02-07 | Lincoln | West Virginia | 54043 | 5037 | 62 |
2167233 | 2167233 | 2022-01-30 | Moore | Texas | 48341 | 5037 | 104 |
2163935 | 2163935 | 2022-01-29 | Karnes | Texas | 48255 | 5037 | 60 |
2132687 | 2132687 | 2022-01-20 | Washington | Indiana | 18175 | 5037 | 70 |
2099273 | 2099273 | 2022-01-09 | Upshur | West Virginia | 54097 | 5037 | 75 |
2058438 | 2058438 | 2021-12-28 | Wexford | Michigan | 26165 | 5037 | 84 |
2055189 | 2055189 | 2021-12-27 | Wexford | Michigan | 26165 | 5037 | 84 |
2038158 | 2038158 | 2021-12-22 | White | Georgia | 13311 | 5037 | 134 |
1989659 | 1989659 | 2021-12-07 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1986409 | 1986409 | 2021-12-06 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1983159 | 1983159 | 2021-12-05 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1979909 | 1979909 | 2021-12-04 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1976659 | 1976659 | 2021-12-03 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1973410 | 1973410 | 2021-12-02 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1970160 | 1970160 | 2021-12-01 | Buena Vista | Iowa | 19021 | 5037 | 49 |
1946879 | 1946879 | 2021-11-24 | Logan | Colorado | 8075 | 5037 | 92 |
1896557 | 1896557 | 2021-11-08 | Macon | North Carolina | 37113 | 5037 | 73 |
1878314 | 1878314 | 2021-11-02 | Trempealeau | Wisconsin | 55121 | 5037 | 52 |
1864400 | 1864400 | 2021-10-29 | Jefferson | Pennsylvania | 42065 | 5037 | 120 |
1848091 | 1848091 | 2021-10-24 | Coos | Oregon | 41011 | 5037 | 94 |
1844464 | 1844464 | 2021-10-23 | Columbia | New York | 36021 | 5037 | 111 |
1844841 | 1844841 | 2021-10-23 | Coos | Oregon | 41011 | 5037 | 94 |
1841591 | 1841591 | 2021-10-22 | Coos | Oregon | 41011 | 5037 | 94 |
1779756 | 1779756 | 2021-10-03 | Putnam | Ohio | 39137 | 5037 | 108 |
1764437 | 1764437 | 2021-09-28 | York | Virginia | 51199 | 5037 | 68 |
1700410 | 1700410 | 2021-09-09 | Miami | Indiana | 18103 | 5037 | 82 |
1694615 | 1694615 | 2021-09-07 | Lincoln | Mississippi | 28085 | 5037 | 123 |
1690088 | 1690088 | 2021-09-06 | Union | Arkansas | 5139 | 5037 | 120 |
1628748 | 1628748 | 2021-08-18 | Bingham | Idaho | 16011 | 5037 | 78 |
1619148 | 1619148 | 2021-08-15 | Woodford | Illinois | 17203 | 5037 | 96 |
1615900 | 1615900 | 2021-08-14 | Woodford | Illinois | 17203 | 5037 | 96 |
1612651 | 1612651 | 2021-08-13 | Woodford | Illinois | 17203 | 5037 | 96 |
1611528 | 1611528 | 2021-08-12 | San Patricio | Texas | 48409 | 5037 | 154 |
1606104 | 1606104 | 2021-08-11 | Livingston | Illinois | 17105 | 5037 | 107 |
1608280 | 1608280 | 2021-08-11 | San Patricio | Texas | 48409 | 5037 | 154 |
1605031 | 1605031 | 2021-08-10 | San Patricio | Texas | 48409 | 5037 | 154 |
1518293 | 1518293 | 2021-07-15 | Ware | Georgia | 13299 | 5037 | 182 |
1484099 | 1484099 | 2021-07-04 | Williams | North Dakota | 38105 | 5037 | 40 |
1480853 | 1480853 | 2021-07-03 | Williams | North Dakota | 38105 | 5037 | 40 |
1361833 | 1361833 | 2021-05-27 | Mercer | West Virginia | 54055 | 5037 | 119 |
1239835 | 1239835 | 2021-04-20 | Cass | Michigan | 26027 | 5037 | 72 |
1217696 | 1217696 | 2021-04-13 | Cattaraugus | New York | 36009 | 5037 | 80 |
1195319 | 1195319 | 2021-04-06 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1192071 | 1192071 | 2021-04-05 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1188645 | 1188645 | 2021-04-04 | Morton | North Dakota | 38059 | 5037 | 98 |
1188822 | 1188822 | 2021-04-04 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1185575 | 1185575 | 2021-04-03 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1182328 | 1182328 | 2021-04-02 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1179081 | 1179081 | 2021-04-01 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1175442 | 1175442 | 2021-03-31 | Curry | New Mexico | 35009 | 5037 | 72 |
1175834 | 1175834 | 2021-03-31 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1149742 | 1149742 | 2021-03-23 | Huron | Ohio | 39077 | 5037 | 110 |
1092104 | 1092104 | 2021-03-05 | Summit | Utah | 49043 | 5037 | 10 |
1044526 | 1044526 | 2021-02-19 | Noble | Indiana | 18113 | 5037 | 78 |
952442 | 952442 | 2021-01-21 | Navarro | Texas | 48349 | 5037 | 81 |
949370 | 949370 | 2021-01-20 | Frederick | Virginia | 51069 | 5037 | 39 |
939644 | 939644 | 2021-01-17 | Harrisonburg city | Virginia | 51660 | 5037 | 53 |
893015 | 893015 | 2021-01-03 | Merrimack | New Hampshire | 33013 | 5037 | 68 |
878971 | 878971 | 2020-12-30 | Floyd | Indiana | 18043 | 5037 | 99 |
871517 | 871517 | 2020-12-27 | Montgomery | Virginia | 51121 | 5037 | 36 |
862560 | 862560 | 2020-12-25 | Walton | Georgia | 13297 | 5037 | 88 |
710738 | 710738 | 2020-11-08 | Unknown | Massachusetts | 5037 | 23 | |
678236 | 678236 | 2020-10-29 | Tangipahoa | Louisiana | 22105 | 5037 | 126 |
670785 | 670785 | 2020-10-27 | Madera | California | 6039 | 5037 | 74 |
603721 | 603721 | 2020-10-06 | Genesee | Michigan | 26049 | 5037 | 309 |
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);