{"action":"created","issue":{"url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/13","labels_url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/13/comments","events_url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/13/events","html_url":"https://github.com/lukehsiao/HardwareDeepDive/issues/13","id":121635684,"number":13,"title":"Create a Candidate Extractor to match part numbers and storage temperature ranges","user":{"login":"lukehsiao","id":7573542,"avatar_url":"https://avatars.githubusercontent.com/u/7573542?v=3","gravatar_id":"","url":"https://api.github.com/users/lukehsiao","html_url":"https://github.com/lukehsiao","followers_url":"https://api.github.com/users/lukehsiao/followers","following_url":"https://api.github.com/users/lukehsiao/following{/other_user}","gists_url":"https://api.github.com/users/lukehsiao/gists{/gist_id}","starred_url":"https://api.github.com/users/lukehsiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukehsiao/subscriptions","organizations_url":"https://api.github.com/users/lukehsiao/orgs","repos_url":"https://api.github.com/users/lukehsiao/repos","events_url":"https://api.github.com/users/lukehsiao/events{/privacy}","received_events_url":"https://api.github.com/users/lukehsiao/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"lukehsiao","id":7573542,"avatar_url":"https://avatars.githubusercontent.com/u/7573542?v=3","gravatar_id":"","url":"https://api.github.com/users/lukehsiao","html_url":"https://github.com/lukehsiao","followers_url":"https://api.github.com/users/lukehsiao/followers","following_url":"https://api.github.com/users/lukehsiao/following{/other_user}","gists_url":"https://api.github.com/users/lukehsiao/gists{/gist_id}","starred_url":"https://api.github.com/users/lukehsiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukehsiao/subscriptions","organizations_url":"https://api.github.com/users/lukehsiao/orgs","repos_url":"https://api.github.com/users/lukehsiao/repos","events_url":"https://api.github.com/users/lukehsiao/events{/privacy}","received_events_url":"https://api.github.com/users/lukehsiao/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2015-12-11T04:33:13Z","updated_at":"2016-01-07T18:02:55Z","closed_at":null,"body":"Now that we have naive implementations of #12 and #10, we should be able to move on to create the candidate extractor.\n\nIn the DeepDive tutorial, this would correspond to the ```has_spouse``` extractor that uses the data in the ```people_mentions``` table to determine whether or not they may be spouses. In our case, we will be using the ```product_num_mentions``` table and the ```storage_temp_mentions``` table to try to decide whether two entries are matched with each other."},"comment":{"url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/comments/169757945","html_url":"https://github.com/lukehsiao/HardwareDeepDive/issues/13#issuecomment-169757945","issue_url":"https://api.github.com/repos/lukehsiao/HardwareDeepDive/issues/13","id":169757945,"user":{"login":"lukehsiao","id":7573542,"avatar_url":"https://avatars.githubusercontent.com/u/7573542?v=3","gravatar_id":"","url":"https://api.github.com/users/lukehsiao","html_url":"https://github.com/lukehsiao","followers_url":"https://api.github.com/users/lukehsiao/followers","following_url":"https://api.github.com/users/lukehsiao/following{/other_user}","gists_url":"https://api.github.com/users/lukehsiao/gists{/gist_id}","starred_url":"https://api.github.com/users/lukehsiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukehsiao/subscriptions","organizations_url":"https://api.github.com/users/lukehsiao/orgs","repos_url":"https://api.github.com/users/lukehsiao/repos","events_url":"https://api.github.com/users/lukehsiao/events{/privacy}","received_events_url":"https://api.github.com/users/lukehsiao/received_events","type":"User","site_admin":false},"created_at":"2016-01-07T18:02:55Z","updated_at":"2016-01-07T18:02:55Z","body":"Output currently looks like this:\r\n```\r\nlh@lh:~/repos/HardwareDeepDive$ deepdive sql \"select * from part_temperature_candidates\"\r\n  doc_id   | part_pg_num | part_table_id | part_relation | part_relation_id | part_num | temp_pg_num | temp_table_id | temp_row_id | temp_min | temp_max | temp_unit |   relation_id   | is_true\r\n-----------+-------------+---------------+---------------+------------------+----------+-------------+---------------+-------------+----------+----------+-----------+-----------------+---------\r\n bc550.pdf |           0 |             0 | header        |                0 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                1 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                2 | BC547    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                3 | BC548    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                4 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                5 | BC547    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                6 | BC548    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                7 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             0 | row           |                8 | BC548    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | header        |                0 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |               12 | BC546    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |               13 | BC549    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |               14 | BC549    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |               15 | 15000MHz |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |               15 | BC550    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |                4 | 100mA    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |                6 | 100mA    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           0 |             1 | row           |                9 | 100MHz   |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           2 |             0 | header        |                2 | 27TYP    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           2 |             0 | row           |               13 | 27TYP    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           2 |             1 | header        |                2 | 27TYP    |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           3 |             0 | row           |                4 | Power247 |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n bc550.pdf |           3 |             0 | row           |                9 | E2CMOS   |           0 |             0 |          12 |      -65 |      150 | C         | NOT_IMPLEMENTED | f\r\n(23 rows)\r\n```"}}