36C78618R0043-00002001.xlsx

XLSX spreadsheet 36 KB Posted Jan 31, 2018

Attached to: Provide Marble Headstones Primarily to Private Cemeteries.
Solicitation number: 36C78618R0043
Issued by: Department of Veterans Affairs National Cemetery Administration

About this file

From the source

36C78618R0043 00002 See attachment Distribution for Private U1 and U5.xlsx

View the file

Other files

File	Type	Posted
36C78618D0117-000.docx	DOCX document	Mar 29, 2018
36C78618R0043-00002000.docx	DOCX document	Jan 31, 2018
36C78618R0043-00001000.docx	DOCX document	Jan 29, 2018
36C78618R0043-010.pdf	PDF	Dec 27, 2017
36C78618R0043-015.pdf	PDF	Dec 27, 2017
36C78618R0043-014.pdf	PDF	Dec 27, 2017
36C78618R0043-016.pdf	PDF	Dec 27, 2017
36C78618R0043-013.pdf	PDF	Dec 27, 2017
36C78618R0043-009.pdf	PDF	Dec 27, 2017
36C78618R0043-005.pdf	PDF	Dec 27, 2017
36C78618R0043-012.pdf	PDF	Dec 27, 2017
36C78618R0043-007.pdf	PDF	Dec 27, 2017
36C78618R0043-006.pdf	PDF	Dec 27, 2017
36C78618R0043-002.docx	DOCX document	Dec 27, 2017
36C78618R0043-003.pdf	PDF	Dec 27, 2017
36C78618R0043-004.pdf	PDF	Dec 27, 2017
36C78618R0043-011.pdf	PDF	Dec 27, 2017
36C78618R0043-008.pdf	PDF	Dec 27, 2017
36C78618R0043-001.pdf	PDF	Dec 27, 2017
36C78618R0043-000.docx	DOCX document	Dec 27, 2017

Show all 20

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

FY16 Private U1 & U5

STA_PROV_CD	COUNTRY_CD	MONUMENT_TYPE_CD	COUNT(MONUMENT_TYPE_CD)	% of Total for FY16
AK		U1	33	0.4%
AL		U1	776	10.5%
AR		U1	117	1.6%
AZ		U1	181	2.4%
CA		U1	147	2.0%
CO		U1	152	2.1%
CT		U1	667	9.0%
DC		U1	5	0.1%
DE		U1	2	0.0%
FL		U1	135	1.8%
GA		U1	280	3.8%
HI		U1	29	0.4%
IA		U1	49	0.7%
ID		U1	22	0.3%
IL		U1	148	2.0%
IN		U1	140	1.9%
KS		U1	66	0.9%
KY		U1	207	2.8%
LA		U1	106	1.4%
MA		U1	190	2.6%
MD		U1	40	0.5%
ME		U1	29	0.4%
MI		U1	109	1.5%
MN		U1	51	0.7%
MO		U1	67	0.9%
MS		U1	141	1.9%
MT		U1	182	2.5%
NC		U1	279	3.8%
ND		U1	12	0.2%
NE		U1	75	1.0%
NH		U1	6	0.1%
NJ		U1	47	0.6%
NM		U1	156	2.1%
NV		U1	5	0.1%
NY		U1	455	6.2%
OH		U1	158	2.1%
OK		U1	216	2.9%
OR		U1	31	0.4%
PA		U1	125	1.7%
PR		U1	6	0.1%
RI		U1	611	8.3%
SC		U1	151	2.0%
SD		U1	70	0.9%
TN		U1	166	2.2%
TX		U1	318	4.3%
UT		U1	16	0.2%
VA		U1	161	2.2%
VT		U1	50	0.7%
WA		U1	89	1.2%
WI		U1	39	0.5%
WV		U1	48	0.6%
WY		U1	33	0.4%
			7394	100.0%

AL	U5	7	5.0%
AR	U5	13	9.2%
AZ	U5	1	0.7%
FL	U5	2	1.4%
GA	U5	12	8.5%
IL	U5	1	0.7%
KY	U5	1	0.7%
LA	U5	6	4.3%
MO	U5	4	2.8%
MS	U5	5	3.5%
NC	U5	15	10.6%
SC	U5	5	3.5%
TN	U5	5	3.5%
TX	U5	3	2.1%
VA	U5	60	42.6%
WV	U5	1	0.7%
	Total	141	100.0%

