names

35 rows where place_id = 594451

✎ 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
3616178 1872698 1872698 defendant Malyet William tailor 594451 594451 Malyet, William, of Hartest, tailor 3
3716937 1931584 1931584 defendant Phyllypson John, junior husbandman 594451 594451 Phyllypson, John, junior, of Hartest, husbandman 0
3717542 1931776 1931776 defendant Phyllypson John, junior husbandman 594451 594451 Phyllypson, John, junior, of Hartest, husbandman 0
3717584 1931794 1931794 defendant Sparrowe John husbandman 594451 594451 Sparrowe, John, of Hartest, husbandman 0
3724509 1933951 1933951 defendant Everard Thomas weaver 594451 594451 Everard, Thomas, of Hartest, weaver 1
3732615 1936432 1936432 defendant Phylypson John, junior husbandman 594451 594451 Phylypson, John, junior, of Hartest, husbandman 0
3741154 1939094 1939094 defendant Phylypson John husbandman 594451 594451 Phylypson, John, of Hartest, husbandman 2
3743793 1939943 1939943 defendant Phylypson John, junior husbandman 594451 594451 Phylypson, John, junior, of Hartest, husbandman 0
3763536 1946230 1946230 defendant Nunny Robert yeoman 594451 594451 Nunny, Robert, of Hartest, yeoman 3
3770757 1948541 1948541 plaintiff Sparke Andrew smith 594451 594451 Sparke, Andrew, of Hartest, smith 0
3770758 1948541 1948541 defendant Martyn Thomas tanner 594451 594451 Martyn, Thomas, of Hartest, tanner 0
3770760 1948542 1948542 defendant Martyn Thomas tanner 594451 594451 Martyn, Thomas, of Hartest, tanner 0
3777042 1950566 1950566 defendant Nunne Robert husbandman 594451 594451 Nunne, Robert, of Hartest, husbandman 0
3779013 1951159 1951159 defendant Nun Robert husbandman 594451 594451 Nun, Robert, of Hartest, husbandman 0
3779542 1951328 1951328 defendant Frost John husbandman 594451 594451 Frost, John, of Hartest, husbandman 0
3796422 1956750 1956750 defendant Coppyng John husbandman 594451 594451 Coppyng, John, of Hartest, husbandman 2
3816038 1962916 1962916 defendant Nunne Robert husbandman 594451 594451 Nunne, Robert, of Hartest, husbandman 3
3821974 1964764 1964764 defendant Nune Robert husbandman 594451 594451 Nune, Robert, of Hartest, husbandman 0
3848200 1973002 1973002 defendant More Thomas butcher 594451 594451 More, Thomas, of Hartest, butcher 1
3873855 1981474 1981474 defendant Grave John yeoman 594451 594451 Grave, John, of Hartest, yeoman 0
3875177 1981936 1981936 defendant Nunne Robert husbandman 594451 594451 Nunne, Robert, of Hartest, husbandman 1
3877070 1982571 1982571 defendant Sparke Andrew smith 594451 594451 Sparke, Andrew, of Hartest, smith 4
3894067 1988232 1988232 defendant Phileppson John, junior husbandman 594451 594451 Phileppson, John, junior, of Hartest, husbandman 2
3909910 1993622 1993622 defendant Phyllypson John husbandman 594451 594451 Phyllypson, John, of Hartest, husbandman 3
4025260 2033697 2033697 defendant Howghton Edmund yeoman 594451 594451 Howghton, Edmund, of Hartest, yeoman 0
4107440 2062948 2062948 plaintiff Philipson Edmund   594451 594451 Philipson, Edmund, of Hartest 0
4111027 2064193 2064193 defendant Petnatt Thomas clothier 594451 594451 Petnatt, Thomas, of Hartest, clothier 0
4326780 2139309 2139309 defendant Gardener Samuel yeoman 594451 594451 Gardener, Samuel, of Hartest, yeoman 2
4401257 2165014 2165014 defendant Froste Thomas yeoman 594451 594451 Froste, Thomas, of Hartest, yeoman 0
4401258 2165014 2165014 defendant Sparke James yeoman 594451 594451 Sparke, James, of Hartest, yeoman 1
4435865 2175966 2175966 defendant Robert John   594451 594451 Robert, John, of Hartest, son of Robert 0
4703244 2266393 2266393 defendant Pumpy William yeoman 594451 594451 Pumpy, William, of Hartest, yeoman 0
5478246 2498521 2498521 defendant Freman Robert husbandman 594451 594451 Freman, Robert, of Hartest, husbandman 1
5568823 2525432 2525432 defendant Mason Edward husbandman 594451 594451 Mason, Edward, of Hartest, husbandman 1
5598896 2534531 2534531 defendant Frost Henry yeoman 594451 594451 Frost, Henry, of Hartest, yeoman 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);