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
17090000001055L17/questions_ecrites1717090000001049170900000010491JO_QUESTION2026-02-1020260006
17090000001129L17/questions_ecrites1717090000001124170900000011241JO_QUESTION2026-01-1320260002
17090000001130L17/questions_ecrites1717090000001124170900000011242JO_QUESTION2026-05-0520260018
17090000001131L17/questions_ecrites1717090000001124170900000011243JO_QUESTION2026-09-0120260035
17090000001156L17/questions_ecrites1717090000001150170900000011501JO_QUESTION2026-01-1320260002
17090000001157L17/questions_ecrites1717090000001150170900000011502JO_QUESTION2026-05-0520260018
17090000001158L17/questions_ecrites1717090000001150170900000011503JO_QUESTION2026-09-0120260035
17090000001166L17/questions_ecrites1717090000001159170900000011591JO_QUESTION2026-01-1320260002
17090000001193L17/questions_ecrites1717090000001186170900000011861JO_QUESTION2026-01-2720260004
17090000001259L17/questions_ecrites1717090000001254170900000012541JO_QUESTION2026-05-2620260021
17090000001303L17/questions_ecrites1717090000001298170900000012981JO_QUESTION2026-01-1320260002
17090000001304L17/questions_ecrites1717090000001298170900000012982JO_QUESTION2026-05-0520260018
17090000001305L17/questions_ecrites1717090000001298170900000012983JO_QUESTION2026-09-0120260035
17090000001341L17/questions_ecrites1717090000001336170900000013361JO_QUESTION2025-02-1120250006
17090000001384L17/questions_ecrites1717090000001379170900000013791JO_QUESTION2026-02-1020260006
17090000001448L17/questions_ecrites1717090000001444170900000014441JO_QUESTION2026-09-1520260037
17090000001457L17/questions_ecrites1717090000001453170900000014531JO_QUESTION2026-05-1920260020
17090000001458L17/questions_ecrites1717090000001453170900000014532JO_QUESTION2026-09-1520260037
17090000001474L17/questions_ecrites1717090000001470170900000014701JO_QUESTION2026-01-2720260004
17090000001475L17/questions_ecrites1717090000001470170900000014702JO_QUESTION2026-06-0220260022
17090000001507L17/questions_ecrites1717090000001502170900000015021JO_QUESTION2026-03-0320260009
17090000001538L17/questions_ecrites1717090000001531170900000015311JO_QUESTION2026-02-1020260006
17090000001585L17/questions_ecrites1717090000001579170900000015791JO_QUESTION2025-02-1120250006
17090000001604L17/questions_ecrites1717090000001600170900000016001JO_QUESTION2026-01-2720260004
17090000001605L17/questions_ecrites1717090000001600170900000016002JO_QUESTION2026-09-2220260038
17090000001622L17/questions_ecrites1717090000001616170900000016161JO_QUESTION2026-02-1020260006
17090000001640L17/questions_ecrites1717090000001635170900000016351JO_QUESTION2026-01-2020260003
17090000001641L17/questions_ecrites1717090000001635170900000016352JO_QUESTION2026-04-2820260017
17090000001642L17/questions_ecrites1717090000001635170900000016353JO_QUESTION2026-08-1120260032
17090000001648L17/questions_ecrites1717090000001643170900000016431JO_QUESTION2025-02-2520250008
17090000001696L17/questions_ecrites1717090000001690170900000016901JO_QUESTION2026-01-2720260004
17090000001712L17/questions_ecrites1717090000001707170900000017071JO_QUESTION2025-02-0420250005
17090000001749L17/questions_ecrites1717090000001745170900000017451JO_QUESTION2026-05-1920260020
17090000001750L17/questions_ecrites1717090000001745170900000017452JO_QUESTION2026-09-1520260037
17090000001882L17/questions_ecrites1717090000001878170900000018781JO_QUESTION2026-05-1220260019
17090000001919L17/questions_ecrites1717090000001914170900000019141JO_QUESTION2026-01-2720260004
17090000001995L17/questions_ecrites1717090000001990170900000019901JO_QUESTION2025-06-0320250022
17090000002059L17/questions_ecrites1717090000002056170900000020561JO_QUESTION2026-01-2720260004
17090000002060L17/questions_ecrites1717090000002056170900000020562JO_QUESTION2026-06-0220260022
17090000002061L17/questions_ecrites1717090000002056170900000020563JO_QUESTION2026-09-0820260036
17090000002066L17/questions_ecrites1717090000002062170900000020621JO_QUESTION2026-01-2720260004
17090000002097L17/questions_ecrites1717090000002094170900000020941JO_QUESTION2026-05-1220260019
17090000002227L17/questions_ecrites1717090000002224170900000022241JO_QUESTION2026-01-2720260004
17090000002238L17/questions_ecrites1717090000002232170900000022321JO_QUESTION2026-01-2720260004
17090000002296L17/questions_ecrites1717090000002293170900000022931JO_QUESTION2026-01-2720260004
17090000002312L17/questions_ecrites1717090000002306170900000023061JO_QUESTION2025-02-0420250005
17090000002399L17/questions_ecrites1717090000002396170900000023961JO_QUESTION2026-01-2720260004
17090000002400L17/questions_ecrites1717090000002396170900000023962JO_QUESTION2026-05-0520260018
17090000002401L17/questions_ecrites1717090000002396170900000023963JO_QUESTION2026-08-1120260032
17090000002413L17/questions_ecrites1717090000002407170900000024071JO_QUESTION2025-03-2520250012