names

25 rows where place_id = 590402

✎ 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
3601106 1868009 1868009 defendant Berkeley Thomas gent 590402 590402 Berkeley, Thomas, of Wotton, Glos, gent 3
3633286 1905228 1905228 defendant Baskerfeld Richard yeoman 590402 590402 Baskerfeld, Richard, of Wotton under Egge, Glos, yeoman 2
3794138 1956035 1956035 defendant Howys John clothier 590402 590402 Howys, John, of Wotton, Glos, clothier 1
3822097 1964805 1964805 defendant Sebourne John, senior clothman 590402 590402 Sebourne, John, senior, of Wotton, Glos, clothman 0
3822101 1964806 1964806 defendant Sebourne John, senior clothman 590402 590402 Sebourne, John, senior, of Wotton, Glos, clothman 0
3919059 1996699 1996699 defendant Bysshopp Thomas clothier 590402 590402 Bysshopp, Thomas, of Wotton under Hege, Glos, clothier 0
3975462 2015985 2015985 plaintiff Hughes John   590402 590402 Hughes, John, of Wotton under Edge, Glos, woollen draper 0
4001197 2025204 2025204 plaintiff Hale Robert clothier 590402 590402 Hale, Robert, of Wotton under Edge, Glos, clothier 0
4001199 2025205 2025205 plaintiff Hale Robert clothier 590402 590402 Hale, Robert, of Wotton under Edge, Glos, clothier 0
4001201 2025206 2025206 plaintiff Hale Robert clothier 590402 590402 Hale, Robert, of Wotton under Hedge, Glos, clothier 0
4053245 2043543 2043543 defendant Haynes Joan widow 590402 590402 Haynes, Joan, of Wotton, Glos, widow 0
4303543 2131365 2131365 defendant Strangwyshe Nicholas gent 590402 590402 Strangwyshe, Nicholas, of Wotton under Edge, Glos, gent 2
4367610 2153468 2153468 defendant Wrighte Francis saddler 590402 590402 Wrighte, Francis, of Wotton under Edge, Glos, saddler 2
4391372 2161731 2161731 defendant Burton Edward yeoman 590402 590402 Burton, Edward, of Wotton under Hedge, Glos, yeoman 2
4401868 2165222 2165222 defendant Bower William chapman 590402 590402 Bower, William, of Wotton under Edge, Glos, chapman 1
5070800 2377762 2377762 defendant Bolter John butcher 590402 590402 Bolter, John, of Wotton under Egge, Glos, butcher 2
5296349 2443922 2443922 defendant Bo- William clothman 590402 590402 Bo-, William, of Wotton under Egge, Glos, clothman 1
5296430 2443946 2443946 defendant Boweton William cothman 590402 590402 Boweton, William, of Wotton under Egge, Glos, cothman 2
5498458 2504492 2504492 defendant Robyns Richard clothmaker 590402 590402 Robyns, Richard, of Wotton, Glos, clothmaker 3
5498464 2504493 2504493 defendant Carpenter Nicholas clothmaker 590402 590402 Carpenter, Nicholas, of Wotton, Glos, clothmaker 2
5529921 2513861 2513861 defendant Plummer John gent 590402 590402 Plummer, John, of Wotton under Egge, Glos, gent 0
5593204 2532856 2532856 defendant Robyns Richard clothman 590402 590402 Robyns, Richard, of Wotton, Glos, clothman 2
5593209 2532857 2532857 defendant Robyns Richard clothman 590402 590402 Robyns, Richard, of Wotton, Glos, clothman 2
5599145 2534614 2534614 defendant Turbyn or Turvyn William clothman 590402 590402 Turbyn or Turvyn, William, of Wotton under Hegge, Glos, clothman 0
5601008 2535201 2535201 defendant Robyns Richard clothman 590402 590402 Robyns, Richard, of Wotton under Hegge, Glos, clothman 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);