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
16090000075374L16/questions_ecrites1616090000075367160900000753671JO_QUESTION2023-09-1920230038
16090000075382L16/questions_ecrites1616090000075375160900000753751JO_QUESTION2023-11-1420230046
16090000075435L16/questions_ecrites1616090000075431160900000754311JO_QUESTION2023-10-0320230040
16090000075454L16/questions_ecrites1616090000075448160900000754481JO_QUESTION2023-10-3120230044
16090000075455L16/questions_ecrites1616090000075448160900000754482JO_QUESTION2024-02-0620240006
16090000075475L16/questions_ecrites1616090000075471160900000754711JO_QUESTION2023-11-2120230047
16090000075476L16/questions_ecrites1616090000075471160900000754712JO_QUESTION2024-03-1220240011
16090000075495L16/questions_ecrites1616090000075490160900000754901JO_QUESTION2023-09-1920230038
16090000075504L16/questions_ecrites1616090000075500160900000755001JO_QUESTION2023-09-1920230038
16090000075509L16/questions_ecrites1616090000075505160900000755051JO_QUESTION2023-09-1920230038
16090000075514L16/questions_ecrites1616090000075510160900000755101JO_QUESTION2022-10-2520220042
16090000075520L16/questions_ecrites1616090000075515160900000755151JO_QUESTION2023-01-3120230005
16090000075529L16/questions_ecrites1616090000075525160900000755251JO_QUESTION2023-10-3120230044
16090000075530L16/questions_ecrites1616090000075525160900000755252JO_QUESTION2024-02-2020240008
16090000075539L16/questions_ecrites1616090000075535160900000755351JO_QUESTION2023-08-2920230035
16090000075597L16/questions_ecrites1616090000075590160900000755901JO_QUESTION2023-09-1220230037
16090000075602L16/questions_ecrites1616090000075598160900000755981JO_QUESTION2023-09-0520230036
16090000075617L16/questions_ecrites1616090000075613160900000756131JO_QUESTION2024-04-1620240016
16090000075705L16/questions_ecrites1616090000075700160900000757001JO_QUESTION2023-11-2820230048
16090000075706L16/questions_ecrites1616090000075700160900000757002JO_QUESTION2024-03-1220240011
16090000075714L16/questions_ecrites1616090000075707160900000757071JO_QUESTION2023-09-0520230036
16090000075715L16/questions_ecrites1616090000075707160900000757072JO_QUESTION2023-12-1220230050
16090000075716L16/questions_ecrites1616090000075707160900000757073JO_QUESTION2024-03-1920240012
16090000075727L16/questions_ecrites1616090000075722160900000757221JO_QUESTION2023-09-1220230037
16090000075728L16/questions_ecrites1616090000075722160900000757222JO_QUESTION2024-01-2320240004
16090000075739L16/questions_ecrites1616090000075734160900000757341JO_QUESTION2022-11-2220220046
16090000075740L16/questions_ecrites1616090000075734160900000757342JO_QUESTION2023-02-2820230009
16090000075765L16/questions_ecrites1616090000075761160900000757611JO_QUESTION2023-10-0320230040
16090000075766L16/questions_ecrites1616090000075761160900000757612JO_QUESTION2024-01-1620240003
16090000075767L16/questions_ecrites1616090000075761160900000757613JO_QUESTION2024-05-1420240020
16090000075839L16/questions_ecrites1616090000075834160900000758341JO_QUESTION2024-02-2020240008
16090000075884L16/questions_ecrites1616090000075879160900000758791JO_QUESTION2023-10-1020230041
16090000075889L16/questions_ecrites1616090000075885160900000758851JO_QUESTION2023-09-0520230036
16090000075959L16/questions_ecrites1616090000075953160900000759531JO_QUESTION2024-04-1620240016
16090000075964L16/questions_ecrites1616090000075960160900000759601JO_QUESTION2022-12-0620220048
16090000075975L16/questions_ecrites1616090000075970160900000759701JO_QUESTION2023-10-1720230042
16090000075992L16/questions_ecrites1616090000075985160900000759851JO_QUESTION2024-03-1220240011
16090000076050L16/questions_ecrites1616090000076045160900000760451JO_QUESTION2023-10-1020230041
16090000076134L16/questions_ecrites1616090000076127160900000761271JO_QUESTION2023-09-0520230036
16090000076135L16/questions_ecrites1616090000076127160900000761272JO_QUESTION2023-12-1220230050
16090000076136L16/questions_ecrites1616090000076127160900000761273JO_QUESTION2024-03-1920240012
16090000076212L16/questions_ecrites1616090000076207160900000762071JO_QUESTION2023-09-0520230036
16090000076228L16/questions_ecrites1616090000076223160900000762231JO_QUESTION2023-10-0320230040
16090000076229L16/questions_ecrites1616090000076223160900000762232JO_QUESTION2024-06-1120240024
16090000076239L16/questions_ecrites1616090000076234160900000762341JO_QUESTION2023-09-0520230036
16090000076279L16/questions_ecrites1616090000076274160900000762741JO_QUESTION2023-09-1920230038
16090000076285L16/questions_ecrites1616090000076280160900000762801JO_QUESTION2023-10-0320230040
16090000076286L16/questions_ecrites1616090000076280160900000762802JO_QUESTION2024-01-0920240002
16090000076287L16/questions_ecrites1616090000076280160900000762803JO_QUESTION2024-04-1620240016
16090000076308L16/questions_ecrites1616090000076304160900000763041JO_QUESTION2022-11-2220220046