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
17090000065402L17/questions_ecrites1717090000065394170900000653941JO_QUESTION2025-09-0920250036
17090000065597L17/questions_ecrites1717090000065590170900000655901JO_QUESTION2025-10-2820250043
17090000065603L17/questions_ecrites1717090000065598170900000655981JO_QUESTION2025-01-2120250003
17090000065604L17/questions_ecrites1717090000065598170900000655982JO_QUESTION2025-04-2920250017
17090000065625L17/questions_ecrites1717090000065620170900000656201JO_QUESTION2025-12-0220250048
17090000065736L17/questions_ecrites1717090000065728170900000657281JO_QUESTION2025-09-1620250037
17090000065737L17/questions_ecrites1717090000065728170900000657282JO_QUESTION2026-01-2020260003
17090000065769L17/questions_ecrites1717090000065764170900000657641JO_QUESTION2025-02-2520250008
17090000065822L17/questions_ecrites1717090000065814170900000658141JO_QUESTION2025-12-0220250048
17090000065851L17/questions_ecrites1717090000065846170900000658461JO_QUESTION2025-12-0220250048
17090000065857L17/questions_ecrites1717090000065852170900000658521JO_QUESTION2025-12-0220250048
17090000065892L17/questions_ecrites1717090000065887170900000658871JO_QUESTION2025-01-2820250004
17090000065940L17/questions_ecrites1717090000065934170900000659341JO_QUESTION2025-12-1620250050
17090000065947L17/questions_ecrites1717090000065941170900000659411JO_QUESTION2025-12-0220250048
17090000065973L17/questions_ecrites1717090000065967170900000659671JO_QUESTION2026-03-0320260009
17090000066050L17/questions_ecrites1717090000066045170900000660451JO_QUESTION2025-12-0220250048
17090000066101L17/questions_ecrites1717090000066094170900000660941JO_QUESTION2026-05-2620260021
17090000066134L17/questions_ecrites1717090000066125170900000661251JO_QUESTION2025-09-0920250036
17090000066309L17/questions_ecrites1717090000066304170900000663041JO_QUESTION2025-02-1120250006
17090000066315L17/questions_ecrites1717090000066310170900000663101JO_QUESTION2025-10-2120250042
17090000066316L17/questions_ecrites1717090000066310170900000663102JO_QUESTION2026-09-1520260037
17090000066329L17/questions_ecrites1717090000066323170900000663231JO_QUESTION2025-12-0220250048
17090000066336L17/questions_ecrites1717090000066330170900000663301JO_QUESTION2025-10-2820250043
17090000066337L17/questions_ecrites1717090000066330170900000663302JO_QUESTION2026-02-1720260007
17090000066365L17/questions_ecrites1717090000066360170900000663601JO_QUESTION2026-08-0420260031
17090000066374L17/questions_ecrites1717090000066366170900000663661JO_QUESTION2025-09-0920250036
17090000066375L17/questions_ecrites1717090000066366170900000663662JO_QUESTION2025-12-1620250050
17090000066393L17/questions_ecrites1717090000066387170900000663871JO_QUESTION2025-09-2320250038
17090000066450L17/questions_ecrites1717090000066442170900000664421JO_QUESTION2025-03-1820250011
17090000066522L17/questions_ecrites1717090000066516170900000665161JO_QUESTION2025-09-2320250038
17090000066686L17/questions_ecrites1717090000066681170900000666811JO_QUESTION2025-11-0420250044
17090000066687L17/questions_ecrites1717090000066681170900000666812JO_QUESTION2026-04-2120260016
17090000066688L17/questions_ecrites1717090000066681170900000666813JO_QUESTION2026-08-0420260031
17090000066710L17/questions_ecrites1717090000066706170900000667061JO_QUESTION2025-08-1920250033
17090000066766L17/questions_ecrites1717090000066759170900000667591JO_QUESTION2025-09-0220250035
17090000066767L17/questions_ecrites1717090000066759170900000667592JO_QUESTION2025-12-1620250050
17090000066768L17/questions_ecrites1717090000066759170900000667593JO_QUESTION2026-03-2420260012
17090000066835L17/questions_ecrites1717090000066828170900000668281JO_QUESTION2025-12-0220250048
17090000066836L17/questions_ecrites1717090000066828170900000668282JO_QUESTION2026-05-1220260019
17090000066921L17/questions_ecrites1717090000066914170900000669141JO_QUESTION2025-10-2120250042
17090000066995L17/questions_ecrites1717090000066989170900000669891JO_QUESTION2026-06-0920260023
17090000067011L17/questions_ecrites1717090000067005170900000670051JO_QUESTION2025-03-2520250012
17090000067063L17/questions_ecrites1717090000067056170900000670561JO_QUESTION2025-11-1120250045
17090000067103L17/questions_ecrites1717090000067097170900000670971JO_QUESTION2025-12-0220250048
17090000067104L17/questions_ecrites1717090000067097170900000670972JO_QUESTION2026-05-1220260019
17090000067121L17/questions_ecrites1717090000067115170900000671151JO_QUESTION2025-11-1120250045
17090000067122L17/questions_ecrites1717090000067115170900000671152JO_QUESTION2026-02-2420260008
17090000067123L17/questions_ecrites1717090000067115170900000671153JO_QUESTION2026-08-1120260032
17090000067130L17/questions_ecrites1717090000067124170900000671241JO_QUESTION2025-08-1220250032
17090000067131L17/questions_ecrites1717090000067124170900000671242JO_QUESTION2025-11-1820250046