Foreign
	United Arab Emirates	U1	2	8.0%
	Canada	U1	2	8.0%
	Germany	U1	1	4.0%
	Ireland	U1	3	12.0%
	Panama	U1	18	72.0%
	Phillipines	U1	1	4.0%
		Total	25	100.0%

FY17-FY16-FY15Private U1 & U5

STA_PROV_CD	COUNTRY_CD	MONUMENT_TYPE_CD	COUNT(MONUMENT_TYPE_CD)	% of Total for FY17	STA_PROV_CD	COUNTRY_CD	MONUMENT_TYPE_CD	COUNT(MONUMENT_TYPE_CD)	% of Total for FY16	STA_PROV_CD	COUNTRY_CD	MONUMENT_TYPE_CD	COUNT(MONUMENT_TYPE_CD)	% of Total for FY15
AK		U1	15	0.20%	AK		U1	33	0.45%	AK		U1	27	0.36%
AL		U1	779	10.33%	AL		U1	776	10.49%	AL		U1	800	10.58%
AR		U1	170	2.26%	AR		U1	117	1.58%	AR		U1	89	1.18%
AS		U1	1	0.01%	AZ		U1	181	2.45%	AS		U1	3	0.04%
AZ		U1	155	2.06%	CA		U1	147	1.99%	AZ		U1	175	2.31%
CA		U1	151	2.00%	CO		U1	152	2.06%	CA		U1	217	2.87%
CO		U1	205	2.72%	CT		U1	667	9.02%	CO		U1	171	2.26%
CT		U1	702	9.31%	DC		U1	5	0.07%	CT		U1	698	9.23%
DC		U1	2	0.03%	DE		U1	2	0.03%	DC		U1	6	0.08%
DE		U1	1	0.01%	FL		U1	135	1.83%	DE		U1	3	0.04%
FL		U1	156	2.07%	GA		U1	280	3.79%	FL		U1	114	1.51%
GA		U1	261	3.46%	HI		U1	29	0.39%	GA		U1	284	3.76%
HI		U1	25	0.33%	IA		U1	49	0.66%	HI		U1	27	0.36%
IA		U1	43	0.57%	ID		U1	22	0.30%	IA		U1	65	0.86%
ID		U1	29	0.38%	IL		U1	148	2.00%	ID		U1	26	0.34%
IL		U1	152	2.02%	IN		U1	140	1.89%	IL		U1	213	2.82%
IN		U1	122	1.62%	KS		U1	66	0.89%	IN		U1	114	1.51%
KS		U1	55	0.73%	KY		U1	207	2.80%	KS		U1	97	1.28%
KY		U1	101	1.34%	LA		U1	106	1.43%	KY		U1	125	1.65%
LA		U1	82	1.09%	MA		U1	190	2.57%	LA		U1	87	1.15%
MA		U1	202	2.68%	MD		U1	40	0.54%	MA		U1	222	2.94%
MD		U1	53	0.70%	ME		U1	29	0.39%	MD		U1	51	0.67%
ME		U1	109	1.45%	MI		U1	109	1.47%	ME		U1	25	0.33%
MI		U1	110	1.46%	MN		U1	51	0.69%	MI		U1	118	1.56%
MN		U1	64	0.85%	MO		U1	67	0.91%	MN		U1	57	0.75%
MO		U1	83	1.10%	MS		U1	141	1.91%	MO		U1	73	0.97%
MS		U1	145	1.92%	MT		U1	182	2.46%	MS		U1	149	1.97%
MT		U1	160	2.12%	NC		U1	279	3.77%	MT		U1	181	2.39%
NC		U1	338	4.48%	ND		U1	12	0.16%	NC		U1	373	4.93%
ND		U1	15	0.20%	NE		U1	75	1.01%	ND		U1	9	0.12%
NE		U1	71	0.94%	NH		U1	6	0.08%	NE		U1	72	0.95%
NH		U1	6	0.08%	NJ		U1	47	0.64%	NH		U1	7	0.09%
NJ		U1	51	0.68%	NM		U1	156	2.11%	NJ		U1	40	0.53%
NM		U1	170	2.26%	NV		U1	5	0.07%	NM		U1	164	2.17%
NV		U1	8	0.11%	NY		U1	455	6.15%	NV		U1	7	0.09%
NY		U1	441	5.85%	OH		U1	158	2.14%	NY		U1	277	3.66%
OH		U1	140	1.86%	OK		U1	216	2.92%	OH		U1	109	1.44%
OK		U1	186	2.47%	OR		U1	31	0.42%	OK		U1	180	2.38%
OR		U1	28	0.37%	PA		U1	125	1.69%	OR		U1	41	0.54%
PA		U1	143	1.90%	PR		U1	6	0.08%	PA		U1	122	1.61%
PR		U1	7	0.09%	RI		U1	611	8.26%	PR		U1	2	0.03%
RI		U1	535	7.10%	SC		U1	151	2.04%	RI		U1	758	10.03%
SC		U1	186	2.47%	SD		U1	70	0.95%	SC		U1	166	2.20%
SD		U1	75	0.99%	TN		U1	166	2.25%	SD		U1	55	0.73%
TN		U1	176	2.33%	TX		U1	318	4.30%	TN		U1	135	1.79%
TX		U1	322	4.27%	UT		U1	16	0.22%	TX		U1	318	4.21%
UT		U1	28	0.37%	VA		U1	161	2.18%	UT		U1	16	0.21%
VA		U1	162	2.15%	VT		U1	50	0.68%	VA		U1	166	2.20%
VI		U1	1	0.01%	WA		U1	89	1.20%	VI		U1	1	0.01%
VT		U1	59	0.78%	WI		U1	39	0.53%	VT		U1	67	0.89%
WA		U1	93	1.23%	WV		U1	48	0.65%	WA		U1	141	1.86%
WI		U1	53	0.70%	WY		U1	33	0.45%	WI		U1	52	0.69%
WV		U1	76	1.01%				7394	100.00%	WV		U1	46	0.61%
WY		U1	35	0.46%						WY		U1	20	0.26%
		Total	7538	100.00%								Total	7561	100.00%

