names

24 rows where place_id = 586285

✎ 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
3588358 1864009 1864009 defendant Blofeld Andrew laborer 586285 586285 Blofeld, Andrew, of North Reppys, laborer 0
3674223 1917977 1917977 defendant Gray William husbandman 586285 586285 Gray, William, of North Reppys, husbandman 2
3682442 1920609 1920609 defendant Wursted William husbandman 586285 586285 Wursted, William, of North Reppys, husbandman 3
3699966 1926222 1926222 plaintiff Aleyn Thomas   586285 586285 Aleyn, Thomas, of North Reppys 0
3699968 1926223 1926223 plaintiff Aleyn Thomas   586285 586285 Aleyn, Thomas, of North Reppys 0
3702271 1926967 1926967 defendant Howard Robert mariner 586285 586285 Howard, Robert, of North Reppys, mariner 1
3729289 1935411 1935411 defendant Grey William, junior husbandman 586285 586285 Grey, William, junior, of North Reppys, husbandman 0
3734917 1937159 1937159 defendant Archer Robert husbandman 586285 586285 Archer, Robert, of North Reppys, husbandman 1
4882573 2321458 2321458 defendant Clerk Adam husbandman 586285 586285 Clerk, Adam, of North Reppys, husbandman 1
4904446 2328002 2328002 defendant Clerk Adam husbandman 586285 586285 Clerk, Adam, of North Reppys, husbandman 1
5004821 2358306 2358306 defendant Blofeld Thomas husbandman 586285 586285 Blofeld, Thomas, of North Reppys, husbandman 1
5009135 2359554 2359554 defendant Roke Nicholas weaver 586285 586285 Roke, Nicholas, of North Reppys, weaver 0
5009136 2359554 2359554 defendant Wenche William husbandman 586285 586285 Wenche, William, of North Reppys, husbandman 1
5069207 2377285 2377285 defendant Blofeld Thomas husbandman 586285 586285 Blofeld, Thomas, of North Reppys, husbandman 1
5069215 2377286 2377286 defendant Blofeld alias Gerveys Thomas husbandman 586285 586285 Blofeld alias Gerveys, Thomas, of North Reppys, husbandman 1
5135431 2396873 2396873 defendant Payn John husbandman 586285 586285 Payn, John, of North Reppys, husbandman 1
5155679 2402819 2402819 defendant Payn John husbandman 586285 586285 Payn, John, of North Reppys, husbandman 1
5163627 2405098 2405098 defendant Calke Thomas husbandman 586285 586285 Calke, Thomas, of North Reppys, husbandman 4
5291308 2442462 2442462 plaintiff Playford Robert clerk 586285 586285 Playford, Robert, of North Reppys, clerk 0
5313833 2449165 2449165 defendant Fryer John husbandman 586285 586285 Fryer, John, of North Reppys, husbandman 0
5410852 2478196 2478196 defendant Turnyn Thomas laborer 586285 586285 Turnyn, Thomas, of North Reppys, laborer 0
5578550 2528361 2528361 defendant Blakeman Richard husbandman 586285 586285 Blakeman, Richard, of North Reppys, husbandman 6
5588734 2531488 2531488 defendant Playford John yeoman 586285 586285 Playford, John, of North Reppys, yeoman 2
5593253 2532871 2532871 defendant Cromfrey John clerk 586285 586285 Cromfrey, John, of North Reppys, clerk 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);