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

59,032 rows where state = "Arkansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips >30

county >30

state 1

  • Arkansas · 59,032 ✖
Link rowid date ▲ county state fips cases deaths
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
2496428 2496428 2022-05-12 Arkansas Arkansas 5001 5695 79
2496429 2496429 2022-05-12 Ashley Arkansas 5003 5114 66
2496430 2496430 2022-05-12 Baxter Arkansas 5005 8847 247
2496431 2496431 2022-05-12 Benton Arkansas 5007 67077 849
2496432 2496432 2022-05-12 Boone Arkansas 5009 9465 179
2496433 2496433 2022-05-12 Bradley Arkansas 5011 2997 49
2496434 2496434 2022-05-12 Calhoun Arkansas 5013 965 10
2496435 2496435 2022-05-12 Carroll Arkansas 5015 6133 102
2496436 2496436 2022-05-12 Chicot Arkansas 5017 2778 60
2496437 2496437 2022-05-12 Clark Arkansas 5019 5377 79
2496438 2496438 2022-05-12 Clay Arkansas 5021 4154 93
2496439 2496439 2022-05-12 Cleburne Arkansas 5023 6465 128
2496440 2496440 2022-05-12 Cleveland Arkansas 5025 2269 36
2496441 2496441 2022-05-12 Columbia Arkansas 5027 5436 95
2496442 2496442 2022-05-12 Conway Arkansas 5029 5489 65
2496443 2496443 2022-05-12 Craighead Arkansas 5031 37757 329
2496444 2496444 2022-05-12 Crawford Arkansas 5033 15879 249
2496445 2496445 2022-05-12 Crittenden Arkansas 5035 14311 226
2496446 2496446 2022-05-12 Cross Arkansas 5037 4835 83
2496447 2496447 2022-05-12 Dallas Arkansas 5039 1746 31
2496448 2496448 2022-05-12 Desha Arkansas 5041 3030 41
2496449 2496449 2022-05-12 Drew Arkansas 5043 4686 70
2496450 2496450 2022-05-12 Faulkner Arkansas 5045 35234 316
2496451 2496451 2022-05-12 Franklin Arkansas 5047 3817 73

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