{
  "reviews": {
    "mappings": {
      "hotels": {
        "properties": {
          "entityCollection": {
            "properties": {
              "entities": {
                "type": "nested",
                "properties": {
                  "displayName": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword"
                      }
                    }
                  },
                  "id": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword"
                      }
                    }
                  },
                  "type": {
                    "type": "text",
                    "fields": {
                      "keyword": {
                        "type": "keyword"
                      }
                    }
                  }
                }
              }
            }
          },
          "reviewSubmissionTime": {
            "type": "date"
          }
        }
      }
    }
  }
}

{
  "_source": {
    "reviewSubmissionTime": "2013-11-18T08:00:00.000Z",
    "entityCollection": {
      "entities": [
        {
          "id": "staff",
          "type": "tag"
        },
        {
          "id": "dining",
          "type": "tag"
        },
        {
          "id": "restaurant",
          "type": "tag"
        }
      ]
    }
  }
}

{
  "size": 0,
  "query": {
    "bool": {
      "filter": [
        {
          "range": {
            "reviewSubmissionTime": {
              "gte": "2013-01-01",
              "format": "yyyy-MM-dd"
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "tags": {
      "nested": {
        "path": "entityCollection.entities"
      },
      "aggs": {
        "selected_tags": {
          "filter": {
            "bool": {
              "must": [
                {
                  "terms": {
                    "entityCollection.entities.id": [
                      "staff"
                    ]
                  }
                }
              ]
            }
          },
          "aggs": {
            "docs": {
              "reverse_nested": {},
              "aggs": {
                "parent_docs": {
                  "top_hits": {
                    "_source": {
                      "includes": [
                        "entityCollection.entities.id",
                        "entityCollection.entities.type",
                        "reviewSubmissionTime"
                      ]
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

{
  "took": 58,
  "timed_out": false,
  "_shards": {
    "total": 3,
    "successful": 3,
    "failed": 0
  },
  "hits": {
    "total": 1632254,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "tags": {
      "doc_count": 1749430,
      "selected_tags": {
        "doc_count": 134003,
        "docs": {
          "doc_count": 134003,
          "parent_docs": {
            "hits": {
              "total": 134003,
              "max_score": 1.4e-45,
              "hits": [
                {
                  "_index": "reviews",
                  "_type": "hotels",
                  "_id": "61721588",
                  "_score": 0,
                  "_source": {
                    "entityCollection": {
                      "entities": [
                        {
                          "id": "staff",
                          "type": "tag"
                        },
                        {
                          "id": "roomBed",
                          "type": "tag"
                        }
                      ]
                    },
                    "reviewSubmissionTime": "2013-11-13T04:27:29.000Z"
                  }
                },
                {
                  "_index": "reviews",
                  "_type": "hotels",
                  "_id": "61730048",
                  "_score": 0,
                  "_source": {
                    "entityCollection": {
                      "entities": [
                        {
                          "id": "staff",
                          "type": "tag"
                        },
                        {
                          "id": "breakfast",
                          "type": "tag"
                        }
                      ]
                    },
                    "reviewSubmissionTime": "2013-11-13T12:25:36.000Z"
                  }
                },
                {
                  "_index": "xreviews-2013-1012",
                  "_type": "psrHotels",
                  "_id": "61773871",
                  "_score": 0,
                  "_source": {
                    "entityCollection": {
                      "entities": [
                        {
                          "id": "staff",
                          "type": "tag"
                        },
                        {
                          "id": "dining",
                          "type": "tag"
                        },
                        {
                          "id": "casino",
                          "type": "tag"
                        },
                        {
                          "id": "restaurant",
                          "type": "tag"
                        },
                        {
                          "id": "skyScraper",
                          "type": "tag"
                        }
                      ]
                    },
                    "reviewSubmissionTime": "2013-11-14T01:02:14.000Z"
                  }
                }
              ]
            }
          }
        }
      }
    }
  }
}