⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,095,698 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
1053606 2021-02-22 Greenlee Arizona 4011 552 8
1053607 2021-02-22 La Paz Arizona 4012 2379 69
1053608 2021-02-22 Maricopa Arizona 4013 506046 8833
1053609 2021-02-22 Mohave Arizona 4015 20931 625
1053610 2021-02-22 Navajo Arizona 4017 15477 478
1053611 2021-02-22 Pima Arizona 4019 108479 2149
1053612 2021-02-22 Pinal Arizona 4021 45535 742
1053613 2021-02-22 Santa Cruz Arizona 4023 7611 166
1053614 2021-02-22 Yavapai Arizona 4025 17348 448
1053615 2021-02-22 Yuma Arizona 4027 36310 770
1053616 2021-02-22 Arkansas Arkansas 5001 1944 38
1053617 2021-02-22 Ashley Arkansas 5003 1744 33
1053618 2021-02-22 Baxter Arkansas 5005 2786 96
1053619 2021-02-22 Benton Arkansas 5007 26736 385
1053620 2021-02-22 Boone Arkansas 5009 3584 78
1053621 2021-02-22 Bradley Arkansas 5011 1317 31
1053622 2021-02-22 Calhoun Arkansas 5013 387 3
1053623 2021-02-22 Carroll Arkansas 5015 2710 41
1053624 2021-02-22 Chicot Arkansas 5017 1584 40
1053625 2021-02-22 Clark Arkansas 5019 1993 37
1053626 2021-02-22 Clay Arkansas 5021 1665 46
1053627 2021-02-22 Cleburne Arkansas 5023 1864 67
1053628 2021-02-22 Cleveland Arkansas 5025 910 23
1053629 2021-02-22 Columbia Arkansas 5027 2110 53
1053630 2021-02-22 Conway Arkansas 5029 2133 31
1053631 2021-02-22 Craighead Arkansas 5031 12691 177
1053632 2021-02-22 Crawford Arkansas 5033 6698 104
1053633 2021-02-22 Crittenden Arkansas 5035 5629 94
1053634 2021-02-22 Cross Arkansas 5037 1892 48
1053635 2021-02-22 Dallas Arkansas 5039 713 12
1053636 2021-02-22 Desha Arkansas 5041 1305 21
1053637 2021-02-22 Drew Arkansas 5043 1943 35
1053638 2021-02-22 Faulkner Arkansas 5045 11575 150
1053639 2021-02-22 Franklin Arkansas 5047 1609 33
1053640 2021-02-22 Fulton Arkansas 5049 1059 44
1053641 2021-02-22 Garland Arkansas 5051 9497 231
1053642 2021-02-22 Grant Arkansas 5053 1540 32
1053643 2021-02-22 Greene Arkansas 5055 5770 74
1053644 2021-02-22 Hempstead Arkansas 5057 1796 18
1053645 2021-02-22 Hot Spring Arkansas 5059 4715 68
1053646 2021-02-22 Howard Arkansas 5061 1506 24
1053647 2021-02-22 Independence Arkansas 5063 3645 120
1053648 2021-02-22 Izard Arkansas 5065 1640 39
1053649 2021-02-22 Jackson Arkansas 5067 3129 33
1053650 2021-02-22 Jefferson Arkansas 5069 8532 164
1053651 2021-02-22 Johnson Arkansas 5071 2691 31
1053652 2021-02-22 Lafayette Arkansas 5073 493 7
1053653 2021-02-22 Lawrence Arkansas 5075 1995 41
1053654 2021-02-22 Lee Arkansas 5077 1632 35
1053655 2021-02-22 Lincoln Arkansas 5079 3130 42
1053656 2021-02-22 Little River Arkansas 5081 1117 40
1053657 2021-02-22 Logan Arkansas 5083 2158 18
1053658 2021-02-22 Lonoke Arkansas 5085 6672 108
1053659 2021-02-22 Madison Arkansas 5087 1397 21
1053660 2021-02-22 Marion Arkansas 5089 927 30
1053661 2021-02-22 Miller Arkansas 5091 3737 33
1053662 2021-02-22 Mississippi Arkansas 5093 5516 112
1053663 2021-02-22 Monroe Arkansas 5095 822 17
1053664 2021-02-22 Montgomery Arkansas 5097 721 29
1053665 2021-02-22 Nevada Arkansas 5099 767 24
1053666 2021-02-22 Newton Arkansas 5101 685 26
1053667 2021-02-22 Ouachita Arkansas 5103 2133 50
1053668 2021-02-22 Perry Arkansas 5105 793 8
1053669 2021-02-22 Phillips Arkansas 5107 1673 34
1053670 2021-02-22 Pike Arkansas 5109 948 22
1053671 2021-02-22 Poinsett Arkansas 5111 3054 75
1053672 2021-02-22 Polk Arkansas 5113 1859 62
1053673 2021-02-22 Pope Arkansas 5115 7636 101
1053674 2021-02-22 Prairie Arkansas 5117 858 24
1053675 2021-02-22 Pulaski Arkansas 5119 36737 576
1053676 2021-02-22 Randolph Arkansas 5121 1926 49
1053677 2021-02-22 Saline Arkansas 5125 11261 163
1053678 2021-02-22 Scott Arkansas 5127 925 14
1053679 2021-02-22 Searcy Arkansas 5129 641 15
1053680 2021-02-22 Sebastian Arkansas 5131 14416 258
1053681 2021-02-22 Sevier Arkansas 5133 2571 28
1053682 2021-02-22 Sharp Arkansas 5135 1513 50
1053683 2021-02-22 St. Francis Arkansas 5123 3417 37
1053684 2021-02-22 Stone Arkansas 5137 950 30
1053685 2021-02-22 Union Arkansas 5139 3613 102
1053686 2021-02-22 Unknown Arkansas   2777 0
1053687 2021-02-22 Van Buren Arkansas 5141 1154 17
1053688 2021-02-22 Washington Arkansas 5143 29089 329
1053689 2021-02-22 White Arkansas 5145 7077 105
1053690 2021-02-22 Woodruff Arkansas 5147 614 10
1053691 2021-02-22 Yell Arkansas 5149 3313 67
1053692 2021-02-22 Alameda California 6001 79670 1200
1053693 2021-02-22 Alpine California 6003 77 0
1053694 2021-02-22 Amador California 6005 3434 39
1053695 2021-02-22 Butte California 6007 10855 158
1053696 2021-02-22 Calaveras California 6009 1860 25
1053697 2021-02-22 Colusa California 6011 2120 13
1053698 2021-02-22 Contra Costa California 6013 61744 654
1053699 2021-02-22 Del Norte California 6015 971 5
1053700 2021-02-22 El Dorado California 6017 8927 93
1053701 2021-02-22 Fresno California 6019 94374 1367
1053702 2021-02-22 Glenn California 6021 2201 23
1053703 2021-02-22 Humboldt California 6023 3124 32
1053704 2021-02-22 Imperial California 6025 26840 583
1053705 2021-02-22 Inyo California 6027 1232 34

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);