Sample Data Guide
Our free sample file shows exactly what is inside our business datasets.
It has 81 businesses and
159 contacts across
2 sheets, linked by a single
id
column: join Data.id to
Contact details.id to see a business with all of its contacts.
Sheet: Data
One row per business, keyed by id. 81 event planners in the United States with names, contact details, ratings, addresses, opening hours and business features.
Identity
| Column | What it means | Example |
|---|---|---|
id |
Business ID. Unique here - one row per business. Use it to match rows in the Contact details sheet. | 1 |
name |
Business name. | Palace of Fine Arts |
status |
Whether the business is open or closed. | Open |
categories |
All categories the business is listed under. | Event venue, Event planner, Wedding venue |
description |
Short description of the business. | Theater & dance in a landmark building |
location_summary |
Longer editorial summary of the location, when available. | Set on 230 acres, this elegant Spanish-style… |
Phone numbers
| Column | What it means | Example |
|---|---|---|
phone |
Main phone number as displayed. | (415) 360-3731 |
phone_isd |
Phone with country code. | +1 415-360-3731 |
phone_e164 |
Phone in E.164 dialling format. | +14153603731 |
Website and email
| Column | What it means | Example |
|---|---|---|
website |
Full business website URL. | https://palaceoffinearts.com/ |
domain |
Website domain only. | palaceoffinearts.com |
emails |
Verified email addresses found for the business. | [email protected] |
uncertain_emails |
Email addresses found but not verified. | [email protected] |
Social profiles
| Column | What it means | Example |
|---|---|---|
facebook |
Facebook page URL. | https://www.facebook.com/Npuevents |
instagram |
Instagram profile URL. | https://www.instagram.com/npu.live |
twitter |
X / Twitter profile URL. | https://x.com/TheEscapeGame |
youtube |
YouTube channel URL. | https://www.youtube.com/theescapegame |
linkedin |
LinkedIn company page URL. | https://www.linkedin.com/company/non-plus-ultra-inc |
Ratings and reviews
| Column | What it means | Example |
|---|---|---|
rating |
Average rating out of 5. | 4.8 |
review_count |
Total number of reviews. | 26227 |
photo_count |
Total number of photos. | 177184 |
rating_1_star |
How many 1-star reviews. | 151 |
rating_2_star |
How many 2-star reviews. | 103 |
rating_3_star |
How many 3-star reviews. | 709 |
rating_4_star |
How many 4-star reviews. | 3924 |
rating_5_star |
How many 5-star reviews. | 21340 |
Price, time and status
| Column | What it means | Example |
|---|---|---|
price_range |
Price level symbol, when listed. | $ |
price_range_text |
Price level in words, when listed. | Moderate |
hotel_star_rating |
Star rating for hotels, when listed. | 4 stars |
timezone |
IANA timezone of the business. | America/Los_Angeles |
open_now |
Whether the business is currently open. | Open |
Address
| Column | What it means | Example |
|---|---|---|
address |
Full address on one line. | 3301 Lyon St, San Francisco, CA 94123 |
street |
Street address. | 3301 Lyon St |
street2 |
Second street line, if any. | 3301 Lyon St |
neighborhood |
Neighborhood, when known. | Marina District |
city |
City. | San Francisco |
zip |
Postcode. | 94123 |
state |
State. | California |
country |
Country. | United States |
country_code |
Two-letter country code. | US |
floor |
Floor, when listed. | Floor 1 |
latitude |
GPS latitude. | 37.8029308 |
longitude |
GPS longitude. | -122.4484231 |
Opening hours
| Column | What it means | Example |
|---|---|---|
monday |
Monday hours, or Closed. | Closed |
tuesday |
Tuesday hours. | 12–9 PM |
wednesday |
Wednesday hours. | 12–9 PM |
thursday |
Thursday hours. | 12–10 PM |
friday |
Friday hours. | 12–11 PM |
saturday |
Saturday hours. | 12–11 PM |
sunday |
Sunday hours. | 12–8 PM |
Business features (info_*)
| Column | What it means | Example |
|---|---|---|
info_service_options |
Services offered, e.g. onsite services. | Onsite services |
info_accessibility |
Accessibility features. | Wheelchair accessible entrance, Wheelchair accessible parkin... |
info_amenities |
Amenities available. | Restroom |
info_payments |
Accepted payment methods. | Credit cards, Debit cards |
info_children |
Child-friendliness, when listed. | Good for kids |
info_parking |
Parking options. | Free parking lot, Free street parking, On-site parking |
info_activities |
Activities offered, when listed. | Mini golf |
info_offerings |
Food and drink offerings, when listed. | Alcohol, Beer, Cocktails, Coffee |
info_atmosphere |
Atmosphere tags, when listed. | Casual, Cozy, Lively |
info_crowd |
Who the venue welcomes. | LGBTQ+ friendly, Transgender safespace |
info_dining_options |
Dining options, when listed. | Brunch, Lunch, Dinner, Catering |
info_highlights |
Notable highlights. | Active military discounts |
info_health_safety |
Health and safety measures, when listed. | — |
info_planning |
Planning advice, when listed. | Getting tickets in advance recommended |
info_popular_for |
What the venue is popular for, when listed. | Lunch, Dinner, Solo dining |
info_currencies_accepted |
Accepted currencies, when listed. | — |
info_languages |
Languages spoken, when listed. | — |
info_ownership |
Ownership details, when listed. | — |
info_from_the_business |
How the business describes itself, when listed. | Identifies as women-owned |
info_getting_here |
Directions info, when listed. | — |
info_recycling |
Recycling info, when listed. | — |
info_other |
Any other listed details. | — |
Bookings
| Column | What it means | Example |
|---|---|---|
reservation_websites |
Booking links as structured data, e.g. OpenTable. Empty ([]) when none. | [{"provider": "opentable.com", …}] |
Sheet: Contact details
One row per contact (email address), keyed by the same id as the Data sheet. 159 contacts across 37 of the 81 businesses, up to 20 for one business.
Who
| Column | What it means | Example |
|---|---|---|
id |
Business ID from the Data sheet. Repeats when a business has more than one contact. | 1 |
email |
The contact email address. | [email protected] |
account_type |
role means a shared address (info@, events@); person means an individual. | role |
email_type |
generic for shared addresses, personal for individuals. | generic |
first_name |
First name, when known. | Bruce |
last_name |
Last name, when known. | — |
full_name |
Full name, when known. | Bruce |
job_title |
Job title, when known. | — |
business_name |
Business this contact belongs to. | Palace of Fine Arts |
domain |
Business website domain. | palaceoffinearts.com |
How to reach them
| Column | What it means | Example |
|---|---|---|
business_phone |
Main business phone. | (415) 360-3731 |
phones |
Extra phone numbers found, comma-separated. | +40727305902 |
contact_phones |
All phone numbers tied to this contact. | +40727305902, (404) 974-4831 |
website_emails |
Emails found on the business website. | [email protected] |
uncertain_emails |
Emails found but not verified. | [email protected] |
city |
City. | San Francisco |
zip |
Postcode. | 94123 |
state |
State. | California |
country |
Country. | United States |
Trust signals
| Column | What it means | Example |
|---|---|---|
confidence_level |
How sure we are: verified, weak, or unmatched. | verified |
match_type |
How the email was matched: role_account, first_name_only, full_name. | role_account |
evidence_types |
What backs the match, when available. | email_first_name_only, unique_first_name_on_domain |
source_url |
Page where the contact was found, when available. | https://chattanoogariverboat.com/… |
enrich_status |
Always "enriched" in this file. | enriched |
Social profiles
| Column | What it means | Example |
|---|---|---|
facebook |
Facebook page URL. | https://www.facebook.com/Npuevents |
instagram |
Instagram profile URL. | https://www.instagram.com/npu.live |
twitter |
X / Twitter profile URL. | https://x.com/TheEscapeGame |
youtube |
YouTube channel URL. | https://www.youtube.com/theescapegame |
linkedin |
LinkedIn company page URL. | https://www.linkedin.com/company/non-plus-ultra-inc |
social_links |
Combined social links, when available. | — |
Unused in this sample
| Column | What it means | Example |
|---|---|---|
contact_job_titles |
Reserved for future enrichment; empty in this file. | — |