Created
February 27, 2019 02:56
-
-
Save jmmccota/3cc576b979b141af09d7498e621618a0 to your computer and use it in GitHub Desktop.
Neo4j data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE INDEX ON :Person(name); | |
CREATE INDEX ON :Person(first_name); | |
CREATE INDEX ON :Person(middle_name); | |
CREATE INDEX ON :Person(last_name); | |
CREATE CONSTRAINT ON (p:Person) ASSERT p.personID IS UNIQUE; | |
USING PERIODIC COMMIT 50000 LOAD CSV WITH HEADERS FROM "file:///lattes_academic_nodes_v4B.csv" AS csvLine | |
OPTIONAL MATCH (p:personID {personID:csvLine.personID}) | |
CREATE (:Person {personID: csvLine.personID, name: csvLine.full_name, last_name: csvLine.last_name, middle_name: csvLine.middle_name, first_name: csvLine.first_name, email: csvLine.email, webpage: csvLine.webpage, userID:csvLine.userID, original_baseID: csvLine.original_baseID}); | |
USING PERIODIC COMMIT 50000 | |
LOAD CSV WITH HEADERS FROM "file:///lattes_academic_relationship_v4.csv" AS csvFile | |
MATCH (student:Person {personID: csvFile.studentID}) | |
MATCH (teacher:Person {personID: csvFile.teacherID}) | |
MERGE (teacher)-[:SUPERVISED {type: csvFile.type, research_area: csvFile.research_area, research_sub_area: csvFile.research_sub_area, title: csvFile.title, year: csvFile.year, institution: csvFile.institution}]->(student); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
personID | full_name | first_name | middle_name | last_name | original_baseID | institution | webpage | userID | ||
---|---|---|---|---|---|---|---|---|---|---|
la2681672335302680 | reivan marinho de souza | reivan | marinho de | souza | 2681672335302680 | Unknown | universidade federal de alagoas | Unknown | Unknown | |
la0465854373309290 | rodrigo marques tonella | rodrigo | marques | tonella | 0465854373309290 | Unknown | universidade estadual de campinas | Unknown | Unknown | |
la1049628236296033 | vera maura fernandes de lima | vera | maura fernandes de | lima | 1049628236296033 | Unknown | comissão de energia nuclear-sp | Unknown | Unknown | |
la1ordr4098878437565477 | aldo agosti marco scavino | aldo | agosti marco | scavino | Unknown | Unknown | Università degli Studi di Torino PRINCIPALE | Unknown | Unknown | |
la4899948304013675 | marcos tatajiba | marcos | tatajiba | 4899948304013675 | Unknown | universitat hannover | Unknown | Unknown | ||
laalmsor7la7901659618951205 | catarina assuncao gabriel | catarina | assuncao | gabriel | Unknown | Unknown | None | Unknown | Unknown | |
laalmsor16la5584662342646500 | janaina franca | janaina | franca | Unknown | Unknown | None | Unknown | Unknown | ||
laaldror1la3421486579714140 | jose wilson andrade | jose | wilson | andrade | Unknown | Unknown | None | Unknown | Unknown | |
la5873028930536300 | ginetton ferreira tavares | ginetton | ferreira | tavares | 5873028930536300 | Unknown | None | Unknown | Unknown |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
teacherID | studentID | type | research_area | research_sub_area | title | year | university_name | country | |
---|---|---|---|---|---|---|---|---|---|
la2681672335302680 | la5426671945549764 | Master S | Unknown | Unknown | formas de controle capitalista: fundamentos e expressÕes contemporÂneas da exploraÇÃo do trabalho | 2013 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la4068446815377739 | Master S | Unknown | Unknown | estado e polÃtica de saúde do trabalhador: controle necessário da reprodução do trabalho ao sistema do capital | 2015 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la8389829453010356 | Master S | Unknown | Unknown | cooperativas no capitalismo contemporÂneo: funcionalidade ao processo de reproduÇÃo do capital | 2013 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la6713979596971898 | Master S | Unknown | Unknown | na saÚde e na doenÇa atÉ que a morte os separe: trabalho e saúde nos tempos do capital | 2012 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la6234439354858543 | Master S | Unknown | Unknown | terceirização: novas formas velhas raÃzes da exploração e controle do trabalho | 2016 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la5974202902008394 | Master S | Unknown | Unknown | a funcionalidade do estado À reproduÇÃo do capital | 2014 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la4933530215036152 | Master S | Unknown | Unknown | exploraÇÃo e opressÃo da forÇa de trabalho feminina e sua luta pela emancipaÇÃo | 2015 | universidade federal de alagoas | Unknown | |
la2681672335302680 | laalmsor1la2681672335302680 | Master S | Unknown | Unknown | o espaÇo sÓcio-ocupacional do assistente social no Âmbito da assistÊncia social: uma nova versÃo do velho plantÃo social | 2009 | universidade federal de alagoas | Unknown | |
la2681672335302680 | la5802969609190589 | Master S | Unknown | Unknown | a funcionalidade do trabalho improdutivo para a reproduÇÃo do sistema capitalista | 2013 | universidade federal de alagoas | Unknown |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment