Splunk Cluster Map用のデータを用意する

[Maps+ for Splunk](https://splunkbase.splunk.com/app/3124/#/overview)があれば、あんまり気にしなくてもいいけど、見つけました。

https://developers.google.com/public-data/docs/canonical/countries_csv

```sql:country_lookup_create.spl
| makeresults
| eval _raw="
country,latitude,longitude,name
AD,42.546245,1.601554,Andorra
AE,23.424076,53.847818,United,Arab,Emirates
AF,33.93911,67.709953,Afghanistan
AG,17.060816,-61.796428,Antigua,and,Barbuda
AI,18.220554,-63.068615,Anguilla
AL,41.153332,20.168331,Albania
AM,40.069099,45.038189,Armenia
AN,12.226079,-69.060087,Netherlands,Antilles
AO,-11.202692,17.873887,Angola
AQ,-75.250973,-0.071389,Antarctica
AR,-38.416097,-63.616672,Argentina
AS,-14.270972,-170.132217,American,Samoa
AT,47.516231,14.550072,Austria
AU,-25.274398,133.775136,Australia
AW,12.52111,-69.968338,Aruba
AZ,40.143105,47.576927,Azerbaijan
BA,43.915886,17.679076,Bosnia,and,Herzegovina
BB,13.193887,-59.543198,Barbados
BD,23.684994,90.356331,Bangladesh
BE,50.503887,4.469936,Belgium
BF,12.238333,-1.561593,Burkina,Faso
BG,42.733883,25.48583,Bulgaria
BH,25.930414,50.637772,Bahrain
BI,-3.373056,29.918886,Burundi
BJ,9.30769,2.315834,Benin
BM,32.321384,-64.75737,Bermuda
BN,4.535277,114.727669,Brunei
BO,-16.290154,-63.588653,Bolivia
BR,-14.235004,-51.92528,Brazil
BS,25.03428,-77.39628,Bahamas
BT,27.514162,90.433601,Bhutan
BV,-54.423199,3.413194,Bouvet,Island
BW,-22.328474,24.684866,Botswana
BY,53.709807,27.953389,Belarus
BZ,17.189877,-88.49765,Belize
CA,56.130366,-106.346771,Canada
CC,-12.164165,96.870956,Cocos,[Keeling],Islands
CD,-4.038333,21.758664,Congo,[DRC]
CF,6.611111,20.939444,Central,African,Republic
CG,-0.228021,15.827659,Congo,[Republic]
CH,46.818188,8.227512,Switzerland
CI,7.539989,-5.54708,Côte,d'Ivoire
CK,-21.236736,-159.777671,Cook,Islands
CL,-35.675147,-71.542969,Chile
CM,7.369722,12.354722,Cameroon
CN,35.86166,104.195397,China
CO,4.570868,-74.297333,Colombia
CR,9.748917,-83.753428,Costa,Rica
CU,21.521757,-77.781167,Cuba
CV,16.002082,-24.013197,Cape,Verde
CX,-10.447525,105.690449,Christmas,Island
CY,35.126413,33.429859,Cyprus
CZ,49.817492,15.472962,Czech,Republic
DE,51.165691,10.451526,Germany
DJ,11.825138,42.590275,Djibouti
DK,56.26392,9.501785,Denmark
DM,15.414999,-61.370976,Dominica
DO,18.735693,-70.162651,Dominican,Republic
DZ,28.033886,1.659626,Algeria
EC,-1.831239,-78.183406,Ecuador
EE,58.595272,25.013607,Estonia
EG,26.820553,30.802498,Egypt
EH,24.215527,-12.885834,Western,Sahara
ER,15.179384,39.782334,Eritrea
ES,40.463667,-3.74922,Spain
ET,9.145,40.489673,Ethiopia
FI,61.92411,25.748151,Finland
FJ,-16.578193,179.414413,Fiji
FK,-51.796253,-59.523613,Falkland,Islands,[Islas,Malvinas]
FM,7.425554,150.550812,Micronesia
FO,61.892635,-6.911806,Faroe,Islands
FR,46.227638,2.213749,France
GA,-0.803689,11.609444,Gabon
GB,55.378051,-3.435973,United,Kingdom
GD,12.262776,-61.604171,Grenada
GE,42.315407,43.356892,Georgia
GF,3.933889,-53.125782,French,Guiana
GG,49.465691,-2.585278,Guernsey
GH,7.946527,-1.023194,Ghana
GI,36.137741,-5.345374,Gibraltar
GL,71.706936,-42.604303,Greenland
GM,13.443182,-15.310139,Gambia
GN,9.945587,-9.696645,Guinea
GP,16.995971,-62.067641,Guadeloupe
GQ,1.650801,10.267895,Equatorial,Guinea
GR,39.074208,21.824312,Greece
GS,-54.429579,-36.587909,South,Georgia,and,the,South,Sandwich,Islands
GT,15.783471,-90.230759,Guatemala
GU,13.444304,144.793731,Guam
GW,11.803749,-15.180413,Guinea-Bissau
GY,4.860416,-58.93018,Guyana
GZ,31.354676,34.308825,Gaza,Strip
HK,22.396428,114.109497,Hong,Kong
HM,-53.08181,73.504158,Heard,Island,and,McDonald,Islands
HN,15.199999,-86.241905,Honduras
HR,45.1,15.2,Croatia
HT,18.971187,-72.285215,Haiti
HU,47.162494,19.503304,Hungary
ID,-0.789275,113.921327,Indonesia
IE,53.41291,-8.24389,Ireland
IL,31.046051,34.851612,Israel
IM,54.236107,-4.548056,Isle,of,Man
IN,20.593684,78.96288,India
IO,-6.343194,71.876519,British,Indian,Ocean,Territory
IQ,33.223191,43.679291,Iraq
IR,32.427908,53.688046,Iran
IS,64.963051,-19.020835,Iceland
IT,41.87194,12.56738,Italy
JE,49.214439,-2.13125,Jersey
JM,18.109581,-77.297508,Jamaica
JO,30.585164,36.238414,Jordan
JP,36.204824,138.252924,Japan
KE,-0.023559,37.906193,Kenya
KG,41.20438,74.766098,Kyrgyzstan
KH,12.565679,104.990963,Cambodia
KI,-3.370417,-168.734039,Kiribati
KM,-11.875001,43.872219,Comoros
KN,17.357822,-62.782998,Saint,Kitts,and,Nevis
KP,40.339852,127.510093,North,Korea
KR,35.907757,127.766922,South,Korea
KW,29.31166,47.481766,Kuwait
KY,19.513469,-80.566956,Cayman,Islands
KZ,48.019573,66.923684,Kazakhstan
LA,19.85627,102.495496,Laos
LB,33.854721,35.862285,Lebanon
LC,13.909444,-60.978893,Saint,Lucia
LI,47.166,9.555373,Liechtenstein
LK,7.873054,80.771797,Sri,Lanka
LR,6.428055,-9.429499,Liberia
LS,-29.609988,28.233608,Lesotho
LT,55.169438,23.881275,Lithuania
LU,49.815273,6.129583,Luxembourg
LV,56.879635,24.603189,Latvia
LY,26.3351,17.228331,Libya
MA,31.791702,-7.09262,Morocco
MC,43.750298,7.412841,Monaco
MD,47.411631,28.369885,Moldova
ME,42.708678,19.37439,Montenegro
MG,-18.766947,46.869107,Madagascar
MH,7.131474,171.184478,Marshall,Islands
MK,41.608635,21.745275,Macedonia,[FYROM]
ML,17.570692,-3.996166,Mali
MM,21.913965,95.956223,Myanmar,[Burma]
MN,46.862496,103.846656,Mongolia
MO,22.198745,113.543873,Macau
MP,17.33083,145.38469,Northern,Mariana,Islands
MQ,14.641528,-61.024174,Martinique
MR,21.00789,-10.940835,Mauritania
MS,16.742498,-62.187366,Montserrat
MT,35.937496,14.375416,Malta
MU,-20.348404,57.552152,Mauritius
MV,3.202778,73.22068,Maldives
MW,-13.254308,34.301525,Malawi
MX,23.634501,-102.552784,Mexico
MY,4.210484,101.975766,Malaysia
MZ,-18.665695,35.529562,Mozambique
NA,-22.95764,18.49041,Namibia
NC,-20.904305,165.618042,New,Caledonia
NE,17.607789,8.081666,Niger
NF,-29.040835,167.954712,Norfolk,Island
NG,9.081999,8.675277,Nigeria
NI,12.865416,-85.207229,Nicaragua
NL,52.132633,5.291266,Netherlands
NO,60.472024,8.468946,Norway
NP,28.394857,84.124008,Nepal
NR,-0.522778,166.931503,Nauru
NU,-19.054445,-169.867233,Niue
NZ,-40.900557,174.885971,New,Zealand
OM,21.512583,55.923255,Oman
PA,8.537981,-80.782127,Panama
PE,-9.189967,-75.015152,Peru
PF,-17.679742,-149.406843,French,Polynesia
PG,-6.314993,143.95555,Papua,New,Guinea
PH,12.879721,121.774017,Philippines
PK,30.375321,69.345116,Pakistan
PL,51.919438,19.145136,Poland
PM,46.941936,-56.27111,Saint,Pierre,and,Miquelon
PN,-24.703615,-127.439308,Pitcairn,Islands
PR,18.220833,-66.590149,Puerto,Rico
PS,31.952162,35.233154,Palestinian,Territories
PT,39.399872,-8.224454,Portugal
PW,7.51498,134.58252,Palau
PY,-23.442503,-58.443832,Paraguay
QA,25.354826,51.183884,Qatar
RE,-21.115141,55.536384,Réunion
RO,45.943161,24.96676,Romania
RS,44.016521,21.005859,Serbia
RU,61.52401,105.318756,Russia
RW,-1.940278,29.873888,Rwanda
SA,23.885942,45.079162,Saudi,Arabia
SB,-9.64571,160.156194,Solomon,Islands
SC,-4.679574,55.491977,Seychelles
SD,12.862807,30.217636,Sudan
SE,60.128161,18.643501,Sweden
SG,1.352083,103.819836,Singapore
SH,-24.143474,-10.030696,Saint,Helena
SI,46.151241,14.995463,Slovenia
SJ,77.553604,23.670272,Svalbard,and,Jan,Mayen
SK,48.669026,19.699024,Slovakia
SL,8.460555,-11.779889,Sierra,Leone
SM,43.94236,12.457777,San,Marino
SN,14.497401,-14.452362,Senegal
SO,5.152149,46.199616,Somalia
SR,3.919305,-56.027783,Suriname
ST,0.18636,6.613081,São,Tomé,and,Príncipe
SV,13.794185,-88.89653,El,Salvador
SY,34.802075,38.996815,Syria
SZ,-26.522503,31.465866,Swaziland
TC,21.694025,-71.797928,Turks,and,Caicos,Islands
TD,15.454166,18.732207,Chad
TF,-49.280366,69.348557,French,Southern,Territories
TG,8.619543,0.824782,Togo
TH,15.870032,100.992541,Thailand
TJ,38.861034,71.276093,Tajikistan
TK,-8.967363,-171.855881,Tokelau
TL,-8.874217,125.727539,Timor-Leste
TM,38.969719,59.556278,Turkmenistan
TN,33.886917,9.537499,Tunisia
TO,-21.178986,-175.198242,Tonga
TR,38.963745,35.243322,Turkey
TT,10.691803,-61.222503,Trinidad,and,Tobago
TV,-7.109535,177.64933,Tuvalu
TW,23.69781,120.960515,Taiwan
TZ,-6.369028,34.888822,Tanzania
UA,48.379433,31.16558,Ukraine
UG,1.373333,32.290275,Uganda
UM,U.S.,Minor,Outlying,Islands
US,37.09024,-95.712891,United,States
UY,-32.522779,-55.765835,Uruguay
UZ,41.377491,64.585262,Uzbekistan
VA,41.902916,12.453389,Vatican,City
VC,12.984305,-61.287228,Saint,Vincent,and,the,Grenadines
VE,6.42375,-66.58973,Venezuela
VG,18.420695,-64.639968,British,Virgin,Islands
VI,18.335765,-64.896335,U.S.,Virgin,Islands
VN,14.058324,108.277199,Vietnam
VU,-15.376706,166.959158,Vanuatu
WF,-13.768752,-177.156097,Wallis,and,Futuna
WS,-13.759029,-172.104629,Samoa
XK,42.602636,20.902977,Kosovo
YE,15.552727,48.516388,Yemen
YT,-12.8275,45.166244,Mayotte
ZA,-30.559482,22.937506,South,Africa
ZM,-13.133897,27.849332,Zambia
ZW,-19.015438,29.154857,Zimbabwe"
| multikv forceheader=1 
| table country,latitude,longitude,name
| outputlookup country
```

_job_の結果をみて、CSVが作成されていれば、OK
あとはlookupを設定すれば、


```sql:clustermap.spl
source="global_mobility_report.csv" date="2020-06-*"
| stats avg(*baseline) as *baseline by date country_region_code
| sort transit_stations_percent_change_from_baseline
| dedup country_region_code
| head 10
| lookup country country as country_region_code OUTPUTNEW
| eval transit=-1 * transit_stations_percent_change_from_baseline
| geostats latfield=latitude longfield=longitude avg(transit) by name
```

データは　https://www.google.com/covid19/mobility/　
を使用しています。

引用記事
https://www.mathkuro.com/visualize/splunk/basic-chart-samples/
どうもありがとうございます。