To retrieve 2014, REG, week 1 games (default fields):

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": 1
  }
}

Request :

GET /games?s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":1}}

Response :

...
[
  {
    "id": "862bc634-5daf-4c07-b557-a88d03d973ec", 

    "week: {
      "season": 2014, 
      "seasonType": "REG", 
      "week": 1, 
    },

    "gameTime": "2014-10-13T00:00:00Z", 
    "gameType": "REG", 
    "homeTeam": {
      "id": "662bc634-5daf-4c07-b557-a88d03d973ec",
      "season": 2014, 
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "id": "962bc634-5daf-4c07-b557-a88d03d973ec",
      "season": 2014, 
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "gameStatus": {
      "gameClock": null, 
      "down": null, 
      "yardsToGo": null, 
      "yardLineSide": null, 
      "yardLineNumber": null, 
      "period": null, 
      "phase": null, 
      "possessionTeamId": null, 
      "redZone": null, 
      "homeTimeoutsRemaining": null, 
      "visitorTimeoutsRemaining": null
    }, 
    "homeTeamScore": {
      "pointsTotal": null, 
      "pointsQ1": null, 
      "pointsQ2": null, 
      "pointsQ3": null, 
      "pointsQ4": null, 
      "pointsOvertime": null, 
      "pointsOvertimeTotal": null
    }, 
    "visitorTeamScore": {
      "pointsTotal": null, 
      "pointsQ1": null, 
      "pointsQ2": null, 
      "pointsQ3": null, 
      "pointsQ4": null, 
      "pointsOvertime": null, 
      "pointsOvertimeTotal": null
    }
  }
]
...

To retrieve 2014, REG, week 1 games :

Field selector :

{
    gameTime, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}, 
    stadiumInfo
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": 1
  }
}

Request :

GET /games?fs={gameTime,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr},stadiumInfo}&s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":1}}

Response :

...
[
  {
    "gameTime": "2014-10-13T00:00:00Z", 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "stadiumInfo": {
      "id": "462bc634-5daf-4c07-b557-a88d03d973ec",
      "name": "Lucas Oil Stadium", 
      "location": {
        "formattedAddress": "500 S Capitol Ave, Indianapolis, IN 46225", 
        "street": "500 S Capitol Ave", 
        "city": "Indianapolis", 
        "postalCode": "46225", 
        "country": "USA", 
        "geoCoordinates": {
          "type": "POINT", 
          "latitude": 34.9484, 
          "longitude": 52.7202
        }
      }
    }
  }, 
  {
    "gameTime": "2014-10-13T00:00:00Z", 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Detroit Lions", 
      "nickName": "Lions", 
      "abbr": "DET"
    }, 
    "stadiumInfo": {
      "id": "162bc634-5daf-4c07-b557-a88d03d973ec",
      "name": "Raph Wilson Stadium", 
      "location": {
        "formattedAddress": "One Bills Drive, Orchard Park, NY 14217", 
        "street": "One Bills Drive", 
        "city": "Orchard Park", 
        "postalCode": "14217", 
        "country": "USA", 
        "geoCoordinates": {
          "type": "POINT", 
          "latitude": 42.7742258, 
          "longitude": -78.7869758
        }
      }
    }
  }
]
...

To retrieve 2014, REG, week > 4 games :

Field selector :

{
    week, 
    gameTime. 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}, 
    stadiumInfo{name}
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": {
      "$gt": 4
    }
  }
}

Request :

GET /games?fs={week,gameTime,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr},stadiumInfo{name}}&s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":{"$gt":4}}}

Response :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 5
    }, 
    "gameTime": "2014-10-13T00:00:00Z", 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Atlanta Falcons", 
      "nickName": "Falcons", 
      "abbr": "ATL"
    }, 
    "stadiumInfo": {
      "name": "Raph Wilson"
    }
  }
]
...

To retrieve 2014, REG, Week 3 to 10 games :

Field selector :

{
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": {
      "$gt": 2, 
      "$lt": 11
    }
  }
}

