Project Kashmir:WAC-02 all I485 case status

K

kashmir

Registered Users (C)
Project Kashmir - scan all WAC-02 I485 case status at BCIS Case Status Online

about project
1) scan all WAC-02 cases at BCIS Case Status Online to obtain all I485 case numbers
2) scan I485 case status regularly to grasp the BCIS CSC activity
3) provide scanned data for application developers
4) analyze scanned data and post its result for I485 applicants

about kashmir
I'm one of I485 applicant at the CSC with WAC-02-124-5xxxx.
If you had some comment or question after reading this page, please send me e-mail.
My e-mail address is kashmir@covad.net.

You may use
1) software written by me and posted at this thread
2) data posted at this thread by me
freely but at your own risk.

I will do my best for this project, but I guarantee nothing at all.

useful links--------------------------------------------------
The following is my original first message posted on 3/31/2003.
-kashmir

WAC-02 all I485 case status
I'm very impressed with
off-patience's WAC-02-041 status
http://boards.immigrationportal.com/showthread.php?s=&threadid=63512
and
Silly Man's WAC-02-046 status
http://boards.immigrationportal.com/showthread.php?s=&threadid=64266

If we get all I485 case status,
we should know exactly
1) how many I485 cases being filed
2) how many cases are pending
3) what case numbers CSC is currently working on
etc.

And, if we update them every week,
we can see the progress exactly.

As the JIT report not being helpful recently,
it may be the only way for us to see the current situation and progress of I485 processing at CSC.

I will try it from WAC-02-001.
Some volunteers are welcome.
 
Last edited by a moderator:
Technical issues about BCIS Case Status Online

At the first two steps of this project:
1) scan all WAC-02 cases at BCIS Case Status Online to obtain all I485 case numbers
2) scan I485 case status regularly to grasp the BCIS CSC activity
a lot of inquiries are required,
however, the BCIS Case Status Online seems to limit about 1,000 inquiries per IP address and per day.

To avoid this limitation, there are two methods as follows.
1) use proxy servers
Using n proxies, I can inquire n x 1000 cases per day.
A proxy server must tunnel HTTPS request and response,
but only a few proxy servers support this feature,
and many of them seem not to be stable enough,
so still my inquiries are limited.
2) contributors to scan
If m people scan everyday for n days, we can inquire m x n x 1000 cases even if using no proxy, and stably.
I provide a Java program for this purpose, and there are another tools available such as off-patience's script for Excel.
If you are interested in some specific date, I encourage you to scan by yourself.
If you send me the result of your scan,
I will incorporate it into my database, and I will share my data with contributors.

Some people had been asking me to scan a specific date like:
"please scan WAC-02-XXX series, thanks"
however, I can not do that for the above technical limitation.
Instead of asking me or somebody,
you can do that by yourself.
You can find the information in this thread.
I will never response this kind of request at all.
-kashmir
 
Last edited by a moderator:
1st step - kashmir3.zip

The first step of this project is:
1) scan all WAC-02 cases at BCIS Case Status Online to obtain all I485 case numbers

If the case date that you are intested in is missing in my list,
all cases of that date must be scanned at first.
One date includes 5,000 cases in average, but sometimes more than 10,000 cases.
The BCIS Case Status Online limits about 1,000 inquiries per IP address and per day,
so scanning all cases will take several days unless using proxy.

kashmir3.zip
You can download kashmir3.zip that is one of my Java program for this project
at the following link.
It includes both Java compiled class file and Java source code.
http://www.immigrationportal.com/showthread.php?s=&postid=476276#post476276

To execute it, you need to install J2RE (Java 2 Runtime Environment) that you can download freely at http://java.sun.com/ .
If you want to modify the source code and compile it, you need J2SDK (Java2 Software Development Kit) that is also free.
I recommend you to download and install the latest version.

Usage of kashmir3.zip

You can execute kashmir3.zip at command prompt with two parameters as follows:

C:\kashmir> java -jar kashmir3.zip WAC0208150001 100

