names

38 rows where place_id = 606154

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664212 1914757 1914757 defendant Scoles Richard yeoman 606154 606154 Scoles, Richard, of Strelley, yeoman 0
3665527 1915170 1915170 defendant Scolys Richard yeoman 606154 606154 Scolys, Richard, of Strelley, yeoman 0
3665528 1915170 1915170 defendant Shetyll Roger smith 606154 606154 Shetyll, Roger, of Strelley, smith 1
3665529 1915170 1915170 defendant Weston Thomas collier 606154 606154 Weston, Thomas, of Strelley, collier 2
3665682 1915217 1915217 plaintiff Strelley Nicholas esq 606154 606154 Strelley, Nicholas, of Strelley, esq 0
3677096 1918875 1918875 defendant Strelley Nicholas esq 606154 606154 Strelley, Nicholas, of Strelley, esq 0
3756696 1944067 1944067 defendant Somoner Thomas clerk 606154 606154 Somoner, Thomas, of Strelley, clerk 9
3837841 1969750 1969750 plaintiff Strelley Nicholas   606154 606154 Strelley, Nicholas, of Strelley, knight 0
3846574 1972484 1972484 defendant Stirley Nicholas   606154 606154 Stirley, Nicholas, of Strelley, knight 0
3846575 1972484 1972484 defendant Styrley Percival gent 606154 606154 Styrley, Percival, of Strelley, gent 1
3846578 1972484 1972484 defendant Coke John yeoman 606154 606154 Coke, John, of Strelley, yeoman 4
3846579 1972484 1972484 defendant Clay Ralph yeoman 606154 606154 Clay, Ralph, of Strelley, yeoman 5
3846580 1972484 1972484 defendant Asshehurst Thomas yeoman 606154 606154 Asshehurst, Thomas, of Strelley, yeoman 6
3846581 1972484 1972484 defendant Armerers William furbisher 606154 606154 Armerers, William, of Strelley, furbisher 7
3846582 1972484 1972484 defendant Alleyn Robert yeoman 606154 606154 Alleyn, Robert, of Strelley, yeoman 8
3853963 1974877 1974877 defendant Strelley Nicholas   606154 606154 Strelley, Nicholas, of Strelley, knight 0
4257633 2115528 2115528 defendant Strelley Anthony (legal representative) 606154 606154 Strelley, Anthony, of Strelley, knight, executor of 0
4276345 2121671 2121671 defendant Strelley Philip esq 606154 606154 Strelley, Philip, of Strelley, esq 0
4308064 2132966 2132966 defendant Strelley Philip esq 606154 606154 Strelley, Philip, of Strelley, esq 0
4330559 2140516 2140516 defendant Jennynges Ralph yeoman 606154 606154 Jennynges, Ralph, of Strelley, yeoman 3
4721649 2272104 2272104 defendant Strelley Nicholas   606154 606154 Strelley, Nicholas, of Strelley, knight 0
4721652 2272105 2272105 defendant Strelley Nicholas   606154 606154 Strelley, Nicholas, of Strelley, knight 0
4793980 2294246 2294246 defendant Strelley Sampson gent 606154 606154 Strelley, Sampson, of Strelley, gent 1
4843233 2309403 2309403 defendant Strelley Richard gent 606154 606154 Strelley, Richard, of Strelley, gent 0
4905598 2328352 2328352 defendant Lenton William collier 606154 606154 Lenton, William, of Strelley, collier 1
5013546 2360803 2360803 defendant Strelley Robert esq 606154 606154 Strelley, Robert, of Strelley, esq 0
5017404 2361979 2361979 defendant Strelley Robert esq 606154 606154 Strelley, Robert, of Strelley, esq 0
5034626 2366987 2366987 defendant Glasier Roger glasier 606154 606154 Glasier, Roger, of Strelley, glasier 0
5091016 2383769 2383769 defendant Grene Henry yeoman 606154 606154 Grene, Henry, of Strelley, yeoman 0
5091018 2383770 2383770 defendant Strelley Robert esq 606154 606154 Strelley, Robert, of Strelley, esq 0
5122896 2393131 2393131 defendant Wastnes Ralph husbandman 606154 606154 Wastnes, Ralph, of Strelley, husbandman 3
5122897 2393131 2393131 defendant Coke William yeoman 606154 606154 Coke, William, of Strelley, yeoman 4
5301958 2445540 2445540 defendant Strelley Robert   606154 606154 Strelley, Robert, of Strelley, knight 0
5316233 2449940 2449940 defendant Strelley Robert   606154 606154 Strelley, Robert, of Strelley, knight 0
5333512 2455096 2455096 defendant Strelley Robert   606154 606154 Strelley, Robert, of Strelley, knight 0
5369040 2465911 2465911 defendant Strelley Robert   606154 606154 Strelley, Robert, of Strelley, knight 0
5532166 2514606 2514606 defendant Baker Richard gent 606154 606154 Baker, Richard, of Strelley, gent 1
5545964 2518811 2518811 plaintiff Strelley John (legal representative) 606154 606154 Strelley, John, of Strelley, esq, executrix of 0

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);