Starfish by SATCO Retailers
Worldwide: 7 countries (6,389 US) · 6,525 locations
6,525 stores that carry Starfish by SATCO (6,389 in the US): every store on Starfish by SATCO's own store locator on satcostarfish.com.
More about this list
Name, address, phone, website and the locator's own store details.
The file has all 6,525 locations across 52 states in one download. Building the same list by searching one area at a time tends to miss places, and a missed place looks like a gap in coverage that is not really there.
Need just some of them? Ask in your own words.
●Where the rows are
≡Sample Data Preview
| store name | address | city | state | zip | phone | website | brand | store id | phone source | website source | description | status | directions url | brand locator store id | brand locator url | country as published | updated date | stockist custom field ids | src priority | custom account code | custom updated date | is chain | chain name | chain store count | overture place id | overture name | overture category | overture brand | overture match meters | overture match basis | naics code | naics title | sic code | sic title | industry source | country source | geo precision | county | county fips | county note | address quality | zip4 | country | latitude | longitude | source | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| First City Electric | 918 Water Street | Ketchikan | AK | 99901 | (907) 225-5688 | Starfish by SATCO | u23834-loc_46xxrey5 | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=55.34499068,-131.65462157 | loc_46xxrey5 | https://satcostarfish.com/ | United States | 2026-10-18 | 0 | N | 646e46b1-a2a8-4adf-ac2d-f65de2ef72f9 | First City Electric | electrician | 20 | name and location | source | Ketchikan Gateway Borough | 02130 | ZIP 99901 spans 2 counties; assigned to the county holding 86% of its land area | complete | US | 55.34499068 | -131.65462157 | Starfish by SATCO store locator | |||||||||||||||||
| Mayer Electric Supply Company, Inc | 1125 14th Street | Columbus | GA | 31906 | (706) 327-2689 | https://www.mayerelectric.com/Columbus | Starfish by SATCO | u23834-loc_32jjxmy9 | Overture Maps place | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=32.4730532,-84.97631392 | loc_32jjxmy9 | https://satcostarfish.com/ | United States | 2026-10-18 | 0 | Y | Mayer Electric Supply Company, Inc | 51 | 71d783ba-8b7c-47b7-98c5-1824b8af0c8f | Mayer Electric Supply | warehouse_club_store | Mayer | 119 | name and location | 455211 | Warehouse Clubs and Supercenters | 5399 | Miscellaneous General Merchandise Stores | Overture category of the matched place | source | Muscogee County | 13215 | complete | 2207 | US | 32.4730532 | -84.97631392 | Starfish by SATCO store locator | |||||||
| Cranberry Hill Lighting LLC | 1280 US ROUTE 1 | Cape Neddick | ME | 03902 | Starfish by SATCO | u23834-loc_xgvqrqn6 | Listed | https://www.google.com/maps/dir/?api=1&destination=43.19361392,-70.6207298 | loc_xgvqrqn6 | https://satcostarfish.com/ | United States | 2026-10-18 | 0 | N | source | York County | 23031 | complete | US | 43.19361392 | -70.6207298 | Starfish by SATCO store locator | |||||||||||||||||||||||||
| Hagemeyer North America | 403 Heron Drive, Suite D | Swedesboro | NJ | 08085 | (856) 467-5411 | http://www.hagemeyerna.com | Starfish by SATCO | u23834-loc_32jjxe79 | Overture Maps place | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=39.76056514,-75.36641235 | loc_32jjxe79 | https://satcostarfish.com/ | United States | 2026-10-18 | 0 | Y | Hagemeyer North America | 45 | afd2f33a-f22f-43e6-9eec-9385d032ba21 | Hagemeyer North America | professional_service | 19 | name and location | source | Gloucester County | 34015 | ZIP 08085 spans 2 counties; assigned to the county holding 99% of its land area | complete | US | 39.76056514 | -75.36641235 | Starfish by SATCO store locator | |||||||||||||
| Crescent Electric Supply Company | 910 W 19th Street | Yankton | SD | 57078 | (605) 665-3471 | https://www.crescentelectric.com/locations/sd/yankton/910-w-19th-st | Starfish by SATCO | u23834-loc_3mppjgpv | Overture Maps place | Overture Maps place | Listed | https://www.google.com/maps/dir/?api=1&destination=42.88837027,-97.40611596 | loc_3mppjgpv | https://satcostarfish.com/ | United States | 2026-10-18 | 0 | Y | Crescent Electric Supply Company | 108 | eda00a03-7e8f-4686-9451-8a05e7d6536f | Crescent Electric Supply Company | warehouse_club_store | Crescent Electric Supply Company | 28 | name and location | 455211 | Warehouse Clubs and Supercenters | 5399 | Miscellaneous General Merchandise Stores | Overture category of the matched place | source | Yankton County | 46135 | complete | 1940 | US | 42.88837027 | -97.40611596 | Starfish by SATCO store locator |
{}What's in each row
| Field | What it is | Rows filled |
|---|---|---|
| brand | The brand whose store locator lists the store | 100% |
| store | Store id (unique per place in this file) | 100% |
| store | Store name as the brand's locator lists it | 100% |
| address | Street address | 100% |
| city | City | 99% |
| state | State or province code (US always; outside the US where the locator gives one) | 100% |
| zip | ZIP or postal code | 99% |
| country | Two-letter country code | 100% |
| latitude | Latitude | 100% |
| longitude | Longitude | 100% |
| phone | Store phone | 59% |
| phone | Where the phone came from: the brand's store locator, or the matched Overture place | 59% |
| website | Store website | 56% |
| website | Where the website came from: the brand's store locator, or the matched Overture place | 56% |
| status | Listed | 100% |
| directions | Google Maps directions link | 100% |
| brand | The store's id on the brand's locator | 100% |
| brand | The brand's store locator page | 100% |
| country | The country as the locator wrote it, where it differs from the code | 98% |
| source | Source of the row | 100% |
| updated | Date the brand's locator was read | 100% |
| stockist | Ids of the locator's custom fields set on this store | 2% |
| src_ | Another field the brand's locator publishes for the store: priority | 100% |
| custom_ | A custom field the brand's locator shows for the store: Account Code | 2% |
| is | Y when 5 or more stores in these brand lists carry the same store name | 100% |
| chain | Chain name | 76% |
| chain | Stores with that chain name across these brand lists | 76% |
| overture | Overture Maps place id of the matched place (join key to Overture data) | 59% |
| overture | Name of the matched Overture place | 59% |
| overture | Overture category of the matched place | 59% |
| overture | Brand of the matched Overture place | 15% |
| overture | Distance between the store and the matched Overture place, in metres | 59% |
| overture | overtureMatchBasis | 59% |
| naics | NAICS 2022 code | 33% |
| naics | NAICS title | 33% |
| sic | SIC code | 33% |
| sic | SIC title | 33% |
| industry | Where the industry code came from | 33% |
| country | countrySource | 2% |
| geo_ | How the map point was set | 100% |
| county | US county (from the store's coordinates) | 98% |
| county_ | US county FIPS code | 98% |
| county_ | Set when the ZIP spans counties | 21% |
| address_ | complete, no house number, po box, missing city or zip or missing | 100% |
| zip4 | ZIP+4 extension | 17% |
Rows filled is measured on every row of the delivered file.
✓Where this data comes from
Each row names the public source it came from, so any record can be checked against where it was published.
October 19, 2026
Snapshot built
48 fields
Columns in the file
Fill measured
On every row of the delivered file
How we build and date every file: methodology.
Using ChatGPT, Claude or an API?
No setup needed. Ask ChatGPT or Claude your question about the Starfish by SATCO Retailers and give it this page: it can open https://locationlists.com/find?dataset=starfish-by-satco-retailers with the filters you need and show you the count and price.
Using ChatGPT or Claude? Tell it to answer from locationlists.com/find — no account, no connector.
How assistants ask
No connector needed. Any AI assistant can answer from this site with a web link, no connector, no account: open https://locationlists.com/find with the question as query parameters.
If a question needs filtering, distance, drive time, combining lists or a price, open a /find link: either put the question itself in q=, or build the structured link. The answer does not need an API, a connector or an account.
Simplest, the question itself: https://locationlists.com/find?q=<the question in plain words>
Or set the parts yourself: https://locationlists.com/find?dataset=<slug>&state=<ST>&city=<city>&county=<county>&zip=<zip>&near=<place or zip>&radius=<miles>&drive=<minutes>&where=<column>:<op>:<value>&total=<rows>
Leave out what the question does not need. Use radius for straight-line miles or drive for minutes of driving (5 to 60), not both; near can name several places separated by | to reach from any of them. To ask about several lists at once, use datasets with two or more names, or category with a kind of business. To compare two lists, add relate=nearest and the other list with b. in front of its parameters. To count by area, use areas=county (or zip, state, metro). To keep only places whose county, ZIP code, metro area or state meets a Census figure, add area_where (for example county:population>1000000); with areas, per=100000 gives counts per 100,000 residents.
Links an assistant can open, each showing how many rows match, a few preview rows and the price for just that part:
- Only California, the state with the most: https://locationlists.com/find?dataset=starfish-by-satco-retailers&state=CA
- Within 25 miles of New York, NY, the busiest area: https://locationlists.com/find?dataset=starfish-by-satco-retailers&near=New+York+NY&radius=25
- Within a 30-minute drive of New York, NY: https://locationlists.com/find?dataset=starfish-by-satco-retailers&near=New+York+NY&drive=30
- Only rows where isChain is Y: https://locationlists.com/find?dataset=starfish-by-satco-retailers&where=isChain%3Aeq%3AY
- Every Home, Kitchen & Appliances list combined, within 25 miles of Edgewater, NJ: https://locationlists.com/find?category=home-kitchen-and-appliances&near=Edgewater+NJ&radius=25
- Each one's nearest CLR Brands Retailers, in California, with miles: https://locationlists.com/find?dataset=starfish-by-satco-retailers&state=CA&relate=nearest&k=1&b.dataset=clr-brands-retailers&b.state=CA
- The whole list: add a city, state, ZIP code or distance:
https://locationlists.com/find?dataset=starfish-by-satco-retailers - In plain words: "Starfish by SATCO Retailers in California": https://locationlists.com/find?q=Starfish+by+SATCO+Retailers+in+California
- In plain words: "Starfish by SATCO Retailers within 25 miles of New York, NY": https://locationlists.com/find?q=Starfish+by+SATCO+Retailers+within+25+miles+of+New+York%2C+NY
Optional: connect for repeat use or wallet payments:
Read https://locationlists.com/skill.md and follow the instructions to connect LocationLists. Then show me the Starfish by SATCO Retailers list.Your assistant will walk you through setup and show you the price before you pay.
For developers
Every step below has a no-connector equivalent: https://locationlists.com/find?dataset=starfish-by-satco-retailers with the same filters as query parameters.
- Connect your agent to
https://locationlists.com/mcp(no key, no signup). - Call
count_locationswithdataset: "starfish-by-satco-retailers"and any filter — it is free, and returns how many rows match and what they cost. - Fetch the rows with
query_locations: $1.21 per 100 rows from this dataset. Above 3,263 rows, buying the whole file is cheaper.
Paid in USDC over x402 — the agent gets an HTTP 402 with the exact price, signs, and retries. Money moves only after rows are delivered, so a failed or empty query costs nothing. Setup for Claude, Cursor and VS Code
?Frequently Asked Questions
Where does this data come from?
From Starfish by SATCO's own store locator on satcostarfish.com. We read every store on its map on 2026-10-19. A store the map shows twice (same name and address) is one row.
What is one row?
One store on the brand's locator, with the brand's own tags for it (storeType) and any custom fields the locator shows.
Does it include stores outside the US?
Yes. 136 of the 6,525 stores are outside the US, across 6 countries. Filter on country for one market.
Where do websites and phones come from?
From the brand's locator where it gives them. Otherwise from the Overture Maps place at the same spot with the same name. phoneSource and websiteSource say which.
How complete are phones and websites?
3,826 of the 6,525 stores have a phone, and 3,665 of the 6,525 have a website.