names

21 rows where place_id = 622019

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3744769 1940263 1940263 defendant Balle Robert yeoman 622019 622019 Balle, Robert, of Samford, yeoman 1
3826131 1966014 1966014 defendant Urche William husbandman 622019 622019 Urche, William, of Samford, husbandman 0
3842076 1971074 1971074 defendant Urche William husbandman 622019 622019 Urche, William, of Samford, husbandman 3
3880007 1983574 1983574 defendant Hamlyn John husbandman 622019 622019 Hamlyn, John, of Samford, husbandman 0
4306946 2132570 2132570 defendant Pyme John victualer 622019 622019 Pyme, John, of Samford, victualer 0
4359002 2150384 2150384 defendant Graunte Henry husbandman 622019 622019 Graunte, Henry, of Samford, husbandman 1
4359003 2150384 2150384 defendant Cowle Nicholas husbandman 622019 622019 Cowle, Nicholas, of Samford, husbandman 2
4601249 2231624 2231624 defendant Onywene John   622019 622019 Onywene, John, of Samford 1
4728373 2274111 2274111 defendant Sprygge John husbandman 622019 622019 Sprygge, John, of Samford, husbandman 1
4855515 2313087 2313087 plaintiff Asteley Ralph esq 622019 622019 Asteley, Ralph, of Samford, esq 0
4921630 2333223 2333223 defendant Wyldesshere William yeoman 622019 622019 Wyldesshere, William, of Samford, yeoman 3
4931078 2336112 2336112 defendant Clerke Walter husbandman 622019 622019 Clerke, Walter, of Samford, husbandman 0
5283166 2440141 2440141 defendant Rolf Thomas yeoman 622019 622019 Rolf, Thomas, of Samford, yeoman 1
5283196 2440152 2440152 defendant Rolf Thomas yeoman 622019 622019 Rolf, Thomas, of Samford, yeoman 1
5324961 2452544 2452544 defendant Baker John yeoman 622019 622019 Baker, John, of Samford, yeoman 4
5350851 2460378 2460378 defendant Bowton John husbandman 622019 622019 Bowton, John, of Samford, husbandman 1
5382044 2469922 2469922 defendant Mershe John yeoman 622019 622019 Mershe, John, of Samford, yeoman 1
5403417 2476051 2476051 defendant Mershe John yeoman 622019 622019 Mershe, John, of Samford, yeoman 1
5416500 2479852 2479852 defendant Braughton John gent 622019 622019 Braughton, John, of Samford, gent 0
5431121 2484247 2484247 defendant Goylynne John farmer of the preceptory 622019 622019 Goylynne, John, of Samford, farmer of the preceptory 0
5486029 2500708 2500708 defendant Horell John yeoman 622019 622019 Horell, John, of Samford, yeoman 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);