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
16090000051335L16/questions_ecrites1616090000051329160900000513292JO_QUESTION2024-02-2020240008
16090000051336L16/questions_ecrites1616090000051329160900000513293JO_QUESTION2024-05-2820240022
16090000051370L16/questions_ecrites1616090000051365160900000513651JO_QUESTION2023-04-2520230017
16090000051384L16/questions_ecrites1616090000051379160900000513791JO_QUESTION2023-03-1420230011
16090000051385L16/questions_ecrites1616090000051379160900000513792JO_QUESTION2023-10-1020230041
16090000051407L16/questions_ecrites1616090000051402160900000514021JO_QUESTION2023-09-0520230036
16090000051437L16/questions_ecrites1616090000051433160900000514331JO_QUESTION2023-05-1620230020
16090000051448L16/questions_ecrites1616090000051442160900000514421JO_QUESTION2023-03-1420230011
16090000051515L16/questions_ecrites1616090000051511160900000515111JO_QUESTION2023-03-1420230011
16090000051520L16/questions_ecrites1616090000051516160900000515161JO_QUESTION2023-03-1420230011
16090000051540L16/questions_ecrites1616090000051533160900000515331JO_QUESTION2023-05-2320230021
16090000051557L16/questions_ecrites1616090000051553160900000515531JO_QUESTION2023-03-1420230011
16090000051589L16/questions_ecrites1616090000051582160900000515821JO_QUESTION2023-03-1420230011
16090000051645L16/questions_ecrites1616090000051640160900000516401JO_QUESTION2023-05-0920230019
16090000051654L16/questions_ecrites1616090000051650160900000516501JO_QUESTION2023-02-2820230009
16090000051673L16/questions_ecrites1616090000051668160900000516681JO_QUESTION2023-05-1620230020
16090000051692L16/questions_ecrites1616090000051686160900000516861JO_QUESTION2023-04-1820230016
16090000051693L16/questions_ecrites1616090000051686160900000516862JO_QUESTION2023-12-1920230051
16090000051715L16/questions_ecrites1616090000051709160900000517091JO_QUESTION2023-05-1620230020
16090000051716L16/questions_ecrites1616090000051709160900000517092JO_QUESTION2023-10-2420230043
16090000051717L16/questions_ecrites1616090000051709160900000517093JO_QUESTION2024-01-3020240005
16090000051803L16/questions_ecrites1616090000051799160900000517991JO_QUESTION2023-04-0420230014
16090000051822L16/questions_ecrites1616090000051818160900000518181JO_QUESTION2023-04-0420230014
16090000051823L16/questions_ecrites1616090000051818160900000518182JO_QUESTION2023-08-0120230031
16090000051824L16/questions_ecrites1616090000051818160900000518183JO_QUESTION2024-03-1220240011
16090000051830L16/questions_ecrites1616090000051825160900000518251JO_QUESTION2023-03-2120230012
16090000051848L16/questions_ecrites1616090000051840160900000518401JO_QUESTION2023-03-1420230011
16090000051849L16/questions_ecrites1616090000051840160900000518402JO_QUESTION2023-08-0820230032
16090000051850L16/questions_ecrites1616090000051840160900000518403JO_QUESTION2023-11-1420230046
16090000051859L16/questions_ecrites1616090000051851160900000518511JO_QUESTION2023-03-1420230011
16090000051860L16/questions_ecrites1616090000051851160900000518512JO_QUESTION2023-06-2020230025
16090000051861L16/questions_ecrites1616090000051851160900000518513JO_QUESTION2023-10-1020230041
16090000051862L16/questions_ecrites1616090000051851160900000518514JO_QUESTION2024-02-0620240006
16090000051997L16/questions_ecrites1616090000051993160900000519931JO_QUESTION2023-03-1420230011
16090000052027L16/questions_ecrites1616090000052023160900000520231JO_QUESTION2023-04-2520230017
16090000052074L16/questions_ecrites1616090000052067160900000520671JO_QUESTION2023-03-1420230011
16090000052075L16/questions_ecrites1616090000052067160900000520672JO_QUESTION2023-06-2020230025
16090000052076L16/questions_ecrites1616090000052067160900000520673JO_QUESTION2023-10-1020230041
16090000052077L16/questions_ecrites1616090000052067160900000520674JO_QUESTION2024-02-0620240006
16090000052078L16/questions_ecrites1616090000052067160900000520675JO_QUESTION2024-05-2820240022
16090000052219L16/questions_ecrites1616090000052214160900000522141JO_QUESTION2023-04-0420230014
16090000052220L16/questions_ecrites1616090000052214160900000522142JO_QUESTION2023-11-2820230048
16090000052225L16/questions_ecrites1616090000052221160900000522211JO_QUESTION2023-04-0420230014
16090000052238L16/questions_ecrites1616090000052234160900000522341JO_QUESTION2023-04-1120230015
16090000052385L16/questions_ecrites1616090000052380160900000523801JO_QUESTION2023-04-0420230014
16090000052454L16/questions_ecrites1616090000052450160900000524501JO_QUESTION2023-03-2820230013
16090000052472L16/questions_ecrites1616090000052467160900000524671JO_QUESTION2022-11-1520220045
16090000052522L16/questions_ecrites1616090000052517160900000525171JO_QUESTION2022-11-1520220045
16090000052556L16/questions_ecrites1616090000052552160900000525521JO_QUESTION2023-04-2520230017
16090000052573L16/questions_ecrites1616090000052569160900000525691JO_QUESTION2023-04-0420230014