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
17090000046918L17/questions_ecrites1717090000046912170900000469122JO_QUESTION2025-11-1120250045
17090000046919L17/questions_ecrites1717090000046912170900000469123JO_QUESTION2026-04-0720260014
17090000046930L17/questions_ecrites1717090000046924170900000469241JO_QUESTION2025-06-0320250022
17090000046935L17/questions_ecrites1717090000046931170900000469311JO_QUESTION2025-05-2720250021
17090000046971L17/questions_ecrites1717090000046966170900000469661JO_QUESTION2025-01-2120250003
17090000046972L17/questions_ecrites1717090000046966170900000469662JO_QUESTION2025-04-2920250017
17090000046990L17/questions_ecrites1717090000046986170900000469861JO_QUESTION2025-04-2920250017
17090000047020L17/questions_ecrites1717090000047014170900000470141JO_QUESTION2025-05-2720250021
17090000047021L17/questions_ecrites1717090000047014170900000470142JO_QUESTION2025-11-1120250045
17090000047030L17/questions_ecrites1717090000047026170900000470261JO_QUESTION2025-04-2220250016
17090000047123L17/questions_ecrites1717090000047117170900000471171JO_QUESTION2025-04-2920250017
17090000047124L17/questions_ecrites1717090000047117170900000471172JO_QUESTION2025-08-0520250031
17090000047125L17/questions_ecrites1717090000047117170900000471173JO_QUESTION2025-12-0220250048
17090000047130L17/questions_ecrites1717090000047126170900000471261JO_QUESTION2025-04-2220250016
17090000047165L17/questions_ecrites1717090000047161170900000471611JO_QUESTION2025-04-2220250016
17090000047188L17/questions_ecrites1717090000047183170900000471831JO_QUESTION2025-04-2220250016
17090000047189L17/questions_ecrites1717090000047183170900000471832JO_QUESTION2025-10-2120250042
17090000047190L17/questions_ecrites1717090000047183170900000471833JO_QUESTION2026-01-2720260004
17090000047191L17/questions_ecrites1717090000047183170900000471834JO_QUESTION2026-05-1220260019
17090000047192L17/questions_ecrites1717090000047183170900000471835JO_QUESTION2026-09-1520260037
17090000047201L17/questions_ecrites1717090000047197170900000471971JO_QUESTION2025-04-2220250016
17090000047215L17/questions_ecrites1717090000047211170900000472111JO_QUESTION2025-04-2920250017
17090000047238L17/questions_ecrites1717090000047233170900000472331JO_QUESTION2026-04-0720260014
17090000047244L17/questions_ecrites1717090000047239170900000472391JO_QUESTION2025-04-2920250017
17090000047262L17/questions_ecrites1717090000047254170900000472541JO_QUESTION2025-01-2820250004
17090000047263L17/questions_ecrites1717090000047254170900000472542JO_QUESTION2025-05-0620250018
17090000047264L17/questions_ecrites1717090000047254170900000472543JO_QUESTION2025-08-1220250032
17090000047279L17/questions_ecrites1717090000047272170900000472721JO_QUESTION2025-04-2220250016
17090000047280L17/questions_ecrites1717090000047272170900000472722JO_QUESTION2025-09-3020250039
17090000047308L17/questions_ecrites1717090000047303170900000473031JO_QUESTION2025-04-2220250016
17090000047309L17/questions_ecrites1717090000047303170900000473032JO_QUESTION2025-10-2120250042
17090000047310L17/questions_ecrites1717090000047303170900000473033JO_QUESTION2026-01-2720260004
17090000047311L17/questions_ecrites1717090000047303170900000473034JO_QUESTION2026-05-1220260019
17090000047312L17/questions_ecrites1717090000047303170900000473035JO_QUESTION2026-09-1520260037
17090000047351L17/questions_ecrites1717090000047346170900000473461JO_QUESTION2025-04-2920250017
17090000047361L17/questions_ecrites1717090000047357170900000473571JO_QUESTION2025-05-2020250020
17090000047370L17/questions_ecrites1717090000047366170900000473661JO_QUESTION2025-05-0620250018
17090000047419L17/questions_ecrites1717090000047415170900000474151JO_QUESTION2025-04-2220250016
17090000047428L17/questions_ecrites1717090000047424170900000474241JO_QUESTION2025-04-2220250016
17090000047519L17/questions_ecrites1717090000047514170900000475141JO_QUESTION2025-05-0620250018
17090000047520L17/questions_ecrites1717090000047514170900000475142JO_QUESTION2026-09-0820260036
17090000047537L17/questions_ecrites1717090000047533170900000475331JO_QUESTION2025-04-2220250016
17090000047559L17/questions_ecrites1717090000047553170900000475531JO_QUESTION2025-10-2820250043
17090000047636L17/questions_ecrites1717090000047628170900000476281JO_QUESTION2025-04-2220250016
17090000047637L17/questions_ecrites1717090000047628170900000476282JO_QUESTION2025-10-2120250042
17090000047638L17/questions_ecrites1717090000047628170900000476283JO_QUESTION2026-01-2720260004
17090000047639L17/questions_ecrites1717090000047628170900000476284JO_QUESTION2026-05-1220260019
17090000047640L17/questions_ecrites1717090000047628170900000476285JO_QUESTION2026-09-1520260037
17090000047655L17/questions_ecrites1717090000047649170900000476491JO_QUESTION2025-05-0620250018
17090000047656L17/questions_ecrites1717090000047649170900000476492JO_QUESTION2025-09-0920250036