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
17090000008772L17/questions_ecrites1717090000008769170900000087691JO_QUESTION2026-04-1420260015
17090000008782L17/questions_ecrites1717090000008777170900000087771JO_QUESTION2025-02-1120250006
17090000008792L17/questions_ecrites1717090000008789170900000087891JO_QUESTION2026-07-1420260028
17090000008818L17/questions_ecrites1717090000008814170900000088141JO_QUESTION2026-04-1420260015
17090000008856L17/questions_ecrites1717090000008853170900000088531JO_QUESTION2026-03-2420260012
17090000008857L17/questions_ecrites1717090000008853170900000088532JO_QUESTION2026-07-0720260027
17090000008864L17/questions_ecrites1717090000008861170900000088611JO_QUESTION2026-05-0520260018
17090000008911L17/questions_ecrites1717090000008908170900000089081JO_QUESTION2026-05-2620260021
17090000008912L17/questions_ecrites1717090000008908170900000089082JO_QUESTION2026-09-2220260038
17090000008916L17/questions_ecrites1717090000008913170900000089131JO_QUESTION2026-04-1420260015
17090000008936L17/questions_ecrites1717090000008932170900000089321JO_QUESTION2026-06-0920260023
17090000008945L17/questions_ecrites1717090000008941170900000089411JO_QUESTION2026-05-0520260018
17090000008995L17/questions_ecrites1717090000008990170900000089901JO_QUESTION2026-03-2420260012
17090000009099L17/questions_ecrites1717090000009096170900000090961JO_QUESTION2026-07-2120260029
17090000009160L17/questions_ecrites1717090000009157170900000091571JO_QUESTION2026-06-1620260024
17090000009164L17/questions_ecrites1717090000009161170900000091611JO_QUESTION2026-03-2420260012
17090000009165L17/questions_ecrites1717090000009161170900000091612JO_QUESTION2026-06-3020260026
17090000009285L17/questions_ecrites1717090000009282170900000092821JO_QUESTION2026-04-1420260015
17090000009337L17/questions_ecrites1717090000009332170900000093321JO_QUESTION2026-03-2420260012
17090000009338L17/questions_ecrites1717090000009332170900000093322JO_QUESTION2026-06-3020260026
17090000009426L17/questions_ecrites1717090000009423170900000094231JO_QUESTION2026-03-2420260012
17090000009427L17/questions_ecrites1717090000009423170900000094232JO_QUESTION2026-06-3020260026
17090000009431L17/questions_ecrites1717090000009428170900000094281JO_QUESTION2026-05-0520260018
17090000009443L17/questions_ecrites1717090000009440170900000094401JO_QUESTION2026-03-2420260012
17090000009444L17/questions_ecrites1717090000009440170900000094402JO_QUESTION2026-06-3020260026
17090000009456L17/questions_ecrites1717090000009452170900000094521JO_QUESTION2026-05-1220260019
17090000009457L17/questions_ecrites1717090000009452170900000094522JO_QUESTION2026-09-2220260038
17090000009528L17/questions_ecrites1717090000009524170900000095241JO_QUESTION2026-05-1920260020
17090000009533L17/questions_ecrites1717090000009529170900000095291JO_QUESTION2026-03-3120260013
17090000009534L17/questions_ecrites1717090000009529170900000095292JO_QUESTION2026-07-0720260027
17090000009628L17/questions_ecrites1717090000009624170900000096241JO_QUESTION2026-03-3120260013
17090000009629L17/questions_ecrites1717090000009624170900000096242JO_QUESTION2026-07-2120260029
17090000009639L17/questions_ecrites1717090000009634170900000096341JO_QUESTION2026-05-2620260021
17090000009643L17/questions_ecrites1717090000009640170900000096401JO_QUESTION2026-03-3120260013
17090000009644L17/questions_ecrites1717090000009640170900000096402JO_QUESTION2026-07-0720260027
17090000009655L17/questions_ecrites1717090000009652170900000096521JO_QUESTION2026-05-0520260018
17090000009766L17/questions_ecrites1717090000009760170900000097601JO_QUESTION2025-02-0420250005
17090000009797L17/questions_ecrites1717090000009794170900000097941JO_QUESTION2026-04-0720260014
17090000009798L17/questions_ecrites1717090000009794170900000097942JO_QUESTION2026-07-2820260030
17090000009811L17/questions_ecrites1717090000009807170900000098071JO_QUESTION2026-06-2320260025
17090000009825L17/questions_ecrites1717090000009821170900000098211JO_QUESTION2026-03-3120260013
17090000009826L17/questions_ecrites1717090000009821170900000098212JO_QUESTION2026-07-0720260027
17090000009850L17/questions_ecrites1717090000009847170900000098471JO_QUESTION2026-04-2120260016
17090000009851L17/questions_ecrites1717090000009847170900000098472JO_QUESTION2026-09-2220260038
17090000009865L17/questions_ecrites1717090000009860170900000098601JO_QUESTION2025-01-2820250004
17090000009870L17/questions_ecrites1717090000009866170900000098661JO_QUESTION2026-06-1620260024
17090000009885L17/questions_ecrites1717090000009882170900000098821JO_QUESTION2026-09-1520260037
17090000009894L17/questions_ecrites1717090000009890170900000098901JO_QUESTION2026-05-1220260019
17090000009921L17/questions_ecrites1717090000009918170900000099181JO_QUESTION2026-05-1920260020
17090000009925L17/questions_ecrites1717090000009922170900000099221JO_QUESTION2026-05-1920260020