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 30,136
- Georgia 21,849
- Virginia 17,468
- Kentucky 15,292
- Missouri 14,251
- North Carolina 13,408
- Illinois 13,254
- Tennessee 12,916
- Iowa 12,671
- Indiana 12,638
- Ohio 11,994
- Kansas 11,473
- Mississippi 11,281
- Minnesota 11,211
- Michigan 11,106
- Arkansas 10,048
- Oklahoma 9,699
- Florida 9,570
- Wisconsin 9,549
- Pennsylvania 9,293
- Nebraska 9,120
- Alabama 9,097
- Louisiana 9,043
- Colorado 8,358
- New York 8,340
- California 8,333
- Puerto Rico 7,521
- South Dakota 7,051
- West Virginia 6,816
- South Carolina 6,465
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
408609 | 408609 | 2020-08-07 | Little River | Arkansas | 5081 | 168 | 1 |
408610 | 408610 | 2020-08-07 | Logan | Arkansas | 5083 | 233 | 1 |
408611 | 408611 | 2020-08-07 | Lonoke | Arkansas | 5085 | 495 | 2 |
408612 | 408612 | 2020-08-07 | Madison | Arkansas | 5087 | 269 | 2 |
408613 | 408613 | 2020-08-07 | Marion | Arkansas | 5089 | 25 | 0 |
408614 | 408614 | 2020-08-07 | Miller | Arkansas | 5091 | 499 | 5 |
408615 | 408615 | 2020-08-07 | Mississippi | Arkansas | 5093 | 958 | 13 |
408616 | 408616 | 2020-08-07 | Monroe | Arkansas | 5095 | 58 | 0 |
408617 | 408617 | 2020-08-07 | Montgomery | Arkansas | 5097 | 34 | 1 |
408618 | 408618 | 2020-08-07 | Nevada | Arkansas | 5099 | 137 | 9 |
408619 | 408619 | 2020-08-07 | Newton | Arkansas | 5101 | 104 | 6 |
408620 | 408620 | 2020-08-07 | Ouachita | Arkansas | 5103 | 92 | 2 |
408621 | 408621 | 2020-08-07 | Perry | Arkansas | 5105 | 50 | 0 |
408622 | 408622 | 2020-08-07 | Phillips | Arkansas | 5107 | 303 | 7 |
408623 | 408623 | 2020-08-07 | Pike | Arkansas | 5109 | 97 | 1 |
408624 | 408624 | 2020-08-07 | Poinsett | Arkansas | 5111 | 240 | 3 |
408625 | 408625 | 2020-08-07 | Polk | Arkansas | 5113 | 140 | 1 |
408626 | 408626 | 2020-08-07 | Pope | Arkansas | 5115 | 1282 | 10 |
408627 | 408627 | 2020-08-07 | Prairie | Arkansas | 5117 | 87 | 0 |
408628 | 408628 | 2020-08-07 | Pulaski | Arkansas | 5119 | 5407 | 83 |
408629 | 408629 | 2020-08-07 | Randolph | Arkansas | 5121 | 206 | 3 |
408630 | 408630 | 2020-08-07 | Saline | Arkansas | 5125 | 999 | 6 |
408631 | 408631 | 2020-08-07 | Scott | Arkansas | 5127 | 55 | 0 |
408632 | 408632 | 2020-08-07 | Searcy | Arkansas | 5129 | 28 | 0 |
408633 | 408633 | 2020-08-07 | Sebastian | Arkansas | 5131 | 2079 | 19 |
408634 | 408634 | 2020-08-07 | Sevier | Arkansas | 5133 | 976 | 10 |
408635 | 408635 | 2020-08-07 | Sharp | Arkansas | 5135 | 109 | 5 |
408636 | 408636 | 2020-08-07 | St. Francis | Arkansas | 5123 | 1186 | 3 |
408637 | 408637 | 2020-08-07 | Stone | Arkansas | 5137 | 64 | 1 |
408638 | 408638 | 2020-08-07 | Union | Arkansas | 5139 | 472 | 17 |
408639 | 408639 | 2020-08-07 | Unknown | Arkansas | 1785 | 0 | |
408640 | 408640 | 2020-08-07 | Van Buren | Arkansas | 5141 | 52 | 2 |
408641 | 408641 | 2020-08-07 | Washington | Arkansas | 5143 | 6231 | 51 |
408642 | 408642 | 2020-08-07 | White | Arkansas | 5145 | 312 | 2 |
408643 | 408643 | 2020-08-07 | Woodruff | Arkansas | 5147 | 21 | 0 |
408644 | 408644 | 2020-08-07 | Yell | Arkansas | 5149 | 1062 | 14 |
408645 | 408645 | 2020-08-07 | Alameda | California | 6001 | 12161 | 193 |
408646 | 408646 | 2020-08-07 | Alpine | California | 6003 | 2 | 0 |
408647 | 408647 | 2020-08-07 | Amador | California | 6005 | 162 | 2 |
408648 | 408648 | 2020-08-07 | Butte | California | 6007 | 1095 | 8 |
408649 | 408649 | 2020-08-07 | Calaveras | California | 6009 | 136 | 1 |
408650 | 408650 | 2020-08-07 | Colusa | California | 6011 | 362 | 4 |
408651 | 408651 | 2020-08-07 | Contra Costa | California | 6013 | 8760 | 136 |
408652 | 408652 | 2020-08-07 | Del Norte | California | 6015 | 99 | 0 |
408653 | 408653 | 2020-08-07 | El Dorado | California | 6017 | 729 | 1 |
408654 | 408654 | 2020-08-07 | Fresno | California | 6019 | 16641 | 171 |
408655 | 408655 | 2020-08-07 | Glenn | California | 6021 | 330 | 3 |
408656 | 408656 | 2020-08-07 | Humboldt | California | 6023 | 282 | 4 |
408657 | 408657 | 2020-08-07 | Imperial | California | 6025 | 9629 | 241 |
408658 | 408658 | 2020-08-07 | Inyo | California | 6027 | 62 | 1 |
408659 | 408659 | 2020-08-07 | Kern | California | 6029 | 22009 | 160 |
408660 | 408660 | 2020-08-07 | Kings | California | 6031 | 4453 | 56 |
408661 | 408661 | 2020-08-07 | Lake | California | 6033 | 209 | 2 |
408662 | 408662 | 2020-08-07 | Lassen | California | 6035 | 638 | 0 |
408663 | 408663 | 2020-08-07 | Los Angeles | California | 6037 | 204167 | 4918 |
408664 | 408664 | 2020-08-07 | Madera | California | 6039 | 2302 | 39 |
408665 | 408665 | 2020-08-07 | Marin | California | 6041 | 5286 | 77 |
408666 | 408666 | 2020-08-07 | Mariposa | California | 6043 | 60 | 2 |
408667 | 408667 | 2020-08-07 | Mendocino | California | 6045 | 380 | 10 |
408668 | 408668 | 2020-08-07 | Merced | California | 6047 | 5012 | 64 |
408669 | 408669 | 2020-08-07 | Modoc | California | 6049 | 5 | 0 |
408670 | 408670 | 2020-08-07 | Mono | California | 6051 | 153 | 1 |
408671 | 408671 | 2020-08-07 | Monterey | California | 6053 | 5156 | 35 |
408672 | 408672 | 2020-08-07 | Napa | California | 6055 | 1047 | 9 |
408673 | 408673 | 2020-08-07 | Nevada | California | 6057 | 327 | 1 |
408674 | 408674 | 2020-08-07 | Orange | California | 6059 | 38754 | 704 |
408675 | 408675 | 2020-08-07 | Placer | California | 6061 | 2099 | 20 |
408676 | 408676 | 2020-08-07 | Plumas | California | 6063 | 25 | 0 |
408677 | 408677 | 2020-08-07 | Riverside | California | 6065 | 40452 | 799 |
408678 | 408678 | 2020-08-07 | Sacramento | California | 6067 | 10794 | 161 |
408679 | 408679 | 2020-08-07 | San Benito | California | 6069 | 709 | 4 |
408680 | 408680 | 2020-08-07 | San Bernardino | California | 6071 | 34939 | 497 |
408681 | 408681 | 2020-08-07 | San Diego | California | 6073 | 31842 | 586 |
408682 | 408682 | 2020-08-07 | San Francisco | California | 6075 | 7329 | 64 |
408683 | 408683 | 2020-08-07 | San Joaquin | California | 6077 | 12303 | 211 |
408684 | 408684 | 2020-08-07 | San Luis Obispo | California | 6079 | 2093 | 16 |
408685 | 408685 | 2020-08-07 | San Mateo | California | 6081 | 5978 | 120 |
408686 | 408686 | 2020-08-07 | Santa Barbara | California | 6083 | 6704 | 69 |
408687 | 408687 | 2020-08-07 | Santa Clara | California | 6085 | 11475 | 204 |
408688 | 408688 | 2020-08-07 | Santa Cruz | California | 6087 | 1229 | 4 |
408689 | 408689 | 2020-08-07 | Shasta | California | 6089 | 411 | 9 |
408690 | 408690 | 2020-08-07 | Sierra | California | 6091 | 3 | 0 |
408691 | 408691 | 2020-08-07 | Siskiyou | California | 6093 | 93 | 0 |
408692 | 408692 | 2020-08-07 | Solano | California | 6095 | 4034 | 40 |
408693 | 408693 | 2020-08-07 | Sonoma | California | 6097 | 3431 | 47 |
408694 | 408694 | 2020-08-07 | Stanislaus | California | 6099 | 9566 | 161 |
408695 | 408695 | 2020-08-07 | Sutter | California | 6101 | 921 | 7 |
408696 | 408696 | 2020-08-07 | Tehama | California | 6103 | 231 | 1 |
408697 | 408697 | 2020-08-07 | Trinity | California | 6105 | 6 | 0 |
408698 | 408698 | 2020-08-07 | Tulare | California | 6107 | 10475 | 196 |
408699 | 408699 | 2020-08-07 | Tuolumne | California | 6109 | 152 | 2 |
408700 | 408700 | 2020-08-07 | Ventura | California | 6111 | 8162 | 89 |
408701 | 408701 | 2020-08-07 | Yolo | California | 6113 | 1690 | 43 |
408702 | 408702 | 2020-08-07 | Yuba | California | 6115 | 588 | 4 |
408703 | 408703 | 2020-08-07 | Adams | Colorado | 8001 | 6375 | 176 |
408704 | 408704 | 2020-08-07 | Alamosa | Colorado | 8003 | 226 | 9 |
408705 | 408705 | 2020-08-07 | Arapahoe | Colorado | 8005 | 7234 | 364 |
408706 | 408706 | 2020-08-07 | Archuleta | Colorado | 8007 | 35 | 0 |
408707 | 408707 | 2020-08-07 | Baca | Colorado | 8009 | 14 | 0 |
408708 | 408708 | 2020-08-07 | Bent | Colorado | 8011 | 9 | 0 |
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);