Google Sheets Demo

	A	B	C	D	E	F	G	H	I	J
2	U.S. non-immigrant visas issued in 2018
3	All data comes from here: https://angelinahli.shinyapps.io/visas/
4	Visa category		Issuances and refusals					Country receiving the most visas
5	Category	Description	# Issued	# Refused	# Refusals overcome	% Issued	% Granted	Country	# Issued	% Total Issued Visas
6					Refusals are sometimes overcome in the following year.		This includes visas that were originally refused, but later were 'overcome'.

7	A1	Ambassador, public minister, career diplomat or consular officer, or immediate family	9,856	2,802	2,504	78%	98%	China - mainland	523	5%
8	A2	Other foreign government official or employee, or immediate family	103,134	16,201	12,881	86%	97%	Japan	9,448	9%
9	A3	Attendant, servant, or personal employee of A1 or A2, or immediate family	830	665	428	56%	84%	Philippines	254	31%
10	B1	Temporary visitor for business	38,705	14,995	6,669	72%	84%	Philippines	6,337	16%
11	B1/B2	Temporary visitor for business & pleasure	5,708,278	2,735,214	446,345	68%	73%	China - mainland	1,241,879	22%
12	B2	Temporary visitor for pleasure	32,428	13,593	3,079	70%	77%	Burma	5,054	16%
13	BBBCC	Combination B-1/B-2 and Border Crossing Card	962,888	404,133	31,891	70%	73%	Mexico	962,888	100%
14	BBBCV	Combination B-1/B-2 and Border Crossing Card (Lincoln Foil)	69,579	10,709	2,345	87%	90%	Mexico	69,579	100%
15	BCC	The Border Crossing Card (BCC) is both a BCC and a B1/B2 visitor‚Äôs visa.							0
16	C1	Alien in transit	9,563	3,880	699	71%	76%	Burma	1,469	15%
17	C1/D	Combined transit and crewmember visa	288,957	29,124	17,506	91%	96%	Philippines	78,518	27%
18	C2	Alien in transit to United Nations Headquarters district under Section 11.(3), (4), or (5) of the Headquarters Agreement	4	4	1	50%	63%	Bangladesh	1	25%
19	C3	Foreign government official, immediate family, attendant, servant or personal employee, in transit	6,085	328	217	95%	98%	Japan	871	14%
20	CW1	Commonwealth of Northern Mariana Islands transitional worker	3,002	1,467	1,258	67%	95%	Philippines	1,871	62%
21	CW2	Spouse or child of CW-1	548	295	256	65%	95%	Philippines	347	63%
22	D	Crewmember (sea or air)	6,689	891	652	88%	97%	Burma	4,229	63%
23	DCREW	Crewlist Visas							0
24	E1	Treaty trader, spouse or child	6,542	2,124	1,705	75%	95%	Japan	1,684	26%
25	E2	Treaty investor, spouse or child	41,181	13,489	8,647	75%	91%	Japan	13,399	33%
26	E2C	Commonwealth of Northern Mariana Islands investor, spouse or child	39	27	24	59%	95%	Korea, South	19	49%
27	E3	Australian specialty occupation profession	5,394	664	572	89%	98%	Australia	5,394	100%
28	E3D	Spouse of child of Australian specialty occupation professional	4,341	437	408	91%	99%	Australia	3,562	82%
29	E3R	Returning Australian specialty occupation professional	2,941	250	234	92%	99%	Australia	2,941	100%
30	F1	Student in an academic or language training program	362,929	195,187	67,850	65%	77%	China - mainland	98,904	27%
31	F2	Spouse or child of F1	26,650	15,398	5,830	63%	77%	Brazil	4,751	18%
32	F3	Border commuter academic or language student							0
33	G1	Principal resident representative of recognized foreign government to international organization, staff, or immediate family	5,328	2,068	1,878	72%	97%	Russia	324	6%
34	G2	Other representative of recognized foreign member government to international organization, and immediate family	16,340	3,603	2,777	82%	96%	Congo, Dem. Rep. of the (Kinshasa)	567	3%
35	G3	Representative of nonrecognized or nonmember foreign government to international organization, and immediate family	343	112	101	75%	98%	Korea, North	45	13%
36	G4	International organization officer or employee, and immediate family	23,617	3,206	2,921	88%	99%	India	1,278	5%
37	G5	Attendant, servant, or personal employee of G1 through G4, and immediate family	541	330	251	62%	91%	Philippines	101	19%
38	H1A	Temporary worker performing services as a registered nurse							0
39	H1B	Temporary worker of distinguished merit and ability performing services other than as a registered nurse	179,660	51,373	49,418	78%	99%	India	125,528	70%
40	H1B1	Free Trade Agreement Professional	1,498	215	175	87%	98%	Singapore	808	54%
41	H1C	Shortage area nurse	0	1	1	0%	100%		0
42	H2A	Temporary worker performing agricultural services	196,409	23,262	8,119	89%	93%	Mexico	180,420	92%
43	H2B	Temporary worker performing other services	83,774	10,218	3,533	89%	93%	Mexico	62,162	74%
44	H2R	Returning H2B worker							0
45	H3	Trainee	1,036	341	252	75%	94%	Mexico	122	12%
46	H4	Spouse or child of H-1B/B1/C, H-2A/B, or H‚Äì3	130,814	23,362	21,937	85%	99%	India	111,242	85%
47	I	Representative of foreign information media, spouse and children	11,874	2,356	1,296	83%	93%	Great Britain and Northern Ireland	1,768	15%
48	J1	Exchange visitor	342,639	63,233	35,298	84%	93%	China - mainland	39,010	11%
49	J2	Spouse or child of exchange visitor	39,580	10,531	9,240	79%	97%	China - mainland	11,359	29%
50	K1	Fiance(e) of U. S. citizen	24,675	18,605	10,427	57%	81%	Philippines	5,124	21%
51	K2	Child of K-1	3,981	1,909	973	68%	84%	Philippines	1,193	30%
52	K3	Certain spouse of U.S. Citizen	6	28	7	18%	38%	Mexico	2	33%
53	K4	Child of K-3	0	0	0				0
54	L1	Intracompany transferee (executive, managerial, and specialized personnel continuing employment with international firm or corporation)	74,388	16,336	8,446	82%	91%	India	18,473	25%
55	L2	Spouse or child of intracompany transferee	78,711	11,681	8,189	87%	96%	India	23,230	30%
56	M1	Vocational student and other nonacademic student	9,317	4,304	1,728	68%	81%	China - mainland	2,136	23%
57	M2	Spouse or child of vocational student	366	217	97	63%	79%	Saudi Arabia	55	15%
58	M3	Border commuter vocational or nonacademic student							0
59	N8	Parent of SK-3 or SN-3 special immigrant	18	21	5	46%	59%	Ghana	2	11%
60	N9	Child of N-8 or of SK-1, SK-2, SK-4, SN-1, SN-2, or SN-4 special immigrant	4	2	0	67%	67%	Nigeria	1	25%
61	NATO1	Principal permanent representative of member state to NATO (including any of its subsidiary bodies) resident in the U.S. and resident members of official staff; principal NATO officers; and immediate family	3	0	0	100%	100%	Latvia	2	67%
62	NATO2	Other representative of member state to NATO (including any of its subsidiary bodies) and immediate family; dependents of member of a force entering in accordance with the provisions of the NATO agreements; members of such a force if issued visas	6,593	198	178	97%	100%	Belgium	898	14%
63	NATO3	Official clerical staff accompanying a representative of member state to NATO, and immediate family	0	0	0				0
64	NATO4	Official of NATO (other than those classifiable as NATO-1), and immediate family	202	4	4	98%	100%	Great Britain and Northern Ireland	30	15%
65	NATO5	Experts, other than NATO-4 officials, employed in missions on behalf of NATO, and their dependents	29	1	0	97%	97%	Germany	21	72%
66	NATO6	Member of a civilian component accompanying a force entering in accordance with the provisions of the NATO agreements, and their dependents	569	23	22	96%	100%	Germany	419	74%
67	NATO7	Attendant, servant, or personal employee of NATO-1 through NATO-6, and immediate family	2	0	0	100%	100%	Estonia	2	100%
68	O1	Person with extraordinary ability in sciences, arts, education, business or athletics	16,904	3,926	3,614	81%	99%	Great Britain and Northern Ireland	2,855	17%
69	O2	Person accompanying and assisting in the artistic or athletic performance by O-1	8,432	1,646	1,233	84%	96%	Great Britain and Northern Ireland	2,261	27%
70	O3	Spouse or child of O-1 or O-2	4,923	1,110	1,009	82%	98%	Great Britain and Northern Ireland	616	13%
71	P1	Internationally recognized athlete or member of internationally recognized entertainment group	24,320	3,991	2,848	86%	96%	Mexico	4,036	17%
72	P2	Artist or entertainer in a reciprocal exchange program	144	15	14	91%	99%	Great Britain and Northern Ireland	75	52%
73	P3	Artist or entertainer in a culturally unique program	10,225	2,831	1,355	78%	89%	India	2,204	22%
74	P4	Spouse or child of P-1, P-2, or P-3	1,386	306	219	82%	95%	Venezuela	195	14%
75	Q1	Participant in an international cultural exchange program	1,997	231	164	90%	97%	Italy	428	21%
76	Q2	Irish Peace Process trainee							0
77	Q3	Spouse or child of Q2							0
78	R1	Alien in a religious occupation	4,607	1,688	905	73%	88%	India	823	18%
79	R2	Spouse or child of R1	1,700	1,002	465	63%	80%	India	294	17%
80	S5	Informant possessing critical reliable information concerning criminal organization or enterprise	0	0	0				0
81	S6	Informant possessing critical information concerning terrorist organization, enterprise, or operation	0	1	1	0%	100%		0
82	S7	Spouse, married or unmarried son or daughter, or parent of S-5 or S-6	0	4	2	0%	50%		0
83	T1	Victim of a severe form of trafficking in persons							0
84	T2	Spouse of T1	66	26	24	72%	98%	Philippines	28	42%
85	T3	Child of T1	296	116	108	72%	98%	Philippines	98	33%
86	T4	Parent of T1 under 21 years of age	28	12	9	70%	93%	El Salvador	8	29%
87	T5	Unmarried sibling under age 18 of T-1 under 21 years of age	34	10	9	77%	98%	Guatemala	12	35%
88	T6	Adult/minor child of derivative beneficiary of T-1	11	11	10	50%	95%	Philippines	8	73%
89	TD	Spouse or child of TN	10,239	1,378	922	88%	96%	Mexico	9,515	93%
90	TN	NAFTA professional	17,950	3,436	1,842	84%	93%	Mexico	17,859	99%
91	U1	Victim of criminal activity	128	243	187	35%	85%	Mexico	93	73%
92	U2	Spouse of U-1	174	162	152	52%	97%	Mexico	64	37%
93	U3	Child of U-1	1,521	670	520	69%	93%	Mexico	542	36%
94	U4	Parent of U-1 under 21 years of age	36	65	61	36%	96%	Mexico	25	69%
95	U5	Unmarried sibling under age 18 of U-1 under 21 years of age	25	17	16	60%	98%	Mexico	12	48%
96	V1	Certain Spouse of Legal Permanent Resident							0
97	V2	Certain Child of Legal Permanent Resident							0
98	V3	Child of V1 or V2							0
99
100
101