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
17090000063763L17/questions_ecrites1717090000063757170900000637571JO_QUESTION2025-12-0220250048
17090000063764L17/questions_ecrites1717090000063757170900000637572JO_QUESTION2026-05-1220260019
17090000063794L17/questions_ecrites1717090000063787170900000637871JO_QUESTION2025-10-2820250043
17090000063896L17/questions_ecrites1717090000063890170900000638901JO_QUESTION2025-08-0520250031
17090000063909L17/questions_ecrites1717090000063903170900000639031JO_QUESTION2025-08-0520250031
17090000063910L17/questions_ecrites1717090000063903170900000639032JO_QUESTION2025-12-1620250050
17090000063969L17/questions_ecrites1717090000063964170900000639641JO_QUESTION2026-05-1220260019
17090000064112L17/questions_ecrites1717090000064106170900000641061JO_QUESTION2025-10-2820250043
17090000064126L17/questions_ecrites1717090000064119170900000641191JO_QUESTION2025-02-1120250006
17090000064127L17/questions_ecrites1717090000064119170900000641192JO_QUESTION2025-06-1720250024
17090000064128L17/questions_ecrites1717090000064119170900000641193JO_QUESTION2025-09-3020250039
17090000064129L17/questions_ecrites1717090000064119170900000641194JO_QUESTION2026-02-1020260006
17090000064158L17/questions_ecrites1717090000064152170900000641521JO_QUESTION2025-07-2220250029
17090000064159L17/questions_ecrites1717090000064152170900000641522JO_QUESTION2025-11-0420250044
17090000064160L17/questions_ecrites1717090000064152170900000641523JO_QUESTION2026-02-2420260008
17090000064161L17/questions_ecrites1717090000064152170900000641524JO_QUESTION2026-06-0220260022
17090000064208L17/questions_ecrites1717090000064202170900000642021JO_QUESTION2025-10-2120250042
17090000064209L17/questions_ecrites1717090000064202170900000642022JO_QUESTION2026-09-1520260037
17090000064214L17/questions_ecrites1717090000064210170900000642101JO_QUESTION2025-07-2220250029
17090000064304L17/questions_ecrites1717090000064296170900000642961JO_QUESTION2025-10-2820250043
17090000064329L17/questions_ecrites1717090000064322170900000643221JO_QUESTION2025-12-2320250051
17090000064371L17/questions_ecrites1717090000064365170900000643651JO_QUESTION2025-01-2820250004
17090000064372L17/questions_ecrites1717090000064365170900000643652JO_QUESTION2025-05-0620250018
17090000064373L17/questions_ecrites1717090000064365170900000643653JO_QUESTION2025-08-1220250032
17090000064514L17/questions_ecrites1717090000064508170900000645081JO_QUESTION2025-11-0420250044
17090000064520L17/questions_ecrites1717090000064515170900000645151JO_QUESTION2025-09-1620250037
17090000064521L17/questions_ecrites1717090000064515170900000645152JO_QUESTION2026-01-2720260004
17090000064522L17/questions_ecrites1717090000064515170900000645153JO_QUESTION2026-06-0220260022
17090000064600L17/questions_ecrites1717090000064593170900000645931JO_QUESTION2025-07-2220250029
17090000064601L17/questions_ecrites1717090000064593170900000645932JO_QUESTION2025-11-0420250044
17090000064602L17/questions_ecrites1717090000064593170900000645933JO_QUESTION2026-02-2420260008
17090000064603L17/questions_ecrites1717090000064593170900000645934JO_QUESTION2026-06-0220260022
17090000064631L17/questions_ecrites1717090000064625170900000646251JO_QUESTION2025-07-2220250029
17090000064651L17/questions_ecrites1717090000064646170900000646461JO_QUESTION2025-07-2220250029
17090000064764L17/questions_ecrites1717090000064759170900000647591JO_QUESTION2026-09-0820260036
17090000064770L17/questions_ecrites1717090000064765170900000647651JO_QUESTION2025-09-3020250039
17090000064771L17/questions_ecrites1717090000064765170900000647652JO_QUESTION2026-02-1020260006
17090000064772L17/questions_ecrites1717090000064765170900000647653JO_QUESTION2026-08-0420260031
17090000064779L17/questions_ecrites1717090000064773170900000647731JO_QUESTION2025-01-2120250003
17090000064785L17/questions_ecrites1717090000064780170900000647801JO_QUESTION2025-10-2820250043
17090000064826L17/questions_ecrites1717090000064821170900000648211JO_QUESTION2026-07-1420260028
17090000064833L17/questions_ecrites1717090000064827170900000648271JO_QUESTION2025-01-2120250003
17090000064893L17/questions_ecrites1717090000064888170900000648881JO_QUESTION2025-01-2120250003
17090000064937L17/questions_ecrites1717090000064931170900000649311JO_QUESTION2025-12-0220250048
17090000064969L17/questions_ecrites1717090000064964170900000649641JO_QUESTION2025-10-2120250042
17090000065090L17/questions_ecrites1717090000065084170900000650841JO_QUESTION2025-10-2120250042
17090000065091L17/questions_ecrites1717090000065084170900000650842JO_QUESTION2026-01-2720260004
17090000065153L17/questions_ecrites1717090000065147170900000651471JO_QUESTION2025-01-2820250004
17090000065154L17/questions_ecrites1717090000065147170900000651472JO_QUESTION2025-05-0620250018
17090000065377L17/questions_ecrites1717090000065372170900000653721JO_QUESTION2025-05-2720250021