ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Texas 178,335
- Georgia 112,800
- Virginia 93,724
- Kentucky 84,577
- Missouri 82,406
- Kansas 73,782
- Illinois 72,506
- North Carolina 70,501
- Iowa 70,497
- Tennessee 67,633
- Nebraska 65,042
- Indiana 64,895
- Ohio 62,478
- Minnesota 61,988
- Michigan 59,190
- Mississippi 57,859
- Puerto Rico 55,695
- Oklahoma 54,852
- Arkansas 53,481
- Wisconsin 50,895
- Florida 47,940
- Pennsylvania 47,235
- Alabama 47,168
- South Dakota 46,263
- Louisiana 45,824
- Colorado 44,920
- New York 40,890
- California 40,846
- West Virginia 38,702
- Montana 38,468
- …
fips >30
county >30
- Washington 21,851
- Unknown 19,312
- Jefferson 18,328
- Franklin 17,623
- Jackson 16,901
- Lincoln 16,887
- Madison 14,098
- Union 12,689
- Clay 12,688
- Montgomery 12,688
- Marion 11,983
- Monroe 11,983
- Wayne 11,219
- Grant 10,474
- Warren 9,870
- Greene 9,868
- Carroll 9,164
- Douglas 8,460
- Lake 8,460
- Johnson 8,459
- Polk 8,459
- Lee 8,458
- Marshall 8,443
- Clark 8,412
- Adams 8,410
- Crawford 7,754
- Fayette 7,754
- Morgan 7,754
- Lawrence 7,753
- Calhoun 7,730
- …
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
218602 | 218602 | 2020-06-08 | Alpine | California | 6003 | 2 | 0 |
218603 | 218603 | 2020-06-08 | Amador | California | 6005 | 9 | 0 |
218604 | 218604 | 2020-06-08 | Butte | California | 6007 | 68 | 1 |
218605 | 218605 | 2020-06-08 | Calaveras | California | 6009 | 19 | 0 |
218606 | 218606 | 2020-06-08 | Colusa | California | 6011 | 7 | 0 |
218607 | 218607 | 2020-06-08 | Contra Costa | California | 6013 | 1706 | 40 |
218608 | 218608 | 2020-06-08 | Del Norte | California | 6015 | 47 | 0 |
218609 | 218609 | 2020-06-08 | El Dorado | California | 6017 | 109 | 0 |
218610 | 218610 | 2020-06-08 | Fresno | California | 6019 | 2216 | 46 |
218611 | 218611 | 2020-06-08 | Glenn | California | 6021 | 19 | 0 |
218612 | 218612 | 2020-06-08 | Humboldt | California | 6023 | 112 | 4 |
218613 | 218613 | 2020-06-08 | Imperial | California | 6025 | 3048 | 37 |
218614 | 218614 | 2020-06-08 | Inyo | California | 6027 | 21 | 1 |
218615 | 218615 | 2020-06-08 | Kern | California | 6029 | 2804 | 47 |
218616 | 218616 | 2020-06-08 | Kings | California | 6031 | 1567 | 6 |
218617 | 218617 | 2020-06-08 | Lake | California | 6033 | 30 | 0 |
218618 | 218618 | 2020-06-08 | Lassen | California | 6035 | 8 | 0 |
218619 | 218619 | 2020-06-08 | Los Angeles | California | 6037 | 64644 | 2655 |
218620 | 218620 | 2020-06-08 | Madera | California | 6039 | 172 | 3 |
218621 | 218621 | 2020-06-08 | Marin | California | 6041 | 625 | 17 |
218622 | 218622 | 2020-06-08 | Mariposa | California | 6043 | 16 | 1 |
218623 | 218623 | 2020-06-08 | Mendocino | California | 6045 | 36 | 0 |
218624 | 218624 | 2020-06-08 | Merced | California | 6047 | 367 | 7 |
218625 | 218625 | 2020-06-08 | Mono | California | 6051 | 37 | 1 |
218626 | 218626 | 2020-06-08 | Monterey | California | 6053 | 751 | 10 |
218627 | 218627 | 2020-06-08 | Napa | California | 6055 | 154 | 3 |
218628 | 218628 | 2020-06-08 | Nevada | California | 6057 | 50 | 1 |
218629 | 218629 | 2020-06-08 | Orange | California | 6059 | 7643 | 177 |
218630 | 218630 | 2020-06-08 | Placer | California | 6061 | 294 | 9 |
218631 | 218631 | 2020-06-08 | Plumas | California | 6063 | 4 | 0 |
218632 | 218632 | 2020-06-08 | Riverside | California | 6065 | 9206 | 356 |
218633 | 218633 | 2020-06-08 | Sacramento | California | 6067 | 1587 | 61 |
218634 | 218634 | 2020-06-08 | San Benito | California | 6069 | 109 | 2 |
218635 | 218635 | 2020-06-08 | San Bernardino | California | 6071 | 6247 | 224 |
218636 | 218636 | 2020-06-08 | San Diego | California | 6073 | 8682 | 312 |
218637 | 218637 | 2020-06-08 | San Francisco | California | 6075 | 2782 | 43 |
218638 | 218638 | 2020-06-08 | San Joaquin | California | 6077 | 1244 | 37 |
218639 | 218639 | 2020-06-08 | San Luis Obispo | California | 6079 | 299 | 1 |
218640 | 218640 | 2020-06-08 | San Mateo | California | 6081 | 2399 | 88 |
218641 | 218641 | 2020-06-08 | Santa Barbara | California | 6083 | 1818 | 15 |
218642 | 218642 | 2020-06-08 | Santa Clara | California | 6085 | 2973 | 146 |
218643 | 218643 | 2020-06-08 | Santa Cruz | California | 6087 | 234 | 3 |
218644 | 218644 | 2020-06-08 | Shasta | California | 6089 | 46 | 4 |
218645 | 218645 | 2020-06-08 | Sierra | California | 6091 | 1 | 0 |
218646 | 218646 | 2020-06-08 | Siskiyou | California | 6093 | 12 | 0 |
218647 | 218647 | 2020-06-08 | Solano | California | 6095 | 595 | 23 |
218648 | 218648 | 2020-06-08 | Sonoma | California | 6097 | 664 | 4 |
218649 | 218649 | 2020-06-08 | Stanislaus | California | 6099 | 937 | 33 |
218650 | 218650 | 2020-06-08 | Sutter | California | 6101 | 65 | 2 |
218651 | 218651 | 2020-06-08 | Tehama | California | 6103 | 8 | 1 |
218652 | 218652 | 2020-06-08 | Trinity | California | 6105 | 3 | 0 |
218653 | 218653 | 2020-06-08 | Tulare | California | 6107 | 2220 | 94 |
218654 | 218654 | 2020-06-08 | Tuolumne | California | 6109 | 7 | 0 |
218655 | 218655 | 2020-06-08 | Ventura | California | 6111 | 1341 | 35 |
218656 | 218656 | 2020-06-08 | Yolo | California | 6113 | 225 | 24 |
218657 | 218657 | 2020-06-08 | Yuba | California | 6115 | 32 | 1 |
218658 | 218658 | 2020-06-08 | Adams | Colorado | 8001 | 3605 | 138 |
218659 | 218659 | 2020-06-08 | Alamosa | Colorado | 8003 | 95 | 2 |
218660 | 218660 | 2020-06-08 | Arapahoe | Colorado | 8005 | 4663 | 326 |
218661 | 218661 | 2020-06-08 | Archuleta | Colorado | 8007 | 8 | 0 |
218662 | 218662 | 2020-06-08 | Baca | Colorado | 8009 | 12 | 0 |
218663 | 218663 | 2020-06-08 | Bent | Colorado | 8011 | 3 | 0 |
218664 | 218664 | 2020-06-08 | Boulder | Colorado | 8013 | 1022 | 67 |
218665 | 218665 | 2020-06-08 | Broomfield | Colorado | 8014 | 256 | 27 |
218666 | 218666 | 2020-06-08 | Chaffee | Colorado | 8015 | 78 | 20 |
218667 | 218667 | 2020-06-08 | Cheyenne | Colorado | 8017 | 5 | 0 |
218668 | 218668 | 2020-06-08 | Clear Creek | Colorado | 8019 | 17 | 1 |
218669 | 218669 | 2020-06-08 | Conejos | Colorado | 8021 | 5 | 0 |
218670 | 218670 | 2020-06-08 | Costilla | Colorado | 8023 | 8 | 0 |
218671 | 218671 | 2020-06-08 | Crowley | Colorado | 8025 | 66 | 1 |
218672 | 218672 | 2020-06-08 | Custer | Colorado | 8027 | 2 | 0 |
218673 | 218673 | 2020-06-08 | Delta | Colorado | 8029 | 76 | 1 |
218674 | 218674 | 2020-06-08 | Denver | Colorado | 8031 | 6138 | 348 |
218675 | 218675 | 2020-06-08 | Douglas | Colorado | 8035 | 757 | 47 |
218676 | 218676 | 2020-06-08 | Eagle | Colorado | 8037 | 610 | 8 |
218677 | 218677 | 2020-06-08 | El Paso | Colorado | 8041 | 1862 | 98 |
218678 | 218678 | 2020-06-08 | Elbert | Colorado | 8039 | 56 | 2 |
218679 | 218679 | 2020-06-08 | Fremont | Colorado | 8043 | 26 | 0 |
218680 | 218680 | 2020-06-08 | Garfield | Colorado | 8045 | 164 | 2 |
218681 | 218681 | 2020-06-08 | Gilpin | Colorado | 8047 | 5 | 0 |
218682 | 218682 | 2020-06-08 | Grand | Colorado | 8049 | 15 | 0 |
218683 | 218683 | 2020-06-08 | Gunnison | Colorado | 8051 | 180 | 6 |
218684 | 218684 | 2020-06-08 | Hinsdale | Colorado | 8053 | 3 | 0 |
218685 | 218685 | 2020-06-08 | Huerfano | Colorado | 8055 | 3 | 0 |
218686 | 218686 | 2020-06-08 | Jefferson | Colorado | 8059 | 2384 | 182 |
218687 | 218687 | 2020-06-08 | Kit Carson | Colorado | 8063 | 30 | 3 |
218688 | 218688 | 2020-06-08 | La Plata | Colorado | 8067 | 82 | 1 |
218689 | 218689 | 2020-06-08 | Lake | Colorado | 8065 | 38 | 0 |
218690 | 218690 | 2020-06-08 | Larimer | Colorado | 8069 | 628 | 28 |
218691 | 218691 | 2020-06-08 | Las Animas | Colorado | 8071 | 5 | 0 |
218692 | 218692 | 2020-06-08 | Lincoln | Colorado | 8073 | 3 | 0 |
218693 | 218693 | 2020-06-08 | Logan | Colorado | 8075 | 631 | 5 |
218694 | 218694 | 2020-06-08 | Mesa | Colorado | 8077 | 62 | 0 |
218695 | 218695 | 2020-06-08 | Mineral | Colorado | 8079 | 2 | 0 |
218696 | 218696 | 2020-06-08 | Moffat | Colorado | 8081 | 8 | 0 |
218697 | 218697 | 2020-06-08 | Montezuma | Colorado | 8083 | 57 | 3 |
218698 | 218698 | 2020-06-08 | Montrose | Colorado | 8085 | 190 | 12 |
218699 | 218699 | 2020-06-08 | Morgan | Colorado | 8087 | 645 | 46 |
218700 | 218700 | 2020-06-08 | Otero | Colorado | 8089 | 22 | 1 |
218701 | 218701 | 2020-06-08 | Ouray | Colorado | 8091 | 8 | 1 |
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);