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
17090000071628L17/questions_ecrites1717090000071622170900000716221JO_QUESTION2025-01-2120250003
17090000071644L17/questions_ecrites1717090000071637170900000716371JO_QUESTION2025-11-1120250045
17090000071645L17/questions_ecrites1717090000071637170900000716372JO_QUESTION2026-05-1220260019
17090000071669L17/questions_ecrites1717090000071663170900000716631JO_QUESTION2025-09-0920250036
17090000071670L17/questions_ecrites1717090000071663170900000716632JO_QUESTION2025-12-1620250050
17090000071803L17/questions_ecrites1717090000071794170900000717941JO_QUESTION2026-05-0520260018
17090000071917L17/questions_ecrites1717090000071912170900000719121JO_QUESTION2025-09-0920250036
17090000072144L17/questions_ecrites1717090000072137170900000721371JO_QUESTION2025-12-0220250048
17090000072192L17/questions_ecrites1717090000072185170900000721851JO_QUESTION2025-11-0420250044
17090000072212L17/questions_ecrites1717090000072207170900000722071JO_QUESTION2025-02-1120250006
17090000072263L17/questions_ecrites1717090000072258170900000722581JO_QUESTION2026-02-1020260006
17090000072294L17/questions_ecrites1717090000072288170900000722881JO_QUESTION2025-10-2120250042
17090000072318L17/questions_ecrites1717090000072311170900000723111JO_QUESTION2025-10-2120250042
17090000072319L17/questions_ecrites1717090000072311170900000723112JO_QUESTION2026-01-2720260004
17090000072320L17/questions_ecrites1717090000072311170900000723113JO_QUESTION2026-05-0520260018
17090000072343L17/questions_ecrites1717090000072336170900000723361JO_QUESTION2025-10-2120250042
17090000072383L17/questions_ecrites1717090000072377170900000723771JO_QUESTION2025-10-2120250042
17090000072465L17/questions_ecrites1717090000072460170900000724601JO_QUESTION2025-09-2320250038
17090000072466L17/questions_ecrites1717090000072460170900000724602JO_QUESTION2026-05-0520260018
17090000072467L17/questions_ecrites1717090000072460170900000724603JO_QUESTION2026-09-0820260036
17090000072541L17/questions_ecrites1717090000072534170900000725341JO_QUESTION2025-10-2120250042
17090000072542L17/questions_ecrites1717090000072534170900000725342JO_QUESTION2026-01-2720260004
17090000072543L17/questions_ecrites1717090000072534170900000725343JO_QUESTION2026-05-0520260018
17090000072549L17/questions_ecrites1717090000072544170900000725441JO_QUESTION2025-03-2520250012
17090000072635L17/questions_ecrites1717090000072627170900000726271JO_QUESTION2025-10-2120250042
17090000072636L17/questions_ecrites1717090000072627170900000726272JO_QUESTION2026-04-2120260016
17090000072684L17/questions_ecrites1717090000072679170900000726791JO_QUESTION2025-01-2120250003
17090000072774L17/questions_ecrites1717090000072767170900000727671JO_QUESTION2025-10-2120250042
17090000072775L17/questions_ecrites1717090000072767170900000727672JO_QUESTION2026-01-2720260004
17090000072803L17/questions_ecrites1717090000072797170900000727971JO_QUESTION2025-01-2120250003
17090000072943L17/questions_ecrites1717090000072936170900000729361JO_QUESTION2025-10-2120250042
17090000072980L17/questions_ecrites1717090000072975170900000729751JO_QUESTION2025-10-2820250043
17090000073014L17/questions_ecrites1717090000073008170900000730081JO_QUESTION2025-12-0220250048
17090000073015L17/questions_ecrites1717090000073008170900000730082JO_QUESTION2026-04-2120260016
17090000073124L17/questions_ecrites1717090000073118170900000731181JO_QUESTION2025-09-1620250037
17090000073125L17/questions_ecrites1717090000073118170900000731182JO_QUESTION2025-12-2320250051
17090000073126L17/questions_ecrites1717090000073118170900000731183JO_QUESTION2026-03-3120260013
17090000073127L17/questions_ecrites1717090000073118170900000731184JO_QUESTION2026-07-0720260027
17090000073178L17/questions_ecrites1717090000073172170900000731721JO_QUESTION2025-09-3020250039
17090000073235L17/questions_ecrites1717090000073228170900000732281JO_QUESTION2026-05-2620260021
17090000073268L17/questions_ecrites1717090000073262170900000732621JO_QUESTION2025-09-1620250037
17090000073311L17/questions_ecrites1717090000073306170900000733061JO_QUESTION2026-01-1320260002
17090000073384L17/questions_ecrites1717090000073378170900000733781JO_QUESTION2025-10-2120250042
17090000073385L17/questions_ecrites1717090000073378170900000733782JO_QUESTION2026-09-1520260037
17090000073432L17/questions_ecrites1717090000073426170900000734261JO_QUESTION2025-09-2320250038
17090000073433L17/questions_ecrites1717090000073426170900000734262JO_QUESTION2026-05-1920260020
17090000073446L17/questions_ecrites1717090000073439170900000734391JO_QUESTION2025-09-2320250038
17090000073499L17/questions_ecrites1717090000073494170900000734941JO_QUESTION2025-02-2520250008
17090000073521L17/questions_ecrites1717090000073515170900000735151JO_QUESTION2025-09-2320250038
17090000073522L17/questions_ecrites1717090000073515170900000735152JO_QUESTION2026-01-1320260002