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
17090000005781L17/questions_ecrites1717090000005776170900000057761JO_QUESTION2026-07-2120260029
17090000005795L17/questions_ecrites1717090000005787170900000057871JO_QUESTION2025-05-2720250021
17090000005886L17/questions_ecrites1717090000005883170900000058831JO_QUESTION2026-03-0320260009
17090000005887L17/questions_ecrites1717090000005883170900000058832JO_QUESTION2026-06-0920260023
17090000005888L17/questions_ecrites1717090000005883170900000058833JO_QUESTION2026-09-2220260038
17090000005906L17/questions_ecrites1717090000005900170900000059001JO_QUESTION2025-02-2520250008
17090000005919L17/questions_ecrites1717090000005915170900000059151JO_QUESTION2026-03-0320260009
17090000005983L17/questions_ecrites1717090000005980170900000059801JO_QUESTION2026-05-1220260019
17090000006002L17/questions_ecrites1717090000005996170900000059961JO_QUESTION2025-02-1120250006
17090000006003L17/questions_ecrites1717090000005996170900000059962JO_QUESTION2025-05-2020250020
17090000006007L17/questions_ecrites1717090000006004170900000060041JO_QUESTION2026-03-3120260013
17090000006008L17/questions_ecrites1717090000006004170900000060042JO_QUESTION2026-07-0720260027
17090000006040L17/questions_ecrites1717090000006036170900000060361JO_QUESTION2026-03-0320260009
17090000006049L17/questions_ecrites1717090000006045170900000060451JO_QUESTION2026-03-3120260013
17090000006077L17/questions_ecrites1717090000006073170900000060731JO_QUESTION2026-03-0320260009
17090000006088L17/questions_ecrites1717090000006084170900000060841JO_QUESTION2026-03-3120260013
17090000006102L17/questions_ecrites1717090000006097170900000060971JO_QUESTION2025-01-2820250004
17090000006123L17/questions_ecrites1717090000006120170900000061201JO_QUESTION2026-03-0320260009
17090000006133L17/questions_ecrites1717090000006127170900000061271JO_QUESTION2026-04-2120260016
17090000006150L17/questions_ecrites1717090000006145170900000061451JO_QUESTION2025-01-2820250004
17090000006164L17/questions_ecrites1717090000006159170900000061591JO_QUESTION2026-03-1020260010
17090000006165L17/questions_ecrites1717090000006159170900000061592JO_QUESTION2026-06-1620260024
17090000006166L17/questions_ecrites1717090000006159170900000061593JO_QUESTION2026-09-2220260038
17090000006291L17/questions_ecrites1717090000006288170900000062881JO_QUESTION2026-03-0320260009
17090000006338L17/questions_ecrites1717090000006333170900000063331JO_QUESTION2026-07-1420260028
17090000006450L17/questions_ecrites1717090000006446170900000064461JO_QUESTION2026-03-0320260009
17090000006474L17/questions_ecrites1717090000006471170900000064711JO_QUESTION2026-05-1920260020
17090000006475L17/questions_ecrites1717090000006471170900000064712JO_QUESTION2026-09-1520260037
17090000006486L17/questions_ecrites1717090000006483170900000064831JO_QUESTION2026-03-3120260013
17090000006487L17/questions_ecrites1717090000006483170900000064832JO_QUESTION2026-08-1120260032
17090000006500L17/questions_ecrites1717090000006496170900000064961JO_QUESTION2026-03-0320260009
17090000006532L17/questions_ecrites1717090000006527170900000065271JO_QUESTION2026-05-0520260018
17090000006538L17/questions_ecrites1717090000006533170900000065331JO_QUESTION2025-01-2820250004
17090000006550L17/questions_ecrites1717090000006547170900000065471JO_QUESTION2026-03-1020260010
17090000006551L17/questions_ecrites1717090000006547170900000065472JO_QUESTION2026-09-2220260038
17090000006723L17/questions_ecrites1717090000006720170900000067201JO_QUESTION2026-09-1520260037
17090000006867L17/questions_ecrites1717090000006860170900000068601JO_QUESTION2025-02-1120250006
17090000006925L17/questions_ecrites1717090000006921170900000069211JO_QUESTION2026-09-1520260037
17090000006937L17/questions_ecrites1717090000006933170900000069331JO_QUESTION2026-05-0520260018
17090000006960L17/questions_ecrites1717090000006955170900000069551JO_QUESTION2026-03-1020260010
17090000007028L17/questions_ecrites1717090000007023170900000070231JO_QUESTION2026-03-1020260010
17090000007085L17/questions_ecrites1717090000007081170900000070811JO_QUESTION2026-03-3120260013
17090000007124L17/questions_ecrites1717090000007121170900000071211JO_QUESTION2026-05-1920260020
17090000007308L17/questions_ecrites1717090000007303170900000073031JO_QUESTION2025-01-2820250004
17090000007313L17/questions_ecrites1717090000007309170900000073091JO_QUESTION2026-03-1020260010
17090000007314L17/questions_ecrites1717090000007309170900000073092JO_QUESTION2026-06-1620260024
17090000007315L17/questions_ecrites1717090000007309170900000073093JO_QUESTION2026-09-2220260038
17090000007344L17/questions_ecrites1717090000007340170900000073401JO_QUESTION2026-04-0720260014
17090000007365L17/questions_ecrites1717090000007362170900000073621JO_QUESTION2026-06-1620260024
17090000007406L17/questions_ecrites1717090000007401170900000074011JO_QUESTION2025-01-2820250004