Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

The includeSynthetic Option

As part of retrieving rows for your query, we sometimes include extra columns–usually indicating row metadata, but sometimes also intermediate columns–in order to correctly calculate results. These are called “synthetic” columns and we return them by default. If you’re not interested in receiving them, you can set this option to false to only receive columns which were explicitly part of your SELECT clause.