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 58,366
- Georgia 39,609
- Virginia 32,364
- Kentucky 28,612
- Missouri 27,238
- Illinois 24,666
- North Carolina 24,608
- Iowa 23,770
- Tennessee 23,647
- Kansas 23,151
- Indiana 22,850
- Ohio 21,850
- Minnesota 20,979
- Michigan 20,430
- Mississippi 20,384
- Nebraska 19,393
- Arkansas 18,524
- Oklahoma 18,428
- Wisconsin 17,687
- Florida 17,118
- Pennsylvania 16,797
- Alabama 16,601
- Puerto Rico 16,369
- Louisiana 16,258
- Colorado 15,415
- New York 14,836
- California 14,771
- South Dakota 14,440
- West Virginia 12,976
- North Dakota 11,772
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
772850 | 772850 | 2020-11-27 | Dundy | Nebraska | 31057 | 62 | 2 |
772851 | 772851 | 2020-11-27 | Fillmore | Nebraska | 31059 | 329 | 4 |
772852 | 772852 | 2020-11-27 | Franklin | Nebraska | 31061 | 171 | 2 |
772853 | 772853 | 2020-11-27 | Frontier | Nebraska | 31063 | 110 | 1 |
772854 | 772854 | 2020-11-27 | Furnas | Nebraska | 31065 | 255 | 3 |
772855 | 772855 | 2020-11-27 | Gage | Nebraska | 31067 | 1265 | 9 |
772856 | 772856 | 2020-11-27 | Garden | Nebraska | 31069 | 76 | 0 |
772857 | 772857 | 2020-11-27 | Garfield | Nebraska | 31071 | 104 | 3 |
772858 | 772858 | 2020-11-27 | Gosper | Nebraska | 31073 | 107 | 1 |
772859 | 772859 | 2020-11-27 | Grant | Nebraska | 31075 | 19 | 1 |
772860 | 772860 | 2020-11-27 | Greeley | Nebraska | 31077 | 123 | 0 |
772861 | 772861 | 2020-11-27 | Hall | Nebraska | 31079 | 4602 | 70 |
772862 | 772862 | 2020-11-27 | Hamilton | Nebraska | 31081 | 547 | 14 |
772863 | 772863 | 2020-11-27 | Harlan | Nebraska | 31083 | 136 | 0 |
772864 | 772864 | 2020-11-27 | Hayes | Nebraska | 31085 | 43 | 0 |
772865 | 772865 | 2020-11-27 | Hitchcock | Nebraska | 31087 | 97 | 1 |
772866 | 772866 | 2020-11-27 | Holt | Nebraska | 31089 | 515 | 10 |
772867 | 772867 | 2020-11-27 | Hooker | Nebraska | 31091 | 44 | 1 |
772868 | 772868 | 2020-11-27 | Howard | Nebraska | 31093 | 347 | 6 |
772869 | 772869 | 2020-11-27 | Jefferson | Nebraska | 31095 | 358 | 0 |
772870 | 772870 | 2020-11-27 | Johnson | Nebraska | 31097 | 306 | 2 |
772871 | 772871 | 2020-11-27 | Kearney | Nebraska | 31099 | 481 | 1 |
772872 | 772872 | 2020-11-27 | Keith | Nebraska | 31101 | 378 | 0 |
772873 | 772873 | 2020-11-27 | Keya Paha | Nebraska | 31103 | 21 | 0 |
772874 | 772874 | 2020-11-27 | Kimball | Nebraska | 31105 | 160 | 1 |
772875 | 772875 | 2020-11-27 | Knox | Nebraska | 31107 | 431 | 2 |
772876 | 772876 | 2020-11-27 | Lancaster | Nebraska | 31109 | 16125 | 72 |
772877 | 772877 | 2020-11-27 | Lincoln | Nebraska | 31111 | 2230 | 18 |
772878 | 772878 | 2020-11-27 | Logan | Nebraska | 31113 | 46 | 0 |
772879 | 772879 | 2020-11-27 | Loup | Nebraska | 31115 | 30 | 0 |
772880 | 772880 | 2020-11-27 | Madison | Nebraska | 31119 | 3030 | 19 |
772881 | 772881 | 2020-11-27 | McPherson | Nebraska | 31117 | 15 | 0 |
772882 | 772882 | 2020-11-27 | Merrick | Nebraska | 31121 | 461 | 4 |
772883 | 772883 | 2020-11-27 | Morrill | Nebraska | 31123 | 343 | 4 |
772884 | 772884 | 2020-11-27 | Nance | Nebraska | 31125 | 275 | 2 |
772885 | 772885 | 2020-11-27 | Nemaha | Nebraska | 31127 | 296 | 0 |
772886 | 772886 | 2020-11-27 | Nuckolls | Nebraska | 31129 | 206 | 1 |
772887 | 772887 | 2020-11-27 | Otoe | Nebraska | 31131 | 727 | 1 |
772888 | 772888 | 2020-11-27 | Pawnee | Nebraska | 31133 | 84 | 0 |
772889 | 772889 | 2020-11-27 | Perkins | Nebraska | 31135 | 136 | 10 |
772890 | 772890 | 2020-11-27 | Phelps | Nebraska | 31137 | 544 | 4 |
772891 | 772891 | 2020-11-27 | Pierce | Nebraska | 31139 | 422 | 14 |
772892 | 772892 | 2020-11-27 | Platte | Nebraska | 31141 | 3075 | 25 |
772893 | 772893 | 2020-11-27 | Polk | Nebraska | 31143 | 407 | 11 |
772894 | 772894 | 2020-11-27 | Red Willow | Nebraska | 31145 | 574 | 3 |
772895 | 772895 | 2020-11-27 | Richardson | Nebraska | 31147 | 344 | 4 |
772896 | 772896 | 2020-11-27 | Rock | Nebraska | 31149 | 81 | 2 |
772897 | 772897 | 2020-11-27 | Saline | Nebraska | 31151 | 1464 | 3 |
772898 | 772898 | 2020-11-27 | Sarpy | Nebraska | 31153 | 11203 | 56 |
772899 | 772899 | 2020-11-27 | Saunders | Nebraska | 31155 | 1240 | 7 |
772900 | 772900 | 2020-11-27 | Scotts Bluff | Nebraska | 31157 | 3309 | 17 |
772901 | 772901 | 2020-11-27 | Seward | Nebraska | 31159 | 1260 | 8 |
772902 | 772902 | 2020-11-27 | Sheridan | Nebraska | 31161 | 276 | 6 |
772903 | 772903 | 2020-11-27 | Sherman | Nebraska | 31163 | 126 | 4 |
772904 | 772904 | 2020-11-27 | Sioux | Nebraska | 31165 | 21 | 0 |
772905 | 772905 | 2020-11-27 | Stanton | Nebraska | 31167 | 202 | 0 |
772906 | 772906 | 2020-11-27 | Thayer | Nebraska | 31169 | 254 | 2 |
772907 | 772907 | 2020-11-27 | Thomas | Nebraska | 31171 | 30 | 0 |
772908 | 772908 | 2020-11-27 | Thurston | Nebraska | 31173 | 542 | 5 |
772909 | 772909 | 2020-11-27 | Valley | Nebraska | 31175 | 187 | 1 |
772910 | 772910 | 2020-11-27 | Washington | Nebraska | 31177 | 1171 | 10 |
772911 | 772911 | 2020-11-27 | Wayne | Nebraska | 31179 | 720 | 5 |
772912 | 772912 | 2020-11-27 | Webster | Nebraska | 31181 | 221 | 3 |
772913 | 772913 | 2020-11-27 | Wheeler | Nebraska | 31183 | 14 | 0 |
772914 | 772914 | 2020-11-27 | York | Nebraska | 31185 | 1015 | 3 |
772915 | 772915 | 2020-11-27 | Carson City | Nevada | 32510 | 2241 | 14 |
772916 | 772916 | 2020-11-27 | Churchill | Nevada | 32001 | 804 | 12 |
772917 | 772917 | 2020-11-27 | Clark | Nevada | 32003 | 112894 | 1735 |
772918 | 772918 | 2020-11-27 | Douglas | Nevada | 32005 | 856 | 3 |
772919 | 772919 | 2020-11-27 | Elko | Nevada | 32007 | 2647 | 17 |
772920 | 772920 | 2020-11-27 | Esmeralda | Nevada | 32009 | 9 | 0 |
772921 | 772921 | 2020-11-27 | Eureka | Nevada | 32011 | 23 | 0 |
772922 | 772922 | 2020-11-27 | Humboldt | Nevada | 32013 | 326 | 5 |
772923 | 772923 | 2020-11-27 | Lander | Nevada | 32015 | 193 | 4 |
772924 | 772924 | 2020-11-27 | Lincoln | Nevada | 32017 | 188 | 1 |
772925 | 772925 | 2020-11-27 | Lyon | Nevada | 32019 | 1165 | 16 |
772926 | 772926 | 2020-11-27 | Mineral | Nevada | 32021 | 99 | 2 |
772927 | 772927 | 2020-11-27 | Nye | Nevada | 32023 | 1229 | 27 |
772928 | 772928 | 2020-11-27 | Pershing | Nevada | 32027 | 98 | 0 |
772929 | 772929 | 2020-11-27 | Storey | Nevada | 32029 | 52 | 0 |
772930 | 772930 | 2020-11-27 | Washoe | Nevada | 32031 | 24079 | 266 |
772931 | 772931 | 2020-11-27 | White Pine | Nevada | 32033 | 242 | 1 |
772932 | 772932 | 2020-11-27 | Belknap | New Hampshire | 33001 | 660 | 10 |
772933 | 772933 | 2020-11-27 | Carroll | New Hampshire | 33003 | 327 | 2 |
772934 | 772934 | 2020-11-27 | Cheshire | New Hampshire | 33005 | 469 | 3 |
772935 | 772935 | 2020-11-27 | Coos | New Hampshire | 33007 | 302 | 6 |
772936 | 772936 | 2020-11-27 | Grafton | New Hampshire | 33009 | 508 | 2 |
772937 | 772937 | 2020-11-27 | Hillsborough | New Hampshire | 33011 | 8647 | 331 |
772938 | 772938 | 2020-11-27 | Merrimack | New Hampshire | 33013 | 1695 | 35 |
772939 | 772939 | 2020-11-27 | Rockingham | New Hampshire | 33015 | 4599 | 107 |
772940 | 772940 | 2020-11-27 | Strafford | New Hampshire | 33017 | 1523 | 15 |
772941 | 772941 | 2020-11-27 | Sullivan | New Hampshire | 33019 | 211 | 5 |
772942 | 772942 | 2020-11-27 | Unknown | New Hampshire | 372 | 1 | |
772943 | 772943 | 2020-11-27 | Atlantic | New Jersey | 34001 | 7768 | 284 |
772944 | 772944 | 2020-11-27 | Bergen | New Jersey | 34003 | 34125 | 2122 |
772945 | 772945 | 2020-11-27 | Burlington | New Jersey | 34005 | 13261 | 543 |
772946 | 772946 | 2020-11-27 | Camden | New Jersey | 34007 | 18435 | 674 |
772947 | 772947 | 2020-11-27 | Cape May | New Jersey | 34009 | 1637 | 109 |
772948 | 772948 | 2020-11-27 | Cumberland | New Jersey | 34011 | 5007 | 173 |
772949 | 772949 | 2020-11-27 | Essex | New Jersey | 34013 | 34711 | 2226 |
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);