names

46 rows where place_id = 601392

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645161 1908894 1908894 defendant Bentys Edward chapman 601392 601392 Bentys, Edward, of Tawnton, Soms, chapman 1
3650721 1910590 1910590 defendant Sydenham Christopher gent 601392 601392 Sydenham, Christopher, of Tawnton, Soms, gent 0
3650723 1910591 1910591 defendant Sydenham Christopher gent 601392 601392 Sydenham, Christopher, of Tawnton, Soms, gent 0
3650725 1910592 1910592 defendant Sydenham William gent 601392 601392 Sydenham, William, of Tawnton, Soms, gent 0
3652370 1911078 1911078 defendant Paten John chapman 601392 601392 Paten, John, of Tawnton, Soms, chapman 0
3652398 1911085 1911085 defendant Whitlond Nicholas merchant 601392 601392 Whitlond, Nicholas, of Tawnton, Soms, merchant 0
3671686 1917130 1917130 defendant Alye Thomas merchant 601392 601392 Alye, Thomas, of Tawnton, Soms, merchant 3
3682414 1920601 1920601 defendant Adams Robert mercer 601392 601392 Adams, Robert, of Tawnton, Soms, mercer 1
3687792 1922346 1922346 defendant Frank John chapman 601392 601392 Frank, John, of Tawnton, Soms, chapman 2
3713439 1930516 1930516 defendant Vyne William clothman 601392 601392 Vyne, William, of Tawnton, Soms, clothman 2
3730897 1935891 1935891 defendant Powlyng Walter weaver 601392 601392 Powlyng, Walter, of Tawnton, Soms, weaver 2
3733412 1936687 1936687 defendant Awbrey Thomas merchant 601392 601392 Awbrey, Thomas, of Tawnton, Soms, merchant 2
3739803 1938663 1938663 defendant Williams Thomas pinner 601392 601392 Williams, Thomas, of Tawnton, Soms, pinner 0
3755868 1943787 1943787 defendant Walrone Osmund husbandman 601392 601392 Walrone, Osmund, of Tawnton, Soms, husbandman 0
3774293 1949682 1949682 defendant Soper John gent 601392 601392 Soper, John, of Tawnton, Soms, gent 0
3779885 1951437 1951437 defendant Wynston John merchant 601392 601392 Wynston, John, of Tawnton, Soms, merchant 3
3804146 1959225 1959225 defendant Franke John merchant 601392 601392 Franke, John, of Tawnton, Soms, merchant 0
3808355 1960486 1960486 defendant Harryes John clothman 601392 601392 Harryes, John,of Tawnton, Soms, clothman 0
3808402 1960503 1960503 defendant Harryes John clothman 601392 601392 Harryes, John, of Tawnton, Soms, clothman 0
3827780 1966555 1966555 defendant Tomson Robert bowyer 601392 601392 Tomson, Robert, of Tawnton, Soms, bowyer 2
3836005 1969173 1969173 defendant Stone Joan widow 601392 601392 Stone, Joan, of Tawnton, Soms, widow 2
3853684 1974784 1974784 defendant Adam John merchant 601392 601392 Adam, John, of Tawnton, Soms, merchant 0
3853686 1974785 1974785 defendant Adam John merchant 601392 601392 Adam, John, of Tawnton, Soms, merchant 0
3860263 1976929 1976929 defendant Davy William chapman 601392 601392 Davy, William, of Tawnton, Soms, chapman 0
3860265 1976930 1976930 defendant Davy William chapman 601392 601392 Davy, William, of Tawnton, Soms, chapman 0
3867065 1979223 1979223 defendant Carvanell John merchant 601392 601392 Carvanell, John, of Tawnton, Soms, merchant 1
3885484 1985401 1985401 defendant Clarke Adam clerk 601392 601392 Clarke, Adam, of Tawnton, Soms, clerk 1
3897504 1989378 1989378 defendant Nethway John gent 601392 601392 Nethway, John, of Tawnton, Soms, gent 0
3962404 2011440 2011440 defendant Mathewe Roger capper 601392 601392 Mathewe, Roger, of Tawnton, Soms, capper 0
3974801 2015751 2015751 plaintiff Hobbes William clothier 601392 601392 Hobbes, William, of Tawnton, Soms, clothier 0
3979277 2017336 2017336 defendant Cornell William plasterer 601392 601392 Cornell, William, of Tawnton, Soms, plasterer 0
4007858 2027588 2027588 defendant More Jasper gent 601392 601392 More, Jasper, of Tawnton, Soms, gent 2
4008356 2027753 2027753 defendant More Thomas gent 601392 601392 More, Thomas, of Tawnton, Soms, gent 0
4101325 2060777 2060777 defendant Hartepole Margaret widow 601392 601392 Hartepole, Margaret, of Tawnton, Soms, widow 0
4112014 2064548 2064548 defendant Dawley William   601392 601392 Dawley, William, of Tawnton, Soms, felt maker 0
4135542 2073034 2073034 defendant Sand Nicholas chapman 601392 601392 Sand, Nicholas, of Tawnton, Soms, chapman 0
4170289 2085101 2085101 defendant Olyver Peter   601392 601392 Olyver, Peter, of Tawnton, Soms, felt maker 0
4237633 2108755 2108755 defendant Aulforde John chapman 601392 601392 Aulforde, John, of Tawnton, Soms, chapman 0
4248326 2112430 2112430 defendant Wyther ot Withers Adam chapman 601392 601392 Wyther ot Withers, Adam, of Tawnton, Soms, chapman 0
4270005 2119551 2119551 defendant Gybbons George carrier 601392 601392 Gybbons, George, of Tawnton, Soms, carrier 1
4272275 2120299 2120299 defendant Smyth Bartholomew cutler 601392 601392 Smyth, Bartholomew, of Tawnton, Soms, cutler 1
4966686 2346969 2346969 defendant Chambre William yeoman 601392 601392 Chambre, William, of Tawnton, Soms, yeoman 1
4966690 2346970 2346970 defendant Kenyngton alias Chaumbre William yeoman 601392 601392 Kenyngton alias Chaumbre, William, of Tawnton, Soms, yeoman 1
5229525 2424248 2424248 defendant Hurston Simon Chapman 601392 601392 Hurston, Simon, of Tawnton, Soms, Chapman 1
5584838 2530336 2530336 plaintiff Hewett John, junior merchant 601392 601392 Hewett, John, junior, of Tawnton, Soms, merchant 0
5607344 2537189 2537189 defendant Boldey Thomas yeoman 601392 601392 Boldey, Thomas, of Tawnton, Soms, yeoman 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);