names

32 rows where place_id = 598240

✎ 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
3631687 1904724 1904724 defendant Tolle Robert yeoman 598240 598240 Tolle, Robert, of Croxston, yeoman 1
3671703 1917134 1917134 defendant West Thomas husbandman 598240 598240 West, Thomas, of Croxston, husbandman 2
3673980 1917900 1917900 defendant West Thomas husbandman 598240 598240 West, Thomas, of Croxston, husbandman 0
3690068 1923054 1923054 defendant West Thomas husbandman 598240 598240 West, Thomas, of Croxston, husbandman 0
3924823 1998621 1998621 defendant West William husbandman 598240 598240 West, William, of Croxston, husbandman 1
3965624 2012591 2012591 defendant Lewes Richard husbandman 598240 598240 Lewes, Richard, of Croxston, husbandman 0
3965625 2012591 2012591 defendant Shawe Thomas smith 598240 598240 Shawe, Thomas, of Croxston, smith 1
3965626 2012591 2012591 defendant Smarte John husbandman 598240 598240 Smarte, John, of Croxston, husbandman 2
4088002 2056004 2056004 defendant Halley James husbandman 598240 598240 Halley, James, of Croxston, husbandman 2
4192794 2093042 2093042 defendant Foliambe Godfrey esq 598240 598240 Foliambe, Godfrey, of Croxston, esq 0
4197804 2094786 2094786 defendant Foliambe Godfrey esq 598240 598240 Foliambe, Godfrey, of Croxston, esq 0
4638666 2242845 2242845 defendant Johanson Thomas   598240 598240 Johanson, Thomas, of Croxston 2
4756103 2282287 2282287 defendant Rodyng Walter   598240 598240 Rodyng, Walter, of Croxston, vicar 0
4756104 2282287 2282287 defendant Estmore John yeoman 598240 598240 Estmore, John, of Croxston, yeoman 1
4756105 2282287 2282287 defendant Reynald John yeoman 598240 598240 Reynald, John, of Croxston, yeoman 2
4929671 2335697 2335697 defendant Eston John   598240 598240 Eston, John, of Croxston, abbot 0
4951772 2342506 2342506 defendant Ratford William husbandman 598240 598240 Ratford, William, of Croxston, husbandman 2
5070161 2377570 2377570 defendant Tomlynson John, senior husbandman 598240 598240 Tomlynson, John, senior, of Croxston, husbandman 0
5187113 2411959 2411959 defendant Scotte Richard   598240 598240 Scotte, Richard, of Croxston, franklin 1
5214035 2419835 2419835 defendant Drury Adam laborer 598240 598240 Drury, Adam, of Croxston, laborer 0
5214036 2419835 2419835 defendant Drury Richard husbandman 598240 598240 Drury, Richard, of Croxston, husbandman 1
5214038 2419836 2419836 defendant Drury Adam laborer 598240 598240 Drury, Adam, of Croxston, laborer 0
5214039 2419836 2419836 defendant Drury Richard husbandman 598240 598240 Drury, Richard, of Croxston, husbandman 1
5219098 2421312 2421312 defendant Scotte Richard   598240 598240 Scotte, Richard, of Croxston, franklin 1
5258993 2432928 2432928 defendant Hoye John Alexander 598240 598240 Hoye, John, of Croxston, shepherd, son of Hoye, Alexander 0
5258994 2432928 2432928 defendant Hoye Alexander husbandman 598240 598240 Hoye, Alexander, of Croxston, husbandman 1
5365124 2464764 2464764 defendant Arghume John   598240 598240 Arghume, John, of Croxston, abbot of the monastery of Blessed Mary 0
5515355 2509647 2509647 plaintiff Peyke John   598240 598240 Peyke, John, of Croxston 1
5541299 2517394 2517394 defendant Drowery Richard husbandman 598240 598240 Drowery, Richard, of Croxston, husbandman 1
5560637 2523078 2523078 plaintiff Steyn William (legal representative) 598240 598240 Steyn, William, of Croxston, executors of 0
5595997 2533659 2533659 defendant Lucas William husbandman 598240 598240 Lucas, William, of Croxston, husbandman 0
5606861 2537034 2537034 defendant Kent William tailor 598240 598240 Kent, William, of Croxston, tailor 3

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