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
16090000047480L16/questions_ecrites1616090000047474160900000474741JO_QUESTION2023-04-1820230016
16090000047481L16/questions_ecrites1616090000047474160900000474742JO_QUESTION2023-11-0720230045
16090000047498L16/questions_ecrites1616090000047494160900000474941JO_QUESTION2023-03-0720230010
16090000047499L16/questions_ecrites1616090000047494160900000474942JO_QUESTION2023-07-0420230027
16090000047539L16/questions_ecrites1616090000047534160900000475341JO_QUESTION2023-03-1420230011
16090000047540L16/questions_ecrites1616090000047534160900000475342JO_QUESTION2023-10-1020230041
16090000047560L16/questions_ecrites1616090000047553160900000475531JO_QUESTION2023-12-1220230050
16090000047644L16/questions_ecrites1616090000047638160900000476381JO_QUESTION2023-02-2820230009
16090000047645L16/questions_ecrites1616090000047638160900000476382JO_QUESTION2023-06-2020230025
16090000047646L16/questions_ecrites1616090000047638160900000476383JO_QUESTION2023-10-0320230040
16090000047687L16/questions_ecrites1616090000047682160900000476821JO_QUESTION2023-04-1820230016
16090000047701L16/questions_ecrites1616090000047696160900000476961JO_QUESTION2023-10-0320230040
16090000047770L16/questions_ecrites1616090000047766160900000477661JO_QUESTION2023-03-1420230011
16090000047799L16/questions_ecrites1616090000047795160900000477951JO_QUESTION2023-02-2820230009
16090000047847L16/questions_ecrites1616090000047841160900000478411JO_QUESTION2023-02-2820230009
16090000047848L16/questions_ecrites1616090000047841160900000478412JO_QUESTION2023-07-1820230029
16090000047849L16/questions_ecrites1616090000047841160900000478413JO_QUESTION2024-06-0420240023
16090000047871L16/questions_ecrites1616090000047867160900000478671JO_QUESTION2023-02-2820230009
16090000047941L16/questions_ecrites1616090000047937160900000479371JO_QUESTION2023-08-0120230031
16090000047942L16/questions_ecrites1616090000047937160900000479372JO_QUESTION2024-04-1620240016
16090000048015L16/questions_ecrites1616090000048011160900000480111JO_QUESTION2023-02-2820230009
16090000048016L16/questions_ecrites1616090000048011160900000480112JO_QUESTION2023-06-2020230025
16090000048153L16/questions_ecrites1616090000048148160900000481481JO_QUESTION2022-11-1520220045
16090000048176L16/questions_ecrites1616090000048172160900000481721JO_QUESTION2023-02-2820230009
16090000048182L16/questions_ecrites1616090000048177160900000481771JO_QUESTION2023-02-2820230009
16090000048195L16/questions_ecrites1616090000048188160900000481881JO_QUESTION2023-02-2820230009
16090000048196L16/questions_ecrites1616090000048188160900000481882JO_QUESTION2023-06-2720230026
16090000048197L16/questions_ecrites1616090000048188160900000481883JO_QUESTION2023-10-0320230040
16090000048198L16/questions_ecrites1616090000048188160900000481884JO_QUESTION2024-01-0920240002
16090000048199L16/questions_ecrites1616090000048188160900000481885JO_QUESTION2024-04-2320240017
16090000048204L16/questions_ecrites1616090000048200160900000482001JO_QUESTION2023-02-2820230009
16090000048205L16/questions_ecrites1616090000048200160900000482002JO_QUESTION2023-06-2020230025
16090000048265L16/questions_ecrites1616090000048261160900000482611JO_QUESTION2022-11-1520220045
16090000048266L16/questions_ecrites1616090000048261160900000482612JO_QUESTION2023-02-2820230009
16090000048267L16/questions_ecrites1616090000048261160900000482613JO_QUESTION2023-06-2720230026
16090000048268L16/questions_ecrites1616090000048261160900000482614JO_QUESTION2023-10-0320230040
16090000048269L16/questions_ecrites1616090000048261160900000482615JO_QUESTION2024-01-0920240002
16090000048270L16/questions_ecrites1616090000048261160900000482616JO_QUESTION2024-04-2320240017
16090000048280L16/questions_ecrites1616090000048275160900000482751JO_QUESTION2023-03-1420230011
16090000048301L16/questions_ecrites1616090000048296160900000482961JO_QUESTION2023-04-1820230016
16090000048306L16/questions_ecrites1616090000048302160900000483021JO_QUESTION2023-05-2320230021
16090000048307L16/questions_ecrites1616090000048302160900000483022JO_QUESTION2023-08-2920230035
16090000048308L16/questions_ecrites1616090000048302160900000483023JO_QUESTION2023-12-0520230049
16090000048309L16/questions_ecrites1616090000048302160900000483024JO_QUESTION2024-03-1220240011
16090000048416L16/questions_ecrites1616090000048408160900000484081JO_QUESTION2023-09-0520230036
16090000048421L16/questions_ecrites1616090000048417160900000484171JO_QUESTION2023-02-2820230009
16090000048472L16/questions_ecrites1616090000048465160900000484651JO_QUESTION2023-05-2320230021
16090000048473L16/questions_ecrites1616090000048465160900000484652JO_QUESTION2023-08-2920230035
16090000048474L16/questions_ecrites1616090000048465160900000484653JO_QUESTION2023-12-0520230049
16090000048475L16/questions_ecrites1616090000048465160900000484654JO_QUESTION2024-03-1220240011