ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 3758 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 8
- Missouri 8
- Virginia 8
- Indiana 7
- Tennessee 6
- Texas 6
- West Virginia 6
- Kansas 5
- Louisiana 5
- Michigan 4
- Nebraska 4
- Pennsylvania 4
- Wisconsin 4
- Minnesota 3
- Mississippi 3
- Ohio 3
- New Hampshire 2
- New York 2
- North Carolina 2
- Washington 2
- Wyoming 2
- Alabama 1
- California 1
- Connecticut 1
- Delaware 1
- Georgia 1
- Idaho 1
- Illinois 1
- Iowa 1
- Kentucky 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468393 | 2468393 | 2022-05-03 | Renville | Minnesota | 27129 | 3758 | 56 |
2360924 | 2360924 | 2022-03-31 | Faribault | Minnesota | 27043 | 3758 | 50 |
2330437 | 2330437 | 2022-03-22 | Howard | Arkansas | 5061 | 3758 | 50 |
2327185 | 2327185 | 2022-03-21 | Howard | Arkansas | 5061 | 3758 | 50 |
2323932 | 2323932 | 2022-03-20 | Howard | Arkansas | 5061 | 3758 | 50 |
2317144 | 2317144 | 2022-03-17 | Grant | West Virginia | 54023 | 3758 | 56 |
2313891 | 2313891 | 2022-03-16 | Grant | West Virginia | 54023 | 3758 | 56 |
2310638 | 2310638 | 2022-03-15 | Grant | West Virginia | 54023 | 3758 | 56 |
2307385 | 2307385 | 2022-03-14 | Grant | West Virginia | 54023 | 3758 | 56 |
2244469 | 2244469 | 2022-02-23 | Polk | North Carolina | 37149 | 3758 | 50 |
2216210 | 2216210 | 2022-02-14 | Goochland | Virginia | 51075 | 3758 | 42 |
2180346 | 2180346 | 2022-02-03 | San Juan | Utah | 49037 | 3758 | 47 |
2131656 | 2131656 | 2022-01-19 | New Kent | Virginia | 51127 | 3758 | 28 |
2117995 | 2117995 | 2022-01-15 | Guayama | Puerto Rico | 72057 | 3758 | |
2063132 | 2063132 | 2021-12-29 | Limestone | Texas | 48293 | 3758 | 111 |
2060288 | 2060288 | 2021-12-28 | Green Lake | Wisconsin | 55047 | 3758 | 49 |
2037551 | 2037551 | 2021-12-21 | Langlade | Wisconsin | 55067 | 3758 | 64 |
1998755 | 1998755 | 2021-12-10 | Lincoln | Arkansas | 5079 | 3758 | 58 |
1944643 | 1944643 | 2021-11-23 | Menominee | Michigan | 26109 | 3758 | 52 |
1941392 | 1941392 | 2021-11-22 | Menominee | Michigan | 26109 | 3758 | 52 |
1937617 | 1937617 | 2021-11-21 | Randolph | Indiana | 18135 | 3758 | 107 |
1934367 | 1934367 | 2021-11-20 | Randolph | Indiana | 18135 | 3758 | 107 |
1931116 | 1931116 | 2021-11-19 | Randolph | Indiana | 18135 | 3758 | 107 |
1920469 | 1920469 | 2021-11-15 | Mason | West Virginia | 54053 | 3758 | 59 |
1906130 | 1906130 | 2021-11-11 | Coos | New Hampshire | 33007 | 3758 | 66 |
1902881 | 1902881 | 2021-11-10 | Coos | New Hampshire | 33007 | 3758 | 66 |
1894500 | 1894500 | 2021-11-07 | Wyoming | West Virginia | 54109 | 3758 | 65 |
1884387 | 1884387 | 2021-11-04 | Milam | Texas | 48331 | 3758 | 85 |
1881138 | 1881138 | 2021-11-03 | Milam | Texas | 48331 | 3758 | 83 |
1833628 | 1833628 | 2021-10-20 | Posey | Indiana | 18129 | 3758 | 44 |
1832203 | 1832203 | 2021-10-19 | Morgan | Tennessee | 47129 | 3758 | 47 |
1808777 | 1808777 | 2021-10-12 | Anson | North Carolina | 37007 | 3758 | 75 |
1793187 | 1793187 | 2021-10-07 | Haywood | Tennessee | 47075 | 3758 | 71 |
1761962 | 1761962 | 2021-09-28 | Jerome | Idaho | 16053 | 3758 | 38 |
1764305 | 1764305 | 2021-09-28 | Accomack | Virginia | 51001 | 3758 | 67 |
1743971 | 1743971 | 2021-09-22 | Fayette | Ohio | 39047 | 3758 | 53 |
1730451 | 1730451 | 2021-09-18 | McDonald | Missouri | 29119 | 3758 | 52 |
1727201 | 1727201 | 2021-09-17 | McDonald | Missouri | 29119 | 3758 | 52 |
1723952 | 1723952 | 2021-09-16 | McDonald | Missouri | 29119 | 3758 | 52 |
1715201 | 1715201 | 2021-09-13 | Grainger | Tennessee | 47057 | 3758 | 53 |
1699851 | 1699851 | 2021-09-09 | Glenn | California | 6021 | 3758 | 31 |
1701083 | 1701083 | 2021-09-09 | Coahoma | Mississippi | 28027 | 3758 | 96 |
1701948 | 1701948 | 2021-09-09 | Greene | Pennsylvania | 42059 | 3758 | 44 |
1702643 | 1702643 | 2021-09-09 | Isle of Wight | Virginia | 51093 | 3758 | 74 |
1689975 | 1689975 | 2021-09-06 | Winston | Alabama | 1133 | 3758 | 79 |
1677053 | 1677053 | 2021-09-02 | Jackson | Arkansas | 5067 | 3758 | 41 |
1678370 | 1678370 | 2021-09-02 | Marion | Mississippi | 28091 | 3758 | 92 |
1669257 | 1669257 | 2021-08-30 | Guernsey | Ohio | 39059 | 3758 | 54 |
1655339 | 1655339 | 2021-08-26 | Sabine | Louisiana | 22085 | 3758 | 67 |
1600727 | 1600727 | 2021-08-09 | Lyon | Nevada | 32019 | 3758 | 69 |
1566243 | 1566243 | 2021-07-29 | Prince George | Virginia | 51149 | 3758 | 33 |
1558844 | 1558844 | 2021-07-27 | Ottawa | Ohio | 39123 | 3758 | 81 |
1537417 | 1537417 | 2021-07-21 | St. Francis | Arkansas | 5123 | 3758 | 46 |
1509059 | 1509059 | 2021-07-12 | Greenup | Kentucky | 21089 | 3758 | 63 |
1472104 | 1472104 | 2021-06-30 | Tazewell | Virginia | 51185 | 3758 | 75 |
1420779 | 1420779 | 2021-06-15 | Bryan | Georgia | 13029 | 3758 | 41 |
1414628 | 1414628 | 2021-06-13 | Knox | Indiana | 18083 | 3758 | 90 |
1411383 | 1411383 | 2021-06-12 | Knox | Indiana | 18083 | 3758 | 90 |
1405758 | 1405758 | 2021-06-10 | Webster | Missouri | 29225 | 3758 | 55 |
1398578 | 1398578 | 2021-06-08 | Ellis | Kansas | 20051 | 3758 | 72 |
1395331 | 1395331 | 2021-06-07 | Ellis | Kansas | 20051 | 3758 | 72 |
1392086 | 1392086 | 2021-06-06 | Ellis | Kansas | 20051 | 3758 | 72 |
1388841 | 1388841 | 2021-06-05 | Ellis | Kansas | 20051 | 3758 | 72 |
1385596 | 1385596 | 2021-06-04 | Ellis | Kansas | 20051 | 3758 | 72 |
1349639 | 1349639 | 2021-05-24 | Montgomery | Illinois | 17135 | 3758 | 79 |
1336721 | 1336721 | 2021-05-20 | Jasper | Indiana | 18073 | 3758 | 53 |
1310004 | 1310004 | 2021-05-11 | Teton | Wyoming | 56039 | 3758 | 9 |
1290671 | 1290671 | 2021-05-06 | Independence | Arkansas | 5063 | 3758 | 123 |
1254763 | 1254763 | 2021-04-24 | Oneida | Wisconsin | 55085 | 3758 | 74 |
1223486 | 1223486 | 2021-04-15 | Iberville | Louisiana | 22047 | 3758 | 97 |
1212713 | 1212713 | 2021-04-12 | Boone | Arkansas | 5009 | 3758 | 79 |
1197732 | 1197732 | 2021-04-07 | Morrison | Minnesota | 27097 | 3758 | 57 |
1122877 | 1122877 | 2021-03-15 | Calvert | Maryland | 24009 | 3758 | 73 |
1098778 | 1098778 | 2021-03-07 | Lewis | Washington | 53041 | 3758 | 50 |
1095006 | 1095006 | 2021-03-06 | Giles | Tennessee | 47055 | 3758 | 97 |
1095530 | 1095530 | 2021-03-06 | Lewis | Washington | 53041 | 3758 | 50 |
1080634 | 1080634 | 2021-03-02 | St. Bernard | Louisiana | 22087 | 3758 | 46 |
1061462 | 1061462 | 2021-02-24 | Neshoba | Mississippi | 28099 | 3758 | 166 |
1052792 | 1052792 | 2021-02-21 | Campbell | Tennessee | 47013 | 3758 | 58 |
1039542 | 1039542 | 2021-02-17 | Bedford | Pennsylvania | 42009 | 3758 | 127 |
1012860 | 1012860 | 2021-02-09 | Johnson | Missouri | 29101 | 3758 | 38 |
998084 | 998084 | 2021-02-04 | Manassas city | Virginia | 51683 | 3758 | 33 |
990332 | 990332 | 2021-02-02 | Platte | Nebraska | 31141 | 3758 | 46 |
987085 | 987085 | 2021-02-01 | Platte | Nebraska | 31141 | 3758 | 46 |
983838 | 983838 | 2021-01-31 | Platte | Nebraska | 31141 | 3758 | 46 |
980592 | 980592 | 2021-01-30 | Platte | Nebraska | 31141 | 3758 | 46 |
980701 | 980701 | 2021-01-30 | Cattaraugus | New York | 36009 | 3758 | 67 |
975584 | 975584 | 2021-01-28 | Albany | Wyoming | 56001 | 3758 | 11 |
924505 | 924505 | 2021-01-13 | Des Moines | Iowa | 19057 | 3758 | 40 |
916252 | 916252 | 2021-01-10 | Mifflin | Pennsylvania | 42087 | 3758 | 128 |
912257 | 912257 | 2021-01-09 | Lincoln | Missouri | 29113 | 3758 | 20 |
877589 | 877589 | 2020-12-29 | Monroe | Tennessee | 47123 | 3758 | 54 |
817854 | 817854 | 2020-12-11 | Gratiot | Michigan | 26057 | 3758 | 47 |
790531 | 790531 | 2020-12-02 | Barron | Wisconsin | 55005 | 3758 | 41 |
764421 | 764421 | 2020-11-24 | Montgomery | Virginia | 51121 | 3758 | 15 |
760384 | 760384 | 2020-11-23 | Rogers | Oklahoma | 40131 | 3758 | 63 |
753924 | 753924 | 2020-11-21 | Lane | Oregon | 41039 | 3758 | 37 |
717497 | 717497 | 2020-11-10 | Cape Girardeau | Missouri | 29031 | 3758 | 60 |
714253 | 714253 | 2020-11-09 | Cape Girardeau | Missouri | 29031 | 3758 | 56 |
571192 | 571192 | 2020-09-26 | Livingston | Louisiana | 22063 | 3758 | 74 |
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);