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
17090000029442L17/questions_ecrites1717090000029430170900000294304JO_QUESTION2025-11-1820250046
17090000029574L17/questions_ecrites1717090000029566170900000295661JO_QUESTION2025-06-0320250022
17090000029619L17/questions_ecrites1717090000029615170900000296151JO_QUESTION2026-09-2920260039
17090000029638L17/questions_ecrites1717090000029635170900000296351JO_QUESTION2026-09-2920260039
17090000029657L17/questions_ecrites1717090000029652170900000296521JO_QUESTION2025-03-1820250011
17090000029670L17/questions_ecrites1717090000029667170900000296671JO_QUESTION2026-09-2920260039
17090000029827L17/questions_ecrites1717090000029824170900000298241JO_QUESTION2026-09-2920260039
17090000029844L17/questions_ecrites1717090000029841170900000298411JO_QUESTION2026-09-2920260039
17090000029860L17/questions_ecrites1717090000029855170900000298551JO_QUESTION2025-01-2820250004
17090000029905L17/questions_ecrites1717090000029900170900000299001JO_QUESTION2025-06-0320250022
17090000030317L17/questions_ecrites1717090000030312170900000303121JO_QUESTION2025-02-1120250006
17090000030437L17/questions_ecrites1717090000030430170900000304301JO_QUESTION2025-02-2520250008
17090000030762L17/questions_ecrites1717090000030757170900000307571JO_QUESTION2025-06-0320250022
17090000030875L17/questions_ecrites1717090000030870170900000308701JO_QUESTION2025-06-1020250023
17090000031570L17/questions_ecrites1717090000031564170900000315641JO_QUESTION2025-05-2020250020
17090000032334L17/questions_ecrites1717090000032329170900000323291JO_QUESTION2025-02-2520250008
17090000032541L17/questions_ecrites1717090000032533170900000325331JO_QUESTION2025-10-2820250043
17090000032664L17/questions_ecrites1717090000032658170900000326581JO_QUESTION2025-03-2520250012
17090000032665L17/questions_ecrites1717090000032658170900000326582JO_QUESTION2025-07-0820250027
17090000032666L17/questions_ecrites1717090000032658170900000326583JO_QUESTION2025-10-2120250042
17090000032667L17/questions_ecrites1717090000032658170900000326584JO_QUESTION2026-01-2720260004
17090000032668L17/questions_ecrites1717090000032658170900000326585JO_QUESTION2026-05-1220260019
17090000032669L17/questions_ecrites1717090000032658170900000326586JO_QUESTION2026-09-1520260037
17090000032762L17/questions_ecrites1717090000032757170900000327571JO_QUESTION2025-02-2520250008
17090000033162L17/questions_ecrites1717090000033156170900000331561JO_QUESTION2025-06-1020250023
17090000033235L17/questions_ecrites1717090000033230170900000332301JO_QUESTION2025-02-1120250006
17090000033319L17/questions_ecrites1717090000033312170900000333121JO_QUESTION2025-03-2520250012
17090000033320L17/questions_ecrites1717090000033312170900000333122JO_QUESTION2025-07-0820250027
17090000033321L17/questions_ecrites1717090000033312170900000333123JO_QUESTION2025-10-2120250042
17090000033322L17/questions_ecrites1717090000033312170900000333124JO_QUESTION2026-01-2720260004
17090000033995L17/questions_ecrites1717090000033987170900000339871JO_QUESTION2025-12-0220250048
17090000033996L17/questions_ecrites1717090000033987170900000339872JO_QUESTION2026-05-1220260019
17090000034076L17/questions_ecrites1717090000034070170900000340701JO_QUESTION2025-02-1120250006
17090000034114L17/questions_ecrites1717090000034109170900000341091JO_QUESTION2025-02-2520250008
17090000034238L17/questions_ecrites1717090000034233170900000342331JO_QUESTION2025-03-2520250012
17090000034688L17/questions_ecrites1717090000034682170900000346821JO_QUESTION2026-05-2620260021
17090000034891L17/questions_ecrites1717090000034886170900000348861JO_QUESTION2025-02-2520250008
17090000035009L17/questions_ecrites1717090000035004170900000350041JO_QUESTION2025-03-1820250011
17090000035200L17/questions_ecrites1717090000035195170900000351951JO_QUESTION2025-04-0120250013
17090000035523L17/questions_ecrites1717090000035517170900000355171JO_QUESTION2025-02-0420250005
17090000035795L17/questions_ecrites1717090000035790170900000357901JO_QUESTION2025-02-2520250008
17090000035915L17/questions_ecrites1717090000035910170900000359101JO_QUESTION2025-01-2120250003
17090000036032L17/questions_ecrites1717090000036027170900000360271JO_QUESTION2025-02-1120250006
17090000036033L17/questions_ecrites1717090000036027170900000360272JO_QUESTION2025-05-2720250021
17090000036302L17/questions_ecrites1717090000036295170900000362951JO_QUESTION2025-03-2520250012
17090000036606L17/questions_ecrites1717090000036601170900000366011JO_QUESTION2025-04-0820250014
17090000037096L17/questions_ecrites1717090000037091170900000370911JO_QUESTION2025-02-1820250007
17090000037286L17/questions_ecrites1717090000037280170900000372801JO_QUESTION2025-02-1820250007
17090000037287L17/questions_ecrites1717090000037280170900000372802JO_QUESTION2025-05-2720250021
17090000037288L17/questions_ecrites1717090000037280170900000372803JO_QUESTION2025-09-0920250036