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
17090000060277L17/questions_ecrites1717090000060264170900000602646JO_QUESTION2026-05-1220260019
17090000060278L17/questions_ecrites1717090000060264170900000602647JO_QUESTION2026-09-0120260035
17090000060328L17/questions_ecrites1717090000060322170900000603221JO_QUESTION2025-11-1120250045
17090000060450L17/questions_ecrites1717090000060438170900000604381JO_QUESTION2025-01-2820250004
17090000060451L17/questions_ecrites1717090000060438170900000604382JO_QUESTION2025-05-0620250018
17090000060452L17/questions_ecrites1717090000060438170900000604383JO_QUESTION2025-08-1220250032
17090000060453L17/questions_ecrites1717090000060438170900000604384JO_QUESTION2025-11-1820250046
17090000060454L17/questions_ecrites1717090000060438170900000604385JO_QUESTION2026-02-2420260008
17090000060626L17/questions_ecrites1717090000060619170900000606191JO_QUESTION2025-01-2120250003
17090000060627L17/questions_ecrites1717090000060619170900000606192JO_QUESTION2025-04-2920250017
17090000060628L17/questions_ecrites1717090000060619170900000606193JO_QUESTION2025-08-0520250031
17090000060635L17/questions_ecrites1717090000060629170900000606291JO_QUESTION2025-07-0820250027
17090000060636L17/questions_ecrites1717090000060629170900000606292JO_QUESTION2026-05-0520260018
17090000060650L17/questions_ecrites1717090000060642170900000606421JO_QUESTION2025-07-2220250029
17090000060702L17/questions_ecrites1717090000060695170900000606951JO_QUESTION2025-07-0120250026
17090000060703L17/questions_ecrites1717090000060695170900000606952JO_QUESTION2025-10-2120250042
17090000060782L17/questions_ecrites1717090000060775170900000607751JO_QUESTION2025-07-0120250026
17090000060810L17/questions_ecrites1717090000060805170900000608051JO_QUESTION2025-02-2520250008
17090000060885L17/questions_ecrites1717090000060877170900000608771JO_QUESTION2025-09-2320250038
17090000060891L17/questions_ecrites1717090000060886170900000608861JO_QUESTION2025-07-0120250026
17090000060892L17/questions_ecrites1717090000060886170900000608862JO_QUESTION2025-11-0420250044
17090000060893L17/questions_ecrites1717090000060886170900000608863JO_QUESTION2026-02-1720260007
17090000060894L17/questions_ecrites1717090000060886170900000608864JO_QUESTION2026-06-1620260024
17090000060914L17/questions_ecrites1717090000060907170900000609071JO_QUESTION2025-07-2920250030
17090000060915L17/questions_ecrites1717090000060907170900000609072JO_QUESTION2025-11-2520250047
17090000060916L17/questions_ecrites1717090000060907170900000609073JO_QUESTION2026-07-1420260028
17090000060956L17/questions_ecrites1717090000060950170900000609501JO_QUESTION2025-07-0120250026
17090000060957L17/questions_ecrites1717090000060950170900000609502JO_QUESTION2025-10-2820250043
17090000060958L17/questions_ecrites1717090000060950170900000609503JO_QUESTION2026-02-1720260007
17090000060959L17/questions_ecrites1717090000060950170900000609504JO_QUESTION2026-07-2820260030
17090000060981L17/questions_ecrites1717090000060975170900000609751JO_QUESTION2026-05-2620260021
17090000060982L17/questions_ecrites1717090000060975170900000609752JO_QUESTION2026-09-2220260038
17090000061004L17/questions_ecrites1717090000060999170900000609991JO_QUESTION2025-03-1120250010
17090000061165L17/questions_ecrites1717090000061159170900000611591JO_QUESTION2025-02-1120250006
17090000061166L17/questions_ecrites1717090000061159170900000611592JO_QUESTION2025-06-1720250024
17090000061337L17/questions_ecrites1717090000061333170900000613331JO_QUESTION2025-07-0820250027
17090000061429L17/questions_ecrites1717090000061425170900000614251JO_QUESTION2025-07-0820250027
17090000061442L17/questions_ecrites1717090000061435170900000614351JO_QUESTION2025-01-2120250003
17090000061443L17/questions_ecrites1717090000061435170900000614352JO_QUESTION2025-04-2920250017
17090000061444L17/questions_ecrites1717090000061435170900000614353JO_QUESTION2025-08-0520250031
17090000061455L17/questions_ecrites1717090000061449170900000614491JO_QUESTION2025-07-0820250027
17090000061456L17/questions_ecrites1717090000061449170900000614492JO_QUESTION2025-10-2120250042
17090000061457L17/questions_ecrites1717090000061449170900000614493JO_QUESTION2026-01-2720260004
17090000061458L17/questions_ecrites1717090000061449170900000614494JO_QUESTION2026-05-1220260019
17090000061551L17/questions_ecrites1717090000061544170900000615441JO_QUESTION2026-02-1020260006
17090000061632L17/questions_ecrites1717090000061626170900000616261JO_QUESTION2025-09-3020250039
17090000061791L17/questions_ecrites1717090000061783170900000617831JO_QUESTION2025-07-0820250027
17090000061899L17/questions_ecrites1717090000061893170900000618931JO_QUESTION2025-11-0420250044
17090000061907L17/questions_ecrites1717090000061900170900000619001JO_QUESTION2025-10-2120250042
17090000062027L17/questions_ecrites1717090000062022170900000620221JO_QUESTION2025-07-0820250027