Comparisons automatically generates a group of similar schools to yours nationwide, as well as local peers.

You’ll see charts and graphs comparing your trends across a variety of financial aid topics, like aid awards and tuition. Market View uses your DASL data to to generate insights and comparisons.

You can toggle on the AI option, which will generate summaries and insights based on your data benchmarked against these peer groups.

Schools can be grouped into two important types of groups: "peers" and "neighbors."

• Nationwide schools like me groups are made by looking at schools that are similar in certain ways, like the type of school, the number of students, the grades they offer, and the income of the nearby area. Schools that are alike in these ways get grouped together into a certain number of peer groups. We use machine learning and k-means cluster algorithms to group like schools together.

• Local neighbor groups are made up of schools that are close to each other and offer similar grades. Each school has its own group of nearby neighbors.

When we want to compare schools, we look at different statistics or numbers (like enrollment, tuition, or financial aid). These statistics can be calculated for individual schools or for the whole group of schools in a peer or neighbor group.

A comparison is when we take one of these statistics and look at how it changes over time for a school and its peer and neighbor groups. For example, we might compare how a school’s enrollment has changed over the past few years with its peers and neighbors. The comparison also comes with a title and a short summary that explains what we’re looking at.

Sometimes, the data for a school or group might be missing. This can happen if the school didn’t provide the needed information, or if there aren’t enough similar schools to create a good comparison.

Schools, groups, and their comparisons all depend on data that gets updated regularly. When new data is added or old data is changed, the statistics and comparisons are recalculated to keep everything up to date.

Market View's Comparisons AI feature uses AI technology. AI technology has come under scrutiny because of the massive computing power it requires to run.

Each day, Market View uses less AI computing power than an average user talking to ChatGPT. We are intentionally making our footprint as small as possible.

Market View sends a school's data to OpenAI for summary and insights once. If the data changes, we send it again to OpenAI for updates. This process is extremely efficient and narrowly scoped.

Even though our footprint is small, we take our water and energy use seriously. As educators, it's our responsibility to steward the planet for future generations.

Market View offsets the emissions generated by our AI use. We know that carbon offsets have their limitations, but it is important to mitigate our energy use until our tech is fully renewably powered. We purchase our carbon offsets from Native Eco.

NAIS uses OpenAI for our AI features. Microsoft Azure runs the servers powering OpenAI, and Azure is supposed to be on 100% renewable energy in 2025. Read more about Azure's sustainability goals here.

Getting started

When you first sign into Market View, you'll land on the Trends Page.

At the top of the page, you'll see some default settings. The query paragraph reads, "Showing data within: 30 minutes drive of my school at a $27,950 tuition level."

In Market View, all charts, graphs, tables, and maps are customized for your school.

Customize your query

• Customize the drive time query (choose a ten minute increment between 10-60 minutes)

