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 91,386
- Georgia 60,569
- Virginia 49,654
- Kentucky 44,332
- Missouri 42,565
- Illinois 38,096
- North Carolina 37,609
- Kansas 37,037
- Iowa 36,870
- Tennessee 36,127
- Indiana 34,902
- Ohio 33,323
- Minnesota 32,507
- Nebraska 31,515
- Michigan 31,434
- Mississippi 31,126
- Oklahoma 28,567
- Arkansas 28,480
- Wisconsin 27,047
- Puerto Rico 26,639
- Florida 26,026
- Pennsylvania 25,507
- Alabama 25,311
- Louisiana 24,773
- Colorado 23,799
- South Dakota 23,020
- New York 22,376
- California 22,369
- West Virginia 20,126
- North Dakota 18,791
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193209 | 1193209 | 2021-04-06 | Greenlee | Arizona | 4011 | 566 | 10 |
1193210 | 1193210 | 2021-04-06 | La Paz | Arizona | 4012 | 2446 | 77 |
1193211 | 1193211 | 2021-04-06 | Maricopa | Arizona | 4013 | 526415 | 9670 |
1193212 | 1193212 | 2021-04-06 | Mohave | Arizona | 4015 | 22238 | 691 |
1193213 | 1193213 | 2021-04-06 | Navajo | Arizona | 4017 | 15746 | 521 |
1193214 | 1193214 | 2021-04-06 | Pima | Arizona | 4019 | 113171 | 2359 |
1193215 | 1193215 | 2021-04-06 | Pinal | Arizona | 4021 | 49900 | 858 |
1193216 | 1193216 | 2021-04-06 | Santa Cruz | Arizona | 4023 | 7851 | 173 |
1193217 | 1193217 | 2021-04-06 | Yavapai | Arizona | 4025 | 18378 | 490 |
1193218 | 1193218 | 2021-04-06 | Yuma | Arizona | 4027 | 36804 | 821 |
1193219 | 1193219 | 2021-04-06 | Arkansas | Arkansas | 5001 | 2081 | 36 |
1193220 | 1193220 | 2021-04-06 | Ashley | Arkansas | 5003 | 1907 | 33 |
1193221 | 1193221 | 2021-04-06 | Baxter | Arkansas | 5005 | 3088 | 100 |
1193222 | 1193222 | 2021-04-06 | Benton | Arkansas | 5007 | 28252 | 409 |
1193223 | 1193223 | 2021-04-06 | Boone | Arkansas | 5009 | 3744 | 79 |
1193224 | 1193224 | 2021-04-06 | Bradley | Arkansas | 5011 | 1356 | 32 |
1193225 | 1193225 | 2021-04-06 | Calhoun | Arkansas | 5013 | 409 | 3 |
1193226 | 1193226 | 2021-04-06 | Carroll | Arkansas | 5015 | 2755 | 44 |
1193227 | 1193227 | 2021-04-06 | Chicot | Arkansas | 5017 | 1610 | 40 |
1193228 | 1193228 | 2021-04-06 | Clark | Arkansas | 5019 | 2090 | 40 |
1193229 | 1193229 | 2021-04-06 | Clay | Arkansas | 5021 | 1723 | 50 |
1193230 | 1193230 | 2021-04-06 | Cleburne | Arkansas | 5023 | 1948 | 73 |
1193231 | 1193231 | 2021-04-06 | Cleveland | Arkansas | 5025 | 941 | 25 |
1193232 | 1193232 | 2021-04-06 | Columbia | Arkansas | 5027 | 2322 | 55 |
1193233 | 1193233 | 2021-04-06 | Conway | Arkansas | 5029 | 2192 | 32 |
1193234 | 1193234 | 2021-04-06 | Craighead | Arkansas | 5031 | 13109 | 175 |
1193235 | 1193235 | 2021-04-06 | Crawford | Arkansas | 5033 | 6996 | 115 |
1193236 | 1193236 | 2021-04-06 | Crittenden | Arkansas | 5035 | 5895 | 96 |
1193237 | 1193237 | 2021-04-06 | Cross | Arkansas | 5037 | 1929 | 49 |
1193238 | 1193238 | 2021-04-06 | Dallas | Arkansas | 5039 | 757 | 15 |
1193239 | 1193239 | 2021-04-06 | Desha | Arkansas | 5041 | 1357 | 24 |
1193240 | 1193240 | 2021-04-06 | Drew | Arkansas | 5043 | 1985 | 41 |
1193241 | 1193241 | 2021-04-06 | Faulkner | Arkansas | 5045 | 12240 | 157 |
1193242 | 1193242 | 2021-04-06 | Franklin | Arkansas | 5047 | 1680 | 39 |
1193243 | 1193243 | 2021-04-06 | Fulton | Arkansas | 5049 | 1101 | 47 |
1193244 | 1193244 | 2021-04-06 | Garland | Arkansas | 5051 | 10050 | 255 |
1193245 | 1193245 | 2021-04-06 | Grant | Arkansas | 5053 | 1637 | 32 |
1193246 | 1193246 | 2021-04-06 | Greene | Arkansas | 5055 | 6027 | 75 |
1193247 | 1193247 | 2021-04-06 | Hempstead | Arkansas | 5057 | 1984 | 20 |
1193248 | 1193248 | 2021-04-06 | Hot Spring | Arkansas | 5059 | 5015 | 71 |
1193249 | 1193249 | 2021-04-06 | Howard | Arkansas | 5061 | 1641 | 24 |
1193250 | 1193250 | 2021-04-06 | Independence | Arkansas | 5063 | 3724 | 121 |
1193251 | 1193251 | 2021-04-06 | Izard | Arkansas | 5065 | 1662 | 41 |
1193252 | 1193252 | 2021-04-06 | Jackson | Arkansas | 5067 | 3210 | 38 |
1193253 | 1193253 | 2021-04-06 | Jefferson | Arkansas | 5069 | 8751 | 163 |
1193254 | 1193254 | 2021-04-06 | Johnson | Arkansas | 5071 | 2885 | 37 |
1193255 | 1193255 | 2021-04-06 | Lafayette | Arkansas | 5073 | 542 | 9 |
1193256 | 1193256 | 2021-04-06 | Lawrence | Arkansas | 5075 | 2071 | 43 |
1193257 | 1193257 | 2021-04-06 | Lee | Arkansas | 5077 | 1659 | 34 |
1193258 | 1193258 | 2021-04-06 | Lincoln | Arkansas | 5079 | 3183 | 48 |
1193259 | 1193259 | 2021-04-06 | Little River | Arkansas | 5081 | 1224 | 41 |
1193260 | 1193260 | 2021-04-06 | Logan | Arkansas | 5083 | 2206 | 22 |
1193261 | 1193261 | 2021-04-06 | Lonoke | Arkansas | 5085 | 7072 | 116 |
1193262 | 1193262 | 2021-04-06 | Madison | Arkansas | 5087 | 1438 | 22 |
1193263 | 1193263 | 2021-04-06 | Marion | Arkansas | 5089 | 1034 | 30 |
1193264 | 1193264 | 2021-04-06 | Miller | Arkansas | 5091 | 4222 | 36 |
1193265 | 1193265 | 2021-04-06 | Mississippi | Arkansas | 5093 | 5764 | 106 |
1193266 | 1193266 | 2021-04-06 | Monroe | Arkansas | 5095 | 862 | 17 |
1193267 | 1193267 | 2021-04-06 | Montgomery | Arkansas | 5097 | 751 | 33 |
1193268 | 1193268 | 2021-04-06 | Nevada | Arkansas | 5099 | 818 | 24 |
1193269 | 1193269 | 2021-04-06 | Newton | Arkansas | 5101 | 707 | 26 |
1193270 | 1193270 | 2021-04-06 | Ouachita | Arkansas | 5103 | 2292 | 60 |
1193271 | 1193271 | 2021-04-06 | Perry | Arkansas | 5105 | 827 | 10 |
1193272 | 1193272 | 2021-04-06 | Phillips | Arkansas | 5107 | 1746 | 37 |
1193273 | 1193273 | 2021-04-06 | Pike | Arkansas | 5109 | 997 | 22 |
1193274 | 1193274 | 2021-04-06 | Poinsett | Arkansas | 5111 | 3119 | 76 |
1193275 | 1193275 | 2021-04-06 | Polk | Arkansas | 5113 | 1964 | 71 |
1193276 | 1193276 | 2021-04-06 | Pope | Arkansas | 5115 | 7881 | 107 |
1193277 | 1193277 | 2021-04-06 | Prairie | Arkansas | 5117 | 888 | 20 |
1193278 | 1193278 | 2021-04-06 | Pulaski | Arkansas | 5119 | 38429 | 631 |
1193279 | 1193279 | 2021-04-06 | Randolph | Arkansas | 5121 | 2066 | 47 |
1193280 | 1193280 | 2021-04-06 | Saline | Arkansas | 5125 | 11744 | 166 |
1193281 | 1193281 | 2021-04-06 | Scott | Arkansas | 5127 | 928 | 14 |
1193282 | 1193282 | 2021-04-06 | Searcy | Arkansas | 5129 | 673 | 17 |
1193283 | 1193283 | 2021-04-06 | Sebastian | Arkansas | 5131 | 15065 | 272 |
1193284 | 1193284 | 2021-04-06 | Sevier | Arkansas | 5133 | 2780 | 24 |
1193285 | 1193285 | 2021-04-06 | Sharp | Arkansas | 5135 | 1554 | 45 |
1193286 | 1193286 | 2021-04-06 | St. Francis | Arkansas | 5123 | 3529 | 41 |
1193287 | 1193287 | 2021-04-06 | Stone | Arkansas | 5137 | 983 | 30 |
1193288 | 1193288 | 2021-04-06 | Union | Arkansas | 5139 | 3948 | 111 |
1193289 | 1193289 | 2021-04-06 | Unknown | Arkansas | 2795 | 0 | |
1193290 | 1193290 | 2021-04-06 | Van Buren | Arkansas | 5141 | 1259 | 21 |
1193291 | 1193291 | 2021-04-06 | Washington | Arkansas | 5143 | 30302 | 344 |
1193292 | 1193292 | 2021-04-06 | White | Arkansas | 5145 | 7840 | 118 |
1193293 | 1193293 | 2021-04-06 | Woodruff | Arkansas | 5147 | 636 | 12 |
1193294 | 1193294 | 2021-04-06 | Yell | Arkansas | 5149 | 3410 | 64 |
1193295 | 1193295 | 2021-04-06 | Alameda | California | 6001 | 84028 | 1432 |
1193296 | 1193296 | 2021-04-06 | Alpine | California | 6003 | 88 | 0 |
1193297 | 1193297 | 2021-04-06 | Amador | California | 6005 | 3583 | 45 |
1193298 | 1193298 | 2021-04-06 | Butte | California | 6007 | 11384 | 193 |
1193299 | 1193299 | 2021-04-06 | Calaveras | California | 6009 | 2019 | 51 |
1193300 | 1193300 | 2021-04-06 | Colusa | California | 6011 | 2171 | 16 |
1193301 | 1193301 | 2021-04-06 | Contra Costa | California | 6013 | 65835 | 774 |
1193302 | 1193302 | 2021-04-06 | Del Norte | California | 6015 | 1230 | 6 |
1193303 | 1193303 | 2021-04-06 | El Dorado | California | 6017 | 9463 | 108 |
1193304 | 1193304 | 2021-04-06 | Fresno | California | 6019 | 99755 | 1622 |
1193305 | 1193305 | 2021-04-06 | Glenn | California | 6021 | 2845 | 25 |
1193306 | 1193306 | 2021-04-06 | Humboldt | California | 6023 | 3500 | 36 |
1193307 | 1193307 | 2021-04-06 | Imperial | California | 6025 | 27604 | 711 |
1193308 | 1193308 | 2021-04-06 | Inyo | California | 6027 | 1377 | 36 |
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);