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
17090000067132L17/questions_ecrites1717090000067124170900000671243JO_QUESTION2026-02-2420260008
17090000067133L17/questions_ecrites1717090000067124170900000671244JO_QUESTION2026-06-0220260022
17090000067139L17/questions_ecrites1717090000067134170900000671341JO_QUESTION2025-01-2820250004
17090000067267L17/questions_ecrites1717090000067260170900000672601JO_QUESTION2025-12-0220250048
17090000067286L17/questions_ecrites1717090000067281170900000672811JO_QUESTION2025-08-1920250033
17090000067287L17/questions_ecrites1717090000067281170900000672812JO_QUESTION2025-11-2520250047
17090000067288L17/questions_ecrites1717090000067281170900000672813JO_QUESTION2026-03-2420260012
17090000067289L17/questions_ecrites1717090000067281170900000672814JO_QUESTION2026-07-1420260028
17090000067296L17/questions_ecrites1717090000067290170900000672901JO_QUESTION2025-12-0220250048
17090000067320L17/questions_ecrites1717090000067315170900000673151JO_QUESTION2025-11-0420250044
17090000067321L17/questions_ecrites1717090000067315170900000673152JO_QUESTION2026-04-2120260016
17090000067322L17/questions_ecrites1717090000067315170900000673153JO_QUESTION2026-08-0420260031
17090000067437L17/questions_ecrites1717090000067433170900000674331JO_QUESTION2025-09-0220250035
17090000067443L17/questions_ecrites1717090000067438170900000674381JO_QUESTION2025-01-2120250003
17090000067444L17/questions_ecrites1717090000067438170900000674382JO_QUESTION2025-04-2920250017
17090000067478L17/questions_ecrites1717090000067473170900000674731JO_QUESTION2026-05-1220260019
17090000067577L17/questions_ecrites1717090000067572170900000675721JO_QUESTION2025-12-2320250051
17090000067578L17/questions_ecrites1717090000067572170900000675722JO_QUESTION2026-05-1920260020
17090000067594L17/questions_ecrites1717090000067587170900000675871JO_QUESTION2025-09-3020250039
17090000067716L17/questions_ecrites1717090000067709170900000677091JO_QUESTION2026-01-2720260004
17090000067746L17/questions_ecrites1717090000067735170900000677351JO_QUESTION2026-03-2420260012
17090000067784L17/questions_ecrites1717090000067778170900000677781JO_QUESTION2025-09-0920250036
17090000067821L17/questions_ecrites1717090000067815170900000678151JO_QUESTION2025-09-3020250039
17090000067822L17/questions_ecrites1717090000067815170900000678152JO_QUESTION2026-01-1320260002
17090000067823L17/questions_ecrites1717090000067815170900000678153JO_QUESTION2026-04-2120260016
17090000067937L17/questions_ecrites1717090000067931170900000679311JO_QUESTION2025-09-0920250036
17090000067938L17/questions_ecrites1717090000067931170900000679312JO_QUESTION2026-02-0320260005
17090000067974L17/questions_ecrites1717090000067969170900000679691JO_QUESTION2025-08-1920250033
17090000067975L17/questions_ecrites1717090000067969170900000679692JO_QUESTION2025-11-2520250047
17090000067982L17/questions_ecrites1717090000067976170900000679761JO_QUESTION2026-03-2420260012
17090000068050L17/questions_ecrites1717090000068043170900000680431JO_QUESTION2025-02-1120250006
17090000068056L17/questions_ecrites1717090000068051170900000680511JO_QUESTION2025-09-0920250036
17090000068081L17/questions_ecrites1717090000068073170900000680731JO_QUESTION2025-11-0420250044
17090000068082L17/questions_ecrites1717090000068073170900000680732JO_QUESTION2026-05-1220260019
17090000068173L17/questions_ecrites1717090000068167170900000681671JO_QUESTION2025-12-3020250052
17090000068233L17/questions_ecrites1717090000068225170900000682251JO_QUESTION2026-01-1320260002
17090000068240L17/questions_ecrites1717090000068234170900000682341JO_QUESTION2025-02-1120250006
17090000068247L17/questions_ecrites1717090000068241170900000682411JO_QUESTION2025-09-0920250036
17090000068248L17/questions_ecrites1717090000068241170900000682412JO_QUESTION2025-12-1620250050
17090000068304L17/questions_ecrites1717090000068296170900000682961JO_QUESTION2025-01-2120250003
17090000068305L17/questions_ecrites1717090000068296170900000682962JO_QUESTION2025-04-2920250017
17090000068306L17/questions_ecrites1717090000068296170900000682963JO_QUESTION2025-08-0520250031
17090000068352L17/questions_ecrites1717090000068347170900000683471JO_QUESTION2025-12-0220250048
17090000068353L17/questions_ecrites1717090000068347170900000683472JO_QUESTION2026-05-1220260019
17090000068369L17/questions_ecrites1717090000068363170900000683631JO_QUESTION2026-02-1720260007
17090000068483L17/questions_ecrites1717090000068477170900000684771JO_QUESTION2025-09-0220250035
17090000068484L17/questions_ecrites1717090000068477170900000684772JO_QUESTION2025-12-1620250050
17090000068526L17/questions_ecrites1717090000068521170900000685211JO_QUESTION2025-11-1820250046
17090000068527L17/questions_ecrites1717090000068521170900000685212JO_QUESTION2026-02-2420260008
17090000068620L17/questions_ecrites1717090000068613170900000686131JO_QUESTION2025-08-2620250034