Data AS A SERVICE

USA - Hyper-Local Quarterly Population & Region Insights

IdeaSpot Geo Location Market Data is now available via Snowflake Data Marketplace.

Get Data Now

DATA DEFINITION.

The IdealSpot DaaS is unique as we offer a ENTITY-ATTRIBUTE-RELATIONSHIP type data model.

There are no tables with 1,200 columns to sort through, or columns like 'PTC_X0_AA12' to decode.

FIPS

Each geographic region is represented by a FIPS code. FIPS codes are numbers which uniquely identify geographic areas. Read More

For example, ALASKA has a FIPS code of `02` while Travis County, Austin, Texas has a FIPS code of `48453`

INSIGHTS

Each location, described by a FIPS code, has a set of properties called insights. These insights describe characteristics around population demographics, consumer behavior like spending, lifestyle segmentation, economic indicators, and physical properties.

For example, the insights available for Travis County,, Austin, TX (FIPS code 48453) can be found using the following query:

SELECT DISTINCT
   i.id,
   ic.name as insight_category,
   i.name
FROM
   LOCATION_DATA ld
   INNER JOIN INSIGHT i ON ld.INSIGHT_ID = i.ID
   INNER JOIN INSIGHT_CATEGORY ic ON i.INSIGHT_CATEGORY_ID = ic.ID
WHERE
   ld.code = 48453;

DIMENSIONS

Dimensions describe a unique breakdown of an insight that is analytically relevant.

For example you may want to compare ages (20-29 vs. 30-39), gender (male vs. female), housing (studio vs. 2-Bedroom), etc.

For example. the unique dimensions for the insight `Ancestry` can be found using the following query:

SELECT DISTINCT
   NAME
FROM
   DIMENSION
WHERE
   INSIGHT_ID = 442 -- Ancestry
ORDER BY
   NAME;

DATE_KEY

Lastly, each location (as described by FIPS)  have insights and dimensions, but to make it relevant we need a place in time. `DATE_KEY` is used and can describe years (2020), quarters (2021-Q1), or months (2020-12).

FULL EXAMPLE

To get every data point for Travis County, Austin, TX (FIPS code 48453) for the 1st quarter of 2021 (DATE_KEY 2021-Q1), we can use the following query:

SELECT DISTINCT
   i.ID AS INSIGHT_ID,
   ic.NAME AS INSIGHT_CATEGORY,
   i.NAME AS INSIGHT_NAME,
   d.NAME AS DIMENSION_NAME,
   ld.DATE_KEY,
   ld.VALUE
FROM
   LOCATION_DATA ld
   INNER JOIN INSIGHT i ON ld.INSIGHT_ID = i.ID
   INNER JOIN DIMENSION d ON ld.DIMENSION_ID = d.ID
   INNER JOIN INSIGHT_CATEGORY ic ON i.INSIGHT_CATEGORY_ID = ic.ID
WHERE
   ld.CODE = 48453 AND
   ld.DATE_KEY = '2021-Q1';

CONTACT US

Please contact us at developer@idealspot.com to request more information.