names

16 rows where place_id = 619648

✎ 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
3731122 1935959 1935959 defendant Holder William husbandman 619648 619648 Holder, William, of Stoughton, Hunts, husbandman 3
3776707 1950462 1950462 defendant Helder William husbandman 619648 619648 Helder, William, of Stoughton, Hunts, husbandman 3
3954362 2008597 2008597 defendant Baldwyn Thomas (legal representative) 619648 619648 Baldwyn, Thomas, of Stoughton, Hunts, gent, administratrix of 0
3963182 2011723 2011723 defendant Walton George gent 619648 619648 Walton, George, of Stoughton, Hunts, gent 0
3965455 2012532 2012532 plaintiff Cawncell Thomas gent 619648 619648 Cawncell, Thomas, of Stoughton, Hunts, gent 1
3970699 2014341 2014341 defendant Welton George gent 619648 619648 Welton, George, of Stoughton, Hunts, gent 1
3986086 2019795 2019795 plaintiff Webster John   619648 619648 Webster, John, of Stoughton, Hunts, servant of James Dyer, knight, Chief Justice 0
4026454 2034105 2034105 plaintiff Byrde John gent 619648 619648 Byrde, John, of Stoughton, Hunts, gent 0
4026456 2034106 2034106 plaintiff Byrde John gent 619648 619648 Byrde, John, of Stoughton, Hunts, gent 0
4090081 2056736 2056736 defendant Ethropp Thomas yeoman 619648 619648 Ethropp, Thomas, of Stoughton, Hunts, yeoman 1
4284328 2124444 2124444 defendant Carter George gent 619648 619648 Carter, George, of Stoughton, Hunts, gent 0
4576759 2224239 2224239 defendant Hanwode John   619648 619648 Hanwode, John, of Stoughton, Hunts 0
4785732 2291570 2291570 defendant Ibot Thomas chaplain 619648 619648 Ibot, Thomas, of Stoughton, Hunts, chaplain 1
4785736 2291571 2291571 defendant Ibot Thomas chaplain 619648 619648 Ibot, Thomas, of Stoughton, Hunts, chaplain 1
4943078 2339809 2339809 defendant Wanton or Wauton William esq 619648 619648 Wanton or Wauton, William, of Stoughton, Hunts, esq 3
5533937 2515156 2515156 defendant Wake John esq 619648 619648 Wake, John, of Stoughton, Hunts, esq 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);