ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 4606 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Illinois 10
- Virginia 10
- Ohio 8
- Tennessee 8
- Georgia 7
- Mississippi 7
- Pennsylvania 7
- Maine 3
- Minnesota 3
- New York 3
- Puerto Rico 3
- South Dakota 3
- Wisconsin 3
- Alabama 2
- Arkansas 2
- Indiana 2
- Iowa 2
- Kentucky 2
- Louisiana 2
- Michigan 2
- New Jersey 2
- North Carolina 2
- North Dakota 2
- Texas 2
- California 1
- Idaho 1
- New Hampshire 1
- New Mexico 1
- Oklahoma 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2382959 | 2382959 | 2022-04-07 | Cass | Illinois | 17017 | 4606 | 44 |
2373198 | 2373198 | 2022-04-04 | Cass | Illinois | 17017 | 4606 | 44 |
2369945 | 2369945 | 2022-04-03 | Cass | Illinois | 17017 | 4606 | 44 |
2366692 | 2366692 | 2022-04-02 | Cass | Illinois | 17017 | 4606 | 44 |
2363439 | 2363439 | 2022-04-01 | Cass | Illinois | 17017 | 4606 | 44 |
2362590 | 2362590 | 2022-03-31 | New Kent | Virginia | 51127 | 4606 | 32 |
2359336 | 2359336 | 2022-03-30 | New Kent | Virginia | 51127 | 4606 | 32 |
2338119 | 2338119 | 2022-03-24 | Roscommon | Michigan | 26143 | 4606 | 113 |
2334865 | 2334865 | 2022-03-23 | Roscommon | Michigan | 26143 | 4606 | 113 |
2300117 | 2300117 | 2022-03-12 | Camuy | Puerto Rico | 72027 | 4606 | |
2294422 | 2294422 | 2022-03-10 | Adams | Wisconsin | 55001 | 4606 | 53 |
2187595 | 2187595 | 2022-02-06 | Appling | Georgia | 13001 | 4606 | 113 |
2189504 | 2189504 | 2022-02-06 | Juniata | Pennsylvania | 42067 | 4606 | 168 |
2184342 | 2184342 | 2022-02-05 | Appling | Georgia | 13001 | 4606 | 113 |
2181090 | 2181090 | 2022-02-04 | Appling | Georgia | 13001 | 4606 | 113 |
2132019 | 2132019 | 2022-01-20 | Columbia | Arkansas | 5027 | 4606 | 77 |
2131833 | 2131833 | 2022-01-19 | Langlade | Wisconsin | 55067 | 4606 | 67 |
2105033 | 2105033 | 2022-01-11 | Vega Alta | Puerto Rico | 72143 | 4606 | |
2100567 | 2100567 | 2022-01-10 | Hancock | Maine | 23009 | 4606 | 66 |
2097316 | 2097316 | 2022-01-09 | Hancock | Maine | 23009 | 4606 | 66 |
2094064 | 2094064 | 2022-01-08 | Hancock | Maine | 23009 | 4606 | 66 |
2037311 | 2037311 | 2021-12-21 | Carroll | Virginia | 51035 | 4606 | 109 |
2023458 | 2023458 | 2021-12-17 | Henry | Ohio | 39069 | 4606 | 83 |
2006585 | 2006585 | 2021-12-12 | Simpson | Mississippi | 28127 | 4606 | 117 |
2003334 | 2003334 | 2021-12-11 | Simpson | Mississippi | 28127 | 4606 | 117 |
2000084 | 2000084 | 2021-12-10 | Simpson | Mississippi | 28127 | 4606 | 117 |
1988996 | 1988996 | 2021-12-07 | Jackson | Arkansas | 5067 | 4606 | 47 |
1981165 | 1981165 | 2021-12-04 | Adams | Ohio | 39001 | 4606 | 110 |
1970068 | 1970068 | 2021-12-01 | Clay | Indiana | 18021 | 4606 | 63 |
1967196 | 1967196 | 2021-11-30 | Ohio | Kentucky | 21183 | 4606 | 87 |
1962591 | 1962591 | 2021-11-28 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1959340 | 1959340 | 2021-11-27 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1956089 | 1956089 | 2021-11-26 | Isle of Wight | Virginia | 51093 | 4606 | 91 |
1939347 | 1939347 | 2021-11-21 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1936097 | 1936097 | 2021-11-20 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1932847 | 1932847 | 2021-11-19 | Lawrence | South Dakota | 46081 | 4606 | 65 |
1902434 | 1902434 | 2021-11-10 | Cass | Minnesota | 27021 | 4606 | 49 |
1891376 | 1891376 | 2021-11-07 | Geneva | Alabama | 1061 | 4606 | 130 |
1854944 | 1854944 | 2021-10-26 | McNairy | Tennessee | 47109 | 4606 | 70 |
1844491 | 1844491 | 2021-10-23 | Otsego | New York | 36077 | 4606 | 55 |
1838446 | 1838446 | 2021-10-21 | Arecibo | Puerto Rico | 72013 | 4606 | |
1791054 | 1791054 | 2021-10-07 | Dawson | Georgia | 13085 | 4606 | 65 |
1771091 | 1771091 | 2021-09-30 | Trempealeau | Wisconsin | 55121 | 4606 | 52 |
1764404 | 1764404 | 2021-09-28 | Prince George | Virginia | 51149 | 4606 | 35 |
1760104 | 1760104 | 2021-09-27 | Pasquotank | North Carolina | 37139 | 4606 | 94 |
1755535 | 1755535 | 2021-09-26 | Lee | Illinois | 17103 | 4606 | 97 |
1752287 | 1752287 | 2021-09-25 | Lee | Illinois | 17103 | 4606 | 97 |
1749038 | 1749038 | 2021-09-24 | Lee | Illinois | 17103 | 4606 | 97 |
1685517 | 1685517 | 2021-09-04 | Logan | Ohio | 39091 | 4606 | 79 |
1675447 | 1675447 | 2021-09-01 | Grafton | New Hampshire | 33009 | 4606 | 30 |
1669244 | 1669244 | 2021-08-30 | Crawford | Ohio | 39033 | 4606 | 112 |
1656162 | 1656162 | 2021-08-26 | Scotland | North Carolina | 37165 | 4606 | 96 |
1656730 | 1656730 | 2021-08-26 | Giles | Tennessee | 47055 | 4606 | 100 |
1568336 | 1568336 | 2021-07-30 | Madison | New York | 36053 | 4606 | 89 |
1563974 | 1563974 | 2021-07-29 | Montgomery | Indiana | 18107 | 4606 | 94 |
1556017 | 1556017 | 2021-07-26 | Cocke | Tennessee | 47029 | 4606 | 101 |
1463924 | 1463924 | 2021-06-28 | Itasca | Minnesota | 27061 | 4606 | 64 |
1444565 | 1444565 | 2021-06-22 | Pearl River | Mississippi | 28109 | 4606 | 148 |
1441320 | 1441320 | 2021-06-21 | Pearl River | Mississippi | 28109 | 4606 | 147 |
1405559 | 1405559 | 2021-06-10 | Winona | Minnesota | 27169 | 4606 | 51 |
1390715 | 1390715 | 2021-06-05 | Nacogdoches | Texas | 48347 | 4606 | 172 |
1374229 | 1374229 | 2021-05-31 | Cheatham | Tennessee | 47021 | 4606 | 56 |
1370984 | 1370984 | 2021-05-30 | Cheatham | Tennessee | 47021 | 4606 | 56 |
1367738 | 1367738 | 2021-05-29 | Cheatham | Tennessee | 47021 | 4606 | 56 |
1364492 | 1364492 | 2021-05-28 | Cheatham | Tennessee | 47021 | 4606 | 56 |
1330954 | 1330954 | 2021-05-18 | Panola | Mississippi | 28107 | 4606 | 108 |
1299977 | 1299977 | 2021-05-08 | Culpeper | Virginia | 51047 | 4606 | 62 |
1288749 | 1288749 | 2021-05-05 | Oktibbeha | Mississippi | 28105 | 4606 | 98 |
1272155 | 1272155 | 2021-04-30 | Shelby | Kentucky | 21211 | 4606 | 70 |
1242482 | 1242482 | 2021-04-21 | Macoupin | Illinois | 17117 | 4606 | 110 |
1239232 | 1239232 | 2021-04-20 | Livingston | Illinois | 17105 | 4606 | 95 |
1232950 | 1232950 | 2021-04-18 | Muscatine | Iowa | 19139 | 4606 | 96 |
1212402 | 1212402 | 2021-04-11 | Washington | Virginia | 51191 | 4606 | 102 |
1192154 | 1192154 | 2021-04-05 | Huntingdon | Pennsylvania | 42061 | 4606 | 127 |
1172434 | 1172434 | 2021-03-30 | Williams | North Dakota | 38105 | 4606 | 37 |
1110797 | 1110797 | 2021-03-11 | Mercer | Ohio | 39107 | 4606 | 81 |
1092690 | 1092690 | 2021-03-06 | Tehama | California | 6103 | 4606 | 52 |
1056774 | 1056774 | 2021-02-23 | Dale | Alabama | 1045 | 4606 | 106 |
1058559 | 1058559 | 2021-02-23 | Salem | New Jersey | 34033 | 4606 | 162 |
1042737 | 1042737 | 2021-02-18 | Stephens | Oklahoma | 40137 | 4606 | 60 |
964730 | 964730 | 2021-01-25 | Lawrence | Ohio | 39087 | 4606 | 58 |
961944 | 961944 | 2021-01-24 | Hawkins | Tennessee | 47073 | 4606 | 72 |
953349 | 953349 | 2021-01-22 | Habersham | Georgia | 13137 | 4606 | 112 |
951939 | 951939 | 2021-01-21 | Indiana | Pennsylvania | 42063 | 4606 | 144 |
933895 | 933895 | 2021-01-16 | Laurens | Georgia | 13175 | 4606 | 126 |
921326 | 921326 | 2021-01-12 | Webster | Iowa | 19187 | 4606 | 68 |
903098 | 903098 | 2021-01-06 | Scioto | Ohio | 39145 | 4606 | 48 |
877035 | 877035 | 2020-12-29 | Morton | North Dakota | 38059 | 4606 | 87 |
869655 | 869655 | 2020-12-27 | Iberia | Louisiana | 22045 | 4606 | 120 |
763255 | 763255 | 2020-11-24 | Santa Fe | New Mexico | 35049 | 4606 | 29 |
760232 | 760232 | 2020-11-23 | Allen | Ohio | 39003 | 4606 | 85 |
690622 | 690622 | 2020-11-02 | Kootenai | Idaho | 16055 | 4606 | 51 |
679903 | 679903 | 2020-10-29 | Taylor | Texas | 48441 | 4606 | 72 |
673637 | 673637 | 2020-10-27 | Clark | Washington | 53011 | 4606 | 81 |
663129 | 663129 | 2020-10-24 | Dauphin | Pennsylvania | 42043 | 4606 | 192 |
636675 | 636675 | 2020-10-16 | Atlantic | New Jersey | 34001 | 4606 | 264 |
628096 | 628096 | 2020-10-13 | Chesapeake city | Virginia | 51550 | 4606 | 76 |
619147 | 619147 | 2020-10-11 | Lowndes | Georgia | 13185 | 4606 | 85 |
601520 | 601520 | 2020-10-05 | Northampton | Pennsylvania | 42095 | 4606 | 305 |
562642 | 562642 | 2020-09-23 | York | Pennsylvania | 42133 | 4606 | 149 |
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);