names

40 rows where place_id = 592225

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606987 1869848 1869848 defendant Salter Ralph gent 592225 592225 Salter, Ralph, of North Wotton, gent 0
3655569 1912003 1912003 defendant Salter Robert yeoman 592225 592225 Salter, Robert, of North Wotton, yeoman 1
3862948 1977804 1977804 defendant Salter William gent 592225 592225 Salter, William, of North Wotton, gent 0
3862953 1977805 1977805 defendant Barkham Robert   592225 592225 Barkham, Robert, of North Wotton, shepherd 3
3904464 1991740 1991740 plaintiff Hewar Arthur gent 592225 592225 Hewar, Arthur, of North Wotton, gent 0
3904466 1991741 1991741 plaintiff Hewar Arthur gent 592225 592225 Hewar, Arthur, of North Wotton, gent 0
3904470 1991742 1991742 plaintiff Hewar Arthur gent 592225 592225 Hewar, Arthur, of North Wotton, gent 0
3922533 1997852 1997852 defendant Plumsted Reginald husbandman 592225 592225 Plumsted, Reginald, of North Wotton, husbandman 0
3998001 2024044 2024044 plaintiff Estmond Peter husbandman 592225 592225 Estmond, Peter, of North Wotton, husbandman 0
4032661 2036332 2036332 defendant Donne or Doune Henry yeoman 592225 592225 Donne or Doune, Henry, of North Wotton, yeoman 0
4062673 2046948 2046948 defendant Slater Geoffrey yeoman 592225 592225 Slater, Geoffrey, of North Wotton, yeoman 2
4062674 2046948 2046948 defendant Donne or Doune Henry yeoman 592225 592225 Donne or Doune, Henry, of North Wotton, yeoman 3
4079862 2053099 2053099 defendant Slater Geoffrey husbandman 592225 592225 Slater, Geoffrey, of North Wotton, husbandman 2
4090313 2056819 2056819 defendant Clark John yeoman 592225 592225 Clark, John, of North Wotton, yeoman 0
4160565 2081772 2081772 defendant Slater Geoffrey yeoman 592225 592225 Slater, Geoffrey, of North Wotton, yeoman 0
4243762 2110895 2110895 defendant Wright John gent 592225 592225 Wright, John, of North Wotton, gent 0
4243767 2110896 2110896 defendant Wryght John gent 592225 592225 Wryght, John, of North Wotton, gent 0
4301697 2130713 2130713 defendant Backham John gent 592225 592225 Backham, John, of North Wotton, gent 0
4308177 2133008 2133008 defendant Snowke Henry husbandman 592225 592225 Snowke, Henry, of North Wotton, husbandman 0
4365301 2152654 2152654 defendant Dackombe or Dackeham John gent 592225 592225 Dackombe or Dackeham, John, of North Wotton, gent 0
4578395 2224731 2224731 plaintiff Clerk John   592225 592225 Clerk, John, of North Wotton 0
4578401 2224732 2224732 plaintiff Clerk John   592225 592225 Clerk, John, of North Wotton 0
4616664 2236213 2236213 defendant Borte Philip   592225 592225 Borte, Philip, of North Wotton 3
4719706 2271509 2271509 defendant Baret Thomas   592225 592225 Baret, Thomas, of North Wotton, vicar 4
4722197 2272267 2272267 plaintiff Clydrowe John   592225 592225 Clydrowe, John, of North Wotton 0
4782407 2290505 2290505 defendant Walsyngham Reginald (legal representative) 592225 592225 Walsyngham, Reginald, of North Wotton, husbandman, executors of 0
4782409 2290505 2290505 defendant Dykson Geoffrey husbandman 592225 592225 Dykson, Geoffrey, of North Wotton, husbandman 2
4782411 2290506 2290506 defendant Walsyngham Reginald (legal representative) 592225 592225 Walsyngham, Reginald, of North Wotton, husbandman, executors of 0
4782413 2290506 2290506 defendant Dykson Geoffrey husbandman 592225 592225 Dykson, Geoffrey, of North Wotton, husbandman 2
4827467 2304639 2304639 defendant Salter William yeoman 592225 592225 Salter, William, of North Wotton, yeoman 4
4968217 2347445 2347445 defendant Holley John yeoman 592225 592225 Holley, John, of North Wotton, yeoman 3
4977913 2350355 2350355 defendant Batayle Henry clerk 592225 592225 Batayle, Henry, of North Wotton, clerk 0
4982674 2351730 2351730 defendant Joye Walter laborer 592225 592225 Joye, Walter, of North Wotton, laborer 0
5008809 2359468 2359468 defendant Constabill John husbandman 592225 592225 Constabill, John, of North wotton, husbandman 1
5019259 2362524 2362524 defendant Fouler William husbandman 592225 592225 Fouler, William, of North Wotton, husbandman 6
5036259 2367457 2367457 defendant Fouler William fouler 592225 592225 Fouler, William, of North Wotton, fouler 2
5296331 2443916 2443916 defendant Shawe Robert husbandman 592225 592225 Shawe, Robert, of North Wotton, husbandman 0
5368623 2465782 2465782 defendant Hilbrond Richard, junior butcher 592225 592225 Hilbrond, Richard, junior, of North Wotton, butcher 1
5532363 2514665 2514665 defendant Salter Ralph gent 592225 592225 Salter, Ralph, of North Wotton, gent 0
5532365 2514666 2514666 defendant Salter Ralph gent 592225 592225 Salter, Ralph, of North Wotton, gent 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);