Data dictionary

ListRiver's full-database files have 35 columns, in the same order in every state's file. Each file is a gzip-compressed CSV (UTF-8, comma separated, first row is the column names), one file per state, with one row per state filing.

#ColumnWhat it holdsFilled in for
1Business NameLegal name of the business as registered with the state.All records
2DBA NameTrade name ("doing business as"), when one is on file.Where available
3Entity TypeThe state's entity type, such as limited liability company or corporation.All records
4StatusRegistration status as the state reports it, in capitals (for example ACTIVE).All records
5StandingStanding with the state, such as good standing, where the state reports it.Where published
6FormedFormation (registration) month, as YYYY-MM.Nearly all records
7Registration StateTwo-letter code of the state registry the filing came from.All records
8State Filing NumberThe ID the state assigned to the filing.All records
9EINFederal Employer Identification Number, as 12-3456789.A minority of records, nearly all Florida registrations
10AddressStreet address of the business.All records
11Address 2Suite, unit or second address line.Where available
12CityCity of the business address.All records
13StateTwo-letter state of the business address. Can differ from Registration State.All records
14ZIPZIP code of the business address.All records
15CountyCounty of the business address.Every record
16Mailing AddressMailing street address, when the state publishes one.Where published
17Mailing Address 2Second mailing address line.Where published
18Mailing CityCity of the mailing address.Where published
19Mailing StateState of the mailing address.Where published
20Mailing ZIPZIP code of the mailing address.Where published
21PhoneBusiness phone number.Almost no records
22EmailBusiness email address.A small minority of records, mostly Connecticut
23WebsiteBusiness website.Almost no records
24Registered AgentName of the registered agent.States that publish it
25NAICSNorth American Industry Classification System code.Where available
26IndustryDescription of the NAICS code.Where available
27Woman-OwnedY when the business is recorded as woman-owned; otherwise blank.Where available
28Veteran-OwnedY when the business is recorded as veteran-owned; otherwise blank.Where available
29Minority-OwnedY when the business is recorded as minority-owned; otherwise blank.Where available
30Disability-OwnedY when the business is recorded as disability-owned; otherwise blank.Where available
31LGBTQI-OwnedY when the business is recorded as LGBTQI-owned; otherwise blank.Where available
32LatitudeLatitude of the business address.Where available
33LongitudeLongitude of the business address.Where available
34Registry Data As OfDate of the state file the record came from, as YYYY-MM-DD.Most records
35ListRiver IDRegistration state plus state filing number. A stable key for matching a business between an update and earlier files.All records

Notes

  • A business registered in several states has one row per registration. Use Registration State to see which registry a row came from and ListRiver ID to match rows between releases.
  • Blank means the state does not publish the field or we do not have it. Nothing is estimated or filled in.
  • Values that begin with =, + or @ are prefixed with an apostrophe so spreadsheets do not read them as formulas.
  • Custom lists from the list builder carry the same core fields; the pricing page shows which fields each plan includes.

For sources, definitions and known limits, see the methodology. For what the whole file contains and costs, see the full database.