names

29 rows where place_id = 615404

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3708727 1929025 1929025 defendant Bercer John carpenter 615404 615404 Bercer, John, of Colerne, carpenter 8
3708728 1929025 1929025 defendant Bullok Robert husbandman 615404 615404 Bullok, Robert, of Colerne, husbandman 9
3708729 1929025 1929025 defendant Smythe John, senior husbandman 615404 615404 Smythe, John, senior, of Colerne, husbandman 10
3723280 1933554 1933554 defendant Jure Thomas husbandman 615404 615404 Jure, Thomas, of Colerne, husbandman 0
3723282 1933555 1933555 defendant Smyth John, senior husbandman 615404 615404 Smyth, John, senior, of Colerne, husbandman 0
3723283 1933555 1933555 defendant Jure Thomas husbandman 615404 615404 Jure, Thomas, of Colerne, husbandman 1
3723284 1933555 1933555 defendant Smyth Thomas husbandman 615404 615404 Smyth, Thomas, of Colerne, husbandman 2
3723285 1933555 1933555 defendant Edwardys Edward husbandman 615404 615404 Edwardys, Edward, of Colerne, husbandman 3
3723286 1933555 1933555 defendant Bulloke Robert husbandman 615404 615404 Bulloke, Robert, of Colerne, husbandman 4
3723287 1933555 1933555 defendant Bercer John husbandman 615404 615404 Bercer, John, of Colerne, husbandman 5
4497744 2199938 2199938 defendant Benet John   615404 615404 Benet, John, of Colerne sawyer 0
4500858 2200888 2200888 defendant Pety John   615404 615404 Pety, John, of Colerne 2
4826966 2304474 2304474 defendant Alewey John husbandman 615404 615404 Alewey, John, of Colerne, husbandman 0
4901524 2327081 2327081 defendant Pety John bellfounder 615404 615404 Pety, John, of Colerne, bellfounder 0
4901525 2327081 2327081 defendant Alberd John husbandman 615404 615404 Alberd, John, of Colerne, husbandman 1
4901526 2327081 2327081 defendant Boteler Thomas husbandman 615404 615404 Boteler, Thomas, of Colerne, husbandman 2
4901527 2327081 2327081 defendant Eyr John chaplain 615404 615404 together with, Eyr, John, of Colerne, chaplain 3
4901538 2327084 2327084 defendant Pyppyngge John baker 615404 615404 Pyppyngge, John, of Colerne, baker 3
5005830 2358605 2358605 defendant Rede William husbandman 615404 615404 Rede, William, of Colerne, husbandman 0
5017158 2361918 2361918 defendant Graunt John husbandman 615404 615404 Graunt, John, of Colerne, husbandman 2
5053673 2372701 2372701 defendant Ned John miller 615404 615404 Ned, John, of Colerne, miller 4
5072965 2378401 2378401 defendant Lyneson or Lyveson Abel carpenter 615404 615404 Lyneson or Lyveson, Abel, of Colerne, carpenter 0
5243397 2428264 2428264 defendant Alwey John husbandman 615404 615404 Alwey, John, of Colerne, husbandman 0
5272476 2437024 2437024 defendant Augyll John husbandman 615404 615404 Augyll, John, of Colerne, husbandman 0
5318264 2450557 2450557 defendant Bullok John husbandman 615404 615404 Bullok, John, of Colerne, husbandman 0
5318268 2450558 2450558 defendant Bullok John husbandman 615404 615404 Bullok, John, of Colerne, husbandman 0
5481302 2499354 2499354 defendant Burton Thomas yeoman 615404 615404 Burton, Thomas, of Colerne, yeoman 2
5595885 2533627 2533627 defendant Goreslade William husbandman 615404 615404 Goreslade, William, of Colerne, husbandman 0
5595886 2533627 2533627 defendant Goreslade John husbandman 615404 615404 Goreslade, John, of Colerne, husbandman 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);