MSA List Table

From edegan.com
Revision as of 12:42, 13 July 2016 by MarcelaInteriano (talk | contribs) (Created page with "Return to Patent Data Specifications. Table "public.msalist" Column | Type | Modifiers --------------+-----------------------...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Return to Patent Data Specifications.

               Table "public.msalist"
   Column    |          Type          | Modifiers 

+------------------------+-----------

msa          | character varying(500) | 
msacode      | integer                | 
supermsa     | character varying(500) | 
supermsacode | integer                | 
msaderived   | character varying      | 
                msa                 | msacode |               supermsa               | supermsacode | msaderived  
------------------------------------+---------+--------------------------------------+--------------+-------------
Allentown-Bethlehem-Easton PA       |     240 | New York- Newark                     |            1 | PA
Bridgeport CT                       |    1160 | New York- Newark                     |            1 | CT
Jersey City NJ                      |    3640 | New York- Newark                     |            1 | NJ
New Haven-Meriden CT                |    5480 | New York- Newark                     |            1 | CT
New York NY                         |    5600 | New York- Newark                     |            1 | NY
Newark NJ                           |    5640 | New York- Newark                     |            1 | NJ
Stamford-Norwalk CT                 |    8040 | New York- Newark                     |            1 | CT
Trenton NJ                          |    8480 | New York- Newark                     |            1 | NJ
Los Angeles-Long Beach CA           |    4480 | Los Angeles-Long Beach               |            2 | CA
Riverside-San Bernardino CA         |    6780 | Los Angeles-Long Beach               |            2 | CA
Ventura CA                          |    8735 | Los Angeles-Long Beach               |            2 | CA
Chicago IL                          |    1600 | Chicago-Naperville                   |            3 | IL
Kankakee IL                         |    3740 | Chicago-Naperville                   |            3 | IL