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
16090000052593L16/questions_ecrites1616090000052588160900000525881JO_QUESTION2023-05-1620230020
16090000052671L16/questions_ecrites1616090000052667160900000526671JO_QUESTION2022-11-1520220045
16090000052677L16/questions_ecrites1616090000052672160900000526721JO_QUESTION2023-03-2820230013
16090000052695L16/questions_ecrites1616090000052690160900000526901JO_QUESTION2023-04-0420230014
16090000052696L16/questions_ecrites1616090000052690160900000526902JO_QUESTION2023-07-1120230028
16090000052722L16/questions_ecrites1616090000052715160900000527151JO_QUESTION2023-04-1820230016
16090000052723L16/questions_ecrites1616090000052715160900000527152JO_QUESTION2023-10-1020230041
16090000052724L16/questions_ecrites1616090000052715160900000527153JO_QUESTION2024-04-0220240014
16090000052772L16/questions_ecrites1616090000052768160900000527681JO_QUESTION2023-06-2720230026
16090000052809L16/questions_ecrites1616090000052804160900000528041JO_QUESTION2023-06-2720230026
16090000052810L16/questions_ecrites1616090000052804160900000528042JO_QUESTION2023-11-1420230046
16090000052827L16/questions_ecrites1616090000052823160900000528231JO_QUESTION2024-03-1220240011
16090000052836L16/questions_ecrites1616090000052832160900000528321JO_QUESTION2023-04-0420230014
16090000052849L16/questions_ecrites1616090000052845160900000528451JO_QUESTION2023-04-0420230014
16090000052947L16/questions_ecrites1616090000052939160900000529391JO_QUESTION2023-03-2120230012
16090000052948L16/questions_ecrites1616090000052939160900000529392JO_QUESTION2023-07-2520230030
16090000052949L16/questions_ecrites1616090000052939160900000529393JO_QUESTION2023-12-1220230050
16090000052983L16/questions_ecrites1616090000052979160900000529791JO_QUESTION2023-04-0420230014
16090000053094L16/questions_ecrites1616090000053087160900000530871JO_QUESTION2023-10-3120230044
16090000053149L16/questions_ecrites1616090000053145160900000531451JO_QUESTION2023-04-0420230014
16090000053348L16/questions_ecrites1616090000053344160900000533441JO_QUESTION2023-04-0420230014
16090000053495L16/questions_ecrites1616090000053490160900000534901JO_QUESTION2023-04-1820230016
16090000053511L16/questions_ecrites1616090000053504160900000535041JO_QUESTION2023-04-0420230014
16090000053512L16/questions_ecrites1616090000053504160900000535042JO_QUESTION2023-07-1120230028
16090000053513L16/questions_ecrites1616090000053504160900000535043JO_QUESTION2023-10-3120230044
16090000053514L16/questions_ecrites1616090000053504160900000535044JO_QUESTION2024-02-0620240006
16090000053515L16/questions_ecrites1616090000053504160900000535045JO_QUESTION2024-06-0420240023
16090000053527L16/questions_ecrites1616090000053520160900000535201JO_QUESTION2023-07-1120230028
16090000053528L16/questions_ecrites1616090000053520160900000535202JO_QUESTION2023-12-0520230049
16090000053529L16/questions_ecrites1616090000053520160900000535203JO_QUESTION2024-04-0220240014
16090000053555L16/questions_ecrites1616090000053551160900000535511JO_QUESTION2023-04-0420230014
16090000053573L16/questions_ecrites1616090000053568160900000535681JO_QUESTION2023-03-2820230013
16090000053574L16/questions_ecrites1616090000053568160900000535682JO_QUESTION2023-07-1120230028
16090000053575L16/questions_ecrites1616090000053568160900000535683JO_QUESTION2023-10-3120230044
16090000053576L16/questions_ecrites1616090000053568160900000535684JO_QUESTION2024-02-0620240006
16090000053577L16/questions_ecrites1616090000053568160900000535685JO_QUESTION2024-05-2820240022
16090000053606L16/questions_ecrites1616090000053602160900000536021JO_QUESTION2023-03-2820230013
16090000053618L16/questions_ecrites1616090000053611160900000536111JO_QUESTION2022-11-2220220046
16090000053619L16/questions_ecrites1616090000053611160900000536112JO_QUESTION2023-05-1620230020
16090000053784L16/questions_ecrites1616090000053780160900000537801JO_QUESTION2023-04-0420230014
16090000053804L16/questions_ecrites1616090000053800160900000538001JO_QUESTION2023-04-0420230014
16090000053805L16/questions_ecrites1616090000053800160900000538002JO_QUESTION2023-11-2820230048
16090000053806L16/questions_ecrites1616090000053800160900000538003JO_QUESTION2024-03-1220240011
16090000053902L16/questions_ecrites1616090000053896160900000538961JO_QUESTION2023-04-2520230017
16090000053903L16/questions_ecrites1616090000053896160900000538962JO_QUESTION2023-10-0320230040
16090000053920L16/questions_ecrites1616090000053916160900000539161JO_QUESTION2023-04-1120230015
16090000053921L16/questions_ecrites1616090000053916160900000539162JO_QUESTION2024-06-1120240024
16090000053935L16/questions_ecrites1616090000053930160900000539301JO_QUESTION2023-04-1820230016
16090000053936L16/questions_ecrites1616090000053930160900000539302JO_QUESTION2023-08-0820230032
16090000053937L16/questions_ecrites1616090000053930160900000539303JO_QUESTION2023-11-2820230048