In [1]:
%run afdb_lab_scripts/afdb_lab_prereglages
%run afdb_lab_scripts/afdb_lab_haut

Un tour d'horizon des Tables du BOAMP

À base des données recueillies en OpenData via l'API consacrée --> https://www.data.gouv.fr/fr/datasets/api-boamp-beta/


Table G_02_Marche


In [2]:
extrait_df_g_02_marche = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_G_02_marche.pkl')

Schéma interactif de la table

In [3]:
from afdb_lab_scripts.afficher_plan_html import afficher_plan_html
afficher_plan_html(source="boamp_plans_html/boamp_plan_g_02_marche.html");
In [4]:
extrait_df_g_02_marche.info()
<class 'pandas.core.frame.DataFrame'>
Index: 7450 entries, 19-138840 to 21-9868
Data columns (total 70 columns):
 #   Column                                                                                                             Non-Null Count  Dtype         
---  ------                                                                                                             --------------  -----         
 0   G_02_01_Marche_Idmarche                                                                                            0 non-null      object        
 1   G_02_02_Marche_Idconsultation                                                                                      0 non-null      object        
 2   G_02_03_Marche_Urlconsultation                                                                                     0 non-null      object        
 3   G_02_04_Marche_Annonceanterieur                                                                                    7450 non-null   object        
 4   G_02_04_01_Marche_Annonceanterieur_Reference                                                                       7450 non-null   object        
 5   G_02_04_01_01_Marche_Annonceanterieur_Reference_Idweb                                                              7450 non-null   object        
 6   G_02_04_01_02_Marche_Annonceanterieur_Reference_Typeavis                                                           7450 non-null   object        
 7   G_02_04_01_02_01_Marche_Annonceanterieur_Reference_Typeavis_Famille                                                7450 non-null   object        
 8   G_02_04_01_02_01_01_Marche_Annonceanterieur_Reference_Typeavis_Famille_Mapa                                        7450 non-null   bool          
 9   G_02_04_01_02_01_02_Marche_Annonceanterieur_Reference_Typeavis_Famille_Fns                                         7450 non-null   bool          
 10  G_02_04_01_02_01_03_Marche_Annonceanterieur_Reference_Typeavis_Famille_Joue                                        7450 non-null   bool          
 11  G_02_04_01_02_01_04_Marche_Annonceanterieur_Reference_Typeavis_Famille_Dsp                                         7450 non-null   bool          
 12  G_02_04_01_02_01_05_Marche_Annonceanterieur_Reference_Typeavis_Famille_Divers                                      7450 non-null   bool          
 13  G_02_04_01_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre                                              7450 non-null   object        
 14  G_02_04_01_02_02_01_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006                                   7450 non-null   bool          
 15  G_02_04_01_02_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006DEFENSE                            7450 non-null   bool          
 16  G_02_04_01_02_02_03_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive18                               7450 non-null   bool          
 17  G_02_04_01_02_02_04_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive17                               7450 non-null   bool          
 18  G_02_04_01_02_02_05_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive81                               7450 non-null   bool          
 19  G_02_04_01_02_02_06_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive23                               7450 non-null   bool          
 20  G_02_04_01_02_02_07_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive24                               7450 non-null   bool          
 21  G_02_04_01_02_02_08_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive25                               7450 non-null   bool          
 22  G_02_04_01_02_02_09_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Dsp                                       7450 non-null   bool          
 23  G_02_04_01_02_02_10_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Autre                                     0 non-null      object        
 24  G_02_04_01_02_03_Marche_Annonceanterieur_Reference_Typeavis_Nature                                                 7450 non-null   object        
 25  G_02_04_01_02_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation                               7450 non-null   object        
 26  G_02_04_01_02_03_01_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Standard                   7450 non-null   bool          
 27  G_02_04_01_02_03_01_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Periodique                 0 non-null      object        
 28  G_02_04_01_02_03_01_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Qualification              0 non-null      object        
 29  G_02_04_01_02_03_01_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Concession                 0 non-null      object        
 30  G_02_04_01_02_03_01_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Reductiondelai             7450 non-null   bool          
 31  G_02_04_01_02_03_01_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence          7450 non-null   bool          
 32  G_02_04_01_02_03_01_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Profilacheteur             0 non-null      object        
 33  G_02_04_01_02_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Profilacheteur                               0 non-null      object        
 34  G_02_04_01_02_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre                                   7450 non-null   object        
 35  G_02_04_01_02_03_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Standard                       7450 non-null   bool          
 36  G_02_04_01_02_03_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concours                       7450 non-null   bool          
 37  G_02_04_01_02_03_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Periodique                     0 non-null      object        
 38  G_02_04_01_02_03_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Qualification                  0 non-null      object        
 39  G_02_04_01_02_03_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Sad                            0 non-null      object        
 40  G_02_04_01_02_03_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concession                     7450 non-null   bool          
 41  G_02_04_01_02_03_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concessionnaire                0 non-null      object        
 42  G_02_04_01_02_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Intentionconclure                            7450 non-null   bool          
 43  G_02_04_01_02_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution                                  7450 non-null   object        
 44  G_02_04_01_02_03_05_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standard                      7450 non-null   bool          
 45  G_02_04_01_02_03_05_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concours                      7450 non-null   bool          
 46  G_02_04_01_02_03_05_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concession                    7450 non-null   bool          
 47  G_02_04_01_02_03_05_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite  0 non-null      object        
 48  G_02_04_01_02_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Soustraitance                                0 non-null      object        
 49  G_02_04_01_02_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Modification                                 7450 non-null   bool          
 50  G_02_04_01_02_03_08_Marche_Annonceanterieur_Reference_Typeavis_Nature_Qualification                                0 non-null      object        
 51  G_02_04_01_02_03_09_Marche_Annonceanterieur_Reference_Typeavis_Nature_Rectificatif                                 7450 non-null   bool          
 52  G_02_04_01_02_03_10_Marche_Annonceanterieur_Reference_Typeavis_Nature_Periodique                                   7450 non-null   object        
 53  G_02_04_01_02_03_11_Marche_Annonceanterieur_Reference_Typeavis_Nature_Autre                                        0 non-null      object        
 54  G_02_04_01_02_04_Marche_Annonceanterieur_Reference_Typeavis_Statut                                                 7450 non-null   object        
 55  G_02_04_01_02_04_01_Marche_Annonceanterieur_Reference_Typeavis_Statut_Initial                                      7450 non-null   bool          
 56  G_02_04_01_02_04_02_Marche_Annonceanterieur_Reference_Typeavis_Statut_Rectificatif                                 7450 non-null   bool          
 57  G_02_04_01_02_04_03_Marche_Annonceanterieur_Reference_Typeavis_Statut_Annulation                                   0 non-null      object        
 58  G_02_04_01_02_04_04_Marche_Annonceanterieur_Reference_Typeavis_Statut_Modification                                 7450 non-null   bool          
 59  G_02_04_01_03_Marche_Annonceanterieur_Reference_Dateenvoi                                                          6025 non-null   datetime64[ns]
 60  G_02_04_02_Marche_Annonceanterieur_Referencepublication                                                            7450 non-null   object        
 61  G_02_04_02_01_Marche_Annonceanterieur_Referencepublication_Publicationpapier                                       7450 non-null   object        
 62  G_02_04_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique                                 7450 non-null   object        
 63  G_02_04_02_02_01_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datepublication              4445 non-null   datetime64[ns]
 64  G_02_04_02_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datefindiffusion             4445 non-null   datetime64[ns]
 65  G_02_04_02_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue                                         7450 non-null   object        
 66  G_02_04_02_03_01_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Annee                                7450 non-null   object        
 67  G_02_04_02_03_02_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numparution                          7450 non-null   object        
 68  G_02_04_02_03_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numannonce                           7450 non-null   object        
 69  G_02_04_02_03_04_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Datepublication                      3005 non-null   datetime64[ns]
