Datamule XML Tables

• Requires a SEC XML Tables subscription.
• Every SEC XML file converted to columnar format.
• Datasets updated daily.

> Instant will be coming soon.

Usage

SEC XML Tables includes 110+ tables converted from SEC XML filings, including insider transactions, institutional holdings, proxy voting records, Form D, 13F filings, and other XML-based SEC forms.

Query Database

Use datamulehub.databases.query when you want Athena to run SQL and write the result as Parquet files.

Single-table example:

from datamulehub import databases

databases.query(
    """
    SELECT
        accessionnumber,
        filingdate,
        transactiondatevalue,
        transactioncode,
        transactionsharesvalue,
        transactionpricepersharevalue
    FROM "345_non_derivative_transaction"
    WHERE filingdate >= '2024-01-01'
    LIMIT 100
    """,
    output_dir="insider_transactions_sample",
)

This writes one or more Parquet files to insider_transactions_sample.

You can also join related XML tables. For example, this joins Form 3/4/5 metadata, reporting owners, and non-derivative transactions:

from datamulehub import databases

databases.query(
    """
    SELECT
        m.accessionnumber,
        m.filingdate,
        m.issuername,
        m.issuertradingsymbol,
        o.rptownername,
        o.rptownercik,
        t.transactiondatevalue,
        t.transactioncode,
        t.transactionsharesvalue,
        t.transactionpricepersharevalue
    FROM "345" m
    JOIN "345_reporting_owner" o
      ON m.accessionnumber = o.accessionnumber
    JOIN "345_non_derivative_transaction" t
      ON m.accessionnumber = t.accessionnumber
    WHERE m.issuertradingsymbol = 'TSLA'
      AND m.filingdate >= '2024-01-01'
    LIMIT 1000
    """,
    output_dir="tsla_insider_transactions",
)

Read Query

Use datamulehub.databases.read_query when you want the query result back in Python instead of keeping the Parquet files.

from datamulehub import databases

rows = databases.read_query(
    """
    SELECT
        accessionnumber,
        filingdate,
        transactiondatevalue,
        transactioncode,
        transactionsharesvalue
    FROM "345_non_derivative_transaction"
    WHERE filingdate >= '2024-01-01'
    LIMIT 10
    """
)

print(rows)

read_query downloads the Parquet result files to a temporary directory, reads them, and returns the rows.

Download Dataset

Use datamulehub.datasets.download when you want the full dataset for a table.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_non_derivative_transaction",
    filename="345_non_derivative_transaction.parquet",
)

This downloads the complete Parquet dataset for that table.

Tables

13fhr

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/13fhr",
    filename="13fhr.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "13fhr"
    LIMIT 10
    """,
    output_dir="13fhr_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | additionalinformation | | amendmentno | | amendmenttype | | city | | confdeniedexpired | | confirmingcopyflag | | crdnumber | | datedeniedexpired | | datereported | | denovorequest | | filenumber | | filerccc | | filercik | | filingmanagername | | form13ffilenumber | | isamendment | | isconfidentialomitted | | livetestflag | | otherincludedmanagerscount | | overrideinternetflag | | periodofreport | | provideinfoforinstruction5 | | reasonfornonconfidentiality | | reportcalendarorquarter | | reporttype | | returncopyflag | | schemaversion | | secfilenumber | | signature | | signaturecity | | signaturedate | | signaturename | | signaturephone | | signaturestateorcountry | | signaturetitle | | stateorcountry | | street1 | | street2 | | submissiontype | | tableentrytotal | | tablevaluetotal | | zipcode |

13fhr_other_manager

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/13fhr_other_manager",
    filename="13fhr_other_manager.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "13fhr_other_manager"
    LIMIT 10
    """,
    output_dir="13fhr_other_manager_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cik | | crdnumber | | form13ffilenumber | | name | | secfilenumber |

13fhr_other_manager2

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/13fhr_other_manager2",
    filename="13fhr_other_manager2.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "13fhr_other_manager2"
    LIMIT 10
    """,
    output_dir="13fhr_other_manager2_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cik | | crdnumber | | form13ffilenumber | | name | | secfilenumber | | sequencenumber |

1_k

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1-K",
    filename="1_k.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1_k"
    LIMIT 10
    """,
    output_dir="1_k_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | confirmingcopyflag | | filenumber | | filerccc | | filercik | | fiscalyearend | | formindication | | issuedsecuritiestitle | | livetestflag | | overrideinternetflag | | phonenumber | | regarule257 | | reportingperiod | | returncopyflag | | shellcompanyflag | | stateorcountry | | street1 | | street2 | | submissiontype | | successorfilingflag | | zipcode |

1_z

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1-z",
    filename="1_z.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1_z"
    LIMIT 10
    """,
    output_dir="1_z_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | approxrecordholders | | auditorfees | | auditorspname | | blueskyfees | | blueskyspname | | certificationfilenumber | | city | | clarificationresponses | | commissionfilenumber | | confirmingcopyflag | | crdnumberbrokerdealer | | filenumber | | filerccc | | filercik | | findersfees | | findersspname | | issuername | | issuernetproceeds | | legalfees | | legalspname | | livetestflag | | offeringcommencedate | | offeringqualificationdate | | offeringsecuritiesqualifiedsold | | offeringsecuritiessold | | overrideinternetflag | | phone | | portionsecuritiessoldissuer | | portionsecuritiessoldsecurityholders | | pricepersecurity | | promoterspname | | promotersfees | | returncopyflag | | salescommissionsfee | | salescommissionsspname | | securitiesclasstitle | | stateorcountry | | street1 | | street2 | | submissiontype | | successorfilingflag | | underwriterfees | | underwrittenspname | | zipcode |

1a

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a",
    filename="1a.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a"
    LIMIT 10
    """,
    output_dir="1a_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | accountspayable | | accountsreceivable | | auditorfees | | auditorserviceprovidername | | blueskyfees | | blueskyserviceprovidername | | brokerdealercrdnumber | | cashequivalents | | certifyifbadactor | | certifyifnotdisqualified | | certifyiftrue | | city | | clarificationresponses | | concurrentofferingaggregate | | connectionname | | costandexpensesappltorevenues | | deposits | | depreciationandamortization | | earningspersharebasic | | earningspersharediluted | | estimatednetamount | | filerccc | | filercik | | financialstatementauditstatus | | finderfeesfee | | findersfeesserviceprovidername | | ifunregisterednone | | indicatetier1tier2offering | | industrygroup | | investmentsecurities | | issueraggregateoffering | | jurisdictionsofsecofferednone | | jurisdictionsofsecofferedsame | | legalfees | | legalserviceprovidername | | livetestflag | | loans | | longtermdebt | | nameauditor | | netincome | | offerdelayedcontinuousflag | | offeringafterqualifflag | | offeringbesteffortsflag | | offeringfilenumber | | offeringyearflag | | outstandingsecurities | | overrideinternetflag | | phonenumber | | policyliabilitiesandaccruals | | pricepersecurity | | promotersfees | | promotersserviceprovidername | | propertyandequipment | | propertyplantequipment | | qualificationofferingaggregate | | resalesecuritiesaffiliatesflag | | returncopyflag | | salescommissionsserviceproviderfees | | salescommissionsserviceprovidername | | securitiesactexemption | | securitiesoffered | | securitiesofferedotherdesc | | securityholderaggregate | | sincelastfiling | | solicitationproposedofferingflag | | stateorcountry | | street1 | | street2 | | submissiontype | | totalaggregateoffering | | totalassets | | totalinterestexpenses | | totalinterestincome | | totalinvestments | | totalliabilities | | totalliabilitiesandequity | | totalrevenues | | totalstockholderequity | | underwritersfees | | underwritersserviceprovidername | | zipcode |

1a_co_filer

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_co_filer",
    filename="1a_co_filer.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_co_filer"
    LIMIT 10
    """,
    output_dir="1a_co_filer_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | coissuerccc | | coissuercik | | coissuerfilenumber |

1a_common_equity

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_common_equity",
    filename="1a_common_equity.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_common_equity"
    LIMIT 10
    """,
    output_dir="1a_common_equity_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | commoncusipequity | | commonequityclassname | | outstandingcommonequity | | publiclytradedcommonequity |

1a_dealers_jurisdiction

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_dealers_jurisdiction",
    filename="1a_dealers_jurisdiction.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_dealers_jurisdiction"
    LIMIT 10
    """,
    output_dir="1a_dealers_jurisdiction_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | dealersjurisdiction |

1a_debt_securities

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_debt_securities",
    filename="1a_debt_securities.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_debt_securities"
    LIMIT 10
    """,
    output_dir="1a_debt_securities_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusipdebtsecurities | | debtsecuritiesclassname | | outstandingdebtsecurities | | publiclytradeddebtsecurities |

1a_employees_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_employees_info",
    filename="1a_employees_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_employees_info"
    LIMIT 10
    """,
    output_dir="1a_employees_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | fulltimeemployees | | irsnum | | issuercik | | issuername | | jurisdictionorganization | | parttimeemployees | | siccode | | yearincorporation |

1a_issue_jurisdiction

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_issue_jurisdiction",
    filename="1a_issue_jurisdiction.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_issue_jurisdiction"
    LIMIT 10
    """,
    output_dir="1a_issue_jurisdiction_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | issuejurisdiction |

1a_preferred_equity

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_preferred_equity",
    filename="1a_preferred_equity.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_preferred_equity"
    LIMIT 10
    """,
    output_dir="1a_preferred_equity_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | outstandingpreferredequity | | preferredcusipequity | | preferredequityclassname | | publiclytradedpreferredequity |

1a_securities_issued

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_securities_issued",
    filename="1a_securities_issued.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_securities_issued"
    LIMIT 10
    """,
    output_dir="1a_securities_issued_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregateconsiderationbasis | | securitiesissuedaggregateamount | | securitiesissuedtotalamount | | securitiesissuername | | securitiesissuertitle | | securitiesprincipalholderamount |

1a_securities_offered_types

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1a_securities_offered_types",
    filename="1a_securities_offered_types.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1a_securities_offered_types"
    LIMIT 10
    """,
    output_dir="1a_securities_offered_types_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | securitiesofferedtypes |

1k_item1_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1k_item1_info",
    filename="1k_item1_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1k_item1_info"
    LIMIT 10
    """,
    output_dir="1k_item1_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | irsnum | | issuercik | | issuername | | jurisdictionorganization |

1k_summary_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1k_summary_info",
    filename="1k_summary_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1k_summary_info"
    LIMIT 10
    """,
    output_dir="1k_summary_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregrateofferingprice | | aggregrateofferingpriceholders | | auditorfees | | auditorspname | | blueskyfees | | blueskyspname | | clarificationresponses | | commissionfilenumber | | crdnumberbrokerdealer | | findersfees | | findersspname | | issuernetproceeds | | legalfees | | legalspname | | offeringcommencedate | | offeringqualificationdate | | offeringsecuritiessold | | pricepersecurity | | promoterspname | | promotersfees | | qualifiedsecuritiessold | | salescommissionsfee | | salescommissionsspname | | underwriterfees | | underwrittenspname |

1z_signature_tab

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/1z_signature_tab",
    filename="1z_signature_tab.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "1z_signature_tab"
    LIMIT 10
    """,
    output_dir="1z_signature_tab_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | regulationissuername1 | | regulationissuername2 | | signatureby | | signaturecik | | signaturedate | | signaturetitle |

24f2nt

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/24f2nt",
    filename="24f2nt.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "24f2nt"
    LIMIT 10
    """,
    output_dir="24f2nt_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | confirmingcopyflag | | filenumber | | filerccc | | filercik | | investmentcompanytype | | livetestflag | | overrideinternetflag | | schemaversion | | submissiontype |

24f2nt_annual_filing_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/24f2nt_annual_filing_info",
    filename="24f2nt_annual_filing_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "24f2nt_annual_filing_info"
    LIMIT 10
    """,
    output_dir="24f2nt_annual_filing_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregateredeemedanyprior | | aggregateredeemedinfiscalyear | | aggregatesaleprice | | annualclassid | | annualclassname | | annualclassnameinfoclassname | | city | | classid | | classname | | country | | feemultiplier | | includeallclassesflag | | investmentcompactfileno | | isfiledlate | | islastfiling | | issuername | | item6interestdue | | item7interestdue | | item7totalfeeplusinterest | | item8explanatorynotes | | item8totalfeeplusinterest | | item9explanatorynotes | | lastdayoffiscalyear | | netsales | | redemptioncreditsavailable | | registrationfeedue | | rptincludeallclassesflag | | rptincludeallflag | | rptincludeallseriesflag | | securitiesactfileno | | securitiesdeducted | | seriesid | | seriesname | | seriesorclassid | | sharesremainingunsold | | signature | | signaturedate | | signaturenameandtitle | | state | | street1 | | street2 | | totalredemptioncredits | | zipcode |

25_nse

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/25-NSE",
    filename="25_nse.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "25_nse"
    LIMIT 10
    """,
    output_dir="25_nse_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | descriptionclasssecurity | | exchangecik | | exchangeentityname | | issuercik | | issuerentityname | | issuerfilenumber | | issuertelephonenumber | | ruleprovision | | schemaversion | | signaturedate | | signaturename | | signaturetitle | | stateorcountry | | stateorcountrycode | | street1 | | street2 | | zipcode |

345

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345",
    filename="345.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345"
    LIMIT 10
    """,
    output_dir="345_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aff10b5one | | dateoforiginalsubmission | | documenttype | | form3holdingsreported | | form4transactionsreported | | issuercik | | issuerforeigntradingsymbol | | issuername | | issuertradingsymbol | | nosecuritiesowned | | notsubjecttosection16 | | periodofreport | | remarks | | rptownercountry | | rptownernonusaddressflag | | rptownernonusstateterritory | | schemaversion |

345_derivative_holding

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_derivative_holding",
    filename="345_derivative_holding.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_derivative_holding"
    LIMIT 10
    """,
    output_dir="345_derivative_holding_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | exercisedatevalue | | expirationdatefootnoteidid | | expirationdatevalue | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | securitytitlefootnoteidid | | securitytitlevalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactioncodingfootnoteidid | | transactionformtype | | underlyingsecuritysharesfootnoteidid | | underlyingsecuritysharesvalue | | underlyingsecuritytitlefootnoteidid | | underlyingsecuritytitlevalue | | underlyingsecurityvaluefootnoteidid | | underlyingsecurityvaluevalue | | value | | valueownedfollowingtransactionfootnoteidid | | valueownedfollowingtransactionvalue |

345_derivative_security

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_derivative_security",
    filename="345_derivative_security.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_derivative_security"
    LIMIT 10
    """,
    output_dir="345_derivative_security_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | deemedexecutiondatevalue | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | equityswapinvolved | | exercisedatefootnoteidid | | exercisedatevalue | | expirationdatefootnoteidid | | expirationdatevalue | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | securitytitlefootnoteidid | | securitytitlevalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactionacquireddisposedcodefootnoteidid | | transactionacquireddisposedcodevalue | | transactioncode | | transactioncodingfootnoteidid | | transactiondatefootnoteidid | | transactiondatevalue | | transactionformtype | | transactionsharesfootnoteidid | | transactionsharesvalue | | transactiontimelinessvalue | | transactionvaluefootnoteidid | | transactionvaluevalue | | underlyingsecuritysharesfootnoteidid | | underlyingsecuritysharesvalue | | underlyingsecuritytitlefootnoteidid | | underlyingsecuritytitlevalue | | underlyingsecurityvaluevalue | | value | | valueownedfollowingtransactionvalue |

345_derivative_transaction

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_derivative_transaction",
    filename="345_derivative_transaction.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_derivative_transaction"
    LIMIT 10
    """,
    output_dir="345_derivative_transaction_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | deemedexecutiondatevalue | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | equityswapinvolved | | exercisedatefootnoteidid | | exercisedatevalue | | expirationdatefootnoteidid | | expirationdatevalue | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | securitytitlefootnoteidid | | securitytitlevalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactionacquireddisposedcodefootnoteidid | | transactionacquireddisposedcodevalue | | transactioncode | | transactioncodingfootnoteidid | | transactiondatefootnoteidid | | transactiondatevalue | | transactionformtype | | transactionpricepersharefootnoteidid | | transactionpricepersharevalue | | transactionsharesfootnoteidid | | transactionsharesvalue | | transactiontimelinessfootnoteidid | | transactiontimelinessvalue | | transactiontotalvaluefootnoteidid | | transactiontotalvaluevalue | | underlyingsecuritysharesfootnoteidid | | underlyingsecuritysharesvalue | | underlyingsecuritytitlefootnoteidid | | underlyingsecuritytitlevalue | | underlyingsecurityvaluefootnoteidid | | underlyingsecurityvaluevalue | | value | | valueownedfollowingtransactionfootnoteidid | | valueownedfollowingtransactionvalue |

345_footnote

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_footnote",
    filename="345_footnote.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_footnote"
    LIMIT 10
    """,
    output_dir="345_footnote_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | footnoteid | | footnotetext |

345_non_derivative_holding

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_non_derivative_holding",
    filename="345_non_derivative_holding.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_non_derivative_holding"
    LIMIT 10
    """,
    output_dir="345_non_derivative_holding_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactionformtype | | value | | valueownedfollowingtransactionfootnoteidid | | valueownedfollowingtransactionvalue |

345_non_derivative_security

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_non_derivative_security",
    filename="345_non_derivative_security.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_non_derivative_security"
    LIMIT 10
    """,
    output_dir="345_non_derivative_security_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | equityswapinvolved | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | securitytitlevalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactionacquireddisposedcodefootnoteidid | | transactionacquireddisposedcodevalue | | transactioncode | | transactioncodingfootnoteidid | | transactiondatefootnoteidid | | transactiondatevalue | | transactionformtype | | transactionsharesfootnoteidid | | transactionsharesvalue | | transactiontimelinessvalue | | transactionvaluefootnoteidid | | transactionvaluevalue | | value | | valueownedfollowingtransactionvalue |

345_non_derivative_transaction

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_non_derivative_transaction",
    filename="345_non_derivative_transaction.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_non_derivative_transaction"
    LIMIT 10
    """,
    output_dir="345_non_derivative_transaction_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | directorindirectownershipfootnoteidid | | directorindirectownershipvalue | | equityswapinvolved | | footnoteidid | | id | | natureofownershipfootnoteidid | | natureofownershipvalue | | securitytitlevalue | | sharesownedfollowingtransactionfootnoteidid | | sharesownedfollowingtransactionvalue | | transactionacquireddisposedcodefootnoteidid | | transactionacquireddisposedcodevalue | | transactioncode | | transactioncodingfootnoteidid | | transactiondatefootnoteidid | | transactiondatevalue | | transactionformtype | | transactionpricepersharefootnoteidid | | transactionpricepersharevalue | | transactionsharesfootnoteidid | | transactionsharesvalue | | transactiontimelinessfootnoteidid | | transactiontimelinessvalue | | value | | valueownedfollowingtransactionfootnoteidid | | valueownedfollowingtransactionvalue |

345_owner_signature

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_owner_signature",
    filename="345_owner_signature.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_owner_signature"
    LIMIT 10
    """,
    output_dir="345_owner_signature_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | signaturedate | | signaturename |

