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 115,008
- Georgia 75,289
- Virginia 62,023
- Kentucky 55,372
- Missouri 53,330
- Illinois 47,572
- North Carolina 46,909
- Kansas 46,708
- Iowa 46,070
- Tennessee 45,055
- Indiana 43,366
- Ohio 41,600
- Minnesota 40,603
- Nebraska 40,186
- Michigan 39,162
- Mississippi 38,670
- Oklahoma 35,821
- Arkansas 35,472
- Puerto Rico 33,986
- Wisconsin 33,743
- Florida 32,282
- Pennsylvania 31,738
- Alabama 31,542
- Louisiana 30,753
- Colorado 29,687
- South Dakota 29,158
- New York 27,770
- California 27,712
- West Virginia 25,241
- North Dakota 23,813
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1496727 | 1496727 | 2021-07-08 | Dundy | Nebraska | 31057 | 184 | 4 |
1496728 | 1496728 | 2021-07-08 | Fillmore | Nebraska | 31059 | 507 | 13 |
1496729 | 1496729 | 2021-07-08 | Franklin | Nebraska | 31061 | 239 | 4 |
1496730 | 1496730 | 2021-07-08 | Frontier | Nebraska | 31063 | 149 | 1 |
1496731 | 1496731 | 2021-07-08 | Furnas | Nebraska | 31065 | 470 | 5 |
1496732 | 1496732 | 2021-07-08 | Gage | Nebraska | 31067 | 2156 | 20 |
1496733 | 1496733 | 2021-07-08 | Garden | Nebraska | 31069 | 118 | 1 |
1496734 | 1496734 | 2021-07-08 | Garfield | Nebraska | 31071 | 156 | 1 |
1496735 | 1496735 | 2021-07-08 | Gosper | Nebraska | 31073 | 180 | 5 |
1496736 | 1496736 | 2021-07-08 | Grant | Nebraska | 31075 | 36 | 4 |
1496737 | 1496737 | 2021-07-08 | Greeley | Nebraska | 31077 | 226 | 1 |
1496738 | 1496738 | 2021-07-08 | Hall | Nebraska | 31079 | 7889 | 120 |
1496739 | 1496739 | 2021-07-08 | Hamilton | Nebraska | 31081 | 974 | 18 |
1496740 | 1496740 | 2021-07-08 | Harlan | Nebraska | 31083 | 228 | 0 |
1496741 | 1496741 | 2021-07-08 | Hayes | Nebraska | 31085 | 57 | 0 |
1496742 | 1496742 | 2021-07-08 | Hitchcock | Nebraska | 31087 | 259 | 5 |
1496743 | 1496743 | 2021-07-08 | Holt | Nebraska | 31089 | 908 | 16 |
1496744 | 1496744 | 2021-07-08 | Hooker | Nebraska | 31091 | 47 | 3 |
1496745 | 1496745 | 2021-07-08 | Howard | Nebraska | 31093 | 594 | 10 |
1496746 | 1496746 | 2021-07-08 | Jefferson | Nebraska | 31095 | 664 | 3 |
1496747 | 1496747 | 2021-07-08 | Johnson | Nebraska | 31097 | 656 | 10 |
1496748 | 1496748 | 2021-07-08 | Kearney | Nebraska | 31099 | 617 | 5 |
1496749 | 1496749 | 2021-07-08 | Keith | Nebraska | 31101 | 706 | 10 |
1496750 | 1496750 | 2021-07-08 | Keya Paha | Nebraska | 31103 | 56 | 0 |
1496751 | 1496751 | 2021-07-08 | Kimball | Nebraska | 31105 | 437 | 7 |
1496752 | 1496752 | 2021-07-08 | Knox | Nebraska | 31107 | 1155 | 12 |
1496753 | 1496753 | 2021-07-08 | Lancaster | Nebraska | 31109 | 31615 | 239 |
1496754 | 1496754 | 2021-07-08 | Lincoln | Nebraska | 31111 | 4147 | 81 |
1496755 | 1496755 | 2021-07-08 | Logan | Nebraska | 31113 | 81 | 0 |
1496756 | 1496756 | 2021-07-08 | Loup | Nebraska | 31115 | 34 | 0 |
1496757 | 1496757 | 2021-07-08 | Madison | Nebraska | 31119 | 4303 | 44 |
1496758 | 1496758 | 2021-07-08 | McPherson | Nebraska | 31117 | 28 | 1 |
1496759 | 1496759 | 2021-07-08 | Merrick | Nebraska | 31121 | 780 | 15 |
1496760 | 1496760 | 2021-07-08 | Morrill | Nebraska | 31123 | 511 | 15 |
1496761 | 1496761 | 2021-07-08 | Nance | Nebraska | 31125 | 414 | 10 |
1496762 | 1496762 | 2021-07-08 | Nemaha | Nebraska | 31127 | 804 | 13 |
1496763 | 1496763 | 2021-07-08 | Nuckolls | Nebraska | 31129 | 548 | 12 |
1496764 | 1496764 | 2021-07-08 | Otoe | Nebraska | 31131 | 1479 | 13 |
1496765 | 1496765 | 2021-07-08 | Pawnee | Nebraska | 31133 | 241 | 4 |
1496766 | 1496766 | 2021-07-08 | Perkins | Nebraska | 31135 | 278 | 11 |
1496767 | 1496767 | 2021-07-08 | Phelps | Nebraska | 31137 | 1007 | 10 |
1496768 | 1496768 | 2021-07-08 | Pierce | Nebraska | 31139 | 732 | 20 |
1496769 | 1496769 | 2021-07-08 | Platte | Nebraska | 31141 | 4150 | 50 |
1496770 | 1496770 | 2021-07-08 | Polk | Nebraska | 31143 | 590 | 18 |
1496771 | 1496771 | 2021-07-08 | Red Willow | Nebraska | 31145 | 1272 | 15 |
1496772 | 1496772 | 2021-07-08 | Richardson | Nebraska | 31147 | 816 | 24 |
1496773 | 1496773 | 2021-07-08 | Rock | Nebraska | 31149 | 151 | 2 |
1496774 | 1496774 | 2021-07-08 | Saline | Nebraska | 31151 | 2041 | 3 |
1496775 | 1496775 | 2021-07-08 | Sarpy | Nebraska | 31153 | 22460 | 132 |
1496776 | 1496776 | 2021-07-08 | Saunders | Nebraska | 31155 | 2546 | 20 |
1496777 | 1496777 | 2021-07-08 | Scotts Bluff | Nebraska | 31157 | 4686 | 96 |
1496778 | 1496778 | 2021-07-08 | Seward | Nebraska | 31159 | 2040 | 34 |
1496779 | 1496779 | 2021-07-08 | Sheridan | Nebraska | 31161 | 539 | 21 |
1496780 | 1496780 | 2021-07-08 | Sherman | Nebraska | 31163 | 213 | 4 |
1496781 | 1496781 | 2021-07-08 | Sioux | Nebraska | 31165 | 31 | 1 |
1496782 | 1496782 | 2021-07-08 | Stanton | Nebraska | 31167 | 372 | 11 |
1496783 | 1496783 | 2021-07-08 | Thayer | Nebraska | 31169 | 491 | 7 |
1496784 | 1496784 | 2021-07-08 | Thomas | Nebraska | 31171 | 55 | 1 |
1496785 | 1496785 | 2021-07-08 | Thurston | Nebraska | 31173 | 1190 | 11 |
1496786 | 1496786 | 2021-07-08 | Valley | Nebraska | 31175 | 344 | 2 |
1496787 | 1496787 | 2021-07-08 | Washington | Nebraska | 31177 | 2205 | 27 |
1496788 | 1496788 | 2021-07-08 | Wayne | Nebraska | 31179 | 1171 | 7 |
1496789 | 1496789 | 2021-07-08 | Webster | Nebraska | 31181 | 419 | 8 |
1496790 | 1496790 | 2021-07-08 | Wheeler | Nebraska | 31183 | 39 | 0 |
1496791 | 1496791 | 2021-07-08 | York | Nebraska | 31185 | 1838 | 13 |
1496792 | 1496792 | 2021-07-08 | Carson City | Nevada | 32510 | 6640 | 124 |
1496793 | 1496793 | 2021-07-08 | Churchill | Nevada | 32001 | 2139 | 49 |
1496794 | 1496794 | 2021-07-08 | Clark | Nevada | 32003 | 263144 | 4517 |
1496795 | 1496795 | 2021-07-08 | Douglas | Nevada | 32005 | 3028 | 37 |
1496796 | 1496796 | 2021-07-08 | Elko | Nevada | 32007 | 5218 | 58 |
1496797 | 1496797 | 2021-07-08 | Esmeralda | Nevada | 32009 | 38 | 0 |
1496798 | 1496798 | 2021-07-08 | Eureka | Nevada | 32011 | 56 | 0 |
1496799 | 1496799 | 2021-07-08 | Humboldt | Nevada | 32013 | 1227 | 14 |
1496800 | 1496800 | 2021-07-08 | Lander | Nevada | 32015 | 482 | 9 |
1496801 | 1496801 | 2021-07-08 | Lincoln | Nevada | 32017 | 376 | 3 |
1496802 | 1496802 | 2021-07-08 | Lyon | Nevada | 32019 | 3385 | 65 |
1496803 | 1496803 | 2021-07-08 | Mineral | Nevada | 32021 | 309 | 7 |
1496804 | 1496804 | 2021-07-08 | Nye | Nevada | 32023 | 3049 | 108 |
1496805 | 1496805 | 2021-07-08 | Pershing | Nevada | 32027 | 971 | 20 |
1496806 | 1496806 | 2021-07-08 | Storey | Nevada | 32029 | 120 | 3 |
1496807 | 1496807 | 2021-07-08 | Washoe | Nevada | 32031 | 46440 | 687 |
1496808 | 1496808 | 2021-07-08 | White Pine | Nevada | 32033 | 637 | 6 |
1496809 | 1496809 | 2021-07-08 | Belknap | New Hampshire | 33001 | 4197 | 100 |
1496810 | 1496810 | 2021-07-08 | Carroll | New Hampshire | 33003 | 2502 | 13 |
1496811 | 1496811 | 2021-07-08 | Cheshire | New Hampshire | 33005 | 3914 | 35 |
1496812 | 1496812 | 2021-07-08 | Coos | New Hampshire | 33007 | 2073 | 43 |
1496813 | 1496813 | 2021-07-08 | Grafton | New Hampshire | 33009 | 4093 | 28 |
1496814 | 1496814 | 2021-07-08 | Hillsborough | New Hampshire | 33011 | 36450 | 647 |
1496815 | 1496815 | 2021-07-08 | Merrimack | New Hampshire | 33013 | 9701 | 116 |
1496816 | 1496816 | 2021-07-08 | Rockingham | New Hampshire | 33015 | 24437 | 266 |
1496817 | 1496817 | 2021-07-08 | Strafford | New Hampshire | 33017 | 10103 | 99 |
1496818 | 1496818 | 2021-07-08 | Sullivan | New Hampshire | 33019 | 1891 | 26 |
1496819 | 1496819 | 2021-07-08 | Unknown | New Hampshire | 324 | 1 | |
1496820 | 1496820 | 2021-07-08 | Atlantic | New Jersey | 34001 | 31697 | 696 |
1496821 | 1496821 | 2021-07-08 | Bergen | New Jersey | 34003 | 105159 | 2892 |
1496822 | 1496822 | 2021-07-08 | Burlington | New Jersey | 34005 | 44486 | 876 |
1496823 | 1496823 | 2021-07-08 | Camden | New Jersey | 34007 | 56039 | 1342 |
1496824 | 1496824 | 2021-07-08 | Cape May | New Jersey | 34009 | 9310 | 208 |
1496825 | 1496825 | 2021-07-08 | Cumberland | New Jersey | 34011 | 17263 | 442 |
1496826 | 1496826 | 2021-07-08 | Essex | New Jersey | 34013 | 94568 | 3025 |
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);