Flying Pig Pub and Kitchen

Oceanside, CA 92054 · O51e0e98bef36 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: licensed2 licences

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
Flying Pig Pub and Kitchen 3 other
a source's own spelling of the licence name (record_title.py)
FLYING PIG PUB & KITCHEN ca-abcvtinfo ×3
Flying Pig Pub Kitchen toast (legal name)
Flying Pig Pub Kitchen Oceanside 509 Mission Ave toast
Street
509 MISSION AVE
ca-abcno other value
City
OCEANSIDE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92054
ca-abcno other value
Pin
33.19600, -117.37895 map
toastno other value
Phone
7605432940 1 other
vtinfo
7604532940 overturetoast ×2
Licences
ca-abc 00623531|47|LIC|0 · ca-abc 00623531|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofe215e2d55e0; Obc98a81feaec; Oc393fbd65b5d; Oa9a09289f83c; O8b99e6210d5c

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ca-abcFLYING PIG PUB & KITCHEN
00623531|47|LIC|0
509 MISSION AVE, OCEANSIDE, CA, 9205433.19592, -117.379382026-10-082026-11-12
ca-abcFLYING PIG PUB & KITCHEN
00623531|58|LIC|0
509 MISSION AVE, OCEANSIDE, CA, 9205433.19592, -117.379382026-10-082026-11-12
inspectionsFLYING PIG PUB AND KITCHEN
inspections|sdcounty|DEH2021-FFPP-013324
509 MISSION AVE, Oceanside, CA, 920542026-11-202026-11-20
overtureFlying Pig Pub and Kitchen
db90e2c4-69b1-4961-a335-bb15ec1a0830
509 Mission Ave, Oceanside, CA, 92054760453294033.19608, -117.379042026-11-062026-11-12
toastFlying Pig Pub Kitchen Oceanside 509 Mission Ave
legal name: Flying Pig Pub Kitchen
fd6e83af-5134-43f8-8336-f1795e3ff0db
509 Mission Ave, Oceanside, CA, 92054760453294033.19600, -117.378952026-11-062026-11-15
vtinfoFLYING PIG PUB & KITCHEN
e15d9100b2f30500
509 MISSION AVE, OCEANSIDE, CA, 92054760543294033.19599, -117.378942026-11-122026-11-14

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ca-abc FLYING PIG PUB & KITCHENca-abc FLYING PIG PUB & KITCHEN1.00one licence filemergedfile: 00623531 · same_address
ca-abc FLYING PIG PUB & KITCHENinspections FLYING PIG PUB AND KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENoverture Flying Pig Pub and Kitchen1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENtoast Flying Pig Pub Kitchen Oceanside 509 Mission Ave1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · matched through the licence's legal name: Flying Pig Pub Kitchen · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENvtinfo FLYING PIG PUB & KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENinspections FLYING PIG PUB AND KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENoverture Flying Pig Pub and Kitchen1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENtoast Flying Pig Pub Kitchen Oceanside 509 Mission Ave1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · matched through the licence's legal name: Flying Pig Pub Kitchen · name similarity 1.00
ca-abc FLYING PIG PUB & KITCHENvtinfo FLYING PIG PUB & KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
inspections FLYING PIG PUB AND KITCHENoverture Flying Pig Pub and Kitchen1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections FLYING PIG PUB AND KITCHENtoast Flying Pig Pub Kitchen Oceanside 509 Mission Ave1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: Flying Pig Pub Kitchen · name similarity 1.00
inspections FLYING PIG PUB AND KITCHENvtinfo FLYING PIG PUB & KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Flying Pig Pub and Kitchentoast Flying Pig Pub Kitchen Oceanside 509 Mission Ave1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · matched through the licence's legal name: Flying Pig Pub Kitchen · name similarity 1.00 · phone: equal
overture Flying Pig Pub and Kitchenvtinfo FLYING PIG PUB & KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00 · phone: differs
toast Flying Pig Pub Kitchen Oceanside 509 Mission Avevtinfo FLYING PIG PUB & KITCHEN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · matched through the licence's legal name: Flying Pig Pub Kitchen · name similarity 1.00 · phone: differs

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
206 within 1 mi · 503 within 3 mi
Off / on premise
32 / 134 within 1 mi · 112 / 306 within 3 mi
Selling alcohol
141 within 1 mi · 323 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
suburban (2,125 people per sq mi)
People within 3 mi
60,077 (47,770 adults 21+, 23,842 households) from 16 tract(s), tracts within 3 mi
Income
per capita $46,682 · median household ~$86,500 (weighted mean of tract medians)
Age and education
median age ~38.0 · bachelor's or higher 39%
Ethnicity
Hispanic 38% · White 52% · Black 4% · Asian 5%
Adults per alcohol outlet
147
Alcohol spend within 3 mi
$16,930,327 a year ($7,677,779 at home, $9,245,954 away) · $52,254 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2021-FFPP-013324 ↔ vtinfo e15d9100b2f30500same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2021-FFPP-013324 ↔ toast fd6e83af-5134-43f8-8336-f1795e3ff0dbsame address and namemerged17
2026-11-20 22:08insertca-abc 00623531|58|LIC|0 ↔ inspections inspections|sdcounty|DEH2021-FFPP-013324same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2021-FFPP-013324 ↔ overture db90e2c4-69b1-4961-a335-bb15ec1a0830same address and namemerged17
2026-11-20 22:08insertca-abc 00623531|47|LIC|0 ↔ inspections inspections|sdcounty|DEH2021-FFPP-013324same address and namemerged17
2026-11-12 14:25insertca-abc 00623531|58|LIC|0 ↔ vtinfo e15d9100b2f30500same address and namemerged12
2026-11-12 14:25insertoverture db90e2c4-69b1-4961-a335-bb15ec1a0830 ↔ vtinfo e15d9100b2f30500same address and namemerged12
2026-11-12 14:25insertca-abc 00623531|47|LIC|0 ↔ vtinfo e15d9100b2f30500same address and namemerged12
2026-11-12 14:25insertca-abc 00623531|58|LIC|0 ↔ toast fd6e83af-5134-43f8-8336-f1795e3ff0dbsame address and namemerged12
2026-11-12 14:25insertoverture db90e2c4-69b1-4961-a335-bb15ec1a0830 ↔ toast fd6e83af-5134-43f8-8336-f1795e3ff0dbsame address and namemerged12
2026-11-12 14:25insertca-abc 00623531|47|LIC|0 ↔ toast fd6e83af-5134-43f8-8336-f1795e3ff0dbsame address and namemerged12
2026-11-12 14:25inserttoast fd6e83af-5134-43f8-8336-f1795e3ff0db ↔ vtinfo e15d9100b2f30500same address and namemerged12
2026-11-06 18:13insertca-abc 00623531|58|LIC|0 ↔ overture db90e2c4-69b1-4961-a335-bb15ec1a0830same address and namemerged11
2026-11-06 18:13insertca-abc 00623531|47|LIC|0 ↔ overture db90e2c4-69b1-4961-a335-bb15ec1a0830same address and namemerged11
2026-10-09 13:59backfillca-abc 00623531|47|LIC|0 ↔ ca-abc 00623531|58|LIC|0one licence filemerged