Data Dictionary

Every field in every dataset — documented. Column name, data type, meaning, source agency, and observed fill rate. Every row we deliver carries verification metadata. Every delivery ships with this reference.

FMCSA Motor Carrier Census 3.81M records

Field	Type	Meaning	Fill %
name	string	Legal carrier name as registered with USDOT	100%
trade_category	string	Business class — always "Motor Carrier" for this set	100%
license_type	string	Authority type — "USDOT" for this registry	100%
license_number	string	USDOT registration number (primary key)	100%
phone	string	Primary operations phone, E.164 or 10-digit	97%
email	string	Registered business email (where provided)	0%
address	string	Principal place of business street address	99%
city / state / zip	string	Normalized US address components	99%
county	string	Derived from ZIP via USPS CASS cross-reference	92%
source	string	Always "FMCSA_Census" — provenance tag	100%

Florida Business-NAICS Directory (NAP) 1.17M records

Field	Type	Meaning	Fill %
business_name	string	Registered business entity operating in FL	100%
naics_code	string	6-digit NAICS industry classification	96%
naics_2digit	string	Top-level NAICS sector (for segmentation)	96%
industry_sector	string	Plain-language industry label	96%
county_code	string	FL county code (1-67)	100%
owner_addr / city / state / zip	string	Business owner mailing address	99%
phy_addr / city / zip	string	Physical business location	98%
equipment_value	numeric	Assessed value of business equipment	92%
leasehold_value	numeric	Leasehold improvements assessed value	68%
asset_tier	string	Size tier derived from total assessed value	100%
out_of_state_owner	boolean	Flag for non-FL owner address	100%
account_id / alt_key	string	County assessor primary keys	100%

SEC Investment Advisors 15.2K records

Field	Type	Meaning	Fill %
firm_name	string	Registered investment adviser legal name	100%
crd_number	string	CRD number (primary key, cross-ref FINRA)	100%
sec_file_number	string	SEC 801-xxxxx identifier	100%
aum_discretionary	numeric	Regulatory AUM under discretion (Form ADV Part 1A)	99%
aum_nondiscretionary	numeric	Non-discretionary AUM	94%
num_clients	integer	Reported client count	98%
phone	string	Main office phone	99%
email	string	CCO or compliance contact email	87%
address / city / state / zip	string	Principal office location	100%
source	string	Always "SEC_ADV_Part1A"	100%

IRS Nonprofit Registry (Pub 78 / BMF) 1.94M records

Field	Type	Meaning	Fill %
name	string	Exempt organization legal name	100%
ein	string	Employer Identification Number (primary key)	100%
classification_code	string	IRC subsection — 501(c)(3), (c)(4), etc.	100%
ntee_code	string	National Taxonomy of Exempt Entities classification	78%
deductibility_code	string	Charitable contribution deductibility status	100%
ruling_date	date	Date of IRS exemption ruling	99%
address / city / state / zip	string	Organization principal address	100%
source	string	Always "IRS_BMF"	100%

FDIC Banks & Branches 106K records

Field	Type	Meaning	Fill %
institution_name	string	Bank legal name	100%
cert	string	FDIC certificate number (primary key)	100%
branch_name	string	Branch office name	100%
charter_class	string	National, state-chartered, savings, etc.	100%
total_deposits	numeric	Branch-level deposits (SOD June snapshot)	98%
established_date	date	Branch opening date	99%
address / city / state / zip	string	Branch physical location	100%
source	string	Always "FDIC_SOD"	100%

Federal Contractors (USAspending) 13.7M+ records

Field	Type	Meaning	Fill %
recipient_name	string	Prime contractor / recipient entity	100%
recipient_uei	string	SAM.gov Unique Entity Identifier	98%
award_id	string	Federal award / contract identifier	100%
awarding_agency	string	Federal department / agency	100%
award_amount	numeric	Total obligated federal dollars	100%
naics_code	string	Product/service NAICS classification	97%
psc_code	string	Product/Service Code (federal taxonomy)	94%
action_date	date	Contract action / modification date	100%
period_of_performance_start / end	date	Award performance window	99%
recipient_addr / city / state / zip	string	Recipient address on file	99%
source	string	Always "USASPENDING_v2"	100%

NPI Healthcare Provider Registry 9.09M records · ENTERPRISE · DPA REQUIRED

Field	Type	Meaning	Fill %
name	string	Provider legal name (individual or entity)	100%
owner	string	Individual provider name (null for entities)	68%
trade_category	string	Provider class — Physician, Dentist, Hospital, etc.	100%
license_type	string	NUCC taxonomy code (primary specialty)	100%
license_number	string	10-digit NPI (primary key)	100%
license_subtype	integer	Entity type: 1 = individual, 2 = organization	100%
phone	string	Primary practice phone	94%
email	string	Practice email (where provided to NPPES)	3%
address	string	Practice location street address	99%
city / state / zip	string	Normalized US address components	99%
source	string	Always "NPI_CMS"	100%

Florida Insurance Agents & Agencies 102K records

Field	Type	Meaning	Fill %
name	string	Licensed agency or agent name	100%
trade_category	string	"Insurance" category	100%
license_type	string	License class (e.g. "AUTOMOBILE WARRANTY", "HOME WARRANTY")	100%
license_number	string	FL DFS license ID	100%
phone	string	Registered business phone	91%
email	string	Registered business email	99.2%
address / city / state / zip / county	string	Normalized Florida address components	100%
source	string	Always "FL_DFS_Insurance"	100%

Universal Verification Metadata

Every delivery includes these columns regardless of dataset:

Field	Type	Meaning	Fill %
last_verified	ISO 8601	UTC timestamp of most recent verification cycle	100%
deliverable	boolean	Email address passed SMTP validation	100%
source_agency	string	Exact agency name + division	100%
source_ingest	ISO 8601	When we pulled from authoritative source	100%
provenance_hash	string	SHA-256 of source file — reproducibility guarantee	100%