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
17090000016867L17/questions_ecrites1717090000016862170900000168621JO_QUESTION2025-04-0120250013
17090000016908L17/questions_ecrites1717090000016903170900000169031JO_QUESTION2025-01-2820250004
17090000016959L17/questions_ecrites1717090000016954170900000169541JO_QUESTION2025-02-2520250008
17090000017032L17/questions_ecrites1717090000017027170900000170271JO_QUESTION2026-06-1620260024
17090000017078L17/questions_ecrites1717090000017075170900000170751JO_QUESTION2026-09-1520260037
17090000017187L17/questions_ecrites1717090000017181170900000171811JO_QUESTION2025-04-0820250014
17090000017188L17/questions_ecrites1717090000017181170900000171812JO_QUESTION2025-12-1620250050
17090000017238L17/questions_ecrites1717090000017231170900000172311JO_QUESTION2025-01-2820250004
17090000017239L17/questions_ecrites1717090000017231170900000172312JO_QUESTION2025-05-0620250018
17090000017240L17/questions_ecrites1717090000017231170900000172313JO_QUESTION2025-12-1620250050
17090000017246L17/questions_ecrites1717090000017241170900000172411JO_QUESTION2026-06-1620260024
17090000017270L17/questions_ecrites1717090000017266170900000172661JO_QUESTION2026-06-1620260024
17090000017271L17/questions_ecrites1717090000017266170900000172662JO_QUESTION2026-09-2220260038
17090000017294L17/questions_ecrites1717090000017288170900000172881JO_QUESTION2025-01-2820250004
17090000017295L17/questions_ecrites1717090000017288170900000172882JO_QUESTION2025-05-0620250018
17090000017296L17/questions_ecrites1717090000017288170900000172883JO_QUESTION2025-12-1620250050
17090000017297L17/questions_ecrites1717090000017288170900000172884JO_QUESTION2026-03-3120260013
17090000017298L17/questions_ecrites1717090000017288170900000172885JO_QUESTION2026-07-1420260028
17090000017329L17/questions_ecrites1717090000017326170900000173261JO_QUESTION2026-07-2120260029
17090000017344L17/questions_ecrites1717090000017341170900000173411JO_QUESTION2026-06-1620260024
17090000017363L17/questions_ecrites1717090000017360170900000173601JO_QUESTION2026-06-1620260024
17090000017364L17/questions_ecrites1717090000017360170900000173602JO_QUESTION2026-09-2220260038
17090000017430L17/questions_ecrites1717090000017425170900000174251JO_QUESTION2026-06-1620260024
17090000017479L17/questions_ecrites1717090000017474170900000174741JO_QUESTION2025-02-1120250006
17090000017487L17/questions_ecrites1717090000017484170900000174841JO_QUESTION2026-06-1620260024
17090000017512L17/questions_ecrites1717090000017509170900000175091JO_QUESTION2026-06-2320260025
17090000017516L17/questions_ecrites1717090000017513170900000175131JO_QUESTION2026-06-1620260024
17090000017525L17/questions_ecrites1717090000017522170900000175221JO_QUESTION2026-09-1520260037
17090000017529L17/questions_ecrites1717090000017526170900000175261JO_QUESTION2026-06-1620260024
17090000017557L17/questions_ecrites1717090000017554170900000175541JO_QUESTION2026-06-1620260024
17090000017558L17/questions_ecrites1717090000017554170900000175542JO_QUESTION2026-09-2220260038
17090000017568L17/questions_ecrites1717090000017564170900000175641JO_QUESTION2026-06-1620260024
17090000017569L17/questions_ecrites1717090000017564170900000175642JO_QUESTION2026-09-2220260038
17090000017635L17/questions_ecrites1717090000017631170900000176311JO_QUESTION2026-08-1120260032
17090000017642L17/questions_ecrites1717090000017639170900000176391JO_QUESTION2026-06-3020260026
17090000017699L17/questions_ecrites1717090000017695170900000176951JO_QUESTION2026-06-2320260025
17090000017700L17/questions_ecrites1717090000017695170900000176952JO_QUESTION2026-09-2920260039
17090000017824L17/questions_ecrites1717090000017820170900000178201JO_QUESTION2026-07-1420260028
17090000017839L17/questions_ecrites1717090000017836170900000178361JO_QUESTION2026-09-0120260035
17090000017849L17/questions_ecrites1717090000017844170900000178441JO_QUESTION2025-02-1120250006
17090000017958L17/questions_ecrites1717090000017953170900000179531JO_QUESTION2026-06-3020260026
17090000018120L17/questions_ecrites1717090000018114170900000181141JO_QUESTION2025-02-1120250006
17090000018121L17/questions_ecrites1717090000018114170900000181142JO_QUESTION2025-06-1720250024
17090000018122L17/questions_ecrites1717090000018114170900000181143JO_QUESTION2025-09-3020250039
17090000018123L17/questions_ecrites1717090000018114170900000181144JO_QUESTION2026-02-1020260006
17090000018124L17/questions_ecrites1717090000018114170900000181145JO_QUESTION2026-08-0420260031
17090000018143L17/questions_ecrites1717090000018140170900000181401JO_QUESTION2026-07-2120260029
17090000018163L17/questions_ecrites1717090000018160170900000181601JO_QUESTION2026-06-2320260025
17090000018164L17/questions_ecrites1717090000018160170900000181602JO_QUESTION2026-09-2920260039
17090000018211L17/questions_ecrites1717090000018207170900000182071JO_QUESTION2026-07-2820260030