Verse Table Schema

The verse table provides metadata about each county in our dataset and is delivered to bulk data customers and is available via API.

This table is provided in the same directories and formats as the county data.

The two critical pieces of information in the verse table are filename_stem and last_refresh. Those two fields tell you the name of the dataset for a county and the last time we did a full data pull from the source, usually the county or a designee.

Field Type Name Description Source
id integer ID Row ID Automatic
wkb_geometry geometry Geometry Geometry of the place described in this row Census
county character varying County County name Census
state character varying State Two-letter state abbreviation Census
seat character varying County Seat County seat Census
population integer Population Total county population (2010 Census) Census
sqmi integer Square Miles County square miles Automatic
geoid character varying GEOID US Census county GEOID Census
city character varying City Slug representing the city, if the data applies to a sub-county area Census
table_name character varying Table Name Table name in Regrid system Automatic (bi-weekly)
total_objects integer Total Objects Total number of parcels in this place Automatic (bi-weekly)
last_refresh date Last Refresh Date Date of the last full refresh of data from our county source. This is always the date of our ingest, see 'assessor_data_date' for the estimated date of the assessor data itself. Hand
path character varying Path Path of data in Regrid system Automatic (bi-weekly)
canonical_path text Canonical Path Internal path used by Regrid's tileserver to identify a place Automatic
filename_stem text Filename Stem The base filename for exports of this place, without extension. Add an extension to get the filename (eg mi_wayne.csv) Hand
date_added timestamp Date Added Date the place was first added to our parcel collection Hand
shapefile_size_flag text Shapefile Size Warning Flag 'y' indicates this place is larger than the shapefile limit of 2 Gigabytes of data and some applications will silently truncate the file. OSGEO tools generally work fine with these files, Esri tools often truncate data silently. Hand
assessor_data_date date Date of the assessor data Date of the assessor data to the best of Regrid's ability to determine. Determined at the same time we refresh our data from the county source. Set if it diverges significantly from the `last_refresh` date, otherwise remains null. Hand
usps_data_date date Date of USPS data Date of the USPS data from our CASS process vendor Hand
buildings_count integer Count of buildings in the county The total of all the individual parcel building counts for the county as derived from [Regrid Matched Building Footprints]( data. Automatic
buildings_data_dates text Date of the building data sources Dates of the imagery and/or lidar data the building counts and building footprint polygons are derived from. Automatic
address_count integer Count of total primary and secondary addresses in the county The total of all the [Matched Addresses]( available in the county. Automatic
address_date date Date of the matched address data source Date of the source data we use to provide matched secondary addresses. Automatic
partial text Partial county data flag An indicator that some parcels in the county are not included in our parcel data. Please see our [FAQ for more information](/articles/parcel-data-faq/#why-do-some-counties-have-partial-data). Hand
msa text Metropolitan Statistical Area The US Census Metropolitan Statistical Area a county falls in, if there is one. Automatic