names

17 rows where place_id = 637687

✎ 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
3837912 1969771 1969771 defendant Jeffrey John clothier 637687 637687 Jeffrey, John, of Lamberhurst, Sussex, clothier 2
3837918 1969772 1969772 defendant Jeffrey John clothier 637687 637687 Jeffrey, John, of Lamberhurst, Sussex, clothier 2
3881033 1983926 1983926 defendant Mugge William   637687 637687 Mugge, William, of Lamberhurst, Sussex, "rypyer" 0
3896470 1989024 1989024 defendant Freebody Henry yeoman 637687 637687 Freebody, Henry, of Lamberhurst, Sussex, yeoman 0
3904879 1991896 1991896 defendant Mugge William clothier 637687 637687 Mugge, William, of Lamberhurst, Sussex, clothier 0
4174933 2086698 2086698 defendant Collen Stephen yeoman 637687 637687 Collen, Stephen, of Lamberhurst, Sussex, yeoman 0
4642354 2243885 2243885 defendant Feryman John   637687 637687 Feryman, John, of Lamberhurst, Sussex 0
4642356 2243886 2243886 defendant Feryman John   637687 637687 Feryman, John, of Lamberhurst, Sussex 0
4760791 2283712 2283712 defendant Harlesey William husbandman 637687 637687 Harlesey, William, of Lamberhurst, Sussex, husbandman 14
4987235 2353131 2353131 defendant Mette William tailor 637687 637687 Mette, William, of Lamberhurst, Sussex, tailor 0
5150762 2401366 2401366 defendant Baker John baker 637687 637687 Baker, John, of Lamberhurst, Sussex, baker 2
5168847 2406618 2406618 defendant Baker John baker 637687 637687 Baker, John, of Lamberhurst, Sussex, baker 2
5297854 2444379 2444379 defendant Godfrey John   637687 637687 Godfrey, John, of Lamberhurst, Sussex, inland fish seller 2
5297856 2444380 2444380 defendant Godfrey John   637687 637687 Godfrey, John, of Lamberhurst, Sussex, inland fish seller 0
5465097 2494465 2494465 defendant Moyse John   637687 637687 Moyse, John, of Lamberhurst, Sussex, inland fish seller 1
5467601 2495238 2495238 defendant Godfrey John yeoman 637687 637687 Godfrey, John, of Lamberhurst, Sussex, yeoman 4
5629462 2553202 2553202 defendant Courthope John smith 637687 637687 Courthope, John, of Lamberhurst, Sussex, smith 1

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