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 = "2022-05-12" 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
2022-05-12 US Arkansas Arkansas 5001 5695 79 0   34.29145151 -91.37277296 2022-05-13 04:20:51 Arkansas, Arkansas, US
2022-05-12 US Arkansas Ashley 5003 5114 66 0   33.19153461 -91.7698471 2022-05-13 04:20:51 Ashley, Arkansas, US
2022-05-12 US Arkansas Baxter 5005 8847 247 0   36.28784385 -92.33782872 2022-05-13 04:20:51 Baxter, Arkansas, US
2022-05-12 US Arkansas Benton 5007 67077 849 0   36.33644656 -94.25680817 2022-05-13 04:20:51 Benton, Arkansas, US
2022-05-12 US Arkansas Boone 5009 9465 179 0   36.3084504 -93.09374925 2022-05-13 04:20:51 Boone, Arkansas, US
2022-05-12 US Arkansas Bradley 5011 2997 49 0   33.46755808 -92.15980837 2022-05-13 04:20:51 Bradley, Arkansas, US
2022-05-12 US Arkansas Calhoun 5013 965 10 0   33.55598792 -92.49974403 2022-05-13 04:20:51 Calhoun, Arkansas, US
2022-05-12 US Arkansas Carroll 5015 6133 102 0   36.3403856 -93.54270261 2022-05-13 04:20:51 Carroll, Arkansas, US
2022-05-12 US Arkansas Chicot 5017 2778 60 0   33.26458973 -91.29539209 2022-05-13 04:20:51 Chicot, Arkansas, US
2022-05-12 US Arkansas Clark 5019 5377 79 0   34.04613432 -93.17484713 2022-05-13 04:20:51 Clark, Arkansas, US
2022-05-12 US Arkansas Clay 5021 4154 93 0   36.36826212 -90.4148172 2022-05-13 04:20:51 Clay, Arkansas, US
2022-05-12 US Arkansas Cleburne 5023 6465 128 0   35.53864922 -92.02640019 2022-05-13 04:20:51 Cleburne, Arkansas, US
2022-05-12 US Arkansas Cleveland 5025 2269 36 0   33.89723187 -92.18537045 2022-05-13 04:20:51 Cleveland, Arkansas, US
2022-05-12 US Arkansas Columbia 5027 5436 95 0   33.21230701 -93.22642793 2022-05-13 04:20:51 Columbia, Arkansas, US
2022-05-12 US Arkansas Conway 5029 5489 65 0   35.26205537 -92.70506566 2022-05-13 04:20:51 Conway, Arkansas, US
2022-05-12 US Arkansas Craighead 5031 37757 329 0   35.83018283 -90.63235729 2022-05-13 04:20:51 Craighead, Arkansas, US
2022-05-12 US Arkansas Crawford 5033 15879 249 0   35.58928601 -94.2446814 2022-05-13 04:20:51 Crawford, Arkansas, US
2022-05-12 US Arkansas Crittenden 5035 14311 226 0   35.21247318 -90.30839406 2022-05-13 04:20:51 Crittenden, Arkansas, US
2022-05-12 US Arkansas Cross 5037 4835 83 0   35.29631396 -90.77185818 2022-05-13 04:20:51 Cross, Arkansas, US
2022-05-12 US Arkansas Dallas 5039 1746 31 0   33.97042763 -92.65167437 2022-05-13 04:20:51 Dallas, Arkansas, US
2022-05-12 US Arkansas Desha 5041 3030 41 0   33.83011025 -91.25500948 2022-05-13 04:20:51 Desha, Arkansas, US
2022-05-12 US Arkansas Drew 5043 4686 70 0   33.59035001 -91.71777921 2022-05-13 04:20:51 Drew, Arkansas, US
2022-05-12 US Arkansas Faulkner 5045 35234 316 0   35.14719007 -92.33717519 2022-05-13 04:20:51 Faulkner, Arkansas, US
2022-05-12 US Arkansas Franklin 5047 3817 73 0   35.51202821 -93.89299569 2022-05-13 04:20:51 Franklin, Arkansas, US
2022-05-12 US Arkansas Fulton 5049 2696 90 0   36.38177105 -91.81729127 2022-05-13 04:20:51 Fulton, Arkansas, US
2022-05-12 US Arkansas Garland 5051 23358 510 0   34.57692074 -93.14921604 2022-05-13 04:20:51 Garland, Arkansas, US
2022-05-12 US Arkansas Grant 5053 4466 61 0   34.29017991 -92.42320562 2022-05-13 04:20:51 Grant, Arkansas, US
2022-05-12 US Arkansas Greene 5055 16079 173 0   36.1173546 -90.55832668 2022-05-13 04:20:51 Greene, Arkansas, US
2022-05-12 US Arkansas Hempstead 5057 4569 68 0   33.73325583 -93.66935133 2022-05-13 04:20:51 Hempstead, Arkansas, US
2022-05-12 US Arkansas Hot Spring 5059 11227 136 0   34.31709259 -92.95396325 2022-05-13 04:20:51 Hot Spring, Arkansas, US
2022-05-12 US Arkansas Howard 5061 3763 50 0   34.09007427 -93.9934871 2022-05-13 04:20:51 Howard, Arkansas, US
2022-05-12 US Arkansas Independence 5063 10637 212 0   35.74242707 -91.57001641 2022-05-13 04:20:51 Independence, Arkansas, US
2022-05-12 US Arkansas Izard 5065 3904 70 0   36.09604046 -91.90847954 2022-05-13 04:20:51 Izard, Arkansas, US
2022-05-12 US Arkansas Jackson 5067 6134 63 0   35.59802983 -91.21494602 2022-05-13 04:20:51 Jackson, Arkansas, US
2022-05-12 US Arkansas Jefferson 5069 18608 277 0   34.26767081 -91.92619839 2022-05-13 04:20:51 Jefferson, Arkansas, US
2022-05-12 US Arkansas Johnson 5071 6828 87 0   35.56759135 -93.46036368 2022-05-13 04:20:51 Johnson, Arkansas, US
2022-05-12 US Arkansas Lafayette 5073 1298 31 0   33.24116713 -93.60677071 2022-05-13 04:20:51 Lafayette, Arkansas, US
2022-05-12 US Arkansas Lawrence 5075 5319 78 0   36.04188196 -91.10867198 2022-05-13 04:20:51 Lawrence, Arkansas, US
2022-05-12 US Arkansas Lee 5077 2912 59 0   34.78498904 -90.78383866 2022-05-13 04:20:51 Lee, Arkansas, US
2022-05-12 US Arkansas Lincoln 5079 4919 68 0   33.95317155 -91.74002806 2022-05-13 04:20:51 Lincoln, Arkansas, US
2022-05-12 US Arkansas Little River 5081 3280 104 0   33.70375665 -94.23468591 2022-05-13 04:20:51 Little River, Arkansas, US
2022-05-12 US Arkansas Logan 5083 5130 80 0   35.21413234 -93.71951016 2022-05-13 04:20:51 Logan, Arkansas, US
2022-05-12 US Arkansas Lonoke 5085 19946 243 0   34.75392199 -91.88742357 2022-05-13 04:20:51 Lonoke, Arkansas, US
2022-05-12 US Arkansas Madison 5087 3975 61 0   36.01038185 -93.72524943 2022-05-13 04:20:51 Madison, Arkansas, US
2022-05-12 US Arkansas Marion 5089 3408 88 0   36.26844485 -92.68451899 2022-05-13 04:20:51 Marion, Arkansas, US
2022-05-12 US Arkansas Miller 5091 9595 181 0   33.31403423 -93.89285258 2022-05-13 04:20:51 Miller, Arkansas, US
2022-05-12 US Arkansas Mississippi 5093 13605 210 0   35.76271485 -90.0519437 2022-05-13 04:20:51 Mississippi, Arkansas, US
2022-05-12 US Arkansas Monroe 5095 1936 35 0   34.6815935 -91.20540287 2022-05-13 04:20:51 Monroe, Arkansas, US
2022-05-12 US Arkansas Montgomery 5097 1525 57 0   34.53704874 -93.65824478 2022-05-13 04:20:51 Montgomery, Arkansas, US
2022-05-12 US Arkansas Nevada 5099 2187 46 0   33.66340119 -93.30632432 2022-05-13 04:20:51 Nevada, Arkansas, US
2022-05-12 US Arkansas Newton 5101 1719 47 0   35.91947491 -93.21612969 2022-05-13 04:20:51 Newton, Arkansas, US
2022-05-12 US Arkansas Ouachita 5103 5483 104 0   33.58839816 -92.87795984 2022-05-13 04:20:51 Ouachita, Arkansas, US
2022-05-12 US Arkansas Perry 5105 2523 37 0   34.9459153 -92.94372564 2022-05-13 04:20:51 Perry, Arkansas, US
2022-05-12 US Arkansas Phillips 5107 4829 99 0   34.43268455 -90.84800154 2022-05-13 04:20:51 Phillips, Arkansas, US
2022-05-12 US Arkansas Pike 5109 2617 44 0   34.16250414 -93.65789349 2022-05-13 04:20:51 Pike, Arkansas, US
2022-05-12 US Arkansas Poinsett 5111 8051 127 0   35.57433534 -90.66268713 2022-05-13 04:20:51 Poinsett, Arkansas, US
2022-05-12 US Arkansas Polk 5113 4146 149 0   34.48254879 -94.22728802 2022-05-13 04:20:51 Polk, Arkansas, US
2022-05-12 US Arkansas Pope 5115 18453 210 0   35.44871474 -93.03212219 2022-05-13 04:20:51 Pope, Arkansas, US
2022-05-12 US Arkansas Prairie 5117 1964 43 0   34.83624419 -91.55162157 2022-05-13 04:20:51 Prairie, Arkansas, US
2022-05-12 US Arkansas Pulaski 5119 103899 1186 0   34.77054088 -92.31355101 2022-05-13 04:20:51 Pulaski, Arkansas, US
2022-05-12 US Arkansas Randolph 5121 5215 89 0   36.3415714 -91.02455531 2022-05-13 04:20:51 Randolph, Arkansas, US
2022-05-12 US Arkansas Saline 5125 31011 339 0   34.64916145 -92.67583224 2022-05-13 04:20:51 Saline, Arkansas, US
2022-05-12 US Arkansas Scott 5127 2298 43 0   34.85588887 -94.0632176 2022-05-13 04:20:51 Scott, Arkansas, US
2022-05-12 US Arkansas Searcy 5129 2126 48 0   35.9109364 -92.69936482 2022-05-13 04:20:51 Searcy, Arkansas, US
2022-05-12 US Arkansas Sebastian 5131 32830 526 0   35.19605503 -94.27162713 2022-05-13 04:20:51 Sebastian, Arkansas, US
2022-05-12 US Arkansas Sevier 5133 5942 75 0   33.99780401 -94.2424869 2022-05-13 04:20:51 Sevier, Arkansas, US
2022-05-12 US Arkansas Sharp 5135 4638 105 0   36.16258158 -91.47819342 2022-05-13 04:20:51 Sharp, Arkansas, US
2022-05-12 US Arkansas St. Francis 5123 7170 96 0   35.02201976 -90.74828138 2022-05-13 04:20:51 St. Francis, Arkansas, US
2022-05-12 US Arkansas Stone 5137 2917 68 0   35.86251946 -92.15684085 2022-05-13 04:20:51 Stone, Arkansas, US
2022-05-12 US Arkansas Unassigned 90005 27000 0 0   36.38177105 0.0 2022-05-13 04:20:51 Unassigned, Arkansas, US
2022-05-12 US Arkansas Union 5139 9267 176 0   33.16887091 -92.59746952 2022-05-13 04:20:51 Union, Arkansas, US
2022-05-12 US Arkansas Van Buren 5141 3489 62 0   35.58095779 -92.51295036 2022-05-13 04:20:51 Van Buren, Arkansas, US
2022-05-12 US Arkansas Washington 5143 68783 620 0   35.976844 -94.21800746 2022-05-13 04:20:51 Washington, Arkansas, US
2022-05-12 US Arkansas White 5145 22157 292 0   35.25688493 -91.74908296 2022-05-13 04:20:51 White, Arkansas, US
2022-05-12 US Arkansas Woodruff 5147 1731 31 0   35.18902527 -91.2439489 2022-05-13 04:20:51 Woodruff, Arkansas, US
2022-05-12 US Arkansas Yell 5149 6859 106 0   35.00292371 -93.41171338 2022-05-13 04:20:51 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;