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

Description

**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](https://www.aufilduboamp.com/heading95.html).   ---- **Data sources** - [SIRENE database of companies and their establishments (SIREN, SIRET) of August](https://www.data.gouv.fr/en/datasets/base-sirene-des-entreprises-et-de-their-etablissements-siren-siret/) - [BOAMP API](https://boamp-datadila.opendatasoft.com/explore/dataset/boamp/table/?q=dateissue:2024&sort=dateissue)   ---- **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! ![www.aufilduboamp.com and BOAMP data on datagouv](https://www.aufilduboamp.com/shares/aufilduboamp_docs/ap_tampon_blanc.jpg "www.aufilduboamp.com and BOAMP data on datagouv")

Resources

Name Format Description Link
8 https://www.data.gouv.fr/fr/datasets/r/aae70945-2bba-48ee-b3bd-282e6bd78acf
0 https://www.data.gouv.fr/fr/datasets/r/f7a4a76e-ff50-4dc6-bae8-97368081add2
8 https://www.data.gouv.fr/fr/datasets/r/c453ff8d-031d-4f57-bfc7-1e621094c30b
0 https://www.data.gouv.fr/fr/datasets/r/30a354bb-6f0a-445b-8b37-bb9e41607eb3
8 https://www.data.gouv.fr/fr/datasets/r/4164534a-ad4a-497d-9aaa-39a50c7f06ed
0 https://www.data.gouv.fr/fr/datasets/r/5f8b8a77-f60c-49cd-8672-16f3bf61367a
0 https://www.data.gouv.fr/fr/datasets/r/b36b838a-3ec6-4dbc-8b28-2b117ad1fc90
8 https://www.data.gouv.fr/fr/datasets/r/63f0d792-148a-4c95-a0b6-9e8ea8b0b34a
0 https://www.data.gouv.fr/fr/datasets/r/1c84ede8-061d-489e-b6ed-8a2b03455933
8 https://www.data.gouv.fr/fr/datasets/r/3c862a3c-6176-4c84-9428-6222b63e8854
8 https://www.data.gouv.fr/fr/datasets/r/8464ca5e-aebf-497d-98bf-49cf4778c343
8 https://www.data.gouv.fr/fr/datasets/r/637ec25c-5ed1-4c3d-97c5-f7527ad0db3e

Tags

  • boamp
  • sirene
  • commande-publique

Topics

Categories