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 139,900
- Georgia 90,969
- Virginia 75,059
- Kentucky 67,132
- Missouri 64,913
- Illinois 57,666
- Kansas 56,998
- North Carolina 56,709
- Iowa 55,870
- Tennessee 54,463
- Indiana 52,382
- Ohio 50,322
- Nebraska 49,421
- Minnesota 49,315
- Michigan 47,462
- Mississippi 46,788
- Oklahoma 43,465
- Arkansas 42,920
- Puerto Rico 41,728
- Wisconsin 40,801
- Florida 38,946
- Pennsylvania 38,304
- Alabama 38,108
- Louisiana 37,122
- Colorado 35,959
- South Dakota 35,626
- New York 33,454
- California 33,396
- West Virginia 30,633
- North Dakota 29,105
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814625 | 1814625 | 2021-10-14 | Chippewa | Michigan | 26033 | 6676 | 58 |
1814626 | 1814626 | 2021-10-14 | Clare | Michigan | 26035 | 3478 | 96 |
1814627 | 1814627 | 2021-10-14 | Clinton | Michigan | 26037 | 9561 | 103 |
1814628 | 1814628 | 2021-10-14 | Crawford | Michigan | 26039 | 1230 | 16 |
1814629 | 1814629 | 2021-10-14 | Delta | Michigan | 26041 | 5492 | 103 |
1814630 | 1814630 | 2021-10-14 | Dickinson | Michigan | 26043 | 3807 | 80 |
1814631 | 1814631 | 2021-10-14 | Eaton | Michigan | 26045 | 12605 | 234 |
1814632 | 1814632 | 2021-10-14 | Emmet | Michigan | 26047 | 3242 | 49 |
1814633 | 1814633 | 2021-10-14 | Genesee | Michigan | 26049 | 49645 | 1055 |
1814634 | 1814634 | 2021-10-14 | Gladwin | Michigan | 26051 | 3085 | 68 |
1814635 | 1814635 | 2021-10-14 | Gogebic | Michigan | 26053 | 1754 | 53 |
1814636 | 1814636 | 2021-10-14 | Grand Traverse | Michigan | 26055 | 8455 | 117 |
1814637 | 1814637 | 2021-10-14 | Gratiot | Michigan | 26057 | 8257 | 129 |
1814638 | 1814638 | 2021-10-14 | Hillsdale | Michigan | 26059 | 5871 | 116 |
1814639 | 1814639 | 2021-10-14 | Houghton | Michigan | 26061 | 3776 | 54 |
1814640 | 1814640 | 2021-10-14 | Huron | Michigan | 26063 | 4620 | 89 |
1814641 | 1814641 | 2021-10-14 | Ingham | Michigan | 26065 | 29858 | 441 |
1814642 | 1814642 | 2021-10-14 | Ionia | Michigan | 26067 | 11306 | 95 |
1814643 | 1814643 | 2021-10-14 | Iosco | Michigan | 26069 | 2768 | 90 |
1814644 | 1814644 | 2021-10-14 | Iron | Michigan | 26071 | 1362 | 54 |
1814645 | 1814645 | 2021-10-14 | Isabella | Michigan | 26073 | 8449 | 109 |
1814646 | 1814646 | 2021-10-14 | Jackson | Michigan | 26075 | 24791 | 351 |
1814647 | 1814647 | 2021-10-14 | Kalamazoo | Michigan | 26077 | 28528 | 441 |
1814648 | 1814648 | 2021-10-14 | Kalkaska | Michigan | 26079 | 1664 | 35 |
1814649 | 1814649 | 2021-10-14 | Kent | Michigan | 26081 | 89258 | 959 |
1814650 | 1814650 | 2021-10-14 | Keweenaw | Michigan | 26083 | 233 | 4 |
1814651 | 1814651 | 2021-10-14 | Lake | Michigan | 26085 | 901 | 20 |
1814652 | 1814652 | 2021-10-14 | Lapeer | Michigan | 26087 | 11626 | 244 |
1814653 | 1814653 | 2021-10-14 | Leelanau | Michigan | 26089 | 1567 | 24 |
1814654 | 1814654 | 2021-10-14 | Lenawee | Michigan | 26091 | 13763 | 197 |
1814655 | 1814655 | 2021-10-14 | Livingston | Michigan | 26093 | 21878 | 229 |
1814656 | 1814656 | 2021-10-14 | Luce | Michigan | 26095 | 1535 | 6 |
1814657 | 1814657 | 2021-10-14 | Mackinac | Michigan | 26097 | 1187 | 7 |
1814658 | 1814658 | 2021-10-14 | Macomb | Michigan | 26099 | 117513 | 2639 |
1814659 | 1814659 | 2021-10-14 | Manistee | Michigan | 26101 | 2393 | 34 |
1814660 | 1814660 | 2021-10-14 | Marquette | Michigan | 26103 | 7601 | 74 |
1814661 | 1814661 | 2021-10-14 | Mason | Michigan | 26105 | 2942 | 45 |
1814662 | 1814662 | 2021-10-14 | Mecosta | Michigan | 26107 | 4371 | 41 |
1814663 | 1814663 | 2021-10-14 | Menominee | Michigan | 26109 | 3168 | 48 |
1814664 | 1814664 | 2021-10-14 | Midland | Michigan | 26111 | 9756 | 126 |
1814665 | 1814665 | 2021-10-14 | Missaukee | Michigan | 26113 | 1780 | 32 |
1814666 | 1814666 | 2021-10-14 | Monroe | Michigan | 26115 | 19394 | 294 |
1814667 | 1814667 | 2021-10-14 | Montcalm | Michigan | 26117 | 10149 | 128 |
1814668 | 1814668 | 2021-10-14 | Montmorency | Michigan | 26119 | 848 | 24 |
1814669 | 1814669 | 2021-10-14 | Muskegon | Michigan | 26121 | 22441 | 417 |
1814670 | 1814670 | 2021-10-14 | Newaygo | Michigan | 26123 | 6243 | 79 |
1814671 | 1814671 | 2021-10-14 | Oakland | Michigan | 26125 | 140924 | 2628 |
1814672 | 1814672 | 2021-10-14 | Oceana | Michigan | 26127 | 3537 | 67 |
1814673 | 1814673 | 2021-10-14 | Ogemaw | Michigan | 26129 | 2548 | 52 |
1814674 | 1814674 | 2021-10-14 | Ontonagon | Michigan | 26131 | 590 | 22 |
1814675 | 1814675 | 2021-10-14 | Osceola | Michigan | 26133 | 2764 | 34 |
1814676 | 1814676 | 2021-10-14 | Oscoda | Michigan | 26135 | 889 | 33 |
1814677 | 1814677 | 2021-10-14 | Otsego | Michigan | 26137 | 3103 | 51 |
1814678 | 1814678 | 2021-10-14 | Ottawa | Michigan | 26139 | 39679 | 488 |
1814679 | 1814679 | 2021-10-14 | Presque Isle | Michigan | 26141 | 1302 | 36 |
1814680 | 1814680 | 2021-10-14 | Roscommon | Michigan | 26143 | 2305 | 61 |
1814681 | 1814681 | 2021-10-14 | Saginaw | Michigan | 26145 | 27186 | 667 |
1814682 | 1814682 | 2021-10-14 | Sanilac | Michigan | 26151 | 4791 | 131 |
1814683 | 1814683 | 2021-10-14 | Schoolcraft | Michigan | 26153 | 735 | 5 |
1814684 | 1814684 | 2021-10-14 | Shiawassee | Michigan | 26155 | 8238 | 124 |
1814685 | 1814685 | 2021-10-14 | St. Clair | Michigan | 26147 | 21579 | 503 |
1814686 | 1814686 | 2021-10-14 | St. Joseph | Michigan | 26149 | 7993 | 115 |
1814687 | 1814687 | 2021-10-14 | Tuscola | Michigan | 26157 | 7053 | 188 |
1814688 | 1814688 | 2021-10-14 | Unknown | Michigan | 802 | 12 | |
1814689 | 1814689 | 2021-10-14 | Van Buren | Michigan | 26159 | 8867 | 156 |
1814690 | 1814690 | 2021-10-14 | Washtenaw | Michigan | 26161 | 32829 | 330 |
1814691 | 1814691 | 2021-10-14 | Wayne | Michigan | 26163 | 192783 | 5494 |
1814692 | 1814692 | 2021-10-14 | Wexford | Michigan | 26165 | 3433 | 51 |
1814693 | 1814693 | 2021-10-14 | Aitkin | Minnesota | 27001 | 1766 | 42 |
1814694 | 1814694 | 2021-10-14 | Anoka | Minnesota | 27003 | 52797 | 511 |
1814695 | 1814695 | 2021-10-14 | Becker | Minnesota | 27005 | 5153 | 62 |
1814696 | 1814696 | 2021-10-14 | Beltrami | Minnesota | 27007 | 6269 | 76 |
1814697 | 1814697 | 2021-10-14 | Benton | Minnesota | 27009 | 7332 | 105 |
1814698 | 1814698 | 2021-10-14 | Big Stone | Minnesota | 27011 | 783 | 4 |
1814699 | 1814699 | 2021-10-14 | Blue Earth | Minnesota | 27013 | 9463 | 59 |
1814700 | 1814700 | 2021-10-14 | Brown | Minnesota | 27015 | 3957 | 45 |
1814701 | 1814701 | 2021-10-14 | Carlton | Minnesota | 27017 | 4356 | 65 |
1814702 | 1814702 | 2021-10-14 | Carver | Minnesota | 27019 | 13318 | 54 |
1814703 | 1814703 | 2021-10-14 | Cass | Minnesota | 27021 | 4082 | 42 |
1814704 | 1814704 | 2021-10-14 | Chippewa | Minnesota | 27023 | 1837 | 39 |
1814705 | 1814705 | 2021-10-14 | Chisago | Minnesota | 27025 | 8115 | 61 |
1814706 | 1814706 | 2021-10-14 | Clay | Minnesota | 27027 | 10010 | 98 |
1814707 | 1814707 | 2021-10-14 | Clearwater | Minnesota | 27029 | 1325 | 18 |
1814708 | 1814708 | 2021-10-14 | Cook | Minnesota | 27031 | 240 | 0 |
1814709 | 1814709 | 2021-10-14 | Cottonwood | Minnesota | 27033 | 1921 | 27 |
1814710 | 1814710 | 2021-10-14 | Crow Wing | Minnesota | 27035 | 9180 | 105 |
1814711 | 1814711 | 2021-10-14 | Dakota | Minnesota | 27037 | 55936 | 519 |
1814712 | 1814712 | 2021-10-14 | Dodge | Minnesota | 27039 | 2667 | 9 |
1814713 | 1814713 | 2021-10-14 | Douglas | Minnesota | 27041 | 6122 | 88 |
1814714 | 1814714 | 2021-10-14 | Faribault | Minnesota | 27043 | 2133 | 30 |
1814715 | 1814715 | 2021-10-14 | Fillmore | Minnesota | 27045 | 2326 | 12 |
1814716 | 1814716 | 2021-10-14 | Freeborn | Minnesota | 27047 | 4792 | 42 |
1814717 | 1814717 | 2021-10-14 | Goodhue | Minnesota | 27049 | 5993 | 82 |
1814718 | 1814718 | 2021-10-14 | Grant | Minnesota | 27051 | 760 | 9 |
1814719 | 1814719 | 2021-10-14 | Hennepin | Minnesota | 27053 | 150856 | 1900 |
1814720 | 1814720 | 2021-10-14 | Houston | Minnesota | 27055 | 2276 | 17 |
1814721 | 1814721 | 2021-10-14 | Hubbard | Minnesota | 27057 | 2814 | 44 |
1814722 | 1814722 | 2021-10-14 | Isanti | Minnesota | 27059 | 5544 | 72 |
1814723 | 1814723 | 2021-10-14 | Itasca | Minnesota | 27061 | 5925 | 78 |
1814724 | 1814724 | 2021-10-14 | Jackson | Minnesota | 27063 | 1436 | 14 |
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);