gistfile1.json

curl -XPUT 'http://localhost:9200/testings/' -d '{
    "index" : {
        "number_of_shards" : 1
    }
    
}'

curl -XPUT 'http://localhost:9200/testings/testing/_mapping' -d '{
    "testing" : {
        "properties" : {
            "reviews" : {
                "type" : "nested"
            }
        }
    }
}'

curl -XPUT 'http://localhost:9200/testings/testing/4' -d '{"user_id":138,"ta_id":4,"for":"major","school":"univ","bio":"this bio","year":"2000","video_link":"this_video","photo_link":"http://s3.amazonaws.com/","admin_score":20,"avg_stars":null,"avg_response_time":null,"avg_reliability_score":null,"avg_explainability_score":null,"price":30,"regions":[],"num_reviews":3,"reviews":null,"all_subjects":[{"id":4,"name":"Algebra I & II","category":"Math","tag_line":"this tag"},{"id":5,"name":"Geometry","category":"Math","tag_line":null},{"id":6,"name":"PreCalculus","category":"Math","tag_line":null},{"id":7,"name":"Calculus","category":"Math","tag_line":null},{"id":2,"name":"Basic math","category":"Math","tag_line":"this tag"},{"id":8,"name":"Chemistry","category":"Science","tag_line":"this tag"},{"id":9,"name":"Physics","category":"Science","tag_line":null},{"id":14,"name":"apps","category":"Other","tag_line":null}],"validated_subjects":[],"availability":null,"activities":[],"books":[],"colleges":[],"current_city":null,"favorite_athletes":[],"favorite_teams":[],"friends":[],"games":[],"high_schools":[],"hometown":null,"inspirational_people":[],"interests":[],"languages":[],"likes":[],"movies":[],"music":[],"politics":null,"religion":null,"sports":[],"television":[],"vouches":[],"expertises":[{"id":59,"ta_id":4,"subject_id":4,"validated":false,"avg_rated_competency":null,"tag_line":"this tag","admin_score":null,"subject_name":"Algebra I & II"},{"id":60,"ta_id":4,"subject_id":5,"validated":false,"avg_rated_competency":null,"tag_line":null,"admin_score":null,"subject_name":"Geometry"},{"id":61,"ta_id":4,"subject_id":6,"validated":false,"avg_rated_competency":null,"tag_line":null,"admin_score":null,"subject_name":"PreCalculus"},{"id":62,"ta_id":4,"subject_id":7,"validated":false,"avg_rated_competency":null,"tag_line":null,"admin_score":null,"subject_name":"Calculus"},{"id":58,"ta_id":4,"subject_id":2,"validated":false,"avg_rated_competency":null,"tag_line":"this tag","admin_score":null,"subject_name":"Basic math"},{"id":63,"ta_id":4,"subject_id":8,"validated":false,"avg_rated_competency":null,"tag_line":"this tag","admin_score":null,"subject_name":"Chemistry"},{"id":268,"ta_id":4,"subject_id":9,"validated":false,"avg_rated_competency":null,"tag_line":null,"admin_score":null,"subject_name":"Physics"},{"id":269,"ta_id":4,"subject_id":14,"validated":false,"avg_rated_competency":null,"tag_line":null,"admin_score":null,"subject_name":"u apps"}],"headline":"This headline","show":true}'


curl -XGET 'http://localhost:9200/testings/testing/_search' -d '{
    "query" : {
        "filtered" : {
            "query" : {
                "match_all" : {}
            },
            "filter" : {
                "not" : {
                    "term" : {
                        "show" : 1
                    }
                }
            }
        }
    }
}'