{"id":680,"date":"2015-04-17T20:00:57","date_gmt":"2015-04-17T20:00:57","guid":{"rendered":"https:\/\/britsimonsays.com\/?p=680"},"modified":"2015-04-17T20:00:57","modified_gmt":"2015-04-17T20:00:57","slug":"ceac-data-extract-april-16","status":"publish","type":"post","link":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/","title":{"rendered":"CEAC data extract April 16"},"content":{"rendered":"

\"April16update\"<\/a><\/p>\n

 <\/p>\n

Time for an update at about the halfway point of April.<\/p>\n

There has been a delay in getting the data. The CEAC website was modified in a way that blocked my script for a while. They will sometimes do that if they feel the website is being hit by robots (which is how they see me!)\u00a0– and so we have to find another way around their measure.\u00a0A game of cat and mouse.\u00a0I spent several days investigating and rewriting the process from scratch and got a second version of the extraction tool work. However, my process is slow and thankfully the original developer of the “old” extract script diagnosed the change and fixed the script. So – we are back in business. Also added to this version are two columns to show counts for the at NVC cases, and the in Transit cases.<\/p>\n

I have also added some information to show the regional response rate. Just a word about that, the countries such as Egypt cannot be current, so the AF response rate is understated. Likewise, EU region is understated because of the U2 countries having such a low response rate. I have explained those things in this previous post on response rate analysis<\/a>.<\/p>\n

AS you can see KCC are on the pace I have described previously. They issue around 5000 visas a month, this is half a month so 250 visas. Contrary to what it feels like – KCC know what they are doing!<\/p>\n

Here is the data<\/a><\/p>\n

And before you ask me to give you data on \u201cyour\u201d embassy \u2013 it is very easy to do that yourself. So \u2013 here is how to use google sheets to analyze the data.<\/a><\/p>\n

One more thing. If youi appreciate the work I am doing in keeping you informed and assisting you through the process I would be grateful if you could read this page about the “Treehouse fund”<\/a> and leave a message or donate.<\/p>\n

CEAC data extract April 16<\/h6>\n","protected":false},"excerpt":{"rendered":"

  Time for an update at about the halfway point of April. There has been a delay in getting the data. The CEAC website was modified in a way that blocked my script for a while. They will sometimes do… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\nCEAC data extract April 16 - BritSimonSays.com<\/title>\n<meta name=\"description\" content=\"CEAC data extract April 16\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"BritSimon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/\",\"url\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/\",\"name\":\"CEAC data extract April 16 - BritSimonSays.com\",\"isPartOf\":{\"@id\":\"https:\/\/britsimonsays.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg\",\"datePublished\":\"2015-04-17T20:00:57+00:00\",\"dateModified\":\"2015-04-17T20:00:57+00:00\",\"author\":{\"@id\":\"https:\/\/britsimonsays.com\/#\/schema\/person\/7c464b8f4e75f40325e6858da2c39320\"},\"description\":\"CEAC data extract April 16\",\"breadcrumb\":{\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage\",\"url\":\"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg\",\"contentUrl\":\"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg\",\"width\":1247,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/britsimonsays.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CEAC data extract April 16\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/britsimonsays.com\/#website\",\"url\":\"https:\/\/britsimonsays.com\/\",\"name\":\"BritSimonSays.com\",\"description\":\"DV Lottery information and other stuff....\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/britsimonsays.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/britsimonsays.com\/#\/schema\/person\/7c464b8f4e75f40325e6858da2c39320\",\"name\":\"BritSimon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/britsimonsays.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/837f690fe3d83f2e4106ae6893f78d8a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/837f690fe3d83f2e4106ae6893f78d8a?s=96&d=mm&r=g\",\"caption\":\"BritSimon\"},\"sameAs\":[\"https:\/\/www.facebook.com\/BritSimonSays\"],\"url\":\"https:\/\/britsimonsays.com\/author\/simonpaul64\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CEAC data extract April 16 - BritSimonSays.com","description":"CEAC data extract April 16","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/","twitter_misc":{"Written by":"BritSimon","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/","url":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/","name":"CEAC data extract April 16 - BritSimonSays.com","isPartOf":{"@id":"https:\/\/britsimonsays.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage"},"image":{"@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage"},"thumbnailUrl":"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg","datePublished":"2015-04-17T20:00:57+00:00","dateModified":"2015-04-17T20:00:57+00:00","author":{"@id":"https:\/\/britsimonsays.com\/#\/schema\/person\/7c464b8f4e75f40325e6858da2c39320"},"description":"CEAC data extract April 16","breadcrumb":{"@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#primaryimage","url":"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg","contentUrl":"https:\/\/britsimonsays.com\/wp-content\/uploads\/2015\/04\/April16update.jpg","width":1247,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/britsimonsays.com\/ceac-data-extract-april-16\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/britsimonsays.com\/"},{"@type":"ListItem","position":2,"name":"CEAC data extract April 16"}]},{"@type":"WebSite","@id":"https:\/\/britsimonsays.com\/#website","url":"https:\/\/britsimonsays.com\/","name":"BritSimonSays.com","description":"DV Lottery information and other stuff....","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/britsimonsays.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/britsimonsays.com\/#\/schema\/person\/7c464b8f4e75f40325e6858da2c39320","name":"BritSimon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/britsimonsays.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/837f690fe3d83f2e4106ae6893f78d8a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/837f690fe3d83f2e4106ae6893f78d8a?s=96&d=mm&r=g","caption":"BritSimon"},"sameAs":["https:\/\/www.facebook.com\/BritSimonSays"],"url":"https:\/\/britsimonsays.com\/author\/simonpaul64\/"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4Qijq-aY","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/posts\/680"}],"collection":[{"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/comments?post=680"}],"version-history":[{"count":0,"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/posts\/680\/revisions"}],"wp:attachment":[{"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/media?parent=680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/categories?post=680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/britsimonsays.com\/wp-json\/wp\/v2\/tags?post=680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}