dossiers.dossier_parlementaire_acte_legislatif_texte_associe
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 %
5 606 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | type_texte | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.typeTexte · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 % |
| 10 | ref_texte_associe | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.textesAssocies.texteAssocie.refTexteAssocie · présence : L17 16 %, L16 14 %, L15 13 %, L14 21 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | type_texte | ref_texte_associe |
|---|---|---|---|---|---|---|---|---|---|
| 15060000144207 | L15/dossiers | 15 | 15060000144132 | 15060000144205 | 2 | 2 | TAP | PRJLANR5L15TAP0195 | |
| 15060000144322 | L15/dossiers | 15 | 15060000144233 | 15060000144321 | 1 | 2 | BTA | PIONSNR5S339BTA0002 | |
| 15060000144341 | L15/dossiers | 15 | 15060000144328 | 15060000144340 | 1 | 2 | BTA | PIONSNR5S319BTA0035 | |
| 15060000144355 | L15/dossiers | 15 | 15060000144328 | 15060000144354 | 1 | 2 | BTA | PIONANR5L15BTA0316 | |
| 15060000144356 | L15/dossiers | 15 | 15060000144328 | 15060000144354 | 2 | 2 | TAP | PIONANR5L15TAP0316 | |
| 15060000144366 | L15/dossiers | 15 | 15060000144328 | 15060000144365 | 1 | 2 | BTA | PIONSNR5S319BTA0144 | |
| 15060000144382 | L15/dossiers | 15 | 15060000144369 | 15060000144381 | 1 | 2 | BTA | PIONSNR5S319BTA0037 | |
| 15060000144439 | L15/dossiers | 15 | 15060000144408 | 15060000144438 | 1 | 2 | BTA | PRJLANR5L15BTA0220 | |
| 15060000144440 | L15/dossiers | 15 | 15060000144408 | 15060000144438 | 2 | 2 | TAP | PRJLANR5L15TAP0220 | |
| 15060000144453 | L15/dossiers | 15 | 15060000144408 | 15060000144452 | 1 | 2 | BTA | PRJLSNR5S319BTA0091 | |
| 15060000144467 | L15/dossiers | 15 | 15060000144408 | 15060000144466 | 1 | 2 | BTA | PRJLANR5L15BTA0314 | |
| 15060000144468 | L15/dossiers | 15 | 15060000144408 | 15060000144466 | 2 | 2 | TAP | PRJLANR5L15TAP0314 | |
| 15060000144472 | L15/dossiers | 15 | 15060000144408 | 15060000144471 | 1 | 2 | BTA | PRJLSNR5S319BTA0136 | |
| 15060000144504 | L15/dossiers | 15 | 15060000144479 | 15060000144503 | 1 | 2 | BTA | PRJLANR5L15BTA0219 | |
| 15060000144505 | L15/dossiers | 15 | 15060000144479 | 15060000144503 | 2 | 2 | TAP | PRJLANR5L15TAP0219 | |
| 15060000144523 | L15/dossiers | 15 | 15060000144479 | 15060000144522 | 1 | 2 | BTA | PRJLSNR5S319BTA0090 | |
| 15060000144537 | L15/dossiers | 15 | 15060000144479 | 15060000144536 | 1 | 2 | BTA | PRJLANR5L15BTA0313 | |
| 15060000144538 | L15/dossiers | 15 | 15060000144479 | 15060000144536 | 2 | 2 | TAP | PRJLANR5L15TAP0313 | |
| 15060000144542 | L15/dossiers | 15 | 15060000144479 | 15060000144541 | 1 | 2 | BTA | PRJLSNR5S319BTA0135 | |
| 15060000144563 | L15/dossiers | 15 | 15060000144549 | 15060000144562 | 1 | 2 | BTA | PRJLSNR5S319BTA0057 | |
| 15060000144583 | L15/dossiers | 15 | 15060000144549 | 15060000144582 | 1 | 2 | BTA | PRJLANR5L15BTA0383 | |
| 15060000144655 | L15/dossiers | 15 | 15060000144638 | 15060000144654 | 1 | 2 | BTA | PIONANR5L15BTA0397 | |
| 15060000144656 | L15/dossiers | 15 | 15060000144638 | 15060000144654 | 2 | 2 | TAP | PIONANR5L15TAP0397 | |
| 15060000144667 | L15/dossiers | 15 | 15060000144638 | 15060000144666 | 1 | 2 | BTA | PIONSNR5S359BTA0117 | |
| 15060000144679 | L15/dossiers | 15 | 15060000144638 | 15060000144678 | 1 | 2 | BTA | PIONANR5L15BTA0703 | |
| 15060000144680 | L15/dossiers | 15 | 15060000144638 | 15060000144678 | 2 | 2 | TAP | PIONANR5L15TAP0703 | |
| 15060000144838 | L15/dossiers | 15 | 15060000144810 | 15060000144837 | 1 | 2 | BTA | PRJLSNR5S319BTA0084 | |
| 15060000144908 | L15/dossiers | 15 | 15060000144810 | 15060000144907 | 1 | 2 | BTA | PRJLANR5L15BTA0286 | |
| 15060000144909 | L15/dossiers | 15 | 15060000144810 | 15060000144907 | 2 | 2 | TAP | PRJLANR5L15TAP0286 | |
| 15060000144944 | L15/dossiers | 15 | 15060000144810 | 15060000144943 | 1 | 2 | BTA | PRJLANR5L15BTA0331 | |
| 15060000144945 | L15/dossiers | 15 | 15060000144810 | 15060000144943 | 2 | 2 | TAP | PRJLANR5L15TAP0331 | |
| 15060000144957 | L15/dossiers | 15 | 15060000144810 | 15060000144956 | 1 | 2 | BTA | PRJLSNR5S339BTA0021 | |
| 15060000144967 | L15/dossiers | 15 | 15060000144810 | 15060000144966 | 1 | 2 | BTA | PRJLANR5L15BTA0349 | |
| 15060000144968 | L15/dossiers | 15 | 15060000144810 | 15060000144966 | 2 | 2 | TAP | PRJLANR5L15TAP0349 | |
| 15060000144991 | L15/dossiers | 15 | 15060000144977 | 15060000144990 | 1 | 2 | BTA | PRJLSNR5S319BTA0063 | |
| 15060000145005 | L15/dossiers | 15 | 15060000144977 | 15060000145004 | 1 | 2 | BTA | PRJLANR5L15BTA0334 | |
| 15060000145191 | L15/dossiers | 15 | 15060000145154 | 15060000145190 | 1 | 2 | BTA | PRJLANR5L15BTA0233 | |
| 15060000145192 | L15/dossiers | 15 | 15060000145154 | 15060000145190 | 2 | 2 | TAP | PRJLANR5L15TAP0233 | |
| 15060000145208 | L15/dossiers | 15 | 15060000145154 | 15060000145207 | 1 | 2 | BTA | PRJLSNR5S319BTA0100 | |
| 15060000145223 | L15/dossiers | 15 | 15060000145154 | 15060000145222 | 1 | 2 | BTA | PRJLANR5L15BTA0302 | |
| 15060000145224 | L15/dossiers | 15 | 15060000145154 | 15060000145222 | 2 | 2 | TAP | PRJLANR5L15TAP0302 | |
| 15060000145228 | L15/dossiers | 15 | 15060000145154 | 15060000145227 | 1 | 2 | BTA | PRJLSNR5S319BTA0126 | |
| 15060000145248 | L15/dossiers | 15 | 15060000145238 | 15060000145247 | 1 | 2 | BTA | RIONANR5L15BTA0222 | |
| 15060000145306 | L15/dossiers | 15 | 15060000145291 | 15060000145305 | 1 | 2 | BTA | PIONANR5L15BTA0266 | |
| 15060000145307 | L15/dossiers | 15 | 15060000145291 | 15060000145305 | 2 | 2 | TAP | PIONANR5L15TAP0266 | |
| 15060000145372 | L15/dossiers | 15 | 15060000145355 | 15060000145371 | 1 | 2 | BTA | PRJLSNR5S319BTA0067 | |
| 15060000145388 | L15/dossiers | 15 | 15060000145355 | 15060000145387 | 1 | 2 | BTA | PRJLANR5L15BTA0260 | |
| 15060000145389 | L15/dossiers | 15 | 15060000145355 | 15060000145387 | 2 | 2 | TAP | PRJLANR5L15TAP0260 | |
| 15060000145403 | L15/dossiers | 15 | 15060000145355 | 15060000145402 | 1 | 2 | BTA | PRJLSNR5S319BTA0105 | |
| 15060000145407 | L15/dossiers | 15 | 15060000145355 | 15060000145406 | 1 | 2 | BTA | PRJLANR5L15BTA0275 |