dtypes: bool(29), datetime64[ns](4), object(37)
memory usage: 2.6+ MB
In [5]:
extrait_df_g_02_marche.head(3).T
Out[5]:
BOAMP_AVIS_NUM 19-138840 19-138840 19-138840
G_02_01_Marche_Idmarche None None None
G_02_02_Marche_Idconsultation None None None
G_02_03_Marche_Urlconsultation None None None
G_02_04_Marche_Annonceanterieur CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_Marche_Annonceanterieur_Reference CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_01_Marche_Annonceanterieur_Reference_Idweb 19-134180 19-134180 19-138857
G_02_04_01_02_Marche_Annonceanterieur_Reference_Typeavis CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_01_Marche_Annonceanterieur_Reference_Typeavis_Famille CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_01_01_Marche_Annonceanterieur_Reference_Typeavis_Famille_Mapa False False False
G_02_04_01_02_01_02_Marche_Annonceanterieur_Reference_Typeavis_Famille_Fns False False False
G_02_04_01_02_01_03_Marche_Annonceanterieur_Reference_Typeavis_Famille_Joue True True True
G_02_04_01_02_01_04_Marche_Annonceanterieur_Reference_Typeavis_Famille_Dsp False False False
G_02_04_01_02_01_05_Marche_Annonceanterieur_Reference_Typeavis_Famille_Divers False False False
G_02_04_01_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_02_01_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006 False False False
G_02_04_01_02_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006DEFENSE False False False
G_02_04_01_02_02_03_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive18 False False False
G_02_04_01_02_02_04_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive17 False False False
G_02_04_01_02_02_05_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive81 False False False
G_02_04_01_02_02_06_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive23 False False False
G_02_04_01_02_02_07_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive24 True True True
G_02_04_01_02_02_08_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive25 False False False
G_02_04_01_02_02_09_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Dsp False False False
G_02_04_01_02_02_10_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Autre None None None
G_02_04_01_02_03_Marche_Annonceanterieur_Reference_Typeavis_Nature CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_03_01_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Standard False False False
G_02_04_01_02_03_01_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Periodique None None None
G_02_04_01_02_03_01_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Qualification None None None
G_02_04_01_02_03_01_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Concession None None None
G_02_04_01_02_03_01_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Reductiondelai False False False
G_02_04_01_02_03_01_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence False False False
G_02_04_01_02_03_01_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Profilacheteur None None None
G_02_04_01_02_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Profilacheteur None None None
G_02_04_01_02_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_03_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Standard True True False
G_02_04_01_02_03_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concours False False False
G_02_04_01_02_03_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Periodique None None None
G_02_04_01_02_03_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Qualification None None None
G_02_04_01_02_03_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Sad None None None
G_02_04_01_02_03_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concession False False False
G_02_04_01_02_03_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concessionnaire None None None
G_02_04_01_02_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Intentionconclure False False False
G_02_04_01_02_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_03_05_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standard False False True
G_02_04_01_02_03_05_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concours False False False
G_02_04_01_02_03_05_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concession False False False
G_02_04_01_02_03_05_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite None None None
G_02_04_01_02_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Soustraitance None None None
G_02_04_01_02_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Modification False False False
G_02_04_01_02_03_08_Marche_Annonceanterieur_Reference_Typeavis_Nature_Qualification None None None
G_02_04_01_02_03_09_Marche_Annonceanterieur_Reference_Typeavis_Nature_Rectificatif False False False
G_02_04_01_02_03_10_Marche_Annonceanterieur_Reference_Typeavis_Nature_Periodique CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_03_11_Marche_Annonceanterieur_Reference_Typeavis_Nature_Autre None None None
G_02_04_01_02_04_Marche_Annonceanterieur_Reference_Typeavis_Statut CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_01_02_04_01_Marche_Annonceanterieur_Reference_Typeavis_Statut_Initial True True True
G_02_04_01_02_04_02_Marche_Annonceanterieur_Reference_Typeavis_Statut_Rectificatif False False False
G_02_04_01_02_04_03_Marche_Annonceanterieur_Reference_Typeavis_Statut_Annulation None None None
G_02_04_01_02_04_04_Marche_Annonceanterieur_Reference_Typeavis_Statut_Modification False False False
G_02_04_01_03_Marche_Annonceanterieur_Reference_Dateenvoi 2019-09-04 23:00:00 2019-09-04 23:00:00 2019-09-11 23:00:00
G_02_04_02_Marche_Annonceanterieur_Referencepublication CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_02_01_Marche_Annonceanterieur_Referencepublication_Publicationpapier [] [] []
G_02_04_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_02_02_01_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datepublication 2019-09-06 23:00:00 NaT 2019-09-13 23:00:00
G_02_04_02_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datefindiffusion 2019-10-06 23:00:00 NaT 2019-09-18 23:00:00
G_02_04_02_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_02_04_02_03_01_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Annee <NA> 2019 <NA>
G_02_04_02_03_02_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numparution <NA> 173 <NA>
G_02_04_02_03_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numannonce <NA> 422306 <NA>
G_02_04_02_03_04_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Datepublication NaT 2019-09-08 23:00:00 NaT
In [6]:
extrait_df_g_02_marche.head(3)
Out[6]:
G_02_01_Marche_Idmarche G_02_02_Marche_Idconsultation G_02_03_Marche_Urlconsultation G_02_04_Marche_Annonceanterieur G_02_04_01_Marche_Annonceanterieur_Reference G_02_04_01_01_Marche_Annonceanterieur_Reference_Idweb G_02_04_01_02_Marche_Annonceanterieur_Reference_Typeavis G_02_04_01_02_01_Marche_Annonceanterieur_Reference_Typeavis_Famille G_02_04_01_02_01_01_Marche_Annonceanterieur_Reference_Typeavis_Famille_Mapa G_02_04_01_02_01_02_Marche_Annonceanterieur_Reference_Typeavis_Famille_Fns G_02_04_01_02_01_03_Marche_Annonceanterieur_Reference_Typeavis_Famille_Joue G_02_04_01_02_01_04_Marche_Annonceanterieur_Reference_Typeavis_Famille_Dsp G_02_04_01_02_01_05_Marche_Annonceanterieur_Reference_Typeavis_Famille_Divers G_02_04_01_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre G_02_04_01_02_02_01_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006 G_02_04_01_02_02_02_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Cmp2006DEFENSE G_02_04_01_02_02_03_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive18 G_02_04_01_02_02_04_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive17 G_02_04_01_02_02_05_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive81 G_02_04_01_02_02_06_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive23 G_02_04_01_02_02_07_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive24 G_02_04_01_02_02_08_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Directive25 G_02_04_01_02_02_09_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Dsp G_02_04_01_02_02_10_Marche_Annonceanterieur_Reference_Typeavis_Perimetre_Autre G_02_04_01_02_03_Marche_Annonceanterieur_Reference_Typeavis_Nature G_02_04_01_02_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation G_02_04_01_02_03_01_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Standard G_02_04_01_02_03_01_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Periodique G_02_04_01_02_03_01_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Qualification G_02_04_01_02_03_01_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Concession G_02_04_01_02_03_01_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Reductiondelai G_02_04_01_02_03_01_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence G_02_04_01_02_03_01_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Preinformation_Profilacheteur G_02_04_01_02_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Profilacheteur G_02_04_01_02_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre G_02_04_01_02_03_03_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Standard G_02_04_01_02_03_03_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concours G_02_04_01_02_03_03_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Periodique G_02_04_01_02_03_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Qualification G_02_04_01_02_03_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Sad G_02_04_01_02_03_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concession G_02_04_01_02_03_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Appeloffre_Concessionnaire G_02_04_01_02_03_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Intentionconclure G_02_04_01_02_03_05_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution G_02_04_01_02_03_05_01_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standard G_02_04_01_02_03_05_02_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concours G_02_04_01_02_03_05_03_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Concession G_02_04_01_02_03_05_04_Marche_Annonceanterieur_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite G_02_04_01_02_03_06_Marche_Annonceanterieur_Reference_Typeavis_Nature_Soustraitance G_02_04_01_02_03_07_Marche_Annonceanterieur_Reference_Typeavis_Nature_Modification G_02_04_01_02_03_08_Marche_Annonceanterieur_Reference_Typeavis_Nature_Qualification G_02_04_01_02_03_09_Marche_Annonceanterieur_Reference_Typeavis_Nature_Rectificatif G_02_04_01_02_03_10_Marche_Annonceanterieur_Reference_Typeavis_Nature_Periodique G_02_04_01_02_03_11_Marche_Annonceanterieur_Reference_Typeavis_Nature_Autre G_02_04_01_02_04_Marche_Annonceanterieur_Reference_Typeavis_Statut G_02_04_01_02_04_01_Marche_Annonceanterieur_Reference_Typeavis_Statut_Initial G_02_04_01_02_04_02_Marche_Annonceanterieur_Reference_Typeavis_Statut_Rectificatif G_02_04_01_02_04_03_Marche_Annonceanterieur_Reference_Typeavis_Statut_Annulation G_02_04_01_02_04_04_Marche_Annonceanterieur_Reference_Typeavis_Statut_Modification G_02_04_01_03_Marche_Annonceanterieur_Reference_Dateenvoi G_02_04_02_Marche_Annonceanterieur_Referencepublication G_02_04_02_01_Marche_Annonceanterieur_Referencepublication_Publicationpapier G_02_04_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique G_02_04_02_02_01_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datepublication G_02_04_02_02_02_Marche_Annonceanterieur_Referencepublication_Publicationelectronique_Datefindiffusion G_02_04_02_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue G_02_04_02_03_01_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Annee G_02_04_02_03_02_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numparution G_02_04_02_03_03_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Numannonce G_02_04_02_03_04_Marche_Annonceanterieur_Referencepublication_Publicationjoue_Datepublication
BOAMP_AVIS_NUM
19-138840 None None None CF_NIV_SUIV CF_NIV_SUIV 19-134180 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False False True False False None CF_NIV_SUIV CF_NIV_SUIV False None None None False False None None CF_NIV_SUIV True False None None None False None False CF_NIV_SUIV False False False None None False None False CF_NIV_SUIV None CF_NIV_SUIV True False None False 2019-09-04 23:00:00 CF_NIV_SUIV [] CF_NIV_SUIV 2019-09-06 23:00:00 2019-10-06 23:00:00 CF_NIV_SUIV <NA> <NA> <NA> NaT
19-138840 None None None CF_NIV_SUIV CF_NIV_SUIV 19-134180 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False False True False False None CF_NIV_SUIV CF_NIV_SUIV False None None None False False None None CF_NIV_SUIV True False None None None False None False CF_NIV_SUIV False False False None None False None False CF_NIV_SUIV None CF_NIV_SUIV True False None False 2019-09-04 23:00:00 CF_NIV_SUIV [] CF_NIV_SUIV NaT NaT CF_NIV_SUIV 2019 173 422306 2019-09-08 23:00:00
19-138840 None None None CF_NIV_SUIV CF_NIV_SUIV 19-138857 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False False True False False None CF_NIV_SUIV CF_NIV_SUIV False None None None False False None None CF_NIV_SUIV False False None None None False None False CF_NIV_SUIV True False False None None False None False CF_NIV_SUIV None CF_NIV_SUIV True False None False 2019-09-11 23:00:00 CF_NIV_SUIV [] CF_NIV_SUIV 2019-09-13 23:00:00 2019-09-18 23:00:00 CF_NIV_SUIV <NA> <NA> <NA> NaT