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 |
|---|---|---|---|---|---|---|---|---|
| 15060000113361 | L15/dossiers | 15 | 15060000113360 | 15060000113360 | 1 | PO717460 | ||
| 15060000113364 | L15/dossiers | 15 | 15060000113363 | 15060000113363 | 1 | PO717460 | ||
| 15060000113367 | L15/dossiers | 15 | 15060000113366 | 15060000113366 | 1 | PO717460 | ||
| 15060000113370 | L15/dossiers | 15 | 15060000113369 | 15060000113369 | 1 | PO717460 | ||
| 15060000113373 | L15/dossiers | 15 | 15060000113372 | 15060000113372 | 1 | PO717460 | ||
| 15060000113376 | L15/dossiers | 15 | 15060000113375 | 15060000113375 | 1 | PO717460 | ||
| 15060000113380 | L15/dossiers | 15 | 15060000113379 | 15060000113379 | 1 | PO717460 | ||
| 15060000113382 | L15/dossiers | 15 | 15060000113381 | 15060000113381 | 1 | PO717460 | ||
| 15060000113385 | L15/dossiers | 15 | 15060000113384 | 15060000113384 | 1 | PO717460 | ||
| 15060000113388 | L15/dossiers | 15 | 15060000113387 | 15060000113387 | 1 | PO717460 | ||
| 15060000113391 | L15/dossiers | 15 | 15060000113390 | 15060000113390 | 1 | PO717460 | ||
| 15060000113394 | L15/dossiers | 15 | 15060000113393 | 15060000113393 | 1 | PO717460 | ||
| 15060000113398 | L15/dossiers | 15 | 15060000113397 | 15060000113397 | 1 | PO717460 | ||
| 15060000113401 | L15/dossiers | 15 | 15060000113400 | 15060000113400 | 1 | PO717460 | ||
| 15060000113404 | L15/dossiers | 15 | 15060000113403 | 15060000113403 | 1 | PO717460 | ||
| 15060000113408 | L15/dossiers | 15 | 15060000113407 | 15060000113407 | 1 | PO717460 | ||
| 15060000113411 | L15/dossiers | 15 | 15060000113410 | 15060000113410 | 1 | PO717460 | ||
| 15060000113414 | L15/dossiers | 15 | 15060000113413 | 15060000113413 | 1 | PO717460 | ||
| 15060000113417 | L15/dossiers | 15 | 15060000113416 | 15060000113416 | 1 | PO717460 | ||
| 15060000113420 | L15/dossiers | 15 | 15060000113419 | 15060000113419 | 1 | PO717460 | ||
| 15060000113424 | L15/dossiers | 15 | 15060000113423 | 15060000113423 | 1 | PO717460 | ||
| 15060000113427 | L15/dossiers | 15 | 15060000113426 | 15060000113426 | 1 | PO717460 | ||
| 15060000113432 | L15/dossiers | 15 | 15060000113431 | 15060000113431 | 1 | PO717460 | ||
| 15060000113435 | L15/dossiers | 15 | 15060000113434 | 15060000113434 | 1 | PO717460 | ||
| 15060000113438 | L15/dossiers | 15 | 15060000113437 | 15060000113437 | 1 | PO717460 | ||
| 15060000113441 | L15/dossiers | 15 | 15060000113440 | 15060000113440 | 1 | PO717460 | ||
| 15060000113445 | L15/dossiers | 15 | 15060000113444 | 15060000113444 | 1 | PO717460 | ||
| 15060000113448 | L15/dossiers | 15 | 15060000113447 | 15060000113447 | 1 | PO717460 | ||
| 15060000113450 | L15/dossiers | 15 | 15060000113449 | 15060000113449 | 1 | PO717460 | ||
| 15060000113452 | L15/dossiers | 15 | 15060000113451 | 15060000113451 | 1 | PO717460 | ||
| 15060000113456 | L15/dossiers | 15 | 15060000113455 | 15060000113455 | 1 | PO717460 | ||
| 15060000113459 | L15/dossiers | 15 | 15060000113458 | 15060000113458 | 1 | PO717460 | ||
| 15060000113462 | L15/dossiers | 15 | 15060000113461 | 15060000113461 | 1 | PO717460 | ||
| 15060000113465 | L15/dossiers | 15 | 15060000113464 | 15060000113464 | 1 | PO717460 | ||
| 15060000113471 | L15/dossiers | 15 | 15060000113470 | 15060000113470 | 1 | PO717460 | ||
| 15060000113474 | L15/dossiers | 15 | 15060000113473 | 15060000113473 | 1 | PO717460 | ||
| 15060000113477 | L15/dossiers | 15 | 15060000113476 | 15060000113476 | 1 | PO717460 | ||
| 15060000113481 | L15/dossiers | 15 | 15060000113480 | 15060000113480 | 1 | PO717460 | ||
| 15060000113483 | L15/dossiers | 15 | 15060000113482 | 15060000113482 | 1 | PO717460 | ||
| 15060000113487 | L15/dossiers | 15 | 15060000113486 | 15060000113486 | 1 | PO717460 | ||
| 15060000113489 | L15/dossiers | 15 | 15060000113488 | 15060000113488 | 1 | PO717460 | ||
| 15060000113492 | L15/dossiers | 15 | 15060000113491 | 15060000113491 | 1 | PO717460 | ||
| 15060000113495 | L15/dossiers | 15 | 15060000113494 | 15060000113494 | 1 | PO717460 | ||
| 15060000113498 | L15/dossiers | 15 | 15060000113497 | 15060000113497 | 1 | PO717460 | ||
| 15060000113501 | L15/dossiers | 15 | 15060000113500 | 15060000113500 | 1 | PO717460 | ||
| 15060000113503 | L15/dossiers | 15 | 15060000113502 | 15060000113502 | 1 | PO717460 | ||
| 15060000113505 | L15/dossiers | 15 | 15060000113504 | 15060000113504 | 1 | PO717460 | ||
| 15060000113507 | L15/dossiers | 15 | 15060000113506 | 15060000113506 | 1 | PO717460 | ||
| 15060000113510 | L15/dossiers | 15 | 15060000113509 | 15060000113509 | 1 | PO717460 | ||
| 15060000113513 | L15/dossiers | 15 | 15060000113512 | 15060000113512 | 1 | PO717460 |