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
16090000076309L16/questions_ecrites1616090000076304160900000763042JO_QUESTION2023-02-2820230009
16090000076310L16/questions_ecrites1616090000076304160900000763043JO_QUESTION2023-06-2720230026
16090000076368L16/questions_ecrites1616090000076364160900000763641JO_QUESTION2023-10-0320230040
16090000076369L16/questions_ecrites1616090000076364160900000763642JO_QUESTION2024-04-0920240015
16090000076403L16/questions_ecrites1616090000076397160900000763971JO_QUESTION2024-02-2020240008
16090000076409L16/questions_ecrites1616090000076404160900000764041JO_QUESTION2023-09-2620230039
16090000076410L16/questions_ecrites1616090000076404160900000764042JO_QUESTION2024-01-0920240002
16090000076444L16/questions_ecrites1616090000076438160900000764381JO_QUESTION2023-09-1220230037
16090000076445L16/questions_ecrites1616090000076438160900000764382JO_QUESTION2024-01-0220240001
16090000076446L16/questions_ecrites1616090000076438160900000764383JO_QUESTION2024-06-1120240024
16090000076467L16/questions_ecrites1616090000076463160900000764631JO_QUESTION2023-09-0520230036
16090000076486L16/questions_ecrites1616090000076479160900000764791JO_QUESTION2023-09-1220230037
16090000076487L16/questions_ecrites1616090000076479160900000764792JO_QUESTION2024-01-2320240004
16090000076561L16/questions_ecrites1616090000076557160900000765571JO_QUESTION2024-04-1620240016
16090000076661L16/questions_ecrites1616090000076654160900000766541JO_QUESTION2022-11-1520220045
16090000076662L16/questions_ecrites1616090000076654160900000766542JO_QUESTION2023-02-2820230009
16090000076663L16/questions_ecrites1616090000076654160900000766543JO_QUESTION2023-06-2020230025
16090000076664L16/questions_ecrites1616090000076654160900000766544JO_QUESTION2023-10-1020230041
16090000076665L16/questions_ecrites1616090000076654160900000766545JO_QUESTION2024-02-0620240006
16090000076666L16/questions_ecrites1616090000076654160900000766546JO_QUESTION2024-05-2820240022
16090000076729L16/questions_ecrites1616090000076725160900000767251JO_QUESTION2023-09-1220230037
16090000076750L16/questions_ecrites1616090000076746160900000767461JO_QUESTION2023-10-0320230040
16090000076761L16/questions_ecrites1616090000076755160900000767551JO_QUESTION2023-10-0320230040
16090000076937L16/questions_ecrites1616090000076933160900000769331JO_QUESTION2023-09-2620230039
16090000076938L16/questions_ecrites1616090000076933160900000769332JO_QUESTION2024-02-0620240006
16090000076939L16/questions_ecrites1616090000076933160900000769333JO_QUESTION2024-05-2120240021
16090000077026L16/questions_ecrites1616090000077020160900000770201JO_QUESTION2023-10-1720230042
16090000077027L16/questions_ecrites1616090000077020160900000770202JO_QUESTION2024-03-1220240011
16090000077151L16/questions_ecrites1616090000077146160900000771461JO_QUESTION2023-09-2620230039
16090000077156L16/questions_ecrites1616090000077152160900000771521JO_QUESTION2023-09-1220230037
16090000077161L16/questions_ecrites1616090000077157160900000771571JO_QUESTION2023-10-0320230040
16090000077213L16/questions_ecrites1616090000077208160900000772081JO_QUESTION2023-10-1020230041
16090000077224L16/questions_ecrites1616090000077219160900000772191JO_QUESTION2023-11-2120230047
16090000077251L16/questions_ecrites1616090000077246160900000772461JO_QUESTION2023-09-2620230039
16090000077269L16/questions_ecrites1616090000077265160900000772651JO_QUESTION2023-09-1220230037
16090000077270L16/questions_ecrites1616090000077265160900000772652JO_QUESTION2023-12-1920230051
16090000077271L16/questions_ecrites1616090000077265160900000772653JO_QUESTION2024-03-2620240013
16090000077277L16/questions_ecrites1616090000077272160900000772721JO_QUESTION2023-09-1220230037
16090000077278L16/questions_ecrites1616090000077272160900000772722JO_QUESTION2023-12-1220230050
16090000077279L16/questions_ecrites1616090000077272160900000772723JO_QUESTION2024-03-1920240012
16090000077316L16/questions_ecrites1616090000077309160900000773091JO_QUESTION2023-09-1920230038
16090000077317L16/questions_ecrites1616090000077309160900000773092JO_QUESTION2023-12-2620230052
16090000077318L16/questions_ecrites1616090000077309160900000773093JO_QUESTION2024-06-1120240024
16090000077383L16/questions_ecrites1616090000077378160900000773781JO_QUESTION2023-09-0520230036
16090000077394L16/questions_ecrites1616090000077389160900000773891JO_QUESTION2024-01-2320240004
16090000077429L16/questions_ecrites1616090000077423160900000774231JO_QUESTION2023-10-1720230042
16090000077486L16/questions_ecrites1616090000077481160900000774811JO_QUESTION2023-09-1220230037
16090000077487L16/questions_ecrites1616090000077481160900000774812JO_QUESTION2024-01-0220240001
16090000077488L16/questions_ecrites1616090000077481160900000774813JO_QUESTION2024-06-1120240024
16090000077505L16/questions_ecrites1616090000077499160900000774991JO_QUESTION2024-04-1620240016