names

13 rows where case_id = 2291667

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4786015 2291667 2291667 plaintiff Forster William   589401 589401 Forster, William, of Scardeburgh 0
4786016 2291667 2291667 defendant Penok John husbandman 802178 802178 Penok, John, of Poton in Pykerynglyth, husbandman 0
4786017 2291667 2291667 defendant Tomson Richard husbandman 802179 802179 Tomson, Richard, of Wellerdby, husbandman 1
4786018 2291667 2291667 defendant Herpour John mercer 586854 586854 together with Herpour, John, of Bridlyngton, mercer 2
4786019 2291667 2291667 defendant Scotte John husbandman 755250 755250 Scotte, John, of Ulrom, husbandman 3
4786020 2291667 2291667 defendant Manger or Mauger Marmaduke husbandman 593265 593265 Manger or Mauger, Marmaduke, of Rigton, husbandman 4
4786021 2291667 2291667 defendant Wilson Gilbert husbandman 802180 802180 Wilson, Gilbert, of Fethyngham, husbandman 5
4786022 2291667 2291667 defendant Alanson John husbandman 608098 608098 Alanson, John, of Lounde, husbandman 6
4786023 2291667 2291667 defendant Danby William shipman 585932 585932 Danby, William, of Kingston on Hull, shipman 7
4786024 2291667 2291667 defendant Broune William tailor 604056 604056 Broune, William, of Hornse, tailor 8
4786025 2291667 2291667 defendant Wedoweson John husbandman 769361 769361 Wedoweson, John, of Hornse Burton, husbandman 9
4786026 2291667 2291667 defendant Bose William husbandman 604056 604056 Bose, William, of Hornse, husbandman 10
4786027 2291667 2291667 defendant Perisson John husbandman 589994 589994 Perisson, John, of Duffeld, husbandman 11

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