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 193,519
- Georgia 124,889
- Virginia 103,128
- Kentucky 92,572
- Missouri 89,600
- Illinois 79,502
- Kansas 79,294
- North Carolina 77,809
- Iowa 77,070
- Tennessee 74,719
- Indiana 71,921
- Nebraska 69,255
- Ohio 69,101
- Minnesota 67,883
- Michigan 65,202
- Mississippi 64,147
- Oklahoma 59,923
- Arkansas 58,956
- Puerto Rico 58,397
- Wisconsin 55,993
- Florida 53,362
- Pennsylvania 52,441
- Alabama 52,245
- Louisiana 50,902
- South Dakota 49,552
- Colorado 49,527
- New York 45,692
- California 45,680
- West Virginia 42,238
- Montana 40,656
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499775 | 2499775 | 2022-05-13 | Inyo | California | 6027 | 4636 | 56 |
2499776 | 2499776 | 2022-05-13 | Kern | California | 6029 | 244681 | 2427 |
2499777 | 2499777 | 2022-05-13 | Kings | California | 6031 | 55429 | 447 |
2499778 | 2499778 | 2022-05-13 | Lake | California | 6033 | 11699 | 137 |
2499779 | 2499779 | 2022-05-13 | Lassen | California | 6035 | 10751 | 69 |
2499780 | 2499780 | 2022-05-13 | Los Angeles | California | 6037 | 2908425 | 32022 |
2499781 | 2499781 | 2022-05-13 | Madera | California | 6039 | 43685 | 365 |
2499782 | 2499782 | 2022-05-13 | Marin | California | 6041 | 38685 | 293 |
2499783 | 2499783 | 2022-05-13 | Mariposa | California | 6043 | 3145 | 35 |
2499784 | 2499784 | 2022-05-13 | Mendocino | California | 6045 | 16568 | 124 |
2499785 | 2499785 | 2022-05-13 | Merced | California | 6047 | 72959 | 823 |
2499786 | 2499786 | 2022-05-13 | Modoc | California | 6049 | 1000 | 8 |
2499787 | 2499787 | 2022-05-13 | Mono | California | 6051 | 3144 | 6 |
2499788 | 2499788 | 2022-05-13 | Monterey | California | 6053 | 95140 | 744 |
2499789 | 2499789 | 2022-05-13 | Napa | California | 6055 | 27765 | 143 |
2499790 | 2499790 | 2022-05-13 | Nevada | California | 6057 | 17503 | 127 |
2499791 | 2499791 | 2022-05-13 | Orange | California | 6059 | 600384 | 7023 |
2499792 | 2499792 | 2022-05-13 | Placer | California | 6061 | 71527 | 628 |
2499793 | 2499793 | 2022-05-13 | Plumas | California | 6063 | 3379 | 13 |
2499794 | 2499794 | 2022-05-13 | Riverside | California | 6065 | 626695 | 6527 |
2499795 | 2499795 | 2022-05-13 | Sacramento | California | 6067 | 314407 | 3159 |
2499796 | 2499796 | 2022-05-13 | San Benito | California | 6069 | 13636 | 98 |
2499797 | 2499797 | 2022-05-13 | San Bernardino | California | 6071 | 597377 | 7423 |
2499798 | 2499798 | 2022-05-13 | San Diego | California | 6073 | 824586 | 5271 |
2499799 | 2499799 | 2022-05-13 | San Francisco | California | 6075 | 143959 | 866 |
2499800 | 2499800 | 2022-05-13 | San Joaquin | California | 6077 | 178501 | 2236 |
2499801 | 2499801 | 2022-05-13 | San Luis Obispo | California | 6079 | 57556 | 478 |
2499802 | 2499802 | 2022-05-13 | San Mateo | California | 6081 | 137238 | 755 |
2499803 | 2499803 | 2022-05-13 | Santa Barbara | California | 6083 | 92683 | 693 |
2499804 | 2499804 | 2022-05-13 | Santa Clara | California | 6085 | 342015 | 2298 |
2499805 | 2499805 | 2022-05-13 | Santa Cruz | California | 6087 | 52532 | 263 |
2499806 | 2499806 | 2022-05-13 | Shasta | California | 6089 | 36988 | 648 |
2499807 | 2499807 | 2022-05-13 | Sierra | California | 6091 | 324 | 4 |
2499808 | 2499808 | 2022-05-13 | Siskiyou | California | 6093 | 7478 | 105 |
2499809 | 2499809 | 2022-05-13 | Solano | California | 6095 | 89419 | 451 |
2499810 | 2499810 | 2022-05-13 | Sonoma | California | 6097 | 90191 | 490 |
2499811 | 2499811 | 2022-05-13 | Stanislaus | California | 6099 | 136645 | 1694 |
2499812 | 2499812 | 2022-05-13 | Sutter | California | 6101 | 23045 | 234 |
2499813 | 2499813 | 2022-05-13 | Tehama | California | 6103 | 14753 | 201 |
2499814 | 2499814 | 2022-05-13 | Trinity | California | 6105 | 1485 | 20 |
2499815 | 2499815 | 2022-05-13 | Tulare | California | 6107 | 136125 | 1469 |
2499816 | 2499816 | 2022-05-13 | Tuolumne | California | 6109 | 13758 | 182 |
2499817 | 2499817 | 2022-05-13 | Ventura | California | 6111 | 186062 | 1498 |
2499818 | 2499818 | 2022-05-13 | Yolo | California | 6113 | 41061 | 316 |
2499819 | 2499819 | 2022-05-13 | Yuba | California | 6115 | 17944 | 122 |
2499820 | 2499820 | 2022-05-13 | Adams | Colorado | 8001 | 137720 | 1380 |
2499821 | 2499821 | 2022-05-13 | Alamosa | Colorado | 8003 | 4560 | 62 |
2499822 | 2499822 | 2022-05-13 | Arapahoe | Colorado | 8005 | 158561 | 1284 |
2499823 | 2499823 | 2022-05-13 | Archuleta | Colorado | 8007 | 2926 | 16 |
2499824 | 2499824 | 2022-05-13 | Baca | Colorado | 8009 | 855 | 13 |
2499825 | 2499825 | 2022-05-13 | Bent | Colorado | 8011 | 2560 | 47 |
2499826 | 2499826 | 2022-05-13 | Boulder | Colorado | 8013 | 68435 | 373 |
2499827 | 2499827 | 2022-05-13 | Broomfield | Colorado | 8014 | 13997 | 116 |
2499828 | 2499828 | 2022-05-13 | Chaffee | Colorado | 8015 | 4749 | 47 |
2499829 | 2499829 | 2022-05-13 | Cheyenne | Colorado | 8017 | 322 | 9 |
2499830 | 2499830 | 2022-05-13 | Clear Creek | Colorado | 8019 | 1601 | 12 |
2499831 | 2499831 | 2022-05-13 | Conejos | Colorado | 8021 | 1763 | 54 |
2499832 | 2499832 | 2022-05-13 | Costilla | Colorado | 8023 | 708 | 18 |
2499833 | 2499833 | 2022-05-13 | Crowley | Colorado | 8025 | 3347 | 30 |
2499834 | 2499834 | 2022-05-13 | Custer | Colorado | 8027 | 656 | 21 |
2499835 | 2499835 | 2022-05-13 | Delta | Colorado | 8029 | 6232 | 140 |
2499836 | 2499836 | 2022-05-13 | Denver | Colorado | 8031 | 177033 | 1360 |
2499837 | 2499837 | 2022-05-13 | Dolores | Colorado | 8033 | 367 | 8 |
2499838 | 2499838 | 2022-05-13 | Douglas | Colorado | 8035 | 81400 | 460 |
2499839 | 2499839 | 2022-05-13 | Eagle | Colorado | 8037 | 16274 | 35 |
2499840 | 2499840 | 2022-05-13 | El Paso | Colorado | 8041 | 190541 | 1695 |
2499841 | 2499841 | 2022-05-13 | Elbert | Colorado | 8039 | 4880 | 40 |
2499842 | 2499842 | 2022-05-13 | Fremont | Colorado | 8043 | 15481 | 187 |
2499843 | 2499843 | 2022-05-13 | Garfield | Colorado | 8045 | 15076 | 91 |
2499844 | 2499844 | 2022-05-13 | Gilpin | Colorado | 8047 | 977 | 4 |
2499845 | 2499845 | 2022-05-13 | Grand | Colorado | 8049 | 3599 | 28 |
2499846 | 2499846 | 2022-05-13 | Gunnison | Colorado | 8051 | 3407 | 14 |
2499847 | 2499847 | 2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 |
2499848 | 2499848 | 2022-05-13 | Huerfano | Colorado | 8055 | 1452 | 35 |
2499849 | 2499849 | 2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 |
2499850 | 2499850 | 2022-05-13 | Jefferson | Colorado | 8059 | 128067 | 1356 |
2499851 | 2499851 | 2022-05-13 | Kiowa | Colorado | 8061 | 336 | 6 |
2499852 | 2499852 | 2022-05-13 | Kit Carson | Colorado | 8063 | 1621 | 33 |
2499853 | 2499853 | 2022-05-13 | La Plata | Colorado | 8067 | 13002 | 86 |
2499854 | 2499854 | 2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 |
2499855 | 2499855 | 2022-05-13 | Larimer | Colorado | 8069 | 81210 | 505 |
2499856 | 2499856 | 2022-05-13 | Las Animas | Colorado | 8071 | 3635 | 43 |
2499857 | 2499857 | 2022-05-13 | Lincoln | Colorado | 8073 | 2199 | 9 |
2499858 | 2499858 | 2022-05-13 | Logan | Colorado | 8075 | 7480 | 109 |
2499859 | 2499859 | 2022-05-13 | Mesa | Colorado | 8077 | 43093 | 565 |
2499860 | 2499860 | 2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 |
2499861 | 2499861 | 2022-05-13 | Moffat | Colorado | 8081 | 3062 | 52 |
2499862 | 2499862 | 2022-05-13 | Montezuma | Colorado | 8083 | 6229 | 81 |
2499863 | 2499863 | 2022-05-13 | Montrose | Colorado | 8085 | 9398 | 160 |
2499864 | 2499864 | 2022-05-13 | Morgan | Colorado | 8087 | 5735 | 138 |
2499865 | 2499865 | 2022-05-13 | Otero | Colorado | 8089 | 4322 | 130 |
2499866 | 2499866 | 2022-05-13 | Ouray | Colorado | 8091 | 884 | 6 |
2499867 | 2499867 | 2022-05-13 | Park | Colorado | 8093 | 2913 | 20 |
2499868 | 2499868 | 2022-05-13 | Phillips | Colorado | 8095 | 894 | 19 |
2499869 | 2499869 | 2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 |
2499870 | 2499870 | 2022-05-13 | Prowers | Colorado | 8099 | 2654 | 51 |
2499871 | 2499871 | 2022-05-13 | Pueblo | Colorado | 8101 | 47690 | 802 |
2499872 | 2499872 | 2022-05-13 | Rio Blanco | Colorado | 8103 | 1696 | 13 |
2499873 | 2499873 | 2022-05-13 | Rio Grande | Colorado | 8105 | 2856 | 46 |
2499874 | 2499874 | 2022-05-13 | Routt | Colorado | 8107 | 6562 | 25 |
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);