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
15090000067889L15/questions_ecrites1515090000067885150900000678851JO_QUESTION17/12/2019
15090000067890L15/questions_ecrites1515090000067885150900000678852JO_QUESTION14/04/2020
15090000067909L15/questions_ecrites1515090000067904150900000679041JO_QUESTION03/03/2020
15090000067910L15/questions_ecrites1515090000067904150900000679042JO_QUESTION09/06/2020
15090000067939L15/questions_ecrites1515090000067932150900000679321JO_QUESTION17/12/2019
15090000067940L15/questions_ecrites1515090000067932150900000679322JO_QUESTION26/05/2020
15090000068002L15/questions_ecrites1515090000067998150900000679981JO_QUESTION17/12/2019
15090000068028L15/questions_ecrites1515090000068023150900000680231JO_QUESTION17/12/2019
15090000068029L15/questions_ecrites1515090000068023150900000680232JO_QUESTION09/06/2020
15090000068030L15/questions_ecrites1515090000068023150900000680233JO_QUESTION22/12/2020
15090000068031L15/questions_ecrites1515090000068023150900000680234JO_QUESTION07/09/2021
15090000068050L15/questions_ecrites1515090000068044150900000680441JO_QUESTION17/12/2019
15090000068051L15/questions_ecrites1515090000068044150900000680442JO_QUESTION09/06/2020
15090000068064L15/questions_ecrites1515090000068058150900000680581JO_QUESTION17/12/2019
15090000068065L15/questions_ecrites1515090000068058150900000680582JO_QUESTION09/06/2020
15090000068066L15/questions_ecrites1515090000068058150900000680583JO_QUESTION22/12/2020
15090000068067L15/questions_ecrites1515090000068058150900000680584JO_QUESTION07/09/2021
15090000068073L15/questions_ecrites1515090000068068150900000680681JO_QUESTION17/12/2019
15090000068074L15/questions_ecrites1515090000068068150900000680682JO_QUESTION09/06/2020
15090000068075L15/questions_ecrites1515090000068068150900000680683JO_QUESTION22/12/2020
15090000068076L15/questions_ecrites1515090000068068150900000680684JO_QUESTION07/09/2021
15090000068088L15/questions_ecrites1515090000068084150900000680841JO_QUESTION17/12/2019
15090000068093L15/questions_ecrites1515090000068089150900000680891JO_QUESTION17/12/2019
15090000068101L15/questions_ecrites1515090000068094150900000680941JO_QUESTION17/12/2019
15090000068102L15/questions_ecrites1515090000068094150900000680942JO_QUESTION09/06/2020
15090000068103L15/questions_ecrites1515090000068094150900000680943JO_QUESTION22/12/2020
15090000068104L15/questions_ecrites1515090000068094150900000680944JO_QUESTION07/09/2021
15090000068110L15/questions_ecrites1515090000068105150900000681051JO_QUESTION17/12/2019
15090000068111L15/questions_ecrites1515090000068105150900000681052JO_QUESTION09/06/2020
15090000068112L15/questions_ecrites1515090000068105150900000681053JO_QUESTION22/12/2020
15090000068113L15/questions_ecrites1515090000068105150900000681054JO_QUESTION07/09/2021
15090000068123L15/questions_ecrites1515090000068118150900000681181JO_QUESTION17/12/2019
15090000068124L15/questions_ecrites1515090000068118150900000681182JO_QUESTION09/06/2020
15090000068125L15/questions_ecrites1515090000068118150900000681183JO_QUESTION22/12/2020
15090000068126L15/questions_ecrites1515090000068118150900000681184JO_QUESTION07/09/2021
15090000068131L15/questions_ecrites1515090000068127150900000681271JO_QUESTION17/12/2019
15090000068156L15/questions_ecrites1515090000068152150900000681521JO_QUESTION17/12/2019
15090000068157L15/questions_ecrites1515090000068152150900000681522JO_QUESTION09/06/2020
15090000068182L15/questions_ecrites1515090000068177150900000681771JO_QUESTION17/12/2019
15090000068183L15/questions_ecrites1515090000068177150900000681772JO_QUESTION09/06/2020
15090000068184L15/questions_ecrites1515090000068177150900000681773JO_QUESTION22/12/2020
15090000068185L15/questions_ecrites1515090000068177150900000681774JO_QUESTION07/09/2021
15090000068191L15/questions_ecrites1515090000068186150900000681861JO_QUESTION17/12/2019
15090000068192L15/questions_ecrites1515090000068186150900000681862JO_QUESTION09/06/2020
15090000068201L15/questions_ecrites1515090000068197150900000681971JO_QUESTION17/12/2019
15090000068325L15/questions_ecrites1515090000068320150900000683201JO_QUESTION10/03/2020
15090000068336L15/questions_ecrites1515090000068330150900000683301JO_QUESTION17/12/2019
15090000068337L15/questions_ecrites1515090000068330150900000683302JO_QUESTION26/05/2020
15090000068348L15/questions_ecrites1515090000068342150900000683421JO_QUESTION24/12/2019
15090000068396L15/questions_ecrites1515090000068390150900000683901JO_QUESTION04/02/2020