Snowflake Marketplace · Product Documentation

US Business Registry Data

US business entity filings from state registries, shared as one Snowflake table. PII-stripped, entity-level data. The table was first loaded in May 2026 and is not refreshed on a daily schedule. Run the coverage query below for current row counts by state.

View on Snowflake Marketplace Contact: support@palavir.co

Dataset at a glance

Columns: 12
First loaded: May 2026
Refresh: Not daily
Delivery: Snowflake share

This share is a separate load from Palavir's CSV export files and its coverage differs from them. For the export files and their per-jurisdiction record counts, see the US Business Registry listing.

Schema

Table PALAVIR_DATA.BUSINESS_REGISTRY.US_BUSINESS_FILINGS.

Column	Type	Description
entity_name	VARCHAR(500)	Legal name of the business entity as filed with the Secretary of State.
entity_type	VARCHAR(100)	Filing type: LLC, Corp, LP, Nonprofit, Sole Prop, etc.
status	VARCHAR(50)	Active, Dissolved, or Unknown.
formation_date	DATE	Date the entity was first registered with the state.
principal_address	VARCHAR(500)	Full address as filed (often street + city + state + zip).
street	VARCHAR(300)	Parsed street component of principal_address.
city	VARCHAR(100)	Parsed city component of principal_address.
state	VARCHAR(10)	Code of the registry that issued the filing.
zip	VARCHAR(20)	Parsed postal code from principal_address.
filing_id	VARCHAR(100)	Unique identifier assigned by the Secretary of State.
source_url	VARCHAR(500)	Public URL on the Secretary of State portal where the filing record can be verified.
naics_code	VARCHAR(20)	NAICS industry classification. Codes may originate from the state filing or, where the state does not collect NAICS, be inferred from the entity name.

Coverage and refresh

This page does not list per-state row counts, because the counts published here earlier came from the May 2026 load and have not been re-checked against the table since. To see what the share holds today, run this query in your account after mounting it:

SELECT state, COUNT(*) AS row_count, MAX(formation_date) AS newest_formation
FROM PALAVIR_DATA.BUSINESS_REGISTRY.US_BUSINESS_FILINGS
GROUP BY state
ORDER BY row_count DESC;

Sample query

All active LLCs formed in New York in 2025, grouped by NAICS sector. Runs in seconds on an XSMALL warehouse.

SELECT
  LEFT(naics_code, 2) AS naics_sector,
  COUNT(*) AS new_llcs_2025
FROM PALAVIR_DATA.BUSINESS_REGISTRY.US_BUSINESS_FILINGS
WHERE state = 'NY'
  AND entity_type = 'LLC'
  AND status = 'Active'
  AND formation_date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY naics_sector
ORDER BY new_llcs_2025 DESC;

Data sourcing and compliance

Primary sources. Rows are sourced from Secretary of State filings or their Socrata data portals where available. The dataset does not include third-party broker scrapes.
PII stripped at ingestion. Registered-agent, officer, and principal name columns are dropped before the data is loaded into Snowflake. The dataset contains business entity metadata only, with no consumer PII.
Source URL retained per row. Each row carries a source_url pointing to a public state-portal record where the filing can be re-verified.
NAICS coverage. Where a state filing does not collect NAICS, the naics_code value is inferred from the entity name; the dataset does not distinguish filed vs. inferred codes in a separate column.

Try a sample on Kaggle

Want to inspect the row shape before installing the Snowflake share? Three Palavir datasets are published as free 5,000-row CC BY 4.0 samples on Kaggle:

ATF Federal Firearms Licensees: 5K sample: companion to the full ATF FFL data product.
OIG LEIE Healthcare Exclusions: 5K sample: companion to the Compliance API feed.
OFAC SDN Sanctions: 5K sample: companion to the Compliance API feed.

The business-registry dataset itself is too large for Kaggle. It is delivered through this Snowflake share or as CSV export files.

Other Palavir data products

ATF FFL Data

77,000+ active FFLs, 51 monthly snapshots since 2022. Snowflake, Gumroad, or Datarade.

Compliance API

269K federal + state exclusion records. Webhook delta delivery, REST API, $999/mo flat.

Support

Questions about schema, coverage, or refresh planning? Email support@palavir.co. Privacy practices are documented at palavir.co/privacy.