ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 4836 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 10
- Tennessee 10
- Minnesota 7
- North Carolina 7
- Virginia 7
- Wisconsin 7
- Louisiana 6
- Georgia 5
- Illinois 5
- New York 5
- Arkansas 4
- Indiana 4
- California 3
- Michigan 3
- Pennsylvania 3
- Alabama 2
- Colorado 2
- Mississippi 2
- Missouri 2
- North Dakota 2
- Ohio 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- Florida 1
- Iowa 1
- Maine 1
- Nevada 1
- Oklahoma 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500630 | 2500630 | 2022-05-13 | Henry | Kentucky | 21103 | 4836 | 52 |
2497372 | 2497372 | 2022-05-12 | Henry | Kentucky | 21103 | 4836 | 52 |
2494114 | 2494114 | 2022-05-11 | Henry | Kentucky | 21103 | 4836 | 52 |
2489930 | 2489930 | 2022-05-10 | Cross | Arkansas | 5037 | 4836 | 83 |
2490856 | 2490856 | 2022-05-10 | Henry | Kentucky | 21103 | 4836 | 52 |
2487599 | 2487599 | 2022-05-09 | Henry | Kentucky | 21103 | 4836 | 52 |
2452072 | 2452072 | 2022-04-28 | Fillmore | Minnesota | 27045 | 4836 | 24 |
2440917 | 2440917 | 2022-04-24 | Taylor | Wisconsin | 55119 | 4836 | 72 |
2437661 | 2437661 | 2022-04-23 | Taylor | Wisconsin | 55119 | 4836 | 72 |
2434405 | 2434405 | 2022-04-22 | Taylor | Wisconsin | 55119 | 4836 | 72 |
2431149 | 2431149 | 2022-04-21 | Taylor | Wisconsin | 55119 | 4836 | 72 |
2418465 | 2418465 | 2022-04-18 | Teller | Colorado | 8119 | 4836 | 57 |
2417294 | 2417294 | 2022-04-17 | Morovis | Puerto Rico | 72101 | 4836 | |
2385309 | 2385309 | 2022-04-07 | Colonial Heights city | Virginia | 51570 | 4836 | 96 |
2372293 | 2372293 | 2022-04-03 | Colonial Heights city | Virginia | 51570 | 4836 | 96 |
2369040 | 2369040 | 2022-04-02 | Colonial Heights city | Virginia | 51570 | 4836 | 96 |
2365787 | 2365787 | 2022-04-01 | Colonial Heights city | Virginia | 51570 | 4836 | 96 |
2332871 | 2332871 | 2022-03-22 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2329618 | 2329618 | 2022-03-21 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2326366 | 2326366 | 2022-03-20 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2323113 | 2323113 | 2022-03-19 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2319859 | 2319859 | 2022-03-18 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2316605 | 2316605 | 2022-03-17 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2313352 | 2313352 | 2022-03-16 | Humphreys | Tennessee | 47085 | 4836 | 70 |
2270431 | 2270431 | 2022-03-03 | Currituck | North Carolina | 37053 | 4836 | 32 |
2256849 | 2256849 | 2022-02-27 | Hubbard | Minnesota | 27057 | 4836 | 56 |
2253598 | 2253598 | 2022-02-26 | Hubbard | Minnesota | 27057 | 4836 | 56 |
2250347 | 2250347 | 2022-02-25 | Hubbard | Minnesota | 27057 | 4836 | 56 |
2206875 | 2206875 | 2022-02-12 | Lincoln | Arkansas | 5079 | 4836 | 60 |
2175331 | 2175331 | 2022-02-02 | Concordia | Louisiana | 22029 | 4836 | 86 |
2149224 | 2149224 | 2022-01-25 | Johnson | Kentucky | 21115 | 4836 | 83 |
2137249 | 2137249 | 2022-01-21 | Holmes | Ohio | 39075 | 4836 | 167 |
2100124 | 2100124 | 2022-01-10 | LaGrange | Indiana | 18087 | 4836 | 97 |
2100145 | 2100145 | 2022-01-10 | Posey | Indiana | 18129 | 4836 | 46 |
2040603 | 2040603 | 2021-12-22 | Isle of Wight | Virginia | 51093 | 4836 | 93 |
2029010 | 2029010 | 2021-12-19 | Jefferson Davis | Louisiana | 22053 | 4836 | 131 |
2025759 | 2025759 | 2021-12-18 | Jefferson Davis | Louisiana | 22053 | 4836 | 131 |
2022508 | 2022508 | 2021-12-17 | Jefferson Davis | Louisiana | 22053 | 4836 | 131 |
2014112 | 2014112 | 2021-12-14 | Lawrence | South Dakota | 46081 | 4836 | 72 |
1969392 | 1969392 | 2021-12-01 | Lawrence | Alabama | 1079 | 4836 | 130 |
1963285 | 1963285 | 2021-11-29 | Decatur | Georgia | 13087 | 4836 | 106 |
1961004 | 1961004 | 2021-11-28 | Todd | Minnesota | 27153 | 4836 | 42 |
1957753 | 1957753 | 2021-11-27 | Todd | Minnesota | 27153 | 4836 | 42 |
1954502 | 1954502 | 2021-11-26 | Todd | Minnesota | 27153 | 4836 | 42 |
1930355 | 1930355 | 2021-11-19 | Clarke | Alabama | 1025 | 4836 | 86 |
1869084 | 1869084 | 2021-10-31 | Lumpkin | Georgia | 13187 | 4836 | 106 |
1865835 | 1865835 | 2021-10-30 | Lumpkin | Georgia | 13187 | 4836 | 106 |
1862586 | 1862586 | 2021-10-29 | Lumpkin | Georgia | 13187 | 4836 | 106 |
1813254 | 1813254 | 2021-10-13 | Preston | West Virginia | 54077 | 4836 | 73 |
1803783 | 1803783 | 2021-10-11 | Poinsett | Arkansas | 5111 | 4836 | 98 |
1782484 | 1782484 | 2021-10-04 | Warren | Missouri | 29219 | 4836 | 41 |
1733150 | 1733150 | 2021-09-19 | Boyle | Kentucky | 21021 | 4836 | 80 |
1733402 | 1733402 | 2021-09-19 | Delta | Michigan | 26041 | 4836 | 98 |
1729900 | 1729900 | 2021-09-18 | Boyle | Kentucky | 21021 | 4836 | 80 |
1730152 | 1730152 | 2021-09-18 | Delta | Michigan | 26041 | 4836 | 98 |
1726650 | 1726650 | 2021-09-17 | Boyle | Kentucky | 21021 | 4836 | 80 |
1726902 | 1726902 | 2021-09-17 | Delta | Michigan | 26041 | 4836 | 98 |
1724838 | 1724838 | 2021-09-16 | Marion | South Carolina | 45067 | 4836 | 120 |
1711965 | 1711965 | 2021-09-12 | Henderson | Tennessee | 47077 | 4836 | 82 |
1708718 | 1708718 | 2021-09-11 | Henderson | Tennessee | 47077 | 4836 | 82 |
1705471 | 1705471 | 2021-09-10 | Henderson | Tennessee | 47077 | 4836 | 82 |
1673454 | 1673454 | 2021-08-31 | Shenandoah | Virginia | 51171 | 4836 | 137 |
1656046 | 1656046 | 2021-08-26 | Madison | New York | 36053 | 4836 | 90 |
1622426 | 1622426 | 2021-08-16 | Harrison | Indiana | 18061 | 4836 | 80 |
1623163 | 1623163 | 2021-08-16 | Pontotoc | Mississippi | 28115 | 4836 | 77 |
1600534 | 1600534 | 2021-08-09 | Platte | Missouri | 29165 | 4836 | 53 |
1589153 | 1589153 | 2021-08-05 | Monroe | Wisconsin | 55081 | 4836 | 51 |
1573619 | 1573619 | 2021-08-01 | Marion | Illinois | 17121 | 4836 | 124 |
1570371 | 1570371 | 2021-07-31 | Marion | Illinois | 17121 | 4836 | 124 |
1567123 | 1567123 | 2021-07-30 | Marion | Illinois | 17121 | 4836 | 124 |
1563842 | 1563842 | 2021-07-29 | Effingham | Illinois | 17049 | 4836 | 85 |
1549380 | 1549380 | 2021-07-24 | Toa Alta | Puerto Rico | 72135 | 4836 | |
1533710 | 1533710 | 2021-07-19 | Fauquier | Virginia | 51061 | 4836 | 69 |
1518504 | 1518504 | 2021-07-15 | Lawrence | Indiana | 18093 | 4836 | 128 |
1463257 | 1463257 | 2021-06-28 | Stephenson | Illinois | 17177 | 4836 | 104 |
1428720 | 1428720 | 2021-06-17 | Clinton | New York | 36019 | 4836 | 33 |
1425041 | 1425041 | 2021-06-16 | Bolivar | Mississippi | 28011 | 4836 | 133 |
1425475 | 1425475 | 2021-06-16 | Clinton | New York | 36019 | 4836 | 33 |
1393114 | 1393114 | 2021-06-06 | Hoke | North Carolina | 37093 | 4836 | 56 |
1389869 | 1389869 | 2021-06-05 | Hoke | North Carolina | 37093 | 4836 | 56 |
1386624 | 1386624 | 2021-06-04 | Hoke | North Carolina | 37093 | 4836 | 56 |
1328288 | 1328288 | 2021-05-17 | Stark | North Dakota | 38089 | 4836 | 51 |
1289050 | 1289050 | 2021-05-05 | Elko | Nevada | 32007 | 4836 | 56 |
1256809 | 1256809 | 2021-04-25 | Vance | North Carolina | 37181 | 4836 | 86 |
1253562 | 1253562 | 2021-04-24 | Vance | North Carolina | 37181 | 4836 | 86 |
1250315 | 1250315 | 2021-04-23 | Vance | North Carolina | 37181 | 4836 | 86 |
1216856 | 1216856 | 2021-04-13 | Boyd | Kentucky | 21019 | 4836 | 72 |
1207297 | 1207297 | 2021-04-10 | Penobscot | Maine | 23019 | 4836 | 89 |
1204721 | 1204721 | 2021-04-09 | Herkimer | New York | 36043 | 4836 | 107 |
1116055 | 1116055 | 2021-03-13 | Sioux | Iowa | 19167 | 4836 | 69 |
1094552 | 1094552 | 2021-03-06 | Jefferson | Ohio | 39081 | 4836 | 137 |
1084583 | 1084583 | 2021-03-03 | Jefferson | New York | 36045 | 4836 | 63 |
1070911 | 1070911 | 2021-02-27 | Vermilion | Louisiana | 22113 | 4836 | 106 |
1067666 | 1067666 | 2021-02-26 | Vermilion | Louisiana | 22113 | 4836 | 106 |
1065516 | 1065516 | 2021-02-25 | Carbon | Pennsylvania | 42025 | 4836 | 151 |
1042730 | 1042730 | 2021-02-18 | Pontotoc | Oklahoma | 40123 | 4836 | 45 |
977639 | 977639 | 2021-01-29 | Morton | North Dakota | 38059 | 4836 | 93 |
933381 | 933381 | 2021-01-15 | Shawano | Wisconsin | 55115 | 4836 | 74 |
910840 | 910840 | 2021-01-09 | Greene | Arkansas | 5055 | 4836 | 58 |
904478 | 904478 | 2021-01-07 | Fremont | Colorado | 8043 | 4836 | 23 |
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);