names

58 rows where place_id = 607973

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671715 1917137 1917137 defendant Foliambe Roger gent 607973 607973 Foliambe, Roger, of Walton, Derbs, gent 0
3687818 1922354 1922354 defendant Fuliambe Roger gent 607973 607973 Fuliambe, Roger, of Walton, Derbs, gent 0
3698971 1925888 1925888 defendant Fuliam Godfrey   607973 607973 Fuliam, Godfrey, of Walton, Derbs, knight 0
3733311 1936650 1936650 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
3757422 1944300 1944300 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3763369 1946171 1946171 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3764301 1946496 1946496 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3765820 1946975 1946975 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3770292 1948379 1948379 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3771320 1948721 1948721 defendant Bocher John chaplain 607973 607973 Bocher, John, of Walton, Derbs, chaplain 0
3909169 1993365 1993365 defendant Filiambe George   607973 607973 Filiambe, George, of Walton, Derbs, gent, son of Geoffrey Fuliamb, knight 0
3909179 1993367 1993367 defendant Dethyk William gent 607973 607973 Dethyk, William, of Walton, Derbs, gent 2
3909194 1993370 1993370 defendant Dethyk William   607973 607973 Dethyk, William, of Walton, Derbs, servant of James Fulgyam 3
3968681 2013684 2013684 defendant Lawe Anne widow 607973 607973 Lawe, Anne, of Walton, Derbs, widow 2
4120197 2067507 2067507 defendant Thacker Thomas gent 607973 607973 Thacker, Thomas, of Walton, Derbs, gent 0
4131212 2071484 2071484 defendant Fowlgambe Godfrey   607973 607973 Fowlgambe, Godfrey, of Walton, Derbs, knight 0
4150011 2078138 2078138 defendant Bramall alias Swindell James yeoman 607973 607973 Bramall alias Swindell, James, of Walton, Derbs, yeoman 0
4150015 2078140 2078140 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
4150502 2078307 2078307 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
4151996 2078807 2078807 defendant Folimabe Godfrey   607973 607973 Folimabe, Godfrey, of Walton, Derbs, knight 0
4156328 2080287 2080287 defendant Fuliambe Godfrey   607973 607973 Fuliambe, Godfrey, of Walton, Derbs, knight 0
4158424 2081017 2081017 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
4175268 2086816 2086816 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
4177513 2087612 2087612 defendant Fulgam Godfrey   607973 607973 Fulgam, Godfrey, of Walton, Derbs, knight 0
4190315 2092125 2092125 defendant Pannell Nicholas gent 607973 607973 Pannell, Nicholas, of Walton, Derbs, gent 0
4199776 2095472 2095472 defendant Foliambe Godfrey   607973 607973 Foliambe, Godfrey, of Walton, Derbs, knight 0
4253707 2114232 2114232 defendant Foliambe Godfrey esq 607973 607973 Foliambe, Godfrey, of Walton, Derbs, esq 0
4253710 2114233 2114233 defendant Foliambe Godfrey esq 607973 607973 Foliambe, Godfrey, of Walton, Derbs, esq 0
4253713 2114234 2114234 defendant Foliambe Godfrey esq 607973 607973 Foliambe, Godfrey, of Walton, Derbs, esq 0
4253716 2114235 2114235 defendant Folliambe Godfrey esq 607973 607973 Folliambe, Godfrey, of Walton, Derbs, esq 0
4334967 2141960 2141960 defendant Shenton John yeoman 607973 607973 Shenton, John, of Walton, Derbs, yeoman 0
4392793 2162208 2162208 defendant Foliambe Godfrey (legal representative) 607973 607973 Foliambe, Godfrey, of Walton, Derbs, esq, executor of Godfrey Foliambe, knight, executors of 0
4408431 2167396 2167396 defendant Fuliame Hercules esq 607973 607973 Fuliame, Hercules, of Walton, Derbs, esq 1
4677937 2258716 2258716 defendant Foliambe William gent 607973 607973 Foliambe, William, of Walton, Derbs, gent 0
4677940 2258717 2258717 defendant Foliambe William gent 607973 607973 Foliambe, William, of Walton, Derbs, gent 0
5013201 2360694 2360694 defendant Foliambe Thomas gent 607973 607973 Foliambe, Thomas, of Walton, Derbs, gent 1
5027246 2364840 2364840 defendant Turnour John husbandman 607973 607973 Turnour, John, of Walton, Derbs, husbandman 0
5254641 2431571 2431571 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 3
5316972 2450158 2450158 defendant Foliambe Henry gent 607973 607973 Foliambe, Henry, of Walton, Derbs, gent 3
5374358 2467583 2467583 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 0
5382986 2470202 2470202 defendant Foliambe Thomas (legal representative) 607973 607973 Foliambe, Thomas, of Walton, Derbs, administrator of 0
5382987 2470202 2470202 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1
5391077 2472519 2472519 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 0
5394174 2473394 2473394 defendant Foliambe Thomas (legal representative) 607973 607973 Foliambe, Thomas, of Walton, Derbs, esq, administrator of 0
5394178 2473395 2473395 defendant Foliambe Thomas (legal representative) 607973 607973 Foliambe, Thomas, of Walton, Derbs, esq, administrator of 0
5394179 2473395 2473395 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1
5400176 2475123 2475123 plaintiff Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1
5404017 2476224 2476224 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 0
5407315 2477155 2477155 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1
5417190 2480051 2480051 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 0
5420552 2481070 2481070 defendant Foliambe Thomas   607973 607973 Foliambe, Thomas, of Walton, Derbs, esq, adminstrator of 0
5439377 2486712 2486712 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1
5503087 2505874 2505874 defendant Foliambe Thomas (legal representative) 607973 607973 Foliambe, Thomas, of Walton, Derbs, esq, administrator of 0
5576761 2527776 2527776 defendant Dyson Robert yeoman 607973 607973 Dyson, Robert, of Walton, Derbs, yeoman 3
5576766 2527777 2527777 defendant Dyson Robert yeoman 607973 607973 Dyson, Robert, of Walton, Derbs, yeoman 3
5602596 2535705 2535705 defendant Fulyambe Godfrey esq 607973 607973 Fulyambe, Godfrey, of Walton, Derbs, esq 8
5609623 2537903 2537903 defendant Foliambe Thomas (legal representative) 607973 607973 Foliambe, Thomas, of Walton, Derbs, esq, administrator of 0
5609624 2537903 2537903 defendant Foliambe Henry esq 607973 607973 Foliambe, Henry, of Walton, Derbs, esq 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);