names

16 rows where place_id = 595492

✎ 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
3620667 1874042 1874042 defendant Large Henry yeoman 595492 595492 Large, Henry, of Beston juxta Mileham, yeoman 1
3620670 1874042 1874042 defendant Large John husbandman 595492 595492 Large, John, of Beston juxta Mileham, husbandman 4
3650951 1910667 1910667 defendant Wryght Thomas husbandman 595492 595492 Wryght, Thomas, of Beston juxta Mileham, husbandman 1
3693765 1924246 1924246 defendant Large Henry butcher 595492 595492 Large, Henry, of Beston juxta Mileham, butcher 0
3834778 1968814 1968814 defendant Deny John yeoman 595492 595492 Deny, John, of Beston juxta Mileham, yeoman 0
3875365 1982007 1982007 defendant Skynner Robert yeoman 595492 595492 Skynner, Robert, of Beston juxta Mileham, yeoman 0
3888775 1986496 1986496 defendant Aleyn Avice widow 595492 595492 (Aleyn, Avice, of Beston juxta Mileham, widow 3
3888776 1986496 1986496 defendant Aleyn John husbandman 595492 595492 Aleyn, John, of Beston juxta Mileham, husbandman 4
3963825 2011949 2011949 defendant Hey Nicholas butcher 595492 595492 Hey, Nicholas, of Beston juxta Mileham, butcher 1
3980895 2017928 2017928 defendant Spelman Erasmus esq 595492 595492 Spelman, Erasmus, of Beston juxta Mileham, esq 0
4043557 2040155 2040155 defendant Spelman Erasmus gent 595492 595492 Spelman, Erasmus, of Beston juxta Mileham, gent 0
4043561 2040156 2040156 defendant Spelman Erasmus gent 595492 595492 Spelman, Erasmus, of Beston juxta Mileham, gent 0
4210914 2099376 2099376 defendant Thirkeld Robert yeoman 595492 595492 Thirkeld, Robert, of Beston juxta Mileham, yeoman 0
4345504 2145697 2145697 defendant Graver Robert carpenter 595492 595492 Graver, Robert, of Beston juxta Mileham, carpenter 3
5520442 2511214 2511214 defendant Yelverton Nicholas gent 595492 595492 Yelverton, Nicholas, of Beston juxta Mileham, gent 0
5635387 2555033 2555033 defendant Skirbek Thomas chapman 595492 595492 Skirbek, Thomas, of Beston juxta Mileham, chapman 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);