Scrape and Query Brazilian Notary Public Auctioneer Data
Scrapes and serves public auctioneer registry data from all 27 Brazilian state commercial boards.
Why it matters
Automate the collection, storage, and querying of official auctioneer data from all 27 Brazilian Commercial Boards. Access this comprehensive dataset via a REST API or export it in CSV/JSON formats.
Outcomes
What it gets done
Scrape auctioneer data from 27 Brazilian Commercial Boards.
Store scraped data in a local SQLite database.
Provide a FastAPI REST API for data querying.
Export data in CSV and JSON formats.
Install
Add it to your toolbox
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/ag-junta-leiloeiros | bash Overview
Skill: Leiloeiros das Juntas Comerciais do Brasil
Collects and serves public auctioneer registry data from all 27 Brazilian state commercial boards, persisted to SQLite with a FastAPI REST layer and CSV/JSON export. Use it when looking up officially registered auctioneers by state, name, or status, or building on that public registry data via API.
What it does
Collects and queries public data on officially registered auctioneers (leiloeiros) from all 27 Brazilian state commercial boards (Juntas Comerciais), via a multi-state scraper, persisting results into a local SQLite database with a FastAPI REST layer and CSV/JSON export. Five states - SP, RJ, MG, CE, and DF - have dedicated scraper implementations; the remaining 22 states run through a shared generic scraper. Collection runs via a CLI script covering all 27 states or a specific subset, with a dry-run mode to preview what would be collected without executing, and configurable concurrency, 5 by default.
python C:\Users\renat\skills\junta-leiloeiros\scripts\run_all.py --estado SP RJ MG
The REST API exposes endpoints to list auctioneers filtered by state, status, or name, search by free text, get aggregate statistics, and export to JSON or CSV, with interactive docs served locally. Data can also be queried directly via a small Python Database class (get_all, search, get_stats) or raw SQL against the SQLite file. Adding a custom scraper for a state needing special handling, such as a JavaScript-heavy site, means subclassing AbstractJuntaScraper, implementing parse_leiloeiros, and registering it in the scrapers registry.
When to use - and when NOT to
Use it when looking up officially registered auctioneers by state, name, or status across Brazil's commercial-board registries, or building on top of that public registry data via API or direct database access.
Inputs and outputs
Input: a state code, or all 27, a name or status filter for lookups, or a custom-scraper implementation for a state needing special handling. Output: a populated local SQLite database, JSON or CSV exports, and REST API responses for auctioneer records and aggregate statistics.
Integrations
Runs on Playwright, installed separately for JavaScript-heavy state sites, for scraping, SQLite for storage, and FastAPI for the REST layer. Delegates to sibling skills leiloeiro-avaliacao, leiloeiro-edital, leiloeiro-ia, leiloeiro-juridico, and leiloeiro-mercado for adjacent auctioneer-domain analysis.
Who it's for
Developers or researchers needing structured, queryable data on Brazil's officially registered auctioneers instead of manually checking 27 separate state commercial-board websites.
Every collection run is logged to a JSON scraping log, and the project ships reference files documenting each of the 27 juntas' source URLs and current scraper status, the SQLite schema, and the legal basis for collecting this public registry data in the first place. A per-state summary is available directly from the database module, and the same counts can be pulled with a raw SQL query grouping records by state.
FAQ
Common questions
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.