names

55 rows where place_id = 618524

✎ 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
3725132 1934151 1934151 defendant Appowell Robert yeoman 618524 618524 Appowell, Robert, of Stogursey, yeoman 0
3985307 2019502 2019502 defendant Baker Alexander yeoman 618524 618524 Baker, Alexander, of Stogursey, yeoman 0
3985308 2019502 2019502 defendant Strange Thomas   618524 618524 Strange, Thomas, of Stogursey, groom 1
4026497 2034125 2034125 defendant Kydmore Eleanor widow 618524 618524 Kydmore, Eleanor, of Stogursey, widow 0
4049892 2042393 2042393 plaintiff Walford Alexander victualer 618524 618524 Walford, Alexander, of Stogursey, victualer 0
4049893 2042393 2042393 defendant Corell John tucker 618524 618524 Corell, John, of Stogursey, tucker 0
4057603 2045100 2045100 defendant Chedsey Robert victualer 618524 618524 Chedsey, Robert, of Stogursey, victualer 1
4110954 2064167 2064167 defendant Sulley Christopher carpenter 618524 618524 Sulley, Christopher, of Stogursey, carpenter 0
4146536 2076939 2076939 defendant Culverwell Clement sherman 618524 618524 Culverwell, Clement, of Stogursey, sherman 1
4148504 2077606 2077606 defendant Hayne John, junior shoemaker 618524 618524 Hayne, John, junior, of Stogursey, shoemaker 0
4148511 2077607 2077607 defendant Walforde John, junior yeoman 618524 618524 Walforde, John, junior, of Stogursey, yeoman 2
4177621 2087649 2087649 defendant Marshall Richard yeoman 618524 618524 Marshall, Richard, of Stogursey, yeoman 0
4182028 2089195 2089195 defendant Walforde John   618524 618524 Walforde, John, of Stogursey. Husbandman 0
4202658 2096474 2096474 defendant Badcocke William husbandman 618524 618524 Badcocke, William, of Stogursey, husbandman 1
4203972 2096942 2096942 defendant Towylls Hugh carpenter 618524 618524 Towylls, Hugh, of Stogursey, carpenter 1
4203973 2096942 2096942 defendant Stoddon John carpenter 618524 618524 Stoddon, John, of Stogursey, carpenter 2
4221296 2102947 2102947 defendant Walker John husbandman 618524 618524 Walker, John, of Stogursey, husbandman 1
4222697 2103429 2103429 defendant Decker Robert husbandman 618524 618524 Decker, Robert, of Stogursey, husbandman 3
4239026 2109269 2109269 defendant Burche John husbandman 618524 618524 Burche, John, of Stogursey, husbandman 0
4240063 2109649 2109649 defendant Dunscombe John, senior husbandman 618524 618524 Dunscombe, John, senior, of Stogursey, husbandman 0
4240064 2109649 2109649 defendant Dunscombe John, junior husbandman 618524 618524 Dunscombe, John, junior, of Stogursey, husbandman 1
4240065 2109649 2109649 defendant Sackvile Robert gent 618524 618524 Sackvile, Robert, of Stogursey, gent 2
4243950 2110959 2110959 defendant Burche John yeoman 618524 618524 Burche, John, of Stogursey, yeoman 0
4243952 2110959 2110959 defendant Frenche William tailor 618524 618524 Frenche, William, of Stogursey, tailor 2
4243978 2110966 2110966 defendant Symons Robert husbandman 618524 618524 Symons, Robert, of Stogursey, husbandman 0
4246865 2111925 2111925 defendant Morgan William yeoman 618524 618524 Morgan, William, of Stogursey, yeoman 3
4251180 2113372 2113372 defendant Dodyngton Richard gent 618524 618524 Dodyngton, Richard, of Stogursey, gent 0
4254432 2114474 2114474 defendant Dowdinge John Soms, yeoman 618524 618524 Dowdinge John, of Stogursey, Soms, yeoman 1
4259903 2116283 2116283 defendant Sydenham George gent 618524 618524 Sydenham, George, of Stogursey, gent 1
4259904 2116283 2116283 defendant Hamond Baldwin weaver 618524 618524 Hamond, Baldwin, of Stogursey, weaver 2
4276687 2121779 2121779 defendant Chotte John yeoman 618524 618524 Chotte, John, of Stogursey, yeoman 0
4283819 2124250 2124250 defendant Lyminge Robert yeoman 618524 618524 Lyminge, Robert, of Stogursey, yeoman 0
4285922 2125020 2125020 defendant Walford James husbandman 618524 618524 Walford, James, of Stogursey, husbandman 0
4288460 2125920 2125920 defendant Walforde John tanner 618524 618524 Walforde, John, of Stogursey, tanner 0
4310562 2133843 2133843 defendant More Bartholomew gent 618524 618524 More, Bartholomew, of Stogursey, gent 0
4310563 2133843 2133843 defendant Smythe Robert smith 618524 618524 Smythe, Robert, of Stogursey, smith 1
4310580 2133849 2133849 defendant Morris James shoemaker 618524 618524 Morris, James, of Stogursey, shoemaker 0
4310581 2133849 2133849 defendant Hellier William victualer 618524 618524 Hellier, William, of Stogursey, victualer 1
4310582 2133849 2133849 defendant Aishe Robert, senior yeoman 618524 618524 Aishe, Robert, senior, of Stogursey, yeoman 2
4310583 2133849 2133849 defendant Aishe Robert, junior yeoman 618524 618524 Aishe, Robert, junior, of Stogursey, yeoman 3
4362882 2151786 2151786 defendant Morrys James shoemaker 618524 618524 Morrys, James, of Stogursey, shoemaker 0
4362883 2151786 2151786 defendant Spreate William butcher 618524 618524 Spreate, William, of Stogursey, butcher 1
4362884 2151786 2151786 defendant Glomer Henry wheeler 618524 618524 Glomer, Henry, of Stogursey, wheeler 2
4362885 2151786 2151786 defendant Walford   husbandman 618524 618524 Walford, , of Stogursey, husbandman 3
4362896 2151790 2151790 defendant Hellyer William butcher 618524 618524 Hellyer, William, of Stogursey, butcher 1
4367950 2153586 2153586 defendant Burlande John yeoman 618524 618524 Burlande, John, of Stogursey, yeoman 1
4367951 2153586 2153586 defendant Hodges John yeoman 618524 618524 Hodges, John, of Stogursey, yeoman 2
4374225 2155854 2155854 defendant Howe Anthony yeoman 618524 618524 Howe, Anthony, of Stogursey, yeoman 0
4374228 2155855 2155855 defendant Howe Anthony yeoman 618524 618524 Howe, Anthony, of Stogursey, yeoman 1
4375599 2156329 2156329 defendant Pounde William yeoman 618524 618524 Pounde, William, of Stogursey, yeoman 2
4382248 2158761 2158761 defendant Smyth Robert smith 618524 618524 Smyth, Robert, of Stogursey, smith 0
4382926 2159002 2159002 defendant Piltorne Thomas   618524 618524 Piltorne, Thomas, of Stogursey, mason 0
4382927 2159002 2159002 defendant Ammerye alias Pryor     618524 618524 Ammerye alias Pryor, , of Stogursey, "spinter" 1
4405156 2166301 2166301 defendant Morrys James yeoman 618524 618524 Morrys, James, of Stogursey, yeoman 0
4409687 2167840 2167840 defendant Symons Robert yeoman 618524 618524 Symons, Robert, of Stogursey, 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);