Data sources
Every table and context layer on this site, with its grain, vintage, refresh cadence, the date it was last pulled, and the licence that governs it. Counts are sites carrying the layer at build 2026-10-20 out of 1902. No subscription data is used; rating-agency and servicer findings arrive secondhand through news reports and are labelled as such.
Core tables
| Table | Holds | Count | Sources | Licence |
|---|---|---|---|---|
site | Name, type, place, acres, GLA, years, strategy, new use, status | 1902 | authors' public map (180), Wikipedia and Wikidata, news extraction, contributions | mixed; see tiers |
deal | Sales, listings, auctions, loans, special servicing, foreclosures | 537 rows on 351 sites | news watcher (Bing News RSS, 6-hourly), Wikipedia text, rating-agency notes via news | facts; quotes under fair use, linked |
parcel | Owner of record, acres, assessed value, last deed | 48 sites | county assessor GIS services | county terms, unverified here |
party / site_party | Owners, operators, developers, architects with role and year | 1482 | Wikidata, Wikipedia, research | CC0 / CC BY-SA |
photo | Site photos with author and licence | 324 sites with a key photo | Wikimedia Commons, Openverse | per photo (CC) |
event | Opened, closed, retrofit, notes with year | 5884 | as site | as site |
Context layers
| Layer | What | Sites | Grain | Vintage | Refresh | Last pulled | Source | Licence |
|---|---|---|---|---|---|---|---|---|
assessment | Structured assessment of the record | 1901 | site | build | each build | model, record-only, with quotes | ours | |
peers | Six most similar sites | 1722 | site | build | each build | computed | ours | |
cluster | Market cluster | 1547 | site | build | each build | computed | ours | |
retail_trend | Retail establishments and jobs 2012 vs 2023 | 1485 | county | CBP 2012, 2023 | annual | Census County Business Patterns | public domain | |
permits | Building permits, county | 1484 | county | BPS 2019 to 2024 | annual | 2026-10-18 | Census Building Permits Survey | public domain |
housing_market | Home values and rents, 10-year change | 1452 | county | Sep 2026 | monthly | Zillow Research ZHVI / ZORI | free with attribution; resale needs Zillow terms | |
traffic | Road traffic (AADT) within 600 m | 1415 | road segment | HPMS 2023/24 | annual | 2026-10-20 | FHWA HPMS via geo.dot.gov | public domain |
web | Web references | 938 | site | live | each fetch | 2026-10-15 | SearXNG meta-search | mixed |
overture | Places and buildings on the site | 831 | point / polygon | Overture 2025 release | monthly release | 2026-10-15 | Overture Maps | CDLA-Permissive 2.0 / ODbL |
pageviews | Wikipedia attention | 727 | article | last 12 months | each fetch | 2026-10-15 | Wikimedia REST | CC0 metrics |
env | EPA facilities and brownfields nearby | 722 | point, 1 km | live | each fetch | 2026-10-15 | EPA FRS / ECHO | public domain |
flood | FEMA flood zone | 722 | point | NFHL current | each fetch | 2026-10-15 | FEMA NFHL | public domain |
lihtc | Tax-credit housing nearby | 722 | point, 1.6 km | HUD LIHTC 2023 | annual | 2026-10-16 | HUD | public domain |
nrhp | National Register listings nearby | 722 | point | NRHP current | each fetch | 2026-10-15 | NPS | public domain |
oz | Opportunity Zone | 722 | tract | 2018 designation | static | 2026-10-15 | HUD | public domain |
nri | FEMA National Risk Index | 721 | county / tract | NRI 2023 | annual | 2026-10-16 | FEMA | public domain |
tract | Census tract profile: population, income, rent, vacancy | 721 | tract | ACS 2023 5-yr | annual | 2026-10-15 | US Census ACS API | public domain |
tract_change | Tract change 2013 to 2023 | 721 | tract | ACS 2013 and 2023 | annual | 2026-10-16 | US Census ACS API | public domain |
svi | CDC Social Vulnerability Index | 720 | tract | SVI 2022 | biennial | 2026-10-15 | CDC/ATSDR | public domain |
fifteen | Amenities within a 15-minute walk | 701 | point, 1.2 km | live OSM | each build | 2026-10-16 | OpenStreetMap via Overpass | ODbL |
edgar | CMBS trusts and public owners naming the mall | 586 | site (name + city text match) | filings 2001 to date | each fetch | 2026-10-20 | SEC EDGAR full-text search | public domain |
web_presence | Mall website liveness and archive | 561 | domain | live | each fetch | 2026-10-15 | site + Wayback CDX | mixed |
walk | EPA National Walkability Index | 558 | block group | 2021 | static | 2026-10-15 | EPA Smart Location Database | public domain |
hpi | House price index, tract | 520 | tract | FHFA 2025 | annual | 2026-10-20 | FHFA HPI | public domain |
transit | Rail stations within 800 m | 355 | point | live OSM | each build | 2026-10-15 | OpenStreetMap | ODbL |
sec | Mall facts from the filings: GLA, year built, occupancy, sales psf, anchors, owner share (REIT 10-K tables); loan balance, maturity, DSCR, appraisal, servicer status (ABS-EE Exhibit 102) | 172 | property (name + place match) | 10-Ks 2002 to 2026, ABS-EE latest month | each fetch | 2026-10-20 | SEC EDGAR filings | public domain |
yield | Tax yield per acre | 67 | parcel | assessor year | annual | county assessor | county terms |
Compared with CoStar
CoStar, Trepp and their peers are the reference for brokers (opinion: because their records are verified by research staff and licensed feeds; not checked here). The Atlas works from the public record and says where each number came from. The comparison, as far as a public-record database can judge it:
| Field | CoStar-class source | Retrofit Atlas today | Gap |
|---|---|---|---|
| Property record (size, year built, anchors) | complete; verified by phone and by brokers | acres or GLA on 502 of 1902 sites (26%), most with a source sentence, some from the Esri 2014 layer; unreviewed. From the owners' own 10-K property tables (Simon, Macerich, CBL, PREIT, Washington Prime, GGP, Glimcher, Rouse, Mills; 2002 to 2026): GLA on 158 malls, occupancy on 156, anchors on 151, year built on 87, in-line sales psf on 37, each with the filing URL and the table row | coverage and verification: theirs is complete and checked, ours is partial and unreviewed; the REIT figures are the filers' own and dated |
| Ownership | true owner, contacts, phone | owner of record from county parcels on 47 of the 48 sites with parcel data (individuals shown as name withheld; some are public bodies); an owner name, often historic, from Wikipedia text and Wikidata on 360; no phone numbers, no natural persons named or contacted | most sites have no confirmed current owner; contact details are left out by design |
| Sales comps | verified comps with cap rate, price psf | a priced sale row of any scope (parcel, portfolio, non-US included) on 161 sites; whole-mall sales that pass the capital page's filter are far fewer; no usable $/sq ft or $/acre yet; no cap rates | verification and cap rates |
| Debt | loan balance, maturity, lender, DSCR, special-servicer notes (Trepp-style) | CMBS trust link per mall from SEC EDGAR; loan amounts and status where reported in news; loan-level rows from the trusts' ABS-EE Exhibit 102 (Reg AB II, trusts issued since late 2016) on 22 malls: balance on 22, maturity on 22, DSCR on 19, appraised value on 22, payment status on 21, special-servicer transfer on 4 | loans securitised before 2017 and balance-sheet, insurance-company or agency loans never appear in ABS-EE; the pre-2017 trusts only confirm a link |
| Listings and asking prices | broker listings | listings found in news; a listing form for owners | live listing feed |
| Tenants and rent roll | tenant roster, lease expiries | former anchors and current places (Overture); no leases | leases (private) |
| Market analytics | submarket vacancy, rent, absorption | county and tract public series: ACS, CBP, Zillow, FHFA, BPS, HPMS, SVI | submarket retail vacancy and rents (private surveys) |
| Planning and policy | limited | rezoning, PUD, TIF/TAD or public purchase recorded on 273 sites, with the planning document where found | ours is filled on a minority of sites; where filled it carries the planning document |
| What became of it | not a field there, as far as we know | strategy, new use, year, share retrofitted, peers, challenges: the authors' taxonomy | the reason the database exists |
Debt and transactions: the public trail
- News watcher: Bing News RSS queries every six hours (mall sold, for sale, special servicing, foreclosure, auction, office park conversion); a model extracts kind, price, acres, loan amount, parties and the supporting sentence into the deal table; rows link to the site when the name and place match.
- Wikipedia text: ownership changes and sales in the article, extracted with the sentence; corporate mergers can look like sales.
- SEC EDGAR full-text search (
efts.sec.gov): one query per US mall, the quoted mall name plus its quoted city, over forms 10-K, 10-D, 8-K, 10-Q and ABS-EE (EDGAR full-text search covers 2001 to date). Filers are classified by their SEC industry code: 6189 (asset-backed securities) is a CMBS trust, 6798 and 65xx (REITs, real-estate operators and lessors) is a public owner, anything else (a retailer listing store locations, a bank) is “other” and stays out of the tables. Stored: filer, CIK, code, filing count in the sample (first 100 hits), first and last filing date, form mix, and the search link. A second query asks for the mall name immediately followed by its city, as a loan table prints them; filers found that way are marked “strong”. Limits: still a text match (a filing that names the mall and, elsewhere, the city, matches; a hotel or a tenant named after the mall matches too), a 100-hit sample per query so dates are “in sample”, no loan numbers yet. Excluded as common-name: malls returning over 200 hits, and records that share name and city with another record (a duplicate, not a usable query). - Next: ABS-EE Exhibit 102 XML carries loan-level balance, maturity, DSCR, occupancy and special-servicer transfer dates for every CMBS loan since 2016; county recorder deeds and mortgages for pre-CMBS and bank debt; REIT 10-K property tables for owned malls (GLA, occupancy, sales psf).
- SEC filings, read directly (
layers10.py): the property tables in mall REITs' annual reports (10-K Item 2; Simon, Macerich, CBL, PREIT, Washington Prime, GGP and Brookfield Property REIT, Glimcher, Rouse Properties, Mills, Tanger; several vintages each so sold and closed malls still appear) give GLA, year built or acquired, occupancy or leased share, in-line sales per sq ft, anchors and the owner's share; the CMBS trusts' monthly asset-level exhibit (Form ABS-EE, Exhibit 102 XML) gives the loan balance, maturity, rate, DSCR, appraised value, occupancy, largest tenants, payment status and any special-servicer transfer. Rows are matched to a site by name and state (exact name; or the name without its generic ending plus the same city; or that name alone when only one such site exists in the state), and every value is stored with the filing URL and the verbatim table row or XML fields (originsec-reit/sec-absee, unreviewed, sec_facts.csv). Limits: only REITs with tables EDGAR serves as HTML (2002 on); ABS-EE exists only for trusts issued after Reg AB II took effect in late 2016, so most pre-2017 loans show a trust link without numbers; a one-property loan shows the whole balance, a multi-property loan's balance covers all its properties and is marked so.
See also methods and limits, the codebook and downloads, and capital trends.