The first parameter is the case number to start scanning,
and the second parameter is the number of cases to scan.

For this example, it scans from WAC208150001 through WAC0208150100 for 100 cases
and writes the result of scanned status to the file named WAC0208150001-200304230521.tsv (if it being started at 5:21am on 4/23/2003).

To use a proxy server,
set two properties as follows:

C:\kashmir>java -Dhttps.proxyHost=HH.HH.HH.HH -Dhttps.proxyPort=PP -jar kashmir3.zip WAC0209550001 800

If you scan at the office that has firewall,
don't use that proxy server,
because BCIS Case Status Online limits about 1,000 inquiries per IP address.

I recommend you to scan at your home computer.
-kashmir
 
Last edited by a moderator:
scanned data format and case number

At the first two steps of this project:
1) scan all WAC-02 cases at BCIS Case Status Online to obtain all I485 case numbers
2) scan I485 case status regularly to grasp the BCIS CSC activity
a lot of case status should be inquired and saved for future usage.
It's important to keep scanned information as close to the original one as possible in order to prepare future change of applications.

Considering the above,
scanned data are stored in TSV format.
(TSV means TAB Separated Value.)
One line corresponds to one case status.
It has four fields such as
1) case number
2) status type
3) access time
4) status description in full sentence.
Here is an example:

WAC0200150001 <- TAB -> I90 <- TAB -> 2003-03-31 01:23:45 <- TAB -> This case has been approved. On December 06, 2001, an approval notice was mailed. ...

Case Number(s)
For tracking each case status, the case number is one of the most important key.
However, it's a little bit risky posting actual case number itself because of several reasons.
For instance, the BCIS Case Status Online seems to limit also the number of inquiries per case number per day,
although I have not confirmed it yet.
If the case were very interesting, we can easily imagine that many people would try to see that case status, then the person of that case may not be able to access his own case status.

So, when I post the information with its case number, I will modify the case number like:
WAC02050$025$
It means 25th I485 case of WAC-02-050 series.

For instance,
suppose WAC02030 has four I485 cases 50010, 50124, 50997, and 52365.
Then, there is 1:1 mapping
WAC02030$001$ <-> WAC0203050010
WAC02030$002$ <-> WAC0203050124
WAC02030$003$ <-> WAC0203050997
WAC02030$004$ <-> WAC0203052365
 
Last edited by a moderator:
Links to Related Threads

 
Last edited by a moderator:
WAC-02-001..005 status as of 3/31/2003

Code: 
[B] WAC-02-001 status as of 3/31/2003[/B]
Approved/Completed  182 (60%)
Transferred .......  25  (8%)
RFE Received ......  11  (4%)
RFE Sent ..........   2  (1%)
Resumed/FP Received  18  (6%)
FP Sent ...........   1  (0%)
Received ..........  19  (6%)
Denied/Withdrawn ..   1  (0%)
Misc ..............  44 (15%)
Total ............. 303

I found 303 I485 cases for WAC-02-001,
however I had to search at least 4728 cases.
I think the maximum case number is WAC0200154728,
but if you know bigger case number,
let me know.

Almost a half ot WAC-02-001 cases were I181

I may have to change my strategy at the first post
because I had some difficulties.

[B] WAC-02-002 status as of 3/31/2003[/B]
Approved/Completed   12 (22%)
Transferred .......  17 (31%)
RFE Received ......   7 (13%)
Resumed/FP Received   4  (7%)
Received ..........   1  (2%)
Misc ..............  13 (24%)
Total .............  54

1301 (WAC-02-002-50001 .. 51301)

[B] WAC-02-003 status as of 3/31/2003[/B]
Approved/Completed   13 (41%)
Transferred .......   3  (9%)
RFE Received ......   1  (3%)
RFE Sent ..........   2  (6%)
Resumed/FP Received   7 (22%)
Misc ..............   6 (19%)
Total .............  32

1032 (WAC-02-003-50001 .. 51032)

