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
17090000020313L17/questions_ecrites1717090000020306170900000203061JO_QUESTION2026-07-1420260028
17090000020329L17/questions_ecrites1717090000020326170900000203261JO_QUESTION2026-07-2820260030
17090000020365L17/questions_ecrites1717090000020362170900000203621JO_QUESTION2026-09-1520260037
17090000020500L17/questions_ecrites1717090000020496170900000204961JO_QUESTION2026-08-1120260032
17090000020539L17/questions_ecrites1717090000020534170900000205341JO_QUESTION2025-02-0420250005
17090000020583L17/questions_ecrites1717090000020577170900000205771JO_QUESTION2025-01-2820250004
17090000020589L17/questions_ecrites1717090000020584170900000205841JO_QUESTION2025-07-0820250027
17090000020611L17/questions_ecrites1717090000020606170900000206061JO_QUESTION2026-08-0420260031
17090000020638L17/questions_ecrites1717090000020632170900000206321JO_QUESTION2025-02-0420250005
17090000020660L17/questions_ecrites1717090000020657170900000206571JO_QUESTION2026-07-2120260029
17090000020674L17/questions_ecrites1717090000020671170900000206711JO_QUESTION2026-07-2120260029
17090000020721L17/questions_ecrites1717090000020718170900000207181JO_QUESTION2026-09-1520260037
17090000020740L17/questions_ecrites1717090000020737170900000207371JO_QUESTION2026-07-2120260029
17090000020757L17/questions_ecrites1717090000020753170900000207531JO_QUESTION2026-08-1820260033
17090000020788L17/questions_ecrites1717090000020784170900000207841JO_QUESTION2026-09-0120260035
17090000020899L17/questions_ecrites1717090000020895170900000208951JO_QUESTION2026-07-2820260030
17090000020951L17/questions_ecrites1717090000020946170900000209461JO_QUESTION2026-07-2120260029
17090000020985L17/questions_ecrites1717090000020982170900000209821JO_QUESTION2026-07-2120260029
17090000021014L17/questions_ecrites1717090000021010170900000210101JO_QUESTION2026-07-2120260029
17090000021146L17/questions_ecrites1717090000021141170900000211411JO_QUESTION2025-02-1120250006
17090000021147L17/questions_ecrites1717090000021141170900000211412JO_QUESTION2025-05-2720250021
17090000021152L17/questions_ecrites1717090000021148170900000211481JO_QUESTION2026-07-2820260030
17090000021223L17/questions_ecrites1717090000021220170900000212201JO_QUESTION2026-07-2120260029
17090000021239L17/questions_ecrites1717090000021235170900000212351JO_QUESTION2026-08-1120260032
17090000021253L17/questions_ecrites1717090000021250170900000212501JO_QUESTION2026-08-0420260031
17090000021257L17/questions_ecrites1717090000021254170900000212541JO_QUESTION2026-08-0420260031
17090000021275L17/questions_ecrites1717090000021270170900000212701JO_QUESTION2025-02-0420250005
17090000021279L17/questions_ecrites1717090000021276170900000212761JO_QUESTION2026-07-2820260030
17090000021293L17/questions_ecrites1717090000021290170900000212901JO_QUESTION2026-07-2120260029
17090000021406L17/questions_ecrites1717090000021400170900000214001JO_QUESTION2026-09-2220260038
17090000021447L17/questions_ecrites1717090000021444170900000214441JO_QUESTION2026-07-2820260030
17090000021466L17/questions_ecrites1717090000021463170900000214631JO_QUESTION2026-07-2820260030
17090000021487L17/questions_ecrites1717090000021482170900000214821JO_QUESTION2025-02-1120250006
17090000021507L17/questions_ecrites1717090000021504170900000215041JO_QUESTION2026-09-1520260037
17090000021514L17/questions_ecrites1717090000021511170900000215111JO_QUESTION2026-07-2820260030
17090000021521L17/questions_ecrites1717090000021518170900000215181JO_QUESTION2026-07-2820260030
17090000021530L17/questions_ecrites1717090000021525170900000215251JO_QUESTION2025-02-0420250005
17090000021534L17/questions_ecrites1717090000021531170900000215311JO_QUESTION2026-08-0420260031
17090000021554L17/questions_ecrites1717090000021551170900000215511JO_QUESTION2026-07-2820260030
17090000021558L17/questions_ecrites1717090000021555170900000215551JO_QUESTION2026-08-1120260032
17090000021567L17/questions_ecrites1717090000021564170900000215641JO_QUESTION2026-07-2820260030
17090000021591L17/questions_ecrites1717090000021588170900000215881JO_QUESTION2026-07-2820260030
17090000021595L17/questions_ecrites1717090000021592170900000215921JO_QUESTION2026-07-2820260030
17090000021636L17/questions_ecrites1717090000021632170900000216321JO_QUESTION2026-09-2220260038
17090000021658L17/questions_ecrites1717090000021655170900000216551JO_QUESTION2026-09-1520260037
17090000021676L17/questions_ecrites1717090000021671170900000216711JO_QUESTION2025-02-0420250005
17090000021677L17/questions_ecrites1717090000021671170900000216712JO_QUESTION2025-05-2020250020
17090000021756L17/questions_ecrites1717090000021752170900000217521JO_QUESTION2026-09-0120260035
17090000021764L17/questions_ecrites1717090000021761170900000217611JO_QUESTION2026-07-2820260030
17090000021896L17/questions_ecrites1717090000021893170900000218931JO_QUESTION2026-07-2820260030