There are 16,302 places matching de-bkg and this is one page of many

0.0849471092224 seconds
{'query': {'function_score': {'boost_mode': 'multiply', 'functions': [{'filter': {'term': {'names_preferred': u'de\\-bkg'}}, 'weight': 10.0}, {'filter': {'term': {'names_all': u'de\\-bkg'}}, 'weight': 1.0}, {'filter': {'term': {'wof:name': u'de\\-bkg'}}, 'weight': 6.0}, {'filter': {'not': {'term': {'wof:placetype': 'venue'}}}, 'weight': 2.0}, {'filter': {'term': {'wof:placetype': 'location'}}, 'weight': 5.0}, {'filter': {'exists': {'field': 'wk:population'}}, 'weight': 1.25}], 'query': {'filtered': {'filter': {'and': [{'bool': {'must_not': [{'exists': {'field': 'edtf:deprecated'}}]}}]}, 'query': {'match': {'_all': {'operator': 'and', 'query': u'de\\-bkg'}}}}}, 'score_mode': 'multiply'}}, 'sort': [{'gn:population': {'mode': 'max', 'order': 'desc'}}, {'geom:area': {'mode': 'max', 'order': 'desc'}}, {'wof:scale': {'mode': 'max', 'order': 'desc'}}, {'wof:megacity': {'mode': 'max', 'order': 'desc'}}]}
Would you like try this query again to include records that have been deprecated ?
  1. 85633111 Germany — this is a country
    • its population is 81,802,257
    • it was last modified on September 28, 2023
  2. 101909779 Berlin — this is a locality in Germany
    • its population is 3,442,675
    • it was last modified on August 01, 2023
  3. 101748841 Hamburg — this is a locality in Germany
    • its population is 1,774,224
    • it was last modified on August 01, 2023
  4. 101748479 München — this is a locality in Germany
    • its population is 1,330,440
    • it was last modified on August 01, 2023
  5. 101752771 Köln — this is a locality in Germany
    • its population is 963,395
    • it was last modified on August 01, 2023
  6. 101913837 Frankfurt am Main — this is a locality in Germany
    • its population is 671,927
    • it was last modified on August 01, 2023
  7. 101905809 Stuttgart — this is a locality in Germany
    • its population is 601,646
    • it was last modified on August 01, 2023
  8. 101748671 Düsseldorf — this is a locality in Germany
    • its population is 586,217
    • it was last modified on August 01, 2023
  9. 101748719 Dortmund — this is a locality in Germany
    • its population is 581,308
    • it was last modified on August 01, 2023
  10. 101748709 Essen — this is a locality in Germany
    • its population is 576,259
    • it was last modified on August 01, 2023
  11. 101913887 Bremen — this is a locality in Germany
    • its population is 546,501
    • it was last modified on August 01, 2023
  12. 101748819 Hannover — this is a locality in Germany
    • its population is 520,966
    • it was last modified on August 01, 2023
  13. 101748685 Leipzig — this is a locality in Germany
    • its population is 518,862
    • it was last modified on August 01, 2023
  14. 101752773 Dresden — this is a locality in Germany
    • its population is 517,052
    • it was last modified on August 01, 2023
  15. 101905935 Nürnberg — this is a locality in Germany
    • its population is 503,673
    • it was last modified on May 17, 2023
  16. 101748713 Duisburg — this is a locality in Germany
    • its population is 491,931
    • it was last modified on August 01, 2023
  17. 101748707 Bochum — this is a locality in Germany
    • its population is 376,319
    • it was last modified on August 01, 2023
  18. 101748657 Wuppertal — this is a locality in Germany
    • its population is 351,050
    • it was last modified on August 01, 2023
  19. 101748767 Bielefeld — this is a locality in Germany
    • its population is 331,906
    • it was last modified on August 01, 2023
  20. 101748595 Bonn — this is a locality in Germany
    • its population is 319,841
    • it was last modified on August 01, 2023
  21. 101748549 Mannheim — this is a locality in Germany
    • its population is 311,969
    • it was last modified on August 01, 2023
  22. 101748527 Karlsruhe — this is a locality in Germany
    • its population is 291,959
    • it was last modified on August 01, 2023
  23. 101907107 Wiesbaden — this is a locality in Germany
    • its population is 277,493
    • it was last modified on August 01, 2023
  24. 101913895 Münster — this is a locality in Germany
    • its population is 275,543
    • it was last modified on August 01, 2023
  25. 101748481 Augsburg — this is a locality in Germany
    • its population is 263,646
    • it was last modified on August 01, 2023
  26. 101907659 Gelsenkirchen — this is a locality in Germany
    • its population is 259,744
    • it was last modified on August 01, 2023
  27. 101748621 Aachen — this is a locality in Germany
    • its population is 258,380
    • it was last modified on August 01, 2023
  28. 101907593 Mönchengladbach — this is a locality in Germany
    • its population is 258,251
    • it was last modified on August 01, 2023
  29. 101909589 Braunschweig — this is a locality in Germany
    • its population is 247,400
    • it was last modified on August 01, 2023
  30. 101748601 Chemnitz — this is a locality in Germany
    • its population is 243,089
    • it was last modified on August 01, 2023
  31. 101748869 Kiel — this is a locality in Germany
    • its population is 238,281
    • it was last modified on August 01, 2023
  32. 1175611403 Krefeld — this is a locality in Germany
    • its population is 235,414
    • it was last modified on August 01, 2023
  33. 101748705 Halle (Saale) — this is a locality in Germany
    • its population is 232,323
    • it was last modified on August 01, 2023
  34. 101748781 Magdeburg — this is a locality in Germany
    • its population is 230,456
    • it was last modified on August 01, 2023
  35. 101905681 Freiburg im Breisgau — this is a locality in Germany
    • its population is 215,966
    • it was last modified on August 01, 2023
  36. 101748715 Oberhausen — this is a locality in Germany
    • its population is 214,024
    • it was last modified on August 01, 2023
  37. 101748855 Lübeck — this is a locality in Germany
    • its population is 209,818
    • it was last modified on August 01, 2023
  38. 101748625 Erfurt — this is a locality in Germany
    • its population is 203,830
    • it was last modified on August 01, 2023
  39. 101748865 Rostock — this is a locality in Germany
    • its population is 201,442
    • it was last modified on August 01, 2023
  40. 101748659 Kassel — this is a locality in Germany
    • its population is 194,774
    • it was last modified on August 01, 2023
  41. 101748679 Hagen — this is a locality in Germany
    • its population is 190,121
    • it was last modified on August 01, 2023
  42. 1175611405 Mainz — this is a locality in Germany
    • its population is 184,997
    • it was last modified on August 01, 2023
  43. 101748739 Hamm — this is a locality in Germany
    • its population is 181,741
    • it was last modified on August 01, 2023
  44. 101905991 Saarbrücken — this is a locality in Germany
    • its population is 181,227
    • it was last modified on August 01, 2023
  45. 101913817 Mülheim an der Ruhr — this is a locality in Germany
    • its population is 167,471
    • it was last modified on August 01, 2023
  46. 101748711 Herne — this is a locality in Germany
    • its population is 165,632
    • it was last modified on August 01, 2023
  47. 101748795 Osnabrück — this is a locality in Germany
    • its population is 163,514
    • it was last modified on August 01, 2023
  48. 101748547 Ludwigshafen am Rhein — this is a locality in Germany
    • its population is 163,196
    • it was last modified on August 01, 2023
  49. 101748641 Leverkusen — this is a locality in Germany
    • its population is 162,738
    • it was last modified on August 01, 2023
  50. 101748649 Solingen — this is a locality in Germany
    • its population is 160,992
    • it was last modified on August 01, 2023
  51. 101748815 Potsdam — this is a locality in Germany
    • its population is 159,456
    • it was last modified on July 16, 2019
  52. 101748665 Neuss — this is a locality in Germany
    • its population is 151,280
    • it was last modified on August 01, 2023
  53. 101906011 Heidelberg — this is a locality in Germany
    • its population is 146,466
    • it was last modified on August 01, 2023
  54. 101748761 Paderborn — this is a locality in Germany
    • its population is 145,320
    • it was last modified on August 01, 2023
  55. 101906949 Darmstadt — this is a locality in Germany
    • its population is 143,332
    • it was last modified on August 01, 2023
  56. 101748557 Würzburg — this is a locality in Germany
    • its population is 133,195
    • it was last modified on August 01, 2023
  57. 101748525 Regensburg — this is a locality in Germany
    • its population is 129,151
    • it was last modified on August 01, 2023
  58. 101905811 Ingolstadt — this is a locality in Germany
    • its population is 124,387
    • it was last modified on August 01, 2023
  59. 101748529 Heilbronn — this is a locality in Germany
    • its population is 122,415
    • it was last modified on August 01, 2023
  60. 101748485 Ulm — this is a locality in Germany
    • its population is 122,087
    • it was last modified on August 01, 2023
  61. 101748721 Göttingen — this is a locality in Germany
    • its population is 121,457
    • it was last modified on August 01, 2023
  62. 101748803 Wolfsburg — this is a locality in Germany
    • its population is 121,109
    • it was last modified on August 01, 2023
  63. 101905847 Pforzheim — this is a locality in Germany
    • its population is 119,788
    • it was last modified on August 01, 2023
  64. 101748751 Recklinghausen — this is a locality in Germany
    • its population is 119,050
    • it was last modified on August 01, 2023
  65. 1175611315 Offenbach am Main — this is a locality in Germany
    • its population is 118,770
    • it was last modified on August 01, 2023
  66. 101748845 Bremerhaven — this is a locality in Germany
    • its population is 117,446
    • it was last modified on August 01, 2023
  67. 101914211 Bottrop — this is a locality in Germany
    • its population is 117,241
    • it was last modified on August 01, 2023
  68. 101748545 Fürth — this is a locality in Germany
    • its population is 114,044
    • it was last modified on August 01, 2023
  69. 101748489 Reutlingen — this is a locality in Germany
    • its population is 112,132
    • it was last modified on August 01, 2023
  70. 101748651 Remscheid — this is a locality in Germany
    • its population is 111,422
    • it was last modified on August 01, 2023
  71. 101751761 Koblenz — this is a locality in Germany
    • its population is 106,445
    • it was last modified on August 01, 2023
  72. 101748759 Moers — this is a locality in Germany
    • its population is 105,929
    • it was last modified on August 01, 2023
  73. 101748647 Bergisch Gladbach — this is a locality in Germany
    • its population is 105,699
    • it was last modified on August 01, 2023
  74. 101748559 Trier — this is a locality in Germany
    • its population is 104,587
    • it was last modified on August 01, 2023
  75. 101748613 Jena — this is a locality in Germany
    • its population is 104,449
    • it was last modified on August 01, 2023
  76. 101748643 Siegen — this is a locality in Germany
    • its population is 103,984
    • it was last modified on August 01, 2023
  77. 101748779 Salzgitter — this is a locality in Germany
    • its population is 103,446
    • it was last modified on August 01, 2023
  78. 101748791 Hildesheim — this is a locality in Germany
    • its population is 102,903
    • it was last modified on August 01, 2023
  79. 101910073 Erlangen — this is a locality in Germany
    • its population is 102,675
    • it was last modified on August 01, 2023
  80. 101748763 Cottbus — this is a locality in Germany
    • its population is 101,671
    • it was last modified on August 01, 2023
  81. 101748611 Gera — this is a locality in Germany
    • its population is 99,987
    • it was last modified on August 01, 2023
  82. 101748541 Kaiserslautern — this is a locality in Germany
    • its population is 99,275
    • it was last modified on August 01, 2023
  83. 101748697 Witten — this is a locality in Germany
    • its population is 98,601
    • it was last modified on August 01, 2023
  84. 101748773 Gütersloh — this is a locality in Germany
    • its population is 96,320
    • it was last modified on August 01, 2023
loading facets from the sky

Log


There are 16,302 results

There are so many results for this query that the Spelunker database can't do page1, page2, page3... style pagination without getting sad. There are actually 195 pages worth of results for this query but as of this writing there is only the "next page" of results. We all have our limits, right? Speaking of limits, these query results have a pretty short shelf life. As long as you are paging through the results everything will be okay but if left idle for too long (about 5 minutes) they will expire and you'll need to perform a new query. It's good to have constraints to work against, right?