AN · données ouvertes
Explorateur / questions_ecrites

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 044 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7info_jo_type_joVARCHARquestion.renouvellements.renouvellement.infoJO.typeJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
8info_jo_date_joVARCHARquestion.renouvellements.renouvellement.infoJO.dateJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
9info_jo_page_joVARCHARquestion.renouvellements.renouvellement.infoJO.pageJO · présence : L17 11 %, L16 10 %
10info_jo_num_joBIGINTquestion.renouvellements.renouvellement.infoJO.numJO · présence : L17 11 %, L16 10 %
11info_jo_url_legifranceVARCHARquestion.renouvellements.renouvellement.infoJO.urlLegifrance · présence : L17 11 %, L16 10 %
12info_jo_reference_norVARCHARquestion.renouvellements.renouvellement.infoJO.referenceNOR · présence : L17 11 %, L16 10 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreinfo_jo_type_joinfo_jo_date_joinfo_jo_page_joinfo_jo_num_joinfo_jo_url_legifranceinfo_jo_reference_nor
17090000082746L17/questions_ecrites1717090000082738170900000827382JO_QUESTION2026-02-0320260005
17090000082747L17/questions_ecrites1717090000082738170900000827383JO_QUESTION2026-05-1220260019
17090000082748L17/questions_ecrites1717090000082738170900000827384JO_QUESTION2026-09-0120260035
17090000082771L17/questions_ecrites1717090000082766170900000827661JO_QUESTION2025-01-2120250003
17090000082772L17/questions_ecrites1717090000082766170900000827662JO_QUESTION2025-04-2920250017
17090000082778L17/questions_ecrites1717090000082773170900000827731JO_QUESTION2025-10-2820250043
17090000082779L17/questions_ecrites1717090000082773170900000827732JO_QUESTION2026-02-0320260005
17090000082780L17/questions_ecrites1717090000082773170900000827733JO_QUESTION2026-05-1220260019
17090000082781L17/questions_ecrites1717090000082773170900000827734JO_QUESTION2026-09-0120260035
17090000082788L17/questions_ecrites1717090000082782170900000827821JO_QUESTION2025-10-2820250043
17090000082789L17/questions_ecrites1717090000082782170900000827822JO_QUESTION2026-02-0320260005
17090000082828L17/questions_ecrites1717090000082821170900000828211JO_QUESTION2026-03-0320260009
17090000082835L17/questions_ecrites1717090000082829170900000828291JO_QUESTION2025-10-2820250043
17090000082836L17/questions_ecrites1717090000082829170900000828292JO_QUESTION2026-02-0320260005
17090000082923L17/questions_ecrites1717090000082914170900000829141JO_QUESTION2025-02-0420250005
17090000082924L17/questions_ecrites1717090000082914170900000829142JO_QUESTION2025-05-2720250021
17090000082925L17/questions_ecrites1717090000082914170900000829143JO_QUESTION2025-09-3020250039
17090000082926L17/questions_ecrites1717090000082914170900000829144JO_QUESTION2026-01-2720260004
17090000082952L17/questions_ecrites1717090000082945170900000829451JO_QUESTION2026-05-2620260021
17090000082960L17/questions_ecrites1717090000082953170900000829531JO_QUESTION2026-09-0120260035
17090000082977L17/questions_ecrites1717090000082971170900000829711JO_QUESTION2025-11-2520250047
17090000083013L17/questions_ecrites1717090000083006170900000830061JO_QUESTION2025-10-2820250043
17090000083053L17/questions_ecrites1717090000083046170900000830461JO_QUESTION2025-11-1820250046
17090000083087L17/questions_ecrites1717090000083081170900000830811JO_QUESTION2025-10-2820250043
17090000083088L17/questions_ecrites1717090000083081170900000830812JO_QUESTION2026-02-0320260005
17090000083089L17/questions_ecrites1717090000083081170900000830813JO_QUESTION2026-05-1220260019
17090000083142L17/questions_ecrites1717090000083136170900000831361JO_QUESTION2025-10-2820250043
17090000083167L17/questions_ecrites1717090000083161170900000831611JO_QUESTION2025-10-2820250043
17090000083192L17/questions_ecrites1717090000083186170900000831861JO_QUESTION2025-11-0420250044
17090000083199L17/questions_ecrites1717090000083193170900000831931JO_QUESTION2025-11-0420250044
17090000083212L17/questions_ecrites1717090000083206170900000832061JO_QUESTION2025-11-2520250047
17090000083267L17/questions_ecrites1717090000083262170900000832621JO_QUESTION2025-05-2720250021
17090000083279L17/questions_ecrites1717090000083272170900000832721JO_QUESTION2025-11-0420250044
17090000083280L17/questions_ecrites1717090000083272170900000832722JO_QUESTION2026-02-1020260006
17090000083340L17/questions_ecrites1717090000083334170900000833341JO_QUESTION2025-12-0220250048
17090000083361L17/questions_ecrites1717090000083356170900000833561JO_QUESTION2026-02-1020260006
17090000083362L17/questions_ecrites1717090000083356170900000833562JO_QUESTION2026-08-0420260031
17090000083397L17/questions_ecrites1717090000083390170900000833901JO_QUESTION2025-11-0420250044
17090000083489L17/questions_ecrites1717090000083484170900000834841JO_QUESTION2025-11-2520250047
17090000083490L17/questions_ecrites1717090000083484170900000834842JO_QUESTION2026-07-1420260028
17090000083533L17/questions_ecrites1717090000083525170900000835251JO_QUESTION2025-11-2520250047
17090000083547L17/questions_ecrites1717090000083541170900000835411JO_QUESTION2025-02-0420250005
17090000083578L17/questions_ecrites1717090000083572170900000835721JO_QUESTION2026-05-0520260018
17090000083587L17/questions_ecrites1717090000083579170900000835791JO_QUESTION2025-11-2520250047
17090000083588L17/questions_ecrites1717090000083579170900000835792JO_QUESTION2026-07-1420260028
17090000083616L17/questions_ecrites1717090000083608170900000836081JO_QUESTION2026-05-0520260018
17090000083688L17/questions_ecrites1717090000083682170900000836821JO_QUESTION2025-11-2520250047
17090000083713L17/questions_ecrites1717090000083707170900000837071JO_QUESTION2025-11-2520250047
17090000083763L17/questions_ecrites1717090000083758170900000837581JO_QUESTION2025-11-0420250044
17090000083793L17/questions_ecrites1717090000083788170900000837881JO_QUESTION2025-11-0420250044