Pig-N-Pizza

Three Rivers, MI 49093 · O5c6bebaf9689 · first seen 2026-11-03
3 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
Pig-N-Pizza 1 other
a source's own spelling of the licence name (record_title.py)
PIG N PIZZA LLC inspectionsmi-lcc ×3
Street
60010 Corey Lake Rd
mi-lccno other value
City
Three Rivers
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49093
mi-lccno other value
Pin
41.92527, -85.76072 map
overtureno other value
Phone
2692449915 1 other
overture
2695067720 mi-lcc ×2
Licences
mi-lcc L-000474296 · mi-lcc L-000474297
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Occ444a151d22; Oa405f1f0f440; O6fe21761003d

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
inspectionsPIG N PIZZA LLC
inspections|mi|SFE-1414-357175
60010 COREY LAKE RD, Three Rivers, MI, 4909341.92485, -85.760592026-11-202026-11-20
mi-lccPIG N PIZZA LLC
L-000474296
60010 Corey Lake Rd, Three Rivers, MI, 49093269506772041.92540, -85.760562026-11-032026-11-20
mi-lccPIG N PIZZA LLC
L-000474297
60010 Corey Lake Rd, Three Rivers, MI, 49093269506772041.92540, -85.760562026-11-032026-11-20
overturePig-N-Pizza
f8c92299-21bc-4cab-9666-0fe52ba4efc7
60010 Corey Lake Rd, Three Rivers, MI, 49093269244991541.92527, -85.760722026-11-062026-11-20

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
inspections PIG N PIZZA LLCmi-lcc PIG N PIZZA LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00
inspections PIG N PIZZA LLCmi-lcc PIG N PIZZA LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 61 m apart · name similarity 1.00
inspections PIG N PIZZA LLCoverture Pig-N-Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
mi-lcc PIG N PIZZA LLCmi-lcc PIG N PIZZA LLC1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc PIG N PIZZA LLCoverture Pig-N-Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00 · phone: differs
mi-lcc PIG N PIZZA LLCoverture Pig-N-Pizza1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00 · phone: differs

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PIG N PIZZA LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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|mi|SFE-1414-357175 ↔ mi-lcc L-000474296same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1414-357175 ↔ mi-lcc L-000474297same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1414-357175 ↔ overture f8c92299-21bc-4cab-9666-0fe52ba4efc7same address and namemerged17
2026-11-06 18:13insertmi-lcc L-000474296 ↔ overture f8c92299-21bc-4cab-9666-0fe52ba4efc7same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000474297 ↔ overture f8c92299-21bc-4cab-9666-0fe52ba4efc7same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000474296 ↔ mi-lcc L-000474297one store listed twicemerged