names

28 rows where place_id = 749803

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4391407 2161742 2161742 defendant Hewes Philip glover 749803 749803 Hewes, Philip, of Stanlake, Oxon, glover 2
4396128 2163277 2163277 defendant Yates Bartholomew yeoman 749803 749803 Yates, Bartholomew, of Stanlake, Oxon, yeoman 0
4643378 2244169 2244169 defendant Halygrave John   749803 749803 Halygrave, John, of Stanlake, Oxon 0
4789613 2292822 2292822 defendant Walker John chapman 749803 749803 Walker, John, of Stanlake, Oxon, chapman 3
4794031 2294268 2294268 defendant Clerk John yeoman 749803 749803 Clerk, John, of Stanlake, Oxon, yeoman 0
4854898 2312885 2312885 defendant Payn Richard husbandman 749803 749803 Payn, Richard, of Stanlake, Oxon, husbandman 2
4991215 2354257 2354257 defendant Boton William chapman 749803 749803 Boton, William, of Stanlake, Oxon, chapman 0
5030658 2365835 2365835 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 0
5030850 2365892 2365892 defendant Walker William   749803 749803 Walker, William, of Stanlake, Oxon, franklin 4
5049303 2371422 2371422 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 1
5063469 2375600 2375600 defendant Bernard William woolman 749803 749803 Bernard, William, of Stanlake, Oxon, woolman 2
5081995 2381110 2381110 defendant Cornwayle John draper 749803 749803 Cornwayle, John, of Stanlake, Oxon, draper 0
5097057 2385572 2385572 defendant Westcote Philip chapman 749803 749803 Westcote, Philip, of Stanlake, Oxon, chapman 0
5117474 2391544 2391544 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 4
5117480 2391545 2391545 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 4
5135119 2396768 2396768 defendant Walker William yeoman 749803 749803 Walker, William, of Stanlake, Oxon, yeoman 0
5151697 2401655 2401655 defendant Gaunt John husbandman 749803 749803 Gaunt, John, of Stanlake, Oxon, husbandman 3
5179553 2409752 2409752 defendant Hore Thomas   749803 749803 Hore, Thomas, of Stanlake, Oxon, wool man 0
5180529 2410051 2410051 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 0
5186917 2411915 2411915 defendant Gaunt John husbandman 749803 749803 Gaunt, John, of Stanlake, Oxon, husbandman 2
5201938 2416332 2416332 defendant Hore Thomas   749803 749803 Hore, Thomas, of Stanlake, Oxon, wool man 0
5217416 2420829 2420829 defendant Hore Thomas chapman 749803 749803 Hore, Thomas, of Stanlake, Oxon, chapman 3
5222191 2422197 2422197 defendant Hore Thomas fisher 749803 749803 Hore, Thomas, of Stanlake, Oxon, fisher 1
5245665 2428890 2428890 defendant Walker William gent 749803 749803 Walker, William, of Stanlake, Oxon, gent 4
5254209 2431436 2431436 defendant Ludbroke John husbandman 749803 749803 Ludbroke, John, of Stanlake, Oxon, husbandman 1
5288449 2441642 2441642 defendant Gaunt John yeoman 749803 749803 Gaunt, John, of Stanlake, Oxon, yeoman 1
5324039 2452279 2452279 defendant Walker William (legal representative) 749803 749803 Walker, William, of Stanlake, Oxon, gent, executors of 3
5354531 2461492 2461492 defendant Gaunt Simon yeoman 749803 749803 Gaunt, Simon, of Stanlake, Oxon, 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);