345_reporting_owner

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/345_reporting_owner",
    filename="345_reporting_owner.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "345_reporting_owner"
    LIMIT 10
    """,
    output_dir="345_reporting_owner_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | isdirector | | isofficer | | isother | | istenpercentowner | | officertitle | | othertext | | rptownercik | | rptownercity | | rptownername | | rptownerstate | | rptownerstatedescription | | rptownerstreet1 | | rptownerstreet2 | | rptownerzipcode |

ats_n_ua

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ats_n_ua",
    filename="ats_n_ua.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ats_n_ua"
    LIMIT 10
    """,
    output_dir="ats_n_ua_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | affiliatespermittedtoenterinterestrbpart2item2aareafflpermittedtoenterinterest | | cbpart1item8exhibit1atwebsite | | cbpart1item9exhibit2atwebsite | | cbpart3item26iinforqstdundrexbt4avlblatwebst | | cbpart3item26iiinforqstdundrexbt5avlblatwebst | | ccc | | cik | | city | | confirmingcopyflag | | contactemailaddress | | contactname | | contactphonenumber | | coverrboperatespursuanttoformats | | dateceasetooperate | | filenumber | | livetestflag | | mpid | | nmsstockatsname | | overrideinternetflag | | part1item5beffectivemembershipdate | | part2item1aarepermittedtoenterinterestrbpart2item1aarepermittedtoenterinterest | | part2item1baresevicessametoallsubscribersrbpart2item1baresevicessametoallsubscribers | | part2item1baresevicessametoallsubscriberstapart2item2bexplaindiff | | part2item2baresevicestoafflsametosubscribersrbpart2item2baresevicestoafflsametosubscribers | | part2item3acansubscroptoutwithoatiofafflrbpart2item3acansubscroptoutwithoatiofaffl | | part2item3acansubscroptoutwithoatiofbdrbpart2item3acansubscroptoutwithoatiofbd | | part2item3careoptoutsametoallsubscribersrbpart2item3careoptoutsametoallsubscribers | | part2item4aaretherearrangementsbtwbdandtcrbpart2item4aaretherearrangementsbtwbdandtc | | part2item5baresevicessametoallsubscribersandbdrbpart2item5baresevicessametoallsubscribersandbd | | part2item6cdoesserviceprovideruseatsservicesrbpart2item6cdoesserviceprovideruseatsservices | | part2item7bcansubscriberconsenttodisclosurerbpart2item7bcansubscriberconsenttodisclosure | | part3item11bmeansfeciltsdtlsrbpart3item11bismeansfeciltssameforall | | part3item11ddiffdtlsrbpart3item11disprocsrulssameforall | | part3item13asegmntdtlsrbpart3item13aisordrtisegmntd | | part3item13bsegmntdtlsrbpart3item13bissegmntatnsameforall | | part3item13earngmntdtlsrbpart3item13eisdsclosrsameforall | | part3item14bselectdtlsrbpart3item14bisselectnsameforall | | part3item15cdsplyprocdtlsrbpart3item15cisdsplyprocsameforall | | part3item16baffirminstrdtlsrbpart3item16bisroutdbefrinstr | | part3item17aaffirinstrdtlsrbpart3item17aisdiffbtwnordtitrtmnt | | part3item22bmtrlarngmntdiffdtlsrbpart3item22bismtrlarngmtsamefrall | | part3item26platfrmdatarbpart3item26isordrfloexecstatspublshd | | part3item2csummaryofconditionsrbpart3item2cisconditionssameforall | | part3item3bsummaryofconditionsrbpart3item3biscondtnssameforall | | part3item5bprotocoldetailsrbpart3item5bisprotclsameforall | | part3item5cothrdtlsrbpart3item5cisanyothermeans | | part3item5dtncdetailsrbpart3item5distncsameforall | | part3item6aprotocoldetailsrbpart3item6aiscolocrltdsrvcsofrd | | part3item6btncdetailsrbpart3item6bistncsameforall | | part3item7btncdetailsrbpart3item7bistncsameforall | | part3item8breqprocdetailsrbpart3item8bisreqprocsameforall | | part3item8coddltordrreqsrbpart3item8cisoddlotsacptdexecutd | | part3item9amsgdtlsrbpart3item9aisanymsgtoindicti | | part3item9bmsgdtlsrbpart3item9bisindintrstsameforall | | rboperatespursuanttoformats | | rbpart1item1isbd | | rbpart2item1aarepermittedtoenterinterest | | rbpart2item1baresevicessametoallsubscribers | | rbpart2item1caretherearrangements | | rbpart2item1dcanoatinterestberouted | | rbpart2item2aareafflpermittedtoenterinterest | | rbpart2item2baresevicestoafflsametosubscribers | | rbpart2item2caretherearrangementswithaffl | | rbpart2item2dcanoatiberoutedbyaffl | | rbpart2item3acansubscroptoutwithoatiofaffl | | rbpart2item3acansubscroptoutwithoatiofbd | | rbpart2item3careoptoutsametoallsubscribers | | rbpart2item4aaretherearrangementsbtwbdandtc | | rbpart2item4baretherearrangementsbtwafflandtc | | rbpart2item5baresevicessametoallsubscribersandbd | | rbpart2item5adoesofferproductsandservices | | rbpart2item5cdoesafflofferproductsandservices | | rbpart2item6cdoesserviceprovideruseatsservices | | rbpart2item6dareatssevicessametoall | | rbpart2item6adoesemployeeaccessconfidentialinfo | | rbpart2item6bdoesanyentitysupportservices | | rbpart2item7bcansubscriberconsenttodisclosure | | rbpart2item7ccansubscriberwithdrawconsent | | rbpart3item10eisanydifbtwnpreopexecflwngstpg | | rbpart3item10bisopnreopnsameforall | | rbpart3item10disanydifbtwnexeproctrdhrs | | rbpart3item10eisanydifbtwnpreopexecflwngstpg | | rbpart3item11bismeansfeciltssameforall | | rbpart3item11disprocsrulssameforall | | rbpart3item12aisanyfrmlinfrmlarngmnts | | rbpart3item13aisordrtisegmntd | | rbpart3item13bissegmntatnsameforall | | rbpart3item13dissegcatgdisclosd | | rbpart3item13eisdsclosrsameforall | | rbpart3item13ciscustmrordr | | rbpart3item14aisdsgtointrctornot | | rbpart3item14bisselectnsameforall | | rbpart3item14aisdsgtointrctornot | | rbpart3item15bissubscrbordbnd | | rbpart3item15cisdsplyprocsameforall | | rbpart3item15aiselectrnccommu | | rbpart3item15bissubscrbordbnd | | rbpart3item16aisinstroutd | | rbpart3item16bisroutdbefrinstr | | rbpart3item16aisinstroutd | | rbpart3item17aisdiffbtwnordtitrtmnt | | rbpart3item17bistrtmntsameforall | | rbpart3item17bistrtmntsameforall | | rbpart3item18aisoutsdetrdinghrs | | rbpart3item20bissuspndprocdursamefrall | | rbpart3item20bissuspndprocdursamefrall | | rbpart3item21bismtrlarngmtsamefrall | | rbpart3item22bismtrlarngmtsamefrall | | rbpart3item23bissrcsamefrall | | rbpart3item24aissubscrbrordr | | rbpart3item25aisavgdlytradinvolexcd | | rbpart3item25biscmplyrule301 | | rbpart3item25aisavgdlytradinvolexcd | | rbpart3item26isordrfloexecstatspublshd | | rbpart3item2cisconditionssameforall | | rbpart3item2aregisteredbd | | rbpart3item2bisthereotherconditions | | rbpart3item2distherewrittenagreement | | rbpart3item3biscondtnssameforall | | rbpart3item3aisexcludesubscriber | | rbpart3item4bishrsofoperationsame | | rbpart3item5aispermitordrtradng | | rbpart3item5bisprotclsameforall | | rbpart3item5cisanyothermeans | | rbpart3item5distncsameforall | | rbpart3item5aispermitordrtradng | | rbpart3item6aiscolocrltdsrvcsofrd | | rbpart3item6bistncsameforall | | rbpart3item6cisanyothermeans | | rbpart3item6eisanyrducdspofcom | | rbpart3item7bistncsameforall | | rbpart3item8bisreqprocsameforall | | rbpart3item8cisoddlotsacptdexecutd | | rbpart3item8disreqsprocdursameforall | | rbpart3item8eismixlotordrsacptdexecutd | | rbpart3item8aisminormaxsizereqd | | rbpart3item8eismixlotordrsacptdexecutd | | rbpart3item8fisrecprocsameforall | | rbpart3item9aisanymsgtoindicti | | rbpart3item9bisindintrstsameforall | | secondarysite7city | | secondarysite7state | | secondarysite7street1 | | secondarysite7street2 | | secondarysite7zip | | state | | street1 | | street2 | | submissiontype | | tapart2item1aunitnamesenterinterest | | tapart2item2aafflthatenterinterest | | tapart2item2bexplaindiff | | tapart2item3aexplianoptout | | tapart2item3bexplianoptout | | tapart2item3cexplaindiff | | tapart2item4atdandatsservices | | tapart2item5bexplaindiff | | tapart2item5aproductsandservices | | tapart2item6cproviderafflandservicesused | | tapart2item6aunitafflemployeeservices | | tapart2item6bserviceprovider | | tapart2item7bexplainhowandconditions | | tapart2item7cexplainhowandconditions | | tapart2item7adescrofsafegaurdsandprocedures | | tapart2item7dsummaryofrolesrespofpersons | | tapart3item10ediffdtls | | tapart3item10aopenreopendtls | | tapart3item10cunexeordrtidtls | | tapart3item11bmeansfeciltsdtls | | tapart3item11ddiffdtls | | tapart3item11astrucofnmsstk | | tapart3item11crulsprocsofnmsstk | | tapart3item13asegprocdurdtls | | tapart3item13bsegdiffdtls | | tapart3item13ddsclosrcontntdtls | | tapart3item13edsclosrdiffdtls | | tapart3item14bselectndiffdtls | | tapart3item14acntrprtydtls | | tapart3item15bsubscrbnddtls | | tapart3item16baffirminstrdiffdtls | | tapart3item16baffirminstrdiffdtlsno | | tapart3item17atrtmntdiffdtls | | tapart3item17bdiffdtls | | tapart3item19asrvcusgfees | | tapart3item19bbundldsrvcusgfees | | tapart3item19crbtdiscoffees | | tapart3item1othersubscrbrdtls | | tapart3item1subscribertype | | tapart3item20bdiffdtls | | tapart3item20asuspndprocdur | | tapart3item21amtrlarngmntdtls | | tapart3item22bdiffdtls | | tapart3item22amtrlarngmntdtls | | tapart3item23amrktdatsrc | | tapart3item25bitickrsymbol | | tapart3item25biidwrtnstndrds | | tapart3item2csummaryofdifferences | | tapart3item2bsummaryofcndtns | | tapart3item3bsummaryofdifferences | | tapart3item3aexcludngsumrydtls | | tapart3item4ahrsofoperation | | tapart3item5aprotocolsumrydtls | | tapart3item5cdsplyprocdiffdtls | | tapart3item5cothrmeansdtls | | tapart3item5dtncsumrydtls | | tapart3item5aprotocolused | | tapart3item6acolocrltdsrvcsdtls | | tapart3item6btncsumrydtls | | tapart3item7aordrtypexplain | | tapart3item7btncsumrydtls | | tapart3item8bdiffrncsinotireqrmnts | | tapart3item8coddltordrreqsnprocdurs | | tapart3item8aotisizereqrmns | | tapart3item8emixltordrreqsprocdtls | | tapart3item9amsgusgdtls | | tapart3item9bmsgusgdtls | | tastatementaboutamendment | | txnmsstockatsname | | txpart1item2atsname | | txpart1item3atsname | | txpart1item4abdcrdnumber | | txpart1item4abdfilenumber | | txpart1item5ansafullname | | txtpart1item5cnmsstockmpid | | txtpart1item6uwebsite | | zip |

c_a

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_a",
    filename="c_a.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_a"
    LIMIT 10
    """,
    output_dir="c_a_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | actreceivedmostrecentfiscalyear | | actreceivedpriorfiscalyear | | cashequimostrecentfiscalyear | | cashequipriorfiscalyear | | city | | commissioncik | | commissionfilenumber | | companyname | | compensationamount | | confirmingcopyflag | | costgoodssoldmostrecentfiscalyear | | costgoodssoldpriorfiscalyear | | crdnumber | | currentemployees | | dateincorporation | | deadlinedate | | descoversubscription | | filenumber | | filerccc | | filercik | | financialinterest | | isamendment | | iscoissuer | | issuejurisdictionsecuritiesoffering | | issuer | | issuersignature | | issuertitle | | issuerwebsite | | jurisdictionorganization | | legalstatusform | | livetestflag | | longtermdebtmostrecentfiscalyear | | longtermdebtpriorfiscalyear | | maximumofferingamount | | nameofissuer | | natureofamendment | | netincomemostrecentfiscalyear | | netincomepriorfiscalyear | | noofsecurityoffered | | offeringamount | | oversubscriptionaccepted | | oversubscriptionallocationtype | | overrideinternetflag | | period | | price | | pricedeterminationmethod | | progressupdate | | returncopyflag | | revenuemostrecentfiscalyear | | revenuepriorfiscalyear | | securityofferedotherdesc | | securityofferedtype | | shorttermdebtmostrecentfiscalyear | | shorttermdebtpriorfiscalyear | | stateorcountry | | street1 | | street2 | | submissiontype | | taxpaidmostrecentfiscalyear | | taxpaidpriorfiscalyear | | totalassetmostrecentfiscalyear | | totalassetpriorfiscalyear | | zipcode |

c_co_issuer

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_co_issuer",
    filename="c_co_issuer.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_co_issuer"
    LIMIT 10
    """,
    output_dir="c_co_issuer_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | coissueraddresscity | | coissueraddressstateorcountry | | coissueraddressstreet1 | | coissueraddresszipcode | | coissuercik | | coissuerlegalstatusdateincorporation | | coissuerlegalstatusjurisdictionorganization | | coissuerlegalstatuslegalstatusform | | coissuerwebsite | | isedgarfiler | | nameofcoissuer |

c_signature_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_signature_person",
    filename="c_signature_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_signature_person"
    LIMIT 10
    """,
    output_dir="c_signature_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | personsignature | | persontitle | | signaturedate |

c_tr

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_tr",
    filename="c_tr.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_tr"
    LIMIT 10
    """,
    output_dir="c_tr_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | dateincorporation | | filerccc | | filercik | | issuersignature | | issuersignaturetext | | issuertitle | | issuerwebsite | | jurisdictionorganization | | legalstatusform | | legalstatusotherdesc | | livetestflag | | nameofissuer | | stateorcountry | | street1 | | street2 | | submissiontype | | zipcode |

c_tr_co_issuer

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_tr_co_issuer",
    filename="c_tr_co_issuer.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_tr_co_issuer"
    LIMIT 10
    """,
    output_dir="c_tr_co_issuer_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | coissuercik | | coissuerwebsite | | dateincorporation | | jurisdictionorganization | | legalstatusform | | legalstatusotherdesc | | nameofcoissuer | | stateorcountry | | street1 | | street2 | | zipcode |

c_tr_signature_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/c_tr_signature_person",
    filename="c_tr_signature_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "c_tr_signature_person"
    LIMIT 10
    """,
    output_dir="c_tr_signature_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | personsignature | | persontitle | | signaturedate |

cfportal

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/cfportal",
    filename="cfportal.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "cfportal"
    LIMIT 10
    """,
    output_dir="cfportal_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | acquireddesc | | acquiredfundingportal | | acquiredportalfilenumber | | agentname | | amendmentexplanation | | anyforeignregistrations | | anypreviousregistrations | | apcrdnumber | | associatedpersonciviljudicialdrpdetailsportalstateorcountry | | associatedpersondetailsscheduleacrdnumber | | bookkeepingentityaddressportalcity | | bookkeepingentityaddressportalstateorcountry | | bookkeepingentityaddressportalstreet1 | | bookkeepingentityaddressportalstreet2 | | bookkeepingentityaddressportalzipcode | | bookkeepingentityfax | | bookkeepingentityname | | bookkeepingentityphone | | bookkeepingentitytype | | bookkeepinglocationdesc | | cityorcounty | | civilactioncourtname | | civilactioncourttype | | civilisfoundinviolationofregulation | | civiljudicialdrpdetailscityorcounty | | civiljudicialdrpdetailscivilactioncourtname | | civiljudicialdrpdetailscivilactioncourttype | | civiljudicialdrpdetailscourtactioninitiatorname | | civiljudicialdrpdetailsdescribecivilactionallegations | | civiljudicialdrpdetailsdocketorcasenumber | | civiljudicialdrpdetailseventcurrentstatus | | civiljudicialdrpdetailsfilingdateofcourtactionexactorexplaindate | | civiljudicialdrpdetailsfilingdateofcourtactionexactorexplainexactorexplanation | | civiljudicialdrpdetailsgrantorfineamount | | civiljudicialdrpdetailsmatterresolvetype | | civiljudicialdrpdetailsotherprincipalproducttype | | civiljudicialdrpdetailsportalstateorcountry | | civiljudicialdrpdetailsprincipalproducttype | | civiljudicialdrpdetailsprincipalreliefsought | | civiljudicialdrpdetailssanctiondetail | | civiljudicialdrpdetailssummaryofcircumstances | | civiljudicialdrpdrpfiledfor | | civiljudicialdrpinitialoramended | | contactfirstname | | contactlastname | | contactmiddlename | | contactprefix | | contacttitle | | controlaffiliatetype | | controlrelationshipfulllegalname | | courtactioninitiatorname | | date | | datebusinessceasedwithdrawn | | dateincorporation | | describecivilactionallegations | | docketorcasenumber | | doesapphaveliens | | drpfiledfor | | escrowcompensationdesc | | eventcurrentstatus | | exactorexplanation | | executiondate | | executionfulllegalname | | executionsignature | | executiontitle | | filerccc | | filercik | | filingdateofcourtactionexactorexplaindate | | filingdateofcourtactionexactorexplainexactorexplanation | | fiscalyearend | | fullname | | grantorfineamount | | hasbonddenied | | hassubjectofbankruptcy | | hastrusteeappointed | | initialoramended | | investorfundscity | | investorfundscontactname | | investorfundscontactphone | | investorfundsstateorcountry | | investorfundsstreet1 | | investorfundsstreet2 | | investorfundszipcode | | investorinitiatedcomplaint | | irsemployeridnumber | | isaddressprivateresidence | | isauthorizedtoactattorney | | iscauseofdenial | | ischargedmisdemeanor | | ischargedwithfelony | | isconaffregisteredcrd | | isconvictedmisdemeanor | | isconvictedoffelony | | isdeniedlicense | | isdisciplined | | isdismissed | | isengagedinnonsecurities | | isenjoined | | isfoundincauseofdenial | | isfoundincauseofsuspension | | isfoundinviolationofregulation | | isfoundinviolationofrules | | isfoundmadefalsestatement | | isimposedpenalty | | isinvestigated | | ismadefalsestatement | | isnamedincivilproceeding | | isorderagainst | | isorderagainstactivity | | isregistered | | isregulatorycomplaint | | issucceedingbusiness | | isunethical | | isviolatedregulation | | jurisdictionorganization | | legalnamechange | | legalstatusform | | mailingaddressdifferent | | mailingcity | | mailingstateorcountry | | mailingstreet1 | | mailingstreet2 | | mailingzipcode | | matterresolvetype | | nameofportal | | nonsecuritiesbusinessdesc | | othernamesused | | otherofficelocationaddressportalcity | | otherofficelocationaddressportalstateorcountry | | otherofficelocationaddressportalstreet1 | | otherofficelocationaddressportalstreet2 | | otherofficelocationaddressportalzipcode | | otherprincipalproducttype | | overrideinternetflag | | personregistered | | persontype | | portaladdressportalcity | | portaladdressportalstateorcountry | | portaladdressportalstreet1 | | portaladdressportalstreet2 | | portaladdressportalzipcode | | portalcity | | portalcontactemail | | portalcontactfax | | portalcontactphone | | portalstateorcountry | | portalstreet1 | | portalstreet2 | | portalzipcode | | prevnamesofportal | | prevwebsiteurls | | principalproducttype | | principalreliefsought | | privatecivillitigation | | resolutiondateexactorexplaindate | | resolutiondateexactorexplainexactorexplanation | | respondingtoresponsequestion | | responsequestion | | returncopyflag | | sanctiondetail | | sanctionordered | | sanctionrelieftypesanctionordered | | schedulebcontrolperson | | schedulebcrdnumber | | schedulebdateoftitlestatusacquired | | schedulebentitytype | | schedulebfulllegalname | | schedulebownershipcode | | schedulebtitlestatus | | schedulebtypeofamendment | | schedulecprintedname | | schedulecsignature | | schedulecsignaturedate | | schedulectitle | | secfilenumbers | | submissiontype | | suffix | | summaryofcircumstances | | websiteofportal |

cfportal_schedule_a_entity

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/cfportal_schedule_a_entity",
    filename="cfportal_schedule_a_entity.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "cfportal_schedule_a_entity"
    LIMIT 10
    """,
    output_dir="cfportal_schedule_a_entity_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | scheduleacontrolperson | | scheduleacrdnumber | | scheduleadateoftitlestatusacquired | | scheduleaentitytype | | scheduleafulllegalname | | scheduleaownershipcode | | scheduleatitlestatus |

cover_page

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/cover_page",
    filename="cover_page.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "cover_page"
    LIMIT 10
    """,
    output_dir="cover_page_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | confirmingcopyflag | | filenumber | | filerccc | | filercik | | livetestflag | | overrideinternetflag | | rboperatespursuanttoformats | | submissiontype | | tastatementaboutamendment | | txnmsstockatsname |

d

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/d",
    filename="d.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "d"
    LIMIT 10
    """,
    output_dir="d_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregatenetassetvaluerange | | authorizedrepresentative | | businesscombinationclarification | | city | | dateoffirstsale | | dateoffirstsaleyettooccur | | descriptionofothertype | | edgarpreviousname | | federalexemptionsitem | | findersfeedollaramount | | findersfeeisestimate | | grossproceedsisestimate | | grossproceedsused | | hasnonaccreditedinvestors | | industrygrouptype | | investmentfundtype | | is40act | | isamendment | | isbusinesscombinationtransaction | | isdebttype | | isequitytype | | ismineralpropertytype | | isoptiontoacquiretype | | isothertype | | ispooledinvestmentfundtype | | issecuritytobeacquiredtype | | istenantincommontype | | issuerphonenumber | | issuerpreviousname | | jurisdictionofinc | | minimuminvestmentaccepted | | morethanoneyear | | nameofsigner | | numbernonaccreditedinvestors | | offeringsalesclarification | | previousaccessionnumber | | primaryissuercik | | primaryissuerentityname | | primaryissuerentitytype | | primaryissuerentitytypeotherdesc | | revenuerange | | salescommissionsclarification | | salescommissionsdollaramount | | salescommissionsisestimate | | schemaversion | | signaturedate | | signatureissuername | | signaturename | | signaturetitle | | stateorcountry | | stateorcountrydescription | | street1 | | street2 | | submissiontype | | testorlive | | totalamountsold | | totalnumberalreadyinvested | | totalofferingamount | | totalremaining | | useofproceedsclarification | | yearofincoverfiveyears | | yearofincvalue | | yearofincwithinfiveyears | | yearofincyettobeformed | | zipcode |

d_issuer

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/d_issuer",
    filename="d_issuer.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "d_issuer"
    LIMIT 10
    """,
    output_dir="d_issuer_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cik | | city | | edgarpreviousname | | entityname | | entitytype | | entitytypeotherdesc | | issuerphonenumber | | issuerpreviousname | | jurisdictionofinc | | stateorcountry | | stateorcountrydescription | | street1 | | street2 | | yearofincoverfiveyears | | yearofincvalue | | yearofincwithinfiveyears | | yearofincyettobeformed | | zipcode |

d_related_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/d_related_person",
    filename="d_related_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "d_related_person"
    LIMIT 10
    """,
    output_dir="d_related_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | firstname | | lastname | | middlename | | relationship | | relationshipclarification | | stateorcountry | | stateorcountrydescription | | street1 | | street2 | | zipcode |

