ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 5081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Illinois 8
- Iowa 8
- Alabama 7
- Georgia 5
- Wyoming 5
- Michigan 4
- Ohio 4
- Arkansas 3
- Pennsylvania 3
- South Carolina 3
- Virginia 3
- Wisconsin 3
- Florida 2
- Indiana 2
- Louisiana 2
- Missouri 2
- New Mexico 2
- New York 2
- North Dakota 2
- Puerto Rico 2
- Tennessee 2
- California 1
- Colorado 1
- Maryland 1
- Massachusetts 1
- Mississippi 1
- New Hampshire 1
- North Carolina 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489542 | 2489542 | 2022-05-09 | King George | Virginia | 51099 | 5081 | 38 |
2430706 | 2430706 | 2022-04-21 | Limestone | Texas | 48293 | 5081 | 124 |
2427450 | 2427450 | 2022-04-20 | Limestone | Texas | 48293 | 5081 | 124 |
2416799 | 2416799 | 2022-04-17 | Schoharie | New York | 36095 | 5081 | 36 |
2400962 | 2400962 | 2022-04-12 | Wyoming | Pennsylvania | 42131 | 5081 | 104 |
2392170 | 2392170 | 2022-04-10 | Randolph | Alabama | 1111 | 5081 | 74 |
2388914 | 2388914 | 2022-04-09 | Randolph | Alabama | 1111 | 5081 | 74 |
2385659 | 2385659 | 2022-04-08 | Randolph | Alabama | 1111 | 5081 | 74 |
2382404 | 2382404 | 2022-04-07 | Randolph | Alabama | 1111 | 5081 | 74 |
2385532 | 2385532 | 2022-04-07 | Green Lake | Wisconsin | 55047 | 5081 | 63 |
2379149 | 2379149 | 2022-04-06 | Randolph | Alabama | 1111 | 5081 | 74 |
2377805 | 2377805 | 2022-04-05 | Madison | North Carolina | 37115 | 5081 | 80 |
2372643 | 2372643 | 2022-04-04 | Randolph | Alabama | 1111 | 5081 | 74 |
2373110 | 2373110 | 2022-04-04 | Tattnall | Georgia | 13267 | 5081 | 130 |
2308660 | 2308660 | 2022-03-15 | Concordia | Louisiana | 22029 | 5081 | 89 |
2305409 | 2305409 | 2022-03-14 | Concordia | Louisiana | 22029 | 5081 | 89 |
2291377 | 2291377 | 2022-03-10 | Ashley | Arkansas | 5003 | 5081 | 62 |
2290277 | 2290277 | 2022-03-09 | Wasco | Oregon | 41065 | 5081 | 56 |
2221561 | 2221561 | 2022-02-16 | Lincoln | New Mexico | 35027 | 5081 | 60 |
2216411 | 2216411 | 2022-02-14 | Iowa | Wisconsin | 55049 | 5081 | 25 |
2206845 | 2206845 | 2022-02-12 | Clark | Arkansas | 5019 | 5081 | 73 |
2205850 | 2205850 | 2022-02-11 | Las Piedras | Puerto Rico | 72085 | 5081 | |
2195555 | 2195555 | 2022-02-08 | Taos | New Mexico | 35055 | 5081 | 82 |
2151414 | 2151414 | 2022-01-25 | Uinta | Wyoming | 56041 | 5081 | 34 |
2097432 | 2097432 | 2022-01-09 | Oceana | Michigan | 26127 | 5081 | 84 |
2094180 | 2094180 | 2022-01-08 | Oceana | Michigan | 26127 | 5081 | 84 |
2090928 | 2090928 | 2022-01-07 | Oceana | Michigan | 26127 | 5081 | 84 |
2033165 | 2033165 | 2021-12-20 | Stutsman | North Dakota | 38093 | 5081 | 92 |
2029915 | 2029915 | 2021-12-19 | Stutsman | North Dakota | 38093 | 5081 | 92 |
1974385 | 1974385 | 2021-12-02 | Carroll | New Hampshire | 33003 | 5081 | 23 |
1956515 | 1956515 | 2021-11-27 | Poinsett | Arkansas | 5111 | 5081 | 102 |
1902324 | 1902324 | 2021-11-10 | Worcester | Maryland | 24047 | 5081 | 123 |
1890220 | 1890220 | 2021-11-06 | Ottawa | Ohio | 39123 | 5081 | 90 |
1871031 | 1871031 | 2021-10-31 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1867782 | 1867782 | 2021-10-30 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1864533 | 1864533 | 2021-10-29 | Clarendon | South Carolina | 45027 | 5081 | 136 |
1860711 | 1860711 | 2021-10-28 | Columbia | New York | 36021 | 5081 | 112 |
1862094 | 1862094 | 2021-10-28 | Park | Wyoming | 56029 | 5081 | 70 |
1853215 | 1853215 | 2021-10-26 | Marion | Iowa | 19125 | 5081 | 91 |
1849966 | 1849966 | 2021-10-25 | Marion | Iowa | 19125 | 5081 | 91 |
1851780 | 1851780 | 2021-10-25 | Cooke | Texas | 48097 | 5081 | 100 |
1846716 | 1846716 | 2021-10-24 | Marion | Iowa | 19125 | 5081 | 91 |
1848530 | 1848530 | 2021-10-24 | Cooke | Texas | 48097 | 5081 | 100 |
1843466 | 1843466 | 2021-10-23 | Marion | Iowa | 19125 | 5081 | 91 |
1845280 | 1845280 | 2021-10-23 | Cooke | Texas | 48097 | 5081 | 99 |
1840216 | 1840216 | 2021-10-22 | Marion | Iowa | 19125 | 5081 | 91 |
1836967 | 1836967 | 2021-10-21 | Marion | Iowa | 19125 | 5081 | 91 |
1833718 | 1833718 | 2021-10-20 | Marion | Iowa | 19125 | 5081 | 91 |
1812265 | 1812265 | 2021-10-13 | Williams | Ohio | 39171 | 5081 | 84 |
1805201 | 1805201 | 2021-10-11 | Pulaski | Missouri | 29169 | 5081 | 75 |
1788934 | 1788934 | 2021-10-06 | Marion | Missouri | 29127 | 5081 | 58 |
1762048 | 1762048 | 2021-09-28 | Morgan | Illinois | 17137 | 5081 | 117 |
1742554 | 1742554 | 2021-09-22 | Monroe | Illinois | 17133 | 5081 | 99 |
1716428 | 1716428 | 2021-09-14 | Upson | Georgia | 13293 | 5081 | 138 |
1654801 | 1654801 | 2021-08-26 | Effingham | Illinois | 17049 | 5081 | 88 |
1657035 | 1657035 | 2021-08-26 | Waller | Texas | 48473 | 5081 | 56 |
1636818 | 1636818 | 2021-08-20 | Shelby | Ohio | 39149 | 5081 | 98 |
1599611 | 1599611 | 2021-08-09 | Marion | Illinois | 17121 | 5081 | 126 |
1562914 | 1562914 | 2021-07-28 | Campbell | Virginia | 51031 | 5081 | 103 |
1534486 | 1534486 | 2021-07-20 | Murray | Georgia | 13213 | 5081 | 92 |
1472941 | 1472941 | 2021-07-01 | Henry | Illinois | 17073 | 5081 | 99 |
1450224 | 1450224 | 2021-06-24 | Henry | Illinois | 17073 | 5081 | 99 |
1446979 | 1446979 | 2021-06-23 | Henry | Illinois | 17073 | 5081 | 99 |
1404886 | 1404886 | 2021-06-10 | Jackson | Indiana | 18071 | 5081 | 75 |
1381667 | 1381667 | 2021-06-03 | Tehama | California | 6103 | 5081 | 63 |
1257176 | 1257176 | 2021-04-25 | Guaynabo | Puerto Rico | 72061 | 5081 | |
1224894 | 1224894 | 2021-04-15 | Franklin | Tennessee | 47051 | 5081 | 88 |
1217100 | 1217100 | 2021-04-13 | Branch | Michigan | 26023 | 5081 | 114 |
1189842 | 1189842 | 2021-04-04 | Fremont | Wyoming | 56013 | 5081 | 82 |
1186595 | 1186595 | 2021-04-03 | Fremont | Wyoming | 56013 | 5081 | 82 |
1183348 | 1183348 | 2021-04-02 | Fremont | Wyoming | 56013 | 5081 | 82 |
1157251 | 1157251 | 2021-03-25 | Harrison | West Virginia | 54033 | 5081 | 77 |
1153156 | 1153156 | 2021-03-24 | Armstrong | Pennsylvania | 42005 | 5081 | 119 |
1148291 | 1148291 | 2021-03-23 | Knox | Illinois | 17095 | 5081 | 164 |
1131089 | 1131089 | 2021-03-17 | Albemarle | Virginia | 51003 | 5081 | 77 |
1125734 | 1125734 | 2021-03-16 | Clinton | Iowa | 19045 | 5081 | 87 |
1075272 | 1075272 | 2021-02-28 | Indiana | Pennsylvania | 42063 | 5081 | 159 |
1070000 | 1070000 | 2021-02-27 | Garfield | Colorado | 8045 | 5081 | 38 |
995795 | 995795 | 2021-02-04 | Cass | Indiana | 18017 | 5081 | 90 |
978176 | 978176 | 2021-01-29 | Jefferson | Tennessee | 47089 | 5081 | 83 |
965423 | 965423 | 2021-01-25 | Navarro | Texas | 48349 | 5081 | 82 |
962178 | 962178 | 2021-01-24 | Navarro | Texas | 48349 | 5081 | 82 |
958933 | 958933 | 2021-01-23 | Navarro | Texas | 48349 | 5081 | 82 |
955687 | 955687 | 2021-01-22 | Navarro | Texas | 48349 | 5081 | 82 |
944388 | 944388 | 2021-01-19 | Hampshire | Massachusetts | 25015 | 5081 | 220 |
936624 | 936624 | 2021-01-16 | Sauk | Wisconsin | 55111 | 5081 | 40 |
913964 | 913964 | 2021-01-10 | Colbert | Alabama | 1033 | 5081 | 61 |
892681 | 892681 | 2021-01-03 | Lauderdale | Mississippi | 28075 | 5081 | 171 |
787730 | 787730 | 2020-12-02 | Indian River | Florida | 12061 | 5081 | 140 |
768306 | 768306 | 2020-11-26 | Bartow | Georgia | 13015 | 5081 | 105 |
586614 | 586614 | 2020-10-01 | Okaloosa | Florida | 12091 | 5081 | 116 |
524106 | 524106 | 2020-09-11 | Bell | Texas | 48027 | 5081 | 72 |
465386 | 465386 | 2020-08-24 | Montgomery | Ohio | 39113 | 5081 | 116 |
372690 | 372690 | 2020-07-26 | Webb | Texas | 48479 | 5081 | 104 |
290644 | 290644 | 2020-07-01 | Cobb | Georgia | 13067 | 5081 | 245 |
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);