johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where "day" is on date 2020-04-27 and province_or_state = "Arkansas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3586404 | 3586404 | 2020-04-27 | US | Arkansas | Arkansas | 5001 | 2 | 0 | 0 | 2 | 34.29145151 | -91.37277296 | 2020-04-28 02:30:51 | Arkansas, Arkansas, US |
3586414 | 3586414 | 2020-04-27 | US | Arkansas | Ashley | 5003 | 13 | 0 | 0 | 13 | 33.19153461 | -91.7698471 | 2020-04-28 02:30:51 | Ashley, Arkansas, US |
3586466 | 3586466 | 2020-04-27 | US | Arkansas | Baxter | 5005 | 5 | 0 | 0 | 5 | 36.28784385 | -92.33782872 | 2020-04-28 02:30:51 | Baxter, Arkansas, US |
3586490 | 3586490 | 2020-04-27 | US | Arkansas | Benton | 5007 | 94 | 0 | 0 | 94 | 36.33644656 | -94.25680817 | 2020-04-28 02:30:51 | Benton, Arkansas, US |
3586536 | 3586536 | 2020-04-27 | US | Arkansas | Boone | 5009 | 5 | 0 | 0 | 5 | 36.3084504 | -93.09374925 | 2020-04-28 02:30:51 | Boone, Arkansas, US |
3586558 | 3586558 | 2020-04-27 | US | Arkansas | Bradley | 5011 | 8 | 1 | 0 | 7 | 33.46755808 | -92.15980837 | 2020-04-28 02:30:51 | Bradley, Arkansas, US |
3586677 | 3586677 | 2020-04-27 | US | Arkansas | Carroll | 5015 | 4 | 0 | 0 | 4 | 36.34038560000001 | -93.54270261 | 2020-04-28 02:30:51 | Carroll, Arkansas, US |
3586772 | 3586772 | 2020-04-27 | US | Arkansas | Chicot | 5017 | 9 | 0 | 0 | 9 | 33.26458973 | -91.29539209 | 2020-04-28 02:30:51 | Chicot, Arkansas, US |
3586799 | 3586799 | 2020-04-27 | US | Arkansas | Clark | 5019 | 27 | 0 | 0 | 27 | 34.04613432 | -93.17484713 | 2020-04-28 02:30:51 | Clark, Arkansas, US |
3586817 | 3586817 | 2020-04-27 | US | Arkansas | Clay | 5021 | 2 | 0 | 0 | 2 | 36.36826212 | -90.4148172 | 2020-04-28 02:30:51 | Clay, Arkansas, US |
3586839 | 3586839 | 2020-04-27 | US | Arkansas | Cleburne | 5023 | 72 | 4 | 0 | 68 | 35.53864922 | -92.02640019 | 2020-04-28 02:30:51 | Cleburne, Arkansas, US |
3586841 | 3586841 | 2020-04-27 | US | Arkansas | Cleveland | 5025 | 10 | 0 | 0 | 10 | 33.89723187 | -92.18537045 | 2020-04-28 02:30:51 | Cleveland, Arkansas, US |
3586878 | 3586878 | 2020-04-27 | US | Arkansas | Columbia | 5027 | 9 | 0 | 0 | 9 | 33.21230701 | -93.22642793 | 2020-04-28 02:30:51 | Columbia, Arkansas, US |
3586897 | 3586897 | 2020-04-27 | US | Arkansas | Conway | 5029 | 12 | 1 | 0 | 11 | 35.26205537 | -92.70506566 | 2020-04-28 02:30:51 | Conway, Arkansas, US |
3586922 | 3586922 | 2020-04-27 | US | Arkansas | Craighead | 5031 | 68 | 0 | 0 | 68 | 35.83018283 | -90.63235729 | 2020-04-28 02:30:51 | Craighead, Arkansas, US |
3586925 | 3586925 | 2020-04-27 | US | Arkansas | Crawford | 5033 | 4 | 0 | 0 | 4 | 35.58928601 | -94.2446814 | 2020-04-28 02:30:51 | Crawford, Arkansas, US |
3586939 | 3586939 | 2020-04-27 | US | Arkansas | Crittenden | 5035 | 174 | 5 | 0 | 169 | 35.21247318 | -90.30839406 | 2020-04-28 02:30:51 | Crittenden, Arkansas, US |
3586945 | 3586945 | 2020-04-27 | US | Arkansas | Cross | 5037 | 16 | 0 | 0 | 16 | 35.29631396 | -90.77185818 | 2020-04-28 02:30:51 | Cross, Arkansas, US |
3586973 | 3586973 | 2020-04-27 | US | Arkansas | Dallas | 5039 | 1 | 0 | 0 | 1 | 33.97042763 | -92.65167437 | 2020-04-28 02:30:51 | Dallas, Arkansas, US |
3587028 | 3587028 | 2020-04-27 | US | Arkansas | Desha | 5041 | 16 | 0 | 0 | 16 | 33.83011025 | -91.25500948 | 2020-04-28 02:30:51 | Desha, Arkansas, US |
3587066 | 3587066 | 2020-04-27 | US | Arkansas | Drew | 5043 | 13 | 1 | 0 | 12 | 33.59035001 | -91.71777921 | 2020-04-28 02:30:51 | Drew, Arkansas, US |
3587143 | 3587143 | 2020-04-27 | US | Arkansas | Faulkner | 5045 | 75 | 2 | 0 | 73 | 35.14719007 | -92.33717519 | 2020-04-28 02:30:51 | Faulkner, Arkansas, US |
3587184 | 3587184 | 2020-04-27 | US | Arkansas | Franklin | 5047 | 2 | 0 | 0 | 2 | 35.51202821 | -93.89299569 | 2020-04-28 02:30:51 | Franklin, Arkansas, US |
3587218 | 3587218 | 2020-04-27 | US | Arkansas | Fulton | 5049 | 1 | 0 | 0 | 1 | 36.38177105 | -91.81729127 | 2020-04-28 02:30:51 | Fulton, Arkansas, US |
3587239 | 3587239 | 2020-04-27 | US | Arkansas | Garland | 5051 | 114 | 0 | 0 | 114 | 34.57692074 | -93.14921604 | 2020-04-28 02:30:51 | Garland, Arkansas, US |
3587292 | 3587292 | 2020-04-27 | US | Arkansas | Grant | 5053 | 12 | 0 | 0 | 12 | 34.29017991 | -92.42320562 | 2020-04-28 02:30:51 | Grant, Arkansas, US |
3587319 | 3587319 | 2020-04-27 | US | Arkansas | Greene | 5055 | 16 | 0 | 0 | 16 | 36.11735460000001 | -90.55832668 | 2020-04-28 02:30:51 | Greene, Arkansas, US |
3587429 | 3587429 | 2020-04-27 | US | Arkansas | Hempstead | 5057 | 5 | 1 | 0 | 4 | 33.73325583 | -93.66935133 | 2020-04-28 02:30:51 | Hempstead, Arkansas, US |
3587480 | 3587480 | 2020-04-27 | US | Arkansas | Hot Spring | 5059 | 10 | 0 | 0 | 10 | 34.31709259 | -92.95396325 | 2020-04-28 02:30:51 | Hot Spring, Arkansas, US |
3587488 | 3587488 | 2020-04-27 | US | Arkansas | Howard | 5061 | 13 | 0 | 0 | 13 | 34.09007427 | -93.9934871 | 2020-04-28 02:30:51 | Howard, Arkansas, US |
3587518 | 3587518 | 2020-04-27 | US | Arkansas | Independence | 5063 | 9 | 0 | 0 | 9 | 35.74242707 | -91.57001641 | 2020-04-28 02:30:51 | Independence, Arkansas, US |
3587538 | 3587538 | 2020-04-27 | US | Arkansas | Izard | 5065 | 5 | 0 | 0 | 5 | 36.09604046 | -91.90847954 | 2020-04-28 02:30:51 | Izard, Arkansas, US |
3587541 | 3587541 | 2020-04-27 | US | Arkansas | Jackson | 5067 | 1 | 0 | 0 | 1 | 35.59802983 | -91.21494602 | 2020-04-28 02:30:51 | Jackson, Arkansas, US |
3587574 | 3587574 | 2020-04-27 | US | Arkansas | Jefferson | 5069 | 160 | 9 | 0 | 151 | 34.26767081 | -91.92619839 | 2020-04-28 02:30:51 | Jefferson, Arkansas, US |
3587611 | 3587611 | 2020-04-27 | US | Arkansas | Johnson | 5071 | 30 | 0 | 0 | 30 | 35.56759135 | -93.46036368 | 2020-04-28 02:30:51 | Johnson, Arkansas, US |
3587706 | 3587706 | 2020-04-27 | US | Arkansas | Lafayette | 5073 | 7 | 1 | 0 | 6 | 33.24116713 | -93.60677071 | 2020-04-28 02:30:51 | Lafayette, Arkansas, US |
3587752 | 3587752 | 2020-04-27 | US | Arkansas | Lawrence | 5075 | 43 | 1 | 0 | 42 | 36.04188196 | -91.10867198 | 2020-04-28 02:30:51 | Lawrence, Arkansas, US |
3587768 | 3587768 | 2020-04-27 | US | Arkansas | Lee | 5077 | 3 | 1 | 0 | 2 | 34.78498904 | -90.78383866 | 2020-04-28 02:30:51 | Lee, Arkansas, US |
3587806 | 3587806 | 2020-04-27 | US | Arkansas | Lincoln | 5079 | 754 | 0 | 0 | 754 | 33.95317155 | -91.74002806 | 2020-04-28 02:30:51 | Lincoln, Arkansas, US |
3587841 | 3587841 | 2020-04-27 | US | Arkansas | Logan | 5083 | 3 | 0 | 0 | 3 | 35.21413234 | -93.71951016 | 2020-04-28 02:30:51 | Logan, Arkansas, US |
3587850 | 3587850 | 2020-04-27 | US | Arkansas | Lonoke | 5085 | 39 | 0 | 0 | 39 | 34.75392199 | -91.88742357 | 2020-04-28 02:30:51 | Lonoke, Arkansas, US |
3587889 | 3587889 | 2020-04-27 | US | Arkansas | Madison | 5087 | 1 | 0 | 0 | 1 | 36.01038185 | -93.72524943 | 2020-04-28 02:30:51 | Madison, Arkansas, US |
3587925 | 3587925 | 2020-04-27 | US | Arkansas | Marion | 5089 | 1 | 0 | 0 | 1 | 36.26844485 | -92.68451899 | 2020-04-28 02:30:51 | Marion, Arkansas, US |
3588048 | 3588048 | 2020-04-27 | US | Arkansas | Miller | 5091 | 33 | 1 | 0 | 32 | 33.31403423 | -93.89285258 | 2020-04-28 02:30:51 | Miller, Arkansas, US |
3588061 | 3588061 | 2020-04-27 | US | Arkansas | Mississippi | 5093 | 13 | 0 | 0 | 13 | 35.76271485 | -90.05194370000002 | 2020-04-28 02:30:51 | Mississippi, Arkansas, US |
3588078 | 3588078 | 2020-04-27 | US | Arkansas | Monroe | 5095 | 4 | 0 | 0 | 4 | 34.6815935 | -91.20540287 | 2020-04-28 02:30:51 | Monroe, Arkansas, US |
3588097 | 3588097 | 2020-04-27 | US | Arkansas | Montgomery | 5097 | 0 | 0 | 0 | 0 | 34.53704874 | -93.65824478 | 2020-04-28 02:30:51 | Montgomery, Arkansas, US |
3588173 | 3588173 | 2020-04-27 | US | Arkansas | Nevada | 5099 | 1 | 0 | 0 | 1 | 33.66340119 | -93.30632432 | 2020-04-28 02:30:51 | Nevada, Arkansas, US |
3588186 | 3588186 | 2020-04-27 | US | Arkansas | Newton | 5101 | 3 | 0 | 0 | 3 | 35.91947491 | -93.21612969 | 2020-04-28 02:30:51 | Newton, Arkansas, US |
3588284 | 3588284 | 2020-04-27 | US | Arkansas | Ouachita | 5103 | 6 | 0 | 0 | 6 | 33.58839816 | -92.87795984 | 2020-04-28 02:30:51 | Ouachita, Arkansas, US |
3588339 | 3588339 | 2020-04-27 | US | Arkansas | Perry | 5105 | 6 | 0 | 0 | 6 | 34.9459153 | -92.94372564 | 2020-04-28 02:30:51 | Perry, Arkansas, US |
3588356 | 3588356 | 2020-04-27 | US | Arkansas | Phillips | 5107 | 5 | 1 | 0 | 4 | 34.43268455 | -90.84800154 | 2020-04-28 02:30:51 | Phillips, Arkansas, US |
3588370 | 3588370 | 2020-04-27 | US | Arkansas | Pike | 5109 | 3 | 0 | 0 | 3 | 34.16250414 | -93.65789349 | 2020-04-28 02:30:51 | Pike, Arkansas, US |
3588400 | 3588400 | 2020-04-27 | US | Arkansas | Poinsett | 5111 | 18 | 0 | 0 | 18 | 35.57433534 | -90.66268713 | 2020-04-28 02:30:51 | Poinsett, Arkansas, US |
3588402 | 3588402 | 2020-04-27 | US | Arkansas | Polk | 5113 | 8 | 0 | 0 | 8 | 34.48254879 | -94.22728802 | 2020-04-28 02:30:51 | Polk, Arkansas, US |
3588417 | 3588417 | 2020-04-27 | US | Arkansas | Pope | 5115 | 42 | 0 | 0 | 42 | 35.44871474 | -93.03212219 | 2020-04-28 02:30:51 | Pope, Arkansas, US |
3588433 | 3588433 | 2020-04-27 | US | Arkansas | Prairie | 5117 | 2 | 0 | 0 | 2 | 34.83624419 | -91.55162157 | 2020-04-28 02:30:51 | Prairie, Arkansas, US |
3588448 | 3588448 | 2020-04-27 | US | Arkansas | Pulaski | 5119 | 484 | 15 | 0 | 469 | 34.77054088 | -92.31355101 | 2020-04-28 02:30:51 | Pulaski, Arkansas, US |
3588477 | 3588477 | 2020-04-27 | US | Arkansas | Randolph | 5121 | 16 | 0 | 0 | 16 | 36.3415714 | -91.02455531 | 2020-04-28 02:30:51 | Randolph, Arkansas, US |
3588570 | 3588570 | 2020-04-27 | US | Arkansas | Saline | 5125 | 56 | 1 | 0 | 55 | 34.64916145 | -92.67583224 | 2020-04-28 02:30:51 | Saline, Arkansas, US |
3588622 | 3588622 | 2020-04-27 | US | Arkansas | Scott | 5127 | 1 | 0 | 0 | 1 | 34.85588887 | -94.0632176 | 2020-04-28 02:30:51 | Scott, Arkansas, US |
3588635 | 3588635 | 2020-04-27 | US | Arkansas | Searcy | 5129 | 6 | 0 | 0 | 6 | 35.9109364 | -92.69936482 | 2020-04-28 02:30:51 | Searcy, Arkansas, US |
3588636 | 3588636 | 2020-04-27 | US | Arkansas | Sebastian | 5131 | 12 | 0 | 0 | 12 | 35.19605503 | -94.27162713 | 2020-04-28 02:30:51 | Sebastian, Arkansas, US |
3588645 | 3588645 | 2020-04-27 | US | Arkansas | Sevier | 5133 | 11 | 0 | 0 | 11 | 33.99780401 | -94.2424869 | 2020-04-28 02:30:51 | Sevier, Arkansas, US |
3588650 | 3588650 | 2020-04-27 | US | Arkansas | Sharp | 5135 | 3 | 0 | 0 | 3 | 36.16258158 | -91.47819342 | 2020-04-28 02:30:51 | Sharp, Arkansas, US |
3588718 | 3588718 | 2020-04-27 | US | Arkansas | St. Francis | 5123 | 81 | 0 | 0 | 81 | 35.02201976 | -90.74828138 | 2020-04-28 02:30:51 | St. Francis, Arkansas, US |
3588765 | 3588765 | 2020-04-27 | US | Arkansas | Stone | 5137 | 7 | 0 | 0 | 7 | 35.86251946 | -92.15684085 | 2020-04-28 02:30:51 | Stone, Arkansas, US |
3588894 | 3588894 | 2020-04-27 | US | Arkansas | Unassigned | 90005 | 203 | 0 | 0 | 203 | 36.38177105 | 0.0 | 2020-04-28 02:30:51 | Unassigned, Arkansas, US |
3588942 | 3588942 | 2020-04-27 | US | Arkansas | Union | 5139 | 38 | 0 | 0 | 38 | 33.16887091 | -92.59746952 | 2020-04-28 02:30:51 | Union, Arkansas, US |
3588969 | 3588969 | 2020-04-27 | US | Arkansas | Van Buren | 5141 | 27 | 2 | 0 | 25 | 35.58095779 | -92.51295036 | 2020-04-28 02:30:51 | Van Buren, Arkansas, US |
3589035 | 3589035 | 2020-04-27 | US | Arkansas | Washington | 5143 | 77 | 3 | 0 | 74 | 35.976844 | -94.21800746 | 2020-04-28 02:30:51 | Washington, Arkansas, US |
3589111 | 3589111 | 2020-04-27 | US | Arkansas | White | 5145 | 31 | 1 | 0 | 30 | 35.25688493 | -91.74908296 | 2020-04-28 02:30:51 | White, Arkansas, US |
3589168 | 3589168 | 2020-04-27 | US | Arkansas | Woodruff | 5147 | 1 | 0 | 0 | 1 | 35.18902527 | -91.2439489 | 2020-04-28 02:30:51 | Woodruff, Arkansas, US |
3589194 | 3589194 | 2020-04-27 | US | Arkansas | Yell | 5149 | 3 | 0 | 0 | 3 | 35.00292371 | -93.41171338 | 2020-04-28 02:30:51 | Yell, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);