Aletheus · ask the archive

Ask the roster archive.

One question in ordinary words, answered from the SEC’s public Form ADV adviser rosters — 197 monthly snapshots spanning 2006 to 2026, about 2.48 million firm-rows across 34,213 distinct firms — or refused by name, with the list of question shapes that would have worked. The answering layer holds a fixed set of shapes; a question that fits none of them is declined rather than guessed at.

Try: find goldman sachs · tell me about firm 361 · when did crd 7506 leave · what aum did crd 361 report · how many advisers in november 2013 · list the snapshots · what can you answer

You asked: “list the snapshots”

The archive’s roster files

snapshots
roster datefirmssource file
2006-06-05105442199190_10044_00050000_00050000.txt
2007-05-07105403269464_10044_00050000_00050000.txt
2007-07-30107193563054_10044_00050000_00050000.txt
2007-09-12107823723205_10044_00050000_00050000.txt
2007-10-26108523886417_10044_00050000_00050000.txt
2007-11-29108874006782_10044_00050000_00050000.txt
2008-01-07108674136951_10044_00050000_00050000.txt
2008-02-01109234228370_10044_00050000_00050000.txt
2008-03-03109714336204_10044_00050000_00050000.txt
2008-04-01109914438816_10044_00050000_00050000.txt
2008-06-02111384654254_10044_00050000_00050000.txt
2008-07-01111924761516_10044_00050000_00050000.txt
2008-08-04112454900533_10044_00050000_00050000.txt
2008-09-02112685010912_10044_00050000_00050000.txt
2008-10-01112945123851_10044_00050000_00050000.txt
2008-12-09113505394982_10044_00050000_00050000.csv
2009-01-0511274ia010509.csv
2009-02-0211272FOIA report 2009-2-2.csv
2009-03-0211290FOIA Download 2009-3-2.csv
2009-04-01112532009-4-1 FOIA IA Download.csv
2009-05-0111283FOIA download.csv
2009-06-0111309IA FOIA Download 6-1-09.csv
2009-07-0111340IA FOIA Download 7-1-09.csv
2009-08-0111371FOIA Download 8-1-09.csv
2009-09-01113992009-9-1 FOIA Report.csv
2009-10-0111452FOIA IA Download 10-1-2009.csv
2009-11-0211503FOIA IA Download 11-2-09.CSV
2009-12-01115432009-12-1 IA FOIA Download.CSV
2010-01-04114882010-1-4 IA FOIA Download.CSV
2010-02-0111554IA FOIA Download 2-1-10.CSV
2010-03-0111597IA FOIA Download 3-1-10.CSV
2010-04-0111607IA FOIA Download 4-1-2010.CSV
2010-05-0311658IA FOIA Download 5-3-10.CSV
2010-06-0211719FOIA Download 6-1-10.CSV
2010-07-0111797FOIA IA Download 7-1-2010.CSV
2010-07-3011837IA FOIA Download 7-30-10.CSV
2010-09-0111867IA FOIA Download 09-01-10.CSV
2010-10-0111888IA FOIA Download 10-1-2010.CSV
2010-11-0111889IA FOIA Download 2010-11-1.CSV
2010-12-0111895IA FOIA Download 12-2010.CSV
2011-01-0311794IA FOIA Download 2011-1.CSV
2011-02-0111832IA FOIA Download 2011-2-1.CSV
2011-03-0111692IA FOIA Download 2011-3-1.CSV
2011-04-0111505ia040111.CSV
2011-05-0111539IA FOIA Download 5-1-2011.CSV
2011-06-0111558IA FOIA Download 6-2011.CSV
2011-07-0111602ia070111.CSV
2011-08-0111645IA FOIA Download 2011-8-1.csv
2011-08-2611660IA FOIA download 8-26-2011.csv
2011-10-0311702IA FOIA Download 10-2011.xlsx
2011-11-0111737IA FOIA Download 2011-11-1.xlsx
2011-12-0111728Adviser Public Download 12-2011.xlsx
2012-01-0111658Adviser Public Download 2012-1-3.xlsx
2012-02-01116852012-2-1 Registered Adviser Public Report.xlsx
2012-03-01117712012-3-1 Registered Adviser Public Report.xlsx
2012-04-01126222012-4-2 Registered Adviser Public Report.xlsx
2012-05-0112598SEC Registered Adviser Report 5-1-2012.xlsx
2012-06-0112476SEC Registered Adviser Report 6-1-2012.xlsx
2012-07-0211622SEC Registered Adviser Report 7-2-2012.xlsx
2012-08-0111308SEC Registered Advisers Report 8-1-2012.xlsx
2012-09-0111144ia090112.xlsx
2012-10-0111002SEC Registered Investment Adviser Report 2012-10-1.xlsx
2012-11-0110891SEC Registered Investment Adviser Report 2012-11-1.xlsx
2012-12-0310870SEC Registered Investment Adviser Report 2012-12-3.xlsx
2013-01-0210754SEC Registered Investment Adviser Report 2013-1-2.xlsx
2013-02-0110773SEC Registered Investment Adviser Report 2013-2-1.xlsx
2013-03-0110643SEC Registered Investment Adviser Report 2013-3-1.xlsx
2013-04-0110615SEC Registered Investment Adviser Report 2013-4-1.xlsx
2013-05-0110681SEC Registered Investment Adviser Report 2013-5-1.xlsx
2013-06-0310719SEC Registered Investment Adviser Report 2013-6-3.xlsx
2013-07-0110773SEC Registered Investment Adviser Report 2013-7-1.xlsx
2013-08-0110825SEC Registered Investment Adviser Report 2013-8-1.xlsx
2013-09-0310856ia090313.xlsx
2013-10-0110899SEC Registered Investment Adviser Report 2013-10-1.xlsx
2013-11-0110905SEC Registered Investment Adviser Report 2013-11-1.xlsx
2013-12-0210946SEC Registered Investment Adviser Report 2013-12-2.xlsx
2014-01-0210920SEC Registered Investment Adviser Report 2014-1-2.xlsx
2014-02-0311012SEC Registered Investment Adviser Report 2014-2-3.xlsx
2014-03-0411055SEC Registered Investment Adviser Report 2014-3-4.xlsx
2014-04-0111023SEC Registered Investment Adviser Report 2014-4-1.xlsx
2014-05-0111170SEC Registered Investment Adviser Report 2014-5-1.xlsx
2014-06-0211235SEC Registered Investment Adviser Report 2014-6-2.xlsx
2014-07-0111324SEC Registered Investment Adviser Report 2014-7-1.xlsx
2014-08-0111405SEC Registered Investment Adviser Report 2014-8-1.xlsx
2014-09-0211438SEC Registered Investment Adviser Report 2014-9-2.xlsx
2014-10-0111474SEC Registered Investment Adviser Report 2014-10-1.xlsx
2014-11-0311506SEC Registered Investment Adviser Report 2014-11-3.xlsx
2014-12-0111508ia120114.xlsx
2015-01-0211508SEC Registered Investment Adviser Report 2015-1-2.xlsx
2015-02-0211611SEC Registered Investment Adviser Report 2015-2-2.xlsx
2015-03-0211639SEC Registered Investment Adviser Report 2015-3-2.xlsx
2015-04-0111615SEC Registered Investment Adviser Report 2015-4-1.xlsx
2015-05-0111702SEC Registered Investment Adviser Report 2015-5-1.xlsx
2015-06-0111765SEC Registered Investment Adviser Report 2015-06-01.xlsx
2015-07-0111820SEC Registered Investment Adviser Report 2015-7-1.xlsx
2015-08-0311918SEC Registered Investment Adviser Report 2015-08-03.xlsx
2015-09-0111947SEC Registered Investment Adviser Report 2015-9-1.xlsx
2015-10-0111986SEC Registered Investment Adviser Report 2015-10-1.xlsx
2015-11-0212013SEC Registered Investment Adviser Report 2015-11-2.xlsx
2015-12-0112026SEC Registered Investment Adviser Report 2015-12-1.xlsx
2016-01-0411956SEC Registered Investment Adviser Report 2016-1-4.xlsx
2016-02-0111958SEC Registered Investment Adviser Report 2016-2-1.xlsx
2016-03-0111987SEC Registered Investment Adviser Report 2016-3-1.xlsx
2016-04-0111967SEC Registered Investment Adviser Report 2016-4-1.xlsx
2016-05-0212025SEC Registered Investment Adviser Report 2016-5-2.xlsx
2016-06-0112055SEC Registered Investment Adviser Report 2016-6-1.xlsx
2016-07-0112091SEC Registered Investment Adviser Report 2016-7-1.xlsx
2016-08-0112137ia080116.xlsx
2016-09-0112160ia090116.xlsx
2016-10-0312201SEC Registered Investment Adviser Report 2016-10-3.xlsx
2016-11-0112234SEC Registered Investment Adviser Report 2016-11-1.xlsx
2016-12-0112241ia120116.xlsx
2017-01-0312176SEC Registered Investment Adviser Report 2017-1-3.xlsx
2017-02-0112258ia020117.xlsx
2017-03-0112286ia030117.xlsx
2017-04-0112276ia040117.xlsx
2017-05-0112378ia050117.xlsx
2017-06-0112412ia060117.xlsx
2017-06-3012438ia063017.xlsx
2017-08-0112505SEC Registered Investment Adviser Report 2017-8-1.xlsx
2017-09-0112559SEC Registered Investment Adviser Report 2017-9-1.xlsx
2017-10-0212616SEC Registered Investment Adviser Report 2017-10-2.xlsx
2017-11-0112700SEC Registered Investment Adviser Report 2017-11-1.xlsx
2017-12-0112693SEC Registered Investment Adviser Report 2017-12-1.xlsx
2018-01-0112659ia010118.xlsx
2018-02-0112693ia020118.xlsx
2018-03-0112728ia030118.xlsx
2018-04-0212643ia040218.xlsx
2018-05-0112821SEC Registered Investment Adviser Report 2018-5-1.xlsx
2018-06-0112948SEC Registered Investment Adviser Report 2018-6-1.xlsx
2018-07-0213012SEC Registered Investment Adviser Report 2018-7-2.xlsx
2018-08-0113127SEC Registered Investment Adviser Report 2018-8-1.xlsx
2018-09-0413181ia090418.xlsx
2018-10-0113222SEC Registered Investment Adviser Report 2018-10-1.xlsx
2018-11-0113250SEC Registered Investment Adviser Report 2018-11-1.xlsx
2018-12-0313266SEC Registered Investment Adviser Report 2018-12-3.xlsx
2019-02-0113214SEC Registered Investment Adviser Report 2019-2-1.xlsx
2019-03-0113226ia030119.xlsx
2019-04-0113173ia040119.xlsx
2019-05-0113198ia050119.xlsx
2019-06-0313270SEC Registered Investment Adviser Report 2019-06-03.xlsx
2019-07-0113285SEC Registered Investment Adviser 2019-7-1.xlsx
2019-08-0113374SEC Registered Investment Adviser Report 2019-8-1.xlsx
2019-10-0113458SEC Registered Investment Adviser Report 2019-10-1.xlsx
2019-11-0113475ia110119.xlsx
2019-12-0213506SEC Registered Investment Adviser Report 2019-12-2.xlsx
2020-01-0213479ia010220.xlsx
2020-02-0313521SEC Registered Investment Adviser Report 2020-02-03.xlsx
2020-03-0213528ia030220.xlsx
2020-04-0113515ia040120.xlsx
2020-05-0113606ia050120.xlsx
2020-06-0113650ia060120.xlsx
2020-07-0113647ia070120.xlsx
2020-08-0313724ia080320.xlsx
2020-09-0213765ia090220.xlsx
2020-10-0113810ia100120.xlsx
2020-11-0213847ia110220.xlsx
2020-12-0213903ia120220.xlsx
2021-01-0513906ia010521.xlsx
2021-02-0113935ia020121.xlsx
2021-03-0113981ia030121.xlsx
2021-04-0513974ia040521.CSV
2021-05-0314150ia050321.csv
2021-06-0114240ia060121.csv
2021-07-0114381ia070121.csv
2021-08-0214543ia080221.csv
2021-09-0114638ia090121.csv
2021-10-0414723ia100421.csv
2021-11-0114777ia110121.csv
2021-12-0114835ia120121.csv
2022-01-0314811ia010322.csv
2022-02-0714840ia020722.csv
2022-03-0114874ia030122.csv
2022-04-0114889ia040122.csv
2022-05-0215028ia050222.csv
2022-06-0115129ia060122.csv
2022-07-0115167ia070122.csv
2022-08-0115292ia080122.csv
2022-09-0115362ia090122.csv
2022-10-0315419ia100322.csv
2022-11-0715423SEC Registered Investment Adviser Report 2022-11-7.xlsx
2022-12-0115444ia120122.xlsx
2023-01-0515399SEC Registered Investment Adviser Report 2023-1-5.xlsx
2023-02-0315412ia020323.xlsx
2023-03-0215403ia030223.xlsx
2023-04-0415300ia040423.xlsx
2023-05-1015345ia051023.xlsx
2025-01-0215941ia010225.xlsx
2025-12-2016484IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34319031.CSV
2026-01-0216475IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34445671.CSV
2026-02-0216558IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34537693.CSV
2026-03-0216606IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34553767.CSV
2026-04-0116621IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34572290.CSV
2026-05-0116779IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34589820.CSV
2026-06-0116876IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34605791.CSV
2026-07-0116935IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34622660.CSV
2026-08-0317018IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34640308.CSV
2026-09-0117149IA_SEC_-_FIRM_ROSTER_FOIA_DOWNLOAD_-_34655879.CSV
2026-10-0217210ia09012026.csv
count
199
row order
chronological
reading it
Each row is one published SEC roster file and the number of firms it listed — the provenance of every other answer here.
coverage note
The archive is twenty years of SPAN, not monthly density: 5 snapshots in 2023, none at all in 2024, 2 in 2025 — the SEC's own publication transition. The 2019-01-01 file was never published into this archive.

