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
17090000081258L17/questions_ecrites1717090000081250170900000812502JO_QUESTION2026-05-1220260019
17090000081296L17/questions_ecrites1717090000081291170900000812911JO_QUESTION2025-10-2120250042
17090000081297L17/questions_ecrites1717090000081291170900000812912JO_QUESTION2026-01-2720260004
17090000081298L17/questions_ecrites1717090000081291170900000812913JO_QUESTION2026-05-1220260019
17090000081299L17/questions_ecrites1717090000081291170900000812914JO_QUESTION2026-08-1820260033
17090000081362L17/questions_ecrites1717090000081356170900000813561JO_QUESTION2026-04-1420260015
17090000081375L17/questions_ecrites1717090000081369170900000813691JO_QUESTION2025-10-2120250042
17090000081376L17/questions_ecrites1717090000081369170900000813692JO_QUESTION2026-01-2720260004
17090000081407L17/questions_ecrites1717090000081402170900000814021JO_QUESTION2025-02-1820250007
17090000081479L17/questions_ecrites1717090000081474170900000814741JO_QUESTION2025-02-1120250006
17090000081504L17/questions_ecrites1717090000081498170900000814981JO_QUESTION2025-11-1120250045
17090000081570L17/questions_ecrites1717090000081565170900000815651JO_QUESTION2025-10-2820250043
17090000081597L17/questions_ecrites1717090000081591170900000815911JO_QUESTION2025-11-2520250047
17090000081639L17/questions_ecrites1717090000081633170900000816331JO_QUESTION2025-11-2520250047
17090000081640L17/questions_ecrites1717090000081633170900000816332JO_QUESTION2026-07-1420260028
17090000081774L17/questions_ecrites1717090000081768170900000817681JO_QUESTION2025-11-1820250046
17090000081870L17/questions_ecrites1717090000081864170900000818641JO_QUESTION2025-11-0420250044
17090000081871L17/questions_ecrites1717090000081864170900000818642JO_QUESTION2026-02-2420260008
17090000081872L17/questions_ecrites1717090000081864170900000818643JO_QUESTION2026-06-0220260022
17090000081911L17/questions_ecrites1717090000081905170900000819051JO_QUESTION2025-11-2520250047
17090000081912L17/questions_ecrites1717090000081905170900000819052JO_QUESTION2026-07-1420260028
17090000081945L17/questions_ecrites1717090000081937170900000819371JO_QUESTION2025-12-2320250051
17090000081966L17/questions_ecrites1717090000081959170900000819591JO_QUESTION2025-10-2820250043
17090000081967L17/questions_ecrites1717090000081959170900000819592JO_QUESTION2026-02-0320260005
17090000081968L17/questions_ecrites1717090000081959170900000819593JO_QUESTION2026-05-1220260019
17090000082002L17/questions_ecrites1717090000081996170900000819961JO_QUESTION2025-11-0420250044
17090000082174L17/questions_ecrites1717090000082168170900000821681JO_QUESTION2025-10-2820250043
17090000082180L17/questions_ecrites1717090000082175170900000821751JO_QUESTION2025-11-2520250047
17090000082181L17/questions_ecrites1717090000082175170900000821752JO_QUESTION2026-07-1420260028
17090000082188L17/questions_ecrites1717090000082182170900000821821JO_QUESTION2026-03-0320260009
17090000082288L17/questions_ecrites1717090000082281170900000822811JO_QUESTION2025-02-0420250005
17090000082300L17/questions_ecrites1717090000082294170900000822941JO_QUESTION2025-10-2820250043
17090000082301L17/questions_ecrites1717090000082294170900000822942JO_QUESTION2026-02-0320260005
17090000082393L17/questions_ecrites1717090000082388170900000823881JO_QUESTION2025-11-0420250044
17090000082394L17/questions_ecrites1717090000082388170900000823882JO_QUESTION2026-02-1720260007
17090000082395L17/questions_ecrites1717090000082388170900000823883JO_QUESTION2026-06-1620260024
17090000082417L17/questions_ecrites1717090000082410170900000824101JO_QUESTION2025-12-2320250051
17090000082459L17/questions_ecrites1717090000082451170900000824511JO_QUESTION2025-12-0220250048
17090000082460L17/questions_ecrites1717090000082451170900000824512JO_QUESTION2026-05-1220260019
17090000082601L17/questions_ecrites1717090000082596170900000825961JO_QUESTION2025-11-0420250044
17090000082602L17/questions_ecrites1717090000082596170900000825962JO_QUESTION2026-02-2420260008
17090000082603L17/questions_ecrites1717090000082596170900000825963JO_QUESTION2026-06-0220260022
17090000082604L17/questions_ecrites1717090000082596170900000825964JO_QUESTION2026-09-0820260036
17090000082628L17/questions_ecrites1717090000082622170900000826221JO_QUESTION2025-01-2120250003
17090000082629L17/questions_ecrites1717090000082622170900000826222JO_QUESTION2025-04-2920250017
17090000082630L17/questions_ecrites1717090000082622170900000826223JO_QUESTION2025-10-2820250043
17090000082631L17/questions_ecrites1717090000082622170900000826224JO_QUESTION2026-02-1720260007
17090000082632L17/questions_ecrites1717090000082622170900000826225JO_QUESTION2026-07-2820260030
17090000082695L17/questions_ecrites1717090000082690170900000826901JO_QUESTION2025-04-1520250015
17090000082745L17/questions_ecrites1717090000082738170900000827381JO_QUESTION2025-10-2820250043