[B]No I485 cases for WAC-02-004 and 005[/B]
although having searched
WAC-02-004-50001 .. 50982
WAC-02-005-50001 .. 51324
 
Last edited by a moderator:
Re: No I485 cases for WAC-02-004 and 005

Originally posted by kashmir
although having searched
WAC-02-004-50001 .. 50982
WAC-02-005-50001 .. 51324
Click to expand...

How did you deal with 1000 request-per-day limit?

It looks like you have scanned many thousands records from different days.
 
> How did you deal with 1000 request-per-day limit?

Actually, it was the first problem I had to solve.
I used several proxy servers that supported HTTPS.

However, I would like to limit my inquiries
less than 10,000 cases = 500 cases/proxy x 20 proxies.
This will affect the strategy in mly first post.

I had already inquired 9,369 cases
for WAC-02-001 thru 005 today,
but I found only 379 I-485 cases.

This issue happens only first time.
Once we got the list of I-485 case numbers,
we may handle only 5-10% of all cases,
but we need a lot of inquiries at first,
and it will require many days.
This is why the volunteers are welcome.
 
02-059 stats

Status group-----Count-Last action on

RFE recvd-----1-1/2/2002
Resumed/FP recvd----61-5/31/2002
Received----6-12/7/2001

total----68
[/font]
 
Last edited by a moderator:
the latest WAC-02 status table in CSV format as of 2003-05-09

