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
16090000046401L16/questions_ecrites1616090000046397160900000463971JO_QUESTION2023-02-0720230006
16090000046420L16/questions_ecrites1616090000046416160900000464161JO_QUESTION2023-02-2820230009
16090000046421L16/questions_ecrites1616090000046416160900000464162JO_QUESTION2023-06-2720230026
16090000046422L16/questions_ecrites1616090000046416160900000464163JO_QUESTION2023-10-2420230043
16090000046423L16/questions_ecrites1616090000046416160900000464164JO_QUESTION2024-02-2020240008
16090000046458L16/questions_ecrites1616090000046453160900000464531JO_QUESTION2023-02-2820230009
16090000046459L16/questions_ecrites1616090000046453160900000464532JO_QUESTION2023-06-2020230025
16090000046460L16/questions_ecrites1616090000046453160900000464533JO_QUESTION2023-10-1020230041
16090000046482L16/questions_ecrites1616090000046478160900000464781JO_QUESTION2023-02-0720230006
16090000046545L16/questions_ecrites1616090000046540160900000465401JO_QUESTION2023-02-0720230006
16090000046546L16/questions_ecrites1616090000046540160900000465402JO_QUESTION2023-05-1620230020
16090000046547L16/questions_ecrites1616090000046540160900000465403JO_QUESTION2023-09-0520230036
16090000046548L16/questions_ecrites1616090000046540160900000465404JO_QUESTION2023-12-1920230051
16090000046620L16/questions_ecrites1616090000046616160900000466161JO_QUESTION2022-11-1520220045
16090000046675L16/questions_ecrites1616090000046671160900000466711JO_QUESTION2023-02-2820230009
16090000046676L16/questions_ecrites1616090000046671160900000466712JO_QUESTION2023-06-2020230025
16090000046716L16/questions_ecrites1616090000046709160900000467091JO_QUESTION2023-02-2820230009
16090000046717L16/questions_ecrites1616090000046709160900000467092JO_QUESTION2023-06-2720230026
16090000046718L16/questions_ecrites1616090000046709160900000467093JO_QUESTION2023-10-2420230043
16090000046719L16/questions_ecrites1616090000046709160900000467094JO_QUESTION2024-02-2020240008
16090000046728L16/questions_ecrites1616090000046724160900000467241JO_QUESTION2023-02-2820230009
16090000046729L16/questions_ecrites1616090000046724160900000467242JO_QUESTION2023-10-0320230040
16090000046730L16/questions_ecrites1616090000046724160900000467243JO_QUESTION2024-01-1620240003
16090000046731L16/questions_ecrites1616090000046724160900000467244JO_QUESTION2024-05-1420240020
16090000046775L16/questions_ecrites1616090000046769160900000467691JO_QUESTION2024-01-2320240004
16090000046784L16/questions_ecrites1616090000046780160900000467801JO_QUESTION2023-02-2820230009
16090000046790L16/questions_ecrites1616090000046785160900000467851JO_QUESTION2023-02-2820230009
16090000046796L16/questions_ecrites1616090000046791160900000467911JO_QUESTION2023-08-0120230031
16090000046837L16/questions_ecrites1616090000046833160900000468331JO_QUESTION2023-02-0720230006
16090000046838L16/questions_ecrites1616090000046833160900000468332JO_QUESTION2023-05-1620230020
16090000046843L16/questions_ecrites1616090000046839160900000468391JO_QUESTION2023-08-0120230031
16090000046875L16/questions_ecrites1616090000046871160900000468711JO_QUESTION2023-02-2820230009
16090000046881L16/questions_ecrites1616090000046876160900000468761JO_QUESTION2023-04-1820230016
16090000046891L16/questions_ecrites1616090000046886160900000468861JO_QUESTION2023-02-0720230006
16090000046892L16/questions_ecrites1616090000046886160900000468862JO_QUESTION2023-05-1620230020
16090000046893L16/questions_ecrites1616090000046886160900000468863JO_QUESTION2023-09-1220230037
16090000046894L16/questions_ecrites1616090000046886160900000468864JO_QUESTION2024-02-2020240008
16090000046940L16/questions_ecrites1616090000046936160900000469361JO_QUESTION2023-02-2820230009
16090000046966L16/questions_ecrites1616090000046962160900000469621JO_QUESTION2023-06-0620230023
16090000046971L16/questions_ecrites1616090000046967160900000469671JO_QUESTION2023-03-1420230011
16090000046972L16/questions_ecrites1616090000046967160900000469672JO_QUESTION2023-10-1020230041
16090000047004L16/questions_ecrites1616090000046999160900000469991JO_QUESTION2023-03-2120230012
16090000047005L16/questions_ecrites1616090000046999160900000469992JO_QUESTION2023-08-0120230031
16090000047015L16/questions_ecrites1616090000047010160900000470101JO_QUESTION2023-06-2020230025
16090000047060L16/questions_ecrites1616090000047056160900000470561JO_QUESTION2023-02-2820230009
16090000047256L16/questions_ecrites1616090000047252160900000472521JO_QUESTION2023-04-1820230016
16090000047270L16/questions_ecrites1616090000047266160900000472661JO_QUESTION2023-03-1420230011
16090000047345L16/questions_ecrites1616090000047340160900000473401JO_QUESTION2022-11-1520220045
16090000047354L16/questions_ecrites1616090000047350160900000473501JO_QUESTION2023-02-2820230009
16090000047382L16/questions_ecrites1616090000047378160900000473781JO_QUESTION2023-03-0720230010