debats.compte_rendu_sommaire1_sommaire2_sommaire3
Chemin compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3 · présence : L17 84 %, L16 83 %, L15 85 %
24 558 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | titre_struct_intitule | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.intitule · présence : L17 84 %, L16 83 %, L15 85 % |
| 8 | titre_struct_intitule_xml | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.intitule.#xml · présence : L17 83 %, L16 83 %, L15 83 % |
| 9 | titre_struct_id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.@id_syceron · présence : L17 84 %, L16 83 %, L15 85 % |
| 10 | titre_struct_type_debat | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.titreStruct.@type_debat · présence : L17 15 %, L16 10 %, L15 18 % |
| 11 | type_debat | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.@type_debat · présence : L17 15 %, L16 10 %, L15 18 % |
| 12 | para | VARCHAR | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.Para · présence : L16 0 % |
| 13 | para_id_syceron | BIGINT | compteRendu.metadonnees.sommaire.sommaire1.sommaire2.sommaire3.Para.@id_syceron · présence : L16 0 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | titre_struct_intitule | titre_struct_intitule_xml | titre_struct_id_syceron | titre_struct_type_debat | type_debat | para | para_id_syceron |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15130001048913 | L15/debats | 15 | 15130001048894 | 15130001048896 | 6 | Après l’article 32 | 1886435 | PLFSS | PLFSS | |||
| 15130001048915 | L15/debats | 15 | 15130001048894 | 15130001048896 | 7 | Article 33 | 1886463 | PLFSS | PLFSS | |||
| 15130001048916 | L15/debats | 15 | 15130001048894 | 15130001048896 | 8 | Article 34 | 1886465 | PLFSS | PLFSS | |||
| 15130001048919 | L15/debats | 15 | 15130001048894 | 15130001048896 | 9 | Article 35 | 1886719 | PLFSS | PLFSS | |||
| 15130001048924 | L15/debats | 15 | 15130001048894 | 15130001048896 | 10 | Après l’article 35 | 1887024 | PLFSS | PLFSS | |||
| 15130001048926 | L15/debats | 15 | 15130001048894 | 15130001048896 | 11 | Article 36 | 1887036 | PLFSS | PLFSS | |||
| 15130001048931 | L15/debats | 15 | 15130001048894 | 15130001048896 | 12 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance</italique> | 1886766 | PLFSS | PLFSS | ||
| 15130001048932 | L15/debats | 15 | 15130001048894 | 15130001048896 | 13 | Article 37 | 1886770 | PLFSS | PLFSS | |||
| 15130001048937 | L15/debats | 15 | 15130001048894 | 15130001048896 | 14 | Après l’article 37 | 1886836 | PLFSS | PLFSS | |||
| 15130001048939 | L15/debats | 15 | 15130001048894 | 15130001048896 | 15 | Article 38 | 1886939 | PLFSS | PLFSS | |||
| 15130001048944 | L15/debats | 15 | 15130001048894 | 15130001048896 | 16 | Après l’article 38 | 1887089 | PLFSS | PLFSS | |||
| 15130001048946 | L15/debats | 15 | 15130001048894 | 15130001048896 | 17 | Article 39 | 1887196 | PLFSS | PLFSS | |||
| 15130001048949 | L15/debats | 15 | 15130001048894 | 15130001048896 | 18 | Après l’article 39 | 1887213 | PLFSS | PLFSS | |||
| 15130001050434 | L15/debats | 15 | 15130001050431 | 15130001050433 | 1 | Article 40 | 1887402 | PLFSS | PLFSS | |||
| 15130001050441 | L15/debats | 15 | 15130001050431 | 15130001050433 | 2 | Après l’article 40 | 1887730 | PLFSS | PLFSS | |||
| 15130001050443 | L15/debats | 15 | 15130001050431 | 15130001050433 | 3 | Article 41 | 1888106 | PLFSS | PLFSS | |||
| 15130001050448 | L15/debats | 15 | 15130001050431 | 15130001050433 | 4 | Après l’article 41 | 1888499 | PLFSS | PLFSS | |||
| 15130001050450 | L15/debats | 15 | 15130001050431 | 15130001050433 | 5 | Article 42 | 1888521 | PLFSS | PLFSS | |||
| 15130001050452 | L15/debats | 15 | 15130001050431 | 15130001050433 | 6 | Après l’article 42 | 1888550 | PLFSS | PLFSS | |||
| 15130001050454 | L15/debats | 15 | 15130001050431 | 15130001050433 | 7 | Article 43 | 1888557 | PLFSS | PLFSS | |||
| 15130001050456 | L15/debats | 15 | 15130001050431 | 15130001050433 | 8 | Article 44 | 1888572 | PLFSS | PLFSS | |||
| 15130001050458 | L15/debats | 15 | 15130001050431 | 15130001050433 | 9 | Après l’article 44 | 1888848 | PLFSS | PLFSS | |||
| 15130001050460 | L15/debats | 15 | 15130001050431 | 15130001050433 | 10 | Article 45 | 1888875 | PLFSS | PLFSS | |||
| 15130001050469 | L15/debats | 15 | 15130001050431 | 15130001050433 | 11 | Après l’article 45 | 1889120 | PLFSS | PLFSS | |||
| 15130001050471 | L15/debats | 15 | 15130001050431 | 15130001050433 | 12 | Article 46 | 1889156 | PLFSS | PLFSS | |||
| 15130001050477 | L15/debats | 15 | 15130001050431 | 15130001050433 | 13 | Après l’article 46 | 1887804 | PLFSS | PLFSS | |||
| 15130001050479 | L15/debats | 15 | 15130001050431 | 15130001050433 | 14 | Suspension et reprise de la séance | <italique>Suspension et reprise de la séance</italique> | 1887816 | PLFSS | PLFSS | ||
| 15130001050480 | L15/debats | 15 | 15130001050431 | 15130001050433 | 15 | Article 47 | 1887820 | PLFSS | PLFSS | |||
| 15130001050482 | L15/debats | 15 | 15130001050431 | 15130001050433 | 16 | Après l’article 47 | 1887828 | PLFSS | PLFSS | |||
| 15130001050484 | L15/debats | 15 | 15130001050431 | 15130001050433 | 17 | Article 48 | 1887831 | PLFSS | PLFSS | |||
| 15130001050487 | L15/debats | 15 | 15130001050431 | 15130001050433 | 18 | Article 49 | 1888180 | PLFSS | PLFSS | |||
| 15130001050490 | L15/debats | 15 | 15130001050431 | 15130001050433 | 19 | Après l’article 49 | 1888315 | PLFSS | PLFSS | |||
| 15130001050492 | L15/debats | 15 | 15130001050431 | 15130001050433 | 20 | Article 50 | 1888640 | PLFSS | PLFSS | |||
| 15130001050493 | L15/debats | 15 | 15130001050431 | 15130001050433 | 21 | Après l’article 50 | 1888642 | PLFSS | PLFSS | |||
| 15130001050495 | L15/debats | 15 | 15130001050431 | 15130001050433 | 22 | Article 51 | 1888591 | PLFSS | PLFSS | |||
| 15130001050497 | L15/debats | 15 | 15130001050431 | 15130001050433 | 23 | Après l’article 51 | 1888595 | PLFSS | PLFSS | |||
| 15130001050499 | L15/debats | 15 | 15130001050431 | 15130001050433 | 24 | Article 52 | 1888618 | PLFSS | PLFSS | |||
| 15130001050502 | L15/debats | 15 | 15130001050431 | 15130001050433 | 25 | Après l’article 52 | 1888913 | PLFSS | PLFSS | |||
| 15130001050504 | L15/debats | 15 | 15130001050431 | 15130001050433 | 26 | Article 53 | 1888924 | PLFSS | PLFSS | |||
| 15130001050507 | L15/debats | 15 | 15130001050431 | 15130001050433 | 27 | Après l’article 53 | 1888740 | PLFSS | PLFSS | |||
| 15130001050509 | L15/debats | 15 | 15130001050431 | 15130001050433 | 28 | Article 54 | 1888761 | PLFSS | PLFSS | |||
| 15130001050511 | L15/debats | 15 | 15130001050431 | 15130001050433 | 29 | Article 55 | 1888774 | PLFSS | PLFSS | |||
| 15130001050513 | L15/debats | 15 | 15130001050431 | 15130001050433 | 30 | Après l’article 55 | 1888783 | PLFSS | PLFSS | |||
| 15130001050515 | L15/debats | 15 | 15130001050431 | 15130001050433 | 31 | Article 56 | 1888792 | PLFSS | PLFSS | |||
| 15130001050517 | L15/debats | 15 | 15130001050431 | 15130001050433 | 32 | Après l’article 56 | 1889021 | PLFSS | PLFSS | |||
| 15130001050519 | L15/debats | 15 | 15130001050431 | 15130001050433 | 33 | Article 57 | 1889054 | PLFSS | PLFSS | |||
| 15130001050520 | L15/debats | 15 | 15130001050431 | 15130001050433 | 34 | Après l’article 57 | 1889056 | PLFSS | PLFSS | |||
| 15130001050522 | L15/debats | 15 | 15130001050431 | 15130001050433 | 35 | Article 58 | 1889207 | PLFSS | PLFSS | |||
| 15130001050524 | L15/debats | 15 | 15130001050431 | 15130001050433 | 36 | Article 59 | 1889213 | PLFSS | PLFSS | |||
| 15130001050527 | L15/debats | 15 | 15130001050431 | 15130001050433 | 37 | Après l’article 59 | 1889312 | PLFSS | PLFSS |