names

20 rows where place_id = 597243

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627800 1903554 1903554 defendant Talface Robert husbandman 597243 597243 Talface, Robert, of Matsale, husbandman 0
3629377 1904043 1904043 defendant Ayleff John laborer 597243 597243 Ayleff, John, of Matsale, laborer 16
3657790 1912689 1912689 plaintiff Den Geoffrey (legal representative) 597243 597243 Den, Geoffrey, of Matsale, executor of 0
3657792 1912689 1912689 defendant Leneryngton John husbandman 597243 597243 Leneryngton, John, of Matsale, husbandman 0
3657793 1912689 1912689 defendant Laws Gustave miller 597243 597243 Laws, Gustave, of Matsale, miller 1
3769470 1948111 1948111 defendant Aylyff Thomas yeoman 597243 597243 Aylyff, Thomas, of Matsale, yeoman 0
3855547 1975378 1975378 plaintiff Wattys William   597243 597243 Wattys, William, of Matsale 0
3877061 1982569 1982569 defendant Davy Thomas butcher 597243 597243 Davy, Thomas, of Matsale, butcher 0
3947231 2006098 2006098 defendant Man William husbandman 597243 597243 Man, William, of Matsale, husbandman 0
3968633 2013667 2013667 defendant Hall Simon husbandman 597243 597243 (Hall, Simon, of Matsale, husbandman 1
4037961 2038224 2038224 defendant Watt Roger yeoman 597243 597243 Watt, Roger, of Matsale, yeoman 0
4053926 2043781 2043781 defendant Wattes John, junior singleman 597243 597243 Wattes, John, junior, of Matsale, husbandman, singleman 3
5188940 2412501 2412501 defendant Plomme Simon husbandman 597243 597243 Plomme, Simon, of Matsale, husbandman 0
5188941 2412501 2412501 defendant Coo John husbandman 597243 597243 Coo, John, of Matsale, husbandman 1
5188942 2412501 2412501 defendant Leveryngton William husbandman 597243 597243 Leveryngton, William, of Matsale, husbandman 2
5188943 2412501 2412501 defendant Harleston Thomas husbandman 597243 597243 Harleston, Thomas, of Matsale, husbandman 3
5578155 2528239 2528239 plaintiff Adams Thomas   597243 597243 Adams, Thomas, of Matsale 0
5578158 2528239 2528239 defendant Love Thomas husbandman 597243 597243 Love, Thomas, of Matsale, husbandman 2
5585980 2530663 2530663 defendant Marteyn Alexander husbandman 597243 597243 Marteyn, Alexander, of Matsale, husbandman 10
5590536 2532008 2532008 defendant Lans Eustace husbandman 597243 597243 Lans, Eustace, of Matsale, husbandman 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);