ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 4694 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 9
- North Carolina 8
- Georgia 7
- Indiana 6
- Mississippi 6
- Wisconsin 5
- Arkansas 4
- Missouri 4
- New Hampshire 4
- New York 4
- Puerto Rico 4
- Virginia 4
- Colorado 3
- Kentucky 3
- Minnesota 3
- Alabama 2
- Idaho 2
- Illinois 2
- Iowa 2
- Ohio 2
- Pennsylvania 2
- Florida 1
- Michigan 1
- Nebraska 1
- Nevada 1
- North Dakota 1
- Tennessee 1
- Utah 1
- Vermont 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502375 | 2502375 | 2022-05-13 | Montague | Texas | 48337 | 4694 | 129 |
2473765 | 2473765 | 2022-05-05 | Chaffee | Colorado | 8015 | 4694 | 47 |
2397718 | 2397718 | 2022-04-11 | Barranquitas | Puerto Rico | 72019 | 4694 | |
2333582 | 2333582 | 2022-03-23 | Hale | Alabama | 1065 | 4694 | 104 |
2328651 | 2328651 | 2022-03-21 | Texas | Missouri | 29215 | 4694 | 96 |
2292765 | 2292765 | 2022-03-10 | Andrew | Missouri | 29003 | 4694 | 55 |
2260266 | 2260266 | 2022-02-28 | Clinton | Missouri | 29049 | 4694 | 111 |
2246519 | 2246519 | 2022-02-24 | Starke | Indiana | 18149 | 4694 | 93 |
2233127 | 2233127 | 2022-02-20 | Appling | Georgia | 13001 | 4694 | 115 |
2235437 | 2235437 | 2022-02-20 | Fayette | Texas | 48149 | 4694 | 99 |
2229876 | 2229876 | 2022-02-19 | Appling | Georgia | 13001 | 4694 | 115 |
2226625 | 2226625 | 2022-02-18 | Appling | Georgia | 13001 | 4694 | 115 |
2213394 | 2213394 | 2022-02-14 | Phillips | Arkansas | 5107 | 4694 | 87 |
2177189 | 2177189 | 2022-02-02 | King George | Virginia | 51099 | 4694 | 27 |
2142253 | 2142253 | 2022-01-23 | Payette | Idaho | 16075 | 4694 | 75 |
2138998 | 2138998 | 2022-01-22 | Payette | Idaho | 16075 | 4694 | 75 |
2132057 | 2132057 | 2022-01-20 | Ouachita | Arkansas | 5103 | 4694 | 92 |
2119676 | 2119676 | 2022-01-16 | Washington | Indiana | 18175 | 4694 | 67 |
2121256 | 2121256 | 2022-01-16 | Juana Diaz | Puerto Rico | 72075 | 4694 | |
2116424 | 2116424 | 2022-01-15 | Washington | Indiana | 18175 | 4694 | 67 |
2113173 | 2113173 | 2022-01-14 | Washington | Indiana | 18175 | 4694 | 67 |
2104119 | 2104119 | 2022-01-11 | Wayne | Mississippi | 28153 | 4694 | 73 |
2081133 | 2081133 | 2022-01-04 | Emmet | Michigan | 26047 | 4694 | 61 |
2081327 | 2081327 | 2022-01-04 | Marion | Mississippi | 28091 | 4694 | 115 |
2075148 | 2075148 | 2022-01-02 | Coos | New Hampshire | 33007 | 4694 | 84 |
2071897 | 2071897 | 2022-01-01 | Coos | New Hampshire | 33007 | 4694 | 84 |
2068646 | 2068646 | 2021-12-31 | Coos | New Hampshire | 33007 | 4694 | 84 |
2065395 | 2065395 | 2021-12-30 | Coos | New Hampshire | 33007 | 4694 | 84 |
2065709 | 2065709 | 2021-12-30 | Hocking | Ohio | 39073 | 4694 | 95 |
2035860 | 2035860 | 2021-12-21 | Yazoo | Mississippi | 28163 | 4694 | 94 |
2001516 | 2001516 | 2021-12-10 | Bennington | Vermont | 50003 | 4694 | 39 |
1984319 | 1984319 | 2021-12-05 | Montgomery | North Carolina | 37123 | 4694 | 110 |
1981069 | 1981069 | 2021-12-04 | Montgomery | North Carolina | 37123 | 4694 | 110 |
1977819 | 1977819 | 2021-12-03 | Montgomery | North Carolina | 37123 | 4694 | 110 |
1973020 | 1973020 | 2021-12-02 | Chattooga | Georgia | 13055 | 4694 | 108 |
1955437 | 1955437 | 2021-11-26 | Arecibo | Puerto Rico | 72013 | 4694 | |
1896373 | 1896373 | 2021-11-08 | Nye | Nevada | 32023 | 4694 | 160 |
1853074 | 1853074 | 2021-10-26 | Daviess | Indiana | 18027 | 4694 | 117 |
1829230 | 1829230 | 2021-10-18 | Willacy | Texas | 48489 | 4694 | 109 |
1825981 | 1825981 | 2021-10-17 | Willacy | Texas | 48489 | 4694 | 109 |
1793523 | 1793523 | 2021-10-07 | Uintah | Utah | 49047 | 4694 | 40 |
1789269 | 1789269 | 2021-10-06 | Tioga | New York | 36107 | 4694 | 68 |
1751657 | 1751657 | 2021-09-25 | Dallas | Alabama | 1047 | 4694 | 189 |
1751800 | 1751800 | 2021-09-25 | Poinsett | Arkansas | 5111 | 4694 | 96 |
1722385 | 1722385 | 2021-09-15 | Teton | Wyoming | 56039 | 4694 | 11 |
1715664 | 1715664 | 2021-09-13 | Petersburg city | Virginia | 51730 | 4694 | 94 |
1678282 | 1678282 | 2021-09-02 | McLeod | Minnesota | 27085 | 4694 | 61 |
1667445 | 1667445 | 2021-08-30 | La Plata | Colorado | 8067 | 4694 | 46 |
1643052 | 1643052 | 2021-08-22 | Livingston | New York | 36051 | 4694 | 60 |
1613819 | 1613819 | 2021-08-13 | Madison | New York | 36053 | 4694 | 89 |
1589348 | 1589348 | 2021-08-06 | Independence | Arkansas | 5063 | 4694 | 131 |
1506234 | 1506234 | 2021-07-11 | Oktibbeha | Mississippi | 28105 | 4694 | 98 |
1502988 | 1502988 | 2021-07-10 | Oktibbeha | Mississippi | 28105 | 4694 | 98 |
1499742 | 1499742 | 2021-07-09 | Oktibbeha | Mississippi | 28105 | 4694 | 98 |
1450641 | 1450641 | 2021-06-24 | Hopkins | Kentucky | 21107 | 4694 | 149 |
1432848 | 1432848 | 2021-06-18 | Howard | Texas | 48227 | 4694 | 101 |
1429602 | 1429602 | 2021-06-17 | Howard | Texas | 48227 | 4694 | 101 |
1426357 | 1426357 | 2021-06-16 | Howard | Texas | 48227 | 4694 | 101 |
1412904 | 1412904 | 2021-06-12 | Bedford | Pennsylvania | 42009 | 4694 | 140 |
1409659 | 1409659 | 2021-06-11 | Bedford | Pennsylvania | 42009 | 4694 | 140 |
1400611 | 1400611 | 2021-06-08 | Culpeper | Virginia | 51047 | 4694 | 66 |
1397366 | 1397366 | 2021-06-07 | Culpeper | Virginia | 51047 | 4694 | 66 |
1373602 | 1373602 | 2021-05-31 | Beaufort | North Carolina | 37013 | 4694 | 95 |
1370357 | 1370357 | 2021-05-30 | Beaufort | North Carolina | 37013 | 4694 | 95 |
1367111 | 1367111 | 2021-05-29 | Beaufort | North Carolina | 37013 | 4694 | 95 |
1363865 | 1363865 | 2021-05-28 | Beaufort | North Carolina | 37013 | 4694 | 95 |
1353592 | 1353592 | 2021-05-25 | Mower | Minnesota | 27099 | 4694 | 32 |
1319702 | 1319702 | 2021-05-14 | Polk | Wisconsin | 55095 | 4694 | 60 |
1290954 | 1290954 | 2021-05-06 | Colquitt | Georgia | 13071 | 4694 | 119 |
1281493 | 1281493 | 2021-05-03 | Woodford | Illinois | 17203 | 4694 | 87 |
1266604 | 1266604 | 2021-04-28 | Stark | North Dakota | 38089 | 4694 | 51 |
1228789 | 1228789 | 2021-04-16 | Pierce | Wisconsin | 55093 | 4694 | 42 |
1198759 | 1198759 | 2021-04-07 | Unknown | Puerto Rico | 4694 | 2139 | |
1194214 | 1194214 | 2021-04-06 | Scott | Kentucky | 21209 | 4694 | 32 |
1186089 | 1186089 | 2021-04-03 | Harrison | Texas | 48203 | 4694 | 105 |
1158978 | 1158978 | 2021-03-26 | Scott | Missouri | 29201 | 4694 | 83 |
1154059 | 1154059 | 2021-03-24 | Dunn | Wisconsin | 55033 | 4694 | 30 |
1126007 | 1126007 | 2021-03-16 | Nelson | Kentucky | 21179 | 4694 | 44 |
1101496 | 1101496 | 2021-03-08 | Fayette | Tennessee | 47047 | 4694 | 73 |
1028417 | 1028417 | 2021-02-14 | Sioux | Iowa | 19167 | 4694 | 67 |
999712 | 999712 | 2021-02-05 | Otter Tail | Minnesota | 27111 | 4694 | 69 |
956807 | 956807 | 2021-01-23 | Ogle | Illinois | 17141 | 4694 | 72 |
951325 | 951325 | 2021-01-21 | Buffalo | Nebraska | 31019 | 4694 | 54 |
941786 | 941786 | 2021-01-18 | Ontario | New York | 36069 | 4694 | 82 |
922371 | 922371 | 2021-01-12 | Duplin | North Carolina | 37061 | 4694 | 82 |
911437 | 911437 | 2021-01-09 | Henry | Indiana | 18065 | 4694 | 62 |
696962 | 696962 | 2020-11-04 | Douglas | Georgia | 13097 | 4694 | 80 |
622760 | 622760 | 2020-10-12 | Linn | Iowa | 19113 | 4694 | 121 |
538025 | 538025 | 2020-09-16 | Okaloosa | Florida | 12091 | 4694 | 97 |
531144 | 531144 | 2020-09-13 | Racine | Wisconsin | 55101 | 4694 | 93 |
510668 | 510668 | 2020-09-07 | Summit | Ohio | 39153 | 4694 | 236 |
473247 | 473247 | 2020-08-27 | Jefferson | Colorado | 8059 | 4694 | 236 |
401558 | 401558 | 2020-08-04 | McLennan | Texas | 48309 | 4694 | 51 |
259255 | 259255 | 2020-06-21 | DeKalb | Georgia | 13089 | 4694 | 165 |
148160 | 148160 | 2020-05-15 | Milwaukee | Wisconsin | 55079 | 4694 | 249 |
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);