---
title: "Querying for Applications by US State"
slug: "querying-for-applications-by-us-state"
status: "new"
updated: 2026-06-18T20:17:16Z
published: 2026-06-18T20:17:16Z
canonical: "knowledge.technolutions.net/querying-for-applications-by-us-state"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Querying for Applications by US State

You can query for applications by U.S. state to understand where application volume is coming from. Use this approach to compare state-level demand, identify strong or underrepresented markets, and support recruitment planning.

#### Try a Slate example 💼

Copy this [Suitcase](/docs/suitcase-import) ID and paste it in **Database → Suitcase Import** to import a pre-made example query:

```SuitcaseID
55d2915b-4204-4449-a8b3-638bdbbb41db:slate-admissions-showcase
```

> [!NOTE]
> 💡 Tip
> 
> Find this query and other importable examples in the [Admissions Showcase environment](/v1/docs/showcase-environments).

## Reviewing application volume by state

An applications-by-state query can return one row for each U.S. state or region and show the number of applications associated with that location. This gives your team a quick geographic view of application volume.

The example uses each applicant’s primary address to count applications by state. It sorts the results from highest count to lowest count so the largest application markets appear first.

![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Number of apps by US state.png)

## Building the query

### Create the query

1. Go to **Queries / Reports**.
2. Select **New Query**.
3. Configure the following settings:
  - **Name:** Applications by U.S. state
  - **Folder:** Select the folder where the query should be saved.
  - **Type:** Configurable Joins
  - **Base:** World - Region
4. Select **Save**.

### Add the Country join

The Country join makes the country for each region available, which lets the query focus on U.S. states.

1. Select **Join**.
2. Select **Country**.
3. Select **Save**.

### Add the Country filter

1. Select **Filter**.
2. Under the joined **Country** path, select **Country**.
3. Select **Continue**.
4. Set the filter to `IN`.
5. From the list, select **United States**.
6. Select **Save**.

### Add region exports

These exports identify each state or region returned by the query.

- **World - Region / ID**, labeled **State Abbreviation**
- **World - Region / Plain**, labeled **State**
- **World - Region / Territory Name**, labeled **Region**

### Add the count subquery export

The **count** export is the main output column. It counts applications whose applicant’s primary address matches the current state row.

1. Select **Subquery Export**.
2. Name the export **count**.
3. Configure the following settings:
  - **Type:** Independent subquery
  - **Category:** Records
  - **Base:** Application
  - **Output:** Aggregate
  - **Aggregate:** Count

#### Same Region

This subquery filter connects each application back to the state row in the parent query. It checks the applicant’s primary address and returns applications where the address region matches the current **World - Region** row.

1. In the subquery export, create a join from **Application** to **Person**.
2. Create a join from **Person** to **Address by Rank Overall**.
3. Select **Subquery Filter**.
4. Name the filter **Same Region**.
5. Configure the filter to compare **Address by Rank Overall / Region** with the parent query’s **World - Region / ID**.
6. Select **Save**.

#### Same Country

This subquery filter keeps the application count aligned with the country context of the parent query. In this example, it supports the U.S.-state count by comparing the applicant’s primary address country with the parent query’s joined country.

1. Select **Subquery Filter**.
2. Name the filter **Same Country**.
3. Configure the filter to compare **Address by Rank Overall / Country** with the parent query’s joined **Country** value.
4. Select **Save**.
5. Select **Save** again to save the subquery export.

### Sort by application count

1. Select **Sort**.
2. Select the **count** export.
3. Configure the sort direction as **Descending**.
4. Select **Save**.

## Customizing the results

Adjust the query based on the geography or application population you want to review. For example, change the country filter to review a different country, filter the application subquery by round or entry term, or add application-status filters when you only want to count submitted, active, or complete applications.

You can also add exports for territory ownership, counselor assignments, or region groupings if the query will support recruitment travel, territory review, or leadership reporting.