ny_times_us_counties

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

660,902 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
635040 2020-10-16 Greenlee Arizona 4011 68 2
635041 2020-10-16 La Paz Arizona 4012 581 16
635042 2020-10-16 Maricopa Arizona 4013 148612 3500
635043 2020-10-16 Mohave Arizona 4015 4156 229
635044 2020-10-16 Navajo Arizona 4017 6136 236
635045 2020-10-16 Pima Arizona 4019 26769 633
635046 2020-10-16 Pinal Arizona 4021 11242 213
635047 2020-10-16 Santa Cruz Arizona 4023 2936 64
635048 2020-10-16 Yavapai Arizona 4025 2760 86
635049 2020-10-16 Yuma Arizona 4027 13123 351
635050 2020-10-16 Arkansas Arkansas 5001 594 11
635051 2020-10-16 Ashley Arkansas 5003 495 12
635052 2020-10-16 Baxter Arkansas 5005 518 7
635053 2020-10-16 Benton Arkansas 5007 7512 102
635054 2020-10-16 Boone Arkansas 5009 940 27
635055 2020-10-16 Bradley Arkansas 5011 354 8
635056 2020-10-16 Calhoun Arkansas 5013 41 0
635057 2020-10-16 Carroll Arkansas 5015 921 12
635058 2020-10-16 Chicot Arkansas 5017 1027 22
635059 2020-10-16 Clark Arkansas 5019 452 5
635060 2020-10-16 Clay Arkansas 5021 413 11
635061 2020-10-16 Cleburne Arkansas 5023 410 14
635062 2020-10-16 Cleveland Arkansas 5025 199 12
635063 2020-10-16 Columbia Arkansas 5027 639 19
635064 2020-10-16 Conway Arkansas 5029 326 3
635065 2020-10-16 Craighead Arkansas 5031 3935 34
635066 2020-10-16 Crawford Arkansas 5033 1821 24
635067 2020-10-16 Crittenden Arkansas 5035 2152 51
635068 2020-10-16 Cross Arkansas 5037 532 20
635069 2020-10-16 Dallas Arkansas 5039 178 5
635070 2020-10-16 Desha Arkansas 5041 361 7
635071 2020-10-16 Drew Arkansas 5043 388 7
635072 2020-10-16 Faulkner Arkansas 5045 3071 27
635073 2020-10-16 Franklin Arkansas 5047 446 2
635074 2020-10-16 Fulton Arkansas 5049 264 8
635075 2020-10-16 Garland Arkansas 5051 2222 58
635076 2020-10-16 Grant Arkansas 5053 331 4
635077 2020-10-16 Greene Arkansas 5055 1212 15
635078 2020-10-16 Hempstead Arkansas 5057 492 5
635079 2020-10-16 Hot Spring Arkansas 5059 2091 30
635080 2020-10-16 Howard Arkansas 5061 536 13
635081 2020-10-16 Independence Arkansas 5063 1354 36
635082 2020-10-16 Izard Arkansas 5065 394 1
635083 2020-10-16 Jackson Arkansas 5067 591 5
635084 2020-10-16 Jefferson Arkansas 5069 3904 97
635085 2020-10-16 Johnson Arkansas 5071 933 8
635086 2020-10-16 Lafayette Arkansas 5073 146 3
635087 2020-10-16 Lawrence Arkansas 5075 700 14
635088 2020-10-16 Lee Arkansas 5077 1096 18
635089 2020-10-16 Lincoln Arkansas 5079 2180 17
635090 2020-10-16 Little River Arkansas 5081 404 29
635091 2020-10-16 Logan Arkansas 5083 531 2
635092 2020-10-16 Lonoke Arkansas 5085 1505 21
635093 2020-10-16 Madison Arkansas 5087 408 6
635094 2020-10-16 Marion Arkansas 5089 126 2
635095 2020-10-16 Miller Arkansas 5091 1146 15
635096 2020-10-16 Mississippi Arkansas 5093 1991 58
635097 2020-10-16 Monroe Arkansas 5095 194 0
635098 2020-10-16 Montgomery Arkansas 5097 178 8
635099 2020-10-16 Nevada Arkansas 5099 260 14
635100 2020-10-16 Newton Arkansas 5101 282 19
635101 2020-10-16 Ouachita Arkansas 5103 326 7
635102 2020-10-16 Perry Arkansas 5105 124 0
635103 2020-10-16 Phillips Arkansas 5107 671 15
635104 2020-10-16 Pike Arkansas 5109 253 2
635105 2020-10-16 Poinsett Arkansas 5111 883 16
635106 2020-10-16 Polk Arkansas 5113 332 4
635107 2020-10-16 Pope Arkansas 5115 2511 36
635108 2020-10-16 Prairie Arkansas 5117 191 4
635109 2020-10-16 Pulaski Arkansas 5119 10954 193
635110 2020-10-16 Randolph Arkansas 5121 572 23
635111 2020-10-16 Saline Arkansas 5125 2544 28
635112 2020-10-16 Scott Arkansas 5127 146 1
635113 2020-10-16 Searcy Arkansas 5129 173 1
635114 2020-10-16 Sebastian Arkansas 5131 4457 87
635115 2020-10-16 Sevier Arkansas 5133 1256 19
635116 2020-10-16 Sharp Arkansas 5135 293 9
635117 2020-10-16 St. Francis Arkansas 5123 1643 9
635118 2020-10-16 Stone Arkansas 5137 389 20
635119 2020-10-16 Union Arkansas 5139 1057 47
635120 2020-10-16 Unknown Arkansas   1982 0
635121 2020-10-16 Van Buren Arkansas 5141 198 3
635122 2020-10-16 Washington Arkansas 5143 10748 131
635123 2020-10-16 White Arkansas 5145 1248 32
635124 2020-10-16 Woodruff Arkansas 5147 82 0
635125 2020-10-16 Yell Arkansas 5149 1310 30
635126 2020-10-16 Alameda California 6001 22429 439
635127 2020-10-16 Alpine California 6003 3 0
635128 2020-10-16 Amador California 6005 308 16
635129 2020-10-16 Butte California 6007 3000 50
635130 2020-10-16 Calaveras California 6009 333 17
635131 2020-10-16 Colusa California 6011 545 6
635132 2020-10-16 Contra Costa California 6013 17893 234
635133 2020-10-16 Del Norte California 6015 173 1
635134 2020-10-16 El Dorado California 6017 1265 4
635135 2020-10-16 Fresno California 6019 29727 429
635136 2020-10-16 Glenn California 6021 632 3
635137 2020-10-16 Humboldt California 6023 544 8
635138 2020-10-16 Imperial California 6025 12410 334
635139 2020-10-16 Inyo California 6027 210 15

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]);
Powered by Datasette · Query took 3841.807ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette