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 55
- Texas 108,912
- Georgia 71,609
- Virginia 58,831
- Kentucky 52,612
- Missouri 50,639
- Illinois 45,203
- North Carolina 44,509
- Kansas 44,293
- Iowa 43,770
- Tennessee 42,751
- Indiana 41,250
- Ohio 39,464
- Minnesota 38,579
- Nebraska 37,982
- Michigan 37,230
- Mississippi 36,784
- Oklahoma 33,949
- Arkansas 33,648
- Puerto Rico 32,090
- Wisconsin 32,015
- Florida 30,718
- Pennsylvania 30,130
- Alabama 29,934
- Louisiana 29,258
- Colorado 28,215
- South Dakota 27,574
- New York 26,378
- California 26,340
- West Virginia 23,921
- North Dakota 22,517
- Montana 22,008
- South Carolina 20,773
- Idaho 18,530
- Washington 17,896
- Oregon 15,791
- New Mexico 14,354
- Utah 12,929
- Maryland 11,320
- Alaska 11,218
- Wyoming 10,156
- New Jersey 10,091
- Maine 7,504
- Nevada 7,146
- Massachusetts 6,919
- Arizona 6,873
- Vermont 6,763
- New Hampshire 4,949
- Connecticut 4,094
- Rhode Island 2,706
- Hawaii 2,053
- Delaware 1,799
- Virgin Islands 1,440
- Northern Mariana Islands 818
- District of Columbia 465
- Guam 457
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417347 | 1417347 | 2021-06-14 | Plumas | California | 6063 | 735 | 6 |
1417348 | 1417348 | 2021-06-14 | Riverside | California | 6065 | 301329 | 4620 |
1417349 | 1417349 | 2021-06-14 | Sacramento | California | 6067 | 107394 | 1723 |
1417350 | 1417350 | 2021-06-14 | San Benito | California | 6069 | 6086 | 63 |
1417351 | 1417351 | 2021-06-14 | San Bernardino | California | 6071 | 299014 | 4788 |
1417352 | 1417352 | 2021-06-14 | San Diego | California | 6073 | 281331 | 3770 |
1417353 | 1417353 | 2021-06-14 | San Francisco | California | 6075 | 37200 | 555 |
1417354 | 1417354 | 2021-06-14 | San Joaquin | California | 6077 | 74419 | 1432 |
1417355 | 1417355 | 2021-06-14 | San Luis Obispo | California | 6079 | 21411 | 261 |
1417356 | 1417356 | 2021-06-14 | San Mateo | California | 6081 | 42611 | 542 |
1417357 | 1417357 | 2021-06-14 | Santa Barbara | California | 6083 | 34577 | 460 |
1417358 | 1417358 | 2021-06-14 | Santa Clara | California | 6085 | 119946 | 2178 |
1417359 | 1417359 | 2021-06-14 | Santa Cruz | California | 6087 | 16206 | 208 |
1417360 | 1417360 | 2021-06-14 | Shasta | California | 6089 | 12580 | 232 |
1417361 | 1417361 | 2021-06-14 | Sierra | California | 6091 | 55 | 0 |
1417362 | 1417362 | 2021-06-14 | Siskiyou | California | 6093 | 2390 | 37 |
1417363 | 1417363 | 2021-06-14 | Solano | California | 6095 | 33630 | 266 |
1417364 | 1417364 | 2021-06-14 | Sonoma | California | 6097 | 30688 | 323 |
1417365 | 1417365 | 2021-06-14 | Stanislaus | California | 6099 | 63266 | 1068 |
1417366 | 1417366 | 2021-06-14 | Sutter | California | 6101 | 9614 | 112 |
1417367 | 1417367 | 2021-06-14 | Tehama | California | 6103 | 5100 | 63 |
1417368 | 1417368 | 2021-06-14 | Trinity | California | 6105 | 333 | 3 |
1417369 | 1417369 | 2021-06-14 | Tulare | California | 6107 | 49734 | 849 |
1417370 | 1417370 | 2021-06-14 | Tuolumne | California | 6109 | 4199 | 70 |
1417371 | 1417371 | 2021-06-14 | Ventura | California | 6111 | 81572 | 1028 |
1417372 | 1417372 | 2021-06-14 | Yolo | California | 6113 | 14120 | 212 |
1417373 | 1417373 | 2021-06-14 | Yuba | California | 6115 | 6461 | 50 |
1417374 | 1417374 | 2021-06-14 | Adams | Colorado | 8001 | 61498 | 748 |
1417375 | 1417375 | 2021-06-14 | Alamosa | Colorado | 8003 | 1711 | 36 |
1417376 | 1417376 | 2021-06-14 | Arapahoe | Colorado | 8005 | 63437 | 813 |
1417377 | 1417377 | 2021-06-14 | Archuleta | Colorado | 8007 | 1008 | 2 |
1417378 | 1417378 | 2021-06-14 | Baca | Colorado | 8009 | 319 | 4 |
1417379 | 1417379 | 2021-06-14 | Bent | Colorado | 8011 | 1545 | 22 |
1417380 | 1417380 | 2021-06-14 | Boulder | Colorado | 8013 | 23893 | 260 |
1417381 | 1417381 | 2021-06-14 | Broomfield | Colorado | 8014 | 4950 | 77 |
1417382 | 1417382 | 2021-06-14 | Chaffee | Colorado | 8015 | 1747 | 25 |
1417383 | 1417383 | 2021-06-14 | Cheyenne | Colorado | 8017 | 130 | 6 |
1417384 | 1417384 | 2021-06-14 | Clear Creek | Colorado | 8019 | 471 | 3 |
1417385 | 1417385 | 2021-06-14 | Conejos | Colorado | 8021 | 703 | 17 |
1417386 | 1417386 | 2021-06-14 | Costilla | Colorado | 8023 | 249 | 4 |
1417387 | 1417387 | 2021-06-14 | Crowley | Colorado | 8025 | 2210 | 16 |
1417388 | 1417388 | 2021-06-14 | Custer | Colorado | 8027 | 220 | 2 |
1417389 | 1417389 | 2021-06-14 | Delta | Colorado | 8029 | 2844 | 64 |
1417390 | 1417390 | 2021-06-14 | Denver | Colorado | 8031 | 73893 | 834 |
1417391 | 1417391 | 2021-06-14 | Dolores | Colorado | 8033 | 123 | 1 |
1417392 | 1417392 | 2021-06-14 | Douglas | Colorado | 8035 | 30696 | 264 |
1417393 | 1417393 | 2021-06-14 | Eagle | Colorado | 8037 | 6341 | 23 |
1417394 | 1417394 | 2021-06-14 | El Paso | Colorado | 8041 | 72148 | 857 |
1417395 | 1417395 | 2021-06-14 | Elbert | Colorado | 8039 | 1857 | 13 |
1417396 | 1417396 | 2021-06-14 | Fremont | Colorado | 8043 | 6505 | 63 |
1417397 | 1417397 | 2021-06-14 | Garfield | Colorado | 8045 | 6055 | 43 |
1417398 | 1417398 | 2021-06-14 | Gilpin | Colorado | 8047 | 278 | 3 |
1417399 | 1417399 | 2021-06-14 | Grand | Colorado | 8049 | 1500 | 7 |
1417400 | 1417400 | 2021-06-14 | Gunnison | Colorado | 8051 | 1370 | 6 |
1417401 | 1417401 | 2021-06-14 | Hinsdale | Colorado | 8053 | 19 | 0 |
1417402 | 1417402 | 2021-06-14 | Huerfano | Colorado | 8055 | 431 | 17 |
1417403 | 1417403 | 2021-06-14 | Jackson | Colorado | 8057 | 65 | 0 |
1417404 | 1417404 | 2021-06-14 | Jefferson | Colorado | 8059 | 48510 | 793 |
1417405 | 1417405 | 2021-06-14 | Kiowa | Colorado | 8061 | 95 | 3 |
1417406 | 1417406 | 2021-06-14 | Kit Carson | Colorado | 8063 | 637 | 11 |
1417407 | 1417407 | 2021-06-14 | La Plata | Colorado | 8067 | 4074 | 41 |
1417408 | 1417408 | 2021-06-14 | Lake | Colorado | 8065 | 824 | 0 |
1417409 | 1417409 | 2021-06-14 | Larimer | Colorado | 8069 | 27356 | 245 |
1417410 | 1417410 | 2021-06-14 | Las Animas | Colorado | 8071 | 1159 | 14 |
1417411 | 1417411 | 2021-06-14 | Lincoln | Colorado | 8073 | 1033 | 4 |
1417412 | 1417412 | 2021-06-14 | Logan | Colorado | 8075 | 4035 | 68 |
1417413 | 1417413 | 2021-06-14 | Mesa | Colorado | 8077 | 16516 | 239 |
1417414 | 1417414 | 2021-06-14 | Mineral | Colorado | 8079 | 93 | 1 |
1417415 | 1417415 | 2021-06-14 | Moffat | Colorado | 8081 | 916 | 23 |
1417416 | 1417416 | 2021-06-14 | Montezuma | Colorado | 8083 | 2035 | 25 |
1417417 | 1417417 | 2021-06-14 | Montrose | Colorado | 8085 | 3665 | 62 |
1417418 | 1417418 | 2021-06-14 | Morgan | Colorado | 8087 | 2720 | 95 |
1417419 | 1417419 | 2021-06-14 | Otero | Colorado | 8089 | 2071 | 67 |
1417420 | 1417420 | 2021-06-14 | Ouray | Colorado | 8091 | 289 | 3 |
1417421 | 1417421 | 2021-06-14 | Park | Colorado | 8093 | 826 | 5 |
1417422 | 1417422 | 2021-06-14 | Phillips | Colorado | 8095 | 398 | 13 |
1417423 | 1417423 | 2021-06-14 | Pitkin | Colorado | 8097 | 2604 | 4 |
1417424 | 1417424 | 2021-06-14 | Prowers | Colorado | 8099 | 1271 | 22 |
1417425 | 1417425 | 2021-06-14 | Pueblo | Colorado | 8101 | 19409 | 414 |
1417426 | 1417426 | 2021-06-14 | Rio Blanco | Colorado | 8103 | 589 | 5 |
1417427 | 1417427 | 2021-06-14 | Rio Grande | Colorado | 8105 | 888 | 16 |
1417428 | 1417428 | 2021-06-14 | Routt | Colorado | 8107 | 2267 | 21 |
1417429 | 1417429 | 2021-06-14 | Saguache | Colorado | 8109 | 426 | 5 |
1417430 | 1417430 | 2021-06-14 | San Juan | Colorado | 8111 | 48 | 0 |
1417431 | 1417431 | 2021-06-14 | San Miguel | Colorado | 8113 | 911 | 0 |
1417432 | 1417432 | 2021-06-14 | Sedgwick | Colorado | 8115 | 236 | 3 |
1417433 | 1417433 | 2021-06-14 | Summit | Colorado | 8117 | 3742 | 8 |
1417434 | 1417434 | 2021-06-14 | Teller | Colorado | 8119 | 1886 | 17 |
1417435 | 1417435 | 2021-06-14 | Washington | Colorado | 8121 | 471 | 13 |
1417436 | 1417436 | 2021-06-14 | Weld | Colorado | 8123 | 33104 | 346 |
1417437 | 1417437 | 2021-06-14 | Yuma | Colorado | 8125 | 963 | 17 |
1417438 | 1417438 | 2021-06-14 | Fairfield | Connecticut | 9001 | 100293 | 2201 |
1417439 | 1417439 | 2021-06-14 | Hartford | Connecticut | 9003 | 84300 | 2431 |
1417440 | 1417440 | 2021-06-14 | Litchfield | Connecticut | 9005 | 14634 | 298 |
1417441 | 1417441 | 2021-06-14 | Middlesex | Connecticut | 9007 | 12824 | 372 |
1417442 | 1417442 | 2021-06-14 | New Haven | Connecticut | 9009 | 92170 | 2128 |
1417443 | 1417443 | 2021-06-14 | New London | Connecticut | 9011 | 22534 | 450 |
1417444 | 1417444 | 2021-06-14 | Tolland | Connecticut | 9013 | 9621 | 187 |
1417445 | 1417445 | 2021-06-14 | Unknown | Connecticut | 1181 | 1 | |
1417446 | 1417446 | 2021-06-14 | Windham | Connecticut | 9015 | 10908 | 195 |
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);