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
17090000083794L17/questions_ecrites1717090000083788170900000837882JO_QUESTION2026-02-1020260006
17090000083795L17/questions_ecrites1717090000083788170900000837883JO_QUESTION2026-05-1920260020
17090000083796L17/questions_ecrites1717090000083788170900000837884JO_QUESTION2026-09-0120260035
17090000083856L17/questions_ecrites1717090000083851170900000838511JO_QUESTION2025-11-0420250044
17090000083857L17/questions_ecrites1717090000083851170900000838512JO_QUESTION2026-02-1720260007
17090000083858L17/questions_ecrites1717090000083851170900000838513JO_QUESTION2026-06-1620260024
17090000083879L17/questions_ecrites1717090000083874170900000838741JO_QUESTION2025-11-1120250045
17090000083880L17/questions_ecrites1717090000083874170900000838742JO_QUESTION2026-02-2420260008
17090000083881L17/questions_ecrites1717090000083874170900000838743JO_QUESTION2026-08-1120260032
17090000083918L17/questions_ecrites1717090000083910170900000839101JO_QUESTION2026-07-2120260029
17090000084029L17/questions_ecrites1717090000084023170900000840231JO_QUESTION2025-11-1120250045
17090000084030L17/questions_ecrites1717090000084023170900000840232JO_QUESTION2026-02-1720260007
17090000084173L17/questions_ecrites1717090000084165170900000841651JO_QUESTION2026-05-0520260018
17090000084210L17/questions_ecrites1717090000084202170900000842021JO_QUESTION2025-11-1120250045
17090000084228L17/questions_ecrites1717090000084221170900000842211JO_QUESTION2025-03-1120250010
17090000084251L17/questions_ecrites1717090000084245170900000842451JO_QUESTION2025-11-0420250044
17090000084269L17/questions_ecrites1717090000084263170900000842631JO_QUESTION2026-02-1020260006
17090000084270L17/questions_ecrites1717090000084263170900000842632JO_QUESTION2026-08-0420260031
17090000084282L17/questions_ecrites1717090000084277170900000842771JO_QUESTION2025-11-0420250044
17090000084283L17/questions_ecrites1717090000084277170900000842772JO_QUESTION2026-06-1620260024
17090000084302L17/questions_ecrites1717090000084296170900000842961JO_QUESTION2025-11-0420250044
17090000084303L17/questions_ecrites1717090000084296170900000842962JO_QUESTION2026-02-1720260007
17090000084304L17/questions_ecrites1717090000084296170900000842963JO_QUESTION2026-05-2620260021
17090000084305L17/questions_ecrites1717090000084296170900000842964JO_QUESTION2026-09-0120260035
17090000084321L17/questions_ecrites1717090000084314170900000843141JO_QUESTION2026-04-1420260015
17090000084340L17/questions_ecrites1717090000084333170900000843331JO_QUESTION2025-12-0220250048
17090000084341L17/questions_ecrites1717090000084333170900000843332JO_QUESTION2026-03-1020260010
17090000084349L17/questions_ecrites1717090000084342170900000843421JO_QUESTION2026-05-0520260018
17090000084361L17/questions_ecrites1717090000084356170900000843561JO_QUESTION2026-01-1320260002
17090000084382L17/questions_ecrites1717090000084376170900000843761JO_QUESTION2026-04-1420260015
17090000084389L17/questions_ecrites1717090000084383170900000843831JO_QUESTION2025-11-0420250044
17090000084390L17/questions_ecrites1717090000084383170900000843832JO_QUESTION2026-02-1020260006
17090000084464L17/questions_ecrites1717090000084455170900000844551JO_QUESTION2025-12-0220250048
17090000084510L17/questions_ecrites1717090000084502170900000845021JO_QUESTION2025-02-0420250005
17090000084546L17/questions_ecrites1717090000084540170900000845401JO_QUESTION2025-11-2520250047
17090000084547L17/questions_ecrites1717090000084540170900000845402JO_QUESTION2026-07-1420260028
17090000084569L17/questions_ecrites1717090000084563170900000845631JO_QUESTION2025-11-2520250047
17090000084625L17/questions_ecrites1717090000084619170900000846191JO_QUESTION2025-11-0420250044
17090000084626L17/questions_ecrites1717090000084619170900000846192JO_QUESTION2026-02-1020260006
17090000084642L17/questions_ecrites1717090000084637170900000846371JO_QUESTION2025-03-1120250010
17090000084656L17/questions_ecrites1717090000084649170900000846491JO_QUESTION2026-05-0520260018
17090000084657L17/questions_ecrites1717090000084649170900000846492JO_QUESTION2026-09-0820260036
17090000084747L17/questions_ecrites1717090000084739170900000847391JO_QUESTION2025-11-1120250045
17090000084755L17/questions_ecrites1717090000084748170900000847481JO_QUESTION2025-11-2520250047
17090000084855L17/questions_ecrites1717090000084849170900000848491JO_QUESTION2025-12-0220250048
17090000084862L17/questions_ecrites1717090000084856170900000848561JO_QUESTION2025-11-2520250047
17090000084863L17/questions_ecrites1717090000084856170900000848562JO_QUESTION2026-03-2420260012
17090000084864L17/questions_ecrites1717090000084856170900000848563JO_QUESTION2026-07-1420260028
17090000084891L17/questions_ecrites1717090000084884170900000848841JO_QUESTION2025-11-1120250045
17090000084899L17/questions_ecrites1717090000084892170900000848921JO_QUESTION2025-11-2520250047