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 72,844
- Georgia 48,889
- Virginia 39,945
- Kentucky 35,572
- Missouri 34,024
- Illinois 30,583
- North Carolina 30,309
- Iowa 29,570
- Kansas 29,299
- Tennessee 29,119
- Indiana 28,186
- Ohio 26,866
- Minnesota 26,083
- Michigan 25,302
- Mississippi 25,140
- Nebraska 24,722
- Oklahoma 22,874
- Arkansas 22,856
- Wisconsin 21,791
- Florida 21,024
- Puerto Rico 20,872
- Pennsylvania 20,616
- Alabama 20,420
- Louisiana 20,028
- Colorado 19,063
- South Dakota 18,202
- New York 18,142
- California 18,077
- West Virginia 16,111
- North Dakota 14,849
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956497 | 956497 | 2021-01-23 | Madison | Florida | 12079 | 1770 | 36 |
956498 | 956498 | 2021-01-23 | Manatee | Florida | 12081 | 27224 | 484 |
956499 | 956499 | 2021-01-23 | Marion | Florida | 12083 | 23209 | 562 |
956500 | 956500 | 2021-01-23 | Martin | Florida | 12085 | 9278 | 236 |
956501 | 956501 | 2021-01-23 | Miami-Dade | Florida | 12086 | 357037 | 4703 |
956502 | 956502 | 2021-01-23 | Monroe | Florida | 12087 | 5135 | 39 |
956503 | 956503 | 2021-01-23 | Nassau | Florida | 12089 | 6613 | 79 |
956504 | 956504 | 2021-01-23 | Okaloosa | Florida | 12091 | 15826 | 276 |
956505 | 956505 | 2021-01-23 | Okeechobee | Florida | 12093 | 3110 | 56 |
956506 | 956506 | 2021-01-23 | Orange | Florida | 12095 | 97841 | 892 |
956507 | 956507 | 2021-01-23 | Osceola | Florida | 12097 | 32033 | 334 |
956508 | 956508 | 2021-01-23 | Palm Beach | Florida | 12099 | 101829 | 2093 |
956509 | 956509 | 2021-01-23 | Pasco | Florida | 12101 | 28076 | 494 |
956510 | 956510 | 2021-01-23 | Pinellas | Florida | 12103 | 56564 | 1220 |
956511 | 956511 | 2021-01-23 | Polk | Florida | 12105 | 47795 | 928 |
956512 | 956512 | 2021-01-23 | Putnam | Florida | 12107 | 5224 | 96 |
956513 | 956513 | 2021-01-23 | Santa Rosa | Florida | 12113 | 14611 | 195 |
956514 | 956514 | 2021-01-23 | Sarasota | Florida | 12115 | 23718 | 602 |
956515 | 956515 | 2021-01-23 | Seminole | Florida | 12117 | 22928 | 353 |
956516 | 956516 | 2021-01-23 | St. Johns | Florida | 12109 | 17379 | 151 |
956517 | 956517 | 2021-01-23 | St. Lucie | Florida | 12111 | 18525 | 470 |
956518 | 956518 | 2021-01-23 | Sumter | Florida | 12119 | 6706 | 169 |
956519 | 956519 | 2021-01-23 | Suwannee | Florida | 12121 | 4716 | 106 |
956520 | 956520 | 2021-01-23 | Taylor | Florida | 12123 | 2368 | 32 |
956521 | 956521 | 2021-01-23 | Union | Florida | 12125 | 1631 | 70 |
956522 | 956522 | 2021-01-23 | Unknown | Florida | 3293 | 0 | |
956523 | 956523 | 2021-01-23 | Volusia | Florida | 12127 | 29051 | 492 |
956524 | 956524 | 2021-01-23 | Wakulla | Florida | 12129 | 2803 | 38 |
956525 | 956525 | 2021-01-23 | Walton | Florida | 12131 | 6037 | 63 |
956526 | 956526 | 2021-01-23 | Washington | Florida | 12133 | 2345 | 30 |
956527 | 956527 | 2021-01-23 | Appling | Georgia | 13001 | 1950 | 50 |
956528 | 956528 | 2021-01-23 | Atkinson | Georgia | 13003 | 923 | 12 |
956529 | 956529 | 2021-01-23 | Bacon | Georgia | 13005 | 1266 | 30 |
956530 | 956530 | 2021-01-23 | Baker | Georgia | 13007 | 204 | 6 |
956531 | 956531 | 2021-01-23 | Baldwin | Georgia | 13009 | 3800 | 88 |
956532 | 956532 | 2021-01-23 | Banks | Georgia | 13011 | 1538 | 26 |
956533 | 956533 | 2021-01-23 | Barrow | Georgia | 13013 | 7487 | 88 |
956534 | 956534 | 2021-01-23 | Bartow | Georgia | 13015 | 10583 | 156 |
956535 | 956535 | 2021-01-23 | Ben Hill | Georgia | 13017 | 1913 | 58 |
956536 | 956536 | 2021-01-23 | Berrien | Georgia | 13019 | 1449 | 35 |
956537 | 956537 | 2021-01-23 | Bibb | Georgia | 13021 | 12810 | 308 |
956538 | 956538 | 2021-01-23 | Bleckley | Georgia | 13023 | 1299 | 40 |
956539 | 956539 | 2021-01-23 | Brantley | Georgia | 13025 | 1302 | 25 |
956540 | 956540 | 2021-01-23 | Brooks | Georgia | 13027 | 1145 | 37 |
956541 | 956541 | 2021-01-23 | Bryan | Georgia | 13029 | 2573 | 25 |
956542 | 956542 | 2021-01-23 | Bulloch | Georgia | 13031 | 5441 | 69 |
956543 | 956543 | 2021-01-23 | Burke | Georgia | 13033 | 2059 | 33 |
956544 | 956544 | 2021-01-23 | Butts | Georgia | 13035 | 2245 | 57 |
956545 | 956545 | 2021-01-23 | Calhoun | Georgia | 13037 | 510 | 12 |
956546 | 956546 | 2021-01-23 | Camden | Georgia | 13039 | 3139 | 24 |
956547 | 956547 | 2021-01-23 | Candler | Georgia | 13043 | 866 | 38 |
956548 | 956548 | 2021-01-23 | Carroll | Georgia | 13045 | 9130 | 156 |
956549 | 956549 | 2021-01-23 | Catoosa | Georgia | 13047 | 4584 | 48 |
956550 | 956550 | 2021-01-23 | Charlton | Georgia | 13049 | 1201 | 23 |
956551 | 956551 | 2021-01-23 | Chatham | Georgia | 13051 | 17300 | 286 |
956552 | 956552 | 2021-01-23 | Chattahoochee | Georgia | 13053 | 2447 | 3 |
956553 | 956553 | 2021-01-23 | Chattooga | Georgia | 13055 | 2299 | 55 |
956554 | 956554 | 2021-01-23 | Cherokee | Georgia | 13057 | 22940 | 190 |
956555 | 956555 | 2021-01-23 | Clarke | Georgia | 13059 | 12482 | 84 |
956556 | 956556 | 2021-01-23 | Clay | Georgia | 13061 | 211 | 3 |
956557 | 956557 | 2021-01-23 | Clayton | Georgia | 13063 | 18487 | 281 |
956558 | 956558 | 2021-01-23 | Clinch | Georgia | 13065 | 806 | 16 |
956559 | 956559 | 2021-01-23 | Cobb | Georgia | 13067 | 59154 | 692 |
956560 | 956560 | 2021-01-23 | Coffee | Georgia | 13069 | 4799 | 117 |
956561 | 956561 | 2021-01-23 | Colquitt | Georgia | 13071 | 3861 | 65 |
956562 | 956562 | 2021-01-23 | Columbia | Georgia | 13073 | 13400 | 133 |
956563 | 956563 | 2021-01-23 | Cook | Georgia | 13075 | 1529 | 33 |
956564 | 956564 | 2021-01-23 | Coweta | Georgia | 13077 | 10661 | 109 |
956565 | 956565 | 2021-01-23 | Crawford | Georgia | 13079 | 532 | 10 |
956566 | 956566 | 2021-01-23 | Crisp | Georgia | 13081 | 1698 | 50 |
956567 | 956567 | 2021-01-23 | Dade | Georgia | 13083 | 1061 | 9 |
956568 | 956568 | 2021-01-23 | Dawson | Georgia | 13085 | 2458 | 23 |
956569 | 956569 | 2021-01-23 | DeKalb | Georgia | 13089 | 48775 | 607 |
956570 | 956570 | 2021-01-23 | Decatur | Georgia | 13087 | 2414 | 57 |
956571 | 956571 | 2021-01-23 | Dodge | Georgia | 13091 | 1919 | 85 |
956572 | 956572 | 2021-01-23 | Dooly | Georgia | 13093 | 851 | 31 |
956573 | 956573 | 2021-01-23 | Dougherty | Georgia | 13095 | 6244 | 244 |
956574 | 956574 | 2021-01-23 | Douglas | Georgia | 13097 | 10950 | 137 |
956575 | 956575 | 2021-01-23 | Early | Georgia | 13099 | 990 | 43 |
956576 | 956576 | 2021-01-23 | Echols | Georgia | 13101 | 428 | 6 |
956577 | 956577 | 2021-01-23 | Effingham | Georgia | 13103 | 3371 | 45 |
956578 | 956578 | 2021-01-23 | Elbert | Georgia | 13105 | 2011 | 41 |
956579 | 956579 | 2021-01-23 | Emanuel | Georgia | 13107 | 2242 | 65 |
956580 | 956580 | 2021-01-23 | Evans | Georgia | 13109 | 802 | 16 |
956581 | 956581 | 2021-01-23 | Fannin | Georgia | 13111 | 1850 | 47 |
956582 | 956582 | 2021-01-23 | Fayette | Georgia | 13113 | 6332 | 104 |
956583 | 956583 | 2021-01-23 | Floyd | Georgia | 13115 | 9540 | 154 |
956584 | 956584 | 2021-01-23 | Forsyth | Georgia | 13117 | 16226 | 100 |
956585 | 956585 | 2021-01-23 | Franklin | Georgia | 13119 | 2267 | 31 |
956586 | 956586 | 2021-01-23 | Fulton | Georgia | 13121 | 73426 | 907 |
956587 | 956587 | 2021-01-23 | Gilmer | Georgia | 13123 | 2380 | 46 |
956588 | 956588 | 2021-01-23 | Glascock | Georgia | 13125 | 214 | 9 |
956589 | 956589 | 2021-01-23 | Glynn | Georgia | 13127 | 6434 | 147 |
956590 | 956590 | 2021-01-23 | Gordon | Georgia | 13129 | 6025 | 81 |
956591 | 956591 | 2021-01-23 | Grady | Georgia | 13131 | 1795 | 43 |
956592 | 956592 | 2021-01-23 | Greene | Georgia | 13133 | 1451 | 31 |
956593 | 956593 | 2021-01-23 | Gwinnett | Georgia | 13135 | 78555 | 700 |
956594 | 956594 | 2021-01-23 | Habersham | Georgia | 13137 | 4621 | 112 |
956595 | 956595 | 2021-01-23 | Hall | Georgia | 13139 | 23198 | 307 |
956596 | 956596 | 2021-01-23 | Hancock | Georgia | 13141 | 807 | 52 |
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);