Results for directory.Facility_byRegionIDandType_Summary_query - struct |
CRITERIA |
Reg_ID = 1,2 & Fac_Type_ID = 13
|
MATCHES |
43
|
ORDER |
reg_id, d_order, fac_name
|
RESULTS |
Results for directory.Facility_byRegionIDandType_Summary_query - query |
|
FAC_ID |
FAC_NAME |
FAC_TYPE_ID |
REG_ID |
STATE |
1 |
5433
|
Bangor Vet Center
|
13
|
1
|
ME
|
2 |
5646
|
Berlin Vet Center
|
13
|
1
|
NH
|
3 |
626
|
Boston Vet Center
|
13
|
1
|
MA
|
4 |
627
|
Brockton Vet Center
|
13
|
1
|
MA
|
5 |
5618
|
Cape Cod Vet Center
|
13
|
1
|
MA
|
6 |
5979
|
Danbury Vet Center
|
13
|
1
|
CT
|
7 |
653
|
Hartford Vet Center
|
13
|
1
|
CT
|
8 |
6245
|
Keene Vet Center Outstation
|
13
|
1
|
NH
|
9 |
5435
|
Lewiston Vet Center
|
13
|
1
|
ME
|
10 |
5436
|
Lowell Vet Center
|
13
|
1
|
MA
|
11 |
422
|
Manchester Vet Center
|
13
|
1
|
NH
|
12 |
5437
|
New Bedford Vet Center
|
13
|
1
|
MA
|
13 |
654
|
New Haven Vet Center
|
13
|
1
|
CT
|
14 |
6571
|
Newington Vet Center Outstation
|
13
|
1
|
NH
|
15 |
5434
|
Northern Maine Vet Center
|
13
|
1
|
ME
|
16 |
655
|
Norwich Vet Center
|
13
|
1
|
CT
|
17 |
5438
|
Portland, ME Vet Center
|
13
|
1
|
ME
|
18 |
484
|
Providence Vet Center
|
13
|
1
|
RI
|
19 |
5439
|
Sanford Vet Center
|
13
|
1
|
ME
|
20 |
477
|
South Burlington Vet Center
|
13
|
1
|
VT
|
21 |
633
|
Springfield, MA Vet Center
|
13
|
1
|
MA
|
22 |
478
|
White River Junction Vet Center
|
13
|
1
|
VT
|
23 |
635
|
Worcester Vet Center
|
13
|
1
|
MA
|
24 |
456
|
Albany Vet Center
|
13
|
2
|
NY
|
25 |
740
|
Babylon Vet Center
|
13
|
2
|
NY
|
26 |
5675
|
Binghamton Vet Center
|
13
|
2
|
NY
|
27 |
943
|
Bloomfield Vet Center
|
13
|
2
|
NJ
|
28 |
741
|
Bronx Vet Center
|
13
|
2
|
NY
|
29 |
742
|
Brooklyn Vet Center
|
13
|
2
|
NY
|
30 |
460
|
Buffalo Vet Center
|
13
|
2
|
NY
|
31 |
5487
|
Harlem Vet Center
|
13
|
2
|
NY
|
32 |
5935
|
Lakewood Vet Center
|
13
|
2
|
NJ
|
33 |
744
|
Manhattan, NY Vet Center
|
13
|
2
|
NY
|
34 |
5654
|
Middletown Vet Center
|
13
|
2
|
NY
|
35 |
5960
|
Nassau Vet Center
|
13
|
2
|
NY
|
36 |
747
|
Queens Vet Center
|
13
|
2
|
NY
|
37 |
465
|
Rochester Vet Center
|
13
|
2
|
NY
|
38 |
5304
|
Secaucus Vet Center
|
13
|
2
|
NJ
|
39 |
5440
|
Staten Island Vet Center
|
13
|
2
|
NY
|
40 |
468
|
Syracuse Vet Center
|
13
|
2
|
NY
|
41 |
5094
|
Trenton Vet Center
|
13
|
2
|
NJ
|
42 |
5619
|
Watertown Vet Center
|
13
|
2
|
NY
|
43 |
5303
|
Westchester Vet Center
|
13
|
2
|
NY
|
|
STATUS |
0
|
|