Applegate Market

Porterville, CA 93257 · O039788ff6884 · first seen 2026-10-08
5 sourcesoff premise · conveniencealcohol: licensed1 licence

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
Applegate Market 2 other
a source's own spelling of the licence name (record_title.py)
Applegates Market overture
applegates market porterville doordash
Street
212 N NEWCOMB ST 1 other
ca-abc
212 North Newcomb Street doordash
City
PORTERVILLE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93257
ca-abcno other value
Pin
36.06971, -119.05276 map 2 other
doordash
64 m away ab-inbev
871 m away ca-abc
Phone
5597819112
overtureno other value
Licences
ca-abc 00636909|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob2f3a5ab5cc0; O36eb4828c5cd; Od8a46381d01d; O212009a0f017

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
ab-inbevAPPLEGATE MARKET
1340415
212 N NEWCOMB ST, PORTERVILLE, CA, 9325736.07028, -119.052902026-11-112026-11-19
ca-abcAPPLEGATE MARKET
00636909|21|LIC|0
212 N NEWCOMB ST, PORTERVILLE, CA, 9325736.06188, -119.052922026-10-082026-11-19
doordashapplegates market porterville
26198417
212 North Newcomb Street, Porterville, CA, 9325736.06971, -119.052762026-10-082026-11-19
overtureApplegates Market
f81bac71-2fa1-4853-b109-302cfe3164db
212 N Newcomb St, Porterville, CA, 93257559781911236.06968, -119.052682026-11-062026-11-19
snapApplegate Market
snap|us|1155095
212 N Newcomb St, Porterville, CA, 9325736.06968, -119.052702026-11-192026-11-19

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
ab-inbev APPLEGATE MARKETca-abc APPLEGATE MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 934 m apart · name similarity 1.00
ab-inbev APPLEGATE MARKETsnap Applegate Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 69 m apart · name similarity 1.00
ca-abc APPLEGATE MARKETsnap Applegate Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 867 m apart · name similarity 1.00
doordash applegates market portervilleoverture Applegates Market1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev APPLEGATE MARKETdoordash applegates market porterville0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 64 m apart · name similarity 0.65
ab-inbev APPLEGATE MARKEToverture Applegates Market0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 69 m apart · name similarity 0.65
ca-abc APPLEGATE MARKETdoordash applegates market porterville0.65Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
The names agree: 'Applegate Market' and the DoorDash slug 'applegates market porterville' (the city appended) are the same name at the identical street address and ZIP. So the shared-building count of
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give the same street address, city and ZIP (212 N Newcomb St, Porterville 93257), and the names match closely (APPLEGATE MARKET vs the DoorDash slug 'applegates market porterville'); the CA off-sale market licence fits a grocery storefront. The building is shared with another business, but the names agree, so the address match plus name match supports SAME.
pair ab96e23d0c2cd4b54ce3
ca-abc APPLEGATE MARKEToverture Applegates Market0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 868 m apart · name similarity 0.65
doordash applegates market portervillesnap Applegate Market0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 7 m apart · name similarity 0.65
overture Applegates Marketsnap Applegate Market0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 2 m apart · name similarity 0.65

Attributes

Channel
off_premise · convenience — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:39.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-19 20:37insertoverture f81bac71-2fa1-4853-b109-302cfe3164db ↔ snap snap|us|1155095same address and namemerged17
2026-11-19 20:37insertdoordash 26198417 ↔ snap snap|us|1155095same address and namemerged17
2026-11-19 20:37insertab-inbev 1340415 ↔ snap snap|us|1155095same address and namemerged17
2026-11-19 20:37insertca-abc 00636909|21|LIC|0 ↔ snap snap|us|1155095same address and namemerged17
2026-11-11 12:56insertab-inbev 1340415 ↔ overture f81bac71-2fa1-4853-b109-302cfe3164dbsame address and namemerged12
2026-11-11 12:56insertab-inbev 1340415 ↔ doordash 26198417same address and namemerged12
2026-11-11 12:56insertab-inbev 1340415 ↔ ca-abc 00636909|21|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00636909|21|LIC|0 ↔ overture f81bac71-2fa1-4853-b109-302cfe3164dbsame address and namemerged11
2026-11-06 18:13insertdoordash 26198417 ↔ overture f81bac71-2fa1-4853-b109-302cfe3164dbsame address and namemerged11
2026-11-02 23:02backfillca-abc 00636909|21|LIC|0 ↔ doordash 26198417Claude judge: samemerged