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 |
|---|---|---|---|---|---|---|---|---|
| 15060000115335 | L15/dossiers | 15 | 15060000115334 | 15060000115334 | 1 | PO717460 | ||
| 15060000115338 | L15/dossiers | 15 | 15060000115337 | 15060000115337 | 1 | PO717460 | ||
| 15060000115341 | L15/dossiers | 15 | 15060000115340 | 15060000115340 | 1 | PO717460 | ||
| 15060000115345 | L15/dossiers | 15 | 15060000115344 | 15060000115344 | 1 | PO717460 | ||
| 15060000115348 | L15/dossiers | 15 | 15060000115347 | 15060000115347 | 1 | PO717460 | ||
| 15060000115351 | L15/dossiers | 15 | 15060000115350 | 15060000115350 | 1 | PO717460 | ||
| 15060000115354 | L15/dossiers | 15 | 15060000115353 | 15060000115353 | 1 | PO717460 | ||
| 15060000115357 | L15/dossiers | 15 | 15060000115356 | 15060000115356 | 1 | PO717460 | ||
| 15060000115361 | L15/dossiers | 15 | 15060000115360 | 15060000115360 | 1 | PO717460 | ||
| 15060000115366 | L15/dossiers | 15 | 15060000115365 | 15060000115365 | 1 | PO717460 | ||
| 15060000115369 | L15/dossiers | 15 | 15060000115368 | 15060000115368 | 1 | PO717460 | ||
| 15060000115372 | L15/dossiers | 15 | 15060000115371 | 15060000115371 | 1 | PO717460 | ||
| 15060000115375 | L15/dossiers | 15 | 15060000115374 | 15060000115374 | 1 | PO717460 | ||
| 15060000115379 | L15/dossiers | 15 | 15060000115378 | 15060000115378 | 1 | PO717460 | ||
| 15060000115382 | L15/dossiers | 15 | 15060000115381 | 15060000115381 | 1 | PO717460 | ||
| 15060000115384 | L15/dossiers | 15 | 15060000115383 | 15060000115383 | 1 | PO717460 | ||
| 15060000115386 | L15/dossiers | 15 | 15060000115385 | 15060000115385 | 1 | PO717460 | ||
| 15060000115389 | L15/dossiers | 15 | 15060000115388 | 15060000115388 | 1 | PO717460 | ||
| 15060000115395 | L15/dossiers | 15 | 15060000115394 | 15060000115394 | 1 | PO717460 | ||
| 15060000115398 | L15/dossiers | 15 | 15060000115397 | 15060000115397 | 1 | PO717460 | ||
| 15060000115401 | L15/dossiers | 15 | 15060000115400 | 15060000115400 | 1 | PO717460 | ||
| 15060000115405 | L15/dossiers | 15 | 15060000115404 | 15060000115404 | 1 | PO717460 | ||
| 15060000115407 | L15/dossiers | 15 | 15060000115406 | 15060000115406 | 1 | PO717460 | ||
| 15060000115411 | L15/dossiers | 15 | 15060000115410 | 15060000115410 | 1 | PO717460 | ||
| 15060000115413 | L15/dossiers | 15 | 15060000115412 | 15060000115412 | 1 | PO717460 | ||
| 15060000115415 | L15/dossiers | 15 | 15060000115414 | 15060000115414 | 1 | PO717460 | ||
| 15060000115417 | L15/dossiers | 15 | 15060000115416 | 15060000115416 | 1 | PO717460 | ||
| 15060000115419 | L15/dossiers | 15 | 15060000115418 | 15060000115418 | 1 | PO717460 | ||
| 15060000115422 | L15/dossiers | 15 | 15060000115421 | 15060000115421 | 1 | PO717460 | ||
| 15060000115425 | L15/dossiers | 15 | 15060000115424 | 15060000115424 | 1 | PO717460 | ||
| 15060000115427 | L15/dossiers | 15 | 15060000115426 | 15060000115426 | 1 | PO717460 | ||
| 15060000115430 | L15/dossiers | 15 | 15060000115429 | 15060000115429 | 1 | PO717460 | ||
| 15060000115433 | L15/dossiers | 15 | 15060000115432 | 15060000115432 | 1 | PO717460 | ||
| 15060000115435 | L15/dossiers | 15 | 15060000115434 | 15060000115434 | 1 | PO717460 | ||
| 15060000115437 | L15/dossiers | 15 | 15060000115436 | 15060000115436 | 1 | PO717460 | ||
| 15060000115439 | L15/dossiers | 15 | 15060000115438 | 15060000115438 | 1 | PO717460 | ||
| 15060000115442 | L15/dossiers | 15 | 15060000115441 | 15060000115441 | 1 | PO717460 | ||
| 15060000115444 | L15/dossiers | 15 | 15060000115443 | 15060000115443 | 1 | PO717460 | ||
| 15060000115448 | L15/dossiers | 15 | 15060000115447 | 15060000115447 | 1 | PO717460 | ||
| 15060000115451 | L15/dossiers | 15 | 15060000115450 | 15060000115450 | 1 | PO717460 | ||
| 15060000115461 | L15/dossiers | 15 | 15060000115460 | 15060000115460 | 1 | PO717460 | ||
| 15060000115464 | L15/dossiers | 15 | 15060000115463 | 15060000115463 | 1 | PO717460 | ||
| 15060000115466 | L15/dossiers | 15 | 15060000115465 | 15060000115465 | 1 | PO717460 | ||
| 15060000115470 | L15/dossiers | 15 | 15060000115469 | 15060000115469 | 1 | PO717460 | ||
| 15060000115473 | L15/dossiers | 15 | 15060000115472 | 15060000115472 | 1 | PO717460 | ||
| 15060000115476 | L15/dossiers | 15 | 15060000115475 | 15060000115475 | 1 | PO717460 | ||
| 15060000115479 | L15/dossiers | 15 | 15060000115478 | 15060000115478 | 1 | PO717460 | ||
| 15060000115481 | L15/dossiers | 15 | 15060000115480 | 15060000115480 | 1 | PO717460 | ||
| 15060000115483 | L15/dossiers | 15 | 15060000115482 | 15060000115482 | 1 | PO717460 | ||
| 15060000115487 | L15/dossiers | 15 | 15060000115486 | 15060000115486 | 1 | PO717460 |