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
17090000004755L17/questions_ecrites1717090000004747170900000047473JO_QUESTION2025-12-1620250050
17090000004756L17/questions_ecrites1717090000004747170900000047474JO_QUESTION2026-03-3120260013
17090000004757L17/questions_ecrites1717090000004747170900000047475JO_QUESTION2026-07-1420260028
17090000004763L17/questions_ecrites1717090000004758170900000047581JO_QUESTION2026-03-0320260009
17090000004884L17/questions_ecrites1717090000004879170900000048791JO_QUESTION2026-08-1820260033
17090000004889L17/questions_ecrites1717090000004885170900000048851JO_QUESTION2026-03-3120260013
17090000004890L17/questions_ecrites1717090000004885170900000048852JO_QUESTION2026-07-2120260029
17090000004917L17/questions_ecrites1717090000004914170900000049141JO_QUESTION2026-02-1720260007
17090000004918L17/questions_ecrites1717090000004914170900000049142JO_QUESTION2026-05-2620260021
17090000004919L17/questions_ecrites1717090000004914170900000049143JO_QUESTION2026-09-0120260035
17090000004936L17/questions_ecrites1717090000004932170900000049321JO_QUESTION2026-03-0320260009
17090000004957L17/questions_ecrites1717090000004949170900000049491JO_QUESTION2025-07-2920250030
17090000004958L17/questions_ecrites1717090000004949170900000049492JO_QUESTION2025-11-2520250047
17090000004963L17/questions_ecrites1717090000004959170900000049591JO_QUESTION2026-03-0320260009
17090000005027L17/questions_ecrites1717090000005021170900000050211JO_QUESTION2026-03-0320260009
17090000005045L17/questions_ecrites1717090000005042170900000050421JO_QUESTION2026-02-1720260007
17090000005046L17/questions_ecrites1717090000005042170900000050422JO_QUESTION2026-05-2620260021
17090000005051L17/questions_ecrites1717090000005047170900000050471JO_QUESTION2026-06-1620260024
17090000005077L17/questions_ecrites1717090000005074170900000050741JO_QUESTION2026-06-1620260024
17090000005103L17/questions_ecrites1717090000005099170900000050991JO_QUESTION2026-02-2420260008
17090000005104L17/questions_ecrites1717090000005099170900000050992JO_QUESTION2026-06-0220260022
17090000005151L17/questions_ecrites1717090000005144170900000051441JO_QUESTION2025-01-2820250004
17090000005152L17/questions_ecrites1717090000005144170900000051442JO_QUESTION2025-05-0620250018
17090000005232L17/questions_ecrites1717090000005228170900000052281JO_QUESTION2026-03-1020260010
17090000005233L17/questions_ecrites1717090000005228170900000052282JO_QUESTION2026-06-1620260024
17090000005234L17/questions_ecrites1717090000005228170900000052283JO_QUESTION2026-09-2220260038
17090000005261L17/questions_ecrites1717090000005256170900000052561JO_QUESTION2026-03-0320260009
17090000005284L17/questions_ecrites1717090000005280170900000052801JO_QUESTION2026-05-2620260021
17090000005285L17/questions_ecrites1717090000005280170900000052802JO_QUESTION2026-09-2220260038
17090000005289L17/questions_ecrites1717090000005286170900000052861JO_QUESTION2026-03-1020260010
17090000005290L17/questions_ecrites1717090000005286170900000052862JO_QUESTION2026-06-1620260024
17090000005291L17/questions_ecrites1717090000005286170900000052863JO_QUESTION2026-09-2220260038
17090000005330L17/questions_ecrites1717090000005324170900000053241JO_QUESTION2026-03-1020260010
17090000005331L17/questions_ecrites1717090000005324170900000053242JO_QUESTION2026-06-1620260024
17090000005396L17/questions_ecrites1717090000005392170900000053921JO_QUESTION2026-05-1920260020
17090000005424L17/questions_ecrites1717090000005421170900000054211JO_QUESTION2026-06-0220260022
17090000005442L17/questions_ecrites1717090000005439170900000054391JO_QUESTION2026-03-0320260009
17090000005443L17/questions_ecrites1717090000005439170900000054392JO_QUESTION2026-06-1620260024
17090000005484L17/questions_ecrites1717090000005480170900000054801JO_QUESTION2026-04-2820260017
17090000005501L17/questions_ecrites1717090000005498170900000054981JO_QUESTION2026-04-0720260014
17090000005511L17/questions_ecrites1717090000005506170900000055061JO_QUESTION2025-01-2820250004
17090000005516L17/questions_ecrites1717090000005512170900000055121JO_QUESTION2026-02-2420260008
17090000005537L17/questions_ecrites1717090000005531170900000055311JO_QUESTION2026-03-0320260009
17090000005542L17/questions_ecrites1717090000005538170900000055381JO_QUESTION2026-05-0520260018
17090000005550L17/questions_ecrites1717090000005547170900000055471JO_QUESTION2026-05-2620260021
17090000005569L17/questions_ecrites1717090000005564170900000055641JO_QUESTION2026-03-1020260010
17090000005683L17/questions_ecrites1717090000005679170900000056791JO_QUESTION2026-03-0320260009
17090000005698L17/questions_ecrites1717090000005692170900000056921JO_QUESTION2025-02-1120250006
17090000005736L17/questions_ecrites1717090000005731170900000057311JO_QUESTION2026-03-2420260012
17090000005775L17/questions_ecrites1717090000005770170900000057701JO_QUESTION2026-03-1020260010