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
16090000083801L16/questions_ecrites1616090000083797160900000837971JO_QUESTION2023-10-1020230041
16090000083825L16/questions_ecrites1616090000083818160900000838181JO_QUESTION2023-10-1020230041
16090000083826L16/questions_ecrites1616090000083818160900000838182JO_QUESTION2024-01-3020240005
16090000083827L16/questions_ecrites1616090000083818160900000838183JO_QUESTION2024-06-0420240023
16090000083833L16/questions_ecrites1616090000083828160900000838281JO_QUESTION2024-02-1320240007
16090000083862L16/questions_ecrites1616090000083856160900000838561JO_QUESTION2023-10-2420230043
16090000083863L16/questions_ecrites1616090000083856160900000838562JO_QUESTION2024-02-0620240006
16090000083912L16/questions_ecrites1616090000083907160900000839071JO_QUESTION2024-05-0720240019
16090000083991L16/questions_ecrites1616090000083985160900000839851JO_QUESTION2023-10-1720230042
16090000083992L16/questions_ecrites1616090000083985160900000839852JO_QUESTION2024-01-2320240004
16090000083993L16/questions_ecrites1616090000083985160900000839853JO_QUESTION2024-05-1420240020
16090000084026L16/questions_ecrites1616090000084022160900000840221JO_QUESTION2023-10-1720230042
16090000084037L16/questions_ecrites1616090000084033160900000840331JO_QUESTION2022-11-1520220045
16090000084042L16/questions_ecrites1616090000084038160900000840381JO_QUESTION2023-04-2520230017
16090000084066L16/questions_ecrites1616090000084060160900000840601JO_QUESTION2023-10-1720230042
16090000084067L16/questions_ecrites1616090000084060160900000840602JO_QUESTION2024-02-2020240008
16090000084068L16/questions_ecrites1616090000084060160900000840603JO_QUESTION2024-06-0420240023
16090000084075L16/questions_ecrites1616090000084069160900000840691JO_QUESTION2023-10-3120230044
16090000084076L16/questions_ecrites1616090000084069160900000840692JO_QUESTION2024-02-0620240006
16090000084089L16/questions_ecrites1616090000084083160900000840831JO_QUESTION2023-12-1220230050
16090000084226L16/questions_ecrites1616090000084221160900000842211JO_QUESTION2023-12-2620230052
16090000084250L16/questions_ecrites1616090000084245160900000842451JO_QUESTION2023-10-1720230042
16090000084256L16/questions_ecrites1616090000084251160900000842511JO_QUESTION2023-10-2420230043
16090000084263L16/questions_ecrites1616090000084257160900000842571JO_QUESTION2023-10-3120230044
16090000084290L16/questions_ecrites1616090000084284160900000842841JO_QUESTION2023-10-2420230043
16090000084329L16/questions_ecrites1616090000084324160900000843241JO_QUESTION2023-10-1720230042
16090000084340L16/questions_ecrites1616090000084335160900000843351JO_QUESTION2023-10-1720230042
16090000084363L16/questions_ecrites1616090000084356160900000843561JO_QUESTION2023-12-2620230052
16090000084369L16/questions_ecrites1616090000084364160900000843641JO_QUESTION2023-10-1720230042
16090000084413L16/questions_ecrites1616090000084408160900000844081JO_QUESTION2023-10-2420230043
16090000084414L16/questions_ecrites1616090000084408160900000844082JO_QUESTION2024-01-3020240005
16090000084415L16/questions_ecrites1616090000084408160900000844083JO_QUESTION2024-05-1420240020
16090000084476L16/questions_ecrites1616090000084471160900000844711JO_QUESTION2023-10-1720230042
16090000084477L16/questions_ecrites1616090000084471160900000844712JO_QUESTION2024-01-2320240004
16090000084478L16/questions_ecrites1616090000084471160900000844713JO_QUESTION2024-06-0420240023
16090000084498L16/questions_ecrites1616090000084494160900000844941JO_QUESTION2023-10-2420230043
16090000084538L16/questions_ecrites1616090000084534160900000845341JO_QUESTION2023-10-3120230044
16090000084587L16/questions_ecrites1616090000084582160900000845821JO_QUESTION2023-12-2620230052
16090000084602L16/questions_ecrites1616090000084597160900000845971JO_QUESTION2023-12-0520230049
16090000084730L16/questions_ecrites1616090000084723160900000847231JO_QUESTION2023-10-3120230044
16090000084737L16/questions_ecrites1616090000084731160900000847311JO_QUESTION2024-04-1620240016
16090000084837L16/questions_ecrites1616090000084832160900000848321JO_QUESTION2023-10-2420230043
16090000084838L16/questions_ecrites1616090000084832160900000848322JO_QUESTION2024-01-3020240005
16090000084916L16/questions_ecrites1616090000084911160900000849111JO_QUESTION2023-11-0720230045
16090000084917L16/questions_ecrites1616090000084911160900000849112JO_QUESTION2024-02-1320240007
16090000084998L16/questions_ecrites1616090000084994160900000849941JO_QUESTION2024-01-3020240005
16090000085008L16/questions_ecrites1616090000085003160900000850031JO_QUESTION2023-11-0720230045
16090000085062L16/questions_ecrites1616090000085056160900000850561JO_QUESTION2023-10-2420230043
16090000085069L16/questions_ecrites1616090000085063160900000850631JO_QUESTION2023-10-2420230043
16090000085090L16/questions_ecrites1616090000085083160900000850831JO_QUESTION2023-12-2620230052