Search neighborhoods

Demonstrating simple like search

Custom SQL query returning 6 rows (hide)

select neighborhood, facet_cities.name, state
from facetable
    join facet_cities
        on facetable.city_id = facet_cities.id
where neighborhood like '%' || :text || '%'
order by neighborhood;

Query parameters

text

This data as json, CSV

neighborhood	name	state
Corktown	Detroit	MI
Downtown	Los Angeles	CA
Downtown	Detroit	MI
Greektown	Detroit	MI
Koreatown	Los Angeles	CA
Mexicantown	Detroit	MI