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 55
- Texas 132,280
- Georgia 86,329
- Virginia 71,068
- Kentucky 63,652
- Missouri 61,403
- Illinois 54,679
- Kansas 53,953
- North Carolina 53,709
- Iowa 52,970
- Tennessee 51,583
- Indiana 49,714
- Ohio 47,652
- Minnesota 46,675
- Nebraska 46,601
- Michigan 44,958
- Mississippi 44,328
- Oklahoma 41,125
- Arkansas 40,716
- Puerto Rico 39,358
- Wisconsin 38,641
- Florida 36,974
- Pennsylvania 36,294
- Alabama 36,098
- Louisiana 35,237
- Colorado 34,103
- South Dakota 33,646
- California 31,714
- New York 31,714
- West Virginia 28,983
- North Dakota 27,485
- Montana 27,160
- South Carolina 25,005
- Idaho 22,578
- Washington 21,484
- Oregon 19,103
- New Mexico 17,403
- Utah 15,689
- Alaska 13,794
- Maryland 13,620
- Wyoming 12,272
- New Jersey 12,115
- Maine 9,014
- Nevada 8,710
- Massachusetts 8,299
- Arizona 8,276
- Vermont 8,143
- New Hampshire 5,961
- Connecticut 4,922
- Rhode Island 3,258
- Hawaii 2,536
- Delaware 2,167
- Virgin Islands 1,727
- Northern Mariana Islands 1,056
- District of Columbia 557
- Guam 549
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1715993 | 1715993 | 2021-09-14 | Greenlee | Arizona | 4011 | 833 | 14 |
1715994 | 1715994 | 2021-09-14 | La Paz | Arizona | 4012 | 2816 | 86 |
1715995 | 1715995 | 2021-09-14 | Maricopa | Arizona | 4013 | 668223 | 11075 |
1715996 | 1715996 | 2021-09-14 | Mohave | Arizona | 4015 | 29757 | 878 |
1715997 | 1715997 | 2021-09-14 | Navajo | Arizona | 4017 | 19053 | 585 |
1715998 | 1715998 | 2021-09-14 | Pima | Arizona | 4019 | 131183 | 2560 |
1715999 | 1715999 | 2021-09-14 | Pinal | Arizona | 4021 | 65790 | 971 |
1716000 | 1716000 | 2021-09-14 | Santa Cruz | Arizona | 4023 | 8643 | 188 |
1716001 | 1716001 | 2021-09-14 | Yavapai | Arizona | 4025 | 24832 | 607 |
1716002 | 1716002 | 2021-09-14 | Yuma | Arizona | 4027 | 40065 | 877 |
1716003 | 1716003 | 2021-09-14 | Arkansas | Arkansas | 5001 | 3273 | 55 |
1716004 | 1716004 | 2021-09-14 | Ashley | Arkansas | 5003 | 2926 | 41 |
1716005 | 1716005 | 2021-09-14 | Baxter | Arkansas | 5005 | 5542 | 161 |
1716006 | 1716006 | 2021-09-14 | Benton | Arkansas | 5007 | 39380 | 550 |
1716007 | 1716007 | 2021-09-14 | Boone | Arkansas | 5009 | 5833 | 105 |
1716008 | 1716008 | 2021-09-14 | Bradley | Arkansas | 5011 | 1887 | 37 |
1716009 | 1716009 | 2021-09-14 | Calhoun | Arkansas | 5013 | 555 | 7 |
1716010 | 1716010 | 2021-09-14 | Carroll | Arkansas | 5015 | 4079 | 64 |
1716011 | 1716011 | 2021-09-14 | Chicot | Arkansas | 5017 | 1915 | 44 |
1716012 | 1716012 | 2021-09-14 | Clark | Arkansas | 5019 | 2987 | 50 |
1716013 | 1716013 | 2021-09-14 | Clay | Arkansas | 5021 | 2454 | 53 |
1716014 | 1716014 | 2021-09-14 | Cleburne | Arkansas | 5023 | 3361 | 85 |
1716015 | 1716015 | 2021-09-14 | Cleveland | Arkansas | 5025 | 1315 | 31 |
1716016 | 1716016 | 2021-09-14 | Columbia | Arkansas | 5027 | 3183 | 65 |
1716017 | 1716017 | 2021-09-14 | Conway | Arkansas | 5029 | 2963 | 41 |
1716018 | 1716018 | 2021-09-14 | Craighead | Arkansas | 5031 | 19689 | 221 |
1716019 | 1716019 | 2021-09-14 | Crawford | Arkansas | 5033 | 9853 | 154 |
1716020 | 1716020 | 2021-09-14 | Crittenden | Arkansas | 5035 | 8067 | 114 |
1716021 | 1716021 | 2021-09-14 | Cross | Arkansas | 5037 | 2687 | 58 |
1716022 | 1716022 | 2021-09-14 | Dallas | Arkansas | 5039 | 1095 | 18 |
1716023 | 1716023 | 2021-09-14 | Desha | Arkansas | 5041 | 1758 | 26 |
1716024 | 1716024 | 2021-09-14 | Drew | Arkansas | 5043 | 2655 | 53 |
1716025 | 1716025 | 2021-09-14 | Faulkner | Arkansas | 5045 | 18358 | 198 |
1716026 | 1716026 | 2021-09-14 | Franklin | Arkansas | 5047 | 2534 | 47 |
1716027 | 1716027 | 2021-09-14 | Fulton | Arkansas | 5049 | 1602 | 54 |
1716028 | 1716028 | 2021-09-14 | Garland | Arkansas | 5051 | 15156 | 353 |
1716029 | 1716029 | 2021-09-14 | Grant | Arkansas | 5053 | 2739 | 46 |
1716030 | 1716030 | 2021-09-14 | Greene | Arkansas | 5055 | 9081 | 101 |
1716031 | 1716031 | 2021-09-14 | Hempstead | Arkansas | 5057 | 2710 | 24 |
1716032 | 1716032 | 2021-09-14 | Hot Spring | Arkansas | 5059 | 7232 | 103 |
1716033 | 1716033 | 2021-09-14 | Howard | Arkansas | 5061 | 2254 | 29 |
1716034 | 1716034 | 2021-09-14 | Independence | Arkansas | 5063 | 5588 | 151 |
1716035 | 1716035 | 2021-09-14 | Izard | Arkansas | 5065 | 2268 | 53 |
1716036 | 1716036 | 2021-09-14 | Jackson | Arkansas | 5067 | 3888 | 41 |
1716037 | 1716037 | 2021-09-14 | Jefferson | Arkansas | 5069 | 11972 | 217 |
1716038 | 1716038 | 2021-09-14 | Johnson | Arkansas | 5071 | 4224 | 55 |
1716039 | 1716039 | 2021-09-14 | Lafayette | Arkansas | 5073 | 776 | 11 |
1716040 | 1716040 | 2021-09-14 | Lawrence | Arkansas | 5075 | 2982 | 47 |
1716041 | 1716041 | 2021-09-14 | Lee | Arkansas | 5077 | 1977 | 41 |
1716042 | 1716042 | 2021-09-14 | Lincoln | Arkansas | 5079 | 3600 | 55 |
1716043 | 1716043 | 2021-09-14 | Little River | Arkansas | 5081 | 1813 | 44 |
1716044 | 1716044 | 2021-09-14 | Logan | Arkansas | 5083 | 3302 | 34 |
1716045 | 1716045 | 2021-09-14 | Lonoke | Arkansas | 5085 | 11192 | 164 |
1716046 | 1716046 | 2021-09-14 | Madison | Arkansas | 5087 | 2299 | 35 |
1716047 | 1716047 | 2021-09-14 | Marion | Arkansas | 5089 | 1978 | 54 |
1716048 | 1716048 | 2021-09-14 | Miller | Arkansas | 5091 | 5831 | 39 |
1716049 | 1716049 | 2021-09-14 | Mississippi | Arkansas | 5093 | 7514 | 123 |
1716050 | 1716050 | 2021-09-14 | Monroe | Arkansas | 5095 | 1129 | 21 |
1716051 | 1716051 | 2021-09-14 | Montgomery | Arkansas | 5097 | 1071 | 36 |
1716052 | 1716052 | 2021-09-14 | Nevada | Arkansas | 5099 | 1188 | 29 |
1716053 | 1716053 | 2021-09-14 | Newton | Arkansas | 5101 | 1117 | 29 |
1716054 | 1716054 | 2021-09-14 | Ouachita | Arkansas | 5103 | 3272 | 72 |
1716055 | 1716055 | 2021-09-14 | Perry | Arkansas | 5105 | 1403 | 17 |
1716056 | 1716056 | 2021-09-14 | Phillips | Arkansas | 5107 | 2994 | 64 |
1716057 | 1716057 | 2021-09-14 | Pike | Arkansas | 5109 | 1579 | 32 |
1716058 | 1716058 | 2021-09-14 | Poinsett | Arkansas | 5111 | 4528 | 94 |
1716059 | 1716059 | 2021-09-14 | Polk | Arkansas | 5113 | 2730 | 93 |
1716060 | 1716060 | 2021-09-14 | Pope | Arkansas | 5115 | 11203 | 142 |
1716061 | 1716061 | 2021-09-14 | Prairie | Arkansas | 5117 | 1240 | 27 |
1716062 | 1716062 | 2021-09-14 | Pulaski | Arkansas | 5119 | 55875 | 845 |
1716063 | 1716063 | 2021-09-14 | Randolph | Arkansas | 5121 | 2916 | 50 |
1716064 | 1716064 | 2021-09-14 | Saline | Arkansas | 5125 | 17487 | 222 |
1716065 | 1716065 | 2021-09-14 | Scott | Arkansas | 5127 | 1487 | 22 |
1716066 | 1716066 | 2021-09-14 | Searcy | Arkansas | 5129 | 1195 | 24 |
1716067 | 1716067 | 2021-09-14 | Sebastian | Arkansas | 5131 | 20714 | 322 |
1716068 | 1716068 | 2021-09-14 | Sevier | Arkansas | 5133 | 3537 | 31 |
1716069 | 1716069 | 2021-09-14 | Sharp | Arkansas | 5135 | 2496 | 59 |
1716070 | 1716070 | 2021-09-14 | St. Francis | Arkansas | 5123 | 4485 | 54 |
1716071 | 1716071 | 2021-09-14 | Stone | Arkansas | 5137 | 1534 | 38 |
1716072 | 1716072 | 2021-09-14 | Union | Arkansas | 5139 | 5187 | 126 |
1716073 | 1716073 | 2021-09-14 | Unknown | Arkansas | 5122 | 0 | |
1716074 | 1716074 | 2021-09-14 | Van Buren | Arkansas | 5141 | 1944 | 35 |
1716075 | 1716075 | 2021-09-14 | Washington | Arkansas | 5143 | 41827 | 433 |
1716076 | 1716076 | 2021-09-14 | White | Arkansas | 5145 | 12269 | 171 |
1716077 | 1716077 | 2021-09-14 | Woodruff | Arkansas | 5147 | 996 | 19 |
1716078 | 1716078 | 2021-09-14 | Yell | Arkansas | 5149 | 4339 | 75 |
1716079 | 1716079 | 2021-09-14 | Alameda | California | 6001 | 114898 | 1330 |
1716080 | 1716080 | 2021-09-14 | Alpine | California | 6003 | 98 | 0 |
1716081 | 1716081 | 2021-09-14 | Amador | California | 6005 | 4805 | 56 |
1716082 | 1716082 | 2021-09-14 | Butte | California | 6007 | 20397 | 225 |
1716083 | 1716083 | 2021-09-14 | Calaveras | California | 6009 | 3276 | 65 |
1716084 | 1716084 | 2021-09-14 | Colusa | California | 6011 | 2859 | 18 |
1716085 | 1716085 | 2021-09-14 | Contra Costa | California | 6013 | 94538 | 908 |
1716086 | 1716086 | 2021-09-14 | Del Norte | California | 6015 | 3347 | 34 |
1716087 | 1716087 | 2021-09-14 | El Dorado | California | 6017 | 15561 | 122 |
1716088 | 1716088 | 2021-09-14 | Fresno | California | 6019 | 133272 | 1853 |
1716089 | 1716089 | 2021-09-14 | Glenn | California | 6021 | 3842 | 31 |
1716090 | 1716090 | 2021-09-14 | Humboldt | California | 6023 | 7969 | 82 |
1716091 | 1716091 | 2021-09-14 | Imperial | California | 6025 | 33849 | 750 |
1716092 | 1716092 | 2021-09-14 | Inyo | California | 6027 | 1611 | 39 |
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);