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
16090000067964L16/questions_ecrites1616090000067959160900000679591JO_QUESTION2023-07-1120230028
16090000067965L16/questions_ecrites1616090000067959160900000679592JO_QUESTION2023-12-0520230049
16090000067970L16/questions_ecrites1616090000067966160900000679661JO_QUESTION2023-07-1120230028
16090000067979L16/questions_ecrites1616090000067975160900000679751JO_QUESTION2024-03-1220240011
16090000068070L16/questions_ecrites1616090000068064160900000680641JO_QUESTION2023-09-2620230039
16090000068098L16/questions_ecrites1616090000068091160900000680911JO_QUESTION2024-04-1620240016
16090000068153L16/questions_ecrites1616090000068149160900000681491JO_QUESTION2024-03-1220240011
16090000068170L16/questions_ecrites1616090000068166160900000681661JO_QUESTION2023-07-1820230029
16090000068180L16/questions_ecrites1616090000068176160900000681761JO_QUESTION2023-09-1920230038
16090000068181L16/questions_ecrites1616090000068176160900000681762JO_QUESTION2024-01-3020240005
16090000068182L16/questions_ecrites1616090000068176160900000681763JO_QUESTION2024-05-2120240021
16090000068188L16/questions_ecrites1616090000068183160900000681831JO_QUESTION2023-08-0120230031
16090000068199L16/questions_ecrites1616090000068194160900000681941JO_QUESTION2023-07-1820230029
16090000068253L16/questions_ecrites1616090000068248160900000682481JO_QUESTION2022-12-2020220050
16090000068321L16/questions_ecrites1616090000068317160900000683171JO_QUESTION2023-08-0120230031
16090000068322L16/questions_ecrites1616090000068317160900000683172JO_QUESTION2024-02-2020240008
16090000068337L16/questions_ecrites1616090000068332160900000683321JO_QUESTION2023-08-0120230031
16090000068401L16/questions_ecrites1616090000068397160900000683971JO_QUESTION2023-07-1120230028
16090000068445L16/questions_ecrites1616090000068441160900000684411JO_QUESTION2023-07-2520230030
16090000068583L16/questions_ecrites1616090000068576160900000685761JO_QUESTION2023-07-1120230028
16090000068584L16/questions_ecrites1616090000068576160900000685762JO_QUESTION2023-10-1720230042
16090000068585L16/questions_ecrites1616090000068576160900000685763JO_QUESTION2024-01-2320240004
16090000068586L16/questions_ecrites1616090000068576160900000685764JO_QUESTION2024-06-1120240024
16090000068634L16/questions_ecrites1616090000068630160900000686301JO_QUESTION2022-11-1520220045
16090000068666L16/questions_ecrites1616090000068662160900000686621JO_QUESTION2023-07-2520230030
16090000068704L16/questions_ecrites1616090000068700160900000687001JO_QUESTION2023-07-1820230029
16090000068709L16/questions_ecrites1616090000068705160900000687051JO_QUESTION2023-07-1820230029
16090000068714L16/questions_ecrites1616090000068710160900000687101JO_QUESTION2023-07-1820230029
16090000068797L16/questions_ecrites1616090000068793160900000687931JO_QUESTION2023-07-1820230029
16090000068873L16/questions_ecrites1616090000068869160900000688691JO_QUESTION2023-08-2920230035
16090000068895L16/questions_ecrites1616090000068890160900000688901JO_QUESTION2023-08-0120230031
16090000068958L16/questions_ecrites1616090000068954160900000689541JO_QUESTION2023-07-1820230029
16090000068980L16/questions_ecrites1616090000068976160900000689761JO_QUESTION2023-09-0520230036
16090000069042L16/questions_ecrites1616090000069038160900000690381JO_QUESTION2023-07-1820230029
16090000069068L16/questions_ecrites1616090000069062160900000690621JO_QUESTION2023-12-1220230050
16090000069069L16/questions_ecrites1616090000069062160900000690622JO_QUESTION2024-04-0220240014
16090000069114L16/questions_ecrites1616090000069110160900000691101JO_QUESTION2023-07-1120230028
16090000069263L16/questions_ecrites1616090000069256160900000692561JO_QUESTION2024-02-2720240009
16090000069347L16/questions_ecrites1616090000069343160900000693431JO_QUESTION2023-08-0820230032
16090000069356L16/questions_ecrites1616090000069352160900000693521JO_QUESTION2023-07-1820230029
16090000069416L16/questions_ecrites1616090000069412160900000694121JO_QUESTION2023-08-0120230031
16090000069422L16/questions_ecrites1616090000069417160900000694171JO_QUESTION2023-08-0120230031
16090000069484L16/questions_ecrites1616090000069478160900000694781JO_QUESTION2024-04-1620240016
16090000069491L16/questions_ecrites1616090000069485160900000694851JO_QUESTION2023-10-1720230042
16090000069492L16/questions_ecrites1616090000069485160900000694852JO_QUESTION2024-05-1420240020
16090000069534L16/questions_ecrites1616090000069530160900000695301JO_QUESTION2023-11-2120230047
16090000069593L16/questions_ecrites1616090000069589160900000695891JO_QUESTION2024-04-3020240018
16090000069632L16/questions_ecrites1616090000069628160900000696281JO_QUESTION2023-11-2120230047
16090000069801L16/questions_ecrites1616090000069795160900000697951JO_QUESTION2023-11-2120230047
16090000069877L16/questions_ecrites1616090000069871160900000698711JO_QUESTION2023-08-0120230031