• Customize the tuition level (input any dollar amount you'd like to research)

• Customize the geographical center point of the search. Market View has rich data for any US location. The location defaults to your school's address.

To change the drive time query or the tuition level, click into those text fields and adjust. To change the geographic centerpoint of the query, click "Change" near the address in the upper right.

Or, feel free to proceed without any customization! This query paragraph will always be at the top of the page for you to experiment.

Filter your data

Depending on where your school is, you may have a lot of ZIP codes in proximity. Market View lets you filter the data and focus on the most impactful areas. Click on the "113 ZIP codes" text and you'll see a list of all the ZIPs included in your search, as well as their neighborhood names.

You can click on any ZIP in the list and Market View will bring you to a page with every data point we use for that ZIP.

You can also search in the dropdown menu to find a specific ZIP or name.

Click "all" to open a dropdown where you can select how many ZIPs you want to see.

Click "Distance". You'll have the option of choosing distance, children, median income, or diversity.

For instance, you can elect to display only the 20 closest ZIPs, or the 30 highest income ZIPs, etc.

If you make selections using these filters, all other ZIPs will be hidden from the map and the data.

Let's move on to the results!

If you are seeing inconsistencies with the data syncing over from Veracross, please use this template to report the issues:

In addition, please let us know if there are any particular student record types that are missing from the data being synced over.

Read about Market View's AI features and the privacy rules governing the data used there.

Data access

Permission to sync or upload your admission data is granted by you or your school. Data refreshes needs to be triggered by you or your school. Market View will not sync data without your initiation, each data sync will need to be triggered manually by you or someone else at your school.

Encryption in transit

Market View encrypts all of its traffic. This includes data flowing between Market View and your admission software. It also includes traffic between Market View's backend and frontend. We are using exclusively https to transfer data, with SSL encryption with SHA-256. This is bank-level security. Market View receives an A+ on SSL reports.

In addition, NAIS enforces HSTS, HTTP Strict Transport Security. This means that all NAIS domains and subdomains deny any unencrypted traffic. We are registered with Chrome, Firefox, and Edge as enforcing HSTS.

Encryption at rest

Market View has taken the additional step to encrypt all student and school data within our database. This is above the usual standard of security, but we felt it was important to protect the data with which you are entrusting us. We are using encryption that features random initialization vectors and tagged ciphertexts.

Security audits

NAIS has conducted security audits with an outside cybersecurity firm to review compliance with proper security protocols and standards.

User access

The only users with access to Market View are paid NAIS members and premium subscribers. Your data is only accessible to users who have accounts within your school and to NAIS for debugging and analysis purposes. If you are curious about who has an account with your school, visit the member portal and click roster.

More

Read our terms and conditions here.

Solution: zoom out.

For Mac users, hold down "command" and tap the minus key.

For Windows users, hold down "ctrl" and tap the minus key.

• Ensure you can log into https://sso.nais.org

• Try deleting your cookies, clearing your cache, closing your browser, then try logging into Market View again

• We find often schools' firewalls or VPNs block the Market View domain. Please ask your IT department to allowlist the following URL: market-view-api-prod.onrender.com.

The 2022 data is the first year of data with the new 2020 Census included fully as both a benchmark year and underlying the estimates. This means we have seen some big shifts when looking at the newest EASI data compared to earlier year releases, this is true not just with income but many Census-based variables since they have all been newly re-benchmarked.

You can see the household and family counts in San Francisco decreased quite a bit overall from 2020 to 2022, therefore this general decline is driving much of the family count declines you are seeing between 2020 and 2022 rather than income shifts per se.

If you convert the numbers into percentages rather than the actual numbers, this may be more helpful for you in looking at trends since overall changes in numbers make it harder to see trends when looking at counts. See attached Excel file and refer to the highlight columns at the right for an example of this.

Due to the timing of when data sources are released, the impact of the pandemic in data sources is not seen in 2020 but rather in the EASI 2021 data and in the EASI 2022 data in some cases, due to the lags in data sources. When there is an unusual shift such as the pandemic (other examples are natural disasters such as Hurricane Katrina), we are constantly updating our projections and modeling as the latest data comes out.

One impact observed by the unusual 2020 time was slowed income growth and this can explain slower growth observed in general in income in certain instances and in the higher income categories specifically. For example, one theory is it may have been “easier” for a family to shift into the $150-200K group during this time than to shift into the $200K+ group or especially the $500K+ group. In general with Covid times, we have seen some shifts in income down in 2022 with a then expected uptick back up for 2027 though perhaps more modest 5-year gains forecasted than was projected in 5-year forecasts created a few years back.

Another point to keep in mind is that the EASI income data for the highest income categories is indeed modeled data based off of the family counts and full income distributions integrating the various income data inputs and also trends over time. Therefore, there is some built-in uncertainty in each estimate and very small percentage shifts can also be impacted by normal variability in the distributions and estimates. This can be seen in particular in very detailed categories such as cross tabs by both children’s age and income.

Look below the query paragraph in the blue header, and you'll see the Overview tab highlighted.

The Overview tab has three topics: Population Data, Income Data, and Diversity Data.

Population data

The map

If you look to the right side of the page, you'll see a multicolored map. This map is called a choropleth (core-o-pleth).

In our case, the choropleth represents total school-age population. Each shape outlined in gray is a ZIP code. The darkest blue shapes are ZIPs with the most children, and the light green ZIPs have the fewest children.

You'll see header text above the map. That's the title of the map, and also displays the data reflected in the map and the charts below. For example, "Total School-Age Population by ZIP Code within a 30-Minute drive of Washington, DC 20036-3425".

You'll also see a "Download" button with icon. Clicking this button will download the map exactly as shown. Before downloading, make sure to adjust your settings and parameters so that the map will show the data you need. Alternatively, you can screenshot the map if you like that better.

On the map, there is shape with a double blue line. This is called an isochrone (ice-oh-crone).

By our estimates, anyone living within the area bounded by the double blue lines can commute to your school within the travel time you specified. You'll see these isochrones throughout the various pages of Market View.

At the top of the map, there is a dropdown selector. The default selection is "Total School-Age Population". Market View defines School-Age Population as 0-18. Click that menu, and you'll see other options. Selecting a different option will cause the map colors to change, reflecting the new values you've chosen.

If you hover your mouse over a ZIP on the map, you'll see a small white box appear in the upper right corner of the map. In the screenshot below, the user is hovering over Riverdale and so the box in the upper right shows the value Riverdale has for the selected value. In this case, "Enrolled PK-12 Private Schools".

In the box in the upper right, "20737" is the ZIP Code, "Riverdale" is the locality name, and "619" is the number of children in that ZIP enrolled in PK-12 Private Schools.

Lastly, there is a gradated color scale below the map on the right. This scale shows the colors that reflect the minimum and maximum values, and their representative colors.

The data

Let's scroll down past the map.

You'll see a table titled Population Data. This tabular layout is probably familiar to you. Feel free to paste it into your spreadsheet editor of choice. From there you can make any custom charts or graphs you need, beyond the graphics available in Market View.

Read more about how and where we get our data.

Next steps

At the bottom of the page, you'll find suggestions for next steps. These suggestions are intended to help you make the most of Market View, on your own or as discussion questions with your team.

Income data

The Income Data subtab empowers you to analyze median income in your area.

You'll notice the title for the map is "Family Median Income by ZIP Code within a XX-Minute drive of YY Location".

Let's break this down!

Family is a census designated descriptor. It is distinct from household. Two unmarried adults are a household. Two married adults are a family. A single adult with a biological child is a family. The census considers people living together with a blood or marriage bond a family. Otherwise, it's a household. Two unmarried adults are a household until they have a child, and then they are considered a family.

You'll notice we use both designations in different places in Market View. Family income cuts off at $500,000, after that it is grouped into "$500k and over". Household income has granularity up to $750,000, after that it is grouped into "$750k and over".

Unless otherwise specified, "Family" in Market View also means "Families with children". Children are people aged 0-18.

The median income is the income amount that divides a population into two equal groups, half having an income above that amount, and half having an income below that amount. It may differ from the mean (or average) income.

Diversity data

The Diversity Data subtab offers an overview of the racial and ethnic breakdown within the selected rive-time parameter, set above.

Remember, if you are ever unsure about the information being displayed, the titles are a great place to start. Here, you'll see that the title of the map is "Total Population by ZIP Code within a XX minute drive of YY location."

This tab makes use of all of the functionality previously discussed in this guide- change the variable displayed in the choropleth map to view densities of a specific group, download the map, and view tabular data with five-year projections below.

Wait! What is the difference between race and ethnicity?

The Census considers race and ethnicity to be distinct concepts.

Race refers to the way a person self identifies with social group(s). The Census offers White, Black or African American, Asian, American Indian and Alaska Native Hawaiian and Other Pacific Islander, or some other race groupings. Participants can also report multiple races.

Ethnicity focuses on whether a person is of Hispanic origin or not.

When viewing your admission data, click on the name of the spreadsheet you want to delete.

Step 1: From "Your Data" page, click the name of the section containing the file you want to delete

Step 2: Select the file you want to delete

Step 3: Click the "x" icon

1. From Map View, run a query by clicking "Show me the results".

2. Then click "Download CSV"

3. You'll see the spreadsheet contains multiple lines for each ZIP code. This is because Market View provides data for multiple years.

Household Income data

You'll notice the default tuition setting is $27,950- this is the NAIS median tuition across all member schools. Update this parameter by typing your school's tuition level. If your school uses stepped-tuition, try viewing each different level or your school's average tuition with a few keystrokes.

Ability to pay is one lens through which school leaders can assess their market.

You'll see the income Market View estimates a family will need to earn to afford the entered tuition level at full-freight. The tool aggregates and crunches data from hundreds of thousands of financial aid applications submitted through the SSS application to make this determination. Based on the incomes reported by the Census in your area, Market View also provides an estimate of the proportion of households in your area earning this much within your designated drive time.

A good rule of thumb is that more than 15% of your market should be earning as much to avoid affordability strain in your admissions funnel.

"Right fit" families exist in all income bands. Market View offers a breakdown of the income needed to afford a spectrum of tuition contributions - from partial pay to full pay, as well as estimates about how much of the market earns each income level, in the breakdown below.

As always, this data can be copy & pasted into any spreadsheet editor, or downloaded via csv.

Below, you'll see the Financial Gap and Expected Household Contribution by Income Band.

This chart illustrates how much a families earning income in bands from <$25k to over $500K annually might be expected to pay and how much aid would be needed at the selected tuition level, according to data from hundreds of thousands of financial aid applications submitted through SSS.

Unlike calculations of average income, median income data is not skewed by large outliers- households making exceptionally high or low incomes.

Below, you'll see the five highest earning ZIPs within your drive time. Do these align with your anecdotal understanding of your market?

The Census provides more nuanced income information for households, allowing us to display incomes over $500K with more detail in the chart.

The chart shows the proportion and number of households in your selected drive time earning income at each level, as well as whether SSS would expect households in that income band to pay full tuition, contribute partial tuition, or require full aid.

If you prefer to work with tabular data, this information is included in the table below.

This chart contains a ton of information, so it can be useful to narrow the field of focus for targeted conversations. Market View has your back- hover the mouse over any of the bars in the chart to focus on one specific group, or use the small, colorful circles in the legend below the chart to toggle the data for different groups on or off.

You can also filter your data using the drop-down menus located just above the chart- click the type of data you'd like to filter, income or race/ethnicity, and click the blue check marks to engage or disengage selected variables.

There are three places your school's data appears in Market View: the map in Map View, the ZIP code detail cards also in Map View, and charts of your data display in the Enrollment section of the Trends page.

View your data on the map

• Click "Show me the results"

• Click the layer selector in the upper right corner and you'll see each of your data sets with a checkbox next to it.

• Click the checkbox to hide or show the data set. Note that the color of the icon matches the color of the pins on the map.

Your data is grouped into two categories in the layer selector panel, Admissions Data and Enrollment Data. Those two categories reflect the two categories of data you can add in the Your Data page.

View your data in ZIP code cards

If you want a more granular view of your data, check out the ZIP code cards in the left sidebar of the Map View. Every single ZIP code card will include your data, if you've uploaded it.

You'll see two groups: Admissions Data and Miscelleneous Data. Those reflect the two categories of data you can add in the Your Data page.

You'll also get calculations for your Admissions Data for the most recent two years. Total applicants, the percent of your applications which came from this ZIP, and the percent of school-age children from this ZIP who applied to your school.

Viewing your data in charts

To see charts of your data along with Market View's data, visit the Enrollments tab on the Trends page.

Population by Age Band: EASI Demographics

What is it?

How do we use it?

EASI’s age band estimates are used to provide an approximation of the school-age population of a single-year age across ZIP codes. These estimates are then combined with mapping technology supplied by Mapbox (described below) to generate the customizable map that you see within Market View.

Family Income, EASI Demographics

What is it?

How do we use it?

EASI’s median income estimates provide an economic snapshot of the various areas in your local community. EASI’s estimates of median family income can be used to get a sense of the wealth distribution of your area, or to see how affordable your school is for a typical family in your community.

Population by Sex by Race/Ethnicity, EASI Demographics

What is it?

How do we use it?

EASI’s estimates for population by race/ethnicity provide schools with a fuller picture of the diversity of their local student population. These estimates are useful for schools seeking to understand how the racial and ethnic diversity of their student body compares to the local population. In addition, EASI’s estimates for population by sex provide more flexibility for single sex schools and other schools seeking to understand local differences in male and female populations. Note that Market View does not currently contain data on gender, as the underlying sources of data (EASI and the Census Bureau) do not currently collect this data.

Drive-Time Area, Mapbox Navigation Service

What is it?

How do we use it?

We heard from members that time, not distance, is the most important metric in measuring a commute. As opposed to simply measuring distance, drivetimes provide a more comprehensive understanding of how conveniently located your school is for families in the area. In addition, Mapbox’s traffic control features provide a realistic understanding of the time it will take families to reach your school during typical commuting hours.

Five-year Data Projections, EASI Demographics

What is it?

How do we use it?

EASI’s projections are a great way to get a sense of how your local area will be changing over the next several years. While projections are not often 100 percent accurate, they are a great starting point to see trends and begin conversations around how the school-age population, demographics, and income profile of your area are changing.

Public and Private School Data, National Center for Education Statistics (NCES)

What is it?

The National Center for Education Statistics (NCES) provides data on public and private schools, which is gathered through its universe surveys each year. The surveys provide data on many schools across the United States, including basic descriptive information such as location, web address, and grade levels served.

How do we use it?

NCES’s school data is uploaded into Market View’s map, so you can see other schools in your area. Each school is represented by a black circle on your map. Clicking the circle will provide the school’s name, type (Public/Private), website (where available), and grade levels served.

Affordability Data

What is it?

NAIS uses data provided by Community Brands’ School and Student Services (SSS) financial aid service which analyzes applications for families across the country. Using the family income and parent contribution data from submitted applications, we calculate the median percentage of income that parents are asked to contribute to school costs by income bands. The contribution is subtracted from the tuition entered by the user to determine the estimated financial gap a family is likely to have to cover.

How do we use it?

By estimating the financial gap between what a family at the median income in a ZIP code is able to pay and the tuition your school, you will have a better picture of how affordable your tuition is in your market.

There are two types of data you can add to Market View, student and miscellaneous.

Student data

Student data can be either applicants or enrolled students. You can include up to five data points about each student.

1. First name

2. Last name

3. Grade

4. ID

5. Address

If you don't want to include any of the above fields, due to privacy concerns or other reasons, feel free to omit them. The importer will work with all columns blank except for address. If you don't want to add addresses either, you can pare it down to just ZIP codes.

Miscellaneous data

Miscellaneous data can be teacher addresses, bus stops, feeder schools, any data source that you find helpful. You can only upload addresses for this type of data.

Online Marketing

Direct Mail

The Post Office will let you select individual postal routes to include. This is helpful especially if you have a bus stop nearby and you are looking for families with easy access to that bus stop.

Market View uses OpenAI to generate the insights we show you about your data on the Comparisons page.

Overview

To add AI Insights to your Comparisons, Market View sends 25 of your DASL datapoints related to financial aid. We are not sending any of your data with words in it, no school names, other names, etc. Only a select list of numbers are shared temporarily with OpenAI to generate insights.

We are using OpenAI's API. We are not using ChatGPT. We send OpenAI a list of numbers and ask it to generate an insight, which we then display on the screen to you.

OpenAI does not use your data to train their models. From OpenAI: We do not train our models on your business data by default. Unless they explicitly opt-in, organizations are opted out of data-sharing by default.

OpenAI temporarily stores your data on their servers for 30 days. This is standard practice for web services so they can have a paper trail to protect against nefarious use. From OpenAI: OpenAI may securely retain API inputs and outputs for up to 30 days to identify abuse.

Read more at OpenAI's Enterprise privacy document. Please note that this is different than their ChatGPT offering, ChatGPT is much less private.

Questions and Answers

Which subprocessor(s) is/are being used to produce AI-generated completions?

• OpenAI uses this list of subprocessors.

Which AI language models are being used?

• GPT-4o mini

Is the AI in question based on machine learning algorithms or large language models?

• Yes, LLM.

Is user data either user related PII or otherwise uploaded data being used to train the AI model?

• No

Is data being used to improve the product via AI?

• No

What explainability measures (if any) are used in understanding the output of the AI model?

• We're prompting the LLM to make the response easy to understand, and providing users the data used so they can understand and analyze the AI responses.

How long is data retained? Where? Is any data such as prompts cached for performance?

• OpenAI retains the data for 30 days, then deletes it.

What steps (if any) have been implemented to reduce bias in AI generated output?

• Since this is a very small set of anonymous numeric financial data, there is no concern about biased output.

Microsoft Excel

1. Open your CSV file in Microsoft Excel.

2. Click File in the top-left corner of your screen.

3. Select Save as...

4. Click the drop-down menu next to File format.

5. Select CSV UTF-8 (Comma delimited) (.csv) from the drop-down menu.

6. Click Save.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported.

Numbers

1. Open your CSV file in Numbers.

2. Click File in the top-left corner of your screen.

3. Select Export to... -> CSV...

4. Click Advanced options.

5. Click the drop-down menu next to Text Encoding.

6. Select Unicode (UTF-8).

7. Click Next

8. Choose a name and location for your new file and click Save.

Your new CSV file is now encoded using the UTF-8 format and is ready to be imported.

Market View can help you identify trends for your local market. For example, let's say we wanted to look at affordability and race/ethnicity. We might want to show the Change in Average Household Income by Race/Ethnicity and Change in School-Aged Population by Race/Ethnicity.

At the end of this 5-minute tutorial, you will have artifacts like these two slides. These are just two examples of the trends you can look at in Market View.

Looking at Change in Average Household Income by Race/Ethnicity

Let's first take a look at the Change in Average Household Income by Race/Ethnicity. We'll go to the Affordability section under the Trends tab in Market View.

Next, we'll select Change in Average.

We'll download an image of this graph by clicking the Download button in the top right.

Looking at Change in School-Aged Population by Race/Ethnicity

Now, let's grab our second graph that shows Change in School-Aged Population by Race/Ethnicity.

We'll go to the Diversity section under the Trends tab in Market View.

Next, we'll select Change.

Finally, we'll download an image of this graph by clicking the Download button in the top right.

That's it! We have the two graphs we need for our presentation. We can just drop them into our presentation like this.

These are just two of 16 trend graphs available in Market View. Have fun digging into the data and trends for your local market!

Market View can help you demonstrate what your school's reach looks like now compared to five years from now. Here's how you might show that difference.

At the end of this 10-minute tutorial, you will have artifacts like these two slides.

Upload Your Addresses

Let's dive into how to create this set of visuals for your school.

We'll start by adding your school's data into Market View. NAIS will never share your addresses, and you can delete them any time.

First, click and download the CSV template below and replace the example data with your school's.

The video below (<2 minutes) shows you how to do that.

Create Your Visuals with Map View

Now that your data is in Market View, let's create your visuals.

First, navigate to the Map View tab.

Fill in the underlined items on the left and click Show me the results.

Creating a Visual for the Current Year

Select the type of map you want by clicking (change) above the map on the right and select Median Income by ZIP code in...

Add your data by selecting clicking the Map Layers button and selecting the data you would like to add.

Finally, position the map as you would like and click on the Download button and Download map to create a screenshot of just the map.

That's it! You're done with your school's current reach. Let's work on the 5-year forecast now.

Create a visual for projections

Click to fill the checkbox for 2025 Forecast and click download the map for the 2025 forecast.

Now that you have your visuals you can insert them into your next presentation. Here's what that looks like for our Acorn School example.

​​

Overview

Audience

Goal

This integration syncs two types of data from Blackbaud into Market View.

1. Applicants. If it exists, we will sync names, grades, addresses, and student IDs for students who applied to your school.

2. Enrollments. If it exists, we will sync names, grades, addresses, and student IDs for students who enrolled in your school.

Step 1: Give yourself permissions in Blackbaud

You'll need to go to Core > Security > Roles. (Do not try to manage roles for this from the security/control panel area).

Find the role in the list and choose Manage Roles from the menu.

Go to Members, Add member and search for yourself to add.

You'll need these roles:

1. Platform Manager or Environment Admin

2. Academic Group Manager, Schedule Manager, or Platform Manager

3. SKY API Data Sync

4. Admissions Manager

Step 1: Add Market View to Blackbaud

• Log into Blackbaud.

• You should see something like this

• Click "Connect"/ "Get Started"

• Follow the steps to finishing adding Market View as an integration partner

Step 2: Authorize Market View

• Click on "Connect to Blackbaud"

• Click "Log in with your Blackbaud Account"

• A window should pop open where you can log in with your Blackbaud credentials

• You should be routed back to Market View. Congratulations!

Next steps

• Now that your integration is complete, you can sync fresh data from Blackbaud anytime by clicking the "Sync" button.

Logging in

All good? Let's explore some of the main Market View features and concepts, starting with Trends.

Market View had a "Library" feature, which were bookmarks, links to the URLs to your reports. The feature was not used often, so we deprecated this feature. You can copy this functionality by using your browser bookmarks. When you get the location and parameters to a map you like, bookmark it in your browser to be able to quickly return to it.

Note: neither Library bookmarks nor browser bookmarks preserve your layer selections, only your location and parameters set in the query paragrah.

There are two types of data you can upload to Market View, student enrollment data and miscellaneous data. Because Market View is geographically driven, all data uploaded should have an address (a ZIP code at the very least).

Upload student enrollment data

You'll need one spreadsheet per year, containing all your applications or enrollments for that year. Please use this template and fill it in with your data.

For student data (applications and enrollments), the template contains five columns. We ask for Student ID so that one day we can show you attrition data, since it allows us to see when students move on to the next grade.

Next, navigate to Your Data. Drag and drop each file to the appropriate school year bucket.

Upload miscellaneous data

You can upload any type of addresses into the Miscellaneous category. Schools upload bus stops, faculty addresses, competitor schools, coffee shop locations, anything that would be helpful to see plotted on the Market View map.

Miscellaneous data only needs a valid address, no title or name required.

For miscellaneous data, the template contains four columns for each address. You can just upload a single column with the entire address as well, if it's easier. Market View concatenates the whole address before geocoding, so it doesn't matter how many columns you use as long as it's only one address per row.

Next, navigate to Miscellaneous Data. Drag and drop each file to the gray bucket. Note that the file name will be used to label this data set in Your Data, as well as in Map View.

Addresses on miscellaneous data uploads which appear more than once won't show up. If you have an address listed more than once per file, it won't show up on the map or the address counts.

Any data that you uploaded prior to August 2022 was migrated to the Miscellaneous Data category. If that data would be better in the applications or enrollments categories, feel free to delete and re-upload. Please make sure you have a local copy of the data before you delete it from Market View, deletion is final. If you no longer have access to that data, and need to download it from Market View, please reach out and we wil try to help you get access.

International addresses

Whenever you upload or import address data to Market View, we attempt to geocode it. Geocoding is the process of converting an address into a latitude/longitude pair of coordinates.

Often, international addresses will not geocode correctly. Here is a map with the countries with the most accurate and least accurate geocoding.

If your international address geocodes succesfully, you will see it on the map if you select that dataset's map layer. If the address doesn't geocode sucessfully, you will not see it plotted on the map.

After you upload your data, Market View will notify you if it had issues with any of the addresses. Feel free to delete the dataset, fix it, and try again. Often, putting the address into Google Maps and using the address the way Google formats it can be helpful.

Tutorial Video

Overview

Audience

Goal

This integration syncs two types of data from Veracross into Market View.

1. Applicants. If it exists, we will sync names, grades, addresses, and student IDs for students who applied to your school. Note: applicants need to have an "application date" to be considered applicants for this process.

2. Enrollments. If it exists, we will sync names, grades, addresses, and student IDs for students who enrolled in your school.

Instructions

Step 1: Add Market View to Veracross

• You should see something like this:

• Select the card titled “NAIS Market View”.

• Click "Start Integration".

• Click the green button at the top "Add application".

• Keep your Veracross tab open for the next step.

Step 2: Add Scopes

• Select the following scopes:

  1. admission.applicants:list

  2. admission.applications:list

  3. admission.households:list

  4. alumni.demographics:list

  5. students:list

• Click the green "Update" button at the top

• Keep your Veracross tab open, you'll need to copy and paste from this page into Market View.

Step 3: Add Veracross details to Market View

• Click on "Connect to Veracross"

• Copy and paste your Client ID, Client Secret, and School Route from Veracross.

Step 4: Connect

• Click "Connect".

• Congratulations! Your data is now in Market View.

Next steps

• Now that your integration is complete, you can sync fresh data from Veracross anytime by clicking the "Sync" button.

How it works

1. Fetch all historical students, applicants, applications, and applicant households

2. Discard students marked as "applicants" who haven't yet applied (these are usually just prospects)

3. Match each applicant to an application and household

   1. If a matching application or household can't be found, an import failure is created

4. Assign a grade level to each applicant

   1. If a grade level doesn't match our list of accepted grades, an import failure is created

5. Match each student to an applicant

   1. If a matching applicant isn't found (e.g. if the applicant became an import failure), an import failure is created

6. For each applicant, look up or geocode their address

   1. An applicant's corresponding student is also assigned this address

   2. If an address can't be geocoded, the student and the applicant become import failures

7. Applicants are separated by year and saved into corresponding "applications" admissions lists

8. A student can be saved in several "enrollments" admissions lists

   1. A student is saved in the enrollment list for the year of their "entry date", at the grade level from their application ("grade level applied for")

   2. Each year after that, until their "exit date", a student is saved in that year with the next grade level

   3. We assume students are promoted each year, since we don't have grade level information for a student for each year

• The file is a .csv file extension

• The file has the correct headers (First name, Last name, Address, ID, Grade). Schools sometimes use "student ID" but the column needs to be "ID".

If you follow these steps and are still having trouble, please reach out!

American Community Survey (ACS)

The American Community Survey (ACS) is a demographics survey program conducted by the U.S. Census Bureau. It regularly gathers information previously contained only in the long form of the decennial census, such as ancestry, citizenship, educational attainment, income, language proficiency, migration, disability, employment, and housing characteristics. These data are used by many public-sector, private-sector, and not-for-profit stakeholders to allocate funding, track shifting demographics, plan for emergencies, and learn about local communities.[1] Sent to approximately 295,000 addresses monthly (or 3.5 million per year), it is the largest household survey that the Census Bureau administers.[2]

Source: Wikipedia

Children of Color

For Market View, "Children of Color" or "Students of Color" are children aged 0-17 who do not identify as white. We acknowledge that this definition is lacking and problematic but unfortunately we are working from the Census data and have to work within its established categories.

For Market View's purposes "children of color" equals the total amount of children minus white/non-hispanic children.

Choropleth

Pronounced "core-o-pleth".

A choropleth map (from Greek χῶρος (choros) 'area/region', and πλῆθος (plethos) 'multitude') is a type of statistical thematic map that uses pseudocolor, i.e., color corresponding with an aggregate summary of a geographic characteristic within spatial enumeration units.

Source: Wikipedia

People often confuse a choropleth map for a heatmap. Market View does not contain heatmaps. Choropleths have distinct geographical boundaries for each color, whereas heatmaps show gradual color changes.

Easy Analytic Software (EASI)

EASI is a New York-based demographics data solutions and statistical estimating firm that specializes in consumer demographics. EASI takes public data, and provides it to NAIS along with their own projections.

Family

A family is a group of two people or more (one of whom is the householder) related by birth, marriage, or adoption and residing together; all such people (including related subfamily members) are considered as members of one family.

Source: Census Bureau

Heatmap

A heat map (or heatmap) is a data visualization technique that shows magnitude of a phenomenon as color in two dimensions. The variation in color may be by hue or intensity, giving obvious visual cues to the reader about how the phenomenon is clustered or varies over space.

Source: Wikipedia

Household

A household consists of all the people who occupy a housing unit. A house, an apartment or other group of rooms, or a single room, is regarded as a housing unit when it is occupied or intended for occupancy as separate living quarters; that is, when the occupants do not live with any other persons in the structure and there is direct access from the outside or through a common hall.

A household includes the related family members and all the unrelated people, if any, such as lodgers, foster children, wards, or employees who share the housing unit. A person living alone in a housing unit, or a group of unrelated people sharing a housing unit such as partners or roomers, is also counted as a household. The count of households excludes group quarters.

Source: Census Bureau

Isochrone

An isochrone map in geography and urban planning is a map that depicts the area accessible from a point within a certain time threshold. An isochrone (iso = equal, chrone = time) is defined as "a line drawn on a map connecting points at which something occurs or arrives at the same time".

Source: Wikipedia

Median income

The median income is the income amount that divides a population into two equal groups, half having an income above that amount, and half having an income below that amount. It may differ from the mean (or average) income. The income that occurs most frequently is the income mode.

Source: Wikipedia

Saturation

Market View uses this formula to calculate saturation: A school's enrollment in a given ZIP, divided by the total school age population in that ZIP.

Travel time

Market View uses Mapbox to calculate travel times.

Traffic Data speed predictions are calculated using the 300 million miles of de-identified location data collected daily from mobile devices running Mapbox-powered apps.

Source: Mapbox

Market View's mapping depends on a browser engine called WebGL. You'll need to have an updated browser to see the map. If you can't see the map, please update your browser.

In Blackbaud, each student has a status. Blackbaud data doesn't have a definitive marker for "applicant", applicants fall under "inquiries" in the system.

In order to sync your applicants from Blackbaud, Market View looks for statuses that have “applicant” in the name, plus any statuses that could have an applicant status as a parent status.

This usually excludes the inquiry statuses, since students usually can’t progress from “applicant” status to “inquiry”, but it depends on how a school sets up their statuses.

If you are missing students from your "applicants" list in Market View, change their status or parent status to include the word "applicant". Then refresh your data and you should see them included.

If you have questions about your applicant data, please get in touch.

Finalsite's API is in beta, and Market View does not currently have an integration. To request that NAIS build a data integration for your Finalsite data to Market View, email us at [email protected] and let us know you would like to sync your data from the platform into Market View. We will continue to monitor the progress of the Finalsite API.

The following quick guides will walk you through creating a presentation with Market View's graphs and data.

We will be building a presentation just like this one. Feel free to duplicate these slides, and then use the following guides to replace the data and graphs with your school's data and graphs.

To cite Market View, you can use the full name of the software: "NAIS Market View". We also recommend citing the source of the underlying data as well.

Market View can help you make the case for a proposed tuition change. It can help you estimate how many households in your area can afford full tuition.

Here are a few slides for our example school.

At the end of this 20-minute tutorial, you will have artifacts like these three slides.

Getting Your Affordability Posture

First, let's get our affordability posture.

We'll navigate to the Affordability section.

On the Summary tab, Market View gives us an estimate of how many households can afford full tuition. We can copy and paste this into presentation to create our first slide.

Looking at Race/Ethnicity Household Income Distribution

Next, we want to look at the distribution of household income by race/ethnicity.

We'll click on the Race/Ethnicity tab.

You can download the graph by clicking the Download button. Now, you can add that image to your presentation.

Census and American Community Survey data

The US Census happens once a decade, and the ACS is conducted in intervening years. In Market View, the years ending in "0" are census data, whereas data for all other years is from the ACS.

Population by Age Band: EASI Demographics

What is it?

EASI provides population estimates by age band (0-4,5-9, etc.) for the current year. These estimates are created using the 2010 census numbers, American Community Survey Data, and Public Use Microdata Survey. To calculate projections, EASI uses the estimates above as a starting point and applies population component change estimates (births, deaths, migration, etc.) to move that number forward. Read the full methodology here.

How do we use it?

EASI’s age band estimates are used to provide an approximation of the school-age population of a single-year age across ZIP codes. These estimates are then combined with mapping technology supplied by Mapbox (described below) to generate the customizable map that you see within Market View.

Family Income, EASI Demographics

What is it?

EASI’s income model builds on a base estimate created using 2010 census data and estimates from the American Community Survey. EASI creates estimates from here by using consumer income survey data provided by the census (P60 Publication Series) and other sources of income data. Differences between the estimates provided from these data and the ACS values are analyzed to provide a final estimate. Income estimates use the 2010 Census household definition of income as a benchmark. Read the full methodology here.

How do we use it?

EASI’s median income estimates provide an economic snapshot of the various areas in your local community. EASI’s estimates of median family income can be used to get a sense of the wealth distribution of your area, or to see how affordable your school is for a typical family in your community.

Population by Sex by Race/Ethnicity, EASI Demographics

What is it?

EASI also provides population estimates by sex and race/ethnicity for age bands in the current year. EASI uses annual estimates released by the census as the basis for their population by sex by race/ethnicity data. To calculate projections, EASI uses the census estimate as a starting point and applies population component change estimates (births, deaths, migration, etc.) to move that number forward. Read the full methodology here.

How do we use it?

EASI’s estimates for population by race/ethnicity provide schools with a fuller picture of the diversity of their local student population. These estimates are useful for schools seeking to understand how the racial and ethnic diversity of their student body compares to the local population. In addition, EASI’s estimates for population by sex provide more flexibility for single sex schools and other schools seeking to understand local differences in male and female populations. Note that Market View does not currently contain data on gender, as the underlying sources of data (EASI and the Census Bureau) do not currently collect this data.

Drive-Time Area, Mapbox Navigation Service

What is it?

Mapbox’s traffic tilesets provide drivetime information, or the time it takes to get from point A to point B, to their maps. Mapbox bases its drivetime estimates on travel data that is transmitted from users of apps embedded with Mapbox technology, such as Airbnb, Instacart, and Snapchat. This data, which consists of over 220 million miles of travel per day, is used to predict and extrapolate real-time traffic, helping to further improve the accuracy of drivetimes. Read the full methodology here.

How do we use it?

We heard from members that time, not distance, is the most important metric in measuring a commute. As opposed to simply measuring distance, drivetimes provide a more comprehensive understanding of how conveniently located your school is for families in the area. In addition, Mapbox’s traffic control features provide a realistic understanding of the time it will take families to reach your school during typical commuting hours.

Five-year Data Projections, EASI Demographics

What is it?

EASI demographics provides five year projections for the population and income variables described above. These projections use EASI’s current year estimates as a starting point, and apply growth models to obtain a five year projection. The models incorporate factors such as births, deaths, and migration to obtain population projections, and build on data from the American Community Survey and Census Consumer Income Survey to obtain income projections. Read the full methodology here.

How do we use it?

EASI’s projections are a great way to get a sense of how your local area will be changing over the next several years. While projections are not often 100 percent accurate, they are a great starting point to see trends and begin conversations around how the school-age population, demographics, and income profile of your area are changing.

Public and Private School Data, National Center for Education Statistics (NCES)

What is it?

The National Center for Education Statistics (NCES) provides data on public and private schools, which is gathered through its universe surveys each year. The surveys provide data on many schools across the United States, including basic descriptive information such as location, web address, and grade levels served.

How do we use it?

NCES’s school data is uploaded into Market View’s map, so you can keep your eye on competitors and potential feeder schools in your area. Each school is represented by a black circle on your map. Clicking the circle will provide the school’s name, type (Public/Private), website (where available), and grade levels served.

Affordability Data

What is it?

NAIS uses data provided by Community Brands’ School and Student Services (SSS) financial aid service which analyzes applications for families across the country. Using the family income and parent contribution data from submitted applications, we calculate the median percentage of income that parents are asked to contribute to school costs by income bands. The contribution is subtracted from the tuition entered by the user to determine the estimated financial gap a family is likely to have to cover.

How do we use it?

By estimating the financial gap between what a family at the median income in a ZIP code is able to pay and the tuition your school, you will have a better picture of how affordable your tuition is in your market.

• You have Platform Manager or Environment Admin permissions

• You have one of the following permissions: Academic Group Manager, Schedule Manager, or Platform Manager

• You have the SKY API Data Sync permission

• You have completed both steps on this page: https://marketview.nais.org/your-data/blackbaud/connect

If all of the above are true, and you're still having issues, please get in touch! Here is the template for reporting data discrepancies.

In addition, please let us know if there are any particular student record types that are missing from the data being synced over.

Market View can help you get really specific and look at specific ZIP codes. Here's how we might show that information for our example school.

At the end of this 10-minute tutorial, you will have artifacts like these four slides.

Getting Detailed Information for Different ZIP Codes in Map View

First, navigate to the Map View tab.

Fill in the underlined items on the left and click Show me the results. The Map will update based on your search criteria.

Sort ZIP codes by median income, number of children, and number of children of color

You can Sort by median income, number of children, and number of children of color to start refining your search.

Show 5-year Forecast

We can take a look at how the market might change in the next 5 years by clicking the 2025 Forecast checkbox.

You can get more detailed data by clicking the Your Data and Demographics accordion toggles.

Now that you have the data you're interested in, you can start putting together a slide that tells a data-rich story.

Here's an example where we are showing the total addressable market for the 20001 ZIP code and what the numbers for a five-year goal of 0.5% might look like.

That's it! You're ready to get detailed data for your school's local market and tell your data story.

Market View 6

Version 6.4.0

• Remove old google analytics

• Update wording in about our data page

• Make entire nav boxes clickable

• Redirect to /your-data after connecting veracross

• Swap to show DASL value in column when there is a mismatch

• Bump @percy/cli from 1.8.0 to 1.26.0

• Add admissions data to standalone zip view

• Update mapbox

• Add forecasts to zip view

• Update affordability statement text

• Add a column for 10-year change to the overview tab of trends.

• Add parenthetical percentages to race counts on data cards

• Split feature flag for blackbaud and veracross

• Fix for race breakdown percentages when zero

• Update text around the beta

• Change styling of the race breakdown percentages

Version 6.1.0

• Label counts for admissions list data as 'students' rather than

• Add sparkles emoji to the new tag

• Add overlay to tables that are scrolled horizontally

• Copy edits on sort bar on trends

• Updates to trends/enrollments

• Only use localstorage for map layer status on /map

• Add admissions data section to map cards

• Add choropleths for most recent and second most recent year applications

• Request previous three years, not including current school year for

• Display admissions items in the zip on the map, including a tooltip

• Add filter to request for admissions list items on map to only get two most recent years

• Update text of link to download upload template / Obscure client secret field on veracross form

• Rename multiple to multiracial

• Correct tutorial "hole" on filters on very wide monitors

• Fix bug where zip codes would toggle visibility when mousing over

Version 6.0.0

• New "Your Data" section with ability to add admissions data

• Enable a new section under trends: "Enrollment" that uses admissions data

• Add in-app chat

• Update help link

• Update terms and conditions

• Format saturation and conversion totals as percentages with one decimal

• Fixes for analysis chart

• Add (last 10 years) to opportunities sort selector options

• Fix text color of school tooltips on maps

• Remove population series from diversity chart on my-school/trends

• Update link to uploading field guide

• Update Check Now links to Learn More and link to help sections

• Implement the help modal on Your Data

• Add terms notice to connect pages and data upload pages

Market View 5

Version 5.0.15

• Update terms

• Fix full-pay, partial-need, and full need labels on distribution chart when all of a particular section is deselected

• Fix some library UI issues

• Fix display of author on reports in library

• Replace many address fields on school with one, 'address'

Version 5.0.8

Released May 10, 2022

• Change choropleth on trends/overview to be forecast percentage

• Remove the dash in the drive time selectors

Version 5.0.7

Released May 2, 2022

• Upgrade to 4.2 of Ember + addons

• Delete the old research tab

• Fix uploading multiple files and dropping files

• Remove zip labels on trends

• Add tooltips on zip lists on trends

• Add year selector to population change chart

• Hide All Ages series by default on School-age population by age

• Add tooltip for private schools on trends

• Extend styles from trends to the rest of the app

• Add percentage of children of total population as choropleth option

• Display 'No addresses found' when no results searching for addresses

• Remove boxes around data labels on column charts on map

• Add query params to trends for drive time, centerpoint and tuition so they persist across tab and when sharing links

• Persist layer selection status in local storage

• Remove ability to edit age preferences

• Change age buckets on trends to default buckets

• Fix horizontal scroll on mobile

• Create the new 'Your Data' route, available at /your-data

• Update fields to correctly display PK-12 instead of K-12

Version 5.0.6

Released March 04, 2022

• Allow duplicate addresses across datasets

Version 5.0.5

Released Feb 08, 2022

• Add option of selecting boys, girls, children in the query paragraph on Map View

• Improve render performance on the Map View when many zips are returned

• Replace the forecast toggle with a checkbox

• Display a warning 5 minutes before a user's session will expire, giving the user the option to log in again or to keep working

• Display a dialog when the user's session is expired, telling the user to log in again

• Use contribution %s for financial gap calculations

• Display a tooltip on income breakdown charts on cards to show the financial gap for each income range

• Round affordability numbers to nearest 1000 to convey their fuzziness

• Add a chart to trends/affordability to show the breakdown of tuition into financial gap and contribution

• Add zones for full pay / partial need / full need to household income distribution by race chart on Trends

• Add additional quotes to the landing page

• Link ZIPs to an page with all data about that ZIP

Version 5.0.4

Released June 16, 2021

• Display names of ZIPs where they are displayed

• Add additional controls to show and hide series on charts on the Trends tab

• Add ability to save images of maps on Trends

• Add a legend for the travel time display on maps on Trends

• Fix a bug on the Map tab where clicking on a ZIP in the map that started with '0' would not scroll to the ZIP's card

• Show labels on maps when zoomed out further

• Show the tuition on saved reports

• Fix the display of ZIPs on the maps in the Library

• Various Copy Edits

Version 5.0.3

Released Jun 07, 2021

• Improve the mobile UI of the trends area

Version 5.0.2

Released May 19, 2021

• Add more debugging info around missing location info

Version 5.0.1

Released May 18, 2021

• Adjust styles to make control sentence UI work on mobile

• Change how copying works to possibly make it more reliable on Chrome

• Add debugging around fetching zips if the lat and long are missing

Version 5.0.0

Released May 17, 2021

• Add /trends section

• Remove /research

• Move Trends to be the landing page after login

Market View 4

Version 4.5.1

Released May 03, 2021

• Add /trends but keep it hidden until we're ready to release

Version 4.5.0

Released Mar 15, 2021

• Add additional map color options and data about children of color

• Close the upper-left hamburger menu when clicking anywhere outside of it

• Display a tooltip on the map when clicking a point from an address dataset

• Upgrade Ember

• Upgrade Highcharts

Version 4.4.0

Released Jan 07, 2021

• Appropriately title the filenames of downloads of charts

• Appropriately title data in chart downloads

• Hide duplicate dropdown navigation items (under hamburger) on desktop

• Bugfix: Correctly get fresh data for forecasted reports when chosen search parameters change

• Bugfix: Hide children-of-color data and maps until data can be corrected

• Bugfix: Show the year of data displayed, not current year, under the income breakdown charts

Version 4.3.0

Released Dec 14, 2020

• Change the selection of the visualization variable to a selection of map visualization by name

• Default to showing 'Number of Children by Zip Code' map visualization

• Default the map zoom to encompass all the zip codes in the result, rather than just the travel time border

• Show a tooltip in the upper right of the map when a zip code is hovered with details for that zip

• Make the Layer Selector and Report Downloads more prominently featured with icons in the upper right

• Move the visualization variable scale over the map on the bottom right.

• Makes consistent use of colors for typography

• Include the # of Children of Color in selected age ranges on the zip card

• When showing the forecast in the report results, show the % change for each value

• Fix a display issue with labels that have tooltips

Version 4.2.0

Released Dec 01, 2020

• Update the icon for the menus on charts

• Update the export options on charts

• Add clarification about scope of data on the Demographics pane of the zip card

• Update links to Help, add additional link to Help in the header

• Bugfix: Fix styling of menus on library

• Bugfix: Ensure files that are text/csv successfully upload

Version 4.1.0

Released Nov 09, 2020

• Fix a bug where financial gap was not available in exports

Version 4.0.0

Released Oct 16, 2020

• Use a hosted image for the twitter card

Importing DASL data

Market View offers the ability to sync selected admission data from DASL.

In order to begin the sync, visit the DASL Data page under Your Data. You'll see a button that says "Refresh" or "Sync". Once you click the button, Market View will begin importing selected admission data.

You'll see a notification at the bottom of your screen when the import is complete. Visit the DASL data page in Market View to see what was synced.

Editing DASL data

If there is a conflict between the data you uploaded to Market View and the data you input into DASL, you'll see an icon with red crossed arrows. When you click that symbol, it will tell you which numbers are a mismatch. In the example below, you uploaded 232 for that variable, but you entered 89 into DASL. You cannot edit DASL data in Market View, but there is a handy link for you to edit each variable in DASL. "Edit on DASL" is the hyperlink you can click to fix DASL numbers. It will bring you directly to the exact cell you can edit.

If the numbers are black and not red, that means there is no conflict between Market View and DASL.

If the Market View numbers are wrong, head to the Admission Data page to adjust the counts for each bucket by deleting or adding spreadsheets, or importing from your admissions tool.

Viewing DASL data in Market View

Once you've imported your DASL data and everything looks good, you can head to Trends > Enrollment Trends to see your DASL data in action. All four of the charts on this tab include DASL data.

The national averages included in these charts are the national average for schools entering data into DASL.

Full table of DASL data available to import

Here is the list of ZIPs for which Market View doesn't include data. Some ZIPs are in military locations, or college campuses. The Census doesn't consider those ZIPs to have permanent residences, so we don't have data for those ZIPs. Other ZIPs are islands, territories or remote locations. Please reach out if you have questions or think a ZIP shouldn't be on this list.

00501
01003
01063
01102
01111
01144
01152
01199
01252
01441
01471
01546
01615
01653
01655
01805
01812
01815
01889
01899
01910
02044
02201
02203
02211
02212
02217
02222
02241
02283
02297
02325
02344
02348
02349
02357
02477
02714
02902
02912
02918
03108
03111
03305
03435
03575
03589
03756
03803
04033
04034
04109
04122
04123
04124
04333
04336
04420
04469
04637
04751
04775
05009
05405
05439
05479
05501
05603
05604
05609
05620
05633
05671
05901
06006
06030
06041
06080
06101
06104
06115
06150
06151
06152
06153
06154
06155
06156
06160
06161
06167
06180
06183
06199
06245
06269
06408
06411
06459
06493
06494
06509
06537
06538
06540
06673
06699
06701
06749
06792
06828
06857
06858
06860
06888
06910
06912
06926
06927
07097
07099
07193
07399
07495
07510
07699
07703
07715
07799
07806
07890
08405
08541
08544
08625
08646
08647
08666
08899
08933
10020
10041
10043
10045
10055
10080
10081
10087
10102
10103
10104
10105
10106
10107
10110
10111
10112
10114
10115
10117
10118
10119
10120
10121
10122
10123
10124
10125
10138
10151
10152
10153
10154
10155
10158
10164
10165
10166
10167
10168
10169
10170
10171
10172
10173
10174
10175
10176
10177
10178
10179
10199
10203
10212
10261
10271
10278
10279
10281
10285
10286
10311
10610
11042
11120
11241
11242
11245
11251
11252
11256
11351
11359
11381
11405
11425
11437
11451
11499
11549
11555
11556
11599
11695
11760
11773
11794
11815
11853
12055
12222
12223
12226
12227
12228
12229
12230
12231
12232
12233
12234
12235
12237
12239
12240
12242
12243
12246
12247
12250
12255
12257
12260
12288
12345
12504
12555
12604
13024
13362
13671
13699
14144
14241
14260
14263
14264
14267
14270
14272
14273
14627
14638
14639
14642
14643
14644
14646
14647
14649
14650
14651
14652
14653
14694
14831
15096
15123
15240
15250
15258
15259
15260
15261
15262
15272
15276
15277
15278
15282
15289
15290
15339
15510
15605
15705
15822
16016
16017
16018
16172
16366
16367
16369
16444
16475
16515
16522
16530
16531
16534
16538
16541
16544
16546
16550
16553
16563
16654
16698
16699
17071
17089
17107
17120
17121
17122
17123
17124
17125
17126
17127
17129
17130
17140
17177
17333
17335
17375
17699
17705
17731
17822
17883
17932
18003
18098
18195
18341
18348
18448
18449
18515
18626
18711
18762
18764
18765
18766
18769
18773
18820
18827
18991
19019
19091
19108
19113
19170
19172
19175
19176
19181
19182
19188
19192
19195
19255
19339
19340
19345
19371
19383
19424
19429
19712
19716
19718
19721
19726
19735
19880
19884
19890
19891
19892
19894
19895
19896
19897
19898
19905
20042
20045
20047
20049
20052
20053
20055
20057
20058
20059
20060
20062
20063
20064
20065
20066
20069
20070
20071
20073
20076
20080
20101
20102
20103
20104
20149
20189
20192
20201
20202
20203
20204
20206
20207
20208
20210
20212
20213
20215
20216
20217
20218
20219
20220
20221
20222
20223
20224
20226
20227
20228
20229
20230
20233
20235
20237
20239
20240
20241
20242
20245
20250
20254
20260
20268
20270
20301
20303
20306
20310
20318
20319
20330
20340
20350
20370
20372
20373
20374
20375
20376
20380
20388
20390
20391
20392
20395
20398
20401
20403
20405
20407
20408
20410
20411
20412
20413
20414
20415
20416
20417
20418
20419
20420
20421
20422
20423
20424
20425
20426
20427
20428
20429
20431
20433
20434
20435
20436
20437
20439
20440
20441
20442
20444
20447
20451
20456
20460
20463
20472
20500
20503
20505
20506
20507
20508
20510
20515
20520
20521
20522
20523
20524
20525
20526
20527
20528
20529
20530
20531
20533
20534
20535
20536
20538
20540
20542
20543
20544
20546
20547
20548
20549
20551
20552
20553
20554
20560
20565
20566
20570
20571
20572
20575
20576
20577
20579
20580
20581
20585
20586
20588
20590
20591
20593
20597
20598
20599
20635
20643
20742
20771
20790
20797
20799
20810
20857
20889
20892
20894
20897
20899
20993
21031
21062
21065
21233
21235
21241
21250
21251
21252
21278
21287
21290
21298
21405
21411
21709
21746
21792
21857
21890
22035
22037
22067
22081
22082
22107
22108
22109
22135
22158
22160
22185
22212
22214
22217
22226
22227
22230
22240
22243
22332
22333
22350
22412
22552
22558
22807
22908
22909
22989
23160
23173
23186
23232
23249
23250
23269
23273
23284
23286
23289
23291
23293
23295
23297
23298
23326
23419
23460
23463
23465
23482
23515
23519
23529
23551
23630
23668
23681
23709
23806
23870
23891
23909
23943
24020
24040
24043
24061
24113
24142
24215
24513
24514
24515
24887
25152
25185
25305
25317
25333
25335
25350
25389
25396
25665
25719
25755
25771
25943
26106
26120
26121
26229
26306
26506
27094
27099
27108
27109
27110
27150
27152
27155
27157
27199
27237
27268
27294
27411
27412
27495
27497
27498
27499
27531
27599
27625
27635
27640
27656
27668
27676
27690
27695
27697
27699
27706
27708
27710
27711
27815
27968
28035
28201
28219
28223
28228
28244
28246
28255
28260
28263
28272
28274
28280
28281
28282
28284
28285
28287
28288
28308
28407
28533
28542
28545
28608
28633
28656
28810
29117
29208
29214
29215
29217
29218
29219
29220
29222
29225
29226
29228
29319
29395
29409
29424
29425
29613
29614
29632
29634
29647
29733
29734
29808
29899
29939
30026
30029
30063
30069
30090
30098
30099
30118
30119
30149
30270
30304
30320
30322
30334
30348
30353
30361
30368
30369
30371
30374
30375
30378
30380
30384
30388
30392
30396
30460
30597
30598
30599
30609
30612
30912
31026
31062
31136
31207
31213
31295
31296
31314
31524
31699
31704
31993
31999
32026
32099
32142
32214
32231
32232
32306
32399
32434
32509
32511
32512
32520
32521
32610
32611
32723
32745
32799
32816
32834
32885
32886
32896
32899
32919
33039
33072
33102
33106
33112
33188
33191
33192
33195
33198
33199
33206
33336
33388
33394
33464
33499
33620
33630
33631
33633
33655
33660
33661
33729
33730
33769
33888
33911
33965
34249
34260
35229
35246
35249
35254
35283
35285
35288
35290
35291
35293
35294
35295
35298
35487
35609
35632
35809
35893
35896
35897
35898
35899
36082
36112
36118
36119
36130
36131
36132
36177
36191
36503
36628
36644
36675
36688
36849
37044
37089
37131
37132
37161
37227
37230
37232
37234
37235
37236
37238
37240
37241
37242
37243
37244
37246
37250
37383
37501
37614
37669
37699
37929
37995
37996
37998
38055
38136
38137
38145
38151
38152
38157
38159
38161
38163
38166
38188
38193
38194
38197
38505
38677
38733
38875
39058
39210
39217
39269
39298
39309
39406
39407
39522
39529
39595
39632
39710
39901
40032
40122
40221
40225
40231
40266
40280
40281
40282
40283
40289
40292
40295
40297
40298
40384
40404
40506
40526
40536
40546
40550
40603
40621
40750
41019
41025
41037
41061
41099
41114
43041
43069
43093
43194
43218
43236
43251
43260
43266
43271
43287
43291
43403
43523
43652
43654
43659
43660
43667
43699
43736
44073
44101
44190
44192
44194
44195
44237
44242
44315
44316
44317
44325
44326
44328
44486
44555
44750
44767
44888
45051
45114
45221
45234
45235
45263
45264
45267
45268
45280
45298
45299
45367
45374
45412
45422
45423
45435
45448
45469
45470
45481
45699
45999
46014
46207
46209
46213
46249
46255
46277
46282
46283
46285
46298
46355
46626
46769
46801
46912
46971
47132
47190
47306
47405
47464
47549
47721
47722
47737
47747
47750
47809
47907
48007
48086
48109
48222
48231
48232
48233
48242
48255
48264
48267
48269
48275
48277
48288
48397
48550
48551
48552
48553
48554
48555
48556
48557
48663
48667
48670
48674
48686
48710
48787
48887
48913
48916
48918
48922
48924
48929
48930
48951
48956
49039
49104
49351
49355
49356
49357
49413
49560
49737
49739
50012
50037
50306
50319
50328
50331
50334
50368
50391
50392
50395
50398
50614
50661
51603
52204
52243
52498
52499
52557
53062
53102
53259
53263
53274
53278
53288
53290
53293
53295
53542
53595
53596
53702
53777
53783
53784
53788
53791
53792
53793
53957
53958
54226
54344
54492
54764
54774
54816
54906
54919
55078
55083
55144
55145
55146
55155
55164
55170
55450
55459
55467
55470
55474
55479
55480
55484
55485
55486
55487
55488
55569
55572
55592
55593
55599
55730
55745
55814
55905
55988
56084
56140
56210
56372
56393
56395
56396
56562
56563
56577
56687
57117
57186
57197
57198
57326
57399
57563
57656
57661
57770
57799
58076
58121
58122
58124
58125
58126
58202
58205
58207
58405
58505
58707
59036
59116
59620
59623
59625
59626
59812
59835
59921
60019
60037
60038
60055
60086
60094
60105
60116
60117
60128
60132
60179
60196
60197
60199
60208
60599
60666
60668
60669
60670
60673
60674
60675
60677
60678
60681
60685
60686
60688
60691
60693
60694
60695
60696
60697
60701
61299
61558
61613
61625
61629
61630
61633
61634
61635
61636
61637
61638
61639
61641
61643
61709
61710
61758
61790
61791
61799
62026
62259
62329
62660
62706
62715
62716
62722
62723
62739
62756
62757
62761
62763
62764
62765
62767
62769
62777
62781
62786
62794
62829
62834
62840
62973
63045
63099
63150
63155
63160
63164
63167
63180
63199
63666
64002
64065
64102
64121
64162
64180
64184
64197
64198
64199
64999
65103
65105
65106
65107
65108
65111
65211
65212
65215
65216
65217
65218
65299
65409
65623
65890
65897
65898
65899
66031
66045
66115
66160
66250
66251
66276
66506
66620
66621
66622
66624
66625
66626
66629
66636
66683
66699
67260
67276
68056
68172
68175
68178
68179
68180
68182
68183
68197
68198
68583
68588
68849
69160
69190
70060
70081
70139
70142
70143
70145
70146
70148
70159
70160
70161
70163
70165
70167
70170
70310
70402
70504
70609
70629
70792
70803
70825
70826
70827
70893
70894
71102
71120
71130
71150
71151
71209
71212
71272
71309
71359
71377
71443
71497
71998
71999
72035
72099
72149
72199
72255
72295
72545
72657
72716
72905
72919
73019
73124
73125
73190
73194
73301
73523
73705
74077
74078
74102
74121
74141
74171
74172
74335
75099
75242
75260
75262
75270
75277
75283
75284
75301
75303
75312
75320
75326
75390
75397
75599
75799
75834
75962
76019
76122
76129
76190
76192
76196
76199
76203
76402
76508
76596
76598
76599
76797
76798
76799
76855
76909
76949
77201
77203
77204
77212
77216
77315
77337
77341
77399
77555
77710
77843
77844
78001
78135
78206
78241
78243
78246
78279
78284
78288
78289
78350
78419
78682
78710
78712
78772
78774
78778
78779
78843
79016
79051
79178
79221
79338
79402
79430
79457
79491
79697
79698
79699
79832
79848
79916
79918
79920
79960
79968
80038
80208
80225
80257
80261
80263
80264
80265
80266
80271
80273
80274
80290
80293
80294
80299
80309
80310
80419
80425
80523
80551
80553
80638
80639
80826
80912
80913
80941
80942
80946
80947
80950
80977
80997
81009
81010
81011
81012
81038
81102
81227
81231
81414
82002
82005
82006
82061
82071
82840
83209
83415
83441
83460
83652
83708
83720
83724
83725
83726
83728
83735
83844
84114
84132
84133
84134
84138
84139
84143
84145
84148
84150
84180
84184
84190
84199
84201
84322
84407
84408
84602
84640
84710
84715
84734
84740
84749
84755
84773
84775
85026
85038
85062
85287
85369
85371
85707
85709
85721
85723
85724
85744
85775
85942
86011
86016
87101
87115
87117
87131
87151
87158
87503
87545
87830
88006
88036
88244
88575
88590
89037
89070
89150
89151
89152
89153
89154
89155
89177
89195
89199
89437
89496
89520
89557
89595
89711
89712
89713
89714
90052
90074
90080
90084
90090
90095
90096
90261
90263
90312
90407
90410
90411
90506
90509
90624
90639
90671
90747
90822
90831
90840
90844
90846
90895
91121
91123
91124
91125
91126
91129
91182
91184
91185
91188
91189
91199
91329
91330
91371
91383
91410
91495
91496
91521
91522
91523
91608
91611
91612
91714
91716
91735
91756
91772
92055
92092
92093
92096
92132
92135
92136
92147
92152
92155
92158
92161
92179
92182
92186
92187
92197
92199
92350
92357
92403
92415
92418
92521
92522
92599
92697
92698
92864
92899
93009
93043
93064
93099
93106
93107
93199
93208
93246
93282
93407
93408
93409
93410
93599
93724
93740
93741
93750
93760
93761
93764
93765
93786
93844
93888
94026
94120
94128
94137
94139
94143
94144
94145
94203
94205
94206
94209
94230
94240
94250
94252
94256
94258
94280
94295
94497
94527
94529
94575
94613
94614
94615
94649
94666
94850
94974
94999
95053
95101
95115
95191
95192
95194
95196
95211
95229
95296
95297
95343
95532
95671
95721
95799
95836
95840
95867
95894
95929
95976
96838
96840
96843
96844
96846
96848
96849
96850
96853
96854
96857
96858
96859
96860
96861
96863
97076
97077
97079
97129
97250
97251
97252
97253
97254
97256
97258
97310
97311
97312
97314
97331
98129
98131
98154
98158
98161
98170
98174
98181
98185
98190
98191
98195
98207
98278
98314
98348
98352
98378
98397
98398
98413
98416
98447
98481
98493
98497
98504
98505
98599
98637
99164
99251
99252
99256
99258
99260
99513
99529
99530
99545
99547
99559
99561
99563
99599
99608
99619
99622
99633
99637
99638
99641
99647
99651
99667
99680
99681
99690
99695
99697
99704
99723
99734
99761
99766
99775
99850
99950