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
16090000048503L16/questions_ecrites1616090000048496160900000484961JO_QUESTION2023-03-0720230010
16090000048504L16/questions_ecrites1616090000048496160900000484962JO_QUESTION2024-03-2620240013
16090000048553L16/questions_ecrites1616090000048548160900000485481JO_QUESTION2023-05-2320230021
16090000048571L16/questions_ecrites1616090000048566160900000485661JO_QUESTION2023-02-2820230009
16090000048572L16/questions_ecrites1616090000048566160900000485662JO_QUESTION2023-06-2020230025
16090000048640L16/questions_ecrites1616090000048635160900000486351JO_QUESTION2023-02-2820230009
16090000048641L16/questions_ecrites1616090000048635160900000486352JO_QUESTION2023-06-2720230026
16090000048642L16/questions_ecrites1616090000048635160900000486353JO_QUESTION2023-10-0320230040
16090000048643L16/questions_ecrites1616090000048635160900000486354JO_QUESTION2024-01-0920240002
16090000048708L16/questions_ecrites1616090000048704160900000487041JO_QUESTION2023-08-0120230031
16090000048709L16/questions_ecrites1616090000048704160900000487042JO_QUESTION2024-04-1620240016
16090000048767L16/questions_ecrites1616090000048763160900000487631JO_QUESTION2023-02-2820230009
16090000048768L16/questions_ecrites1616090000048763160900000487632JO_QUESTION2023-06-2020230025
16090000048769L16/questions_ecrites1616090000048763160900000487633JO_QUESTION2023-10-1020230041
16090000048778L16/questions_ecrites1616090000048774160900000487741JO_QUESTION2023-10-3120230044
16090000048779L16/questions_ecrites1616090000048774160900000487742JO_QUESTION2024-02-2020240008
16090000048874L16/questions_ecrites1616090000048870160900000488701JO_QUESTION2022-11-1520220045
16090000048880L16/questions_ecrites1616090000048875160900000488751JO_QUESTION2023-02-2820230009
16090000048881L16/questions_ecrites1616090000048875160900000488752JO_QUESTION2023-06-0620230023
16090000048882L16/questions_ecrites1616090000048875160900000488753JO_QUESTION2023-10-0320230040
16090000048913L16/questions_ecrites1616090000048909160900000489091JO_QUESTION2023-06-2720230026
16090000048943L16/questions_ecrites1616090000048938160900000489381JO_QUESTION2023-02-2820230009
16090000048954L16/questions_ecrites1616090000048949160900000489491JO_QUESTION2023-03-1420230011
16090000049018L16/questions_ecrites1616090000049012160900000490121JO_QUESTION2023-03-2120230012
16090000049019L16/questions_ecrites1616090000049012160900000490122JO_QUESTION2023-08-0120230031
16090000049020L16/questions_ecrites1616090000049012160900000490123JO_QUESTION2023-11-0720230045
16090000049021L16/questions_ecrites1616090000049012160900000490124JO_QUESTION2024-02-2720240009
16090000049033L16/questions_ecrites1616090000049028160900000490281JO_QUESTION2022-12-1320220049
16090000049056L16/questions_ecrites1616090000049051160900000490511JO_QUESTION2023-04-0420230014
16090000049065L16/questions_ecrites1616090000049061160900000490611JO_QUESTION2023-04-1820230016
16090000049102L16/questions_ecrites1616090000049094160900000490941JO_QUESTION2023-03-2820230013
16090000049148L16/questions_ecrites1616090000049144160900000491441JO_QUESTION2023-03-1420230011
16090000049189L16/questions_ecrites1616090000049182160900000491821JO_QUESTION2022-11-1520220045
16090000049190L16/questions_ecrites1616090000049182160900000491822JO_QUESTION2023-02-2820230009
16090000049191L16/questions_ecrites1616090000049182160900000491823JO_QUESTION2023-06-2020230025
16090000049192L16/questions_ecrites1616090000049182160900000491824JO_QUESTION2023-10-1020230041
16090000049193L16/questions_ecrites1616090000049182160900000491825JO_QUESTION2024-02-0620240006
16090000049194L16/questions_ecrites1616090000049182160900000491826JO_QUESTION2024-05-2820240022
16090000049288L16/questions_ecrites1616090000049284160900000492841JO_QUESTION2023-02-2820230009
16090000049289L16/questions_ecrites1616090000049284160900000492842JO_QUESTION2023-06-2720230026
16090000049312L16/questions_ecrites1616090000049308160900000493081JO_QUESTION2023-03-1420230011
16090000049350L16/questions_ecrites1616090000049346160900000493461JO_QUESTION2023-04-1820230016
16090000049351L16/questions_ecrites1616090000049346160900000493462JO_QUESTION2024-04-3020240018
16090000049360L16/questions_ecrites1616090000049356160900000493561JO_QUESTION2023-03-1420230011
16090000049361L16/questions_ecrites1616090000049356160900000493562JO_QUESTION2023-07-2520230030
16090000049362L16/questions_ecrites1616090000049356160900000493563JO_QUESTION2023-12-1220230050
16090000049363L16/questions_ecrites1616090000049356160900000493564JO_QUESTION2024-06-1120240024
16090000049516L16/questions_ecrites1616090000049512160900000495121JO_QUESTION2023-05-1620230020
16090000049627L16/questions_ecrites1616090000049622160900000496221JO_QUESTION2023-02-2820230009
16090000049649L16/questions_ecrites1616090000049644160900000496441JO_QUESTION2023-06-0620230023