civic_records

Building permits and business licenses from municipal open-data portals.

Data license: CC BY 4.0 · Data source: MyTown

2,492 rows where kind = "business_license"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: applied_date (date), issued_date (date), fetched_at (date)

kind 1

  • business_license · 2,492 ✖
Link rowid ▼ civic_source_id muni_id kind record_no address rec_type description applicant value applied_date issued_date status official_url fetched_at
1961 1961 49 56 business_license 1 21777 W Ventura Boulevard Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1962 1962 49 56 business_license 10 22837 Pacific Coast Highway Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1963 1963 49 56 business_license 11 9863 N Rincon Avenue Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1964 1964 49 56 business_license 12 5003 Whittier Boulevard Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1965 1965 49 56 business_license 13 1133 E Florence Avenue Adult Cabaret             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1966 1966 49 56 business_license 14 28124 Newhall Ranch Road Adult Cabaret             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1967 1967 49 56 business_license 15 19900 Normandie Avenue Adult Cabaret             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1968 1968 49 56 business_license 16 30354 Mulholland Highway Adult Cabaret             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1969 1969 49 56 business_license 17 10785 Northgate Street Adult Theatre             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1970 1970 49 56 business_license 18 451 AVIATION Boulevard Air Ambulance (Aircraft)             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1971 1971 49 56 business_license 19 10676 SHERMAN WAY Air Ambulance (Aircraft)             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1972 1972 49 56 business_license 2 21777 W Ventura Boulevard Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1973 1973 49 56 business_license 20 1055 W Avenue J Air Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1974 1974 49 56 business_license 21 716 N MCKEEVER Avenue Air Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1975 1975 49 56 business_license 22 16303 W Waterman Drive Air Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1976 1976 49 56 business_license 23 451 AVIATION Boulevard Air Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1977 1977 49 56 business_license 24 7755 HASKELL AVE Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1978 1978 49 56 business_license 25 7755 N Haskell Avenue Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1979 1979 49 56 business_license 26 6644 1/2 N Van Nuys Boulevard Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1980 1980 49 56 business_license 27 15105 S Broadway Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1981 1981 49 56 business_license 28 16945 W Sherman Way Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1982 1982 49 56 business_license 29 1055 W Avenue J Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1983 1983 49 56 business_license 3 4555 E 3rd Street Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1984 1984 49 56 business_license 30 13257 W Saticoy Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1985 1985 49 56 business_license 31 42540 N 6th Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1986 1986 49 56 business_license 32 900 W Glenoaks Boulevard Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1987 1987 49 56 business_license 33 17430 W Chatsworth Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1988 1988 49 56 business_license 34 1557 Santa Anita Avenue Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1989 1989 49 56 business_license 35 2019 N Lincoln Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1990 1990 49 56 business_license 36 1517 Braden Court Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1991 1991 49 56 business_license 37 190 S Mountain Trail Avenue Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1992 1992 49 56 business_license 38 2019 N LINCOLN ST Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1993 1993 49 56 business_license 39 2128 S ATLANTIC Boulevard Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1994 1994 49 56 business_license 4 1455 W Redondo Beach Boulevard Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1995 1995 49 56 business_license 40 1745 Pacific Avenue Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1996 1996 49 56 business_license 41 1801 ORANGE TREE Lane Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1997 1997 49 56 business_license 42 6605 E Washington Boulevard Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1998 1998 49 56 business_license 43 3200 E BIRCH Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
1999 1999 49 56 business_license 44 6850 Canby St. Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2000 2000 49 56 business_license 45 1040 E COMPTON Boulevard Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2001 2001 49 56 business_license 46 1515 W 190Th Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2002 2002 49 56 business_license 47 2950 E LA JOLLA Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2003 2003 49 56 business_license 48 716 N MCKEEVER Avenue Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2004 2004 49 56 business_license 49 13915 SATICOY ST Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2005 2005 49 56 business_license 5 22960 Newhall Ranch Road Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2006 2006 49 56 business_license 50 13915 W Saticoy Street Ambulance Operator             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2007 2007 49 56 business_license 6 28253 Newhall Ranch Road Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2008 2008 49 56 business_license 7 20615-17 SOLEDAD CYN RD Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2009 2009 49 56 business_license 8 20615 Soledad Canyon Road Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51
2010 2010 49 56 business_license 9 20617 Soledad Canyon Road Adult Bookstore             https://www.arcgis.com/home/item.html?id=8256f46ea75d49a1ba7cae2c807dce1c 2026-07-17 04:05:51

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "civic_records" ("civic_source_id", "muni_id", "kind", "record_no", "address", "rec_type", "description", "applicant", "value", "applied_date", "issued_date", "status", "official_url", "fetched_at");
CREATE INDEX "ix_civic_records_muni_id" ON "civic_records" ("muni_id");