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
16090000053963L16/questions_ecrites1616090000053958160900000539581JO_QUESTION2023-04-1820230016
16090000054028L16/questions_ecrites1616090000054022160900000540221JO_QUESTION2023-10-0320230040
16090000054085L16/questions_ecrites1616090000054078160900000540781JO_QUESTION2023-10-1720230042
16090000054086L16/questions_ecrites1616090000054078160900000540782JO_QUESTION2024-05-1420240020
16090000054185L16/questions_ecrites1616090000054178160900000541781JO_QUESTION2022-11-1520220045
16090000054186L16/questions_ecrites1616090000054178160900000541782JO_QUESTION2023-07-0420230027
16090000054234L16/questions_ecrites1616090000054230160900000542301JO_QUESTION2022-11-1520220045
16090000054235L16/questions_ecrites1616090000054230160900000542302JO_QUESTION2023-03-2120230012
16090000054254L16/questions_ecrites1616090000054249160900000542491JO_QUESTION2023-08-0120230031
16090000054255L16/questions_ecrites1616090000054249160900000542492JO_QUESTION2024-02-2020240008
16090000054260L16/questions_ecrites1616090000054256160900000542561JO_QUESTION2023-08-0120230031
16090000054265L16/questions_ecrites1616090000054261160900000542611JO_QUESTION2023-05-2320230021
16090000054274L16/questions_ecrites1616090000054270160900000542701JO_QUESTION2023-04-2520230017
16090000054297L16/questions_ecrites1616090000054292160900000542921JO_QUESTION2023-04-1820230016
16090000054298L16/questions_ecrites1616090000054292160900000542922JO_QUESTION2023-11-2120230047
16090000054299L16/questions_ecrites1616090000054292160900000542923JO_QUESTION2024-03-1220240011
16090000054323L16/questions_ecrites1616090000054316160900000543161JO_QUESTION2024-03-1220240011
16090000054344L16/questions_ecrites1616090000054340160900000543401JO_QUESTION2022-10-2520220042
16090000054345L16/questions_ecrites1616090000054340160900000543402JO_QUESTION2023-01-3120230005
16090000054422L16/questions_ecrites1616090000054415160900000544151JO_QUESTION2023-08-0120230031
16090000054423L16/questions_ecrites1616090000054415160900000544152JO_QUESTION2023-11-0720230045
16090000054424L16/questions_ecrites1616090000054415160900000544153JO_QUESTION2024-02-2720240009
16090000054508L16/questions_ecrites1616090000054504160900000545041JO_QUESTION2023-04-2520230017
16090000054648L16/questions_ecrites1616090000054642160900000546421JO_QUESTION2023-07-1120230028
16090000054649L16/questions_ecrites1616090000054642160900000546422JO_QUESTION2024-02-2720240009
16090000054706L16/questions_ecrites1616090000054702160900000547021JO_QUESTION2023-05-2320230021
16090000054881L16/questions_ecrites1616090000054877160900000548771JO_QUESTION2023-06-2720230026
16090000054907L16/questions_ecrites1616090000054903160900000549031JO_QUESTION2023-05-2320230021
16090000054976L16/questions_ecrites1616090000054969160900000549691JO_QUESTION2023-10-0320230040
16090000055005L16/questions_ecrites1616090000054999160900000549991JO_QUESTION2023-04-2520230017
16090000055060L16/questions_ecrites1616090000055056160900000550561JO_QUESTION2023-06-2720230026
16090000055120L16/questions_ecrites1616090000055116160900000551161JO_QUESTION2023-04-2520230017
16090000055137L16/questions_ecrites1616090000055133160900000551331JO_QUESTION2023-06-2020230025
16090000055250L16/questions_ecrites1616090000055245160900000552451JO_QUESTION2023-06-0620230023
16090000055283L16/questions_ecrites1616090000055279160900000552791JO_QUESTION2023-04-0420230014
16090000055346L16/questions_ecrites1616090000055342160900000553421JO_QUESTION2022-10-2520220042
16090000055347L16/questions_ecrites1616090000055342160900000553422JO_QUESTION2023-01-3120230005
16090000055438L16/questions_ecrites1616090000055434160900000554341JO_QUESTION2023-04-1120230015
16090000055488L16/questions_ecrites1616090000055484160900000554841JO_QUESTION2023-04-1120230015
16090000055544L16/questions_ecrites1616090000055539160900000555391JO_QUESTION2023-06-2720230026
16090000055545L16/questions_ecrites1616090000055539160900000555392JO_QUESTION2023-10-1720230042
16090000055546L16/questions_ecrites1616090000055539160900000555393JO_QUESTION2024-01-2320240004
16090000055547L16/questions_ecrites1616090000055539160900000555394JO_QUESTION2024-06-1120240024
16090000055631L16/questions_ecrites1616090000055627160900000556271JO_QUESTION2023-04-2520230017
16090000055689L16/questions_ecrites1616090000055685160900000556851JO_QUESTION2023-05-0220230018
16090000055699L16/questions_ecrites1616090000055694160900000556941JO_QUESTION2023-04-1820230016
16090000055774L16/questions_ecrites1616090000055766160900000557661JO_QUESTION2024-01-2320240004
16090000055824L16/questions_ecrites1616090000055819160900000558191JO_QUESTION2023-05-3020230022
16090000055829L16/questions_ecrites1616090000055825160900000558251JO_QUESTION2023-06-2720230026
16090000055854L16/questions_ecrites1616090000055850160900000558501JO_QUESTION2022-11-1520220045