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
17090000047657L17/questions_ecrites1717090000047649170900000476493JO_QUESTION2025-12-1620250050
17090000047658L17/questions_ecrites1717090000047649170900000476494JO_QUESTION2026-03-2420260012
17090000047683L17/questions_ecrites1717090000047679170900000476791JO_QUESTION2025-04-2220250016
17090000047742L17/questions_ecrites1717090000047737170900000477371JO_QUESTION2025-05-2720250021
17090000047939L17/questions_ecrites1717090000047931170900000479311JO_QUESTION2025-01-2120250003
17090000047940L17/questions_ecrites1717090000047931170900000479312JO_QUESTION2025-04-2920250017
17090000047941L17/questions_ecrites1717090000047931170900000479313JO_QUESTION2025-08-0520250031
17090000047966L17/questions_ecrites1717090000047960170900000479601JO_QUESTION2025-04-2920250017
17090000048034L17/questions_ecrites1717090000048028170900000480281JO_QUESTION2025-10-2120250042
17090000048043L17/questions_ecrites1717090000048035170900000480351JO_QUESTION2026-05-0520260018
17090000048089L17/questions_ecrites1717090000048085170900000480851JO_QUESTION2025-05-0620250018
17090000048123L17/questions_ecrites1717090000048120170900000481201JO_QUESTION2025-05-0620250018
17090000048186L17/questions_ecrites1717090000048180170900000481801JO_QUESTION2025-07-2220250029
17090000048187L17/questions_ecrites1717090000048180170900000481802JO_QUESTION2026-05-1220260019
17090000048248L17/questions_ecrites1717090000048244170900000482441JO_QUESTION2025-05-0620250018
17090000048292L17/questions_ecrites1717090000048288170900000482881JO_QUESTION2025-05-0620250018
17090000048343L17/questions_ecrites1717090000048338170900000483381JO_QUESTION2025-03-1820250011
17090000048456L17/questions_ecrites1717090000048450170900000484501JO_QUESTION2026-05-2620260021
17090000048545L17/questions_ecrites1717090000048539170900000485391JO_QUESTION2025-05-2720250021
17090000048546L17/questions_ecrites1717090000048539170900000485392JO_QUESTION2026-01-2020260003
17090000048547L17/questions_ecrites1717090000048539170900000485393JO_QUESTION2026-05-0520260018
17090000048586L17/questions_ecrites1717090000048577170900000485771JO_QUESTION2025-05-0620250018
17090000048587L17/questions_ecrites1717090000048577170900000485772JO_QUESTION2025-09-0920250036
17090000048618L17/questions_ecrites1717090000048613170900000486131JO_QUESTION2025-10-2120250042
17090000048619L17/questions_ecrites1717090000048613170900000486132JO_QUESTION2026-09-1520260037
17090000048626L17/questions_ecrites1717090000048620170900000486201JO_QUESTION2025-01-0720250001
17090000048627L17/questions_ecrites1717090000048620170900000486202JO_QUESTION2025-06-1720250024
17090000048628L17/questions_ecrites1717090000048620170900000486203JO_QUESTION2025-10-2120250042
17090000048629L17/questions_ecrites1717090000048620170900000486204JO_QUESTION2026-02-1720260007
17090000048642L17/questions_ecrites1717090000048637170900000486371JO_QUESTION2026-01-1320260002
17090000048654L17/questions_ecrites1717090000048648170900000486481JO_QUESTION2025-05-0620250018
17090000048655L17/questions_ecrites1717090000048648170900000486482JO_QUESTION2025-09-0220250035
17090000048656L17/questions_ecrites1717090000048648170900000486483JO_QUESTION2025-12-1620250050
17090000048657L17/questions_ecrites1717090000048648170900000486484JO_QUESTION2026-03-2420260012
17090000048658L17/questions_ecrites1717090000048648170900000486485JO_QUESTION2026-06-3020260026
17090000048666L17/questions_ecrites1717090000048659170900000486591JO_QUESTION2025-05-2020250020
17090000048667L17/questions_ecrites1717090000048659170900000486592JO_QUESTION2025-09-3020250039
17090000048720L17/questions_ecrites1717090000048715170900000487151JO_QUESTION2025-05-2720250021
17090000048857L17/questions_ecrites1717090000048851170900000488511JO_QUESTION2025-05-2020250020
17090000048858L17/questions_ecrites1717090000048851170900000488512JO_QUESTION2025-09-2320250038
17090000048859L17/questions_ecrites1717090000048851170900000488513JO_QUESTION2026-05-1920260020
17090000048860L17/questions_ecrites1717090000048851170900000488514JO_QUESTION2026-09-1520260037
17090000048891L17/questions_ecrites1717090000048884170900000488841JO_QUESTION2025-01-2120250003
17090000048936L17/questions_ecrites1717090000048932170900000489321JO_QUESTION2025-05-0620250018
17090000048942L17/questions_ecrites1717090000048937170900000489371JO_QUESTION2025-05-1320250019
17090000048943L17/questions_ecrites1717090000048937170900000489372JO_QUESTION2025-08-1920250033
17090000048944L17/questions_ecrites1717090000048937170900000489373JO_QUESTION2025-11-2520250047
17090000048945L17/questions_ecrites1717090000048937170900000489374JO_QUESTION2026-03-1020260010
17090000048946L17/questions_ecrites1717090000048937170900000489375JO_QUESTION2026-06-1620260024
17090000048947L17/questions_ecrites1717090000048937170900000489376JO_QUESTION2026-09-2220260038