Fraud Detection Dataset
Tags: fraud detection
, loan application
Fraud Detection Dataset Generated by Wey's fraud-detection-datagen, see more details on this blog: Fraud Fetection with NebulaGraph Download
Data Showcase
Schema
CREATE TAG corp (corp_name string, phone_num string, is_risky string, risk_comment string);
CREATE TAG application (apply_agent_id string, apply_date date, application_uuid string, approval_status string, application_type string, rejection_reason string);
CREATE TAG phone_num (phone_num string);
CREATE TAG device (device_id string);
CREATE TAG person (name string);
CREATE TAG applicant (name string, gender string, birth date, addr string, degree string, occupation string, year_salary string, is_risky string, risk_comment string);
CREATE EDGE applied_for_loan (start_time date);
CREATE EDGE with_phone_num (start_time date);
CREATE EDGE is_related_to (start_time date, level int);
CREATE EDGE worked_for (start_time date);
CREATE EDGE used_device (start_time date);
graph TD
A[corp]
B[application]
C[phone_num]
D[device]
E[person]
F[applicant]
A -->|applied_for_loan| B
B -->|with_phone_num| C
C -->|used_device| D
D -->|is_related_to| E
E -->|worked_for| F
style A fill:#f9d,stroke:#333,stroke-width:3px;
style B fill:#fcc,stroke:#333,stroke-width:3px;
style C fill:#cfc,stroke:#333,stroke-width:3px;
style D fill:#ccf,stroke:#333,stroke-width:3px;
style E fill:#a44,stroke:#333,stroke-width:3px;
style F fill:#18d,stroke:#333,stroke-width:3px;
classDiagram
class corp {
string corp_name
string phone_num
string is_risky
string risk_comment
}
class application {
string apply_agent_id
string apply_date
string application_uuid
string approval_status
string application_type
string rejection_reason
}
class phone_num {
string phone_num
}
class device {
string device_id
}
class person {
string name
}
class applicant {
string name
string gender
date birth
string addr
string degree
string occupation
string year_salary
string is_risky
string risk_comment
}
applicant --> application : applied_for_loan(start_time date)
application --> phone_num : with_phone_num(start_time date)
applicant --> device : used_device(start_time date)
device --> person : is_related_to(level int)
applicant --> corp : worked_for(start_time date)
person --> applicant : is_related_to(start_time date)
person --> phone_num : with_phone_num(start_time date)
corp --> phone_num : with_phone_num(start_time date)
style corp fill:#f9d,stroke:#333,stroke-width:3px;
style applicant fill:#fcc,stroke:#333,stroke-width:3px;
style application fill:#cfc,stroke:#333,stroke-width:3px;
style phone_num fill:#ccf,stroke:#333,stroke-width:3px;
style device fill:#a44,stroke:#333,stroke-width:3px;
style person fill:#18d,stroke:#333,stroke-width:3px;
Sample Data
loan_application_id_1 | address_1 | degree_1 | occupation_1 | salary_1 | is_risky_1 | risk_profile_1 | apply_agent_id_1 | apply_date_1 | application_uuid_1 | approval_status_1 | application_type_1 | rejection_reason_1 | applied_for_loan_start_time_1 | loan_application_id_0 | address_0 | degree_0 | occupation_0 | salary_0 | is_risky_0 | risk_profile_0 | apply_agent_id_0 | apply_date_0 | application_uuid_0 | approval_status_0 | application_type_0 | rejection_reason_0 | applied_for_loan_start_time_0 | applicant_id_0 | applicant_id_1 | pn_id | name_0 | gender_0 | birthday_0 | name_1 | gender_1 | birthday_1 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
la_p_23897 | 57449\ Emily\ Inlet\ Suite\ 981\ East\ Kimberly\ \ WI\ 17822 | Master | Designer\ \ industrial/product | 123749 | False | 46668b5759886e51b726f0a8865bf966 | 2009-05-25 | d3f01380469f60e9c308da2aa877f313 | Approved | Credit | 2009-05-25 | la_p_1 | 943\ Brittany\ Forge\ Apt.\ 718\ East\ Eric\ \ WV\ 97881 | Master | Public\ relations\ officer | 694483 | False | a8ea9313ed04f4da42a0563306bbe0cb | 2008-05-23 | 4e858dbb77b894b1b70b5f90a27c4ee1 | Approved | Credit | 2008-05-23 | p_1 | p_3009 | pn_51760 | Miranda Miller | M | 1957-08-27 | Jacob Smith | F | 2001-12-26 | ||||
la_p_23898 | 4100\ Scott\ Shore\ Suite\ 884\ South\ Johnmouth\ \ SC\ 27867 | Master | Translator | 138235 | False | abe7339ae4d55b71ab5bcf36934c67f1 | 2019-01-13 | dcba55b23f959d33df0fa0407eb464d5 | Approved | Credit | 2019-01-13 | la_p_2 | 22071\ Amanda\ Freeway\ Lisaland\ \ NJ\ 94933 | Master | Banker | 603860 | False | e4a278734d409f43b83e2482a9b1246a | 1992-07-05 | 68382c45c04ab9259c468c0049a2f4d9 | Approved | Credit | 1992-07-05 | p_1 | p_14645 | pn_38475 | Miranda Miller | M | 1957-08-27 | Brian Smith | M | 1980-11-23 | ||||
la_p_23899 | 088\ Smith\ Gardens\ Luishaven\ \ DC\ 38237 | PhD | Development\ worker\ \ international\ aid | 204830 | False | 44b843b2469d8e0e70f4b190dffe8f0a | 2000-02-17 | 3ece3602d299533aa3f68bf45205cd17 | Approved | Loan | 2000-02-17 | la_p_3 | 0295\ Rodriguez\ Track\ East\ Connorfort\ \ NC\ 63144 | Master | Communications\ engineer | 113752 | True | Soon high beat center sound class store. | 633fc21592bfd6ef496f4cede7c9d4d8 | 1994-10-21 | 37d575a5adc300bdc076d800f21ddbfe | Approved | Credit | 1994-10-21 | p_1 | p_19932 | pn_10 | Miranda Miller | M | 1957-08-27 | April Richardson | F | 2016-12-27 | |||
la_p_23900 | Unit\ 6485\ Box\ 9249\ DPO\ AE\ 37202 | Bachelor | Dietitian | 619939 | False | 641185db4961ec4722a9ce0b0bd690d9 | 2000-10-25 | aea6f3a359a989eb22ba14561cee9600 | Approved | Loan | 2000-10-25 | la_p_4 | 107\ Richard\ Curve\ Kingstad\ \ AZ\ 05660 | PhD | Arts\ development\ officer | 270147 | False | 3fe7348ed258bd1e1a8d93084331a18a | 2021-07-15 | 4756a9e01080105ae6b0018234841308 | Approved | Loan | 2021-07-15 | p_1 | p_96908 | pn_37140 | Miranda Miller | M | 1957-08-27 | Kayla Ferguson | M | 1970-09-25 |
corp_id | corp_name | corp_address | is_risky | risk_profile |
---|---|---|---|---|
co_1 | Hendrix_Mckenzie\ and\ Perry | USCGC\ Johnson\ FPO\ AA\ 44239 | False | NA |
co_2 | Irwin\ PLC | USNS\ Walton\ FPO\ AP\ 44570 | False | NA |
co_3 | Johnson\ Ltd | 38084\ Tran\ Crescent\ Ellenland\ \ MT\ 28211 | False | NA |
co_4 | Kline-Jackson | 093\ Jonathan\ Motorway\ Lake\ Christopher\ \ UT\ 78313 | False | NA |
loan_application_id_1 | address_1 | degree_1 | occupation_1 | salary_1 | is_risky_1 | risk_profile_1 | apply_agent_id_1 | apply_date_1 | application_uuid_1 | approval_status_1 | application_type_1 | rejection_reason_1 | applied_for_loan_start_time_1 | loan_application_id_0 | address_0 | degree_0 | occupation_0 | salary_0 | is_risky_0 | risk_profile_0 | apply_agent_id_0 | apply_date_0 | application_uuid_0 | approval_status_0 | application_type_0 | rejection_reason_0 | applied_for_loan_start_time_0 | applicant_id_0 | applicant_id_1 | corp_id | pn_id | src_work_for_start_time | name_0 | gender_0 | birthday_0 | name_1 | gender_1 | birthday_1 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
la_v_5975 | 686\ Hill\ Manor\ Suite\ 867\ South\ Nicoleburgh\ \ UT\ 91323 | Master | Visual\ merchandiser | 404886 | False | dfa8fe6abd7df58f75cf6121b2b141f0 | 1993-06-24 | 03e72b4b2740ce2105cc21eb821b7ea7 | Approved | Credit | 1993-06-24 | la_v_1 | 7714\ Christopher\ Circles\ Apt.\ 889\ Cynthiaburgh\ \ VA\ 68994 | Bachelor | Media\ planner | 564106 | False | c0b68ed755d010c065bee58477aca637 | 2021-03-28 | feea0be2977318fd8a7bfb17fe66358f | Approved | Credit | 2021-03-28 | p_40332 | p_42557 | co_1223 | pn_47939 | 2022-03-05 | Kevin Thomas | F | 1929-10-14 | Joseph White | F | 2004-03-21 | ||||
la_v_5976 | Unit\ 9914\ Box\ 6074\ DPO\ AE\ 10020 | Master | Pilot\ \ airline | 336267 | False | 564d9d1c6e8a61a4fcda5fd58aa09208 | 2013-05-11 | 59de9659734d758140a9e5535584be46 | Approved | Credit | 2013-05-11 | la_v_2 | USCGC\ Phelps\ FPO\ AP\ 87289 | PhD | Chiropodist | 892349 | False | 750271de4a5d3d106b22405687acfdb1 | 1994-05-12 | 766bbdcaa43765145dcc05a6cdc34bda | Approved | Loan | 1994-05-12 | p_40332 | p_95456 | co_7250 | pn_19609 | 2020-11-08 | Kevin Thomas | F | 1929-10-14 | Rebecca Nelson | F | 1989-04-26 | ||||
la_v_5977 | 232\ Anthony\ Terrace\ Port\ Jared\ \ MD\ 43408 | PhD | Actuary | 298939 | False | 660185f1e8951dac7b26b61812c19807 | 2013-03-20 | 69a845291649ea512657107767bbee46 | Approved | Loan | 2013-03-20 | la_v_3 | 71265\ Ronald\ Plains\ North\ Maryview\ \ AL\ 05037 | PhD | Arts\ development\ officer | 411539 | False | d0073a8dc089cda4d46dc49ac052df12 | 1999-06-19 | 705bafec93b2009316cc9fd0269f4572 | Approved | Loan | 1999-06-19 | p_40333 | p_74894 | co_954 | pn_64515 | 2021-12-20 | Diana Wilson | M | 1984-11-13 | Jennifer Stephens | M | 1917-04-11 | ||||
la_v_5978 | 6209\ Robert\ Rapids\ Suite\ 564\ Austinfort\ \ OH\ 92586 | PhD | Intelligence\ analyst | 400638 | False | 96543476955492fff5da12ebef377425 | 1993-04-20 | cc70bc42b65f61f01fea7ab27de728fd | Approved | Loan | 1993-04-20 | la_v_4 | 6105\ Dakota\ Well\ East\ Mauricehaven\ \ MS\ 53989 | Master | Theme\ park\ manager | 989839 | False | e2eefa33c4fe57058285b810eccda5de | 1997-03-21 | 70ee555216d28803d98fd231b61a01d8 | Approved | Loan | 1997-03-21 | p_40337 | p_84227 | co_60 | pn_80992 | 2021-06-23 | Scott Long | M | 1945-02-17 | Colleen Brennan | M | 1980-03-23 |
loan_application_id_1 | address_1 | degree_1 | occupation_1 | salary_1 | is_risky_1 | risk_profile_1 | apply_agent_id_1 | apply_date_1 | application_uuid_1 | approval_status_1 | application_type_1 | rejection_reason_1 | applied_for_loan_start_time_1 | loan_application_id_0 | address_0 | degree_0 | occupation_0 | salary_0 | is_risky_0 | risk_profile_0 | apply_agent_id_0 | apply_date_0 | application_uuid_0 | approval_status_0 | application_type_0 | rejection_reason_0 | applied_for_loan_start_time_0 | applicant_id_0 | applicant_id_1 | corp_id | src_work_for_start_time | dst_work_for_start_time | name_0 | gender_0 | birthday_0 | name_1 | gender_1 | birthday_1 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
la_e_11949 | 1154\ Tate\ Islands\ Apt.\ 694\ East\ Jose\ \ CO\ 44294 | Master | Public\ relations\ account\ executive | 506292 | False | 0f339ae16f94aae6da0c5bc791c737dd | 2004-10-21 | 11ef253aca17448192e8de0c3d760466 | Approved | Loan | 2004-10-21 | la_e_1 | 08415\ Thomas\ Fall\ Suite\ 748\ North\ Steven\ \ TN\ 96507 | PhD | Engineer\ \ mining | 399208 | False | 1afba71585831d00ef872ce78063a095 | 2007-11-24 | ed787474761f5a8a576dd5cb161ec26c | Approved | Credit | 2007-11-24 | p_29530 | p_79880 | co_10 | 2022-04-17 | 2021-01-21 | Leslie Torres | F | 2008-05-13 | Vanessa Vasquez | F | 1997-09-15 | ||||
la_e_11950 | PSC\ 8004\ \ Box\ 2654\ APO\ AE\ 21796 | PhD | Land | 448138 | False | 4bf4bcdc0a856b03b68503d9cb7f5442 | 1998-11-21 | c81cdee1a7a115cd01eb6f5f9362fb22 | Approved | Loan | 1998-11-21 | la_e_2 | 207\ Emily\ Points\ Suite\ 672\ Wilsonland\ \ NY\ 08530 | Master | Production\ assistant\ \ television | 374687 | False | 53101a2d38304a0d7b50731b5fd281f5 | 1999-04-14 | a255eb0dc8df0d3431b2b510c33a39b7 | Approved | Loan | 1999-04-14 | p_29531 | p_68456 | co_1138 | 2019-07-20 | 2020-01-03 | Mercedes Curry | F | 1989-08-05 | Patricia Perry | F | 1909-10-04 | ||||
la_e_11951 | 45980\ Foster\ Forge\ Bobbyburgh\ \ TN\ 14269 | Bachelor | Conservator\ \ furniture | 518225 | False | de3e3ec272255f352fbf1371db8d62b8 | 2006-01-08 | f650b035aa2edab45a1d1831e14b0072 | Approved | Credit | 2006-01-08 | la_e_3 | 392\ Hunter\ Ferry\ Bryanttown\ \ VT\ 75828 | Master | Civil\ Service\ fast\ streamer | 987525 | False | 3a8585dd2431c771ac6952512dfb610c | 2019-03-14 | 1cccbbdf48b99dbf0bf482c9cf701048 | Approved | Credit | 2019-03-14 | p_29531 | p_87877 | co_886 | 2021-12-10 | 2020-10-18 | Mercedes Curry | F | 1989-08-05 | Bruce Foster | F | 1990-11-13 | ||||
la_e_11952 | 20687\ Pineda\ Mount\ Suite\ 993\ Margaretport\ \ MO\ 58875 | PhD | Fashion\ designer | 365690 | False | 5666443e4430aa4b602e5b80d75f607b | 2020-02-01 | 75ec0b7498e49ebe6697007f8ba21cb6 | Approved | Credit | 2020-02-01 | la_e_4 | 22445\ Myers\ Flat\ Suite\ 617\ South\ Timothyland\ \ OK\ 01285 | Bachelor | Musician | 641427 | False | bc64248bb5d2680a1c9114614ba33078 | 2000-03-10 | 7c47fc5d215d63ace80037f4f78ec092 | Approved | Loan | 2000-03-10 | p_29532 | p_51537 | co_7442 | 2020-11-24 | 2020-07-17 | Shawn Lawrence | M | 1991-07-20 | Fernando Smith | F | 2012-11-13 |
person_id | contact_id | level |
---|---|---|
p_46617 | p_95395 | 0 |
p_46619 | p_75593 | 56 |
p_46619 | p_89341 | 38 |
p_46620 | p_76157 | 38 |
phone_number_id | phone_number |
---|---|
pn_1 | (724)681-7804x1810 |
pn_2 | 001-870-792-7551x33639 |
pn_3 | (133)391-8959 |
pn_4 | 352-954-1791 |
loan_application_id_1 | address_1 | degree_1 | occupation_1 | salary_1 | is_risky_1 | risk_profile_1 | apply_agent_id_1 | apply_date_1 | application_uuid_1 | approval_status_1 | application_type_1 | rejection_reason_1 | applied_for_loan_start_time_1 | loan_application_id_0 | address_0 | degree_0 | occupation_0 | salary_0 | is_risky_0 | risk_profile_0 | apply_agent_id_0 | apply_date_0 | application_uuid_0 | approval_status_0 | application_type_0 | rejection_reason_0 | applied_for_loan_start_time_0 | applicant_id_0 | applicant_id_1 | d_id | src_device_start_time | dst_device_start_time | name_0 | gender_0 | birthday_0 | name_1 | gender_1 | birthday_1 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
la_d_53767 | 49138\ Kathleen\ Track\ South\ Brent\ \ IN\ 95389 | PhD | Radiographer\ \ diagnostic | 404374 | False | f0ce91d396e5ec060a2b9fbe2634be91 | 2010-02-24 | fef192f09f5f3177a9292edc07a469ac | Approved | Credit | 2010-02-24 | la_d_1 | 9873\ Edward\ Forest\ Apt.\ 411\ Julietown\ \ SC\ 55796 | PhD | Surveyor\ \ insurance | 121908 | False | a6026184108db717704d13bfbd1e3544 | 2004-05-09 | 599bfe1d13b6682cc0fb01cf8fcb7ddc | Approved | Credit | 2004-05-09 | p_6316 | p_15886 | dev_1 | 2022-03-19 | 2020-01-17 | Heidi Calderon | F | 1934-05-19 | Dr. Patrick Campbell DDS | M | 1977-10-26 | ||||
la_d_74272 | 404\ Gonzalez\ Prairie\ Jonathanfort\ \ CT\ 40534 | Bachelor | Interior\ and\ spatial\ designer | 207021 | False | 8b7d23f764a2ee649c3ae0eab15a132d | 1994-02-16 | 2bed1dd53ea90ff8834f7af83b99d68d | Approved | Credit | 1994-02-16 | la_d_20506 | 44310\ James\ Fork\ Benitezfurt\ \ WI\ 17012 | Bachelor | Fine\ artist | 666577 | False | b4d45413846d3ce5924fe0a0ba990e27 | 2008-01-13 | dafa46124b5ef2a2f1e2ce1af9081812 | Rejected | Loan | Happen government determine again score. | 2008-01-13 | p_13545 | p_15886 | dev_2 | 2022-01-11 | 2022-06-24 | Jeffrey Smith | F | 2009-10-04 | Dr. Patrick Campbell DDS | M | 1977-10-26 | |||
la_d_53768 | 72859\ Laura\ Track\ Port\ Lesliestad\ \ KY\ 24749 | Master | Chief\ Financial\ Officer | 944423 | False | c28b94691de407ea4dcdad770a1887c0 | 2001-12-23 | 5a45c542729fcff9620b41436010fec2 | Approved | Loan | 2001-12-23 | la_d_2 | 0191\ Christina\ Dam\ Apt.\ 120\ Port\ Jessica\ \ DC\ 40896 | Bachelor | Contractor | 211055 | False | 944ce0445e5b3dd6eaf0df22800fa13c | 2009-10-31 | e120471bc99a5d3be82b209376bed561 | Approved | Loan | 2009-10-31 | p_6316 | p_63662 | dev_4 | 2022-04-06 | 2021-01-16 | Heidi Calderon | F | 1934-05-19 | Christina Benson | F | 1938-05-20 | ||||
la_d_53769 | 244\ Edward\ Well\ Lake\ Kenneth\ \ AL\ 31168 | PhD | Recruitment\ consultant | 795936 | False | 33c7a4bddfa52c005b0c4518debeb31e | 2000-11-15 | 07564690d9283410ab1289ec3e2c33a6 | Approved | Loan | 2000-11-15 | la_d_3 | 885\ Michael\ Street\ Port\ Angela\ \ NH\ 79737 | PhD | Lawyer | 282486 | False | 164880d4f5411d3979e125fc6b2fc2b5 | 1995-01-27 | 2a2e0c62173ef557a9e1d0bd0edd90d5 | Approved | Credit | 1995-01-27 | p_6316 | p_97300 | dev_63 | 2019-12-22 | 2019-08-17 | Heidi Calderon | F | 1934-05-19 | Danielle Huber | M | 1928-08-11 |
src_id | dst_id | d_id | src_device_start_time | dst_device_start_time |
---|---|---|---|---|
p_6316 | p_15886 | dev_1 | 2022-03-19 | 2020-01-17 |
p_6316 | p_63662 | dev_4 | 2022-04-06 | 2021-01-16 |
p_6316 | p_97300 | dev_63 | 2019-12-22 | 2019-08-17 |
p_6317 | p_22201 | dev_71620 | 2020-03-06 | 2022-02-08 |
src_id | dst_id | corp_id | src_work_for_start_time | dst_work_for_start_time |
---|---|---|---|---|
p_29530 | p_79880 | co_10 | 2022-04-17 | 2021-01-21 |
p_29531 | p_68456 | co_1138 | 2019-07-20 | 2020-01-03 |
p_29531 | p_87877 | co_886 | 2021-12-10 | 2020-10-18 |
p_29532 | p_51537 | co_7442 | 2020-11-24 | 2020-07-17 |
src_id | dst_id | corp_id | pn_id | src_work_for_start_time |
---|---|---|---|---|
p_40332 | p_42557 | co_1223 | pn_47939 | 2022-03-05 |
p_40332 | p_95456 | co_7250 | pn_19609 | 2020-11-08 |
p_40333 | p_74894 | co_954 | pn_64515 | 2021-12-20 |
p_40337 | p_84227 | co_60 | pn_80992 | 2021-06-23 |
person_id | name | gender | birthday |
---|---|---|---|
p_1 | Miranda Miller | M | 1957-08-27 |
p_2 | Holly Pollard | F | 1910-10-19 |
p_3 | Julia Hall | F | 1927-08-24 |
p_4 | Franklin Barnett | M | 2020-03-01 |
loan_application_id | address | degree | occupation | salary | is_risky | risk_profile | apply_agent_id | apply_date | application_uuid | approval_status | application_type | rejection_reason | applied_for_loan_start_time | applicant_id | contact_id | level | name | gender | birthday |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
la_r_1 | 4674\ Kristen\ Rapid\ West\ Kimberly\ \ MT\ 61282 | Master | Psychologist\ \ sport\ and\ exercise | 877249 | False | 04abdecc218042f12504141d3462339f | 2010-05-30 | 0900c09324181fb841bb578088b8bf5c | Approved | Credit | 2010-05-30 | p_46617 | p_95395 | 0 | Kimberly Carr | M | 1973-01-17 | ||
la_r_2 | 58396\ Jeffrey\ Mountain\ Cruzfurt\ \ MN\ 71496 | Bachelor | Records\ manager | 791868 | False | a0f297cc246f43658ed9c319c3ffecd9 | 2020-07-28 | d8b9461921087359682762d4fb32333b | Approved | Loan | 2020-07-28 | p_46619 | p_75593 | 56 | Susan Daugherty | F | 1974-01-27 | ||
la_r_3 | 37430\ Cody\ Neck\ South\ Shannon\ \ OH\ 35235 | Bachelor | Advertising\ art\ director | 71480 | True | Environmental because business man usually. | 5b0dd380214d22ceffcf9bcb2b4d39b5 | 1993-07-15 | b2d84796981c896cf9ecded3f4e69163 | Approved | Credit | 1993-07-15 | p_46619 | p_89341 | 38 | Susan Daugherty | F | 1974-01-27 | |
la_r_4 | 150\ Jennifer\ Squares\ North\ Jessica\ \ ID\ 13048 | Master | Police\ officer | 446128 | False | ad600fc55630941de6e8e1af34d59659 | 1996-10-07 | 7161436814d7f1b131935d7558c0a16b | Approved | Loan | 1996-10-07 | p_46620 | p_76157 | 38 | Karen Clark | M | 2005-05-24 |
src_id | dst_id | pn_id |
---|---|---|
p_1 | p_3009 | pn_51760 |
p_1 | p_14645 | pn_38475 |
p_1 | p_19932 | pn_10 |
p_1 | p_96908 | pn_37140 |
device_id | device_name |
---|---|
dev_1 | 53ba6518d709c99a37267a308c7779e6 |
dev_2 | 1ec4dd7f74e805d8c7c8afaba445d169 |
dev_3 | ba39c9ae6c19d2c004e00f4eb0293959 |
dev_4 | fe5c70bf84434e89cfac9ec498ce9277 |
Download
Gephi Lite is an OSS tool for Graph Visualization and In Canvas Graph Exploration and Computational Analysis.
Download this sample Gephi Lite file to visualize the sampled graph data from here.
💡: You can generate gephi file from any graph query with NebulaGraph-Gephi.
Install the Jupyter-NebulaGraph extension, refer to the documentation for more information.
!pip install jupyter-nebulagraph
%load_ext ngql
%ngql --address 127.0.0.1 --port 9669 --user root --password nebula
Create Graph Space and Schema.
%ngql CREATE SPACE fraud_detection(partition_num=1, replica_factor=1, vid_type=fixed_string(128));
# wait for a while
%ngql USE fraud_detection;
# DDL with `%%ngql` magic for multi-line execution
%%ngql
CREATE TAG corp (corp_name string, phone_num string, is_risky string, risk_comment string);
CREATE TAG application (apply_agent_id string, apply_date date, application_uuid string, approval_status string, application_type string, rejection_reason string);
CREATE TAG phone_num (phone_num string);
CREATE TAG device (device_id string);
CREATE TAG person (name string);
CREATE TAG applicant (name string, gender string, birth date, addr string, degree string, occupation string, year_salary string, is_risky string, risk_comment string);
CREATE EDGE applied_for_loan (start_time date);
CREATE EDGE with_phone_num (start_time date);
CREATE EDGE is_related_to (start_time date, level int);
CREATE EDGE worked_for (start_time date);
CREATE EDGE used_device (start_time date);
Refer to jupyter-nebulagraph for more information.
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/corporation.csv --tag corp --vid 0 --props 1:corp_name,3:is_risky,4:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_is_related_to.csv --tag application --vid 0 --props 7:apply_agent_id,8:apply_date,9:application_uuid,10:approval_status,11:application_type,12:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/phone_number.csv --tag phone_num --vid 0 --props 1:phone_num --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/device.csv --tag device --vid 0 --props 1:device_id --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/person.csv --tag person --vid 0 --props 1:name --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_is_related_to.csv --tag applicant --vid 14 --props 17:name,18:gender,19:birth,1:addr,2:degree,3:occupation,4:year_salary,5:is_risky,6:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_is_related_to.csv --edge applied_for_loan --src 14 --dst 0 --props 8:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --edge with_phone_num --src 28 --dst 30 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --edge with_phone_num --src 29 --dst 30 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_is_related_to.csv --edge is_related_to --src 14 --dst 15 --props 16:level --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --edge worked_for --src 28 --dst 30 --props 31:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --edge worked_for --src 29 --dst 30 --props 31:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --edge used_device --src 28 --dst 30 --props 31:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --edge used_device --src 29 --dst 30 --props 32:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/shared_phone_num_relationship.csv --edge with_phone_num --src 1 --dst 2 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/shared_via_employer_phone_num_relationship.csv --edge with_phone_num --src 1 --dst 3 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/shared_via_employer_phone_num_relationship.csv --edge with_phone_num --src 2 --dst 3 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --edge worked_for --src 28 --dst 30 --props 32:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --edge with_phone_num --src 29 --dst 31 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --edge with_phone_num --src 30 --dst 31 --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --tag application --vid 0 --props 7:apply_agent_id,8:apply_date,9:application_uuid,10:approval_status,11:application_type,12:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --tag application --vid 0 --props 7:apply_agent_id,8:apply_date,9:application_uuid,10:approval_status,11:application_type,12:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --tag application --vid 0 --props 7:apply_agent_id,8:apply_date,9:application_uuid,10:approval_status,11:application_type,12:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --tag application --vid 0 --props 7:apply_agent_id,8:apply_date,9:application_uuid,10:approval_status,11:application_type,12:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --tag application --vid 14 --props 21:apply_agent_id,22:apply_date,23:application_uuid,24:approval_status,25:application_type,26:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --tag application --vid 14 --props 21:apply_agent_id,22:apply_date,23:application_uuid,24:approval_status,25:application_type,26:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --tag application --vid 14 --props 21:apply_agent_id,22:apply_date,23:application_uuid,24:approval_status,25:application_type,26:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --tag application --vid 14 --props 21:apply_agent_id,22:apply_date,23:application_uuid,24:approval_status,25:application_type,26:rejection_reason --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --tag applicant --vid 28 --props 33:name,34:gender,35:birth,1:addr,2:degree,3:occupation,4:year_salary,5:is_risky,6:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --tag applicant --vid 28 --props 33:name,34:gender,35:birth,1:addr,2:degree,3:occupation,4:year_salary,5:is_risky,6:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --tag applicant --vid 28 --props 33:name,34:gender,35:birth,1:addr,2:degree,3:occupation,4:year_salary,5:is_risky,6:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --tag applicant --vid 28 --props 31:name,32:gender,33:birth,1:addr,2:degree,3:occupation,4:year_salary,5:is_risky,6:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --tag applicant --vid 29 --props 36:name,37:gender,38:birth,15:addr,16:degree,17:occupation,18:year_salary,19:is_risky,20:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --tag applicant --vid 29 --props 36:name,37:gender,38:birth,15:addr,16:degree,17:occupation,18:year_salary,19:is_risky,20:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --tag applicant --vid 29 --props 36:name,37:gender,38:birth,15:addr,16:degree,17:occupation,18:year_salary,19:is_risky,20:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --tag applicant --vid 29 --props 34:name,35:gender,36:birth,15:addr,16:degree,17:occupation,18:year_salary,19:is_risky,20:risk_comment --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --edge applied_for_loan --src 28 --dst 0 --props 8:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --edge applied_for_loan --src 28 --dst 0 --props 8:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --edge applied_for_loan --src 28 --dst 0 --props 8:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --edge applied_for_loan --src 28 --dst 0 --props 8:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_device.csv --edge applied_for_loan --src 29 --dst 14 --props 22:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_employer.csv --edge applied_for_loan --src 29 --dst 14 --props 22:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_phone_num.csv --edge applied_for_loan --src 29 --dst 14 --props 22:start_time --space fraud_detection
%ng_load --header --source https://github.com/wey-gu/awesome-graph-dataset/raw/main/datasets/fraud_detection/small/applicant_application_with_shared_via_employer_phone_num.csv --edge applied_for_loan --src 29 --dst 14 --props 22:start_time --space fraud_detection
The Nebula Importer is a tool for importing data from various data sources into NebulaGraph.
We provide a configuration file for the Nebula Importer(version: v3) to import the dataset.
Reference call command, assuming the configuration file is named importer.yaml
in your current directory:
# get the configuration file
# modify the configuration file according to your environment
# ls -l ./data/fraud_detection/
# ls -l importer.yaml
# run the importer
docker run --rm -ti \
-v ${PWD}/data/fraud_detection/:/data \
-v ${PWD}/importer.yaml:/root/importer_v3_config.yaml \
vesoft/nebula-importer:v3 \
-c /root/importer_v3_config.yaml