d_sales_compensation_recipient

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/d_sales_compensation_recipient",
    filename="d_sales_compensation_recipient.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "d_sales_compensation_recipient"
    LIMIT 10
    """,
    output_dir="d_sales_compensation_recipient_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | associatedbdcrdnumber | | associatedbdname | | city | | foreignsolicitation | | recipientcrdnumber | | recipientname | | solicitationdescription | | solicitationstate | | solicitationvalue | | stateorcountry | | stateorcountrydescription | | street1 | | street2 | | zipcode |

dos

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/dos",
    filename="dos.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "dos"
    LIMIT 10
    """,
    output_dir="dos_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | accountspayable | | accountsreceivable | | aggregateconsiderationbasis | | auditorfees | | auditorserviceprovidername | | blueskyfees | | blueskyserviceprovidername | | brokerdealercrdnumber | | cashequivalents | | certifyifbadactor | | certifyifnotdisqualified | | certifyiftrue | | cik | | city | | clarificationresponses | | commoncusipequity | | commonequityclassname | | concurrentofferingaggregate | | connectionname | | costandexpensesappltorevenues | | cusipdebtsecurities | | dealersjurisdictionsecuritiesoffering | | debtsecuritiesclassname | | deposits | | depreciationandamortization | | earningspersharebasic | | earningspersharediluted | | estimatednetamount | | filerccc | | filercik | | financialstatementauditstatus | | finderfeesfee | | findersfeesserviceprovidername | | fulltimeemployees | | ifunregisterednone | | indicatetier1tier2offering | | industrygroup | | investmentsecurities | | irsnum | | issuejurisdictionsecuritiesoffering | | issueraggregateoffering | | issuername | | jurisdictionorganization | | jurisdictionsofsecofferednone | | jurisdictionsofsecofferedsame | | legalfees | | legalserviceprovidername | | livetestflag | | loans | | longtermdebt | | nameauditor | | netincome | | offerdelayedcontinuousflag | | offeringafterqualifflag | | offeringbesteffortsflag | | offeringyearflag | | outstandingcommonequity | | outstandingdebtsecurities | | outstandingpreferredequity | | outstandingsecurities | | overrideinternetflag | | parttimeemployees | | phonenumber | | preferredcusipequity | | preferredequityclassname | | pricepersecurity | | promotersfees | | promotersserviceprovidername | | propertyandequipment | | propertyplantequipment | | publiclytradedcommonequity | | publiclytradeddebtsecurities | | publiclytradedpreferredequity | | qualificationofferingaggregate | | resalesecuritiesaffiliatesflag | | returncopyflag | | salescommissionsserviceproviderfees | | salescommissionsserviceprovidername | | securitiesactexemption | | securitiesissuedaggregateamount | | securitiesissuedtotalamount | | securitiesissuername | | securitiesissuertitle | | securitiesoffered | | securitiesofferedotherdesc | | securitiesofferedtypes | | securitiesprincipalholderamount | | securityholderaggregate | | siccode | | sincelastfiling | | solicitationproposedofferingflag | | stateorcountry | | street1 | | street2 | | submissiontype | | totalaggregateoffering | | totalassets | | totalinterestexpenses | | totalinterestincome | | totalliabilities | | totalliabilitiesandequity | | totalrevenues | | totalstockholderequity | | underwritersfees | | underwritersserviceprovidername | | yearincorporation | | zipcode |

effect

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/effect",
    filename="effect.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "effect"
    LIMIT 10
    """,
    output_dir="effect_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | act | | cik | | entityname | | filenumber | | finaleffectivenessdispdate | | finaleffectivenessdisptime | | form | | submissiontype | | testorlive |

effect_merger

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/effect_merger",
    filename="effect_merger.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "effect_merger"
    LIMIT 10
    """,
    output_dir="effect_merger_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | acquiringcik | | acquiringclasscontractid | | acquiringclasscontractname | | acquiringentityname | | acquiringseriesid | | acquiringseriesname | | targetcik | | targetclasscontractid | | targetclasscontractname | | targetentityname | | targetseriesid | | targetseriesname |

ex_102

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ex_102",
    filename="ex_102.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ex_102"
    LIMIT 10
    """,
    output_dir="ex_102_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | armindexratepercentage | | armmarginnumber | | assetaddedindicator | | assetnumber | | assetsubjectdemandindicator | | assettypenumber | | balloonindicator | | debtservicecoveragesecuritizationcode | | defeasanceoptionstartdate | | defeasedstatuscode | | deferredinterestcollectedamount | | deferredinterestcumulativeamount | | dscnetcashflowsecuritizationpercentage | | dscnetoperatingincomesecuritizationpercentage | | financialssecuritizationdate | | firstloanpaymentduedate | | gracedaysallowednumber | | groupid | | hyperamortizingdate | | indexlookbackdaysnumber | | interestaccrualmethodcode | | interestonlyindicator | | interestratesecuritizationpercentage | | largesttenant | | lastmodificationdate | | leaseexpirationlargesttenantdate | | leaseexpirationsecondlargesttenantdate | | leaseexpirationthirdlargesttenantdate | | lienpositionsecuritizationcode | | lifetimeratecappercentage | | lifetimeratefloorpercentage | | liquidationprepaymentcode | | liquidationprepaymentdate | | loanstructurecode | | maturitydate | | maxnegamortamount | | maxnegamortpercentage | | modificationcode | | modifiedindicator | | mostrecentannualleaserolloverreviewdate | | mostrecentdebtserviceamount | | mostrecentdebtservicecoveragecode | | mostrecentdscnetcashflowpercentage | | mostrecentdscnetoperatingincomepercentage | | mostrecentfinancialsenddate | | mostrecentfinancialsstartdate | | mostrecentmasterservicerreturndate | | mostrecentnetcashflowamount | | mostrecentnetoperatingincomeamount | | mostrecentphysicaloccupancypercentage | | mostrecentrevenueamount | | mostrecentspecialservicertransferdate | | mostrecentvaluationamount | | mostrecentvaluationdate | | mostrecentvaluationsourcecode | | negamortdeferredinterestcapamount | | negativeamortizationindicator | | netcashflowsecuritizationamount | | netoperatingincomenetcashflowcode | | netoperatingincomenetcashflowsecuritizationcode | | netoperatingincomesecuritizationamount | | netrentablesquarefeetnumber | | netrentablesquarefeetsecuritizationnumber | | nextinterestratechangeadjustmentdate | | nextinterestratepercentage | | nonrecoverabilityindicator | | numberproperties | | numberpropertiessecuritization | | operatingexpensesamount | | operatingexpensessecuritizationamount | | originalamortizationtermnumber | | originalinterestonlytermnumber | | originalinterestratepercentage | | originalinterestratetypecode | | originalloanamount | | originaltermloannumber | | originationdate | | originatorname | | otherexpensesadvancedoutstandingamount | | otherinterestadjustmentamount | | otherprincipaladjustmentamount | | paidthroughdate | | paymentfrequencycode | | paymentstatusloancode | | paymenttypecode | | periodicpipaymentsecuritizationamount | | periodicpaymentadjustmentmaximumamount | | periodicpaymentadjustmentmaximumpercent | | periodicratedecreaselimitpercentage | | periodicrateincreaselimitpercentage | | physicaloccupancysecuritizationpercentage | | postmodificationamortizationperiodamount | | postmodificationinterestpercentage | | postmodificationmaturitydate | | postmodificationpaymentamount | | prepaymentlockoutenddate | | prepaymentpremiumindicator | | prepaymentpremiumyieldmaintenancereceivedamount | | prepaymentpremiumsenddate | | primaryservicername | | propertyaddress | | propertycity | | propertycounty | | propertyname | | propertystate | | propertystatuscode | | propertytypecode | | propertyzip | | realizedlosstotrustamount | | reportperiodbeginningscheduleloanbalanceamount | | reportperiodendactualbalanceamount | | reportperiodendscheduledloanbalanceamount | | reportperiodinterestratepercentage | | reportperiodmodificationindicator | | reportingperiodbeginningdate | | reportingperiodenddate | | repurchaseamount | | revenuesecuritizationamount | | scheduledinterestamount | | scheduledprincipalamount | | scheduledprincipalbalancesecuritizationamount | | secondlargesttenant | | servicertrusteefeeratepercentage | | servicingadvancemethodcode | | squarefeetlargesttenantnumber | | squarefeetsecondlargesttenantnumber | | squarefeetthirdlargesttenantnumber | | thirdlargesttenant | | totalpiadvancedoutstandingamount | | totalscheduledpiamount | | totaltaxesinsuranceadvancesoutstandingamount | | underwritingindicator | | unitsbedsroomsnumber | | unitsbedsroomssecuritizationnumber | | unscheduledprincipalcollectedamount | | valuationsecuritizationamount | | valuationsecuritizationdate | | valuationsourcesecuritizationcode | | workoutstrategycode | | yearbuiltnumber | | yearlastrenovated | | yieldmaintenanceenddate |

ex_103

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ex_103",
    filename="ex_103.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ex_103"
    LIMIT 10
    """,
    output_dir="ex_103_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | columnname | | comment | | commentcolumn | | commentdescription | | commentnumber | | fieldname | | itemnumber |

form_144

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/form_144",
    filename="form_144.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "form_144"
    LIMIT 10
    """,
    output_dir="form_144_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | contactemailaddress | | contactname | | contactphonenumber | | filerccc | | filercik | | issuercik | | issuercontactphone | | issuername | | livetestflag | | nameofpersonforwhoseaccount | | nothingtoreportflag | | noticedate | | overrideinternetflag | | planadoptiondate | | previousaccessionnumber | | relationshiptoissuer | | remarks | | secfilenumber | | signature | | stateorcountry | | street1 | | street2 | | submissiontype | | zipcode |

form_144_securities_information

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/form_144_securities_information",
    filename="form_144_securities_information.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "form_144_securities_information"
    LIMIT 10
    """,
    output_dir="form_144_securities_information_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregatemarketvalue | | approxsaledate | | brokercity | | brokername | | brokerstateorcountry | | brokerstreet1 | | brokerstreet2 | | brokerzipcode | | noofunitsoutstanding | | noofunitssold | | securitiesexchangename | | securitiesinfoclasstitle |

form_144_securities_sold

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/form_144_securities_sold",
    filename="form_144_securities_sold.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "form_144_securities_sold"
    LIMIT 10
    """,
    output_dir="form_144_securities_sold_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amountofsecuritiessold | | city | | grossproceeds | | saledate | | securitiesclasstitle | | sellername | | stateorcountry | | street1 | | street2 | | zipcode |

form_144_securities_to_be_sold

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/form_144_securities_to_be_sold",
    filename="form_144_securities_to_be_sold.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "form_144_securities_to_be_sold"
    LIMIT 10
    """,
    output_dir="form_144_securities_to_be_sold_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | acquireddate | | amountofsecuritiesacquired | | donaracquireddate | | isgifttransaction | | nameofpersonfromwhomacquired | | natureofacquisitiontransaction | | natureofpayment | | paymentdate | | securitiesclasstitle |

information_table

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/information_table",
    filename="information_table.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "information_table"
    LIMIT 10
    """,
    output_dir="information_table_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | figi | | investmentdiscretion | | nameofissuer | | othermanager | | putcall | | sshprnamt | | sshprnamttype | | titleofclass | | value | | votingauthoritynone | | votingauthorityshared | | votingauthoritysole |

ma

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma",
    filename="ma.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma"
    LIMIT 10
    """,
    output_dir="ma_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | activelyengagedprimarybusinessisactivelyengaged | | activelyengagedprimarybusinessisprimarybusiness | | additionaloffices | | additionalregs | | addressaddresscity | | addressaddressstateorcountry | | addressaddressstreet1 | | addressaddressstreet2 | | addressaddresszipcode | | addresscity | | addressinfoaddresscity | | addressinfoaddressstateorcountry | | addressinfoaddressstreet1 | | addressinfoaddressstreet2 | | addressinfoaddresszipcode | | addressstateorcountry | | addressstreet1 | | addressstreet2 | | addresszipcode | | advbdu4filingcrdnumber | | advbdu4filingdisclosurenumber | | advbdu4filingname | | affiliatename | | allegationsdescription | | amountordered | | anotherregistrationdescription | | anotherregistrationregistrationid | | apdrpfiledcount | | aptypenaturalpersoninfofirstname | | aptypenaturalpersoninfolastname | | aptypenaturalpersoninfomiddlename | | aptypesfiaaptypes | | baseheaderapdrpfiledcount | | baseinfobaseinformationcrdnumber | | baseinfobaseinformationiscontroperson | | baseinfobaseinformationownershipcode | | baseinfobaseinformationstatusacquired | | baseinfobaseinformationtitlestatus | | baseinfocontropersonpr | | baseinfoempidnumber | | baseinfoirsnum | | baseinfoname | | baseinfonamefirstname | | baseinfonamelastname | | baseinfonamemiddlename | | baseinformationbaseinfobaseinformationcrdnumber | | baseinformationbaseinfobaseinformationiscontroperson | | baseinformationbaseinfobaseinformationownershipcode | | baseinformationbaseinfobaseinformationstatusacquired | | baseinformationbaseinfobaseinformationtitlestatus | | baseinformationbaseinfocontropersonpr | | baseinformationbaseinfoempidnumber | | baseinformationbaseinfoirsnum | | baseinformationbaseinfoname | | baseinformationbaseinfonamefirstname | | baseinformationbaseinfonamelastname | | baseinformationbaseinfonamemiddlename | | baseinformationbaseinformationcrdnumber | | baseinformationbaseinformationiscontroperson | | baseinformationbaseinformationownershipcode | | baseinformationbaseinformationstatusacquired | | baseinformationbaseinformationtitlestatus | | baseinformationchargesbroughtinaddresscity | | baseinformationchargesbroughtinaddressstateorcountry | | baseinformationchargesbroughtinaddressstreet1 | | baseinformationchargesbroughtinaddresszipcode | | baseinformationchargesbroughtinname | | baseinformationcontropersonpr | | baseinformationcrdnumber | | baseinformationempidnumber | | baseinformationirsnum | | baseinformationiscontroperson | | baseinformationname | | baseinformationnamefirstname | | baseinformationnamelastname | | baseinformationnamemiddlename | | baseinformationownershipcode | | baseinformationowningentity | | baseinformationstatusacquired | | baseinformationsummary | | baseinformationtitlestatus | | bdregistrationcrdnumber | | bdregistrationfilenumber | | booksandrecordslocationcontactphonenumber | | brokerdealersisactivelyengaged | | brokerdealersisprimarybusiness | | businessirsnum | | businessname | | businesstypeadd | | businesstypeamend | | comptypeotherdescription | | calyearend | | chargesbroughtinaddresscity | | chargesbroughtinaddressstateorcountry | | chargesbroughtinaddressstreet1 | | chargesbroughtinaddresszipcode | | chargesbroughtindocketorcaseno | | chargesbroughtinname | | cik | | city | | clienttypes | | clientsservedasma | | commiditytaisactivelyengaged | | compensationtypes | | compensationtypescompensationtypes | | contactaddressinfoaddresscity | | contactaddressinfoaddressstateorcountry | | contactaddressinfoaddressstreet1 | | contactaddressinfoaddressstreet2 | | contactaddressinfoaddresszipcode | | contactemail | | contactfaxnumber | | contactname | | contactpersonaddressaddressstateorcountry | | contactpersonemail | | contactpersonfaxnumber | | contactpersonphonenumber | | contactphonenumber | | contropersonpr | | country | | crd | | crdnumber | | date | | datedate | | dateinitiateddate | | dateoforganization | | dbaname | | description | | detailssanctionsordered | | detailssanctionssanction | | detailstotalamountordered | | disclosurenumber | | docketorcaseno | | eatypeotherdescription | | effectivedate | | email | | empidnumber | | employeesengagedinmaa | | engagedactivitytype | | engineeringisactivelyengaged | | explanation | | faxnumber | | ffraregistrationname | | fiaaptypes | | fiaassociatedpersontypeadd | | fiaassociatedpersontypeamend | | fiaassociatedpersontypenewadd | | filenumber | | fileddisclosureadvbdu4filingcrdnumber | | fileddisclosureadvbdu4filingname | | filerccc | | filerid | | finalamount | | firmcrdnumber | | firminfo | | firmname | | firstname | | fiscalyearend | | foreigncountry | | formorgotherdescription | | hasadditionaldbanames | | hasadditionalwebsites | | hasannualreceiptslessthan7million | | hasapplicableregistration | | hasbooksrecords | | haschanges | | hasdbaname | | hasmatreg | | hasmailingaddress | | hasnamechange | | haspreviousdbaname | | hasscheduleb | | independentbusinessemployee | | indirectbusinessesbusinesstypeadd | | indirectbusinessesbusinesstypeamend | | indirectpersonspersontypeadd | | indirectpersonspersontypeamend | | initiatedbyname | | initiateddrpallegationsdescription | | initiateddrpdateinitiateddate | | insuranceisactivelyengaged | | insuranceisprimarybusiness | | internetnotificationaddress | | investmentadvisorisactivelyengaged | | investmentadvisorisprimarybusiness | | irsnum | | isactivelyengaged | | isaffiliatedotherbus | | isaffiliatedwithreceiptsmorethan7million | | isauthorizedtoactattorney | | iscpforapplicantpolicy | | iscauseofdenial | | ischargedwithfelony | | iscontroperson | | iscontrolorcontrolled | | isconvictedoffelony | | isdeniedlicense | | isdiscipliend | | isdismissed | | isengagedinothernonmaabusiness | | isenjoined | | isfinalorder | | isfoundincauseofdenial | | isfoundincauseofsuspension | | isfoundinviolationofregulation | | isfoundinviolationofrules | | isfoundmadefalsestatement | | isimposedpenalty | | ismadefalsestatement | | isnamedincivilproceeding | | isorderagainst | | isorderagainstactivity | | isorgchargedwithfelony | | isorgconvictedoffelony | | isothernonmaabuisinesssprimary | | isprcompanyunder1215 | | isprcapplicant | | isprimarybusiness | | isregisteredffra | | isregisteredwithffra | | isregulatorycomplaint | | issecregistered | | issection12or15reportingcompany | | issolepropietor | | issucceedingapplicant | | isunethical | | isundercommoncontrol | | isviolatedregulation | | issuingagencyname | | judgement | | lastname | | lawyerslicensedjurisdictions | | legalname | | licensedjurisdictions | | locationname | | maregistrationfilenumber | | maaemployeesregbd | | maaregia | | mactbuysellfromclients | | mactbuysellrecommendtoclients | | mactcompensateforreferrals | | mactdiscauthbuysell | | mactdiscauthbuysellasmaa | | mactdiscauthdeterminebrokerdealer | | mactdiscauthdeterminebrokerdealerareap | | mactdiscauthdeterminecommissiontobrokerdealer | | mactenterderivativeswithclients | | mactreceivecompensationforreferrals | | mactrecommendbrokerdealertoclient | | mactrecommendbrokerdealertoclientareap | | mactrecommendownedinteresttoclients | | mactrecommendtoclientshavingothersalesinterest | | mactrecommendtoclientsserving | | mailingaddressdifferent | | middlename | | miscellaneous | | monetarysanctionsamountordered | | monetarysanctionsfinalamount | | monthoffiscalyearend | | namefirstname | | namelastname | | namemiddlename | | naturalpersoninfofirstname | | naturalpersoninfolastname | | naturalpersoninfomiddlename | | nonscheduleabccontrolpersonnaturalnamefirstname | | nonscheduleabccontrolpersonnaturalnamelastname | | nonscheduleabccontrolpersonnaturalnamemiddlename | | nonscheduleabccontrollingpersoncontactaddressinfoaddresscity | | nonscheduleabccontrollingpersoncontactaddressinfoaddressstateorcountry | | nonscheduleabccontrollingpersoncontactaddressinfoaddressstreet1 | | nonscheduleabccontrollingpersoncontactaddressinfoaddressstreet2 | | nonscheduleabccontrollingpersoncontactaddressinfoaddresszipcode | | nonscheduleabccontrollingpersoncontactfaxnumber | | nonscheduleabccontrollingpersoncontactphonenumber | | nonscheduleabccontrollingpersondescription | | nonscheduleabccontrollingpersontypeadd | | numberofadditionalwebsites | | numberofemployees | | numberofsolicitedme | | numberofsolicitedop | | numberofsolicitingfirms | | officeinfoaddressinfoaddresscity | | officeinfoaddressinfoaddressstateorcountry | | officeinfoaddressinfoaddressstreet1 | | officeinfoaddressinfoaddressstreet2 | | officeinfoaddressinfoaddresszipcode | | otherfinancialproductadvisoractivelyengagedprimarybusinessisactivelyengaged | | otherfinancialproductadvisoractivelyengagedprimarybusinessisprimarybusiness | | otherfinancialproductadvisorlicensedjurisdictions | | othernonmaabusinessprimarydescription | | otherregistrationcik | | otherregistrationdescription | | otherregistrationfilenumber | | ownershipcode | | owningentity | | personbaseinfobaseinformationiscontroperson | | personbaseinfobaseinformationownershipcode | | personbaseinfobaseinformationstatusacquired | | personbaseinfobaseinformationtitlestatus | | personbaseinformationbaseinfobaseinformationiscontroperson | | personbaseinformationbaseinfobaseinformationownershipcode | | personbaseinformationbaseinfobaseinformationstatusacquired | | personbaseinformationbaseinfobaseinformationtitlestatus | | personbaseinformationbaseinformationcrdnumber | | personbaseinformationbaseinformationiscontroperson | | personbaseinformationbaseinformationownershipcode | | personbaseinformationbaseinformationstatusacquired | | personbaseinformationbaseinformationtitlestatus | | personbaseinformationcrdnumber | | personbaseinformationowningentity | | personnamefirstname | | personnamelastname | | personnamemiddlename | | personowningentity | | persontypeadd | | persontypeamend | | persontypedelete | | persontypenewadd | | phonenumber | | previousdbaname | | previouslegalname | | primarybusinessname | | primarywebaddress | | principalofficeaddressfaxnumber | | principalofficeaddressphonenumber | | principalproducttypesproduct | | product | | realestateisactivelyengaged | | receivecompensationformaafromotherclients | | receivecompensationformaafromotherclientsexplanation | | registeredbrokerdealerrepsisactivelyengaged | | registeredbrokerdealerrepsisprimarybusiness | | registrationinfocrdnumber | | registrationinfoissecregistered | | registrationnum | | registrationnumber | | regulatorydisclosureisfoundinviolationofregulation | | reportingschedule | | resolutioninformationdatedate | | respondingtoresponsequestion | | responsequestion | | sanction | | sanctionsordered | | sanctionssanction | | sanctionssoughtsanction | | satisfied | | secregistrationcrdnumber | | secregistrationfilenumber | | secregistrationnumber | | section1215dpublicreportingcompanyname | | signature | | signaturetitle | | signername | | soleproprietornamefirstname | | soleproprietornamelastname | | soleproprietornamemiddlename | | solicitationcompensationtypescomptypeotherdescription | | solicitationpersontypes | | spotherdescription | | state | | stateorcountry | | stateregistrationcrdnumber | | statusacquired | | street1 | | street2 | | submissiontype | | suffix | | summary | | title | | titlestatus | | titlestitle | | totalamountordered | | totalfiaassociatedpersons | | totalnumberofsolicitedmeandop | | typeadd | | typeamend | | typedelete | | typenewadd | | typesexplanation | | typesisfinalorder | | typesjudgement | | typesofclientsother | | usstate | | zipcode |

ma_additional_office

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_additional_office",
    filename="ma_additional_office.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_additional_office"
    LIMIT 10
    """,
    output_dir="ma_additional_office_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | add | | amend | | delete | | newadd | | officeinfoaddressinfoaddresscity | | officeinfoaddressinfoaddressstateorcountry | | officeinfoaddressinfoaddressstreet1 | | officeinfoaddressinfoaddressstreet2 | | officeinfoaddressinfoaddresszipcode | | officeinfofaxnumber | | officeinfophonenumber |

ma_additional_registration

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_additional_registration",
    filename="ma_additional_registration.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_additional_registration"
    LIMIT 10
    """,
    output_dir="ma_additional_registration_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | nameandregistrationname | | registrationid |

