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
17090000045981L17/questions_ecrites1717090000045973170900000459731JO_QUESTION2025-12-0220250048
17090000046010L17/questions_ecrites1717090000046005170900000460051JO_QUESTION2025-04-0120250013
17090000046019L17/questions_ecrites1717090000046011170900000460111JO_QUESTION2025-04-0120250013
17090000046020L17/questions_ecrites1717090000046011170900000460112JO_QUESTION2025-07-0820250027
17090000046021L17/questions_ecrites1717090000046011170900000460113JO_QUESTION2025-10-2120250042
17090000046035L17/questions_ecrites1717090000046027170900000460271JO_QUESTION2026-01-2720260004
17090000046036L17/questions_ecrites1717090000046027170900000460272JO_QUESTION2026-09-2220260038
17090000046179L17/questions_ecrites1717090000046172170900000461721JO_QUESTION2025-07-1520250028
17090000046240L17/questions_ecrites1717090000046232170900000462321JO_QUESTION2025-10-2120250042
17090000046311L17/questions_ecrites1717090000046304170900000463041JO_QUESTION2025-04-1520250015
17090000046312L17/questions_ecrites1717090000046304170900000463042JO_QUESTION2025-09-0220250035
17090000046419L17/questions_ecrites1717090000046413170900000464131JO_QUESTION2025-01-2120250003
17090000046420L17/questions_ecrites1717090000046413170900000464132JO_QUESTION2025-04-2920250017
17090000046421L17/questions_ecrites1717090000046413170900000464133JO_QUESTION2025-08-0520250031
17090000046504L17/questions_ecrites1717090000046497170900000464971JO_QUESTION2025-04-1520250015
17090000046505L17/questions_ecrites1717090000046497170900000464972JO_QUESTION2025-08-0520250031
17090000046506L17/questions_ecrites1717090000046497170900000464973JO_QUESTION2025-11-1120250045
17090000046507L17/questions_ecrites1717090000046497170900000464974JO_QUESTION2026-02-1720260007
17090000046508L17/questions_ecrites1717090000046497170900000464975JO_QUESTION2026-05-2620260021
17090000046550L17/questions_ecrites1717090000046541170900000465411JO_QUESTION2025-01-2120250003
17090000046551L17/questions_ecrites1717090000046541170900000465412JO_QUESTION2025-04-2920250017
17090000046552L17/questions_ecrites1717090000046541170900000465413JO_QUESTION2025-08-0520250031
17090000046553L17/questions_ecrites1717090000046541170900000465414JO_QUESTION2025-11-1120250045
17090000046554L17/questions_ecrites1717090000046541170900000465415JO_QUESTION2026-02-1720260007
17090000046555L17/questions_ecrites1717090000046541170900000465416JO_QUESTION2026-05-2620260021
17090000046609L17/questions_ecrites1717090000046600170900000466001JO_QUESTION2025-04-0820250014
17090000046610L17/questions_ecrites1717090000046600170900000466002JO_QUESTION2025-07-2920250030
17090000046611L17/questions_ecrites1717090000046600170900000466003JO_QUESTION2025-11-2520250047
17090000046612L17/questions_ecrites1717090000046600170900000466004JO_QUESTION2026-03-0320260009
17090000046613L17/questions_ecrites1717090000046600170900000466005JO_QUESTION2026-07-2820260030
17090000046619L17/questions_ecrites1717090000046614170900000466141JO_QUESTION2025-04-1520250015
17090000046624L17/questions_ecrites1717090000046620170900000466201JO_QUESTION2025-04-0820250014
17090000046633L17/questions_ecrites1717090000046629170900000466291JO_QUESTION2025-04-0820250014
17090000046756L17/questions_ecrites1717090000046752170900000467521JO_QUESTION2025-04-2920250017
17090000046801L17/questions_ecrites1717090000046796170900000467961JO_QUESTION2025-04-2220250016
17090000046802L17/questions_ecrites1717090000046796170900000467962JO_QUESTION2025-09-3020250039
17090000046803L17/questions_ecrites1717090000046796170900000467963JO_QUESTION2026-01-2720260004
17090000046804L17/questions_ecrites1717090000046796170900000467964JO_QUESTION2026-05-1220260019
17090000046805L17/questions_ecrites1717090000046796170900000467965JO_QUESTION2026-09-2220260038
17090000046811L17/questions_ecrites1717090000046806170900000468061JO_QUESTION2025-04-2220250016
17090000046849L17/questions_ecrites1717090000046843170900000468431JO_QUESTION2025-01-2820250004
17090000046860L17/questions_ecrites1717090000046855170900000468551JO_QUESTION2026-03-1020260010
17090000046861L17/questions_ecrites1717090000046855170900000468552JO_QUESTION2026-06-1620260024
17090000046862L17/questions_ecrites1717090000046855170900000468553JO_QUESTION2026-09-2220260038
17090000046879L17/questions_ecrites1717090000046872170900000468721JO_QUESTION2025-04-2220250016
17090000046880L17/questions_ecrites1717090000046872170900000468722JO_QUESTION2025-09-3020250039
17090000046904L17/questions_ecrites1717090000046898170900000468981JO_QUESTION2025-04-2220250016
17090000046905L17/questions_ecrites1717090000046898170900000468982JO_QUESTION2025-12-1620250050
17090000046911L17/questions_ecrites1717090000046906170900000469061JO_QUESTION2025-01-1420250002
17090000046917L17/questions_ecrites1717090000046912170900000469121JO_QUESTION2025-05-2720250021