Detailed value distributions and statistics for each field in the filings endpoint.
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Firm CRD number tied to the filing. | integer | ?crd_number=eq.801234 | 100.0% | 27,099 of 27,099 | 16,267 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| UUID for the uploaded brochure record. | uuid | ?document_id=eq.<uuid> | 100.0% | 27,099 of 27,099 | 27,099 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Brochure title from the SEC payload. | text | ?document_title=ilike.brochure | 100.0% | 27,090 of 27,099 | 15,778 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| JSON array of extracted brochure snippets. | jsonb | ?extracts=not.is.null | 89.4% | 24,213 of 27,099 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| PDF size in bytes. | bigint | ?file_size_bytes=gte.200000 | 0.0% | 0 of 27,099 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Date the brochure was filed. | date | ?filing_date=eq.2025-09-30 | 100.0% | 27,099 of 27,099 | 254 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| SEC Form ADV filing identifier. | text | ?filing_id=eq.1234567 | 100.0% | 27,099 of 27,099 | 23,532 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Month bucket for reporting (first day of month). | date | ?filing_month=eq.2025-09-01 | 100.0% | 27,099 of 27,099 | 9 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Type of filing (currently adv_part2). | text | ?filing_type=eq.adv_part2 | 100.0% | 27,099 of 27,099 | 1 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Primary key of the firm in api.firms. | uuid | ?firm_id=eq.<uuid> | 96.1% | 26,038 of 27,099 | 15,832 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| JSON object of latest LLM insights by item key. | jsonb | ?insights ? item_8_methods_strategy | 73.6% | 19,955 of 27,099 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Permanent Supabase URL for the PDF. | text | ?public_url=not.is.null | 0.0% | 0 of 27,099 | 0 |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Sequence number when multiple brochures exist per filing. | integer | ?sequence_number=eq.1 | 100.0% | 27,099 of 27,099 | 95 |