ma_additional_web_address

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_additional_web_address",
    filename="ma_additional_web_address.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_additional_web_address"
    LIMIT 10
    """,
    output_dir="ma_additional_web_address_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | adddeleteamendadd | | amend | | delete | | newadd | | webaddress |

ma_business_conducted_other_name

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_business_conducted_other_name",
    filename="ma_business_conducted_other_name.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_business_conducted_other_name"
    LIMIT 10
    """,
    output_dir="ma_business_conducted_other_name_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amend | | businessconductedothernameadddeleteamendadd | | delete | | jurisdictions | | name | | newadd |

ma_i

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_i",
    filename="ma_i.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_i"
    LIMIT 10
    """,
    output_dir="ma_i_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | addresscity | | addressinfocity | | addressinfostateorcountrystateorcountry | | addressinfozipcode | | addressstateorcountry | | addressstreet1 | | addresszipcode | | applicantcrdnum | | approximatehoursormonths | | city | | civiljudicialinitiator | | contactemail | | contactname | | crdnumber | | datesigned | | dutiesdescription | | enddate | | explanation | | filerccc | | filerid | | filingname | | firstname | | hasmorethanoneadvisoryfirms | | internetnotificationaddress | | investigationauthorityname | | investigationnature | | isamendment | | isassociationbared | | isauthorizedtoactattorney | | isbankruptcypetition | | isbondrevoked | | iscauseofdenial | | ischargedwithfelony | | ischargedwithmisdemeanor | | iscomplaintpending | | iscomplaintsettled | | iscompromised | | isconvictedoffelony | | isconvictedofmisdemeanor | | isdeniedlicense | | isdiscipliend | | isdismissed | | isengagedinotherbusiness | | isenjoined | | isfailedresonably | | isfailedtosupervise | | isfinalorder | | isfoundincauseofdenial | | isfoundincauseofsuspension | | isfoundinviolationofregulation | | isfoundinviolationofrules | | isfoundmadefalsestatement | | isfoundwillfullyaided | | isfraudcasepending | | isfraudcaseresultedaward | | isfraudcasesettled | | isimposedpenalty | | isindividual | | isinvestigated | | isinvolvedinfraud | | islienagainst | | ismadefalsestatement | | isnamedincivilproceeding | | isorderagainst | | isorderagainstactivity | | isorgchargedwithfelony | | isorgchargedwithmisdemeanor | | isorgconvictedoffelony | | isorgconvictedofmisdemeanor | | isregulatorycomplaint | | isrelatedtoinvestment | | isrelatedtomunicipaladvisor | | istrusteeapointed | | isunethical | | isviloatedindustrystandard | | isviolatedregulation | | isviolatedsecurityact | | iswillfullyaided | | iswillfullyviolatedsecurityact | | lastname | | middlename | | name | | nameofapplicantfirstname | | nameofapplicantlastname | | nameofapplicantmiddlename | | natureofbusiness | | noofadvisoryfirms | | otherbusinessisrelatedtoinvestment | | otherbusinessisrelatedtomunicipaladvisor | | otherbusinessname | | otherbusinesspositiondescription | | otherbusinessstartdate | | phonenumber | | positiondescription | | prioremployeraddressinfocity | | prioremployeraddressinfozipcode | | prioremployerenddate | | prioremployerisrelatedtoinvestment | | prioremployerisrelatedtomunicipaladvisor | | prioremployername | | prioremployerpositiondescription | | prioremployerstartdate | | regulatorydisclosurecommonquestionisfoundinviolationofregulation | | regulatoryquestions | | signature | | signaturedatesigned | | signaturesignature | | startdate | | stateorcountry | | stateorcountrystateorcountry | | street1 | | street2 | | submissiontype | | suffix | | terminationdisclosureisfailedtosupervise | | terminationfirmcrdnumber | | title | | zipcode |

ma_i_advisor_office

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_i_advisor_office",
    filename="ma_i_advisor_office.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_i_advisor_office"
    LIMIT 10
    """,
    output_dir="ma_i_advisor_office_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | addresscity | | addressstateorcountry | | addressstreet1 | | addressstreet2 | | addresszipcode | | advisorofficestartdate | | locationinfo |

ma_i_municipal_advisor_office

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_i_municipal_advisor_office",
    filename="ma_i_municipal_advisor_office.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_i_municipal_advisor_office"
    LIMIT 10
    """,
    output_dir="ma_i_municipal_advisor_office_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cik | | explanation | | filenumber | | isindependentrelatioship | | municipaldbaname | | municipalfilerfilerid | | municipalfirmname | | recentemploymentcommenceddate |

ma_i_other_name

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_i_other_name",
    filename="ma_i_other_name.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_i_other_name"
    LIMIT 10
    """,
    output_dir="ma_i_other_name_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | othernamefirstname | | othernamelastname | | othernamemiddlename | | othernamesuffix |

ma_w

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_w",
    filename="ma_w.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_w"
    LIMIT 10
    """,
    output_dir="ma_w_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | contactemail | | contactphonenumber | | date | | email | | filenumber | | filerccc | | filerfilenumber | | filerid | | firstname | | fulllegalname | | internetnotificationaddress | | isadvisorycontract | | isborrowednotrepaid | | isreceivedanyprepaidfee | | isunsatisfiedjudgementsorliens | | lastname | | middlename | | muncipaladvisoryfirmtitle | | name | | phonenumber | | signature | | signername | | soleproprietordate | | soleproprietorsignature | | soleproprietorsignername | | soleproprietortitle | | stateorcountry | | street1 | | street2 | | submissiontype | | title | | zipcode |

ma_w_person_location

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ma_w_person_location",
    filename="ma_w_person_location.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ma_w_person_location"
    LIMIT 10
    """,
    output_dir="ma_w_person_location_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | addresscity | | addressinfoaddresscity | | addressinfoaddressstateorcountry | | addressinfoaddressstreet1 | | addressinfoaddressstreet2 | | addressinfoaddresszipcode | | addressstateorcountry | | addressstreet1 | | addressstreet2 | | addresszipcode | | description | | nameaddressphonename | | nameaddressphonephonenumber | | personinfoname | | personinfophonenumber |

n_cen

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_cen",
    filename="n_cen.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_cen"
    LIMIT 10
    """,
    output_dir="n_cen_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | additionalunitstotalvalue | | admincountry | | adminlei | | adminname | | adminother | | adminrssdid | | adminstate | | adminstatecountryadmincountry | | aggregatecommission | | assetclasstype | | assettype | | assettypeotherdesc | | authorizedparticipantcrdno | | authorizedparticipantfileno | | authorizedparticipantlei | | authorizedparticipantname | | authorizedparticipantpurchasevalue | | authorizedparticipantredeemvalue | | averagecreditlineused | | averagepercentagepurchased | | averagepercentageredeemed | | avgportfoliosecuritiesvalue | | booksrecordsdesc | | brokercountry | | brokercrdno | | brokerdealercommission | | brokerdealercountry | | brokerdealercrdno | | brokerdealerfileno | | brokerdealerlei | | brokerdealername | | brokerdealerrssdid | | brokerdealerstate | | brokerdealerstatecountrybrokerdealercountry | | brokerfileno | | brokerlei | | brokername | | brokerrssdid | | brokerstate | | brokerstatecountrybrokercountry | | ccc | | ccocity | | ccocountry | | ccoemployerid | | ccoemployername | | cconame | | ccophone | | ccostate | | ccostreet1 | | ccostreet2 | | ccozipcode | | changeexplanation | | cik | | classid | | classinfoclassid | | collateralmanagerlei | | collateralmanagername | | commonstockexchange | | commonstocktickersymbol | | confirmingcopyflag | | contractvalueredeemed | | contractvalueredeemedsection1035 | | coveredbyinsurancepolicyiscoveredbyinsurancepolicy | | crdnumber | | creationunitnumofshares | | creationunitpercentageredeemedinkind | | creationunitpurchasedinkind | | creationunitpurchasedsdinkind | | creationunitsdredeemedinkind | | creationunittransactionfeecashmanyunits | | creationunittransactionfeecashperunit | | creationunittransactionfeecashpercentageperunit | | creationunittransactionfeemanyunits | | creationunittransactionfeeperunit | | creationunittransactionfeepercentageperunit | | creditinstitutionname | | creditlineusediscreditlineused | | credittype | | credituserfundname | | custodiancountry | | custodianlei | | custodianname | | custodianrssdid | | custodianstate | | custodianstatecountrycustodiancountry | | custodytype | | dailyavgnetassets | | dateofchange | | dayscreditused | | depositorcountry | | depositorcrdno | | depositorlei | | depositorname | | depositorrssdid | | depositorstate | | depositorultimateparentname | | description | | didfundlendsecurities | | didindemnificationrights | | directorcrdnumber | | directorname | | etfseriesid | | familyinvcompfullname | | feederfundname | | filenumber | | filenumberinfofilenumber | | financialsupportseriesinfoisfinancialsupportduringperiod | | foreigninvestmentsisforeignsubsidiary | | foreignsubsidiarylei | | foreignsubsidiaryname | | fundexchange | | fundlendsecuritiesdidfundlendsecurities | | fundname | | fundtype | | fundtypesfundtype | | fundstickersymbol | | grosscommission | | grosspremiumreceived | | grosspremiumreceivedsection1035 | | haslineofcredit | | idnumberdesc | | idemnityproviderlei | | idemnityprovidername | | idemnityproviderrssdid | | includeallclassesflag | | indexfundinfofundtype | | indexfundreturndailystdevafterexpense | | indexfundreturndailystdevbeforeexpense | | indexfundreturndiffafterexpense | | indexfundreturndiffbeforeexpense | | interfundborrowingdaysoutstanding | | interfundborrowingdetailsisinterfundborrowing | | interfundborrowingloanaverage | | interfundlendingdaysoutstanding | | interfundlendingdetailsisinterfundlending | | interfundlendingloanaverage | | investadviserterminatedcrdno | | investadviserterminatedfileno | | investadviserterminatedlei | | investadviserterminationdate | | investmentadvisercountry | | investmentadvisercrdno | | investmentadviserfileno | | investmentadviserhiredisinvestmentadviserhired | | investmentadviserlei | | investmentadvisername | | investmentadviserrssdid | | investmentadviserstartdate | | investmentadviserstate | | investmentadviserstatecountryinvestmentadvisercountry | | investmentadviserterminatedcountry | | investmentadviserterminatedname | | investmentadviserterminatedstate | | investmentcompfileno | | investmentcompanytype | | investmenttype | | isaccountingprinciplechange | | isadminaffiliated | | isadminhiredorterminated | | isadminsubadmin | | isaffiliatedperson | | isbrokerageresearchpayment | | isbyaffiliatedperson | | isccochangedsincelastfiling | | ischangeaccprinciples | | isclaimfiled | | isclaimfiledduringperiod | | iscodeofethics | | iscollateralmanageraffliliated | | iscollateralmanageraffliliatedwithfund | | iscollateralrequired | | iscoveredbyinsurancepolicy | | iscreditlinecommitted | | iscreditlineused | | iscustodianaffiliated | | iscustodianhiredorterminated | | isdefaultlongtermdebt | | isdirectorinterestedperson | | isdividendsinarrears | | isexclusivefund | | isexemptionfromact | | isexpenselimitationinplace | | isexpensereducedorwaived | | isexpensewaivedrecoupable | | isfeeswaivedrecoupable | | isfinancialsupportduringperiod | | isfirstfilingbyfund | | isforeignsubsidiary | | isfundadverselyimpacted | | isfundliquidated | | isfundsecuritieslending | | isipareportinternalcontrol | | isinkindetf | | isindexfundaffiliated | | isindexfundexclusive | | isinfoitem405 | | isinforequiredeo | | isinstdefiningrights | | isinterfundborrowing | | isinterfundlending | | isinvestmentadviserhired | | islegalproceedings | | isliquidityhiredterminated | | ismaterialamendments | | ismaterialchange | | ismaterialweakness | | isneworamendedinvadvcontracts | | isnondiversifiedcompany | | isopinionoffered | | isotherinforequired | | ispaymentdividend | | ispaymenterrorinnetassetvalue | | ispreviouslegalproceeding | | ispreviousproceedingterminated | | ispricingserviceaffiliated | | ispricingservicehiredorterminated | | isprincipalunderwriteraffiliatedwithregistrant | | isprovisionfinancialsupport | | ispublicaccountantchanged | | isregistrantfamilyinvcomp | | isregistrantfirstfiling | | isregistrantlastfiling | | isregistrantseparateinsuranceaccount | | isregistrantsubmittedmatter | | isreportperiodlt12 | | isrepurchasesecurity | | isrightsoffering | | isrule11a2reliance | | isrule12d1dash4reliance | | isrule12d1greliance | | isrule6c7reliance | | issecondaryoffering | | issecuritiesactregistration | | issecuritiesagentaffiliated | | issecuritiesmodified | | issecurityagentidemnity | | isshareholderserviceagentaffiliated | | isshareholderserviceagentsubshare | | isshareholderservicehiredterminated | | issubadviseraffiliated | | issubadviserhired | | issubcustodian | | isswingpricing | | istransferagentaffiliated | | istransferagenthiredorterminated | | istransferagentsubagent | | isuitadminaffiliated | | isuitadminhiredterminated | | isuitadminsubadmin | | isunderwriterhiredorterminated | | legalproceedingseriesinfoispreviouslegalproceeding | | lineofcredithaslineofcredit | | lineofcreditsize | | liquiditycountry | | liquiditylei | | liquidityname | | liquidityrssdid | | liquiditystate | | livetestflag | | managementfee | | marketpricepershare | | masterfeederfundinfofundtype | | masterfundfileno | | masterfundlei | | masterfundname | | masterfundsecfileno | | mgmtinvfundname | | mgmtinvlei | | mgmtinvseriesid | | mnthlyavgnetassets | | netassetvaluepershare | | netincomesecuritieslending | | netoperatingexpenses | | newseriesaggregatevalue | | numaddedclass | | numauthorizedclass | | numcontractsaffected | | numcontractsaffectedredeemed | | numcontractssold | | numofcontracts | | numofexistingseries | | numofexistingseriesadditionalunits | | numofnewseriesregistration | | numofseriescurrentprospectus | | numterminatedclass | | officeaddress1 | | officeaddress2 | | officecity | | officecountry | | officename | | officephone | | officerecordszipcode | | officestate | | officestatecountryofficecountry | | othercustodiandesc | | otherfeedesc | | otherrepurchasesecuritydesc | | othersecuritydescription | | overrideinternetflag | | paymentdividendseriesispaymentdividend | | paymenterrorseriesispaymenterrorinnetassetvalue | | paymenterrorseriesseriesinfoseriesid | | paymenterrorseriesseriesinfoseriesname | | paymenttoagentmanagertype | | paymenttoagentmanagerspaymenttoagentmanagertype | | pcaobnumber | | percentsdredeemed | | previousproceedingterminatedispreviousproceedingterminated | | pricingservicecountry | | pricingserviceidnumberdesc | | pricingservicelei | | pricingservicename | | pricingserviceother | | pricingservicerssdid | | pricingservicestate | | pricingservicestatecountrypricingservicecountry | | principalaggregatepurchase | | principalcountry | | principalcrdno | | principalfileno | | principallei | | principalname | | principalrssdid | | principalstate | | principalstatecountryprincipalcountry | | principaltotalpurchasesale | | principalunderwritercountry | | principalunderwriterstate | | principalunderwritercrdnumber | | principalunderwriterfilenumber | | principalunderwriterlei | | principalunderwritername | | principalunderwriterrssdid | | publicaccountantcountry | | publicaccountantlei | | publicaccountantname | | publicaccountantrssdid | | publicaccountantstate | | purchasecreationunitcashpermoreunits | | purchasecreationunitcashperunit | | purchasecreationunitcashpercentageperunit | | purchasecreationunitdollarpermoreunits | | purchasecreationunitdollarperunit | | purchasecreationunitdollarpercentageperunit | | regfeederfundfileno | | regfeederfundlei | | regfeederfundseriesidno | | registrantcik | | registrantclassificationtype | | registrantfamilyinvcompisregistrantfamilyinvcomp | | registrantfullname | | registrantlei | | registrantseparateinsuranceaccountisregistrantseparateinsuranceaccount | | registrantsignedname | | registrantcity | | registrantcountry | | registrantphonenumber | | registrantstate | | registrantstreet1 | | registrantstreet2 | | registrantzipcode | | releasenumber | | releasenumbersisexemptionfromact | | relyonruletype | | relyonruletypesrelyonruletype | | reportendingperiod | | repurchasesecuritiesisrepurchasesecurity | | repurchasesecuritytype | | returncopyflag | | rightsofferingfundsisrightsoffering | | rightsofferingparticipationpercent | | rightsofferingtype | | rptincludeallclassesflag | | rptincludeallseriesflag | | rptseriesclassinfoseriesid | | schemaversion | | secfileno | | secondaryofferingtype | | secondaryofferingsissecondaryoffering | | securitiesagentlei | | securitiesagentname | | securityagentidemnityissecurityagentidemnity | | securityclasstitle | | securitymatterseriesinfoisregistrantsubmittedmatter | | securitymatterseriesinfoseriesinfoseriesid | | securitymatterseriesinfoseriesinfoseriesname | | separateaccountcontractid | | separateaccountsecurityname | | separateaccountseriesid | | separateaccounttotalasset | | seriescikcik | | seriesid | | seriesinfoseriesid | | seriesinfoseriesname | | seriesname | | shareholderserviceagentcountry | | shareholderserviceagentlei | | shareholderserviceagentname | | shareholderserviceagentother | | shareholderserviceagentrssdid | | shareholderserviceagentstate | | shareholderserviceagentstatecountryshareholderserviceagentcountry | | shareholderserviceidnumberdesc | | sharesoutstandingclassid | | sharesoutstandingclassname | | sharesoutstandingtickersymbol | | signature | | signeddate | | solecredittypecredittype | | sponsorcountry | | sponsorcrdno | | sponsorlei | | sponsorname | | sponsorrssdid | | sponsorstate | | standarddeviationpurchased | | statutoryregulatorybasis | | subadvisercountry | | subadvisercrdno | | subadviserfileno | | subadviserhiredissubadviserhired | | subadviserlei | | subadvisername | | subadviserrssdid | | subadviserstartdate | | subadviserstate | | subadviserstatecountrysubadvisercountry | | subadviserterminatedcountry | | subadviserterminatedcrdno | | subadviserterminatedfileno | | subadviserterminatedlei | | subadviserterminatedname | | subadviserterminatedstate | | subadviserterminatedstatecountrysubadviserterminatedcountry | | subadviserterminationdate | | submissiontype | | terminatedseriesinfoseriesid | | terminatedseriesinfoseriesname | | terminationdate | | title | | totalassetsseries | | totalseries | | transferagentcountry | | transferagentfileno | | transferagentlei | | transferagentname | | transferagentrssdid | | transferagentstate | | transferagentstatecountrytransferagentcountry | | trusteecountry | | trusteename | | trusteestate | | uitadmincountry | | uitadmindescothernumber | | uitadminlei | | uitadminname | | uitadminother | | uitadminrssdid | | uitadminstate | | unitinportfoliovalue | | unregfeederfileno | | unregfeederfundlei | | valuationmethodschangeseriesseriesinfoseriesid | | valuationmethodschangeseriesseriesinfoseriesname | | valuationmethodschangesismaterialchange | | webpage |

n_mfp

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp",
    filename="n_mfp.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp"
    LIMIT 10
    """,
    output_dir="n_mfp_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | administrator | | adviserfilenumber | | advisername | | assetsnet | | assetssoldunderagreementstorepurchasecarryingamounts | | availableforsalesecuritiesamortizedcost | | cr | | cusipmember | | cashcollateralforborrowedsecurities | | categoryofinvestmentdesc | | city | | classid | | containedfileinformationfilenumber | | date | | dateasofwhichvaluewascalculated | | datecalculatedfornetvaluepershareexcludingcapitalsupportagreement | | datecalculatedfornetvaluepershareincludingcapitalsupportagreement | | demandfeatureissuerinvestmentissuer | | documentperiodenddate | | doessecurityhavedemandfeature | | doessecurityhaveenhancementsonwhichfundrelying | | doessecurityhaveguarantee | | dollarweightedaveragelifematurity | | dollarweightedaverageportfoliomaturity | | enhancementprovider | | entitycentralindexkey | | entityregistrantname | | feederfundcontainedfileinformationfilenumber | | feederfundentitycentralindexkey | | feederfundentityregistrantname | | feederfundseriesidentifier | | filenumber | | finallegalinvestmentmaturitydate | | from | | grossredemptionsformonthended | | grosssubscriptionsformonthended | | hasfundacquiredormergedwithanotherfundsincelastfiling | | investmentidentifier | | investmentissuer | | investmentmaturitydate | | investmentownedatfairvalue | | investmentownedbalanceprincipalamount | | investmentownedinvestmentadditionalinformation | | investmentownedpercentofnetassets | | investmenttitle | | investmenttypedomain | | isfundliquidating | | isfundmergingwithorbeingacquiredbyanotherfund | | isfundtreatingasacquisitionunderlyingsecurities | | isthiselectroniccopyofpaperformat | | isthisfeederfund | | isthisfinalfiling | | isthisilliquidsecurity | | isthismasterfund | | isthisseriesprimarilyusedtofundinsurancecompanyseperateaccounts | | liabilities | | livetestflag | | masterfundentitycentralindexkey | | mininitialinvestment | | moneymarketsevendayyield | | nrsroratinglistnrsroratingr | | nrsroratinglistnrsroratingran | | nrsroratingr | | nrsroratingran | | nrsrosratingr | | nrsrosratingran | | name | | netassetvaluepershare | | netassetvaluepershareincludingcapitalsupportagreementdateasofwhichvaluewascalculated | | netassetvaluepershareincludingcapitalsupportagreementvalue | | netassetsofclass | | netshareholderflowactivityformonthended | | netvaluepershareexcludingcapitalsupportagreement | | netvaluepershareincludingcapitalsupportagreement | | o | | otherassets | | r | | ran | | rating | | repurchaseagreementcategoryofinvestmentdesc | | repurchaseagreementinvestmentissuer | | repurchaseagreementinvestmenttypedomain | | scheduleofportfoliosecuritiesavailableforsalesecuritiesamortizedcost | | scheduleofportfoliosecuritiesentitycentralindexkey | | scheduleofportfoliosecuritiesinvestmenttypedomain | | seriesid | | seriesidentifier | | sevendaynetyield | | state | | subadviseradviserfilenumber | | subadviseradvisername | | submissiontype | | to | | totalclassesinseries | | transferagententitycentralindexkey | | transferagentname | | typeofenhancement | | value | | valueofsecurityexcludingvalueofcapitalsupportagreement |

