{"took":684,"timed_out":false,"_shards":{"total":50,"successful":50,"skipped":0,"failed":0},"hits":{"total":{"value":5,"relation":"eq"},"max_score":15.5808325,"hits":[{"_index":"edgar_file","_id":"0001709576-18-000002:primary_doc.xml","_score":15.5808325,"_source":{"ciks":["0001709576"],"period_ending":null,"file_num":["021-288960"],"display_names":["Water Property Investor II, LP  (CIK 0001709576)"],"xsl":"xslFormDX01","schema_version":"X0708","sequence":1,"root_forms":["D"],"file_date":"2018-08-24","biz_states":["NY"],"sics":[],"form":"D/A","adsh":"0001709576-18-000002","film_num":["181035544"],"biz_locations":["New York, NY"],"file_type":"D/A","file_description":null,"inc_states":["DE"],"items":["06B","3C","3C.7"]}},{"_index":"edgar_file","_id":"0001104659-20-087722:primary_doc.xml","_score":15.5520525,"_source":{"ciks":["0001709576"],"period_ending":null,"file_num":["021-288960"],"display_names":["Water Property Investor II, LP  (CIK 0001709576)"],"xsl":"xslFormDX01","schema_version":"X0708","sequence":1,"root_forms":["D"],"file_date":"2020-07-29","biz_states":["NY"],"sics":[],"form":"D/A","adsh":"0001104659-20-087722","film_num":["201056692"],"biz_locations":["New York, NY"],"file_type":"D/A","file_description":null,"inc_states":["DE"],"items":["06B","3C","3C.1"]}},{"_index":"edgar_file","_id":"0001709576-18-000001:primary_doc.xml","_score":15.5460825,"_source":{"ciks":["0001709576"],"period_ending":null,"file_num":["021-288960"],"display_names":["Water Property Investor II, LP  (CIK 0001709576)"],"xsl":"xslFormDX01","schema_version":"X0708","sequence":1,"root_forms":["D"],"file_date":"2018-01-30","biz_states":["NY"],"sics":[],"form":"D/A","adsh":"0001709576-18-000001","film_num":["18559586"],"biz_locations":["New York, NY"],"file_type":"D/A","file_description":null,"inc_states":["DE"],"items":["06B","3C","3C.7"]}},{"_index":"edgar_file","_id":"0001709576-17-000001:primary_doc.xml","_score":15.47825,"_source":{"ciks":["0001709576"],"period_ending":null,"file_num":["021-288960"],"display_names":["Water Property Investor II, LP  (CIK 0001709576)"],"xsl":"xslFormDX01","schema_version":"X0707","sequence":1,"root_forms":["D"],"file_date":"2017-06-19","biz_states":["NY"],"sics":[],"form":"D","adsh":"0001709576-17-000001","film_num":["17917141"],"biz_locations":["New York, NY"],"file_type":"D","file_description":null,"inc_states":["DE"],"items":["06B","3C","3C.7"]}},{"_index":"edgar_file","_id":"0001144204-19-037017:primary_doc.xml","_score":15.428608,"_source":{"ciks":["0001709576"],"period_ending":null,"file_num":["021-288960"],"display_names":["Water Property Investor II, LP  (CIK 0001709576)"],"xsl":"xslFormDX01","schema_version":"X0708","sequence":1,"root_forms":["D"],"file_date":"2019-08-01","biz_states":["NY"],"sics":[],"form":"D/A","adsh":"0001144204-19-037017","film_num":["19990630"],"biz_locations":["New York, NY"],"file_type":"D/A","file_description":null,"inc_states":["DE"],"items":["06B","3C","3C.1"]}}]},"aggregations":{"entity_filter":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Water Property Investor II, LP  (CIK 0001709576)","doc_count":5}]},"sic_filter":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[]},"biz_states_filter":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"NY","doc_count":5}]},"form_filter":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"D","doc_count":5}]}},"query":{"_source":{"exclude":["doc_text"]},"query":{"bool":{"must":[{"match_phrase":{"doc_text":"Water Development II LLC"}}],"must_not":[],"should":[],"filter":[]}},"from":0,"size":100,"aggregations":{"form_filter":{"terms":{"field":"root_forms","size":30}},"entity_filter":{"terms":{"field":"display_names.raw","size":30}},"sic_filter":{"terms":{"field":"sics","size":30}},"biz_states_filter":{"terms":{"field":"biz_states","size":30}}}}}