ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 5263 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 8
- Mississippi 8
- Florida 7
- Georgia 4
- Michigan 4
- Missouri 4
- North Carolina 4
- Tennessee 4
- Indiana 3
- Kansas 3
- Kentucky 3
- New Mexico 3
- New York 3
- Puerto Rico 3
- Illinois 2
- Maryland 2
- Minnesota 2
- North Dakota 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Idaho 1
- Iowa 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495949 | 2495949 | 2022-05-11 | Carbon | Utah | 49007 | 5263 | 46 |
2483339 | 2483339 | 2022-05-08 | Pickens | Alabama | 1107 | 5263 | 102 |
2480081 | 2480081 | 2022-05-07 | Pickens | Alabama | 1107 | 5263 | 102 |
2476823 | 2476823 | 2022-05-06 | Pickens | Alabama | 1107 | 5263 | 102 |
2475407 | 2475407 | 2022-05-05 | Schoharie | New York | 36095 | 5263 | 36 |
2361977 | 2361977 | 2022-03-31 | San Lorenzo | Puerto Rico | 72129 | 5263 | |
2358016 | 2358016 | 2022-03-30 | Dawson | Nebraska | 31047 | 5263 | 42 |
2358246 | 2358246 | 2022-03-30 | Caswell | North Carolina | 37033 | 5263 | 44 |
2310826 | 2310826 | 2022-03-16 | Monroe | Alabama | 1099 | 5263 | 80 |
2290989 | 2290989 | 2022-03-09 | Fredericksburg city | Virginia | 51630 | 5263 | 34 |
2286606 | 2286606 | 2022-03-08 | Taos | New Mexico | 35055 | 5263 | 89 |
2235566 | 2235566 | 2022-02-20 | San Jacinto | Texas | 48407 | 5263 | 98 |
2213922 | 2213922 | 2022-02-14 | Union | Illinois | 17181 | 5263 | 67 |
2199720 | 2199720 | 2022-02-09 | Karnes | Texas | 48255 | 5263 | 63 |
2188419 | 2188419 | 2022-02-06 | Garrett | Maryland | 24023 | 5263 | 110 |
2171403 | 2171403 | 2022-02-01 | Haralson | Georgia | 13143 | 5263 | 145 |
2172211 | 2172211 | 2022-02-01 | Gladwin | Michigan | 26051 | 5263 | 105 |
2172289 | 2172289 | 2022-02-01 | Dodge | Minnesota | 27039 | 5263 | 15 |
2167691 | 2167691 | 2022-01-31 | Barbour | Alabama | 1005 | 5263 | 84 |
2168958 | 2168958 | 2022-01-31 | Gladwin | Michigan | 26051 | 5263 | 105 |
2163225 | 2163225 | 2022-01-29 | Rolette | North Dakota | 38079 | 5263 | 39 |
2012635 | 2012635 | 2021-12-14 | Clay | Kentucky | 21051 | 5263 | 65 |
1965430 | 1965430 | 2021-11-29 | Lauderdale | Tennessee | 47097 | 5263 | 70 |
1948916 | 1948916 | 2021-11-24 | Snyder | Pennsylvania | 42109 | 5263 | 110 |
1949624 | 1949624 | 2021-11-24 | Prince George | Virginia | 51149 | 5263 | 51 |
1943649 | 1943649 | 2021-11-23 | Summit | Colorado | 8117 | 5263 | 12 |
1930186 | 1930186 | 2021-11-18 | Stevens | Washington | 53065 | 5263 | 99 |
1917367 | 1917367 | 2021-11-15 | Dallas | Alabama | 1047 | 5263 | 207 |
1914117 | 1914117 | 2021-11-14 | Dallas | Alabama | 1047 | 5263 | 207 |
1909451 | 1909451 | 2021-11-12 | Columbia | New York | 36021 | 5263 | 113 |
1898589 | 1898589 | 2021-11-09 | Jefferson | Indiana | 18077 | 5263 | 103 |
1790811 | 1790811 | 2021-10-07 | Amador | California | 6005 | 5263 | 62 |
1792282 | 1792282 | 2021-10-07 | Silver Bow | Montana | 30093 | 5263 | 96 |
1778539 | 1778539 | 2021-10-03 | Cowley | Kansas | 20035 | 5263 | 122 |
1775289 | 1775289 | 2021-10-02 | Cowley | Kansas | 20035 | 5263 | 122 |
1772039 | 1772039 | 2021-10-01 | Cowley | Kansas | 20035 | 5263 | 122 |
1755418 | 1755418 | 2021-09-26 | Upson | Georgia | 13293 | 5263 | 152 |
1752170 | 1752170 | 2021-09-25 | Upson | Georgia | 13293 | 5263 | 152 |
1748921 | 1748921 | 2021-09-24 | Upson | Georgia | 13293 | 5263 | 152 |
1736068 | 1736068 | 2021-09-20 | Randolph | Illinois | 17157 | 5263 | 103 |
1736846 | 1736846 | 2021-09-20 | Lincoln | Mississippi | 28085 | 5263 | 131 |
1677297 | 1677297 | 2021-09-02 | Wakulla | Florida | 12129 | 5263 | 56 |
1673692 | 1673692 | 2021-09-01 | Franklin | Alabama | 1059 | 5263 | 89 |
1674050 | 1674050 | 2021-09-01 | Wakulla | Florida | 12129 | 5263 | 56 |
1670802 | 1670802 | 2021-08-31 | Wakulla | Florida | 12129 | 5263 | 56 |
1667555 | 1667555 | 2021-08-30 | Wakulla | Florida | 12129 | 5263 | 56 |
1664308 | 1664308 | 2021-08-29 | Wakulla | Florida | 12129 | 5263 | 56 |
1661060 | 1661060 | 2021-08-28 | Wakulla | Florida | 12129 | 5263 | 56 |
1657812 | 1657812 | 2021-08-27 | Wakulla | Florida | 12129 | 5263 | 56 |
1619908 | 1619908 | 2021-08-15 | Neshoba | Mississippi | 28099 | 5263 | 182 |
1616660 | 1616660 | 2021-08-14 | Neshoba | Mississippi | 28099 | 5263 | 182 |
1613412 | 1613412 | 2021-08-13 | Neshoba | Mississippi | 28099 | 5263 | 182 |
1574828 | 1574828 | 2021-08-01 | Herkimer | New York | 36043 | 5263 | 110 |
1552293 | 1552293 | 2021-07-25 | Athens | Ohio | 39009 | 5263 | 60 |
1549046 | 1549046 | 2021-07-24 | Athens | Ohio | 39009 | 5263 | 60 |
1506277 | 1506277 | 2021-07-11 | Callaway | Missouri | 29027 | 5263 | 51 |
1493701 | 1493701 | 2021-07-07 | Carteret | North Carolina | 37031 | 5263 | 55 |
1490113 | 1490113 | 2021-07-06 | Pettis | Missouri | 29159 | 5263 | 77 |
1490454 | 1490454 | 2021-07-06 | Carteret | North Carolina | 37031 | 5263 | 55 |
1405965 | 1405965 | 2021-06-10 | Curry | New Mexico | 35009 | 5263 | 84 |
1397641 | 1397641 | 2021-06-07 | Fremont | Wyoming | 56013 | 5263 | 84 |
1352107 | 1352107 | 2021-05-24 | Putnam | West Virginia | 54079 | 5263 | 93 |
1308794 | 1308794 | 2021-05-11 | Morton | North Dakota | 38059 | 5263 | 100 |
1282395 | 1282395 | 2021-05-03 | Taney | Missouri | 29213 | 5263 | 92 |
1168619 | 1168619 | 2021-03-29 | Washington | Mississippi | 28151 | 5263 | 132 |
1165371 | 1165371 | 2021-03-28 | Washington | Mississippi | 28151 | 5263 | 132 |
1162123 | 1162123 | 2021-03-27 | Washington | Mississippi | 28151 | 5263 | 132 |
1158875 | 1158875 | 2021-03-26 | Washington | Mississippi | 28151 | 5263 | 132 |
1135980 | 1135980 | 2021-03-19 | Van Buren | Michigan | 26159 | 5263 | 98 |
1119645 | 1119645 | 2021-03-14 | St. Mary's | Maryland | 24037 | 5263 | 117 |
1087903 | 1087903 | 2021-03-04 | Granville | North Carolina | 37077 | 5263 | 76 |
1062584 | 1062584 | 2021-02-24 | Monroe | Tennessee | 47123 | 5263 | 89 |
1004191 | 1004191 | 2021-02-06 | Warren | Tennessee | 47177 | 5263 | 66 |
995819 | 995819 | 2021-02-04 | Henry | Indiana | 18065 | 5263 | 82 |
991745 | 991745 | 2021-02-02 | Barron | Wisconsin | 55005 | 5263 | 71 |
948999 | 948999 | 2021-01-20 | Roane | Tennessee | 47145 | 5263 | 79 |
912035 | 912035 | 2021-01-09 | Blue Earth | Minnesota | 27013 | 5263 | 32 |
853317 | 853317 | 2020-12-22 | Daviess | Kentucky | 21059 | 5263 | 76 |
836373 | 836373 | 2020-12-17 | Middlesex | Connecticut | 9007 | 5263 | 226 |
792966 | 792966 | 2020-12-03 | Carolina | Puerto Rico | 72031 | 5263 | |
787523 | 787523 | 2020-12-02 | Jefferson | Arkansas | 5069 | 5263 | 111 |
782727 | 782727 | 2020-11-30 | Santa Fe | New Mexico | 35049 | 5263 | 36 |
771902 | 771902 | 2020-11-27 | Madison | Indiana | 18095 | 5263 | 135 |
749687 | 749687 | 2020-11-20 | Calhoun | Michigan | 26025 | 5263 | 110 |
713325 | 713325 | 2020-11-09 | Kootenai | Idaho | 16055 | 5263 | 55 |
564451 | 564451 | 2020-09-24 | Woodbury | Iowa | 19193 | 5263 | 63 |
485058 | 485058 | 2020-08-30 | San Juan | Puerto Rico | 72127 | 5263 | |
394159 | 394159 | 2020-08-02 | Somerset | New Jersey | 34035 | 5263 | 555 |
377830 | 377830 | 2020-07-28 | Kansas City | Missouri | 5263 | 60 | |
368919 | 368919 | 2020-07-25 | Lancaster | Pennsylvania | 42071 | 5263 | 401 |
351675 | 351675 | 2020-07-20 | Jefferson | Kentucky | 21111 | 5263 | 232 |
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);