n_mfp12

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp12",
    filename="n_mfp12.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp12"
    LIMIT 10
    """,
    output_dir="n_mfp12_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | administratorname | | adviserfilenumber | | advisername | | amortizedcostportfoliosecurities | | averagelifematurity | | averageportfoliomaturity | | cash | | ccc | | cik | | city | | feederfundcik | | feederfundflag | | feederfundseriesid | | filenumber | | filercredentialscik | | finalfilingflag | | fridayday1 | | fridayday2 | | fridayday3 | | fridayday4 | | fridayday5 | | fundacqrdormrgdwthanthrflag | | fundexemptretailflag | | fundliquidatingflag | | fundmrgoracqrdbyothrflag | | indppubaccountantname | | masterfeederfundcik | | masterfeederfundname | | masterfeederfundseriesid | | masterfundflag | | moneymarketfundcategory | | name | | nameofsigningofficer | | netassetofseries | | netassetvaluefridayweek1 | | netassetvaluefridayweek2 | | netassetvaluefridayweek3 | | netassetvaluefridayweek4 | | netassetvaluefridayweek5 | | percentagedailyliquidassetsfridayweek1 | | percentagedailyliquidassetsfridayweek2 | | percentagedailyliquidassetsfridayweek3 | | percentagedailyliquidassetsfridayweek4 | | percentagedailyliquidassetsfridayweek5 | | percentageweeklyliquidassetsfridayweek1 | | percentageweeklyliquidassetsfridayweek2 | | percentageweeklyliquidassetsfridayweek3 | | percentageweeklyliquidassetsfridayweek4 | | percentageweeklyliquidassetsfridayweek5 | | registrant | | registrantleiid | | reportdate | | securitiesactfilenumber | | seriesfundinsucmpnysepaccntflag | | seriesid | | serieslevelinfonumberofsharesoutstanding | | sevendaygrossyield | | signature | | signaturedate | | stablepricepershare | | statecountry | | subadviseradviserfilenumber | | subadviseradvisername | | submissiontype | | titleofsigningofficer | | totalshareclassesinseries | | totalvaluedailyliquidassetsfridayday1 | | totalvaluedailyliquidassetsfridayday2 | | totalvaluedailyliquidassetsfridayday3 | | totalvaluedailyliquidassetsfridayday4 | | totalvaluedailyliquidassetsfridayday5 | | totalvaluedailyliquidassetsfridayweek1 | | totalvaluedailyliquidassetsfridayweek2 | | totalvaluedailyliquidassetsfridayweek3 | | totalvaluedailyliquidassetsfridayweek4 | | totalvaluedailyliquidassetsfridayweek5 | | totalvalueliabilities | | totalvalueotherassets | | totalvalueportfoliosecurities | | totalvalueweeklyliquidassetsfridayweek1 | | totalvalueweeklyliquidassetsfridayweek2 | | totalvalueweeklyliquidassetsfridayweek3 | | totalvalueweeklyliquidassetsfridayweek4 | | totalvalueweeklyliquidassetsfridayweek5 | | transferagentcik | | transferagentfilenumber | | transferagentname |

n_mfp12_class_level_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp12_class_level_info",
    filename="n_mfp12_class_level_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp12_class_level_info"
    LIMIT 10
    """,
    output_dir="n_mfp12_class_level_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | classesid | | fridayweek1 | | fridayweek2 | | fridayweek2weeklygrossredemptions | | fridayweek2weeklygrosssubscriptions | | fridayweek3 | | fridayweek3weeklygrossredemptions | | fridayweek3weeklygrosssubscriptions | | fridayweek4 | | fridayweek4weeklygrossredemptions | | fridayweek4weeklygrosssubscriptions | | fridayweek5 | | fridayweek5weeklygrossredemptions | | fridayweek5weeklygrosssubscriptions | | mininitialinvestment | | nameofpersondescexpensepay | | netassetsofclass | | numberofsharesoutstanding | | personpayforfundflag | | sevendaynetyield | | totalforthemonthreportedweeklygrossredemptions | | totalforthemonthreportedweeklygrosssubscriptions | | weeklygrossredemptions | | weeklygrosssubscriptions |

n_mfp12_portfolio_security

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp12_portfolio_security",
    filename="n_mfp12_portfolio_security.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp12_portfolio_security"
    LIMIT 10
    """,
    output_dir="n_mfp12_portfolio_security_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amountprovidedbydemandfeatureissuer | | amountprovidedbyenhancement | | amountprovidedbyguarantor | | briefdescription | | cusipmember | | collateralissuersleiid | | couponoryield | | creditratingdesignatednrsro | | ctgryinvestmentsrprsntscollateral | | dailyliquidassetsecurityflag | | date | | demandfeatureconditionalflag | | demandfeatureratingornrsronameofnrsro | | demandfeatureratingornrsrorating | | designatednrsrodemandfeaturecreditratingdesignatednrsro | | designatednrsrodemandfeaturenameofdesignatednrsro | | designatednrsroenhancementcreditratingdesignatednrsro | | designatednrsroenhancementnameofdesignatednrsro | | designatednrsroguarantorcreditratingdesignatednrsro | | designatednrsroguarantornameofdesignatednrsro | | enhancementratingornrsronameofnrsro | | enhancementratingornrsrorating | | excludingvalueofanysponsorsupport | | explanatorynotes | | finallegalinvestmentmaturitydate | | from | | fundacqstnundrlyngsecurityflag | | guarantorratingornrsronameofnrsro | | guarantorratingornrsrorating | | isinid | | identityofdemandfeatureissuer | | identityoftheenhancementprovider | | identityoftheguarantor | | illiquidsecurityflag | | includingvalueofanysponsorsupport | | investmentcategory | | investmentmaturitydatewal | | investmentmaturitydatewam | | leiid | | nameofcollateralissuer | | nameofdesignatednrsro | | nameofissuer | | nameofnrsro | | otherinstrumentbriefdesc | | otheruniqueid | | percentageofmoneymarketfundnetassets | | principalamounttothenearestcent | | rating | | remainingperioddemandfeature | | repurchaseagreementopenflag | | scheduleofportfoliosecuritiesinfocik | | securitycategorizedatlevel3flag | | securitydemandfeatureflag | | securityeligibilityflag | | securityenhancementsflag | | securityguaranteeflag | | securityrated | | titleofissuer | | to | | totalvalueoffundposition | | typeofenhancement | | valueofcollateraltothenearestcent | | weeklyliquidassetsecurityflag | | yieldofthesecurityasofreportingdate |

n_mfp3

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3",
    filename="n_mfp3.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3"
    LIMIT 10
    """,
    output_dir="n_mfp3_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | administratorname | | amortizedcostportfoliosecurities | | assetbackedcommercialpaperamt | | averagelifematurity | | averageportfoliomaturity | | cash | | cashmgmtvehicleaffliatedfundflag | | ccc | | certificatedepositamt | | cik | | city | | dailynetassetvaluepersharedateseries | | dailynetassetvaluepershareseries | | depositionustreasurydebtamt | | feederfundcik | | feederfundflag | | feederfundseriesid | | filenumber | | filercredentialscik | | finalfilingflag | | financialcompanycommercialamt | | fundacqrdormrgdwthanthrflag | | fundretailmoneymarketflag | | govmoneymrktfundflag | | govtagencycouponpayingdebtamt | | govtagencynoncouponpayingdebtamt | | indppubaccountantname | | insurancecompanyfundagreementamt | | investmentcompanyamt | | leiofseries | | liquidityfeefundapplyflag | | masterfeederfundcik | | masterfeederfundname | | masterfeederfundseriesid | | masterfundflag | | moneymarketfundcategory | | name | | nameofseries | | nameofsigningofficer | | netassetofseries | | nonfinancialcompanycommercialamt | | nonnegotiabletimedepositamt | | nonussovereignsupranationaldebtamt | | otherassetbackedsecuritiesamt | | otherinstrumentamt | | otherinstrumentbriefdescription | | othermunicipalsecurityamt | | otherrepurchaseagreementamt | | percentagedailyliquidassets | | percentageweeklyliquidassets | | registrant | | registrantfullname | | registrantleiid | | reportdate | | securitiesactfilenumber | | seekstablepricepershare | | seriesfundinsucmpnysepaccntflag | | seriesid | | serieslevelinfonumberofsharesoutstanding | | signature | | signaturedate | | stablepricepershare | | statecountry | | submissiontype | | tenderoptionbondamt | | titleofsigningofficer | | totalliquidassetsnearpercentdate | | totalshareclassesinseries | | totalvaluedailyliquidassets | | totalvalueliabilities | | totalvalueotherassets | | totalvalueportfoliosecurities | | totalvalueweeklyliquidassets | | transferagentcik | | transferagentfilenumber | | transferagentname | | usgovtagencyrepurchaseagreementamt | | ustreasuryrepurchaseagreementamt | | variableratedemandnoteamt |

n_mfp3_acquired_merged_fund

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_acquired_merged_fund",
    filename="n_mfp3_acquired_merged_fund.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_acquired_merged_fund"
    LIMIT 10
    """,
    output_dir="n_mfp3_acquired_merged_fund_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | feederfundcik | | feederfundseriesid | | filenumber |

n_mfp3_adviser

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_adviser",
    filename="n_mfp3_adviser.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_adviser"
    LIMIT 10
    """,
    output_dir="n_mfp3_adviser_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | adviserfilenumber | | advisername |

n_mfp3_class_level_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_class_level_info",
    filename="n_mfp3_class_level_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_class_level_info"
    LIMIT 10
    """,
    output_dir="n_mfp3_class_level_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | beneficialrecordownercategorytype | | cancelledsharedate | | cancelledsharedollarvalue | | cancelledsharenumber | | classfullname | | classesid | | dailygrossredemptions | | dailygrosssubscriptions | | dailynetassetvaluepershareclass | | dailynetassetvaluepersharedateclass | | dailyshareholderflowdate | | mininitialinvestment | | nameofpersondescexpensepay | | netassetsofclass | | numberofsharesoutstanding | | otherinvestorcategory | | otherinvestortypedescription | | percentoutstandingsharesbeneficial | | percentoutstandingsharesrecord | | percentshareholdercompbrokerdealer | | percentshareholdercompdepositoryinst | | percentshareholdercompinsurance | | percentshareholdercompmunicipal | | percentshareholdercompnonfinancialcorp | | percentshareholdercompnonprofit | | percentshareholdercompother | | percentshareholdercomppensionplan | | percentshareholdercompprivatefunds | | percentshareholdercompreginvestment | | percentshareholdercompsovereignfund | | personpayforfundflag | | sevendaynetyielddate | | sevendaynetyieldvalue | | sharecancellationreportingperiod | | totalgrossredemptions | | totalgrosssubscriptions |

n_mfp3_portfolio_security

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_portfolio_security",
    filename="n_mfp3_portfolio_security.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_portfolio_security"
    LIMIT 10
    """,
    output_dir="n_mfp3_portfolio_security_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amountprovidedbydemandfeatureissuer | | amountprovidedbyenhancement | | amountprovidedbyguarantor | | briefdescription | | cusipmember | | collateralissuerscusipmember | | collateralissuerscoupon | | collateralissuersleiid | | coupon | | ctgryinvestmentsrprsntscollateral | | dailyliquidassetsecurityflag | | date | | demandfeatureconditionalflag | | demandfeatureratingornrsronameofnrsro | | demandfeatureratingornrsrorating | | enhancementratingornrsronameofnrsro | | enhancementratingornrsrorating | | excludingvalueofanysponsorsupport | | explanatorynotes | | finallegalinvestmentmaturitydate | | from | | fundacqstnundrlyngsecurityflag | | guarantorratingornrsronameofnrsro | | guarantorratingornrsrorating | | isinid | | identityofdemandfeatureissuer | | identityoftheenhancementprovider | | identityoftheguarantor | | illiquidsecurityflag | | includingvalueofanysponsorsupport | | investmentcategory | | investmentmaturitydatewal | | investmentmaturitydatewam | | leiid | | nameofccp | | nameofcollateralissuer | | nameofissuer | | nameofnrsro | | otherinstrumentbriefdesc | | otheruniqueid | | percentageofmoneymarketfundnetassets | | principalamounttothenearestcent | | rating | | remainingperioddemandfeature | | repurchaseagreementclearedflag | | repurchaseagreementopenflag | | repurchaseagreementtripartyflag | | scheduleofportfoliosecuritiesinfocik | | securitycategorizedatlevel3flag | | securitydemandfeatureflag | | securityeligibilityflag | | securityenhancementsflag | | securityguaranteeflag | | titleofissuer | | to | | typeofenhancement | | valueofcollateraltothenearestcent | | weeklyliquidassetsecurityflag | | yield | | yieldofthesecurityasofreportingdate |

n_mfp3_seven_day_gross_yield

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_seven_day_gross_yield",
    filename="n_mfp3_seven_day_gross_yield.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_seven_day_gross_yield"
    LIMIT 10
    """,
    output_dir="n_mfp3_seven_day_gross_yield_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | sevendaygrossyielddate | | sevendaygrossyieldvalue |

n_mfp3_sub_adviser

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_sub_adviser",
    filename="n_mfp3_sub_adviser.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_sub_adviser"
    LIMIT 10
    """,
    output_dir="n_mfp3_sub_adviser_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | subadviseradviserfilenumber | | subadviseradvisername |

n_mfp3_successor_fund

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_mfp3_successor_fund",
    filename="n_mfp3_successor_fund.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_mfp3_successor_fund"
    LIMIT 10
    """,
    output_dir="n_mfp3_successor_fund_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | feederfundcik | | feederfundseriesid | | filenumber |

n_px

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_px",
    filename="n_px.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_px"
    LIMIT 10
    """,
    output_dir="n_px_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | agentcity | | agentname | | agentstateorcountry | | agentstreet1 | | agentstreet2 | | agentzipcode | | amendmentno | | amendmenttype | | city | | confdeniedexpired | | confidentialtreatment | | confirmingcopyflag | | coverfilenumber | | dateexpireddenied | | datereported | | explanatorychoice | | explanatorynotes | | filenumber | | filerccc | | filercik | | investmentcompanytype | | isamendment | | leinumber | | livetestflag | | noticeexplanation | | otherincludedmanagerscount | | overrideinternetflag | | periodofreport | | reasonfornonconfidentiality | | registranttype | | reportcalendaryear | | reportquarteryear | | reporttype | | reportingcrdnumber | | reportingpersonname | | reportingpersonphone | | reportingsecfilenumber | | seriescount | | signaturereportingperson | | stateorcountry | | street1 | | street2 | | submissiontype | | txasofdate | | txprintedsignature | | txsignature | | txtitle | | yearorquarter | | zipcode |

n_px_investment_manager

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_px_investment_manager",
    filename="n_px_investment_manager.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_px_investment_manager"
    LIMIT 10
    """,
    output_dir="n_px_investment_manager_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | crdnumber | | form13ffilenumber | | leinumber | | name | | secfilenumber | | serialno |

n_px_other_manager

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_px_other_manager",
    filename="n_px_other_manager.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_px_other_manager"
    LIMIT 10
    """,
    output_dir="n_px_other_manager_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | crdnumber | | icaor13ffilenumber | | leinumber | | managername | | otherfilenumber |

n_px_secondary_record

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_px_secondary_record",
    filename="n_px_secondary_record.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_px_secondary_record"
    LIMIT 10
    """,
    output_dir="n_px_secondary_record_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | printedsign | | txasofdate | | txsignature | | txtitle |

n_px_series

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/n_px_series",
    filename="n_px_series.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "n_px_series"
    LIMIT 10
    """,
    output_dir="n_px_series_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | idofseries | | leiofseries | | nameofseries |

