names

36 rows where place_id = 592628

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608297 1870253 1870253 defendant Bowle Robert husbandman 592628 592628 Bowle, Robert, of Thurleton, husbandman 0
3608299 1870253 1870253 defendant Cater. Robert senior husbandman 592628 592628 Cater. Robert, senior, of Thurleton, husbandman 2
3615790 1872580 1872580 defendant Bowele Robert husbandman 592628 592628 Bowele, Robert, of Thurleton, husbandman 0
3693638 1924205 1924205 defendant Mekylburgh Edmund husbandman 592628 592628 Mekylburgh, Edmund, of Thurleton, husbandman 0
3707812 1928741 1928741 defendant Mott William carpenter 592628 592628 Mott, William, of Thurleton, carpenter 0
3758520 1944661 1944661 defendant Wegge Stephen husbandman 592628 592628 Wegge, Stephen, of Thurleton, husbandman 0
3762753 1945990 1945990 defendant Swetale John husbandman 592628 592628 Swetale, John, of Thurleton, husbandman 2
3779477 1951303 1951303 defendant Franke Richard husbandman 592628 592628 Franke, Richard, of Thurleton, husbandman 1
3801133 1958274 1958274 defendant Mottys William carpenter 592628 592628 Mottys, William, of Thurleton, carpenter 1
3810918 1961315 1961315 defendant Wegge Stephen husbandman 592628 592628 Wegge, Stephen, of Thurleton, husbandman 0
3852532 1974400 1974400 defendant Franke Richard husbandman 592628 592628 Franke, Richard, of Thurleton, husbandman 0
3974280 2015572 2015572 plaintiff Harvye Robert yeoman 592628 592628 Harvye, Robert, of Thurleton, yeoman 0
4003631 2026063 2026063 defendant Hornynge Nicholas husbandman 592628 592628 Hornynge, Nicholas, of Thurleton, husbandman 1
4239506 2109442 2109442 defendant Wales John husbandman 592628 592628 Wales, John, of Thurleton, husbandman 0
4239507 2109442 2109442 defendant Wales Anthony husbandman 592628 592628 Wales, Anthony, of Thurleton, husbandman 1
4261797 2116901 2116901 defendant Wales John yeoman 592628 592628 Wales, John, of Thurleton, yeoman 0
4261798 2116901 2116901 defendant Wales Gregory husbandman 592628 592628 Wales, Gregory, of Thurleton, husbandman 1
4261799 2116901 2116901 defendant Wales John husbandman 592628 592628 Wales, John, of Thurleton, husbandman 2
4261800 2116901 2116901 defendant Wales Anthony husbandman 592628 592628 Wales, Anthony, of Thurleton, husbandman 3
4291402 2127000 2127000 defendant Wales John yeoman 592628 592628 Wales, John, of Thurleton, yeoman 0
4291403 2127000 2127000 defendant Wales Gregory husbandman 592628 592628 Wales, Gregory, of Thurleton, husbandman 1
4291404 2127000 2127000 defendant Wales John husbandman 592628 592628 Wales, John, of Thurleton, husbandman 2
4291405 2127000 2127000 defendant Wales Anthony husbandman 592628 592628 Wales, Anthony, of Thurleton, husbandman 3
4351696 2147836 2147836 defendant Burrowe Richard yeoman 592628 592628 Burrowe, Richard, of Thurleton, yeoman 1
4736690 2276604 2276604 defendant Cook Richard husbandman 592628 592628 Cook, Richard, of Thurleton, husbandman 0
4900118 2326666 2326666 defendant Feraunt Lawrence yeoman 592628 592628 Feraunt, Lawrence, of Thurleton, yeoman 1
4916682 2331726 2331726 defendant Hornyng Henry   592628 592628 Hornyng, Henry, of Thurleton 8
4916690 2331727 2331727 defendant Burgh William   592628 592628 Burgh, William, of Thurleton 0
4916698 2331727 2331727 defendant Hornyng Henry   592628 592628 Hornyng, Henry, of Thurleton 8
4948810 2341609 2341609 plaintiff Mekilbergh Robert   592628 592628 Mekilbergh, Robert, of Thurleton 0
5083940 2381699 2381699 defendant Mekelbergh William yeoman 592628 592628 Mekelbergh, William, of Thurleton, yeoman 0
5121147 2392610 2392610 defendant Eston John husbandman 592628 592628 Eston, John, of Thurleton, husbandman 0
5127737 2394593 2394593 defendant Godewyn John yeoman 592628 592628 Godewyn, John, of Thurleton, yeoman 1
5146782 2400202 2400202 defendant Godewyn John yeoman 592628 592628 Godewyn, John, of Thurleton, yeoman 0
5165440 2405636 2405636 defendant Hervy John husbandman 592628 592628 Hervy, John, of Thurleton, husbandman 3
5334869 2455499 2455499 plaintiff Franke Adam butcher 592628 592628 Franke, Adam, of Thurleton, butcher 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);