Congress Trades

Coverage gap. Senate eFD: the last 13 checks failed; last successful check Oct 23. New filings from this source are not coming in. Newest Senate eFD filing on this site: 2026-10-21.

Source status
Filing audit view

20016393Parsed

DZoe Lofgren · House · ptr · filed Apr 11, 2020

Official filing metadata

Filer (as printed)
Hon. Zoe Lofgren
Office (as printed)
CA19
Chamber
House
Filing type
ptr
Filing date
Apr 11, 2020
Filing year
2020
Document format
pdf

Processing (ours)

Status
Parsed
Rows parsed
63
Parser version
house_pdf_v2
First seen
Sep 8, 2026 23:51 UTC (initial backfill, not when it was published)
Fetched
Nov 3, 2026
Parsed
Nov 3, 2026
Internal id
1512

Reading this page

The left half of each row below is the text exactly as it appears in the official document. The right half is our normalized interpretation: matched ticker, typed transaction, parsed dates and dollar range.

When the two disagree, the official document wins. Rows flagged for review are kept, never discarded, and the raw text is never edited.

Rows · 63

Left: official, as printed · Right: normalized
Raw filing rows beside their normalized interpretation
Official · as printed in the filingNormalized · our interpretation
#OwnerAssetTickerTypeTx dateNotifiedAmountConf.TickerTypeOwnerTx dateAmountClassFlags
1SPAdobe Inc. (AdbE) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00ADBE0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
2SPAlphabet Inc. - Class A (gOOgL) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00GOOGL0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
3SPAmerican Electric Power Company, Inc. (AEP) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
AEPS03/23/202003/23/2020$1,001 - $15,0001.00AEP0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
4SPAmerican Water Works Company, Inc. (AWK) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
AWKS03/23/202003/23/2020$1,001 - $15,0001.00AWK0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
5SPAmphenol Corporation (APH) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
APHS03/17/202003/19/2020$1,001 - $15,0001.00APH0.98SellSellSpouseMar 17, 2020$1,001 - $15,000mid $8KStockmodelled
6SPApple Inc. (AAPL) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
AAPLS03/23/202003/23/2020$1,001 - $15,0001.00AAPL0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
7SPAres Capital Corporation - Closed End Fund (ARCC) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
ARCCS03/23/202003/23/2020$1,001 - $15,0001.00ARCC0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
8SPAT&T Inc. (T) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
TS03/23/202003/23/2020$1,001 - $15,0001.00T0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
9SPAvangrid, Inc. (AgR) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00—0.00SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStocknot modelled
10SPbank of America Corporation (bAC) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00BAC0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
11SPberkshire Hathaway Inc. New (bRK.b) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00BRK-B0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
12SPChubb Limited (Cb) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00CB0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
13SPCincinnati Financial Corporation (CINF) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CINFS03/23/202003/23/2020$1,001 - $15,0001.00CINF0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
14SPCintas Corporation (CTAS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CTASS03/23/202003/23/2020$1,001 - $15,0001.00CTAS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
15SPCME group Inc. - Class A (CME) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CMES03/23/202003/23/2020$1,001 - $15,0001.00CME0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
16SPCMS Energy Corporation (CMS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CMSS03/23/202003/23/2020$1,001 - $15,0001.00CMS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
17SPCoca-Cola Company (KO) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
KOS03/23/202003/23/2020$1,001 - $15,0001.00KO0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
18SPColgate-Palmolive Company (CL) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CLS03/23/202003/23/2020$1,001 - $15,0001.00CL0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
19SPComcast Corporation - Class A (CMCSA) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
CMCSAS03/23/202003/23/2020$1,001 - $15,0001.00CMCSA0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
20SPCostco Wholesale Corporation (COST) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
COSTS03/23/202003/23/2020$1,001 - $15,0001.00COST0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
21SPdanaher Corporation (dHR) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00DHR0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
22SPdominion Energy, Inc. (d) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00D0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
23SPduke Energy Corporation (duK) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00DUK0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
24SPEdwards Lifesciences Corporation (EW) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
EWS03/23/202003/23/2020$1,001 - $15,0001.00EW0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
25SPEPR Properties (EPR) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
EPRS03/16/202003/19/2020$1,001 - $15,0001.00EPR0.98SellSellSpouseMar 16, 2020$1,001 - $15,000mid $8KStockmodelled
26SPEssex Property Trust, Inc. (ESS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
ESSS03/23/202003/23/2020$1,001 - $15,0001.00ESS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
27SPEversource Energy (ES) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
ESS03/23/202003/23/2020$1,001 - $15,0001.00ES0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
28SPFacebook, Inc. - Class A (Fb) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00META0.92SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
29SPHealthcare Trust of America, Inc. Class A (HTA) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
HTAS03/23/202003/23/2020$1,001 - $15,0001.00—0.60SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockReviewnot modelled
30SPHome depot, Inc. (Hd) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00HD0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
31SPIntel Corporation (INTC) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
INTCS03/23/202003/23/2020$1,001 - $15,0001.00INTC0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
32SPJohnson & Johnson (JNJ) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
JNJS03/23/202003/23/2020$1,001 - $15,0001.00JNJ0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
33SPJP Morgan Chase & Co. (JPM) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
JPMS03/23/202003/23/2020$1,001 - $15,0001.00JPM0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
34SPKimberly-Clark Corporation (KMb) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00KMB0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
35SPLamar Advertising Company - Class A (LAMR) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
LAMRS03/23/202003/23/2020$1,001 - $15,0001.00LAMR0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
36SPMagna International, Inc. (MgA) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/17/202003/19/2020$1,001 - $15,0001.00MGA0.98SellSellSpouseMar 17, 2020$1,001 - $15,000mid $8KStockmodelled
37SPMastercard Incorporated (MA) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
MAS03/23/202003/23/2020$1,001 - $15,0001.00MA0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
38SPMcdonald's Corporation (MCd) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00MCD0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
39SPMerck & Company, Inc. Common Stock (MRK) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
MRKS03/23/202003/23/2020$1,001 - $15,0001.00MRK0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
40SPMicrosoft Corporation (MSFT) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
MSFTS03/23/202003/23/2020$1,001 - $15,0001.00MSFT0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
41SPMid-America Apartment Communities, Inc. (MAA) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
MAAS03/23/202003/23/2020$1,001 - $15,0001.00MAA0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
42SPNational Retail Properties (NNN) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
NNNS03/23/202003/23/2020$1,001 - $15,0001.00NNN0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockReviewmodelled
43SPNextEra Energy, Inc. (NEE) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
NEES03/23/202003/23/2020$1,001 - $15,0001.00NEE0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
44SPPaychex, Inc. (PAYX) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
PAYXS03/23/202003/23/2020$1,001 - $15,0001.00PAYX0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
45SPPepsico, Inc. (PEP) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
PEPS03/23/202003/23/2020$1,001 - $15,0001.00PEP0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
46SPPNC Financial Services group, Inc. (PNC) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
PNCS03/17/202003/19/2020$1,001 - $15,0001.00PNC0.98SellSellSpouseMar 17, 2020$1,001 - $15,000mid $8KStockmodelled
47SPProcter & gamble Company (Pg) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00PG0.95SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
48SPProLogis, Inc. (PLd) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00PLD0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
49SPPrudential Financial, Inc. (PRu) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/13/202003/19/2020$1,001 - $15,0001.00PRU0.98SellSellSpouseMar 13, 2020$1,001 - $15,000mid $8KStockmodelled
50SPPultegroup, Inc. (PHM) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
PHMS03/23/202003/23/2020$1,001 - $15,0001.00PHM0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
51SPSysco Corporation (SYY) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
SYYS03/16/202003/19/2020$1,001 - $15,0001.00SYY0.98SellSellSpouseMar 16, 2020$1,001 - $15,000mid $8KStockmodelled
52SPThermo Fisher Scientific Inc (TMO) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
TMOS03/23/202003/23/2020$1,001 - $15,0001.00TMO0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
53SPT-Mobile uS, Inc. (TMuS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00TMUS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
54SPTrane Technologies plc (TT) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
TTS03/23/202003/23/2020$1,001 - $15,0001.00TT0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
55SPunion Pacific Corporation (uNP) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/17/202003/19/2020$1,001 - $15,0001.00UNP0.98SellSellSpouseMar 17, 2020$1,001 - $15,000mid $8KStockmodelled
56SPunitedHealth group Incorporated Common Stock (uNH) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00UNH0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
57SPVerizon Communications Inc. (VZ) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
VZS03/23/202003/23/2020$1,001 - $15,0001.00VZ0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
58SPVisa Inc. (V) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
VS03/23/202003/23/2020$1,001 - $15,0001.00V0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
59SPW. P. Carey Inc. REIT (WPC) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
WPCS03/23/202003/23/2020$1,001 - $15,0001.00WPC0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
60SPWalmart Inc. (WMT) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
WMTS03/23/202003/23/2020$1,001 - $15,0001.00WMT0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
61SPWalt disney Company (dIS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
—S03/23/202003/23/2020$1,001 - $15,0001.00DIS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
62SPXcel Energy Inc. (XEL) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
XELS03/23/202003/23/2020$1,001 - $15,0001.00XEL0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled
63SPZoetis Inc. Class A (ZTS) [ST]
other: F ILINg S TATuS : New S ubHOLdINg O F : John Marshall Collins Rollover IRA | filing_status: New
ZTSS03/23/202003/23/2020$1,001 - $15,0001.00ZTS0.98SellSellSpouseMar 23, 2020$1,001 - $15,000mid $8KStockmodelled