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
17090000074848L17/questions_ecrites1717090000074841170900000748412JO_QUESTION2026-01-2720260004
17090000074849L17/questions_ecrites1717090000074841170900000748413JO_QUESTION2026-05-0520260018
17090000074930L17/questions_ecrites1717090000074924170900000749241JO_QUESTION2026-06-1620260024
17090000074990L17/questions_ecrites1717090000074985170900000749851JO_QUESTION2026-01-1320260002
17090000074991L17/questions_ecrites1717090000074985170900000749852JO_QUESTION2026-09-1520260037
17090000075003L17/questions_ecrites1717090000074998170900000749981JO_QUESTION2025-12-0220250048
17090000075004L17/questions_ecrites1717090000074998170900000749982JO_QUESTION2026-05-1220260019
17090000075015L17/questions_ecrites1717090000075009170900000750091JO_QUESTION2025-10-2820250043
17090000075117L17/questions_ecrites1717090000075111170900000751111JO_QUESTION2025-09-3020250039
17090000075255L17/questions_ecrites1717090000075249170900000752491JO_QUESTION2025-09-3020250039
17090000075256L17/questions_ecrites1717090000075249170900000752492JO_QUESTION2026-01-2720260004
17090000075257L17/questions_ecrites1717090000075249170900000752493JO_QUESTION2026-06-0220260022
17090000075258L17/questions_ecrites1717090000075249170900000752494JO_QUESTION2026-09-0820260036
17090000075273L17/questions_ecrites1717090000075267170900000752671JO_QUESTION2025-11-1120250045
17090000075294L17/questions_ecrites1717090000075287170900000752871JO_QUESTION2025-01-2120250003
17090000075295L17/questions_ecrites1717090000075287170900000752872JO_QUESTION2025-04-2920250017
17090000075296L17/questions_ecrites1717090000075287170900000752873JO_QUESTION2025-08-0520250031
17090000075297L17/questions_ecrites1717090000075287170900000752874JO_QUESTION2025-11-1120250045
17090000075333L17/questions_ecrites1717090000075326170900000753261JO_QUESTION2025-11-0420250044
17090000075357L17/questions_ecrites1717090000075350170900000753501JO_QUESTION2025-11-0420250044
17090000075455L17/questions_ecrites1717090000075449170900000754491JO_QUESTION2025-09-3020250039
17090000075456L17/questions_ecrites1717090000075449170900000754492JO_QUESTION2026-01-0620260001
17090000075557L17/questions_ecrites1717090000075550170900000755501JO_QUESTION2025-01-2120250003
17090000075558L17/questions_ecrites1717090000075550170900000755502JO_QUESTION2025-04-2920250017
17090000075559L17/questions_ecrites1717090000075550170900000755503JO_QUESTION2025-08-0520250031
17090000075560L17/questions_ecrites1717090000075550170900000755504JO_QUESTION2025-11-1120250045
17090000075561L17/questions_ecrites1717090000075550170900000755505JO_QUESTION2026-02-1720260007
17090000075562L17/questions_ecrites1717090000075550170900000755506JO_QUESTION2026-05-2620260021
17090000075563L17/questions_ecrites1717090000075550170900000755507JO_QUESTION2026-09-0120260035
17090000075585L17/questions_ecrites1717090000075579170900000755791JO_QUESTION2025-09-3020250039
17090000075633L17/questions_ecrites1717090000075625170900000756251JO_QUESTION2025-11-0420250044
17090000075640L17/questions_ecrites1717090000075634170900000756341JO_QUESTION2025-02-0420250005
17090000075649L17/questions_ecrites1717090000075641170900000756411JO_QUESTION2025-09-3020250039
17090000075650L17/questions_ecrites1717090000075641170900000756412JO_QUESTION2026-01-0620260001
17090000075651L17/questions_ecrites1717090000075641170900000756413JO_QUESTION2026-04-1420260015
17090000075674L17/questions_ecrites1717090000075669170900000756691JO_QUESTION2026-07-2820260030
17090000075686L17/questions_ecrites1717090000075681170900000756811JO_QUESTION2026-07-2820260030
17090000075699L17/questions_ecrites1717090000075693170900000756931JO_QUESTION2025-10-2120250042
17090000075700L17/questions_ecrites1717090000075693170900000756932JO_QUESTION2026-01-2720260004
17090000075756L17/questions_ecrites1717090000075751170900000757511JO_QUESTION2025-09-3020250039
17090000075763L17/questions_ecrites1717090000075757170900000757571JO_QUESTION2025-11-2520250047
17090000075770L17/questions_ecrites1717090000075764170900000757641JO_QUESTION2026-04-1420260015
17090000075867L17/questions_ecrites1717090000075861170900000758611JO_QUESTION2025-09-3020250039
17090000075883L17/questions_ecrites1717090000075877170900000758771JO_QUESTION2025-11-2520250047
17090000075884L17/questions_ecrites1717090000075877170900000758772JO_QUESTION2026-07-1420260028
17090000076039L17/questions_ecrites1717090000076033170900000760331JO_QUESTION2025-10-2120250042
17090000076103L17/questions_ecrites1717090000076097170900000760971JO_QUESTION2025-11-0420250044
17090000076111L17/questions_ecrites1717090000076104170900000761041JO_QUESTION2025-10-2820250043
17090000076112L17/questions_ecrites1717090000076104170900000761042JO_QUESTION2026-02-1020260006
17090000076197L17/questions_ecrites1717090000076191170900000761911JO_QUESTION2025-10-2120250042