001,231,2,23,8,3,14,1,16,1,4,303
002,24,1,12,3,0,4,0,1,0,9,54
003,17,0,2,1,2,7,0,0,0,3,32
004,0,0,0,0,0,0,0,0,0,0,0
005,0,0,0,0,0,0,0,0,0,0,0
006,0,0,0,0,0,0,0,0,0,0,0
007,0,0,0,0,0,0,0,0,0,0,0
008,2,0,0,0,0,1,0,0,0,0,3
009,79,1,3,0,2,10,0,3,0,0,98
010,90,0,2,3,2,5,0,2,0,0,104
011,0,0,0,0,0,0,0,0,0,0,0
012,0,0,0,0,0,0,0,0,0,0,0
013,0,0,0,0,0,0,0,0,0,0,0
014,2,0,0,0,0,0,1,0,0,0,3
015,0,0,0,0,0,0,0,2,0,0,2
016,0,0,0,0,0,0,0,0,0,0,0
017,0,0,0,0,0,0,0,0,0,0,0
018,0,0,0,0,0,0,0,0,0,0,0
019,0,1,1,0,0,0,1,0,0,0,3
020,6,0,0,0,0,0,0,0,0,0,6
021,0,0,0,0,0,0,0,0,0,0,0
022,0,0,0,0,0,0,0,0,0,0,0
023,0,0,0,0,0,0,0,0,0,0,0
024,0,0,0,0,0,0,0,0,0,0,0
025,0,0,0,0,0,0,0,0,0,0,0
026,0,0,0,0,0,0,0,0,0,0,0
027,0,0,0,0,0,0,0,0,0,0,0
028,0,0,0,0,0,0,0,0,0,0,0
029,0,0,0,0,0,0,0,0,0,0,0
030,0,0,0,0,0,0,0,0,0,0,0
031,17,0,12,4,1,8,0,3,0,0,45
032,79,0,21,17,3,64,2,14,0,3,203
033,200,0,20,40,5,70,0,24,1,0,360
034,151,3,32,20,14,67,1,22,0,4,314
035,141,3,36,28,7,54,2,24,0,3,298
036,50,3,8,21,8,27,0,11,0,0,128
037,76,0,13,11,7,28,2,7,0,7,151
038,24,0,4,3,3,12,0,5,0,5,56
039,40,0,6,1,1,9,3,2,0,0,62
040,147,2,18,16,15,62,4,23,5,0,292
041,206,3,50,25,23,162,10,52,1,3,535
042,156,0,21,18,5,65,7,26,7,2,307
043,112,1,18,15,2,70,0,10,1,5,234
044,285,4,49,40,9,165,7,34,4,3,600
045,217,2,25,37,12,112,7,41,2,3,458
046,244,6,35,29,9,130,8,45,0,7,513
047,137,2,36,21,20,79,5,20,1,2,323
048,18,0,1,4,1,6,0,0,0,0,30
049,135,0,17,19,11,115,9,27,1,3,337
050,156,5,11,9,7,78,2,25,1,5,299
051,41,0,19,17,5,49,3,15,0,7,156
052,10,1,10,2,0,17,1,10,0,1,52
053,30,0,2,2,0,25,1,2,0,0,62
054,25,2,7,8,2,49,5,13,0,2,113
055,8,0,4,0,0,63,3,5,0,3,86
056,18,0,0,0,1,116,10,22,0,0,167
057,8,0,5,3,10,122,6,30,1,1,186
058,5,0,0,0,1,34,1,4,0,2,47
059,1,0,0,1,0,59,0,7,1,1,70
060,0,0,0,0,0,0,0,0,0,0,0
061,1,0,1,0,3,69,3,8,0,0,85
062,3,0,0,0,7,120,5,39,0,6,180
063,2,0,10,0,0,75,9,18,0,0,114
064,1,0,1,1,1,36,4,14,0,0,58
065,9,0,4,0,1,68,1,23,0,1,107
066,2,0,1,0,4,79,4,13,0,1,104
067,4,3,2,1,0,64,3,17,0,1,95
068,6,2,0,2,3,74,10,27,0,2,126
069,3,0,4,0,0,55,8,14,0,1,85
070,9,0,8,0,5,101,5,24,0,0,152
071,1,0,2,1,7,82,9,11,0,0,113
072,3,0,4,0,1,82,3,32,1,0,126
073,3,0,1,1,3,77,0,16,0,0,101
074,0,0,2,0,2,91,2,26,0,0,123
075,1,0,6,0,0,7,0,0,0,0,14
076,0,0,3,0,4,79,2,16,0,1,105
077,0,0,5,1,0,67,0,15,0,0,88
078,3,0,0,1,2,53,7,14,0,6,86
079,1,0,1,0,0,34,1,16,0,3,56
080,12,0,3,1,0,72,4,14,1,5,112
081,5,0,0,0,3,44,9,16,0,1,78
082,4,0,2,0,1,47,4,5,0,11,74
083,0,0,2,0,0,78,0,15,0,3,98
084,5,0,4,0,1,89,3,20,0,1,123
085,0,0,0,0,0,15,2,1,0,0,18
086,6,0,8,1,1,80,3,20,1,7,127
087,2,0,1,0,6,128,13,32,0,1,183
088,4,0,2,0,1,100,5,33,0,0,145
089,2,0,2,0,9,147,4,43,0,12,219
090,3,0,0,1,1,29,2,4,0,2,42
091,0,0,5,0,1,40,0,11,0,0,57
092,1,0,0,0,1,60,0,12,0,0,74
093,10,0,0,0,0,77,0,41,1,2,131
094,5,0,4,1,0,135,5,55,0,1,206
095,3,0,0,0,0,65,4,29,0,2,103
096,0,0,0,0,0,0,0,0,0,0,0
097,0,0,0,0,1,84,2,62,0,1,150
098,2,0,8,1,4,146,5,75,0,7,248
099,4,0,1,2,1,67,12,45,0,8,140
100,7,0,0,0,4,131,0,47,0,5,194
101,9,0,7,1,3,57,0,5,0,9,91
102,0,0,1,0,1,37,1,11,0,0,51
103,5,0,4,0,3,133,0,32,0,0,177
104,6,0,5,0,1,83,12,12,0,14,133
105,6,0,3,0,2,137,16,35,0,11,210
106,8,0,0,0,3,80,14,20,0,16,141
107,3,0,5,0,1,124,2,29,0,9,173
108,0,0,0,0,0,0,0,0,0,0,0
109,0,0,2,0,1,39,0,11,0,7,60
110,0,0,0,0,0,0,0,0,0,0,0
111,0,0,0,0,0,0,0,0,0,0,0
112,0,0,0,0,0,0,0,0,0,0,0
113,0,0,0,0,0,0,0,0,0,0,0
114,0,0,0,0,0,0,0,0,0,0,0
115,0,0,0,0,0,0,0,0,0,0,0
116,0,0,0,0,0,0,0,0,0,0,0
117,0,4,3,0,0,126,15,34,0,5,187
118,0,0,0,4,0,51,0,21,0,0,76
119,0,0,0,0,0,0,0,0,0,0,0
120,0,0,0,0,0,0,0,0,0,0,0
121,9,1,0,0,0,141,8,42,0,4,205
122,7,2,0,0,0,89,5,34,0,0,137
123,0,0,4,0,0,112,16,25,0,11,168
124,0,0,10,0,2,172,1,73,0,1,259
125,0,0,2,0,0,88,2,31,0,0,123
126,2,0,0,1,5,114,5,24,0,0,151
127,0,0,0,0,0,0,0,0,0,0,0
128,0,0,0,0,0,0,0,0,0,0,0
129,0,0,0,0,0,0,0,0,0,0,0
130,0,0,0,0,0,0,0,0,0,0,0
131,3,0,0,0,0,47,0,6,0,0,56
132,0,0,0,0,0,0,0,0,0,0,0
133,0,0,0,0,0,0,0,0,0,0,0
134,0,0,0,0,0,0,0,0,0,0,0
135,0,0,0,0,0,0,0,0,0,0,0
136,0,0,0,0,0,0,0,0,0,0,0
137,0,0,0,0,4,21,2,5,0,0,32
138,0,0,0,0,0,0,0,0,0,0,0
139,0,0,0,0,0,0,0,0,0,0,0
140,0,0,0,0,0,0,0,0,0,0,0
141,0,0,0,0,0,0,0,0,0,0,0
142,0,0,0,0,0,0,0,0,0,0,0
143,0,0,0,0,0,29,0,18,0,3,50
144,0,0,0,0,0,0,0,0,0,0,0
145,0,0,0,0,0,0,0,0,0,0,0
146,0,0,0,0,0,0,0,0,0,0,0
147,0,0,0,0,0,0,0,0,0,0,0
148,0,0,0,0,0,0,0,0,0,0,0
149,0,0,0,0,0,0,0,0,0,0,0
150,3,0,6,0,6,122,8,28,1,4,178
151,0,0,0,0,0,0,0,0,0,0,0
152,0,0,0,0,0,0,0,0,0,0,0
153,0,0,0,0,0,0,0,0,0,0,0
154,0,0,0,0,0,0,0,0,0,0,0
155,0,0,0,0,0,0,0,0,0,0,0
156,4,0,4,1,13,137,2,49,1,4,215
157,0,0,0,0,0,0,0,0,0,0,0
158,0,0,0,0,0,0,0,0,0,0,0
159,0,0,0,0,0,0,0,0,0,0,0
160,0,0,0,0,0,0,0,0,0,0,0
161,0,0,0,0,0,0,0,0,0,0,0
162,0,0,0,0,0,0,0,0,0,0,0
163,0,0,0,0,0,0,0,0,0,0,0
164,0,0,0,0,0,0,0,0,0,0,0
165,2,0,13,0,0,75,6,13,0,4,113
166,0,0,0,0,0,0,0,0,0,0,0
167,0,0,0,0,0,0,0,0,0,0,0
168,0,0,0,0,0,0,0,0,0,0,0
169,0,0,0,0,0,0,0,0,0,0,0
170,0,0,0,0,0,0,0,0,0,0,0
171,0,0,0,0,0,0,0,0,0,0,0
172,0,0,0,0,0,0,0,0,0,0,0
173,0,0,0,0,0,0,0,0,0,0,0
174,0,0,0,0,0,0,0,0,0,0,0
175,0,0,0,0,0,0,0,0,0,0,0
176,0,0,0,0,3,94,2,13,0,0,112
177,0,0,0,0,0,0,0,0,0,0,0
178,0,0,0,0,0,0,0,0,0,0,0
179,0,0,0,0,0,0,0,0,0,0,0
180,7,0,7,0,1,136,0,21,0,3,175
181,0,0,0,0,0,0,0,0,0,0,0
182,1,1,6,0,1,142,0,23,0,8,182
183,3,0,0,0,0,63,3,11,0,5,85
184,4,0,0,0,0,156,0,21,3,6,190
185,0,0,0,0,0,0,0,0,0,0,0
186,0,0,0,0,0,0,0,0,0,0,0
187,0,0,0,0,0,0,0,0,0,0,0
188,0,0,0,0,0,0,0,0,0,0,0
189,0,0,0,0,0,0,0,0,0,0,0
190,0,0,0,0,0,0,0,0,0,0,0
191,0,0,0,0,0,0,0,0,0,0,0
192,0,0,2,0,2,69,0,13,0,1,87
193,0,0,0,0,0,0,0,0,0,0,0
194,0,0,0,0,0,0,0,0,0,0,0
195,0,0,0,0,0,0,0,0,0,0,0
196,0,0,0,0,0,0,0,0,0,0,0
197,0,0,0,0,0,0,0,0,0,0,0
198,0,0,0,0,0,0,0,0,0,0,0
199,0,0,0,0,0,0,0,0,0,0,0
200,15,0,1,2,0,44,0,10,0,3,75
201,0,0,0,0,0,0,0,0,0,0,0
202,0,0,0,0,0,0,0,0,0,0,0
203,0,0,0,0,0,0,0,0,0,0,0
204,0,0,0,0,0,0,0,0,0,0,0
205,0,0,3,1,0,184,2,40,0,8,238
206,0,0,0,0,0,0,0,0,0,0,0
207,0,0,0,0,0,0,0,0,0,0,0
208,0,0,0,0,0,0,0,0,0,0,0
209,0,0,0,0,0,0,0,0,0,0,0
210,0,0,0,0,0,0,0,0,0,0,0
211,0,0,0,0,0,0,0,0,0,0,0
212,0,0,0,0,0,0,0,0,0,0,0
213,0,0,0,0,0,0,0,0,0,0,0
214,0,0,0,0,0,0,0,0,0,0,0
215,0,0,0,0,0,0,0,0,0,0,0
216,0,0,0,0,0,0,0,0,0,0,0
217,0,0,0,0,0,0,0,0,0,0,0
218,3,0,0,1,0,55,1,15,0,0,75
219,0,0,0,0,0,0,0,0,0,0,0
220,0,0,0,0,0,0,0,0,0,0,0
221,0,0,0,0,0,0,0,0,0,0,0
222,0,0,0,0,0,0,0,0,0,0,0
223,0,0,0,0,0,0,0,0,0,0,0
224,0,0,0,0,0,0,0,0,0,0,0
225,0,0,0,0,0,90,1,15,0,4,110
226,0,0,0,0,0,0,0,0,0,0,0
227,0,0,0,0,0,0,0,0,0,0,0
228,0,0,0,0,0,0,0,0,0,0,0
229,0,0,0,0,0,0,0,0,0,0,0
230,0,0,0,0,0,0,0,0,0,0,0
231,0,0,0,0,0,0,0,0,0,0,0
232,0,0,0,0,0,0,0,0,0,0,0
233,0,0,0,0,0,0,0,0,0,0,0
234,0,0,0,0,0,0,0,0,0,0,0
235,0,0,0,0,0,0,0,0,0,0,0
236,0,0,0,0,0,0,0,0,0,0,0
237,0,0,0,0,0,0,0,0,0,0,0
238,0,0,0,0,0,0,0,0,0,0,0
239,0,0,0,0,0,0,0,0,0,0,0
240,0,0,0,0,0,0,0,0,0,0,0
241,0,0,0,0,0,0,0,0,0,0,0
242,2,0,0,0,0,55,2,7,0,0,66
243,0,0,0,0,0,0,0,0,0,0,0
244,0,0,0,0,0,0,0,0,0,0,0
245,0,0,0,0,0,0,0,0,0,0,0
246,0,0,0,0,0,0,0,0,0,0,0
247,0,0,0,0,0,0,0,0,0,0,0
248,0,0,0,0,0,0,0,0,0,0,0
249,0,0,0,0,0,0,0,0,0,0,0
250,0,0,0,0,0,0,0,0,0,0,0
251,0,0,0,0,0,0,0,0,0,0,0
252,0,0,7,0,0,65,0,17,0,0,89
253,0,0,0,0,0,0,0,0,0,0,0
254,0,0,0,0,0,0,0,0,0,0,0
255,0,0,0,0,0,0,0,0,0,0,0
256,0,0,0,0,0,0,0,0,0,0,0
257,0,0,0,0,0,0,0,0,0,0,0
258,0,0,0,0,0,0,0,0,0,0,0
259,0,0,0,0,0,0,0,0,0,0,0
260,0,0,0,0,0,0,0,0,0,0,0
261,0,0,0,0,0,0,0,0,0,0,0
262,0,0,0,0,0,0,0,0,0,0,0
263,0,0,0,0,0,0,0,0,0,0,0
264,0,0,0,0,0,0,0,0,0,0,0
265,0,0,0,0,0,0,0,0,0,0,0
266,0,0,0,0,0,0,0,0,0,0,0
267,0,0,3,0,0,41,4,5,0,0,53
268,0,0,0,0,0,0,0,0,0,0,0
269,0,0,0,0,0,0,0,0,0,0,0
270,0,0,0,0,0,0,0,0,0,0,0
271,0,0,2,1,1,126,43,34,0,21,228
272,0,0,0,0,0,0,0,0,0,0,0
273,5,0,2,0,0,121,66,41,0,4,239
274,0,0,0,0,0,0,0,0,0,0,0
275,4,0,1,1,0,112,39,41,0,15,213
276,0,0,0,0,0,0,0,0,0,0,0
277,0,0,0,0,0,0,0,0,0,0,0
278,0,0,0,0,0,0,0,0,0,0,0
279,0,0,4,2,1,126,4,28,0,9,174
280,0,0,0,0,0,0,0,0,0,0,0
281,0,0,0,0,0,0,0,0,0,0,0
282,0,0,0,0,0,0,0,0,0,0,0
283,0,0,0,0,0,0,0,0,0,0,0
284,0,0,0,0,0,87,77,33,0,9,206
285,0,0,3,0,0,46,47,19,0,4,119
286,0,0,0,0,0,0,0,0,0,0,0
287,0,0,0,0,0,0,0,0,0,0,0
288,0,0,0,0,0,0,0,0,0,0,0
289,0,0,0,1,0,160,3,24,0,7,195
 
