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 142,186
- Georgia 92,569
- Virginia 76,256
- Kentucky 68,332
- Missouri 65,966
- Illinois 58,696
- Kansas 58,048
- North Carolina 57,609
- Iowa 56,870
- Tennessee 55,327
- Indiana 53,302
- Ohio 51,123
- Nebraska 50,267
- Minnesota 50,107
- Michigan 48,234
- Mississippi 47,526
- Oklahoma 44,167
- Arkansas 43,680
- Puerto Rico 42,439
- Wisconsin 41,449
- Florida 39,626
- Pennsylvania 38,907
- Alabama 38,711
- Louisiana 37,772
- Colorado 36,599
- South Dakota 36,220
- California 33,976
- New York 33,976
- West Virginia 31,128
- North Dakota 29,591
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1842706 | 1842706 | 2021-10-23 | Graham | Arizona | 4009 | 7486 | 115 |
1842707 | 1842707 | 2021-10-23 | Greenlee | Arizona | 4011 | 1073 | 16 |
1842708 | 1842708 | 2021-10-23 | La Paz | Arizona | 4012 | 3150 | 97 |
1842709 | 1842709 | 2021-10-23 | Maricopa | Arizona | 4013 | 728245 | 12041 |
1842710 | 1842710 | 2021-10-23 | Mohave | Arizona | 4015 | 32977 | 974 |
1842711 | 1842711 | 2021-10-23 | Navajo | Arizona | 4017 | 21026 | 618 |
1842712 | 1842712 | 2021-10-23 | Pima | Arizona | 4019 | 141688 | 2706 |
1842713 | 1842713 | 2021-10-23 | Pinal | Arizona | 4021 | 72566 | 1071 |
1842714 | 1842714 | 2021-10-23 | Santa Cruz | Arizona | 4023 | 8993 | 193 |
1842715 | 1842715 | 2021-10-23 | Unknown | Arizona | 1 | 0 | |
1842716 | 1842716 | 2021-10-23 | Yavapai | Arizona | 4025 | 27883 | 684 |
1842717 | 1842717 | 2021-10-23 | Yuma | Arizona | 4027 | 41347 | 903 |
1842718 | 1842718 | 2021-10-23 | Arkansas | Arkansas | 5001 | 3469 | 59 |
1842719 | 1842719 | 2021-10-23 | Ashley | Arkansas | 5003 | 3160 | 48 |
1842720 | 1842720 | 2021-10-23 | Baxter | Arkansas | 5005 | 5814 | 176 |
1842721 | 1842721 | 2021-10-23 | Benton | Arkansas | 5007 | 41935 | 598 |
1842722 | 1842722 | 2021-10-23 | Boone | Arkansas | 5009 | 6205 | 126 |
1842723 | 1842723 | 2021-10-23 | Bradley | Arkansas | 5011 | 1956 | 41 |
1842724 | 1842724 | 2021-10-23 | Calhoun | Arkansas | 5013 | 592 | 8 |
1842725 | 1842725 | 2021-10-23 | Carroll | Arkansas | 5015 | 4291 | 74 |
1842726 | 1842726 | 2021-10-23 | Chicot | Arkansas | 5017 | 2014 | 44 |
1842727 | 1842727 | 2021-10-23 | Clark | Arkansas | 5019 | 3229 | 55 |
1842728 | 1842728 | 2021-10-23 | Clay | Arkansas | 5021 | 2704 | 68 |
1842729 | 1842729 | 2021-10-23 | Cleburne | Arkansas | 5023 | 3707 | 91 |
1842730 | 1842730 | 2021-10-23 | Cleveland | Arkansas | 5025 | 1415 | 32 |
1842731 | 1842731 | 2021-10-23 | Columbia | Arkansas | 5027 | 3372 | 72 |
1842732 | 1842732 | 2021-10-23 | Conway | Arkansas | 5029 | 3154 | 43 |
1842733 | 1842733 | 2021-10-23 | Craighead | Arkansas | 5031 | 21449 | 243 |
1842734 | 1842734 | 2021-10-23 | Crawford | Arkansas | 5033 | 10676 | 172 |
1842735 | 1842735 | 2021-10-23 | Crittenden | Arkansas | 5035 | 8754 | 167 |
1842736 | 1842736 | 2021-10-23 | Cross | Arkansas | 5037 | 2961 | 64 |
1842737 | 1842737 | 2021-10-23 | Dallas | Arkansas | 5039 | 1136 | 19 |
1842738 | 1842738 | 2021-10-23 | Desha | Arkansas | 5041 | 1896 | 32 |
1842739 | 1842739 | 2021-10-23 | Drew | Arkansas | 5043 | 2870 | 54 |
1842740 | 1842740 | 2021-10-23 | Faulkner | Arkansas | 5045 | 19487 | 220 |
1842741 | 1842741 | 2021-10-23 | Franklin | Arkansas | 5047 | 2720 | 52 |
1842742 | 1842742 | 2021-10-23 | Fulton | Arkansas | 5049 | 1693 | 62 |
1842743 | 1842743 | 2021-10-23 | Garland | Arkansas | 5051 | 15932 | 385 |
1842744 | 1842744 | 2021-10-23 | Grant | Arkansas | 5053 | 2870 | 48 |
1842745 | 1842745 | 2021-10-23 | Greene | Arkansas | 5055 | 10015 | 122 |
1842746 | 1842746 | 2021-10-23 | Hempstead | Arkansas | 5057 | 2933 | 38 |
1842747 | 1842747 | 2021-10-23 | Hot Spring | Arkansas | 5059 | 7598 | 105 |
1842748 | 1842748 | 2021-10-23 | Howard | Arkansas | 5061 | 2422 | 35 |
1842749 | 1842749 | 2021-10-23 | Independence | Arkansas | 5063 | 6315 | 158 |
1842750 | 1842750 | 2021-10-23 | Izard | Arkansas | 5065 | 2521 | 55 |
1842751 | 1842751 | 2021-10-23 | Jackson | Arkansas | 5067 | 4251 | 42 |
1842752 | 1842752 | 2021-10-23 | Jefferson | Arkansas | 5069 | 12307 | 226 |
1842753 | 1842753 | 2021-10-23 | Johnson | Arkansas | 5071 | 4584 | 56 |
1842754 | 1842754 | 2021-10-23 | Lafayette | Arkansas | 5073 | 843 | 27 |
1842755 | 1842755 | 2021-10-23 | Lawrence | Arkansas | 5075 | 3260 | 56 |
1842756 | 1842756 | 2021-10-23 | Lee | Arkansas | 5077 | 2091 | 48 |
1842757 | 1842757 | 2021-10-23 | Lincoln | Arkansas | 5079 | 3644 | 57 |
1842758 | 1842758 | 2021-10-23 | Little River | Arkansas | 5081 | 2021 | 72 |
1842759 | 1842759 | 2021-10-23 | Logan | Arkansas | 5083 | 3611 | 44 |
1842760 | 1842760 | 2021-10-23 | Lonoke | Arkansas | 5085 | 11915 | 175 |
1842761 | 1842761 | 2021-10-23 | Madison | Arkansas | 5087 | 2471 | 38 |
1842762 | 1842762 | 2021-10-23 | Marion | Arkansas | 5089 | 2128 | 57 |
1842763 | 1842763 | 2021-10-23 | Miller | Arkansas | 5091 | 6443 | 116 |
1842764 | 1842764 | 2021-10-23 | Mississippi | Arkansas | 5093 | 8281 | 138 |
1842765 | 1842765 | 2021-10-23 | Monroe | Arkansas | 5095 | 1191 | 24 |
1842766 | 1842766 | 2021-10-23 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1842767 | 1842767 | 2021-10-23 | Nevada | Arkansas | 5099 | 1366 | 38 |
1842768 | 1842768 | 2021-10-23 | Newton | Arkansas | 5101 | 1169 | 37 |
1842769 | 1842769 | 2021-10-23 | Ouachita | Arkansas | 5103 | 3394 | 83 |
1842770 | 1842770 | 2021-10-23 | Perry | Arkansas | 5105 | 1510 | 21 |
1842771 | 1842771 | 2021-10-23 | Phillips | Arkansas | 5107 | 3188 | 76 |
1842772 | 1842772 | 2021-10-23 | Pike | Arkansas | 5109 | 1703 | 35 |
1842773 | 1842773 | 2021-10-23 | Poinsett | Arkansas | 5111 | 4896 | 99 |
1842774 | 1842774 | 2021-10-23 | Polk | Arkansas | 5113 | 2978 | 109 |
1842775 | 1842775 | 2021-10-23 | Pope | Arkansas | 5115 | 11920 | 156 |
1842776 | 1842776 | 2021-10-23 | Prairie | Arkansas | 5117 | 1276 | 29 |
1842777 | 1842777 | 2021-10-23 | Pulaski | Arkansas | 5119 | 58544 | 902 |
1842778 | 1842778 | 2021-10-23 | Randolph | Arkansas | 5121 | 3317 | 57 |
1842779 | 1842779 | 2021-10-23 | Saline | Arkansas | 5125 | 18466 | 241 |
1842780 | 1842780 | 2021-10-23 | Scott | Arkansas | 5127 | 1717 | 29 |
1842781 | 1842781 | 2021-10-23 | Searcy | Arkansas | 5129 | 1244 | 24 |
1842782 | 1842782 | 2021-10-23 | Sebastian | Arkansas | 5131 | 22269 | 375 |
1842783 | 1842783 | 2021-10-23 | Sevier | Arkansas | 5133 | 3861 | 50 |
1842784 | 1842784 | 2021-10-23 | Sharp | Arkansas | 5135 | 2850 | 66 |
1842785 | 1842785 | 2021-10-23 | St. Francis | Arkansas | 5123 | 4804 | 67 |
1842786 | 1842786 | 2021-10-23 | Stone | Arkansas | 5137 | 1711 | 41 |
1842787 | 1842787 | 2021-10-23 | Union | Arkansas | 5139 | 5751 | 137 |
1842788 | 1842788 | 2021-10-23 | Unknown | Arkansas | 5154 | 0 | |
1842789 | 1842789 | 2021-10-23 | Van Buren | Arkansas | 5141 | 2178 | 42 |
1842790 | 1842790 | 2021-10-23 | Washington | Arkansas | 5143 | 44411 | 473 |
1842791 | 1842791 | 2021-10-23 | White | Arkansas | 5145 | 13158 | 192 |
1842792 | 1842792 | 2021-10-23 | Woodruff | Arkansas | 5147 | 1092 | 24 |
1842793 | 1842793 | 2021-10-23 | Yell | Arkansas | 5149 | 4638 | 78 |
1842794 | 1842794 | 2021-10-23 | Alameda | California | 6001 | 120713 | 1400 |
1842795 | 1842795 | 2021-10-23 | Alpine | California | 6003 | 105 | 0 |
1842796 | 1842796 | 2021-10-23 | Amador | California | 6005 | 5472 | 64 |
1842797 | 1842797 | 2021-10-23 | Butte | California | 6007 | 23818 | 273 |
1842798 | 1842798 | 2021-10-23 | Calaveras | California | 6009 | 3914 | 81 |
1842799 | 1842799 | 2021-10-23 | Colusa | California | 6011 | 3076 | 18 |
1842800 | 1842800 | 2021-10-23 | Contra Costa | California | 6013 | 100018 | 1008 |
1842801 | 1842801 | 2021-10-23 | Del Norte | California | 6015 | 3691 | 42 |
1842802 | 1842802 | 2021-10-23 | El Dorado | California | 6017 | 17207 | 149 |
1842803 | 1842803 | 2021-10-23 | Fresno | California | 6019 | 146318 | 2094 |
1842804 | 1842804 | 2021-10-23 | Glenn | California | 6021 | 4384 | 42 |
1842805 | 1842805 | 2021-10-23 | Humboldt | California | 6023 | 9269 | 109 |
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);