ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 4532 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 7
- Montana 6
- Texas 6
- Georgia 5
- Michigan 5
- North Carolina 5
- Missouri 4
- Puerto Rico 4
- Tennessee 4
- Washington 4
- Alabama 3
- Arkansas 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Wisconsin 3
- California 2
- Maine 2
- Minnesota 2
- South Carolina 2
- West Virginia 2
- Colorado 1
- Hawaii 1
- Idaho 1
- Indiana 1
- Kentucky 1
- Mississippi 1
- Nevada 1
- North Dakota 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496962 | 2496962 | 2022-05-12 | Johnson | Illinois | 17087 | 4532 | 46 |
2467674 | 2467674 | 2022-05-03 | Piatt | Illinois | 17147 | 4532 | 29 |
2450293 | 2450293 | 2022-04-27 | Robertson | Texas | 48395 | 4532 | 77 |
2447036 | 2447036 | 2022-04-26 | Robertson | Texas | 48395 | 4532 | 77 |
2444103 | 2444103 | 2022-04-25 | Taylor | West Virginia | 54091 | 4532 | 73 |
2418352 | 2418352 | 2022-04-18 | Colusa | California | 6011 | 4532 | 21 |
2405328 | 2405328 | 2022-04-14 | Colusa | California | 6011 | 4532 | 21 |
2398879 | 2398879 | 2022-04-12 | Chaffee | Colorado | 8015 | 4532 | 44 |
2328679 | 2328679 | 2022-03-21 | Hill | Montana | 30041 | 4532 | 71 |
2330257 | 2330257 | 2022-03-21 | Sawyer | Wisconsin | 55113 | 4532 | 60 |
2325427 | 2325427 | 2022-03-20 | Hill | Montana | 30041 | 4532 | 71 |
2322173 | 2322173 | 2022-03-19 | Hill | Montana | 30041 | 4532 | 71 |
2318919 | 2318919 | 2022-03-18 | Hill | Montana | 30041 | 4532 | 71 |
2315666 | 2315666 | 2022-03-17 | Hill | Montana | 30041 | 4532 | 71 |
2312413 | 2312413 | 2022-03-16 | Hill | Montana | 30041 | 4532 | 71 |
2309889 | 2309889 | 2022-03-15 | Guayama | Puerto Rico | 72057 | 4532 | |
2297327 | 2297327 | 2022-03-11 | Panola | Texas | 48365 | 4532 | 129 |
2224177 | 2224177 | 2022-02-17 | Lincoln | Maine | 23015 | 4532 | 24 |
2225326 | 2225326 | 2022-02-17 | Barranquitas | Puerto Rico | 72019 | 4532 | |
2225330 | 2225330 | 2022-02-17 | Camuy | Puerto Rico | 72027 | 4532 | |
2178062 | 2178062 | 2022-02-03 | Clay | Illinois | 17025 | 4532 | 67 |
2174809 | 2174809 | 2022-02-02 | Clay | Illinois | 17025 | 4532 | 67 |
2171555 | 2171555 | 2022-02-01 | Clark | Illinois | 17023 | 4532 | 55 |
2167734 | 2167734 | 2022-01-31 | Marengo | Alabama | 1091 | 4532 | 94 |
2168080 | 2168080 | 2022-01-31 | Appling | Georgia | 13001 | 4532 | 113 |
2162750 | 2162750 | 2022-01-29 | New Madrid | Missouri | 29143 | 4532 | 71 |
2145388 | 2145388 | 2022-01-24 | Lamar | Georgia | 13171 | 4532 | 105 |
2100963 | 2100963 | 2022-01-10 | Randolph | Missouri | 29175 | 4532 | 88 |
2101820 | 2101820 | 2022-01-10 | Jasper | South Carolina | 45053 | 4532 | 82 |
1992001 | 1992001 | 2021-12-07 | Upshur | West Virginia | 54097 | 4532 | 70 |
1972012 | 1972012 | 2021-12-01 | Cass | Texas | 48067 | 4532 | 155 |
1961923 | 1961923 | 2021-11-28 | Susquehanna | Pennsylvania | 42115 | 4532 | 75 |
1944066 | 1944066 | 2021-11-23 | Decatur | Indiana | 18031 | 4532 | 115 |
1928428 | 1928428 | 2021-11-18 | Brown | Minnesota | 27015 | 4532 | 57 |
1861362 | 1861362 | 2021-10-28 | Meade | South Dakota | 46093 | 4532 | 46 |
1854133 | 1854133 | 2021-10-26 | Nye | Nevada | 32023 | 4532 | 153 |
1829425 | 1829425 | 2021-10-18 | Clallam | Washington | 53009 | 4532 | 52 |
1826176 | 1826176 | 2021-10-17 | Clallam | Washington | 53009 | 4532 | 52 |
1822927 | 1822927 | 2021-10-16 | Clallam | Washington | 53009 | 4532 | 52 |
1819678 | 1819678 | 2021-10-15 | Clallam | Washington | 53009 | 4532 | 52 |
1815934 | 1815934 | 2021-10-14 | Hickman | Tennessee | 47081 | 4532 | 72 |
1792546 | 1792546 | 2021-10-07 | Cherokee | North Carolina | 37039 | 4532 | 74 |
1781061 | 1781061 | 2021-10-04 | Yell | Arkansas | 5149 | 4532 | 76 |
1777811 | 1777811 | 2021-10-03 | Yell | Arkansas | 5149 | 4532 | 76 |
1761810 | 1761810 | 2021-09-28 | Dawson | Georgia | 13085 | 4532 | 55 |
1725816 | 1725816 | 2021-09-17 | St. Francis | Arkansas | 5123 | 4532 | 54 |
1709423 | 1709423 | 2021-09-12 | Dallas | Alabama | 1047 | 4532 | 173 |
1663525 | 1663525 | 2021-08-28 | Upshur | Texas | 48459 | 4532 | 83 |
1642765 | 1642765 | 2021-08-22 | Pulaski | Missouri | 29169 | 4532 | 61 |
1622097 | 1622097 | 2021-08-16 | Bryan | Georgia | 13029 | 4532 | 42 |
1602881 | 1602881 | 2021-08-10 | Randolph | Illinois | 17157 | 4532 | 93 |
1594566 | 1594566 | 2021-08-07 | Madison | Ohio | 39097 | 4532 | 65 |
1556433 | 1556433 | 2021-07-26 | Danville city | Virginia | 51590 | 4532 | 144 |
1532354 | 1532354 | 2021-07-19 | Webster | Missouri | 29225 | 4532 | 60 |
1514518 | 1514518 | 2021-07-14 | Chilton | Alabama | 1021 | 4532 | 116 |
1464436 | 1464436 | 2021-06-28 | Livingston | New York | 36051 | 4532 | 60 |
1391793 | 1391793 | 2021-06-06 | Franklin | Illinois | 17055 | 4532 | 89 |
1360579 | 1360579 | 2021-05-27 | Madison | New York | 36053 | 4532 | 89 |
1354318 | 1354318 | 2021-05-25 | Knox | Ohio | 39083 | 4532 | 111 |
1338522 | 1338522 | 2021-05-20 | Cocke | Tennessee | 47029 | 4532 | 100 |
1330043 | 1330043 | 2021-05-18 | Maui | Hawaii | 15009 | 4532 | 54 |
1330947 | 1330947 | 2021-05-18 | Marshall | Mississippi | 28093 | 4532 | 103 |
1283383 | 1283383 | 2021-05-03 | Obion | Tennessee | 47131 | 4532 | 96 |
1250720 | 1250720 | 2021-04-23 | Toa Baja | Puerto Rico | 72137 | 4532 | |
1246449 | 1246449 | 2021-04-22 | Mower | Minnesota | 27099 | 4532 | 32 |
1225535 | 1225535 | 2021-04-15 | Monroe | Wisconsin | 55081 | 4532 | 38 |
1208237 | 1208237 | 2021-04-10 | Shelby | Ohio | 39149 | 4532 | 89 |
1197408 | 1197408 | 2021-04-07 | Henderson | Kentucky | 21101 | 4532 | 72 |
1197548 | 1197548 | 2021-04-07 | Kennebec | Maine | 23011 | 4532 | 58 |
1136651 | 1136651 | 2021-03-19 | Vance | North Carolina | 37181 | 4532 | 85 |
1130613 | 1130613 | 2021-03-17 | Newberry | South Carolina | 45071 | 4532 | 92 |
1120629 | 1120629 | 2021-03-14 | Osage | Oklahoma | 40113 | 4532 | 56 |
1048949 | 1048949 | 2021-02-20 | Edgecombe | North Carolina | 37065 | 4532 | 99 |
1041060 | 1041060 | 2021-02-18 | Ware | Georgia | 13299 | 4532 | 139 |
1043688 | 1043688 | 2021-02-18 | Dunn | Wisconsin | 55033 | 4532 | 27 |
947659 | 947659 | 2021-01-20 | Chippewa | Michigan | 26033 | 4532 | 31 |
941231 | 941231 | 2021-01-18 | Van Buren | Michigan | 26159 | 4532 | 91 |
919192 | 919192 | 2021-01-11 | Wilkes | North Carolina | 37193 | 4532 | 80 |
847830 | 847830 | 2020-12-20 | Morton | North Dakota | 38059 | 4532 | 84 |
783159 | 783159 | 2020-11-30 | Butler | Pennsylvania | 42019 | 4532 | 75 |
671144 | 671144 | 2020-10-27 | Bonneville | Idaho | 16019 | 4532 | 30 |
665367 | 665367 | 2020-10-25 | Ingham | Michigan | 26065 | 4532 | 64 |
662122 | 662122 | 2020-10-24 | Ingham | Michigan | 26065 | 4532 | 64 |
650679 | 650679 | 2020-10-20 | Randall | Texas | 48381 | 4532 | 53 |
588552 | 588552 | 2020-10-01 | Northampton | Pennsylvania | 42095 | 4532 | 305 |
533787 | 533787 | 2020-09-14 | Sumner | Tennessee | 47165 | 4532 | 91 |
516928 | 516928 | 2020-09-09 | Cumberland | North Carolina | 37051 | 4532 | 71 |
250718 | 250718 | 2020-06-18 | Kent | Michigan | 26081 | 4532 | 118 |
47351 | 47351 | 2020-04-10 | Orange | New York | 36071 | 4532 | 91 |
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);