names

18 rows where place_id = 591526

✎ 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
3604666 1869122 1869122 defendant Veske Simon woolman 591526 591526 Veske, Simon, of Besthorpe, woolman 0
3604670 1869123 1869123 defendant Veske Simon woolman 591526 591526 Veske, Simon, of Besthorpe, woolman 0
3888229 1986320 1986320 plaintiff Drury William gent 591526 591526 Drury, William, of Besthorpe, gent 0
3888231 1986321 1986321 plaintiff Drury William gent 591526 591526 Drury, William, of Besthorpe, gent 0
3913777 1994953 1994953 plaintiff Brampton William, senior esq 591526 591526 Brampton, William, senior, of Besthorpe, esq 0
3917318 1996150 1996150 defendant Downyng Thomas clerk 591526 591526 (Downyng, Thomas, of Besthorpe, clerk 1
3951915 2007731 2007731 defendant Trokowe Robert husbandman 591526 591526 Trokowe, Robert, of Besthorpe, husbandman 0
3963076 2011684 2011684 defendant Cockett William esq 591526 591526 Cockett, William, of Besthorpe, esq 3
4059227 2045698 2045698 defendant Cockell Thomas butcher 591526 591526 Cockell, Thomas, of Besthorpe, butcher 0
4130600 2071255 2071255 defendant Knyght Robert joiner 591526 591526 Knyght, Robert, of Besthorpe, joiner 0
4141533 2075203 2075203 defendant Crampe Simon husbandman 591526 591526 Crampe, Simon, of Besthorpe, husbandman 3
4166542 2083794 2083794 defendant Beane Daniel yeoman 591526 591526 Beane, Daniel, of Besthorpe, yeoman 0
4205761 2097563 2097563 defendant Knyght Robert joiner 591526 591526 Knyght, Robert, of Besthorpe, joiner 3
4275022 2121217 2121217 defendant Drury Anthony esq 591526 591526 Drury, Anthony, of Besthorpe, esq 1
4278498 2122415 2122415 defendant Potter Henry yeoman 591526 591526 Potter, Henry, of Besthorpe, yeoman 0
4389521 2161122 2161122 defendant Meake or Meakes John husbandman 591526 591526 Meake or Meakes, John, of Besthorpe, husbandman 0
4393274 2162354 2162354 defendant Sporle Peter   591526 591526 Sporle, Peter, of Besthorpe, "keymer" 3
4408277 2167338 2167338 defendant Bett Richard husbandman 591526 591526 Bett, Richard, of Besthorpe, husbandman 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);