ny_times_us_counties

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

2,502,832 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: county, fips

state >30

Link rowid date ▲ county state fips cases deaths
2499675 2499675 2022-05-13 Graham Arizona 4009 12051 177
2499676 2499676 2022-05-13 Greenlee Arizona 4011 2226 33
2499677 2499677 2022-05-13 La Paz Arizona 4012 5227 144
2499678 2499678 2022-05-13 Maricopa Arizona 4013 1283590 17326
2499679 2499679 2022-05-13 Mohave Arizona 4015 57631 1454
2499680 2499680 2022-05-13 Navajo Arizona 4017 38394 909
2499681 2499681 2022-05-13 Pima Arizona 4019 255688 3850
2499682 2499682 2022-05-13 Pinal Arizona 4021 132748 1666
2499683 2499683 2022-05-13 Santa Cruz Arizona 4023 16683 232
2499684 2499684 2022-05-13 Yavapai Arizona 4025 48293 1212
2499685 2499685 2022-05-13 Yuma Arizona 4027 62751 1181
2499686 2499686 2022-05-13 Arkansas Arkansas 5001 5696 79
2499687 2499687 2022-05-13 Ashley Arkansas 5003 5115 66
2499688 2499688 2022-05-13 Baxter Arkansas 5005 8848 247
2499689 2499689 2022-05-13 Benton Arkansas 5007 67110 849
2499690 2499690 2022-05-13 Boone Arkansas 5009 9468 179
2499691 2499691 2022-05-13 Bradley Arkansas 5011 2997 49
2499692 2499692 2022-05-13 Calhoun Arkansas 5013 965 10
2499693 2499693 2022-05-13 Carroll Arkansas 5015 6138 102
2499694 2499694 2022-05-13 Chicot Arkansas 5017 2778 60
2499695 2499695 2022-05-13 Clark Arkansas 5019 5379 79
2499696 2499696 2022-05-13 Clay Arkansas 5021 4154 93
2499697 2499697 2022-05-13 Cleburne Arkansas 5023 6466 128
2499698 2499698 2022-05-13 Cleveland Arkansas 5025 2269 36
2499699 2499699 2022-05-13 Columbia Arkansas 5027 5438 95
2499700 2499700 2022-05-13 Conway Arkansas 5029 5491 65
2499701 2499701 2022-05-13 Craighead Arkansas 5031 37767 329
2499702 2499702 2022-05-13 Crawford Arkansas 5033 15884 249
2499703 2499703 2022-05-13 Crittenden Arkansas 5035 14315 226
2499704 2499704 2022-05-13 Cross Arkansas 5037 4835 83
2499705 2499705 2022-05-13 Dallas Arkansas 5039 1747 31
2499706 2499706 2022-05-13 Desha Arkansas 5041 3030 41
2499707 2499707 2022-05-13 Drew Arkansas 5043 4686 70
2499708 2499708 2022-05-13 Faulkner Arkansas 5045 35251 316
2499709 2499709 2022-05-13 Franklin Arkansas 5047 3818 73
2499710 2499710 2022-05-13 Fulton Arkansas 5049 2696 90
2499711 2499711 2022-05-13 Garland Arkansas 5051 23359 510
2499712 2499712 2022-05-13 Grant Arkansas 5053 4468 61
2499713 2499713 2022-05-13 Greene Arkansas 5055 16088 173
2499714 2499714 2022-05-13 Hempstead Arkansas 5057 4571 68
2499715 2499715 2022-05-13 Hot Spring Arkansas 5059 11237 136
2499716 2499716 2022-05-13 Howard Arkansas 5061 3763 50
2499717 2499717 2022-05-13 Independence Arkansas 5063 10639 212
2499718 2499718 2022-05-13 Izard Arkansas 5065 3906 70
2499719 2499719 2022-05-13 Jackson Arkansas 5067 6135 63
2499720 2499720 2022-05-13 Jefferson Arkansas 5069 18608 277
2499721 2499721 2022-05-13 Johnson Arkansas 5071 6830 87
2499722 2499722 2022-05-13 Lafayette Arkansas 5073 1298 31
2499723 2499723 2022-05-13 Lawrence Arkansas 5075 5324 78
2499724 2499724 2022-05-13 Lee Arkansas 5077 2912 59
2499725 2499725 2022-05-13 Lincoln Arkansas 5079 4920 68
2499726 2499726 2022-05-13 Little River Arkansas 5081 3281 104
2499727 2499727 2022-05-13 Logan Arkansas 5083 5130 80
2499728 2499728 2022-05-13 Lonoke Arkansas 5085 19951 243
2499729 2499729 2022-05-13 Madison Arkansas 5087 3975 61
2499730 2499730 2022-05-13 Marion Arkansas 5089 3409 88
2499731 2499731 2022-05-13 Miller Arkansas 5091 9596 181
2499732 2499732 2022-05-13 Mississippi Arkansas 5093 13608 210
2499733 2499733 2022-05-13 Monroe Arkansas 5095 1936 35
2499734 2499734 2022-05-13 Montgomery Arkansas 5097 1525 57
2499735 2499735 2022-05-13 Nevada Arkansas 5099 2188 46
2499736 2499736 2022-05-13 Newton Arkansas 5101 1719 47
2499737 2499737 2022-05-13 Ouachita Arkansas 5103 5484 104
2499738 2499738 2022-05-13 Perry Arkansas 5105 2523 37
2499739 2499739 2022-05-13 Phillips Arkansas 5107 4829 99
2499740 2499740 2022-05-13 Pike Arkansas 5109 2617 44
2499741 2499741 2022-05-13 Poinsett Arkansas 5111 8052 127
2499742 2499742 2022-05-13 Polk Arkansas 5113 4146 149
2499743 2499743 2022-05-13 Pope Arkansas 5115 18455 210
2499744 2499744 2022-05-13 Prairie Arkansas 5117 1965 43
2499745 2499745 2022-05-13 Pulaski Arkansas 5119 103939 1186
2499746 2499746 2022-05-13 Randolph Arkansas 5121 5217 89
2499747 2499747 2022-05-13 Saline Arkansas 5125 31019 339
2499748 2499748 2022-05-13 Scott Arkansas 5127 2299 43
2499749 2499749 2022-05-13 Searcy Arkansas 5129 2126 48
2499750 2499750 2022-05-13 Sebastian Arkansas 5131 32837 526
2499751 2499751 2022-05-13 Sevier Arkansas 5133 5943 75
2499752 2499752 2022-05-13 Sharp Arkansas 5135 4640 105
2499753 2499753 2022-05-13 St. Francis Arkansas 5123 7170 96
2499754 2499754 2022-05-13 Stone Arkansas 5137 2918 68
2499755 2499755 2022-05-13 Union Arkansas 5139 9268 176
2499756 2499756 2022-05-13 Unknown Arkansas   27002 0
2499757 2499757 2022-05-13 Van Buren Arkansas 5141 3489 62
2499758 2499758 2022-05-13 Washington Arkansas 5143 68841 620
2499759 2499759 2022-05-13 White Arkansas 5145 22164 292
2499760 2499760 2022-05-13 Woodruff Arkansas 5147 1732 31
2499761 2499761 2022-05-13 Yell Arkansas 5149 6859 106
2499762 2499762 2022-05-13 Alameda California 6001 284054 1868
2499763 2499763 2022-05-13 Alpine California 6003 126 0
2499764 2499764 2022-05-13 Amador California 6005 9242 86
2499765 2499765 2022-05-13 Butte California 6007 40181 424
2499766 2499766 2022-05-13 Calaveras California 6009 7754 120
2499767 2499767 2022-05-13 Colusa California 6011 4549 21
2499768 2499768 2022-05-13 Contra Costa California 6013 209958 1301
2499769 2499769 2022-05-13 Del Norte California 6015 6381 50
2499770 2499770 2022-05-13 El Dorado California 6017 30508 212
2499771 2499771 2022-05-13 Fresno California 6019 257611 2757
2499772 2499772 2022-05-13 Glenn California 6021 6631 67
2499773 2499773 2022-05-13 Humboldt California 6023 20952 146
2499774 2499774 2022-05-13 Imperial California 6025 66715 916

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