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
17090000077648L17/questions_ecrites1717090000077642170900000776421JO_QUESTION2025-10-2120250042
17090000077666L17/questions_ecrites1717090000077660170900000776601JO_QUESTION2025-12-0220250048
17090000077679L17/questions_ecrites1717090000077673170900000776731JO_QUESTION2025-10-2820250043
17090000077680L17/questions_ecrites1717090000077673170900000776732JO_QUESTION2026-02-1020260006
17090000077681L17/questions_ecrites1717090000077673170900000776733JO_QUESTION2026-05-1220260019
17090000077682L17/questions_ecrites1717090000077673170900000776734JO_QUESTION2026-08-2520260034
17090000077700L17/questions_ecrites1717090000077694170900000776941JO_QUESTION2026-01-2720260004
17090000077714L17/questions_ecrites1717090000077707170900000777071JO_QUESTION2025-12-0220250048
17090000077810L17/questions_ecrites1717090000077803170900000778031JO_QUESTION2026-07-2120260029
17090000077988L17/questions_ecrites1717090000077982170900000779821JO_QUESTION2025-12-0220250048
17090000078076L17/questions_ecrites1717090000078067170900000780671JO_QUESTION2025-07-2220250029
17090000078204L17/questions_ecrites1717090000078198170900000781981JO_QUESTION2025-12-0220250048
17090000078222L17/questions_ecrites1717090000078216170900000782161JO_QUESTION2025-10-2120250042
17090000078251L17/questions_ecrites1717090000078245170900000782451JO_QUESTION2025-10-2120250042
17090000078252L17/questions_ecrites1717090000078245170900000782452JO_QUESTION2026-01-2720260004
17090000078280L17/questions_ecrites1717090000078272170900000782721JO_QUESTION2026-01-2020260003
17090000078290L17/questions_ecrites1717090000078285170900000782851JO_QUESTION2025-11-0420250044
17090000078291L17/questions_ecrites1717090000078285170900000782852JO_QUESTION2026-06-1620260024
17090000078317L17/questions_ecrites1717090000078312170900000783121JO_QUESTION2026-05-2620260021
17090000078348L17/questions_ecrites1717090000078342170900000783421JO_QUESTION2025-02-2520250008
17090000078365L17/questions_ecrites1717090000078359170900000783591JO_QUESTION2025-10-2820250043
17090000078380L17/questions_ecrites1717090000078374170900000783741JO_QUESTION2025-12-0220250048
17090000078381L17/questions_ecrites1717090000078374170900000783742JO_QUESTION2026-05-1220260019
17090000078427L17/questions_ecrites1717090000078422170900000784221JO_QUESTION2025-12-0220250048
17090000078428L17/questions_ecrites1717090000078422170900000784222JO_QUESTION2026-05-1220260019
17090000078511L17/questions_ecrites1717090000078504170900000785041JO_QUESTION2025-10-2120250042
17090000078595L17/questions_ecrites1717090000078588170900000785881JO_QUESTION2026-06-3020260026
17090000078611L17/questions_ecrites1717090000078604170900000786041JO_QUESTION2026-05-0520260018
17090000078778L17/questions_ecrites1717090000078772170900000787721JO_QUESTION2026-01-2020260003
17090000078779L17/questions_ecrites1717090000078772170900000787722JO_QUESTION2026-05-0520260018
17090000078911L17/questions_ecrites1717090000078905170900000789051JO_QUESTION2026-07-2120260029
17090000078999L17/questions_ecrites1717090000078992170900000789921JO_QUESTION2025-10-2120250042
17090000079028L17/questions_ecrites1717090000079022170900000790221JO_QUESTION2025-10-2120250042
17090000079034L17/questions_ecrites1717090000079029170900000790291JO_QUESTION2025-01-2820250004
17090000079202L17/questions_ecrites1717090000079195170900000791951JO_QUESTION2026-04-1420260015
17090000079299L17/questions_ecrites1717090000079294170900000792941JO_QUESTION2026-07-2120260029
17090000079358L17/questions_ecrites1717090000079353170900000793531JO_QUESTION2025-10-2120250042
17090000079359L17/questions_ecrites1717090000079353170900000793532JO_QUESTION2026-09-1520260037
17090000079386L17/questions_ecrites1717090000079378170900000793781JO_QUESTION2025-11-2520250047
17090000079601L17/questions_ecrites1717090000079595170900000795951JO_QUESTION2025-10-2820250043
17090000079608L17/questions_ecrites1717090000079602170900000796021JO_QUESTION2026-02-1720260007
17090000079629L17/questions_ecrites1717090000079623170900000796231JO_QUESTION2025-12-0220250048
17090000079643L17/questions_ecrites1717090000079637170900000796371JO_QUESTION2025-10-2820250043
17090000079663L17/questions_ecrites1717090000079655170900000796551JO_QUESTION2025-10-2120250042
17090000079675L17/questions_ecrites1717090000079668170900000796681JO_QUESTION2025-11-2520250047
17090000079749L17/questions_ecrites1717090000079744170900000797441JO_QUESTION2025-02-1820250007
17090000079813L17/questions_ecrites1717090000079805170900000798051JO_QUESTION2025-04-0820250014
17090000079843L17/questions_ecrites1717090000079837170900000798371JO_QUESTION2025-10-2120250042
17090000079878L17/questions_ecrites1717090000079873170900000798731JO_QUESTION2025-02-0420250005
17090000079934L17/questions_ecrites1717090000079928170900000799281JO_QUESTION2025-10-2120250042