{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["non admission frontière","asile frontière","rétention","mesures exécutées","ESI","ELOI","nat et faux docs","Filières","LPC","Top 20 LPC","AME","Mise en cause","Index 93 94 95","index 94","INDEX 93 et 95","index 81_82_83","Aides aux retours","contribution spéciale OFII","fraude docs"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"non admission frontière","index":0,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["T I3-1","Non-admissions et réadmissions simplifiées"]
[]
[null,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,"2014 / 2015","2015 / 2016","2016 / 2017"]
["Nombre de refus d'admission",17628,15819,10456,11459,11508,12029,11537,15849,63732,85408,0.37375400884111987,3.0212000757145563,0.34011171781836441]
["Nombre de réadmissions simplifiées (sens France vers étranger)",11844,11178,9255,11477,11548,9894,24262,24842,5852,5010,2.3905696150358584E-2,-0.76443120521697128,-0.14388243335611756]
["Total",29472,26997,19711,22936,23056,21923,35799,40691,69584,90418,0.13665186178384872,0.71005873534688257,0.29940790986433663]
[]
["source"]

{"sheet":"asile frontière","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["I3-2","Nombre de demandes d'asile à la frontière"]
[]
["Années","Nombre de demandes"]
[2007,5639]
[2008,6415]
[2009,3576]
[2010,2789]
[2011,2572]
[2012,2223]
[2013,1402]
[2014,1129]
[2015,937]
[2016,989]
[2017,1386]
[]
[]
["Chiffres DCPAF"]

{"sheet":"rétention","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["I3-5","Placement en centre de rétention administrative"]
[]
[null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017,"2017 / 2016"]
[null,"Capacité théorique :"]
[null,"-métropole",1480,1646,1726,1672,1633,1571,1554,1554,1601,3.0244530244530245E-2]
[null,"-outre-mer",144,144,144,144,184,184,227,227,227,0]
[null,"- total",1624,1790,1870,1816,1817,1755,1781,1781,1828,2.6389668725435148E-2]
[null,"Nombre de personnes placées en CRA :"]
[null,"- métropole",31608,27450,24544,23394,24176,25018,26266,22730,26003,0.14399472063352398]
[null,"- outre-mer",27699,32880,24009,16595,14090,16301,13828,16890,17388,2.9484902309058616E-2]
[null,"Total personnes en CRA",57969,60330,48553,39989,38266,41319,40094,39620,43391,9.517920242301868E-2]
[null,"Mineurs accompagnants placés en CRA :"]
[null,"- métropole",null,null,478,98,41,42,112,181,308,0.7016574585635359]
[null,"- outre-mer",null,null,2553,3990,3711,5058,4378,4285,2602,-0.39276546091015169]
[null,"Total mineurs",null,null,3031,4088,3752,5100,4490,4466,2910,-0.34841021047917597]
[null,"Taux d'occupation moyen"]
[null,"- métropole",0.6,0.55000000000000004,0.46700000000000003,0.505,0.48299999999999998,0.52700000000000002,0.54100000000000004,0.49399999999999999,0.57899999999999996,0.17206477732793515]
[null,"- outre-mer",0.69,0.56999999999999995,0.29799999999999999,0.26400000000000001,0.23799999999999999,0.30599999999999999,0.21299999999999999,0.24199999999999999,0.22,-9.0909090909090884E-2]
[null,"Durée moyenne de la rétention (en jours)"]
[null,"- métropole",10.199999999999999,10.029999999999999,8.6999999999999993,11,11.9,12.1,11.6,12.2,12.4,1.6393442622950907E-2]
[null,"- outre-mer",1.3,0.9,0.9,1,0.9,1,0.8,0.9,0.9,0]
[null,"Source : DGEF"]

{"sheet":"mesures exécutées","index":3,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,0,4,0],[5,0,6,0],[7,0,8,0],[17,0,24,0],[26,0,27,0],[31,0,32,0],[9,0,10,0],[11,0,12,0],[13,0,14,0]]}
["I3-9","Mesures prononcées et exécutées "]
[]
[null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017,null,"2017 / 2016"]
["Retours RPT","Prononcées",77697,66877,76526,72333,80178,81979,75668,77886,81866,null,5.1100326117659141E-2]
[null,"Exécutées",13623,11975,11775,12769,11415,12040,10909,9498,9829,null,3.4849441987786903E-2]
["Réadmissions RPT dans UE","Prononcées",12165,10849,7970,6204,6287,6178,7154,8305,17251,null,1.0771824202287779]
[null,"Exécutées",4156,3504,5728,6316,6038,5314,5014,3338,4589,null,0.37477531455961655]
["Renvois ressortissants UE","Prononcées",4951,6620,9608,12331,10932,8072,6169,5939,4823,null,-0.1879104226300724]
[null,"Exécutées",3275,4143,5424,7727,5300,4135,4068,3653,3739,null,2.3542294004927456E-2]
["Départs volontaires aidés","Prononcées","-","-","-","-","-","-","-","-","-"]
[null,"Exécutées",8278,8404,9985,10010,4328,2930,3093,2627,3778,null,0.4381423677198325]
["Départs spontanés","Prononcées","-","-","-","-","-","-","-","-","-"]
[null,"Exécutées",null,null,null,null,null,3187,6512,5591,5438,null,-2.7365408692541584E-2]
["Total","Prononcées",94813,84346,94104,90868,97397,96229,88991,92130,103940,null,0.12818842939324868]
[null,"Exécutées",29332,28026,32912,36822,27081,27606,29596,24707,27373,null,0.10790464240903387]
[]
[null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Eloignements non aidés","retours forcés RPT*",8253,6401,4015,4136,"4 656",6515,7039,6539,6909]
[null,"dont vers les pays tiers",8230,6374,3992,4127,4650,5675,6311,6166,6596]
[null,"réadmissions RPT*",null,null,5728,6316,6038,5314,5014,3338,4589]
[null,"renvois forcés RUE**",1499,2129,2804,"2 934",3382,3332,3432,3084,2772]
[null,"Total forcés",13908,12034,12547,13386,14076,15161,15485,12961,14270]
[null,"retours spontanés RPT*",3172,3437,5363,6645,5377,4060,2791,2150,1861]
[null,"renvois spontanés RUE**",434,855,1418,1810,1400,721,597,537,358]
[null,"Total spontanés",3606,4292,6781,8455,6777,4781,3388,2687,2219]
["Total éloignements non aidés",null,17514,16326,19328,21841,20853,19942,18873,15648,16489]
["Eloignements aidés","retours aidés RPT*",2198,2137,2397,1988,1382,1465,1079,809,1066]
[null,"renvois aidés RUE**",1342,1159,1202,2983,518,82,39,32,12]
["Total éloignements aidés",null,3540,3296,3599,4971,1900,1547,1118,841,1078]
["Total éloignements (A)",null,21054,19622,22927,26812,22753,21489,19991,16489,17567]
[]
["Départs volontaires aides","départs volontaires RPT* aidés",1644,2422,3923,4269,3329,2710,2950,2504,3734]
[null,"départs volontaires RUE** aidés",6634,5982,6062,5741,999,220,143,123,44]
["Total départs volontaires aidés (B)",null,8278,8404,9985,10010,4328,2930,3093,2627,3778]
["Départs spontanés (C)",null,"-","--","-","-","-",3187,6512,5591,5438]
["Total sorties du territoire (A) + (B) + (C)",null,29332,28026,32912,36822,27081,27606,29596,24707,26783]

{"sheet":"ESI","index":4,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"INTERPELLATIONS D'ETRANGERS EN SITUATION IRREGULIERE"]
[]
[]
[null,null,"Annee"]
[null,null,2012,2013,2014,2015,2016,2017]
[null,"Total",71356,74223,101349,114266,97111,119635]
[null,"evolution",null,4.0178821682829755E-2,0.36546623014429491,0.12745069018934574,-0.15013214779549472,0.2319407688109483]

{"sheet":"ELOI","index":5,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,0,18,2],[3,0,12,0],[3,1,5,1],[6,1,6,2],[8,1,8,2],[9,1,11,1],[12,1,12,2],[13,0,13,2],[14,0,16,0],[14,1,15,1],[16,1,16,2],[17,0,17,2]]}
[]
[" Mesures\nexécutées",null,null,"ANNEE"]
[null,null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Eloignements","Retour RPT hors UE","Retours spontanés",3172,3437,5363,6645,5377,4060,2791,2150,1861]
[null,null,"Retours aidés",2198,2137,2397,1988,1382,1465,1079,809,1066,null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,null,"Retours forcés sous billeterie",8253,6401,4015,4136,4656,6515,7039,6539,6909,null,"Retours forcés sous billeterie PT",8253,6401,4015,4136,4656,6515,7039,6539,6903]
[null,"Total Retour RPT hors UE",null,13623,11975,11775,12769,11415,12040,10909,9498,9836,null,"Retours spontanés PT",3172,3437,5363,6645,5377,4060,2791,2150,1860]
[null,"Réadmissions RPT dans UE","Remises",4156,3504,5728,6316,6038,5314,5014,3338,4589,null,"Réadmissions RPT dans UE",4156,3504,5728,6316,6038,5314,5014,3338,4589]
[null,"Total Réadmissions RPT dans UE",null,4156,3504,5728,6316,6038,5314,5014,3338,4589,null,"Renvois UE",1933,2984,4222,4744,4782,4053,4029,3621,3137]
[null,"Renvois ressortissants UE","Renvois spontanés ",434,855,1418,1810,1400,721,597,537,358,null,"Total non aidés",17514,16326,19328,21841,20853,19942,18873,15648,16489]
[null,null,"Renvois aidés",1342,1159,1202,2983,518,82,39,32,12]
[null,null,"Renvois forcés sous billeterie",1499,2129,2804,2934,3382,3332,3432,3084,2772]
[null,"Total Renvois ressortissants UE",null,3275,4143,5424,7727,5300,4135,4068,3653,3142]
["Total Eloignements",null,null,21054,19622,22927,26812,22753,21489,19991,16489,17567]
["Aide au départ","Départs volontaires aidés","Départs volontaires aidés RPT",1644,2422,3923,4269,3329,2710,2950,2504,3734]
[null,null,"Départs volontaires aidés UE-Schengen",6634,5982,6062,5741,999,220,143,123,44]
[null,"Total Départs volontaires aidés",null,8278,8404,9985,10010,4328,2930,3093,2627,3778]
["Total Aide au départ",null,null,8278,8404,9985,10010,4328,2930,3093,2627,3778]
["Total général",null,null,29332,28026,32912,36822,27081,24419,23084,19116,21345]
["départs spontanés",null,null,null,null,null,null,null,3187,6512,5591,5438]
["GLOBAL",null,null,null,null,null,null,null,27606,29596,24707,26783]
[null,null,null,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,null,"Eloignements forcés ",13908,12034,12547,13386,14076,15161,15485,12961,14270]
[null,null,"Eloignements et départs spontanés",3606,4292,6781,8455,6777,7968,9900,8278,7657]
[null,null,"Eloignements et départs aidés",11818,11700,13584,14981,6228,4477,4211,3468,4856]

{"sheet":"nat et faux docs","index":6,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["T I3-22",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Métropole",2013,"Outre-Mer",2013,null,"Métropole",2014,"Outre-Mer",2014]
["ALBANAISE",765,"COMORIENNE",286,null,"ALBANAISE",696,"COMORIENNE",407]
["FRANCAISE",534,"HAITIENNE",68,null,"FRANCAISE",579,"HAITIENNE",52]
["CONGOLAISE",388,"BRESILIENNE",45,null,"SYRIENNE",431,"BRESILIENNE",39]
["ALGERIENNE",371,"MALGACHE",35,null,"ALGERIENNE",363,"MALGACHE",35]
["CONGOLAISE RDC",359,"SURINAMIENNE",17,null,"CONGOLAISE",339,"FRANCAISE",15]
["TUNISIENNE",263,"DOMINICAINE",17,null,"CONGOLAISE RDC",309,"SYRIENNE",12]
["CAMEROUNAISE",252,"FRANCAISE",12,null,"MAROCAINE",295,"SURINAMIENNE",11]
["MAROCAINE",245,"CHINOISE",4,null,"TUNISIENNE",260,"DOMINICAINE",7]
["SYRIENNE",240,"CONGOLAISE",4,null,"GUINEENNE",220,"CHINOISE",4]
[]
[]
["Métropole",2015,"Outre-Mer",2015,null,"Métropole",2016,"Outre-Mer",2016]
["ALBANAISE",916,"COMORIENNE",243,null,"ALBANAISE",776,"COMORIENNE",237]
["FRANCAISE",589,"HAITIENNE",68,null,"FRANCAISE",472,"SURINAMIENNE",92]
["UKRAINIENNE",543,"SURINAMIENNE",63,null,"GUINEENNE",465,"HAITIENNE",86]
["INDETERMINEE",461,"FRANCAISE",31,null,"ALGERIENNE",425,"BRESILIENNE",60]
["SYRIENNE",391,"BRESILIENNE",24,null,"CONGOLAISE",316,"FRANCAISE",51]
["CONGOLAISE",377,"MALGACHE",22,null,"NIGERIANE",267,"DOMINICAINE",21]
["ALGERIENNE",372,"DOMINICAINE",20,null,"IRANIENNE",260,"MALGACHE",14]
["CONGOLAISE RDC",362,"SYRIENNE",18,null,"UKRAINIENNE",257,"SAINTE LUCIENNE",11]
["GUINEENNE",330,"IRAKIENNE",16,null,"MALIENNE",252,"ALBANAISE",11]
[]
[]
["Métropole",2017,"Outre-Mer",2017]
["ALBANAISE",null,"COMORIENNE"]
["FRANCAISE",null,"SURINAMIENNE"]
["GUINEENNE",null,"HAITIENNE"]
["ALGERIENNE",null,"BRESILIENNE"]
["CONGOLAISE",null,"FRANCAISE"]
["NIGERIANE",null,"DOMINICAINE"]
["IRANIENNE",null,"MALGACHE"]
["UKRAINIENNE",null,"SAINTE LUCIENNE"]
["MALIENNE",null,"ALBANAISE"]

{"sheet":"Filières","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Filières d'immigration irrégulière en 2014 et 2015"]
[]
["Filières",2014,2015,2016,2017]
["aide à l'entrée et au séjour",110,91,118,139]
["organisation de mariage de complaisance",2,6,8,2]
["reconnaissances indues d'enfant",12,13,14,21]
["recours à la fraude documentaire",102,92,82,79]
["Dont travail illégal",null,null,64,62]
[]
["Source : DCPAF"]

{"sheet":"LPC","index":8,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[14,0,14,1],[42,0,42,1],[43,0,43,1],[42,2,43,3],[42,4,43,6],[0,2,0,7],[27,0,27,1]]}
[null,"I3-10","laissez-passer consulaires"]
[]
[]
[]
[]
["année",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Laissez-passer demandés",14011,12218,10668,8350,6515,7022,7423,6647,5859,5811]
["Laissez-passer obtenus dans les délais utiles",4523,3822,3493,2460,2403,2474,2857,2859,2707,2966]
["Laissez-passer obtenus hors délai",320,404,318,227,177,168,207,200,170,147]
["Laissez-passer refusés",3806,3870,3766,1787,1481,1327,1144,770,587,314]
["demandes laissées sans réponse\n(demandes - réponses)",5362,4122,3091,3876,2454,3053,3215,2818,2395,2384]
["Taux de délivrance dans délai",0.32281778602526584,0.31281715501718776,0.3274278215223097,0.29461077844311379,0.36884113584036837,0.3523212759897465,0.3848848174592483,0.43011885060929744,0.4620242362177846,0.51041128893477883]
["Taux de délivrance global",0.34565698379844406,0.34588312326076281,0.35723659542557179,0.32179640718562874,0.39600920951650037,0.37624608373682711,0.4127711167991378,0.46020761245674741,0.49103942652329752,0.53570813973498532]
[]
["Année 2017"]
["top 10","PAYS ","NOMBRE DE MESURES D’ELOIGNEMENT PRONONCEES","NOMBRE DE MESURES D'ELOIGNEMENT EXECUTEES (sans compter les aides au départ et les départs spontanés)"," DEMANDES  LPC","TAUX DE RECONNAISSANCE  DE LA NATIONALITE","TAUX DE DELIVRANCE DES LPC DANS LES DELAIS "]
[1,"Algérie",10245,1610,1356,0.58260000000000001,0.50439999999999996]
[2,"Maroc",7533,1488,646,0.39630000000000004,0.29719999999999996]
[3,"Tunisie",5099,985,963,0.50159999999999993,0.39770000000000005]
[4,"Pakistan",3560,466,83,0.4819,0.33729999999999999]
[5,"Mali",3289,260,73,0.17809999999999998,0.1096]
[6,"Bangladesh",2591,68,24,0.33329999999999999,0.29170000000000001]
[7,"Sénégal",2252,331,113,0.40710000000000002,0.32740000000000002]
[8,"Egypte",2349,230,119,0.25209999999999999,0.1681]
[9,"Inde",1880,191,113,0.54869999999999997,0.47789999999999999]
[10,"Mauritanie",816,49,26,0.42310000000000003,0.26919999999999999]
[null,"TOTAL ET TAUX MOYEN TOUS PAYS",103940,17567,5811,0.60250000000000004,0.51039999999999996]
["Année 2016"]
["top 10","PAYS ","NOMBRE DE MESURES D’ELOIGNEMENT PRONONCEES","NOMBRE DE MESURES D'ELOIGNEMENT EXECUTEES (sans compter les aides au départ et les départs spontanés)"," DEMANDES  LPC","TAUX DE RECONNAISSANCE  DE LA NATIONALITE","TAUX DE DELIVRANCE DES LPC DANS LES DELAIS "]
[1,"Algérie",9278,1539,1294,0.54330000000000001,0.47989999999999999]
[2,"Maroc",6651,1544,680,0.35880000000000001,0.27500000000000002]
[3,"Tunisie",4671,1060,1139,0.41089999999999999,0.31519999999999998]
[4,"Pakistan",3008,370,33,0.21210000000000001,0.1212]
[5,"Mali",2844,250,76,0.3947,0.11840000000000001]
[6,"Bangladesh",2247,82,66,0.2424,0.21210000000000001]
[7,"Sénégal",2127,328,96,0.375,0.32290000000000002]
[8,"Egypte",1979,184,157,0.25480000000000003,0.17199999999999999]
[9,"Inde",1397,159,79,0.41770000000000002,0.40510000000000002]
[10,"Mauritanie",757,38,13,0.23080000000000001,0.23080000000000001]
[null,"TOTAL ET TAUX MOYEN TOUS PAYS",92076,16489,5859,0.5544,0.46200000000000002]
[]
["Analyse de 10 pays suivi pour leur participation"]
[]
["Année 2015"]
["top 10","PAYS ","NOMBRE DE MESURES D’ELOIGNEMENT PRONONCEES","NOMBRE DE MESURES D'ELOIGNEMENT EXECUTEES (sans compter les aides au départ et les départs spontanés)"," DEMANDES  LPC","TAUX DE RECONNAISSANCE","TAUX DE DELIVRANCE DES LPC DANS LES DELAIS "]
[null,null,null,null,null," DE LA NATIONALITE "]
[1,"ALGERIE",8298,1633,1107,0.54100000000000004,0.47699999999999998]
[2,"MAROC",6563,2014,746,0.34599999999999997,0.24]
[3,"TUNISIE",5507,1611,1552,0.34499999999999997,0.246]
[4,"MALI",2485,262,83,0.39800000000000002,0.253]
[5,"PAKISTAN",2358,550,94,0.46800000000000003,0.436]
[6,"BANGLADESH",2171,109,63,0.222,0.159]
[7,"SENEGAL",2067,508,118,0.55900000000000005,0.46600000000000003]
[8,"EGYPTE",1708,283,162,0.11700000000000001,0.105]
[9,"INDE",1154,266,178,0.214,0.20799999999999999]
[10,"MAURITANIE",829,50,28,0.35699999999999998,0.25]
[null,"TOTAL ET TAUX MOYEN TOUS PAYS",88991,19991,6630,0.51600000000000001,0.42899999999999999]

{"sheet":"Top 20 LPC","index":9,"n_rows":26,"n_cols":24,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,21,2,23],[2,12,2,14],[2,6,2,8],[2,1,2,3],[2,0,3,0],[2,16,2,18]]}
[null,null,null,null,null,"Taux de délivrance des 20 pays dits peu coopératifs"]
[]
["Nationalité",2013,null,null,null,null,2014,null,null,null,null,null,2015,null,null,null,2016,null,null,null,null,2017]
[null,"total des demandes","LPC délivrés dans les délais utiles","Taux de délivrance",null,"Nationalité","total des demandes","LPC délivrés dans les délais utiles","Taux de délivrance",null,null,"Nationalité","total des demandes","LPC délivrés dans les délais utiles","Taux de délivrance","Nationalité","total des demandes","LPC délivrés dans les délais utiles","Taux de délivrance","EVO","Nationalité","total des demandes","LPC délivrés dans les délais utiles","Taux de délivrance"]
["Tunisie",2002,478,23.88,null,"Afghanistan",13,2,15.38,{"$f":"I5-D5","v":-8.4999999999999982},null,"Albanie",320,288,90,"Algérie",1294,621,47.99,{"$f":"S5-O5","v":-42.01},"Algérie"]
["Chine",198,72,36.36,null,"Angola",28,16,57.14,{"$f":"I6-D6","v":20.78},null,"Algérie",1107,528,47.7,"Tunisie",1139,359,31.52,-16.180000000000003,"Tunisie"]
["Egypte",192,25,13.02,null,"Arménie",232,140,60.34,47.320000000000007,null,"Arménie",153,111,72.55,"Maroc",680,187,27.5,-45.05,"Maroc"]
["Inde",186,32,17.2,null,"Bangladesh",84,15,17.86,0.66000000000000014,null,"Bangladesh",63,10,15.87,"Albanie",306,268,87.58,71.709999999999994,"Albanie"]
["Arménie",128,88,68.75,null,"Cap-vert",21,6,28.57,-40.18,null,"Cameroun",50,40,80,"Roumanie",260,245,94.23,14.230000000000004,"Roumanie"]
["Congo (RDC)",97,39,40.21,null,"Chine",174,86,49.43,9.2199999999999989,null,"Chine (Hong-Kong inclus)",121,50,41.32,"Egypte",157,27,17.2,-24.12,"Egypte"]
["Pakistan",97,24,24.74,null,"Congo (RDC)",96,44,45.83,21.09,null,"Congo, République démocratique du",104,49,47.12,"Kosovo",140,94,67.14,20.020000000000003,"Kosovo"]
["Sénégal",76,27,35.53,null,"Congo Brazz. (Rép. du)",33,16,48.48,12.949999999999996,null,"Côte d'Ivoire",48,13,27.08,"Arménie",138,108,78.260000000000005,51.180000000000007,"Arménie"]
["Mali",69,12,17.39,null,"Côte d'Ivoire",55,22,40,22.61,null,"Egypte",160,17,10.63,"Chine (Hong-Kong inclus)",135,70,51.85,41.22,"Chine (Hong-Kong inclus)"]
["Bangladesh",68,3,4.41,null,"Egypte",187,29,15.51,11.1,null,"Fédération de Russie",41,27,65.849999999999994,"Géorgie",135,117,86.67,20.820000000000007,"Géorgie"]
["Russie",61,16,26.23,null,"Gabon",93,4,4.3,-21.93,null,"Géorgie",158,134,84.81,"Sénégal",96,31,32.29,-52.52,"Sénégal"]
["Côte d'Ivoire",55,18,32.729999999999997,null,"Inde",217,37,17.05,-15.679999999999996,null,"Kosovo",174,133,76.44,"Inde",79,32,40.51,-35.93,"Inde"]
["Gabon",43,1,2.33,null,"Irak",20,2,10,7.67,null,"Mali",83,21,25.3,"Mali",76,9,11.84,-13.46,"Mali"]
["Congo Brazz. (Rép. du)",25,14,56,null,"Mali",93,18,19.350000000000001,-36.65,null,"Maroc",746,179,23.99,"Bangladesh",66,14,21.21,-2.7799999999999976,"Bangladesh"]
["Irak",24,0,0,null,"Mauritanie",41,11,26.83,26.83,null,"Pakistan",94,41,43.62,"Congo, République démocratique du",65,28,43.08,-0.53999999999999915,"Congo, République démocratique du"]
["Afghanistan",23,5,21.74,null,"Pakistan",92,22,23.91,2.1700000000000017,null,"Roumanie",326,300,92.02,"Côte d'Ivoire",61,32,52.46,-39.559999999999995,"Côte d'Ivoire"]
["Angola",23,6,26.09,null,"Russie",57,18,31.58,5.4899999999999984,null,"Sénégal",117,54,46.15,"Serbie",60,37,61.67,15.520000000000003,"Serbie"]
["Mauritanie",23,1,4.3499999999999996,null,"Sénégal",96,36,37.5,33.15,null,"Serbie",55,31,56.36,"Cameroun",55,51,92.73,36.370000000000005,"Cameroun"]
["Cap-vert",19,10,52.63,null,"Tunisie",1840,500,27.17,-25.46,null,"Tunisie",1552,381,24.55,"Guinée",51,28,54.9,30.349999999999998,"Guinée"]
["Viet-Nam",3,0,0,null,"Viet-Nam",16,0,0,0,null,"Turquie",49,33,67.349999999999994,"Fédération de Russie",43,12,27.91,-39.44,"Fédération de Russie"]
[]
[null,{"$f":"SUM(B5:B24)","v":3412},{"$f":"SUM(C5:C24)","v":871},{"$f":"C26/B26","v":0.25527549824150059},null,null,{"$f":"SUM(G5:G24)","v":3488},{"$f":"SUM(H5:H24)","v":1024},{"$f":"H26/G26","v":0.29357798165137616},null,null,null,{"$f":"SUM(M5:M24)","v":5521},{"$f":"SUM(N5:N24)","v":2440},{"$f":"N26/M26","v":0.44194892229668536},null,{"$f":"SUM(Q5:Q24)","v":5036},{"$f":"SUM(R5:R24)","v":2370},{"$f":"R26/Q26","v":0.47061159650516282}]

{"sheet":"AME","index":10,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["I3-8",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Date","France entière","métropole"]
["2007-12-31",194615]
["2008-12-31",202503]
["2009-12-31",215763]
["2010-12-31",228036]
["2011-12-31",208974]
["2012-12-31",252437]
["2013-12-31",282425]
["2014-12-31",294298]
["2015-12-31",316314,295233]
["2016-12-31",311310,288269]
["2017-12-31",315800,null,{"$f":"B14/B13-1","v":1.4422922488837475E-2}]
[]
["Source : CNAMTS"]

{"sheet":"Mise en cause","index":11,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,0,7,0],[3,1,3,6]]}
["G I3-3","Emploi d'étrangers sans titre"]
[]
[]
[null,"EVOLUTION DU NOMBRE DE PERSONNES MISE EN CAUSE POUR EMPLOI D'ETRANGERS SANS TITRE DE TRAVAIL (INDEX 94)"]
[]
["Données","métropole",null,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[" MEC total","PMC en Métropole",null,586,887,1077,1564,2675,2843,2608,2703,2689,2401,2063,1974,1854,939]
[null,"PMC dans les DOM-COM",null,161,187,141,124,356,364,353,353,403,348,354,259,245,147]
[" MEC Etranger","dont PMC étrangers en Métropole",null,258,450,580,802,1450,1508,1350,1433,1334,1215,989,903,852,883]
[null,"Nombre total de PMC",null,747,1074,1218,1688,3031,3207,2961,3056,3092,2749,2417,2233,2099,1086]

{"sheet":"Index 93 94 95","index":12,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["I3-13","Etat 4001 – Résultats des index 93, 94 et 95 métropole"]
[]
[null,2010,2011,2012,2013,2014,2015,2016,2017,"Évolution\n2016/2017"]
["Total des personnes mises en cause",12479,13707,13954,12907,12024,11202,10685,9878,-7.5526438933083764E-2]
["Etrangers mis en cause",3988,4331,4272,4495,3654,3323,3129,2997,-4.218600191754554E-2]
["Part des étrangers",0.319576889173812,0.31596994236521486,0.30614877454493333,0.34826063376462385,0.30389221556886226,0.29664345652562041,0.29284043051006081,0.30340149827900387,3.6064240687490111E-2]
[]
["Source MI - DCPJ"]

{"sheet":"index 94","index":13,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["T I-3-14a",null,"Emploi d'étrangers sans titres - Etat 4001 - Index 94"]
[]
[null,2009,2010,2011,2012,2013,2014,2015,2016,2017,"Évolution\n2017/2016"]
["Total des personnes mises en cause",2843,2608,2687,2689,2401,2063,1977,1854,1830,{"$f":"(J4-I4)/I4","v":-1.2944983818770227E-2}]
["- dont étrangers",1534,1354,1426,1334,1215,989,911,852,883,{"$f":"(J5-I5)/I5","v":3.6384976525821594E-2}]
["Part des étrangers",{"$f":"B5/B4","v":0.53957087583538521},0.51917177914110424,0.530703386676591,0.49609520267757529,0.50603915035401914,0.47939893359185654,0.46079919069296915,0.45954692556634302,0.48251366120218581,{"$f":"(J6-I6)/I6","v":4.9976910644193101E-2}]
[]
["Source MI - DCPJ"]

{"sheet":"INDEX 93 et 95","index":14,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,2,26,3],[14,2,15,2],[16,2,16,3],[27,2,28,2],[29,2,29,3],[5,1,13,1],[5,2,6,2],[7,2,7,3],[8,2,9,2],[10,2,10,3],[11,2,12,2],[13,2,13,3],[18,1,26,1],[18,2,19,2],[20,2,20,3],[21,2,22,2],[23,2,23,3],[24,2,25,2]]}
[null,"index 93 et 95 (travail dissimulé et prêt illicite de main d'œuvre), "]
[]
[]
[null,null,null,null,"Données"]
[null,"métropole","année","Index"," Faits constatés"," MEC total"," MEC Etranger"," Parts d'étrangers"]
[null,"Métropole","2014",93,10510,9829,2627,26.73]
[null,null,null,95,232,132,38,28.79]
[null,null,"Total 2014",null,10742,9961,2665,26.75]
[null,null,"2015",93,10792,9100,2373,26.08]
[null,null,null,95,184,125,39,31.2]
[null,null,"Total 2015",null,10976,9225,2412,26.15]
[null,null,"2016",93,10714,8733,2252,25.79]
[null,null,null,95,131,111,27,24.32]
[null,null,"Total 2016",null,10845,8844,2279,25.77]
[null,null,2017,93,9651,7957,2092,26.29]
[null,null,null,95,105,91,22,24.18]
[null,null,"Total 2017",null,9756,8048,2114,26.27]
[]
[null,"DOM-COM","2014",93,1110,912,147,16.12]
[null,null,null,95,2,9,0,0]
[null,null,"Total 2014",null,1112,921,147,15.96]
[null,null,"2015",93,1204,914,154,16.850000000000001]
[null,null,null,95,2,1,0,0]
[null,null,"Total 2015",null,1206,915,154,16.829999999999998]
[null,null,"2016",93,1220,891,187,20.99]
[null,null,null,95,3,5,0,0]
[null,null,"Total 2016",null,1223,896,187,20.87]
[null,null,2017,93,1086,829,209,25.21]
[null,null,null,95,4,0,0]
[null,null,"Total 2017",null,1090,829,209,25.21]

{"sheet":"index 81_82_83","index":15,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,17,2,18],[2,15,2,16],[0,1,0,5],[2,1,2,2],[2,3,2,4],[2,13,2,14],[2,11,2,12],[2,9,2,10],[2,7,2,8],[2,5,2,6]]}
["T I3-21","Index 81, 82 et 83"]
[]
[null,2009,null,2010,null,2011,null,2012,null,2013,null,2014,null,2015,null,2016,null,2017]
["METROPOLE","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers","Nombre de personnes mises en cause","Part d'étrangers"]
["Index 81",3593,83.13,3668,82.61,4340,84.59,4272,84.85,5126,86.66,5041,87.11,4781,89.69,4491,91.25,4633,91.6]
["Index 82",2604,50.12,2567,52.2,2823,53.91,3191,50.36,3403,53.63,3079,50.44,2608,49.12,2622,52.63,2946,52.99]
["Index 83",2311,30.29,2397,30.08,2429,33.39,2852,27.1,3645,31.14,3619,30.06,3209,26.89,3351,27.25,2927,26.61]
["Total cumulé",8508,58.67,8632,58.98,9592,62.59,10315,58.22,12174,60.8,11739,59.9,10598,60.7,10464,61.08,10506,62.67]
[]
["Source: MI - DCPJ"]

{"sheet":"Aides aux retours","index":16,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["I3-12","Etat récapitulatif des retours aidés (ARV et ARH)"]
[]
[]
["source OFII"]
[null,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
["Aide au retours \npays tiers",3128,4096,4713,6839,6824,5492,5423,4479,4546,7024]
["Aide au retour\n Union européenne",9290,11140,9341,9001,10749,1894,445,279,228,90]
["Total",12418,15236,14054,15840,17573,7386,5868,4758,4774,7114]

{"sheet":"contribution spéciale OFII","index":17,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Évolution du nombre de dossiers transmis à l’OFII"]
[]
[]
[]
["Année",2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,"2017 / 2016"]
["Nombre de dossiers parvenus à l’OFII",1341,1433,1240,1265,2052,1944,1568,1547,1232,1140,{"$f":"(K6-J6)/J6","v":-7.4675324675324672E-2}]
["Nombre  d’étrangers employés sans titre)",2814,2046,2438,2240,3974,3473,2512,2449,2007,1918,{"$f":"(K7-J7)/J7","v":-4.434479322371699E-2}]
["Nombre moyen d’infractions par dossier",{"$f":"B7/B6","v":2.0984340044742731},1.4277739009071877,1.9661290322580645,1.7707509881422925,1.9366471734892787,1.7865226337448559,1.6020408163265305,1.58,1.63,1.68,{"$f":"(K8-J8)/J8","v":3.0674846625766899E-2}]
["Source : OFII "]

{"sheet":"fraude docs","index":18,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,0,53,0],[22,0,27,0],[28,0,33,0],[34,0,39,0],[0,1,0,3],[4,0,9,0],[10,0,15,0],[16,0,21,0],[46,0,49,0]]}
["T I3-20","Typologie des fraudes (en nombre de faux documents découverts)"]
[]
[]
["DOCUMENTS","TYPES DE FRAUDE","2009 2","2010 2","2011 2","2012 1","2013 1","2014 1",2015,2016,2017]
["Cartes d'identité","FAUX DOCUMENTS",1144,651,762,974,792,799,617,655,903]
[null,"dont contrefaçons ",110,133,117,106,144,218,120,132,337]
[null,"dont falsifications ",93,63,46,156,54,43,28,25,48]
[null,"dont usages frauduleux ",220,186,256,244,275,234,210,264,298]
[null,"dont obtentions frauduleuses",720,268,341,454,318,302,258,218,200]
[null,"dont voles vierges ",1,1,2,14,1,2,1,16,20]
["Passeports","FAUX DOCUMENTS",1157,526,643,515,588,452,448,445,899]
[null,"dont contrefaçons ",41,43,21,23,29,21,14,16,183]
[null,"dont falsifications ",232,152,182,155,138,89,71,39,356]
[null,"dont usages frauduleux ",174,160,203,179,205,159,170,178,183]
[null,"dont obtentions frauduleuses",698,169,228,158,211,181,190,208,173]
[null,"dont voles vierges ",12,2,9,0,5,2,3,4,4]
["Permis de conduire","FAUX DOCUMENTS",279,151,125,208,178,237,265,140,265]
[null,"dont contrefaçons ",42,45,37,38,57,111,87,23,145]
[null,"dont falsifications ",21,23,12,22,31,19,15,19,16]
[null,"dont usages frauduleux ",20,15,23,21,18,21,14,18,33]
[null,"dont obtentions frauduleuses",193,67,52,127,72,85,148,77,71]
[null,"dont voles vierges ",3,1,1,0,0,1,1,3,0]
["Titres de séjour","FAUX DOCUMENTS",1141,1159,929,1178,1017,997,732,825,737]
[null,"dont contrefaçons ",397,322,233,296,225,201,146,146,184]
[null,"dont falsifications ",162,148,102,174,95,71,64,59,81]
[null,"dont usages frauduleux ",309,251,256,250,256,197,145,180,170]
[null,"dont obtentions frauduleuses",270,437,338,457,441,528,377,440,302]
[null,"dont voles vierges ",3,1,0,1,0,0,0,0,0]
["Visas","FAUX DOCUMENTS",144,216,194,146,211,135,121,116,175]
[null,"dont contrefaçons ",57,66,34,33,57,37,38,17,37]
[null,"dont falsifications ",56,102,91,32,38,18,13,9,19]
[null,"dont usages frauduleux ",7,11,23,14,19,5,9,32,14]
[null,"dont obtentions frauduleuses",21,37,46,66,97,75,61,58,105]
[null,"dont voles vierges ",3,0,0,1,0,0,0,0,0]
["Actes d'état civil","FAUX DOCUMENTS",1667,323,658,516,1057,522,404,589,572]
[null,"dont contrefaçons ",992,165,431,127,415,154,188,167,231]
[null,"dont falsifications ",33,36,22,45,194,47,47,55,15]
[null,"dont usages frauduleux ",29,42,66,150,288,242,84,171,259]
[null,"dont obtentions frauduleuses",613,80,139,194,160,79,85,196,67]
[null,"dont voles vierges ","-",0,0,0,0,0,0,0,0]
["1 métropole (source DCPAF); \n2 national"]
[]
[]
[]
["GENDARMERIE",null,null,2010,2011,2012,2013,2014,2015,2016,2017]
[null,"Nombre de documents contrôlés",null,13390,21496,34786,39257,39998,54641,70072,91607]
["Documents français","Fausses CNI détectées",null,44,64,54,103,176,34,55,47]
[null,"Faux passeports détectés",null,21,59,31,62,11,5,3,5]
[null,"Faux permis conduire détectés",null,34,152,63,185,134,24,29,28]
[null,"Autres faux détectés",null,123,291,234,268,559,78,107,227]
["Documents étrangers","Fausses CNI détectées",null,123,167,203,234,86,62,50,85]
[null,"Faux passeports détectés",null,60,78,68,144,39,48,57,54]
[null,"Faux permis conduire détectés",null,422,421,420,440,222,220,240,266]
[null,"Autres faux détectés",null,108,167,160,116,103,153,180,248]
["source MI-DGGN"]