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 142,933
- Georgia 92,889
- Virginia 76,655
- Kentucky 68,572
- Missouri 66,200
- Illinois 58,902
- Kansas 58,258
- North Carolina 57,809
- Iowa 57,070
- Tennessee 55,519
- Indiana 53,486
- Ohio 51,301
- Nebraska 50,455
- Minnesota 50,283
- Michigan 48,402
- Mississippi 47,690
- Oklahoma 44,323
- Arkansas 43,832
- Puerto Rico 42,597
- Wisconsin 41,665
- Florida 39,762
- Pennsylvania 39,041
- Alabama 38,912
- Louisiana 37,902
- Colorado 36,727
- South Dakota 36,352
- California 34,092
- New York 34,092
- West Virginia 31,293
- North Dakota 29,699
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1854996 | 1854996 | 2021-10-26 | Blanco | Texas | 48031 | 1270 | 28 |
1854997 | 1854997 | 2021-10-26 | Borden | Texas | 48033 | 42 | 2 |
1854998 | 1854998 | 2021-10-26 | Bosque | Texas | 48035 | 2429 | 55 |
1854999 | 1854999 | 2021-10-26 | Bowie | Texas | 48037 | 12714 | 319 |
1855000 | 1855000 | 2021-10-26 | Brazoria | Texas | 48039 | 59168 | 817 |
1855001 | 1855001 | 2021-10-26 | Brazos | Texas | 48041 | 38553 | 354 |
1855002 | 1855002 | 2021-10-26 | Brewster | Texas | 48043 | 1090 | 20 |
1855003 | 1855003 | 2021-10-26 | Briscoe | Texas | 48045 | 224 | 7 |
1855004 | 1855004 | 2021-10-26 | Brooks | Texas | 48047 | 1119 | 47 |
1855005 | 1855005 | 2021-10-26 | Brown | Texas | 48049 | 6987 | 183 |
1855006 | 1855006 | 2021-10-26 | Burleson | Texas | 48051 | 3265 | 59 |
1855007 | 1855007 | 2021-10-26 | Burnet | Texas | 48053 | 7381 | 124 |
1855008 | 1855008 | 2021-10-26 | Caldwell | Texas | 48055 | 8386 | 152 |
1855009 | 1855009 | 2021-10-26 | Calhoun | Texas | 48057 | 3907 | 36 |
1855010 | 1855010 | 2021-10-26 | Callahan | Texas | 48059 | 1805 | 53 |
1855011 | 1855011 | 2021-10-26 | Cameron | Texas | 48061 | 65611 | 1961 |
1855012 | 1855012 | 2021-10-26 | Camp | Texas | 48063 | 2013 | 65 |
1855013 | 1855013 | 2021-10-26 | Carson | Texas | 48065 | 779 | 24 |
1855014 | 1855014 | 2021-10-26 | Cass | Texas | 48067 | 4467 | 144 |
1855015 | 1855015 | 2021-10-26 | Castro | Texas | 48069 | 1320 | 37 |
1855016 | 1855016 | 2021-10-26 | Chambers | Texas | 48071 | 8755 | 97 |
1855017 | 1855017 | 2021-10-26 | Cherokee | Texas | 48073 | 6796 | 218 |
1855018 | 1855018 | 2021-10-26 | Childress | Texas | 48075 | 1573 | 21 |
1855019 | 1855019 | 2021-10-26 | Clay | Texas | 48077 | 1544 | 23 |
1855020 | 1855020 | 2021-10-26 | Cochran | Texas | 48079 | 445 | 18 |
1855021 | 1855021 | 2021-10-26 | Coke | Texas | 48081 | 676 | 16 |
1855022 | 1855022 | 2021-10-26 | Coleman | Texas | 48083 | 1112 | 53 |
1855023 | 1855023 | 2021-10-26 | Collin | Texas | 48085 | 128882 | 1117 |
1855024 | 1855024 | 2021-10-26 | Collingsworth | Texas | 48087 | 391 | 11 |
1855025 | 1855025 | 2021-10-26 | Colorado | Texas | 48089 | 2538 | 51 |
1855026 | 1855026 | 2021-10-26 | Comal | Texas | 48091 | 19367 | 449 |
1855027 | 1855027 | 2021-10-26 | Comanche | Texas | 48093 | 2187 | 64 |
1855028 | 1855028 | 2021-10-26 | Concho | Texas | 48095 | 702 | 10 |
1855029 | 1855029 | 2021-10-26 | Cooke | Texas | 48097 | 5094 | 100 |
1855030 | 1855030 | 2021-10-26 | Coryell | Texas | 48099 | 10770 | 159 |
1855031 | 1855031 | 2021-10-26 | Cottle | Texas | 48101 | 227 | 9 |
1855032 | 1855032 | 2021-10-26 | Crane | Texas | 48103 | 865 | 18 |
1855033 | 1855033 | 2021-10-26 | Crockett | Texas | 48105 | 780 | 16 |
1855034 | 1855034 | 2021-10-26 | Crosby | Texas | 48107 | 998 | 37 |
1855035 | 1855035 | 2021-10-26 | Culberson | Texas | 48109 | 388 | 11 |
1855036 | 1855036 | 2021-10-26 | Dallam | Texas | 48111 | 1216 | 30 |
1855037 | 1855037 | 2021-10-26 | Dallas | Texas | 48113 | 402626 | 5288 |
1855038 | 1855038 | 2021-10-26 | Dawson | Texas | 48115 | 2143 | 77 |
1855039 | 1855039 | 2021-10-26 | DeWitt | Texas | 48123 | 2952 | 82 |
1855040 | 1855040 | 2021-10-26 | Deaf Smith | Texas | 48117 | 3394 | 75 |
1855041 | 1855041 | 2021-10-26 | Delta | Texas | 48119 | 610 | 21 |
1855042 | 1855042 | 2021-10-26 | Denton | Texas | 48121 | 107129 | 1002 |
1855043 | 1855043 | 2021-10-26 | Dickens | Texas | 48125 | 249 | 13 |
1855044 | 1855044 | 2021-10-26 | Dimmit | Texas | 48127 | 3778 | 45 |
1855045 | 1855045 | 2021-10-26 | Donley | Texas | 48129 | 580 | 18 |
1855046 | 1855046 | 2021-10-26 | Duval | Texas | 48131 | 1947 | 57 |
1855047 | 1855047 | 2021-10-26 | Eastland | Texas | 48133 | 2153 | 77 |
1855048 | 1855048 | 2021-10-26 | Ector | Texas | 48135 | 25644 | 526 |
1855049 | 1855049 | 2021-10-26 | Edwards | Texas | 48137 | 325 | 7 |
1855050 | 1855050 | 2021-10-26 | El Paso | Texas | 48141 | 148294 | 2863 |
1855051 | 1855051 | 2021-10-26 | Ellis | Texas | 48139 | 33350 | 458 |
1855052 | 1855052 | 2021-10-26 | Erath | Texas | 48143 | 6304 | 101 |
1855053 | 1855053 | 2021-10-26 | Falls | Texas | 48145 | 2619 | 45 |
1855054 | 1855054 | 2021-10-26 | Fannin | Texas | 48147 | 4983 | 149 |
1855055 | 1855055 | 2021-10-26 | Fayette | Texas | 48149 | 3591 | 92 |
1855056 | 1855056 | 2021-10-26 | Fisher | Texas | 48151 | 417 | 16 |
1855057 | 1855057 | 2021-10-26 | Floyd | Texas | 48153 | 1177 | 38 |
1855058 | 1855058 | 2021-10-26 | Foard | Texas | 48155 | 181 | 10 |
1855059 | 1855059 | 2021-10-26 | Fort Bend | Texas | 48157 | 99809 | 957 |
1855060 | 1855060 | 2021-10-26 | Franklin | Texas | 48159 | 1330 | 35 |
1855061 | 1855061 | 2021-10-26 | Freestone | Texas | 48161 | 2756 | 67 |
1855062 | 1855062 | 2021-10-26 | Frio | Texas | 48163 | 3928 | 69 |
1855063 | 1855063 | 2021-10-26 | Gaines | Texas | 48165 | 2131 | 60 |
1855064 | 1855064 | 2021-10-26 | Galveston | Texas | 48167 | 63942 | 692 |
1855065 | 1855065 | 2021-10-26 | Garza | Texas | 48169 | 721 | 22 |
1855066 | 1855066 | 2021-10-26 | Gillespie | Texas | 48171 | 3517 | 77 |
1855067 | 1855067 | 2021-10-26 | Glasscock | Texas | 48173 | 154 | 3 |
1855068 | 1855068 | 2021-10-26 | Goliad | Texas | 48175 | 699 | 28 |
1855069 | 1855069 | 2021-10-26 | Gonzales | Texas | 48177 | 3536 | 83 |
1855070 | 1855070 | 2021-10-26 | Gray | Texas | 48179 | 3494 | 79 |
1855071 | 1855071 | 2021-10-26 | Grayson | Texas | 48181 | 16190 | 483 |
1855072 | 1855072 | 2021-10-26 | Gregg | Texas | 48183 | 19219 | 539 |
1855073 | 1855073 | 2021-10-26 | Grimes | Texas | 48185 | 5153 | 105 |
1855074 | 1855074 | 2021-10-26 | Guadalupe | Texas | 48187 | 24322 | 333 |
1855075 | 1855075 | 2021-10-26 | Hale | Texas | 48189 | 7894 | 187 |
1855076 | 1855076 | 2021-10-26 | Hall | Texas | 48191 | 542 | 15 |
1855077 | 1855077 | 2021-10-26 | Hamilton | Texas | 48193 | 1303 | 29 |
1855078 | 1855078 | 2021-10-26 | Hansford | Texas | 48195 | 1129 | 26 |
1855079 | 1855079 | 2021-10-26 | Hardeman | Texas | 48197 | 452 | 14 |
1855080 | 1855080 | 2021-10-26 | Hardin | Texas | 48199 | 10348 | 203 |
1855081 | 1855081 | 2021-10-26 | Harris | Texas | 48201 | 573925 | 9037 |
1855082 | 1855082 | 2021-10-26 | Harrison | Texas | 48203 | 9131 | 177 |
1855083 | 1855083 | 2021-10-26 | Hartley | Texas | 48205 | 857 | 2 |
1855084 | 1855084 | 2021-10-26 | Haskell | Texas | 48207 | 622 | 31 |
1855085 | 1855085 | 2021-10-26 | Hays | Texas | 48209 | 32847 | 396 |
1855086 | 1855086 | 2021-10-26 | Hemphill | Texas | 48211 | 700 | 3 |
1855087 | 1855087 | 2021-10-26 | Henderson | Texas | 48213 | 9730 | 333 |
1855088 | 1855088 | 2021-10-26 | Hidalgo | Texas | 48215 | 114622 | 3436 |
1855089 | 1855089 | 2021-10-26 | Hill | Texas | 48217 | 5796 | 158 |
1855090 | 1855090 | 2021-10-26 | Hockley | Texas | 48219 | 4241 | 131 |
1855091 | 1855091 | 2021-10-26 | Hood | Texas | 48221 | 9659 | 197 |
1855092 | 1855092 | 2021-10-26 | Hopkins | Texas | 48223 | 5368 | 144 |
1855093 | 1855093 | 2021-10-26 | Houston | Texas | 48225 | 2849 | 80 |
1855094 | 1855094 | 2021-10-26 | Howard | Texas | 48227 | 5754 | 133 |
1855095 | 1855095 | 2021-10-26 | Hudspeth | Texas | 48229 | 583 | 14 |
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);