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
17090000037289L17/questions_ecrites1717090000037280170900000372804JO_QUESTION2025-12-1620250050
17090000037290L17/questions_ecrites1717090000037280170900000372805JO_QUESTION2026-03-2420260012
17090000037562L17/questions_ecrites1717090000037554170900000375541JO_QUESTION2025-02-1820250007
17090000037563L17/questions_ecrites1717090000037554170900000375542JO_QUESTION2025-09-3020250039
17090000037715L17/questions_ecrites1717090000037708170900000377081JO_QUESTION2025-02-1820250007
17090000038952L17/questions_ecrites1717090000038947170900000389471JO_QUESTION2025-03-1820250011
17090000039053L17/questions_ecrites1717090000039048170900000390481JO_QUESTION2025-03-2520250012
17090000039064L17/questions_ecrites1717090000039059170900000390591JO_QUESTION2025-02-1820250007
17090000039065L17/questions_ecrites1717090000039059170900000390592JO_QUESTION2025-06-0320250022
17090000039085L17/questions_ecrites1717090000039080170900000390801JO_QUESTION2025-02-1820250007
17090000039165L17/questions_ecrites1717090000039159170900000391591JO_QUESTION2025-02-1820250007
17090000039178L17/questions_ecrites1717090000039171170900000391711JO_QUESTION2025-09-0920250036
17090000039198L17/questions_ecrites1717090000039193170900000391931JO_QUESTION2025-03-1820250011
17090000039254L17/questions_ecrites1717090000039249170900000392491JO_QUESTION2025-03-1820250011
17090000039268L17/questions_ecrites1717090000039260170900000392601JO_QUESTION2025-02-1820250007
17090000039269L17/questions_ecrites1717090000039260170900000392602JO_QUESTION2025-05-2720250021
17090000039270L17/questions_ecrites1717090000039260170900000392603JO_QUESTION2025-09-0920250036
17090000039271L17/questions_ecrites1717090000039260170900000392604JO_QUESTION2025-12-1620250050
17090000039272L17/questions_ecrites1717090000039260170900000392605JO_QUESTION2026-03-2420260012
17090000039302L17/questions_ecrites1717090000039297170900000392971JO_QUESTION2025-03-1120250010
17090000039362L17/questions_ecrites1717090000039357170900000393571JO_QUESTION2025-03-2520250012
17090000039371L17/questions_ecrites1717090000039363170900000393631JO_QUESTION2025-01-2820250004
17090000039372L17/questions_ecrites1717090000039363170900000393632JO_QUESTION2025-05-0620250018
17090000039373L17/questions_ecrites1717090000039363170900000393633JO_QUESTION2025-08-1220250032
17090000039374L17/questions_ecrites1717090000039363170900000393634JO_QUESTION2025-11-1820250046
17090000039431L17/questions_ecrites1717090000039424170900000394241JO_QUESTION2025-02-1820250007
17090000039432L17/questions_ecrites1717090000039424170900000394242JO_QUESTION2025-05-2720250021
17090000039433L17/questions_ecrites1717090000039424170900000394243JO_QUESTION2025-09-0220250035
17090000039434L17/questions_ecrites1717090000039424170900000394244JO_QUESTION2025-12-1620250050
17090000039435L17/questions_ecrites1717090000039424170900000394245JO_QUESTION2026-03-2420260012
17090000039436L17/questions_ecrites1717090000039424170900000394246JO_QUESTION2026-06-3020260026
17090000039454L17/questions_ecrites1717090000039448170900000394481JO_QUESTION2025-02-1820250007
17090000039455L17/questions_ecrites1717090000039448170900000394482JO_QUESTION2025-05-2720250021
17090000039456L17/questions_ecrites1717090000039448170900000394483JO_QUESTION2025-09-0220250035
17090000039457L17/questions_ecrites1717090000039448170900000394484JO_QUESTION2025-12-1620250050
17090000039458L17/questions_ecrites1717090000039448170900000394485JO_QUESTION2026-03-2420260012
17090000039459L17/questions_ecrites1717090000039448170900000394486JO_QUESTION2026-06-3020260026
17090000039477L17/questions_ecrites1717090000039471170900000394711JO_QUESTION2025-10-2120250042
17090000039641L17/questions_ecrites1717090000039636170900000396361JO_QUESTION2025-02-1820250007
17090000039642L17/questions_ecrites1717090000039636170900000396362JO_QUESTION2025-05-2720250021
17090000039710L17/questions_ecrites1717090000039702170900000397021JO_QUESTION2025-10-2120250042
17090000039750L17/questions_ecrites1717090000039742170900000397421JO_QUESTION2025-08-0520250031
17090000039751L17/questions_ecrites1717090000039742170900000397422JO_QUESTION2025-12-0220250048
17090000039752L17/questions_ecrites1717090000039742170900000397423JO_QUESTION2026-04-0720260014
17090000039753L17/questions_ecrites1717090000039742170900000397424JO_QUESTION2026-08-1820260033
17090000039765L17/questions_ecrites1717090000039759170900000397591JO_QUESTION2025-02-1120250006
17090000039918L17/questions_ecrites1717090000039913170900000399131JO_QUESTION2025-03-2520250012
17090000039924L17/questions_ecrites1717090000039919170900000399191JO_QUESTION2025-03-0420250009
17090000039964L17/questions_ecrites1717090000039958170900000399581JO_QUESTION2025-05-2720250021
17090000039965L17/questions_ecrites1717090000039958170900000399582JO_QUESTION2026-03-3120260013