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
17090000051492L17/questions_ecrites1717090000051485170900000514851JO_QUESTION2025-05-2020250020
17090000051493L17/questions_ecrites1717090000051485170900000514852JO_QUESTION2025-08-2620250034
17090000051494L17/questions_ecrites1717090000051485170900000514853JO_QUESTION2026-01-1320260002
17090000051495L17/questions_ecrites1717090000051485170900000514854JO_QUESTION2026-05-0520260018
17090000051589L17/questions_ecrites1717090000051581170900000515811JO_QUESTION2025-01-2820250004
17090000051590L17/questions_ecrites1717090000051581170900000515812JO_QUESTION2025-05-0620250018
17090000051591L17/questions_ecrites1717090000051581170900000515813JO_QUESTION2025-08-1220250032
17090000051592L17/questions_ecrites1717090000051581170900000515814JO_QUESTION2025-11-1820250046
17090000051756L17/questions_ecrites1717090000051752170900000517521JO_QUESTION2025-06-0320250022
17090000051776L17/questions_ecrites1717090000051771170900000517711JO_QUESTION2025-10-2120250042
17090000051837L17/questions_ecrites1717090000051831170900000518311JO_QUESTION2025-05-2720250021
17090000051838L17/questions_ecrites1717090000051831170900000518312JO_QUESTION2025-09-3020250039
17090000051950L17/questions_ecrites1717090000051944170900000519441JO_QUESTION2025-06-2420250025
17090000051951L17/questions_ecrites1717090000051944170900000519442JO_QUESTION2025-11-1120250045
17090000052015L17/questions_ecrites1717090000052010170900000520101JO_QUESTION2025-05-2020250020
17090000052098L17/questions_ecrites1717090000052090170900000520901JO_QUESTION2025-05-2020250020
17090000052099L17/questions_ecrites1717090000052090170900000520902JO_QUESTION2025-09-0920250036
17090000052107L17/questions_ecrites1717090000052100170900000521001JO_QUESTION2025-02-1120250006
17090000052190L17/questions_ecrites1717090000052186170900000521861JO_QUESTION2025-05-2020250020
17090000052213L17/questions_ecrites1717090000052207170900000522071JO_QUESTION2025-01-2820250004
17090000052290L17/questions_ecrites1717090000052282170900000522821JO_QUESTION2025-05-2020250020
17090000052291L17/questions_ecrites1717090000052282170900000522822JO_QUESTION2025-09-0920250036
17090000052292L17/questions_ecrites1717090000052282170900000522823JO_QUESTION2026-02-0320260005
17090000052313L17/questions_ecrites1717090000052305170900000523051JO_QUESTION2025-06-1020250023
17090000052352L17/questions_ecrites1717090000052347170900000523471JO_QUESTION2025-05-2720250021
17090000052371L17/questions_ecrites1717090000052367170900000523671JO_QUESTION2025-06-0320250022
17090000052396L17/questions_ecrites1717090000052390170900000523901JO_QUESTION2025-01-2120250003
17090000052397L17/questions_ecrites1717090000052390170900000523902JO_QUESTION2025-04-2920250017
17090000052398L17/questions_ecrites1717090000052390170900000523903JO_QUESTION2025-08-0520250031
17090000052458L17/questions_ecrites1717090000052454170900000524541JO_QUESTION2025-05-2720250021
17090000052525L17/questions_ecrites1717090000052520170900000525201JO_QUESTION2025-06-0320250022
17090000052580L17/questions_ecrites1717090000052575170900000525751JO_QUESTION2025-05-2020250020
17090000052581L17/questions_ecrites1717090000052575170900000525752JO_QUESTION2025-08-2620250034
17090000052641L17/questions_ecrites1717090000052637170900000526371JO_QUESTION2025-06-1020250023
17090000052669L17/questions_ecrites1717090000052663170900000526631JO_QUESTION2025-05-2020250020
17090000052670L17/questions_ecrites1717090000052663170900000526632JO_QUESTION2025-08-2620250034
17090000052671L17/questions_ecrites1717090000052663170900000526633JO_QUESTION2025-12-0220250048
17090000052680L17/questions_ecrites1717090000052676170900000526761JO_QUESTION2025-05-2720250021
17090000052728L17/questions_ecrites1717090000052722170900000527221JO_QUESTION2025-06-0320250022
17090000052746L17/questions_ecrites1717090000052742170900000527421JO_QUESTION2025-05-2720250021
17090000052785L17/questions_ecrites1717090000052780170900000527801JO_QUESTION2025-01-2820250004
17090000052834L17/questions_ecrites1717090000052828170900000528281JO_QUESTION2025-01-2120250003
17090000052835L17/questions_ecrites1717090000052828170900000528282JO_QUESTION2025-04-2920250017
17090000052836L17/questions_ecrites1717090000052828170900000528283JO_QUESTION2025-08-0520250031
17090000052850L17/questions_ecrites1717090000052844170900000528441JO_QUESTION2025-05-2020250020
17090000052851L17/questions_ecrites1717090000052844170900000528442JO_QUESTION2025-09-0220250035
17090000052998L17/questions_ecrites1717090000052991170900000529911JO_QUESTION2025-06-0320250022
17090000052999L17/questions_ecrites1717090000052991170900000529912JO_QUESTION2025-09-3020250039
17090000053000L17/questions_ecrites1717090000052991170900000529913JO_QUESTION2026-07-1420260028
17090000053112L17/questions_ecrites1717090000053105170900000531051JO_QUESTION2025-05-2720250021