daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

76 rows where "day" is on date 2020-07-07, "last_update" is on date 2020-07-08 and province_or_state = "Arkansas" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Arkansas · 76 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-07-07 US Arkansas Arkansas 5001 41 0 0 41 34.29145151 -91.37277296 2020-07-08 05:33:48 Arkansas, Arkansas, US
2020-07-07 US Arkansas Ashley 5003 84 1 0 83 33.19153461 -91.7698471 2020-07-08 05:33:48 Ashley, Arkansas, US
2020-07-07 US Arkansas Baxter 5005 25 0 0 25 36.28784385 -92.33782872 2020-07-08 05:33:48 Baxter, Arkansas, US
2020-07-07 US Arkansas Benton 5007 3095 21 0 3074 36.33644656 -94.25680817 2020-07-08 05:33:48 Benton, Arkansas, US
2020-07-07 US Arkansas Boone 5009 30 1 0 29 36.3084504 -93.09374925 2020-07-08 05:33:48 Boone, Arkansas, US
2020-07-07 US Arkansas Bradley 5011 55 2 0 53 33.46755808 -92.15980837 2020-07-08 05:33:48 Bradley, Arkansas, US
2020-07-07 US Arkansas Calhoun 5013 2 0 0 2 33.55598792 -92.49974403 2020-07-08 05:33:48 Calhoun, Arkansas, US
2020-07-07 US Arkansas Carroll 5015 197 5 0 192 36.34038560000001 -93.54270261 2020-07-08 05:33:48 Carroll, Arkansas, US
2020-07-07 US Arkansas Chicot 5017 183 3 0 180 33.26458973 -91.29539209 2020-07-08 05:33:48 Chicot, Arkansas, US
2020-07-07 US Arkansas Clark 5019 59 0 0 59 34.04613432 -93.17484713 2020-07-08 05:33:48 Clark, Arkansas, US
2020-07-07 US Arkansas Clay 5021 71 3 0 68 36.36826212 -90.4148172 2020-07-08 05:33:48 Clay, Arkansas, US
2020-07-07 US Arkansas Cleburne 5023 117 4 0 113 35.53864922 -92.02640019 2020-07-08 05:33:48 Cleburne, Arkansas, US
2020-07-07 US Arkansas Cleveland 5025 30 0 0 30 33.89723187 -92.18537045 2020-07-08 05:33:48 Cleveland, Arkansas, US
2020-07-07 US Arkansas Columbia 5027 90 4 0 86 33.21230701 -93.22642793 2020-07-08 05:33:48 Columbia, Arkansas, US
2020-07-07 US Arkansas Conway 5029 77 3 0 74 35.26205537 -92.70506566 2020-07-08 05:33:48 Conway, Arkansas, US
2020-07-07 US Arkansas Craighead 5031 485 7 0 478 35.83018283 -90.63235729 2020-07-08 05:33:48 Craighead, Arkansas, US
2020-07-07 US Arkansas Crawford 5033 218 1 0 217 35.58928601 -94.2446814 2020-07-08 05:33:48 Crawford, Arkansas, US
2020-07-07 US Arkansas Crittenden 5035 786 13 0 773 35.21247318 -90.30839406 2020-07-08 05:33:48 Crittenden, Arkansas, US
2020-07-07 US Arkansas Cross 5037 90 1 0 89 35.29631396 -90.77185818 2020-07-08 05:33:48 Cross, Arkansas, US
2020-07-07 US Arkansas Dallas 5039 10 0 0 10 33.97042763 -92.65167437 2020-07-08 05:33:48 Dallas, Arkansas, US
2020-07-07 US Arkansas Desha 5041 66 1 0 65 33.83011025 -91.25500948 2020-07-08 05:33:48 Desha, Arkansas, US
2020-07-07 US Arkansas Drew 5043 79 2 0 77 33.59035001 -91.71777921 2020-07-08 05:33:48 Drew, Arkansas, US
2020-07-07 US Arkansas Faulkner 5045 622 3 0 619 35.14719007 -92.33717519 2020-07-08 05:33:48 Faulkner, Arkansas, US
2020-07-07 US Arkansas Franklin 5047 27 1 0 26 35.51202821 -93.89299569 2020-07-08 05:33:48 Franklin, Arkansas, US
2020-07-07 US Arkansas Fulton 5049 16 0 0 16 36.38177105 -91.81729127 2020-07-08 05:33:48 Fulton, Arkansas, US
2020-07-07 US Arkansas Garland 5051 293 1 0 292 34.57692074 -93.14921604 2020-07-08 05:33:48 Garland, Arkansas, US
2020-07-07 US Arkansas Grant 5053 51 0 0 51 34.29017991 -92.42320562 2020-07-08 05:33:48 Grant, Arkansas, US
2020-07-07 US Arkansas Greene 5055 128 0 0 128 36.11735460000001 -90.55832668 2020-07-08 05:33:48 Greene, Arkansas, US
2020-07-07 US Arkansas Hempstead 5057 65 1 0 64 33.73325583 -93.66935133 2020-07-08 05:33:48 Hempstead, Arkansas, US
2020-07-07 US Arkansas Hot Spring 5059 587 1 0 586 34.31709259 -92.95396325 2020-07-08 05:33:48 Hot Spring, Arkansas, US
2020-07-07 US Arkansas Howard 5061 106 1 0 105 34.09007427 -93.9934871 2020-07-08 05:33:48 Howard, Arkansas, US
2020-07-07 US Arkansas Independence 5063 60 0 0 60 35.74242707 -91.57001641 2020-07-08 05:33:48 Independence, Arkansas, US
2020-07-07 US Arkansas Izard 5065 25 1 0 24 36.09604046 -91.90847954 2020-07-08 05:33:48 Izard, Arkansas, US
2020-07-07 US Arkansas Jackson 5067 35 0 0 35 35.59802983 -91.21494602 2020-07-08 05:33:48 Jackson, Arkansas, US
2020-07-07 US Arkansas Jefferson 5069 774 28 0 746 34.26767081 -91.92619839 2020-07-08 05:33:48 Jefferson, Arkansas, US
2020-07-07 US Arkansas Johnson 5071 281 0 0 281 35.56759135 -93.46036368 2020-07-08 05:33:48 Johnson, Arkansas, US
2020-07-07 US Arkansas Lafayette 5073 22 2 0 20 33.24116713 -93.60677071 2020-07-08 05:33:48 Lafayette, Arkansas, US
2020-07-07 US Arkansas Lawrence 5075 103 9 0 94 36.04188196 -91.10867198 2020-07-08 05:33:48 Lawrence, Arkansas, US
2020-07-07 US Arkansas Lee 5077 805 3 0 802 34.78498904 -90.78383866 2020-07-08 05:33:48 Lee, Arkansas, US
2020-07-07 US Arkansas Lincoln 5079 1044 11 0 1033 33.95317155 -91.74002806 2020-07-08 05:33:48 Lincoln, Arkansas, US
2020-07-07 US Arkansas Little River 5081 40 0 0 40 33.70375665 -94.23468591 2020-07-08 05:33:48 Little River, Arkansas, US
2020-07-07 US Arkansas Logan 5083 62 0 0 62 35.21413234 -93.71951016 2020-07-08 05:33:48 Logan, Arkansas, US
2020-07-07 US Arkansas Lonoke 5085 178 1 0 177 34.75392199 -91.88742357 2020-07-08 05:33:48 Lonoke, Arkansas, US
2020-07-07 US Arkansas Madison 5087 211 0 0 211 36.01038185 -93.72524943 2020-07-08 05:33:48 Madison, Arkansas, US
2020-07-07 US Arkansas Marion 5089 12 0 0 12 36.26844485 -92.68451899 2020-07-08 05:33:48 Marion, Arkansas, US
2020-07-07 US Arkansas Miller 5091 232 2 0 230 33.31403423 -93.89285258 2020-07-08 05:33:48 Miller, Arkansas, US
2020-07-07 US Arkansas Mississippi 5093 225 3 0 222 35.76271485 -90.05194370000002 2020-07-08 05:33:48 Mississippi, Arkansas, US
2020-07-07 US Arkansas Monroe 5095 17 0 0 17 34.6815935 -91.20540287 2020-07-08 05:33:48 Monroe, Arkansas, US
2020-07-07 US Arkansas Montgomery 5097 7 0 0 7 34.53704874 -93.65824478 2020-07-08 05:33:48 Montgomery, Arkansas, US
2020-07-07 US Arkansas Nevada 5099 104 3 0 101 33.66340119 -93.30632432 2020-07-08 05:33:48 Nevada, Arkansas, US
2020-07-07 US Arkansas Newton 5101 7 0 0 7 35.91947491 -93.21612969 2020-07-08 05:33:48 Newton, Arkansas, US
2020-07-07 US Arkansas Ouachita 5103 25 0 0 25 33.58839816 -92.87795984 2020-07-08 05:33:48 Ouachita, Arkansas, US
2020-07-07 US Arkansas Perry 5105 34 0 0 34 34.9459153 -92.94372564 2020-07-08 05:33:48 Perry, Arkansas, US
2020-07-07 US Arkansas Phillips 5107 159 5 0 154 34.43268455 -90.84800154 2020-07-08 05:33:48 Phillips, Arkansas, US
2020-07-07 US Arkansas Pike 5109 11 0 0 11 34.16250414 -93.65789349 2020-07-08 05:33:48 Pike, Arkansas, US
2020-07-07 US Arkansas Poinsett 5111 63 3 0 60 35.57433534 -90.66268713 2020-07-08 05:33:48 Poinsett, Arkansas, US
2020-07-07 US Arkansas Polk 5113 80 0 0 80 34.48254879 -94.22728802 2020-07-08 05:33:48 Polk, Arkansas, US
2020-07-07 US Arkansas Pope 5115 516 4 0 512 35.44871474 -93.03212219 2020-07-08 05:33:48 Pope, Arkansas, US
2020-07-07 US Arkansas Prairie 5117 22 0 0 22 34.83624419 -91.55162157 2020-07-08 05:33:48 Prairie, Arkansas, US
2020-07-07 US Arkansas Pulaski 5119 2522 62 0 2460 34.77054088 -92.31355101 2020-07-08 05:33:48 Pulaski, Arkansas, US
2020-07-07 US Arkansas Randolph 5121 56 1 0 55 36.3415714 -91.02455531 2020-07-08 05:33:48 Randolph, Arkansas, US
2020-07-07 US Arkansas Saline 5125 375 2 0 373 34.64916145 -92.67583224 2020-07-08 05:33:48 Saline, Arkansas, US
2020-07-07 US Arkansas Scott 5127 14 0 0 14 34.85588887 -94.0632176 2020-07-08 05:33:48 Scott, Arkansas, US
2020-07-07 US Arkansas Searcy 5129 12 0 0 12 35.9109364 -92.69936482 2020-07-08 05:33:48 Searcy, Arkansas, US
2020-07-07 US Arkansas Sebastian 5131 634 7 0 627 35.19605503 -94.27162713 2020-07-08 05:33:48 Sebastian, Arkansas, US
2020-07-07 US Arkansas Sevier 5133 758 9 0 749 33.99780401 -94.2424869 2020-07-08 05:33:48 Sevier, Arkansas, US
2020-07-07 US Arkansas Sharp 5135 56 5 0 51 36.16258158 -91.47819342 2020-07-08 05:33:48 Sharp, Arkansas, US
2020-07-07 US Arkansas St. Francis 5123 893 3 0 890 35.02201976 -90.74828138 2020-07-08 05:33:48 St. Francis, Arkansas, US
2020-07-07 US Arkansas Stone 5137 19 1 0 18 35.86251946 -92.15684085 2020-07-08 05:33:48 Stone, Arkansas, US
2020-07-07 US Arkansas Unassigned 90005 914 0 0 914 36.38177105 0.0 2020-07-08 05:33:48 Unassigned, Arkansas, US
2020-07-07 US Arkansas Union 5139 256 13 0 243 33.16887091 -92.59746952 2020-07-08 05:33:48 Union, Arkansas, US
2020-07-07 US Arkansas Van Buren 5141 34 2 0 32 35.58095779 -92.51295036 2020-07-08 05:33:48 Van Buren, Arkansas, US
2020-07-07 US Arkansas Washington 5143 4171 34 0 4137 35.976844 -94.21800746 2020-07-08 05:33:48 Washington, Arkansas, US
2020-07-07 US Arkansas White 5145 101 2 0 99 35.25688493 -91.74908296 2020-07-08 05:33:48 White, Arkansas, US
2020-07-07 US Arkansas Woodruff 5147 8 0 0 8 35.18902527 -91.2439489 2020-07-08 05:33:48 Woodruff, Arkansas, US
2020-07-07 US Arkansas Yell 5149 750 5 0 745 35.00292371 -93.41171338 2020-07-08 05:33:48 Yell, Arkansas, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;