Project Kashmir:WAC-02 all I485 case status

[kashmir]

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

• Technical issue about the BCIS Case Status Online
• 1st step - kashmir3.zip
• scanned data format and case number(s)
• links to related threads

--------------------------------------------------
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/...threadid=63512
and
Silly Man's WAC-02-046 status
http://boards.immigrationportal.com/...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.

[kashmir]

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

[kashmir]

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/sho...276#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

[kashmir]

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

[kashmir]

• Project Kashmir - related small projects
• Vote Your Opinion: Project Kashmir - posting data with actual case number(s)

• Silly Man - Vote Your Opinion: Kashmir Project and Projectlets
• off-patience - How to make a simple status report with only Excel in hands...
• off-patience - I485 Status Snapshost for WAC-02-041-5XXXX
• Silly Man - WAC-02-046 stats
• Tasse - WAC-02-067 status
• Silly Man - More kashmir research
• cal_aos_waiting - Processing Speed at CSC (based on Kashmir's analyses)
• Silly Man - Some interesting analysis from kashmir's data
• HFIG - Good Job, Kashmir
• ND022202 - Post graphs and stat analysis here - J.Bcis.Res.
• Jitup - Congrats Kashmir
• bankebihari123 - Kashmir where are you...
• longwait_2001 - Approvals based on Kashmir stats(From 06/17 to 06/30)
• kenboo - I-140 scan (Project kashmir related small project)
• cal_aos_waiting - Kashmir, where r u man?

• sbctsublc - Vsc 485 Case Status
• DNJ - Scanning All 485 Cases possible ! - VSC
• Jan-MMII - Stats for ND 12/3, 12/28, 1/3, 1/16, 2/1-2/7
• OnlyGC - To monitor our own EAC series

• lifeonhold - kashmir project for NSC ???
• Pork Chop - The Greenland Report - NSC
• ImmigrationUSA - Statistic info to share
• gheewalabhai888 - JAVA Gurus: Aawo fellas seer takaraye!: Technical help needed:
• CustomCat - Project Kashmir vs. Greenland Script
• march02485info - Scan LINS Using Greenland and Kashmir - Reduce Overhead
• FunkyJunky - NSC processing methodology - a breakthrough in understanding?
• FunkyJunky - Greenland Summary Report

• eb2_I485_RD0901 - Data Consolidation Project

[kashmir]

 WAC-02-001 status as of 3/31/2003
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.

 WAC-02-002 status as of 3/31/2003
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)

 WAC-02-003 status as of 3/31/2003
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)

No I485 cases for WAC-02-004 and 005
although having searched
WAC-02-004-50001 .. 50982
WAC-02-005-50001 .. 51324

[off-patience]

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

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

It looks like you have scanned many thousands records from different days.

[kashmir]

> 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.

[ND022202]

to track how things are changing. Like 02-001, 02-005, 02-010,...

[ND022202]

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]

[kashmir]

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

[kashmir]

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

WAC-02-008-50001 .. 51452

[kashmir]

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

[kashmir]

No I485 cases for WAC-02-006 and 007
although having searched
WAC-02-006-50001 .. 50272
WAC-02-007-50001 .. 51389

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

WAC-02-009 status as of 4/1/2003
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-010 status as of 4/1/2003
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)

[Silly Man]

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.

[kashmir]

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:

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.

[Silly Man]

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

[kashmir]

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

[Silly Man]

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?

[kashmir]

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/rs...alifornia.html

[kashmir]

although having searched
WAC-02-011-50001 .. 50379
WAC-02-012-50001 .. 51517
WAC-02-013-50001 .. 52501

[kashmir]

Approved/Completed    2 (67%)
FP Sent ...........   1 (33%)
Total .............   3

WAC-02-014-50001 .. 53016

[kashmir]

Received ..........   2 (100%)
Total .............   2

WAC-02-015-50001 .. 53642

[zhongman]

Dear Kashmir,

I was trying to run your program under window 2000. I got the following error:

java -jar Kashmir1.jar
Exception in thread "main" java.util.zip.ZipException: error in opening zip file

at java.util.zip.ZipFile.open<Native Methodd>
at java.util.zip.ZipFile.<init><Unknown Source>
at java.util.jar.JarFile.<init><Unknown Source>
at java.util.jar.JarFile.<init><Unknown Source>

I ran the program on a Sun machine, I got the same error message.

Could you tell what was wrong?

Your help is highly appreicaited.

Zhongman

[kashmir]

Hi, zhongman,

Which version of Java do you use ?
It might be old.
I tested it only with v1.4.1 .

Workarounds are:
1) get the latest version of J2RE (or J2SE) from http://java.sun.com/
It's free.
OR
2) extract the zip file, then execute without -jar option as follows
( jar file is basically a zip file.)
C> unzip kashmir1.zip
... you will find kashmir\Kashmir1.class (and Kashmir1.java source code)
C> java kashmir.Kashmir1

If you can not unzip it,
the file must be corrupted.

[jaymehra11]

Kashmir,
Great Job!!!!!!!!!!!!!!

Let us prepare the list of all wac number in the txt file
between 10/01/2001 to 12/30/2001.
I think total number of 485 between 10/01/2001
and 12/30/2001 , Would be within 10,000-15,000 cases.

and everyweek uses this txt file run against the bcis server.
and have a good progress report.


-jay.

[kashmir]

This project consists of three parts
as jaymehra11 mentioned at the previous post and another thread:
http://boards.immigrationportal.com/...threadid=78771

1) make the list of all I485 case numbers
2) inquire the I485 case status regularly (maybe weekly)
3) analize

For the third part,
I wrote a simple program to summarize case status in order to post to this thread,
but it seems to have a minor bug.
And, I think some of you have already had some tools, maybe scripts for spreadsheet.

For the second part,
we will be able to do that as jaymehra11 proposing
once we had the list of I485 case numbers.

I believe the most difficult part is the first one.
The ratio of I485 cases seems only 2-5%,
however we must inquire all cases to BCIS web site.
It will take a long time.

Anyway, I will focus the first part for a while
to make the list of all I485 case numbers.

[kashmir]

Although WAC-001-016 to 020 scanned,
only 9 new I485 cases were found.

WAC-02-016-50001 .. 53671 : 0
WAC-02-017-50001 .. 52592 : 0
WAC-02-018-50001 .. 50721 : 0
WAC-02-019-50001 .. 54137 : 3
WAC-02-020-50001 .. 54310 : 6

Attached includes 608 I485 cases.

*
I deleted the attachment on 4/12/2003.
-kashmir

[kashmir]

WAC-02-019
Transferred .......   1 (33%)
FP Sent ...........   1 (33%)
Received ..........   1 (33%)
Total .............   3

WAC-02-020
Approved/Completed    5 (83%)
Misc ..............   1 (17%)
Total .............   6

My summary report might have a minor error as I posted before.

[kashmir]

Our focus is I485,
but it might be helpful
to have information:
1) what type of application being filed
2) how many cases per type being filed

Attached is the list of application type for all cases WAC-02-001 thru 020.
FOrmat is:
case number (TAB) application type

It includes 45,373 records.
(The number of I485 cases is only 608.)

.. but attach file must be less than 102,400 bytes,
so I devided it.

*
I deleted the attachment on 4/12/2003.
-kashmir