Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Patent Assignment Data Restructure
(view source)
Revision as of 14:33, 20 April 2017
2 bytes added
,
14:33, 20 April 2017
→Identify Clean Data
SELECT DISTINCT state FROM ptoassigneend_us_temp;
The output shows that all the records not null or
!=
not
space are valid state names.
*city that is a city
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