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
17090000015805L17/questions_ecrites1717090000015801170900000158012JO_QUESTION2026-09-0820260036
17090000015834L17/questions_ecrites1717090000015828170900000158281JO_QUESTION2025-01-2820250004
17090000015835L17/questions_ecrites1717090000015828170900000158282JO_QUESTION2025-05-0620250018
17090000015836L17/questions_ecrites1717090000015828170900000158283JO_QUESTION2025-12-1620250050
17090000015837L17/questions_ecrites1717090000015828170900000158284JO_QUESTION2026-03-3120260013
17090000015838L17/questions_ecrites1717090000015828170900000158285JO_QUESTION2026-07-1420260028
17090000015878L17/questions_ecrites1717090000015873170900000158731JO_QUESTION2026-06-0920260023
17090000015886L17/questions_ecrites1717090000015879170900000158791JO_QUESTION2025-04-0820250014
17090000015896L17/questions_ecrites1717090000015891170900000158911JO_QUESTION2026-06-0920260023
17090000015954L17/questions_ecrites1717090000015949170900000159491JO_QUESTION2026-06-2320260025
17090000015975L17/questions_ecrites1717090000015969170900000159691JO_QUESTION2026-06-0220260022
17090000015997L17/questions_ecrites1717090000015994170900000159941JO_QUESTION2026-09-1520260037
17090000016002L17/questions_ecrites1717090000015998170900000159981JO_QUESTION2026-06-0220260022
17090000016003L17/questions_ecrites1717090000015998170900000159982JO_QUESTION2026-09-0820260036
17090000016036L17/questions_ecrites1717090000016031170900000160311JO_QUESTION2025-02-1120250006
17090000016050L17/questions_ecrites1717090000016047170900000160471JO_QUESTION2026-06-0220260022
17090000016051L17/questions_ecrites1717090000016047170900000160472JO_QUESTION2026-09-0820260036
17090000016064L17/questions_ecrites1717090000016061170900000160611JO_QUESTION2026-06-0220260022
17090000016065L17/questions_ecrites1717090000016061170900000160612JO_QUESTION2026-09-2920260039
17090000016085L17/questions_ecrites1717090000016081170900000160811JO_QUESTION2025-02-0420250005
17090000016103L17/questions_ecrites1717090000016099170900000160991JO_QUESTION2026-06-1620260024
17090000016118L17/questions_ecrites1717090000016114170900000161141JO_QUESTION2026-06-0220260022
17090000016119L17/questions_ecrites1717090000016114170900000161142JO_QUESTION2026-09-0820260036
17090000016148L17/questions_ecrites1717090000016144170900000161441JO_QUESTION2026-07-2120260029
17090000016226L17/questions_ecrites1717090000016218170900000162181JO_QUESTION2025-03-1120250010
17090000016227L17/questions_ecrites1717090000016218170900000162182JO_QUESTION2025-11-1120250045
17090000016253L17/questions_ecrites1717090000016250170900000162501JO_QUESTION2026-07-2120260029
17090000016257L17/questions_ecrites1717090000016254170900000162541JO_QUESTION2026-07-2120260029
17090000016286L17/questions_ecrites1717090000016283170900000162831JO_QUESTION2026-07-2120260029
17090000016290L17/questions_ecrites1717090000016287170900000162871JO_QUESTION2026-09-1520260037
17090000016306L17/questions_ecrites1717090000016302170900000163021JO_QUESTION2026-07-1420260028
17090000016468L17/questions_ecrites1717090000016465170900000164651JO_QUESTION2026-06-2320260025
17090000016478L17/questions_ecrites1717090000016475170900000164751JO_QUESTION2026-09-1520260037
17090000016499L17/questions_ecrites1717090000016493170900000164931JO_QUESTION2025-02-1120250006
17090000016510L17/questions_ecrites1717090000016505170900000165051JO_QUESTION2026-07-2120260029
17090000016576L17/questions_ecrites1717090000016573170900000165731JO_QUESTION2026-06-1620260024
17090000016604L17/questions_ecrites1717090000016601170900000166011JO_QUESTION2026-08-0420260031
17090000016621L17/questions_ecrites1717090000016618170900000166181JO_QUESTION2026-07-2120260029
17090000016635L17/questions_ecrites1717090000016629170900000166291JO_QUESTION2025-04-0820250014
17090000016661L17/questions_ecrites1717090000016657170900000166571JO_QUESTION2026-08-1820260033
17090000016726L17/questions_ecrites1717090000016718170900000167181JO_QUESTION2025-01-2820250004
17090000016727L17/questions_ecrites1717090000016718170900000167182JO_QUESTION2025-05-0620250018
17090000016728L17/questions_ecrites1717090000016718170900000167183JO_QUESTION2025-12-1620250050
17090000016772L17/questions_ecrites1717090000016766170900000167661JO_QUESTION2025-01-2820250004
17090000016773L17/questions_ecrites1717090000016766170900000167662JO_QUESTION2025-05-0620250018
17090000016780L17/questions_ecrites1717090000016777170900000167771JO_QUESTION2026-06-0920260023
17090000016781L17/questions_ecrites1717090000016777170900000167772JO_QUESTION2026-09-2220260038
17090000016798L17/questions_ecrites1717090000016794170900000167941JO_QUESTION2026-06-0920260023
17090000016799L17/questions_ecrites1717090000016794170900000167942JO_QUESTION2026-09-1520260037
17090000016804L17/questions_ecrites1717090000016800170900000168001JO_QUESTION2026-06-1620260024