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 31,136
- Georgia 22,489
- Virginia 18,000
- Kentucky 15,772
- Missouri 14,719
- North Carolina 13,808
- Illinois 13,666
- Tennessee 13,299
- Iowa 13,071
- Indiana 13,006
- Ohio 12,346
- Kansas 11,888
- Mississippi 11,609
- Minnesota 11,563
- Michigan 11,442
- Arkansas 10,316
- Oklahoma 10,007
- Florida 9,842
- Wisconsin 9,841
- Pennsylvania 9,561
- Nebraska 9,467
- Alabama 9,365
- Louisiana 9,303
- Colorado 8,607
- New York 8,572
- California 8,507
- Puerto Rico 7,837
- South Dakota 7,311
- West Virginia 7,036
- South Carolina 6,650
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
421587 | 421587 | 2020-08-11 | Archuleta | Colorado | 8007 | 36 | 0 |
421588 | 421588 | 2020-08-11 | Baca | Colorado | 8009 | 15 | 0 |
421589 | 421589 | 2020-08-11 | Bent | Colorado | 8011 | 9 | 0 |
421590 | 421590 | 2020-08-11 | Boulder | Colorado | 8013 | 2105 | 76 |
421591 | 421591 | 2020-08-11 | Broomfield | Colorado | 8014 | 482 | 32 |
421592 | 421592 | 2020-08-11 | Chaffee | Colorado | 8015 | 304 | 19 |
421593 | 421593 | 2020-08-11 | Cheyenne | Colorado | 8017 | 9 | 0 |
421594 | 421594 | 2020-08-11 | Clear Creek | Colorado | 8019 | 30 | 1 |
421595 | 421595 | 2020-08-11 | Conejos | Colorado | 8021 | 23 | 0 |
421596 | 421596 | 2020-08-11 | Costilla | Colorado | 8023 | 23 | 0 |
421597 | 421597 | 2020-08-11 | Crowley | Colorado | 8025 | 72 | 1 |
421598 | 421598 | 2020-08-11 | Custer | Colorado | 8027 | 11 | 0 |
421599 | 421599 | 2020-08-11 | Delta | Colorado | 8029 | 128 | 1 |
421600 | 421600 | 2020-08-11 | Denver | Colorado | 8031 | 10319 | 419 |
421601 | 421601 | 2020-08-11 | Dolores | Colorado | 8033 | 1 | 0 |
421602 | 421602 | 2020-08-11 | Douglas | Colorado | 8035 | 1759 | 59 |
421603 | 421603 | 2020-08-11 | Eagle | Colorado | 8037 | 1126 | 9 |
421604 | 421604 | 2020-08-11 | El Paso | Colorado | 8041 | 5228 | 141 |
421605 | 421605 | 2020-08-11 | Elbert | Colorado | 8039 | 107 | 2 |
421606 | 421606 | 2020-08-11 | Fremont | Colorado | 8043 | 128 | 0 |
421607 | 421607 | 2020-08-11 | Garfield | Colorado | 8045 | 773 | 4 |
421608 | 421608 | 2020-08-11 | Gilpin | Colorado | 8047 | 16 | 0 |
421609 | 421609 | 2020-08-11 | Grand | Colorado | 8049 | 51 | 1 |
421610 | 421610 | 2020-08-11 | Gunnison | Colorado | 8051 | 274 | 7 |
421611 | 421611 | 2020-08-11 | Hinsdale | Colorado | 8053 | 3 | 0 |
421612 | 421612 | 2020-08-11 | Huerfano | Colorado | 8055 | 8 | 1 |
421613 | 421613 | 2020-08-11 | Jackson | Colorado | 8057 | 9 | 0 |
421614 | 421614 | 2020-08-11 | Jefferson | Colorado | 8059 | 4258 | 233 |
421615 | 421615 | 2020-08-11 | Kit Carson | Colorado | 8063 | 56 | 3 |
421616 | 421616 | 2020-08-11 | La Plata | Colorado | 8067 | 222 | 2 |
421617 | 421617 | 2020-08-11 | Lake | Colorado | 8065 | 79 | 0 |
421618 | 421618 | 2020-08-11 | Larimer | Colorado | 8069 | 1590 | 37 |
421619 | 421619 | 2020-08-11 | Las Animas | Colorado | 8071 | 18 | 0 |
421620 | 421620 | 2020-08-11 | Lincoln | Colorado | 8073 | 8 | 0 |
421621 | 421621 | 2020-08-11 | Logan | Colorado | 8075 | 655 | 5 |
421622 | 421622 | 2020-08-11 | Mesa | Colorado | 8077 | 329 | 4 |
421623 | 421623 | 2020-08-11 | Mineral | Colorado | 8079 | 18 | 0 |
421624 | 421624 | 2020-08-11 | Moffat | Colorado | 8081 | 32 | 1 |
421625 | 421625 | 2020-08-11 | Montezuma | Colorado | 8083 | 112 | 4 |
421626 | 421626 | 2020-08-11 | Montrose | Colorado | 8085 | 312 | 13 |
421627 | 421627 | 2020-08-11 | Morgan | Colorado | 8087 | 687 | 46 |
421628 | 421628 | 2020-08-11 | Otero | Colorado | 8089 | 76 | 6 |
421629 | 421629 | 2020-08-11 | Ouray | Colorado | 8091 | 13 | 1 |
421630 | 421630 | 2020-08-11 | Park | Colorado | 8093 | 42 | 1 |
421631 | 421631 | 2020-08-11 | Phillips | Colorado | 8095 | 19 | 0 |
421632 | 421632 | 2020-08-11 | Pitkin | Colorado | 8097 | 188 | 2 |
421633 | 421633 | 2020-08-11 | Prowers | Colorado | 8099 | 54 | 0 |
421634 | 421634 | 2020-08-11 | Pueblo | Colorado | 8101 | 709 | 34 |
421635 | 421635 | 2020-08-11 | Rio Blanco | Colorado | 8103 | 20 | 0 |
421636 | 421636 | 2020-08-11 | Rio Grande | Colorado | 8105 | 89 | 2 |
421637 | 421637 | 2020-08-11 | Routt | Colorado | 8107 | 125 | 8 |
421638 | 421638 | 2020-08-11 | Saguache | Colorado | 8109 | 106 | 2 |
421639 | 421639 | 2020-08-11 | San Juan | Colorado | 8111 | 2 | 0 |
421640 | 421640 | 2020-08-11 | San Miguel | Colorado | 8113 | 90 | 0 |
421641 | 421641 | 2020-08-11 | Sedgwick | Colorado | 8115 | 11 | 1 |
421642 | 421642 | 2020-08-11 | Summit | Colorado | 8117 | 338 | 4 |
421643 | 421643 | 2020-08-11 | Teller | Colorado | 8119 | 136 | 3 |
421644 | 421644 | 2020-08-11 | Washington | Colorado | 8121 | 49 | 0 |
421645 | 421645 | 2020-08-11 | Weld | Colorado | 8123 | 3743 | 145 |
421646 | 421646 | 2020-08-11 | Yuma | Colorado | 8125 | 63 | 0 |
421647 | 421647 | 2020-08-11 | Fairfield | Connecticut | 9001 | 18081 | 1409 |
421648 | 421648 | 2020-08-11 | Hartford | Connecticut | 9003 | 12826 | 1415 |
421649 | 421649 | 2020-08-11 | Litchfield | Connecticut | 9005 | 1618 | 138 |
421650 | 421650 | 2020-08-11 | Middlesex | Connecticut | 9007 | 1408 | 192 |
421651 | 421651 | 2020-08-11 | New Haven | Connecticut | 9009 | 13240 | 1106 |
421652 | 421652 | 2020-08-11 | New London | Connecticut | 9011 | 1467 | 103 |
421653 | 421653 | 2020-08-11 | Tolland | Connecticut | 9013 | 1056 | 66 |
421654 | 421654 | 2020-08-11 | Unknown | Connecticut | 243 | 0 | |
421655 | 421655 | 2020-08-11 | Windham | Connecticut | 9015 | 745 | 15 |
421656 | 421656 | 2020-08-11 | Kent | Delaware | 10001 | 2306 | 108 |
421657 | 421657 | 2020-08-11 | New Castle | Delaware | 10003 | 7276 | 291 |
421658 | 421658 | 2020-08-11 | Sussex | Delaware | 10005 | 5867 | 192 |
421659 | 421659 | 2020-08-11 | Unknown | Delaware | 250 | 0 | |
421660 | 421660 | 2020-08-11 | District of Columbia | District of Columbia | 11001 | 12896 | 593 |
421661 | 421661 | 2020-08-11 | Alachua | Florida | 12001 | 4246 | 26 |
421662 | 421662 | 2020-08-11 | Baker | Florida | 12003 | 964 | 4 |
421663 | 421663 | 2020-08-11 | Bay | Florida | 12005 | 4523 | 52 |
421664 | 421664 | 2020-08-11 | Bradford | Florida | 12007 | 519 | 4 |
421665 | 421665 | 2020-08-11 | Brevard | Florida | 12009 | 6190 | 157 |
421666 | 421666 | 2020-08-11 | Broward | Florida | 12011 | 63605 | 856 |
421667 | 421667 | 2020-08-11 | Calhoun | Florida | 12013 | 481 | 8 |
421668 | 421668 | 2020-08-11 | Charlotte | Florida | 12015 | 2281 | 94 |
421669 | 421669 | 2020-08-11 | Citrus | Florida | 12017 | 1594 | 37 |
421670 | 421670 | 2020-08-11 | Clay | Florida | 12019 | 3327 | 52 |
421671 | 421671 | 2020-08-11 | Collier | Florida | 12021 | 10487 | 143 |
421672 | 421672 | 2020-08-11 | Columbia | Florida | 12023 | 2917 | 16 |
421673 | 421673 | 2020-08-11 | DeSoto | Florida | 12027 | 1377 | 18 |
421674 | 421674 | 2020-08-11 | Dixie | Florida | 12029 | 562 | 4 |
421675 | 421675 | 2020-08-11 | Duval | Florida | 12031 | 23741 | 198 |
421676 | 421676 | 2020-08-11 | Escambia | Florida | 12033 | 9807 | 131 |
421677 | 421677 | 2020-08-11 | Flagler | Florida | 12035 | 1095 | 13 |
421678 | 421678 | 2020-08-11 | Franklin | Florida | 12037 | 433 | 2 |
421679 | 421679 | 2020-08-11 | Gadsden | Florida | 12039 | 1927 | 21 |
421680 | 421680 | 2020-08-11 | Gilchrist | Florida | 12041 | 369 | 6 |
421681 | 421681 | 2020-08-11 | Glades | Florida | 12043 | 406 | 3 |
421682 | 421682 | 2020-08-11 | Gulf | Florida | 12045 | 685 | 2 |
421683 | 421683 | 2020-08-11 | Hamilton | Florida | 12047 | 623 | 4 |
421684 | 421684 | 2020-08-11 | Hardee | Florida | 12049 | 986 | 7 |
421685 | 421685 | 2020-08-11 | Hendry | Florida | 12051 | 1805 | 38 |
421686 | 421686 | 2020-08-11 | Hernando | Florida | 12053 | 2069 | 50 |
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);