Request :

GET /games?fs={week,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr}}}&s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":{"$gt":2,"$lt":11}}}

Response :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 5
    }, 
    "gameType": "REG", 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Atlanta Falcons", 
      "nickName": "Falcons", 
      "abbr": "ATL"
    }
  }, 
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 3
    }, 
    "gameType": "REG", 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Chicago Bears", 
      "nickName": "Bears", 
      "abbr": "CHI"
    }
  }
]
...

To retrieve 2014, REG, DEN games :

Field selector :

{
    week, 
    gameTime, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "$or": [
      {
        "homeTeam.abbr": "DEN"
      }, 
      {
        "visitorTeam.abbr": "DEN"
      }
    ]
  }
}

Request :

GET /games?fs={week,gameTime,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr}}&s={"$query":{"week.season":2014,"week.seasonType":"REG","$or":[{"homeTeam.abbr":"DEN"},{"visitorTeam.abbr": "DEN"}]}}

Response :

...
[
  {
    "week": 1, 
    "gameTime": "2014-10-13T00:00:00Z", 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "id": "862bc634-5daf-4c07-b557-a88d03d973ec",
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }
  }, 
  {
    "week": 6, 
    "gameTime": "2014-10-13T00:00:00Z", 
    "homeTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "visitorTeam": {
      "fullName": "New York Giants", 
      "nickName": "Giants", 
      "abbr": "NYG"
    }
  }
]
...

To retrieve 2014, REG games with drives that had more than 2 first downs and more than 25 total yards :

Field selector :

{
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}, 
    drives
}

Query :

{
  "$query": {
    "season": 2014, 
    "seasonType": "REG", 
    "$and": [
      {
        "drives.firstDowns": {
          "$gt": 2
        }
      }, 
      {
        "drives.yards": {
          "$gt": 25
        }
      }
    ]
  }
}

Request :

GET /games?fs={week, homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr},drives}&s={"$query":{"week.season":2014,"week.seasonType":"REG","$and":[{"drives.firstDowns":{"$gt":2}},{"drives.yards":{"$gt":25}}]}}

Reponse :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 6
    }, 
    "homeTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "visitorTeam": {
      "fullName": "New York Giants", 
      "nickName": "Giants", 
      "abbr": "NYG"
    }, 
    "drives": [
      {
        "id": "862bc634-5daf-4c07-b557-a88d03d973ec",
        "possessionTeam": "1667", 
        "orderSequence": 5, 
        "quarterStart": 2, 
        "quarterEnd": null, 
        "gameClockStart": "12:20", 
        "gameClockEnd": null, 
        "realTimeStart": "2014-10-14T15:20:00Z", 
        "realTimeEnd": null, 
        "startYardLine": "40", 
        "endYardLine": null, 
        "yards": 30, 
        "firstDowns": 3
      }
    ]
  }
]
...

To retrieve 2014, REG, Week 6 games and within those games, get only the drives that had more than 2 first down :

Field selector :

{
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}, drives
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": 6
  }, 
  "drives": {
    "$query": {
      "firstDown": {
        "$gt": 2
      }
    }
  }
}

Request :

GET /games?fs={week,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr},drives}&s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":6},"drives":{"$query":{"firstDown":{"$gt":2}}}}

Response :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 6
    }, 
    "homeTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "visitorTeam": {
      "fullName": "New York Giants", 
      "nickName": "Giants", 
      "abbr": "NYG"
    }, 
    "drives": [
      {
        "id": "862bc634-5daf-4c07-b557-a88d03d973ec",
        "possessionTeam": "1667", 
        "orderSequence": 5, 
        "quarterStart": 2, 
        "quarterEnd": null, 
        "gameClockStart": "12:20", 
        "gameClockEnd": null, 
        "realTimeStart": "2014-10-14T15:20:00Z", 
        "realTimeEnd": null, 
        "startYardLine": "40", 
        "endYardLine": null, 
        "yards": 30, 
        "firstDowns": 3
      }
    ]
  }, 
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 6
    }, 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Atlanta Falcons", 
      "nickName": "Falcons", 
      "abbr": "ATL"
    }
  }
]
...

