names

15 rows where place_id = 692596

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4078304 2052541 2052541 defendant Idon Nicholas   692596 692596 Idon, Nicholas, of Spaldinge, Lincs, linen draper 0
4078309 2052542 2052542 defendant Hougham John yeoman 692596 692596 Hougham, John, of Spaldinge, Lincs, or of Pickworth, Rutland, yeoman 3
4095721 2058801 2058801 defendant Idon Thomas mercer 692596 692596 Idon, Thomas, of Spaldinge, Lincs, mercer 2
4113538 2065121 2065121 defendant Watson Thomas tailor 692596 692596 Watson, Thomas, of Spaldinge, Lincs, tailor 1
4154856 2079793 2079793 defendant Ballye George chapman 692596 692596 Ballye, George, of Spaldinge, Lincs, chapman 1
4208058 2098379 2098379 defendant Bayly George chapman 692596 692596 Bayly, George, of Spaldinge, Lincs, chapman 2
4246366 2111763 2111763 defendant Devell Thomas haberdasher 692596 692596 Devell, Thomas, of Spaldinge, Lincs, haberdasher 0
4252176 2113715 2113715 defendant Heye John chapman 692596 692596 Heye, John, of Spaldinge, Lincs, chapman 0
4252179 2113716 2113716 defendant Heye John chapman 692596 692596 Heye, John, of Spaldinge, Lincs, chapman 0
4265921 2118240 2118240 defendant Heye or Hye John chapman 692596 692596 Heye or Hye, John, of Spaldinge, Lincs, chapman 0
4265924 2118241 2118241 defendant Heye or Hye John chapman 692596 692596 Heye or Hye, John, of Spaldinge, Lincs, chapman 0
4265927 2118242 2118242 defendant Hoye or Hye John chapman 692596 692596 Hoye or Hye, John, of Spaldinge, Lincs, chapman 0
4270870 2119830 2119830 defendant Bevell George haberdasher 692596 692596 Bevell, George, of Spaldinge, Lincs, haberdasher 0
4278117 2122280 2122280 defendant Baker Hugh gent 692596 692596 Baker, Hugh, of Spaldinge, Lincs, gent 0
4317192 2136125 2136125 defendant Gamlyn Mathew gent 692596 692596 Gamlyn, Mathew, of Spaldinge, Lincs, gent 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);