Is it possible to export the data in the K1 timeline table?

[GandK 168]

Hi

I have too much time in my hands and would like to do some data mining on the processing time of K1 data. Is it possible to export the data set on K1 timeline on the site?

I am mainly interested in finding the trend in K1 processing time for different service centers. Like what is shown in the picture below but I want to see it way back to 7-8 years ago.

thanks

Uploaded with ImageShack.us

[Captain Ewok 1,891]

I can do a quick run to provide any data you need. Just post here and I can reply back with any aggregated stats.

[GandK 168]

I can do a quick run to provide any data you need. Just post here and I can reply back with any aggregated stats.

Hi Ewok

Can you do a quick run for comparison of processing time stats for K-1 (I-129F) for CSC and VSC in the past 5 years? please

I would really appreciate it

Thank you

[Donald-n-Analyn 6]

I can do a quick run to provide any data you need. Just post here and I can reply back with any aggregated stats.

Captain,

In the Removal of Conditions forum, users are constantly quoting and updating a formatted list, like the one below for January filers. This seems like a lot of unnecessary work, and is very error prone with all the formatting. It would be nice if we could just make a link to search the timelines for Lifting entries where the filing date was in a range.

I guess it might be harder to get the VJ member names, as this would probably require a join on the member number.

Is there any way to compose a link to do this?

Very nice job with the site too, it really helps a lot of people!

--

don

California Service Center (25 applicants)

VJName.............Date of I-751.....NOA1 Date......Biometrics......Approved....

MENINA...............01/03/12........01/04/12.......02/09/12........--/--/12.... (Early Bio, 02/03)

JOHNCALI9............01/03/12........01/04/12.......01/27/12........--/--/12....

FATIMA AND JIM.......01/04/12........01/05/12.......02/09/12........--/--/12....

ABBIELOVESJEREMY.....01/05/12........01/09/12.......02/07/12........--/--/12....

F1_GURL..............01/07/12........01/11/12.......02/15/12........--/--/12....

ALMONDMILKTEAGIRL....01/09/12........01/11/12.......02/06/12........--/--/12....

DJOHN................01/10/12........01/11/12.......03/07/12........--/--/12....

MGEURTS..............01/10/12........--/--/12.......--/--/12........--/--/12....

CALYPSO..............01/11/12........01/12/12.......02/17/12........--/--/12....

B*J..................01/11/12........01/12/12.......03/05/12........--/--/12....

SASKA+TIM............01/13/12........01/17/12.......02/07/12........--/--/12....

ANDANA_DJ............01/13/12........--/--/12.......02/03/12........--/--/12....

SNIVVEL..............01/17/12........01/18/12.......02/16/12........--/--/12.... (Early Bio, 01/30)

BABYLOVESBABY........01/18/12........02/08/12.......02/24/12........--/--/12.... (Never received NOA1, got I-551 stamp)

MARM.................01/18/12........01/19/12.......02/24/12........--/--/12....

100% AL AHLY FAN.....01/19/12........02/13/12.......03/12/12........--/--/12.... (Never received NOA1, got I-551 stamp)

MI.PI................01/20/12........01/23/12.......02/24/12........--/--/12....

LETSGOHEAT...........01/20/12........01/23/12.......02/14/12........--/--/12.... (Early Bio, 01/31)

LIRWIN2000...........01/21/12........01/23/12.......--/--/12........--/--/12....

ISTANBULLS...........01/21/12........01/24/12.......02/24/12........--/--/12....

ALEX AND ASTRID......01/23/12........01/24/12.......--/--/12........--/--/12....

DAIRYFARMER..........01/23/12........--/--/12.......--/--/12........--/--/12....

SKIDIVAWANNABE.......01/24/12........01/25/12.......03/02/12........--/--/12....

SAGARCIA.............01/25/12........01/27/12.......02/17/12........--/--/12....

BODEY................01/28/12........01/30/12.......03/02/12........--/--/12....

Vermont Service Center (25 applicants)

VJName.............Date of I-751.....NOA1 Date......Biometrics......Approved....

RICARDO_C............01/03/12........01/06/12.......02/02/12........--/--/12....

TOYOTA...............01/03/12........01/06/12.......--/--/12........--/--/12....

VAL MARTY............01/03/12........01/06/12.......02/01/12........--/--/12....

