johns_hopkins_csse_daily_reports

⚠️ 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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

10,589 rows where province_or_state = "Arkansas" sorted by day descending

View and edit SQL

Suggested facets: day (date)

province_or_state

  • Arkansas · 10,589

country_or_region

  • US 10,589
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496310 2020-08-11 US Arkansas Pulaski 5119 5706 86 0 5620 34.77054088 -92.31355101 2020-08-12 04:27:29 Pulaski, Arkansas, US
496630 2020-08-11 US Arkansas Phillips 5107 329 9 0 320 34.43268455 -90.84800154 2020-08-12 04:27:29 Phillips, Arkansas, US
496631 2020-08-11 US Arkansas Randolph 5121 222 4 0 218 36.3415714 -91.02455531 2020-08-12 04:27:29 Randolph, Arkansas, US
496632 2020-08-11 US Arkansas Perry 5105 55 0 0 55 34.9459153 -92.94372564 2020-08-12 04:27:29 Perry, Arkansas, US
496633 2020-08-11 US Arkansas Jefferson 5069 1584 40 0 1544 34.26767081 -91.92619839 2020-08-12 04:27:29 Jefferson, Arkansas, US
496634 2020-08-11 US Arkansas Yell 5149 1069 17 0 1052 35.00292371 -93.41171338 2020-08-12 04:27:29 Yell, Arkansas, US
496635 2020-08-11 US Arkansas Pike 5109 111 1 0 110 34.16250414 -93.65789349 2020-08-12 04:27:29 Pike, Arkansas, US
496636 2020-08-11 US Arkansas Bradley 5011 207 4 0 203 33.46755808 -92.15980837 2020-08-12 04:27:29 Bradley, Arkansas, US
496637 2020-08-11 US Arkansas Crittenden 5035 1381 23 0 1358 35.21247318 -90.30839406 2020-08-12 04:27:29 Crittenden, Arkansas, US
496638 2020-08-11 US Arkansas Stone 5137 69 1 0 68 35.86251946 -92.15684085 2020-08-12 04:27:29 Stone, Arkansas, US
496680 2020-08-11 US Arkansas Prairie 5117 100 0 0 100 34.83624419 -91.55162157 2020-08-12 04:27:29 Prairie, Arkansas, US
497114 2020-08-11 US Arkansas Crawford 5033 648 4 0 644 35.58928601 -94.2446814 2020-08-12 04:27:29 Crawford, Arkansas, US
497115 2020-08-11 US Arkansas Franklin 5047 128 2 0 126 35.51202821 -93.89299569 2020-08-12 04:27:29 Franklin, Arkansas, US
497116 2020-08-11 US Arkansas Montgomery 5097 38 1 0 37 34.53704874 -93.65824478 2020-08-12 04:27:29 Montgomery, Arkansas, US
497117 2020-08-11 US Arkansas Ouachita 5103 105 2 0 103 33.58839816 -92.87795984 2020-08-12 04:27:29 Ouachita, Arkansas, US
497118 2020-08-11 US Arkansas Clark 5019 177 1 0 176 34.04613432 -93.17484713 2020-08-12 04:27:29 Clark, Arkansas, US
497119 2020-08-11 US Arkansas Dallas 5039 64 1 0 63 33.97042763 -92.65167437 2020-08-12 04:27:29 Dallas, Arkansas, US
497120 2020-08-11 US Arkansas St. Francis 5123 1226 3 0 1223 35.02201976 -90.74828138 2020-08-12 04:27:29 St. Francis, Arkansas, US
497121 2020-08-11 US Arkansas Cross 5037 208 4 0 204 35.29631396 -90.77185818 2020-08-12 04:27:29 Cross, Arkansas, US
497122 2020-08-11 US Arkansas Van Buren 5141 53 2 0 51 35.58095779 -92.51295036 2020-08-12 04:27:29 Van Buren, Arkansas, US
497123 2020-08-11 US Arkansas Fulton 5049 44 0 0 44 36.38177105 -91.81729127 2020-08-12 04:27:29 Fulton, Arkansas, US
497183 2020-08-11 US Arkansas Howard 5061 355 4 0 351 34.09007427 -93.9934871 2020-08-12 04:27:29 Howard, Arkansas, US
497184 2020-08-11 US Arkansas Lonoke 5085 531 2 0 529 34.75392199 -91.88742357 2020-08-12 04:27:29 Lonoke, Arkansas, US
497598 2020-08-11 US Arkansas Ashley 5003 330 5 0 325 33.19153461 -91.7698471 2020-08-12 04:27:29 Ashley, Arkansas, US
497599 2020-08-11 US Arkansas Saline 5125 1113 7 0 1106 34.64916145 -92.67583224 2020-08-12 04:27:29 Saline, Arkansas, US
497600 2020-08-11 US Arkansas Hempstead 5057 249 2 0 247 33.73325583 -93.66935133 2020-08-12 04:27:29 Hempstead, Arkansas, US
497601 2020-08-11 US Arkansas Nevada 5099 143 9 0 134 33.66340119 -93.30632432 2020-08-12 04:27:29 Nevada, Arkansas, US
497602 2020-08-11 US Arkansas White 5145 328 2 0 326 35.25688493 -91.74908296 2020-08-12 04:27:29 White, Arkansas, US
497603 2020-08-11 US Arkansas Newton 5101 106 10 0 96 35.91947491 -93.21612969 2020-08-12 04:27:29 Newton, Arkansas, US
497604 2020-08-11 US Arkansas Cleburne 5023 202 5 0 197 35.53864922 -92.02640019 2020-08-12 04:27:29 Cleburne, Arkansas, US
498058 2020-08-11 US Arkansas Searcy 5129 33 0 0 33 35.9109364 -92.69936482 2020-08-12 04:27:29 Searcy, Arkansas, US
498059 2020-08-11 US Arkansas Greene 5055 492 2 0 490 36.11735460000001 -90.55832668 2020-08-12 04:27:29 Greene, Arkansas, US
498060 2020-08-11 US Arkansas Benton 5007 4805 43 0 4762 36.33644656 -94.25680817 2020-08-12 04:27:29 Benton, Arkansas, US
498061 2020-08-11 US Arkansas Carroll 5015 379 7 0 372 36.34038560000001 -93.54270261 2020-08-12 04:27:29 Carroll, Arkansas, US
498062 2020-08-11 US Arkansas Madison 5087 270 2 0 268 36.01038185 -93.72524943 2020-08-12 04:27:29 Madison, Arkansas, US
498063 2020-08-11 US Arkansas Lincoln 5079 1224 12 0 1212 33.95317155 -91.74002806 2020-08-12 04:27:29 Lincoln, Arkansas, US
498064 2020-08-11 US Arkansas Monroe 5095 64 0 0 64 34.6815935 -91.20540287 2020-08-12 04:27:29 Monroe, Arkansas, US
498065 2020-08-11 US Arkansas Hot Spring 5059 1557 12 0 1545 34.31709259 -92.95396325 2020-08-12 04:27:29 Hot Spring, Arkansas, US
498066 2020-08-11 US Arkansas Izard 5065 53 1 0 52 36.09604046 -91.90847954 2020-08-12 04:27:29 Izard, Arkansas, US
498566 2020-08-11 US Arkansas Jackson 5067 117 1 0 116 35.59802983 -91.21494602 2020-08-12 04:27:29 Jackson, Arkansas, US
498567 2020-08-11 US Arkansas Clay 5021 138 4 0 134 36.36826212 -90.4148172 2020-08-12 04:27:29 Clay, Arkansas, US
498568 2020-08-11 US Arkansas Marion 5089 29 0 0 29 36.26844485 -92.68451899 2020-08-12 04:27:29 Marion, Arkansas, US
498569 2020-08-11 US Arkansas Lafayette 5073 56 2 0 54 33.24116713 -93.60677071 2020-08-12 04:27:29 Lafayette, Arkansas, US
498570 2020-08-11 US Arkansas Columbia 5027 220 12 0 208 33.21230701 -93.22642793 2020-08-12 04:27:29 Columbia, Arkansas, US
498571 2020-08-11 US Arkansas Chicot 5017 736 9 0 727 33.26458973 -91.29539209 2020-08-12 04:27:29 Chicot, Arkansas, US
498572 2020-08-11 US Arkansas Scott 5127 66 0 0 66 34.85588887 -94.0632176 2020-08-12 04:27:29 Scott, Arkansas, US
498573 2020-08-11 US Arkansas Cleveland 5025 103 2 0 101 33.89723187 -92.18537045 2020-08-12 04:27:29 Cleveland, Arkansas, US
498574 2020-08-11 US Arkansas Poinsett 5111 292 3 0 289 35.57433534 -90.66268713 2020-08-12 04:27:29 Poinsett, Arkansas, US
499062 2020-08-11 US Arkansas Lawrence 5075 217 9 0 208 36.04188196 -91.10867198 2020-08-12 04:27:29 Lawrence, Arkansas, US
499063 2020-08-11 US Arkansas Union 5139 508 18 0 490 33.16887091 -92.59746952 2020-08-12 04:27:29 Union, Arkansas, US
499064 2020-08-11 US Arkansas Polk 5113 150 1 0 149 34.48254879 -94.22728802 2020-08-12 04:27:29 Polk, Arkansas, US
499065 2020-08-11 US Arkansas Sevier 5133 996 10 0 986 33.99780401 -94.2424869 2020-08-12 04:27:29 Sevier, Arkansas, US
499066 2020-08-11 US Arkansas Arkansas 5001 227 1 0 226 34.29145151 -91.37277296 2020-08-12 04:27:29 Arkansas, Arkansas, US
499067 2020-08-11 US Arkansas Lee 5077 896 8 0 888 34.78498904 -90.78383866 2020-08-12 04:27:29 Lee, Arkansas, US
499068 2020-08-11 US Arkansas Faulkner 5045 1330 6 0 1324 35.14719007 -92.33717519 2020-08-12 04:27:29 Faulkner, Arkansas, US
499069 2020-08-11 US Arkansas Pope 5115 1333 10 0 1323 35.44871474 -93.03212219 2020-08-12 04:27:29 Pope, Arkansas, US
499113 2020-08-11 US Arkansas Unassigned 90005 1811 0 0 1811 36.38177105 0.0 2020-08-12 04:27:29 Unassigned, Arkansas, US
499545 2020-08-11 US Arkansas Desha 5041 201 2 0 199 33.83011025 -91.25500948 2020-08-12 04:27:29 Desha, Arkansas, US
499546 2020-08-11 US Arkansas Mississippi 5093 1044 14 0 1030 35.76271485 -90.05194370000002 2020-08-12 04:27:29 Mississippi, Arkansas, US
499547 2020-08-11 US Arkansas Washington 5143 6321 52 0 6269 35.976844 -94.21800746 2020-08-12 04:27:29 Washington, Arkansas, US
499548 2020-08-11 US Arkansas Little River 5081 185 1 0 184 33.70375665 -94.23468591 2020-08-12 04:27:29 Little River, Arkansas, US
499549 2020-08-11 US Arkansas Miller 5091 518 5 0 513 33.31403423 -93.89285258 2020-08-12 04:27:29 Miller, Arkansas, US
499550 2020-08-11 US Arkansas Sebastian 5131 2250 20 0 2230 35.19605503 -94.27162713 2020-08-12 04:27:29 Sebastian, Arkansas, US
499551 2020-08-11 US Arkansas Logan 5083 277 1 0 276 35.21413234 -93.71951016 2020-08-12 04:27:29 Logan, Arkansas, US
499552 2020-08-11 US Arkansas Drew 5043 217 3 0 214 33.59035001 -91.71777921 2020-08-12 04:27:29 Drew, Arkansas, US
499553 2020-08-11 US Arkansas Grant 5053 140 0 0 140 34.29017991 -92.42320562 2020-08-12 04:27:29 Grant, Arkansas, US
499554 2020-08-11 US Arkansas Woodruff 5147 22 0 0 22 35.18902527 -91.2439489 2020-08-12 04:27:29 Woodruff, Arkansas, US
499555 2020-08-11 US Arkansas Conway 5029 153 3 0 150 35.26205537 -92.70506566 2020-08-12 04:27:29 Conway, Arkansas, US
499556 2020-08-11 US Arkansas Sharp 5135 114 5 0 109 36.16258158 -91.47819342 2020-08-12 04:27:29 Sharp, Arkansas, US
499845 2020-08-11 US Arkansas Independence 5063 550 1 0 549 35.74242707 -91.57001641 2020-08-12 04:27:29 Independence, Arkansas, US
499846 2020-08-11 US Arkansas Baxter 5005 73 0 0 73 36.28784385 -92.33782872 2020-08-12 04:27:29 Baxter, Arkansas, US
499847 2020-08-11 US Arkansas Garland 5051 1071 17 0 1054 34.57692074 -93.14921604 2020-08-12 04:27:29 Garland, Arkansas, US
499848 2020-08-11 US Arkansas Calhoun 5013 17 0 0 17 33.55598792 -92.49974403 2020-08-12 04:27:29 Calhoun, Arkansas, US
499849 2020-08-11 US Arkansas Johnson 5071 672 2 0 670 35.56759135 -93.46036368 2020-08-12 04:27:29 Johnson, Arkansas, US
499850 2020-08-11 US Arkansas Craighead 5031 1389 12 0 1377 35.83018283 -90.63235729 2020-08-12 04:27:29 Craighead, Arkansas, US
499851 2020-08-11 US Arkansas Boone 5009 214 2 0 212 36.3084504 -93.09374925 2020-08-12 04:27:29 Boone, Arkansas, US
274167 2020-08-10 US Arkansas Arkansas 5001 221 1 0 220 34.29145151 -91.37277296 2020-08-11 04:35:08 Arkansas, Arkansas, US
274178 2020-08-10 US Arkansas Ashley 5003 330 5 0 325 33.19153461 -91.76984709999999 2020-08-11 04:35:08 Ashley, Arkansas, US
274237 2020-08-10 US Arkansas Baxter 5005 71 0 0 71 36.28784385 -92.33782872 2020-08-11 04:35:08 Baxter, Arkansas, US
274269 2020-08-10 US Arkansas Benton 5007 4794 43 0 4751 36.33644656 -94.25680817 2020-08-11 04:35:08 Benton, Arkansas, US
274320 2020-08-10 US Arkansas Boone 5009 212 2 0 210 36.3084504 -93.09374925 2020-08-11 04:35:08 Boone, Arkansas, US
274346 2020-08-10 US Arkansas Bradley 5011 204 4 0 200 33.46755808 -92.15980837 2020-08-11 04:35:08 Bradley, Arkansas, US
274435 2020-08-10 US Arkansas Calhoun 5013 17 0 0 17 33.55598792 -92.49974403 2020-08-11 04:35:08 Calhoun, Arkansas, US
274482 2020-08-10 US Arkansas Carroll 5015 359 7 0 352 36.34038560000001 -93.54270261 2020-08-11 04:35:08 Carroll, Arkansas, US
274584 2020-08-10 US Arkansas Chicot 5017 739 8 0 731 33.26458973 -91.29539209 2020-08-11 04:35:08 Chicot, Arkansas, US
274614 2020-08-10 US Arkansas Clark 5019 177 1 0 176 34.04613432 -93.17484713 2020-08-11 04:35:08 Clark, Arkansas, US
274633 2020-08-10 US Arkansas Clay 5021 136 4 0 132 36.36826212 -90.4148172 2020-08-11 04:35:08 Clay, Arkansas, US
274657 2020-08-10 US Arkansas Cleburne 5023 202 5 0 197 35.53864922 -92.02640019 2020-08-11 04:35:08 Cleburne, Arkansas, US
274659 2020-08-10 US Arkansas Cleveland 5025 102 2 0 100 33.89723187 -92.18537045 2020-08-11 04:35:08 Cleveland, Arkansas, US
274700 2020-08-10 US Arkansas Columbia 5027 217 12 0 205 33.21230701 -93.22642793 2020-08-11 04:35:08 Columbia, Arkansas, US
274722 2020-08-10 US Arkansas Conway 5029 153 3 0 150 35.26205537 -92.70506566 2020-08-11 04:35:08 Conway, Arkansas, US
274749 2020-08-10 US Arkansas Craighead 5031 1374 12 0 1362 35.83018283 -90.63235729 2020-08-11 04:35:08 Craighead, Arkansas, US
274752 2020-08-10 US Arkansas Crawford 5033 635 4 0 631 35.58928601 -94.2446814 2020-08-11 04:35:08 Crawford, Arkansas, US
274766 2020-08-10 US Arkansas Crittenden 5035 1369 23 0 1346 35.21247318 -90.30839406 2020-08-11 04:35:08 Crittenden, Arkansas, US
274773 2020-08-10 US Arkansas Cross 5037 204 4 0 200 35.29631396 -90.77185818 2020-08-11 04:35:08 Cross, Arkansas, US
274806 2020-08-10 US Arkansas Dallas 5039 64 0 0 64 33.97042763 -92.65167437 2020-08-11 04:35:08 Dallas, Arkansas, US
274869 2020-08-10 US Arkansas Desha 5041 197 2 0 195 33.83011025 -91.25500948 2020-08-11 04:35:08 Desha, Arkansas, US
274916 2020-08-10 US Arkansas Drew 5043 209 3 0 206 33.59035001 -91.71777921 2020-08-11 04:35:08 Drew, Arkansas, US
275006 2020-08-10 US Arkansas Faulkner 5045 1319 6 0 1313 35.14719007 -92.33717519 2020-08-11 04:35:08 Faulkner, Arkansas, US
275053 2020-08-10 US Arkansas Franklin 5047 127 2 0 125 35.51202821 -93.89299569 2020-08-11 04:35:08 Franklin, Arkansas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 2077.557ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette