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
17090000076198L17/questions_ecrites1717090000076191170900000761912JO_QUESTION2026-01-2720260004
17090000076199L17/questions_ecrites1717090000076191170900000761913JO_QUESTION2026-06-0220260022
17090000076200L17/questions_ecrites1717090000076191170900000761914JO_QUESTION2026-09-0820260036
17090000076207L17/questions_ecrites1717090000076201170900000762011JO_QUESTION2025-10-2120250042
17090000076304L17/questions_ecrites1717090000076299170900000762991JO_QUESTION2026-01-2720260004
17090000076305L17/questions_ecrites1717090000076299170900000762992JO_QUESTION2026-06-0220260022
17090000076439L17/questions_ecrites1717090000076433170900000764331JO_QUESTION2025-03-2520250012
17090000076460L17/questions_ecrites1717090000076453170900000764531JO_QUESTION2025-10-2120250042
17090000076562L17/questions_ecrites1717090000076557170900000765571JO_QUESTION2025-02-0420250005
17090000076594L17/questions_ecrites1717090000076588170900000765881JO_QUESTION2025-10-2120250042
17090000076595L17/questions_ecrites1717090000076588170900000765882JO_QUESTION2026-01-2720260004
17090000076602L17/questions_ecrites1717090000076596170900000765961JO_QUESTION2026-06-2320260025
17090000076616L17/questions_ecrites1717090000076611170900000766111JO_QUESTION2026-06-2320260025
17090000076623L17/questions_ecrites1717090000076617170900000766171JO_QUESTION2026-06-2320260025
17090000076633L17/questions_ecrites1717090000076624170900000766241JO_QUESTION2025-07-2220250029
17090000076640L17/questions_ecrites1717090000076634170900000766341JO_QUESTION2026-06-2320260025
17090000076760L17/questions_ecrites1717090000076753170900000767531JO_QUESTION2025-10-2120250042
17090000076803L17/questions_ecrites1717090000076797170900000767971JO_QUESTION2025-10-2820250043
17090000076804L17/questions_ecrites1717090000076797170900000767972JO_QUESTION2026-02-1720260007
17090000076821L17/questions_ecrites1717090000076815170900000768151JO_QUESTION2025-11-1820250046
17090000076822L17/questions_ecrites1717090000076815170900000768152JO_QUESTION2026-09-0120260035
17090000076836L17/questions_ecrites1717090000076829170900000768291JO_QUESTION2025-10-2820250043
17090000076894L17/questions_ecrites1717090000076885170900000768851JO_QUESTION2026-03-2420260012
17090000076928L17/questions_ecrites1717090000076920170900000769201JO_QUESTION2025-11-0420250044
17090000076956L17/questions_ecrites1717090000076951170900000769511JO_QUESTION2025-11-2520250047
17090000076962L17/questions_ecrites1717090000076957170900000769571JO_QUESTION2026-04-1420260015
17090000076963L17/questions_ecrites1717090000076957170900000769572JO_QUESTION2026-09-2920260039
17090000077017L17/questions_ecrites1717090000077012170900000770121JO_QUESTION2026-01-2720260004
17090000077018L17/questions_ecrites1717090000077012170900000770122JO_QUESTION2026-06-0220260022
17090000077045L17/questions_ecrites1717090000077039170900000770391JO_QUESTION2025-11-1820250046
17090000077052L17/questions_ecrites1717090000077046170900000770461JO_QUESTION2025-10-2120250042
17090000077053L17/questions_ecrites1717090000077046170900000770462JO_QUESTION2026-01-2720260004
17090000077072L17/questions_ecrites1717090000077066170900000770661JO_QUESTION2026-04-0720260014
17090000077079L17/questions_ecrites1717090000077073170900000770731JO_QUESTION2025-10-2120250042
17090000077108L17/questions_ecrites1717090000077101170900000771011JO_QUESTION2025-10-2120250042
17090000077162L17/questions_ecrites1717090000077155170900000771551JO_QUESTION2025-10-2120250042
17090000077163L17/questions_ecrites1717090000077155170900000771552JO_QUESTION2026-01-2720260004
17090000077215L17/questions_ecrites1717090000077209170900000772091JO_QUESTION2025-11-2520250047
17090000077315L17/questions_ecrites1717090000077308170900000773081JO_QUESTION2025-10-2120250042
17090000077328L17/questions_ecrites1717090000077321170900000773211JO_QUESTION2025-11-1120250045
17090000077329L17/questions_ecrites1717090000077321170900000773212JO_QUESTION2026-05-1220260019
17090000077330L17/questions_ecrites1717090000077321170900000773213JO_QUESTION2026-08-1820260033
17090000077372L17/questions_ecrites1717090000077365170900000773651JO_QUESTION2025-10-2820250043
17090000077442L17/questions_ecrites1717090000077437170900000774371JO_QUESTION2026-04-0720260014
17090000077469L17/questions_ecrites1717090000077464170900000774641JO_QUESTION2025-11-1820250046
17090000077470L17/questions_ecrites1717090000077464170900000774642JO_QUESTION2026-09-0120260035
17090000077498L17/questions_ecrites1717090000077493170900000774931JO_QUESTION2026-06-3020260026
17090000077505L17/questions_ecrites1717090000077499170900000774991JO_QUESTION2026-07-2120260029
17090000077602L17/questions_ecrites1717090000077597170900000775971JO_QUESTION2025-02-1820250007
17090000077635L17/questions_ecrites1717090000077629170900000776291JO_QUESTION2025-11-0420250044