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
17090000044370L17/questions_ecrites1717090000044360170900000443605JO_QUESTION2026-05-1220260019
17090000044371L17/questions_ecrites1717090000044360170900000443606JO_QUESTION2026-09-1520260037
17090000044388L17/questions_ecrites1717090000044381170900000443811JO_QUESTION2025-05-2720250021
17090000044394L17/questions_ecrites1717090000044389170900000443891JO_QUESTION2025-04-0820250014
17090000044542L17/questions_ecrites1717090000044537170900000445371JO_QUESTION2025-03-1820250011
17090000044556L17/questions_ecrites1717090000044548170900000445481JO_QUESTION2025-05-2020250020
17090000044637L17/questions_ecrites1717090000044627170900000446271JO_QUESTION2025-07-0120250026
17090000044694L17/questions_ecrites1717090000044688170900000446881JO_QUESTION2025-01-2820250004
17090000044820L17/questions_ecrites1717090000044813170900000448131JO_QUESTION2025-03-2520250012
17090000044853L17/questions_ecrites1717090000044848170900000448481JO_QUESTION2025-05-2720250021
17090000044925L17/questions_ecrites1717090000044918170900000449181JO_QUESTION2025-03-1820250011
17090000044932L17/questions_ecrites1717090000044926170900000449261JO_QUESTION2025-03-1820250011
17090000044977L17/questions_ecrites1717090000044972170900000449721JO_QUESTION2025-03-1820250011
17090000045003L17/questions_ecrites1717090000044998170900000449981JO_QUESTION2025-03-1820250011
17090000045009L17/questions_ecrites1717090000045004170900000450041JO_QUESTION2025-03-1820250011
17090000045010L17/questions_ecrites1717090000045004170900000450042JO_QUESTION2025-06-2420250025
17090000045065L17/questions_ecrites1717090000045060170900000450601JO_QUESTION2025-05-0620250018
17090000045126L17/questions_ecrites1717090000045120170900000451201JO_QUESTION2025-03-1820250011
17090000045161L17/questions_ecrites1717090000045155170900000451551JO_QUESTION2025-01-2820250004
17090000045229L17/questions_ecrites1717090000045223170900000452231JO_QUESTION2025-01-2120250003
17090000045230L17/questions_ecrites1717090000045223170900000452232JO_QUESTION2025-04-2920250017
17090000045238L17/questions_ecrites1717090000045231170900000452311JO_QUESTION2025-05-1320250019
17090000045239L17/questions_ecrites1717090000045231170900000452312JO_QUESTION2025-09-1620250037
17090000045240L17/questions_ecrites1717090000045231170900000452313JO_QUESTION2026-01-2020260003
17090000045271L17/questions_ecrites1717090000045266170900000452661JO_QUESTION2025-03-1820250011
17090000045284L17/questions_ecrites1717090000045277170900000452771JO_QUESTION2025-05-1320250019
17090000045313L17/questions_ecrites1717090000045308170900000453081JO_QUESTION2025-03-1820250011
17090000045314L17/questions_ecrites1717090000045308170900000453082JO_QUESTION2025-06-2420250025
17090000045322L17/questions_ecrites1717090000045315170900000453151JO_QUESTION2025-05-1320250019
17090000045337L17/questions_ecrites1717090000045332170900000453321JO_QUESTION2025-03-1820250011
17090000045343L17/questions_ecrites1717090000045338170900000453381JO_QUESTION2025-04-1520250015
17090000045412L17/questions_ecrites1717090000045406170900000454061JO_QUESTION2025-04-1520250015
17090000045413L17/questions_ecrites1717090000045406170900000454062JO_QUESTION2025-07-2220250029
17090000045414L17/questions_ecrites1717090000045406170900000454063JO_QUESTION2025-10-2820250043
17090000045415L17/questions_ecrites1717090000045406170900000454064JO_QUESTION2026-02-0320260005
17090000045416L17/questions_ecrites1717090000045406170900000454065JO_QUESTION2026-05-1220260019
17090000045417L17/questions_ecrites1717090000045406170900000454066JO_QUESTION2026-09-0120260035
17090000045526L17/questions_ecrites1717090000045521170900000455211JO_QUESTION2025-04-1520250015
17090000045539L17/questions_ecrites1717090000045534170900000455341JO_QUESTION2025-03-2520250012
17090000045770L17/questions_ecrites1717090000045761170900000457611JO_QUESTION2025-12-0220250048
17090000045771L17/questions_ecrites1717090000045761170900000457612JO_QUESTION2026-05-1220260019
17090000045884L17/questions_ecrites1717090000045878170900000458781JO_QUESTION2025-03-2520250012
17090000045898L17/questions_ecrites1717090000045893170900000458931JO_QUESTION2025-03-2520250012
17090000045909L17/questions_ecrites1717090000045904170900000459041JO_QUESTION2025-04-1520250015
17090000045927L17/questions_ecrites1717090000045920170900000459201JO_QUESTION2025-07-2220250029
17090000045935L17/questions_ecrites1717090000045928170900000459281JO_QUESTION2025-05-0620250018
17090000045936L17/questions_ecrites1717090000045928170900000459282JO_QUESTION2025-09-3020250039
17090000045937L17/questions_ecrites1717090000045928170900000459283JO_QUESTION2026-01-1320260002
17090000045938L17/questions_ecrites1717090000045928170900000459284JO_QUESTION2026-04-2120260016
17090000045939L17/questions_ecrites1717090000045928170900000459285JO_QUESTION2026-07-2820260030