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: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063597 | 1063597 | 2021-02-25 | Lafayette | Florida | 12067 | 1583 | 24 |
1063598 | 1063598 | 2021-02-25 | Lake | Florida | 12069 | 24342 | 544 |
1063599 | 1063599 | 2021-02-25 | Lee | Florida | 12071 | 57274 | 869 |
1063600 | 1063600 | 2021-02-25 | Leon | Florida | 12073 | 28960 | 276 |
1063601 | 1063601 | 2021-02-25 | Levy | Florida | 12075 | 2854 | 35 |
1063602 | 1063602 | 2021-02-25 | Liberty | Florida | 12077 | 1039 | 15 |
1063603 | 1063603 | 2021-02-25 | Madison | Florida | 12079 | 1980 | 42 |
1063604 | 1063604 | 2021-02-25 | Manatee | Florida | 12081 | 31579 | 577 |
1063605 | 1063605 | 2021-02-25 | Marion | Florida | 12083 | 27382 | 780 |
1063606 | 1063606 | 2021-02-25 | Martin | Florida | 12085 | 10500 | 273 |
1063607 | 1063607 | 2021-02-25 | Miami-Dade | Florida | 12086 | 406986 | 5369 |
1063608 | 1063608 | 2021-02-25 | Monroe | Florida | 12087 | 5771 | 46 |
1063609 | 1063609 | 2021-02-25 | Nassau | Florida | 12089 | 7681 | 109 |
1063610 | 1063610 | 2021-02-25 | Okaloosa | Florida | 12091 | 18661 | 327 |
1063611 | 1063611 | 2021-02-25 | Okeechobee | Florida | 12093 | 3545 | 75 |
1063612 | 1063612 | 2021-02-25 | Orange | Florida | 12095 | 113329 | 1090 |
1063613 | 1063613 | 2021-02-25 | Osceola | Florida | 12097 | 36521 | 435 |
1063614 | 1063614 | 2021-02-25 | Palm Beach | Florida | 12099 | 119371 | 2443 |
1063615 | 1063615 | 2021-02-25 | Pasco | Florida | 12101 | 33035 | 641 |
1063616 | 1063616 | 2021-02-25 | Pinellas | Florida | 12103 | 65937 | 1433 |
1063617 | 1063617 | 2021-02-25 | Polk | Florida | 12105 | 56583 | 1131 |
1063618 | 1063618 | 2021-02-25 | Putnam | Florida | 12107 | 5820 | 123 |
1063619 | 1063619 | 2021-02-25 | Santa Rosa | Florida | 12113 | 16972 | 256 |
1063620 | 1063620 | 2021-02-25 | Sarasota | Florida | 12115 | 26804 | 730 |
1063621 | 1063621 | 2021-02-25 | Seminole | Florida | 12117 | 26967 | 422 |
1063622 | 1063622 | 2021-02-25 | St. Johns | Florida | 12109 | 19982 | 189 |
1063623 | 1063623 | 2021-02-25 | St. Lucie | Florida | 12111 | 21949 | 543 |
1063624 | 1063624 | 2021-02-25 | Sumter | Florida | 12119 | 7946 | 235 |
1063625 | 1063625 | 2021-02-25 | Suwannee | Florida | 12121 | 5099 | 131 |
1063626 | 1063626 | 2021-02-25 | Taylor | Florida | 12123 | 2624 | 41 |
1063627 | 1063627 | 2021-02-25 | Union | Florida | 12125 | 1740 | 70 |
1063628 | 1063628 | 2021-02-25 | Unknown | Florida | 3446 | 0 | |
1063629 | 1063629 | 2021-02-25 | Volusia | Florida | 12127 | 34240 | 650 |
1063630 | 1063630 | 2021-02-25 | Wakulla | Florida | 12129 | 3151 | 51 |
1063631 | 1063631 | 2021-02-25 | Walton | Florida | 12131 | 6996 | 80 |
1063632 | 1063632 | 2021-02-25 | Washington | Florida | 12133 | 2616 | 41 |
1063633 | 1063633 | 2021-02-25 | Appling | Georgia | 13001 | 2208 | 62 |
1063634 | 1063634 | 2021-02-25 | Atkinson | Georgia | 13003 | 983 | 19 |
1063635 | 1063635 | 2021-02-25 | Bacon | Georgia | 13005 | 1359 | 34 |
1063636 | 1063636 | 2021-02-25 | Baker | Georgia | 13007 | 220 | 7 |
1063637 | 1063637 | 2021-02-25 | Baldwin | Georgia | 13009 | 4275 | 108 |
1063638 | 1063638 | 2021-02-25 | Banks | Georgia | 13011 | 1711 | 32 |
1063639 | 1063639 | 2021-02-25 | Barrow | Georgia | 13013 | 8868 | 116 |
1063640 | 1063640 | 2021-02-25 | Bartow | Georgia | 13015 | 12948 | 197 |
1063641 | 1063641 | 2021-02-25 | Ben Hill | Georgia | 13017 | 2034 | 73 |
1063642 | 1063642 | 2021-02-25 | Berrien | Georgia | 13019 | 1692 | 40 |
1063643 | 1063643 | 2021-02-25 | Bibb | Georgia | 13021 | 14805 | 373 |
1063644 | 1063644 | 2021-02-25 | Bleckley | Georgia | 13023 | 1429 | 49 |
1063645 | 1063645 | 2021-02-25 | Brantley | Georgia | 13025 | 1507 | 29 |
1063646 | 1063646 | 2021-02-25 | Brooks | Georgia | 13027 | 1278 | 45 |
1063647 | 1063647 | 2021-02-25 | Bryan | Georgia | 13029 | 3186 | 33 |
1063648 | 1063648 | 2021-02-25 | Bulloch | Georgia | 13031 | 6371 | 91 |
1063649 | 1063649 | 2021-02-25 | Burke | Georgia | 13033 | 2375 | 51 |
1063650 | 1063650 | 2021-02-25 | Butts | Georgia | 13035 | 2642 | 73 |
1063651 | 1063651 | 2021-02-25 | Calhoun | Georgia | 13037 | 574 | 15 |
1063652 | 1063652 | 2021-02-25 | Camden | Georgia | 13039 | 3687 | 30 |
1063653 | 1063653 | 2021-02-25 | Candler | Georgia | 13043 | 907 | 59 |
1063654 | 1063654 | 2021-02-25 | Carroll | Georgia | 13045 | 10498 | 210 |
1063655 | 1063655 | 2021-02-25 | Catoosa | Georgia | 13047 | 5605 | 63 |
1063656 | 1063656 | 2021-02-25 | Charlton | Georgia | 13049 | 1306 | 27 |
1063657 | 1063657 | 2021-02-25 | Chatham | Georgia | 13051 | 20705 | 367 |
1063658 | 1063658 | 2021-02-25 | Chattahoochee | Georgia | 13053 | 3054 | 11 |
1063659 | 1063659 | 2021-02-25 | Chattooga | Georgia | 13055 | 2580 | 64 |
1063660 | 1063660 | 2021-02-25 | Cherokee | Georgia | 13057 | 27335 | 262 |
1063661 | 1063661 | 2021-02-25 | Clarke | Georgia | 13059 | 14042 | 118 |
1063662 | 1063662 | 2021-02-25 | Clay | Georgia | 13061 | 229 | 3 |
1063663 | 1063663 | 2021-02-25 | Clayton | Georgia | 13063 | 23050 | 385 |
1063664 | 1063664 | 2021-02-25 | Clinch | Georgia | 13065 | 908 | 23 |
1063665 | 1063665 | 2021-02-25 | Cobb | Georgia | 13067 | 69152 | 902 |
1063666 | 1063666 | 2021-02-25 | Coffee | Georgia | 13069 | 5200 | 150 |
1063667 | 1063667 | 2021-02-25 | Colquitt | Georgia | 13071 | 4397 | 100 |
1063668 | 1063668 | 2021-02-25 | Columbia | Georgia | 13073 | 15637 | 185 |
1063669 | 1063669 | 2021-02-25 | Cook | Georgia | 13075 | 1695 | 39 |
1063670 | 1063670 | 2021-02-25 | Coweta | Georgia | 13077 | 12749 | 160 |
1063671 | 1063671 | 2021-02-25 | Crawford | Georgia | 13079 | 619 | 16 |
1063672 | 1063672 | 2021-02-25 | Crisp | Georgia | 13081 | 1912 | 60 |
1063673 | 1063673 | 2021-02-25 | Dade | Georgia | 13083 | 1281 | 10 |
1063674 | 1063674 | 2021-02-25 | Dawson | Georgia | 13085 | 2821 | 35 |
1063675 | 1063675 | 2021-02-25 | DeKalb | Georgia | 13089 | 56776 | 819 |
1063676 | 1063676 | 2021-02-25 | Decatur | Georgia | 13087 | 2742 | 65 |
1063677 | 1063677 | 2021-02-25 | Dodge | Georgia | 13091 | 2093 | 98 |
1063678 | 1063678 | 2021-02-25 | Dooly | Georgia | 13093 | 984 | 40 |
1063679 | 1063679 | 2021-02-25 | Dougherty | Georgia | 13095 | 7069 | 279 |
1063680 | 1063680 | 2021-02-25 | Douglas | Georgia | 13097 | 13325 | 179 |
1063681 | 1063681 | 2021-02-25 | Early | Georgia | 13099 | 1120 | 44 |
1063682 | 1063682 | 2021-02-25 | Echols | Georgia | 13101 | 454 | 6 |
1063683 | 1063683 | 2021-02-25 | Effingham | Georgia | 13103 | 4170 | 60 |
1063684 | 1063684 | 2021-02-25 | Elbert | Georgia | 13105 | 2210 | 60 |
1063685 | 1063685 | 2021-02-25 | Emanuel | Georgia | 13107 | 2451 | 78 |
1063686 | 1063686 | 2021-02-25 | Evans | Georgia | 13109 | 902 | 22 |
1063687 | 1063687 | 2021-02-25 | Fannin | Georgia | 13111 | 2178 | 60 |
1063688 | 1063688 | 2021-02-25 | Fayette | Georgia | 13113 | 7873 | 141 |
1063689 | 1063689 | 2021-02-25 | Floyd | Georgia | 13115 | 10971 | 195 |
1063690 | 1063690 | 2021-02-25 | Forsyth | Georgia | 13117 | 19846 | 148 |
1063691 | 1063691 | 2021-02-25 | Franklin | Georgia | 13119 | 2556 | 42 |
1063692 | 1063692 | 2021-02-25 | Fulton | Georgia | 13121 | 84805 | 1119 |
1063693 | 1063693 | 2021-02-25 | Gilmer | Georgia | 13123 | 2772 | 74 |
1063694 | 1063694 | 2021-02-25 | Glascock | Georgia | 13125 | 256 | 16 |
1063695 | 1063695 | 2021-02-25 | Glynn | Georgia | 13127 | 7534 | 160 |
1063696 | 1063696 | 2021-02-25 | Gordon | Georgia | 13129 | 7465 | 101 |
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);