We at mySidewalk work hard to build a data library that contains data for your community. It is not always possible however to build data values for every topic, at every time, for every geography. In these instances, you will see NULL or No Data in a mySidewalk product.

Data availability is influenced by a combination of 3 things: Geography, Topic, and Time.

These three factors combine to get to a data value. Selecting options for these 3 things will get you to a data value. For the same reasons, the right (or wrong depending on your perspective) combination of 3 things results in NULL or No Data.

The following are the most common reasons the combination of a topic + time + geography may be NULL or show as No Data.

Even when a raw data source publishes data for a geography, such as county, it may not provide a data value for every county. This is because every data source has its own rules and protocols when it comes to sample size and privacy. Where sample size is too low, data values are also suppressed or replaced with a placeholder. The minimum threshold of what qualifies as “too low” varies from data source to data source. This can be done in an effort to protect privacy. It also could be due to lack of confidence in the produced data values due to small sample size.

Even when a raw data source publishes data for a geography, such as county, it may not provide a data value for every county. This is because every data source has its own rules and protocols when it comes to sample size and privacy. Where sample size is too low, not meeting a minimum threshold, data values are also suppressed or replaced with a placeholder. This can be done in an effort to protect privacy. It also could be due to lack of confidence in the produced data values due to small sample size.

In other instances, the values may be known but are so specific - such as a combination of a particular age, sex, education, poverty status, and disability - that it could be possible to use the data to identify an individual. Each data source takes its own approach to obfuscate the data in ways to prevent individual identification. One of the tools in their toolbox is suppression, in which they replace the known value with a placeholder or NULL.

Data sources sometimes published only the calculation outputs, in formats such as ratios or percentiles. Without access to the input data, it is sometimes impossible to recalculate the values for additional geographies.

Apportionment is a powerful tool that we use to calculate data values for non-Census geographies (City Councils, Neighborhoods, MPOs) and for geographies that are not published by the raw data provider. It does have its limits.

Data will be NULL or No Data if the target geography (the geography to which you are apportioning data) fails to capture enough block points. Or if the captured block points have zero ratio for the selected apportionment types. There are four block-to-block group apportionment type ratios: people, households, housing units, and properties.

We take a great deal of pride at mySidewalk in providing data you can trust to make decisions for the betterment of your community. To that end, we have an extensive QA process, customized to every data source. Data that fails testing does not get added to the mySidewalk data library. Sometimes the data that fail are only for specific geographies - in which case only they will be made NULL or No Data.

The display of data availability in Seek is rounded. So a value of 99.51798% will appear as 100%.