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

784,213 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
748603 2020-11-20 Greenlee Arizona 4011 154 2
748604 2020-11-20 La Paz Arizona 4012 740 18
748605 2020-11-20 Maricopa Arizona 4013 186564 3878
748606 2020-11-20 Mohave Arizona 4015 5482 247
748607 2020-11-20 Navajo Arizona 4017 7444 267
748608 2020-11-20 Pima Arizona 4019 34985 673
748609 2020-11-20 Pinal Arizona 4021 14851 250
748610 2020-11-20 Santa Cruz Arizona 4023 3468 67
748611 2020-11-20 Yavapai Arizona 4025 4245 105
748612 2020-11-20 Yuma Arizona 4027 16042 371
748613 2020-11-20 Arkansas Arkansas 5001 894 20
748614 2020-11-20 Ashley Arkansas 5003 724 13
748615 2020-11-20 Baxter Arkansas 5005 1216 26
748616 2020-11-20 Benton Arkansas 5007 10906 141
748617 2020-11-20 Boone Arkansas 5009 1522 41
748618 2020-11-20 Bradley Arkansas 5011 420 8
748619 2020-11-20 Calhoun Arkansas 5013 125 0
748620 2020-11-20 Carroll Arkansas 5015 1259 21
748621 2020-11-20 Chicot Arkansas 5017 1119 25
748622 2020-11-20 Clark Arkansas 5019 734 9
748623 2020-11-20 Clay Arkansas 5021 755 18
748624 2020-11-20 Cleburne Arkansas 5023 635 20
748625 2020-11-20 Cleveland Arkansas 5025 324 14
748626 2020-11-20 Columbia Arkansas 5027 952 24
748627 2020-11-20 Conway Arkansas 5029 582 6
748628 2020-11-20 Craighead Arkansas 5031 6423 71
748629 2020-11-20 Crawford Arkansas 5033 2818 35
748630 2020-11-20 Crittenden Arkansas 5035 3043 55
748631 2020-11-20 Cross Arkansas 5037 740 25
748632 2020-11-20 Dallas Arkansas 5039 255 6
748633 2020-11-20 Desha Arkansas 5041 505 8
748634 2020-11-20 Drew Arkansas 5043 558 7
748635 2020-11-20 Faulkner Arkansas 5045 4342 50
748636 2020-11-20 Franklin Arkansas 5047 698 8
748637 2020-11-20 Fulton Arkansas 5049 488 12
748638 2020-11-20 Garland Arkansas 5051 3416 99
748639 2020-11-20 Grant Arkansas 5053 519 5
748640 2020-11-20 Greene Arkansas 5055 2482 26
748641 2020-11-20 Hempstead Arkansas 5057 790 6
748642 2020-11-20 Hot Spring Arkansas 5059 2729 41
748643 2020-11-20 Howard Arkansas 5061 759 15
748644 2020-11-20 Independence Arkansas 5063 1923 71
748645 2020-11-20 Izard Arkansas 5065 940 5
748646 2020-11-20 Jackson Arkansas 5067 1479 6
748647 2020-11-20 Jefferson Arkansas 5069 4929 107
748648 2020-11-20 Johnson Arkansas 5071 1191 11
748649 2020-11-20 Lafayette Arkansas 5073 248 3
748650 2020-11-20 Lawrence Arkansas 5075 1070 28
748651 2020-11-20 Lee Arkansas 5077 1148 18
748652 2020-11-20 Lincoln Arkansas 5079 2382 18
748653 2020-11-20 Little River Arkansas 5081 601 39
748654 2020-11-20 Logan Arkansas 5083 822 6
748655 2020-11-20 Lonoke Arkansas 5085 2423 44
748656 2020-11-20 Madison Arkansas 5087 546 6
748657 2020-11-20 Marion Arkansas 5089 365 5
748658 2020-11-20 Miller Arkansas 5091 2017 22
748659 2020-11-20 Mississippi Arkansas 5093 2960 79
748660 2020-11-20 Monroe Arkansas 5095 283 4
748661 2020-11-20 Montgomery Arkansas 5097 235 10
748662 2020-11-20 Nevada Arkansas 5099 416 14
748663 2020-11-20 Newton Arkansas 5101 397 22
748664 2020-11-20 Ouachita Arkansas 5103 579 11
748665 2020-11-20 Perry Arkansas 5105 222 3
748666 2020-11-20 Phillips Arkansas 5107 874 16
748667 2020-11-20 Pike Arkansas 5109 344 1
748668 2020-11-20 Poinsett Arkansas 5111 1557 38
748669 2020-11-20 Polk Arkansas 5113 673 7
748670 2020-11-20 Pope Arkansas 5115 3413 41
748671 2020-11-20 Prairie Arkansas 5117 335 6
748672 2020-11-20 Pulaski Arkansas 5119 15255 251
748673 2020-11-20 Randolph Arkansas 5121 907 28
748674 2020-11-20 Saline Arkansas 5125 4170 51
748675 2020-11-20 Scott Arkansas 5127 323 2
748676 2020-11-20 Searcy Arkansas 5129 268 1
748677 2020-11-20 Sebastian Arkansas 5131 6467 119
748678 2020-11-20 Sevier Arkansas 5133 1630 16
748679 2020-11-20 Sharp Arkansas 5135 604 14
748680 2020-11-20 St. Francis Arkansas 5123 1959 13
748681 2020-11-20 Stone Arkansas 5137 439 22
748682 2020-11-20 Union Arkansas 5139 1420 56
748683 2020-11-20 Unknown Arkansas   2404 0
748684 2020-11-20 Van Buren Arkansas 5141 307 3
748685 2020-11-20 Washington Arkansas 5143 14252 170
748686 2020-11-20 White Arkansas 5145 2663 46
748687 2020-11-20 Woodruff Arkansas 5147 181 0
748688 2020-11-20 Yell Arkansas 5149 1563 33
748689 2020-11-20 Alameda California 6001 27244 499
748690 2020-11-20 Alpine California 6003 20 0
748691 2020-11-20 Amador California 6005 435 16
748692 2020-11-20 Butte California 6007 3624 59
748693 2020-11-20 Calaveras California 6009 422 21
748694 2020-11-20 Colusa California 6011 639 6
748695 2020-11-20 Contra Costa California 6013 22191 257
748696 2020-11-20 Del Norte California 6015 251 1
748697 2020-11-20 El Dorado California 6017 1825 4
748698 2020-11-20 Fresno California 6019 35711 471
748699 2020-11-20 Glenn California 6021 806 6
748700 2020-11-20 Humboldt California 6023 730 9
748701 2020-11-20 Imperial California 6025 14720 352
748702 2020-11-20 Inyo California 6027 262 16

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