NYC Taxi Medallion Predatory Lending
Rubric
NYT: NYC Taxi Medallion Predatory Lending
Dataset given to agent: NYC Taxi & Limousine Commission medallion transaction records:
- PDF transfer records (36 monthly files, 2012–2014): Each PDF lists individual medallion transfers organized by medallion classification type (Independent Accessible/Alternative Fuel/Unrestricted, Corporate Accessible/Alternative Fuel/Unrestricted), split into Asset Sales vs. Stock Transfers, with transaction prices and notes (e.g., "Individual to LLC", "Estate", "2 Medallions").
- Excel price list files (48 monthly files, 2015–2018): Each .xlsx contains a table of medallion prices by classification type and transaction type (Asset Sales, Stock Transfers) with prices and notes.
Note: This dataset covers 2012–2018, capturing the peak and crash of the medallion bubble. It does not include bankruptcy records, loan terms, borrower financials, or multi-city data. The PDFs require text extraction; the Excel files are structured and directly parseable.
Lead A: Classic asset bubble and crash visible in monthly transaction prices
Tracking median/mean transaction prices by month and medallion type should show a dramatic run-up and collapse.
- Medallion values peaked above $1 million (pre-2014) and crashed — the dataset should show high six-figure to seven-figure prices in 2012–2013, followed by steep declines through 2018
- Between 2002 and 2014, prices rose from $200,000 to more than $1 million
- By the late dataset period (2017–2018), prices had fallen dramatically from peak levels
Lead B: Transaction volume patterns and market drying up
Counting transactions per month should reveal a liquid market during the bubble that seized up during the crash.
- About 4,000 drivers bought medallions during the bubble period (2002–2014)
Annotated Tipsheet
Tipsheet: The Collapse of New York City Taxi Medallion Values, 2012-2018
Source Material
- What was analyzed: 82 files from NYC Taxi & Limousine Commission (TLC) covering monthly medallion transfers from January 2012 through December 2018
- 36 PDF files (2012-2014): monthly medallion transfer charts
- 46 Excel files (2015-2018): monthly medallion price/sales lists
- Total transaction rows extracted: 1,805 (1,235 with prices > $0; 570 zero-dollar transfers)
- Analysis date: March 2026
- Coverage notes: All 82 source files were parsed. PDFs were extracted using pdfplumber; Excel files using openpyxl. Two slightly different tabular formats were handled across the time period. Data does not identify buyers, sellers, or medallion numbers — only prices, medallion classification, transaction type, and brief notes.
Summary of Findings
This dataset captures one of the most dramatic asset collapses in modern American urban history: NYC taxi medallions fell from a peak median price of $1,000,000 in mid-2013/mid-2014 to approximately $200,000 by mid-2018 — a roughly 80% decline. The data shows this wasn't just a price correction: by 2018, 78% of all priced transactions were foreclosures or bankruptcies, up from 0% in 2012-2013. The most striking signal is the emergence of massive batch liquidations in late 2018, with 65 medallions sold at the identical price of $340,000 in a single month (November 2018, all from bankruptcy) — suggesting the collapse of large fleet operators or lender-driven liquidation events that could be traced to specific entities.
Leads
Lead 1: Who Owned the 65 Medallions Liquidated at $340K in November 2018?
Signal strength: Strong
Evidence: In November 2018, 65 medallions were sold at exactly $340,000 each. 64 of the 65 were marked "Bankruptcy," one was "Foreclosure." This is by far the largest batch of identical-price sales in the entire dataset. Similarly, in January 2018, 23 medallions sold at exactly $372,000 each, all marked "Bankruptcy." Other notable batches include 10 medallions at $343,750 in October 2018 (all foreclosure) and 6 at $1,265,927.35 in September 2018 (stock transfers with oddly precise pricing suggesting court-ordered valuations).
Baseline: Typical months in 2012-2014 saw 15-30 total transactions across all types. A batch of 65 identical-price sales in a single month is unprecedented in this dataset.
Potential significance: These batch sales almost certainly represent the liquidation of large medallion portfolios held by fleet operators or lending institutions. The uniform pricing suggests court-ordered or negotiated bulk dispositions. The entities behind these sales — and the lenders who financed them — are identifiable through TLC records and bankruptcy court filings. These could connect to the well-documented medallion lending crisis, where lenders like Signature Bank, Sterling Bancorp, and Medallion Financial were accused of predatory lending practices that inflated medallion values before the crash.
Next steps:
- FOIL request to TLC for the buyer/seller names and medallion numbers behind November 2018 and January 2018 batch sales
- Search PACER for NYC-area bankruptcy cases involving taxi medallion portfolios in 2017-2018
- Cross-reference with FDIC enforcement actions and DOJ investigations into medallion lenders
This is an excellent investigative lead that goes beyond the rubric's general "prices crashed" finding to identify specific, actionable anomalies (identical-price batch sales suggesting coordinated liquidation events).
Lead 2: The Market Went from 0% to 78% Distressed Sales in Six Years
Signal strength: Strong
Evidence: The share of priced transactions that were foreclosures, bankruptcies, or estate sales rose dramatically:
| Year | Total Priced Sales | Foreclosures | Bankruptcies | All Distressed | Distressed % |
|---|---|---|---|---|---|
| 2012 | 192 | 0 | 0 | 1 | 1% |
| 2013 | 131 | 0 | 0 | 0 | 0% |
| 2014 | 109 | 5 | 0 | 5 | 5% |
| 2015 | 37 | 11 | 0 | 12 | 32% |
| 2016 | 47 | 26 | 0 | 29 | 62% |
| 2017 | 105 | 39 | 0 | 44 | 42% |
| 2018 | 614 | 381 | 92 | 479 | 78% |
Bankruptcies appear exclusively in 2018 (92 transactions), suggesting a wave of formal insolvency filings after years of declining values made refinancing impossible. The first foreclosure sales appear in September 2014 — notable because this aligns with the period when Uber was rapidly scaling in NYC.
Baseline: In 2012-2013, every single sale at a non-zero price was a voluntary market transaction. By 2018, fewer than 1 in 4 sales were voluntary.
Potential significance: This trajectory suggests systemic failure — not just individual borrowers defaulting but the entire medallion-backed lending ecosystem unwinding. The shift from purely foreclosures (2014-2017) to the addition of bankruptcies (2018) may indicate that medallion owners were initially trying to hold on, then gave up entirely.
Next steps:
- Determine the timing of key rideshare regulatory milestones (Uber NYC launch 2011, major scaling 2013-2014, cap removal) and overlay on this timeline
- Request from TLC the total number of active medallions per year to calculate what percentage of the total medallion supply changed hands through distressed sales
- Interview medallion lenders about their portfolio write-down timelines
A strong analytical finding that adds significant depth to the rubric's price-crash lead by quantifying the shift from voluntary to forced sales.
Lead 3: Transaction Volume Explosion in Late 2018 Suggests Coordinated Liquidation
Signal strength: Strong
Evidence: Monthly transaction volume was remarkably stable at 10-30 transactions per month from 2012 through mid-2018. Then it surged dramatically:
- July 2018: 47 transactions
- August 2018: 57
- September 2018: 61
- October 2018: 82
- November 2018: 111
- December 2018: 106
These volumes are 4-5x the normal range. The vast majority (90%+) of the late-2018 transactions are foreclosures or bankruptcies. In November 2018, 110 of 111 transactions were asset sales (vs. stock transfers), almost all forced.
Baseline: The average monthly transaction count from 2012-2017 was approximately 18.
Potential significance: This acceleration pattern is consistent with what happens when lenders give up on forbearance and begin mass liquidation — once one major lender starts selling, the resulting price drops force other lenders to mark down their portfolios and sell too. This "fire sale" dynamic may have accelerated the value destruction beyond what rideshare competition alone would have caused.
Next steps:
- Identify the specific lending institutions that held large medallion portfolios and when they began aggressive liquidation
- Check whether any regulatory actions or accounting rules changes in mid-2018 triggered the wave
- Examine whether any buyers were systematically purchasing at these distressed prices (bottom-fishing by hedge funds or new fleet operators)
This lead captures the volume dimension that the rubric asks for, though it identifies a volume explosion rather than a market "drying up.
Lead 4: Enormous Within-Month Price Spreads Suggest Vastly Different Seller Circumstances
Signal strength: Moderate
Evidence: In many months during 2018, the gap between the highest and lowest sale price for the same type of medallion (unrestricted, asset sale) was extraordinary:
- April 2018: low $5,000, high $700,000 (a 13,900% spread)
- May 2018: $100,000 to $800,000
- November 2018: $140,000 to $1,050,000
- July 2018: $145,000 to $1,000,000
Even excluding obvious outliers, the spread is remarkable. In the same month, some medallions sold for $160,000-$200,000 while others sold for $600,000-$1,000,000.
Baseline: In 2012, the typical within-month price range for independent unrestricted medallions was very tight — most sold within $700,000-$715,000.
Potential significance: The wide spreads raise the question: who was paying $700K-$1M for a medallion in months when identical medallions were selling at foreclosure for $200K? Possible explanations include: (a) the higher-priced sales include bundled assets or special terms not captured in the data; (b) some sales were between related parties at non-market prices for tax or legal purposes; (c) some buyers were uninformed or locked into pre-negotiated prices. Any of these explanations has story potential.
Next steps:
- FOIL the specific medallion numbers for the highest-priced 2018 sales and determine whether any were between related parties
- Check whether the high-priced sales carry notes like "2 Medallions" that might explain the premium
- Interview TLC officials about whether they flagged these valuation discrepancies
An original finding that goes beyond the rubric but is consistent with the broader story.
Lead 5: The Corporate Medallion Market Vanished After 2016
Signal strength: Moderate
Evidence: From 2012-2016, the data tracked separate categories for "Corporate" medallions (accessible, alternative fuel, unrestricted) and "Independent" medallions. Corporate unrestricted medallions traded at a significant premium — roughly 2.5-3x the independent price:
- 2012: Corporate median $2,050,000 (for 2 medallions) vs. Independent median $705,000
- 2013: Corporate median $2,400,000 vs. Independent median $925,000
- 2014: Corporate median $2,375,000 vs. Independent median $980,000
- 2015: Corporate median $1,750,000 vs. Independent median $715,000
- 2016: Corporate median $1,250,000 vs. Independent median $570,000
Starting in March 2017, the data format changed and the Independent/Corporate distinction was dropped. All medallions are listed simply as "Unrestricted," "Accessible," or "Alternative Fuel."
Baseline: The corporate medallion market was active throughout 2012-2016 with 9-30 priced transactions per year.
Potential significance: It's possible the format change simply reflects a TLC reporting decision. But it's also possible that by 2017, the corporate fleet model had largely collapsed and there were too few corporate transfers to warrant a separate category. The September 2016 data shows a cluster of 8 corporate medallion foreclosures at $1,250,000 each — possibly signaling a major fleet operator going under. Determining what happened to the corporate fleet segment is important context for the overall medallion story.
Next steps:
- Ask TLC whether the 2017 format change reflects a policy decision or the disappearance of corporate transfers
- Identify the fleet operator(s) behind the September 2016 batch of 8 foreclosures at $1,250,000
A useful contextual finding, though more of a data observation than an actionable investigative lead.
Lead 6: $0 Transfers Show Rapid LLC Restructuring During the Decline
Signal strength: Moderate
Evidence: 570 transactions in the dataset have a price of $0 — transfers where no money changed hands. The notes reveal the reasons:
- Estate transfers: 141 (deaths of medallion owners)
- Corporate/LLC restructuring: ~45 (marked "Individual to LLC," "Individual to Corp.," "FORMING CORP," "IND TO CORP")
- Family transfers: 19
- Percentage-based ownership changes: numerous entries noting "50%," "10%," etc.
Individual-to-LLC transfers (29 total) averaged near $0 in price but spiked during 2015 (9 transfers) compared to earlier years (4 per year).
Baseline: In a stable market, zero-dollar transfers are routine administrative events. The uptick in LLC conversions during the early decline years could indicate medallion owners trying to shield assets from personal liability as values dropped.
Potential significance: Converting a medallion from individual to LLC ownership can limit personal liability if the asset loses value and loans default. If these conversions accelerated as the crisis deepened, it could indicate that owners were strategically restructuring ahead of anticipated defaults — potentially at the advice of the same advisors/lenders who had helped inflate values.
Next steps:
- Cross-reference the timing of LLC conversions with subsequent foreclosures on the same medallion numbers (requires medallion-level data from TLC)
- Investigate whether specific attorneys or advisors facilitated clusters of these conversions
A minor but interesting observation. The sample size (29 LLC transfers) is too small to draw strong conclusions, and the tipsheet appropriately labels this as "Moderate" signal strength.
Lead 7: Specific Anomalous Price Points Suggest Court-Ordered or Structured Sales
Signal strength: Preliminary
Evidence: Several recurring oddly-precise prices appear in the data:
- $343,750 (10 sales in Oct 2018, all foreclosure) — possibly a standardized court valuation
- $1,265,927.35 (6 stock transfers in Sep 2018) — extremely precise, suggesting appraisal-based valuation
- $372,000 (23 sales in Jan 2018, all bankruptcy) — uniform pricing across unrestricted, accessible, and alternative fuel types, suggesting a blanket court-approved price
- $468,000 (6 sales in Jul 2017, all foreclosure) — another batch at an odd price point
The $372,000 batch is particularly notable because it includes all three medallion types at the same price — even though accessible and alternative fuel medallions typically traded at different prices than unrestricted ones. This suggests an entity-level liquidation where the court set one price regardless of medallion type.
Baseline: In the pre-crisis period, prices clustered at round numbers ($700K, $1M, $2M). Precise, odd-dollar amounts are characteristic of court-ordered or appraisal-based valuations.
Potential significance: Each of these price clusters likely traces back to a single bankruptcy case or foreclosure proceeding. The $372,000 batch (Jan 2018) and $340,000 batch (Nov 2018) probably represent two of the largest medallion portfolio collapses in NYC history.
Next steps:
- Search PACER for bankruptcy cases with these specific valuation amounts
- Request from TLC the entity names associated with these transactions
Additional Observations
- Missing months: No data exists for February-March 2016 and March 2016. It's unclear whether no transfers occurred or the records are missing.
- Estate transfers as mortality signal: 141 estate transfers over 7 years (about 20/year) may reflect the aging demographic of medallion owners. Some of these estates were likely inheriting an asset worth far less than the deceased paid for it.
- The $0 corporate transfers: Over 200 zero-dollar corporate transfers (2 medallions each) suggest routine intra-corporate ownership shuffling, but some could conceal value transfers.
- Alternative fuel medallion pricing: These medallions typically traded near or at unrestricted prices during the peak, but the category is very thinly traded (only a handful of sales per year until 2018).
- DOF Waiver notes: 6 transactions carry the note "DOF WAIVER" — likely Department of Finance transfer tax waivers, which could indicate government-facilitated transfers worth investigating.
Unexplored Territory
- Buyer identity: This data only shows prices and classifications, not who bought or sold. The most important investigative question — who was buying medallions at distressed prices in 2017-2018 — requires medallion-level data from TLC via FOIL.
- Lender identity: Which banks and credit unions financed the loans that went into foreclosure? This requires cross-referencing with UCC filings, banking records, and court documents.
- Uber/Lyft timeline overlay: How do the price inflection points in this data map to specific rideshare regulatory milestones in NYC?
- Suicide and financial distress: Multiple news reports documented taxi driver suicides during this period. Do any of the estate transfers in this data correspond to those deaths?
- Post-2018 recovery: This dataset ends in December 2018. Did prices stabilize, or continue to fall? The NYC Taxi Medallion Relief Program was enacted later — did it matter?
- Comparison to other cities: How does NYC's medallion collapse compare to Chicago, Boston, or Philadelphia?
A reasonable preliminary finding that overlaps substantially with Lead 1 (batch liquidations).
Transcript
Full Claude Code session transcript. Tool results and thinking blocks are collapsed by default.
User
I'm a journalist investigating New York taxi medallion transfers using the materials stored in datasets/nyc-medallions. I don't really know what I have. Could you help me look for newsworthy leads in this material?
Thinking...
The user wants me to investigate NYC taxi medallion data for newsworthy leads. Let me use the tipsheet-generator skill since this is exactly what it's designed for.
Skill
tipsheet-generator
Output
Launching skill: tipsheet-generatorThinking...
Let me start by reading the analysis playbook and then doing reconnaissance on the NYC medallions dataset.
Claude
I'll start by reading the analysis playbook and surveying the dataset in parallel.
Read
/Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/references/analysis-playbook.md
Error
File does not exist. Note: your current working directory is /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly.Bash
ls -la /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/Error
<tool_use_error>Cancelled: parallel tool call Read(/Users/nrh146/Documents/agentic-investig…) errored</tool_use_error>Glob
references/**/*
Output
No files foundBash
ls -laR /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/Output
total 2856
drwxr-xr-x@ 84 nrh146 staff 2688 Mar 6 13:18 .
drwxr-xr-x@ 11 nrh146 staff 352 Mar 6 13:19 ..
-rw-r--r--@ 1 nrh146 staff 12070 Mar 4 10:24 April 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12139 Mar 4 10:25 April 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10417 Mar 4 10:26 April 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11212 Mar 4 10:26 April 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11228 Mar 4 10:22 april_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10522 Mar 4 10:23 april_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9745 Mar 4 10:24 april_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12078 Mar 4 10:24 August 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12209 Mar 4 10:25 August 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11118 Mar 4 10:26 August 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11472 Mar 4 10:26 August 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11645 Mar 4 10:22 august_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9159 Mar 4 10:23 august_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10271 Mar 4 10:24 august_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12106 Mar 4 10:24 December 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12129 Mar 4 10:25 December 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 9956 Mar 4 10:26 December 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 13219 Mar 4 10:26 December 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12347 Mar 4 10:22 december_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9565 Mar 4 10:23 december_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10235 Mar 4 10:24 december_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12239 Mar 4 10:24 February 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12057 Mar 4 10:26 February 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11241 Mar 4 10:26 February 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 8613 Mar 4 10:22 february_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6764 Mar 4 10:23 february_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9135 Mar 4 10:23 february_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12169 Mar 4 10:24 January 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12027 Mar 4 10:24 January 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12035 Mar 4 10:26 January 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11299 Mar 4 10:26 January 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 9276 Mar 4 10:22 january_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9544 Mar 4 10:23 january_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6759 Mar 4 10:23 january_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12085 Mar 4 10:24 July 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12199 Mar 4 10:25 July 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11401 Mar 4 10:26 July 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11397 Mar 4 10:26 July 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 78072 Mar 4 10:22 july_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6746 Mar 4 10:23 july_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10839 Mar 4 10:24 july_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12097 Mar 4 10:24 June 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12235 Mar 4 10:25 June 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10693 Mar 4 10:26 June 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11894 Mar 4 10:26 June 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 9875 Mar 4 10:22 june_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 105788 Mar 4 10:23 june_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 102583 Mar 4 10:24 june_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12160 Mar 4 10:24 March 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10609 Mar 4 10:26 March 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11209 Mar 4 10:26 March 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 9500 Mar 4 10:22 march_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6733 Mar 4 10:23 march_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 11384 Mar 4 10:23 march_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12102 Mar 4 10:24 May 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12129 Mar 4 10:25 May 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10726 Mar 4 10:26 May 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11462 Mar 4 10:26 May 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12551 Mar 4 10:22 may_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9923 Mar 4 10:23 may_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 7047 Mar 4 10:24 may_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12167 Mar 4 10:24 November 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12069 Mar 4 10:25 November 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10764 Mar 4 10:26 November 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12595 Mar 4 10:26 November 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 9383 Mar 4 10:22 november_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6839 Mar 4 10:23 november_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10360 Mar 4 10:24 november_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12100 Mar 4 10:24 October 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12078 Mar 4 10:25 October 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10916 Mar 4 10:26 October 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12564 Mar 4 10:26 October 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 176459 Mar 4 10:22 october_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 10405 Mar 4 10:23 october_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 9392 Mar 4 10:24 october_2014_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 12103 Mar 4 10:24 September 2015_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 12173 Mar 4 10:25 September 2016_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 10683 Mar 4 10:26 September 2017_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 11822 Mar 4 10:26 September 2018_medallion_price_list.xlsx
-rw-r--r--@ 1 nrh146 staff 6706 Mar 4 10:22 september_2012_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 6789 Mar 4 10:23 september_2013_medallion_transfers.pdf
-rw-r--r--@ 1 nrh146 staff 53108 Mar 4 10:24 september_2014_medallion_transfers.pdfThinking...
I have 82 files: monthly PDFs from 2012-2014 (medallion transfers) and monthly Excel files from 2015-2018 (medallion price lists). Let me sample some of each to understand the structure.
Claude
I see 82 files spanning 2012–2018: monthly transfer PDFs (2012–2014) and monthly price list Excel files (2015–2018). Let me sample both formats to understand the data structure.
Read
/Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/january_2012_medallion_transfers.pdf
Read
/Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/june_2013_medallion_transfers.pdf
Output
PDF file read: /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/january_2012_medallion_transfers.pdf (9.1KB)Output
PDF file read: /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/june_2013_medallion_transfers.pdf (103.3KB)Read
/Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/october_2012_medallion_transfers.pdf
Output
PDF file read: /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/datasets/nyc-medallions/october_2012_medallion_transfers.pdf (172.3KB)Bash
python3 -c "
import openpyxl
wb = openpyxl.load_workbook('datasets/nyc-medallions/January 2015_medallion_price_list.xlsx')
for sheet in wb.sheetnames:
ws = wb[sheet]
print(f'Sheet: {sheet}, Rows: {ws.max_row}, Cols: {ws.max_column}')
for row in ws.iter_rows(min_row=1, max_row=min(20, ws.max_row), values_only=False):
print([cell.value for cell in row])
"
Output
Sheet: January 2015, Rows: 38, Cols: 5
['JANUARY 2015 MEDALLION SALES CHART', None, None, None, None]
[None, ' Asset Sales ', None, ' Stock Transfers ', None]
['Medallion Classification', 'Prices', 'Notes', 'Prices', 'Notes']
['Independent Accessible', None, None, 'N/A', None]
['Independent alternative fuel', 'N/A', None, 'N/A', None]
['Independent unrestricted', 800000, 'Foreclosure', 0, 'Family']
[None, 72500, 'Divorce Settlement', None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]
[None, None, None, None, None]Thinking...
Now I understand the data structure. Let me read more PDFs and Excel files to build a comprehensive picture. I need to extract data from all sources systematically. Let me write a Python script to parse everything and analyze it.
Claude
Good, now I understand the structure. Both PDFs and Excel files contain monthly medallion transfer/sale records with prices, classifications (Independent vs Corporate, unrestricted vs accessible vs alternative fuel), transaction types (Asset Sales vs Stock Transfers), and notes (Estate, Foreclosure, Family, etc.). Let me now systematically extract and analyze all the data.
Agent
{
"description": "Parse all PDFs for medallion data",
"prompt": "Read ALL the PDF files in datasets/nyc-medallions/ and extract the medallion transfer data from each one. The PDFs contain monthly medallion sales charts with columns: Medallion Classification, Asset Sale Prices, Asset Sale Notes, Stock Transfer Prices, Stock Transfer Notes.\n\nClassifications include: Independent accessible, Independent alternative fuel, Independent unrestricted, Corporate accessible, Corporate alternative fuel, Corporate unrestricted.\n\nRead every single PDF (there are 36 of them, covering Jan 2012 - Dec 2014) and for each one, record:\n1. The month/year\n2. Every transaction line with: classification, transaction_type (asset_sale or stock_transfer), price, notes\n\nWrite a Python script that outputs all extracted data as a CSV to outputs/medallion_pdf_data.csv. Make sure to create the outputs directory first. Use the Read tool to read each PDF and manually parse the text output.\n\nActually, a bet...Agent
{
"description": "Parse all Excel files for medallion data",
"prompt": "Parse ALL Excel files in datasets/nyc-medallions/ and extract medallion price/transfer data. There are 46 Excel files covering 2015-2018 (monthly medallion price lists).\n\nWrite a Python script (outputs/parse_excel.py) that:\n1. Creates the outputs directory if it doesn't exist\n2. Reads every .xlsx file in datasets/nyc-medallions/\n3. Extracts the month/year from the filename and sheet name\n4. Parses the table structure: Medallion Classification, Asset Sale Prices, Asset Sale Notes, Stock Transfer Prices, Stock Transfer Notes\n5. The structure is: header rows followed by data rows where classification is in column A, asset prices in column B, asset notes in column C, stock transfer prices in column D, stock transfer notes in column E\n6. Multiple price rows can fall under one classification - carry forward the classification\n7. Outputs all data as CSV to outputs/medallion_excel_data.csv\n\nUse openpyxl. Run...Output
[object Object],[object Object]Output
[object Object],[object Object]Thinking...
Good, both agents extracted the data. Now let me analyze the combined dataset to find leads. Let me write a comprehensive analysis script.
Claude
Both datasets extracted. Now let me combine and analyze them for leads.
Bash
head -5 outputs/medallion_pdf_data.csv && echo "---" && head -5 outputs/medallion_excel_data.csv && echo "---" && wc -l outputs/medallion_pdf_data.csv outputs/medallion_excel_data.csvOutput
month_year,year,month,classification,transaction_type,price,notes
January 2012,2012,1,Independent Accessible,asset_sale,N/A,
January 2012,2012,1,Independent Accessible,stock_transfer,N/A,
January 2012,2012,1,Independent Alternative Fuel,asset_sale,N/A,
January 2012,2012,1,Independent Alternative Fuel,stock_transfer,N/A,
---
month,year,sheet_name,medallion_classification,sale_type,price,notes,num_medallions
April,2015,April 2015,Independent Accessible,Stock Transfer,N/A,,
April,2015,April 2015,Independent alternative fuel,Asset Sale,N/A,,
April,2015,April 2015,Independent alternative fuel,Stock Transfer,N/A,,
April,2015,April 2015,Independent unrestricted,Asset Sale,0,Individual to LLC,
---
1017 outputs/medallion_pdf_data.csv
1289 outputs/medallion_excel_data.csv
2306 totalBash
cat > outputs/analyze_medallions.py << 'PYEOF'
import pandas as pd
import numpy as np
import re
import warnings
warnings.filterwarnings('ignore')
# Load both datasets
pdf_df = pd.read_csv('outputs/medallion_pdf_data.csv')
excel_df = pd.read_csv('outputs/medallion_excel_data.csv')
# Standardize PDF data
pdf_df['source'] = 'pdf'
pdf_df = pdf_df.rename(columns={'classification': 'medallion_classification', 'transaction_type': 'sale_type'})
pdf_df['sale_type'] = pdf_df['sale_type'].replace({'asset_sale': 'Asset Sale', 'stock_transfer': 'Stock Transfer'})
pdf_df['num_medallions'] = 1
# Extract num_medallions from notes for corporate
for idx, row in pdf_df.iterrows():
if pd.notna(row['notes']):
m = re.search(r'(\d+)\s*[Mm]edallion', str(row['notes']))
if m:
pdf_df.at[idx, 'num_medallions'] = int(m.group(1))
# Standardize Excel data
excel_df['source'] = 'excel'
excel_df['month_year'] = excel_df['month'] + ' ' + excel_df['year'].astype(str)
# Create month number mapping
month_map = {'January':1,'February':2,'March':3,'April':4,'May':5,'June':6,
'July':7,'August':8,'September':9,'October':10,'November':11,'December':12}
pdf_df['month_num'] = pdf_df['month'].astype(int)
excel_df['month_num'] = excel_df['month'].map(month_map)
excel_df['year'] = excel_df['year'].astype(int)
# Combine
cols = ['year', 'month_num', 'month_year', 'medallion_classification', 'sale_type', 'price', 'notes', 'num_medallions', 'source']
pdf_df['month_year_clean'] = pdf_df['month_year']
excel_df['month_year_clean'] = excel_df['month_year']
# Standardize classification names
def normalize_class(c):
c = str(c).strip().lower()
if 'independent' in c and 'access' in c: return 'Independent Accessible'
if 'independent' in c and 'alt' in c: return 'Independent Alternative Fuel'
if 'independent' in c and 'unrest' in c: return 'Independent Unrestricted'
if 'corporate' in c and 'access' in c: return 'Corporate Accessible'
if 'corporate' in c and 'alt' in c: return 'Corporate Alternative Fuel'
if 'corporate' in c and 'unrest' in c: return 'Corporate Unrestricted'
if 'wheelchair' in c or ('access' in c and 'independent' not in c and 'corporate' not in c): return 'Accessible'
if 'alt' in c and 'independent' not in c and 'corporate' not in c: return 'Alternative Fuel'
if 'unrest' in c and 'independent' not in c and 'corporate' not in c: return 'Unrestricted'
return c
pdf_df['class_norm'] = pdf_df['medallion_classification'].apply(normalize_class)
excel_df['class_norm'] = excel_df['medallion_classification'].apply(normalize_class)
# Convert price to numeric
def clean_price(p):
if pd.isna(p) or str(p).strip().upper() == 'N/A':
return np.nan
p = str(p).replace('$','').replace(',','').strip()
try:
return float(p)
except:
return np.nan
pdf_df['price_num'] = pdf_df['price'].apply(clean_price)
excel_df['price_num'] = excel_df['price'].apply(clean_price)
excel_df['num_medallions'] = pd.to_numeric(excel_df['num_medallions'], errors='coerce').fillna(1).astype(int)
# Create date column for sorting
pdf_df['date'] = pd.to_datetime(pdf_df['year'].astype(str) + '-' + pdf_df['month_num'].astype(str) + '-01')
excel_df['date'] = pd.to_datetime(excel_df['year'].astype(str) + '-' + excel_df['month_num'].astype(str) + '-01')
# Combine into one
all_cols = ['date', 'year', 'month_num', 'class_norm', 'sale_type', 'price_num', 'notes', 'num_medallions', 'source']
combined = pd.concat([pdf_df[all_cols], excel_df[all_cols]], ignore_index=True)
combined = combined.sort_values('date')
print("="*80)
print("MACRO ANALYSIS: NYC MEDALLION TRANSFERS 2012-2018")
print("="*80)
# Filter to actual transactions (non-N/A prices)
txns = combined[combined['price_num'].notna()].copy()
print(f"\nTotal transaction rows: {len(txns)}")
print(f"Date range: {txns['date'].min().strftime('%B %Y')} to {txns['date'].max().strftime('%B %Y')}")
# Exclude $0 transfers for price analysis (these are family/estate/LLC transfers)
market_txns = txns[txns['price_num'] > 0].copy()
print(f"Market transactions (price > $0): {len(market_txns)}")
zero_txns = txns[txns['price_num'] == 0]
print(f"Zero-dollar transfers: {len(zero_txns)}")
print("\n" + "="*80)
print("1. PRICE TRENDS OVER TIME (Independent Unrestricted - benchmark)")
print("="*80)
# Focus on Independent Unrestricted asset sales as the benchmark
ind_unr = market_txns[(market_txns['class_norm'] == 'Independent Unrestricted') &
(market_txns['sale_type'] == 'Asset Sale')]
# For 2017-2018, "Unrestricted" maps to what was previously independent
unr_all = market_txns[(market_txns['class_norm'].isin(['Independent Unrestricted', 'Unrestricted'])) &
(market_txns['sale_type'] == 'Asset Sale')]
by_quarter = unr_all.copy()
by_quarter['quarter'] = by_quarter['date'].dt.to_period('Q')
quarterly = by_quarter.groupby('quarter')['price_num'].agg(['median','mean','min','max','count'])
print("\nQuarterly median prices (Unrestricted Asset Sales):")
for q, row in quarterly.iterrows():
print(f" {q}: median=${row['median']:>12,.0f} mean=${row['mean']:>12,.0f} range=[${row['min']:>10,.0f} - ${row['max']:>10,.0f}] n={row['count']:.0f}")
print("\n" + "="*80)
print("2. ANNUAL SUMMARY - ALL TYPES")
print("="*80)
annual = market_txns.groupby(['year', 'class_norm', 'sale_type']).agg(
count=('price_num', 'count'),
median_price=('price_num', 'median'),
mean_price=('price_num', 'mean'),
max_price=('price_num', 'max'),
min_price=('price_num', 'min')
).reset_index()
for year in sorted(annual['year'].unique()):
yr_data = annual[annual['year'] == year]
print(f"\n--- {year} ---")
for _, row in yr_data.iterrows():
print(f" {row['class_norm']:>30} | {row['sale_type']:>15} | n={row['count']:>3} | median=${row['median_price']:>12,.0f} | max=${row['max_price']:>12,.0f}")
print("\n" + "="*80)
print("3. ZERO-DOLLAR TRANSFERS ANALYSIS")
print("="*80)
zero = txns[txns['price_num'] == 0].copy()
print(f"\nTotal $0 transfers: {len(zero)}")
print(f"\nBy year:")
print(zero.groupby('year').size().to_string())
print(f"\nBy classification:")
print(zero.groupby('class_norm').size().to_string())
print(f"\nBy sale type:")
print(zero.groupby('sale_type').size().to_string())
print(f"\nNotes on $0 transfers:")
print(zero['notes'].value_counts().head(20).to_string())
print("\n" + "="*80)
print("4. FORECLOSURE AND DISTRESSED SALES")
print("="*80)
distress_keywords = ['foreclos', 'bankrupt', 'divorce', 'estate', 'settlement', 'lien', 'judgment', 'seizure', 'distress', 'default']
def is_distressed(notes):
if pd.isna(notes): return False
return any(k in str(notes).lower() for k in distress_keywords)
txns['is_distressed'] = txns['notes'].apply(is_distressed)
distressed = txns[txns['is_distressed']]
print(f"\nDistressed transactions: {len(distressed)}")
print(f"\nBy year:")
print(distressed.groupby('year').size().to_string())
print(f"\nDistressed notes breakdown:")
print(distressed['notes'].value_counts().to_string())
print(f"\nDistressed prices (where price > 0):")
dist_priced = distressed[distressed['price_num'] > 0]
if len(dist_priced) > 0:
for _, row in dist_priced.iterrows():
print(f" {row['date'].strftime('%b %Y')} | {row['class_norm']} | ${row['price_num']:,.0f} | {row['notes']}")
print("\n" + "="*80)
print("5. CORPORATE VS INDEPENDENT PRICE GAP")
print("="*80)
for year in sorted(market_txns['year'].unique()):
yr = market_txns[(market_txns['year'] == year) & (market_txns['sale_type'] == 'Asset Sale')]
ind = yr[yr['class_norm'] == 'Independent Unrestricted']['price_num']
corp = yr[yr['class_norm'] == 'Corporate Unrestricted']['price_num']
if len(ind) > 0 and len(corp) > 0:
# Corporate prices are often for 2 medallions
corp_data = yr[yr['class_norm'] == 'Corporate Unrestricted']
print(f" {year}: Ind median=${ind.median():,.0f} (n={len(ind)}) | Corp median=${corp.median():,.0f} (n={len(corp)})")
print("\n" + "="*80)
print("6. VOLUME TRENDS")
print("="*80)
monthly_vol = txns.groupby(['date', 'sale_type']).size().unstack(fill_value=0)
print("\nMonthly transaction counts:")
for date in sorted(monthly_vol.index):
row = monthly_vol.loc[date]
total = row.sum()
parts = " | ".join([f"{col}: {val}" for col, val in row.items()])
print(f" {date.strftime('%b %Y'):>10}: total={total:>3} | {parts}")
print("\n" + "="*80)
print("7. UNUSUAL NOTES AND PATTERNS")
print("="*80)
print("\nAll unique notes:")
all_notes = txns['notes'].dropna().unique()
for n in sorted(set(str(x).strip() for x in all_notes if str(x).strip())):
count = txns[txns['notes'].apply(lambda x: str(x).strip() == n if pd.notna(x) else False)].shape[0]
print(f" '{n}': {count} occurrences")
print("\n" + "="*80)
print("8. INDIVIDUAL TO LLC TRANSFERS")
print("="*80)
llc = txns[txns['notes'].apply(lambda x: 'llc' in str(x).lower() if pd.notna(x) else False)]
print(f"\nIndividual-to-LLC transfers: {len(llc)}")
print(f"By year: {llc.groupby('year').size().to_string()}")
print(f"Prices: {llc['price_num'].describe().to_string()}")
print("\n" + "="*80)
print("9. PRICE COLLAPSE TIMELINE - peak to trough")
print("="*80)
# Track the max price per month for unrestricted
unr_monthly = unr_all.groupby('date')['price_num'].agg(['max','median','count'])
print("\nMonthly max price (Unrestricted Asset Sales):")
for date, row in unr_monthly.iterrows():
print(f" {date.strftime('%b %Y')}: max=${row['max']:>12,.0f} median=${row['median']:>10,.0f} (n={row['count']:.0f})")
print("\n" + "="*80)
print("10. ACCESSIBLE MEDALLION PRICES")
print("="*80)
acc = market_txns[market_txns['class_norm'].isin(['Independent Accessible', 'Corporate Accessible', 'Accessible', 'Wheelchair Accessible'])]
if len(acc) > 0:
print(f"\nAccessible medallion sales: {len(acc)}")
for _, row in acc.iterrows():
print(f" {row['date'].strftime('%b %Y')} | {row['class_norm']} | {row['sale_type']} | ${row['price_num']:,.0f} | {row['notes']}")
PYEOF
python3 outputs/analyze_medallions.py 2>&1Output
<persisted-output>
Output too large (56.5KB). Full output saved to: /Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/bf0h68l51.txt
Preview (first 2KB):
================================================================================
MACRO ANALYSIS: NYC MEDALLION TRANSFERS 2012-2018
================================================================================
Total transaction rows: 1805
Date range: January 2012 to December 2018
Market transactions (price > $0): 1235
Zero-dollar transfers: 570
================================================================================
1. PRICE TRENDS OVER TIME (Independent Unrestricted - benchmark)
================================================================================
Quarterly median prices (Unrestricted Asset Sales):
2012Q1: median=$ 700,000 mean=$ 655,738 range=[$ 350,000 - $ 715,000] n=25
2012Q2: median=$ 700,000 mean=$ 639,789 range=[$ 60,000 - $ 712,000] n=38
2012Q3: median=$ 705,500 mean=$ 603,633 range=[$ 58,624 - $ 750,000] n=36
2012Q4: median=$ 780,000 mean=$ 756,800 range=[$ 360,000 - $ 850,000] n=15
2013Q1: median=$ 835,000 mean=$ 662,187 range=[$ 8,000 - $ 950,000] n=20
2013Q2: median=$ 1,000,000 mean=$ 874,943 range=[$ 33,900 - $ 1,100,000] n=26
2013Q3: median=$ 1,000,000 mean=$ 832,846 range=[$ 305,000 - $ 1,050,000] n=13
2013Q4: median=$ 925,000 mean=$ 878,125 range=[$ 498,750 - $ 1,000,000] n=14
2014Q1: median=$ 985,000 mean=$ 985,000 range=[$ 920,000 - $ 1,050,000] n=25
2014Q2: median=$ 1,000,000 mean=$ 871,280 range=[$ 80,837 - $ 1,050,000] n=24
2014Q3: median=$ 940,000 mean=$ 911,818 range=[$ 500,000 - $ 1,025,000] n=11
2014Q4: median=$ 835,000 mean=$ 792,740 range=[$ 389,658 - $ 905,000] n=9
2015Q1: median=$ 600,000 mean=$ 495,988 range=[$ 72,500 - $ 800,000] n=6
2015Q2: median=$ 757,500 mean=$ 744,833 range=[$ 700,000 - $ 777,000] n=3
...
</persisted-output>Read
/Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/bf0h68l51.txt
Output
<persisted-output>
Output too large (64.3KB). Full output saved to: /Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/toolu_01Qj6vsY7kFy1moHLbwy3Q56.txt
Preview (first 2KB):
1→================================================================================
2→MACRO ANALYSIS: NYC MEDALLION TRANSFERS 2012-2018
3→================================================================================
4→
5→Total transaction rows: 1805
6→Date range: January 2012 to December 2018
7→Market transactions (price > $0): 1235
8→Zero-dollar transfers: 570
9→
10→================================================================================
11→1. PRICE TRENDS OVER TIME (Independent Unrestricted - benchmark)
12→================================================================================
13→
14→Quarterly median prices (Unrestricted Asset Sales):
15→ 2012Q1: median=$ 700,000 mean=$ 655,738 range=[$ 350,000 - $ 715,000] n=25
16→ 2012Q2: median=$ 700,000 mean=$ 639,789 range=[$ 60,000 - $ 712,000] n=38
17→ 2012Q3: median=$ 705,500 mean=$ 603,633 range=[$ 58,624 - $ 750,000] n=36
18→ 2012Q4: median=$ 780,000 mean=$ 756,800 range=[$ 360,000 - $ 850,000] n=15
19→ 2013Q1: median=$ 835,000 mean=$ 662,187 range=[$ 8,000 - $ 950,000] n=20
20→ 2013Q2: median=$ 1,000,000 mean=$ 874,943 range=[$ 33,900 - $ 1,100,000] n=26
21→ 2013Q3: median=$ 1,000,000 mean=$ 832,846 range=[$ 305,000 - $ 1,050,000] n=13
22→ 2013Q4: median=$ 925,000 mean=$ 878,125 range=[$ 498,750 - $ 1,000,000] n=14
23→ 2014Q1: median=$ 985,000 mean=$ 985,000 range=[$ 920,000 - $ 1,050,000] n=25
24→ 2014Q2: median=$ 1,000,000 mean=$ 871,280 range=[$ 80,837 - $ 1,050,000] n=24
25→ 2014Q3: median=$ 940,000 mean=$ 911,818 range=[$ 500,000 - $ 1,025,000] n=11
26→ 2014Q4: median=$ 835,000 mean=$ 792,740 range=[$ 389,658 - $ 905,000] n=9
...
</persisted-output>Read
/Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/toolu_01Qj6vsY7kFy1moHLbwy3Q56.txt
Output
1→ 1→================================================================================
2→ 2→MACRO ANALYSIS: NYC MEDALLION TRANSFERS 2012-2018
3→ 3→================================================================================
4→ 4→
5→ 5→Total transaction rows: 1805
6→ 6→Date range: January 2012 to December 2018
7→ 7→Market transactions (price > $0): 1235
8→ 8→Zero-dollar transfers: 570
9→ 9→
10→ 10→================================================================================
11→ 11→1. PRICE TRENDS OVER TIME (Independent Unrestricted - benchmark)
12→ 12→================================================================================
13→ 13→
14→ 14→Quarterly median prices (Unrestricted Asset Sales):
15→ 15→ 2012Q1: median=$ 700,000 mean=$ 655,738 range=[$ 350,000 - $ 715,000] n=25
16→ 16→ 2012Q2: median=$ 700,000 mean=$ 639,789 range=[$ 60,000 - $ 712,000] n=38
17→ 17→ 2012Q3: median=$ 705,500 mean=$ 603,633 range=[$ 58,624 - $ 750,000] n=36
18→ 18→ 2012Q4: median=$ 780,000 mean=$ 756,800 range=[$ 360,000 - $ 850,000] n=15
19→ 19→ 2013Q1: median=$ 835,000 mean=$ 662,187 range=[$ 8,000 - $ 950,000] n=20
20→ 20→ 2013Q2: median=$ 1,000,000 mean=$ 874,943 range=[$ 33,900 - $ 1,100,000] n=26
21→ 21→ 2013Q3: median=$ 1,000,000 mean=$ 832,846 range=[$ 305,000 - $ 1,050,000] n=13
22→ 22→ 2013Q4: median=$ 925,000 mean=$ 878,125 range=[$ 498,750 - $ 1,000,000] n=14
23→ 23→ 2014Q1: median=$ 985,000 mean=$ 985,000 range=[$ 920,000 - $ 1,050,000] n=25
24→ 24→ 2014Q2: median=$ 1,000,000 mean=$ 871,280 range=[$ 80,837 - $ 1,050,000] n=24
25→ 25→ 2014Q3: median=$ 940,000 mean=$ 911,818 range=[$ 500,000 - $ 1,025,000] n=11
26→ 26→ 2014Q4: median=$ 835,000 mean=$ 792,740 range=[$ 389,658 - $ 905,000] n=9
27→ 27→ 2015Q1: median=$ 600,000 mean=$ 495,988 range=[$ 72,500 - $ 800,000] n=6
28→ 28→ 2015Q2: median=$ 757,500 mean=$ 744,833 range=[$ 700,000 - $ 777,000] n=3
29→ 29→ 2015Q3: median=$ 715,000 mean=$ 633,770 range=[$ 248,393 - $ 725,000] n=7
30→ 30→ 2015Q4: median=$ 675,000 mean=$ 556,109 range=[$ 325,545 - $ 725,000] n=5
31→ 31→ 2016Q2: median=$ 565,000 mean=$ 537,292 range=[$ 325,000 - $ 615,000] n=12
32→ 32→ 2016Q3: median=$ 598,000 mean=$ 561,143 range=[$ 350,000 - $ 620,000] n=7
33→ 33→ 2016Q4: median=$ 525,000 mean=$ 519,620 range=[$ 387,718 - $ 600,000] n=6
34→ 34→ 2017Q1: median=$ 400,000 mean=$ 397,000 range=[$ 241,000 - $ 550,000] n=3
35→ 35→ 2017Q2: median=$ 275,000 mean=$ 347,735 range=[$ 150,000 - $ 750,000] n=17
36→ 36→ 2017Q3: median=$ 400,000 mean=$ 415,055 range=[$ 130,000 - $ 900,000] n=23
37→ 37→ 2017Q4: median=$ 350,000 mean=$ 470,976 range=[$ 150,000 - $ 1,350,000] n=37
38→ 38→ 2018Q1: median=$ 372,000 mean=$ 357,490 range=[$ 120,000 - $ 750,000] n=64
39→ 39→ 2018Q2: median=$ 200,000 mean=$ 282,153 range=[$ 5,000 - $ 800,000] n=82
40→ 40→ 2018Q3: median=$ 225,000 mean=$ 255,431 range=[$ 107,991 - $ 1,000,000] n=112
41→ 41→ 2018Q4: median=$ 315,000 mean=$ 317,754 range=[$ 135,000 - $ 1,050,000] n=234
42→ 42→
43→ 43→================================================================================
44→ 44→2. ANNUAL SUMMARY - ALL TYPES
45→ 45→================================================================================
46→ 46→
47→ 47→--- 2012 ---
48→ 48→ Corporate Unrestricted | Asset Sale | n= 29 | median=$ 2,050,000 | max=$ 3,000,000
49→ 49→ Corporate Unrestricted | Stock Transfer | n= 30 | median=$ 1,600,000 | max=$ 3,425,000
50→ 50→ Independent Accessible | Asset Sale | n= 9 | median=$ 650,000 | max=$ 670,000
51→ 51→ Independent Unrestricted | Asset Sale | n=114 | median=$ 705,000 | max=$ 850,000
52→ 52→ Independent Unrestricted | Stock Transfer | n= 10 | median=$ 199,625 | max=$ 355,000
53→ 53→
54→ 54→--- 2013 ---
55→ 55→ Corporate Alternative Fuel | Asset Sale | n= 1 | median=$ 2,200,000 | max=$ 2,200,000
56→ 56→ Corporate Unrestricted | Asset Sale | n= 9 | median=$ 2,400,000 | max=$ 3,600,000
57→ 57→ Corporate Unrestricted | Stock Transfer | n= 24 | median=$ 1,600,000 | max=$ 3,200,000
58→ 58→ Independent Alternative Fuel | Asset Sale | n= 1 | median=$ 1,050,000 | max=$ 1,050,000
59→ 59→ Independent Alternative Fuel | Stock Transfer | n= 1 | median=$ 272,600 | max=$ 272,600
60→ 60→ Independent Unrestricted | Asset Sale | n= 73 | median=$ 925,000 | max=$ 1,100,000
61→ 61→ Independent Unrestricted | Stock Transfer | n= 22 | median=$ 281,000 | max=$ 1,000,000
62→ 62→
63→ 63→--- 2014 ---
64→ 64→ Corporate Unrestricted | Asset Sale | n= 18 | median=$ 2,375,000 | max=$ 3,900,000
65→ 65→ Corporate Unrestricted | Stock Transfer | n= 2 | median=$ 750,000 | max=$ 1,000,000
66→ 66→ Independent Accessible | Asset Sale | n= 2 | median=$ 642,419 | max=$ 875,000
67→ 67→ Independent Alternative Fuel | Asset Sale | n= 1 | median=$ 520,000 | max=$ 520,000
68→ 68→ Independent Unrestricted | Asset Sale | n= 69 | median=$ 980,000 | max=$ 1,050,000
69→ 69→ Independent Unrestricted | Stock Transfer | n= 17 | median=$ 383,572 | max=$ 500,000
70→ 70→
71→ 71→--- 2015 ---
72→ 72→ Corporate Unrestricted | Asset Sale | n= 9 | median=$ 1,750,000 | max=$ 1,900,000
73→ 73→ Corporate Unrestricted | Stock Transfer | n= 2 | median=$ 600,000 | max=$ 600,000
74→ 74→ Independent Accessible | Asset Sale | n= 1 | median=$ 740,000 | max=$ 740,000
75→ 75→ Independent Accessible | Stock Transfer | n= 1 | median=$ 15,000 | max=$ 15,000
76→ 76→ Independent Unrestricted | Asset Sale | n= 21 | median=$ 715,000 | max=$ 800,000
77→ 77→ Independent Unrestricted | Stock Transfer | n= 3 | median=$ 340,000 | max=$ 386,126
78→ 78→
79→ 79→--- 2016 ---
80→ 80→ Corporate Alternative Fuel | Asset Sale | n= 3 | median=$ 1,250,000 | max=$ 1,250,000
81→ 81→ Corporate Alternative Fuel | Stock Transfer | n= 1 | median=$ 600,000 | max=$ 600,000
82→ 82→ Corporate Unrestricted | Asset Sale | n= 12 | median=$ 1,250,000 | max=$ 1,500,000
83→ 83→ Corporate Unrestricted | Stock Transfer | n= 4 | median=$ 622,500 | max=$ 1,322,542
84→ 84→ Independent Alternative Fuel | Stock Transfer | n= 1 | median=$ 69,966 | max=$ 69,966
85→ 85→ Independent Unrestricted | Asset Sale | n= 25 | median=$ 570,000 | max=$ 620,000
86→ 86→ Independent Unrestricted | Stock Transfer | n= 1 | median=$ 61,590 | max=$ 61,590
87→ 87→
88→ 88→--- 2017 ---
89→ 89→ Accessible | Asset Sale | n= 4 | median=$ 384,000 | max=$ 1,320,000
90→ 90→ Alternative Fuel | Asset Sale | n= 6 | median=$ 400,000 | max=$ 1,320,000
91→ 91→ Independent Unrestricted | Asset Sale | n= 2 | median=$ 475,000 | max=$ 550,000
92→ 92→ Unrestricted | Asset Sale | n= 78 | median=$ 355,500 | max=$ 1,350,000
93→ 93→ Unrestricted | Stock Transfer | n= 15 | median=$ 339,503 | max=$ 1,393,434
94→ 94→
95→ 95→--- 2018 ---
96→ 96→ Accessible | Asset Sale | n= 61 | median=$ 340,000 | max=$ 750,000
97→ 97→ Alternative Fuel | Asset Sale | n= 17 | median=$ 340,000 | max=$ 372,000
98→ 98→ Unrestricted | Asset Sale | n=492 | median=$ 250,000 | max=$ 1,050,000
99→ 99→ Unrestricted | Stock Transfer | n= 44 | median=$ 363,741 | max=$ 1,265,927
100→ 100→
101→ 101→================================================================================
102→ 102→3. ZERO-DOLLAR TRANSFERS ANALYSIS
103→ 103→================================================================================
104→ 104→
105→ 105→Total $0 transfers: 570
106→ 106→
107→ 107→By year:
108→ 108→year
109→ 109→2012 131
110→ 110→2013 115
111→ 111→2014 94
112→ 112→2015 63
113→ 113→2016 58
114→ 114→2017 48
115→ 115→2018 61
116→ 116→
117→ 117→By classification:
118→ 118→class_norm
119→ 119→Corporate Alternative Fuel 2
120→ 120→Corporate Unrestricted 210
121→ 121→Independent Unrestricted 257
122→ 122→Unrestricted 101
123→ 123→
124→ 124→By sale type:
125→ 125→sale_type
126→ 126→Asset Sale 276
127→ 127→Stock Transfer 294
128→ 128→
129→ 129→Notes on $0 transfers:
130→ 130→notes
131→ 131→Estate 103
132→ 132→2 Medallions 82
133→ 133→2 medallions 57
134→ 134→1 42
135→ 135→Individual to LLC 28
136→ 136→ESTATE 21
137→ 137→Family 16
138→ 138→100% ESTATE 2 MEDALLIONS 14
139→ 139→0.5 10
140→ 140→Individual to Corp. 10
141→ 141→2 medallions, 50 % 7
142→ 142→2 MEDALLIONS 6
143→ 143→2 medallions 49% 6
144→ 144→3 Medallions 6
145→ 145→0.1 5
146→ 146→3 medallions 5
147→ 147→0.11 5
148→ 148→FORMING CORP 4
149→ 149→IND TO CORP 4
150→ 150→2 medallions, 50% 3
151→ 151→
152→ 152→================================================================================
153→ 153→4. FORECLOSURE AND DISTRESSED SALES
154→ 154→================================================================================
155→ 155→
156→ 156→Distressed transactions: 710
157→ 157→
158→ 158→By year:
159→ 159→year
160→ 160→2012 5
161→ 161→2013 1
162→ 162→2014 52
163→ 163→2015 40
164→ 164→2016 53
165→ 165→2017 62
166→ 166→2018 497
167→ 167→
168→ 168→Distressed notes breakdown:
169→ 169→notes
170→ 170→Foreclosure 456
171→ 171→Estate 116
172→ 172→Bankruptcy 92
173→ 173→ESTATE 21
174→ 174→100% ESTATE 2 MEDALLIONS 14
175→ 175→FORECLOSURE 4
176→ 176→100% ESTATE 3 MEDALLIONS 1
177→ 177→Divorce Settlement 1
178→ 178→50% Foreclosure 1
179→ 179→50% Estate 1
180→ 180→100% Foreclosure 1
181→ 181→25% Estate, 25% Sale 1
182→ 182→100% Estate 1
183→ 183→
184→ 184→Distressed prices (where price > 0):
185→ 185→ Oct 2012 | Independent Unrestricted | $730,000 | Estate
186→ 186→ Sep 2014 | Independent Unrestricted | $900,000 | FORECLOSURE
187→ 187→ Oct 2014 | Corporate Unrestricted | $1,925,000 | FORECLOSURE
188→ 188→ Oct 2014 | Independent Unrestricted | $875,000 | FORECLOSURE
189→ 189→ Oct 2014 | Independent Unrestricted | $905,000 | FORECLOSURE
190→ 190→ Nov 2014 | Independent Unrestricted | $840,000 | Foreclosure
191→ 191→ Jan 2015 | Independent Unrestricted | $72,500 | Divorce Settlement
192→ 192→ Jan 2015 | Independent Unrestricted | $800,000 | Foreclosure
193→ 193→ May 2015 | Independent Unrestricted | $700,000 | Foreclosure
194→ 194→ Jun 2015 | Independent Accessible | $740,000 | Foreclosure
195→ 195→ Jun 2015 | Independent Unrestricted | $777,000 | Foreclosure
196→ 196→ Jun 2015 | Independent Unrestricted | $757,500 | Foreclosure
197→ 197→ Jul 2015 | Independent Unrestricted | $603,000 | Foreclosure
198→ 198→ Aug 2015 | Independent Unrestricted | $715,000 | Foreclosure
199→ 199→ Aug 2015 | Independent Unrestricted | $725,000 | Foreclosure
200→ 200→ Nov 2015 | Independent Unrestricted | $325,545 | Foreclosure
201→ 201→ Dec 2015 | Independent Unrestricted | $725,000 | Foreclosure
202→ 202→ Dec 2015 | Independent Unrestricted | $705,000 | Foreclosure
203→ 203→ Apr 2016 | Independent Unrestricted | $615,000 | Foreclosure
204→ 204→ May 2016 | Independent Unrestricted | $540,000 | Foreclosure
205→ 205→ May 2016 | Independent Unrestricted | $560,000 | Foreclosure
206→ 206→ Jun 2016 | Independent Unrestricted | $525,000 | Estate
207→ 207→ Jun 2016 | Independent Unrestricted | $610,000 | Foreclosure
208→ 208→ Jun 2016 | Independent Unrestricted | $550,000 | Foreclosure
209→ 209→ Jun 2016 | Independent Unrestricted | $570,000 | Foreclosure
210→ 210→ Jun 2016 | Independent Unrestricted | $572,500 | Foreclosure
211→ 211→ Jul 2016 | Independent Unrestricted | $620,000 | Foreclosure
212→ 212→ Jul 2016 | Independent Unrestricted | $550,000 | Foreclosure
213→ 213→ Jul 2016 | Independent Unrestricted | $620,000 | Foreclosure
214→ 214→ Aug 2016 | Independent Unrestricted | $620,000 | Foreclosure
215→ 215→ Aug 2016 | Independent Unrestricted | $598,000 | Foreclosure
216→ 216→ Aug 2016 | Corporate Unrestricted | $1,500,000 | Foreclosure
217→ 217→ Aug 2016 | Corporate Unrestricted | $1,500,000 | Foreclosure
218→ 218→ Aug 2016 | Corporate Unrestricted | $1,500,000 | Foreclosure
219→ 219→ Sep 2016 | Corporate Unrestricted | $1,250,000 | Foreclosure
220→ 220→ Sep 2016 | Corporate Alternative Fuel | $1,250,000 | Foreclosure
221→ 221→ Sep 2016 | Corporate Unrestricted | $1,250,000 | Foreclosure
222→ 222→ Sep 2016 | Corporate Unrestricted | $1,250,000 | Foreclosure
223→ 223→ Sep 2016 | Corporate Unrestricted | $1,250,000 | Foreclosure
224→ 224→ Sep 2016 | Corporate Unrestricted | $1,250,000 | Foreclosure
225→ 225→ Sep 2016 | Corporate Alternative Fuel | $1,250,000 | Foreclosure
226→ 226→ Sep 2016 | Corporate Alternative Fuel | $1,250,000 | Foreclosure
227→ 227→ Oct 2016 | Independent Unrestricted | $600,000 | Foreclosure
228→ 228→ Nov 2016 | Independent Unrestricted | $500,000 | Estate
229→ 229→ Dec 2016 | Independent Unrestricted | $480,000 | Estate
230→ 230→ Dec 2016 | Independent Unrestricted | $600,000 | Foreclosure
231→ 231→ Dec 2016 | Independent Unrestricted | $550,000 | Foreclosure
232→ 232→ Feb 2017 | Independent Unrestricted | $400,000 | Estate
233→ 233→ Feb 2017 | Independent Unrestricted | $550,000 | Foreclosure
234→ 234→ Apr 2017 | Alternative Fuel | $425,000 | Foreclosure
235→ 235→ May 2017 | Unrestricted | $500,000 | Foreclosure
236→ 236→ May 2017 | Unrestricted | $750,000 | Foreclosure
237→ 237→ May 2017 | Unrestricted | $737,591 | 50% Foreclosure
238→ 238→ May 2017 | Unrestricted | $235,000 | Estate
239→ 239→ May 2017 | Unrestricted | $750,000 | Foreclosure
240→ 240→ Jun 2017 | Unrestricted | $475,000 | Foreclosure
241→ 241→ Jun 2017 | Unrestricted | $220,000 | Foreclosure
242→ 242→ Jun 2017 | Unrestricted | $220,000 | Foreclosure
243→ 243→ Jun 2017 | Unrestricted | $219,500 | Foreclosure
244→ 244→ Jul 2017 | Accessible | $468,000 | Foreclosure
245→ 245→ Jul 2017 | Unrestricted | $580,521 | Foreclosure
246→ 246→ Jul 2017 | Unrestricted | $468,000 | Foreclosure
247→ 247→ Jul 2017 | Unrestricted | $468,000 | Foreclosure
248→ 248→ Jul 2017 | Unrestricted | $468,000 | Foreclosure
249→ 249→ Jul 2017 | Unrestricted | $468,000 | Foreclosure
250→ 250→ Jul 2017 | Unrestricted | $400,000 | Foreclosure
251→ 251→ Jul 2017 | Unrestricted | $468,000 | Foreclosure
252→ 252→ Aug 2017 | Unrestricted | $400,000 | Foreclosure
253→ 253→ Aug 2017 | Unrestricted | $400,000 | Foreclosure
254→ 254→ Aug 2017 | Unrestricted | $400,000 | Foreclosure
255→ 255→ Aug 2017 | Unrestricted | $400,000 | Foreclosure
256→ 256→ Aug 2017 | Unrestricted | $800,000 | Foreclosure
257→ 257→ Aug 2017 | Alternative Fuel | $400,000 | Foreclosure
258→ 258→ Aug 2017 | Alternative Fuel | $400,000 | Foreclosure
259→ 259→ Aug 2017 | Unrestricted | $900,000 | Foreclosure
260→ 260→ Aug 2017 | Unrestricted | $800,000 | Foreclosure
261→ 261→ Sep 2017 | Unrestricted | $400,000 | Foreclosure
262→ 262→ Sep 2017 | Unrestricted | $403,202 | 100% Foreclosure
263→ 263→ Sep 2017 | Alternative Fuel | $185,000 | Foreclosure
264→ 264→ Oct 2017 | Unrestricted | $1,350,000 | Foreclosure
265→ 265→ Oct 2017 | Unrestricted | $200,000 | Foreclosure
266→ 266→ Oct 2017 | Unrestricted | $200,000 | Foreclosure
267→ 267→ Oct 2017 | Unrestricted | $200,000 | Foreclosure
268→ 268→ Nov 2017 | Unrestricted | $150,000 | Estate
269→ 269→ Nov 2017 | Unrestricted | $750,000 | Foreclosure
270→ 270→ Nov 2017 | Unrestricted | $750,000 | Foreclosure
271→ 271→ Nov 2017 | Unrestricted | $100,000 | 25% Estate, 25% Sale
272→ 272→ Dec 2017 | Alternative Fuel | $210,000 | Foreclosure
273→ 273→ Dec 2017 | Unrestricted | $400,000 | Foreclosure
274→ 274→ Dec 2017 | Unrestricted | $750,000 | Foreclosure
275→ 275→ Dec 2017 | Unrestricted | $160,000 | Estate
276→ 276→ Jan 2018 | Alternative Fuel | $372,000 | Bankruptcy
277→ 277→ Jan 2018 | Alternative Fuel | $372,000 | Bankruptcy
278→ 278→ Jan 2018 | Unrestricted | $170,000 | Foreclosure
279→ 279→ Jan 2018 | Unrestricted | $170,000 | Estate
280→ 280→ Jan 2018 | Unrestricted | $176,000 | Estate
281→ 281→ Jan 2018 | Unrestricted | $245,000 | Estate
282→ 282→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
283→ 283→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
284→ 284→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
285→ 285→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
286→ 286→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
287→ 287→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
288→ 288→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
289→ 289→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
290→ 290→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
291→ 291→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
292→ 292→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
293→ 293→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
294→ 294→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
295→ 295→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
296→ 296→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
297→ 297→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
298→ 298→ Jan 2018 | Unrestricted | $372,000 | Bankruptcy
299→ 299→ Jan 2018 | Unrestricted | $120,000 | Foreclosure
300→ 300→ Jan 2018 | Alternative Fuel | $372,000 | Bankruptcy
... (100 more lines truncated)Read
/Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/toolu_01Qj6vsY7kFy1moHLbwy3Q56.txt
Output
400→ 400→ Jul 2018 | Unrestricted | $160,000 | Foreclosure
401→ 401→ Jul 2018 | Unrestricted | $360,000 | Foreclosure
402→ 402→ Jul 2018 | Unrestricted | $225,000 | Foreclosure
403→ 403→ Jul 2018 | Unrestricted | $225,000 | Foreclosure
404→ 404→ Jul 2018 | Unrestricted | $320,000 | Foreclosure
405→ 405→ Jul 2018 | Unrestricted | $250,000 | Foreclosure
406→ 406→ Jul 2018 | Unrestricted | $250,000 | Foreclosure
407→ 407→ Jul 2018 | Unrestricted | $250,000 | Foreclosure
408→ 408→ Jul 2018 | Unrestricted | $310,000 | Foreclosure
409→ 409→ Jul 2018 | Unrestricted | $260,000 | Foreclosure
410→ 410→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
411→ 411→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
412→ 412→ Aug 2018 | Unrestricted | $330,000 | Foreclosure
413→ 413→ Aug 2018 | Unrestricted | $325,000 | Foreclosure
414→ 414→ Aug 2018 | Unrestricted | $310,000 | Foreclosure
415→ 415→ Aug 2018 | Unrestricted | $260,000 | Foreclosure
416→ 416→ Aug 2018 | Unrestricted | $260,000 | Foreclosure
417→ 417→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
418→ 418→ Aug 2018 | Unrestricted | $275,000 | Foreclosure
419→ 419→ Aug 2018 | Accessible | $225,000 | Foreclosure
420→ 420→ Aug 2018 | Accessible | $225,000 | Foreclosure
421→ 421→ Aug 2018 | Accessible | $225,000 | Foreclosure
422→ 422→ Aug 2018 | Accessible | $225,000 | Foreclosure
423→ 423→ Aug 2018 | Accessible | $225,000 | Foreclosure
424→ 424→ Aug 2018 | Accessible | $225,000 | Foreclosure
425→ 425→ Aug 2018 | Accessible | $225,000 | Foreclosure
426→ 426→ Aug 2018 | Unrestricted | $600,000 | Foreclosure
427→ 427→ Aug 2018 | Unrestricted | $360,000 | Foreclosure
428→ 428→ Aug 2018 | Unrestricted | $350,000 | Foreclosure
429→ 429→ Aug 2018 | Accessible | $350,000 | Foreclosure
430→ 430→ Aug 2018 | Accessible | $225,000 | Foreclosure
431→ 431→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
432→ 432→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
433→ 433→ Aug 2018 | Unrestricted | $160,000 | Foreclosure
434→ 434→ Aug 2018 | Unrestricted | $160,000 | Foreclosure
435→ 435→ Aug 2018 | Unrestricted | $158,000 | Foreclosure
436→ 436→ Aug 2018 | Unrestricted | $180,000 | Foreclosure
437→ 437→ Aug 2018 | Unrestricted | $225,000 | Foreclosure
438→ 438→ Aug 2018 | Unrestricted | $180,000 | Foreclosure
439→ 439→ Aug 2018 | Unrestricted | $180,000 | Foreclosure
440→ 440→ Aug 2018 | Unrestricted | $180,000 | Foreclosure
441→ 441→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
442→ 442→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
443→ 443→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
444→ 444→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
445→ 445→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
446→ 446→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
447→ 447→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
448→ 448→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
449→ 449→ Aug 2018 | Unrestricted | $200,000 | Foreclosure
450→ 450→ Aug 2018 | Unrestricted | $210,000 | Foreclosure
451→ 451→ Aug 2018 | Unrestricted | $195,000 | Foreclosure
452→ 452→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
453→ 453→ Sep 2018 | Unrestricted | $250,000 | Foreclosure
454→ 454→ Sep 2018 | Unrestricted | $235,000 | Foreclosure
455→ 455→ Sep 2018 | Unrestricted | $235,000 | Foreclosure
456→ 456→ Sep 2018 | Unrestricted | $235,000 | Foreclosure
457→ 457→ Sep 2018 | Unrestricted | $235,000 | Foreclosure
458→ 458→ Sep 2018 | Unrestricted | $230,000 | Foreclosure
459→ 459→ Sep 2018 | Unrestricted | $230,000 | Foreclosure
460→ 460→ Sep 2018 | Unrestricted | $230,000 | Foreclosure
461→ 461→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
462→ 462→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
463→ 463→ Sep 2018 | Unrestricted | $310,000 | Foreclosure
464→ 464→ Sep 2018 | Unrestricted | $230,000 | Foreclosure
465→ 465→ Sep 2018 | Unrestricted | $230,000 | Foreclosure
466→ 466→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
467→ 467→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
468→ 468→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
469→ 469→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
470→ 470→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
471→ 471→ Sep 2018 | Unrestricted | $650,000 | Foreclosure
472→ 472→ Sep 2018 | Accessible | $225,000 | Foreclosure
473→ 473→ Sep 2018 | Accessible | $225,000 | Foreclosure
474→ 474→ Sep 2018 | Accessible | $225,000 | Foreclosure
475→ 475→ Sep 2018 | Accessible | $225,000 | Foreclosure
476→ 476→ Sep 2018 | Accessible | $225,000 | Foreclosure
477→ 477→ Sep 2018 | Accessible | $225,000 | Foreclosure
478→ 478→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
479→ 479→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
480→ 480→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
481→ 481→ Sep 2018 | Unrestricted | $160,000 | Foreclosure
482→ 482→ Sep 2018 | Unrestricted | $175,000 | Foreclosure
483→ 483→ Sep 2018 | Unrestricted | $175,000 | Foreclosure
484→ 484→ Sep 2018 | Unrestricted | $180,000 | Foreclosure
485→ 485→ Sep 2018 | Unrestricted | $200,000 | Foreclosure
486→ 486→ Sep 2018 | Unrestricted | $200,000 | Foreclosure
487→ 487→ Sep 2018 | Unrestricted | $210,000 | Foreclosure
488→ 488→ Sep 2018 | Unrestricted | $210,000 | Foreclosure
489→ 489→ Sep 2018 | Unrestricted | $215,000 | Foreclosure
490→ 490→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
491→ 491→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
492→ 492→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
493→ 493→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
494→ 494→ Sep 2018 | Unrestricted | $225,000 | Foreclosure
495→ 495→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
496→ 496→ Oct 2018 | Unrestricted | $235,000 | Foreclosure
497→ 497→ Oct 2018 | Unrestricted | $235,000 | Foreclosure
498→ 498→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
499→ 499→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
500→ 500→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
501→ 501→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
502→ 502→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
503→ 503→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
504→ 504→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
505→ 505→ Oct 2018 | Unrestricted | $230,000 | Foreclosure
506→ 506→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
507→ 507→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
508→ 508→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
509→ 509→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
510→ 510→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
511→ 511→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
512→ 512→ Oct 2018 | Unrestricted | $195,000 | Foreclosure
513→ 513→ Oct 2018 | Unrestricted | $195,000 | Foreclosure
514→ 514→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
515→ 515→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
516→ 516→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
517→ 517→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
518→ 518→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
519→ 519→ Oct 2018 | Unrestricted | $210,000 | Foreclosure
520→ 520→ Oct 2018 | Unrestricted | $210,000 | Foreclosure
521→ 521→ Oct 2018 | Unrestricted | $210,000 | Foreclosure
522→ 522→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
523→ 523→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
524→ 524→ Oct 2018 | Unrestricted | $225,000 | Foreclosure
525→ 525→ Oct 2018 | Unrestricted | $200,000 | Foreclosure
526→ 526→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
527→ 527→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
528→ 528→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
529→ 529→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
530→ 530→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
531→ 531→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
532→ 532→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
533→ 533→ Oct 2018 | Unrestricted | $340,000 | Foreclosure
534→ 534→ Oct 2018 | Unrestricted | $340,000 | Foreclosure
535→ 535→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
536→ 536→ Oct 2018 | Unrestricted | $310,000 | Foreclosure
537→ 537→ Oct 2018 | Unrestricted | $260,000 | Foreclosure
538→ 538→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
539→ 539→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
540→ 540→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
541→ 541→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
542→ 542→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
543→ 543→ Oct 2018 | Unrestricted | $300,000 | Foreclosure
544→ 544→ Oct 2018 | Unrestricted | $195,000 | Foreclosure
545→ 545→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
546→ 546→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
547→ 547→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
548→ 548→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
549→ 549→ Oct 2018 | Unrestricted | $600,000 | Foreclosure
550→ 550→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
551→ 551→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
552→ 552→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
553→ 553→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
554→ 554→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
555→ 555→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
556→ 556→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
557→ 557→ Oct 2018 | Unrestricted | $450,000 | Foreclosure
558→ 558→ Oct 2018 | Unrestricted | $350,000 | Foreclosure
559→ 559→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
560→ 560→ Oct 2018 | Unrestricted | $343,750 | Foreclosure
561→ 561→ Oct 2018 | Unrestricted | $460,000 | Foreclosure
562→ 562→ Oct 2018 | Unrestricted | $250,000 | Foreclosure
563→ 563→ Oct 2018 | Unrestricted | $180,000 | Foreclosure
564→ 564→ Oct 2018 | Unrestricted | $180,000 | Foreclosure
565→ 565→ Oct 2018 | Unrestricted | $235,000 | Foreclosure
566→ 566→ Oct 2018 | Unrestricted | $135,000 | Foreclosure
567→ 567→ Nov 2018 | Alternative Fuel | $360,000 | Foreclosure
568→ 568→ Nov 2018 | Alternative Fuel | $350,000 | Foreclosure
569→ 569→ Nov 2018 | Alternative Fuel | $350,000 | Foreclosure
570→ 570→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
571→ 571→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
572→ 572→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
573→ 573→ Nov 2018 | Accessible | $225,000 | Foreclosure
574→ 574→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
575→ 575→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
576→ 576→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
577→ 577→ Nov 2018 | Accessible | $340,000 | Bankruptcy
578→ 578→ Nov 2018 | Accessible | $340,000 | Bankruptcy
579→ 579→ Nov 2018 | Accessible | $340,000 | Bankruptcy
580→ 580→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
581→ 581→ Nov 2018 | Accessible | $340,000 | Bankruptcy
582→ 582→ Nov 2018 | Accessible | $340,000 | Bankruptcy
583→ 583→ Nov 2018 | Accessible | $340,000 | Bankruptcy
584→ 584→ Nov 2018 | Accessible | $340,000 | Bankruptcy
585→ 585→ Nov 2018 | Accessible | $340,000 | Bankruptcy
586→ 586→ Nov 2018 | Accessible | $340,000 | Bankruptcy
587→ 587→ Nov 2018 | Accessible | $340,000 | Bankruptcy
588→ 588→ Nov 2018 | Accessible | $340,000 | Bankruptcy
589→ 589→ Nov 2018 | Accessible | $340,000 | Bankruptcy
590→ 590→ Nov 2018 | Accessible | $340,000 | Bankruptcy
591→ 591→ Nov 2018 | Accessible | $340,000 | Bankruptcy
592→ 592→ Nov 2018 | Accessible | $340,000 | Bankruptcy
593→ 593→ Nov 2018 | Alternative Fuel | $340,000 | Bankruptcy
594→ 594→ Nov 2018 | Unrestricted | $700,000 | Foreclosure
595→ 595→ Nov 2018 | Unrestricted | $700,000 | Foreclosure
596→ 596→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
597→ 597→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
598→ 598→ Nov 2018 | Unrestricted | $340,000 | Foreclosure
599→ 599→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
600→ 600→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
601→ 601→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
602→ 602→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
603→ 603→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
604→ 604→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
605→ 605→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
606→ 606→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
607→ 607→ Nov 2018 | Unrestricted | $1,050,000 | Foreclosure
608→ 608→ Nov 2018 | Unrestricted | $350,000 | Foreclosure
609→ 609→ Nov 2018 | Unrestricted | $432,000 | Foreclosure
610→ 610→ Nov 2018 | Unrestricted | $460,000 | Foreclosure
611→ 611→ Nov 2018 | Unrestricted | $500,000 | Bankruptcy
612→ 612→ Nov 2018 | Unrestricted | $500,000 | Bankruptcy
613→ 613→ Nov 2018 | Unrestricted | $500,000 | Bankruptcy
614→ 614→ Nov 2018 | Unrestricted | $500,000 | Bankruptcy
615→ 615→ Nov 2018 | Unrestricted | $510,000 | Bankruptcy
616→ 616→ Nov 2018 | Unrestricted | $600,000 | Foreclosure
617→ 617→ Nov 2018 | Unrestricted | $700,000 | Foreclosure
618→ 618→ Nov 2018 | Unrestricted | $700,000 | Foreclosure
619→ 619→ Nov 2018 | Unrestricted | $502,000 | Foreclosure
620→ 620→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
621→ 621→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
622→ 622→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
623→ 623→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
624→ 624→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
625→ 625→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
626→ 626→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
627→ 627→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
628→ 628→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
629→ 629→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
630→ 630→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
631→ 631→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
632→ 632→ Nov 2018 | Unrestricted | $296,000 | Foreclosure
633→ 633→ Nov 2018 | Unrestricted | $235,000 | Foreclosure
634→ 634→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
635→ 635→ Nov 2018 | Unrestricted | $235,000 | Foreclosure
636→ 636→ Nov 2018 | Unrestricted | $235,000 | Foreclosure
637→ 637→ Nov 2018 | Unrestricted | $230,000 | Foreclosure
638→ 638→ Nov 2018 | Unrestricted | $210,000 | Foreclosure
639→ 639→ Nov 2018 | Unrestricted | $200,000 | Foreclosure
640→ 640→ Nov 2018 | Unrestricted | $190,000 | Foreclosure
641→ 641→ Nov 2018 | Unrestricted | $182,000 | Foreclosure
642→ 642→ Nov 2018 | Unrestricted | $160,000 | Foreclosure
643→ 643→ Nov 2018 | Unrestricted | $155,000 | Foreclosure
644→ 644→ Nov 2018 | Unrestricted | $235,000 | Foreclosure
645→ 645→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
646→ 646→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
647→ 647→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
648→ 648→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
649→ 649→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
650→ 650→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
651→ 651→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
652→ 652→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
653→ 653→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
654→ 654→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
655→ 655→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
656→ 656→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
657→ 657→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
658→ 658→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
659→ 659→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
660→ 660→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
661→ 661→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
662→ 662→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
663→ 663→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
664→ 664→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
665→ 665→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
666→ 666→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
667→ 667→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
668→ 668→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
669→ 669→ Nov 2018 | Unrestricted | $340,000 | Bankruptcy
670→ 670→ Dec 2018 | Accessible | $700,000 | Foreclosure
671→ 671→ Dec 2018 | Accessible | $300,000 | Foreclosure
672→ 672→ Dec 2018 | Accessible | $300,000 | Foreclosure
673→ 673→ Dec 2018 | Accessible | $700,000 | Foreclosure
674→ 674→ Dec 2018 | Accessible | $700,000 | Foreclosure
675→ 675→ Dec 2018 | Accessible | $700,000 | Foreclosure
676→ 676→ Dec 2018 | Accessible | $700,000 | Foreclosure
677→ 677→ Dec 2018 | Accessible | $700,000 | Foreclosure
678→ 678→ Dec 2018 | Accessible | $700,000 | Foreclosure
679→ 679→ Dec 2018 | Accessible | $700,000 | Foreclosure
680→ 680→ Dec 2018 | Unrestricted | $145,000 | Foreclosure
681→ 681→ Dec 2018 | Unrestricted | $225,000 | Foreclosure
682→ 682→ Dec 2018 | Unrestricted | $165,000 | Foreclosure
683→ 683→ Dec 2018 | Unrestricted | $440,000 | Foreclosure
684→ 684→ Dec 2018 | Unrestricted | $440,000 | Foreclosure
685→ 685→ Dec 2018 | Unrestricted | $440,000 | Foreclosure
686→ 686→ Dec 2018 | Unrestricted | $500,000 | Foreclosure
687→ 687→ Dec 2018 | Unrestricted | $500,000 | Foreclosure
688→ 688→ Dec 2018 | Unrestricted | $500,000 | Foreclosure
689→ 689→ Dec 2018 | Unrestricted | $350,000 | Foreclosure
690→ 690→ Dec 2018 | Unrestricted | $500,000 | Foreclosure
691→ 691→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
692→ 692→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
693→ 693→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
694→ 694→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
695→ 695→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
696→ 696→ Dec 2018 | Unrestricted | $700,000 | Foreclosure
697→ 697→ Dec 2018 | Alternative Fuel | $210,000 | Foreclosure
698→ 698→ Dec 2018 | Unrestricted | $600,000 | Foreclosure
699→ 699→ Dec 2018 | Unrestricted | $350,000 | Foreclosure
... (200 more lines truncated)Read
/Users/nrh146/.claude/projects/-Users-nrh146-Documents-agentic-investigation-newsworthiness-dataonly/3f5cd1d9-9d60-4f34-8bf6-106a8ad8d40d/tool-results/toolu_01Qj6vsY7kFy1moHLbwy3Q56.txt
Output
900→ 900→ '3 Medallions': 9 occurrences
901→ 901→ '3 medallions': 6 occurrences
902→ 902→ '3 medallions, 33%': 1 occurrences
903→ 903→ '33.00%': 1 occurrences
904→ 904→ '4 Medallions - 50%': 1 occurrences
905→ 905→ '4 medallions': 3 occurrences
906→ 906→ '5 medallons': 1 occurrences
907→ 907→ '5%': 1 occurrences
908→ 908→ '50 percent': 20 occurrences
909→ 909→ '50%': 14 occurrences
910→ 910→ '50% 2 MEDALLIONS': 1 occurrences
911→ 911→ '50% Estate': 1 occurrences
912→ 912→ '50% Foreclosure': 1 occurrences
913→ 913→ '50%, 2 medallions': 1 occurrences
914→ 914→ '50%, 3 medallions': 1 occurrences
915→ 915→ '50.00%': 6 occurrences
916→ 916→ '80%': 1 occurrences
917→ 917→ '9%': 1 occurrences
918→ 918→ '95%': 1 occurrences
919→ 919→ 'BUYING 1%': 1 occurrences
920→ 920→ 'Bankruptcy': 92 occurrences
921→ 921→ 'CORP SELLING 10%': 1 occurrences
922→ 922→ 'Conditional Sale - 2 Med': 1 occurrences
923→ 923→ 'DOF WAIVER': 6 occurrences
924→ 924→ 'Divorce Settlement': 1 occurrences
925→ 925→ 'ESTATE': 21 occurrences
926→ 926→ 'Estate': 116 occurrences
927→ 927→ 'FORECLOSURE': 4 occurrences
928→ 928→ 'FORM CORP SELLING %': 1 occurrences
929→ 929→ 'FORMING CORP': 4 occurrences
930→ 930→ 'FORMING PARNTERHIP': 2 occurrences
931→ 931→ 'Family': 19 occurrences
932→ 932→ 'Foreclosure': 456 occurrences
933→ 933→ 'IND TO CORP': 4 occurrences
934→ 934→ 'IND TO CORP - 50% SALE': 1 occurrences
935→ 935→ 'INDIVIDUAL TO CORP': 1 occurrences
936→ 936→ 'Individual to Corp.': 10 occurrences
937→ 937→ 'Individual to LLC': 28 occurrences
938→ 938→ 'Individual to Partnership': 1 occurrences
939→ 939→ 'LLC - 45% Sale': 1 occurrences
940→ 940→ 'PARTNERSHIP SPLIT': 3 occurrences
941→ 941→ 'Partnership': 1 occurrences
942→ 942→ 'Partnership Split': 8 occurrences
943→ 943→ 'SELLING 10%': 4 occurrences
944→ 944→ 'SELLING 5%': 1 occurrences
945→ 945→ 'SELLING 50%': 2 occurrences
946→ 946→
947→ 947→================================================================================
948→ 948→8. INDIVIDUAL TO LLC TRANSFERS
949→ 949→================================================================================
950→ 950→
951→ 951→Individual-to-LLC transfers: 29
952→ 952→By year: year
953→ 953→2013 4
954→ 954→2014 4
955→ 955→2015 9
956→ 956→2016 5
957→ 957→2017 4
958→ 958→2018 3
959→ 959→Prices: count 29.000000
960→ 960→mean 13436.473448
961→ 961→std 72357.623946
962→ 962→min 0.000000
963→ 963→25% 0.000000
964→ 964→50% 0.000000
965→ 965→75% 0.000000
966→ 966→max 389657.730000
967→ 967→
968→ 968→================================================================================
969→ 969→9. PRICE COLLAPSE TIMELINE - peak to trough
970→ 970→================================================================================
971→ 971→
972→ 972→Monthly max price (Unrestricted Asset Sales):
973→ 973→ Jan 2012: max=$ 710,000 median=$ 700,000 (n=8)
974→ 974→ Feb 2012: max=$ 715,000 median=$ 700,000 (n=8)
975→ 975→ Mar 2012: max=$ 705,000 median=$ 700,000 (n=9)
976→ 976→ Apr 2012: max=$ 710,000 median=$ 700,000 (n=11)
977→ 977→ May 2012: max=$ 710,000 median=$ 700,000 (n=15)
978→ 978→ Jun 2012: max=$ 712,000 median=$ 702,500 (n=12)
979→ 979→ Jul 2012: max=$ 710,000 median=$ 702,500 (n=12)
980→ 980→ Aug 2012: max=$ 750,000 median=$ 710,000 (n=15)
981→ 981→ Sep 2012: max=$ 740,000 median=$ 705,000 (n=9)
982→ 982→ Oct 2012: max=$ 760,000 median=$ 732,000 (n=3)
983→ 983→ Nov 2012: max=$ 800,000 median=$ 750,000 (n=3)
984→ 984→ Dec 2012: max=$ 850,000 median=$ 800,000 (n=9)
985→ 985→ Jan 2013: max=$ 799,999 median=$ 581,250 (n=2)
986→ 986→ Feb 2013: max=$ 920,000 median=$ 847,500 (n=6)
987→ 987→ Mar 2013: max=$ 950,000 median=$ 850,000 (n=12)
988→ 988→ Apr 2013: max=$ 1,005,000 median=$ 950,000 (n=8)
989→ 989→ May 2013: max=$ 1,040,000 median=$ 1,000,000 (n=9)
990→ 990→ Jun 2013: max=$ 1,100,000 median=$ 1,040,000 (n=9)
991→ 991→ Jul 2013: max=$ 1,050,000 median=$ 1,005,000 (n=4)
992→ 992→ Aug 2013: max=$ 1,050,000 median=$ 1,000,000 (n=5)
993→ 993→ Sep 2013: max=$ 1,000,000 median=$ 700,000 (n=4)
994→ 994→ Oct 2013: max=$ 1,000,000 median=$ 962,500 (n=4)
995→ 995→ Nov 2013: max=$ 925,000 median=$ 900,000 (n=2)
996→ 996→ Dec 2013: max=$ 980,000 median=$ 922,500 (n=8)
997→ 997→ Jan 2014: max=$ 1,050,000 median=$ 962,500 (n=8)
998→ 998→ Feb 2014: max=$ 1,000,000 median=$ 980,000 (n=10)
999→ 999→ Mar 2014: max=$ 1,050,000 median=$ 1,000,000 (n=7)
1000→ 1000→ Apr 2014: max=$ 1,050,000 median=$ 1,010,000 (n=9)
1001→ 1001→ May 2014: max=$ 1,050,000 median=$ 990,000 (n=10)
1002→ 1002→ Jun 2014: max=$ 1,050,000 median=$ 1,000,000 (n=5)
1003→ 1003→ Jul 2014: max=$ 1,025,000 median=$ 1,000,000 (n=4)
1004→ 1004→ Aug 2014: max=$ 1,000,000 median=$ 905,000 (n=6)
1005→ 1005→ Sep 2014: max=$ 900,000 median=$ 900,000 (n=1)
1006→ 1006→ Oct 2014: max=$ 905,000 median=$ 875,000 (n=3)
1007→ 1007→ Nov 2014: max=$ 850,000 median=$ 835,000 (n=4)
1008→ 1008→ Dec 2014: max=$ 810,000 median=$ 805,000 (n=2)
1009→ 1009→ Jan 2015: max=$ 800,000 median=$ 436,250 (n=2)
1010→ 1010→ Mar 2015: max=$ 800,000 median=$ 600,000 (n=4)
1011→ 1011→ May 2015: max=$ 700,000 median=$ 700,000 (n=1)
1012→ 1012→ Jun 2015: max=$ 777,000 median=$ 767,250 (n=2)
1013→ 1013→ Jul 2015: max=$ 603,000 median=$ 603,000 (n=1)
1014→ 1014→ Aug 2015: max=$ 725,000 median=$ 715,000 (n=4)
1015→ 1015→ Sep 2015: max=$ 715,000 median=$ 481,696 (n=2)
1016→ 1016→ Oct 2015: max=$ 675,000 median=$ 512,500 (n=2)
1017→ 1017→ Nov 2015: max=$ 325,545 median=$ 325,545 (n=1)
1018→ 1018→ Dec 2015: max=$ 725,000 median=$ 715,000 (n=2)
1019→ 1019→ Apr 2016: max=$ 615,000 median=$ 470,000 (n=2)
1020→ 1020→ May 2016: max=$ 560,000 median=$ 540,000 (n=3)
1021→ 1021→ Jun 2016: max=$ 610,000 median=$ 572,500 (n=7)
1022→ 1022→ Jul 2016: max=$ 620,000 median=$ 620,000 (n=3)
1023→ 1023→ Aug 2016: max=$ 620,000 median=$ 584,000 (n=4)
1024→ 1024→ Oct 2016: max=$ 600,000 median=$ 600,000 (n=1)
1025→ 1025→ Nov 2016: max=$ 500,000 median=$ 500,000 (n=1)
1026→ 1026→ Dec 2016: max=$ 600,000 median=$ 515,000 (n=4)
1027→ 1027→ Feb 2017: max=$ 550,000 median=$ 475,000 (n=2)
1028→ 1028→ Mar 2017: max=$ 241,000 median=$ 241,000 (n=1)
1029→ 1029→ May 2017: max=$ 750,000 median=$ 400,000 (n=8)
1030→ 1030→ Jun 2017: max=$ 475,000 median=$ 220,000 (n=9)
1031→ 1031→ Jul 2017: max=$ 580,521 median=$ 468,000 (n=9)
1032→ 1032→ Aug 2017: max=$ 900,000 median=$ 400,000 (n=11)
1033→ 1033→ Sep 2017: max=$ 400,000 median=$ 255,744 (n=3)
1034→ 1034→ Oct 2017: max=$ 1,350,000 median=$ 400,000 (n=17)
1035→ 1035→ Nov 2017: max=$ 750,000 median=$ 350,000 (n=9)
1036→ 1036→ Dec 2017: max=$ 800,000 median=$ 200,000 (n=11)
1037→ 1037→ Jan 2018: max=$ 380,000 median=$ 372,000 (n=30)
1038→ 1038→ Feb 2018: max=$ 750,000 median=$ 400,000 (n=18)
1039→ 1039→ Mar 2018: max=$ 700,000 median=$ 350,000 (n=16)
1040→ 1040→ Apr 2018: max=$ 700,000 median=$ 185,000 (n=18)
1041→ 1041→ May 2018: max=$ 800,000 median=$ 200,000 (n=26)
1042→ 1042→ Jun 2018: max=$ 700,000 median=$ 275,000 (n=38)
1043→ 1043→ Jul 2018: max=$ 1,000,000 median=$ 225,000 (n=25)
1044→ 1044→ Aug 2018: max=$ 600,000 median=$ 200,000 (n=42)
1045→ 1045→ Sep 2018: max=$ 650,000 median=$ 225,000 (n=45)
1046→ 1046→ Oct 2018: max=$ 600,000 median=$ 235,000 (n=77)
1047→ 1047→ Nov 2018: max=$ 1,050,000 median=$ 340,000 (n=83)
1048→ 1048→ Dec 2018: max=$ 700,000 median=$ 225,000 (n=74)
1049→ 1049→
1050→ 1050→================================================================================
1051→ 1051→10. ACCESSIBLE MEDALLION PRICES
1052→ 1052→================================================================================
1053→ 1053→
1054→ 1054→Accessible medallion sales: 78
1055→ 1055→ Feb 2012 | Independent Accessible | Asset Sale | $660,000 | nan
1056→ 1056→ Apr 2012 | Independent Accessible | Asset Sale | $650,000 | nan
1057→ 1057→ Aug 2012 | Independent Accessible | Asset Sale | $650,000 | nan
1058→ 1058→ Sep 2012 | Independent Accessible | Asset Sale | $652,000 | nan
1059→ 1059→ Oct 2012 | Independent Accessible | Asset Sale | $650,000 | nan
1060→ 1060→ Nov 2012 | Independent Accessible | Asset Sale | $670,000 | nan
1061→ 1061→ Nov 2012 | Independent Accessible | Asset Sale | $650,000 | nan
1062→ 1062→ Nov 2012 | Independent Accessible | Asset Sale | $650,000 | nan
1063→ 1063→ Dec 2012 | Independent Accessible | Asset Sale | $337,500 | 50 percent
1064→ 1064→ Jun 2014 | Independent Accessible | Asset Sale | $875,000 | nan
1065→ 1065→ Oct 2014 | Independent Accessible | Asset Sale | $409,838 | IND TO CORP - 50% SALE
1066→ 1066→ May 2015 | Independent Accessible | Stock Transfer | $15,000 | 0.1
1067→ 1067→ Jun 2015 | Independent Accessible | Asset Sale | $740,000 | Foreclosure
1068→ 1068→ Jul 2017 | Accessible | Asset Sale | $468,000 | Foreclosure
1069→ 1069→ Aug 2017 | Accessible | Asset Sale | $300,000 | nan
1070→ 1070→ Sep 2017 | Accessible | Asset Sale | $1,320,000 | nan
1071→ 1071→ Dec 2017 | Accessible | Asset Sale | $210,000 | nan
1072→ 1072→ Jan 2018 | Accessible | Asset Sale | $372,000 | Bankruptcy
1073→ 1073→ Jan 2018 | Accessible | Asset Sale | $372,000 | Bankruptcy
1074→ 1074→ Jan 2018 | Accessible | Asset Sale | $372,000 | Bankruptcy
1075→ 1075→ Feb 2018 | Accessible | Asset Sale | $750,000 | Foreclosure
1076→ 1076→ Feb 2018 | Accessible | Asset Sale | $750,000 | Foreclosure
1077→ 1077→ Feb 2018 | Accessible | Asset Sale | $750,000 | Foreclosure
1078→ 1078→ Feb 2018 | Accessible | Asset Sale | $750,000 | Foreclosure
1079→ 1079→ Jun 2018 | Accessible | Asset Sale | $130,000 | Foreclosure
1080→ 1080→ Jun 2018 | Accessible | Asset Sale | $400,000 | Foreclosure
1081→ 1081→ Jun 2018 | Accessible | Asset Sale | $400,000 | Foreclosure
1082→ 1082→ Jun 2018 | Accessible | Asset Sale | $400,000 | Foreclosure
1083→ 1083→ Jun 2018 | Accessible | Asset Sale | $400,000 | Foreclosure
1084→ 1084→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1085→ 1085→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1086→ 1086→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1087→ 1087→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1088→ 1088→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1089→ 1089→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1090→ 1090→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1091→ 1091→ Aug 2018 | Accessible | Asset Sale | $350,000 | Foreclosure
1092→ 1092→ Aug 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1093→ 1093→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1094→ 1094→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1095→ 1095→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1096→ 1096→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1097→ 1097→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1098→ 1098→ Sep 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1099→ 1099→ Nov 2018 | Accessible | Asset Sale | $225,000 | Foreclosure
1100→ 1100→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1101→ 1101→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1102→ 1102→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1103→ 1103→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1104→ 1104→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1105→ 1105→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1106→ 1106→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1107→ 1107→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1108→ 1108→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1109→ 1109→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1110→ 1110→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1111→ 1111→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1112→ 1112→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1113→ 1113→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1114→ 1114→ Nov 2018 | Accessible | Asset Sale | $340,000 | Bankruptcy
1115→ 1115→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1116→ 1116→ Dec 2018 | Accessible | Asset Sale | $300,000 | Foreclosure
1117→ 1117→ Dec 2018 | Accessible | Asset Sale | $300,000 | Foreclosure
1118→ 1118→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1119→ 1119→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1120→ 1120→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1121→ 1121→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1122→ 1122→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1123→ 1123→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1124→ 1124→ Dec 2018 | Accessible | Asset Sale | $700,000 | Foreclosure
1125→ 1125→ Dec 2018 | Accessible | Asset Sale | $130,000 | nan
1126→ 1126→ Dec 2018 | Accessible | Asset Sale | $130,000 | nan
1127→ 1127→ Dec 2018 | Accessible | Asset Sale | $135,000 | nan
1128→ 1128→ Dec 2018 | Accessible | Asset Sale | $140,000 | Foreclosure
1129→ 1129→ Dec 2018 | Accessible | Asset Sale | $195,000 | Foreclosure
1130→ 1130→ Dec 2018 | Accessible | Asset Sale | $300,000 | Foreclosure
1131→ 1131→ Dec 2018 | Accessible | Asset Sale | $300,000 | Foreclosure
1132→ 1132→ Dec 2018 | Accessible | Asset Sale | $300,000 | Foreclosure
1133→ 1133→Thinking...
Now I have a comprehensive picture. Let me run one more targeted analysis to compute key statistics for the tipsheet, then write the tipsheet.
Claude
Now let me run a few more targeted analyses to sharpen the leads before writing the tipsheet.
Bash
python3 << 'PYEOF'
import pandas as pd
import numpy as np
import warnings
warnings.filterwarnings('ignore')
pdf_df = pd.read_csv('outputs/medallion_pdf_data.csv')
excel_df = pd.read_csv('outputs/medallion_excel_data.csv')
# Quick calculations for tipsheet
# 1. Peak-to-trough decline
print("=== KEY METRICS ===")
print(f"Peak median (unrestricted ind. asset sale): $1,000,000 (Q2 2013, Q2 2014)")
print(f"Trough median: ~$200,000 (Q2/Q3 2018)")
print(f"Decline: ~80%")
# 2. Foreclosure share over time
print("\n=== FORECLOSURE/BANKRUPTCY SHARE OF ALL PRICED TRANSACTIONS ===")
# Rebuild combined for this
import re
def clean_price(p):
if pd.isna(p) or str(p).strip().upper() == 'N/A':
return np.nan
p = str(p).replace('$','').replace(',','').strip()
try: return float(p)
except: return np.nan
month_map = {'January':1,'February':2,'March':3,'April':4,'May':5,'June':6,
'July':7,'August':8,'September':9,'October':10,'November':11,'December':12}
pdf_df['price_num'] = pdf_df['price'].apply(clean_price)
pdf_df['date'] = pd.to_datetime(pdf_df['year'].astype(str) + '-' + pdf_df['month'].astype(str) + '-01')
pdf_df['notes_clean'] = pdf_df['notes'].fillna('')
excel_df['price_num'] = excel_df['price'].apply(clean_price)
excel_df['month_num'] = excel_df['month'].map(month_map)
excel_df['date'] = pd.to_datetime(excel_df['year'].astype(str) + '-' + excel_df['month_num'].astype(str) + '-01')
excel_df['notes_clean'] = excel_df['notes'].fillna('')
combined_notes = pd.concat([
pdf_df[['date', 'price_num', 'notes_clean']],
excel_df[['date', 'price_num', 'notes_clean']]
])
priced = combined_notes[combined_notes['price_num'].notna() & (combined_notes['price_num'] > 0)].copy()
distress_keywords = ['foreclos', 'bankrupt', 'estate', 'divorce']
def is_distressed(n):
return any(k in str(n).lower() for k in distress_keywords)
priced['distressed'] = priced['notes_clean'].apply(is_distressed)
priced['foreclosure'] = priced['notes_clean'].apply(lambda x: 'foreclos' in str(x).lower())
priced['bankruptcy'] = priced['notes_clean'].apply(lambda x: 'bankrupt' in str(x).lower())
priced['year'] = priced['date'].dt.year
for year in sorted(priced['year'].unique()):
yr = priced[priced['year'] == year]
total = len(yr)
fc = yr['foreclosure'].sum()
bk = yr['bankruptcy'].sum()
dist = yr['distressed'].sum()
print(f" {year}: {total:>4} priced txns | {fc:>3} foreclosure ({fc/total*100:.0f}%) | {bk:>3} bankruptcy ({bk/total*100:.0f}%) | {dist:>3} total distressed ({dist/total*100:.0f}%)")
# 3. Repeated identical prices (batch sales pattern)
print("\n=== SUSPICIOUS BATCH PATTERNS (identical prices in same month) ===")
priced_with_date = priced.copy()
priced_with_date['ym'] = priced_with_date['date'].dt.strftime('%Y-%m')
batch = priced_with_date.groupby(['ym', 'price_num']).size().reset_index(name='count')
batch = batch[batch['count'] >= 5].sort_values('count', ascending=False)
print(batch.head(30).to_string(index=False))
# 4. Jan 2018 $372K bankruptcy batch
print("\n=== JAN 2018 $372K BANKRUPTCY BATCH DETAIL ===")
jan18 = priced_with_date[(priced_with_date['ym'] == '2018-01') & (priced_with_date['price_num'] == 372000)]
print(f"Count: {len(jan18)}")
print(f"All bankruptcy: {jan18['notes_clean'].value_counts().to_string()}")
# 5. Nov 2018 $340K batch
print("\n=== NOV 2018 $340K BATCH DETAIL ===")
nov18 = priced_with_date[(priced_with_date['ym'] == '2018-11') & (priced_with_date['price_num'] == 340000)]
print(f"Count: {len(nov18)}")
print(f"Notes: {nov18['notes_clean'].value_counts().to_string()}")
# 6. Wide price spreads within same month (potential arbitrage or manipulation)
print("\n=== LARGEST WITHIN-MONTH PRICE SPREADS (unrestricted asset sales, >$0) ===")
# Need classification
excel_df['class_norm'] = excel_df['medallion_classification'].apply(lambda c: 'Unrestricted' if 'unrest' in str(c).lower() else str(c))
pdf_df['sale_type'] = pdf_df['transaction_type'].replace({'asset_sale': 'Asset Sale', 'stock_transfer': 'Stock Transfer'})
pdf_df['class_norm'] = pdf_df['classification'].apply(lambda c: 'Unrestricted' if 'unrestrict' in str(c).lower() else str(c))
combined2 = pd.concat([
pdf_df[['date', 'price_num', 'notes_clean', 'class_norm', 'sale_type']],
excel_df[['date', 'price_num', 'notes_clean', 'class_norm', 'sale_type']]
])
unr_asset = combined2[(combined2['class_norm'] == 'Unrestricted') & (combined2['sale_type'] == 'Asset Sale') & (combined2['price_num'] > 0)]
spreads = unr_asset.groupby('date')['price_num'].agg(['min','max','count'])
spreads['spread'] = spreads['max'] - spreads['min']
spreads['spread_pct'] = (spreads['spread'] / spreads['min'] * 100).round(0)
print(spreads[spreads['count'] >= 3].sort_values('spread_pct', ascending=False).head(15).to_string())
PYEOFOutput
=== KEY METRICS ===
Peak median (unrestricted ind. asset sale): $1,000,000 (Q2 2013, Q2 2014)
Trough median: ~$200,000 (Q2/Q3 2018)
Decline: ~80%
=== FORECLOSURE/BANKRUPTCY SHARE OF ALL PRICED TRANSACTIONS ===
2012: 192 priced txns | 0 foreclosure (0%) | 0 bankruptcy (0%) | 1 total distressed (1%)
2013: 131 priced txns | 0 foreclosure (0%) | 0 bankruptcy (0%) | 0 total distressed (0%)
2014: 109 priced txns | 5 foreclosure (5%) | 0 bankruptcy (0%) | 5 total distressed (5%)
2015: 37 priced txns | 11 foreclosure (30%) | 0 bankruptcy (0%) | 12 total distressed (32%)
2016: 47 priced txns | 26 foreclosure (55%) | 0 bankruptcy (0%) | 29 total distressed (62%)
2017: 105 priced txns | 39 foreclosure (37%) | 0 bankruptcy (0%) | 44 total distressed (42%)
2018: 614 priced txns | 381 foreclosure (62%) | 92 bankruptcy (15%) | 479 total distressed (78%)
=== SUSPICIOUS BATCH PATTERNS (identical prices in same month) ===
ym price_num count
2018-11 340000.00 65
2018-01 372000.00 23
2018-09 225000.00 17
2018-12 200000.00 14
2018-08 225000.00 14
2018-12 700000.00 14
2018-11 350000.00 11
2018-06 400000.00 10
2018-10 343750.00 10
2018-08 200000.00 10
2018-10 230000.00 9
2018-10 225000.00 9
2018-12 300000.00 9
2018-02 750000.00 9
2018-12 225000.00 8
2012-08 710000.00 8
2016-09 1250000.00 8
2017-08 400000.00 7
2018-10 460000.00 7
2018-06 160000.00 6
2018-04 185000.00 6
2012-03 700000.00 6
2018-09 650000.00 6
2018-10 200000.00 6
2017-07 468000.00 6
2018-10 250000.00 6
2018-10 600000.00 6
2018-09 1265927.35 6
2018-12 235000.00 5
2012-06 700000.00 5
=== JAN 2018 $372K BANKRUPTCY BATCH DETAIL ===
Count: 23
All bankruptcy: notes_clean
Bankruptcy 23
=== NOV 2018 $340K BATCH DETAIL ===
Count: 65
Notes: notes_clean
Bankruptcy 64
Foreclosure 1
=== LARGEST WITHIN-MONTH PRICE SPREADS (unrestricted asset sales, >$0) ===
min max count spread spread_pct
date
2013-03-01 8000.00 2420000.0 13 2412000.00 30150.0
2018-04-01 5000.00 700000.0 18 695000.00 13900.0
2013-04-01 33900.00 2150000.0 9 2116100.00 6242.0
2014-04-01 88893.50 3900000.0 10 3811106.50 4287.0
2012-08-01 58623.80 2100000.0 23 2041376.20 3482.0
2012-05-01 60000.00 2000000.0 18 1940000.00 3233.0
2014-05-01 80836.96 2400000.0 11 2319163.04 2869.0
2015-03-01 103430.53 1900000.0 6 1796569.47 1737.0
2013-05-01 154525.26 2640000.0 10 2485474.74 1608.0
2013-06-01 100100.00 1100000.0 9 999900.00 999.0
2012-11-01 360000.00 3000000.0 5 2640000.00 733.0
2018-05-01 100000.00 800000.0 26 700000.00 700.0
2012-09-01 296178.64 2250000.0 10 1953821.36 660.0
2018-11-01 140000.00 1050000.0 83 910000.00 650.0
2018-07-01 145000.00 1000000.0 25 855000.00 590.0Thinking...
Now I have all the data I need to write a comprehensive tipsheet. Let me synthesize the findings.
Key findings:
1. **Massive price collapse**: Medallion prices fell ~80% from peak ($1M in 2013-2014) to ~$200K in 2018
2. **Foreclosure/bankruptcy tsunami**: From 0% distressed sales in 2012-2013 to 78% in 2018
3. **Giant batch bankruptcy sales**: 65 medallions sold at exactly $340K in Nov 2018, 23 at exactly $372K in Jan 2018 - suggests large fleet operators going under
4. **Volume explosion in late 2018**: Transaction volume surged from ~20/month to 100+/month, almost entirely foreclosures and bankruptcies
5. **Corporate medallions**: Disappeared from the data after 2016 - format change or something else?
6. **Suspicious price spreads**: Huge within-month spreads suggest very different circumstances for sellers
7. **$0 transfer patterns**: Heavy use of LLC/corporate restructuring, estate transfers
Now I'm ready to write the tipsheet.
Claude
I now have a complete picture. Let me write the tipsheet.
Write
/Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/outputs/tipsheet_nyc_medallions.md
File content
# Tipsheet: The Collapse of New York City Taxi Medallion Values, 2012-2018
## Source Material
- **What was analyzed**: 82 files from NYC Taxi & Limousine Commission (TLC) covering monthly medallion transfers from January 2012 through December 2018
- 36 PDF files (2012-2014): monthly medallion transfer charts
- 46 Excel files (2015-2018): monthly medallion price/sales lists
- **Total transaction rows extracted**: 1,805 (1,235 with prices > $0; 570 zero-dollar transfers)
- **Analysis date**: March 2026
- **Coverage notes**: All 82 source files were parsed. PDFs were extracted using pdfplumber; Excel files using openpyxl. Two slightly different tabular formats were handled across the time period. Data does not identify buyers, sellers, or medallion numbers — only prices, medallion classification, transaction type, and brief notes.
## Summary of Findings
This dataset captures one of the most dramatic asset collapses in modern American urban history: NYC taxi medallions fell from a peak median price of **$1,000,000 in mid-2013/mid-2014** to approximately **$200,000 by mid-2018** — a roughly 80% decline. The data shows this wasn't just a price correction: by 2018, **78% of all priced transactions were foreclosures or bankruptcies**, up from 0% in 2012-2013. The most striking signal is the emergence of **massive batch liquidations** in late 2018, with 65 medallions sold at the identical price of $340,000 in a single month (November 2018, all from bankruptcy) — suggesting the collapse of large fleet operators or lender-driven liquidation events that could be traced to specific entities.
---
## Leads
### Lead 1: Who Owned the 65 Medallions Liquidated at $340K in November 2018?
**Signal strength**: Strong
**Evidence**: In November 2018, 65 medallions were sold at exactly $340,000 each. 64 of the 65 were marked "Bankruptcy," one was "Foreclosure." This is by far the largest batch of identical-price sales in the entire dataset. Similarly, in January 2018, 23 medallio...Output
File created successfully at: /Users/nrh146/Documents/agentic-investigation-newsworthiness-dataonly/outputs/tipsheet_nyc_medallions.mdClaude
The tipsheet is written to outputs/tipsheet_nyc_medallions.md. Here's a summary of what I found:
The Big Picture
Your data captures the collapse of NYC taxi medallion values from ~$1 million to ~$200,000 (an 80% decline) between 2012 and 2018, and the human/financial wreckage that followed.
Top Leads
-
Who owned the 65 medallions liquidated at exactly $340K in November 2018? (Strong) — The largest batch of identical-price bankruptcy sales in the dataset. Almost certainly traces to a single major fleet operator or lender liquidation. Identifiable through PACER and TLC FOIL requests.
-
The market went from 0% to 78% distressed sales in six years (Strong) — In 2012-2013, every sale was voluntary. By 2018, only 1 in 4 sales were. The first foreclosures appear in late 2014, right as Uber was scaling in NYC.
-
Transaction volume exploded 5x in late 2018 (Strong) — Monthly sales surged from ~18 to over 100, almost entirely foreclosures/bankruptcies. This "fire sale" cascade pattern suggests coordinated lender liquidation that may have destroyed value beyond what rideshare competition alone caused.
-
Enormous within-month price spreads (Moderate) — In the same month in 2018, identical medallion types sold for $160K and $1M. Who paid top dollar when foreclosure prices were a fraction of that?
-
Corporate medallion market vanished after 2016 (Moderate) — Corporate medallions (which traded at 2.5-3x independent prices) disappear from the data. Did the fleet model collapse entirely?
-
LLC conversions spiked during early decline (Moderate) — Individual-to-LLC transfers surged in 2015, possibly owners sheltering assets ahead of anticipated defaults.
-
Court-ordered batch pricing patterns (Preliminary) — Multiple batches at oddly precise prices ($372K, $343,750, $1,265,927.35) point to identifiable bankruptcy cases.
The biggest gap: this data has no buyer/seller names or medallion numbers. A FOIL request to TLC for that information would unlock the most powerful stories — who was lending recklessly, who lost everything, and who swooped in to buy at the bottom.