Last edited by a moderator:
WAC02008 status on 4/1/2003

Code: 
Denied/Withdrawn ..   1 (33%)
Misc ..............   2 (67%)
Total .............   3

WAC-02-008-50001 .. 51452
 
WAC-02-009 status on 4/1/2003

Code: 
Approved/Completed   67 (68%)
Transferred .......   6  (6%)
RFE Sent ..........   2  (2%)
Resumed/FP Received  10 (10%)
Received ..........   4  (4%)
Misc ..............   9  (9%)
Total .............  98

WAC-02-009-50001 .. 54390
 
WAC-02-006..010 status as of 4/1/2003

Code: 
[B]No I485 cases for WAC-02-006 and 007[/B]
although having searched
WAC-02-006-50001 .. 50272
WAC-02-007-50001 .. 51389

[B]WAC-02-008 status as of 4/1/2003[/B]
Denied/Withdrawn ..   1 (33%)
Misc ..............   2 (67%)
Total .............   3
(WAC-02-008-50001 .. 51452)

[B]WAC-02-009 status as of 4/1/2003[/B]
Approved/Completed   67 (68%)
Transferred .......   6  (6%)
RFE Sent ..........   2  (2%)
Resumed/FP Received  10 (10%)
Received ..........   4  (4%)
Misc ..............   9  (9%)
Total .............  98
(WAC-02-009-50001 .. 54390)

