names

33 rows where place_id = 699409

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4128718 2070567 2070567 defendant Rushe Edmund husbandman 699409 699409 Rushe, Edmund, of Terrington St John, husbandman 0
4128721 2070567 2070567 defendant Kyde Geoffrey husbandman 699409 699409 Kyde, Geoffrey, of Terrington St John, husbandman 3
4137826 2073887 2073887 defendant Browne Anthony butcher 699409 699409 Browne, Anthony, of Terrington St John, butcher 0
4145049 2076429 2076429 defendant Burges Northen   699409 699409 Burges, Northen, of Terrington St John husbandman 2
4145053 2076430 2076430 defendant Brigg Northen husbandman 699409 699409 Brigg, Northen, of Terrington St John, husbandman 2
4163362 2082711 2082711 defendant Whincke John husbandman 699409 699409 Whincke, John, of Terrington St John, husbandman 0
4201433 2096048 2096048 defendant Boston Humphrey yeoman 699409 699409 Boston, Humphrey, of Terrington St John, yeoman 0
4211521 2099584 2099584 defendant Wyncke John husbandman 699409 699409 Wyncke, John, of Terrington St John, husbandman 1
4212761 2100003 2100003 defendant Layne Thomas clerk 699409 699409 Layne, Thomas, of Terrington St John, clerk 1
4222150 2103238 2103238 defendant Robynson John husbandman 699409 699409 Robynson, John, of Terrington St John, husbandman 1
4222151 2103238 2103238 defendant Medcalfe Geoffrey husbandman 699409 699409 Medcalfe, Geoffrey, of Terrington St John, husbandman 2
4222152 2103238 2103238 defendant Dawe Henry laborer 699409 699409 Dawe, Henry, of Terrington St John, laborer 3
4262181 2117023 2117023 defendant Cheveley Francis husbandman 699409 699409 Cheveley, Francis, of Terrington St John, husbandman 0
4274422 2121000 2121000 defendant Wyseman William husbandman 699409 699409 Wyseman, William, of Terrington St John, husbandman 0
4284561 2124527 2124527 defendant Boston Humphrey husbandman 699409 699409 Boston, Humphrey, of Terrington St John, husbandman 0
4290443 2126641 2126641 defendant Boston Humphrey yeoman 699409 699409 Boston, Humphrey, of Terrington St John, yeoman 0
4309997 2133654 2133654 defendant Wyseman William yeoman 699409 699409 Wyseman, William, of Terrington St John, yeoman 0
4318382 2136537 2136537 defendant Crowe John yeoman 699409 699409 Crowe, John, of Terrington St John, yeoman 0
4323284 2138205 2138205 defendant Skotton John (legal representative) 699409 699409 Skotton, John, of Terrington St John, yeoman, executors of 0
4323285 2138205 2138205 defendant Gregorye Guy husbandman 699409 699409 (Gregorye, Guy, of Terrington St John, husbandman 1
4335941 2142303 2142303 defendant Meadowe John husbandman 699409 699409 Meadowe, John, of Terrington St John, husbandman 0
4335942 2142303 2142303 defendant Roome Robert husbandman 699409 699409 together with Roome, Robert, of Terrington St John, husbandman 1
4335944 2142304 2142304 defendant Roome Robert husbandman 699409 699409 Roome, Robert, of Terrington St John, husbandman 0
4335945 2142304 2142304 defendant Meadowe John husbandman 699409 699409 together with Meadowe, John, of Terrington St John, husbandman 1
4346977 2146194 2146194 defendant Thacker Robert husbandman 699409 699409 Thacker, Robert, of Terrington St John, husbandman 0
4362840 2151770 2151770 defendant Farthing Thomas yeoman 699409 699409 Farthing, Thomas, of Terrington St John, yeoman 0
4376993 2156843 2156843 defendant Crowe John butcher 699409 699409 Crowe, John, of Terrington St John, butcher 0
4383934 2159331 2159331 defendant Wyseman William yeoman 699409 699409 Wyseman, William, of Terrington St John, yeoman 0
4389405 2161082 2161082 defendant Farthing Thomas yeoman 699409 699409 Farthing, Thomas, of Terrington St John, yeoman 0
4392503 2162114 2162114 defendant Harvy Robert yeoman 699409 699409 Harvy, Robert, of Terrington St John, yeoman 0
4392638 2162157 2162157 defendant Walbott James yeoman 699409 699409 Walbott, James, of Terrington St John, yeoman 0
4393223 2162339 2162339 defendant Mower John husbandman 699409 699409 Mower, John, of Terrington St John, husbandman 3
4406282 2166666 2166666 defendant Crowe John butcher 699409 699409 Crowe, John, of Terrington St John, butcher 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);