names

23 rows where place_id = 687867

✎ 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
3806502 1959947 1959947 defendant Hopton Arthur   687867 687867 Hopton, Arthur, of Yoxford, Suff, knight 0
3961712 2011197 2011197 defendant Hopton Owen   687867 687867 Hopton, Owen, of Yoxford, Suff, knight 0
3961722 2011200 2011200 defendant Hopton Owen   687867 687867 Hopton, Owen, of Yoxford, Suff, knight 0
4073072 2050663 2050663 defendant Countays John tailor 687867 687867 Countays, John, of Yoxford, Suff, tailor 2
4087054 2055663 2055663 defendant Osborne Thomas husbandman 687867 687867 Osborne, Thomas, of Yoxford, Suff, husbandman 2
4121990 2068166 2068166 defendant Osborne Thomas husbandman 687867 687867 Osborne, Thomas, of Yoxford, Suff, husbandman 0
4124030 2068894 2068894 defendant Cryspe Mathew gent 687867 687867 Cryspe, Mathew, of Yoxford, Suff, gent 0
4166832 2083895 2083895 defendant Crispe Mathew gent 687867 687867 Crispe, Mathew, of Yoxford, Suff, gent 0
4172112 2085707 2085707 defendant Gybon Humphrey tailor 687867 687867 Gybon, Humphrey, of Yoxford, Suff, tailor 0
4185740 2090515 2090515 defendant Cryspe Mathew gent 687867 687867 Cryspe, Mathew, of Yoxford, Suff, gent 0
4190694 2092308 2092308 defendant Payne Thomas husbandman 687867 687867 Payne, Thomas, of Yoxford, Suff, husbandman 0
4195366 2093926 2093926 defendant Gybon Humphrey tailor 687867 687867 Gybon, Humphrey, of Yoxford, Suff, tailor 0
4198060 2094868 2094868 defendant Whinwery or Whinery Nicholas mercer 687867 687867 Whinwery or Whinery, Nicholas, of Yoxford, Suff, mercer 2
4205638 2097525 2097525 defendant Mells Arthur gent 687867 687867 Mells, Arthur, of Yoxford, Suff, gent 1
4253917 2114308 2114308 defendant Whynwery Nicholas yeoman 687867 687867 Whynwery, Nicholas, of Yoxford, Suff, yeoman 0
4278884 2122549 2122549 defendant Cresse Richard mercer 687867 687867 Cresse, Richard, of Yoxford, Suff, mercer 1
4281139 2123307 2123307 defendant Whynnerye Nicholas yeoman 687867 687867 Whynnerye, Nicholas, of Yoxford, Suff, yeoman 0
4284341 2124449 2124449 defendant Crispe Mathew (legal representative) 687867 687867 Crispe, Mathew, of Yoxford, Suff, gent, administrator of 0
4284345 2124450 2124450 defendant Crispe Mathew (legal representative) 687867 687867 Crispe, Mathew, of Yoxford, Suff, gent, administrator of 0
4400817 2164864 2164864 defendant Whynerye Nicholas yeoman 687867 687867 Whynerye, Nicholas, of Yoxford, Suff, yeoman 0
4787132 2292041 2292041 defendant Norwyche John gent 687867 687867 Norwyche, John, of Yoxford, Suff, gent 0
4936627 2337840 2337840 defendant Styward John yeoman 687867 687867 Styward, John, of Yoxford, Suff, yeoman 1
5561248 2523273 2523273 defendant Sydney Nicholas esq 687867 687867 Sydney, Nicholas, of Yoxford, Suff, esq 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);