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 139,646
- Georgia 90,969
- Virginia 74,926
- Kentucky 67,132
- Missouri 64,796
- Illinois 57,666
- Kansas 56,998
- North Carolina 56,609
- Iowa 55,870
- Tennessee 54,367
- Indiana 52,382
- Ohio 50,233
- Nebraska 49,327
- Minnesota 49,227
- Michigan 47,394
- Mississippi 46,706
- Oklahoma 43,387
- Arkansas 42,844
- Puerto Rico 41,649
- Wisconsin 40,729
- Florida 38,946
- Pennsylvania 38,237
- Alabama 38,041
- Louisiana 37,122
- Colorado 35,959
- South Dakota 35,560
- New York 33,396
- California 33,383
- West Virginia 30,578
- North Dakota 29,051
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810317 | 1810317 | 2021-10-13 | Inyo | California | 6027 | 1918 | 39 |
1810318 | 1810318 | 2021-10-13 | Kern | California | 6029 | 143272 | 1597 |
1810319 | 1810319 | 2021-10-13 | Kings | California | 6031 | 32093 | 312 |
1810320 | 1810320 | 2021-10-13 | Lake | California | 6033 | 6500 | 97 |
1810321 | 1810321 | 2021-10-13 | Lassen | California | 6035 | 7418 | 43 |
1810322 | 1810322 | 2021-10-13 | Los Angeles | California | 6037 | 1474114 | 26362 |
1810323 | 1810323 | 2021-10-13 | Madera | California | 6039 | 23319 | 277 |
1810324 | 1810324 | 2021-10-13 | Marin | California | 6041 | 17551 | 242 |
1810325 | 1810325 | 2021-10-13 | Mariposa | California | 6043 | 1231 | 15 |
1810326 | 1810326 | 2021-10-13 | Mendocino | California | 6045 | 7480 | 86 |
1810327 | 1810327 | 2021-10-13 | Merced | California | 6047 | 41912 | 581 |
1810328 | 1810328 | 2021-10-13 | Modoc | California | 6049 | 794 | 8 |
1810329 | 1810329 | 2021-10-13 | Mono | California | 6051 | 1624 | 5 |
1810330 | 1810330 | 2021-10-13 | Monterey | California | 6053 | 50592 | 586 |
1810331 | 1810331 | 2021-10-13 | Napa | California | 6055 | 12769 | 97 |
1810332 | 1810332 | 2021-10-13 | Nevada | California | 6057 | 9008 | 90 |
1810333 | 1810333 | 2021-10-13 | Orange | California | 6059 | 322299 | 5508 |
1810334 | 1810334 | 2021-10-13 | Placer | California | 6061 | 38714 | 405 |
1810335 | 1810335 | 2021-10-13 | Plumas | California | 6063 | 1518 | 6 |
1810336 | 1810336 | 2021-10-13 | Riverside | California | 6065 | 368590 | 5068 |
1810337 | 1810337 | 2021-10-13 | Sacramento | California | 6067 | 157142 | 2256 |
1810338 | 1810338 | 2021-10-13 | San Benito | California | 6069 | 7350 | 71 |
1810339 | 1810339 | 2021-10-13 | San Bernardino | California | 6071 | 355666 | 5563 |
1810340 | 1810340 | 2021-10-13 | San Diego | California | 6073 | 379091 | 4137 |
1810341 | 1810341 | 2021-10-13 | San Francisco | California | 6075 | 53860 | 643 |
1810342 | 1810342 | 2021-10-13 | San Joaquin | California | 6077 | 101461 | 1702 |
1810343 | 1810343 | 2021-10-13 | San Luis Obispo | California | 6079 | 29562 | 331 |
1810344 | 1810344 | 2021-10-13 | San Mateo | California | 6081 | 53724 | 618 |
1810345 | 1810345 | 2021-10-13 | Santa Barbara | California | 6083 | 44720 | 515 |
1810346 | 1810346 | 2021-10-13 | Santa Clara | California | 6085 | 144154 | 1883 |
1810347 | 1810347 | 2021-10-13 | Santa Cruz | California | 6087 | 20819 | 218 |
1810348 | 1810348 | 2021-10-13 | Shasta | California | 6089 | 23083 | 334 |
1810349 | 1810349 | 2021-10-13 | Sierra | California | 6091 | 169 | 0 |
1810350 | 1810350 | 2021-10-13 | Siskiyou | California | 6093 | 4557 | 56 |
1810351 | 1810351 | 2021-10-13 | Solano | California | 6095 | 45686 | 329 |
1810352 | 1810352 | 2021-10-13 | Sonoma | California | 6097 | 40613 | 398 |
1810353 | 1810353 | 2021-10-13 | Stanislaus | California | 6099 | 84709 | 1302 |
1810354 | 1810354 | 2021-10-13 | Sutter | California | 6101 | 13721 | 168 |
1810355 | 1810355 | 2021-10-13 | Tehama | California | 6103 | 9156 | 103 |
1810356 | 1810356 | 2021-10-13 | Trinity | California | 6105 | 854 | 11 |
1810357 | 1810357 | 2021-10-13 | Tulare | California | 6107 | 78346 | 944 |
1810358 | 1810358 | 2021-10-13 | Tuolumne | California | 6109 | 6842 | 107 |
1810359 | 1810359 | 2021-10-13 | Ventura | California | 6111 | 100337 | 1160 |
1810360 | 1810360 | 2021-10-13 | Yolo | California | 6113 | 20028 | 247 |
1810361 | 1810361 | 2021-10-13 | Yuba | California | 6115 | 10284 | 71 |
1810362 | 1810362 | 2021-10-13 | Adams | Colorado | 8001 | 74013 | 861 |
1810363 | 1810363 | 2021-10-13 | Alamosa | Colorado | 8003 | 2293 | 43 |
1810364 | 1810364 | 2021-10-13 | Arapahoe | Colorado | 8005 | 77970 | 907 |
1810365 | 1810365 | 2021-10-13 | Archuleta | Colorado | 8007 | 1418 | 4 |
1810366 | 1810366 | 2021-10-13 | Baca | Colorado | 8009 | 413 | 5 |
1810367 | 1810367 | 2021-10-13 | Bent | Colorado | 8011 | 1656 | 23 |
1810368 | 1810368 | 2021-10-13 | Boulder | Colorado | 8013 | 29831 | 273 |
1810369 | 1810369 | 2021-10-13 | Broomfield | Colorado | 8014 | 6437 | 80 |
1810370 | 1810370 | 2021-10-13 | Chaffee | Colorado | 8015 | 2159 | 30 |
1810371 | 1810371 | 2021-10-13 | Cheyenne | Colorado | 8017 | 164 | 7 |
1810372 | 1810372 | 2021-10-13 | Clear Creek | Colorado | 8019 | 742 | 5 |
1810373 | 1810373 | 2021-10-13 | Conejos | Colorado | 8021 | 953 | 32 |
1810374 | 1810374 | 2021-10-13 | Costilla | Colorado | 8023 | 354 | 10 |
1810375 | 1810375 | 2021-10-13 | Crowley | Colorado | 8025 | 2337 | 22 |
1810376 | 1810376 | 2021-10-13 | Custer | Colorado | 8027 | 340 | 6 |
1810377 | 1810377 | 2021-10-13 | Delta | Colorado | 8029 | 3727 | 81 |
1810378 | 1810378 | 2021-10-13 | Denver | Colorado | 8031 | 88415 | 921 |
1810379 | 1810379 | 2021-10-13 | Dolores | Colorado | 8033 | 227 | 2 |
1810380 | 1810380 | 2021-10-13 | Douglas | Colorado | 8035 | 39406 | 308 |
1810381 | 1810381 | 2021-10-13 | Eagle | Colorado | 8037 | 8082 | 31 |
1810382 | 1810382 | 2021-10-13 | El Paso | Colorado | 8041 | 96167 | 1059 |
1810383 | 1810383 | 2021-10-13 | Elbert | Colorado | 8039 | 2567 | 22 |
1810384 | 1810384 | 2021-10-13 | Fremont | Colorado | 8043 | 7936 | 84 |
1810385 | 1810385 | 2021-10-13 | Garfield | Colorado | 8045 | 7597 | 60 |
1810386 | 1810386 | 2021-10-13 | Gilpin | Colorado | 8047 | 412 | 3 |
1810387 | 1810387 | 2021-10-13 | Grand | Colorado | 8049 | 2093 | 10 |
1810388 | 1810388 | 2021-10-13 | Gunnison | Colorado | 8051 | 1794 | 10 |
1810389 | 1810389 | 2021-10-13 | Hinsdale | Colorado | 8053 | 54 | 0 |
1810390 | 1810390 | 2021-10-13 | Huerfano | Colorado | 8055 | 596 | 19 |
1810391 | 1810391 | 2021-10-13 | Jackson | Colorado | 8057 | 101 | 0 |
1810392 | 1810392 | 2021-10-13 | Jefferson | Colorado | 8059 | 60330 | 888 |
1810393 | 1810393 | 2021-10-13 | Kiowa | Colorado | 8061 | 134 | 4 |
1810394 | 1810394 | 2021-10-13 | Kit Carson | Colorado | 8063 | 909 | 14 |
1810395 | 1810395 | 2021-10-13 | La Plata | Colorado | 8067 | 5529 | 52 |
1810396 | 1810396 | 2021-10-13 | Lake | Colorado | 8065 | 978 | 1 |
1810397 | 1810397 | 2021-10-13 | Larimer | Colorado | 8069 | 37010 | 291 |
1810398 | 1810398 | 2021-10-13 | Las Animas | Colorado | 8071 | 1715 | 21 |
1810399 | 1810399 | 2021-10-13 | Lincoln | Colorado | 8073 | 1274 | 7 |
1810400 | 1810400 | 2021-10-13 | Logan | Colorado | 8075 | 4548 | 79 |
1810401 | 1810401 | 2021-10-13 | Mesa | Colorado | 8077 | 22687 | 309 |
1810402 | 1810402 | 2021-10-13 | Mineral | Colorado | 8079 | 124 | 1 |
1810403 | 1810403 | 2021-10-13 | Moffat | Colorado | 8081 | 1881 | 37 |
1810404 | 1810404 | 2021-10-13 | Montezuma | Colorado | 8083 | 2866 | 34 |
1810405 | 1810405 | 2021-10-13 | Montrose | Colorado | 8085 | 5011 | 79 |
1810406 | 1810406 | 2021-10-13 | Morgan | Colorado | 8087 | 3244 | 98 |
1810407 | 1810407 | 2021-10-13 | Otero | Colorado | 8089 | 2453 | 78 |
1810408 | 1810408 | 2021-10-13 | Ouray | Colorado | 8091 | 416 | 5 |
1810409 | 1810409 | 2021-10-13 | Park | Colorado | 8093 | 1305 | 8 |
1810410 | 1810410 | 2021-10-13 | Phillips | Colorado | 8095 | 491 | 14 |
1810411 | 1810411 | 2021-10-13 | Pitkin | Colorado | 8097 | 3065 | 5 |
1810412 | 1810412 | 2021-10-13 | Prowers | Colorado | 8099 | 1550 | 29 |
1810413 | 1810413 | 2021-10-13 | Pueblo | Colorado | 8101 | 23681 | 469 |
1810414 | 1810414 | 2021-10-13 | Rio Blanco | Colorado | 8103 | 908 | 8 |
1810415 | 1810415 | 2021-10-13 | Rio Grande | Colorado | 8105 | 1395 | 21 |
1810416 | 1810416 | 2021-10-13 | Routt | Colorado | 8107 | 3224 | 23 |
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);