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

570,096 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
534579 2020-09-15 La Paz Arizona 4012 527 15
534580 2020-09-15 Maricopa Arizona 4013 137870 3172
534581 2020-09-15 Mohave Arizona 4015 3798 218
534582 2020-09-15 Navajo Arizona 4017 5704 227
534583 2020-09-15 Pima Arizona 4019 22643 601
534584 2020-09-15 Pinal Arizona 4021 10198 196
534585 2020-09-15 Santa Cruz Arizona 4023 2787 61
534586 2020-09-15 Yavapai Arizona 4025 2429 80
534587 2020-09-15 Yuma Arizona 4027 12430 337
534588 2020-09-15 Arkansas Arkansas 5001 319 4
534589 2020-09-15 Ashley Arkansas 5003 403 8
534590 2020-09-15 Baxter Arkansas 5005 222 1
534591 2020-09-15 Benton Arkansas 5007 5940 79
534592 2020-09-15 Boone Arkansas 5009 555 7
534593 2020-09-15 Bradley Arkansas 5011 324 7
534594 2020-09-15 Calhoun Arkansas 5013 31 0
534595 2020-09-15 Carroll Arkansas 5015 573 9
534596 2020-09-15 Chicot Arkansas 5017 977 17
534597 2020-09-15 Clark Arkansas 5019 286 4
534598 2020-09-15 Clay Arkansas 5021 243 7
534599 2020-09-15 Cleburne Arkansas 5023 299 7
534600 2020-09-15 Cleveland Arkansas 5025 164 10
534601 2020-09-15 Columbia Arkansas 5027 348 18
534602 2020-09-15 Conway Arkansas 5029 233 3
534603 2020-09-15 Craighead Arkansas 5031 2417 19
534604 2020-09-15 Crawford Arkansas 5033 1127 14
534605 2020-09-15 Crittenden Arkansas 5035 1816 45
534606 2020-09-15 Cross Arkansas 5037 383 7
534607 2020-09-15 Dallas Arkansas 5039 154 2
534608 2020-09-15 Desha Arkansas 5041 265 5
534609 2020-09-15 Drew Arkansas 5043 336 6
534610 2020-09-15 Faulkner Arkansas 5045 2061 15
534611 2020-09-15 Franklin Arkansas 5047 221 2
534612 2020-09-15 Fulton Arkansas 5049 104 2
534613 2020-09-15 Garland Arkansas 5051 1658 45
534614 2020-09-15 Grant Arkansas 5053 227 2
534615 2020-09-15 Greene Arkansas 5055 733 7
534616 2020-09-15 Hempstead Arkansas 5057 344 4
534617 2020-09-15 Hot Spring Arkansas 5059 1790 25
534618 2020-09-15 Howard Arkansas 5061 450 8
534619 2020-09-15 Independence Arkansas 5063 931 13
534620 2020-09-15 Izard Arkansas 5065 133 0
534621 2020-09-15 Jackson Arkansas 5067 248 1
534622 2020-09-15 Jefferson Arkansas 5069 2588 60
534623 2020-09-15 Johnson Arkansas 5071 805 5
534624 2020-09-15 Lafayette Arkansas 5073 80 2
534625 2020-09-15 Lawrence Arkansas 5075 321 11
534626 2020-09-15 Lee Arkansas 5077 1027 16
534627 2020-09-15 Lincoln Arkansas 5079 1792 15
534628 2020-09-15 Little River Arkansas 5081 331 23
534629 2020-09-15 Logan Arkansas 5083 383 1
534630 2020-09-15 Lonoke Arkansas 5085 947 9
534631 2020-09-15 Madison Arkansas 5087 319 2
534632 2020-09-15 Marion Arkansas 5089 64 0
534633 2020-09-15 Miller Arkansas 5091 725 11
534634 2020-09-15 Mississippi Arkansas 5093 1520 48
534635 2020-09-15 Monroe Arkansas 5095 105 0
534636 2020-09-15 Montgomery Arkansas 5097 123 4
534637 2020-09-15 Nevada Arkansas 5099 186 13
534638 2020-09-15 Newton Arkansas 5101 184 18
534639 2020-09-15 Ouachita Arkansas 5103 220 6
534640 2020-09-15 Perry Arkansas 5105 73 0
534641 2020-09-15 Phillips Arkansas 5107 437 11
534642 2020-09-15 Pike Arkansas 5109 215 3
534643 2020-09-15 Poinsett Arkansas 5111 579 8
534644 2020-09-15 Polk Arkansas 5113 249 4
534645 2020-09-15 Pope Arkansas 5115 1963 28
534646 2020-09-15 Prairie Arkansas 5117 133 1
534647 2020-09-15 Pulaski Arkansas 5119 8231 135
534648 2020-09-15 Randolph Arkansas 5121 352 22
534649 2020-09-15 Saline Arkansas 5125 1856 19
534650 2020-09-15 Scott Arkansas 5127 93 1
534651 2020-09-15 Searcy Arkansas 5129 132 0
534652 2020-09-15 Sebastian Arkansas 5131 3253 55
534653 2020-09-15 Sevier Arkansas 5133 1185 16
534654 2020-09-15 Sharp Arkansas 5135 170 6
534655 2020-09-15 St. Francis Arkansas 5123 1398 4
534656 2020-09-15 Stone Arkansas 5137 283 5
534657 2020-09-15 Union Arkansas 5139 816 31
534658 2020-09-15 Unknown Arkansas   1595 0
534659 2020-09-15 Van Buren Arkansas 5141 159 2
534660 2020-09-15 Washington Arkansas 5143 8396 105
534661 2020-09-15 White Arkansas 5145 652 18
534662 2020-09-15 Woodruff Arkansas 5147 36 0
534663 2020-09-15 Yell Arkansas 5149 1206 29
534664 2020-09-15 Alameda California 6001 20118 356
534665 2020-09-15 Alpine California 6003 2 0
534666 2020-09-15 Amador California 6005 280 16
534667 2020-09-15 Butte California 6007 2642 31
534668 2020-09-15 Calaveras California 6009 305 13
534669 2020-09-15 Colusa California 6011 499 6
534670 2020-09-15 Contra Costa California 6013 15489 194
534671 2020-09-15 Del Norte California 6015 135 1
534672 2020-09-15 El Dorado California 6017 1051 4
534673 2020-09-15 Fresno California 6019 27232 348
534674 2020-09-15 Glenn California 6021 521 3
534675 2020-09-15 Humboldt California 6023 479 6
534676 2020-09-15 Imperial California 6025 11392 308
534677 2020-09-15 Inyo California 6027 176 14
534678 2020-09-15 Kern California 6029 30916 333

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 4701.098ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette