l_nlrb_region

45 rows

✎ View and edit SQL

This data as json, CSV (advanced)

region ▼ description force_xfer_log
01 Region 01, Boston, Massachusetts I
02 Region 02, New York, New York I
03 Region 03, Buffalo, New York I
04 Region 04, Philadelphia, Pennsylvania I
05 Region 05, Baltimore, Maryland I
06 Region 06, Pittsburgh, Pennsylvania I
07 Region 07, Detroit, Michigan I
08 Region 08, Cleveland, Ohio I
09 Region 09, Cincinnati, Ohio I
10 Region 10, Atlanta, Georgia I
11 Region 11, Winston-Salem, North Carolina I
12 Region 12, Tampa, Florida I
13 Region 13, Chicago, Illinois I
14 Region 14, St. Louis, Missouri I
15 Region 15, New Orleans, Louisiana I
16 Region 16, Fort Worth, Texas I
17 Region 17, Kansas City, Kansas I
18 Region 18, Minneapolis, Minnesota I
19 Region 19, Seattle, Washington I
20 Region 20, San Francisco, California I
21 Region 21, Los Angeles, California, I
22 Region 22, Newark, New Jersey I
24 Region 24, Hato Rey, Puerto Rico I
25 Region 25, Indianapolis, Indiana I
26 Region 26, Memphis, Tennessee I
27 Region 27, Denver, Colorado I
28 Region 28, Phoenix, Arizona I
29 Region 29, Brooklyn, New York I
30 Region 30, Milwaukee, Wisconsin I
31 Region 31, Los Angeles, California I
32 Region 32, Oakland, California I
33 Sub-Region 33, Peoria, Illinois I
34 Region 34, Hartford, Connecticut I
36 Sub-Region 36, Portland, Oregon I
37 Sub-Region 37, Honolulu, Hawaii I
AP Office of Appeals I
AV Division of Advice I
BD Office of the Board, Board Members I
ES Office of Executive Secretary I
GC Office of General Counsel I
HQ Headquarters, Washington, DC I
IT Office of the CIO I
LS Library & Administrative Services Branch I
RA Office of Representation Appeals I
SO Office of the Solicitor I

Advanced export

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

CSV options: 

CREATE TABLE "l_nlrb_region" (
[region] text PRIMARY KEY,
[description] text,
[force_xfer_log] text
);