names

18 rows where place_id = 639514

✎ 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
3849374 1973403 1973403 defendant Wylkes John yeoman 639514 639514 Wylkes, John, of Wednesfeld, yeoman 0
3898584 1989734 1989734 defendant Wylkys Richard husbandman 639514 639514 Wylkys, Richard, of Wednesfeld, husbandman 1
4330940 2140648 2140648 defendant Burton William yeoman 639514 639514 Burton, William, of Wednesfeld, yeoman 2
4443178 2182827 2182827 defendant Boys William   639514 639514 Boys, William, of Wednesfeld 2
4467394 2190484 2190484 plaintiff atte Wode Nicholas   639514 639514 atte Wode, Nicholas, of Wednesfeld, son of William 0
4467396 2190485 2190485 plaintiff atte Wode Nicholas   639514 639514 atte Wode, Nicholas, of Wednesfeld, son of William 0
4707354 2267677 2267677 defendant Bone William husbandman 639514 639514 Bone, William, of Wednesfeld, husbandman 2
4772814 2287467 2287467 defendant Cokkes Richard yeoman 639514 639514 Cokkes, Richard, of Wednesfeld, yeoman 0
4827371 2304609 2304609 plaintiff Wylkys Clement   639514 639514 Wylkys, Clement, of Wednesfeld 0
4828701 2305019 2305019 defendant Waters Nicholas husbandman 639514 639514 Waters, Nicholas, of Wednesfeld, husbandman 0
4828702 2305019 2305019 defendant Waters Gillian widow 639514 639514 Waters, Gillian, of Wednesfeld, widow 1
4828705 2305020 2305020 defendant Waters Nicholas husbandman 639514 639514 Waters, Nicholas, of Wednesfeld, husbandman 0
4828706 2305020 2305020 defendant Waters Gillian widow 639514 639514 Waters, Gillian, of Wednesfeld, widow 1
4828712 2305023 2305023 defendant Aleyn William husbandman 639514 639514 Aleyn, William, of Wednesfeld, husbandman 0
4828713 2305023 2305023 defendant Waters Nicholas husbandman 639514 639514 Waters, Nicholas, of Wednesfeld, husbandman 1
5063608 2375648 2375648 defendant Walle Nicholas laborer 639514 639514 Walle, Nicholas, of Wednesfeld, laborer 0
5080546 2380671 2380671 defendant Necheles William   639514 639514 Necheles, William, of Wednesfeld 6
5089188 2383208 2383208 defendant Wode John husbandman 639514 639514 Wode, John, of Wednesfeld, husbandman 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);