names

30 rows where place_id = 639228

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3847721 1972859 1972859 defendant Toly Thomas husbandman 639228 639228 Toly, Thomas, of Byrston, husbandman 0
3952941 2008098 2008098 defendant Catys Thomas husbandman 639228 639228 Catys, Thomas, of Byrston, yeoman, son of Thomas Catys, of Byrston, husbandman 0
3954423 2008616 2008616 defendant Toley Thomas yeoman 639228 639228 Toley, Thomas, of Byrston, yeoman 0
3954425 2008617 2008617 defendant Toley Thomas yeoman 639228 639228 Toley, Thomas, of Byrston, yeoman 0
4052122 2043180 2043180 defendant Yarham Robert husbandman 639228 639228 Yarham, Robert, of Byrston, husbandman 7
4052135 2043181 2043181 defendant Yarham Robert husbandman 639228 639228 Yarham, Robert, of Byrston, husbandman 8
4072456 2050453 2050453 defendant Johnson John gent 639228 639228 Johnson, John, of Byrston, gent 0
4109484 2063654 2063654 defendant Cates John yeoman 639228 639228 Cates, John, of Byrston, yeoman 0
4113399 2065063 2065063 defendant Crogate William husbabdnman 639228 639228 Crogate, William, of Byrston, husbabdnman 0
4113400 2065063 2065063 defendant Broun Thomas husbandman 639228 639228 Broun, Thomas, of Byrston, husbandman 1
4113402 2065064 2065064 defendant Tolke Richard husbandman 639228 639228 Tolke, Richard, of Byrston, husbandman 0
4113403 2065064 2065064 defendant Hubberd Robert husbandman 639228 639228 Hubberd, Robert, of Byrston, husbandman 1
4227845 2105220 2105220 defendant Buttell Walter yeoman 639228 639228 Buttell, Walter, of Byrston, yeoman 3
4228627 2105496 2105496 defendant Reymers John husbandman 639228 639228 Reymers, John, of Byrston, husbandman 1
4242997 2110653 2110653 defendant Shyppe George thatcher 639228 639228 Shyppe, George, of Byrston, thatcher 0
4242998 2110653 2110653 defendant Coffer John yeoman 639228 639228 together with Coffer, John, of Byrston, yeoman 1
4253193 2114063 2114063 defendant Shippe George thatcher 639228 639228 Shippe, George, of Byrston, thatcher 0
4313011 2134674 2134674 defendant Goslinge John yeoman 639228 639228 Goslinge, John, of Byrston, yeoman 0
4317668 2136290 2136290 defendant Fulcher Leonard weaver 639228 639228 Fulcher, Leonard, of Byrston, weaver 3
4321399 2137576 2137576 defendant Fulcher Leonard weaver 639228 639228 Fulcher, Leonard, of Byrston, weaver 0
4323595 2138308 2138308 defendant Fulcher Leonard yeoman 639228 639228 Fulcher, Leonard, of Byrston, yeoman 0
4857174 2313628 2313628 defendant Everard John butcher 639228 639228 Everard, John, of Byrston, butcher 1
4942632 2339667 2339667 defendant Kyng Roger thatcher 639228 639228 Kyng, Roger, of Byrston, thatcher 0
4990711 2354132 2354132 defendant Sawer John fuller 639228 639228 Sawer, John, of Byrston, fuller 0
5069269 2377296 2377296 defendant Bully John husbandman 639228 639228 Bully, John, of Byrston, husbandman 1
5391592 2472665 2472665 defendant Bully Thomas carpenter 639228 639228 Bully, Thomas, of Byrston, carpenter 4
5391597 2472665 2472665 defendant Santon William (legal representative) 639228 639228 Santon, William, of Byrston, clerk, administrator of 9
5404612 2476394 2476394 defendant Bully Thomas carpenter 639228 639228 Bully, Thomas, of Byrston, carpenter 4
5404617 2476394 2476394 defendant Santon William (legal representative) 639228 639228 Santon, William, of Byrston, clerk, administrator of 9
5594152 2533148 2533148 defendant Toly Robert husbandman 639228 639228 Toly, Robert, of Byrston, husbandman 2

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