AL	U5	5	2.55%	AL	U5	7	4.96%	AL	U5	5	3.14%
AR	U5	8	4.08%	AR	U5	13	9.22%	AR	U5	36	22.64%
CO	U5	1	0.51%	AZ	U5	1	0.71%	CO	U5	3	1.89%
FL	U5	3	1.53%	FL	U5	2	1.42%	FL	U5	4	2.52%
GA	U5	33	16.84%	GA	U5	12	8.51%	GA	U5	16	10.06%
IL	U5	1	0.51%	IL	U5	1	0.71%	KY	U5	1	0.63%
IN	U5	1	0.51%	KY	U5	1	0.71%	LA	U5	5	3.14%
KS	U5	2	1.02%	LA	U5	6	4.26%	MD	U5	1	0.63%
KY	U5	4	2.04%	MO	U5	4	2.84%	MO	U5	3	1.89%
LA	U5	2	1.02%	MS	U5	5	3.55%	MS	U5	9	5.66%
MO	U5	6	3.06%	NC	U5	15	10.64%	NC	U5	20	12.58%
MS	U5	6	3.06%	SC	U5	5	3.55%	OR	U5	1	0.63%
NC	U5	18	9.18%	TN	U5	5	3.55%	SC	U5	4	2.52%
OK	U5	1	0.51%	TX	U5	3	2.13%	TN	U5	3	1.89%
PA	U5	1	0.51%	VA	U5	60	42.55%	TX	U5	3	1.89%
SC	U5	4	2.04%	WV	U5	1	0.71%	VA	U5	43	27.04%
TN	U5	5	2.55%		Total	141	100.00%	WV	U5	2	1.26%
TX	U5	5	2.55%						Total	159	100.00%
VA	U5	87	44.39%
WV	U5	3	1.53%
	Total	196	100.00%

