Hoodie Bev
Scrape & data console
Healthy
36
Degraded / failed
10
No creds
0
Never run
0
Rows landed
7,936,606

Browse data / ca-abc

ca_outlets · 130,937 rows total · run history
↓ Download CSV
← Prev page 38 of 2619 · 130,937 rows Next →
idlicense_typefile_numberlic_or_apptype_statusorig_issue_dateexpir_datefee_codesdup_countsmaster_indterm_monthsgeo_codedistrictprimary_nameprem_addr1prem_addr2prem_cityprem_stateprem_zipdba_namemail_addr1mail_addr2mail_citymail_statemail_zipprem_countyprem_census_tractpulled_atfirst_seen_atlast_seen_at
00054345|47|LIC|04700054345LICACTIVE01-JAN-197731-MAY-2027P0Y12350226JARDINES DE SAN JUAN115 3RD STSAN JUAN BAUTISTACA95045JARDINES DE SAN JUANP O BOX 940SAN JUAN BAUTISTACA95045SAN BENITO0002.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054345|58|APP|05800054345APPACTIVEP0001N12350226JARDINES DE SAN JUAN115 3RD STSAN JUAN BAUTISTACA95045JARDINES DE SAN JUAN130 OLD RANCH RDSANTA CRUZCA95060SAN BENITO0002.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054352|48|LIC|04800054352LICACTIVE01-JAN-199428-FEB-2027P40Y12340523GREENERS PUB LTD1928 L STSACRAMENTOCA95811MERCANTILE SALOON1928 L STSACRAMENTOCA95811SACRAMENTO0011.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054352|48|LIC|14800054352LICACTIVE01-JAN-199428-FEB-2027P40001N12340523GREENERS PUB LTD1928 L STSACRAMENTOCA95811MERCANTILE SALOON1928 L STSACRAMENTOCA95811SACRAMENTO0011.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054507|21|LIC|02100054507LICACTIVE01-OCT-197430-JUN-2027P40Y12371009THE VONS COMPANIES INC11986 BERNARDO PLAZA DRSAN DIEGOCA92128-2538VONS 2079PO BOX 29096MAIL STOP 6516PHOENIXAZ85038-9096SAN DIEGO0170.142026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054507|86|LIC|08600054507LICACTIVE09-AUG-201730-JUN-2027P40Y12371009THE VONS COMPANIES INC11986 BERNARDO PLAZA DRSAN DIEGOCA92128-2538VONS 2079PO BOX 29096MAIL STOP 6516PHOENIXAZ85038-9096SAN DIEGO0170.142026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054519|52|LIC|05200054519LICACTIVE06-MAY-195830-SEP-2027P40Y12193305ALL AMERICAN POST NO. 2323 VFW17522 CHATSWORTH STGRANADA HILLSCA91344-5719ALL AMERICAN POST 2323LOS ANGELES1113.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054533|51|LIC|05100054533LICACTIVE28-MAR-195631-MAR-2027P0Y12240029LOS BANOS SPORTSMEN ASSNMERCEY SPRINGS RD W/S 2M N OFLOS BANOSCA93635LOS BANOS SPORTSMENPO BOX 746LOS BANOSCA93635MERCED0021.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054573|51|LIC|05100054573LICACTIVE29-MAR-195431-MAR-2027P0Y12310123ELKS LODGE AUBURN 1691195 PINE STAUBURNCA95603ELKS LODGE AUBURN 1691PLACER0204.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054573|58|LIC|05800054573LICACTIVE29-MAR-195431-MAR-2027P0001N12310123ELKS LODGE AUBURN 1691195 PINE STAUBURNCA95603ELKS LODGE AUBURN 1691PLACER0204.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054584|52|LIC|05200054584LICACTIVE01-JAN-199430-APR-2027P40Y12194603AMERICAN LEGION SOUTH BAY POST 184412 CAMINO REALREDONDO BEACHCA90277LOS ANGELES6213.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054584|58|LIC|05800054584LICACTIVE01-JAN-199430-APR-2027P40001N12194603AMERICAN LEGION SOUTH BAY POST 184412 CAMINO REALREDONDO BEACHCA90277LOS ANGELES6213.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054591|48|LIC|04800054591LICACTIVE01-JAN-197831-JAN-2027P40Y12380024CASTLE SUSAN B1101 OCEAN AVESAN FRANCISCOCA94112RANDY'S PLACESAN FRANCISCO0312.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054605|41|LIC|04100054605LICACTIVE01-AUG-197731-MAY-2027P40Y12380024NASER JULIET A501-03 IRVING STSAN FRANCISCOCA94122YELLOW SUBMARINE THE1438 21ST AVESAN FRANCISCOCA94122SAN FRANCISCO0301.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054612|52|LIC|05200054612LICACTIVE17-MAY-196328-FEB-2027P20Y12196902THE TEMPLE CITY POST 279 AMERICAN LEGION9522 LAS TUNAS DRTEMPLE CITYCA91780-2104AMERICAN LEGION POST 279PO BOX 856TEMPLE CITYCA91780-0856LOS ANGELES4320.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054644|52|LIC|05200054644LICACTIVE12-MAR-194830-APR-2027P40Y12191005AMERICAN LEGION BURBANK POST 150 IN940 W OLIVE AVEBURBANKCA91506AMERICAN LEGION BURBANK POST 150 INCLOS ANGELES3108.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054670|20|APP|02000054670APPACTIVEP40Y12193304COTTER CHURCH SUPPLIES INC1701 JAMES M WOOD BLVDLOS ANGELESCA90015COTTER CHURCH SUPPLIES INCLOS ANGELES2094.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054670|20|LIC|02000054670LICACTIVE01-AUG-197531-OCT-2026P40Y12193304COTTER CHURCH SUPPLIES INC1701 JAMES M WOOD BLVDLOS ANGELESCA90015COTTER CHURCH SUPPLIES INC1701 JAMES M WOOD BLVDLOS ANGELESCA90015LOS ANGELES2094.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054749|21|LIC|02100054749LICACTIVE01-OCT-197330-JUN-2027P40Y12193305THE VONS COMPANIES INC7789 FOOTHILL BLVDSUNLANDCA91040VONS 2124PO BOX 29096MAIL STOP 6516PHOENIXAZ85038-9096LOS ANGELES1031.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054761|51|LIC|05100054761LICACTIVE10-JUN-195631-JAN-2027P40Y12370810EAGLES LODGE AERIE 27121131 ROOSEVELT AVENATIONAL CITYCA91950EAGLES AERIE 2712SAN DIEGO0219.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00054875|47|LIC|04700054875LICACTIVE01-JUN-197631-MAY-2027P40Y12410525VALS REDWOOD ROOM INC2468 JUNIPERO SERRA BLVDDALY CITYCA94015VALS REDWOOD ROOM INC744A LAUREL AVEBURLINGAMECA94010-2714SAN MATEO6012.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055067|51|LIC|05100055067LICACTIVE22-MAY-197931-JUL-2027P0Y12040031PARADISE PINES PROPERTY OWNERS ASSO14211 WYCLIFF WYMAGALIACA95954PARADISE PINES PROPERTY OWNERS ASSOCIATIONBUTTE0017.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055067|58|LIC|05800055067LICACTIVE22-MAY-197931-JUL-2027P0001N12040031PARADISE PINES PROPERTY OWNERS ASSO14211 WYCLIFF WYMAGALIACA95954PARADISE PINES PROPERTY OWNERS ASSOCIATIONBUTTE0017.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055069|51|LIC|05100055069LICACTIVE08-APR-195530-SEP-2027P0Y12070022SAN JOAQUIN YACHT CLUB550 RIVERVIEW PLBETHEL ISLANDCA94511SAN JOAQUIN YACHT CLUBPO BOX 326BETHEL ISLANDCA94511CONTRA COSTA3020.112026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055135|21|LIC|02100055135LICACTIVE30-NOV-196430-JUN-2027P40Y12193305GELSONS MARKETS4738 LAUREL CANYON BLVDNORTH HOLLYWOODCA91607-3912GELSONS MARKET13833 FREEWAY DRSANTA FE SPRINGSCA90670LOS ANGELES1433.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055135|41|LIC|04100055135LICACTIVE15-JAN-202031-DEC-2026P40Y12193305GELSONS MARKETS4738 LAUREL CANYON BLVDNORTH HOLLYWOODCA91607-3912GELSONS MARKET13833 FREEWAY DRSANTA FE SPRINGSCA90670LOS ANGELES1433.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055135|58|LIC|05800055135LICACTIVE15-JAN-202031-DEC-2026P40001N12193305GELSONS MARKETS4738 LAUREL CANYON BLVDNORTH HOLLYWOODCA91607-3912GELSONS MARKET13833 FREEWAY DRSANTA FE SPRINGSCA90670LOS ANGELES1433.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055135|86|LIC|08600055135LICACTIVE01-JUL-201630-JUN-2027P40Y12193305GELSONS MARKETS4738 LAUREL CANYON BLVDNORTH HOLLYWOODCA91607-3912GELSONS MARKET13833 FREEWAY DRSANTA FE SPRINGSCA90670LOS ANGELES1433.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055189|51|LIC|05100055189LICACTIVE23-MAY-195630-SEP-2026P40Y12194502POMONA AERIE NO. 2215 FRATERNAL ORDER OF EAGLES954 W MISSION BLVDPOMONACA91766-1445EAGLES LODGELOS ANGELES4025.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055191|20|APP|02000055191APPACTIVEP20Y12240129PAUL OIL COMPANY INC1198 WINTON WAYATWATERCA95301ATWATER SHELLPO BOX 248OAKDALECA95361-0248MERCED0007.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055191|20|LIC|02000055191LICACTIVE15-JAN-197931-JAN-2027P20Y12240129PAUL OIL COMPANY INC1198 WINTON WAYATWATERCA95301ATWATER SHELLPO BOX 248OAKDALECA95361-0248MERCED0007.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055202|21|LIC|02100055202LICACTIVE01-JAN-199428-FEB-2027P40Y12560612TOPPER MOTOR HOTEL & LIQUORS INC1696 E THOMPSON BLVDVENTURACA93001TOPPER MOTOR HOTEL & LIQUORS INCVENTURA0026.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055401|20|LIC|02000055401LICACTIVE01-JUL-196731-JAN-2027P40Y12193304SOTELO CONCEPCION3300 E CESAR E CHAVEZ AVELOS ANGELESCA90063LOS CINCO PINTOSLOS ANGELES2048.102026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055432|48|LIC|04800055432LICACTIVE14-MAY-199628-FEB-2027P0Y12310123W G W INVESTMENTS INC1580 LINCOLN WYAUBURNCA95603CALIFORNIA CLUB THEPLACER0204.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055434|51|LIC|05100055434LICACTIVE01-JAN-199430-APR-2027P0Y12540021KINGS RIVER GOLF & COUNTRY CLUB INCAVE 400KINGSBURGCA93631KINGS RIVER GOLF & COUNTRY CLUB3100 AVE 400KINGSBURGCA93631TULARE0003.032026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055575|52|LIC|05200055575LICACTIVE01-JAN-199431-MAY-2027P0Y12360007AMERICAN LEGION POST 4979980 CEDAR AVEBLOOMINGTONCA92316AMERICAN LEGION POST 497SAN BERNARDINO0036.062026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055625|51|LIC|05100055625LICACTIVE01-APR-197731-MAY-2027P40Y12362207ELKS LODGE YUCAIPA 238912165 2ND STYUCAIPACA92399ELKS LODGE YUCAIPA 2389SAN BERNARDINO0088.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055625|58|LIC|05800055625LICACTIVE01-APR-197731-MAY-2027P40001N12362207ELKS LODGE YUCAIPA 238912165 2ND STYUCAIPACA92399ELKS LODGE YUCAIPA 2389SAN BERNARDINO0088.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055666|51|LIC|05100055666LICACTIVE01-AUG-197730-JUN-2027P40Y12560312MOOSE LODGE OXNARD 5611935 S OXNARD BLVDOXNARDCA93033OXNARD MOOSE LODGE 561VENTURA0039.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055682|51|LIC|05100055682LICACTIVE02-AUG-199128-FEB-2027P0Y12470031SQUAW VALLEY RIDING CLUB500 HWY 89MCCLOUDCA96057SQUAW VALLEY RIDING CLUBPO BOX 435MCCLOUDCA96057SISKIYOU0009.022026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055814|51|LIC|05100055814LICACTIVE01-JAN-199430-APR-2027P40Y12193304BRENTWOOD COUNTRY CLUB LOS ANGELES590 S BURLINGAME AVELOS ANGELESCA90049BRENTWOOD COUNTRY CLUB LOS ANGELESLOS ANGELES2643.052026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055891|48|LIC|04800055891LICACTIVE01-JAN-197831-JAN-2027P0Y12490527JACKS CENTRAL CIGAR STORE INC153 N MAIN STSEBASTOPOLCA95472OLD MAIN ST SALOON INCSONOMA1534.062026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055912|52|LIC|05200055912LICACTIVE16-MAR-194828-FEB-2027P40Y12100521AMERICAN LEGION FRESNO FEDERAL POST3509 N 1ST STFRESNOCA93726AMERICAN LEGION POST 509FRESNO0051.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055912|58|LIC|05800055912LICACTIVE16-MAR-194828-FEB-2027P40001N12100521AMERICAN LEGION FRESNO FEDERAL POST3509 N 1ST STFRESNOCA93726AMERICAN LEGION POST 509FRESNO0051.002026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055913|52|LIC|05200055913LICACTIVE04-MAR-195031-MAR-2027P0Y12340023AMERICAN LEGION POST 5216700 8TH STRIO LINDACA95673AMERICAN LEGION POST 521SACRAMENTO0072.092026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055919|41|APP|04100055919APPACTIVEP40Y12196102LAUREL FOODS INC16363 WHITTIER BLVDWHITTIERCA90603-2912SEAFARE INNLOS ANGELES5002.012026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055972|52|LIC|05200055972LICACTIVE01-MAY-197628-FEB-2027P0Y12151106VFW CALIFORNIA CITY POST 937521016 NEURALIA RDCALIFORNIA CITYCA93505VETERANS OF FOREIGN WARS POST 9375KERN0055.112026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055995|47|APP|04700055995APPACTIVEP20Y12302811WIND & SEA RESTAURANTS INC.34699 STREET OF THE GOLDEN LANTERNDANA POINTCA92629WIND & SEA RESTAURANTORANGE0423.132026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055995|47|LIC|04700055995LICACTIVE01-JAN-199431-MAY-2027P20Y12302811WIND & SEA RESTAURANTS INC.34699 STREET OF THE GOLDEN LANTERNDANA POINTCA92629WIND & SEA RESTAURANTORANGE0423.132026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
00055995|47|LIC|14700055995LICACTIVE01-JAN-199431-MAY-2027P20001N12302811WIND & SEA RESTAURANTS INC.34699 STREET OF THE GOLDEN LANTERNDANA POINTCA92629WIND & SEA RESTAURANTORANGE0423.132026-10-08 18:02:08.547236+00:002026-09-24 16:15:52.954133+00:002026-10-08 18:02:09.386853+00:00
← Prev page 38 of 2619 · 130,937 rows Next →