ncr

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ncr",
    filename="ncr.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ncr"
    LIMIT 10
    """,
    output_dir="ncr_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | contractrestrictionsdesc | | dateofdailyassets | | factsdescription | | filenumber | | filerccc | | filercik | | livetestflag | | optionaldisclosure | | percentageofdailyassets | | percentageofweeklyassets | | periodofreport | | reasondescription | | registrantcik | | registrantlei | | registrantname | | relationshipdescription | | reportdate | | schemaversion | | seriesid | | serieslei | | seriesname | | signature | | signaturedate | | signaturename | | signaturetitle | | submissiontype | | supportamtdescription | | supportdate | | supportdescription | | supportpersonname | | termofsupport |

nport_p

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/nport_p",
    filename="nport_p.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "nport_p"
    LIMIT 10
    """,
    output_dir="nport_p_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregateconditionisnoncashcollateral | | amt | | amtpayaftoneyrbanksborr | | amtpayaftoneyrctrldcomp | | amtpayaftoneyrothaffil | | amtpayaftoneyrother | | amtpayoneyrbanksborr | | amtpayoneyrctrldcomp | | amtpayoneyrothaffil | | amtpayoneyrother | | assetsattrmiscsec | | assetsinvested | | backtestingresults | | ccc | | cik | | classid | | collatrl | | creditcontractsfuturecategoryinstrmon1netrealizedgain | | creditcontractsfuturecategoryinstrmon1netunrealizedappr | | creditcontractsfuturecategoryinstrmon2netrealizedgain | | creditcontractsfuturecategoryinstrmon2netunrealizedappr | | creditcontractsfuturecategoryinstrmon3netrealizedgain | | creditcontractsfuturecategoryinstrmon3netunrealizedappr | | creditcontractsmon1netrealizedgain | | creditcontractsmon1netunrealizedappr | | creditcontractsmon2netrealizedgain | | creditcontractsmon2netunrealizedappr | | creditcontractsmon3netrealizedgain | | creditcontractsmon3netunrealizedappr | | creditcontractsoptioncategoryinstrmon1netrealizedgain | | creditcontractsoptioncategoryinstrmon1netunrealizedappr | | creditcontractsoptioncategoryinstrmon2netrealizedgain | | creditcontractsoptioncategoryinstrmon2netunrealizedappr | | creditcontractsoptioncategoryinstrmon3netrealizedgain | | creditcontractsoptioncategoryinstrmon3netunrealizedappr | | creditcontractsothercategoryinstrmon1netrealizedgain | | creditcontractsothercategoryinstrmon1netunrealizedappr | | creditcontractsothercategoryinstrmon2netrealizedgain | | creditcontractsothercategoryinstrmon2netunrealizedappr | | creditcontractsothercategoryinstrmon3netrealizedgain | | creditcontractsothercategoryinstrmon3netunrealizedappr | | creditcontractsswapcategoryinstrmon1netrealizedgain | | creditcontractsswapcategoryinstrmon1netunrealizedappr | | creditcontractsswapcategoryinstrmon2netrealizedgain | | creditcontractsswapcategoryinstrmon2netunrealizedappr | | creditcontractsswapcategoryinstrmon3netrealizedgain | | creditcontractsswapcategoryinstrmon3netunrealizedappr | | creditcontractsswaptioncategoryinstrmon1netrealizedgain | | creditcontractsswaptioncategoryinstrmon1netunrealizedappr | | creditcontractsswaptioncategoryinstrmon2netrealizedgain | | creditcontractsswaptioncategoryinstrmon2netunrealizedappr | | creditcontractsswaptioncategoryinstrmon3netrealizedgain | | creditcontractsswaptioncategoryinstrmon3netunrealizedappr | | creditcontractswarrantcategoryinstrmon1netrealizedgain | | creditcontractswarrantcategoryinstrmon1netunrealizedappr | | creditcontractswarrantcategoryinstrmon2netrealizedgain | | creditcontractswarrantcategoryinstrmon2netunrealizedappr | | creditcontractswarrantcategoryinstrmon3netrealizedgain | | creditcontractswarrantcategoryinstrmon3netunrealizedappr | | creditsprdrisknoninvstgradeperiod10yr | | creditsprdrisknoninvstgradeperiod1yr | | creditsprdrisknoninvstgradeperiod30yr | | creditsprdrisknoninvstgradeperiod3mon | | creditsprdrisknoninvstgradeperiod5yr | | cshnotrptdincord | | datesigned | | delaydeliv | | derivcurrencyexposurepct | | derivexposurepct | | derivintrateexposurepct | | documents | | equitycontractsforwardcategoryinstrmon1netrealizedgain | | equitycontractsforwardcategoryinstrmon1netunrealizedappr | | equitycontractsforwardcategoryinstrmon2netrealizedgain | | equitycontractsforwardcategoryinstrmon2netunrealizedappr | | equitycontractsforwardcategoryinstrmon3netrealizedgain | | equitycontractsforwardcategoryinstrmon3netunrealizedappr | | equitycontractsfuturecategoryinstrmon1netrealizedgain | | equitycontractsfuturecategoryinstrmon1netunrealizedappr | | equitycontractsfuturecategoryinstrmon2netrealizedgain | | equitycontractsfuturecategoryinstrmon2netunrealizedappr | | equitycontractsfuturecategoryinstrmon3netrealizedgain | | equitycontractsfuturecategoryinstrmon3netunrealizedappr | | equitycontractsmon1netrealizedgain | | equitycontractsmon1netunrealizedappr | | equitycontractsmon2netrealizedgain | | equitycontractsmon2netunrealizedappr | | equitycontractsmon3netrealizedgain | | equitycontractsmon3netunrealizedappr | | equitycontractsoptioncategoryinstrmon1netrealizedgain | | equitycontractsoptioncategoryinstrmon1netunrealizedappr | | equitycontractsoptioncategoryinstrmon2netrealizedgain | | equitycontractsoptioncategoryinstrmon2netunrealizedappr | | equitycontractsoptioncategoryinstrmon3netrealizedgain | | equitycontractsoptioncategoryinstrmon3netunrealizedappr | | equitycontractsothercategoryinstrmon1netrealizedgain | | equitycontractsothercategoryinstrmon1netunrealizedappr | | equitycontractsothercategoryinstrmon2netrealizedgain | | equitycontractsothercategoryinstrmon2netunrealizedappr | | equitycontractsothercategoryinstrmon3netrealizedgain | | equitycontractsothercategoryinstrmon3netunrealizedappr | | equitycontractsswapcategoryinstrmon1netrealizedgain | | equitycontractsswapcategoryinstrmon1netunrealizedappr | | equitycontractsswapcategoryinstrmon2netrealizedgain | | equitycontractsswapcategoryinstrmon2netunrealizedappr | | equitycontractsswapcategoryinstrmon3netrealizedgain | | equitycontractsswapcategoryinstrmon3netunrealizedappr | | equitycontractsswaptioncategoryinstrmon1netrealizedgain | | equitycontractsswaptioncategoryinstrmon1netunrealizedappr | | equitycontractsswaptioncategoryinstrmon2netrealizedgain | | equitycontractsswaptioncategoryinstrmon2netunrealizedappr | | equitycontractsswaptioncategoryinstrmon3netrealizedgain | | equitycontractsswaptioncategoryinstrmon3netunrealizedappr | | equitycontractswarrantcategoryinstrmon1netrealizedgain | | equitycontractswarrantcategoryinstrmon1netunrealizedappr | | equitycontractswarrantcategoryinstrmon2netrealizedgain | | equitycontractswarrantcategoryinstrmon2netunrealizedappr | | equitycontractswarrantcategoryinstrmon3netrealizedgain | | equitycontractswarrantcategoryinstrmon3netunrealizedappr | | foreignexchgcontractsforwardcategoryinstrmon1netrealizedgain | | foreignexchgcontractsforwardcategoryinstrmon1netunrealizedappr | | foreignexchgcontractsforwardcategoryinstrmon2netrealizedgain | | foreignexchgcontractsforwardcategoryinstrmon2netunrealizedappr | | foreignexchgcontractsforwardcategoryinstrmon3netrealizedgain | | foreignexchgcontractsforwardcategoryinstrmon3netunrealizedappr | | foreignexchgcontractsfuturecategoryinstrmon1netrealizedgain | | foreignexchgcontractsfuturecategoryinstrmon1netunrealizedappr | | foreignexchgcontractsfuturecategoryinstrmon2netrealizedgain | | foreignexchgcontractsfuturecategoryinstrmon2netunrealizedappr | | foreignexchgcontractsfuturecategoryinstrmon3netrealizedgain | | foreignexchgcontractsfuturecategoryinstrmon3netunrealizedappr | | foreignexchgcontractsmon1netrealizedgain | | foreignexchgcontractsmon1netunrealizedappr | | foreignexchgcontractsmon2netrealizedgain | | foreignexchgcontractsmon2netunrealizedappr | | foreignexchgcontractsmon3netrealizedgain | | foreignexchgcontractsmon3netunrealizedappr | | foreignexchgcontractsoptioncategoryinstrmon1netrealizedgain | | foreignexchgcontractsoptioncategoryinstrmon1netunrealizedappr | | foreignexchgcontractsoptioncategoryinstrmon2netrealizedgain | | foreignexchgcontractsoptioncategoryinstrmon2netunrealizedappr | | foreignexchgcontractsoptioncategoryinstrmon3netrealizedgain | | foreignexchgcontractsoptioncategoryinstrmon3netunrealizedappr | | foreignexchgcontractsothercategoryinstrmon1netrealizedgain | | foreignexchgcontractsothercategoryinstrmon1netunrealizedappr | | foreignexchgcontractsothercategoryinstrmon2netrealizedgain | | foreignexchgcontractsothercategoryinstrmon2netunrealizedappr | | foreignexchgcontractsothercategoryinstrmon3netrealizedgain | | foreignexchgcontractsothercategoryinstrmon3netunrealizedappr | | foreignexchgcontractsswapcategoryinstrmon1netrealizedgain | | foreignexchgcontractsswapcategoryinstrmon1netunrealizedappr | | foreignexchgcontractsswapcategoryinstrmon2netrealizedgain | | foreignexchgcontractsswapcategoryinstrmon2netunrealizedappr | | foreignexchgcontractsswapcategoryinstrmon3netrealizedgain | | foreignexchgcontractsswapcategoryinstrmon3netunrealizedappr | | foreignexchgcontractsswaptioncategoryinstrmon1netrealizedgain | | foreignexchgcontractsswaptioncategoryinstrmon1netunrealizedappr | | foreignexchgcontractsswaptioncategoryinstrmon2netrealizedgain | | foreignexchgcontractsswaptioncategoryinstrmon2netunrealizedappr | | foreignexchgcontractsswaptioncategoryinstrmon3netrealizedgain | | foreignexchgcontractsswaptioncategoryinstrmon3netunrealizedappr | | foreignexchgcontractswarrantcategoryinstrmon1netrealizedgain | | foreignexchgcontractswarrantcategoryinstrmon1netunrealizedappr | | foreignexchgcontractswarrantcategoryinstrmon2netrealizedgain | | foreignexchgcontractswarrantcategoryinstrmon2netunrealizedappr | | foreignexchgcontractswarrantcategoryinstrmon3netrealizedgain | | foreignexchgcontractswarrantcategoryinstrmon3netunrealizedappr | | forwardcategoryinstrmon1netrealizedgain | | forwardcategoryinstrmon1netunrealizedappr | | forwardcategoryinstrmon2netrealizedgain | | forwardcategoryinstrmon2netunrealizedappr | | forwardcategoryinstrmon3netrealizedgain | | forwardcategoryinstrmon3netunrealizedappr | | futurecategoryinstrmon1netrealizedgain | | futurecategoryinstrmon1netunrealizedappr | | futurecategoryinstrmon2netrealizedgain | | futurecategoryinstrmon2netunrealizedappr | | futurecategoryinstrmon3netrealizedgain | | futurecategoryinstrmon3netunrealizedappr | | indexidentifier | | instrmon1netrealizedgain | | instrmon1netunrealizedappr | | instrmon2netrealizedgain | | instrmon2netunrealizedappr | | instrmon3netrealizedgain | | instrmon3netunrealizedappr | | interestrtcontractsforwardcategoryinstrmon1netrealizedgain | | interestrtcontractsforwardcategoryinstrmon1netunrealizedappr | | interestrtcontractsforwardcategoryinstrmon2netrealizedgain | | interestrtcontractsforwardcategoryinstrmon2netunrealizedappr | | interestrtcontractsforwardcategoryinstrmon3netrealizedgain | | interestrtcontractsforwardcategoryinstrmon3netunrealizedappr | | interestrtcontractsfuturecategoryinstrmon1netrealizedgain | | interestrtcontractsfuturecategoryinstrmon1netunrealizedappr | | interestrtcontractsfuturecategoryinstrmon2netrealizedgain | | interestrtcontractsfuturecategoryinstrmon2netunrealizedappr | | interestrtcontractsfuturecategoryinstrmon3netrealizedgain | | interestrtcontractsfuturecategoryinstrmon3netunrealizedappr | | interestrtcontractsmon1netrealizedgain | | interestrtcontractsmon1netunrealizedappr | | interestrtcontractsmon2netrealizedgain | | interestrtcontractsmon2netunrealizedappr | | interestrtcontractsmon3netrealizedgain | | interestrtcontractsmon3netunrealizedappr | | interestrtcontractsoptioncategoryinstrmon1netrealizedgain | | interestrtcontractsoptioncategoryinstrmon1netunrealizedappr | | interestrtcontractsoptioncategoryinstrmon2netrealizedgain | | interestrtcontractsoptioncategoryinstrmon2netunrealizedappr | | interestrtcontractsoptioncategoryinstrmon3netrealizedgain | | interestrtcontractsoptioncategoryinstrmon3netunrealizedappr | | interestrtcontractsothercategoryinstrmon1netrealizedgain | | interestrtcontractsothercategoryinstrmon1netunrealizedappr | | interestrtcontractsothercategoryinstrmon2netrealizedgain | | interestrtcontractsothercategoryinstrmon2netunrealizedappr | | interestrtcontractsothercategoryinstrmon3netrealizedgain | | interestrtcontractsothercategoryinstrmon3netunrealizedappr | | interestrtcontractsswapcategoryinstrmon1netrealizedgain | | interestrtcontractsswapcategoryinstrmon1netunrealizedappr | | interestrtcontractsswapcategoryinstrmon2netrealizedgain | | interestrtcontractsswapcategoryinstrmon2netunrealizedappr | | interestrtcontractsswapcategoryinstrmon3netrealizedgain | | interestrtcontractsswapcategoryinstrmon3netunrealizedappr | | interestrtcontractsswaptioncategoryinstrmon1netrealizedgain | | interestrtcontractsswaptioncategoryinstrmon1netunrealizedappr | | interestrtcontractsswaptioncategoryinstrmon2netrealizedgain | | interestrtcontractsswaptioncategoryinstrmon2netunrealizedappr | | interestrtcontractsswaptioncategoryinstrmon3netrealizedgain | | interestrtcontractsswaptioncategoryinstrmon3netunrealizedappr | | interestrtcontractswarrantcategoryinstrmon1netrealizedgain | | interestrtcontractswarrantcategoryinstrmon1netunrealizedappr | | interestrtcontractswarrantcategoryinstrmon2netrealizedgain | | interestrtcontractswarrantcategoryinstrmon2netunrealizedappr | | interestrtcontractswarrantcategoryinstrmon3netrealizedgain | | interestrtcontractswarrantcategoryinstrmon3netunrealizedappr | | invstcat | | invstcatconditionalinvstcat | | invstcatconditionalotherdesc | | isconfidential | | isfinalfiling | | isnoncashcollateral | | liquidpref | | mediandailyvarpct | | medianvarratiopct | | mon1netrealizedgain | | mon1netunrealizedappr | | mon2flowredemption | | mon2flowreinvestment | | mon2flowsales | | mon2netrealizedgain | | mon2netunrealizedappr | | mon3flowredemption | | mon3flowreinvestment | | mon3flowsales | | mon3netrealizedgain | | mon3netunrealizedappr | | monthlytotreturnclassid | | namedesignatedindex | | nameofapplicant | | netassets | | netrealizedgain | | netunrealizedappr | | noofbusinessdaysinexcess | | optioncategoryinstrmon1netrealizedgain | | optioncategoryinstrmon1netunrealizedappr | | optioncategoryinstrmon2netrealizedgain | | optioncategoryinstrmon2netunrealizedappr | | optioncategoryinstrmon3netrealizedgain | | optioncategoryinstrmon3netunrealizedappr | | othmon2netrealizedgain | | othmon2netunrealizedappr | | othmon3netrealizedgain | | othmon3netunrealizedappr | | othercategoryinstrmon1netrealizedgain | | othercategoryinstrmon1netunrealizedappr | | othercategoryinstrmon2netrealizedgain | | othercategoryinstrmon2netunrealizedappr | | othercategoryinstrmon3netrealizedgain | | othercategoryinstrmon3netunrealizedappr | | othercontractsforwardcategoryinstrmon1netrealizedgain | | othercontractsforwardcategoryinstrmon1netunrealizedappr | | othercontractsforwardcategoryinstrmon2netrealizedgain | | othercontractsforwardcategoryinstrmon2netunrealizedappr | | othercontractsforwardcategoryinstrmon3netrealizedgain | | othercontractsforwardcategoryinstrmon3netunrealizedappr | | othercontractsfuturecategoryinstrmon1netrealizedgain | | othercontractsfuturecategoryinstrmon1netunrealizedappr | | othercontractsfuturecategoryinstrmon2netrealizedgain | | othercontractsfuturecategoryinstrmon2netunrealizedappr | | othercontractsfuturecategoryinstrmon3netrealizedgain | | othercontractsfuturecategoryinstrmon3netunrealizedappr | | othercontractsmon1netrealizedgain | | othercontractsmon1netunrealizedappr | | othercontractsmon2netrealizedgain | | othercontractsmon2netunrealizedappr | | othercontractsmon3netrealizedgain | | othercontractsmon3netunrealizedappr | | othercontractsoptioncategoryinstrmon1netrealizedgain | | othercontractsoptioncategoryinstrmon1netunrealizedappr | | othercontractsoptioncategoryinstrmon2netrealizedgain | | othercontractsoptioncategoryinstrmon2netunrealizedappr | | othercontractsoptioncategoryinstrmon3netrealizedgain | | othercontractsoptioncategoryinstrmon3netunrealizedappr | | othercontractsothercategoryinstrmon1netrealizedgain | | othercontractsothercategoryinstrmon1netunrealizedappr | | othercontractsothercategoryinstrmon2netrealizedgain | | othercontractsothercategoryinstrmon2netunrealizedappr | | othercontractsothercategoryinstrmon3netrealizedgain | | othercontractsothercategoryinstrmon3netunrealizedappr | | othercontractsswapcategoryinstrmon1netrealizedgain | | othercontractsswapcategoryinstrmon1netunrealizedappr | | othercontractsswapcategoryinstrmon2netrealizedgain | | othercontractsswapcategoryinstrmon2netunrealizedappr | | othercontractsswapcategoryinstrmon3netrealizedgain | | othercontractsswapcategoryinstrmon3netunrealizedappr | | othercontractsswaptioncategoryinstrmon1netrealizedgain | | othercontractsswaptioncategoryinstrmon1netunrealizedappr | | othercontractsswaptioncategoryinstrmon2netrealizedgain | | othercontractsswaptioncategoryinstrmon2netunrealizedappr | | othercontractsswaptioncategoryinstrmon3netrealizedgain | | othercontractsswaptioncategoryinstrmon3netunrealizedappr | | othercontractswarrantcategoryinstrmon1netrealizedgain | | othercontractswarrantcategoryinstrmon1netunrealizedappr | | othercontractswarrantcategoryinstrmon2netrealizedgain | | othercontractswarrantcategoryinstrmon2netunrealizedappr | | othercontractswarrantcategoryinstrmon3netrealizedgain | | othercontractswarrantcategoryinstrmon3netunrealizedappr | | otherdesc | | period10yr | | period1yr | | period30yr | | period3mon | | period5yr | | redemption | | regcik | | regcity | | regcountry | | regfilenumber | | reglei | | regname | | regphone | | regstate | | regstateconditionalregcountry | | regstreet1 | | regstreet2 | | regziporpostalcode | | reinvestment | | reppddate | | reppdend | | rtn1 | | rtn2 | | rtn3 | | sales | | seriesclassinfoseriesid | | seriesid | | serieslei | | seriesname | | signature | | signername | | standbycommit | | submissiontype | | swapcategoryinstrmon1netrealizedgain | | swapcategoryinstrmon1netunrealizedappr | | swapcategoryinstrmon2netrealizedgain | | swapcategoryinstrmon2netunrealizedappr | | swapcategoryinstrmon3netrealizedgain | | swapcategoryinstrmon3netunrealizedappr | | swaptioncategoryinstrmon1netrealizedgain | | swaptioncategoryinstrmon1netunrealizedappr | | swaptioncategoryinstrmon2netrealizedgain | | swaptioncategoryinstrmon2netunrealizedappr | | swaptioncategoryinstrmon3netrealizedgain | | swaptioncategoryinstrmon3netunrealizedappr | | title | | totassets | | totliabs | | warrantcategoryinstrmon1netrealizedgain | | warrantcategoryinstrmon1netunrealizedappr | | warrantcategoryinstrmon2netrealizedgain | | warrantcategoryinstrmon2netunrealizedappr | | warrantcategoryinstrmon3netrealizedgain | | warrantcategoryinstrmon3netunrealizedappr |

nport_p_borrower

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/nport_p_borrower",
    filename="nport_p_borrower.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "nport_p_borrower"
    LIMIT 10
    """,
    output_dir="nport_p_borrower_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggrval | | borrowerlei | | borrowername |

nport_p_cur_metric

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/nport_p_cur_metric",
    filename="nport_p_cur_metric.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "nport_p_cur_metric"
    LIMIT 10
    """,
    output_dir="nport_p_cur_metric_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | curmetriccurcd | | intrstrtriskdv01period10yr | | intrstrtriskdv01period1yr | | intrstrtriskdv01period30yr | | intrstrtriskdv01period3mon | | intrstrtriskdv01period5yr | | intrstrtriskdv100period10yr | | intrstrtriskdv100period1yr | | intrstrtriskdv100period30yr | | intrstrtriskdv100period3mon | | intrstrtriskdv100period5yr |

nport_p_explntr_note

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/nport_p_explntr_note",
    filename="nport_p_explntr_note.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "nport_p_explntr_note"
    LIMIT 10
    """,
    output_dir="nport_p_explntr_note_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | note | | noteitem |

nport_p_invst_or_sec

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/nport_p_invst_or_sec",
    filename="nport_p_invst_or_sec.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "nport_p_invst_or_sec"
    LIMIT 10
    """,
    output_dir="nport_p_invst_or_sec_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amount | | amtcurpur | | amtcursold | | annualizedrt | | areintrstpmntsinarrs | | assetcat | | assetconditionalassetcat | | balance | | cashcollateralconditioniscashcollateral | | cashcollateralval | | centralcounterparty | | collateralcd | | collateralval | | componentidentifierscusipvalue | | componentidentifiersisinvalue | | componentidentifierstickervalue | | convratio | | counterpartiescounterpartylei | | counterpartiescounterpartyname | | counterpartyinfolei | | counterpartyinfoname | | counterpartylei | | counterpartyname | | couponkind | | curcd | | curpur | | cursold | | currencyconditionalcurcd | | currencyinfocurcd | | cusip | | cusipvalue | | dbtsecrefinstrumentcurcd | | dbtsecrefinstrumentname | | dbtsecrefinstrumenttitle | | delta | | derivaddlinfoassetcat | | derivaddlinfobalance | | derivaddlinfocurcd | | derivaddlinfocusip | | derivaddlinfodescothunits | | derivaddlinfoidentifiersotherotherdesc | | derivaddlinfoidentifiersothervalue | | derivaddlinfoidentifierstickervalue | | derivaddlinfoinvcountry | | derivaddlinfoissuercat | | derivaddlinfoissuerconditionaldesc | | derivaddlinfoissuerconditionalissuercat | | derivaddlinfolei | | derivaddlinfoname | | derivaddlinfopctval | | derivaddlinfotitle | | derivaddlinfounits | | derivaddlinfovalusd | | derivcat | | desc | | descothunits | | descrefinstrmntindexbasketinfoindexidentifier | | descrefinstrmntindexbasketinfoindexname | | descrefinstrmntindexbasketinfonarrativedesc | | descrefinstrmntotherrefinstidentifierscusipvalue | | descrefinstrmntotherrefinstidentifiersisinvalue | | descrefinstrmntotherrefinstidentifiersotherotherdesc | | descrefinstrmntotherrefinstidentifiersothervalue | | descrefinstrmntotherrefinstidentifierstickervalue | | descrefinstrmntotherrefinstissuetitle | | descrefinstrmntotherrefinstissuername | | exchangert | | exerciseprice | | exercisepricecurcd | | expdate | | expdt | | fairvallevel | | fixedorfloating | | fixedpmntdescamount | | fixedpmntdesccurcd | | fixedpmntdescfixedorfloating | | fixedpmntdescfixedrt | | fixedrecdescamount | | fixedrecdesccurcd | | fixedrecdescfixedorfloating | | fixedrecdescfixedrt | | fixedrt | | floatingpmntdesccurcd | | floatingpmntdescfixedorfloating | | floatingpmntdescfloatingrtindex | | floatingpmntdescfloatingrtspread | | floatingpmntdescpmntamt | | floatingrecdesccurcd | | floatingrecdescfixedorfloating | | floatingrecdescfloatingrtindex | | floatingrecdescfloatingrtspread | | floatingrecdescpmntamt | | floatingrecdescrtresettenorsrtresettenorratetenor | | floatingrecdescrtresettenorsrtresettenorratetenorunit | | floatingrecdescrtresettenorsrtresettenorresetdt | | floatingrecdescrtresettenorsrtresettenorresetdtunit | | floatingrtindex | | floatingrtspread | | futrderivcounterpartiescounterpartylei | | futrderivcounterpartiescounterpartyname | | futrderivcurcd | | futrderivderivcat | | futrderivdescrefinstrmntindexbasketinfoindexidentifier | | futrderivdescrefinstrmntindexbasketinfoindexname | | futrderivdescrefinstrmntotherrefinstidentifierscusipvalue | | futrderivdescrefinstrmntotherrefinstidentifiersisinvalue | | futrderivdescrefinstrmntotherrefinstidentifiersotherotherdesc | | futrderivdescrefinstrmntotherrefinstidentifiersothervalue | | futrderivdescrefinstrmntotherrefinstidentifierstickervalue | | futrderivdescrefinstrmntotherrefinstissuetitle | | futrderivdescrefinstrmntotherrefinstissuername | | futrderivexpdate | | futrderivnotionalamt | | futrderivpayoffprof | | fwdderivamtcurpur | | fwdderivamtcursold | | fwdderivcounterpartiescounterpartylei | | fwdderivcounterpartiescounterpartyname | | fwdderivcurpur | | fwdderivcursold | | fwdderivderivaddlinfoassetcat | | fwdderivderivaddlinfobalance | | fwdderivderivaddlinfocurcd | | fwdderivderivaddlinfocusip | | fwdderivderivaddlinfoidentifiersotherotherdesc | | fwdderivderivaddlinfoidentifiersothervalue | | fwdderivderivaddlinfoinvcountry | | fwdderivderivaddlinfoissuerconditionaldesc | | fwdderivderivaddlinfoissuerconditionalissuercat | | fwdderivderivaddlinfolei | | fwdderivderivaddlinfoname | | fwdderivderivaddlinfopctval | | fwdderivderivaddlinfotitle | | fwdderivderivaddlinfounits | | fwdderivderivaddlinfovalusd | | fwdderivderivcat | | fwdderivsettlementdt | | fwdderivunrealizedappr | | identifierscusipvalue | | identifiersisinvalue | | identifiersotherotherdesc | | identifiersothervalue | | identifierstickervalue | | indexbasketinfoindexidentifier | | indexbasketinfoindexname | | indexbasketinfonarrativedesc | | indexname | | invcountry | | invothcountry | | invstcatconditionaldesc | | invstorsectitle | | iscashcollateral | | iscleared | | iscontngtconvrtbl | | isdefault | | isloanbyfund | | ismandatoryconvrtbl | | ispaidkind | | isrestrictedsec | | istriparty | | isinvalue | | issuetitle | | issuercat | | issuerconditionaldesc | | issuerconditionalissuercat | | issuername | | lei | | loanbyfundconditionisloanbyfund | | loanval | | maturitydt | | name | | narrativedesc | | nestedderivinfofutrderivcurcd | | nestedderivinfofwdderivderivcat | | nestedderivinfoswapderivcounterpartiescounterpartylei | | nestedderivinfoswapderivcounterpartiescounterpartyname | | nestedderivinfoswapderivcurcd | | nestedderivinfoswapderivderivcat | | nestedderivinfoswapderivdescrefinstrmntotherrefinstissuetitle | | nestedderivinfoswapderivdescrefinstrmntotherrefinstissuername | | nestedderivinfoswapderivnotionalamt | | nestedderivinfoswapderivterminationdt | | noncashcollateralconditionisnoncashcollateral | | noncashcollateralval | | notclearedcentcpartyiscleared | | notionalamt | | notionalamtamt | | notionalamtcurcd | | optionswaptionwarrantderivcounterpartiescounterpartylei | | optionswaptionwarrantderivcounterpartiescounterpartyname | | optionswaptionwarrantderivcurcd | | optionswaptionwarrantderivdelta | | optionswaptionwarrantderivderivcat | | optionswaptionwarrantderivunrealizedappr | | othderivcounterpartiescounterpartylei | | othderivcounterpartiescounterpartyname | | othderivdelta | | othderivderivcat | | othderivdescrefinstrmntotherrefinstidentifiersothervalue | | othderivunrealizedappr | | othdesc | | othindcurcd | | othindisscurcd | | othindname | | othindnotamt | | othindvalue | | otherdesc | | otherotherdesc | | otherpmntdesc | | otherpmntdescfixedorfloating | | otherrecdesc | | otherrecdescfixedorfloating | | otherrefinstidentifierscusipvalue | | otherrefinstidentifiersisinvalue | | otherrefinstidentifiersotherotherdesc | | otherrefinstidentifiersothervalue | | otherrefinstidentifierstickervalue | | otherrefinstissuetitle | | otherrefinstissuername | | othervalue | | payoffprof | | payoffprofile | | pctval | | pmntamt | | pmntcurcd | | principalamt | | principalcd | | putorcall | | ratetenor | | ratetenorunit | | rcptcurcd | | repurchaseagrmtmaturitydt | | repurchasecollateralinvstcat | | repurchasecollateralinvstcatconditionalinvstcat | | repurchasecollateralprincipalamt | | repurchasert | | resetdt | | resetdtunit | | rtresettenorratetenor | | rtresettenorratetenorunit | | rtresettenorresetdt | | rtresettenorresetdtunit | | rtresettenorsrtresettenorratetenor | | rtresettenorsrtresettenorratetenorunit | | rtresettenorsrtresettenorresetdt | | rtresettenorsrtresettenorresetdtunit | | securitylendingisnoncashcollateral | | settlementdt | | shareno | | swapderivamtcurpur | | swapderivamtcursold | | swapderivcounterpartiescounterpartylei | | swapderivcounterpartiescounterpartyname | | swapderivcurcd | | swapderivcurpur | | swapderivcursold | | swapderivderivaddlinfoassetcat | | swapderivderivaddlinfobalance | | swapderivderivaddlinfocurcd | | swapderivderivaddlinfocusip | | swapderivderivaddlinfoidentifiersotherotherdesc | | swapderivderivaddlinfoidentifiersothervalue | | swapderivderivaddlinfoinvcountry | | swapderivderivaddlinfoissuercat | | swapderivderivaddlinfoissuerconditionaldesc | | swapderivderivaddlinfoissuerconditionalissuercat | | swapderivderivaddlinfolei | | swapderivderivaddlinfoname | | swapderivderivaddlinfopctval | | swapderivderivaddlinfotitle | | swapderivderivaddlinfounits | | swapderivderivaddlinfovalusd | | swapderivderivcat | | swapderivdescrefinstrmntindexbasketinfoindexidentifier | | swapderivdescrefinstrmntotherrefinstidentifierscusipvalue | | swapderivdescrefinstrmntotherrefinstidentifiersisinvalue | | swapderivdescrefinstrmntotherrefinstidentifiersotherotherdesc | | swapderivdescrefinstrmntotherrefinstidentifiersothervalue | | swapderivdescrefinstrmntotherrefinstidentifierstickervalue | | swapderivdescrefinstrmntotherrefinstissuetitle | | swapderivdescrefinstrmntotherrefinstissuername | | swapderivfixedpmntdesccurcd | | swapderivfixedrecdescamount | | swapderivfixedrecdesccurcd | | swapderivfixedrecdescfixedorfloating | | swapderivfixedrecdescfixedrt | | swapderivfloatingpmntdesccurcd | | swapderivfloatingpmntdescfixedorfloating | | swapderivfloatingrecdesccurcd | | swapderivfloatingrecdescfixedorfloating | | swapderivfloatingrecdescfloatingrtindex | | swapderivfloatingrecdescfloatingrtspread | | swapderivfloatingrecdescpmntamt | | swapderivnotionalamt | | swapderivpmntcurcd | | swapderivrcptcurcd | | swapderivsettlementdt | | swapderivterminationdt | | swapderivunrealizedappr | | swapderivupfrontpmnt | | swapderivupfrontrcpt | | swapflag | | terminationdt | | tickervalue | | transcat | | units | | unrealizedappr | | upfrontpmnt | | upfrontrcpt | | valusd | | value | | writtenorpur |

