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
16090000055855L16/questions_ecrites1616090000055850160900000558502JO_QUESTION2023-02-2820230009
16090000055856L16/questions_ecrites1616090000055850160900000558503JO_QUESTION2023-06-2020230025
16090000055861L16/questions_ecrites1616090000055857160900000558571JO_QUESTION2023-01-1720230003
16090000055869L16/questions_ecrites1616090000055862160900000558621JO_QUESTION2023-06-0620230023
16090000055882L16/questions_ecrites1616090000055878160900000558781JO_QUESTION2023-06-2720230026
16090000055941L16/questions_ecrites1616090000055934160900000559341JO_QUESTION2024-04-0220240014
16090000055970L16/questions_ecrites1616090000055966160900000559661JO_QUESTION2023-05-0220230018
16090000056046L16/questions_ecrites1616090000056041160900000560411JO_QUESTION2023-04-1820230016
16090000056058L16/questions_ecrites1616090000056052160900000560521JO_QUESTION2023-04-2520230017
16090000056059L16/questions_ecrites1616090000056052160900000560522JO_QUESTION2023-10-0320230040
16090000056074L16/questions_ecrites1616090000056070160900000560701JO_QUESTION2023-05-0220230018
16090000056111L16/questions_ecrites1616090000056103160900000561031JO_QUESTION2024-03-1920240012
16090000056226L16/questions_ecrites1616090000056222160900000562221JO_QUESTION2023-05-0220230018
16090000056269L16/questions_ecrites1616090000056262160900000562621JO_QUESTION2023-05-3020230022
16090000056292L16/questions_ecrites1616090000056285160900000562851JO_QUESTION2023-07-1820230029
16090000056293L16/questions_ecrites1616090000056285160900000562852JO_QUESTION2024-06-0420240023
16090000056302L16/questions_ecrites1616090000056298160900000562981JO_QUESTION2023-05-3020230022
16090000056365L16/questions_ecrites1616090000056361160900000563611JO_QUESTION2023-05-3020230022
16090000056396L16/questions_ecrites1616090000056390160900000563901JO_QUESTION2024-03-1220240011
16090000056435L16/questions_ecrites1616090000056431160900000564311JO_QUESTION2023-09-1920230038
16090000056436L16/questions_ecrites1616090000056431160900000564312JO_QUESTION2024-01-3020240005
16090000056437L16/questions_ecrites1616090000056431160900000564313JO_QUESTION2024-05-2120240021
16090000056442L16/questions_ecrites1616090000056438160900000564381JO_QUESTION2023-08-0120230031
16090000056447L16/questions_ecrites1616090000056443160900000564431JO_QUESTION2023-07-1820230029
16090000056467L16/questions_ecrites1616090000056462160900000564621JO_QUESTION2023-05-0920230019
16090000056468L16/questions_ecrites1616090000056462160900000564622JO_QUESTION2023-11-2120230047
16090000056475L16/questions_ecrites1616090000056469160900000564691JO_QUESTION2023-05-0220230018
16090000056489L16/questions_ecrites1616090000056484160900000564841JO_QUESTION2023-05-2320230021
16090000056592L16/questions_ecrites1616090000056588160900000565881JO_QUESTION2023-04-2520230017
16090000056718L16/questions_ecrites1616090000056714160900000567141JO_QUESTION2023-04-2520230017
16090000056758L16/questions_ecrites1616090000056753160900000567531JO_QUESTION2023-05-1620230020
16090000056821L16/questions_ecrites1616090000056815160900000568151JO_QUESTION2023-04-2520230017
16090000056848L16/questions_ecrites1616090000056842160900000568421JO_QUESTION2023-05-0220230018
16090000056849L16/questions_ecrites1616090000056842160900000568422JO_QUESTION2023-08-2920230035
16090000056850L16/questions_ecrites1616090000056842160900000568423JO_QUESTION2023-12-2620230052
16090000056851L16/questions_ecrites1616090000056842160900000568424JO_QUESTION2024-03-2620240013
16090000056879L16/questions_ecrites1616090000056875160900000568751JO_QUESTION2023-06-2720230026
16090000056903L16/questions_ecrites1616090000056897160900000568971JO_QUESTION2023-05-2320230021
16090000056908L16/questions_ecrites1616090000056904160900000569041JO_QUESTION2023-04-2520230017
16090000056932L16/questions_ecrites1616090000056928160900000569281JO_QUESTION2023-05-1620230020
16090000057045L16/questions_ecrites1616090000057040160900000570401JO_QUESTION2023-05-0220230018
16090000057046L16/questions_ecrites1616090000057040160900000570402JO_QUESTION2023-10-1720230042
16090000057083L16/questions_ecrites1616090000057079160900000570791JO_QUESTION2023-05-0220230018
16090000057117L16/questions_ecrites1616090000057113160900000571131JO_QUESTION2023-05-2320230021
16090000057141L16/questions_ecrites1616090000057136160900000571361JO_QUESTION2023-05-0920230019
16090000057298L16/questions_ecrites1616090000057294160900000572941JO_QUESTION2023-05-0220230018
16090000057384L16/questions_ecrites1616090000057379160900000573791JO_QUESTION2023-07-1820230029
16090000057465L16/questions_ecrites1616090000057459160900000574591JO_QUESTION2023-05-1620230020
16090000057466L16/questions_ecrites1616090000057459160900000574592JO_QUESTION2023-10-2420230043
16090000057467L16/questions_ecrites1616090000057459160900000574593JO_QUESTION2024-01-3020240005