dossiers.document_auteur
Chemin document.auteurs.auteur · présence : L17 100 %, L16 100 %, L15 100 %, L14 100 %
59 600 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 | acteur_acteur_ref | VARCHAR | document.auteurs.auteur.acteur.acteurRef · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % |
| 8 | acteur_qualite | VARCHAR | document.auteurs.auteur.acteur.qualite · présence : L17 71 %, L16 72 %, L15 74 %, L14 86 % · 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 |
| 9 | organe_organe_ref | VARCHAR | document.auteurs.auteur.organe.organeRef · présence : L17 59 %, L16 58 %, L15 56 %, L14 56 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_acteur_ref | acteur_qualite | organe_organe_ref |
|---|---|---|---|---|---|---|---|---|
| 16060000087373 | L16/dossiers | 16 | 16060000087372 | 16060000087372 | 1 | PA719138 | rapporteur | |
| 16060000087374 | L16/dossiers | 16 | 16060000087372 | 16060000087372 | 2 | PO59048 | ||
| 16060000087379 | L16/dossiers | 16 | 16060000087375 | 16060000087375 | 1 | PA267766 | rapporteur | |
| 16060000087380 | L16/dossiers | 16 | 16060000087375 | 16060000087375 | 2 | PO59051 | ||
| 16060000087382 | L16/dossiers | 16 | 16060000087381 | 16060000087381 | 1 | PA793398 | rapporteur | |
| 16060000087383 | L16/dossiers | 16 | 16060000087381 | 16060000087381 | 2 | PO419604 | ||
| 16060000087388 | L16/dossiers | 16 | 16060000087384 | 16060000087384 | 1 | PA822617 | rapporteur | |
| 16060000087389 | L16/dossiers | 16 | 16060000087384 | 16060000087384 | 2 | PO420120 | ||
| 16060000087394 | L16/dossiers | 16 | 16060000087390 | 16060000087390 | 1 | PA720696 | rapporteur | |
| 16060000087395 | L16/dossiers | 16 | 16060000087390 | 16060000087390 | 2 | PO420120 | ||
| 16060000087400 | L16/dossiers | 16 | 16060000087396 | 16060000087396 | 1 | PA719286 | rapporteur | |
| 16060000087401 | L16/dossiers | 16 | 16060000087396 | 16060000087396 | 2 | PO420120 | ||
| 16060000087403 | L16/dossiers | 16 | 16060000087402 | 16060000087402 | 1 | PA2162 | rapporteur | |
| 16060000087405 | L16/dossiers | 16 | 16060000087404 | 16060000087404 | 1 | PA2756 | rapporteur | |
| 16060000087407 | L16/dossiers | 16 | 16060000087406 | 16060000087406 | 1 | PA99999999 | rapporteur | |
| 16060000087409 | L16/dossiers | 16 | 16060000087408 | 16060000087408 | 1 | PA1447 | rapporteur | |
| 16060000087411 | L16/dossiers | 16 | 16060000087410 | 16060000087410 | 1 | PA1824 | rapporteur | |
| 16060000087413 | L16/dossiers | 16 | 16060000087412 | 16060000087412 | 1 | PA1824 | rapporteur | |
| 16060000087415 | L16/dossiers | 16 | 16060000087414 | 16060000087414 | 1 | PA592 | rapporteur | |
| 16060000087417 | L16/dossiers | 16 | 16060000087416 | 16060000087416 | 1 | PA227018 | rapporteur | |
| 16060000087418 | L16/dossiers | 16 | 16060000087416 | 16060000087416 | 2 | PO211492 | ||
| 16060000087420 | L16/dossiers | 16 | 16060000087419 | 16060000087419 | 1 | PA2081 | rapporteur | |
| 16060000087421 | L16/dossiers | 16 | 16060000087419 | 16060000087419 | 2 | PO211494 | ||
| 16060000087423 | L16/dossiers | 16 | 16060000087422 | 16060000087422 | 1 | PA267419 | rapporteur | |
| 16060000087424 | L16/dossiers | 16 | 16060000087422 | 16060000087422 | 2 | PO211495 | ||
| 16060000087426 | L16/dossiers | 16 | 16060000087425 | 16060000087425 | 1 | PA227087 | rapporteur | |
| 16060000087427 | L16/dossiers | 16 | 16060000087425 | 16060000087425 | 2 | PO211495 | ||
| 16060000087429 | L16/dossiers | 16 | 16060000087428 | 16060000087428 | 1 | PA2905 | rapporteur | |
| 16060000087430 | L16/dossiers | 16 | 16060000087428 | 16060000087428 | 2 | PO211495 | ||
| 16060000087432 | L16/dossiers | 16 | 16060000087431 | 16060000087431 | 1 | PA227026 | rapporteur | |
| 16060000087433 | L16/dossiers | 16 | 16060000087431 | 16060000087431 | 2 | PO211493 | ||
| 16060000087435 | L16/dossiers | 16 | 16060000087434 | 16060000087434 | 1 | PA658 | rapporteur | |
| 16060000087436 | L16/dossiers | 16 | 16060000087434 | 16060000087434 | 2 | PO211492 | ||
| 16060000087438 | L16/dossiers | 16 | 16060000087437 | 16060000087437 | 1 | PA406065 | rapporteur | |
| 16060000087439 | L16/dossiers | 16 | 16060000087437 | 16060000087437 | 2 | PO211495 | ||
| 16060000087441 | L16/dossiers | 16 | 16060000087440 | 16060000087440 | 1 | PA2538 | rapporteur | |
| 16060000087442 | L16/dossiers | 16 | 16060000087440 | 16060000087440 | 2 | PO211492 | ||
| 16060000087444 | L16/dossiers | 16 | 16060000087443 | 16060000087443 | 1 | PA429891 | rapporteur | |
| 16060000087445 | L16/dossiers | 16 | 16060000087443 | 16060000087443 | 2 | PO211495 | ||
| 16060000087447 | L16/dossiers | 16 | 16060000087446 | 16060000087446 | 1 | PA944 | rapporteur | |
| 16060000087448 | L16/dossiers | 16 | 16060000087446 | 16060000087446 | 2 | PO211492 | ||
| 16060000087450 | L16/dossiers | 16 | 16060000087449 | 16060000087449 | 1 | PA429896 | rapporteur | |
| 16060000087451 | L16/dossiers | 16 | 16060000087449 | 16060000087449 | 2 | PO211493 | ||
| 16060000087453 | L16/dossiers | 16 | 16060000087452 | 16060000087452 | 1 | PA677483 | rapporteur | |
| 16060000087454 | L16/dossiers | 16 | 16060000087452 | 16060000087452 | 2 | PO516754 | ||
| 16060000087456 | L16/dossiers | 16 | 16060000087455 | 16060000087455 | 1 | PA415460 | rapporteur | |
| 16060000087457 | L16/dossiers | 16 | 16060000087455 | 16060000087455 | 2 | PO211495 | ||
| 16060000087459 | L16/dossiers | 16 | 16060000087458 | 16060000087458 | 1 | PA304082 | rapporteur | |
| 16060000087460 | L16/dossiers | 16 | 16060000087458 | 16060000087458 | 2 | PO211495 | ||
| 16060000087462 | L16/dossiers | 16 | 16060000087461 | 16060000087461 | 1 | PA2552 | rapporteur |