Skip to content

Instantly share code, notes, and snippets.

@nik9000

nik9000/what countries are in what temperature ranges

Created June 8, 2020 17:36
Show Gist options
  • Save nik9000/c63388960920fd6216fb15fcf99e1297 to your computer and use it in GitHub Desktop.
Save nik9000/c63388960920fd6216fb15fcf99e1297 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
what countries are in what temperature ranges
$ curl -XPOST -HContent-Type:application/json 'localhost:9200/_search?size=0&pretty' -d'{
> "query": {
> "range": {
> "TMAX": {
> "gt": -90,
> "lt": 200
> }
> }
> },
> "aggs" : {
> "temp" : {
> "variable_width_histogram" : {
> "field" : "TMAX",
> "buckets": 20
> },
> "aggs": {
> "country": {
> "terms": {
> "field": "station.country",
> "size": 5
> }
> }
> }
> }
> }
> }'
{
"took" : 4019,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 10000,
"relation" : "gte"
},
"max_score" : null,
"hits" : [ ]
},
"aggregations" : {
"temp" : {
"buckets" : [
{
"min" : -77.19999694824219,
"key" : -43.10635535603821,
"max" : -28.399999618530273,
"doc_count" : 3918,
"country" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "Russia",
"doc_count" : 2416
},
{
"key" : "Antarctica",
"doc_count" : 758
},
{
"key" : "Canada",
"doc_count" : 424
},
{
"key" : "United",
"doc_count" : 182
},
{
"key" : "American",
"doc_count" : 120
},
{
"key" : "Sweden",
"doc_count" : 10
},
{
"key" : "Norway",
"doc_count" : 5
},
{
"key" : "Finland",
"doc_count" : 3
}
]
}
},
{
"min" : -32.84999942779541,
"key" : -31.600208115290982,
"max" : -22.0,
"doc_count" : 12972,
"country" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "Canada",
"doc_count" : 5691
},
{
"key" : "Russia",
"doc_count" : 4946
},
{
"key" : "United",
"doc_count" : 1576
},
{
"key" : "Antarctica",
"doc_count" : 235
},
{
"key" : "Sweden",
"doc_count" : 176
},
{
"key" : "Mongolia",
"doc_count" : 149
},
{
"key" : "Finland",
"doc_count" : 101
},
{
"key" : "Norway",
"doc_count" : 46
},
{
"key" : "Kazakhstan",
"doc_count" : 25
},
{
"key" : "Greenland",
"doc_count" : 20
},
{
"key" : "China",
"doc_count" : 5
},
{
"key" : "Bolivia",
"doc_count" : 1
},
{
"key" : "Oman",
"doc_count" : 1
}
]
}
},
{
"min" : -25.449999809265137,
"key" : -26.30940687700594,
"max" : -23.299999237060547,
"doc_count" : 17264,
"country" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 0,
"buckets" : [
{
"key" : "Canada",
"doc_count" : 8035
},
{
"key" : "Russia",
"doc_count" : 5229
},
{
"key" : "United",
"doc_count" : 2519
},
{
"key" : "Antarctica",
"doc_count" : 310
},
{
"key" : "Finland",
"doc_count" : 305
},
{
"key" : "Mongolia",
"doc_count" : 302
},
{
"key" : "Sweden",
"doc_count" : 238
},
{
"key" : "Kazakhstan",
"doc_count" : 209
},
{
"key" : "Greenland",
"doc_count" : 79
},
{
"key" : "Norway",
"doc_count" : 22
},
{
"key" : "China",
"doc_count" : 16
}
]
}
},
{
"min" : -24.0,
"key" : -22.095761703013725,
"max" : 4.9E-324,
"doc_count" : 36052,
"country" : {
"doc_count_error_upper_bound" : 1,
"sum_other_doc_count" : 2151,
"buckets" : [
{
"key" : "Canada",
"doc_count" : 15989
},
{
"key" : "Russia",
"doc_count" : 8897
},
{
"key" : "United",
"doc_count" : 7567
},
{
"key" : "Mongolia",
"doc_count" : 772
},
{
"key" : "Antarctica",
"doc_count" : 676
}
]
}
},
{
"min" : -11.0,
"key" : -18.5286381035044,
"max" : 4.9E-324,
"doc_count" : 47737,
"country" : {
"doc_count_error_upper_bound" : 7,
"sum_other_doc_count" : 3143,
"buckets" : [
{
"key" : "Canada",
"doc_count" : 18129
},
{
"key" : "United",
"doc_count" : 15810
},
{
"key" : "Russia",
"doc_count" : 8789
},
{
"key" : "Mongolia",
"doc_count" : 1013
},
{
"key" : "Antarctica",
"doc_count" : 853
}
]
}
},
{
"min" : -8.550000190734863,
"key" : -15.25835400266161,
"max" : 4.9E-324,
"doc_count" : 81943,
"country" : {
"doc_count_error_upper_bound" : 33,
"sum_other_doc_count" : 6250,
"buckets" : [
{
"key" : "United",
"doc_count" : 33196
},
{
"key" : "Canada",
"doc_count" : 26027
},
{
"key" : "Russia",
"doc_count" : 12722
},
{
"key" : "Mongolia",
"doc_count" : 1991
},
{
"key" : "Finland",
"doc_count" : 1757
}
]
}
},
{
"min" : -6.900000095367432,
"key" : -11.492627718682995,
"max" : 4.9E-324,
"doc_count" : 145680,
"country" : {
"doc_count_error_upper_bound" : 128,
"sum_other_doc_count" : 12755,
"buckets" : [
{
"key" : "United",
"doc_count" : 69628
},
{
"key" : "Canada",
"doc_count" : 39734
},
{
"key" : "Russia",
"doc_count" : 16750
},
{
"key" : "Finland",
"doc_count" : 3569
},
{
"key" : "Sweden",
"doc_count" : 3244
}
]
}
},
{
"min" : -4.900000095367432,
"key" : -7.86561309350483,
"max" : 4.9E-324,
"doc_count" : 201798,
"country" : {
"doc_count_error_upper_bound" : 225,
"sum_other_doc_count" : 16057,
"buckets" : [
{
"key" : "United",
"doc_count" : 114897
},
{
"key" : "Canada",
"doc_count" : 44095
},
{
"key" : "Russia",
"doc_count" : 17018
},
{
"key" : "Finland",
"doc_count" : 4885
},
{
"key" : "Sweden",
"doc_count" : 4846
}
]
}
},
{
"min" : -3.0999999046325684,
"key" : -3.591523591249834,
"max" : 4.9E-324,
"doc_count" : 515631,
"country" : {
"doc_count_error_upper_bound" : 678,
"sum_other_doc_count" : 42047,
"buckets" : [
{
"key" : "United",
"doc_count" : 319983
},
{
"key" : "Canada",
"doc_count" : 87675
},
{
"key" : "Russia",
"doc_count" : 34064
},
{
"key" : "Sweden",
"doc_count" : 16655
},
{
"key" : "Finland",
"doc_count" : 15207
}
]
}
},
{
"min" : -0.75,
"key" : 0.050054364662367415,
"max" : 1.2000000476837158,
"doc_count" : 503113,
"country" : {
"doc_count_error_upper_bound" : 927,
"sum_other_doc_count" : 47867,
"buckets" : [
{
"key" : "United",
"doc_count" : 316482
},
{
"key" : "Canada",
"doc_count" : 69121
},
{
"key" : "Russia",
"doc_count" : 28765
},
{
"key" : "Finland",
"doc_count" : 21141
},
{
"key" : "Sweden",
"doc_count" : 19737
}
]
}
},
{
"min" : 1.2000000476837158,
"key" : 3.912425260429459,
"max" : 6.300000190734863,
"doc_count" : 1197029,
"country" : {
"doc_count_error_upper_bound" : 3048,
"sum_other_doc_count" : 141463,
"buckets" : [
{
"key" : "United",
"doc_count" : 771613
},
{
"key" : "Canada",
"doc_count" : 147144
},
{
"key" : "Russia",
"doc_count" : 50257
},
{
"key" : "Sweden",
"doc_count" : 45876
},
{
"key" : "Finland",
"doc_count" : 40676
}
]
}
},
{
"min" : 6.25,
"key" : 9.580199822000283,
"max" : 12.699999809265137,
"doc_count" : 1780864,
"country" : {
"doc_count_error_upper_bound" : 5242,
"sum_other_doc_count" : 278502,
"buckets" : [
{
"key" : "United",
"doc_count" : 1165577
},
{
"key" : "Canada",
"doc_count" : 198360
},
{
"key" : "Russia",
"doc_count" : 51241
},
{
"key" : "Sweden",
"doc_count" : 48894
},
{
"key" : "Norway",
"doc_count" : 38290
}
]
}
},
{
"min" : 12.699999809265137,
"key" : 15.701067662489,
"max" : 18.600000381469727,
"doc_count" : 2174039,
"country" : {
"doc_count_error_upper_bound" : 6905,
"sum_other_doc_count" : 315851,
"buckets" : [
{
"key" : "United",
"doc_count" : 1434518
},
{
"key" : "Canada",
"doc_count" : 189770
},
{
"key" : "Australia",
"doc_count" : 145362
},
{
"key" : "Russia",
"doc_count" : 47298
},
{
"key" : "Sweden",
"doc_count" : 41240
}
]
}
},
{
"min" : 18.600000381469727,
"key" : 21.70784709305924,
"max" : 24.700000762939453,
"doc_count" : 2452717,
"country" : {
"doc_count_error_upper_bound" : 8868,
"sum_other_doc_count" : 343421,
"buckets" : [
{
"key" : "United",
"doc_count" : 1646197
},
{
"key" : "Canada",
"doc_count" : 198838
},
{
"key" : "Australia",
"doc_count" : 176213
},
{
"key" : "Russia",
"doc_count" : 52484
},
{
"key" : "Japan",
"doc_count" : 35564
}
]
}
},
{
"min" : 24.700000762939453,
"key" : 27.237295512179585,
"max" : 29.899999618530273,
"doc_count" : 2099751,
"country" : {
"doc_count_error_upper_bound" : 7129,
"sum_other_doc_count" : 326197,
"buckets" : [
{
"key" : "United",
"doc_count" : 1464319
},
{
"key" : "Australia",
"doc_count" : 139340
},
{
"key" : "Canada",
"doc_count" : 109350
},
{
"key" : "Russia",
"doc_count" : 30634
},
{
"key" : "Japan",
"doc_count" : 29911
}
]
}
},
{
"min" : 29.899999618530273,
"key" : 32.00242141940304,
"max" : 34.70000076293945,
"doc_count" : 1661125,
"country" : {
"doc_count_error_upper_bound" : 7607,
"sum_other_doc_count" : 377715,
"buckets" : [
{
"key" : "United",
"doc_count" : 1034416
},
{
"key" : "Australia",
"doc_count" : 121067
},
{
"key" : "Indonesia",
"doc_count" : 66261
},
{
"key" : "India",
"doc_count" : 35252
},
{
"key" : "Thailand",
"doc_count" : 26414
}
]
}
},
{
"min" : 34.70000076293945,
"key" : 35.941964336672804,
"max" : 37.79999923706055,
"doc_count" : 379620,
"country" : {
"doc_count_error_upper_bound" : 2314,
"sum_other_doc_count" : 86221,
"buckets" : [
{
"key" : "United",
"doc_count" : 217115
},
{
"key" : "Australia",
"doc_count" : 46191
},
{
"key" : "India",
"doc_count" : 13202
},
{
"key" : "Thailand",
"doc_count" : 9326
},
{
"key" : "Mexico",
"doc_count" : 7565
}
]
}
},
{
"min" : 37.75,
"key" : 39.123709391468914,
"max" : 41.5,
"doc_count" : 171417,
"country" : {
"doc_count_error_upper_bound" : 1467,
"sum_other_doc_count" : 46377,
"buckets" : [
{
"key" : "United",
"doc_count" : 77256
},
{
"key" : "Australia",
"doc_count" : 32030
},
{
"key" : "India",
"doc_count" : 7591
},
{
"key" : "Niger",
"doc_count" : 4176
},
{
"key" : "Algeria",
"doc_count" : 3987
}
]
}
},
{
"min" : 41.45000076293945,
"key" : 43.38397335278915,
"max" : 49.70000076293945,
"doc_count" : 48388,
"country" : {
"doc_count_error_upper_bound" : 301,
"sum_other_doc_count" : 14799,
"buckets" : [
{
"key" : "United",
"doc_count" : 15151
},
{
"key" : "Australia",
"doc_count" : 8240
},
{
"key" : "Oman",
"doc_count" : 4154
},
{
"key" : "Saudi",
"doc_count" : 3240
},
{
"key" : "India",
"doc_count" : 2804
}
]
}
},
{
"min" : 47.35000038146973,
"key" : 54.15524756932021,
"max" : 183.3000030517578,
"doc_count" : 1010,
"country" : {
"doc_count_error_upper_bound" : 0,
"sum_other_doc_count" : 2,
"buckets" : [
{
"key" : "United",
"doc_count" : 610
},
{
"key" : "Iran",
"doc_count" : 100
},
{
"key" : "Kuwait",
"doc_count" : 91
},
{
"key" : "Saudi",
"doc_count" : 55
},
{
"key" : "Oman",
"doc_count" : 34
},
{
"key" : "Iraq",
"doc_count" : 31
},
{
"key" : "Algeria",
"doc_count" : 26
},
{
"key" : "Australia",
"doc_count" : 19
},
{
"key" : "India",
"doc_count" : 18
},
{
"key" : "Mexico",
"doc_count" : 7
},
{
"key" : "Senegal",
"doc_count" : 5
},
{
"key" : "Pakistan",
"doc_count" : 4
},
{
"key" : "Canada",
"doc_count" : 2
},
{
"key" : "Niger",
"doc_count" : 2
},
{
"key" : "Qatar",
"doc_count" : 2
},
{
"key" : "Egypt",
"doc_count" : 1
},
{
"key" : "Mauritania",
"doc_count" : 1
}
]
}
}
]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment