Spatial.aiHelp Center

Delivery Format

CSV and Parquet delivery at census block group level, with key files for variable IDs and optional multi-file splits.

Now that we've explained the dataset structure, we can go over the format in which this data is delivered.

File Format

Due to the high number of variables, this is a large dataset. Only subsets of variables or geographies will be able to be opened in applications like Excel, and those opening this data in more advanced statistical or programming environments may need to manage memory.

Files are typically delivered through your Spatial Cloud account.

That said, this data is typically delivered in .csv or .parquet format with each row representing a single geography and each column representing a FollowGraph variable. Our standard geographic file is at the census block group level.

The below table is an example table with 10 randomly selected variables (you can scroll the table right to see the whole thing) at a census block group level.

BLOCKGROUPBoy Band FansBudget Fashion EnthusiastsBusiness ReadersDalai LamaDaniel DaleOlive GardenProductivity Apps EnthusiastsRachael Ray ShowSoccer EnthusiastsCardi B
010010201001119141607460146581268592
0100102010021061046881781167810910781
0100102020011231657683761517112592149
0100102020021111397380701407212288123
0100102030011051257278751317512093104
.................................

All scores provided are index scores where 100 represents the national average. The first value in the first row is 119, indicating that the people in block group 010010201001 are 1.19 times as likely to follow Boy Bands on social media. This can also be stated as "19% more likely". This is further explained in the Dataset Structure section.

Your data file may include column IDs instead of names (for the column headers). The "Key" file contains the full variable listing and you can use the IDs to match the data and key files. The key file contains a list of all the variables including names, descriptions, categorizations, and the social media accounts which each variable is based on.

Multiple Files

This dataset has thousands of variables. Depending on use case, we may deliver the data in multiple files. Typically, we would split along variable sections (i.e. one file for "Interests", one file for "Celebrities & Influencers", etc.).

On this page