Database
69,240 Flower Shops across 27,185 Cities in US
Phone numbers, addresses and zip codes of 69,240 florist shops in the United States
Samples
CSV
Listed below are the first 10 - 100 (or more) records of each of the 4 tables.
Download CSV
flower top
| id | city_id | title | zip_code | phone | address | description |
|---|---|---|---|---|---|---|
| 1 | 583 | Anchor Point Greenhouse | 99556 | 9072357288 | Anchor Point, AK | |
| 2 | 584 | Bakers Blossoms | 99501 | 907-561-7770 | Anchorage, AK | |
| 3 | 584 | Secret Garden | 99519 | 3606924323 | Anchorage, AK | |
| 4 | 584 | Flowers For The Moment | 99519 | 8004887251 | Anchorage, AK | |
| 5 | 584 | Bunka Art Richards | 99519 | 9072431346 | Anchorage, AK | |
| 6 | 584 | Bloomies Floral - Gifts | 99519 | 8007709446 | Anchorage, AK | |
| 7 | 584 | Bagoy S Florist | 99519 | 9072775532 | Anchorage, AK | |
| 8 | 584 | Js Cafe - Bloomers | 99519 | 9072745297 | Anchorage, AK | |
| 9 | 584 | Mylord S Floral Center | 99519 | 8007112535 | Anchorage, AK | |
| 10 | 584 | Floral Gift & Art Gallery | 99519 | 9073387768 | Anchorage, AK | |
| 11 | 584 | Muffy's Magic Garden | 99519 | 9075624770 | Anchorage, AK | |
| 12 | 584 | Rose Garden | 99519 | 9075635515 | Anchorage, AK | |
| 13 | 584 | Statewide Wholesale | 99519 | 9075223480 | Anchorage, AK | |
| 14 | 584 | Alaska Flower Shop | 99519 | 9075615277 | Anchorage, AK | |
| 15 | 584 | Action Florist | 99519 | 9073454433 | Anchorage, AK | |
| 16 | 584 | Petals & Stems | 99519 | 9075617774 | Anchorage, AK | |
| 17 | 584 | Uptown Blossoms | 99519 | 9075617673 | Anchorage, AK | |
| 18 | 584 | Floral Expressions | 99519 | 9073311770 | Anchorage, AK | |
| 19 | 584 | Shakepeare's Garden | 99519 | 9073449592 | Anchorage, AK | |
| 20 | 584 | Flowers By June | 99519 | 9073331114 | Anchorage, AK | |
| 21 | 584 | Floral Expressions | 99519 | 9072970570 | Anchorage, AK | |
| 22 | 584 | Flower Room | 99519 | 9072725477 | Anchorage, AK | |
| 23 | 584 | Juju Flowers | 99519 | 9072792956 | Anchorage, AK | |
| 24 | 584 | Ju Ju Flowers | 99519 | 9073442956 | Anchorage, AK | |
| 25 | 584 | Gift Notions | 99519 | 9072727857 | Anchorage, AK | |
| 26 | 584 | Floral Expressions | 99519 | 9073481370 | Anchorage, AK | |
| 27 | 584 | Down The Aisle | 99519 | 9072729900 | Anchorage, AK | |
| 28 | 584 | Petals & Bows Florist | 99519 | 9072777006 | Anchorage, AK | |
| 29 | 584 | D C Flowers Balloons & Gifts | 99519 | 9073380650 | Anchorage, AK | |
| 30 | 584 | Gestures Of The Heart | 99519 | 9072588083 | Anchorage, AK | |
| 31 | 584 | Green Connection | 99519 | 9072767836 | Anchorage, AK | |
| 32 | 584 | Thiele Brothers Landscaping | 99519 | 9072435323 | Anchorage, AK | |
| 33 | 584 | Arctic Blossoms | 99519 | 9073384892 | Anchorage, AK | |
| 34 | 584 | Evalyn's Floral | 99519 | 9075617322 | Anchorage, AK | |
| 35 | 584 | Shelly's Magic Garden | 99519 | 9072221655 | Anchorage, AK | |
| 36 | 584 | Bagoy's Flowers | 99519 | 9072771922 | Anchorage, AK | |
| 37 | 584 | Every Bloomin' Thing | 99519 | 9072743158 | Anchorage, AK | |
| 38 | 584 | Muffy's Magic Garden Ii | 99519 | 9077706459 | Anchorage, AK | |
| 39 | 584 | Adrian's Flowers | 99519 | 9072431000 | Anchorage, AK | |
| 40 | 584 | Picadilly Flowers | 99519 | 9075627673 | Anchorage, AK | |
| 41 | 584 | Midnight Rose | 99519 | 9072724646 | Anchorage, AK | |
| 42 | 584 | Market Garden Design | 99519 | 9078681568 | Anchorage, AK | |
| 43 | 584 | Stems Inc | 99519 | 9075633366 | Anchorage, AK | |
| 44 | 584 | Lighted Forest Candle Co | 99519 | 9073499425 | Anchorage, AK | |
| 45 | 584 | Market Garden Design | 99519 | 9079295268 | Anchorage, AK | |
| 46 | 584 | Bell's Nursery | 99519 | 9073452654 | Anchorage, AK | |
| 47 | 584 | Aurora Florist | 99519 | 9075611608 | Anchorage, AK | |
| 48 | 584 | Dimond Greenhouses | 99519 | 9073492552 | Anchorage, AK | |
| 49 | 584 | Mylord's Floral Ctr | 99519 | 9075222535 | Anchorage, AK | |
| 50 | 584 | Eden Orchids | 99519 | 9073331719 | Anchorage, AK | |
Download CSV
city top
| id | state_id | title | count | slug |
|---|---|---|---|---|
| 1 | 1 | Abbeville Bakery | 14 | al-alabama/abbeville |
| 2 | 1 | Abernant Bakery | 29 | al-alabama/abernant |
| 3 | 1 | Adamsville Bakery | 175 | al-alabama/adamsville |
| 4 | 1 | Addison Bakery | 18 | al-alabama/addison |
| 5 | 1 | Adger Bakery | 144 | al-alabama/adger |
| 6 | 1 | Akron Bakery | 12 | al-alabama/akron |
| 7 | 1 | Alabaster Bakery | 50 | al-alabama/alabaster |
| 8 | 1 | Alberta Bakery | 5 | al-alabama/alberta |
| 9 | 1 | Albertville Bakery | 45 | al-alabama/albertville |
| 10 | 1 | Alexander City Bakery | 15 | al-alabama/alexander-city |
| 11 | 1 | Alexandria Bakery | 45 | al-alabama/alexandria |
| 12 | 1 | Aliceville Bakery | 10 | al-alabama/aliceville |
| 13 | 1 | Allgood Bakery | 28 | al-alabama/allgood |
| 14 | 1 | Alma Bakery | 16 | al-alabama/alma |
| 15 | 1 | Alpine Bakery | 30 | al-alabama/alpine |
| 16 | 1 | Alton Bakery | 172 | al-alabama/alton |
| 17 | 1 | Altoona Bakery | 31 | al-alabama/altoona |
| 18 | 1 | Andalusia Bakery | 14 | al-alabama/andalusia |
| 19 | 1 | Anderson Bakery | 30 | al-alabama/anderson |
| 20 | 1 | Annemanie Bakery | 5 | al-alabama/annemanie |
| 21 | 1 | Anniston Bakery | 26 | al-alabama/anniston |
| 22 | 1 | Arab Bakery | 42 | al-alabama/arab |
| 23 | 1 | Ardmore Bakery | 39 | al-alabama/ardmore |
| 24 | 1 | Ariton Bakery | 10 | al-alabama/ariton |
| 25 | 1 | Arley Bakery | 32 | al-alabama/arley |
| 26 | 1 | Arlington Bakery | 14 | al-alabama/arlington |
| 27 | 1 | Ashford Bakery | 35 | al-alabama/ashford |
| 28 | 1 | Ashland Bakery | 24 | al-alabama/ashland |
| 29 | 1 | Ashville Bakery | 43 | al-alabama/ashville |
| 30 | 1 | Athens Bakery | 44 | al-alabama/athens |
| 31 | 1 | Atmore Bakery | 11 | al-alabama/atmore |
| 32 | 1 | Attalla Bakery | 39 | al-alabama/attalla |
| 33 | 1 | Auburn Bakery | 23 | al-alabama/auburn |
| 34 | 1 | Auburn University Bakery | 24 | al-alabama/auburn-university |
| 35 | 1 | Autaugaville Bakery | 16 | al-alabama/autaugaville |
| 36 | 1 | Axis Bakery | 85 | al-alabama/axis |
| 37 | 1 | Baileyton Bakery | 52 | al-alabama/baileyton |
| 38 | 1 | Banks Bakery | 16 | al-alabama/banks |
| 39 | 1 | Bankston Bakery | 17 | al-alabama/bankston |
| 40 | 1 | Bay Minette Bakery | 25 | al-alabama/bay-minette |
| 41 | 1 | Bayou La Batre Bakery | 71 | al-alabama/bayou-la-batre |
| 42 | 1 | Bear Creek Bakery | 27 | al-alabama/bear-creek |
| 43 | 1 | Beatrice Bakery | 10 | al-alabama/beatrice |
| 44 | 1 | Beaverton Bakery | 22 | al-alabama/beaverton |
| 45 | 1 | Belk Bakery | 23 | al-alabama/belk |
| 46 | 1 | Bellamy Bakery | 15 | al-alabama/bellamy |
| 47 | 1 | Belle Mina Bakery | 44 | al-alabama/belle-mina |
| 48 | 1 | Bellwood Bakery | 34 | al-alabama/bellwood |
| 49 | 1 | Berry Bakery | 11 | al-alabama/berry |
| 50 | 1 | Bessemer Bakery | 164 | al-alabama/bessemer |
Download CSV
city_to_flower top
| id | city_id | flower_id |
|---|---|---|
| 1 | 1 | 174 |
| 2 | 1 | 175 |
| 3 | 1 | 177 |
| 4 | 1 | 176 |
| 5 | 1 | 619 |
| 6 | 1 | 620 |
| 7 | 1 | 615 |
| 8 | 1 | 616 |
| 9 | 1 | 617 |
| 10 | 1 | 618 |
| 11 | 1 | 614 |
| 12 | 1 | 806 |
| 13 | 1 | 807 |
| 14 | 1 | 805 |
| 15 | 2 | 811 |
| 16 | 2 | 823 |
| 17 | 2 | 1416 |
| 18 | 2 | 447 |
| 19 | 2 | 446 |
| 20 | 2 | 1488 |
| 21 | 2 | 1450 |
| 22 | 2 | 1473 |
| 23 | 2 | 293 |
| 24 | 2 | 303 |
| 25 | 2 | 296 |
| 26 | 2 | 304 |
| 27 | 2 | 297 |
| 28 | 2 | 298 |
| 29 | 2 | 289 |
| 30 | 2 | 302 |
| 31 | 2 | 295 |
| 32 | 2 | 292 |
| 33 | 2 | 301 |
| 34 | 2 | 294 |
| 35 | 2 | 300 |
| 36 | 2 | 299 |
| 37 | 2 | 291 |
| 38 | 2 | 290 |
| 39 | 2 | 1212 |
| 40 | 2 | 1211 |
| 41 | 2 | 1116 |
| 42 | 2 | 632 |
| 43 | 2 | 631 |
| 44 | 3 | 811 |
| 45 | 3 | 422 |
| 46 | 3 | 702 |
| 47 | 3 | 418 |
| 48 | 3 | 420 |
| 49 | 3 | 1115 |
| 50 | 3 | 416 |
Download CSV
state top
| id | title | count | abbreviation | slug |
|---|---|---|---|---|
| 1 | Alabama Bakery | 22909 | AL | al-alabama |
| 2 | Alaska Bakery | 833 | AK | ak-alaska |
| 3 | Arizona Bakery | 9974 | AZ | az-arizona |
| 4 | Arkansas Bakery | 15269 | AR | ar-arkansas |
| 5 | California Bakery | 219340 | CA | ca-california |
| 6 | Colorado Bakery | 12242 | CO | co-colorado |
| 7 | Connecticut Bakery | 44832 | CT | ct-connecticut |
| 8 | DC Bakery | 590 | DC | dc-dc |
| 9 | Delaware Bakery | 6058 | DE | de-delaware |
| 10 | Florida Bakery | 53476 | FL | fl-florida |
| 11 | Georgia Bakery | 35795 | GA | ga-georgia |
| 12 | Hawaii Bakery | 5454 | HI | hi-hawaii |
| 13 | Idaho Bakery | 2754 | ID | id-idaho |
| 14 | Illinois Bakery | 140871 | IL | il-illinois |
| 15 | Indiana Bakery | 42759 | IN | in-indiana |
| 16 | Iowa Bakery | 23507 | IA | ia-iowa |
| 17 | Kansas Bakery | 11705 | KS | ks-kansas |
| 18 | Kentucky Bakery | 35635 | KY | ky-kentucky |
| 19 | Louisiana Bakery | 19429 | LA | la-louisiana |
| 20 | Maine Bakery | 13178 | ME | me-maine |
| 21 | Maryland Bakery | 76277 | MD | md-maryland |
| 22 | Massachusetts Bakery | 76481 | MA | ma-massachusetts |
| 23 | Michigan Bakery | 11019 | MI | mi-michigan |
| 24 | Minnesota Bakery | 30191 | MN | mn-minnesota |
| 25 | Mississippi Bakery | 9821 | MS | ms-mississippi |
| 26 | Missouri Bakery | 29674 | MO | mo-missouri |
| 27 | Montana Bakery | 1563 | MT | mt-montana |
| 28 | Nebraska Bakery | 7455 | NE | ne-nebraska |
| 29 | Nevada Bakery | 2845 | NV | nv-nevada |
| 30 | New Hampshire Bakery | 18348 | NH | nh-new-hampshire |
| 31 | New Jersey Bakery | 411769 | NJ | nj-new-jersey |
| 32 | New Mexico Bakery | 3732 | NM | nm-new-mexico |
| 33 | New York Bakery | 360584 | NY | ny-new-york |
| 34 | North Carolina Bakery | 43356 | NC | nc-north-carolina |
| 35 | North Dakota Bakery | 1666 | ND | nd-north-dakota |
| 36 | Ohio Bakery | 86157 | OH | oh-ohio |
| 37 | Oklahoma Bakery | 13974 | OK | ok-oklahoma |
| 38 | Oregon Bakery | 13668 | OR | or-oregon |
| 39 | Pennsylvania Bakery | 245274 | PA | pa-pennsylvania |
| 40 | Rhode Island Bakery | 17474 | RI | ri-rhode-island |
| 41 | South Carolina Bakery | 20293 | SC | sc-south-carolina |
| 42 | South Dakota Bakery | 2202 | SD | sd-south-dakota |
| 43 | Tennessee Bakery | 28704 | TN | tn-tennessee |
| 44 | Texas Bakery | 54779 | TX | tx-texas |
| 45 | Utah Bakery | 6453 | UT | ut-utah |
| 46 | Vermont Bakery | 8905 | VT | vt-vermont |
| 47 | Virginia Bakery | 44081 | VA | va-virginia |
| 48 | Washington Bakery | 25658 | WA | wa-washington |
| 49 | West Virginia Bakery | 24945 | WV | wv-west-virginia |
| 50 | Wisconsin Bakery | 27290 | WI | wi-wisconsin |
| 51 | Wyoming Bakery | 488 | WY | wy-wyoming |