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
17090000021903L17/questions_ecrites1717090000021897170900000218971JO_QUESTION2025-02-0420250005
17090000021904L17/questions_ecrites1717090000021897170900000218972JO_QUESTION2025-05-1320250019
17090000021905L17/questions_ecrites1717090000021897170900000218973JO_QUESTION2025-08-1920250033
17090000021906L17/questions_ecrites1717090000021897170900000218974JO_QUESTION2025-11-2520250047
17090000021907L17/questions_ecrites1717090000021897170900000218975JO_QUESTION2026-03-1020260010
17090000021908L17/questions_ecrites1717090000021897170900000218976JO_QUESTION2026-06-1620260024
17090000021909L17/questions_ecrites1717090000021897170900000218977JO_QUESTION2026-09-2220260038
17090000021943L17/questions_ecrites1717090000021940170900000219401JO_QUESTION2026-09-2920260039
17090000022030L17/questions_ecrites1717090000022027170900000220271JO_QUESTION2026-09-0820260036
17090000022104L17/questions_ecrites1717090000022100170900000221001JO_QUESTION2026-08-0420260031
17090000022184L17/questions_ecrites1717090000022181170900000221811JO_QUESTION2026-09-0120260035
17090000022221L17/questions_ecrites1717090000022218170900000222181JO_QUESTION2026-07-2820260030
17090000022315L17/questions_ecrites1717090000022312170900000223121JO_QUESTION2026-08-1820260033
17090000022380L17/questions_ecrites1717090000022376170900000223761JO_QUESTION2026-07-2820260030
17090000022432L17/questions_ecrites1717090000022429170900000224291JO_QUESTION2026-09-1520260037
17090000022508L17/questions_ecrites1717090000022504170900000225041JO_QUESTION2026-09-0820260036
17090000022523L17/questions_ecrites1717090000022520170900000225201JO_QUESTION2026-08-0420260031
17090000022527L17/questions_ecrites1717090000022524170900000225241JO_QUESTION2026-09-1520260037
17090000022531L17/questions_ecrites1717090000022528170900000225281JO_QUESTION2026-09-1520260037
17090000022538L17/questions_ecrites1717090000022535170900000225351JO_QUESTION2026-09-0820260036
17090000022704L17/questions_ecrites1717090000022699170900000226991JO_QUESTION2025-06-0320250022
17090000022749L17/questions_ecrites1717090000022740170900000227401JO_QUESTION2025-03-1820250011
17090000022750L17/questions_ecrites1717090000022740170900000227402JO_QUESTION2025-06-2420250025
17090000022751L17/questions_ecrites1717090000022740170900000227403JO_QUESTION2025-10-2820250043
17090000022787L17/questions_ecrites1717090000022784170900000227841JO_QUESTION2026-08-0420260031
17090000022887L17/questions_ecrites1717090000022881170900000228811JO_QUESTION2025-02-1120250006
17090000022995L17/questions_ecrites1717090000022991170900000229911JO_QUESTION2026-09-0820260036
17090000023035L17/questions_ecrites1717090000023032170900000230321JO_QUESTION2026-08-0420260031
17090000023060L17/questions_ecrites1717090000023054170900000230541JO_QUESTION2025-03-2520250012
17090000023088L17/questions_ecrites1717090000023085170900000230851JO_QUESTION2026-09-1520260037
17090000023119L17/questions_ecrites1717090000023116170900000231161JO_QUESTION2026-08-0420260031
17090000023123L17/questions_ecrites1717090000023120170900000231201JO_QUESTION2026-09-0820260036
17090000023128L17/questions_ecrites1717090000023124170900000231241JO_QUESTION2026-09-0820260036
17090000023188L17/questions_ecrites1717090000023183170900000231831JO_QUESTION2025-05-0620250018
17090000023202L17/questions_ecrites1717090000023198170900000231981JO_QUESTION2026-08-1120260032
17090000023294L17/questions_ecrites1717090000023290170900000232901JO_QUESTION2026-09-0820260036
17090000023332L17/questions_ecrites1717090000023327170900000233271JO_QUESTION2025-03-1120250010
17090000023430L17/questions_ecrites1717090000023426170900000234261JO_QUESTION2026-08-2520260034
17090000023443L17/questions_ecrites1717090000023439170900000234391JO_QUESTION2026-08-2520260034
17090000023451L17/questions_ecrites1717090000023447170900000234471JO_QUESTION2026-08-1120260032
17090000023469L17/questions_ecrites1717090000023464170900000234641JO_QUESTION2025-02-1120250006
17090000023470L17/questions_ecrites1717090000023464170900000234642JO_QUESTION2025-05-2720250021
17090000023562L17/questions_ecrites1717090000023557170900000235571JO_QUESTION2025-02-0420250005
17090000023563L17/questions_ecrites1717090000023557170900000235572JO_QUESTION2025-05-1320250019
17090000023637L17/questions_ecrites1717090000023633170900000236331JO_QUESTION2026-09-0120260035
17090000023664L17/questions_ecrites1717090000023659170900000236591JO_QUESTION2026-08-1120260032
17090000023669L17/questions_ecrites1717090000023665170900000236651JO_QUESTION2026-09-0120260035
17090000023682L17/questions_ecrites1717090000023679170900000236791JO_QUESTION2026-09-0820260036
17090000023792L17/questions_ecrites1717090000023789170900000237891JO_QUESTION2026-09-2220260038
17090000023801L17/questions_ecrites1717090000023796170900000237961JO_QUESTION2025-02-0420250005