dossiers.document_division_auteur
Chemin document.divisions.division.auteurs.auteur · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 %
7 614 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 | acteur_acteur_ref | VARCHAR | document.divisions.division.auteurs.auteur.acteur.acteurRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
| 10 | acteur_qualite | VARCHAR | document.divisions.division.auteurs.auteur.acteur.qualite · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF |
| 11 | organe_organe_ref | VARCHAR | document.divisions.division.auteurs.auteur.organe.organeRef · présence : L17 4 %, L16 4 %, L15 4 %, L14 3 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000085350 | L16/dossiers | 16 | 16060000085344 | 16060000085348 | 2 | 0 | PO59048 | |||
| 16060000085352 | L16/dossiers | 16 | 16060000085344 | 16060000085351 | 1 | 0 | PA719472 | rapporteur général | ||
| 16060000085353 | L16/dossiers | 16 | 16060000085344 | 16060000085351 | 2 | 0 | PO59048 | |||
| 16060000085370 | L16/dossiers | 16 | 16060000085368 | 16060000085369 | 1 | 0 | PA795926 | rapporteur | ||
| 16060000085371 | L16/dossiers | 16 | 16060000085368 | 16060000085369 | 2 | 0 | PO419604 | |||
| 16060000085382 | L16/dossiers | 16 | 16060000085380 | 16060000085381 | 1 | 0 | PA720696 | rapporteur | ||
| 16060000085383 | L16/dossiers | 16 | 16060000085380 | 16060000085381 | 2 | 0 | PA793382 | rapporteur | ||
| 16060000085384 | L16/dossiers | 16 | 16060000085380 | 16060000085381 | 3 | 0 | PO420120 | |||
| 16060000085390 | L16/dossiers | 16 | 16060000085388 | 16060000085389 | 1 | 0 | PA642868 | rapporteur | ||
| 16060000085391 | L16/dossiers | 16 | 16060000085388 | 16060000085389 | 2 | 0 | PO420120 | |||
| 16060000085405 | L16/dossiers | 16 | 16060000085403 | 16060000085404 | 1 | 0 | PA719512 | rapporteur | ||
| 16060000085406 | L16/dossiers | 16 | 16060000085403 | 16060000085404 | 2 | 0 | PO419610 | |||
| 16060000085411 | L16/dossiers | 16 | 16060000085409 | 16060000085410 | 1 | 0 | PA720066 | rapporteur | ||
| 16060000085412 | L16/dossiers | 16 | 16060000085409 | 16060000085410 | 2 | 0 | PO420120 | |||
| 16060000085417 | L16/dossiers | 16 | 16060000085415 | 16060000085416 | 1 | 0 | PA793940 | rapporteur | ||
| 16060000085418 | L16/dossiers | 16 | 16060000085415 | 16060000085416 | 2 | 0 | PO59051 | |||
| 16060000085426 | L16/dossiers | 16 | 16060000085424 | 16060000085425 | 1 | 0 | PA720862 | rapporteur | ||
| 16060000085427 | L16/dossiers | 16 | 16060000085424 | 16060000085425 | 2 | 0 | PO419610 | |||
| 16060000085438 | L16/dossiers | 16 | 16060000085436 | 16060000085437 | 1 | 0 | PA793876 | rapporteur | ||
| 16060000085439 | L16/dossiers | 16 | 16060000085436 | 16060000085437 | 2 | 0 | PO420120 | |||
| 16060000085469 | L16/dossiers | 16 | 16060000085467 | 16060000085468 | 1 | 0 | PA774960 | rapporteur | ||
| 16060000085470 | L16/dossiers | 16 | 16060000085467 | 16060000085468 | 2 | 0 | PO59051 | |||
| 16060000085475 | L16/dossiers | 16 | 16060000085473 | 16060000085474 | 1 | 0 | PA608695 | rapporteur | ||
| 16060000085476 | L16/dossiers | 16 | 16060000085473 | 16060000085474 | 2 | 0 | PO59051 | |||
| 16060000085484 | L16/dossiers | 16 | 16060000085482 | 16060000085483 | 1 | 0 | PA795828 | rapporteur | ||
| 16060000085485 | L16/dossiers | 16 | 16060000085482 | 16060000085483 | 2 | 0 | PO419610 | |||
| 16060000085490 | L16/dossiers | 16 | 16060000085488 | 16060000085489 | 1 | 0 | PA793394 | rapporteur | ||
| 16060000085491 | L16/dossiers | 16 | 16060000085488 | 16060000085489 | 2 | 0 | PO419610 | |||
| 16060000085496 | L16/dossiers | 16 | 16060000085494 | 16060000085495 | 1 | 0 | PA795156 | rapporteur | ||
| 16060000085497 | L16/dossiers | 16 | 16060000085494 | 16060000085495 | 2 | 0 | PO419604 | |||
| 16060000085505 | L16/dossiers | 16 | 16060000085503 | 16060000085504 | 1 | 0 | PA793624 | rapporteur | ||
| 16060000085506 | L16/dossiers | 16 | 16060000085503 | 16060000085504 | 2 | 0 | PO59048 | |||
| 16060000085511 | L16/dossiers | 16 | 16060000085509 | 16060000085510 | 1 | 0 | PA720066 | rapporteur | ||
| 16060000085512 | L16/dossiers | 16 | 16060000085509 | 16060000085510 | 2 | 0 | PO420120 | |||
| 16060000085514 | L16/dossiers | 16 | 16060000085509 | 16060000085513 | 1 | 0 | PA720066 | rapporteur | ||
| 16060000085515 | L16/dossiers | 16 | 16060000085509 | 16060000085513 | 2 | 0 | PO420120 | |||
| 16060000085523 | L16/dossiers | 16 | 16060000085521 | 16060000085522 | 1 | 0 | PA605782 | rapporteur | ||
| 16060000085524 | L16/dossiers | 16 | 16060000085521 | 16060000085522 | 2 | 0 | PO419604 | |||
| 16060000085529 | L16/dossiers | 16 | 16060000085527 | 16060000085528 | 1 | 0 | PA719382 | rapporteur | ||
| 16060000085530 | L16/dossiers | 16 | 16060000085527 | 16060000085528 | 2 | 0 | PO419610 | |||
| 16060000085535 | L16/dossiers | 16 | 16060000085533 | 16060000085534 | 1 | 0 | PA642868 | rapporteur | ||
| 16060000085536 | L16/dossiers | 16 | 16060000085533 | 16060000085534 | 2 | 0 | PO420120 | |||
| 16060000085541 | L16/dossiers | 16 | 16060000085539 | 16060000085540 | 1 | 0 | PA720704 | rapporteur | ||
| 16060000085542 | L16/dossiers | 16 | 16060000085539 | 16060000085540 | 2 | 0 | PA266797 | rapporteur | ||
| 16060000085543 | L16/dossiers | 16 | 16060000085539 | 16060000085540 | 3 | 0 | PO59051 | |||
| 16060000085566 | L16/dossiers | 16 | 16060000085564 | 16060000085565 | 1 | 0 | PA722046 | rapporteur | ||
| 16060000085567 | L16/dossiers | 16 | 16060000085564 | 16060000085565 | 2 | 0 | PO59051 | |||
| 16060000085572 | L16/dossiers | 16 | 16060000085570 | 16060000085571 | 1 | 0 | PA720754 | rapporteur | ||
| 16060000085573 | L16/dossiers | 16 | 16060000085570 | 16060000085571 | 2 | 0 | PO59051 | |||
| 16060000085578 | L16/dossiers | 16 | 16060000085576 | 16060000085577 | 1 | 0 | PA720074 | rapporteur |