names

38 rows where place_id = 591041

✎ 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
3603129 1868643 1868643 defendant Lechmer Richard yeoman 591041 591041 Lechmer, Richard, of Hanley, Worcs, yeoman 1
3606706 1869772 1869772 defendant Bagger Roger husbandman 591041 591041 Bagger, Roger, of Hanley, Worcs, husbandman 2
3607391 1869973 1869973 defendant Knottesford James gent 591041 591041 Knottesford, James, of Hanley, Worcs, gent 0
3644302 1908642 1908642 defendant Saunders Thomas yeoman 591041 591041 Saunders, Thomas, of Hanley, Worcs, yeoman 11
3646743 1909384 1909384 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 0
3689975 1923024 1923024 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 0
3690683 1923251 1923251 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 0
3705027 1927863 1927863 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 2
3885289 1985332 1985332 defendant Pynnok William esq 591041 591041 (Pynnok, William, of Hanley, Worcs, esq 1
3885293 1985333 1985333 defendant Pynnok William esq 591041 591041 (Pynnok, William, of Hanley, Worcs, esq 1
3892547 1987751 1987751 defendant Crofte John gent 591041 591041 Crofte, John, of Hanley, Worcs, gent 1
3953594 2008332 2008332 defendant Gatley Richard husbandman 591041 591041 Gatley, Richard, of Hanley, Worcs, husbandman 1
4051448 2042939 2042939 defendant Budd George husbandman 591041 591041 Budd, George, of Hanley, Worcs, husbandman 1
4056297 2044637 2044637 defendant Wythe Robert esq 591041 591041 (Wythe, Robert, of Hanley, Worcs, esq 1
4056300 2044638 2044638 defendant Wythe Robert esq 591041 591041 (Wythe, Robert, of Hanley, Worcs, esq 1
4105400 2062211 2062211 defendant Newport Elizabeth widow 591041 591041 Newport, Elizabeth, of Hanley, Worcs, widow 1
4216886 2101402 2101402 defendant Wheler Richard gent 591041 591041 Wheler, Richard, of Hanley, Worcs, gent 2
4219438 2102299 2102299 defendant Wheler Richard gent 591041 591041 Wheler, Richard, of Hanley, Worcs, gent 1
4236941 2108498 2108498 defendant Wheler Richard gent 591041 591041 Wheler, Richard, of Hanley, Worcs, gent 1
4244470 2111129 2111129 defendant Cries Richard husbandman 591041 591041 Cries, Richard, of Hanley, Worcs, husbandman 0
4325785 2138998 2138998 defendant More John husbandman 591041 591041 More, John, of Hanley, Worcs, husbandman 2
4406500 2166737 2166737 defendant Barnes Richard husbandman 591041 591041 Barnes, Richard, of Hanley, Worcs, husbandman 2
4823645 2303487 2303487 defendant Taillour Nicholas tailor 591041 591041 Taillour, Nicholas, of Hanley, Worcs, tailor 3
5077565 2379787 2379787 defendant Waterden Maurice yeoman 591041 591041 Waterden, Maurice, of Hanley, Worcs, yeoman 3
5132403 2395974 2395974 defendant Edm--- John yeoman 591041 591041 Edm---, John, of Hanley, Worcs, yeoman 0
5152159 2401769 2401769 defendant Edmundes John yeoman 591041 591041 Edmundes, John, of Hanley, Worcs, yeoman 0
5170040 2406974 2406974 defendant Edmundes John yeoman 591041 591041 Edmundes, John, of Hanley, Worcs, yeoman 0
5217523 2420862 2420862 defendant Salter Richard carpenter 591041 591041 Salter, Richard, of Hanley, Worcs, carpenter 0
5371679 2466731 2466731 defendant Laweton Henry (legal representative) 591041 591041 Laweton, Henry, of Hanley, Worcs, yeoman, executors of 1
5477747 2498362 2498362 defendant Frewyn Thomas husbandman 591041 591041 Frewyn, Thomas, of Hanley, Worcs, husbandman 4
5480142 2499043 2499043 defendant Pycher Thomas chaplain 591041 591041 (Pycher, Thomas, of Hanley, Worcs, chaplain 2
5549692 2519950 2519950 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 13
5558668 2522486 2522486 defendant Hanley John gent 591041 591041 Hanley, John, of Hanley, Worcs, gent 1
5558671 2522487 2522487 defendant Hanley John gent 591041 591041 Hanley, John, of Hanley, Worcs, gent 0
5567030 2524948 2524948 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 12
5567971 2525200 2525200 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 8
5568023 2525206 2525206 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 6
5598318 2534362 2534362 defendant Savage John   591041 591041 Savage, John, of Hanley, Worcs, knight 2

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