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
16090000022954L16/questions_ecrites1616090000022948160900000229481JO_QUESTION2024-04-3020240018
16090000023123L16/questions_ecrites1616090000023118160900000231181JO_QUESTION2024-04-0220240014
16090000023153L16/questions_ecrites1616090000023148160900000231481JO_QUESTION2024-05-1420240020
16090000023245L16/questions_ecrites1616090000023241160900000232411JO_QUESTION2024-04-0220240014
16090000023442L16/questions_ecrites1616090000023438160900000234381JO_QUESTION2024-05-0720240019
16090000023511L16/questions_ecrites1616090000023506160900000235061JO_QUESTION2024-06-1120240024
16090000023587L16/questions_ecrites1616090000023581160900000235811JO_QUESTION2024-04-1620240016
16090000023680L16/questions_ecrites1616090000023675160900000236751JO_QUESTION2024-05-2120240021
16090000023757L16/questions_ecrites1616090000023753160900000237531JO_QUESTION2024-06-1120240024
16090000023788L16/questions_ecrites1616090000023783160900000237831JO_QUESTION2024-05-2120240021
16090000023846L16/questions_ecrites1616090000023840160900000238401JO_QUESTION2024-05-2120240021
16090000023907L16/questions_ecrites1616090000023903160900000239031JO_QUESTION2024-04-1620240016
16090000023921L16/questions_ecrites1616090000023914160900000239141JO_QUESTION2024-04-1620240016
16090000023942L16/questions_ecrites1616090000023937160900000239371JO_QUESTION2024-04-2320240017
16090000023958L16/questions_ecrites1616090000023953160900000239531JO_QUESTION2024-04-1620240016
16090000024041L16/questions_ecrites1616090000024036160900000240361JO_QUESTION2024-04-1620240016
16090000024081L16/questions_ecrites1616090000024074160900000240741JO_QUESTION2024-04-1620240016
16090000024092L16/questions_ecrites1616090000024087160900000240871JO_QUESTION2024-04-1620240016
16090000024098L16/questions_ecrites1616090000024093160900000240931JO_QUESTION2024-05-2120240021
16090000024103L16/questions_ecrites1616090000024099160900000240991JO_QUESTION2024-05-2820240022
16090000024152L16/questions_ecrites1616090000024147160900000241471JO_QUESTION2024-04-1620240016
16090000024192L16/questions_ecrites1616090000024188160900000241881JO_QUESTION2024-04-1620240016
16090000024249L16/questions_ecrites1616090000024244160900000242441JO_QUESTION2024-05-0720240019
16090000024257L16/questions_ecrites1616090000024250160900000242501JO_QUESTION2024-05-2820240022
16090000024463L16/questions_ecrites1616090000024459160900000244591JO_QUESTION2024-05-0720240019
16090000024590L16/questions_ecrites1616090000024587160900000245871JO_QUESTION2024-05-0720240019
16090000024641L16/questions_ecrites1616090000024636160900000246361JO_QUESTION2024-06-1120240024
16090000024729L16/questions_ecrites1616090000024726160900000247261JO_QUESTION2024-05-2120240021
16090000024775L16/questions_ecrites1616090000024771160900000247711JO_QUESTION2024-05-1420240020
16090000024813L16/questions_ecrites1616090000024807160900000248071JO_QUESTION2023-05-2320230021
16090000024898L16/questions_ecrites1616090000024895160900000248951JO_QUESTION2024-06-1120240024
16090000024911L16/questions_ecrites1616090000024908160900000249081JO_QUESTION2024-06-1120240024
16090000025004L16/questions_ecrites1616090000025001160900000250011JO_QUESTION2024-04-3020240018
16090000025049L16/questions_ecrites1616090000025046160900000250461JO_QUESTION2024-04-3020240018
16090000025058L16/questions_ecrites1616090000025055160900000250551JO_QUESTION2024-04-3020240018
16090000025201L16/questions_ecrites1616090000025198160900000251981JO_QUESTION2024-06-1120240024
16090000025209L16/questions_ecrites1616090000025206160900000252061JO_QUESTION2024-06-1120240024
16090000025216L16/questions_ecrites1616090000025213160900000252131JO_QUESTION2024-06-1120240024
16090000025220L16/questions_ecrites1616090000025217160900000252171JO_QUESTION2024-06-1120240024
16090000025246L16/questions_ecrites1616090000025243160900000252431JO_QUESTION2024-05-1420240020
16090000025275L16/questions_ecrites1616090000025272160900000252721JO_QUESTION2024-06-1120240024
16090000025311L16/questions_ecrites1616090000025307160900000253071JO_QUESTION2024-05-2820240022
16090000025361L16/questions_ecrites1616090000025358160900000253581JO_QUESTION2024-05-2820240022
16090000025433L16/questions_ecrites1616090000025430160900000254301JO_QUESTION2024-06-1120240024
16090000025471L16/questions_ecrites1616090000025468160900000254681JO_QUESTION2024-05-2120240021
16090000025584L16/questions_ecrites1616090000025580160900000255801JO_QUESTION2024-05-0720240019
16090000025643L16/questions_ecrites1616090000025640160900000256401JO_QUESTION2024-05-2820240022
16090000025712L16/questions_ecrites1616090000025709160900000257091JO_QUESTION2024-06-1120240024
16090000025744L16/questions_ecrites1616090000025741160900000257411JO_QUESTION2024-05-2820240022
16090000025748L16/questions_ecrites1616090000025745160900000257451JO_QUESTION2024-05-2120240021