names

27 rows where place_id = 622834

✎ 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
3749170 1941668 1941668 defendant Arteys John husbandman 622834 622834 Arteys, John, of Westhall, husbandman 0
3908252 1993057 1993057 defendant Calbere David yeoman 622834 622834 Calbere, David, of Westhall, yeoman 0
3951543 2007595 2007595 plaintiff Gyle Thomas yeoman 622834 622834 Gyle, Thomas, of Westhall, yeoman 0
3973615 2015343 2015343 plaintiff Gyle Thomas   622834 622834 Gyle, Thomas, of Westhall 0
4001078 2025163 2025163 defendant Clerk John weaver 622834 622834 Clerk, John, of Westhall, weaver 1
4041787 2039545 2039545 defendant Thurketyll Peter yeoman 622834 622834 Thurketyll, Peter, of Westhall, yeoman 0
4091239 2057157 2057157 defendant Richardson Bartholomew   622834 622834 Richardson, Bartholomew, of Westhall, millwright 0
4101992 2061021 2061021 defendant Clyfford Ursula widow 622834 622834 Clyfford, Ursula, of Westhall, widow 1
4137907 2073915 2073915 defendant Sadler Richard tailor 622834 622834 Sadler, Richard, of Westhall, tailor 0
4192861 2093067 2093067 defendant Stracheley Andrew gent 622834 622834 Stracheley, Andrew, of Westhall, or of Yevell, Soms, gent 0
4277013 2121893 2121893 defendant Base John gent 622834 622834 Base, John, of Westhall, gent 0
4277892 2122197 2122197 defendant Vase John gent 622834 622834 Vase, John, of Westhall, gent 0
4279079 2122613 2122613 defendant Kinge John yeoman 622834 622834 Kinge, John, of Westhall, yeoman 1
4279748 2122834 2122834 defendant Lambe Richard tailor 622834 622834 Lambe, Richard, of Westhall, tailor 0
4303732 2131432 2131432 defendant Lece Vincent yeoman 622834 622834 Lece, Vincent, of Westhall, yeoman 0
4335953 2142308 2142308 defendant Mercer George   622834 622834 Mercer, George, of Westhall yeoman 0
4399178 2164310 2164310 defendant Kinge John weaver 622834 622834 Kinge, John, of Westhall, weaver 0
4399180 2164311 2164311 defendant Kynge Robert weaver 622834 622834 Kynge, Robert, of Westhall, weaver 0
4606259 2233069 2233069 defendant Broun William   622834 622834 Broun, William, of Westhall 0
4988956 2353636 2353636 defendant Couper John cooper 622834 622834 Couper, John, of Westhall, cooper 0
4998477 2356423 2356423 defendant Codenam William husbandman 622834 622834 Codenam, William, of Westhall, husbandman 3
5132879 2396110 2396110 defendant Aylmer John, senior yeoman 622834 622834 Aylmer, John, senior, of Westhall, yeoman 3
5132880 2396110 2396110 defendant Aylmer John, junior yeoman 622834 622834 Aylmer, John,junior, of Westhall, yeoman 4
5153059 2402039 2402039 defendant Aylemer John, sen yeoman 622834 622834 Aylemer, John, sen, of Westhall, yeoman 2
5188406 2412324 2412324 defendant Aylemer John, sen yeoman 622834 622834 Aylemer, John, sen, of Westhall, yeoman 3
5389409 2472017 2472017 defendant Benet John (legal representative) 622834 622834 Benet, John, of Westhall, yeoman, executrix of 4
5389410 2472017 2472017 defendant Benet Stacy widow 622834 622834 Benet, Stacy, of Westhall, widow 5

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