Your Data

Once you've purchased state data, the real power of GeoData opens up. The data explorer is where you browse, filter, visualize, and download every business record in the states you own. It's the most feature-rich part of the platform -- a combined data table, interactive map, and advanced filter system all in one view.

Why a Platform, Not Just a File

A state like California has over 200,000 business records. Texas has nearly 100,000. If you tried to work with datasets this large in Excel or Google Sheets, you'd immediately run into problems: slow load times, freezing on sorts, row limits, and no way to meaningfully search or cross-reference the data.

GeoData's data explorer is purpose-built for this. It handles hundreds of thousands of records without breaking a sweat -- instant filtering, sortable columns, paginated browsing, and a live map visualization. You can search for "all pizza restaurants in San Francisco with an email address" and get results in under a second, across a dataset of 200,000+ rows. No formulas, no pivot tables, no waiting. Just ask the data what you want and get answers immediately.

Getting There

From your dashboard, click Purchased Data in the sidebar. You'll see a grid of all the states you've bought, each showing the state name, flag, and total number of businesses. Click any state card to open its data explorer.

The Data Explorer

When you open a state, you land on a split-screen view: an interactive map on the left and a data table on the right. On mobile, these are separated into two tabs.

Header

The header bar at the top shows:

• The state flag and name
• The total business count for that state
• Aggregate contact stats -- how many records have emails, Instagram, Facebook, and phone numbers
• A view mode toggle (desktop only) to switch between: map + table side by side, map only, or table only

The Data Table

The table is where you explore individual business records. It's designed to handle massive datasets -- even states with 200,000+ records load instantly, with results shown 100 rows at a time.

Columns

Each row shows the following information:

Every column is sortable -- click any column header to sort ascending, descending, or clear the sort. Columns are also resizable by dragging the column edges.

Row Details

Click any row to open a full detail dialog showing everything about that business:

• Basic Information -- address, coordinates, category, subcategory, brand, location count, operating status, market/DMA, county FIPS, and census tract
• Contact Information -- clickable email links, phone links, website links, Instagram handles, and Facebook pages
• Alternate Categories -- all additional business classifications

Selecting Rows

Use the checkboxes to select individual rows, or hold Shift and click to select a range. When you select all rows on a page and there are more results beyond that page, you'll see a prompt to "Select all X rows" across every page.

Filtering

The filter system is where the platform really shines over traditional spreadsheet tools. Instead of writing complex formulas or building pivot tables, you get a visual interface that lets you narrow down hundreds of thousands of records to exactly what you need in seconds. There are two ways to filter.

Table Filters

Click the Filters button above the table to open the full filter panel. You can filter on:

• Name -- search by business name
• Address -- search by street address
• City -- narrow to a specific city
• Email -- find businesses with specific email addresses
• Phone -- search by phone number
• Website -- filter by website URL
• Facebook -- filter by Facebook page
• Instagram -- filter by Instagram handle
• Location Count -- filter by number of locations (supports numeric operators: equals, greater than, less than, etc.)
• Market / DMA -- filter by metropolitan market name
• County -- filter by county FIPS code
• Census Tract -- filter by census tract GEOID

Each text filter supports multiple conditions with operators like Contains, Equals, Starts with, Ends with, Does not contain, Is empty, and Is not empty. You can combine multiple conditions on the same field. Numeric fields like Location Count support Equals, Greater than, Greater than or equal, Less than, Less than or equal, Is empty, and Is not empty.

Category Filter

The category filter is a hierarchical multi-select that mirrors GeoData's full category tree:

• Top-level groups -- Restaurants, Cafes, Bars, and Other
• Subcategories within each group -- with the count of matching records
• Search -- type to quickly find a specific subcategory
• Select all / Deselect all at the group level

Selected categories appear as removable badges, making it easy to see and adjust your active filters.

Per-Column Filters

Each column header also has a dropdown menu (the three-dot icon) where you can apply a quick filter directly on that column without opening the full filter panel.

Active Filters

When filters are active, a badge on the Filters button shows how many are applied, and the result count updates to show how many records match. A "Clear" button lets you reset all filters at once.

The Map

The map gives you a geographic view of every business in the state, rendered using WebGL for smooth performance even with hundreds of thousands of points. Where a spreadsheet can only show you rows and columns, the map instantly reveals geographic patterns -- clusters, gaps, density hotspots -- that would take hours of manual analysis to uncover from tabular data.

Category Colors

Points are color-coded by category:

• Blue -- Cafes and coffee shops
• Orange -- Bars, pubs, and cocktail bars
• Green -- Restaurants, diners, and grills

Interacting with the Map

• Hover over any point to see a quick tooltip with the business name, category, and which contact info is available
• Click a point to pin its details -- this fetches the full record showing name, address, category, brand, emails, phone, website, Instagram, and Facebook
• Click the map background to dismiss a pinned tooltip
• Zoom and pan to explore different areas of the state

Map Use Cases

The map is useful for much more than just seeing where businesses are:

• Market analysis -- visually identify areas with high or low density of specific business types
• Competitive mapping -- see where competitors are clustered and where gaps exist
• Territory planning -- divide geographic areas for sales teams based on actual business density
• Site selection -- evaluate potential locations by seeing what's nearby
• Data validation -- spot-check records by clicking individual points to verify the data matches expectations

Downloading Your Data

Download All

Click the "Download All Data" button to download every record for the current state (respecting any active filters). A confirmation dialog shows the total row count before proceeding.

Download Selected

When you have rows selected, a "Download Selected" button appears. This downloads only the records you've checked. If you've used the "Select all" feature to select across all pages, it downloads the entire filtered dataset.

File Format

Downloads come as a ZIP file containing a CSV with all data fields. The filename follows the pattern geodata-{state}-all-{count}.zip or geodata-{state}-selected-{count}.zip.

The CSV is ready to import into Excel, Google Sheets, any CRM, or data processing tool.

Tips

• You don't need to download everything to start working -- use the platform's filters and sorting to explore your data first, then download only the subset you actually need
• Use the map to identify geographic clusters, then switch to the table to explore the businesses in those areas
• Filter by "Is not empty" on email to get only businesses with contact information -- ideal for outreach campaigns
• Combine city + category filters for hyper-targeted lists (e.g., all Pizza Restaurants in San Francisco)
• Use the view mode toggle to go full-screen on the map when doing geographic analysis, or full-screen on the table when building download lists
• Download filtered subsets rather than the full dataset when you only need a specific slice -- filtered downloads only include matching records
• Think of GeoData as your working environment, not just a download portal -- the search, filter, and sort capabilities are designed to replace the tedious spreadsheet work you'd otherwise have to do yourself