ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where cases = 4709 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 10
- Ohio 7
- Oklahoma 7
- Wisconsin 7
- Illinois 5
- Kentucky 5
- Mississippi 5
- Oregon 5
- Georgia 4
- Louisiana 4
- Minnesota 4
- Nebraska 4
- Pennsylvania 4
- Texas 4
- Indiana 3
- Missouri 3
- Colorado 2
- Tennessee 2
- Virginia 2
- Washington 2
- Alabama 1
- Arkansas 1
- Florida 1
- Idaho 1
- Maryland 1
- Michigan 1
- New Mexico 1
- New York 1
- North Dakota 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500069 | 2500069 | 2022-05-13 | Morgan | Georgia | 13211 | 4709 | 70 |
2496811 | 2496811 | 2022-05-12 | Morgan | Georgia | 13211 | 4709 | 70 |
2493553 | 2493553 | 2022-05-11 | Morgan | Georgia | 13211 | 4709 | 70 |
2486797 | 2486797 | 2022-05-09 | Chaffee | Colorado | 8015 | 4709 | 47 |
2335503 | 2335503 | 2022-03-23 | Hertford | North Carolina | 37091 | 4709 | 81 |
2279779 | 2279779 | 2022-03-06 | Clinton | Missouri | 29049 | 4709 | 114 |
2276526 | 2276526 | 2022-03-05 | Clinton | Missouri | 29049 | 4709 | 114 |
2273273 | 2273273 | 2022-03-04 | Clinton | Missouri | 29049 | 4709 | 114 |
2239852 | 2239852 | 2022-02-22 | Clay | Illinois | 17025 | 4709 | 69 |
2237040 | 2237040 | 2022-02-21 | Henry | Kentucky | 21103 | 4709 | 45 |
2234741 | 2234741 | 2022-02-20 | Yancey | North Carolina | 37199 | 4709 | 50 |
2231490 | 2231490 | 2022-02-19 | Yancey | North Carolina | 37199 | 4709 | 50 |
2228239 | 2228239 | 2022-02-18 | Yancey | North Carolina | 37199 | 4709 | 50 |
2178463 | 2178463 | 2022-02-03 | Breckinridge | Kentucky | 21027 | 4709 | 61 |
2160578 | 2160578 | 2022-01-28 | Burleson | Texas | 48051 | 4709 | 62 |
2146322 | 2146322 | 2022-01-24 | Waseca | Minnesota | 27161 | 4709 | 36 |
2124387 | 2124387 | 2022-01-17 | Lincoln | Oregon | 41041 | 4709 | 60 |
2121135 | 2121135 | 2022-01-16 | Lincoln | Oregon | 41041 | 4709 | 60 |
2117883 | 2117883 | 2022-01-15 | Lincoln | Oregon | 41041 | 4709 | 60 |
2114632 | 2114632 | 2022-01-14 | Lincoln | Oregon | 41041 | 4709 | 60 |
2082844 | 2082844 | 2022-01-04 | Gloucester | Virginia | 51073 | 4709 | 83 |
2082849 | 2082849 | 2022-01-04 | Halifax | Virginia | 51083 | 4709 | 127 |
2072211 | 2072211 | 2022-01-01 | Hocking | Ohio | 39073 | 4709 | 96 |
2068960 | 2068960 | 2021-12-31 | Hocking | Ohio | 39073 | 4709 | 96 |
2058266 | 2058266 | 2021-12-28 | Morehouse | Louisiana | 22067 | 4709 | 118 |
2055026 | 2055026 | 2021-12-27 | Sabine | Louisiana | 22085 | 4709 | 99 |
2034393 | 2034393 | 2021-12-21 | Geneva | Alabama | 1061 | 4709 | 137 |
2034188 | 2034188 | 2021-12-20 | Island | Washington | 53029 | 4709 | 54 |
1994232 | 1994232 | 2021-12-08 | Pike | Ohio | 39131 | 4709 | 78 |
1972749 | 1972749 | 2021-12-02 | Johnson | Arkansas | 5071 | 4709 | 58 |
1932396 | 1932396 | 2021-11-19 | Stutsman | North Dakota | 38093 | 4709 | 91 |
1898988 | 1898988 | 2021-11-09 | Franklin | Louisiana | 22041 | 4709 | 139 |
1860546 | 1860546 | 2021-10-28 | Dakota | Nebraska | 31043 | 4709 | 82 |
1857297 | 1857297 | 2021-10-27 | Dakota | Nebraska | 31043 | 4709 | 82 |
1824589 | 1824589 | 2021-10-17 | Scott | Mississippi | 28123 | 4709 | 98 |
1821340 | 1821340 | 2021-10-16 | Scott | Mississippi | 28123 | 4709 | 98 |
1818091 | 1818091 | 2021-10-15 | Scott | Mississippi | 28123 | 4709 | 98 |
1809463 | 1809463 | 2021-10-12 | Overton | Tennessee | 47133 | 4709 | 78 |
1711353 | 1711353 | 2021-09-12 | Jackson | North Carolina | 37099 | 4709 | 62 |
1708106 | 1708106 | 2021-09-11 | Jackson | North Carolina | 37099 | 4709 | 62 |
1704859 | 1704859 | 2021-09-10 | Jackson | North Carolina | 37099 | 4709 | 62 |
1669722 | 1669722 | 2021-08-30 | Giles | Tennessee | 47055 | 4709 | 100 |
1654024 | 1654024 | 2021-08-25 | Whitman | Washington | 53075 | 4709 | 54 |
1625618 | 1625618 | 2021-08-17 | Randolph | Illinois | 17157 | 4709 | 95 |
1611175 | 1611175 | 2021-08-12 | Codington | South Dakota | 46029 | 4709 | 82 |
1564706 | 1564706 | 2021-07-29 | Warren | Mississippi | 28149 | 4709 | 127 |
1535459 | 1535459 | 2021-07-20 | Panola | Mississippi | 28107 | 4709 | 112 |
1536202 | 1536202 | 2021-07-20 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1537217 | 1537217 | 2021-07-20 | Albany | Wyoming | 56001 | 4709 | 18 |
1531372 | 1531372 | 2021-07-19 | Franklin | Illinois | 17055 | 4709 | 90 |
1532954 | 1532954 | 2021-07-19 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1529707 | 1529707 | 2021-07-18 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1526460 | 1526460 | 2021-07-17 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1523213 | 1523213 | 2021-07-16 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1519965 | 1519965 | 2021-07-15 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1516717 | 1516717 | 2021-07-14 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1494519 | 1494519 | 2021-07-07 | Howard | Texas | 48227 | 4709 | 102 |
1491272 | 1491272 | 2021-07-06 | Howard | Texas | 48227 | 4709 | 102 |
1457453 | 1457453 | 2021-06-26 | Mower | Minnesota | 27099 | 4709 | 33 |
1448608 | 1448608 | 2021-06-23 | Bedford | Pennsylvania | 42009 | 4709 | 141 |
1445363 | 1445363 | 2021-06-22 | Bedford | Pennsylvania | 42009 | 4709 | 141 |
1420317 | 1420317 | 2021-06-14 | Marinette | Wisconsin | 55075 | 4709 | 73 |
1400845 | 1400845 | 2021-06-08 | Marinette | Wisconsin | 55075 | 4709 | 73 |
1395160 | 1395160 | 2021-06-07 | Lawrence | Indiana | 18093 | 4709 | 124 |
1386918 | 1386918 | 2021-06-04 | Klamath | Oregon | 41035 | 4709 | 74 |
1337327 | 1337327 | 2021-05-20 | Douglas | Minnesota | 27041 | 4709 | 77 |
1334868 | 1334868 | 2021-05-19 | Shelby | Ohio | 39149 | 4709 | 93 |
1329440 | 1329440 | 2021-05-17 | Polk | Wisconsin | 55095 | 4709 | 60 |
1326194 | 1326194 | 2021-05-16 | Polk | Wisconsin | 55095 | 4709 | 60 |
1322948 | 1322948 | 2021-05-15 | Polk | Wisconsin | 55095 | 4709 | 60 |
1287908 | 1287908 | 2021-05-05 | Effingham | Illinois | 17049 | 4709 | 83 |
1281137 | 1281137 | 2021-05-03 | Hendry | Florida | 12051 | 4709 | 82 |
1272100 | 1272100 | 2021-04-30 | Henderson | Kentucky | 21101 | 4709 | 75 |
1201601 | 1201601 | 2021-04-08 | Vance | North Carolina | 37181 | 4709 | 85 |
1192311 | 1192311 | 2021-04-05 | Newberry | South Carolina | 45071 | 4709 | 97 |
1156001 | 1156001 | 2021-03-25 | Genesee | New York | 36037 | 4709 | 121 |
1129417 | 1129417 | 2021-03-17 | Branch | Michigan | 26023 | 4709 | 111 |
1125927 | 1125927 | 2021-03-16 | Boyd | Kentucky | 21019 | 4709 | 48 |
1126612 | 1126612 | 2021-03-16 | Dodge | Nebraska | 31053 | 4709 | 56 |
1120119 | 1120119 | 2021-03-14 | Dodge | Nebraska | 31053 | 4709 | 56 |
1111469 | 1111469 | 2021-03-11 | Medina | Texas | 48325 | 4709 | 99 |
1088094 | 1088094 | 2021-03-04 | Seneca | Ohio | 39147 | 4709 | 107 |
1088104 | 1088104 | 2021-03-04 | Washington | Ohio | 39167 | 4709 | 91 |
1083242 | 1083242 | 2021-03-03 | Tift | Georgia | 13277 | 4709 | 120 |
1079417 | 1079417 | 2021-03-01 | Oconto | Wisconsin | 55083 | 4709 | 55 |
1076172 | 1076172 | 2021-02-28 | Oconto | Wisconsin | 55083 | 4709 | 55 |
1058852 | 1058852 | 2021-02-23 | Jefferson | Ohio | 39081 | 4709 | 107 |
987288 | 987288 | 2021-02-01 | Granville | North Carolina | 37077 | 4709 | 73 |
974179 | 974179 | 2021-01-28 | Curry | New Mexico | 35009 | 4709 | 60 |
947015 | 947015 | 2021-01-20 | Coles | Illinois | 17029 | 4709 | 81 |
918536 | 918536 | 2021-01-11 | Crow Wing | Minnesota | 27035 | 4709 | 71 |
853496 | 853496 | 2020-12-22 | Carroll | Maryland | 24013 | 4709 | 158 |
820620 | 820620 | 2020-12-12 | Wayne | Indiana | 18177 | 4709 | 118 |
766947 | 766947 | 2020-11-25 | Erie | Pennsylvania | 42049 | 4709 | 56 |
743892 | 743892 | 2020-11-18 | Iredell | North Carolina | 37097 | 4709 | 42 |
697121 | 697121 | 2020-11-04 | Twin Falls | Idaho | 16083 | 4709 | 53 |
467286 | 467286 | 2020-08-25 | St. Joseph | Indiana | 18141 | 4709 | 95 |
406389 | 406389 | 2020-08-06 | Ouachita | Louisiana | 22073 | 4709 | 109 |
375323 | 375323 | 2020-07-27 | Chester | Pennsylvania | 42029 | 4709 | 343 |
335682 | 335682 | 2020-07-15 | Jefferson | Kentucky | 21111 | 4709 | 227 |
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);