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 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,640
- 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
- New York 31,714
- California 31,700
- West Virginia 28,983
- North Dakota 27,485
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716093 | 1716093 | 2021-09-14 | Kern | California | 6029 | 132607 | 1505 |
1716094 | 1716094 | 2021-09-14 | Kings | California | 6031 | 29463 | 278 |
1716095 | 1716095 | 2021-09-14 | Lake | California | 6033 | 5887 | 82 |
1716096 | 1716096 | 2021-09-14 | Lassen | California | 6035 | 6741 | 32 |
1716097 | 1716097 | 2021-09-14 | Los Angeles | California | 6037 | 1435872 | 25713 |
1716098 | 1716098 | 2021-09-14 | Madera | California | 6039 | 21209 | 254 |
1716099 | 1716099 | 2021-09-14 | Marin | California | 6041 | 16944 | 242 |
1716100 | 1716100 | 2021-09-14 | Mariposa | California | 6043 | 933 | 10 |
1716101 | 1716101 | 2021-09-14 | Mendocino | California | 6045 | 6599 | 69 |
1716102 | 1716102 | 2021-09-14 | Merced | California | 6047 | 38856 | 532 |
1716103 | 1716103 | 2021-09-14 | Modoc | California | 6049 | 647 | 8 |
1716104 | 1716104 | 2021-09-14 | Mono | California | 6051 | 1461 | 5 |
1716105 | 1716105 | 2021-09-14 | Monterey | California | 6053 | 48922 | 563 |
1716106 | 1716106 | 2021-09-14 | Napa | California | 6055 | 12117 | 91 |
1716107 | 1716107 | 2021-09-14 | Nevada | California | 6057 | 8283 | 85 |
1716108 | 1716108 | 2021-09-14 | Orange | California | 6059 | 312348 | 5316 |
1716109 | 1716109 | 2021-09-14 | Placer | California | 6061 | 35550 | 343 |
1716110 | 1716110 | 2021-09-14 | Plumas | California | 6063 | 1167 | 6 |
1716111 | 1716111 | 2021-09-14 | Riverside | California | 6065 | 354155 | 4851 |
1716112 | 1716112 | 2021-09-14 | Sacramento | California | 6067 | 147938 | 2038 |
1716113 | 1716113 | 2021-09-14 | San Benito | California | 6069 | 7009 | 64 |
1716114 | 1716114 | 2021-09-14 | San Bernardino | California | 6071 | 343967 | 5441 |
1716115 | 1716115 | 2021-09-14 | San Diego | California | 6073 | 362482 | 3961 |
1716116 | 1716116 | 2021-09-14 | San Francisco | California | 6075 | 51296 | 603 |
1716117 | 1716117 | 2021-09-14 | San Joaquin | California | 6077 | 95699 | 1581 |
1716118 | 1716118 | 2021-09-14 | San Luis Obispo | California | 6079 | 27864 | 301 |
1716119 | 1716119 | 2021-09-14 | San Mateo | California | 6081 | 51629 | 603 |
1716120 | 1716120 | 2021-09-14 | Santa Barbara | California | 6083 | 42212 | 494 |
1716121 | 1716121 | 2021-09-14 | Santa Clara | California | 6085 | 139229 | 1821 |
1716122 | 1716122 | 2021-09-14 | Santa Cruz | California | 6087 | 19951 | 210 |
1716123 | 1716123 | 2021-09-14 | Shasta | California | 6089 | 19575 | 266 |
1716124 | 1716124 | 2021-09-14 | Sierra | California | 6091 | 138 | 0 |
1716125 | 1716125 | 2021-09-14 | Siskiyou | California | 6093 | 3933 | 46 |
1716126 | 1716126 | 2021-09-14 | Solano | California | 6095 | 43575 | 306 |
1716127 | 1716127 | 2021-09-14 | Sonoma | California | 6097 | 38984 | 368 |
1716128 | 1716128 | 2021-09-14 | Stanislaus | California | 6099 | 79230 | 1197 |
1716129 | 1716129 | 2021-09-14 | Sutter | California | 6101 | 12812 | 145 |
1716130 | 1716130 | 2021-09-14 | Tehama | California | 6103 | 7839 | 79 |
1716131 | 1716131 | 2021-09-14 | Trinity | California | 6105 | 677 | 7 |
1716132 | 1716132 | 2021-09-14 | Tulare | California | 6107 | 70927 | 887 |
1716133 | 1716133 | 2021-09-14 | Tuolumne | California | 6109 | 6131 | 99 |
1716134 | 1716134 | 2021-09-14 | Ventura | California | 6111 | 96840 | 1107 |
1716135 | 1716135 | 2021-09-14 | Yolo | California | 6113 | 18823 | 239 |
1716136 | 1716136 | 2021-09-14 | Yuba | California | 6115 | 9251 | 61 |
1716137 | 1716137 | 2021-09-14 | Adams | Colorado | 8001 | 69856 | 819 |
1716138 | 1716138 | 2021-09-14 | Alamosa | Colorado | 8003 | 2000 | 42 |
1716139 | 1716139 | 2021-09-14 | Arapahoe | Colorado | 8005 | 72899 | 866 |
1716140 | 1716140 | 2021-09-14 | Archuleta | Colorado | 8007 | 1305 | 3 |
1716141 | 1716141 | 2021-09-14 | Baca | Colorado | 8009 | 371 | 5 |
1716142 | 1716142 | 2021-09-14 | Bent | Colorado | 8011 | 1580 | 22 |
1716143 | 1716143 | 2021-09-14 | Boulder | Colorado | 8013 | 27588 | 267 |
1716144 | 1716144 | 2021-09-14 | Broomfield | Colorado | 8014 | 5883 | 77 |
1716145 | 1716145 | 2021-09-14 | Chaffee | Colorado | 8015 | 2010 | 26 |
1716146 | 1716146 | 2021-09-14 | Cheyenne | Colorado | 8017 | 148 | 7 |
1716147 | 1716147 | 2021-09-14 | Clear Creek | Colorado | 8019 | 649 | 4 |
1716148 | 1716148 | 2021-09-14 | Conejos | Colorado | 8021 | 818 | 28 |
1716149 | 1716149 | 2021-09-14 | Costilla | Colorado | 8023 | 297 | 6 |
1716150 | 1716150 | 2021-09-14 | Crowley | Colorado | 8025 | 2242 | 18 |
1716151 | 1716151 | 2021-09-14 | Custer | Colorado | 8027 | 274 | 6 |
1716152 | 1716152 | 2021-09-14 | Delta | Colorado | 8029 | 3336 | 78 |
1716153 | 1716153 | 2021-09-14 | Denver | Colorado | 8031 | 83127 | 884 |
1716154 | 1716154 | 2021-09-14 | Dolores | Colorado | 8033 | 157 | 1 |
1716155 | 1716155 | 2021-09-14 | Douglas | Colorado | 8035 | 36357 | 280 |
1716156 | 1716156 | 2021-09-14 | Eagle | Colorado | 8037 | 7640 | 29 |
1716157 | 1716157 | 2021-09-14 | El Paso | Colorado | 8041 | 86922 | 970 |
1716158 | 1716158 | 2021-09-14 | Elbert | Colorado | 8039 | 2251 | 18 |
1716159 | 1716159 | 2021-09-14 | Fremont | Colorado | 8043 | 7070 | 71 |
1716160 | 1716160 | 2021-09-14 | Garfield | Colorado | 8045 | 6993 | 58 |
1716161 | 1716161 | 2021-09-14 | Gilpin | Colorado | 8047 | 359 | 3 |
1716162 | 1716162 | 2021-09-14 | Grand | Colorado | 8049 | 1780 | 8 |
1716163 | 1716163 | 2021-09-14 | Gunnison | Colorado | 8051 | 1657 | 8 |
1716164 | 1716164 | 2021-09-14 | Hinsdale | Colorado | 8053 | 52 | 0 |
1716165 | 1716165 | 2021-09-14 | Huerfano | Colorado | 8055 | 530 | 17 |
1716166 | 1716166 | 2021-09-14 | Jackson | Colorado | 8057 | 74 | 0 |
1716167 | 1716167 | 2021-09-14 | Jefferson | Colorado | 8059 | 55675 | 848 |
1716168 | 1716168 | 2021-09-14 | Kiowa | Colorado | 8061 | 113 | 3 |
1716169 | 1716169 | 2021-09-14 | Kit Carson | Colorado | 8063 | 809 | 14 |
1716170 | 1716170 | 2021-09-14 | La Plata | Colorado | 8067 | 4875 | 48 |
1716171 | 1716171 | 2021-09-14 | Lake | Colorado | 8065 | 938 | 1 |
1716172 | 1716172 | 2021-09-14 | Larimer | Colorado | 8069 | 33364 | 268 |
1716173 | 1716173 | 2021-09-14 | Las Animas | Colorado | 8071 | 1567 | 19 |
1716174 | 1716174 | 2021-09-14 | Lincoln | Colorado | 8073 | 1165 | 6 |
1716175 | 1716175 | 2021-09-14 | Logan | Colorado | 8075 | 4304 | 72 |
1716176 | 1716176 | 2021-09-14 | Mesa | Colorado | 8077 | 20299 | 286 |
1716177 | 1716177 | 2021-09-14 | Mineral | Colorado | 8079 | 105 | 1 |
1716178 | 1716178 | 2021-09-14 | Moffat | Colorado | 8081 | 1484 | 30 |
1716179 | 1716179 | 2021-09-14 | Montezuma | Colorado | 8083 | 2458 | 33 |
1716180 | 1716180 | 2021-09-14 | Montrose | Colorado | 8085 | 4442 | 75 |
1716181 | 1716181 | 2021-09-14 | Morgan | Colorado | 8087 | 3030 | 97 |
1716182 | 1716182 | 2021-09-14 | Otero | Colorado | 8089 | 2252 | 71 |
1716183 | 1716183 | 2021-09-14 | Ouray | Colorado | 8091 | 368 | 5 |
1716184 | 1716184 | 2021-09-14 | Park | Colorado | 8093 | 1090 | 7 |
1716185 | 1716185 | 2021-09-14 | Phillips | Colorado | 8095 | 445 | 14 |
1716186 | 1716186 | 2021-09-14 | Pitkin | Colorado | 8097 | 2918 | 4 |
1716187 | 1716187 | 2021-09-14 | Prowers | Colorado | 8099 | 1417 | 25 |
1716188 | 1716188 | 2021-09-14 | Pueblo | Colorado | 8101 | 21636 | 448 |
1716189 | 1716189 | 2021-09-14 | Rio Blanco | Colorado | 8103 | 801 | 7 |
1716190 | 1716190 | 2021-09-14 | Rio Grande | Colorado | 8105 | 1103 | 20 |
1716191 | 1716191 | 2021-09-14 | Routt | Colorado | 8107 | 2906 | 22 |
1716192 | 1716192 | 2021-09-14 | Saguache | Colorado | 8109 | 523 | 8 |
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);