To retrieve 2014, REG, DEN games, sorted by week(highest to lowest) :

Field selector :

{  
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "$or": [
      {
        "homeTeam.abbr": "DEN"
      }, 
      {
        "visitorTeam.abbr": "DEN"
      }
    ]
  }, 
  "$sort": {
    "week.week": -1
  }
}

Request :

GET /games?fs={week,homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr}}&s={"$query":{"week.season":2014,"week.seasonType":"REG","$or":[{"homeTeam.abbr":"DEN"},{"visitorTeam.abbr":"DEN"}]}},"$sort":{"week.week":-1}}

Response :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 6
    }, 
    "homeTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }, 
    "visitorTeam": {
      "fullName": "New York Giants", 
      "nickName": "Giants", 
      "abbr": "NYG"
    }
  }, 
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 1
    }, 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbreviation": "DEN"
    }
  }
]
...

To retrieve 2014, REG games, sorted by week(lowest to highest) and homeTeam's abbr(alphabetical) :

Field selector :

{
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query :

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG"
  }, 
  "$sort": {
    "week.week": 1, 
    "homeTeam.abbreviation": 1
  }
}

Request :

GET /games?fs={week,homeTeam{fullName,nickName,abbr},visitorTeam}{fullName,nickName,abbr}&s={"$query":{"week.season":2014 "week.seasonType":"REG"},"$sort":{"week.week":1,"homeTeam.abbr":1}}

Reponse :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 1
    }, 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Detroit Lions", 
      "nickName": "Lions", 
      "abbr": "DET"
    }
  }, 
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 3
    }, 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Chicago Bears", 
      "nickName": "Bears", 
      "abbr": "CHI"
    }
  }
]
...

To retrieve the first 2 games of 2014, REG, Week 1, sorted by homeTeam.abbr(alphabetical) :

Field selector:

{
    week, 
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query:

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": 1
  }, 
  "$sort": {
    "homeTeam.abbr": 1
  }, 
  "$take": 2
}

Request :

GET /games?fs={week, homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr}}&s={"$query":{"week.season":2014,"week.seasonType":"REG","week.week":1},"$sort":{"homeTeam.abbr":1},"$take":2}

Response :

...
[
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 1
    }, 
    "homeTeam": {
      "fullName": "Buffalo Bills", 
      "nickName": "Bills", 
      "abbr": "BUF"
    }, 
    "visitorTeam": {
      "fullName": " Detroit Lions", 
      "nickName": "Lions", 
      "abbr": "DET"
    }
  }, 
  {
    "week": {
      "season": 2014,
      "seasonType": "REG",
      "week": 1
    }, 
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }
  }
]
...

To retrieve the second game of 2014, REG, Week 1 , sorted by homeTeam.abbr(reverse alphabetical order) :

Field selector:

{
    homeTeam{fullName, nickName, abbr}, 
    visitorTeam{fullName, nickName, abbr}
}

Query:

{
  "$query": {
    "week.season": 2014, 
    "week.seasonType": "REG", 
    "week.week": 1
  }, 
  "$sort": {
    "homeTeam.abbr": -1
  }, 
  "$take": 1, 
  "$skip": 1
}

Request :

GET /games?fs={homeTeam{fullName,nickName,abbr},visitorTeam{fullName,nickName,abbr}}&s={"$query":{"week.season": 2014,"week.seasonType":"REG","week.week" :1},"$sort":{homeTeam.abbr":-1},"$take":1,"$skip":1}

Response :

...
[
  {
    "homeTeam": {
      "fullName": "Indianapolis Colts", 
      "nickName": "Colts", 
      "abbr": "IND"
    }, 
    "visitorTeam": {
      "fullName": "Denver Broncos", 
      "nickName": "Broncos", 
      "abbr": "DEN"
    }
  }
]