February 2021 K1 Filers

[Gail and Derrick 270]

Not much movement in the last week. 5 Feb cases approved so I'm not going to post the spreadsheet. We should start to see more movement by the middle of the month.  

[thekevkev 32]

I just wanted to state that I am giving you a link to my Google Drive, where I pull the entire Data or CSV files of the CaseTracker

App for the month February.

 

It is for people which are interested in doing a spreadsheet or cooperate together, which is a good option. Due the 

limitation of the CaseTracker App of only being able to pull 500 Cases every time, makes it to a total time of over an hour 

to achieve an entire month. Thats one of the reason I wanted to participate in the entire process, because it saves a lot of time for the person

which is doing the actual spreadsheet or refreshes it once a week or similar.

 

 

I thought of pulling the data every third day, but it is so time consuming that I am doing it every 5th day, unless somebody else wants to

participate.

 

---------------

I also found out that the cases we (February) are looking for starts with the Case Range 

 

WAC 21900-50000 and ends up with around ....-57500.

 

That means that in total 7500 cases are going to be processed within February, independent of the K1.

In case somebody is a February filler and is outside the CaseRange should definitely write something to be a part of the spreadsheet :).

---------------

 

Google Drive Link (CSV-files)

 

Link:

https://drive.google.com/drive/folders/13M-6Dqp6ccP1Yar7FC1vG4oBIetK63gc?usp=sharing

 

 

Kevin

 

 

 

[Caboose29 172]

I will gladly contribute where I can as soon as I get back from Russia. 👍👍

[Gail and Derrick 270]

2 hours ago, thekevkev said:

I just wanted to state that I am giving you a link to my Google Drive, where I pull the entire Data or CSV files of the CaseTracker

App for the month February.

 

 

 

 

 

Hey everyone! thekevkev posted this and then remembered I, along with a couple of others from this sub, am already doing this so we're going to join forces! There really has not been much movement at all. We're updating our spreadsheet every Wednesday and Sunday right now, but as we get more into Feb cases we'll increase. We'll share the data as soon as there's something more interesting going on! Right now there's only a couple that have moved since September 1. 

 

Thanks thekevkev!

 

And thanks also to Benny4352 who is helping update. If anyone else wants to help out, let me know. 

 

I'm also entirely happy to share the master spreadsheet with anyone who wants to run their own analysis of the data if that's your jam. 

[Gail and Derrick 270]

Here's the spreadsheet for anyone who wants to see it. It is set to view only (gotta protect the data!)  

 

https://docs.google.com/spreadsheets/d/1jeopDTfHoK_MdrqQHFGNWZLwaij9YfKATb3NtFfKlEA/edit?usp=sharing

 

We're at less than 2% of cases approved/denied/RFEd. 

 

You will be most interested in the 1st tab, Pivot: Status by Date, that shows how many cases there are by date, how many have been approved, RFEd etc). This is what it looks like (case count just means it was received/has NOA1). 

 

[Veronka 6]

6 hours ago, thekevkev said:

I just wanted to state that I am giving you a link to my Google Drive, where I pull the entire Data or CSV files of the CaseTracker

App for the month February.

 

It is for people which are interested in doing a spreadsheet or cooperate together, which is a good option. Due the 

limitation of the CaseTracker App of only being able to pull 500 Cases every time, makes it to a total time of over an hour 

to achieve an entire month. Thats one of the reason I wanted to participate in the entire process, because it saves a lot of time for the person

which is doing the actual spreadsheet or refreshes it once a week or similar.

 

 

I thought of pulling the data every third day, but it is so time consuming that I am doing it every 5th day, unless somebody else wants to

participate.

 

---------------

I also found out that the cases we (February) are looking for starts with the Case Range 

 

WAC 21900-50000 and ends up with around ....-57500.

 

That means that in total 7500 cases are going to be processed within February, independent of the K1.

In case somebody is a February filler and is outside the CaseRange should definitely write something to be a part of the spreadsheet :).

---------------

 

Google Drive Link (CSV-files)

 

Link:

https://drive.google.com/drive/folders/13M-6Dqp6ccP1Yar7FC1vG4oBIetK63gc?usp=sharing

 

 

Kevin

 

 

 

I wish I could help but I'm awful with numbers 😕. My fiance is the "clever one" in this relationship 😅😉

Thanks for all your help! 

[Elena1505 0]

On 9/8/2021 at 3:59 PM, Gail and Derrick said:

Here's the spreadsheet for anyone who wants to see it. It is set to view only (gotta protect the data!)  

 

https://docs.google.com/spreadsheets/d/1jeopDTfHoK_MdrqQHFGNWZLwaij9YfKATb3NtFfKlEA/edit?usp=sharing

 

We're at less than 2% of cases approved/denied/RFEd. 

 

You will be most interested in the 1st tab, Pivot: Status by Date, that shows how many cases there are by date, how many have been approved, RFEd etc). This is what it looks like (case count just means it was received/has NOA1). 

 

Hi Gail and Derrick. I can help with downloading this files. I don’t know how to do excel file, but I know how to download them from the app. 
 

so, you can count on me and give me numbers to search for and the way to send it to you)

[MarkPajr 23]

Curious, Any idea where the data for the app is coming from? It might be feasible to build a data scraper that updates automatically versus having to mainly run 500 cases at a time and update it. Also, This app is only available for iphones right?

[Gail and Derrick 270]

13 minutes ago, MarkPajr said:

Curious, Any idea where the data for the app is coming from? It might be feasible to build a data scraper that updates automatically versus having to mainly run 500 cases at a time and update it. Also, This app is only available for iphones right?

I think others in other groups have done that. I assume it pulls from https://egov.uscis.gov/casestatus/landing.do

The app available for both Android and iOS I believe. 

At this point, I've got the original data from NOA1 so it's just a matter of updating a few at a time as they are being processed. Of course, having the spreadsheet update automatically when it detects a change would be great, but it's not a lot of work to scan through the updates. 

[MarkPajr 23]

Could you remind me what the app is again? I haven't been able to find one for android.

[Patou & Kashou 38]

5 minutes ago, MarkPajr said:

Could you remind me what the app is again? I haven't been able to find one for android.

One of the apps is not available for Android. I use the USCIS Case Tracker App.

[Gail and Derrick 270]

9 minutes ago, MarkPajr said:

Could you remind me what the app is again? I haven't been able to find one for android.

I have "Case Tracker for USCIS" by Stephen Aldous

 

[Gail and Derrick 270]

Finally some movement today! 29 cases processed so far on 9/13.

• Most in the 49500 to 50500 range
• All are from Feb 1
• 21 approvals
• 7 RFEs
• 1 expedite request denied

Spreadsheet Link

[Patou & Kashou 38]

53 minutes ago, Gail and Derrick said:

Finally some movement today! 29 cases processed so far on 9/13.

• Most in the 49500 to 50500 range
• All are from Feb 1
• 21 approvals
• 7 RFEs
• 1 expedite request denied

Spreadsheet Link

 

I’m praying this the trend all week!!! We have all been so patient!

[thekevkev 32]

10 hours ago, Gail and Derrick said:

Finally some movement today! 29 cases processed so far on 9/13.

• Most in the 49500 to 50500 range
• All are from Feb 1
• 21 approvals
• 7 RFEs
• 1 expedite request denied

Spreadsheet Link

 

Awesome to see some movement, kinda exciting.

 

I delayed my search of yesterday and set it to today. So I don't know if you still need the cases.

I made a summary of all cases in one file so you can easily copy and paste it.