Check In Qld app - Customer Check Ins by statistical area per day
Check In Qld app - Customer Check-ins by location per day represents the total persons checked-in, aggregated to per day and Statistical Area Level 3 (SA3).
The commencement date for this data is 28 February 2021.
Notes:
- The 'SA3_Name' column contains values that are “Not Mapped.” A value of “Not Mapped” occurs when a business or organisation has a registered address that does not validate and match an SA3 area. This can be due to addressing issues or organisations without a static address.
- To protect the privacy of individuals, in the ‘TOTAL_PEOPLE_CHECKEDIN’ column, any value less than six (6) is replaced with a NULL (blank) value.
- The number of check-in’s for recent dates may increase as offline check in data is reported.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| CHECKIN_DATE | timestamp | Check-in date | The date, in yyyy-dd-mm format, that a user has checked-in using the Check In Qld app. |
| SA3_NAME | text | SA3 Name | The name of the Statistical Area Level 3 location where the check-in occurred. |
| TOTAL_PEOPLE_CHECKEDIN | numeric | Total People Checked-in | The sum of people that have checked-in. |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 1 July 2022 |
| Metadata last updated | 1 July 2022 |
| Created | 29 April 2022 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 |
| Archiver | {'resource_timestamp': '2022-04-28T23:55:04.478497', 'status_id': 0, 'is_broken': False, 'reason': '', 'url_redirected_to': 'https://www.data.qld.gov.au/dataset/862e28be-7315-45ac-946e-8eee68c45dcb/resource/f330c054-19c9-41c3-947a-f6c66a62d12f/download/ciq_opendata_checkins_sa3_date.csv', 'cache_filepath': 'resources/f330c054-19c9-41c3-947a-f6c66a62d12f/ciq_opendata_checkins_sa3_date.csv', 'cache_url': 'https://www.data.qld.gov.au/dataset/862e28be-7315-45ac-946e-8eee68c45dcb/resource/f330c054-19c9-41c3-947a-f6c66a62d12f/download/ciq_opendata_checkins_sa3_date.csv', 'size': 1096857, 'mimetype': 'text/csv', 'hash': '"273d027cd2ecdcde3630d31136ee3f51"', 'etag': None, 'last_modified': None, 'first_failure': None, 'last_success': '2022-04-28T23:55:05.418062', 'failure_count': 0, 'created': '2022-04-28T23:55:05.429526', 'updated': '2022-04-28T23:55:05.418062', 'status': 'Archived successfully', 'is_broken_printable': 'Downloaded OK'} |
| Ckan url | https://www.data.qld.gov.au |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | True |
| Hash | 9571ee5e9053414ff7c7c96285ef0a68 |
| Id | f330c054-19c9-41c3-947a-f6c66a62d12f |
| Ignore hash | False |
| Mimetype | text/csv |
| Original url | https://www.data.qld.gov.au/dataset/862e28be-7315-45ac-946e-8eee68c45dcb/resource/f330c054-19c9-41c3-947a-f6c66a62d12f/download/ciq_opendata_checkins_sa3_date-20220701.csv |
| Package id | 862e28be-7315-45ac-946e-8eee68c45dcb |
| Position | 0 |
| Qa | {'resource_timestamp': None, 'archival_timestamp': '2022-04-28T23:55:05.418062', 'openness_score': 3, 'openness_score_reason': 'A system error occurred during downloading this file. [Errno 404] Received a bad HTTP response when trying to download the data file: u\'https://www.data.qld.gov.au/dataset/862e28be-7315-45ac-946e-8eee68c45dcb/resource/f330c054-19c9-41c3-947a-f6c66a62d12f/download/ciq_opendata_checkins_sa3_date.csv\' URL extension "csv" relates to format "CSV" and receives score: 3.', 'format': 'CSV', 'created': '2022-04-28T23:55:07.135436', 'updated': '2022-04-28T23:55:07.125557'} |
| Resource id | f330c054-19c9-41c3-947a-f6c66a62d12f |
| Set url type | False |
| Size | 1.2 MiB |
| State | active |
| Task created | 2022-07-01 05:24:38.246056 |
| Url type | upload |
| Validation status | success |
| Validation timestamp | 2 years ago |
| Size | 1.2 MiB |
| Aligned with default data schema |
Data usability rating
:
Contains open format machine-readable open data.
Link is ok
Link checked: 29 April 2022
Link checked: 29 April 2022