names

22 rows where place_id = 611284

✎ 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
3687733 1922331 1922331 defendant Aylard John yeoman 611284 611284 Aylard, John, of Alphyngton, yeoman 1
3808849 1960648 1960648 plaintiff Aylerd John, senior   611284 611284 Aylerd, John, senior, of Alphyngton 0
3808850 1960648 1960648 defendant Stone Richard husbandman 611284 611284 Stone, Richard, of Alphyngton, husbandman 0
3814356 1962402 1962402 defendant Medlond John husbandman 611284 611284 Medlond, John, of Alphyngton, husbandman 1
3822493 1964932 1964932 defendant Down John husbandman 611284 611284 Down, John, of Alphyngton, husbandman 0
3824897 1965666 1965666 defendant Elard John husbandman 611284 611284 Elard, John, of Alphyngton, husbandman 11
3840563 1970610 1970610 defendant Stoner Richard husbandman 611284 611284 Stoner, Richard, of Alphyngton, husbandman 0
3989220 2020884 2020884 defendant Tethyll Roger husbandman 611284 611284 Tethyll, Roger, of Alphyngton, husbandman 1
3997200 2023768 2023768 defendant Emett Thomas yeoman 611284 611284 Emett, Thomas, of Alphyngton, yeoman 1
3997907 2024011 2024011 defendant Trewe John yeoman 611284 611284 Trewe, John, of Alphyngton, yeoman 0
3997908 2024011 2024011 defendant Menesye Thomas yeoman 611284 611284 Menesye, Thomas, of Alphyngton, yeoman 1
3997909 2024011 2024011 defendant Myldon Richard laborer 611284 611284 Myldon, Richard, of Alphyngton, laborer 2
4009078 2028013 2028013 defendant Trewe John yeoman 611284 611284 Trewe, John, of Alphyngton, yeoman 0
4009079 2028013 2028013 defendant Menesye Thomas yeoman 611284 611284 Menesye, Thomas, of Alphyngton, yeoman 1
4009080 2028013 2028013 defendant Myldon Richard laborer 611284 611284 Myldon, Richard, of Alphyngton, laborer 2
4041667 2039509 2039509 defendant Mydwynter Michael yeoman 611284 611284 Mydwynter, Michael, of Alphyngton, yeoman 9
4042951 2039954 2039954 defendant Mydwynter Michael yeoman 611284 611284 Mydwynter, Michael, of Alphyngton, yeoman 0
4185348 2090387 2090387 defendant Collyns Geoffrey (legal representative) 611284 611284 Collyns, Geoffrey, of Alphyngton, gent, executors of 0
4213758 2100327 2100327 defendant Foureacres John yeoman 611284 611284 Foureacres, John, of Alphyngton, yeoman 0
4260372 2116437 2116437 defendant Peter alias Truman John yeoman 611284 611284 Peter alias Truman, John, of Alphyngton, yeoman 2
4436197 2176063 2176063 defendant Martyn Adam Exeter diocese 611284 611284 Martyn, Adam, of Alphyngton, Exeter diocese 0
5599380 2534692 2534692 defendant Fitz John husbandman 611284 611284 Fitz, John, of Alphyngton, husbandman 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);