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

0.0316939353943 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 August 13
  2. 101909779 Berlin — this is a locality in Germany
    • its population is 3,375,222
    • it was last modified on July 24
  3. 101748841 Hamburg — this is a locality in Germany
    • its population is 1,739,117
    • it was last modified on July 16
  4. 101748479 M├╝nchen — this is a locality in Germany
    • its population is 1,260,391
    • it was last modified on July 16
  5. 101752771 K├Âln — this is a locality in Germany
    • its population is 963,395
    • it was last modified on July 16
  6. 101913837 Frankfurt am Main — this is a locality in Germany
    • its population is 650,000
    • it was last modified on July 16
  7. 101748709 Essen — this is a locality in Germany
    • its population is 593,085
    • it was last modified on July 16
  8. 101905809 Stuttgart — this is a locality in Germany
    • its population is 589,793
    • it was last modified on July 16
  9. 101748719 Dortmund — this is a locality in Germany
    • its population is 588,462
    • it was last modified on July 16
  10. 101748671 D├╝sseldorf — this is a locality in Germany
    • its population is 573,057
    • it was last modified on July 16
  11. 101913887 Bremen — this is a locality in Germany
    • its population is 546,501
    • it was last modified on July 16
  12. 101748819 Hannover — this is a locality in Germany
    • its population is 515,140
    • it was last modified on July 16
  13. 101748685 Leipzig — this is a locality in Germany
    • its population is 504,971
    • it was last modified on July 16
  14. 101748713 Duisburg — this is a locality in Germany
    • its population is 504,358
    • it was last modified on July 16
  15. 101905935 N├╝rnberg — this is a locality in Germany
    • its population is 495,121
    • it was last modified on June 29
  16. 101752773 Dresden — this is a locality in Germany
    • its population is 486,854
    • it was last modified on July 16
  17. 101748707 Bochum — this is a locality in Germany
    • its population is 385,729
    • it was last modified on July 16
  18. 101748657 Wuppertal — this is a locality in Germany
    • its population is 360,797
    • it was last modified on July 16
  19. 101748767 Bielefeld — this is a locality in Germany
    • its population is 331,906
    • it was last modified on July 16
  20. 101748595 Bonn — this is a locality in Germany
    • its population is 313,125
    • it was last modified on July 16
  21. 101748549 Mannheim — this is a locality in Germany
    • its population is 307,960
    • it was last modified on July 16
  22. 101748527 Karlsruhe — this is a locality in Germany
    • its population is 283,799
    • it was last modified on July 16
  23. 101907107 Wiesbaden — this is a locality in Germany
    • its population is 272,636
    • it was last modified on July 16
  24. 101913895 M├╝nster — this is a locality in Germany
    • its population is 270,184
    • it was last modified on July 16
  25. 101748621 Aachen — this is a locality in Germany
    • its population is 265,208
    • it was last modified on July 16
  26. 101907593 M├Ânchengladbach — this is a locality in Germany
    • its population is 261,742
    • it was last modified on July 16
  27. 101748481 Augsburg — this is a locality in Germany
    • its population is 259,196
    • it was last modified on July 16
  28. 101907659 Gelsenkirchen — this is a locality in Germany
    • its population is 257,607
    • it was last modified on July 16
  29. 101748601 Chemnitz — this is a locality in Germany
    • its population is 247,220
    • it was last modified on July 16
  30. 101909589 Braunschweig — this is a locality in Germany
    • its population is 244,715
    • it was last modified on July 16
  31. 1175611403 Krefeld — this is a locality in Germany
    • its population is 237,984
    • it was last modified on July 16
  32. 101748705 Halle (Saale) — this is a locality in Germany
    • its population is 234,107
    • it was last modified on July 16
  33. 101748869 Kiel — this is a locality in Germany
    • its population is 232,758
    • it was last modified on July 16
  34. 101748781 Magdeburg — this is a locality in Germany
    • its population is 229,826
    • it was last modified on July 16
  35. 101748715 Oberhausen — this is a locality in Germany
    • its population is 219,176
    • it was last modified on July 16
  36. 101905681 Freiburg im Breisgau — this is a locality in Germany
    • its population is 215,966
    • it was last modified on July 16
  37. 101748855 L├╝beck — this is a locality in Germany
    • its population is 212,207
    • it was last modified on July 16
  38. 101748625 Erfurt — this is a locality in Germany
    • its population is 203,254
    • it was last modified on July 16
  39. 101748679 Hagen — this is a locality in Germany
    • its population is 198,972
    • it was last modified on July 16
  40. 101748865 Rostock — this is a locality in Germany
    • its population is 198,293
    • it was last modified on July 16
  41. 101748659 Kassel — this is a locality in Germany
    • its population is 194,501
    • it was last modified on July 16
  42. 101748739 Hamm — this is a locality in Germany
    • its population is 185,327
    • it was last modified on July 16
  43. 1175611405 Mainz — this is a locality in Germany
    • its population is 184,997
    • it was last modified on July 16
  44. 101905991 Saarbr├╝cken — this is a locality in Germany
    • its population is 181,227
    • it was last modified on July 16
  45. 101748711 Herne — this is a locality in Germany
    • its population is 172,108
    • it was last modified on July 16
  46. 101913817 M├╝lheim an der Ruhr — this is a locality in Germany
    • its population is 166,654
    • it was last modified on July 16
  47. 101748795 Osnabr├╝ck — this is a locality in Germany
    • its population is 166,462
    • it was last modified on July 16
  48. 101748649 Solingen — this is a locality in Germany
    • its population is 164,359
    • it was last modified on July 16
  49. 101748547 Ludwigshafen am Rhein — this is a locality in Germany
    • its population is 163,196
    • it was last modified on July 16
  50. 101748641 Leverkusen — this is a locality in Germany
    • its population is 162,738
    • it was last modified on July 16
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 327 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?