{"action":"created","issue":{"url":"https://api.github.com/repos/frictionlessdata/specs/issues/105","repository_url":"https://api.github.com/repos/frictionlessdata/specs","labels_url":"https://api.github.com/repos/frictionlessdata/specs/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/frictionlessdata/specs/issues/105/comments","events_url":"https://api.github.com/repos/frictionlessdata/specs/issues/105/events","html_url":"https://github.com/frictionlessdata/specs/issues/105","id":28116042,"number":105,"title":"Calendar Units / Date Types (e.g. Year, Month)","user":{"login":"Stiivi","id":71105,"avatar_url":"https://avatars.githubusercontent.com/u/71105?v=3","gravatar_id":"","url":"https://api.github.com/users/Stiivi","html_url":"https://github.com/Stiivi","followers_url":"https://api.github.com/users/Stiivi/followers","following_url":"https://api.github.com/users/Stiivi/following{/other_user}","gists_url":"https://api.github.com/users/Stiivi/gists{/gist_id}","starred_url":"https://api.github.com/users/Stiivi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Stiivi/subscriptions","organizations_url":"https://api.github.com/users/Stiivi/orgs","repos_url":"https://api.github.com/users/Stiivi/repos","events_url":"https://api.github.com/users/Stiivi/events{/privacy}","received_events_url":"https://api.github.com/users/Stiivi/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/frictionlessdata/specs/labels/spec-json-table-schema","name":"spec-json-table-schema","color":"d7e102"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/frictionlessdata/specs/milestones/1","html_url":"https://github.com/frictionlessdata/specs/milestones/Current","labels_url":"https://api.github.com/repos/frictionlessdata/specs/milestones/1/labels","id":1814953,"number":1,"title":"Current","description":"","creator":{"login":"pwalsh","id":791678,"avatar_url":"https://avatars.githubusercontent.com/u/791678?v=3","gravatar_id":"","url":"https://api.github.com/users/pwalsh","html_url":"https://github.com/pwalsh","followers_url":"https://api.github.com/users/pwalsh/followers","following_url":"https://api.github.com/users/pwalsh/following{/other_user}","gists_url":"https://api.github.com/users/pwalsh/gists{/gist_id}","starred_url":"https://api.github.com/users/pwalsh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pwalsh/subscriptions","organizations_url":"https://api.github.com/users/pwalsh/orgs","repos_url":"https://api.github.com/users/pwalsh/repos","events_url":"https://api.github.com/users/pwalsh/events{/privacy}","received_events_url":"https://api.github.com/users/pwalsh/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":0,"state":"open","created_at":"2016-06-08T06:04:57Z","updated_at":"2016-09-27T15:56:55Z","due_on":null,"closed_at":null},"comments":7,"created_at":"2014-02-23T10:21:17Z","updated_at":"2016-09-27T17:23:37Z","closed_at":null,"body":"\r\nThis issue is now about adding the following two types (or formats of the `date` type) to JTS:\r\n\r\n- gYear: YYYY\r\n- gYearMonth: YYYY-MM\r\n\r\n## Original Description from @Stiivi 2014-02-23\r\n\r\nBased on discussion in the [Calendar fields (date/time)](https://lists.okfn.org/pipermail/okfn-labs/2014-February/001313.html) and the [suggestion](https://lists.okfn.org/pipermail/okfn-labs/2014-February/001318.html) by @rgrp, the standard should contain a recommendation (not yet strict specification) for some calendar units:\r\n\r\n* `iso-year` – the field SHOULD be an integer and represents a calendar year as in the ISO date format\r\n* `iso-year-month` – the field SHOULD be a string in ISO date format \"YYYY-MM\" representing a month in a year with unspecified day\r\n* `iso-weekday` – the field SHOULD be an integer or a string convertible to integer that represents ISO week day number (0 = monday)\r\n\r\nThe units should be added to the [unit list](http://dataprotocols.org/units/).\r\n\r\nUnresolved questions:\r\n\r\n* Should the [ISO week date](http://en.wikipedia.org/wiki/ISO_week_date) belong to the `unit` metadata or some other metadata?\r\n* What about compact date format YYYYMMYY as common key in the date dimension in data warehouses?"},"comment":{"url":"https://api.github.com/repos/frictionlessdata/specs/issues/comments/249935285","html_url":"https://github.com/frictionlessdata/specs/issues/105#issuecomment-249935285","issue_url":"https://api.github.com/repos/frictionlessdata/specs/issues/105","id":249935285,"user":{"login":"jpmckinney","id":26463,"avatar_url":"https://avatars.githubusercontent.com/u/26463?v=3","gravatar_id":"","url":"https://api.github.com/users/jpmckinney","html_url":"https://github.com/jpmckinney","followers_url":"https://api.github.com/users/jpmckinney/followers","following_url":"https://api.github.com/users/jpmckinney/following{/other_user}","gists_url":"https://api.github.com/users/jpmckinney/gists{/gist_id}","starred_url":"https://api.github.com/users/jpmckinney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jpmckinney/subscriptions","organizations_url":"https://api.github.com/users/jpmckinney/orgs","repos_url":"https://api.github.com/users/jpmckinney/repos","events_url":"https://api.github.com/users/jpmckinney/events{/privacy}","received_events_url":"https://api.github.com/users/jpmckinney/received_events","type":"User","site_admin":false},"created_at":"2016-09-27T17:23:37Z","updated_at":"2016-09-27T17:23:37Z","body":"@Stiivi All the current units are real units of measurement. The units of measurement for time are seconds, minutes, etc. but not with respect to any particular anchor.\r\n\r\nYYYY and YYYY-MM only make sense given the anchor of 0 at roughly 2016 revolutions of the Earth around the Sun ago. They are not units, at least not in the same sense as the others."}}
{"actor":{"display_login":"jpmckinney"}}