| 1 |
60979
|
miriam.bag
|
INSERT INTO dsm_datasources (id, officialname, namespaceprefix, typology)
|
| 2 |
|
|
VALUES
|
| 3 |
|
|
('openaire____::nserc', 'Natural Sciences and Engineering Research Council of Canada', 'nserc_______', 'entityregistry::projects'),
|
| 4 |
|
|
('openaire____::sshrc', 'Social Sciences and Humanities Research Council', 'sshrc_______', 'entityregistry::projects'),
|
| 5 |
|
|
('openaire____::cihr', 'Canadian Institutes of Health Research', 'cihr________','entityregistry::projects');
|
| 6 |
|
|
|
| 7 |
55162
|
miriam.bag
|
INSERT INTO dsm_organizations (id, legalshortname,legalname)
|
| 8 |
|
|
VALUES
|
| 9 |
|
|
('nserc_______::NSERC','NSERC','Natural Sciences and Engineering Research Council of Canada'),
|
| 10 |
|
|
('sshrc_______::SSHRC','SSHRC','Social Sciences and Humanities Research Council'),
|
| 11 |
|
|
('cihr________::CIHR','CIHR','Canadian Institutes of Health Research');
|
| 12 |
|
|
|
| 13 |
|
|
INSERT INTO fundingpaths (id,path,funder,jurisdiction)
|
| 14 |
|
|
VALUES
|
| 15 |
55170
|
miriam.bag
|
('nserc_______::NSERC','<fundingtree>
|
| 16 |
55162
|
miriam.bag
|
<funder>
|
| 17 |
|
|
<id>nserc_______::NSERC</id>
|
| 18 |
|
|
<shortname>NSERC</shortname>
|
| 19 |
|
|
<name>Natural Sciences and Engineering Research Council of Canada</name>
|
| 20 |
|
|
<originalname>Natural Sciences and Engineering Research Council of Canada</originalname>
|
| 21 |
|
|
<jurisdiction>CA</jurisdiction>
|
| 22 |
|
|
</funder>
|
| 23 |
55170
|
miriam.bag
|
</fundingtree>', 'nserc_______::NSERC','CA'),
|
| 24 |
|
|
('sshrc_______::SSHRC','<fundingtree>
|
| 25 |
55162
|
miriam.bag
|
<funder>
|
| 26 |
|
|
<id>sshrc_______::SSHRC</id>
|
| 27 |
|
|
<shortname>SSHRC</shortname>
|
| 28 |
|
|
<name>Social Sciences and Humanities Research Council</name>
|
| 29 |
|
|
<originalname>Social Sciences and Humanities Research Council</originalname>
|
| 30 |
|
|
<jurisdiction>CA</jurisdiction>
|
| 31 |
|
|
</funder>
|
| 32 |
55170
|
miriam.bag
|
</fundingtree>', 'sshrc_______::SSHRC','CA'),
|
| 33 |
|
|
('cihr________::CIHR','<fundingtree>
|
| 34 |
55162
|
miriam.bag
|
<funder>
|
| 35 |
|
|
<id>cihr________::CIHR</id>
|
| 36 |
|
|
<shortname>CIHR</shortname>
|
| 37 |
|
|
<name>Canadian Institutes of Health Research</name>
|
| 38 |
|
|
<originalname>Canadian Institutes of Health Research</originalname>
|
| 39 |
|
|
<jurisdiction>CA</jurisdiction>
|
| 40 |
|
|
</funder>
|
| 41 |
55170
|
miriam.bag
|
</fundingtree>', 'cihr________::CIHR','CA');
|
| 42 |
55162
|
miriam.bag
|
|
| 43 |
|
|
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass)
|
| 44 |
|
|
VALUES
|
| 45 |
60979
|
miriam.bag
|
('nserc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::nserc', 'sysimport:crosswalk:entityregistry'),
|
| 46 |
|
|
('sshrc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::sshrc', 'sysimport:crosswalk:entityregistry'),
|
| 47 |
|
|
('cihr________::unidentified', 'unidentified', 'unidentified', 'openaire__::cihr', 'sysimport:crosswalk:entityregistry');
|
| 48 |
55162
|
miriam.bag
|
|
| 49 |
|
|
INSERT INTO project_fundingpath (funding, project)
|
| 50 |
|
|
VALUES
|
| 51 |
|
|
('nserc_______::NSERC', 'nserc_______::unidentified'),
|
| 52 |
|
|
('sshrc_______::SSHRC', 'sshrc_______::unidentified'),
|
| 53 |
|
|
('cihr________::CIHR', 'cihr________::unidentified');
|
| 54 |
|
|
|