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
16090000043396L16/questions_ecrites1616090000043392160900000433921JO_QUESTION2023-01-1720230003
16090000043397L16/questions_ecrites1616090000043392160900000433922JO_QUESTION2023-04-2520230017
16090000043398L16/questions_ecrites1616090000043392160900000433923JO_QUESTION2023-10-0320230040
16090000043427L16/questions_ecrites1616090000043421160900000434211JO_QUESTION2023-11-0720230045
16090000043457L16/questions_ecrites1616090000043452160900000434521JO_QUESTION2022-11-2220220046
16090000043491L16/questions_ecrites1616090000043487160900000434871JO_QUESTION2023-01-3120230005
16090000043528L16/questions_ecrites1616090000043524160900000435241JO_QUESTION2023-01-3120230005
16090000043529L16/questions_ecrites1616090000043524160900000435242JO_QUESTION2024-04-0920240015
16090000043548L16/questions_ecrites1616090000043544160900000435441JO_QUESTION2023-02-0720230006
16090000043655L16/questions_ecrites1616090000043650160900000436501JO_QUESTION2022-11-1520220045
16090000043656L16/questions_ecrites1616090000043650160900000436502JO_QUESTION2023-03-2120230012
16090000043657L16/questions_ecrites1616090000043650160900000436503JO_QUESTION2023-08-0120230031
16090000043658L16/questions_ecrites1616090000043650160900000436504JO_QUESTION2023-11-0720230045
16090000043679L16/questions_ecrites1616090000043673160900000436731JO_QUESTION2023-01-3120230005
16090000043727L16/questions_ecrites1616090000043722160900000437221JO_QUESTION2023-12-1220230050
16090000043745L16/questions_ecrites1616090000043741160900000437411JO_QUESTION2023-02-2820230009
16090000043764L16/questions_ecrites1616090000043760160900000437601JO_QUESTION2023-06-2020230025
16090000043765L16/questions_ecrites1616090000043760160900000437602JO_QUESTION2024-02-2020240008
16090000043766L16/questions_ecrites1616090000043760160900000437603JO_QUESTION2024-06-0420240023
16090000043941L16/questions_ecrites1616090000043936160900000439361JO_QUESTION2023-02-0720230006
16090000043990L16/questions_ecrites1616090000043986160900000439861JO_QUESTION2023-02-2820230009
16090000044048L16/questions_ecrites1616090000044043160900000440431JO_QUESTION2023-04-2520230017
16090000044049L16/questions_ecrites1616090000044043160900000440432JO_QUESTION2023-10-1720230042
16090000044068L16/questions_ecrites1616090000044064160900000440641JO_QUESTION2022-11-1520220045
16090000044150L16/questions_ecrites1616090000044145160900000441451JO_QUESTION2023-01-3120230005
16090000044311L16/questions_ecrites1616090000044307160900000443071JO_QUESTION2023-06-1320230024
16090000044320L16/questions_ecrites1616090000044316160900000443161JO_QUESTION2022-11-1520220045
16090000044366L16/questions_ecrites1616090000044361160900000443611JO_QUESTION2022-11-1520220045
16090000044367L16/questions_ecrites1616090000044361160900000443612JO_QUESTION2023-03-2820230013
16090000044368L16/questions_ecrites1616090000044361160900000443613JO_QUESTION2023-10-0320230040
16090000044440L16/questions_ecrites1616090000044435160900000444351JO_QUESTION2023-01-3120230005
16090000044549L16/questions_ecrites1616090000044544160900000445441JO_QUESTION2023-02-2820230009
16090000044584L16/questions_ecrites1616090000044580160900000445801JO_QUESTION2023-04-0420230014
16090000044597L16/questions_ecrites1616090000044593160900000445931JO_QUESTION2023-06-0620230023
16090000044632L16/questions_ecrites1616090000044626160900000446261JO_QUESTION2023-01-3120230005
16090000044633L16/questions_ecrites1616090000044626160900000446262JO_QUESTION2023-05-3020230022
16090000044662L16/questions_ecrites1616090000044657160900000446571JO_QUESTION2023-06-0620230023
16090000044777L16/questions_ecrites1616090000044773160900000447731JO_QUESTION2022-11-1520220045
16090000044832L16/questions_ecrites1616090000044828160900000448281JO_QUESTION2023-01-3120230005
16090000044868L16/questions_ecrites1616090000044864160900000448641JO_QUESTION2023-04-0420230014
16090000044918L16/questions_ecrites1616090000044914160900000449141JO_QUESTION2023-03-2120230012
16090000044940L16/questions_ecrites1616090000044933160900000449331JO_QUESTION2023-10-1720230042
16090000044941L16/questions_ecrites1616090000044933160900000449332JO_QUESTION2024-05-1420240020
16090000045012L16/questions_ecrites1616090000045009160900000450091JO_QUESTION2023-03-2120230012
16090000045066L16/questions_ecrites1616090000045062160900000450621JO_QUESTION2023-02-0720230006
16090000045067L16/questions_ecrites1616090000045062160900000450622JO_QUESTION2023-06-0620230023
16090000045086L16/questions_ecrites1616090000045081160900000450811JO_QUESTION2023-01-3120230005
16090000045087L16/questions_ecrites1616090000045081160900000450812JO_QUESTION2023-05-3020230022
16090000045088L16/questions_ecrites1616090000045081160900000450813JO_QUESTION2023-10-0320230040
16090000045142L16/questions_ecrites1616090000045135160900000451351JO_QUESTION2023-11-2820230048