Outlets /
2ND AND MAIN COFFEEHOUSE
NILES, MI 49120 · O00fdb1ee64af · first seen 2026-11-03
4 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | 2ND AND MAIN COFFEEHOUSE 2 other | the most common name a source states | 2ND AND MAIN, INC. mi-lcc ×2 2nd & Main Coffeehouse overture |
| Street | 127 E MAIN ST | mi-lcc | no other value |
| City | NILES | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 49120 | mi-lcc | no other value |
| Pin | 41.83003, -86.25755 map | overture | no other value |
| Phone | 8888888888 1 other | vtinfo | 2693627434 mi-lcc ×2 |
| Licences | mi-lcc L-000459951 · mi-lcc L-000474160 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ofa3eb5d58b9a; O712bdee2e561; O6f38a47671bb; O3fa3d8b3d22b
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | 2ND AND MAIN COFFEEHOUSE 4732783 | 127 E MAIN ST, NILES, MI, 49120 | 41.82999, -86.25763 | 2026-11-11 | 2026-11-16 | |
| mi-lcc | 2ND AND MAIN, INC. L-000459951 | 127 E MAIN ST, NILES, MI, 49120 | 2693627434 | 41.82997, -86.25789 | 2026-11-03 | 2026-11-16 |
| mi-lcc | 2ND AND MAIN, INC. L-000474160 | 127 E MAIN ST, NILES, MI, 49120 | 2693627434 | 41.82997, -86.25789 | 2026-11-03 | 2026-11-16 |
| overture | 2nd & Main Coffeehouse 51d19e6e-b9e6-48c1-9846-c3c3067a5c2f | 127 E Main St, Niles, MI, 49120 | 8888888888 | 41.83003, -86.25755 | 2026-11-13 | 2026-11-16 |
| vtinfo | 2ND AND MAIN COFFEEHOUSE dbff7bf8a334d8f5 | 127 E MAIN ST, NILES, MI | 8888888888 | 41.83022, -86.25763 | 2026-11-16 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev 2ND AND MAIN COFFEEHOUSE | overture 2nd & Main Coffeehouse | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00 |
| ab-inbev 2ND AND MAIN COFFEEHOUSE | vtinfo 2ND AND MAIN COFFEEHOUSE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 26 m apart · name similarity 1.00 |
| mi-lcc 2ND AND MAIN, INC. | mi-lcc 2ND AND MAIN, INC. | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| overture 2nd & Main Coffeehouse | vtinfo 2ND AND MAIN COFFEEHOUSE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00 · phone: equal |
| ab-inbev 2ND AND MAIN COFFEEHOUSE | mi-lcc 2ND AND MAIN, INC. | 0.62 | one name contains the other, same address | merged | judge: None · pair_id: 9a61cbb5786e8627c06e · person: None · rule: names contained at one address · stratum: near |
| ab-inbev 2ND AND MAIN COFFEEHOUSE | mi-lcc 2ND AND MAIN, INC. | 0.62 | one name contains the other, same address | merged | judge: None · pair_id: 4dcc20e3db093bea2add · person: None · rule: names contained at one address · stratum: near |
Attributes
- Channel
- on_premise · restaurant — overture-category
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- 2ND AND MAIN, INC. — 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 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 37 within 1 mi · 80 within 3 mi
- Off / on premise
- 13 / 11 within 1 mi · 24 / 30 within 3 mi
- Selling alcohol
- 31 within 1 mi · 56 within 3 mi
- Nearest
- same channel 0.15 mi · licensed 0.02 mi
- Setting
- suburban (720 people per sq mi)
- People within 3 mi
- 20,370 (14,712 adults 21+, 8,089 households) from 6 tract(s), tracts within 3 mi
- Income
- per capita $27,406 · median household ~$52,609 (weighted mean of tract medians)
- Age and education
- median age ~37.8 · bachelor's or higher 16%
- Ethnicity
- Hispanic 6% · White 79% · Black 10% · Asian 0%
- Adults per alcohol outlet
- 258
- Alcohol spend within 3 mi
- $3,786,829 a year ($1,870,409 at home, $1,915,264 away) · $66,436 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-16 14:56 | insert | ab-inbev 4732783 ↔ mi-lcc L-000474160 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 4732783 ↔ mi-lcc L-000459951 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ab-inbev 4732783 ↔ vtinfo dbff7bf8a334d8f5 | same address and name | merged | 15 |
| 2026-11-16 14:56 | insert | overture 51d19e6e-b9e6-48c1-9846-c3c3067a5c2f ↔ vtinfo dbff7bf8a334d8f5 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 4732783 ↔ overture 51d19e6e-b9e6-48c1-9846-c3c3067a5c2f | same address and name | merged | 15 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000459951 ↔ mi-lcc L-000474160 | one store listed twice | merged |