names

25 rows where place_id = 607326

✎ 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
3668753 1916162 1916162 defendant Holle John husbandman 607326 607326 Holle, John, of Morecote, husbandman 0
3894397 1988342 1988342 defendant Borcher Thomas yeoman 607326 607326 Borcher, Thomas, of Morecote, yeoman 1
4153209 2079220 2079220 defendant Goodyere Nicholas tanner 607326 607326 Goodyere, Nicholas, of Morecote, tanner 0
4297239 2129119 2129119 defendant Renoles John yeoman 607326 607326 Renoles, John, of Morecote, yeoman 1
4604117 2232455 2232455 defendant Laxton William   607326 607326 Laxton, William, of Morecote 0
4670295 2256415 2256415 defendant Wryght William yeoman 607326 607326 Wryght, William, of Morecote, yeoman 1
4840512 2308574 2308574 defendant Whitmay John husbandman 607326 607326 Whitmay, John, of Morecote, husbandman 0
4857865 2313826 2313826 defendant Whitemay John laborer 607326 607326 Whitemay, John, of Morecote, laborer 0
4887021 2322787 2322787 defendant Berd John husbandman 607326 607326 Berd, John, of Morecote, husbandman 3
4911128 2329992 2329992 defendant Swyft John yeoman 607326 607326 Swyft, John, of Morecote, yeoman 0
5054915 2373036 2373036 defendant Hogges Thomas husbandman 607326 607326 Hogges, Thomas, of Morecote, husbandman 0
5054916 2373036 2373036 defendant Felde Thomas smith 607326 607326 Felde, Thomas, of Morecote, smith 1
5054917 2373036 2373036 defendant Coklas John husbandman 607326 607326 Coklas, John, of Morecote, husbandman 2
5054919 2373036 2373036 defendant Hille Robert husbandman 607326 607326 Hille, Robert, of Morecote, husbandman 4
5054924 2373037 2373037 defendant Hogges Thomas husbandman 607326 607326 Hogges, Thomas, of Morecote, husbandman 0
5054925 2373037 2373037 defendant Felde Thomas smith 607326 607326 Felde, Thomas, of Morecote, smith 1
5054926 2373037 2373037 defendant Cokkes John husbandman 607326 607326 Cokkes, John, of Morecote, husbandman 2
5054928 2373037 2373037 defendant Hille Robert husbandman 607326 607326 Hille, Robert, of Morecote, husbandman 4
5057536 2373823 2373823 defendant Freman Richard butcher 607326 607326 Freman, Richard, of Morecote, butcher 4
5064205 2375835 2375835 defendant Pers William husbandman 607326 607326 Pers, William, of Morecote, husbandman 0
5119013 2391997 2391997 defendant None Thomas husbandman 607326 607326 None, Thomas, of Morecote, husbandman 0
5119014 2391997 2391997 defendant None Hugh husbandman 607326 607326 None, Hugh, of Morecote, husbandman 1
5219299 2421366 2421366 defendant Huggys Thomas husbandman 607326 607326 Huggys, Thomas, of Morecote, husbandman 0
5548586 2519628 2519628 defendant Pope Richard tucker 607326 607326 Pope, Richard, of Morecote, tucker 4
5627532 2552582 2552582 defendant Truyt Thomas husbandman 607326 607326 Truyt, Thomas, of Morecote, husbandman 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);