Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Patent Assignment Data Restructure
(view source)
Revision as of 17:31, 10 April 2017
65 bytes added
,
17:31, 10 April 2017
→5. Output (Tables)
city_city is the city name extracted from 'city'; city_addr1 is the city name extracted from 'addrline1'; city_addr2 is the city name extracted from 'addrline2'.
SQL code is in:
E:/McNair/Projects/PatentAddress/Functions.sql
====Master Table====
SONIAZHANG
Bureaucrats
,
Administrators
353
edits
Navigation menu
Personal tools
Log in
Request account
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Sites
Wiki
Articles
Sections
Projects
Papers in Development
Paper Reviews
Team Members
Legislation
Research Computing
Organizations
Incubator Project
McNair Center
Berkeley's BPP Group
NBER Patent Data
Help
General help
Team help
Administration
Batch Upload Files
Tools
Special pages
Printable version