names

28 rows where place_id = 608919

✎ 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
3676132 1918575 1918575 defendant Atkynson John husbandman 608919 608919 Atkynson, John, of Magna Driffeld, husbandman 0
3676133 1918575 1918575 defendant homson John husbandman 608919 608919 homson, John, of Magna Driffeld, husbandman 1
3692033 1923677 1923677 defendant Atkynson John husbandman 608919 608919 Atkynson, John, of Magna Driffeld, husbandman 0
3692034 1923677 1923677 defendant Thomson John husbandman 608919 608919 Thomson, John, of Magna Driffeld, husbandman 1
3692036 1923678 1923678 defendant Atkynson John husbandman 608919 608919 Atkynson, John, of Magna Driffeld, husbandman 0
3692037 1923678 1923678 defendant Thomson John husbandman 608919 608919 Thomson, John, of Magna Driffeld, husbandman 1
3700124 1926271 1926271 defendant Lyndesey George husbandman 608919 608919 Lyndesey, George, of Magna Driffeld, husbandman 0
3700125 1926271 1926271 defendant Bosse Brian yeoman 608919 608919 Bosse, Brian, of Magna Driffeld, yeoman 1
3700126 1926271 1926271 defendant Stabler Thomas yeoman 608919 608919 Stabler, Thomas, of Magna Driffeld, yeoman 2
3700127 1926271 1926271 defendant Atkynson John husbandman 608919 608919 Atkynson, John, of Magna Driffeld, husbandman 3
3700128 1926271 1926271 defendant Thomson John husbandman 608919 608919 Thomson, John, of Magna Driffeld, husbandman 4
3700129 1926271 1926271 defendant Nevill Leonard yeoman 608919 608919 Nevill, Leonard, of Magna Driffeld, yeoman 5
4315951 2135692 2135692 defendant Bissit John husbandman 608919 608919 Bissit, John, of Magna Driffeld, husbandman 0
4321202 2137510 2137510 defendant Gardiner John husbandman 608919 608919 Gardiner, John, of Magna Driffeld, husbandman 2
4321203 2137510 2137510 defendant Bushbye William husbandman 608919 608919 Bushbye, William, of Magna Driffeld, husbandman 3
4341543 2144319 2144319 defendant Dawson Stephen yeoman 608919 608919 Dawson, Stephen, of Magna Driffeld, yeoman 0
4341545 2144320 2144320 defendant Wetherill William husbandman 608919 608919 Wetherill, William, of Magna Driffeld, husbandman 0
4341546 2144320 2144320 defendant Ulyett John husbandman 608919 608919 Ulyett, John, of Magna Driffeld, husbandman 1
4341547 2144320 2144320 defendant Messanger Richard husbandman 608919 608919 Messanger, Richard, of Magna Driffeld, husbandman 2
4390823 2161544 2161544 defendant Newton John, senior husbandman 608919 608919 Newton, John, senior, of Magna Driffeld, husbandman 0
4397178 2163629 2163629 defendant Dringe William husbandman 608919 608919 Dringe, William, of Magna Driffeld, husbandman 2
4409934 2167929 2167929 defendant Dayles Thomas yeoman 608919 608919 Dayles, Thomas, of Magna Driffeld, yeoman 0
4409935 2167929 2167929 defendant Hart Christopher laborer 608919 608919 Hart, Christopher, of Magna Driffeld, laborer 1
4409936 2167929 2167929 defendant Wetherill William yeoman 608919 608919 Wetherill, William, of Magna Driffeld, yeoman 2
4409938 2167930 2167930 defendant Newton John, junior husbandman 608919 608919 Newton, John, junior, of Magna Driffeld, husbandman 0
5578400 2528313 2528313 defendant Giles William yeoman 608919 608919 Giles, William, of Magna Driffeld, yeoman 1
5593722 2533025 2533025 defendant Paull Brian husbandman 608919 608919 Paull, Brian, of Magna Driffeld, husbandman 0
5593723 2533025 2533025 defendant Godfrey John husbandman 608919 608919 Godfrey, John, of Magna Driffeld, 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);