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
16090000042494L16/questions_ecrites1616090000042488160900000424881JO_QUESTION2022-10-2520220042
16090000042495L16/questions_ecrites1616090000042488160900000424882JO_QUESTION2023-02-2820230009
16090000042496L16/questions_ecrites1616090000042488160900000424883JO_QUESTION2023-06-0620230023
16090000042497L16/questions_ecrites1616090000042488160900000424884JO_QUESTION2023-09-1220230037
16090000042584L16/questions_ecrites1616090000042578160900000425781JO_QUESTION2023-01-3120230005
16090000042589L16/questions_ecrites1616090000042585160900000425851JO_QUESTION2023-02-0720230006
16090000042590L16/questions_ecrites1616090000042585160900000425852JO_QUESTION2023-06-0620230023
16090000042630L16/questions_ecrites1616090000042624160900000426241JO_QUESTION2023-09-0520230036
16090000042637L16/questions_ecrites1616090000042631160900000426311JO_QUESTION2023-04-0420230014
16090000042642L16/questions_ecrites1616090000042638160900000426381JO_QUESTION2023-01-3120230005
16090000042656L16/questions_ecrites1616090000042652160900000426521JO_QUESTION2023-01-1720230003
16090000042741L16/questions_ecrites1616090000042735160900000427351JO_QUESTION2023-01-1720230003
16090000042742L16/questions_ecrites1616090000042735160900000427352JO_QUESTION2023-05-0220230018
16090000042743L16/questions_ecrites1616090000042735160900000427353JO_QUESTION2023-08-2920230035
16090000042744L16/questions_ecrites1616090000042735160900000427354JO_QUESTION2023-12-0520230049
16090000042745L16/questions_ecrites1616090000042735160900000427355JO_QUESTION2024-04-2320240017
16090000042757L16/questions_ecrites1616090000042752160900000427521JO_QUESTION2023-05-2320230021
16090000042758L16/questions_ecrites1616090000042752160900000427522JO_QUESTION2024-03-1220240011
16090000042781L16/questions_ecrites1616090000042777160900000427771JO_QUESTION2023-01-1720230003
16090000042782L16/questions_ecrites1616090000042777160900000427772JO_QUESTION2023-04-2520230017
16090000042783L16/questions_ecrites1616090000042777160900000427773JO_QUESTION2023-10-0320230040
16090000042817L16/questions_ecrites1616090000042813160900000428131JO_QUESTION2023-11-2820230048
16090000042818L16/questions_ecrites1616090000042813160900000428132JO_QUESTION2024-03-1220240011
16090000042823L16/questions_ecrites1616090000042819160900000428191JO_QUESTION2023-10-3120230044
16090000042824L16/questions_ecrites1616090000042819160900000428192JO_QUESTION2024-02-2020240008
16090000042878L16/questions_ecrites1616090000042874160900000428741JO_QUESTION2022-12-0620220048
16090000042972L16/questions_ecrites1616090000042968160900000429681JO_QUESTION2023-02-0720230006
16090000042989L16/questions_ecrites1616090000042985160900000429851JO_QUESTION2023-06-2020230025
16090000043003L16/questions_ecrites1616090000042999160900000429991JO_QUESTION2023-05-3020230022
16090000043004L16/questions_ecrites1616090000042999160900000429992JO_QUESTION2023-11-2820230048
16090000043005L16/questions_ecrites1616090000042999160900000429993JO_QUESTION2024-03-1220240011
16090000043028L16/questions_ecrites1616090000043023160900000430231JO_QUESTION2023-01-3120230005
16090000043054L16/questions_ecrites1616090000043050160900000430501JO_QUESTION2023-01-3120230005
16090000043075L16/questions_ecrites1616090000043071160900000430711JO_QUESTION2023-06-2020230025
16090000043103L16/questions_ecrites1616090000043099160900000430991JO_QUESTION2023-01-3120230005
16090000043160L16/questions_ecrites1616090000043154160900000431541JO_QUESTION2023-02-0720230006
16090000043161L16/questions_ecrites1616090000043154160900000431542JO_QUESTION2023-06-0620230023
16090000043170L16/questions_ecrites1616090000043166160900000431661JO_QUESTION2023-01-1720230003
16090000043187L16/questions_ecrites1616090000043180160900000431801JO_QUESTION2023-04-0420230014
16090000043188L16/questions_ecrites1616090000043180160900000431802JO_QUESTION2023-11-2820230048
16090000043189L16/questions_ecrites1616090000043180160900000431803JO_QUESTION2024-03-1220240011
16090000043197L16/questions_ecrites1616090000043190160900000431901JO_QUESTION2023-11-0720230045
16090000043209L16/questions_ecrites1616090000043205160900000432051JO_QUESTION2023-02-0720230006
16090000043222L16/questions_ecrites1616090000043218160900000432181JO_QUESTION2023-04-1820230016
16090000043223L16/questions_ecrites1616090000043218160900000432182JO_QUESTION2023-07-2520230030
16090000043224L16/questions_ecrites1616090000043218160900000432183JO_QUESTION2023-11-0720230045
16090000043225L16/questions_ecrites1616090000043218160900000432184JO_QUESTION2024-02-1320240007
16090000043300L16/questions_ecrites1616090000043293160900000432931JO_QUESTION2023-11-0720230045
16090000043333L16/questions_ecrites1616090000043329160900000433291JO_QUESTION2023-01-3120230005
16090000043387L16/questions_ecrites1616090000043383160900000433831JO_QUESTION2023-01-3120230005