Difference between revisions of "MSA List Table"
Jump to navigation
Jump to search
(Created page with "Return to Patent Data Specifications. Table "public.msalist" Column | Type | Modifiers --------------+-----------------------...") |
|||
| Line 3: | Line 3: | ||
Table "public.msalist" | Table "public.msalist" | ||
Column | Type | Modifiers | Column | Type | Modifiers | ||
| − | + | -------------+------------------------+----------- | |
msa | character varying(500) | | msa | character varying(500) | | ||
msacode | integer | | msacode | integer | | ||
Revision as of 12:42, 13 July 2016
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
