names

19 rows where place_id = 758081

✎ 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
4451005 2185282 2185282 defendant Fynhawe William   758081 758081 Fynhawe, William, of Sedelescombe 1
4802891 2297092 2297092 defendant Beche Richard   758081 758081 Beche, Richard, of Sedelescombe 0
4902229 2327306 2327306 defendant Whyte Thomas husbandman 758081 758081 Whyte, Thomas, of Sedelescombe, husbandman 0
4918634 2332344 2332344 defendant atte Bourne Robert thatcher 758081 758081 atte Bourne, Robert, of Sedelescombe, thatcher 0
4918635 2332344 2332344 defendant Gefferay John husbandman 758081 758081 Gefferay, John, of Sedelescombe, husbandman 1
4918636 2332344 2332344 defendant Wayte Thomas   758081 758081 with Wayte, Thomas, of Sedelescombe, nail maker 2
4918638 2332345 2332345 defendant Wayte Thomas   758081 758081 Wayte, Thomas, of Sedelescombe, nail maker 0
4918640 2332345 2332345 defendant Geffray John husbandman 758081 758081 Geffray, John, of Sedelescombe, husbandman 2
4918642 2332346 2332346 defendant Wayte Thomas husbandman 758081 758081 Wayte, Thomas, of Sedelescombe, husbandman 0
4988313 2353474 2353474 plaintiff Bourner Robert   758081 758081 Bourner, Robert, of Sedelescombe 0
4988315 2353474 2353474 defendant Motay Edward laborer 758081 758081 Motay, Edward, of Sedelescombe, laborer 1
5010987 2360071 2360071 defendant Bysshop William husbandman 758081 758081 Bysshop, William, of Sedelescombe, husbandman 0
5185189 2411415 2411415 defendant Wayte Thomas   758081 758081 Wayte, Thomas, of Sedelescombe 0
5217632 2420890 2420890 defendant Bysshop Alexander husbandman 758081 758081 Bysshop, Alexander, of Sedelescombe, husbandman 29
5353151 2461063 2461063 defendant Moryse William husbandman 758081 758081 Moryse, William, of Sedelescombe, husbandman 1
5357634 2462459 2462459 defendant Grene Brian butcher 758081 758081 Grene, Brian, of Sedelescombe, butcher 1
5357636 2462459 2462459 defendant Knyght Thomas laborer 758081 758081 Knyght, Thomas, of Sedelescombe, laborer 3
5412804 2478781 2478781 defendant Beche William yeoman 758081 758081 Beche, William, of Sedelescombe, yeoman 0
5445221 2488464 2488464 defendant Beche William yeoman 758081 758081 Beche, William, of Sedelescombe, yeoman 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);