OpenData / Features / Full column spec

The full column spec: all 12 fields in every OpenData record

By the OpenData team · 15 Nov 2026

Every OpenData record — in the downloadable files and in the API — carries the same 12 fields, so what you test in the free sample is exactly what you get when you buy. This page defines each field, where it comes from, and how buyers actually use it.

OpenData index — 23,984,359 domains scanned · 1,504,744 verified stores · snapshot 15 Nov 2026

Identity fields: which store is this?

The first three fields pin down the store itself. They are present on all 1,504,744 verified records in the 15 Nov 2026 snapshot, because a record only becomes verified once our own scanner has fetched the storefront and confirmed it is a real, live shop.

Market fields: where does it sell?

Country and currency tell you which market a store operates in before you spend a minute researching it. Both are read from the storefront itself — its settings, localisation and checkout — not guessed from the domain suffix.

Stack fields: what does it run on?

Three fields describe the store's technology. They come from markers our scanner detects in the live page source, so they reflect what the store runs today — not what it ran when some third-party list was compiled. Segment slices built on these fields are among our most-used lists; the Cloudflare slice alone covers 141,204 stores and the React slice 81,205.

Contact fields: present only where the store publishes them

Two fields carry contact details, and we are blunt about their coverage: they are filled only where the store itself publishes them on its own site. Across the verified index, 205,297 stores publish a business email and 38,416 publish a business phone. The rest of the row is complete — the contact cells are simply empty, never padded with guesses.

Provenance fields: where did this row come from?

The last two fields are the audit trail. Every other database asks you to trust its counts; these two fields let you check any single row yourself, which is also what makes our historical archive possible.

Same 12 fields everywhere: files, sample and API

There is one record format across everything we sell. Paid pulls (billed per row, no subscriptions) carry all 12 fields as CSV plus a formatted spreadsheet twin. The API returns the same 12 fields per store, with filters for platform, technology, app, gateway, country and has-email. And the free sample for each industry uses the identical layout with contacts masked — so the file you test is structurally the file you buy.

Questions, answered straight

How many fields does an OpenData record have?

Twelve: domain, store name, platform, country, currency, technologies, apps, payment gateways, public business email, business phone, source URL and last-observed date. The same 12 fields appear in the downloadable files and in API responses.

Does every record include an email address?

No, and we state the real coverage: 205,297 of the 1,504,744 verified stores publish a business email on their own site. Where a store does not publish one, the field is left empty rather than filled with a guess. You can filter any list or API query to email-bearing stores only.

Are the phone numbers personal mobile numbers?

No. The phone field holds business numbers that stores publish for their customers, present on 38,416 stores. We collect public business facts only, and we never buy or copy third-party contact lists.

What is the source URL for?

It is the exact page where our scanner observed the store, so you can open it and verify the record yourself — the platform, the apps and the published contact details are all visible there. Together with the last-observed date, it makes every row auditable.

Can I see the fields before paying?

Yes. Each industry has a free sample file with the identical 12-field layout (contacts masked), and the free store checker includes 30 full-record unlocks a month. Paid pulls are billed per row — full records $4 per 1,000 rows, platform records $1 per 1,000 rows — with no subscription, and the data is refreshed monthly.

Next steps