ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4704 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 10
- Georgia 9
- Missouri 9
- Kentucky 7
- Illinois 6
- Kansas 5
- Montana 5
- North Carolina 5
- Texas 5
- West Virginia 5
- Arkansas 4
- Virginia 4
- Minnesota 3
- New York 3
- California 2
- Idaho 2
- Indiana 2
- Iowa 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Tennessee 2
- Alabama 1
- Louisiana 1
- Mississippi 1
- Nevada 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465982 | 2465982 | 2022-05-02 | Clatsop | Oregon | 41007 | 4704 | 50 |
2384738 | 2384738 | 2022-04-07 | Morovis | Puerto Rico | 72101 | 4704 | |
2325433 | 2325433 | 2022-03-20 | Lincoln | Montana | 30053 | 4704 | 86 |
2322179 | 2322179 | 2022-03-19 | Lincoln | Montana | 30053 | 4704 | 86 |
2318925 | 2318925 | 2022-03-18 | Lincoln | Montana | 30053 | 4704 | 86 |
2270021 | 2270021 | 2022-03-03 | Clinton | Missouri | 29049 | 4704 | 114 |
2266025 | 2266025 | 2022-03-02 | Starke | Indiana | 18149 | 4704 | 94 |
2262774 | 2262774 | 2022-03-01 | Starke | Indiana | 18149 | 4704 | 93 |
2239629 | 2239629 | 2022-02-22 | Appling | Georgia | 13001 | 4704 | 116 |
2236378 | 2236378 | 2022-02-21 | Appling | Georgia | 13001 | 4704 | 116 |
2235692 | 2235692 | 2022-02-20 | Colonial Heights city | Virginia | 51570 | 4704 | 88 |
2232441 | 2232441 | 2022-02-19 | Colonial Heights city | Virginia | 51570 | 4704 | 88 |
2229190 | 2229190 | 2022-02-18 | Colonial Heights city | Virginia | 51570 | 4704 | 88 |
2179018 | 2179018 | 2022-02-03 | New Madrid | Missouri | 29143 | 4704 | 73 |
2173172 | 2173172 | 2022-02-01 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2169920 | 2169920 | 2022-01-31 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2166665 | 2166665 | 2022-01-30 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2163410 | 2163410 | 2022-01-29 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2160155 | 2160155 | 2022-01-28 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2156900 | 2156900 | 2022-01-27 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2151908 | 2151908 | 2022-01-26 | Mitchell | Georgia | 13205 | 4704 | 104 |
2153647 | 2153647 | 2022-01-26 | Woodward | Oklahoma | 40153 | 4704 | 60 |
2141778 | 2141778 | 2022-01-23 | Clark | Arkansas | 5019 | 4704 | 66 |
2108624 | 2108624 | 2022-01-12 | Jasper | Texas | 48241 | 4704 | 167 |
2086176 | 2086176 | 2022-01-05 | Winchester city | Virginia | 51840 | 4704 | 58 |
2074433 | 2074433 | 2022-01-02 | Lincoln | Kentucky | 21137 | 4704 | 106 |
2071182 | 2071182 | 2022-01-01 | Lincoln | Kentucky | 21137 | 4704 | 106 |
2067931 | 2067931 | 2021-12-31 | Lincoln | Kentucky | 21137 | 4704 | 106 |
2064680 | 2064680 | 2021-12-30 | Lincoln | Kentucky | 21137 | 4704 | 106 |
2066046 | 2066046 | 2021-12-30 | Edgefield | South Carolina | 45037 | 4704 | 60 |
2061430 | 2061430 | 2021-12-29 | Lincoln | Kentucky | 21137 | 4704 | 106 |
2058012 | 2058012 | 2021-12-28 | Barton | Kansas | 20009 | 4704 | 71 |
2054763 | 2054763 | 2021-12-27 | Barton | Kansas | 20009 | 4704 | 71 |
2021390 | 2021390 | 2021-12-17 | Geneva | Alabama | 1061 | 4704 | 137 |
1996856 | 1996856 | 2021-12-09 | Barry | Missouri | 29009 | 4704 | 92 |
1898032 | 1898032 | 2021-11-09 | Yell | Arkansas | 5149 | 4704 | 79 |
1879901 | 1879901 | 2021-11-03 | Lafayette | Missouri | 29107 | 4704 | 74 |
1875531 | 1875531 | 2021-11-02 | Dawson | Georgia | 13085 | 4704 | 71 |
1872282 | 1872282 | 2021-11-01 | Dawson | Georgia | 13085 | 4704 | 71 |
1808523 | 1808523 | 2021-10-12 | Ravalli | Montana | 30081 | 4704 | 65 |
1791275 | 1791275 | 2021-10-07 | Lee | Illinois | 17103 | 4704 | 99 |
1755367 | 1755367 | 2021-09-26 | Madison | Georgia | 13195 | 4704 | 65 |
1755551 | 1755551 | 2021-09-26 | Montgomery | Illinois | 17135 | 4704 | 82 |
1752119 | 1752119 | 2021-09-25 | Madison | Georgia | 13195 | 4704 | 65 |
1752303 | 1752303 | 2021-09-25 | Montgomery | Illinois | 17135 | 4704 | 82 |
1748870 | 1748870 | 2021-09-24 | Madison | Georgia | 13195 | 4704 | 65 |
1749054 | 1749054 | 2021-09-24 | Montgomery | Illinois | 17135 | 4704 | 82 |
1738061 | 1738061 | 2021-09-20 | Cooke | Texas | 48097 | 4704 | 80 |
1734811 | 1734811 | 2021-09-19 | Cooke | Texas | 48097 | 4704 | 80 |
1731561 | 1731561 | 2021-09-18 | Cooke | Texas | 48097 | 4704 | 80 |
1715207 | 1715207 | 2021-09-13 | Hardeman | Tennessee | 47069 | 4704 | 70 |
1649543 | 1649543 | 2021-08-24 | Fulton | New York | 36035 | 4704 | 93 |
1633421 | 1633421 | 2021-08-19 | Stokes | North Carolina | 37169 | 4704 | 83 |
1622359 | 1622359 | 2021-08-16 | Monroe | Illinois | 17133 | 4704 | 96 |
1624473 | 1624473 | 2021-08-16 | Matagorda | Texas | 48321 | 4704 | 116 |
1617067 | 1617067 | 2021-08-14 | Madison | New York | 36053 | 4704 | 89 |
1587500 | 1587500 | 2021-08-05 | Howell | Missouri | 29091 | 4704 | 51 |
1578803 | 1578803 | 2021-08-02 | Obion | Tennessee | 47131 | 4704 | 98 |
1519220 | 1519220 | 2021-07-15 | Oktibbeha | Mississippi | 28105 | 4704 | 98 |
1489360 | 1489360 | 2021-07-06 | Des Moines | Iowa | 19057 | 4704 | 73 |
1425888 | 1425888 | 2021-06-16 | Bedford | Pennsylvania | 42009 | 4704 | 141 |
1386050 | 1386050 | 2021-06-04 | Mower | Minnesota | 27099 | 4704 | 33 |
1382805 | 1382805 | 2021-06-03 | Mower | Minnesota | 27099 | 4704 | 33 |
1380093 | 1380093 | 2021-06-02 | Beaufort | North Carolina | 37013 | 4704 | 97 |
1374807 | 1374807 | 2021-05-31 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1371562 | 1371562 | 2021-05-30 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1368316 | 1368316 | 2021-05-29 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1365070 | 1365070 | 2021-05-28 | Jefferson | West Virginia | 54037 | 4704 | 52 |
1347705 | 1347705 | 2021-05-23 | Richmond | North Carolina | 37153 | 4704 | 94 |
1344457 | 1344457 | 2021-05-22 | Richmond | North Carolina | 37153 | 4704 | 94 |
1341209 | 1341209 | 2021-05-21 | Richmond | North Carolina | 37153 | 4704 | 94 |
1337038 | 1337038 | 2021-05-20 | Jessamine | Kentucky | 21113 | 4704 | 64 |
1334080 | 1334080 | 2021-05-19 | Douglas | Minnesota | 27041 | 4704 | 76 |
1314846 | 1314846 | 2021-05-13 | Scott | Missouri | 29201 | 4704 | 84 |
1297236 | 1297236 | 2021-05-08 | Nevada | California | 6057 | 4704 | 75 |
1281415 | 1281415 | 2021-05-03 | Effingham | Illinois | 17049 | 4704 | 83 |
1283190 | 1283190 | 2021-05-03 | Toa Baja | Puerto Rico | 72137 | 4704 | |
1255728 | 1255728 | 2021-04-25 | Crawford | Kansas | 20037 | 4704 | 82 |
1256872 | 1256872 | 2021-04-25 | Williams | North Dakota | 38105 | 4704 | 38 |
1252481 | 1252481 | 2021-04-24 | Crawford | Kansas | 20037 | 4704 | 82 |
1249234 | 1249234 | 2021-04-23 | Crawford | Kansas | 20037 | 4704 | 82 |
1208168 | 1208168 | 2021-04-10 | Auglaize | Ohio | 39011 | 4704 | 84 |
1187173 | 1187173 | 2021-04-04 | Bingham | Idaho | 16011 | 4704 | 69 |
1183926 | 1183926 | 2021-04-03 | Bingham | Idaho | 16011 | 4704 | 69 |
1178464 | 1178464 | 2021-04-01 | Scott | Missouri | 29201 | 4704 | 83 |
1175217 | 1175217 | 2021-03-31 | Scott | Missouri | 29201 | 4704 | 83 |
1147881 | 1147881 | 2021-03-23 | Tehama | California | 6103 | 4704 | 45 |
1122681 | 1122681 | 2021-03-15 | Boyd | Kentucky | 21019 | 4704 | 47 |
1101163 | 1101163 | 2021-03-08 | Stephens | Oklahoma | 40137 | 4704 | 68 |
1097917 | 1097917 | 2021-03-07 | Stephens | Oklahoma | 40137 | 4704 | 68 |
1079996 | 1079996 | 2021-03-02 | Tift | Georgia | 13277 | 4704 | 120 |
1079360 | 1079360 | 2021-03-01 | Raleigh | West Virginia | 54081 | 4704 | 58 |
1040661 | 1040661 | 2021-02-18 | Hot Spring | Arkansas | 5059 | 4704 | 68 |
1031664 | 1031664 | 2021-02-15 | Sioux | Iowa | 19167 | 4704 | 67 |
938821 | 938821 | 2021-01-17 | Cherokee | Oklahoma | 40021 | 4704 | 25 |
929363 | 929363 | 2021-01-14 | Georgetown | South Carolina | 45043 | 4704 | 97 |
818823 | 818823 | 2020-12-11 | Jackson | Oregon | 41029 | 4704 | 48 |
779287 | 779287 | 2020-11-29 | Missoula | Montana | 30063 | 4704 | 43 |
764485 | 764485 | 2020-11-24 | Grant | Washington | 53025 | 4704 | 32 |
741881 | 741881 | 2020-11-17 | Manitowoc | Wisconsin | 55071 | 4704 | 33 |
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);