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
16090000005582L16/questions_ecrites1616090000005577160900000055771JO_QUESTION2024-03-1220240011
16090000005617L16/questions_ecrites1616090000005613160900000056131JO_QUESTION2024-02-2720240009
16090000005623L16/questions_ecrites1616090000005618160900000056181JO_QUESTION2024-02-2720240009
16090000005667L16/questions_ecrites1616090000005663160900000056631JO_QUESTION2024-01-0220240001
16090000005668L16/questions_ecrites1616090000005663160900000056632JO_QUESTION2024-06-1120240024
16090000005693L16/questions_ecrites1616090000005689160900000056891JO_QUESTION2023-12-2620230052
16090000005694L16/questions_ecrites1616090000005689160900000056892JO_QUESTION2024-04-0220240014
16090000005705L16/questions_ecrites1616090000005698160900000056981JO_QUESTION2023-12-1920230051
16090000005706L16/questions_ecrites1616090000005698160900000056982JO_QUESTION2024-03-2620240013
16090000005784L16/questions_ecrites1616090000005778160900000057781JO_QUESTION2023-12-1220230050
16090000005879L16/questions_ecrites1616090000005875160900000058751JO_QUESTION2024-04-3020240018
16090000005958L16/questions_ecrites1616090000005954160900000059541JO_QUESTION2024-01-3020240005
16090000005959L16/questions_ecrites1616090000005954160900000059542JO_QUESTION2024-05-2120240021
16090000006023L16/questions_ecrites1616090000006018160900000060181JO_QUESTION2023-12-2620230052
16090000006024L16/questions_ecrites1616090000006018160900000060182JO_QUESTION2024-03-2620240013
16090000006059L16/questions_ecrites1616090000006053160900000060531JO_QUESTION2023-12-1220230050
16090000006070L16/questions_ecrites1616090000006064160900000060641JO_QUESTION2024-02-2720240009
16090000006120L16/questions_ecrites1616090000006113160900000061131JO_QUESTION2024-04-3020240018
16090000006132L16/questions_ecrites1616090000006125160900000061251JO_QUESTION2023-12-1220230050
16090000006133L16/questions_ecrites1616090000006125160900000061252JO_QUESTION2024-04-0220240014
16090000006167L16/questions_ecrites1616090000006161160900000061611JO_QUESTION2024-03-1220240011
16090000006183L16/questions_ecrites1616090000006177160900000061771JO_QUESTION2023-12-2620230052
16090000006191L16/questions_ecrites1616090000006184160900000061841JO_QUESTION2024-01-3020240005
16090000006192L16/questions_ecrites1616090000006184160900000061842JO_QUESTION2024-05-2120240021
16090000006233L16/questions_ecrites1616090000006226160900000062261JO_QUESTION2024-01-1620240003
16090000006266L16/questions_ecrites1616090000006260160900000062601JO_QUESTION2023-12-1220230050
16090000006267L16/questions_ecrites1616090000006260160900000062602JO_QUESTION2024-03-1920240012
16090000006275L16/questions_ecrites1616090000006268160900000062681JO_QUESTION2023-12-1220230050
16090000006276L16/questions_ecrites1616090000006268160900000062682JO_QUESTION2024-03-1920240012
16090000006358L16/questions_ecrites1616090000006354160900000063541JO_QUESTION2024-02-2720240009
16090000006359L16/questions_ecrites1616090000006354160900000063542JO_QUESTION2024-06-1120240024
16090000006403L16/questions_ecrites1616090000006398160900000063981JO_QUESTION2024-04-0220240014
16090000006427L16/questions_ecrites1616090000006420160900000064201JO_QUESTION2024-06-0420240023
16090000006514L16/questions_ecrites1616090000006509160900000065091JO_QUESTION2024-03-1220240011
16090000006521L16/questions_ecrites1616090000006515160900000065151JO_QUESTION2023-12-2620230052
16090000006566L16/questions_ecrites1616090000006562160900000065621JO_QUESTION2024-02-2020240008
16090000006575L16/questions_ecrites1616090000006571160900000065711JO_QUESTION2024-01-2320240004
16090000006593L16/questions_ecrites1616090000006589160900000065891JO_QUESTION2024-05-0720240019
16090000006600L16/questions_ecrites1616090000006594160900000065941JO_QUESTION2023-12-1920230051
16090000006601L16/questions_ecrites1616090000006594160900000065942JO_QUESTION2024-04-0220240014
16090000006609L16/questions_ecrites1616090000006602160900000066021JO_QUESTION2024-04-0920240015
16090000006687L16/questions_ecrites1616090000006682160900000066821JO_QUESTION2023-12-2620230052
16090000006688L16/questions_ecrites1616090000006682160900000066822JO_QUESTION2024-06-1120240024
16090000006736L16/questions_ecrites1616090000006731160900000067311JO_QUESTION2023-12-2620230052
16090000006761L16/questions_ecrites1616090000006756160900000067561JO_QUESTION2024-01-2320240004
16090000006781L16/questions_ecrites1616090000006775160900000067751JO_QUESTION2024-01-3020240005
16090000006782L16/questions_ecrites1616090000006775160900000067752JO_QUESTION2024-05-2120240021
16090000006800L16/questions_ecrites1616090000006794160900000067941JO_QUESTION2024-01-3020240005
16090000006801L16/questions_ecrites1616090000006794160900000067942JO_QUESTION2024-05-2120240021
16090000007005L16/questions_ecrites1616090000006999160900000069991JO_QUESTION2024-02-0620240006