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
17090000068621L17/questions_ecrites1717090000068613170900000686132JO_QUESTION2026-01-1320260002
17090000068680L17/questions_ecrites1717090000068674170900000686741JO_QUESTION2025-10-2120250042
17090000068681L17/questions_ecrites1717090000068674170900000686742JO_QUESTION2026-06-2320260025
17090000068692L17/questions_ecrites1717090000068687170900000686871JO_QUESTION2025-01-1420250002
17090000068733L17/questions_ecrites1717090000068726170900000687261JO_QUESTION2026-07-2120260029
17090000068795L17/questions_ecrites1717090000068787170900000687871JO_QUESTION2025-11-2520250047
17090000068896L17/questions_ecrites1717090000068889170900000688891JO_QUESTION2025-11-0420250044
17090000068914L17/questions_ecrites1717090000068909170900000689091JO_QUESTION2025-09-0920250036
17090000068915L17/questions_ecrites1717090000068909170900000689092JO_QUESTION2025-12-1620250050
17090000068916L17/questions_ecrites1717090000068909170900000689093JO_QUESTION2026-03-2420260012
17090000068932L17/questions_ecrites1717090000068927170900000689271JO_QUESTION2025-01-1420250002
17090000068979L17/questions_ecrites1717090000068973170900000689731JO_QUESTION2025-11-2520250047
17090000068980L17/questions_ecrites1717090000068973170900000689732JO_QUESTION2026-07-1420260028
17090000068987L17/questions_ecrites1717090000068981170900000689811JO_QUESTION2025-10-2120250042
17090000069023L17/questions_ecrites1717090000069016170900000690161JO_QUESTION2025-09-0920250036
17090000069024L17/questions_ecrites1717090000069016170900000690162JO_QUESTION2026-02-0320260005
17090000069039L17/questions_ecrites1717090000069033170900000690331JO_QUESTION2025-09-0920250036
17090000069040L17/questions_ecrites1717090000069033170900000690332JO_QUESTION2025-12-1620250050
17090000069121L17/questions_ecrites1717090000069115170900000691151JO_QUESTION2025-02-1820250007
17090000069122L17/questions_ecrites1717090000069115170900000691152JO_QUESTION2025-06-0320250022
17090000069123L17/questions_ecrites1717090000069115170900000691153JO_QUESTION2025-11-0420250044
17090000069124L17/questions_ecrites1717090000069115170900000691154JO_QUESTION2026-04-2120260016
17090000069125L17/questions_ecrites1717090000069115170900000691155JO_QUESTION2026-08-0420260031
17090000069221L17/questions_ecrites1717090000069215170900000692151JO_QUESTION2025-09-2320250038
17090000069222L17/questions_ecrites1717090000069215170900000692152JO_QUESTION2026-05-1920260020
17090000069252L17/questions_ecrites1717090000069247170900000692471JO_QUESTION2025-02-1120250006
17090000069306L17/questions_ecrites1717090000069299170900000692991JO_QUESTION2025-12-0220250048
17090000069312L17/questions_ecrites1717090000069307170900000693071JO_QUESTION2025-01-0720250001
17090000069369L17/questions_ecrites1717090000069361170900000693611JO_QUESTION2025-12-0220250048
17090000069520L17/questions_ecrites1717090000069513170900000695131JO_QUESTION2026-01-1320260002
17090000069528L17/questions_ecrites1717090000069521170900000695211JO_QUESTION2025-09-2320250038
17090000069529L17/questions_ecrites1717090000069521170900000695212JO_QUESTION2026-05-1920260020
17090000069530L17/questions_ecrites1717090000069521170900000695213JO_QUESTION2026-09-1520260037
17090000069539L17/questions_ecrites1717090000069531170900000695311JO_QUESTION2025-10-2120250042
17090000069606L17/questions_ecrites1717090000069602170900000696021JO_QUESTION2025-09-0220250035
17090000069701L17/questions_ecrites1717090000069697170900000696971JO_QUESTION2025-09-0220250035
17090000069708L17/questions_ecrites1717090000069702170900000697021JO_QUESTION2025-10-2820250043
17090000069741L17/questions_ecrites1717090000069736170900000697361JO_QUESTION2025-01-1420250002
17090000069764L17/questions_ecrites1717090000069758170900000697581JO_QUESTION2025-11-0420250044
17090000069765L17/questions_ecrites1717090000069758170900000697582JO_QUESTION2026-04-2120260016
17090000069772L17/questions_ecrites1717090000069766170900000697661JO_QUESTION2025-09-2320250038
17090000069773L17/questions_ecrites1717090000069766170900000697662JO_QUESTION2026-05-1920260020
17090000069780L17/questions_ecrites1717090000069774170900000697741JO_QUESTION2025-10-2120250042
17090000069808L17/questions_ecrites1717090000069800170900000698001JO_QUESTION2026-03-1020260010
17090000069932L17/questions_ecrites1717090000069927170900000699271JO_QUESTION2025-01-1420250002
17090000069933L17/questions_ecrites1717090000069927170900000699272JO_QUESTION2025-04-2920250017
17090000070002L17/questions_ecrites1717090000069995170900000699951JO_QUESTION2025-12-0220250048
17090000070049L17/questions_ecrites1717090000070043170900000700431JO_QUESTION2025-09-2320250038
17090000070073L17/questions_ecrites1717090000070065170900000700651JO_QUESTION2025-10-2120250042
17090000070084L17/questions_ecrites1717090000070079170900000700791JO_QUESTION2025-09-3020250039