Foreign					Foreign					Foreign
	United Arab Emirates	U1	2	8.70%		United Arab Emirates	U1	2	8.00%		Phillipines	U1	1	6.25%
	Canada	U1	2	8.70%		Canada	U1	2	8.00%		Canada	U1	3	18.75%
	Germany	U1	2	8.70%		Germany	U1	1	4.00%		Germany	U1	4	25.00%
	Ireland	U1	1	4.35%		Ireland	U1	3	12.00%		FM	U1	1	6.25%
	Saint Kits/Nevis	U1	1	4.35%		Panama	U1	18	72.00%		France	U1	1	6.25%
	Panama	U1	16	69.57%		Phillipines	U1	1	4.00%		Ireland	U1	1	6.25%
	Phillipines	U1	1	4.35%			Total	25	100.00%		Mexico	U1	1	6.25%
		Total	23	100.00%							Panama	U1	4	25.00%
												Total	16	100.00%

FY15 Private U1 & U5

STA_PROV_CD	COUNTRY_CD	MONUMENT_TYPE_CD	COUNT(MONUMENT_TYPE_CD)	% of Total for FY15
AK		U1	27	0.4%
AL		U1	800	10.6%
AR		U1	89	1.2%
AS		U1	3	0.0%
AZ		U1	175	2.3%
CA		U1	217	2.9%
CO		U1	171	2.3%
CT		U1	698	9.2%
DC		U1	6	0.1%
DE		U1	3	0.0%
FL		U1	114	1.5%
GA		U1	284	3.8%
HI		U1	27	0.4%
IA		U1	65	0.9%
ID		U1	26	0.3%
IL		U1	213	2.8%
IN		U1	114	1.5%
KS		U1	97	1.3%
KY		U1	125	1.7%
LA		U1	87	1.2%
MA		U1	222	2.9%
MD		U1	51	0.7%
ME		U1	25	0.3%
MI		U1	118	1.6%
MN		U1	57	0.8%
MO		U1	73	1.0%
MS		U1	149	2.0%
MT		U1	181	2.4%
NC		U1	373	4.9%
ND		U1	9	0.1%
NE		U1	72	1.0%
NH		U1	7	0.1%
NJ		U1	40	0.5%
NM		U1	164	2.2%
NV		U1	7	0.1%
NY		U1	277	3.7%
OH		U1	109	1.4%
OK		U1	180	2.4%
OR		U1	41	0.5%
PA		U1	122	1.6%
PR		U1	2	0.0%
RI		U1	758	10.0%
SC		U1	166	2.2%
SD		U1	55	0.7%
TN		U1	135	1.8%
TX		U1	318	4.2%
UT		U1	16	0.2%
VA		U1	166	2.2%
VI		U1	1	0.0%
VT		U1	67	0.9%
WA		U1	141	1.9%
WI		U1	52	0.7%
WV		U1	46	0.6%
WY		U1	20	0.3%
		Total	7561	100.0%

AL	U5	5	3.1%
AR	U5	36	22.6%
CO	U5	3	1.9%
FL	U5	4	2.5%
GA	U5	16	10.1%
KY	U5	1	0.6%
LA	U5	5	3.1%
MD	U5	1	0.6%
MO	U5	3	1.9%
MS	U5	9	5.7%
NC	U5	20	12.6%
OR	U5	1	0.6%
SC	U5	4	2.5%
TN	U5	3	1.9%
TX	U5	3	1.9%
VA	U5	43	27.0%
WV	U5	2	1.3%
	Total	159	100.0%

Foreign
	Phillipines	U1	1	6.3%
	Canada	U1	3	18.8%
	Germany	U1	4	25.0%
	FM	U1	1	6.3%
	France	U1	1	6.3%
	Ireland	U1	1	6.3%
	Mexico	U1	1	6.3%
	Panama	U1	4	25.0%
		Total	16	100.0%

SQL

select z.sta_prov_cd, p.country_cd, monument_type_cd, count (monument_type_cd) from monument_apl m, monapl_address ma, address a, zip_code z, postal_code p where m.origin_cd = 'D' and m.status_cd in ('MO','MS','AD') and trunc (assembly_dt) between to_date('10/01/2015','mm/dd/yyyy') and to_date('09/30/2016','mm/dd/yyyy') and monument_type_cd in ('U1','U5') and m.id = ma.monapl_id and ma.address_id = a.id and a.zip_five_cd = z.zip_five_cd (+) and a.postal_cd = p.cd (+) and ma.monapl_addr_type = 'F' group by z.sta_prov_cd, p.country_cd, monument_type_cd order by z.sta_prov_cd, p.country_cd, monument_type_cd

File details come from the government source that posted it.