names

34 rows where place_id = 607183

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668020 1915937 1915937 plaintiff Adlam John clothman 607183 607183 Adlam, John, of Westbury, Wilts, clothman 0
3674946 1918193 1918193 defendant Fippe Thomas clothmaker 607183 607183 Fippe, Thomas, of Westbury, Wilts, clothmaker 3
3690314 1923132 1923132 defendant Phypp Thomas clothman 607183 607183 Phypp, Thomas, of Westbury, Wilts, clothman 3
3705217 1927916 1927916 defendant Phypp Thomas clothmaker 607183 607183 Phypp, Thomas, of Westbury, Wilts, clothmaker 3
3768971 1947947 1947947 defendant Whetacre Robert clothier 607183 607183 Whetacre, Robert, of Westbury, Wilts, clothier 2
3786505 1953571 1953571 defendant Whetacre Robert clothier 607183 607183 Whetacre, Robert, of Westbury, Wilts, clothier 2
3938336 2003158 2003158 defendant Benett William clothman 607183 607183 Benett, William, of Westbury, Wilts, clothman 0
3948039 2006379 2006379 defendant Alain Robert yeoman 607183 607183 (Alain, Robert, of Westbury, Wilts, yeoman 1
3960102 2010634 2010634 defendant Bessey Peter baker 607183 607183 Bessey, Peter, of Westbury under Playne, Wilts, baker 1
3962578 2011503 2011503 plaintiff Whetacre Geoffrey (legal representative) 607183 607183 Whetacre, Geoffrey, of Westbury under Plain, Wilts, clothman, administratrix of 0
3980607 2017827 2017827 defendant Wallys Mathew draper 607183 607183 Wallys, Mathew, of Westbury, Wilts, draper 0
4088626 2056233 2056233 defendant Adlam George husbandman 607183 607183 Adlam, George, of Westbury, Wilts, husbandman 1
4117252 2066474 2066474 defendant Adlam George clothier 607183 607183 Adlam, George, of Westbury, Wilts, clothier 1
4120049 2067458 2067458 defendant Stephens Richard gent 607183 607183 Stephens, Richard, of Westbury under Playne, Wilts, gent 2
4139214 2074393 2074393 defendant Lyde Hugh clerk 607183 607183 Lyde, Hugh, of Westbury, Wilts, clerk 0
4141454 2075171 2075171 defendant Stevens Richard gent 607183 607183 Stevens, Richard, of Westbury, Wilts, gent 0
4199139 2095255 2095255 defendant Stevans Richard gent 607183 607183 Stevans, Richard, of Westbury, Wilts, gent 1
4483236 2195457 2195457 defendant Newe William   607183 607183 Newe, William, of Westbury, Wilts, vicar 0
4583669 2226308 2226308 defendant Norton John   607183 607183 Norton, John, of Westbury, Wilts 0
4591868 2228810 2228810 defendant Knyght John fuller 607183 607183 Knyght, John, of Westbury, Wilts, fuller 0
4613104 2235155 2235155 defendant Sebat Robert   607183 607183 Sebat, Robert, of Westbury, Wilts 0
4672565 2257063 2257063 defendant Bradeford Walter clothmaker 607183 607183 Bradeford, Walter, of Westbury, Wilts, clothmaker 1
4704244 2266703 2266703 defendant Sybet John butcher 607183 607183 Sybet, John, of Westbury, Wilts, butcher 1
4943985 2340084 2340084 defendant Lynche Walter weaver 607183 607183 Lynche, Walter, of Westbury, Wilts, weaver 0
4997790 2356195 2356195 defendant Wodeward William husbandman 607183 607183 Wodeward, William, of Westbury, Wilts, husbandman 1
5049612 2371509 2371509 defendant Gaweter John clerk 607183 607183 Gaweter, John, of Westbury, Wilts, clerk 0
5058976 2374247 2374247 defendant Knyght Thomas husbandman 607183 607183 Knyght, Thomas, of Westbury, Wilts, husbandman 3
5190503 2412967 2412967 defendant Davy William husbandman 607183 607183 Davy, William, of Westbury, Wilts, husbandman 0
5225655 2423175 2423175 defendant Knyght William weaver 607183 607183 Knyght, William, of Westbury, Wilts, weaver 0
5404593 2476389 2476389 defendant Rodeler William weaver 607183 607183 Rodeler, William, of Westbury, Wilts, weaver 0
5414287 2479206 2479206 defendant Waleys John yeoman 607183 607183 Waleys, John, of Westbury, Wilts, yeoman 0
5417734 2480229 2480229 defendant Redeler William weaver 607183 607183 Redeler, William, of Westbury, Wilts, weaver 0
5430062 2483925 2483925 defendant Waleys John yeoman 607183 607183 Waleys, John, of Westbury, Wilts, yeoman 0
5554076 2521231 2521231 defendant Clevelode John chapman 607183 607183 Clevelode, John, of Westbury under Pleyn, Wilts, chapman 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);