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 91,132
- Georgia 60,249
- Virginia 49,521
- Kentucky 44,092
- Missouri 42,331
- Illinois 37,890
- North Carolina 37,409
- Kansas 36,825
- Iowa 36,670
- Tennessee 36,031
- Indiana 34,718
- Ohio 33,145
- Minnesota 32,331
- Nebraska 31,327
- Michigan 31,266
- Mississippi 30,962
- Oklahoma 28,467
- Arkansas 28,328
- Wisconsin 26,975
- Puerto Rico 26,560
- Florida 25,890
- Pennsylvania 25,440
- Alabama 25,244
- Louisiana 24,643
- Colorado 23,671
- South Dakota 22,954
- New York 22,260
- California 22,253
- West Virginia 20,071
- North Dakota 18,683
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1192032 | 1192032 | 2021-04-05 | Ellis | Oklahoma | 40045 | 354 | 3 |
1192033 | 1192033 | 2021-04-05 | Garfield | Oklahoma | 40047 | 7696 | 89 |
1192034 | 1192034 | 2021-04-05 | Garvin | Oklahoma | 40049 | 3539 | 56 |
1192035 | 1192035 | 2021-04-05 | Grady | Oklahoma | 40051 | 5809 | 88 |
1192036 | 1192036 | 2021-04-05 | Grant | Oklahoma | 40053 | 548 | 7 |
1192037 | 1192037 | 2021-04-05 | Greer | Oklahoma | 40055 | 571 | 17 |
1192038 | 1192038 | 2021-04-05 | Harmon | Oklahoma | 40057 | 307 | 3 |
1192039 | 1192039 | 2021-04-05 | Harper | Oklahoma | 40059 | 409 | 4 |
1192040 | 1192040 | 2021-04-05 | Haskell | Oklahoma | 40061 | 1240 | 11 |
1192041 | 1192041 | 2021-04-05 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1192042 | 1192042 | 2021-04-05 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1192043 | 1192043 | 2021-04-05 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1192044 | 1192044 | 2021-04-05 | Johnston | Oklahoma | 40069 | 1358 | 20 |
1192045 | 1192045 | 2021-04-05 | Kay | Oklahoma | 40071 | 5244 | 86 |
1192046 | 1192046 | 2021-04-05 | Kingfisher | Oklahoma | 40073 | 2023 | 27 |
1192047 | 1192047 | 2021-04-05 | Kiowa | Oklahoma | 40075 | 805 | 16 |
1192048 | 1192048 | 2021-04-05 | Latimer | Oklahoma | 40077 | 828 | 10 |
1192049 | 1192049 | 2021-04-05 | Le Flore | Oklahoma | 40079 | 5509 | 47 |
1192050 | 1192050 | 2021-04-05 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1192051 | 1192051 | 2021-04-05 | Logan | Oklahoma | 40083 | 4122 | 34 |
1192052 | 1192052 | 2021-04-05 | Love | Oklahoma | 40085 | 1457 | 13 |
1192053 | 1192053 | 2021-04-05 | Major | Oklahoma | 40093 | 949 | 13 |
1192054 | 1192054 | 2021-04-05 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1192055 | 1192055 | 2021-04-05 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1192056 | 1192056 | 2021-04-05 | McClain | Oklahoma | 40087 | 5153 | 57 |
1192057 | 1192057 | 2021-04-05 | McCurtain | Oklahoma | 40089 | 3887 | 71 |
1192058 | 1192058 | 2021-04-05 | McIntosh | Oklahoma | 40091 | 1971 | 39 |
1192059 | 1192059 | 2021-04-05 | Murray | Oklahoma | 40099 | 1957 | 23 |
1192060 | 1192060 | 2021-04-05 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1192061 | 1192061 | 2021-04-05 | Noble | Oklahoma | 40103 | 1370 | 16 |
1192062 | 1192062 | 2021-04-05 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1192063 | 1192063 | 2021-04-05 | Okfuskee | Oklahoma | 40107 | 1776 | 21 |
1192064 | 1192064 | 2021-04-05 | Oklahoma | Oklahoma | 40109 | 83647 | 837 |
1192065 | 1192065 | 2021-04-05 | Okmulgee | Oklahoma | 40111 | 3676 | 53 |
1192066 | 1192066 | 2021-04-05 | Osage | Oklahoma | 40113 | 4592 | 57 |
1192067 | 1192067 | 2021-04-05 | Ottawa | Oklahoma | 40115 | 3782 | 51 |
1192068 | 1192068 | 2021-04-05 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1192069 | 1192069 | 2021-04-05 | Payne | Oklahoma | 40119 | 8571 | 52 |
1192070 | 1192070 | 2021-04-05 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1192071 | 1192071 | 2021-04-05 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1192072 | 1192072 | 2021-04-05 | Pottawatomie | Oklahoma | 40125 | 8140 | 86 |
1192073 | 1192073 | 2021-04-05 | Pushmataha | Oklahoma | 40127 | 1005 | 14 |
1192074 | 1192074 | 2021-04-05 | Roger Mills | Oklahoma | 40129 | 386 | 9 |
1192075 | 1192075 | 2021-04-05 | Rogers | Oklahoma | 40131 | 10199 | 131 |
1192076 | 1192076 | 2021-04-05 | Seminole | Oklahoma | 40133 | 2817 | 43 |
1192077 | 1192077 | 2021-04-05 | Sequoyah | Oklahoma | 40135 | 4051 | 35 |
1192078 | 1192078 | 2021-04-05 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1192079 | 1192079 | 2021-04-05 | Texas | Oklahoma | 40139 | 3490 | 27 |
1192080 | 1192080 | 2021-04-05 | Tillman | Oklahoma | 40141 | 780 | 16 |
1192081 | 1192081 | 2021-04-05 | Tulsa | Oklahoma | 40143 | 72684 | 794 |
1192082 | 1192082 | 2021-04-05 | Unknown | Oklahoma | 2169 | 0 | |
1192083 | 1192083 | 2021-04-05 | Wagoner | Oklahoma | 40145 | 7848 | 91 |
1192084 | 1192084 | 2021-04-05 | Washington | Oklahoma | 40147 | 5047 | 95 |
1192085 | 1192085 | 2021-04-05 | Washita | Oklahoma | 40149 | 1067 | 9 |
1192086 | 1192086 | 2021-04-05 | Woods | Oklahoma | 40151 | 1197 | 11 |
1192087 | 1192087 | 2021-04-05 | Woodward | Oklahoma | 40153 | 3129 | 21 |
1192088 | 1192088 | 2021-04-05 | Baker | Oregon | 41001 | 779 | 12 |
1192089 | 1192089 | 2021-04-05 | Benton | Oregon | 41003 | 2611 | 18 |
1192090 | 1192090 | 2021-04-05 | Clackamas | Oregon | 41005 | 14490 | 201 |
1192091 | 1192091 | 2021-04-05 | Clatsop | Oregon | 41007 | 850 | 7 |
1192092 | 1192092 | 2021-04-05 | Columbia | Oregon | 41009 | 1437 | 24 |
1192093 | 1192093 | 2021-04-05 | Coos | Oregon | 41011 | 1903 | 29 |
1192094 | 1192094 | 2021-04-05 | Crook | Oregon | 41013 | 822 | 18 |
1192095 | 1192095 | 2021-04-05 | Curry | Oregon | 41015 | 562 | 9 |
1192096 | 1192096 | 2021-04-05 | Deschutes | Oregon | 41017 | 6470 | 70 |
1192097 | 1192097 | 2021-04-05 | Douglas | Oregon | 41019 | 2937 | 60 |
1192098 | 1192098 | 2021-04-05 | Gilliam | Oregon | 41021 | 54 | 1 |
1192099 | 1192099 | 2021-04-05 | Grant | Oregon | 41023 | 292 | 4 |
1192100 | 1192100 | 2021-04-05 | Harney | Oregon | 41025 | 294 | 6 |
1192101 | 1192101 | 2021-04-05 | Hood River | Oregon | 41027 | 1086 | 29 |
1192102 | 1192102 | 2021-04-05 | Jackson | Oregon | 41029 | 9400 | 123 |
1192103 | 1192103 | 2021-04-05 | Jefferson | Oregon | 41031 | 2022 | 31 |
1192104 | 1192104 | 2021-04-05 | Josephine | Oregon | 41033 | 2864 | 60 |
1192105 | 1192105 | 2021-04-05 | Klamath | Oregon | 41035 | 3086 | 57 |
1192106 | 1192106 | 2021-04-05 | Lake | Oregon | 41037 | 406 | 7 |
1192107 | 1192107 | 2021-04-05 | Lane | Oregon | 41039 | 10935 | 143 |
1192108 | 1192108 | 2021-04-05 | Lincoln | Oregon | 41041 | 1235 | 20 |
1192109 | 1192109 | 2021-04-05 | Linn | Oregon | 41043 | 3907 | 60 |
1192110 | 1192110 | 2021-04-05 | Malheur | Oregon | 41045 | 3403 | 58 |
1192111 | 1192111 | 2021-04-05 | Marion | Oregon | 41047 | 19510 | 297 |
1192112 | 1192112 | 2021-04-05 | Morrow | Oregon | 41049 | 1064 | 15 |
1192113 | 1192113 | 2021-04-05 | Multnomah | Oregon | 41051 | 33712 | 567 |
1192114 | 1192114 | 2021-04-05 | Polk | Oregon | 41053 | 3289 | 48 |
1192115 | 1192115 | 2021-04-05 | Sherman | Oregon | 41055 | 53 | 0 |
1192116 | 1192116 | 2021-04-05 | Tillamook | Oregon | 41057 | 533 | 2 |
1192117 | 1192117 | 2021-04-05 | Umatilla | Oregon | 41059 | 7884 | 82 |
1192118 | 1192118 | 2021-04-05 | Union | Oregon | 41061 | 1390 | 22 |
1192119 | 1192119 | 2021-04-05 | Wallowa | Oregon | 41063 | 151 | 5 |
1192120 | 1192120 | 2021-04-05 | Wasco | Oregon | 41065 | 1246 | 27 |
1192121 | 1192121 | 2021-04-05 | Washington | Oregon | 41067 | 22526 | 226 |
1192122 | 1192122 | 2021-04-05 | Wheeler | Oregon | 41069 | 25 | 1 |
1192123 | 1192123 | 2021-04-05 | Yamhill | Oregon | 41071 | 3991 | 70 |
1192124 | 1192124 | 2021-04-05 | Adams | Pennsylvania | 42001 | 8275 | 161 |
1192125 | 1192125 | 2021-04-05 | Allegheny | Pennsylvania | 42003 | 87623 | 1823 |
1192126 | 1192126 | 2021-04-05 | Armstrong | Pennsylvania | 42005 | 5241 | 120 |
1192127 | 1192127 | 2021-04-05 | Beaver | Pennsylvania | 42007 | 13414 | 360 |
1192128 | 1192128 | 2021-04-05 | Bedford | Pennsylvania | 42009 | 3999 | 130 |
1192129 | 1192129 | 2021-04-05 | Berks | Pennsylvania | 42011 | 40836 | 932 |
1192130 | 1192130 | 2021-04-05 | Blair | Pennsylvania | 42013 | 11294 | 314 |
1192131 | 1192131 | 2021-04-05 | Bradford | Pennsylvania | 42015 | 4955 | 84 |
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);