ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 3737 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 16
- Ohio 8
- Arkansas 7
- Missouri 7
- Georgia 6
- Illinois 6
- Minnesota 6
- Virginia 6
- Colorado 4
- Kansas 4
- Michigan 4
- Texas 4
- Connecticut 3
- New York 3
- North Carolina 3
- Oklahoma 3
- Alabama 2
- Florida 2
- Iowa 2
- Louisiana 2
- Mississippi 2
- Tennessee 2
- Virgin Islands 2
- West Virginia 2
- California 1
- Idaho 1
- Maryland 1
- Nebraska 1
- New Hampshire 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489838 | 2489838 | 2022-05-10 | Lamar | Alabama | 1075 | 3737 | 65 |
2293965 | 2293965 | 2022-03-10 | Falls | Texas | 48145 | 3737 | 63 |
2281651 | 2281651 | 2022-03-07 | Howard | Arkansas | 5061 | 3737 | 48 |
2223678 | 2223678 | 2022-02-17 | Wabash | Illinois | 17185 | 3737 | 27 |
2221259 | 2221259 | 2022-02-16 | Dallas | Missouri | 29059 | 3737 | 67 |
2217597 | 2217597 | 2022-02-15 | Washington | Kentucky | 21229 | 3737 | 54 |
2195102 | 2195102 | 2022-02-08 | Redwood | Minnesota | 27127 | 3737 | 52 |
2174591 | 2174591 | 2022-02-02 | Banks | Georgia | 13011 | 3737 | 75 |
2174665 | 2174665 | 2022-02-02 | Jeff Davis | Georgia | 13161 | 3737 | 64 |
2147683 | 2147683 | 2022-01-24 | Lee | Texas | 48287 | 3737 | 55 |
2129341 | 2129341 | 2022-01-19 | White | Illinois | 17193 | 3737 | 45 |
2097624 | 2097624 | 2022-01-09 | Andrew | Missouri | 29003 | 3737 | 42 |
2051622 | 2051622 | 2021-12-26 | Bourbon | Kentucky | 21017 | 3737 | 42 |
2048372 | 2048372 | 2021-12-25 | Bourbon | Kentucky | 21017 | 3737 | 42 |
2045122 | 2045122 | 2021-12-24 | Bourbon | Kentucky | 21017 | 3737 | 42 |
2041873 | 2041873 | 2021-12-23 | Bourbon | Kentucky | 21017 | 3737 | 42 |
2038623 | 2038623 | 2021-12-22 | Bourbon | Kentucky | 21017 | 3737 | 42 |
2035719 | 2035719 | 2021-12-21 | Hubbard | Minnesota | 27057 | 3737 | 51 |
2037290 | 2037290 | 2021-12-21 | St. Thomas | Virgin Islands | 78030 | 3737 | 46 |
2034040 | 2034040 | 2021-12-20 | St. Thomas | Virgin Islands | 78030 | 3737 | 46 |
1994014 | 1994014 | 2021-12-08 | Ashe | North Carolina | 37009 | 3737 | 55 |
1972755 | 1972755 | 2021-12-02 | Logan | Arkansas | 5083 | 3737 | 52 |
1967927 | 1967927 | 2021-11-30 | Grant | New Mexico | 35017 | 3737 | 55 |
1960604 | 1960604 | 2021-11-28 | Anderson | Kentucky | 21005 | 3737 | 52 |
1957353 | 1957353 | 2021-11-27 | Anderson | Kentucky | 21005 | 3737 | 52 |
1954102 | 1954102 | 2021-11-26 | Anderson | Kentucky | 21005 | 3737 | 52 |
1950851 | 1950851 | 2021-11-25 | Anderson | Kentucky | 21005 | 3737 | 52 |
1947600 | 1947600 | 2021-11-24 | Anderson | Kentucky | 21005 | 3737 | 52 |
1927780 | 1927780 | 2021-11-18 | Shelby | Illinois | 17173 | 3737 | 54 |
1930147 | 1930147 | 2021-11-18 | Waynesboro city | Virginia | 51820 | 3737 | 50 |
1925430 | 1925430 | 2021-11-17 | Randolph | Missouri | 29175 | 3737 | 37 |
1907470 | 1907470 | 2021-11-11 | Mason | West Virginia | 54053 | 3737 | 59 |
1883696 | 1883696 | 2021-11-04 | Holmes | Ohio | 39075 | 3737 | 126 |
1884592 | 1884592 | 2021-11-04 | Lee | Virginia | 51105 | 3737 | 60 |
1872044 | 1872044 | 2021-11-01 | Del Norte | California | 6015 | 3737 | 42 |
1846264 | 1846264 | 2021-10-24 | Burke | Georgia | 13033 | 3737 | 83 |
1843014 | 1843014 | 2021-10-23 | Burke | Georgia | 13033 | 3737 | 83 |
1839764 | 1839764 | 2021-10-22 | Burke | Georgia | 13033 | 3737 | 83 |
1833522 | 1833522 | 2021-10-20 | McDonough | Illinois | 17109 | 3737 | 73 |
1811185 | 1811185 | 2021-10-13 | Letcher | Kentucky | 21133 | 3737 | 65 |
1813098 | 1813098 | 2021-10-13 | Halifax | Virginia | 51083 | 3737 | 100 |
1782546 | 1782546 | 2021-10-04 | Adams | Nebraska | 31001 | 3737 | 54 |
1740722 | 1740722 | 2021-09-21 | Fayette | Ohio | 39047 | 3737 | 53 |
1733523 | 1733523 | 2021-09-19 | Pine | Minnesota | 27115 | 3737 | 26 |
1730273 | 1730273 | 2021-09-18 | Pine | Minnesota | 27115 | 3737 | 26 |
1727023 | 1727023 | 2021-09-17 | Pine | Minnesota | 27115 | 3737 | 26 |
1720705 | 1720705 | 2021-09-15 | Miller | Missouri | 29131 | 3737 | 70 |
1696991 | 1696991 | 2021-09-08 | Latah | Idaho | 16057 | 3737 | 18 |
1691961 | 1691961 | 2021-09-06 | Stutsman | North Dakota | 38093 | 3737 | 82 |
1686725 | 1686725 | 2021-09-05 | Winston | Alabama | 1133 | 3737 | 79 |
1678441 | 1678441 | 2021-09-02 | Dunklin | Missouri | 29069 | 3737 | 55 |
1651954 | 1651954 | 2021-08-25 | Clark | Kentucky | 21049 | 3737 | 32 |
1654169 | 1654169 | 2021-08-25 | Sheridan | Wyoming | 56033 | 3737 | 33 |
1611018 | 1611018 | 2021-08-12 | Snyder | Pennsylvania | 42109 | 3737 | 86 |
1601204 | 1601204 | 2021-08-09 | Malheur | Oregon | 41045 | 3737 | 68 |
1559747 | 1559747 | 2021-07-27 | Prince George | Virginia | 51149 | 3737 | 33 |
1559884 | 1559884 | 2021-07-27 | Clark | Wisconsin | 55019 | 3737 | 66 |
1548879 | 1548879 | 2021-07-24 | Warren | New York | 36113 | 3737 | 59 |
1539775 | 1539775 | 2021-07-21 | Carroll | Tennessee | 47017 | 3737 | 83 |
1536528 | 1536528 | 2021-07-20 | Carroll | Tennessee | 47017 | 3737 | 83 |
1464688 | 1464688 | 2021-06-28 | Ottawa | Ohio | 39123 | 3737 | 81 |
1461443 | 1461443 | 2021-06-27 | Ottawa | Ohio | 39123 | 3737 | 81 |
1458198 | 1458198 | 2021-06-26 | Ottawa | Ohio | 39123 | 3737 | 81 |
1394714 | 1394714 | 2021-06-07 | Summit | Colorado | 8117 | 3737 | 8 |
1391469 | 1391469 | 2021-06-06 | Summit | Colorado | 8117 | 3737 | 8 |
1378488 | 1378488 | 2021-06-02 | Summit | Colorado | 8117 | 3737 | 9 |
1294626 | 1294626 | 2021-05-07 | Lee | Iowa | 19111 | 3737 | 55 |
1291450 | 1291450 | 2021-05-06 | Ellis | Kansas | 20051 | 3737 | 72 |
1288204 | 1288204 | 2021-05-05 | Ellis | Kansas | 20051 | 3737 | 72 |
1251217 | 1251217 | 2021-04-23 | Sanpete | Utah | 49039 | 3737 | 22 |
1235474 | 1235474 | 2021-04-19 | Independence | Arkansas | 5063 | 3737 | 122 |
1236769 | 1236769 | 2021-04-19 | Hancock | Mississippi | 28045 | 3737 | 85 |
1232227 | 1232227 | 2021-04-18 | Independence | Arkansas | 5063 | 3737 | 122 |
1228978 | 1228978 | 2021-04-17 | Independence | Arkansas | 5063 | 3737 | 122 |
1200750 | 1200750 | 2021-04-08 | Iberville | Louisiana | 22047 | 3737 | 97 |
1194964 | 1194964 | 2021-04-06 | Columbia | New York | 36021 | 3737 | 99 |
1181697 | 1181697 | 2021-04-02 | Phelps | Missouri | 29161 | 3737 | 127 |
1167243 | 1167243 | 2021-03-29 | Boone | Arkansas | 5009 | 3737 | 79 |
1168992 | 1168992 | 2021-03-29 | Fulton | New York | 36035 | 3737 | 85 |
1159461 | 1159461 | 2021-03-26 | Crawford | Ohio | 39033 | 3737 | 100 |
1136645 | 1136645 | 2021-03-19 | Stokes | North Carolina | 37169 | 3737 | 75 |
1109891 | 1109891 | 2021-03-11 | Calvert | Maryland | 24009 | 3737 | 73 |
1097210 | 1097210 | 2021-03-07 | Camden | Missouri | 29029 | 3737 | 81 |
1094531 | 1094531 | 2021-03-06 | Defiance | Ohio | 39039 | 3737 | 88 |
1092244 | 1092244 | 2021-03-05 | Shenandoah | Virginia | 51171 | 3737 | 123 |
1083418 | 1083418 | 2021-03-03 | Woodford | Illinois | 17203 | 3737 | 73 |
1073230 | 1073230 | 2021-02-28 | Broomfield | Colorado | 8014 | 3737 | 74 |
1061248 | 1061248 | 2021-02-24 | Barry | Michigan | 26015 | 3737 | 43 |
1053661 | 1053661 | 2021-02-22 | Miller | Arkansas | 5091 | 3737 | 33 |
1042468 | 1042468 | 2021-02-18 | Haywood | North Carolina | 37087 | 3737 | 83 |
1039471 | 1039471 | 2021-02-17 | McCurtain | Oklahoma | 40089 | 3737 | 61 |
1034944 | 1034944 | 2021-02-16 | Cowley | Kansas | 20035 | 3737 | 9 |
1031698 | 1031698 | 2021-02-15 | Cowley | Kansas | 20035 | 3737 | 9 |
991592 | 991592 | 2021-02-02 | Manassas city | Virginia | 51683 | 3737 | 33 |
986526 | 986526 | 2021-02-01 | Webster | Louisiana | 22119 | 3737 | 84 |
983354 | 983354 | 2021-01-31 | Cass | Michigan | 26027 | 3737 | 57 |
980108 | 980108 | 2021-01-30 | Cass | Michigan | 26027 | 3737 | 57 |
960758 | 960758 | 2021-01-24 | Mower | Minnesota | 27099 | 3737 | 29 |
951710 | 951710 | 2021-01-21 | Athens | Ohio | 39009 | 3737 | 9 |
949524 | 949524 | 2021-01-20 | Mercer | West Virginia | 54055 | 3737 | 77 |
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);