names

24 rows where place_id = 632883

✎ 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
3809318 1960796 1960796 defendant Farrand William yeoman 632883 632883 Farrand, William, of Carleton in Craven, yeoman 0
3809319 1960796 1960796 defendant Dayllye John yeoman 632883 632883 Dayllye, John, of Carleton in Craven, yeoman 1
3935597 2002218 2002218 defendant Dawtreye Richard gent 632883 632883 Dawtreye, Richard, of Carleton in Craven, gent 0
4348873 2146867 2146867 defendant Hargraves William drover 632883 632883 Hargraves, William, of Carleton in Craven, drover 0
4400991 2164921 2164921 defendant Hargraves William drover 632883 632883 Hargraves, William, of Carleton in Craven, drover 0
4910307 2329741 2329741 defendant Mosele Robert husbandman 632883 632883 Mosele, Robert, of Carleton in Craven, husbandman 0
4953248 2342932 2342932 defendant Elys James   632883 632883 Elys, James, of Carleton in Craven, wright 0
5108776 2389002 2389002 defendant Bould Elizabeth widow 632883 632883 Bould, Elizabeth, of Carleton in Craven, widow 0
5108777 2389002 2389002 defendant Bould Brian esq 632883 632883 Bould, Brian, of Carleton in Craven, esq 1
5108778 2389002 2389002 defendant Erlescotes Henry gent 632883 632883 Erlescotes, Henry, of Carleton in Craven, gent 2
5108779 2389002 2389002 defendant Baker Henry yeoman 632883 632883 Baker, Henry, of Carleton in Craven, yeoman 3
5108780 2389002 2389002 defendant Scalys Thomas husbandman 632883 632883 Scalys, Thomas, of Carleton in Craven, husbandman 4
5108781 2389002 2389002 defendant Scalys John laborer 632883 632883 Scalys, John, of Carleton in Craven, laborer 5
5108782 2389002 2389002 defendant Scalys James laborer 632883 632883 Scalys, James, of Carleton in Craven, laborer 6
5108783 2389002 2389002 defendant Scalys William   632883 632883 Scalys, William, of Carleton in Craven, servant 7
5108784 2389002 2389002 defendant Doweson Alexander yeoman 632883 632883 Doweson, Alexander, of Carleton in Craven, yeoman 8
5108785 2389002 2389002 defendant Gawkethorp James husbandman 632883 632883 Gawkethorp, James, of Carleton in Craven, husbandman 9
5108786 2389002 2389002 defendant Gawkethorp Gerard laborer 632883 632883 Gawkethorp, Gerard, of Carleton in Craven, laborer 10
5108787 2389002 2389002 defendant Scot William   632883 632883 Scot, William, of Carleton in Craven, servant 11
5108788 2389002 2389002 defendant Whitwain John laborer 632883 632883 Whitwain, John, of Carleton in Craven, laborer 12
5227107 2423580 2423580 defendant Dautry or Dantry Robert yeoman 632883 632883 Dautry or Dantry, Robert, of Carleton in Craven, yeoman 3
5227108 2423580 2423580 defendant Baxter Henry yeoman 632883 632883 Baxter, Henry, of Carleton in Craven, yeoman 4
5277353 2438454 2438454 defendant Wilson William husbandman 632883 632883 Wilson, William, of Carleton in Craven, husbandman 1
5277354 2438454 2438454 defendant Gaukthorp James husbandman 632883 632883 Gaukthorp, James, of Carleton in Craven, husbandman 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);