热门 Skills
中文
English 简体中文 français

搜索

PythonReactSEOPDF
OpenClaw

Ng Lawyer Db Build

NG Lawyer DB Build Step 1

gfly0424-maker0 来源安装数☆ 0 仓库 Stars
查看来源 ↗安装与使用SKILL.md ↗

安装与使用

请根据来源仓库和你的 AI 工具说明安装此技能。先阅读技能文件和依赖要求，再添加到工作流。

SkillHub CLI

skillhub install gfly0424-maker/ng-lawyer-db-build

打开来源仓库，查看说明和兼容环境后，按来源提供的命令或步骤安装。

将来源链接提供给你的 Agent，让它先读取说明、核对依赖，并向你说明将执行的安装步骤。

查看来源 ↗使用指南

技能说明

NG Lawyer DB Build (Step 1)

What this skill does

This is Step 1 of Fei Gao’s “Nigeria Lawyer Network” workflow:

  1. Build a Lawyer Database (this skill)
  2. Send outreach emails and score by response (separate skill)
  3. Sort & export for fast lookup (separate skill)

The objective is to create a database that allows fast matching by: City → Practice → Sub-specialty → Regulator → Firm size → Position → Score → Contact.

This skill focuses on data collection + structured classification with evidence links.

Inputs

  • city: Lagos | Abuja
  • practice: Construction | RealEstate | Labour | Tax | Criminal | IP
  • n_per_segment: integer (target 3)

Output files

  • lawyer_db_ng.xlsx (main database)
  • sources.jsonl (evidence per record: url + snippet + timestamp)

Database schema (fixed column order)

The Excel must contain columns in this exact order:

  1. Lawyer_UID
  2. Country
  3. City
  4. Practice
  5. Sub_Practice
  6. Regulator_Tag
  7. Firm_Name
  8. Firm_Size
  9. Position
  10. Lawyer_Name
  11. Email
  12. Phone
  13. LinkedIn
  14. Website
  15. Evidence_URL
  16. Score_Total (blank in Step 1)
  17. Score_ResponseSpeed (blank)
  18. Score_Detail (blank)
  19. Score_Pricing (blank)
  20. Score_Cooperation (blank)
  21. Risk_Flag (blank)
  22. NeedFollowUp (0/1)
  23. ChannelCostRisk (Low/Medium/High)
  24. Last_Updated

Non-negotiable rules (to avoid future scoring chaos)

1) Unique key (Lawyer_UID)

All later scoring MUST be written back by Lawyer_UID, never by name.

Format:

  • LAW-NG-{CITYCODE}-{PRACTICECODE}-{NNNN}
  • CityCode: Lagos=LAG, Abuja=ABJ
  • PracticeCode: Construction=CON, RealEstate=REA, Labour=LAB, Tax=TAX, Criminal=CRI, IP=IPR

Example:

  • LAW-NG-LAG-CON-0001
2) Email policy (anti-channel-cost)
  • Email must be explicitly published on the evidence page (law firm bio page, author page, or official profile).
  • NO guessing (e.g., firstname...

来源信息

Source
github
Repository
openclaw/skills
Path
skills/gfly0424-maker/ng-lawyer-db-build
Version
—
Commit
8fd68b4a91346bd8c2dd789be1443cccfbe08054
分类来源
rules
状态
active
可见性
public

这些信息来自收录时的来源分析，可能滞后；使用前请核对最新来源文件。

README ↗

README

NG Lawyer DB Build — Step 1 skill for building Nigeria lawyer database with evidence-backed contacts.

来源内容

SKILL.md
# NG Lawyer DB Build (Step 1)

## What this skill does
This is **Step 1** of Fei Gao’s “Nigeria Lawyer Network” workflow:
1) Build a **Lawyer Database** (this skill)  
2) Send outreach emails and score by response (separate skill)  
3) Sort & export for fast lookup (separate skill)

The objective is to create a database that allows **fast matching** by:
**City → Practice → Sub-specialty → Regulator → Firm size → Position → Score → Contact**.

This skill focuses on **data collection + structured classification** with evidence links.

---

## Inputs
- **city**: `Lagos` | `Abuja`
- **practice**: `Construction` | `RealEstate` | `Labour` | `Tax` | `Criminal` | `IP`
- **n_per_segment**: integer (target **3**)

---

## Output files
- **lawyer_db_ng.xlsx** (main database)
- **sources.jsonl** (evidence per record: url + snippet + timestamp)

---

## Database schema (fixed column order)
The Excel must contain columns in this exact order:

1. Lawyer_UID  
2. Country  
3. City  
4. Practice  
5. Sub_Practice  
6. Regulator_Tag  
7. Firm_Name  
8. Firm_Size  
9. Position  
10. Lawyer_Name  
11. Email  
12. Phone  
13. LinkedIn  
14. Website  
15. Evidence_URL  
16. Score_Total (blank in Step 1)  
17. Score_ResponseSpeed (blank)  
18. Score_Detail (blank)  
19. Score_Pricing (blank)  
20. Score_Cooperation (blank)  
21. Risk_Flag (blank)  
22. NeedFollowUp (0/1)  
23. ChannelCostRisk (Low/Medium/High)  
24. Last_Updated

---

## Non-negotiable rules (to avoid future scoring chaos)
### 1) Unique key (Lawyer_UID)
All later scoring MUST be written back by **Lawyer_UID**, never by name.

Format:
- `LAW-NG-{CITYCODE}-{PRACTICECODE}-{NNNN}`
- CityCode: Lagos=LAG, Abuja=ABJ
- PracticeCode: Construction=CON, RealEstate=REA, Labour=LAB, Tax=TAX, Criminal=CRI, IP=IPR

Example:
- `LAW-NG-LAG-CON-0001`

### 2) Email policy (anti-channel-cost)
- Email must be **explicitly published** on the evidence page (law firm bio page, author page, or official profile).
- **NO guessing** (e.g., firstname...
README
NG Lawyer DB Build — Step 1 skill for building Nigeria lawyer database with evidence-backed contacts.

相关技能

OpenClaw

1password

daggerkun007

Set up and use 1Password CLI (op). Use when installing the CLI, enabling desktop app integration, signing in (single or multi-account), or reading/injecting/running secrets via op.

☆ 0查看技能