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 22,902
- Georgia 17,209
- Virginia 13,611
- Kentucky 11,812
- Missouri 10,858
- North Carolina 10,508
- Illinois 10,267
- Tennessee 10,137
- Indiana 9,970
- Iowa 9,773
- Ohio 9,441
- Mississippi 8,899
- Minnesota 8,674
- Michigan 8,670
- Kansas 8,501
- Arkansas 7,808
- Florida 7,598
- Oklahoma 7,468
- Wisconsin 7,432
- Pennsylvania 7,350
- Louisiana 7,158
- Alabama 7,154
- Nebraska 6,683
- New York 6,658
- California 6,634
- Colorado 6,542
- West Virginia 5,236
- Puerto Rico 5,230
- South Dakota 5,180
- South Carolina 5,130
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315761 | 315761 | 2020-07-09 | San Francisco | California | 6075 | 4148 | 50 |
315762 | 315762 | 2020-07-09 | San Joaquin | California | 6077 | 6065 | 67 |
315763 | 315763 | 2020-07-09 | San Luis Obispo | California | 6079 | 877 | 4 |
315764 | 315764 | 2020-07-09 | San Mateo | California | 6081 | 3787 | 111 |
315765 | 315765 | 2020-07-09 | Santa Barbara | California | 6083 | 3985 | 29 |
315766 | 315766 | 2020-07-09 | Santa Clara | California | 6085 | 5678 | 167 |
315767 | 315767 | 2020-07-09 | Santa Cruz | California | 6087 | 509 | 3 |
315768 | 315768 | 2020-07-09 | Shasta | California | 6089 | 176 | 6 |
315769 | 315769 | 2020-07-09 | Sierra | California | 6091 | 1 | 0 |
315770 | 315770 | 2020-07-09 | Siskiyou | California | 6093 | 33 | 0 |
315771 | 315771 | 2020-07-09 | Solano | California | 6095 | 1990 | 27 |
315772 | 315772 | 2020-07-09 | Sonoma | California | 6097 | 1561 | 14 |
315773 | 315773 | 2020-07-09 | Stanislaus | California | 6099 | 4344 | 50 |
315774 | 315774 | 2020-07-09 | Sutter | California | 6101 | 337 | 4 |
315775 | 315775 | 2020-07-09 | Tehama | California | 6103 | 100 | 1 |
315776 | 315776 | 2020-07-09 | Trinity | California | 6105 | 3 | 0 |
315777 | 315777 | 2020-07-09 | Tulare | California | 6107 | 5509 | 148 |
315778 | 315778 | 2020-07-09 | Tuolumne | California | 6109 | 59 | 0 |
315779 | 315779 | 2020-07-09 | Ventura | California | 6111 | 4139 | 53 |
315780 | 315780 | 2020-07-09 | Yolo | California | 6113 | 802 | 28 |
315781 | 315781 | 2020-07-09 | Yuba | California | 6115 | 163 | 3 |
315782 | 315782 | 2020-07-09 | Adams | Colorado | 8001 | 4588 | 156 |
315783 | 315783 | 2020-07-09 | Alamosa | Colorado | 8003 | 204 | 6 |
315784 | 315784 | 2020-07-09 | Arapahoe | Colorado | 8005 | 5510 | 349 |
315785 | 315785 | 2020-07-09 | Archuleta | Colorado | 8007 | 12 | 0 |
315786 | 315786 | 2020-07-09 | Baca | Colorado | 8009 | 14 | 0 |
315787 | 315787 | 2020-07-09 | Bent | Colorado | 8011 | 4 | 0 |
315788 | 315788 | 2020-07-09 | Boulder | Colorado | 8013 | 1492 | 72 |
315789 | 315789 | 2020-07-09 | Broomfield | Colorado | 8014 | 333 | 30 |
315790 | 315790 | 2020-07-09 | Chaffee | Colorado | 8015 | 81 | 19 |
315791 | 315791 | 2020-07-09 | Cheyenne | Colorado | 8017 | 5 | 0 |
315792 | 315792 | 2020-07-09 | Clear Creek | Colorado | 8019 | 21 | 1 |
315793 | 315793 | 2020-07-09 | Conejos | Colorado | 8021 | 15 | 0 |
315794 | 315794 | 2020-07-09 | Costilla | Colorado | 8023 | 22 | 0 |
315795 | 315795 | 2020-07-09 | Crowley | Colorado | 8025 | 71 | 1 |
315796 | 315796 | 2020-07-09 | Custer | Colorado | 8027 | 3 | 0 |
315797 | 315797 | 2020-07-09 | Delta | Colorado | 8029 | 83 | 1 |
315798 | 315798 | 2020-07-09 | Denver | Colorado | 8031 | 7651 | 386 |
315799 | 315799 | 2020-07-09 | Douglas | Colorado | 8035 | 1078 | 52 |
315800 | 315800 | 2020-07-09 | Eagle | Colorado | 8037 | 738 | 8 |
315801 | 315801 | 2020-07-09 | El Paso | Colorado | 8041 | 2871 | 111 |
315802 | 315802 | 2020-07-09 | Elbert | Colorado | 8039 | 60 | 2 |
315803 | 315803 | 2020-07-09 | Fremont | Colorado | 8043 | 41 | 0 |
315804 | 315804 | 2020-07-09 | Garfield | Colorado | 8045 | 349 | 3 |
315805 | 315805 | 2020-07-09 | Gilpin | Colorado | 8047 | 8 | 0 |
315806 | 315806 | 2020-07-09 | Grand | Colorado | 8049 | 23 | 1 |
315807 | 315807 | 2020-07-09 | Gunnison | Colorado | 8051 | 190 | 6 |
315808 | 315808 | 2020-07-09 | Hinsdale | Colorado | 8053 | 3 | 0 |
315809 | 315809 | 2020-07-09 | Huerfano | Colorado | 8055 | 4 | 1 |
315810 | 315810 | 2020-07-09 | Jackson | Colorado | 8057 | 2 | 0 |
315811 | 315811 | 2020-07-09 | Jefferson | Colorado | 8059 | 2922 | 214 |
315812 | 315812 | 2020-07-09 | Kit Carson | Colorado | 8063 | 35 | 3 |
315813 | 315813 | 2020-07-09 | La Plata | Colorado | 8067 | 130 | 1 |
315814 | 315814 | 2020-07-09 | Lake | Colorado | 8065 | 52 | 0 |
315815 | 315815 | 2020-07-09 | Larimer | Colorado | 8069 | 869 | 30 |
315816 | 315816 | 2020-07-09 | Las Animas | Colorado | 8071 | 10 | 0 |
315817 | 315817 | 2020-07-09 | Lincoln | Colorado | 8073 | 4 | 0 |
315818 | 315818 | 2020-07-09 | Logan | Colorado | 8075 | 640 | 5 |
315819 | 315819 | 2020-07-09 | Mesa | Colorado | 8077 | 129 | 0 |
315820 | 315820 | 2020-07-09 | Mineral | Colorado | 8079 | 15 | 0 |
315821 | 315821 | 2020-07-09 | Moffat | Colorado | 8081 | 14 | 0 |
315822 | 315822 | 2020-07-09 | Montezuma | Colorado | 8083 | 76 | 3 |
315823 | 315823 | 2020-07-09 | Montrose | Colorado | 8085 | 214 | 12 |
315824 | 315824 | 2020-07-09 | Morgan | Colorado | 8087 | 655 | 46 |
315825 | 315825 | 2020-07-09 | Otero | Colorado | 8089 | 22 | 1 |
315826 | 315826 | 2020-07-09 | Ouray | Colorado | 8091 | 12 | 1 |
315827 | 315827 | 2020-07-09 | Park | Colorado | 8093 | 32 | 0 |
315828 | 315828 | 2020-07-09 | Phillips | Colorado | 8095 | 16 | 0 |
315829 | 315829 | 2020-07-09 | Pitkin | Colorado | 8097 | 117 | 2 |
315830 | 315830 | 2020-07-09 | Prowers | Colorado | 8099 | 33 | 0 |
315831 | 315831 | 2020-07-09 | Pueblo | Colorado | 8101 | 417 | 30 |
315832 | 315832 | 2020-07-09 | Rio Blanco | Colorado | 8103 | 4 | 0 |
315833 | 315833 | 2020-07-09 | Rio Grande | Colorado | 8105 | 80 | 2 |
315834 | 315834 | 2020-07-09 | Routt | Colorado | 8107 | 79 | 6 |
315835 | 315835 | 2020-07-09 | Saguache | Colorado | 8109 | 103 | 2 |
315836 | 315836 | 2020-07-09 | San Juan | Colorado | 8111 | 2 | 0 |
315837 | 315837 | 2020-07-09 | San Miguel | Colorado | 8113 | 43 | 0 |
315838 | 315838 | 2020-07-09 | Summit | Colorado | 8117 | 289 | 4 |
315839 | 315839 | 2020-07-09 | Teller | Colorado | 8119 | 53 | 2 |
315840 | 315840 | 2020-07-09 | Washington | Colorado | 8121 | 46 | 0 |
315841 | 315841 | 2020-07-09 | Weld | Colorado | 8123 | 2961 | 138 |
315842 | 315842 | 2020-07-09 | Yuma | Colorado | 8125 | 54 | 0 |
315843 | 315843 | 2020-07-09 | Fairfield | Connecticut | 9001 | 16886 | 1380 |
315844 | 315844 | 2020-07-09 | Hartford | Connecticut | 9003 | 11866 | 1385 |
315845 | 315845 | 2020-07-09 | Litchfield | Connecticut | 9005 | 1510 | 137 |
315846 | 315846 | 2020-07-09 | Middlesex | Connecticut | 9007 | 1334 | 187 |
315847 | 315847 | 2020-07-09 | New Haven | Connecticut | 9009 | 12509 | 1079 |
315848 | 315848 | 2020-07-09 | New London | Connecticut | 9011 | 1319 | 102 |
315849 | 315849 | 2020-07-09 | Tolland | Connecticut | 9013 | 928 | 64 |
315850 | 315850 | 2020-07-09 | Unknown | Connecticut | 227 | 0 | |
315851 | 315851 | 2020-07-09 | Windham | Connecticut | 9015 | 630 | 14 |
315852 | 315852 | 2020-07-09 | Kent | Delaware | 10001 | 1795 | 92 |
315853 | 315853 | 2020-07-09 | New Castle | Delaware | 10003 | 5626 | 249 |
315854 | 315854 | 2020-07-09 | Sussex | Delaware | 10005 | 5008 | 176 |
315855 | 315855 | 2020-07-09 | Unknown | Delaware | 102 | 0 | |
315856 | 315856 | 2020-07-09 | District of Columbia | District of Columbia | 11001 | 10679 | 568 |
315857 | 315857 | 2020-07-09 | Alachua | Florida | 12001 | 1871 | 12 |
315858 | 315858 | 2020-07-09 | Baker | Florida | 12003 | 127 | 4 |
315859 | 315859 | 2020-07-09 | Bay | Florida | 12005 | 940 | 5 |
315860 | 315860 | 2020-07-09 | Bradford | Florida | 12007 | 113 | 2 |
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);