names

33 rows where place_id = 588619

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595078 1866094 1866094 defendant Baker John husbandman 588619 588619 Baker, John, of Somerleton, Suff, husbandman 0
3602487 1868439 1868439 defendant Oweden Thomas yeoman 588619 588619 Oweden, Thomas, of Somerleton, Suff, yeoman 1
3635111 1905781 1905781 defendant Copyldyke William clerk 588619 588619 Copyldyke, William, of Somerleton, Suff, clerk 0
3637371 1906494 1906494 defendant Palmer John gent 588619 588619 Palmer, John, of Somerleton, Suff, gent 0
3913259 1994764 1994764 defendant Hacon alias Crystmesse John clerk 588619 588619 Hacon alias Crystmesse, John, of Somerleton, Suff, clerk 0
4738459 2277119 2277119 defendant Baker John husbandman 588619 588619 Baker, John, of Somerleton, Suff, husbandman 0
4768710 2286191 2286191 defendant Oweden John chapman 588619 588619 Oweden, John, of Somerleton, Suff, chapman 4
4824388 2303688 2303688 defendant Hoo John yeoman 588619 588619 Hoo, John, of Somerleton, Suff, yeoman 1
4950296 2342058 2342058 plaintiff Kemster Thomas   588619 588619 Kemster, Thomas, of Somerleton, Suff 3
5237852 2426654 2426654 defendant Webster Roger husbandman 588619 588619 Webster, Roger, of Somerleton, Suff, husbandman 0
5248804 2429768 2429768 defendant Bakere John yeoman 588619 588619 Bakere, John, of Somerleton, Suff, yeoman 2
5257014 2432322 2432322 defendant Jernegan John, junior esq 588619 588619 Jernegan, John, junior, of Somerleton, Suff, esq 0
5265485 2434966 2434966 defendant Gernyngham alias Jernegan John gent 588619 588619 Gernyngham alias Jernegan, John, of Somerleton, Suff, or of Calais, gent 1
5265871 2435080 2435080 defendant Jernegam John esq 588619 588619 Jernegam, John, of Somerleton, Suff, esq 2
5266644 2435321 2435321 defendant Jernegan John esq 588619 588619 Jernegan, John, of Somerleton, Suff, esq 0
5267693 2435655 2435655 defendant Jernegan John, junior esq 588619 588619 Jernegan, John, junior, of Somerleton,Suff, esq 0
5272055 2436908 2436908 defendant Gernyngham John, junior gent 588619 588619 Gernyngham, John, junior, of Somerleton, Suff, gent 0
5272057 2436909 2436909 defendant Gernyngham John, junior gent 588619 588619 Gernyngham, John, junior, of Somerleton, Suff, gent 0
5272059 2436910 2436910 defendant Gernyngham John, junior gent 588619 588619 Gernyngham, John, junior, of Somerleton, Suff, gent 0
5272061 2436911 2436911 defendant Gernyngham John, junior gent 588619 588619 Gernyngham, John, junior, of Somerleton, Suff, gent 0
5272063 2436912 2436912 defendant Jernegan John, junior esq 588619 588619 Jernegan, John, junior, of Somerleton, Suff, esq 0
5272066 2436913 2436913 defendant Jernegan John, junior esq 588619 588619 Jernegan, John, junior, of Somerleton, Suff, esq 0
5338968 2456759 2456759 defendant Baker John yeoman 588619 588619 Baker, John, of Somerleton, Suff, yeoman 0
5376393 2468213 2468213 defendant Jernyngham John esq 588619 588619 Jernyngham, John, of Somerleton, Suff, esq 0
5398441 2474615 2474615 defendant Jernegan John, junior esq 588619 588619 Jernegan, John, junior, of Somerleton, Suff, esq 0
5402217 2475706 2475706 defendant Wellys Robert husbandman 588619 588619 Wellys, Robert, of Somerleton, Suff, husbandman 0
5492265 2502602 2502602 defendant Jernyngham alias Jernegan John, junior esq 588619 588619 Jernyngham alias Jernegan, John, junior, of Somerleton, Suff, esq 0
5492270 2502603 2502603 defendant Jernyngham or Jernegan John, junior esq 588619 588619 Jernyngham or Jernegan, John, junior, of Somerleton, Suff, esq 0
5520320 2511173 2511173 defendant Gernyngham Edward esq 588619 588619 Gernyngham, Edward, of Somerleton, Suff, esq 3
5533576 2515051 2515051 defendant Gernygan John esq 588619 588619 Gernygan, John, of Somerleton, Suff, esq 0
5572905 2526626 2526626 defendant Copyldyke William clerk 588619 588619 Copyldyke, William, of Somerleton, Suff, clerk 0
5572910 2526627 2526627 defendant Copyldyke William clerk 588619 588619 Copyldyke, William, of Somerleton, Suff, clerk 0
5572926 2526630 2526630 defendant Phelipp Robert husbandman 588619 588619 Phelipp, Robert, of Somerleton, Suff, husbandman 4

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