How I Turned the SAM.gov Public Bulk Dataset Into a Searchable Contractor Database

Описание и применение

Создан локальный компилятор, позволяющий быстро и повторяемо фильтровать большой набор данных SAM.gov по NAICS, географии, статусу малого бизнеса и другим критериям, экспортируя результаты в Excel/CSV без зависимости от API.

Задача

Researchers and analysts need to filter the large SAM.gov public bulk dataset by criteria such as NAICS code, geography, small‑business status, CAGE availability, and more, but existing solutions rely on APIs, commercial platforms, or complex scripting.

Результат

The compiler enables rapid, repeatable filtering of the SAM.gov dataset locally, producing clean, export‑friendly Excel/CSV files without API dependencies, suitable for analysts and developers.

Рабочий процесс

• Download SAM.gov public bulk extract
• Run the SAM.gov Public Contractor & NAICS Database Compiler (Windows EXE or Python/BAT)
• Select desired filters (status, NAICS, state, small‑business, CAGE, website, etc.)
• Choose output mode (registration‑level or entity‑level)
• Export to Excel or CSV
• Use exported data for research or downstream workflows

Доказательства

The workflow does not depend on repeatedly calling an external API just to filter data that already exists in a downloadable public dataset.

Источник

The product includes a standalone Windows EXE, but I also wanted a Python/BAT version available.

Источник