First quarter 2024 / Table BOAMP-SIREN-BUYERS (BSA): a cross between the BOAMP table (DILA) and the Sirene Business Base (INSEE)

Crossing table of the BOAMP table (DILA) with the Sirene Business Base (INSEE) / First Quarter 2024.

• The BUYER's Siren number (column "SN_30_Siren") is implemented for each ad (column and primary key "B_17_idweb");
• Several columns facilitating datamining have been added;
• The names of the original columns have been prefixed, numbered and sorted alphabetically.

You will find here
- The BSA for the first quarter of 2024 in free and open access (csv/separator ** semicolon** formats, and Public Prosecutor’s Office);
- The schema of the BSA table (csv/comma separator format);
- An excerpt from the March 30 BSA (csv/comma separator format) to quickly give you an idea of the Datagouv explorer.

NB / The March 30 extract sees its columns of cells in json GESTION, DATA, and ANNONCES_ANTERIEURES purged. The data thus deleted can be found in a nicer format by following the links of the added columns:
 
- B_41_GESTION_URL_JSON;
- B_43_DONNEES_URL_JSON;
- B_45_ANNONCES_ANTERIEURES_URL_JSON.

More info
- Daily and paid updates on the entire BOAMP 2024 are available on our website under ► [AuFilDuBoamp Downloads] (https://www.aufilduboamp.com/rubrique90.html);
- Further documentation can be found at ► AuFilDuBoamp Doc & TP.

Data sources
- SIRENE database of companies and their establishments (SIREN, SIRET) of August
- BOAMP API

To download the first quarter of the BSA with Python, run:

For the CSV:

df = pd.read_csv("https://www.data.gouv.fr/en/datasets/r/63f0d792-148a-4c95-a0b6-9e8ea8b0b34a", dtype='string', sep=';')

For the Public Prosecutor's Office:

df = pd.read_parquet("https://www.data.gouv.fr/en/datasets/r/f7a4a76e-ff50-4dc6-bae8-97368081add2")

Enjoy!