⚠️ 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

946,480 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
920618 2021-01-12 Greenlee Arizona 4011 464 4
920619 2021-01-12 La Paz Arizona 4012 1885 41
920620 2021-01-12 Maricopa Arizona 4013 396147 6067
920621 2021-01-12 Mohave Arizona 4015 15790 404
920622 2021-01-12 Navajo Arizona 4017 12854 377
920623 2021-01-12 Pima Arizona 4019 84426 1311
920624 2021-01-12 Pinal Arizona 4021 34653 447
920625 2021-01-12 Santa Cruz Arizona 4023 6790 121
920626 2021-01-12 Yavapai Arizona 4025 14079 292
920627 2021-01-12 Yuma Arizona 4027 31658 591
920628 2021-01-12 Arkansas Arkansas 5001 1474 33
920629 2021-01-12 Ashley Arkansas 5003 1415 23
920630 2021-01-12 Baxter Arkansas 5005 2378 81
920631 2021-01-12 Benton Arkansas 5007 22024 299
920632 2021-01-12 Boone Arkansas 5009 2878 71
920633 2021-01-12 Bradley Arkansas 5011 1092 20
920634 2021-01-12 Calhoun Arkansas 5013 271 1
920635 2021-01-12 Carroll Arkansas 5015 2310 33
920636 2021-01-12 Chicot Arkansas 5017 1476 33
920637 2021-01-12 Clark Arkansas 5019 1552 27
920638 2021-01-12 Clay Arkansas 5021 1437 36
920639 2021-01-12 Cleburne Arkansas 5023 1522 44
920640 2021-01-12 Cleveland Arkansas 5025 638 22
920641 2021-01-12 Columbia Arkansas 5027 1724 45
920642 2021-01-12 Conway Arkansas 5029 1672 19
920643 2021-01-12 Craighead Arkansas 5031 11169 146
920644 2021-01-12 Crawford Arkansas 5033 5320 69
920645 2021-01-12 Crittenden Arkansas 5035 4832 79
920646 2021-01-12 Cross Arkansas 5037 1618 38
920647 2021-01-12 Dallas Arkansas 5039 557 12
920648 2021-01-12 Desha Arkansas 5041 1048 14
920649 2021-01-12 Drew Arkansas 5043 1626 24
920650 2021-01-12 Faulkner Arkansas 5045 9104 109
920651 2021-01-12 Franklin Arkansas 5047 1292 26
920652 2021-01-12 Fulton Arkansas 5049 980 38
920653 2021-01-12 Garland Arkansas 5051 7106 172
920654 2021-01-12 Grant Arkansas 5053 1219 19
920655 2021-01-12 Greene Arkansas 5055 4923 59
920656 2021-01-12 Hempstead Arkansas 5057 1387 11
920657 2021-01-12 Hot Spring Arkansas 5059 3968 59
920658 2021-01-12 Howard Arkansas 5061 1206 18
920659 2021-01-12 Independence Arkansas 5063 3139 102
920660 2021-01-12 Izard Arkansas 5065 1442 25
920661 2021-01-12 Jackson Arkansas 5067 2962 27
920662 2021-01-12 Jefferson Arkansas 5069 7243 136
920663 2021-01-12 Johnson Arkansas 5071 2195 22
920664 2021-01-12 Lafayette Arkansas 5073 376 6
920665 2021-01-12 Lawrence Arkansas 5075 1753 39
920666 2021-01-12 Lee Arkansas 5077 1529 28
920667 2021-01-12 Lincoln Arkansas 5079 2910 29
920668 2021-01-12 Little River Arkansas 5081 913 39
920669 2021-01-12 Logan Arkansas 5083 1712 13
920670 2021-01-12 Lonoke Arkansas 5085 4971 90
920671 2021-01-12 Madison Arkansas 5087 1163 14
920672 2021-01-12 Marion Arkansas 5089 750 24
920673 2021-01-12 Miller Arkansas 5091 3023 25
920674 2021-01-12 Mississippi Arkansas 5093 4771 100
920675 2021-01-12 Monroe Arkansas 5095 569 9
920676 2021-01-12 Montgomery Arkansas 5097 597 21
920677 2021-01-12 Nevada Arkansas 5099 630 22
920678 2021-01-12 Newton Arkansas 5101 596 25
920679 2021-01-12 Ouachita Arkansas 5103 1622 35
920680 2021-01-12 Perry Arkansas 5105 561 5
920681 2021-01-12 Phillips Arkansas 5107 1422 27
920682 2021-01-12 Pike Arkansas 5109 791 15
920683 2021-01-12 Poinsett Arkansas 5111 2652 67
920684 2021-01-12 Polk Arkansas 5113 1452 49
920685 2021-01-12 Pope Arkansas 5115 6314 66
920686 2021-01-12 Prairie Arkansas 5117 616 17
920687 2021-01-12 Pulaski Arkansas 5119 28788 435
920688 2021-01-12 Randolph Arkansas 5121 1646 44
920689 2021-01-12 Saline Arkansas 5125 8913 122
920690 2021-01-12 Scott Arkansas 5127 743 14
920691 2021-01-12 Searcy Arkansas 5129 551 13
920692 2021-01-12 Sebastian Arkansas 5131 11733 169
920693 2021-01-12 Sevier Arkansas 5133 2204 23
920694 2021-01-12 Sharp Arkansas 5135 1328 37
920695 2021-01-12 St. Francis Arkansas 5123 3028 23
920696 2021-01-12 Stone Arkansas 5137 843 27
920697 2021-01-12 Union Arkansas 5139 2812 77
920698 2021-01-12 Unknown Arkansas   2705 0
920699 2021-01-12 Van Buren Arkansas 5141 897 10
920700 2021-01-12 Washington Arkansas 5143 24631 238
920701 2021-01-12 White Arkansas 5145 5649 75
920702 2021-01-12 Woodruff Arkansas 5147 453 4
920703 2021-01-12 Yell Arkansas 5149 2737 53
920704 2021-01-12 Alameda California 6001 62067 763
920705 2021-01-12 Alpine California 6003 70 0
920706 2021-01-12 Amador California 6005 2866 28
920707 2021-01-12 Butte California 6007 8795 112
920708 2021-01-12 Calaveras California 6009 1460 22
920709 2021-01-12 Colusa California 6011 1643 9
920710 2021-01-12 Contra Costa California 6013 48449 392
920711 2021-01-12 Del Norte California 6015 826 2
920712 2021-01-12 El Dorado California 6017 6987 33
920713 2021-01-12 Fresno California 6019 76581 838
920714 2021-01-12 Glenn California 6021 1763 18
920715 2021-01-12 Humboldt California 6023 2138 24
920716 2021-01-12 Imperial California 6025 24418 448
920717 2021-01-12 Inyo California 6027 763 27

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