ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 4569 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 13
- California 8
- Georgia 6
- North Carolina 6
- Virginia 6
- Kansas 5
- Ohio 4
- Tennessee 4
- Washington 4
- Alabama 3
- Colorado 3
- Indiana 3
- Michigan 3
- Mississippi 3
- Missouri 3
- Nevada 3
- New York 3
- Texas 3
- Arkansas 2
- Louisiana 2
- Maine 2
- Minnesota 2
- North Dakota 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Alaska 1
- Arizona 1
- Delaware 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496456 | 2496456 | 2022-05-12 | Hempstead | Arkansas | 5057 | 4569 | 68 |
2494263 | 2494263 | 2022-05-11 | Washington | Maine | 23029 | 4569 | 56 |
2428128 | 2428128 | 2022-04-21 | Inyo | California | 6027 | 4569 | 56 |
2424872 | 2424872 | 2022-04-20 | Inyo | California | 6027 | 4569 | 56 |
2421616 | 2421616 | 2022-04-19 | Inyo | California | 6027 | 4569 | 56 |
2418360 | 2418360 | 2022-04-18 | Inyo | California | 6027 | 4569 | 56 |
2415104 | 2415104 | 2022-04-17 | Inyo | California | 6027 | 4569 | 56 |
2411848 | 2411848 | 2022-04-16 | Inyo | California | 6027 | 4569 | 56 |
2408592 | 2408592 | 2022-04-15 | Inyo | California | 6027 | 4569 | 56 |
2353874 | 2353874 | 2022-03-29 | Buchanan | Iowa | 19019 | 4569 | 57 |
2350622 | 2350622 | 2022-03-28 | Buchanan | Iowa | 19019 | 4569 | 57 |
2347369 | 2347369 | 2022-03-27 | Buchanan | Iowa | 19019 | 4569 | 57 |
2344116 | 2344116 | 2022-03-26 | Buchanan | Iowa | 19019 | 4569 | 57 |
2340863 | 2340863 | 2022-03-25 | Buchanan | Iowa | 19019 | 4569 | 57 |
2337610 | 2337610 | 2022-03-24 | Buchanan | Iowa | 19019 | 4569 | 57 |
2334356 | 2334356 | 2022-03-23 | Buchanan | Iowa | 19019 | 4569 | 57 |
2239014 | 2239014 | 2022-02-21 | Prince Edward | Virginia | 51147 | 4569 | 60 |
2216514 | 2216514 | 2022-02-15 | Hale | Alabama | 1065 | 4569 | 96 |
2210744 | 2210744 | 2022-02-13 | Perry | Indiana | 18123 | 4569 | 64 |
2207491 | 2207491 | 2022-02-12 | Perry | Indiana | 18123 | 4569 | 64 |
2204238 | 2204238 | 2022-02-11 | Perry | Indiana | 18123 | 4569 | 64 |
2190762 | 2190762 | 2022-02-07 | Teller | Colorado | 8119 | 4569 | 54 |
2097891 | 2097891 | 2022-01-09 | Churchill | Nevada | 32001 | 4569 | 92 |
2094639 | 2094639 | 2022-01-08 | Churchill | Nevada | 32001 | 4569 | 92 |
2091387 | 2091387 | 2022-01-07 | Churchill | Nevada | 32001 | 4569 | 92 |
2076345 | 2076345 | 2022-01-02 | Halifax | Virginia | 51083 | 4569 | 127 |
2073094 | 2073094 | 2022-01-01 | Halifax | Virginia | 51083 | 4569 | 127 |
2069843 | 2069843 | 2021-12-31 | Halifax | Virginia | 51083 | 4569 | 127 |
2032704 | 2032704 | 2021-12-20 | Saline | Missouri | 29195 | 4569 | 84 |
1974665 | 1974665 | 2021-12-02 | Adams | Ohio | 39001 | 4569 | 109 |
1928625 | 1928625 | 2021-11-18 | Dunklin | Missouri | 29069 | 4569 | 91 |
1899898 | 1899898 | 2021-11-09 | Stutsman | North Dakota | 38093 | 4569 | 88 |
1886709 | 1886709 | 2021-11-05 | Franklin | New York | 36033 | 4569 | 25 |
1876298 | 1876298 | 2021-11-02 | Somerset | Maine | 23025 | 4569 | 51 |
1859776 | 1859776 | 2021-10-28 | Ellis | Kansas | 20051 | 4569 | 76 |
1856527 | 1856527 | 2021-10-27 | Ellis | Kansas | 20051 | 4569 | 76 |
1849524 | 1849524 | 2021-10-25 | Chattooga | Georgia | 13055 | 4569 | 103 |
1831094 | 1831094 | 2021-10-19 | Tate | Mississippi | 28137 | 4569 | 109 |
1832198 | 1832198 | 2021-10-19 | McNairy | Tennessee | 47109 | 4569 | 67 |
1810568 | 1810568 | 2021-10-13 | Gilmer | Georgia | 13123 | 4569 | 126 |
1805061 | 1805061 | 2021-10-11 | Itawamba | Mississippi | 28057 | 4569 | 104 |
1806487 | 1806487 | 2021-10-11 | Willacy | Texas | 48489 | 4569 | 107 |
1802706 | 1802706 | 2021-10-10 | Arecibo | Puerto Rico | 72013 | 4569 | |
1803237 | 1803237 | 2021-10-10 | Willacy | Texas | 48489 | 4569 | 107 |
1799457 | 1799457 | 2021-10-09 | Arecibo | Puerto Rico | 72013 | 4569 | |
1781179 | 1781179 | 2021-10-04 | Summit | Colorado | 8117 | 4569 | 10 |
1724819 | 1724819 | 2021-09-16 | Clarendon | South Carolina | 45027 | 4569 | 132 |
1719164 | 1719164 | 2021-09-15 | Dallas | Alabama | 1047 | 4569 | 173 |
1719685 | 1719685 | 2021-09-15 | White | Georgia | 13311 | 4569 | 108 |
1701030 | 1701030 | 2021-09-09 | Morrison | Minnesota | 27097 | 4569 | 62 |
1651110 | 1651110 | 2021-08-25 | Unknown | Arkansas | 4569 | 0 | |
1652801 | 1652801 | 2021-08-25 | Montgomery | New York | 36057 | 4569 | 128 |
1632788 | 1632788 | 2021-08-19 | Isanti | Minnesota | 27059 | 4569 | 68 |
1622832 | 1622832 | 2021-08-16 | Evangeline | Louisiana | 22039 | 4569 | 101 |
1617283 | 1617283 | 2021-08-14 | Fulton | Ohio | 39051 | 4569 | 77 |
1603689 | 1603689 | 2021-08-10 | Union | Mississippi | 28145 | 4569 | 79 |
1581000 | 1581000 | 2021-08-03 | Howell | Missouri | 29091 | 4569 | 50 |
1581328 | 1581328 | 2021-08-03 | Livingston | New York | 36051 | 4569 | 60 |
1554600 | 1554600 | 2021-07-26 | Avoyelles | Louisiana | 22009 | 4569 | 127 |
1530755 | 1530755 | 2021-07-19 | Chilton | Alabama | 1021 | 4569 | 116 |
1533286 | 1533286 | 2021-07-19 | Cocke | Tennessee | 47029 | 4569 | 101 |
1469256 | 1469256 | 2021-06-30 | Humboldt | California | 6023 | 4569 | 50 |
1440378 | 1440378 | 2021-06-21 | Thomas | Georgia | 13275 | 4569 | 124 |
1437131 | 1437131 | 2021-06-20 | Thomas | Georgia | 13275 | 4569 | 124 |
1422475 | 1422475 | 2021-06-15 | Knox | Ohio | 39083 | 4569 | 112 |
1420352 | 1420352 | 2021-06-14 | Albany | Wyoming | 56001 | 4569 | 15 |
1387617 | 1387617 | 2021-06-04 | Campbell | Virginia | 51031 | 4569 | 86 |
1380938 | 1380938 | 2021-06-02 | Kerr | Texas | 48265 | 4569 | 88 |
1336537 | 1336537 | 2021-05-20 | Maui | Hawaii | 15009 | 4569 | 54 |
1319580 | 1319580 | 2021-05-14 | Lewis | Washington | 53041 | 4569 | 65 |
1302179 | 1302179 | 2021-05-09 | Beaufort | North Carolina | 37013 | 4569 | 95 |
1298931 | 1298931 | 2021-05-08 | Beaufort | North Carolina | 37013 | 4569 | 95 |
1295685 | 1295685 | 2021-05-07 | Beaufort | North Carolina | 37013 | 4569 | 95 |
1290271 | 1290271 | 2021-05-05 | James City | Virginia | 51095 | 4569 | 72 |
1262011 | 1262011 | 2021-04-27 | Woodford | Illinois | 17203 | 4569 | 81 |
1260012 | 1260012 | 2021-04-26 | Hoke | North Carolina | 37093 | 4569 | 55 |
1251819 | 1251819 | 2021-04-24 | Broomfield | Colorado | 8014 | 4569 | 75 |
1181436 | 1181436 | 2021-04-02 | Shiawassee | Michigan | 26155 | 4569 | 84 |
1176051 | 1176051 | 2021-03-31 | Chesterfield | South Carolina | 45025 | 4569 | 98 |
1164986 | 1164986 | 2021-03-28 | Scott | Kentucky | 21209 | 4569 | 31 |
1151315 | 1151315 | 2021-03-24 | Colquitt | Georgia | 13071 | 4569 | 110 |
1152885 | 1152885 | 2021-03-24 | Vance | North Carolina | 37181 | 4569 | 85 |
1146145 | 1146145 | 2021-03-22 | Scotts Bluff | Nebraska | 31157 | 4569 | 95 |
1146454 | 1146454 | 2021-03-22 | Williams | North Dakota | 38105 | 4569 | 36 |
1119337 | 1119337 | 2021-03-14 | Crawford | Kansas | 20037 | 4569 | 80 |
1116090 | 1116090 | 2021-03-13 | Crawford | Kansas | 20037 | 4569 | 80 |
1112844 | 1112844 | 2021-03-12 | Crawford | Kansas | 20037 | 4569 | 80 |
1068792 | 1068792 | 2021-02-26 | Mifflin | Pennsylvania | 42087 | 4569 | 166 |
1060856 | 1060856 | 2021-02-24 | Marshall | Iowa | 19127 | 4569 | 72 |
1057610 | 1057610 | 2021-02-23 | Marshall | Iowa | 19127 | 4569 | 72 |
1054364 | 1054364 | 2021-02-22 | Marshall | Iowa | 19127 | 4569 | 70 |
1051117 | 1051117 | 2021-02-21 | Marshall | Iowa | 19127 | 4569 | 70 |
1047870 | 1047870 | 2021-02-20 | Marshall | Iowa | 19127 | 4569 | 70 |
1044625 | 1044625 | 2021-02-19 | Marshall | Iowa | 19127 | 4569 | 70 |
1014405 | 1014405 | 2021-02-09 | Walla Walla | Washington | 53071 | 4569 | 54 |
993067 | 993067 | 2021-02-03 | Berkshire | Massachusetts | 25003 | 4569 | 222 |
983320 | 983320 | 2021-01-31 | St. Mary's | Maryland | 24037 | 4569 | 104 |
964766 | 964766 | 2021-01-25 | Union | Ohio | 39159 | 4569 | 28 |
950944 | 950944 | 2021-01-21 | Midland | Michigan | 26111 | 4569 | 53 |
846146 | 846146 | 2020-12-20 | Highlands | Florida | 12055 | 4569 | 191 |
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);