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 57,604
- Georgia 39,289
- Virginia 31,965
- Kentucky 28,372
- Missouri 27,004
- Illinois 24,462
- North Carolina 24,308
- Iowa 23,570
- Tennessee 23,359
- Kansas 22,939
- Indiana 22,666
- Ohio 21,586
- Minnesota 20,803
- Michigan 20,262
- Mississippi 20,220
- Nebraska 19,142
- Arkansas 18,296
- Oklahoma 18,194
- Wisconsin 17,471
- Florida 16,982
- Pennsylvania 16,596
- Alabama 16,400
- Puerto Rico 16,132
- Louisiana 16,128
- Colorado 15,287
- New York 14,662
- California 14,612
- South Dakota 14,242
- West Virginia 12,811
- North Dakota 11,610
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761647 | 761647 | 2020-11-24 | Santa Cruz | California | 6087 | 4092 | 28 |
761648 | 761648 | 2020-11-24 | Shasta | California | 6089 | 4470 | 43 |
761649 | 761649 | 2020-11-24 | Sierra | California | 6091 | 15 | 0 |
761650 | 761650 | 2020-11-24 | Siskiyou | California | 6093 | 582 | 2 |
761651 | 761651 | 2020-11-24 | Solano | California | 6095 | 9929 | 81 |
761652 | 761652 | 2020-11-24 | Sonoma | California | 6097 | 11608 | 155 |
761653 | 761653 | 2020-11-24 | Stanislaus | California | 6099 | 22169 | 420 |
761654 | 761654 | 2020-11-24 | Sutter | California | 6101 | 3057 | 15 |
761655 | 761655 | 2020-11-24 | Tehama | California | 6103 | 1526 | 23 |
761656 | 761656 | 2020-11-24 | Trinity | California | 6105 | 121 | 0 |
761657 | 761657 | 2020-11-24 | Tulare | California | 6107 | 20352 | 305 |
761658 | 761658 | 2020-11-24 | Tuolumne | California | 6109 | 873 | 8 |
761659 | 761659 | 2020-11-24 | Ventura | California | 6111 | 18480 | 175 |
761660 | 761660 | 2020-11-24 | Yolo | California | 6113 | 4363 | 74 |
761661 | 761661 | 2020-11-24 | Yuba | California | 6115 | 1948 | 10 |
761662 | 761662 | 2020-11-24 | Adams | Colorado | 8001 | 26942 | 317 |
761663 | 761663 | 2020-11-24 | Alamosa | Colorado | 8003 | 526 | 12 |
761664 | 761664 | 2020-11-24 | Arapahoe | Colorado | 8005 | 24758 | 431 |
761665 | 761665 | 2020-11-24 | Archuleta | Colorado | 8007 | 167 | 0 |
761666 | 761666 | 2020-11-24 | Baca | Colorado | 8009 | 72 | 0 |
761667 | 761667 | 2020-11-24 | Bent | Colorado | 8011 | 79 | 1 |
761668 | 761668 | 2020-11-24 | Boulder | Colorado | 8013 | 10282 | 117 |
761669 | 761669 | 2020-11-24 | Broomfield | Colorado | 8014 | 1848 | 48 |
761670 | 761670 | 2020-11-24 | Chaffee | Colorado | 8015 | 590 | 21 |
761671 | 761671 | 2020-11-24 | Cheyenne | Colorado | 8017 | 51 | 0 |
761672 | 761672 | 2020-11-24 | Clear Creek | Colorado | 8019 | 172 | 2 |
761673 | 761673 | 2020-11-24 | Conejos | Colorado | 8021 | 154 | 3 |
761674 | 761674 | 2020-11-24 | Costilla | Colorado | 8023 | 69 | 1 |
761675 | 761675 | 2020-11-24 | Crowley | Colorado | 8025 | 1011 | 2 |
761676 | 761676 | 2020-11-24 | Custer | Colorado | 8027 | 59 | 0 |
761677 | 761677 | 2020-11-24 | Delta | Colorado | 8029 | 511 | 8 |
761678 | 761678 | 2020-11-24 | Denver | Colorado | 8031 | 33971 | 510 |
761679 | 761679 | 2020-11-24 | Dolores | Colorado | 8033 | 11 | 0 |
761680 | 761680 | 2020-11-24 | Douglas | Colorado | 8035 | 9593 | 98 |
761681 | 761681 | 2020-11-24 | Eagle | Colorado | 8037 | 2155 | 11 |
761682 | 761682 | 2020-11-24 | El Paso | Colorado | 8041 | 23923 | 258 |
761683 | 761683 | 2020-11-24 | Elbert | Colorado | 8039 | 534 | 5 |
761684 | 761684 | 2020-11-24 | Fremont | Colorado | 8043 | 2296 | 3 |
761685 | 761685 | 2020-11-24 | Garfield | Colorado | 8045 | 1974 | 6 |
761686 | 761686 | 2020-11-24 | Gilpin | Colorado | 8047 | 75 | 0 |
761687 | 761687 | 2020-11-24 | Grand | Colorado | 8049 | 333 | 1 |
761688 | 761688 | 2020-11-24 | Gunnison | Colorado | 8051 | 447 | 7 |
761689 | 761689 | 2020-11-24 | Hinsdale | Colorado | 8053 | 7 | 0 |
761690 | 761690 | 2020-11-24 | Huerfano | Colorado | 8055 | 121 | 4 |
761691 | 761691 | 2020-11-24 | Jackson | Colorado | 8057 | 18 | 0 |
761692 | 761692 | 2020-11-24 | Jefferson | Colorado | 8059 | 18369 | 425 |
761693 | 761693 | 2020-11-24 | Kiowa | Colorado | 8061 | 21 | 0 |
761694 | 761694 | 2020-11-24 | Kit Carson | Colorado | 8063 | 251 | 7 |
761695 | 761695 | 2020-11-24 | La Plata | Colorado | 8067 | 1039 | 3 |
761696 | 761696 | 2020-11-24 | Lake | Colorado | 8065 | 248 | 0 |
761697 | 761697 | 2020-11-24 | Larimer | Colorado | 8069 | 9029 | 67 |
761698 | 761698 | 2020-11-24 | Las Animas | Colorado | 8071 | 186 | 0 |
761699 | 761699 | 2020-11-24 | Lincoln | Colorado | 8073 | 117 | 0 |
761700 | 761700 | 2020-11-24 | Logan | Colorado | 8075 | 2042 | 29 |
761701 | 761701 | 2020-11-24 | Mesa | Colorado | 8077 | 5051 | 50 |
761702 | 761702 | 2020-11-24 | Mineral | Colorado | 8079 | 32 | 0 |
761703 | 761703 | 2020-11-24 | Moffat | Colorado | 8081 | 243 | 2 |
761704 | 761704 | 2020-11-24 | Montezuma | Colorado | 8083 | 609 | 6 |
761705 | 761705 | 2020-11-24 | Montrose | Colorado | 8085 | 868 | 15 |
761706 | 761706 | 2020-11-24 | Morgan | Colorado | 8087 | 1499 | 51 |
761707 | 761707 | 2020-11-24 | Otero | Colorado | 8089 | 458 | 9 |
761708 | 761708 | 2020-11-24 | Ouray | Colorado | 8091 | 113 | 2 |
761709 | 761709 | 2020-11-24 | Park | Colorado | 8093 | 205 | 4 |
761710 | 761710 | 2020-11-24 | Phillips | Colorado | 8095 | 164 | 2 |
761711 | 761711 | 2020-11-24 | Pitkin | Colorado | 8097 | 442 | 2 |
761712 | 761712 | 2020-11-24 | Prowers | Colorado | 8099 | 534 | 12 |
761713 | 761713 | 2020-11-24 | Pueblo | Colorado | 8101 | 7195 | 96 |
761714 | 761714 | 2020-11-24 | Rio Blanco | Colorado | 8103 | 109 | 1 |
761715 | 761715 | 2020-11-24 | Rio Grande | Colorado | 8105 | 205 | 4 |
761716 | 761716 | 2020-11-24 | Routt | Colorado | 8107 | 560 | 10 |
761717 | 761717 | 2020-11-24 | Saguache | Colorado | 8109 | 201 | 2 |
761718 | 761718 | 2020-11-24 | San Juan | Colorado | 8111 | 20 | 0 |
761719 | 761719 | 2020-11-24 | San Miguel | Colorado | 8113 | 186 | 0 |
761720 | 761720 | 2020-11-24 | Sedgwick | Colorado | 8115 | 97 | 1 |
761721 | 761721 | 2020-11-24 | Summit | Colorado | 8117 | 1366 | 4 |
761722 | 761722 | 2020-11-24 | Teller | Colorado | 8119 | 559 | 4 |
761723 | 761723 | 2020-11-24 | Washington | Colorado | 8121 | 199 | 5 |
761724 | 761724 | 2020-11-24 | Weld | Colorado | 8123 | 12611 | 188 |
761725 | 761725 | 2020-11-24 | Yuma | Colorado | 8125 | 305 | 1 |
761726 | 761726 | 2020-11-24 | Fairfield | Connecticut | 9001 | 35494 | 1478 |
761727 | 761727 | 2020-11-24 | Hartford | Connecticut | 9003 | 26555 | 1573 |
761728 | 761728 | 2020-11-24 | Litchfield | Connecticut | 9005 | 3908 | 160 |
761729 | 761729 | 2020-11-24 | Middlesex | Connecticut | 9007 | 3375 | 200 |
761730 | 761730 | 2020-11-24 | New Haven | Connecticut | 9009 | 26643 | 1207 |
761731 | 761731 | 2020-11-24 | New London | Connecticut | 9011 | 5648 | 163 |
761732 | 761732 | 2020-11-24 | Tolland | Connecticut | 9013 | 2850 | 72 |
761733 | 761733 | 2020-11-24 | Unknown | Connecticut | 465 | 0 | |
761734 | 761734 | 2020-11-24 | Windham | Connecticut | 9015 | 2342 | 28 |
761735 | 761735 | 2020-11-24 | Kent | Delaware | 10001 | 4562 | 125 |
761736 | 761736 | 2020-11-24 | New Castle | Delaware | 10003 | 18121 | 375 |
761737 | 761737 | 2020-11-24 | Sussex | Delaware | 10005 | 9876 | 257 |
761738 | 761738 | 2020-11-24 | Unknown | Delaware | 105 | 0 | |
761739 | 761739 | 2020-11-24 | District of Columbia | District of Columbia | 11001 | 20409 | 673 |
761740 | 761740 | 2020-11-24 | Alachua | Florida | 12001 | 12468 | 98 |
761741 | 761741 | 2020-11-24 | Baker | Florida | 12003 | 1979 | 31 |
761742 | 761742 | 2020-11-24 | Bay | Florida | 12005 | 8256 | 152 |
761743 | 761743 | 2020-11-24 | Bradford | Florida | 12007 | 1381 | 18 |
761744 | 761744 | 2020-11-24 | Brevard | Florida | 12009 | 14811 | 432 |
761745 | 761745 | 2020-11-24 | Broward | Florida | 12011 | 102638 | 1630 |
761746 | 761746 | 2020-11-24 | Calhoun | Florida | 12013 | 843 | 21 |
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);