Store cities_served as a JSON array column. The firm appears once in the roster but renders on every city hub it serves via list mapping. The firm page itself lists all coverage cities, and search engines see the firm name on each city hub without the roster needing duplicate rows.

SleekRank does not validate license numbers against state regulators directly, but it can pull the data from a REST endpoint that your operations team maintains against the regulator portal. Set the cache duration to refresh weekly so license changes show up without manual sheet edits.

Flip the status column to suspended or revoked. The firm drops from hub lists on the next cache cycle, and you can choose to keep the firm page live with a banner or remove it entirely. The sitemap regenerates so search engines drop the URL cleanly if you remove the row.

Yes. With a URL pattern like /security/{service}/{city}/ each service plus city combination becomes a unique indexable page. Armed and unarmed are separate hubs, each rendering only firms tagged with that service in the roster. Buyers searching for "armed security Houston" land on the matching combination page.

Yes. Store insurance_general_liability and insurance_excess as columns. Selector mappings render them in the credibility block on the firm page, and you can filter hubs by minimum insurance threshold for procurement buyers who require specific coverage levels before accepting bids.

Yes. Build the quote form once in the base template using your normal form plugin. A hidden field captured via selector mapping passes the firm's routing ID with the submission, so quote requests land directly in the firm's inbox without per-page form configuration.

Use a single-element cities_served array. The firm appears on one city hub and renders a single coverage badge on its own page. The URL pattern still works because the same template handles both single-city and multi-city firms by iterating over the array.

Yes. Either filter the same page group on the services column to render only armed firms, or run two parallel page groups with separate URL patterns like /armed-security/{city}/ and /unarmed-security/{city}/. Both setups read the same underlying roster.