Federalist Pig

Washington, DC 20009 · O430680687bc1 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
Federalist Pig 1 other
the most common name a source states
federalist pig washington doordash
Street
1654 COLUMBIA ROAD NW 2 other
dc-abca
1654 Columbia Rd NW overture
1654 Columbia Road Northwest doordash
City
Washington
dc-abcano other value
State
DC
dc-abcano other value
ZIP
20009
dc-abcano other value
Pin
38.92503, -77.03863 map
toastno other value
Phone
2028274400
toastno other value
Licences
dc-abca DC|ABRA-105172
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of4aa0ad5e254; Oa83f3f1da38b; Oaac5ae460518

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
dc-abcaFederalist Pig
DC|ABRA-105172
1654 COLUMBIA ROAD NW, Washington, DC, 2000938.92502, -77.038632026-11-182026-11-18
doordashfederalist pig washington
633809
1654 Columbia Road Northwest, Washington, DC, 2000938.92508, -77.038572026-10-082026-11-11
overtureFederalist Pig
882fbba4-6e8e-4d8c-bb2c-e1075d221f3e
1654 Columbia Rd NW, Washington, DC, 20009202827440038.92501, -77.038622026-11-092026-11-12
toastFederalist Pig
cf229d36-2a82-41bb-b2e6-855fbf9aabec
1654 Columbia Road NW, Washington, DC, 20009202827440038.92503, -77.038632026-11-062026-11-15

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
dc-abca Federalist Pigdoordash federalist pig washington1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
dc-abca Federalist Pigoverture Federalist Pig1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
dc-abca Federalist Pigtoast Federalist Pig1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
doordash federalist pig washingtonoverture Federalist Pig1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
doordash federalist pig washingtontoast Federalist Pig1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
overture Federalist Pigtoast Federalist Pig1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none — DC Restaurant Class C (not mapped)
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
686 within 1 mi · 3,308 within 3 mi
Off / on premise
87 / 410 within 1 mi · 427 / 1,877 within 3 mi
Selling alcohol
345 within 1 mi · 1,590 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.23 mi
Setting
urban (13,409 people per sq mi)
People within 3 mi
379,138 (305,811 adults 21+, 192,209 households) from 115 tract(s), tracts within 3 mi
Income
per capita $88,900 · median household ~$131,555 (weighted mean of tract medians)
Age and education
median age ~35.7 · bachelor's or higher 75%
Ethnicity
Hispanic 16% · White 48% · Black 26% · Asian 7%
Adults per alcohol outlet
192
Alcohol spend within 3 mi
$175,699,486 a year ($75,686,101 at home, $99,947,727 away) · $110,503 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-18 18:58insertdc-abca DC|ABRA-105172 ↔ doordash 633809same address and namemerged15
2026-11-18 18:58insertdc-abca DC|ABRA-105172 ↔ toast cf229d36-2a82-41bb-b2e6-855fbf9aabecsame address and namemerged15
2026-11-18 18:58insertdc-abca DC|ABRA-105172 ↔ overture 882fbba4-6e8e-4d8c-bb2c-e1075d221f3esame address and namemerged15
2026-11-12 14:25insertdoordash 633809 ↔ toast cf229d36-2a82-41bb-b2e6-855fbf9aabecsame address and namemerged12
2026-11-12 14:25insertdoordash 633809 ↔ overture 882fbba4-6e8e-4d8c-bb2c-e1075d221f3esame address and namemerged12
2026-11-09 15:32insertoverture 882fbba4-6e8e-4d8c-bb2c-e1075d221f3e ↔ toast cf229d36-2a82-41bb-b2e6-855fbf9aabecsame address and namemerged11