proxy_voting_record

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/proxy_voting_record",
    filename="proxy_voting_record.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "proxy_voting_record"
    LIMIT 10
    """,
    output_dir="proxy_voting_record_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | categorytype | | cusip | | figi | | howvoted | | isin | | issuername | | managementrecommendation | | meetingdate | | othervotedescription | | sharesonloan | | sharesvoted | | votedescription | | votemanagerothermanager | | voteotherinfo | | voterecordsharesvoted | | voteseries | | votesource |

qualif

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/qualif",
    filename="qualif.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "qualif"
    LIMIT 10
    """,
    output_dir="qualif_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | act | | cik | | entityname | | filenumber | | finaleffectivenessdispdate | | finaleffectivenessdisptime | | form | | submissiontype |

sbse_c

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sbse_c",
    filename="sbse_c.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sbse_c"
    LIMIT 10
    """,
    output_dir="sbse_c_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | addresscity | | addressstateorcountry | | addressstreet1 | | addresszipcode | | amendeditemslist | | applicantaddresscity | | applicantaddressstateorcountry | | applicantaddressstreet1 | | applicantaddressstreet2 | | applicantaddresszipcode | | applicantcik | | applicantdatapagefiveapplicantname | | applicantdatapagefiveisforeignregulatory | | applicantdatapagefourapplicantname | | applicantdatapageoneapplicantcik | | applicantdatapageoneapplicantuic | | applicantdatapageonebusinesstelephonenumber | | applicantdatapageonechiefcomplianceofficeremailaddress | | applicantdatapageonechiefcomplianceofficerphone | | applicantdatapageonechiefcomplianceofficertitle | | applicantdatapageonecontactemployeetitle | | applicantdatapageonefullapplicantname | | applicantdatapageonemainaddresscity | | applicantdatapageonemainaddressstateorcountry | | applicantdatapageonemainaddressstreet1 | | applicantdatapageonemainaddresszipcode | | applicantdatapageonewebsiteurl | | applicantdatapagethreeapplicantname | | applicantdatapagethreeiscontrolthroughagreement | | applicantdatapagethreeisonbehalf | | applicantdatapagethreeisrecordskept | | applicantdatapagethreeiswhollyorpartiallyfinance | | applicantdatapagetwoapplicantname | | applicantdatapagetwodescriptionbusiness | | applicantdatapagetwoiscommissiondetermine | | applicantdatapagetwoisholdfunds | | applicantdatapagetwoisnonresidententity | | applicantdatapagetwoisselfdetermine | | applicantdatapagetwoissubjecttoregulator | | applicantdatapagetwoissucceeding | | applicantdatapagetwoisswapdealer | | applicantdatapagetwoisswapparticipant | | applicantname | | applicantnfaid | | applicantnfano | | applicantnfanumber | | applicantonechiefcomplianceofficeremailaddress | | applicantonechiefcomplianceofficerofficernamefirstname | | applicantonechiefcomplianceofficerofficernamelastname | | applicantonechiefcomplianceofficerofficernamemiddlename | | applicantonechiefcomplianceofficerphone | | applicantonechiefcomplianceofficertitle | | applicantonecontactemployeecontactemployeenamefirstname | | applicantonecontactemployeecontactemployeenamelastname | | applicantonecontactemployeeemailaddress | | applicantonecontactemployeephone | | applicantonecontactemployeetitle | | applicantonefullapplicantname | | applicantoneirsemplidentno | | applicantonemailingaddresscity | | applicantonemailingaddressstateorcountry | | applicantonemailingaddressstreet1 | | applicantonemailingaddressstreet2 | | applicantonemailingaddresszipcode | | applicantonemainaddresscity | | applicantonemainaddressstateorcountry | | applicantonemainaddressstreet1 | | applicantonemainaddressstreet2 | | applicantonemainaddresszipcode | | applicantonewebsiteurl | | applicantthreeapplicantname | | applicantthreeapplicantnfano | | applicantthreeisforeignregulatory | | applicanttwoapplicantname | | applicanttwoapplicantnfano | | applicanttwoissubjecttoregulator | | applicanttwoisswapdealer | | applicanttwoisswapparticipant | | applicanttworegisteredas | | applicantuic | | assigningregulators | | associatedperson | | businesslocchangeoption | | businessname | | businesstelephonenumber | | ccc | | cerapplicantname | | cerdate | | certificationoneapplicantname | | certificationonename | | certificationonesignature | | certificationtwoapplicantname | | certificationtwocerapplicantname | | certificationtwocerdate | | certificationtwoname | | certificationtwosignature | | chargedesc | | chiefcomplianceofficeremailaddress | | chiefcomplianceofficerofficernamefirstname | | chiefcomplianceofficerofficernamelastname | | chiefcomplianceofficerofficernamemiddlename | | chiefcomplianceofficerphone | | chiefcomplianceofficertitle | | cik | | city | | cityorcounty | | civiljudicialactiondisclosureisdismissed | | civiljudicialactiondisclosureisenjoined | | civiljudicialactiondisclosureisfoundinviolationofregulation | | civiljudicialactiondisclosureisnamedincivilproceeding | | contactemployeecontactemployeenamefirstname | | contactemployeecontactemployeenamelastname | | contactemployeecontactemployeenamemiddlename | | contactemployeeemailaddress | | contactemployeenamefirstname | | contactemployeenamelastname | | contactemployeenamemiddlename | | contactemployeenameprefix | | contactemployeephone | | contactemployeetitle | | controlaffiliatecontrolaffiliatedetailsfirstname | | controlaffiliatecontrolaffiliatedetailslastname | | controlaffiliatedetailscrdnumber | | controlaffiliatedetailsfirstname | | controlaffiliatedetailsispersonregistered | | controlaffiliatedetailsisshouldberemoved | | controlaffiliatedetailsissubmittedtocrd | | controlaffiliatedetailslastname | | controlaffiliatedetailsmiddlename | | controlaffiliatedetailspersontype | | controlaffiliatedetailsuicnumber | | controlperson | | controlthroughagreementdescriptionarrangement | | controlthroughagreementdetailscontrolthroughagreementdescriptionarrangement | | controlthroughagreementdetailscontrolthroughagreementfirmciknumber | | controlthroughagreementdetailscontrolthroughagreementfirmeffectivedate | | controlthroughagreementdetailscontrolthroughagreementfirmororganizationname | | controlthroughagreementdetailscontrolthroughagreementfirmuic | | controlthroughagreementdetailscontrolthroughagreementresponsetype | | controlthroughagreementfirmaddresscity | | controlthroughagreementfirmaddressstateorcountry | | controlthroughagreementfirmaddressstreet1 | | controlthroughagreementfirmaddressstreet2 | | controlthroughagreementfirmaddresszipcode | | controlthroughagreementfirmciknumber | | controlthroughagreementfirmeffectivedate | | controlthroughagreementfirmforeignbusinessno | | controlthroughagreementfirmnfa | | controlthroughagreementfirmorindividual | | controlthroughagreementfirmororganizationname | | controlthroughagreementfirmuic | | controlthroughagreementresponsetype | | controlwithbank | | countryofdomicile | | countryofformation | | courttype | | crdno | | crdnumber | | criminaldisclosureischargedmisdemeanor | | criminaldisclosureischargedwithfelony | | criminaldisclosureisconvictedmisdemeanor | | criminaldisclosureisconvictedoffelony | | criminaldrpdetailsstateorcountry | | criminaldrpinitialoramended | | currentstatus | | date | | datebeganworking | | dateceasedbusiness | | datefirstchargeddate | | datefirstchargedexactorexplanation | | dateinitiateddate | | dateinitiatedexactorexplanation | | dateofformation | | datepaid | | datetitleorstatusacquired | | descallegations | | descrelationshipwithapplicant | | describebusiness | | description | | description3c | | descriptionarrangement | | descriptionbusiness | | descriptionrelationship | | dispositiondisclosuredate | | dispositiontype | | docketorcasenumber | | drpfiledfor | | effecttype | | effectivedate | | emailaddress | | engagedinsecurities | | entitytype | | eventcurrentstatus | | eventstatusdatedate | | exactorexplanation | | executiondate | | felonyormisdemeanor | | filerccc | | filercik | | financialdisclosurehassubjectofbankruptcy | | financialdisclosurehastrusteeappointed | | financialinstitutionname | | firmaddresscity | | firmaddressstateorcountry | | firmaddressstreet1 | | firmaddressstreet2 | | firmaddresszipcode | | firmciknumber | | firmcrdno | | firmeffectivedate | | firmforeignbusinessno | | firmname | | firmnfa | | firmorindividual | | firmororganizationname | | firmsecfilenumber | | firmterminationdate | | firmuic | | firstname | | foreignfinancialregforeignbusinessno | | foreignfinancialregulatory | | fullapplicantname | | fulllegalname | | fullname | | hassubjectofbankruptcy | | hastrusteeappointed | | haveownershipinterest | | initialoramended | | institutionaddresscity | | institutionaddressstateorcountry | | institutionaddressstreet1 | | institutionaddressstreet2 | | institutionaddresszipcode | | institutionname | | institutiontype | | investmentproducttype | | irsemplidentno | | irstaxno | | isanyindirectowners | | isauthorizedtoactattorney | | iscauseofdenial | | ischargedmisdemeanor | | ischargedwithfelony | | iscommissiondetermine | | iscomplaint | | iscontrolthroughagreement | | iscontrolwithbank | | isconvictedmisdemeanor | | isconvictedoffelony | | isdeniedlicense | | isderivativesdealer | | isdisciplined | | isdismissed | | iseffecttransactions | | isengageinotherbusiness | | isengagedininvestmentrelatedbusiness | | isengagedinnonsecurity | | isengagedinsecurities | | isenjoined | | isforeignentity | | isforeignregulatory | | isfoundincauseofdenial | | isfoundincauseofsuspension | | isfoundinviolationofregulation | | isfoundinviolationofrules | | isfoundmadefalsestatement | | isholdcollateral | | isholdfunds | | isimposedpenalty | | isinvestigation | | isinvestmentadvisor | | isinvestmentadvisoryact | | isinvestmentrelated | | ismadefalsestatement | | ismathematicalmodels | | isnamedincivilproceeding | | isnamedinregulatoryproceeding | | isnonresidententity | | isnotidentified | | isonbehalf | | isorderagainst | | isorderagainstactivity | | ispersonregistered | | isrecordskept | | isregisteredasother | | isregisteredwithcommission | | issecurityact | | isselfdetermine | | isshouldberemoved | | issubjecttoregulator | | issubmittedtocrd | | issucceeding | | isswapdealer | | isswapparticipant | | isunethical | | isusemathmodels | | isviolatedregulation | | iswhollyorpartiallyfinance | | islitigation | | lastname | | legalstatus | | livetestflag | | mailingaddresscity | | mailingaddressstateorcountry | | mailingaddressstreet1 | | mailingaddressstreet2 | | mailingaddresszipcode | | mainaddresscity | | mainaddressstateorcountry | | mainaddressstreet1 | | mainaddressstreet2 | | mainaddresszipcode | | matterresolvedtype | | middlename | | monetaryfineamount | | monthapplicantfiscalends | | name | | nameofapplicant | | nameofcountry | | nameofcourt | | nameoffirm | | nameofpersonsigning | | nameofprincipal | | nameofregulatory | | nfaidentificationno | | numberofcounts | | numberofprincipals | | officernamefirstname | | officernamelastname | | officernamemiddlename | | officernameprefix | | officernamesuffix | | onbehalfdescriptionarrangement | | onbehalfdetailsonbehalffirmaddresscity | | onbehalfdetailsonbehalffirmaddressstateorcountry | | onbehalfdetailsonbehalffirmaddressstreet1 | | onbehalfdetailsonbehalffirmaddresszipcode | | onbehalffirmaddresscity | | onbehalffirmaddressstateorcountry | | onbehalffirmaddressstreet1 | | onbehalffirmaddressstreet2 | | onbehalffirmaddresszipcode | | onbehalffirmciknumber | | onbehalffirmcrdno | | onbehalffirmeffectivedate | | onbehalffirmnfa | | onbehalffirmorindividual | | onbehalffirmororganizationname | | onbehalffirmuic | | onbehalfresponsetype | | organizationname | | othername | | otherprincipalsanction | | othersanctionsordered | | overrideinternetflag | | ownershipcode | | partneraddresscity | | partneraddressstateorcountry | | partneraddressstreet1 | | partneraddressstreet2 | | partneraddresszipcode | | partnercorporgname | | partnercorporgtype | | partnercrdnumber | | partneruicnumber | | penaltyfineamount | | personaddresscity | | personaddressstateorcountry | | personaddressstreet1 | | personaddresszipcode | | persontelephonenumber | | persontype | | phone | | plea | | prefix | | principalinfoapplicantname | | principalname | | principalproducttype | | principalproducttypeotherdesc | | principalsanction | | prudentialregulator | | prudentialregulatorsprudentialregulator | | reasontowithdraw | | recordskeptdescriptionarrangement | | recordskeptdetailsrecordskeptdescriptionarrangement | | recordskeptdetailsrecordskeptfirmaddresscity | | recordskeptdetailsrecordskeptfirmaddressstateorcountry | | recordskeptdetailsrecordskeptfirmaddressstreet1 | | recordskeptdetailsrecordskeptfirmaddressstreet2 | | recordskeptdetailsrecordskeptfirmaddresszipcode | | recordskeptdetailsrecordskeptfirmciknumber | | recordskeptdetailsrecordskeptfirmeffectivedate | | recordskeptdetailsrecordskeptfirmororganizationname | | recordskeptdetailsrecordskeptresponsetype | | recordskeptfirmaddresscity | | recordskeptfirmaddressstateorcountry | | recordskeptfirmaddressstreet1 | | recordskeptfirmaddressstreet2 | | recordskeptfirmaddresszipcode | | recordskeptfirmciknumber | | recordskeptfirmeffectivedate | | recordskeptfirmorindividual | | recordskeptfirmororganizationname | | recordskeptfirmuic | | recordskeptresponsetype | | registeredas | | registrationtype | | regulatorname | | regulatoryactiondisclosureisauthorizedtoactattorney | | regulatoryactiondisclosureiscauseofdenial | | regulatoryactiondisclosureisdeniedlicense | | regulatoryactiondisclosureisdisciplined | | regulatoryactiondisclosureisfoundincauseofdenial | | regulatoryactiondisclosureisfoundincauseofsuspension | | regulatoryactiondisclosureisfoundinviolationofregulation | | regulatoryactiondisclosureisfoundinviolationofrules | | regulatoryactiondisclosureisfoundmadefalsestatement | | regulatoryactiondisclosureisimposedpenalty | | regulatoryactiondisclosureismadefalsestatement | | regulatoryactiondisclosureisnamedinregulatoryproceeding | | regulatoryactiondisclosureisorderagainst | | regulatoryactiondisclosureisorderagainstactivity | | regulatoryactiondisclosureisunethical | | regulatoryactiondisclosureisviolatedregulation | | regulatoryactioninitiatedby | | regulatorydrpdetailsdocketorcasenumber | | regulatorydrpdrpfiledfor | | regulatorydrpinitialoramended | | resolutiondatedate | | resolutiondateexactorexplanation | | respondingtoresponsequestion | | responsequestion | | responsetype | | returncopyflag | | sanctiondetail | | sanctionordered | | scheduleainfocrdno | | scheduleainfodescription | | scheduleainfofirmorindividual | | schedulebapplicantname | | schedulebapplicantnfano | | scheduledlistapplicantname | | scheduledlistapplicantnfano | | scheduledlistciviljudicialactiondisclosureisfoundinviolationofregulation | | scheduledoneapplicantname | | scheduledoneinitialoramended | | scheduledthreeapplicantname | | scheduledthreeinitialoramended | | scheduledtwoapplicantname | | scheduledtwoinitialoramended | | scheduleeapplicantname | | schedulefapplicantname | | schedulefapplicantnfano | | schedulefsignature | | secfilenumber | | sectionfiveeffectivedate | | sectionfourdescription | | sectionsixcountryofdomicile | | sectionsixdescriptionrelationship | | sectionsixeffectivedate | | sectionsixuicnumber | | sentencepenalty | | serviceaddresscity | | serviceaddressstateorcountry | | serviceaddressstreet1 | | serviceaddresszipcode | | serviceofprocessfirmname | | serviceofprocessfirmorindividual | | signature | | signaturedate | | signername | | signertitle | | startdatepenalty | | stateofformation | | stateorcountry | | street1 | | street2 | | submissiontype | | suffix | | summaryofcircumstances | | summaryofdetails | | swapoption | | taxidentificationno | | taxidentificationnumber | | telephonenumber | | terminationdate | | title | | titleofpersonsigning | | titleorstatus | | typeofentity | | uicnumber | | websiteurl | | whollyorpartiallyfinancedescriptionarrangement | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancedescriptionarrangement | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmaddresscity | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmaddressstateorcountry | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmaddressstreet1 | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmaddressstreet2 | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmaddresszipcode | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmciknumber | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmcrdno | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmeffectivedate | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmororganizationname | | whollyorpartiallyfinancedetailswhollyorpartiallyfinancefirmuic | | whollyorpartiallyfinancedetailswhollyorpartiallyfinanceresponsetype | | whollyorpartiallyfinancefirmaddresscity | | whollyorpartiallyfinancefirmaddressstateorcountry | | whollyorpartiallyfinancefirmaddressstreet1 | | whollyorpartiallyfinancefirmaddressstreet2 | | whollyorpartiallyfinancefirmaddresszipcode | | whollyorpartiallyfinancefirmciknumber | | whollyorpartiallyfinancefirmcrdno | | whollyorpartiallyfinancefirmeffectivedate | | whollyorpartiallyfinancefirmforeignbusinessno | | whollyorpartiallyfinancefirmnfa | | whollyorpartiallyfinancefirmorindividual | | whollyorpartiallyfinancefirmororganizationname | | whollyorpartiallyfinancefirmsecfilenumber | | whollyorpartiallyfinancefirmuic | | whollyorpartiallyfinanceresponsetype | | zipcode |

sbse_schedule_b_info

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sbse_schedule_b_info",
    filename="sbse_schedule_b_info.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sbse_schedule_b_info"
    LIMIT 10
    """,
    output_dir="sbse_schedule_b_info_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | foreignbusinessno | | interestownedentity | | pr | | schedulebinfocontrolperson | | schedulebinfodatetitleorstatusacquired | | schedulebinfoentitytype | | schedulebinfofirmorindividual | | schedulebinfofulllegalname | | schedulebinfoirstaxno | | schedulebinfoownershipcode | | status | | uic |