[B]WAC-02-010 status as of 4/1/2003[/B]
Approved/Completed   73 (70%)
RFE Received ......   3  (3%)
Resumed/FP Received   7  (7%)
Received ..........   3  (3%)
Denied/Withdrawn ..   1  (1%)
Misc ..............  17 (16%)
Total ............. 104
(WAC-02-010-50001 .. 52017)
 
Last edited by a moderator:
Kashmir, this is ultra awesome, tracking for a large number of wac-02-xxxx would really really help us all.

I am toying with the idea of making all those excel sheets public, so that anyone who asks me or anyone to run the scan for say .. wac-02-50 .. can just pick this excel sheet and do it himself.

But this thing you are doing, WOW :)

Also, it'd be great if we can post as a standard format that Kashmir is using. So someone can copy paste and make a graph out of excel.
 
data format

I am so poor that I can not purchase an expensive software such as Excel.
Linux is running on my computer, and I wrote some Java programs for this thread.
The current version of my programs is a very early stage of prototype and totally not user-friendly,
but I may open it with source codes.

It consists of two parts.
The first one gets case status from egov.immigration.gov.
The second one makes the summary report from data.
Both of them have command line interface.

The data format is very simple, just text format separated by TAB.
One line corresponds to one case status.
For the first program,
input format has only one field, case number,
and output format has four fields such as case number, type, access time, and status in full description.
For instance, if input is:
WAC0200150001
then output is:
Code: 
WAC0200150001   I90     2003-03-31 01:23:45     This case has been approved. On December  06, 2001, an approval notice was mailed.  ...