DHLUNAR..............01/03/12........01/06/12.......02/01/12........--/--/12....

HAKUNA_MATATA2.......01/04/12........01/05/12.......01/31/12........--/--/12....

DOWNTORIDE...........01/09/12........01/10/12.......02/13/12........--/--/12....

DONALD-N-ANALYN......01/09/12........01/12/12.......--/--/12........--/--/12....

NOTWORKSTE...........01/10/12........01/17/12.......02/08/12........--/--/12....

COCO2012.............01/10/12........01/12/12.......02/15/12........--/--/12.... (Early Bio, 01/27)

THEREDBIRD...........01/10/12........01/13/12.......02/17/12........--/--/12....

TERI.D...............01/12/12........01/17/12.......03/01/12........--/--/12....

2KOOL4SKOOL..........01/12/12........01/13/12.......--/--/12........--/--/12....

WILLCATHY............01/12/12........01/13/12.......02/09/12........--/--/12....

LOVELYALEX...........01/13/12........01/17/12.......02/24/12........--/--/12....

N1DOM................01/17/12........01/20/12.......02/15/12........--/--/12....

STEPHEN + ELISHA.....01/17/12........01/20/12.......03/01/12........--/--/12....

DANMARKX.............01/17/12........01/23/12.......02/13/12........--/--/12....

JIM & A.D............01/17/12........01/20/12.......03/08/12........--/--/12....

PROUD&LOUD...........01/18/12........01/20/12.......02/17/12........--/--/12....

ALEXZY75.............01/20/12........01/24/12.......02/24/12........--/--/12....

SPECTHEINTRO.........01/23/12........01/26/12.......--/--/12........--/--/12....

THE MEGHAN J.........01/25/12........--/--/12.......--/--/12........--/--/12....

PEET.................01/26/12........01/30/12.......--/--/12........--/--/12....

LAURELMIKE...........01/26/12........01/27/12.......--/--/12........--/--/12....

MISSMISSY............01/30/12........01/31/12.......02/17/12........--/--/12....

IMPORTANT!

* Make sure that your VJ Text Editor setting is set to Rich Text Editor.

* Go to the MOST RECENTLY POSTED VERSION of this list (go to the last post and scroll UP) and "Reply" to it, deleting the "quote" tags in your reply.

* Please DO NOT change the font, font size, add colors, stuff like that.

* Please PREVIEW before posting to make sure it is properly formatted.

* Please check that you have not deleted anyone's NAME & DATA.

Date of I-751 = The Date you sent your application

NOA Date = The Receipt Date on your original NOA letter

Biometrics = The Date of your biometrics appointment

Approved = The Date your case was approved

* Please Capitalize your VJ Name when adding it to the list.

* When you're on this list, please come back to update your information accordingly.

* If you cannot add your information yourself, please ask another VJ member to help you do so.

Edited February 20, 2012 by Donald-n-Analyn

[Captain Ewok 1,891]

I'll update Igor's List to do this right now .

[Captain Ewok 1,891]

Complete!! You can now use Igor's list for I-751s!

www.visajourney.com/timeline/monthly_filers.php

[TBoneTX 45,284]

Vunderdink, Admiral. Have you notified the intrepid Y-Bone (Yurika) of this save-laboring achievement?

Edited February 21, 2012 by TBoneTX

[Captain Ewok 1,891]

Feel free to spread the word!!

[DanielPlainview 368]

On 2/21/2012 at 2:50 AM, Captain Ewok said:

Feel free to spread the word!!

Hi Captain, looks like this might be your site?   If so, it's been absolutely incredible for so many people.  Particularly creative are the timelines.....I use the search feature all the time.  So much so, in fact, that I've reached my limit of usability.   Now I'm trying to run some trend analysis on specific times, but the 100 records is a bit limiting.   Possible to get the following in a comma delimited or any format I can convert to Excel ?    Obviously I'm just anxious here awaiting my NVC receipt, and I'm just trying to calculate different averages.

 

Fields listed below for K1 records with NOA2 date of Jan 1, 2018 to present (or even 6 months if one year is too big):

• Consulate
• First NOA
• Second NOA
• Rec'd by NVC
• Left NVC
• Rec'd by Consulate
• Rec'd Packet 3
• Sent Packet 3
• Rec'd Packet 4
• Interview Date
• Date Visa Rec'd