Archive: 199 roster snapshots, 2006-06-05 to 2026-10-02; the latest lists 17210 firms (ia09012026.csv). Every answer describes the archive as of the latest snapshot above. A firm that registered or deregistered since is not in it yet.

Source, limits, and what this archive cannot show

source

dataset
SEC Form ADV investment-adviser firm roster
publisher
U.S. Securities and Exchange Commission
retrieved from
https://adviserinfo.sec.gov/ (IAPD), monthly published roster files
redistribution
Works of the United States Government carry no U.S. copyright (17 U.S.C. 105(a)). These roster files were served to the public, free of charge, by the SEC's own public website. Cite the SEC as the source. No SEC seal, logo or artwork is reproduced here, and IARD is a registered service mark of its owner.
what it is
One row per firm per monthly roster snapshot, as filed. Nothing here is computed, weighted, scored or ranked.

limits

max firms per answer
25
min name query characters
3
fields never served
  • discipline_any
  • discipline_kinds
  • phone
ordering
Results are returned in a fixed identifier order. Nothing on this surface is ranked, scored, sorted by any measure of a firm, or presented as a comparison.
paging
None. No cursor, offset or page parameter exists, so there is no way to walk past the cap.

cannot show

What this archive CANNOT show: it is a registration roster, not a conduct record. It does not show what any firm or person did, whether anyone was harmed, whether a complaint was ever made, what a firm charged, or anything about any individual representative. A firm leaving the roster is ordinary — an acquisition, or a move to state registration below the SEC threshold — and is not evidence of anything by itself.

retrieved

2026-10-16

Answers come from public SEC records. They describe what was filed, not whether anyone did anything wrong, and they are not legal advice. Automated retrieval and analysis may be inaccurate or incomplete — verify against the cited source documents before relying on any answer.

What this page answers: finding a firm by name, CRD, CIK or SEC file number; one firm’s roster record, its span across the rosters, and its own reported AUM and accounts over time; how many advisers a named snapshot lists; and the archive’s own provenance — every roster file with its date and source filename. What it refuses, always: anything ordered by a measure of a firm, anything about discipline or conduct, anything about an individual person, any cause or reason for a change, and any answer bigger than twenty-five firms. A misspelled firm name comes back with up to five similar names drawn from the archive’s own index, for you to re-ask — never a corrected search run on your behalf, and never a ranking.

Answers come from public SEC records. They describe what was filed, not whether anyone did anything wrong, and they are not legal advice. Automated retrieval and analysis may be inaccurate or incomplete — verify anything that matters against the cited source documents before relying on any answer. The archive is a registration roster, not a conduct record: a firm leaving it is ordinary, and is not evidence of anything by itself.