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,377
- Virginia 62,023
- Kentucky 55,492
- Missouri 53,447
- Illinois 47,675
- North Carolina 46,909
- Kansas 46,813
- Iowa 46,170
- Tennessee 45,055
- Indiana 43,458
- Ohio 41,600
- Minnesota 40,691
- Nebraska 40,214
- Michigan 39,246
- Mississippi 38,752
- Oklahoma 35,821
- Arkansas 35,472
- Puerto Rico 33,986
- Wisconsin 33,743
- Florida 32,282
- Pennsylvania 31,738
- Alabama 31,542
- Louisiana 30,818
- 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 |
---|---|---|---|---|---|---|---|
1495492 | 1495492 | 2021-07-08 | Hart | Georgia | 13147 | 2442 | 57 |
1495493 | 1495493 | 2021-07-08 | Heard | Georgia | 13149 | 893 | 23 |
1495494 | 1495494 | 2021-07-08 | Henry | Georgia | 13151 | 26106 | 335 |
1495495 | 1495495 | 2021-07-08 | Houston | Georgia | 13153 | 15040 | 274 |
1495496 | 1495496 | 2021-07-08 | Irwin | Georgia | 13155 | 1033 | 31 |
1495497 | 1495497 | 2021-07-08 | Jackson | Georgia | 13157 | 10071 | 151 |
1495498 | 1495498 | 2021-07-08 | Jasper | Georgia | 13159 | 1421 | 40 |
1495499 | 1495499 | 2021-07-08 | Jeff Davis | Georgia | 13161 | 1932 | 44 |
1495500 | 1495500 | 2021-07-08 | Jefferson | Georgia | 13163 | 1977 | 69 |
1495501 | 1495501 | 2021-07-08 | Jenkins | Georgia | 13165 | 873 | 44 |
1495502 | 1495502 | 2021-07-08 | Johnson | Georgia | 13167 | 1135 | 50 |
1495503 | 1495503 | 2021-07-08 | Jones | Georgia | 13169 | 2081 | 59 |
1495504 | 1495504 | 2021-07-08 | Lamar | Georgia | 13171 | 2081 | 58 |
1495505 | 1495505 | 2021-07-08 | Lanier | Georgia | 13173 | 802 | 13 |
1495506 | 1495506 | 2021-07-08 | Laurens | Georgia | 13175 | 5710 | 173 |
1495507 | 1495507 | 2021-07-08 | Lee | Georgia | 13177 | 2790 | 59 |
1495508 | 1495508 | 2021-07-08 | Liberty | Georgia | 13179 | 4209 | 68 |
1495509 | 1495509 | 2021-07-08 | Lincoln | Georgia | 13181 | 847 | 28 |
1495510 | 1495510 | 2021-07-08 | Long | Georgia | 13183 | 887 | 13 |
1495511 | 1495511 | 2021-07-08 | Lowndes | Georgia | 13185 | 13133 | 217 |
1495512 | 1495512 | 2021-07-08 | Lumpkin | Georgia | 13187 | 3059 | 79 |
1495513 | 1495513 | 2021-07-08 | Macon | Georgia | 13193 | 893 | 37 |
1495514 | 1495514 | 2021-07-08 | Madison | Georgia | 13195 | 3295 | 56 |
1495515 | 1495515 | 2021-07-08 | Marion | Georgia | 13197 | 578 | 24 |
1495516 | 1495516 | 2021-07-08 | McDuffie | Georgia | 13189 | 2555 | 52 |
1495517 | 1495517 | 2021-07-08 | McIntosh | Georgia | 13191 | 871 | 16 |
1495518 | 1495518 | 2021-07-08 | Meriwether | Georgia | 13199 | 2081 | 89 |
1495519 | 1495519 | 2021-07-08 | Miller | Georgia | 13201 | 856 | 14 |
1495520 | 1495520 | 2021-07-08 | Mitchell | Georgia | 13205 | 2114 | 84 |
1495521 | 1495521 | 2021-07-08 | Monroe | Georgia | 13207 | 2745 | 103 |
1495522 | 1495522 | 2021-07-08 | Montgomery | Georgia | 13209 | 909 | 23 |
1495523 | 1495523 | 2021-07-08 | Morgan | Georgia | 13211 | 2291 | 31 |
1495524 | 1495524 | 2021-07-08 | Murray | Georgia | 13213 | 5056 | 92 |
1495525 | 1495525 | 2021-07-08 | Muscogee | Georgia | 13215 | 17018 | 500 |
1495526 | 1495526 | 2021-07-08 | Newton | Georgia | 13217 | 11451 | 263 |
1495527 | 1495527 | 2021-07-08 | Oconee | Georgia | 13219 | 4065 | 73 |
1495528 | 1495528 | 2021-07-08 | Oglethorpe | Georgia | 13221 | 1515 | 31 |
1495529 | 1495529 | 2021-07-08 | Paulding | Georgia | 13223 | 17541 | 232 |
1495530 | 1495530 | 2021-07-08 | Peach | Georgia | 13225 | 2731 | 70 |
1495531 | 1495531 | 2021-07-08 | Pickens | Georgia | 13227 | 3557 | 79 |
1495532 | 1495532 | 2021-07-08 | Pierce | Georgia | 13229 | 2541 | 62 |
1495533 | 1495533 | 2021-07-08 | Pike | Georgia | 13231 | 2377 | 43 |
1495534 | 1495534 | 2021-07-08 | Polk | Georgia | 13233 | 5759 | 100 |
1495535 | 1495535 | 2021-07-08 | Pulaski | Georgia | 13235 | 948 | 45 |
1495536 | 1495536 | 2021-07-08 | Putnam | Georgia | 13237 | 2259 | 59 |
1495537 | 1495537 | 2021-07-08 | Quitman | Georgia | 13239 | 170 | 3 |
1495538 | 1495538 | 2021-07-08 | Rabun | Georgia | 13241 | 1803 | 50 |
1495539 | 1495539 | 2021-07-08 | Randolph | Georgia | 13243 | 651 | 34 |
1495540 | 1495540 | 2021-07-08 | Richmond | Georgia | 13245 | 25238 | 532 |
1495541 | 1495541 | 2021-07-08 | Rockdale | Georgia | 13247 | 7961 | 178 |
1495542 | 1495542 | 2021-07-08 | Schley | Georgia | 13249 | 355 | 5 |
1495543 | 1495543 | 2021-07-08 | Screven | Georgia | 13251 | 1022 | 33 |
1495544 | 1495544 | 2021-07-08 | Seminole | Georgia | 13253 | 962 | 19 |
1495545 | 1495545 | 2021-07-08 | Spalding | Georgia | 13255 | 6527 | 203 |
1495546 | 1495546 | 2021-07-08 | Stephens | Georgia | 13257 | 3185 | 81 |
1495547 | 1495547 | 2021-07-08 | Stewart | Georgia | 13259 | 1072 | 25 |
1495548 | 1495548 | 2021-07-08 | Sumter | Georgia | 13261 | 2646 | 106 |
1495549 | 1495549 | 2021-07-08 | Talbot | Georgia | 13263 | 501 | 19 |
1495550 | 1495550 | 2021-07-08 | Taliaferro | Georgia | 13265 | 123 | 3 |
1495551 | 1495551 | 2021-07-08 | Tattnall | Georgia | 13267 | 2375 | 69 |
1495552 | 1495552 | 2021-07-08 | Taylor | Georgia | 13269 | 819 | 26 |
1495553 | 1495553 | 2021-07-08 | Telfair | Georgia | 13271 | 1353 | 60 |
1495554 | 1495554 | 2021-07-08 | Terrell | Georgia | 13273 | 823 | 49 |
1495555 | 1495555 | 2021-07-08 | Thomas | Georgia | 13275 | 4645 | 126 |
1495556 | 1495556 | 2021-07-08 | Tift | Georgia | 13277 | 5000 | 132 |
1495557 | 1495557 | 2021-07-08 | Toombs | Georgia | 13279 | 3477 | 119 |
1495558 | 1495558 | 2021-07-08 | Towns | Georgia | 13281 | 1286 | 60 |
1495559 | 1495559 | 2021-07-08 | Treutlen | Georgia | 13283 | 862 | 34 |
1495560 | 1495560 | 2021-07-08 | Troup | Georgia | 13285 | 7705 | 239 |
1495561 | 1495561 | 2021-07-08 | Turner | Georgia | 13287 | 1061 | 42 |
1495562 | 1495562 | 2021-07-08 | Twiggs | Georgia | 13289 | 732 | 46 |
1495563 | 1495563 | 2021-07-08 | Union | Georgia | 13291 | 2310 | 81 |
1495564 | 1495564 | 2021-07-08 | Unknown | Georgia | 3031 | 4 | |
1495565 | 1495565 | 2021-07-08 | Upson | Georgia | 13293 | 3531 | 133 |
1495566 | 1495566 | 2021-07-08 | Walker | Georgia | 13295 | 7935 | 90 |
1495567 | 1495567 | 2021-07-08 | Walton | Georgia | 13297 | 10927 | 265 |
1495568 | 1495568 | 2021-07-08 | Ware | Georgia | 13299 | 5013 | 182 |
1495569 | 1495569 | 2021-07-08 | Warren | Georgia | 13301 | 552 | 20 |
1495570 | 1495570 | 2021-07-08 | Washington | Georgia | 13303 | 2172 | 88 |
1495571 | 1495571 | 2021-07-08 | Wayne | Georgia | 13305 | 3659 | 91 |
1495572 | 1495572 | 2021-07-08 | Webster | Georgia | 13307 | 150 | 4 |
1495573 | 1495573 | 2021-07-08 | Wheeler | Georgia | 13309 | 640 | 25 |
1495574 | 1495574 | 2021-07-08 | White | Georgia | 13311 | 3254 | 83 |
1495575 | 1495575 | 2021-07-08 | Whitfield | Georgia | 13313 | 17123 | 249 |
1495576 | 1495576 | 2021-07-08 | Wilcox | Georgia | 13315 | 844 | 48 |
1495577 | 1495577 | 2021-07-08 | Wilkes | Georgia | 13317 | 1116 | 30 |
1495578 | 1495578 | 2021-07-08 | Wilkinson | Georgia | 13319 | 947 | 27 |
1495579 | 1495579 | 2021-07-08 | Worth | Georgia | 13321 | 1808 | 69 |
1495580 | 1495580 | 2021-07-08 | Unknown | Guam | 9392 | 141 | |
1495581 | 1495581 | 2021-07-08 | Hawaii | Hawaii | 15001 | 3312 | 55 |
1495582 | 1495582 | 2021-07-08 | Honolulu | Hawaii | 15003 | 28145 | 402 |
1495583 | 1495583 | 2021-07-08 | Kalawao | Hawaii | 15005 | 1 | 0 |
1495584 | 1495584 | 2021-07-08 | Kauai | Hawaii | 15007 | 400 | 2 |
1495585 | 1495585 | 2021-07-08 | Maui | Hawaii | 15009 | 4919 | 57 |
1495586 | 1495586 | 2021-07-08 | Ada | Idaho | 16001 | 53844 | 487 |
1495587 | 1495587 | 2021-07-08 | Adams | Idaho | 16003 | 344 | 4 |
1495588 | 1495588 | 2021-07-08 | Bannock | Idaho | 16005 | 8896 | 110 |
1495589 | 1495589 | 2021-07-08 | Bear Lake | Idaho | 16007 | 405 | 2 |
1495590 | 1495590 | 2021-07-08 | Benewah | Idaho | 16009 | 773 | 10 |
1495591 | 1495591 | 2021-07-08 | Bingham | Idaho | 16011 | 4879 | 77 |
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);