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 73,098
- Georgia 49,049
- Virginia 40,078
- Kentucky 35,692
- Missouri 34,141
- Illinois 30,685
- North Carolina 30,409
- Iowa 29,670
- Kansas 29,405
- Tennessee 29,215
- Indiana 28,278
- Ohio 26,954
- Minnesota 26,171
- Michigan 25,386
- Mississippi 25,222
- Nebraska 24,815
- Oklahoma 22,952
- Arkansas 22,938
- Wisconsin 21,863
- Florida 21,130
- Puerto Rico 20,951
- Pennsylvania 20,683
- Alabama 20,487
- Louisiana 20,093
- Colorado 19,191
- South Dakota 18,268
- New York 18,200
- California 18,193
- West Virginia 16,166
- North Dakota 14,903
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959563 | 959563 | 2021-01-24 | Unknown | Arkansas | 2917 | 0 | |
959564 | 959564 | 2021-01-24 | Van Buren | Arkansas | 5141 | 1039 | 12 |
959565 | 959565 | 2021-01-24 | Washington | Arkansas | 5143 | 26790 | 283 |
959566 | 959566 | 2021-01-24 | White | Arkansas | 5145 | 6241 | 83 |
959567 | 959567 | 2021-01-24 | Woodruff | Arkansas | 5147 | 524 | 5 |
959568 | 959568 | 2021-01-24 | Yell | Arkansas | 5149 | 2966 | 59 |
959569 | 959569 | 2021-01-24 | Alameda | California | 6001 | 70355 | 894 |
959570 | 959570 | 2021-01-24 | Alpine | California | 6003 | 72 | 0 |
959571 | 959571 | 2021-01-24 | Amador | California | 6005 | 3048 | 32 |
959572 | 959572 | 2021-01-24 | Butte | California | 6007 | 9757 | 134 |
959573 | 959573 | 2021-01-24 | Calaveras | California | 6009 | 1695 | 23 |
959574 | 959574 | 2021-01-24 | Colusa | California | 6011 | 1854 | 9 |
959575 | 959575 | 2021-01-24 | Contra Costa | California | 6013 | 54951 | 488 |
959576 | 959576 | 2021-01-24 | Del Norte | California | 6015 | 873 | 2 |
959577 | 959577 | 2021-01-24 | El Dorado | California | 6017 | 7984 | 59 |
959578 | 959578 | 2021-01-24 | Fresno | California | 6019 | 85274 | 1043 |
959579 | 959579 | 2021-01-24 | Glenn | California | 6021 | 2339 | 22 |
959580 | 959580 | 2021-01-24 | Humboldt | California | 6023 | 2494 | 25 |
959581 | 959581 | 2021-01-24 | Imperial | California | 6025 | 25581 | 492 |
959582 | 959582 | 2021-01-24 | Inyo | California | 6027 | 987 | 29 |
959583 | 959583 | 2021-01-24 | Kern | California | 6029 | 90213 | 590 |
959584 | 959584 | 2021-01-24 | Kings | California | 6031 | 19904 | 160 |
959585 | 959585 | 2021-01-24 | Lake | California | 6033 | 2673 | 32 |
959586 | 959586 | 2021-01-24 | Lassen | California | 6035 | 5269 | 16 |
959587 | 959587 | 2021-01-24 | Los Angeles | California | 6037 | 1073533 | 15260 |
959588 | 959588 | 2021-01-24 | Madera | California | 6039 | 13858 | 151 |
959589 | 959589 | 2021-01-24 | Marin | California | 6041 | 11953 | 163 |
959590 | 959590 | 2021-01-24 | Mariposa | California | 6043 | 351 | 4 |
959591 | 959591 | 2021-01-24 | Mendocino | California | 6045 | 3277 | 36 |
959592 | 959592 | 2021-01-24 | Merced | California | 6047 | 25048 | 324 |
959593 | 959593 | 2021-01-24 | Modoc | California | 6049 | 385 | 3 |
959594 | 959594 | 2021-01-24 | Mono | California | 6051 | 1111 | 4 |
959595 | 959595 | 2021-01-24 | Monterey | California | 6053 | 37285 | 259 |
959596 | 959596 | 2021-01-24 | Napa | California | 6055 | 7894 | 47 |
959597 | 959597 | 2021-01-24 | Nevada | California | 6057 | 3332 | 74 |
959598 | 959598 | 2021-01-24 | Orange | California | 6059 | 236312 | 2638 |
959599 | 959599 | 2021-01-24 | Placer | California | 6061 | 17675 | 188 |
959600 | 959600 | 2021-01-24 | Plumas | California | 6063 | 528 | 5 |
959601 | 959601 | 2021-01-24 | Riverside | California | 6065 | 258352 | 2777 |
959602 | 959602 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
959603 | 959603 | 2021-01-24 | San Benito | California | 6069 | 5166 | 48 |
959604 | 959604 | 2021-01-24 | San Bernardino | California | 6071 | 264457 | 1667 |
959605 | 959605 | 2021-01-24 | San Diego | California | 6073 | 227258 | 2375 |
959606 | 959606 | 2021-01-24 | San Francisco | California | 6075 | 30311 | 293 |
959607 | 959607 | 2021-01-24 | San Joaquin | California | 6077 | 59395 | 808 |
959608 | 959608 | 2021-01-24 | San Luis Obispo | California | 6079 | 16652 | 151 |
959609 | 959609 | 2021-01-24 | San Mateo | California | 6081 | 33731 | 340 |
959610 | 959610 | 2021-01-24 | Santa Barbara | California | 6083 | 26820 | 265 |
959611 | 959611 | 2021-01-24 | Santa Clara | California | 6085 | 98057 | 1235 |
959612 | 959612 | 2021-01-24 | Santa Cruz | California | 6087 | 12771 | 130 |
959613 | 959613 | 2021-01-24 | Shasta | California | 6089 | 9951 | 129 |
959614 | 959614 | 2021-01-24 | Sierra | California | 6091 | 41 | 0 |
959615 | 959615 | 2021-01-24 | Siskiyou | California | 6093 | 1484 | 13 |
959616 | 959616 | 2021-01-24 | Solano | California | 6095 | 26499 | 111 |
959617 | 959617 | 2021-01-24 | Sonoma | California | 6097 | 24935 | 247 |
959618 | 959618 | 2021-01-24 | Stanislaus | California | 6099 | 48753 | 788 |
959619 | 959619 | 2021-01-24 | Sutter | California | 6101 | 7943 | 83 |
959620 | 959620 | 2021-01-24 | Tehama | California | 6103 | 4006 | 46 |
959621 | 959621 | 2021-01-24 | Trinity | California | 6105 | 263 | 4 |
959622 | 959622 | 2021-01-24 | Tulare | California | 6107 | 42759 | 531 |
959623 | 959623 | 2021-01-24 | Tuolumne | California | 6109 | 3443 | 40 |
959624 | 959624 | 2021-01-24 | Ventura | California | 6111 | 65581 | 507 |
959625 | 959625 | 2021-01-24 | Yolo | California | 6113 | 11087 | 138 |
959626 | 959626 | 2021-01-24 | Yuba | California | 6115 | 5049 | 29 |
959627 | 959627 | 2021-01-24 | Adams | Colorado | 8001 | 45480 | 587 |
959628 | 959628 | 2021-01-24 | Alamosa | Colorado | 8003 | 1118 | 27 |
959629 | 959629 | 2021-01-24 | Arapahoe | Colorado | 8005 | 44488 | 644 |
959630 | 959630 | 2021-01-24 | Archuleta | Colorado | 8007 | 592 | 1 |
959631 | 959631 | 2021-01-24 | Baca | Colorado | 8009 | 262 | 3 |
959632 | 959632 | 2021-01-24 | Bent | Colorado | 8011 | 1283 | 20 |
959633 | 959633 | 2021-01-24 | Boulder | Colorado | 8013 | 16848 | 219 |
959634 | 959634 | 2021-01-24 | Broomfield | Colorado | 8014 | 3313 | 69 |
959635 | 959635 | 2021-01-24 | Chaffee | Colorado | 8015 | 1258 | 23 |
959636 | 959636 | 2021-01-24 | Cheyenne | Colorado | 8017 | 113 | 5 |
959637 | 959637 | 2021-01-24 | Clear Creek | Colorado | 8019 | 340 | 2 |
959638 | 959638 | 2021-01-24 | Conejos | Colorado | 8021 | 394 | 3 |
959639 | 959639 | 2021-01-24 | Costilla | Colorado | 8023 | 175 | 2 |
959640 | 959640 | 2021-01-24 | Crowley | Colorado | 8025 | 1764 | 14 |
959641 | 959641 | 2021-01-24 | Custer | Colorado | 8027 | 159 | 1 |
959642 | 959642 | 2021-01-24 | Delta | Colorado | 8029 | 2240 | 48 |
959643 | 959643 | 2021-01-24 | Denver | Colorado | 8031 | 54554 | 732 |
959644 | 959644 | 2021-01-24 | Dolores | Colorado | 8033 | 61 | 0 |
959645 | 959645 | 2021-01-24 | Douglas | Colorado | 8035 | 18710 | 224 |
959646 | 959646 | 2021-01-24 | Eagle | Colorado | 8037 | 4192 | 18 |
959647 | 959647 | 2021-01-24 | El Paso | Colorado | 8041 | 46875 | 685 |
959648 | 959648 | 2021-01-24 | Elbert | Colorado | 8039 | 1120 | 12 |
959649 | 959649 | 2021-01-24 | Fremont | Colorado | 8043 | 5075 | 35 |
959650 | 959650 | 2021-01-24 | Garfield | Colorado | 8045 | 4640 | 36 |
959651 | 959651 | 2021-01-24 | Gilpin | Colorado | 8047 | 144 | 2 |
959652 | 959652 | 2021-01-24 | Grand | Colorado | 8049 | 898 | 5 |
959653 | 959653 | 2021-01-24 | Gunnison | Colorado | 8051 | 987 | 6 |
959654 | 959654 | 2021-01-24 | Hinsdale | Colorado | 8053 | 15 | 0 |
959655 | 959655 | 2021-01-24 | Huerfano | Colorado | 8055 | 288 | 17 |
959656 | 959656 | 2021-01-24 | Jackson | Colorado | 8057 | 44 | 0 |
959657 | 959657 | 2021-01-24 | Jefferson | Colorado | 8059 | 33760 | 676 |
959658 | 959658 | 2021-01-24 | Kiowa | Colorado | 8061 | 85 | 3 |
959659 | 959659 | 2021-01-24 | Kit Carson | Colorado | 8063 | 496 | 10 |
959660 | 959660 | 2021-01-24 | La Plata | Colorado | 8067 | 2646 | 31 |
959661 | 959661 | 2021-01-24 | Lake | Colorado | 8065 | 487 | 0 |
959662 | 959662 | 2021-01-24 | Larimer | Colorado | 8069 | 17517 | 182 |
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);