names

27 rows where place_id = 766626

✎ 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
4530008 2209675 2209675 defendant Symmeson Robert   766626 766626 Symmeson, Robert, of Wynfeld 0
4530009 2209675 2209675 defendant Colman Robert   766626 766626 Colman, Robert, of Wynfeld 1
4530010 2209675 2209675 defendant Colmen Richard   766626 766626 Colmen, Richard, of Wynfeld 2
4601278 2231634 2231634 defendant Yevele John   766626 766626 Yevele, John, of Wynfeld, parson 0
4713708 2269609 2269609 defendant Colman Richard tanner 766626 766626 Colman, Richard, of Wynfeld, tanner 1
4820081 2302358 2302358 defendant Merston John husbandman 766626 766626 Merston, John, of Wynfeld, husbandman 2
4894781 2325037 2325037 defendant Osberne Thomas   766626 766626 Osberne, Thomas, of Wynfeld, shepherd 0
4937777 2338198 2338198 defendant Raulynson alias Wodehous Thomas husbandman 766626 766626 Raulynson alias Wodehous, Thomas, of Wynfeld, husbandman 0
5001011 2357173 2357173 defendant Dod William yeoman 766626 766626 Dod, William, of Wynfeld, yeoman 3
5009837 2359753 2359753 plaintiff Ulgerthorp John   766626 766626 Ulgerthorp, John, of Wynfeld 0
5017019 2361872 2361872 defendant Busshe Thomas husbandman 766626 766626 Busshe, Thomas, of Wynfeld, husbandman 0
5017022 2361872 2361872 defendant Busshe William husbandman 766626 766626 Busshe, William, of Wynfeld, husbandman 3
5059096 2374285 2374285 defendant North Richard   766626 766626 North, Richard, of Wynfeld, mason 0
5064324 2375876 2375876 defendant Wodehouse Thomas husbandman 766626 766626 Wodehouse, Thomas, of Wynfeld, husbandman 2
5064340 2375880 2375880 defendant Wodehouse Thomas husbhandman 766626 766626 Wodehouse, Thomas, of Wynfeld, husbhandman 2
5073214 2378477 2378477 plaintiff Ulkerthorp John   766626 766626 Ulkerthorp, John, of Wynfeld 0
5091272 2383848 2383848 plaintiff Naden John   766626 766626 Naden, John, of Wynfeld 0
5118697 2391898 2391898 defendant Bynfeld Thomas husbandman 766626 766626 Bynfeld, Thomas, of Wynfeld, husbandman 4
5140078 2398198 2398198 defendant Wodhous Robert husbandman 766626 766626 Wodhous, Robert, of Wynfeld, husbandman 2
5140080 2398198 2398198 defendant Blake John husbandman 766626 766626 Blake, John, of Wynfeld, husbandman 4
5161105 2404346 2404346 defendant Blake John husbandman 766626 766626 Blake, John, of Wynfeld, husbandman 4
5197028 2414873 2414873 defendant Wodhous Robert husbandman 766626 766626 Wodhous, Robert, of Wynfeld, husbandman 2
5197030 2414873 2414873 defendant Blake John husbandman 766626 766626 Blake, John, of Wynfeld, husbandman 4
5266788 2435366 2435366 defendant Hall John husbandman 766626 766626 Hall, John, of Wynfeld, husbandman 0
5361948 2463762 2463762 defendant Hille William yeoman 766626 766626 Hille, William, of Wynfeld, yeoman 0
5482667 2499761 2499761 defendant Barshire Richard husbandman 766626 766626 Barshire, Richard, of Wynfeld, husbandman 0
5632784 2554267 2554267 defendant Cliderowe Richard esq 766626 766626 Cliderowe, Richard, of Wynfeld, esq 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);