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
17090000059436L17/questions_ecrites1717090000059426170900000594263JO_QUESTION2025-08-1220250032
17090000059437L17/questions_ecrites1717090000059426170900000594264JO_QUESTION2025-11-1820250046
17090000059533L17/questions_ecrites1717090000059527170900000595271JO_QUESTION2025-06-2420250025
17090000059534L17/questions_ecrites1717090000059527170900000595272JO_QUESTION2025-09-3020250039
17090000059541L17/questions_ecrites1717090000059535170900000595351JO_QUESTION2025-09-3020250039
17090000059542L17/questions_ecrites1717090000059535170900000595352JO_QUESTION2026-02-1020260006
17090000059640L17/questions_ecrites1717090000059631170900000596311JO_QUESTION2025-06-2420250025
17090000059641L17/questions_ecrites1717090000059631170900000596312JO_QUESTION2025-10-2120250042
17090000059642L17/questions_ecrites1717090000059631170900000596313JO_QUESTION2026-01-2720260004
17090000059643L17/questions_ecrites1717090000059631170900000596314JO_QUESTION2026-05-0520260018
17090000059644L17/questions_ecrites1717090000059631170900000596315JO_QUESTION2026-08-1120260032
17090000059673L17/questions_ecrites1717090000059669170900000596691JO_QUESTION2025-06-2420250025
17090000059691L17/questions_ecrites1717090000059686170900000596861JO_QUESTION2025-06-2420250025
17090000059768L17/questions_ecrites1717090000059762170900000597621JO_QUESTION2025-07-0120250026
17090000059769L17/questions_ecrites1717090000059762170900000597622JO_QUESTION2025-10-2120250042
17090000059775L17/questions_ecrites1717090000059770170900000597701JO_QUESTION2025-01-1420250002
17090000059787L17/questions_ecrites1717090000059780170900000597801JO_QUESTION2026-02-1020260006
17090000059795L17/questions_ecrites1717090000059788170900000597881JO_QUESTION2025-11-0420250044
17090000059859L17/questions_ecrites1717090000059853170900000598531JO_QUESTION2025-12-1620250050
17090000059876L17/questions_ecrites1717090000059871170900000598711JO_QUESTION2025-07-1520250028
17090000059877L17/questions_ecrites1717090000059871170900000598712JO_QUESTION2025-10-2820250043
17090000059878L17/questions_ecrites1717090000059871170900000598713JO_QUESTION2026-02-1020260006
17090000059879L17/questions_ecrites1717090000059871170900000598714JO_QUESTION2026-05-1220260019
17090000059880L17/questions_ecrites1717090000059871170900000598715JO_QUESTION2026-08-2520260034
17090000059886L17/questions_ecrites1717090000059881170900000598811JO_QUESTION2025-08-0520250031
17090000059887L17/questions_ecrites1717090000059881170900000598812JO_QUESTION2025-11-1120250045
17090000059892L17/questions_ecrites1717090000059888170900000598881JO_QUESTION2025-07-0120250026
17090000059967L17/questions_ecrites1717090000059962170900000599621JO_QUESTION2025-07-2920250030
17090000059997L17/questions_ecrites1717090000059990170900000599901JO_QUESTION2025-11-1120250045
17090000060002L17/questions_ecrites1717090000059998170900000599981JO_QUESTION2025-07-0120250026
17090000060035L17/questions_ecrites1717090000060027170900000600271JO_QUESTION2025-10-2120250042
17090000060036L17/questions_ecrites1717090000060027170900000600272JO_QUESTION2026-09-1520260037
17090000060067L17/questions_ecrites1717090000060061170900000600611JO_QUESTION2025-07-0820250027
17090000060068L17/questions_ecrites1717090000060061170900000600612JO_QUESTION2025-10-2120250042
17090000060069L17/questions_ecrites1717090000060061170900000600613JO_QUESTION2026-01-2720260004
17090000060070L17/questions_ecrites1717090000060061170900000600614JO_QUESTION2026-05-1220260019
17090000060071L17/questions_ecrites1717090000060061170900000600615JO_QUESTION2026-09-2220260038
17090000060091L17/questions_ecrites1717090000060085170900000600851JO_QUESTION2025-07-1520250028
17090000060092L17/questions_ecrites1717090000060085170900000600852JO_QUESTION2025-10-2820250043
17090000060124L17/questions_ecrites1717090000060118170900000601181JO_QUESTION2025-07-0820250027
17090000060125L17/questions_ecrites1717090000060118170900000601182JO_QUESTION2025-10-2120250042
17090000060126L17/questions_ecrites1717090000060118170900000601183JO_QUESTION2026-01-2720260004
17090000060152L17/questions_ecrites1717090000060146170900000601461JO_QUESTION2025-01-2120250003
17090000060248L17/questions_ecrites1717090000060242170900000602421JO_QUESTION2025-07-0120250026
17090000060249L17/questions_ecrites1717090000060242170900000602422JO_QUESTION2025-10-2120250042
17090000060272L17/questions_ecrites1717090000060264170900000602641JO_QUESTION2025-01-1420250002
17090000060273L17/questions_ecrites1717090000060264170900000602642JO_QUESTION2025-04-1520250015
17090000060274L17/questions_ecrites1717090000060264170900000602643JO_QUESTION2025-07-2220250029
17090000060275L17/questions_ecrites1717090000060264170900000602644JO_QUESTION2025-10-2820250043
17090000060276L17/questions_ecrites1717090000060264170900000602645JO_QUESTION2026-02-0320260005