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
17090000039966L17/questions_ecrites1717090000039958170900000399583JO_QUESTION2026-07-1420260028
17090000040009L17/questions_ecrites1717090000040002170900000400021JO_QUESTION2025-06-0320250022
17090000040010L17/questions_ecrites1717090000040002170900000400022JO_QUESTION2025-10-2820250043
17090000040086L17/questions_ecrites1717090000040081170900000400811JO_QUESTION2025-01-2820250004
17090000040144L17/questions_ecrites1717090000040135170900000401351JO_QUESTION2025-12-0220250048
17090000040161L17/questions_ecrites1717090000040155170900000401551JO_QUESTION2025-02-2520250008
17090000040162L17/questions_ecrites1717090000040155170900000401552JO_QUESTION2025-06-0320250022
17090000040183L17/questions_ecrites1717090000040177170900000401771JO_QUESTION2025-03-1120250010
17090000040189L17/questions_ecrites1717090000040184170900000401841JO_QUESTION2025-03-1120250010
17090000040206L17/questions_ecrites1717090000040200170900000402001JO_QUESTION2025-04-0820250014
17090000040259L17/questions_ecrites1717090000040254170900000402541JO_QUESTION2025-03-1820250011
17090000040388L17/questions_ecrites1717090000040383170900000403831JO_QUESTION2025-03-1120250010
17090000040435L17/questions_ecrites1717090000040428170900000404281JO_QUESTION2025-04-2920250017
17090000040436L17/questions_ecrites1717090000040428170900000404282JO_QUESTION2026-05-2620260021
17090000040449L17/questions_ecrites1717090000040442170900000404421JO_QUESTION2025-03-2520250012
17090000040450L17/questions_ecrites1717090000040442170900000404422JO_QUESTION2025-07-2220250029
17090000040451L17/questions_ecrites1717090000040442170900000404423JO_QUESTION2025-11-0420250044
17090000040452L17/questions_ecrites1717090000040442170900000404424JO_QUESTION2026-04-2120260016
17090000040453L17/questions_ecrites1717090000040442170900000404425JO_QUESTION2026-08-0420260031
17090000040481L17/questions_ecrites1717090000040475170900000404751JO_QUESTION2025-04-2920250017
17090000040482L17/questions_ecrites1717090000040475170900000404752JO_QUESTION2026-05-2620260021
17090000040505L17/questions_ecrites1717090000040498170900000404981JO_QUESTION2025-03-1120250010
17090000040506L17/questions_ecrites1717090000040498170900000404982JO_QUESTION2025-06-1720250024
17090000040507L17/questions_ecrites1717090000040498170900000404983JO_QUESTION2025-09-3020250039
17090000040508L17/questions_ecrites1717090000040498170900000404984JO_QUESTION2026-01-1320260002
17090000040509L17/questions_ecrites1717090000040498170900000404985JO_QUESTION2026-04-2120260016
17090000040522L17/questions_ecrites1717090000040515170900000405151JO_QUESTION2025-03-2520250012
17090000040531L17/questions_ecrites1717090000040523170900000405231JO_QUESTION2026-01-2720260004
17090000040549L17/questions_ecrites1717090000040543170900000405431JO_QUESTION2025-12-2320250051
17090000040576L17/questions_ecrites1717090000040570170900000405701JO_QUESTION2025-03-1820250011
17090000040670L17/questions_ecrites1717090000040663170900000406631JO_QUESTION2025-03-1120250010
17090000040671L17/questions_ecrites1717090000040663170900000406632JO_QUESTION2025-06-2420250025
17090000040672L17/questions_ecrites1717090000040663170900000406633JO_QUESTION2025-10-2120250042
17090000040688L17/questions_ecrites1717090000040680170900000406801JO_QUESTION2025-01-1420250002
17090000040694L17/questions_ecrites1717090000040689170900000406891JO_QUESTION2025-03-2520250012
17090000040742L17/questions_ecrites1717090000040737170900000407371JO_QUESTION2025-03-0420250009
17090000040743L17/questions_ecrites1717090000040737170900000407372JO_QUESTION2025-06-1020250023
17090000040815L17/questions_ecrites1717090000040808170900000408081JO_QUESTION2025-03-1820250011
17090000040816L17/questions_ecrites1717090000040808170900000408082JO_QUESTION2025-12-1620250050
17090000040829L17/questions_ecrites1717090000040823170900000408231JO_QUESTION2025-06-0320250022
17090000040901L17/questions_ecrites1717090000040895170900000408951JO_QUESTION2025-03-1120250010
17090000040902L17/questions_ecrites1717090000040895170900000408952JO_QUESTION2026-09-0820260036
17090000040909L17/questions_ecrites1717090000040903170900000409031JO_QUESTION2025-03-1120250010
17090000040910L17/questions_ecrites1717090000040903170900000409032JO_QUESTION2025-06-2420250025
17090000040911L17/questions_ecrites1717090000040903170900000409033JO_QUESTION2025-10-2120250042
17090000040912L17/questions_ecrites1717090000040903170900000409034JO_QUESTION2026-01-2720260004
17090000040913L17/questions_ecrites1717090000040903170900000409035JO_QUESTION2026-05-0520260018
17090000040921L17/questions_ecrites1717090000040914170900000409141JO_QUESTION2025-04-2920250017
17090000041015L17/questions_ecrites1717090000041010170900000410101JO_QUESTION2025-01-2120250003
17090000041067L17/questions_ecrites1717090000041059170900000410591JO_QUESTION2025-04-0820250014