dossiers.dossier_parlementaire_acte_legislatif_info_jo_rect
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect · présence : L15 0 %, L14 1 %
44 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | type_jo | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.typeJO · présence : L15 0 %, L14 1 % |
| 10 | date_jo | DATE | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.dateJO · présence : L15 0 %, L14 1 % |
| 11 | page_jo | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.pageJO · présence : L15 0 %, L14 1 % |
| 12 | num_jo | BIGINT | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.numJO · présence : L15 0 %, L14 1 % |
| 13 | url_legifrance | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.urlLegifrance · présence : L15 0 % |
| 14 | reference_nor | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.infoJORect.referenceNOR · présence : L15 0 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | type_jo | date_jo | page_jo | num_jo | url_legifrance | reference_nor |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15060000130031 | L15/dossiers | 15 | 15060000129977 | 15060000130030 | 1 | 1 | JO_LOI_DECRET | 2018-01-20 | 16 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=SSAH1712342Z | SSAH1712342Z | ||
| 15060000130564 | L15/dossiers | 15 | 15060000130146 | 15060000130563 | 1 | 1 | JO_LOI_DECRET | 2018-01-20 | 16 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAX1723900Z | CPAX1723900Z | ||
| 15060000132142 | L15/dossiers | 15 | 15060000132048 | 15060000132141 | 1 | 1 | JO_LOI_DECRET | 2018-11-17 | 266 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAX1723907Z | CPAX1723907Z | ||
| 15060000136523 | L15/dossiers | 15 | 15060000136489 | 15060000136522 | 1 | 1 | JO_LOI_DECRET | 2018-04-21 | 93 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=MENX1805338Z | MENX1805338Z | ||
| 15060000137076 | L15/dossiers | 15 | 15060000136945 | 15060000137075 | 1 | 1 | JO_LOI_DECRET | 2018-11-10 | 260 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=INTX1801788Z | INTX1801788Z | ||
| 15060000140880 | L15/dossiers | 15 | 15060000140732 | 15060000140879 | 1 | 1 | JO_LOI_DECRET | 2019-06-15 | 137 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=ECOT1810669Z | ECOT1810669Z | ||
| 15060000141242 | L15/dossiers | 15 | 15060000140896 | 15060000141241 | 1 | 1 | JO_LOI_DECRET | 2019-01-12 | 10 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAX1823550Z | CPAX1823550Z | ||
| 15060000144213 | L15/dossiers | 15 | 15060000144132 | 15060000144212 | 1 | 1 | JO_LOI_DECRET | 2018-12-15 | 290 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAX1827882Z | CPAX1827882Z | ||
| 15060000144546 | L15/dossiers | 15 | 15060000144479 | 15060000144545 | 1 | 1 | JO_LOI_DECRET | 2019-07-27 | 173 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=TREL1827740Z | TREL1827740Z | ||
| 15060000148565 | L15/dossiers | 15 | 15060000148481 | 15060000148564 | 1 | 1 | JO_LOI_DECRET | 2019-09-07 | 208 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAF1832065Z | CPAF1832065Z | ||
| 15060000153856 | L15/dossiers | 15 | 15060000153738 | 15060000153855 | 1 | 1 | JO_LOI_DECRET | 2020-01-11 | 9 | http://www.legifrance.gouv.fr/WAspad/UnTexteDeJorf?numjo=CPAX1927098Z | CPAX1927098Z | ||
| 14060000091145 | L14/dossiers | 14 | 14060000090723 | 14060000091144 | 1 | 1 | JO_LOI_DECRET | 2015-04-04 | 80 | ||||
| 14060000094368 | L14/dossiers | 14 | 14060000094310 | 14060000094367 | 1 | 1 | JO_LOI_DECRET | 2013-10-12 | 238 | ||||
| 14060000097220 | L14/dossiers | 14 | 14060000097157 | 14060000097219 | 1 | 1 | JO_LOI_DECRET | 2013-11-14 | 264 | ||||
| 14060000097348 | L14/dossiers | 14 | 14060000097301 | 14060000097347 | 1 | 1 | JO_LOI_DECRET | 2016-05-28 | 123 | ||||
| 14060000097623 | L14/dossiers | 14 | 14060000097487 | 14060000097622 | 1 | 1 | JO_LOI_DECRET | 2014-06-21 | 142 | ||||
| 14060000097624 | L14/dossiers | 14 | 14060000097487 | 14060000097622 | 2 | 1 | JO_LOI_DECRET | 2014-09-30 | 226 | ||||
| 14060000097804 | L14/dossiers | 14 | 14060000097719 | 14060000097803 | 1 | 1 | JO_LOI_DECRET | 2014-02-08 | 33 | ||||
| 14060000099103 | L14/dossiers | 14 | 14060000098680 | 14060000099102 | 1 | 1 | JO_LOI_DECRET | 2016-01-16 | 13 | ||||
| 14060000100119 | L14/dossiers | 14 | 14060000099774 | 14060000100118 | 1 | 1 | JO_LOI_DECRET | 2013-02-22 | 45 | ||||
| 14060000102644 | L14/dossiers | 14 | 14060000102567 | 14060000102643 | 1 | 1 | JO_LOI_DECRET | 2015-01-03 | 2 | ||||
| 14060000103106 | L14/dossiers | 14 | 14060000103040 | 14060000103105 | 1 | 1 | JO_LOI_DECRET | 2014-09-13 | 212 | ||||
| 14060000107083 | L14/dossiers | 14 | 14060000106995 | 14060000107082 | 1 | 1 | JO_LOI_DECRET | 2013-11-14 | 264 | ||||
| 14060000107922 | L14/dossiers | 14 | 14060000107748 | 14060000107921 | 1 | 1 | JO_LOI_DECRET | 2015-08-08 | 182 | ||||
| 14060000107923 | L14/dossiers | 14 | 14060000107748 | 14060000107921 | 2 | 1 | JO_LOI_DECRET | 2015-08-22 | 193 | ||||
| 14060000110278 | L14/dossiers | 14 | 14060000110204 | 14060000110277 | 1 | 1 | JO_LOI_DECRET | 2013-10-12 | 238 | ||||
| 14060000110357 | L14/dossiers | 14 | 14060000110282 | 14060000110356 | 1 | 1 | JO_LOI_DECRET | 2013-10-12 | 238 | ||||
| 14060000110473 | L14/dossiers | 14 | 14060000110362 | 14060000110472 | 1 | 1 | JO_LOI_DECRET | 2013-11-14 | 264 | ||||
| 14060000110928 | L14/dossiers | 14 | 14060000110876 | 14060000110927 | 1 | 1 | JO_LOI_DECRET | 2013-10-01 | 228 | ||||
| 14060000114361 | L14/dossiers | 14 | 14060000114226 | 14060000114360 | 1 | 1 | JO_LOI_DECRET | 2015-01-03 | 2 | ||||
| 14060000115684 | L14/dossiers | 14 | 14060000115594 | 14060000115683 | 1 | 1 | JO_LOI_DECRET | 2013-12-03 | 280 | ||||
| 14060000115961 | L14/dossiers | 14 | 14060000115887 | 14060000115960 | 1 | 1 | JO_LOI_DECRET | 2014-07-09 | 157 | ||||
| 14060000119923 | L14/dossiers | 14 | 14060000119790 | 14060000119922 | 1 | 1 | JO_LOI_DECRET | 2015-01-31 | 26 | ||||
| 14060000121648 | L14/dossiers | 14 | 14060000121504 | 14060000121647 | 1 | 1 | JO_LOI_DECRET | 2016-04-09 | 84 | ||||
| 14060000121649 | L14/dossiers | 14 | 14060000121504 | 14060000121647 | 2 | 1 | JO_LOI_DECRET | 2016-11-19 | 269 | ||||
| 14060000121988 | L14/dossiers | 14 | 14060000121873 | 14060000121987 | 1 | 1 | JO_LOI_DECRET | 2013-02-01 | 27 | ||||
| 14060000123433 | L14/dossiers | 14 | 14060000123368 | 14060000123432 | 1 | 1 | JO_LOI_DECRET | 2012-11-30 | 279 | ||||
| 14060000124042 | L14/dossiers | 14 | 14060000123945 | 14060000124041 | 1 | 1 | JO_LOI_DECRET | 2015-01-10 | 8 | ||||
| 14060000125861 | L14/dossiers | 14 | 14060000125749 | 14060000125860 | 1 | 1 | JO_LOI_DECRET | 2016-01-16 | 13 | ||||
| 14060000128782 | L14/dossiers | 14 | 14060000128700 | 14060000128781 | 1 | 1 | JO_LOI_DECRET | 2013-02-22 | 45 | ||||
| 14060000129553 | L14/dossiers | 14 | 14060000129463 | 14060000129552 | 1 | 1 | JO_LOI_DECRET | 2012-09-01 | 203 | ||||
| 14060000132206 | L14/dossiers | 14 | 14060000132099 | 14060000132205 | 1 | 1 | JO_LOI_DECRET | 2016-01-01 | 1 | ||||
| 14060000135135 | L14/dossiers | 14 | 14060000135007 | 14060000135134 | 1 | 1 | JO_LOI_DECRET | 2017-01-31 | 26 | ||||
| 14060000135352 | L14/dossiers | 14 | 14060000135261 | 14060000135351 | 1 | 1 | JO_LOI_DECRET | 2013-02-22 | 45 |