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
17090000048968L17/questions_ecrites1717090000048963170900000489631JO_QUESTION2025-05-0620250018
17090000049035L17/questions_ecrites1717090000049030170900000490301JO_QUESTION2025-05-0620250018
17090000049036L17/questions_ecrites1717090000049030170900000490302JO_QUESTION2025-10-2120250042
17090000049037L17/questions_ecrites1717090000049030170900000490303JO_QUESTION2026-04-2120260016
17090000049056L17/questions_ecrites1717090000049051170900000490511JO_QUESTION2025-05-0620250018
17090000049086L17/questions_ecrites1717090000049080170900000490801JO_QUESTION2025-05-2720250021
17090000049087L17/questions_ecrites1717090000049080170900000490802JO_QUESTION2026-03-3120260013
17090000049088L17/questions_ecrites1717090000049080170900000490803JO_QUESTION2026-07-1420260028
17090000049176L17/questions_ecrites1717090000049171170900000491711JO_QUESTION2025-05-0620250018
17090000049214L17/questions_ecrites1717090000049210170900000492101JO_QUESTION2025-06-0320250022
17090000049240L17/questions_ecrites1717090000049236170900000492361JO_QUESTION2025-05-0620250018
17090000049324L17/questions_ecrites1717090000049320170900000493201JO_QUESTION2025-05-1320250019
17090000049331L17/questions_ecrites1717090000049325170900000493251JO_QUESTION2025-07-2220250029
17090000049353L17/questions_ecrites1717090000049348170900000493481JO_QUESTION2025-05-0620250018
17090000049371L17/questions_ecrites1717090000049364170900000493641JO_QUESTION2026-05-0520260018
17090000049437L17/questions_ecrites1717090000049433170900000494331JO_QUESTION2025-05-0620250018
17090000049448L17/questions_ecrites1717090000049443170900000494431JO_QUESTION2025-05-0620250018
17090000049500L17/questions_ecrites1717090000049495170900000494951JO_QUESTION2025-05-0620250018
17090000049501L17/questions_ecrites1717090000049495170900000494952JO_QUESTION2026-06-1620260024
17090000049582L17/questions_ecrites1717090000049578170900000495781JO_QUESTION2025-05-2020250020
17090000049681L17/questions_ecrites1717090000049677170900000496771JO_QUESTION2025-06-0320250022
17090000049805L17/questions_ecrites1717090000049799170900000497991JO_QUESTION2025-06-0320250022
17090000049819L17/questions_ecrites1717090000049815170900000498151JO_QUESTION2025-05-1320250019
17090000049863L17/questions_ecrites1717090000049858170900000498581JO_QUESTION2025-01-0720250001
17090000049885L17/questions_ecrites1717090000049880170900000498801JO_QUESTION2025-05-1320250019
17090000049886L17/questions_ecrites1717090000049880170900000498802JO_QUESTION2025-09-0920250036
17090000049887L17/questions_ecrites1717090000049880170900000498803JO_QUESTION2026-02-0320260005
17090000049894L17/questions_ecrites1717090000049888170900000498881JO_QUESTION2025-09-3020250039
17090000049895L17/questions_ecrites1717090000049888170900000498882JO_QUESTION2026-01-2720260004
17090000049914L17/questions_ecrites1717090000049907170900000499071JO_QUESTION2025-05-2020250020
17090000049915L17/questions_ecrites1717090000049907170900000499072JO_QUESTION2025-09-2320250038
17090000049916L17/questions_ecrites1717090000049907170900000499073JO_QUESTION2026-05-1920260020
17090000049995L17/questions_ecrites1717090000049988170900000499881JO_QUESTION2025-05-2020250020
17090000049996L17/questions_ecrites1717090000049988170900000499882JO_QUESTION2025-09-2320250038
17090000050004L17/questions_ecrites1717090000049997170900000499971JO_QUESTION2025-05-2020250020
17090000050040L17/questions_ecrites1717090000050035170900000500351JO_QUESTION2025-01-0720250001
17090000050064L17/questions_ecrites1717090000050060170900000500601JO_QUESTION2025-05-0620250018
17090000050153L17/questions_ecrites1717090000050147170900000501471JO_QUESTION2025-01-2120250003
17090000050217L17/questions_ecrites1717090000050210170900000502101JO_QUESTION2025-09-2320250038
17090000050244L17/questions_ecrites1717090000050239170900000502391JO_QUESTION2025-05-2720250021
17090000050273L17/questions_ecrites1717090000050266170900000502661JO_QUESTION2025-06-1720250024
17090000050274L17/questions_ecrites1717090000050266170900000502662JO_QUESTION2025-11-1120250045
17090000050275L17/questions_ecrites1717090000050266170900000502663JO_QUESTION2026-02-2420260008
17090000050276L17/questions_ecrites1717090000050266170900000502664JO_QUESTION2026-08-1120260032
17090000050366L17/questions_ecrites1717090000050360170900000503601JO_QUESTION2025-06-0320250022
17090000050414L17/questions_ecrites1717090000050408170900000504081JO_QUESTION2025-08-0520250031
17090000050415L17/questions_ecrites1717090000050408170900000504082JO_QUESTION2025-11-1120250045
17090000050475L17/questions_ecrites1717090000050469170900000504691JO_QUESTION2025-06-1720250024
17090000050476L17/questions_ecrites1717090000050469170900000504692JO_QUESTION2025-10-2120250042
17090000050527L17/questions_ecrites1717090000050521170900000505211JO_QUESTION2025-05-1320250019