[Superseded] Intellectual Property Government Open Data 2019

# What is IPGOD?\r\nThe Intellectual Property Government Open Data (IPGOD) includes over 100 years of registry data on all intellectual property (IP) rights administered by IP Australia. It also has derived information about the applicants who filed these IP rights, to allow for research and analysis at the regional, business and individual level. This is the 2019 release of IPGOD.\r\n\r\n\r\n# How do I use IPGOD?\r\nIPGOD is large, with millions of data points across up to 40 tables, making them too large to open with Microsoft Excel. Furthermore, analysis often requires information from separate tables which would need specialised software for merging. We recommend that advanced users interact with the IPGOD data using the right tools with enough memory and compute power. This includes a wide range of programming and statistical software such as Tableau, Power BI, Stata, SAS, R, Python, and Scalar.\r\n\r\n\r\n# IP Data Platform\r\nIP Australia is also providing free trials to a cloud-based analytics platform with the capabilities to enable working with large intellectual property datasets, such as the IPGOD, through the web browser, without any installation of software. [IP Data Platform](https://www.ipdataplatform.com)\r\n\r\n# References\r\n\r\nThe following pages can help you gain the understanding of the intellectual property administration and processes in Australia to help your analysis on the dataset.\r\n\r\n* [Patents](https://www.ipaustralia.gov.au/patents/)\r\n* [Trade Marks](https://www.ipaustralia.gov.au/trade-marks/)\r\n* [Designs](https://www.ipaustralia.gov.au/designs/)\r\n* [Plant Breeder’s Rights](https://www.ipaustralia.gov.au/plant-breeders-rights/)\r\n\r\n\r\n# Updates\r\n\r\n### Tables and columns\r\n\r\nDue to the changes in our systems, some tables have been affected.\r\n\r\n* We have added IPGOD 225 and IPGOD 325 to the dataset!\r\n* The IPGOD 206 table is not available this year.\r\n* Many tables have been re-built, and as a result may have different columns or different possible values. Please check the data dictionary for each table before use.\r\n\r\n### Data quality improvements\r\n\r\nData quality has been improved across all tables.\r\n\r\n* Null values are simply empty rather than '31/12/9999'.\r\n* All date columns are now in ISO format 'yyyy-mm-dd'.\r\n* All indicator columns have been converted to Boolean data type (True/False) rather than Yes/No, Y/N, or 1/0.\r\n* All tables are encoded in UTF-8.\r\n* All tables use the backslash \\ as the escape character.\r\n* The applicant name cleaning and matching algorithms have been updated. We believe that this year's method improves the accuracy of the matches. Please note that the "ipa_id" generated in IPGOD 2019 will not match with those in previous releases of IPGOD.