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
17090000041073L17/questions_ecrites1717090000041068170900000410681JO_QUESTION2025-02-2520250008
17090000041111L17/questions_ecrites1717090000041106170900000411061JO_QUESTION2025-03-0420250009
17090000041146L17/questions_ecrites1717090000041141170900000411411JO_QUESTION2025-03-1820250011
17090000041165L17/questions_ecrites1717090000041157170900000411571JO_QUESTION2025-03-2520250012
17090000041166L17/questions_ecrites1717090000041157170900000411572JO_QUESTION2025-07-2220250029
17090000041167L17/questions_ecrites1717090000041157170900000411573JO_QUESTION2025-11-0420250044
17090000041168L17/questions_ecrites1717090000041157170900000411574JO_QUESTION2026-04-2120260016
17090000041169L17/questions_ecrites1717090000041157170900000411575JO_QUESTION2026-08-0420260031
17090000041176L17/questions_ecrites1717090000041170170900000411701JO_QUESTION2025-02-2520250008
17090000041200L17/questions_ecrites1717090000041195170900000411951JO_QUESTION2025-02-2520250008
17090000041251L17/questions_ecrites1717090000041242170900000412421JO_QUESTION2025-12-0220250048
17090000041261L17/questions_ecrites1717090000041252170900000412521JO_QUESTION2025-03-2520250012
17090000041262L17/questions_ecrites1717090000041252170900000412522JO_QUESTION2025-07-2220250029
17090000041263L17/questions_ecrites1717090000041252170900000412523JO_QUESTION2025-11-0420250044
17090000041317L17/questions_ecrites1717090000041311170900000413111JO_QUESTION2025-10-2120250042
17090000041360L17/questions_ecrites1717090000041355170900000413551JO_QUESTION2025-03-1120250010
17090000041418L17/questions_ecrites1717090000041413170900000414131JO_QUESTION2025-01-2820250004
17090000041449L17/questions_ecrites1717090000041443170900000414431JO_QUESTION2025-04-0120250013
17090000041450L17/questions_ecrites1717090000041443170900000414432JO_QUESTION2025-10-2120250042
17090000041451L17/questions_ecrites1717090000041443170900000414433JO_QUESTION2026-06-2320260025
17090000041484L17/questions_ecrites1717090000041476170900000414761JO_QUESTION2025-03-1820250011
17090000041485L17/questions_ecrites1717090000041476170900000414762JO_QUESTION2026-05-2620260021
17090000041530L17/questions_ecrites1717090000041524170900000415241JO_QUESTION2025-03-1120250010
17090000041531L17/questions_ecrites1717090000041524170900000415242JO_QUESTION2025-06-2420250025
17090000041543L17/questions_ecrites1717090000041537170900000415371JO_QUESTION2025-03-0420250009
17090000041544L17/questions_ecrites1717090000041537170900000415372JO_QUESTION2025-06-1020250023
17090000041550L17/questions_ecrites1717090000041545170900000415451JO_QUESTION2025-03-1120250010
17090000041551L17/questions_ecrites1717090000041545170900000415452JO_QUESTION2025-06-1720250024
17090000041560L17/questions_ecrites1717090000041552170900000415521JO_QUESTION2025-03-1820250011
17090000041561L17/questions_ecrites1717090000041552170900000415522JO_QUESTION2026-05-2620260021
17090000041632L17/questions_ecrites1717090000041626170900000416261JO_QUESTION2025-03-1120250010
17090000041641L17/questions_ecrites1717090000041633170900000416331JO_QUESTION2026-06-2320260025
17090000041649L17/questions_ecrites1717090000041642170900000416421JO_QUESTION2025-07-0820250027
17090000041700L17/questions_ecrites1717090000041695170900000416951JO_QUESTION2025-03-0420250009
17090000041775L17/questions_ecrites1717090000041770170900000417701JO_QUESTION2025-03-1820250011
17090000041796L17/questions_ecrites1717090000041791170900000417911JO_QUESTION2025-03-0420250009
17090000041807L17/questions_ecrites1717090000041802170900000418021JO_QUESTION2025-05-2720250021
17090000041821L17/questions_ecrites1717090000041813170900000418131JO_QUESTION2025-01-2120250003
17090000041822L17/questions_ecrites1717090000041813170900000418132JO_QUESTION2025-05-2720250021
17090000041838L17/questions_ecrites1717090000041833170900000418331JO_QUESTION2025-05-0620250018
17090000041846L17/questions_ecrites1717090000041839170900000418391JO_QUESTION2025-03-0420250009
17090000041847L17/questions_ecrites1717090000041839170900000418392JO_QUESTION2025-06-1020250023
17090000041848L17/questions_ecrites1717090000041839170900000418393JO_QUESTION2025-09-3020250039
17090000041893L17/questions_ecrites1717090000041887170900000418871JO_QUESTION2025-04-1520250015
17090000041913L17/questions_ecrites1717090000041907170900000419071JO_QUESTION2025-11-1820250046
17090000041914L17/questions_ecrites1717090000041907170900000419072JO_QUESTION2026-09-0120260035
17090000041943L17/questions_ecrites1717090000041937170900000419371JO_QUESTION2025-03-0420250009
17090000041962L17/questions_ecrites1717090000041957170900000419571JO_QUESTION2025-03-2520250012
17090000041973L17/questions_ecrites1717090000041967170900000419671JO_QUESTION2025-03-0420250009
17090000041986L17/questions_ecrites1717090000041981170900000419811JO_QUESTION2025-03-0420250009