I am posting only the summary at this thread, but I may put all raw data.
I believe it is a good idea to share all raw data among us.
For instance, I don't have Excel, but somebody may be able to create a useful table and a wonderful graph.

As I'm not familier with Excel,
so if another format is preferred,
I can convert it to CSV, XML, etc. but not to Excel binary file.
 
kashmir, you are hella smart. I remember a need for a long time for such a program to be written in Java.

All we need is a list of wac's that are 485's in different WAC#'s ... say as a text file. If you can provide that, I can do the rest. Easy as that :)
 
WAC-02-001 .. 010 I485 case number list

Attached is the list of I485 case numbers
from WAC-01-001 through 010.
It includes 594 cases.

*
I deleted the attachment on 4/12/2003.
-kashmir
 
Last edited by a moderator:
Great, ultra awesome.

Now as you go scanning, maybe if you could have us know this same thing for say .. wac-02-1x-- ?? etc. etc.

That way, we would have a neat little picture of ALL of wac-02 series ..

Doesn't get anymore accurate than that does it? :)
 
Java program part 1

Attached is my Java program to inquire case status.
It includes Java source code, too.
Please rename it to "kashmir1.jar".

input (STDIN) : case number
output (STDOUT) : case number (TAB) type (TAB) inquiry time (TAB) status full description

You can use it interactively,
but if you prepare the list of case numbers,
you can run it in batch mode.
example:
% cat wac02-001-010-i485.txt | java -jar kashmir1.jar > STATUS.TSV

If you want to use a proxy server,
set the following two properties:
https.proxyHost
https.proxyPort
example:
% java -Dhttps.proxyHost=XXX.XXX.XXX.XXX -Dhttps.proxyPort=XXXX -jar kashmir1.jar

If you have not signed the CSC petition yet,
please sign the petition before downloading.
http://www.immigration.com/common/rsk/petition_california.html
 
You must log in or register to reply here.
Top