ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 192,754
- Georgia 124,409
- Virginia 102,729
- Kentucky 92,212
- Missouri 89,249
- Illinois 79,193
- Kansas 78,976
- North Carolina 77,509
- Iowa 76,770
- Tennessee 74,431
- Indiana 71,642
- Nebraska 68,973
- Ohio 68,834
- Minnesota 67,619
- Michigan 64,950
- Mississippi 63,898
- Oklahoma 59,689
- Arkansas 58,728
- Puerto Rico 58,160
- Wisconsin 55,777
- Florida 53,158
- Pennsylvania 52,240
- Alabama 52,044
- Louisiana 50,707
- South Dakota 49,354
- Colorado 49,327
- New York 45,518
- California 45,461
- West Virginia 42,073
- Montana 40,488
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490054 | 2490054 | 2022-05-10 | Chaffee | Colorado | 8015 | 4717 | 47 |
2490055 | 2490055 | 2022-05-10 | Cheyenne | Colorado | 8017 | 322 | 9 |
2490056 | 2490056 | 2022-05-10 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2490057 | 2490057 | 2022-05-10 | Conejos | Colorado | 8021 | 1757 | 54 |
2490058 | 2490058 | 2022-05-10 | Costilla | Colorado | 8023 | 703 | 18 |
2490059 | 2490059 | 2022-05-10 | Crowley | Colorado | 8025 | 3342 | 30 |
2490060 | 2490060 | 2022-05-10 | Custer | Colorado | 8027 | 655 | 21 |
2490061 | 2490061 | 2022-05-10 | Delta | Colorado | 8029 | 6195 | 140 |
2490062 | 2490062 | 2022-05-10 | Denver | Colorado | 8031 | 175374 | 1357 |
2490063 | 2490063 | 2022-05-10 | Dolores | Colorado | 8033 | 367 | 8 |
2490064 | 2490064 | 2022-05-10 | Douglas | Colorado | 8035 | 81050 | 458 |
2490065 | 2490065 | 2022-05-10 | Eagle | Colorado | 8037 | 16203 | 35 |
2490066 | 2490066 | 2022-05-10 | El Paso | Colorado | 8041 | 188684 | 1694 |
2490067 | 2490067 | 2022-05-10 | Elbert | Colorado | 8039 | 4831 | 40 |
2490068 | 2490068 | 2022-05-10 | Fremont | Colorado | 8043 | 15407 | 187 |
2490069 | 2490069 | 2022-05-10 | Garfield | Colorado | 8045 | 15012 | 91 |
2490070 | 2490070 | 2022-05-10 | Gilpin | Colorado | 8047 | 972 | 4 |
2490071 | 2490071 | 2022-05-10 | Grand | Colorado | 8049 | 3593 | 28 |
2490072 | 2490072 | 2022-05-10 | Gunnison | Colorado | 8051 | 3402 | 14 |
2490073 | 2490073 | 2022-05-10 | Hinsdale | Colorado | 8053 | 131 | 0 |
2490074 | 2490074 | 2022-05-10 | Huerfano | Colorado | 8055 | 1449 | 35 |
2490075 | 2490075 | 2022-05-10 | Jackson | Colorado | 8057 | 165 | 0 |
2490076 | 2490076 | 2022-05-10 | Jefferson | Colorado | 8059 | 126673 | 1356 |
2490077 | 2490077 | 2022-05-10 | Kiowa | Colorado | 8061 | 336 | 6 |
2490078 | 2490078 | 2022-05-10 | Kit Carson | Colorado | 8063 | 1614 | 34 |
2490079 | 2490079 | 2022-05-10 | La Plata | Colorado | 8067 | 12943 | 86 |
2490080 | 2490080 | 2022-05-10 | Lake | Colorado | 8065 | 1825 | 2 |
2490081 | 2490081 | 2022-05-10 | Larimer | Colorado | 8069 | 80142 | 503 |
2490082 | 2490082 | 2022-05-10 | Las Animas | Colorado | 8071 | 3623 | 43 |
2490083 | 2490083 | 2022-05-10 | Lincoln | Colorado | 8073 | 2185 | 9 |
2490084 | 2490084 | 2022-05-10 | Logan | Colorado | 8075 | 7466 | 109 |
2490085 | 2490085 | 2022-05-10 | Mesa | Colorado | 8077 | 42913 | 563 |
2490086 | 2490086 | 2022-05-10 | Mineral | Colorado | 8079 | 237 | 2 |
2490087 | 2490087 | 2022-05-10 | Moffat | Colorado | 8081 | 3045 | 52 |
2490088 | 2490088 | 2022-05-10 | Montezuma | Colorado | 8083 | 6211 | 81 |
2490089 | 2490089 | 2022-05-10 | Montrose | Colorado | 8085 | 9369 | 160 |
2490090 | 2490090 | 2022-05-10 | Morgan | Colorado | 8087 | 5706 | 138 |
2490091 | 2490091 | 2022-05-10 | Otero | Colorado | 8089 | 4309 | 130 |
2490092 | 2490092 | 2022-05-10 | Ouray | Colorado | 8091 | 875 | 6 |
2490093 | 2490093 | 2022-05-10 | Park | Colorado | 8093 | 2883 | 20 |
2490094 | 2490094 | 2022-05-10 | Phillips | Colorado | 8095 | 890 | 19 |
2490095 | 2490095 | 2022-05-10 | Pitkin | Colorado | 8097 | 6624 | 7 |
2490096 | 2490096 | 2022-05-10 | Prowers | Colorado | 8099 | 2645 | 51 |
2490097 | 2490097 | 2022-05-10 | Pueblo | Colorado | 8101 | 47224 | 801 |
2490098 | 2490098 | 2022-05-10 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2490099 | 2490099 | 2022-05-10 | Rio Grande | Colorado | 8105 | 2847 | 46 |
2490100 | 2490100 | 2022-05-10 | Routt | Colorado | 8107 | 6516 | 25 |
2490101 | 2490101 | 2022-05-10 | Saguache | Colorado | 8109 | 1200 | 12 |
2490102 | 2490102 | 2022-05-10 | San Juan | Colorado | 8111 | 203 | 0 |
2490103 | 2490103 | 2022-05-10 | San Miguel | Colorado | 8113 | 2314 | 8 |
2490104 | 2490104 | 2022-05-10 | Sedgwick | Colorado | 8115 | 489 | 10 |
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2490106 | 2490106 | 2022-05-10 | Teller | Colorado | 8119 | 4880 | 57 |
2490107 | 2490107 | 2022-05-10 | Washington | Colorado | 8121 | 1063 | 28 |
2490108 | 2490108 | 2022-05-10 | Weld | Colorado | 8123 | 85522 | 702 |
2490109 | 2490109 | 2022-05-10 | Yuma | Colorado | 8125 | 1883 | 23 |
2490110 | 2490110 | 2022-05-10 | Fairfield | Connecticut | 9001 | 212518 | 2725 |
2490111 | 2490111 | 2022-05-10 | Hartford | Connecticut | 9003 | 185485 | 3144 |
2490112 | 2490112 | 2022-05-10 | Litchfield | Connecticut | 9005 | 33166 | 462 |
2490113 | 2490113 | 2022-05-10 | Middlesex | Connecticut | 9007 | 29644 | 481 |
2490114 | 2490114 | 2022-05-10 | New Haven | Connecticut | 9009 | 203793 | 2831 |
2490115 | 2490115 | 2022-05-10 | New London | Connecticut | 9011 | 57604 | 660 |
2490116 | 2490116 | 2022-05-10 | Tolland | Connecticut | 9013 | 21691 | 274 |
2490117 | 2490117 | 2022-05-10 | Unknown | Connecticut | 2347 | 1 | |
2490118 | 2490118 | 2022-05-10 | Windham | Connecticut | 9015 | 26461 | 305 |
2490119 | 2490119 | 2022-05-10 | Kent | Delaware | 10001 | 51498 | 650 |
2490120 | 2490120 | 2022-05-10 | New Castle | Delaware | 10003 | 150458 | 1423 |
2490121 | 2490121 | 2022-05-10 | Sussex | Delaware | 10005 | 62866 | 855 |
2490122 | 2490122 | 2022-05-10 | Unknown | Delaware | 885 | 0 | |
2490123 | 2490123 | 2022-05-10 | District of Columbia | District of Columbia | 11001 | 143005 | 1340 |
2490124 | 2490124 | 2022-05-10 | Alachua | Florida | 12001 | 69008 | 664 |
2490125 | 2490125 | 2022-05-10 | Baker | Florida | 12003 | 8712 | 142 |
2490126 | 2490126 | 2022-05-10 | Bay | Florida | 12005 | 45926 | 825 |
2490127 | 2490127 | 2022-05-10 | Bradford | Florida | 12007 | 7538 | 149 |
2490128 | 2490128 | 2022-05-10 | Brevard | Florida | 12009 | 135740 | 2097 |
2490129 | 2490129 | 2022-05-10 | Broward | Florida | 12011 | 614436 | 5841 |
2490130 | 2490130 | 2022-05-10 | Calhoun | Florida | 12013 | 4103 | 98 |
2490131 | 2490131 | 2022-05-10 | Charlotte | Florida | 12015 | 36528 | 810 |
2490132 | 2490132 | 2022-05-10 | Citrus | Florida | 12017 | 29988 | 976 |
2490133 | 2490133 | 2022-05-10 | Clay | Florida | 12019 | 53825 | 855 |
2490134 | 2490134 | 2022-05-10 | Collier | Florida | 12021 | 85078 | 998 |
2490135 | 2490135 | 2022-05-10 | Columbia | Florida | 12023 | 21193 | 402 |
2490136 | 2490136 | 2022-05-10 | DeSoto | Florida | 12027 | 9455 | 150 |
2490137 | 2490137 | 2022-05-10 | Dixie | Florida | 12029 | 4046 | 70 |
2490138 | 2490138 | 2022-05-10 | Duval | Florida | 12031 | 255189 | 3406 |
2490139 | 2490139 | 2022-05-10 | Escambia | Florida | 12033 | 78190 | 1311 |
2490140 | 2490140 | 2022-05-10 | Flagler | Florida | 12035 | 22651 | 358 |
2490141 | 2490141 | 2022-05-10 | Franklin | Florida | 12037 | 3087 | 52 |
2490142 | 2490142 | 2022-05-10 | Gadsden | Florida | 12039 | 13475 | 206 |
2490143 | 2490143 | 2022-05-10 | Gilchrist | Florida | 12041 | 4562 | 93 |
2490144 | 2490144 | 2022-05-10 | Glades | Florida | 12043 | 1995 | 36 |
2490145 | 2490145 | 2022-05-10 | Gulf | Florida | 12045 | 4292 | 78 |
2490146 | 2490146 | 2022-05-10 | Hamilton | Florida | 12047 | 3841 | 56 |
2490147 | 2490147 | 2022-05-10 | Hardee | Florida | 12049 | 8696 | 125 |
2490148 | 2490148 | 2022-05-10 | Hendry | Florida | 12051 | 11773 | 160 |
2490149 | 2490149 | 2022-05-10 | Hernando | Florida | 12053 | 42396 | 1093 |
2490150 | 2490150 | 2022-05-10 | Highlands | Florida | 12055 | 24304 | 685 |
2490151 | 2490151 | 2022-05-10 | Hillsborough | Florida | 12057 | 379994 | 3787 |
2490152 | 2490152 | 2022-05-10 | Holmes | Florida | 12059 | 5429 | 87 |
2490153 | 2490153 | 2022-05-10 | Indian River | Florida | 12061 | 33156 | 652 |
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);