What is IPGOD?

The 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.

How do I use IPGOD?

IPGOD 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.

IP Data Platform

IP 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

References

The following pages can help you gain the understanding of the intellectual property administration and processes in Australia to help your analysis on the dataset.

• Patents
• Trade Marks
• Designs
• Plant Breeder’s Rights

Updates

Tables and columns

Due to the changes in our systems, some tables have been affected.

• We have added IPGOD 225 and IPGOD 325 to the dataset!
• The IPGOD 206 table is not available this year.
• 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.

Data quality improvements

Data quality has been improved across all tables.

• Null values are simply empty rather than '31/12/9999'.
• All date columns are now in ISO format 'yyyy-mm-dd'.
• All indicator columns have been converted to Boolean data type (True/False) rather than Yes/No, Y/N, or 1/0.
• All tables are encoded in UTF-8.
• All tables use the backslash \ as the escape character.
• 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.

Data mashup with Microsoft Excel using Power Query and M : finding, transforming, and loading data from external sources is a book. It was written by Adam Aspin and published by Apress in 2020.

Warning: Large file size (over 1GB). Each monthly data set is large (over 4 million rows), but can be viewed in standard software such as Microsoft WordPad (save by right-clicking on the file name and selecting 'Save Target As', or equivalent on Mac OSX). It is then possible to select the required rows of data and copy and paste the information into another software application, such as a spreadsheet. Alternatively, add-ons to existing software, such as the Microsoft PowerPivot add-on for Excel, to handle larger data sets, can be used. The Microsoft PowerPivot add-on for Excel is available from Microsoft http://office.microsoft.com/en-gb/excel/download-power-pivot-HA101959985.aspx Once PowerPivot has been installed, to load the large files, please follow the instructions below. Note that it may take at least 20 to 30 minutes to load one monthly file. 1. Start Excel as normal 2. Click on the PowerPivot tab 3. Click on the PowerPivot Window icon (top left) 4. In the PowerPivot Window, click on the "From Other Sources" icon 5. In the Table Import Wizard e.g. scroll to the bottom and select Text File 6. Browse to the file you want to open and choose the file extension you require e.g. CSV Once the data has been imported you can view it in a spreadsheet. What does the data cover? General practice prescribing data is a list of all medicines, dressings and appliances that are prescribed and dispensed each month. A record will only be produced when this has occurred and there is no record for a zero total. For each practice in England, the following information is presented at presentation level for each medicine, dressing and appliance, (by presentation name): - the total number of items prescribed and dispensed - the total net ingredient cost - the total actual cost - the total quantity The data covers NHS prescriptions written in England and dispensed in the community in the UK. Prescriptions written in England but dispensed outside England are included. The data includes prescriptions written by GPs and other non-medical prescribers (such as nurses and pharmacists) who are attached to GP practices. GP practices are identified only by their national code, so an additional data file - linked to the first by the practice code - provides further detail in relation to the practice. Presentations are identified only by their BNF code, so an additional data file - linked to the first by the BNF code - provides the chemical name for that presentation.

This dataset is about book subjects and is filtered where the books is Beginning big data with Power BI and Excel 2013 : big data processing and analysis using Power BI in Excel 2013, featuring 10 columns including authors, average publication date, book publishers, book subject, and books. The preview is ordered by number of books (descending).

Data Analytics Interview questions and answers. Topic Covered: Data analytics (Basics) Microsoft Excel MySQL Tableau Power BI

The Department of the Prime Minister and Cabinet is no longer maintaining this dataset. If you would like to take ownership of this dataset for ongoing maintenance please contact us.

PLEASE READ BEFORE USING

The data format has been updated to align with a tidy data style (http://vita.had.co.nz/papers/tidy-data.html).

The data in this dataset is manually collected and combined in a csv format from the following state and territory portals:

• https://www.cmtedd.act.gov.au/communication/holidays
• https://www.nsw.gov.au/about-nsw/public-holidays
• https://nt.gov.au/nt-public-holidays
• https://www.qld.gov.au/recreation/travel/holidays/public
• https://www.safework.sa.gov.au/resources/public-holidays
• https://worksafe.tas.gov.au/topics/laws-and-compliance/public-holidays
• https://business.vic.gov.au/business-information/public-holidays
• https://www.commerce.wa.gov.au/labour-relations/public-holidays-western-australia

The data API by default returns only the first 100 records. The JSON response will contain a key that shows the link for the next page of records. Alternatively you can view all records by updating the limit on the endpoint or using a query to select all records, i.e. /api/3/action/datastore_search_sql?sql=SELECT * from "{{resource_id}}".

This report presents data about GPs, Nurses, Direct Patient Care and Admin/Non-Clinical staff working in General Practice in England, along with information on their patients and practices. This series of statistics was previously produced quarterly but will now be produced monthly from the publication of September 2020’s data onwards. We will aim to publish these new monthly publications as close to the end of the month following extraction as possible, and a clearer timetable will be produced as the production stabilises. We have been reviewing and rationalising the contents of this series and in our two most recent publications in May and August we published our proposals for the initial changes which have now come into effect. Monthly publications will include as standard the Bulletin tables Excel file and the Individual-level and Practice-level CSV files. We will also aim to update the interactive Power BI dashboard. Twice a year, for March and September data, we will produce additional regional and experimental tables in Excel, and a CSV of Practice Information including contract type. The first of these biannual publications will be of September 2020 data and will be released 26 November 2020. Information on the next phase of changes will be detailed in future publications. We welcome feedback from all our users on these proposals, by email to: PrimaryCareWorkforce@nhs.net. Information about the contents of this publication and how it can and cannot be used, can be found in the Report tab. Our publication includes information on recent and planned changes as well as highlighting future developments. We are continually working to improve our publication to ensure the components are as useful and relevant as possible for our users. In the General Practice Workforce 30 September 2019 publication, released 28 November 2019, we produced a revised General Practice Workforce time series incorporating improvements in the estimation methodology and in the collection of GP registrar and GP locum data. The revised time series figures are not comparable with earlier figures published prior to 28 November 2019 and therefore all the figures released in the General Practice Workforce 30 September 2019 publication and later publications supersede the earlier releases, all of which we have archived and we advise you not to use them. Various data breakdowns are available in the accompanying Excel and CSV files, including time series and breakdowns by characteristics such as age and gender. Data is also presented regionally and at practice level for September 2020 in the accompanying CSVs. This publication also features an interactive Power BI dashboard which allows users to explore the underlying data in a variety of ways. This can be accessed by clicking on the dashboard link below. Links to other publications presenting healthcare workforce information can be found under Related Links.

ISO 3166-1-alpha-2 English country names and code elements. This list states the country names (official short names in English) in alphabetical order as given in ISO 3166-1 and the corresponding ISO 3166-1-alpha-2 code elements.