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
16090000081599L16/questions_ecrites1616090000081594160900000815941JO_QUESTION2023-10-0320230040
16090000081600L16/questions_ecrites1616090000081594160900000815942JO_QUESTION2024-01-1620240003
16090000081601L16/questions_ecrites1616090000081594160900000815943JO_QUESTION2024-05-1420240020
16090000081636L16/questions_ecrites1616090000081629160900000816291JO_QUESTION2023-10-3120230044
16090000081663L16/questions_ecrites1616090000081659160900000816591JO_QUESTION2022-12-0620220048
16090000081674L16/questions_ecrites1616090000081670160900000816701JO_QUESTION2024-01-2320240004
16090000081679L16/questions_ecrites1616090000081675160900000816751JO_QUESTION2023-10-0320230040
16090000081680L16/questions_ecrites1616090000081675160900000816752JO_QUESTION2024-01-3020240005
16090000081727L16/questions_ecrites1616090000081722160900000817221JO_QUESTION2022-12-0620220048
16090000081758L16/questions_ecrites1616090000081753160900000817531JO_QUESTION2023-10-3120230044
16090000081765L16/questions_ecrites1616090000081759160900000817591JO_QUESTION2023-10-0320230040
16090000081776L16/questions_ecrites1616090000081770160900000817701JO_QUESTION2023-11-0720230045
16090000081787L16/questions_ecrites1616090000081783160900000817831JO_QUESTION2022-11-2920220047
16090000081797L16/questions_ecrites1616090000081792160900000817921JO_QUESTION2023-10-0320230040
16090000081816L16/questions_ecrites1616090000081812160900000818121JO_QUESTION2024-01-2320240004
16090000081821L16/questions_ecrites1616090000081817160900000818171JO_QUESTION2023-11-2820230048
16090000081829L16/questions_ecrites1616090000081822160900000818221JO_QUESTION2023-10-2420230043
16090000081830L16/questions_ecrites1616090000081822160900000818222JO_QUESTION2024-02-0620240006
16090000081831L16/questions_ecrites1616090000081822160900000818223JO_QUESTION2024-05-2120240021
16090000081845L16/questions_ecrites1616090000081838160900000818381JO_QUESTION2023-12-1220230050
16090000081892L16/questions_ecrites1616090000081887160900000818871JO_QUESTION2023-12-0520230049
16090000081928L16/questions_ecrites1616090000081921160900000819211JO_QUESTION2023-12-1220230050
16090000081958L16/questions_ecrites1616090000081954160900000819541JO_QUESTION2023-12-1220230050
16090000081980L16/questions_ecrites1616090000081976160900000819761JO_QUESTION2024-04-1620240016
16090000082002L16/questions_ecrites1616090000081997160900000819971JO_QUESTION2024-02-0620240006
16090000082021L16/questions_ecrites1616090000082016160900000820161JO_QUESTION2023-10-0320230040
16090000082051L16/questions_ecrites1616090000082043160900000820431JO_QUESTION2024-04-1620240016
16090000082071L16/questions_ecrites1616090000082066160900000820661JO_QUESTION2023-11-0720230045
16090000082085L16/questions_ecrites1616090000082081160900000820811JO_QUESTION2023-10-1020230041
16090000082102L16/questions_ecrites1616090000082098160900000820981JO_QUESTION2023-10-3120230044
16090000082103L16/questions_ecrites1616090000082098160900000820982JO_QUESTION2024-02-2020240008
16090000082129L16/questions_ecrites1616090000082125160900000821251JO_QUESTION2023-10-2420230043
16090000082239L16/questions_ecrites1616090000082234160900000822341JO_QUESTION2023-03-1420230011
16090000082240L16/questions_ecrites1616090000082234160900000822342JO_QUESTION2023-09-0520230036
16090000082251L16/questions_ecrites1616090000082245160900000822451JO_QUESTION2023-10-1020230041
16090000082279L16/questions_ecrites1616090000082273160900000822731JO_QUESTION2024-05-0720240019
16090000082291L16/questions_ecrites1616090000082287160900000822871JO_QUESTION2023-10-1020230041
16090000082300L16/questions_ecrites1616090000082296160900000822961JO_QUESTION2022-10-2520220042
16090000082301L16/questions_ecrites1616090000082296160900000822962JO_QUESTION2023-01-3120230005
16090000082343L16/questions_ecrites1616090000082336160900000823361JO_QUESTION2023-10-1720230042
16090000082344L16/questions_ecrites1616090000082336160900000823362JO_QUESTION2024-01-2320240004
16090000082345L16/questions_ecrites1616090000082336160900000823363JO_QUESTION2024-06-1120240024
16090000082389L16/questions_ecrites1616090000082384160900000823841JO_QUESTION2024-02-1320240007
16090000082398L16/questions_ecrites1616090000082394160900000823941JO_QUESTION2023-10-1020230041
16090000082412L16/questions_ecrites1616090000082408160900000824081JO_QUESTION2023-10-1020230041
16090000082448L16/questions_ecrites1616090000082441160900000824411JO_QUESTION2023-10-1020230041
16090000082449L16/questions_ecrites1616090000082441160900000824412JO_QUESTION2024-01-3020240005
16090000082481L16/questions_ecrites1616090000082474160900000824741JO_QUESTION2023-10-1020230041
16090000082487L16/questions_ecrites1616090000082482160900000824821JO_QUESTION2023-10-2420230043
16090000082498L16/questions_ecrites1616090000082493160900000824931JO_QUESTION2023-10-1020230041