schedule_13d

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13d",
    filename="schedule_13d.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13d"
    LIMIT 10
    """,
    output_dir="schedule_13d_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amendmentno | | authorizedcity | | authorizedpersonname | | authorizedpersonphone | | authorizedstateorcountry | | authorizedstreet1 | | authorizedstreet2 | | authorizedzipcode | | dateofevent | | filerccc | | filercik | | issuercik | | issuercusip | | issuercity | | issuername | | issuerstateorcountry | | issuerstreet1 | | issuerstreet2 | | issuerzipcode | | item1city | | item1commenttext | | item1issuername | | item1securitytitle | | item1stateorcountry | | item1street1 | | item1street2 | | item1zipcode | | item2citizenship | | item2convictiondescription | | item2filingpersonname | | item2hasbeenconvicted | | item2principalbusinessaddress | | item2principaljob | | item3fundssource | | item4transactionpurpose | | item5date5percentownership | | item5listofshareholders | | item5numberofshares | | item5percentageofclass | | item5transactiondesc | | item6contractdescription | | item7filedexhibits | | livetestflag | | previousaccessionnumber | | previouslyfiledflag | | securitiesclasstitle | | signaturecommenttext | | submissiontype |

schedule_13d_reporting_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13d_reporting_person",
    filename="schedule_13d_reporting_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13d_reporting_person"
    LIMIT 10
    """,
    output_dir="schedule_13d_reporting_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregateamountowned | | citizenshipororganization | | commentcontent | | fundtype | | isaggregateexcludeshares | | legalproceedings | | memberofgroup | | percentofclass | | reportingpersoncik | | reportingpersonname | | reportingpersonnocik | | shareddispositivepower | | sharedvotingpower | | soledispositivepower | | solevotingpower | | typeofreportingperson |

schedule_13d_signature_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13d_signature_person",
    filename="schedule_13d_signature_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13d_signature_person"
    LIMIT 10
    """,
    output_dir="schedule_13d_signature_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | date | | signature | | signaturereportingperson | | title |

schedule_13g

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13g",
    filename="schedule_13g.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13g"
    LIMIT 10
    """,
    output_dir="schedule_13g_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amendmentno | | designaterulepursuantthisschedulefiled | | eventdaterequiresfilingthisstatement | | exhibitinfo | | filerccc | | filercik | | issuercik | | issuercity | | issuercusip | | issuername | | issuerstateorcountry | | issuerstreet1 | | issuerstreet2 | | issuerzipcode | | item10certifications | | item10notapplicable | | item1issueraddress | | item1issuername | | item2citizenship | | item2filingpersonname | | item2principaladdress | | item3notapplicable | | item3othertypeofpersonfiling | | item3typeofpersonfiling | | item4amountbeneficiallyowned | | item4classpercent | | item4shareddispositivepower | | item4sharedvotingpower | | item4soledispositivepower | | item4solevotingpower | | item5classownership5percentorless | | item5notapplicable | | item6notapplicable | | item6ownershipmorethan5percent | | item7notapplicable | | item7subsidiaryidentification | | item8groupmembers | | item8notapplicable | | item9groupdissolutionnotice | | item9notapplicable | | livetestflag | | previousaccessionnumber | | securitiesclasstitle | | signaturecomments | | submissiontype |

schedule_13g_reporting_person

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13g_reporting_person",
    filename="schedule_13g_reporting_person.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13g_reporting_person"
    LIMIT 10
    """,
    output_dir="schedule_13g_reporting_person_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | aggregateamountexcludescertainsharesflag | | aggregatesharesowned | | citizenshipororganization | | classpercent | | comments | | membergroup | | reportingpersonname | | shareddispositivepower | | sharedvotingpower | | soledispositivepower | | solevotingpower | | typeofreportingperson |

schedule_13g_signature_information

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/schedule_13g_signature_information",
    filename="schedule_13g_signature_information.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "schedule_13g_signature_information"
    LIMIT 10
    """,
    output_dir="schedule_13g_signature_information_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | signature | | signaturedate | | signaturereportingpersonname | | signaturetitle |

sdr

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sdr",
    filename="sdr.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sdr"
    LIMIT 10
    """,
    output_dir="sdr_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | amendeditemslist | | applicanttype | | applicanttypeconfflag | | applicanttypeotherdesc | | assetclassesconfflag | | assetclasseslist | | businessaddressconfflag | | businesscity | | businessnameconfflag | | businessstateorcountry | | businessstreet1 | | businesszipcode | | confirmingcopyflag | | consentaddressconfflag | | consentapplicantname | | consentcity | | consentnameconfflag | | consentpersonname | | consentphone | | consentphoneconfflag | | consentstateorcountry | | consentstreet1 | | consentzipcode | | contactemail | | contactname | | contactphone | | corporgconfflag | | dateofincorporation | | filerccc | | filercik | | functiondescription | | functiondescriptionconfflag | | livetestflag | | officecity | | officeconfflag | | officename | | officestateorcountry | | officestreet1 | | officezipcode | | overrideinternetflag | | partnershipconfflag | | predecessorcikflag | | predecessornameaddressflag | | previousbusinessnameconfflag | | principalapplicantname | | principalcity | | principalconfflag | | principalstateorcountry | | principalstreet1 | | principalzipcode | | returncopyflag | | signature | | signatureapplicantname | | signatureconfflag | | signaturedate | | signaturetitle | | stateofincorporation | | submissiontype | | successiondateflag | | successionflag | | successorconfflag |

sh_er

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er",
    filename="sh_er.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er"
    LIMIT 10
    """,
    output_dir="sh_er_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cik |

sh_er_friday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_friday",
    filename="sh_er_friday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_friday"
    LIMIT 10
    """,
    output_dir="sh_er_friday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_monday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_monday",
    filename="sh_er_monday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_monday"
    LIMIT 10
    """,
    output_dir="sh_er_monday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_saturday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_saturday",
    filename="sh_er_saturday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_saturday"
    LIMIT 10
    """,
    output_dir="sh_er_saturday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_sunday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_sunday",
    filename="sh_er_sunday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_sunday"
    LIMIT 10
    """,
    output_dir="sh_er_sunday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_thursday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_thursday",
    filename="sh_er_thursday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_thursday"
    LIMIT 10
    """,
    output_dir="sh_er_thursday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_tuesday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_tuesday",
    filename="sh_er_tuesday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_tuesday"
    LIMIT 10
    """,
    output_dir="sh_er_tuesday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

sh_er_wednesday

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/sh_er_wednesday",
    filename="sh_er_wednesday.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "sh_er_wednesday"
    LIMIT 10
    """,
    output_dir="sh_er_wednesday_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | cusip | | nameofissuer | | numbersecuritiessoldshort | | saledate | | shortendposition | | shortstartposition |

ta_1

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_1",
    filename="ta_1.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_1"
    LIMIT 10
    """,
    output_dir="ta_1_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | authoritydescription | | authorizationdeniedorsuspendedinvolved | | ccc | | cik | | city | | conductbusinessinotherlocations | | controlperson | | corporationpartnershipdatacontrolperson | | corporationpartnershipdataentityname | | corporationpartnershipdataownershipcode | | corporationpartnershipdatarelationshipstartdate | | corporationpartnershipdatatitleorstatus | | differentmailingaddress | | disciplinaryhistoryenjoinedinvestmentrelatedactivityinvolved | | disciplinaryhistoryfalsestatementoromissioninvolved | | disciplinaryhistoryfelonyormisdemeanorinvolved | | disciplinaryhistoryforeignagencyinvolved | | disciplinaryhistoryotherfelonyinvolved | | disciplinaryhistoryregistrationdeniedorsuspendedinvolved | | disciplinaryhistoryrevokedbondinvolved | | disciplinaryhistorysubjectofproceedingsinvolved | | disciplinaryhistoryunsatisfiedjudgementsorliensinvolved | | disciplinaryhistoryviolationofinvestmentrelatedregulationinvolved | | disciplinaryhistoryviolationofregulationsinvolved | | engagedasservicecompany | | engagedservicecompany | | enjoinedinvestmentrelatedactivityinvolved | | entityname | | falsestatementoromissioninvolved | | federalorstateregulatoryagencyfsrauthorizationdeniedorsuspendedinvolved | | federalorstateregulatoryagencyfsrfalsestatementoromissioninvolved | | federalorstateregulatoryagencyfsrfoundorderagainstapplicantinvolved | | federalorstateregulatoryagencyfsrregistrationdeniedorsuspendedinvolved | | federalorstateregulatoryagencyfsrrevokedsuspendedlicenseinvolved | | federalorstateregulatoryagencyfsrviolationofinvestmentrelatedregulationinvolved | | felonyormisdemeanorinvolved | | filercredentialscik | | finsnumber | | foreignagencyinvolved | | formversion | | fsrauthorizationdeniedorsuspendedinvolved | | fsrfalsestatementoromissioninvolved | | fsrfoundorderagainstapplicantinvolved | | fsrregistrationdeniedorsuspendedinvolved | | fsrrevokedsuspendedlicenseinvolved | | fsrviolationofinvestmentrelatedregulationinvolved | | headerdatasubmissiontype | | independentregistrantcorporationpartnershipdataentityname | | independentregistrantothercontrolmanagementotherentity | | independentregistrantregistranttype | | involved | | livetestflag | | othercontrolfinanceotherentity | | othercontrolmanagementotherentity | | otherentity | | otherfelonyinvolved | | ownershipcode | | principalofficeaddresscity | | principalofficeaddressstateorcountry | | principalofficeaddressstreet1 | | principalofficeaddressstreet2 | | principalofficeaddresszipcode | | registrantconductbusinessinotherlocations | | registrantdifferentmailingaddress | | registrantengagedasservicecompany | | registrantengagedservicecompany | | registrantentityname | | registrantfinsnumber | | registrantregulatoryagency | | registrantselftransferagent | | registranttelephonenumber | | registranttype | | registranttypedescription | | registrationdeniedorsuspendedinvolved | | regulatoryagency | | relationshipstartdate | | returncopyflag | | revokedbondinvolved | | schemaversion | | selfregulatoryagencysraauthorizationdeniedorsuspendedinvolved | | selfregulatoryagencysrafalsestatementoromissioninvolved | | selfregulatoryagencysrarevokedsuspendedlicenseinvolved | | selfregulatoryagencysraviolationofrulesinvolved | | selftransferagent | | signaturedate | | signaturename | | signaturephonenumber | | signaturesignaturedate | | signaturesignaturename | | signaturesignaturephonenumber | | signaturesignaturetitle | | signaturetitle | | soleproprietorshipotherdataentityname | | soleproprietorshipotherdatarelationshipstartdate | | soleproprietorshipotherdatatitleorstatus | | sraauthorizationdeniedorsuspendedinvolved | | srafalsestatementoromissioninvolved | | srarevokedsuspendedlicenseinvolved | | sraviolationofrulesinvolved | | stateorcountry | | stateorcountrycode | | street1 | | street2 | | subjectofproceedingsinvolved | | submissiontype | | telephonenumber | | testorlive | | titleorstatus | | unsatisfiedjudgementsorliensinvolved | | violationofinvestmentrelatedregulationinvolved | | violationofregulationsinvolved | | zipcode |

ta_1_as_service_company

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_1_as_service_company",
    filename="ta_1_as_service_company.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_1_as_service_company"
    LIMIT 10
    """,
    output_dir="ta_1_as_service_company_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | corporationpartnershipdataentityname | | principalofficeaddresscity | | principalofficeaddressstateorcountry | | principalofficeaddressstreet1 | | principalofficeaddressstreet2 | | principalofficeaddresszipcode | | registrantfinsnumber | | stateorcountrycode |

ta_1_other_business_location

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_1_other_business_location",
    filename="ta_1_other_business_location.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_1_other_business_location"
    LIMIT 10
    """,
    output_dir="ta_1_other_business_location_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | city | | principalofficeaddresscity | | principalofficeaddressstateorcountry | | principalofficeaddressstreet1 | | principalofficeaddressstreet2 | | principalofficeaddresszipcode | | stateorcountry | | stateorcountrycode | | street1 | | street2 | | zipcode |

ta_1_service_company

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_1_service_company",
    filename="ta_1_service_company.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_1_service_company"
    LIMIT 10
    """,
    output_dir="ta_1_service_company_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | corporationpartnershipdataentityname | | principalofficeaddresscity | | principalofficeaddressstateorcountry | | principalofficeaddressstreet1 | | principalofficeaddressstreet2 | | principalofficeaddresszipcode | | registrantfinsnumber | | stateorcountrycode |

ta_2

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_2",
    filename="ta_2.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_2"
    LIMIT 10
    """,
    output_dir="ta_2_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | additionalinformation | | alwayscompliant | | amendmentfiled | | amountissues | | asservicecompanytransferagententityname | | asservicecompanytransferagentfilenumber | | ccc | | cik | | currentagentamountissues | | currentagentnumberissues | | databasesearchdate | | databasesearchesdatabasesearchdate | | databasesearchesnumberaddressesfromsearch | | databasesearchesnumberlostaccountssearched | | debtsecurity | | directregistrationsystem | | directregistrationsystemnumberissues | | dividendandinterestamountissues | | dividendandinterestnumberissues | | dividendreinvdirectpurchaseplan | | dividendreinvdirectpurchaseplannumberissues | | engagedservicecompanyasservicecompanytransferagententityname | | engagedservicecompanyasservicecompanytransferagentfilenumber | | engagedservicecompanyfunction | | engagedservicecompanyservicecompanytransferagententityname | | engagedservicecompanyservicecompanytransferagentfilenumber | | entityname | | equitysecurity | | filenumber | | filercredentialscik | | filerfilenumber | | filerinfoentityname | | filerinfoperiodofreport | | filerinfotestorlive | | formversion | | function | | headerdatasubmissiontype | | isfilingamendment | | limitedpartnership | | municipaldebt | | nottransmaintmastersecholderdebtsecurity | | nottransmaintmastersecholderequitysecurity | | nottransmaintmastersecholderlimitedpartnership | | nottransmaintmastersecholdermunicipaldebt | | nottransmaintmastersecholderopenendinvestmentcompany | | nottransmaintmastersecholderother | | numberaddressesfromsearch | | numberdirectregistsystemaccounts | | numberdivreinvdirpurplanaccounts | | numberfiled | | numberindividualaccounts | | numberissues | | numberitemsreceivedfortransfer | | numberlostaccountsremittedtostates | | numberlostaccountssearched | | numbermastersecurityholderfilings | | openendinvestmentcompany | | other | | periodofreport | | prioragentamountissues | | prioragentnumberissues | | purchaseredemptionpricingsharestotal | | purchaseredemptionpricingsharestotalotherthanreceiptorderdate | | quarterlyreportsregardingbuyinsnumberfiled | | registrantengagedservice | | registrantregulatoryagencyadditionalinformation | | registrantregulatoryagencyamendmentfiled | | registrantregulatoryagencyregulatoryagency | | regulatoryagency | | returncopy | | schemaversion | | securityholderaccountsdebtsecurity | | securityholderaccountsequitysecurity | | securityholderaccountslimitedpartnership | | securityholderaccountsmunicipaldebt | | securityholderaccountsopenendinvestmentcompany | | securityholderaccountsother | | securityholderdatadividendandinterestamountissues | | securityholderdatadividendandinterestnumberissues | | securityholderdatanottransmaintmastersecholderdebtsecurity | | securityholderdatanottransmaintmastersecholderequitysecurity | | securityholderdatanottransmaintmastersecholderlimitedpartnership | | securityholderdatanottransmaintmastersecholdermunicipaldebt | | securityholderdatanottransmaintmastersecholderopenendinvestmentcompany | | securityholderdatanottransmaintmastersecholderother | | securityholderdataprioragentamountissues | | securityholderdataprioragentnumberissues | | securityholderdatatransmaintainmastersecholderdebtsecurity | | securityholderdatatransmaintainmastersecholderequitysecurity | | securityholderdatatransmaintainmastersecholderlimitedpartnership | | securityholderdatatransmaintainmastersecholdermunicipaldebt | | securityholderdatatransmaintainmastersecholderopenendinvestmentcompany | | securityholderdatatransmaintainmastersecholderother | | securityholderdatatransnotmaintmastersecholderdebtsecurity | | securityholderdatatransnotmaintmastersecholderequitysecurity | | securityholderdatatransnotmaintmastersecholderlimitedpartnership | | securityholderdatatransnotmaintmastersecholdermunicipaldebt | | securityholderdatatransnotmaintmastersecholderopenendinvestmentcompany | | securityholderdatatransnotmaintmastersecholderother | | servicecompany | | servicecompanydatanumberdirectregistsystemaccounts | | servicecompanydatanumberdivreinvdirpurplanaccounts | | servicecompanydatanumberindividualaccounts | | servicecompanydatanumberitemsreceivedfortransfer | | servicecompanydatanumberlostaccountsremittedtostates | | servicecompanydatanumbermastersecurityholderfilings | | servicecompanytransferagententityname | | servicecompanytransferagentfilenumber | | signaturedatasignaturedate | | signaturedatasignaturename | | signaturedatasignaturephonenumber | | signaturedatasignaturetitle | | signaturedate | | signaturename | | signaturephonenumber | | signaturetitle | | submissiontype | | testorlive | | total | | totalotherthanreceiptorderdate | | transmaintainmastersecholderdebtsecurity | | transmaintainmastersecholderequitysecurity | | transmaintainmastersecholderlimitedpartnership | | transmaintainmastersecholdermunicipaldebt | | transmaintainmastersecholderopenendinvestmentcompany | | transmaintainmastersecholderother | | transnotmaintmastersecholderdebtsecurity | | transnotmaintmastersecholderequitysecurity | | transnotmaintmastersecholderlimitedpartnership | | transnotmaintmastersecholdermunicipaldebt | | transnotmaintmastersecholderopenendinvestmentcompany | | transnotmaintmastersecholderother | | turnaroundcompliantalwayscompliant |

ta_w

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_w",
    filename="ta_w.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_w"
    LIMIT 10
    """,
    output_dir="ta_w_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | businessaddresscity | | businessaddressstateorcountry | | businessaddressstreet1 | | businessaddressstreet2 | | businessaddresszipcode | | ccc | | cik | | city | | documentretentiontawcustodiansentityname | | entityname | | filenumber | | filercredentialscik | | formversion | | futuretransferagentfunctions | | headerdatasubmissiontype | | involved | | lastactiondate | | livetestflag | | registrantentityname | | registrantfilenumber | | returncopyflag | | schemaversion | | signaturedatasignaturedate | | signaturedatasignaturename | | signaturedatasignaturephonenumber | | signaturedatasignaturetitle | | signaturedate | | signaturename | | signaturephonenumber | | signaturetitle | | stateorcountry | | stateorcountrycode | | street1 | | street2 | | subjectofproceedingsinvolved | | submissiontype | | successorregistered | | successortransferagents | | tawsuccessoraddresscity | | tawsuccessoraddressstateorcountry | | tawsuccessoraddressstateorcountrycode | | tawsuccessoraddressstreet1 | | tawsuccessoraddresszipcode | | tawsuccessordetailsentityname | | tawsuccessorssuccessortransferagents | | testorlive | | unsatisfiedjudgementsorliensinvolved | | unsatisfiedjudgmentsinvolved | | withdrawaldescription | | withdrawalfuturetransferagentfunctions | | withdrawallastactiondate | | withdrawalwithdrawaldescription | | zipcode |

ta_w_custodians

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_w_custodians",
    filename="ta_w_custodians.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_w_custodians"
    LIMIT 10
    """,
    output_dir="ta_w_custodians_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | documentretentiontawcustodiansentityname | | tawcustodianaddresscity | | tawcustodianaddressstateorcountry | | tawcustodianaddressstateorcountrycode | | tawcustodianaddressstreet1 | | tawcustodianaddressstreet2 | | tawcustodianaddresszipcode | | tawcustodiansentityname | | tawcustodianstawcustodianaddresscity | | tawcustodianstawcustodianaddressstateorcountry | | tawcustodianstawcustodianaddressstreet1 | | tawcustodianstawcustodianaddresszipcode |

ta_w_locations

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/ta_w_locations",
    filename="ta_w_locations.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "ta_w_locations"
    LIMIT 10
    """,
    output_dir="ta_w_locations_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | documentretentiontawcustodiansentityname | | tawcustodianaddresscity | | tawcustodianaddressstateorcountry | | tawcustodianaddressstateorcountrycode | | tawcustodianaddressstreet1 | | tawcustodianaddressstreet2 | | tawcustodianaddresszipcode | | tawcustodiansentityname | | tawcustodianstawcustodianaddresscity | | tawcustodianstawcustodianaddressstateorcountry | | tawcustodianstawcustodianaddressstreet1 | | tawcustodianstawcustodianaddresszipcode |

x_17a_5

Use this table name inside datamulehub.databases.query. Use the dataset name shown below for full-table downloads.

from datamulehub import datasets

datasets.download(
    "xml2tables/x_17a_5",
    filename="x_17a_5.parquet",
)

from datamulehub import databases

databases.query(
    """
    SELECT *
    FROM "x_17a_5"
    LIMIT 10
    """,
    output_dir="x_17a_5_sample",
)

Schema

| Column | |---| | accessionnumber | | filingdate | | _sourcekey | | _table | | accountantcity | | accountantname | | accountantstateorcountry | | accountantstreet1 | | accountantstreet2 | | accountanttype | | accountantzipcode | | amendmentdescription | | brokerdealername | | city | | confirmnotarizedflag | | contactpersonname | | contactpersonphonenumber | | explanation | | filerccc | | filercik | | livetestflag | | materialweakness | | oathentityname | | oathtitle | | periodbegin | | periodend | | signdate | | signpersonname | | signature | | stateorcountry | | street1 | | street2 | | subtypeofbdregistrant | | subtypeofregistrant | | subtypeofsdregistrant | | submissiontype | | typeofbdregistrant | | typeofsdregistrant | | zipcode |