l_nlrb_office

45 rows

✎ View and edit SQL

This data as json, CSV (advanced)

nlrb_office_id ▼ region branch division district office_name description supervising_office office_mgr_name office_type street_address_1 street_address_2 city state zip main_phone_num main_phone_ext main_fax_num e_mail_address system_time_out io_daily_hours trigger_flag standard_correspond_path standard_reports_path office_correspond_path office_reports_path office_forms_path path_legal_research path_forms path_summation path_crystal message_of_the_day date_in_service cats_version
01 Region 01, Boston, Massachusetts 01 Operations-Management OP Division of Operations-Management OP District I 01 Boston Region 01, Boston, Massachusetts 01 01-00025 Regional Office R Thomas P. O'Neill, Jr. Federal Building 10 Causeway Street, 6th Floor Boston MA 02222-1072 617-565-6700   617-565-6725 Region1@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-02-02T11:35:00 9
02 Region 02, New York, New York 02 Operations-Management OP Division of Operations-Management OP District I 01 New York Region 02, New York, New York 02 02-00045 Regional Office R 26 Federal Plaza, Room 3614   New York NY 10278-0104 212-264-0300   212-264-2450 Region2@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-03-16T12:48:00 9
03 Region 03, Buffalo, New York 03 Operations-Management OP Division of Operations-Management OP District I 01 Buffalo Region 03, Buffalo, New York 03 03-00017 Regional Office R Niagara Center 130 S. Elmwood Avenue, 6th Floor Buffalo NY 14202-2387 716-551-4931   716-551-4972 Region3@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-04-14T14:43:00 9
04 Region 04, Philadelphia, Pennsylvania 04 Operations-Management OP Division of Operations-Management OP District I 01 Philadelphia Region 04, Philadelphia, Pennsylvania 04 04-00004 Regional Office R 615 Chestnut Street, 7th Floor   Philadelphia PA 19106-4404 215-597-7601   215-597-7658 Region4@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-11-09T12:47:00 9
05 Region 05, Baltimore, Maryland 05 Operations-Management OP Division of Operations-Management OP District II 02 Baltimore Region 05, Baltimore, Maryland 05 05-00064 Regional Office R The Appraisers Store Building 103 S. Gay Street, 8th Floor Baltimore MD 21202-4061 410-962-2822   410-962-2198 Region5@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Region 05 Production 2000-01-21T15:29:00 9
06 Region 06, Pittsburgh, Pennsylvania 06 Operations-Management OP Division of Operations-Management OP District II 02 Pittsburgh Region 06, Pittsburgh, Pennsylvania 06 06-00043 Regional Office R Two Chatham Center, Suite 510 112 Washington Place Pittsburgh PA 15219-3458 412-395-4400   412-395-5986 Region6@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-11-09T18:12:00 9
07 Region 07, Detroit, Michigan 07 Operations-Management OP Division of Operations-Management OP District II 02 Detroit Region 07, Detroit, Michigan 07 07-00006 Regional Office R 477 Michigan Avenue, Room 300   Detroit MI 48226-2569 313-226-3200   313-226-2090 Region7@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-08-26T12:39:00 9
08 Region 08, Cleveland, Ohio 08 Operations-Management OP Division of Operations-Management OP District II 02 Cleveland Region 08, Cleveland, Ohio 08 08-00014 Regional Office R a hearing room of the NLRB 1695 AJC Federal Bldg., 1240 E. 9th St. Cleveland OH 44199-2086 216-522-3716   216-522-2418 Region8@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-04-13T16:13:00 9
09 Region 09, Cincinnati, Ohio 09 Operations-Management OP Division of Operations-Management OP District II 02 Cincinnati Region 09, Cincinnati, Ohio 09 09-00040 Regional Office R John Weld Peck Federal Building 550 Main Street, Room 3003 Cincinnati OH 45202-3271 513-684-3686   513-684-3946 Region9@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-01-25T15:47:00 9
10 Region 10, Atlanta, Georgia 10 Operations-Management OP Division of Operations-Management OP District II 02 Atlanta Region 10, Atlanta, Georgia 10 10-00017 Regional Office R 233 Peachtree Street N.E. Harris Tower, Suite 1000 Atlanta GA 30303-1531 404-331-2896   404-331-2858 Region10@nlrb.gov   17.0   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-02-03T08:03:00 9
11 Region 11, Winston-Salem, North Carolina 11 Operations-Management OP Division of Operations-Management OP District II 02 Winston-Salem Region 11, Winston-Salem, North Carolina 11 11-00048 Regional Office R Hearing Room, NLRB, Republic Square Suite 200, 4035 University Parkway Winston-Salem NC 27106-3323 336-631-5201   336-631-5210 Region11@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-03-20T13:12:00 9
12 Region 12, Tampa, Florida 12 Operations-Management OP Division of Operations-Management OP District II 02 Tampa Region 12, Tampa, Florida 12 12-00021 Regional Office R South Trust Plaza, Suite 530 201 East Kennedy Boulevard Tampa FL 33602-5824 813-228-2641   813-228-2874 Region12@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-04-26T16:20:00 9
13 Region 13, Chicago, Illinois 13 Operations-Management OP Division of Operations-Management OP District III 03 Chicago Region 13, Chicago, Illinois 13 13-00050 Regional Office R 209 South LaSalle Street, Suite 900   Chicago IL 60604-1443 312-353-7570   312-886-1341 Region13@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-04-09T16:43:00 9
14 Region 14, St. Louis, Missouri 14 Operations-Management OP Division of Operations-Management OP District III 03 St. Louis Region 14, St. Louis, Missouri 14 14-00045 Regional Office R 1222 Spruce Street, Room 8.302   St. Louis MO 63103-2829 314-539-7770   314-539-7794 Region14@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-02-10T12:29:00 9
15 Region 15, New Orleans, Louisiana 15 Operations-Management OP Division of Operations-Management OP District I 01 New Orleans Region 15, New Orleans, Louisiana 15 15-00006 Regional Office R NLRB Hearing Room "A," Sixth Floor, #649 1515 Poydras Street New Orleans LA 70112-3723 504-589-6361   504-589-4069 Region15@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-02-15T13:49:00 9
16 Region 16, Fort Worth, Texas 16 Operations-Management OP Division of Operations-Management OP District IV 04 Fort Worth Region 16, Fort Worth, Texas 16 16-00015 Regional Office R Federal Office Building, Room 8A24 819 Taylor Street Fort Worth TX 76102-6178 817-978-2921   817-978-2928 Region16@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-01-27T12:10:00 9
17 Region 17, Kansas City, Kansas 17 Operations-Management OP Division of Operations-Management OP District III 03 Kansas City Region 17, Kansas City, Kansas 17 17-00020 Regional Office R 8600 Farley Street, Suite 100   Overland Park KS 66212-4677 913-967-3000   913-967-3010 Region17@nlrb.gov 1 8.5 Y Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Eliminate the impossible, and whatever remains, no matter how improbable, must be the truth. -- Sherlock Holmes 1999-01-22T06:27:00 9
18 Region 18, Minneapolis, Minnesota 18 Operations-Management OP Division of Operations-Management OP District III 03 Minneapolis Region 18, Minneapolis, Minnesota 18 18-00022 Regional Office R NLRB Hearing Room, Suite 790 330 South Second Avenue Minneapolis MN 55401-2221 612-348-1757   612-348-1785 Region18@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-05-10T15:54:00 9
19 Region 19, Seattle, Washington 19 Operations-Management OP Division of Operations-Management OP District IV 04 Seattle Region 19, Seattle, Washington 19 19-00030 Regional Office R James C. Sand Hearing Room, 29th Floor Jackson Federal Building, 915 Second Ave Seattle WA 98174-1078 206-220-6300   206-220-6305 Region19@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-09-09T14:13:00 9
20 Region 20, San Francisco, California 20 Operations-Management OP Division of Operations-Management OP District IV 04 San Francisco Region 20, San Francisco, California 20 20-00020 Regional Office R 901 Market Street, Suite 400   San Francisco CA 94103-1735 415-356-5130   415-356-5156 Region20@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-06-04T15:41:00 9
21 Region 21, Los Angeles, California, 21 Operations-Management OP Division of Operations-Management OP District IV 04 Los Angeles Region 21, Los Angeles, California, 21 21-00074 Regional Office R Regional Office Hearing Room, Room 888 South Figueroa Street, Ninth Floor Los Angeles CA 90017-5449 213-894-5200   213-894-2778 Region21@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-06-29T17:08:00 9
22 Region 22, Newark, New Jersey 22 Operations-Management OP Division of Operations-Management OP District I 01 Newark Region 22, Newark, New Jersey 22 22-00005 Regional Office R Veterans Administration Building 20 Washington Place, 5th Floor Newark NJ 07102-3110 973-645-2100   973-645-3852 Region22@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-03-03T14:16:00 9
24 Region 24, Hato Rey, Puerto Rico 24 Operations-Management OP Division of Operations-Management OP District IV 04 Hato Rey Region 24, Hato Rey, Puerto Rico 24 24-00022 Regional Office R La Torre de Plaza, Suite 1002 525 F. D. Roosevelt Avenue San Juan PR 00918-1002 787-766-5347   787-766-5478 Region24@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-05-11T13:48:00 9
25 Region 25, Indianapolis, Indiana 25 Operations-Management OP Division of Operations-Management OP District III 03 Indianapolis Region 25, Indianapolis, Indiana 25 25-00042 Regional Office R Hearing Room, Minton-Capehart Fed. Bldg. NLRB, 575 North Pennsylvania St., #238 Indianapolis IN 46204-1577 317-226-7382   317-226-5103 Region25@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-01-24T16:17:00 9
26 Region 26, Memphis, Tennessee 26 Operations-Management OP Division of Operations-Management OP District III 03 Memphis Region 26, Memphis, Tennessee 26 26-00030 Regional Office R NLRB Hearing Room, Brinkley Plaza Bldg. 80 Monroe Avenue, Suite 350 Memphis TN 38103-2481 901-544-0018   901-544-0008 Region26@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-03-02T16:02:00 9
27 Region 27, Denver, Colorado 27 Operations-Management OP Division of Operations-Management OP District III 03 Denver Region 27, Denver, Colorado 27 27-00029 Regional Office R 600 17th Street 7th Floor, North Tower Denver CO 80202-5433 303-844-3551   303-844-6249 Region27@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-02-12T10:01:00 9
28 Region 28, Phoenix, Arizona 28 Operations-Management OP Division of Operations-Management OP District IV 04 Phoenix Region 28, Phoenix, Arizona 28 28-00012 Regional Office R 2600 North Central Avenue, Suite 1800   Phoenix AZ 85004-3099 602-640-2160   602-640-2178 Region28@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-08-03T14:28:00 9
29 Region 29, Brooklyn, New York 29 Operations-Management OP Division of Operations-Management OP District I 01 Brooklyn Region 29, Brooklyn, New York 29 29-00049 Regional Office R One MetroTech Center North Tenth Floor Brooklyn NY 11201-4201 718-330-7713   718-330-7579 Region29@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-03-09T14:09:00 9
30 Region 30, Milwaukee, Wisconsin 30 Operations-Management OP Division of Operations-Management OP District III 03 Milwaukee Region 30, Milwaukee, Wisconsin 30 30-00003 Regional Office R NLRB Hearing Room, Reuss Federal Plaza 310 West Wisconsin Avenue, Suite 700 Milwaukee WI 53203-2211 414-297-3861   414-297-3880 Region30@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-05-02T15:21:00 9
31 Region 31, Los Angeles, California 31 Operations-Management OP Division of Operations-Management OP District IV 04 Los Angeles Region 31, Los Angeles, California 31 31-00024 Regional Office R 11150 West Olympic Boulevard, Suite 700   Los Angeles CA 90064-1824 310-235-7351   310-235-7420 Region31@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-06-29T18:58:00 9
32 Region 32, Oakland, California 32 Operations-Management OP Division of Operations-Management OP District IV 04 Oakland Region 32, Oakland, California 32 32-00012 Regional Office R Oakland Regional Office of the Board 1301 Clay Street, Room 300N Oakland CA 94612-5211 510-637-3300   510-637-3315 Region32@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-06-04T13:34:00 9
33 Sub-Region 33, Peoria, Illinois 33 Operations-Management OP Division of Operations-Management OP District III 03 Peoria Sub-Region 33, Peoria, Illinois 14 33-00008 Regional Office R Thomas M. Harvey NLRB Hearing Room 300 Hamilton Boulevard, Suite 200 Peoria IL 61602-1246 309-671-7080   309-671-7095 Subregion33@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-04-05T11:48:00 9
34 Region 34, Hartford, Connecticut 34 Operations-Management OP Division of Operations-Management OP District I 01 Hartford Region 34, Hartford, Connecticut 34 34-00017 Regional Office R 280 Trumbull Street, 21st Floor   Hartford CT 06103-3503 860-240-3522   860-240-3564 Region34@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     2000-05-11T18:07:00 9
36 Sub-Region 36, Portland, Oregon 36 Operations-Management OP Division of Operations-Management OP District IV 04 Portland Sub-Region 36, Portland, Oregon 19 36-00009 Regional Office R Room 1910, ODS Tower 601 S.W. Second Avenue Portland OR 97204-3170 503-326-3085   503-326-5387 Subregion36@nlrb.gov   0.0   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-09-09T15:53:00 9
37 Sub-Region 37, Honolulu, Hawaii 37 Operations-Management OP Division of Operations-Management OP District IV 04 Honolulu Sub-Region 37, Honolulu, Hawaii 20 37-00008 Regional Office R 300 Ala Moana Boulevard Hearing Room 7-241 Honolulu HI 96850-4980 808-541-2814   808-541-2818 Subregion37@nlrb.gov   8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\     1999-12-01T13:53:00 9
AP Headquarters, Washington, DC HQ General Counsel GC Division of Enforcement Litigation LI General Counsel GC Office of Appeals Office of Appeals LI Y. Dixon Headquarters Office H 1099 14th Street, NW Suite 8828 Washington DC 20570-0001 202-273-3760         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ J:\CATS\Catsocor\Appeals\ J:\CATS\Catsocor\Appeals\ J:\CATS\Catsocor\Appeals\ Y:\ZYIMAGE\   J:\SUMNET\   Office of Appeals   9
AV Headquarters, Washington, DC HQ General Counsel GC Division of Advice AV General Counsel GC Division of Advice Division of Advice AV B.Kearne Headquarters Office H 1099 14th Street, NW Suite 1040 Washington DC 20570-0001 (202)273-3800       0 8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZYIMAGE\   J:\SUMNET\   Division of Advice 2002-08-16T11:59:00 9
BD Headquarters, Washington, DC HQ Board BD Office of Board, Board Members BD Board BD Office of the Board HQ Board Office, Board BD Truesdal Headquarters Office H 1099 14th Street, NW Suite 11100 Washington DC 20570-0001 202-273-1790         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ G:\bdsup\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Office of the Board   9
ES Headquarters, Washington, DC HQ Board BD Office of Board, Board Members BD Board BD Office of the Executive Secretary HQ Board Office, Executive Secretary BD Toner Headquarters Office H 1099 14th Street, NW Suite 11600 Washington DC 20570-0001 202-273-1940         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Office of the Executive Secretary   9
GC Headquarters, Washington, DC HQ General Counsel GC Division of Administration AM General Counsel GC Division of Operations-Management Division of Operations-Management GC     1099 14th Street, NW Suite 10200 Washington DC 20570-0001 202-273-2900         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS_UAT\UAT_VENUS_TEST_RESULTS\Test Plans\Colleen's Test Plans\ Y:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZYIMAGE\   J:\SUMNET\   Division of Operations-Management   9
HQ Headquarters, Washington, DC HQ Headquarters, General HQ Division of Operations-Management OP Headquarter, General HQ Headquarters, General Headquarters, General HQ   Headquarters Office H 1099 14th Street, NW Suite 7300 Washington DC 22202 202-273-1975         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\       9
IT Headquarters, Washington, DC HQ Office of the CIO IT Division of Administration AM General Counsel GC Office of the CIO Office of the CIO IT Adams   1099 14th Street Suite 7300 Washington DC 22202 202-273-4030         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ Y:\CATS\Catstcor\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Information Technology Branch   9
LS Headquarters, Washington, DC HQ General Counsel GC Division of Administration AM General Counsel GC Library & Administrative Services Branch Library & Administrative Services Branch GC V. Reyno Headquarters Office H 1099 14th Street, NW Suite 7618 Washington DC 20570-0001 (202)273-3920   (202)273-4266     8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZYIMAGE\   J:\SUMNET\   Library and Administrative Services Branch 2003-03-03T00:00:00 9
RA Headquarters, Washington, DC HQ Board BD Office of Board, Board Members BD Board BD Office of Representation Appeals HQ Board Office, Office of Representatio BD Gold Headquarters Office H 1099 14th Street, NW Suite 11700 Washington DC 20570-0001 202-273-1980         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Office of Representation Appeals   9
SO Headquarters, Washington, DC HQ Board BD Office of Board, Board Members BD Board BD Office of the Solicitor HQ Board Office, Solicitor BD Higgins Headquarters Office H 1099 14th Street, NW Suite 11800 Washington DC 20570-0001 202-273-2910         8.5   Y:\CATS\CATSTCOR\ Y:\CATS\CATSTREP\ H:\CATS\CATSOCOR\ H:\CATS\CATSOREP\ Y:\CATS\CATSTREP\ Y:\ZyImage\   Y:\SumNet\   Office of the Solicitor   9

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_nlrb_office" (
[nlrb_office_id] text PRIMARY KEY,
[region] text,
[branch] text,
[division] text,
[district] text,
[office_name] text,
[description] text,
[supervising_office] text,
[office_mgr_name] text,
[office_type] text,
[street_address_1] text,
[street_address_2] text,
[city] text,
[state] text REFERENCES[l_state] ([state]),
[zip] text,
[main_phone_num] text,
[main_phone_ext] integer,
[main_fax_num] text,
[e_mail_address] text,
[system_time_out] integer,
[io_daily_hours] float,
[trigger_flag] text,
[standard_correspond_path] text,
[standard_reports_path] text,
[office_correspond_path] text,
[office_reports_path] text,
[office_forms_path] text,
[path_legal_research] text,
[path_forms] integer,
[path_summation] text,
[path_crystal] integer,
[message_of_the_day] text,
[date_in_service] text,
[cats_version] integer,
    FOREIGN KEY ([region]) REFERENCES[l_nlrb_region] ([region]),
    FOREIGN KEY ([branch]) REFERENCES[l_nlrb_branch] ([branch]),
    FOREIGN KEY ([division]) REFERENCES[l_nlrb_division] ([division]),
    FOREIGN KEY ([district]) REFERENCES[l_nlrb_district] ([district]),
    FOREIGN KEY ([office_type]) REFERENCES[l_nlrb_office_type] ([office_type])
);