ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 3367 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 16
- Mississippi 9
- Georgia 7
- Minnesota 7
- Colorado 6
- Illinois 6
- Kansas 6
- Missouri 6
- Michigan 5
- Nevada 5
- North Carolina 5
- Puerto Rico 5
- Alabama 4
- Kentucky 4
- Oregon 4
- Virginia 4
- Arkansas 3
- Ohio 3
- Wisconsin 3
- Florida 2
- Indiana 2
- Pennsylvania 2
- South Dakota 2
- Texas 2
- Arizona 1
- California 1
- Iowa 1
- Massachusetts 1
- Nebraska 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499255 | 2499255 | 2022-05-12 | Alleghany | Virginia | 51005 | 3367 | 98 |
2490232 | 2490232 | 2022-05-10 | Dade | Georgia | 13083 | 3367 | 29 |
2486975 | 2486975 | 2022-05-09 | Dade | Georgia | 13083 | 3367 | 29 |
2451339 | 2451339 | 2022-04-28 | Cumberland | Illinois | 17035 | 3367 | 49 |
2416665 | 2416665 | 2022-04-17 | Unknown | Nebraska | 3367 | 459 | |
2392386 | 2392386 | 2022-04-10 | Gunnison | Colorado | 8051 | 3367 | 14 |
2389130 | 2389130 | 2022-04-09 | Gunnison | Colorado | 8051 | 3367 | 14 |
2385875 | 2385875 | 2022-04-08 | Gunnison | Colorado | 8051 | 3367 | 14 |
2370467 | 2370467 | 2022-04-03 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2367214 | 2367214 | 2022-04-02 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2363961 | 2363961 | 2022-04-01 | Caldwell | Louisiana | 22021 | 3367 | 55 |
2360707 | 2360707 | 2022-03-31 | Caldwell | Louisiana | 22021 | 3367 | 54 |
2274607 | 2274607 | 2022-03-04 | Tyler | Texas | 48457 | 3367 | 83 |
2224215 | 2224215 | 2022-02-17 | Dukes | Massachusetts | 25007 | 3367 | 0 |
2217578 | 2217578 | 2022-02-15 | Pendleton | Kentucky | 21191 | 3367 | 33 |
2214628 | 2214628 | 2022-02-14 | Sibley | Minnesota | 27143 | 3367 | 23 |
2195831 | 2195831 | 2022-02-08 | Monroe | Ohio | 39111 | 3367 | 69 |
2188487 | 2188487 | 2022-02-06 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2189463 | 2189463 | 2022-02-06 | Tillamook | Oregon | 41057 | 3367 | 55 |
2185234 | 2185234 | 2022-02-05 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2186210 | 2186210 | 2022-02-05 | Tillamook | Oregon | 41057 | 3367 | 55 |
2181982 | 2181982 | 2022-02-04 | Kalkaska | Michigan | 26079 | 3367 | 50 |
2182958 | 2182958 | 2022-02-04 | Tillamook | Oregon | 41057 | 3367 | 55 |
2177131 | 2177131 | 2022-02-02 | Appomattox | Virginia | 51011 | 3367 | 44 |
2164448 | 2164448 | 2022-01-30 | Cleburne | Alabama | 1029 | 3367 | 63 |
2160318 | 2160318 | 2022-01-28 | Quebradillas | Puerto Rico | 72115 | 3367 | |
2147288 | 2147288 | 2022-01-24 | Lares | Puerto Rico | 72081 | 3367 | |
2109800 | 2109800 | 2022-01-13 | Moultrie | Illinois | 17139 | 3367 | 48 |
2061496 | 2061496 | 2021-12-29 | Concordia | Louisiana | 22029 | 3367 | 80 |
2028156 | 2028156 | 2021-12-19 | Pitkin | Colorado | 8097 | 3367 | 6 |
2024905 | 2024905 | 2021-12-18 | Pitkin | Colorado | 8097 | 3367 | 6 |
2021654 | 2021654 | 2021-12-17 | Pitkin | Colorado | 8097 | 3367 | 6 |
1959720 | 1959720 | 2021-11-28 | Clark | Arkansas | 5019 | 3367 | 61 |
1860300 | 1860300 | 2021-10-28 | Jasper | Mississippi | 28061 | 3367 | 65 |
1796227 | 1796227 | 2021-10-08 | Dorado | Puerto Rico | 72051 | 3367 | |
1781623 | 1781623 | 2021-10-04 | LaGrange | Indiana | 18087 | 3367 | 78 |
1782641 | 1782641 | 2021-10-04 | Churchill | Nevada | 32001 | 3367 | 57 |
1760656 | 1760656 | 2021-09-27 | Yankton | South Dakota | 46135 | 3367 | 36 |
1761124 | 1761124 | 2021-09-27 | Lee | Virginia | 51105 | 3367 | 52 |
1727926 | 1727926 | 2021-09-17 | Elk | Pennsylvania | 42047 | 3367 | 46 |
1721073 | 1721073 | 2021-09-15 | Dare | North Carolina | 37055 | 3367 | 11 |
1714637 | 1714637 | 2021-09-13 | Transylvania | North Carolina | 37175 | 3367 | 36 |
1694199 | 1694199 | 2021-09-07 | Grant | Kentucky | 21081 | 3367 | 27 |
1694594 | 1694594 | 2021-09-07 | Grenada | Mississippi | 28043 | 3367 | 96 |
1675127 | 1675127 | 2021-09-01 | Newton | Mississippi | 28101 | 3367 | 67 |
1671590 | 1671590 | 2021-08-31 | Union | Louisiana | 22111 | 3367 | 90 |
1668343 | 1668343 | 2021-08-30 | Union | Louisiana | 22111 | 3367 | 90 |
1665096 | 1665096 | 2021-08-29 | Union | Louisiana | 22111 | 3367 | 90 |
1661848 | 1661848 | 2021-08-28 | Union | Louisiana | 22111 | 3367 | 90 |
1658600 | 1658600 | 2021-08-27 | Union | Louisiana | 22111 | 3367 | 90 |
1630286 | 1630286 | 2021-08-18 | Jackson | Ohio | 39079 | 3367 | 54 |
1605885 | 1605885 | 2021-08-11 | Decatur | Georgia | 13087 | 3367 | 78 |
1597083 | 1597083 | 2021-08-08 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1597134 | 1597134 | 2021-08-08 | Copiah | Mississippi | 28029 | 3367 | 69 |
1593834 | 1593834 | 2021-08-07 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1593885 | 1593885 | 2021-08-07 | Copiah | Mississippi | 28029 | 3367 | 69 |
1590585 | 1590585 | 2021-08-06 | Nicollet | Minnesota | 27103 | 3367 | 45 |
1590636 | 1590636 | 2021-08-06 | Copiah | Mississippi | 28029 | 3367 | 69 |
1590738 | 1590738 | 2021-08-06 | Dunklin | Missouri | 29069 | 3367 | 50 |
1587112 | 1587112 | 2021-08-05 | Morehouse | Louisiana | 22067 | 3367 | 80 |
1556656 | 1556656 | 2021-07-26 | Juneau | Wisconsin | 55057 | 3367 | 31 |
1545285 | 1545285 | 2021-07-23 | Lafayette | Missouri | 29107 | 3367 | 57 |
1532127 | 1532127 | 2021-07-19 | Pine | Minnesota | 27115 | 3367 | 23 |
1505894 | 1505894 | 2021-07-11 | Beauregard | Louisiana | 22011 | 3367 | 79 |
1502648 | 1502648 | 2021-07-10 | Beauregard | Louisiana | 22011 | 3367 | 79 |
1499402 | 1499402 | 2021-07-09 | Beauregard | Louisiana | 22011 | 3367 | 79 |
1501028 | 1501028 | 2021-07-09 | Kendall | Texas | 48259 | 3367 | 72 |
1487061 | 1487061 | 2021-07-05 | Lyon | Nevada | 32019 | 3367 | 65 |
1483815 | 1483815 | 2021-07-04 | Lyon | Nevada | 32019 | 3367 | 65 |
1480569 | 1480569 | 2021-07-03 | Lyon | Nevada | 32019 | 3367 | 65 |
1477322 | 1477322 | 2021-07-02 | Lyon | Nevada | 32019 | 3367 | 65 |
1418083 | 1418083 | 2021-06-14 | McPherson | Kansas | 20113 | 3367 | 89 |
1414837 | 1414837 | 2021-06-13 | McPherson | Kansas | 20113 | 3367 | 89 |
1411592 | 1411592 | 2021-06-12 | McPherson | Kansas | 20113 | 3367 | 89 |
1408347 | 1408347 | 2021-06-11 | McPherson | Kansas | 20113 | 3367 | 89 |
1401963 | 1401963 | 2021-06-09 | Knox | Kentucky | 21121 | 3367 | 44 |
1395471 | 1395471 | 2021-06-07 | Knox | Kentucky | 21121 | 3367 | 44 |
1386225 | 1386225 | 2021-06-04 | Laclede | Missouri | 29105 | 3367 | 70 |
1308734 | 1308734 | 2021-05-11 | Pasquotank | North Carolina | 37139 | 3367 | 80 |
1263645 | 1263645 | 2021-04-27 | Arecibo | Puerto Rico | 72013 | 3367 | |
1233868 | 1233868 | 2021-04-18 | Cheshire | New Hampshire | 33005 | 3367 | 33 |
1201657 | 1201657 | 2021-04-08 | Stutsman | North Dakota | 38093 | 3367 | 79 |
1190394 | 1190394 | 2021-04-05 | Upson | Georgia | 13293 | 3367 | 123 |
1157195 | 1157195 | 2021-03-25 | York | Virginia | 51199 | 3367 | 50 |
1141853 | 1141853 | 2021-03-21 | Adams | Indiana | 18001 | 3367 | 52 |
1125874 | 1125874 | 2021-03-16 | Montgomery | Kansas | 20125 | 3367 | 6 |
1122075 | 1122075 | 2021-03-15 | Bryan | Georgia | 13029 | 3367 | 35 |
1122628 | 1122628 | 2021-03-15 | Montgomery | Kansas | 20125 | 3367 | 6 |
1118828 | 1118828 | 2021-03-14 | Bryan | Georgia | 13029 | 3367 | 35 |
1110237 | 1110237 | 2021-03-11 | Lawrence | Missouri | 29109 | 3367 | 77 |
1104441 | 1104441 | 2021-03-09 | Malheur | Oregon | 41045 | 3367 | 58 |
1086613 | 1086613 | 2021-03-04 | Lee | Illinois | 17103 | 3367 | 82 |
1071062 | 1071062 | 2021-02-27 | Beltrami | Minnesota | 27007 | 3367 | 51 |
1071188 | 1071188 | 2021-02-27 | Leflore | Mississippi | 28083 | 3367 | 118 |
1053514 | 1053514 | 2021-02-22 | Chambers | Alabama | 1017 | 3367 | 99 |
1050267 | 1050267 | 2021-02-21 | Chambers | Alabama | 1017 | 3367 | 99 |
1045662 | 1045662 | 2021-02-19 | Tompkins | New York | 36109 | 3367 | 42 |
1021237 | 1021237 | 2021-02-12 | Amador | California | 6005 | 3367 | 37 |
1017816 | 1017816 | 2021-02-11 | Clarke | Alabama | 1025 | 3367 | 43 |
1016775 | 1016775 | 2021-02-10 | Texas | Oklahoma | 40139 | 3367 | 22 |
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);