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
16090000007055L16/questions_ecrites1616090000007049160900000070491JO_QUESTION2023-12-2620230052
16090000007133L16/questions_ecrites1616090000007129160900000071291JO_QUESTION2024-01-0220240001
16090000007134L16/questions_ecrites1616090000007129160900000071292JO_QUESTION2024-06-1120240024
16090000007164L16/questions_ecrites1616090000007158160900000071581JO_QUESTION2024-02-1320240007
16090000007210L16/questions_ecrites1616090000007204160900000072041JO_QUESTION2024-01-2320240004
16090000007211L16/questions_ecrites1616090000007204160900000072042JO_QUESTION2024-05-0720240019
16090000007352L16/questions_ecrites1616090000007348160900000073481JO_QUESTION2024-04-3020240018
16090000007383L16/questions_ecrites1616090000007378160900000073781JO_QUESTION2024-02-1320240007
16090000007391L16/questions_ecrites1616090000007387160900000073871JO_QUESTION2024-01-3020240005
16090000007392L16/questions_ecrites1616090000007387160900000073872JO_QUESTION2024-05-2120240021
16090000007398L16/questions_ecrites1616090000007393160900000073931JO_QUESTION2024-01-3020240005
16090000007408L16/questions_ecrites1616090000007403160900000074031JO_QUESTION2024-04-3020240018
16090000007417L16/questions_ecrites1616090000007413160900000074131JO_QUESTION2024-05-2120240021
16090000007474L16/questions_ecrites1616090000007470160900000074701JO_QUESTION2024-01-3020240005
16090000007475L16/questions_ecrites1616090000007470160900000074702JO_QUESTION2024-05-2120240021
16090000007585L16/questions_ecrites1616090000007579160900000075791JO_QUESTION2023-12-2620230052
16090000007820L16/questions_ecrites1616090000007816160900000078161JO_QUESTION2024-04-3020240018
16090000007836L16/questions_ecrites1616090000007829160900000078291JO_QUESTION2023-12-1220230050
16090000007859L16/questions_ecrites1616090000007853160900000078531JO_QUESTION2024-01-1620240003
16090000007900L16/questions_ecrites1616090000007895160900000078951JO_QUESTION2024-02-2020240008
16090000007910L16/questions_ecrites1616090000007906160900000079061JO_QUESTION2024-06-1120240024
16090000007929L16/questions_ecrites1616090000007925160900000079251JO_QUESTION2024-04-3020240018
16090000008030L16/questions_ecrites1616090000008024160900000080241JO_QUESTION2023-12-2620230052
16090000008031L16/questions_ecrites1616090000008024160900000080242JO_QUESTION2024-04-0920240015
16090000008079L16/questions_ecrites1616090000008073160900000080731JO_QUESTION2024-01-0220240001
16090000008080L16/questions_ecrites1616090000008073160900000080732JO_QUESTION2024-06-1120240024
16090000008229L16/questions_ecrites1616090000008224160900000082241JO_QUESTION2024-01-0220240001
16090000008242L16/questions_ecrites1616090000008236160900000082361JO_QUESTION2024-01-3020240005
16090000008248L16/questions_ecrites1616090000008243160900000082431JO_QUESTION2024-05-1420240020
16090000008271L16/questions_ecrites1616090000008266160900000082661JO_QUESTION2024-05-0720240019
16090000008277L16/questions_ecrites1616090000008272160900000082721JO_QUESTION2022-11-2920220047
16090000008278L16/questions_ecrites1616090000008272160900000082722JO_QUESTION2023-05-3020230022
16090000008279L16/questions_ecrites1616090000008272160900000082723JO_QUESTION2023-11-2820230048
16090000008280L16/questions_ecrites1616090000008272160900000082724JO_QUESTION2024-03-1220240011
16090000008298L16/questions_ecrites1616090000008294160900000082941JO_QUESTION2024-01-1620240003
16090000008299L16/questions_ecrites1616090000008294160900000082942JO_QUESTION2024-05-0720240019
16090000008311L16/questions_ecrites1616090000008305160900000083051JO_QUESTION2024-01-2320240004
16090000008312L16/questions_ecrites1616090000008305160900000083052JO_QUESTION2024-04-3020240018
16090000008317L16/questions_ecrites1616090000008313160900000083131JO_QUESTION2024-03-1920240012
16090000008322L16/questions_ecrites1616090000008318160900000083181JO_QUESTION2024-01-1620240003
16090000008323L16/questions_ecrites1616090000008318160900000083182JO_QUESTION2024-05-1420240020
16090000008348L16/questions_ecrites1616090000008342160900000083421JO_QUESTION2024-01-3020240005
16090000008373L16/questions_ecrites1616090000008368160900000083681JO_QUESTION2024-01-3020240005
16090000008420L16/questions_ecrites1616090000008414160900000084141JO_QUESTION2024-01-3020240005
16090000008450L16/questions_ecrites1616090000008443160900000084431JO_QUESTION2024-01-0920240002
16090000008480L16/questions_ecrites1616090000008475160900000084751JO_QUESTION2024-01-0220240001
16090000008494L16/questions_ecrites1616090000008489160900000084891JO_QUESTION2024-01-0220240001
16090000008495L16/questions_ecrites1616090000008489160900000084892JO_QUESTION2024-04-0920240015
16090000008562L16/questions_ecrites1616090000008558160900000085581JO_QUESTION2022-12-2020220050
16090000008582L16/questions_ecrites1616090000008577160900000085771JO_QUESTION2024-01-3020240005