ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 4703 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 9
- Georgia 8
- Illinois 7
- Kansas 7
- Mississippi 5
- North Carolina 4
- Tennessee 4
- Texas 4
- Alabama 3
- Kentucky 3
- Louisiana 3
- Ohio 3
- Pennsylvania 3
- South Carolina 3
- Virginia 3
- Wisconsin 3
- Arkansas 2
- Iowa 2
- Missouri 2
- Puerto Rico 2
- California 1
- Colorado 1
- Florida 1
- Indiana 1
- Maine 1
- Maryland 1
- Michigan 1
- Nebraska 1
- North Dakota 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353100 | 2353100 | 2022-03-29 | Hale | Alabama | 1065 | 4703 | 105 |
2327310 | 2327310 | 2022-03-21 | Elbert | Colorado | 8039 | 4703 | 37 |
2259523 | 2259523 | 2022-02-28 | Starke | Indiana | 18149 | 4703 | 93 |
2248441 | 2248441 | 2022-02-24 | Fayette | Texas | 48149 | 4703 | 99 |
2226398 | 2226398 | 2022-02-18 | Phillips | Arkansas | 5107 | 4703 | 89 |
2177923 | 2177923 | 2022-02-03 | Lamar | Georgia | 13171 | 4703 | 105 |
2145358 | 2145358 | 2022-01-24 | Fannin | Georgia | 13111 | 4703 | 124 |
2127082 | 2127082 | 2022-01-18 | Dawson | Nebraska | 31047 | 4703 | 38 |
2118747 | 2118747 | 2022-01-15 | Hampshire | West Virginia | 54027 | 4703 | 60 |
2104125 | 2104125 | 2022-01-11 | Adair | Missouri | 29001 | 4703 | 54 |
2066558 | 2066558 | 2021-12-30 | Carroll | Virginia | 51035 | 4703 | 113 |
1987205 | 1987205 | 2021-12-06 | Stoddard | Missouri | 29207 | 4703 | 106 |
1978191 | 1978191 | 2021-12-03 | Arecibo | Puerto Rico | 72013 | 4703 | |
1915551 | 1915551 | 2021-11-14 | Leflore | Mississippi | 28083 | 4703 | 144 |
1912301 | 1912301 | 2021-11-13 | Leflore | Mississippi | 28083 | 4703 | 144 |
1909051 | 1909051 | 2021-11-12 | Leflore | Mississippi | 28083 | 4703 | 144 |
1904385 | 1904385 | 2021-11-11 | Lawrence | Alabama | 1079 | 4703 | 125 |
1869052 | 1869052 | 2021-10-31 | Gilmer | Georgia | 13123 | 4703 | 135 |
1865803 | 1865803 | 2021-10-30 | Gilmer | Georgia | 13123 | 4703 | 135 |
1862554 | 1862554 | 2021-10-29 | Gilmer | Georgia | 13123 | 4703 | 135 |
1853340 | 1853340 | 2021-10-26 | Seward | Kansas | 20175 | 4703 | 47 |
1850091 | 1850091 | 2021-10-25 | Seward | Kansas | 20175 | 4703 | 47 |
1850255 | 1850255 | 2021-10-25 | Jefferson Davis | Louisiana | 22053 | 4703 | 126 |
1850592 | 1850592 | 2021-10-25 | Tippah | Mississippi | 28139 | 4703 | 81 |
1846841 | 1846841 | 2021-10-24 | Seward | Kansas | 20175 | 4703 | 47 |
1843591 | 1843591 | 2021-10-23 | Seward | Kansas | 20175 | 4703 | 47 |
1840341 | 1840341 | 2021-10-22 | Seward | Kansas | 20175 | 4703 | 47 |
1837092 | 1837092 | 2021-10-21 | Seward | Kansas | 20175 | 4703 | 47 |
1833843 | 1833843 | 2021-10-20 | Seward | Kansas | 20175 | 4703 | 47 |
1829524 | 1829524 | 2021-10-18 | Clark | Wisconsin | 55019 | 4703 | 76 |
1811594 | 1811594 | 2021-10-13 | Scott | Mississippi | 28123 | 4703 | 98 |
1802818 | 1802818 | 2021-10-10 | Marlboro | South Carolina | 45069 | 4703 | 75 |
1799569 | 1799569 | 2021-10-09 | Marlboro | South Carolina | 45069 | 4703 | 75 |
1796320 | 1796320 | 2021-10-08 | Marlboro | South Carolina | 45069 | 4703 | 75 |
1746207 | 1746207 | 2021-09-23 | Logan | Kentucky | 21141 | 4703 | 77 |
1743977 | 1743977 | 2021-09-22 | Guernsey | Ohio | 39059 | 4703 | 64 |
1674869 | 1674869 | 2021-09-01 | Calvert | Maryland | 24009 | 4703 | 89 |
1649790 | 1649790 | 2021-08-24 | Madison | Ohio | 39097 | 4703 | 65 |
1621029 | 1621029 | 2021-08-15 | Marshall | Tennessee | 47117 | 4703 | 65 |
1617781 | 1617781 | 2021-08-14 | Marshall | Tennessee | 47117 | 4703 | 65 |
1614533 | 1614533 | 2021-08-13 | Marshall | Tennessee | 47117 | 4703 | 65 |
1573602 | 1573602 | 2021-08-01 | Jefferson | Illinois | 17081 | 4703 | 124 |
1570354 | 1570354 | 2021-07-31 | Jefferson | Illinois | 17081 | 4703 | 124 |
1567106 | 1567106 | 2021-07-30 | Jefferson | Illinois | 17081 | 4703 | 124 |
1513470 | 1513470 | 2021-07-13 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1514046 | 1514046 | 2021-07-13 | Medina | Texas | 48325 | 4703 | 107 |
1510224 | 1510224 | 2021-07-12 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1506977 | 1506977 | 2021-07-11 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1503731 | 1503731 | 2021-07-10 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1500485 | 1500485 | 2021-07-09 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1495227 | 1495227 | 2021-07-08 | Humboldt | California | 6023 | 4703 | 51 |
1497239 | 1497239 | 2021-07-08 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1493992 | 1493992 | 2021-07-07 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1486113 | 1486113 | 2021-07-05 | Des Moines | Iowa | 19057 | 4703 | 73 |
1482867 | 1482867 | 2021-07-04 | Des Moines | Iowa | 19057 | 4703 | 73 |
1471793 | 1471793 | 2021-06-30 | Howard | Texas | 48227 | 4703 | 102 |
1442806 | 1442806 | 2021-06-21 | Culpeper | Virginia | 51047 | 4703 | 67 |
1436314 | 1436314 | 2021-06-19 | Culpeper | Virginia | 51047 | 4703 | 67 |
1429769 | 1429769 | 2021-06-17 | Wasatch | Utah | 49051 | 4703 | 22 |
1411079 | 1411079 | 2021-06-12 | Effingham | Georgia | 13103 | 4703 | 72 |
1384618 | 1384618 | 2021-06-03 | Marinette | Wisconsin | 55075 | 4703 | 72 |
1291700 | 1291700 | 2021-05-06 | St. Mary | Louisiana | 22101 | 4703 | 137 |
1278168 | 1278168 | 2021-05-02 | Effingham | Illinois | 17049 | 4703 | 83 |
1274643 | 1274643 | 2021-05-01 | Hendry | Florida | 12051 | 4703 | 82 |
1268853 | 1268853 | 2021-04-29 | Henderson | Kentucky | 21101 | 4703 | 75 |
1269851 | 1269851 | 2021-04-29 | Stark | North Dakota | 38089 | 4703 | 51 |
1224455 | 1224455 | 2021-04-15 | Mercer | Ohio | 39107 | 4703 | 84 |
1202008 | 1202008 | 2021-04-08 | Unknown | Puerto Rico | 4703 | 2141 | |
1195833 | 1195833 | 2021-04-06 | Harrison | Texas | 48203 | 4703 | 105 |
1146703 | 1146703 | 2021-03-22 | Mifflin | Pennsylvania | 42087 | 4703 | 175 |
1131949 | 1131949 | 2021-03-18 | Ware | Georgia | 13299 | 4703 | 156 |
1119434 | 1119434 | 2021-03-14 | Boyd | Kentucky | 21019 | 4703 | 47 |
1094669 | 1094669 | 2021-03-06 | Stephens | Oklahoma | 40137 | 4703 | 68 |
1087897 | 1087897 | 2021-03-04 | Edgecombe | North Carolina | 37065 | 4703 | 100 |
1043906 | 1043906 | 2021-02-19 | Hot Spring | Arkansas | 5059 | 4703 | 68 |
1045728 | 1045728 | 2021-02-19 | McDowell | North Carolina | 37111 | 4703 | 55 |
976929 | 976929 | 2021-01-29 | Van Buren | Michigan | 26159 | 4703 | 92 |
958724 | 958724 | 2021-01-23 | Monroe | Tennessee | 47123 | 4703 | 63 |
943768 | 943768 | 2021-01-19 | Coles | Illinois | 17029 | 4703 | 80 |
933842 | 933842 | 2021-01-16 | Coffee | Georgia | 13069 | 4703 | 110 |
876204 | 876204 | 2020-12-29 | York | Maine | 23031 | 4703 | 60 |
852985 | 852985 | 2020-12-22 | Whiteside | Illinois | 17195 | 4703 | 154 |
854258 | 854258 | 2020-12-22 | Orange | North Carolina | 37135 | 4703 | 63 |
849078 | 849078 | 2020-12-21 | Jackson | Alabama | 1071 | 4703 | 31 |
832728 | 832728 | 2020-12-15 | Calumet | Wisconsin | 55015 | 4703 | 31 |
809060 | 809060 | 2020-12-08 | Rogers | Oklahoma | 40131 | 4703 | 69 |
687971 | 687971 | 2020-11-01 | Unknown | Louisiana | 4703 | 214 | |
643679 | 643679 | 2020-10-18 | Luzerne | Pennsylvania | 42079 | 4703 | 190 |
573893 | 573893 | 2020-09-27 | Champaign | Illinois | 17019 | 4703 | 20 |
381419 | 381419 | 2020-07-29 | Forsyth | North Carolina | 37067 | 4703 | 49 |
375347 | 375347 | 2020-07-27 | Lehigh | Pennsylvania | 42077 | 4703 | 335 |
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);