names

24 rows where place_id = 613511

✎ 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
3698724 1925817 1925817 defendant Eynold John, senior husbandman 613511 613511 Eynold, John, senior, of Bysshopston, husbandman 0
3698725 1925817 1925817 defendant Eynold John, junior husbandman 613511 613511 Eynold, John, junior, of Bysshopston, husbandman 1
3698726 1925817 1925817 defendant Eynold Nicholas husbandman 613511 613511 Eynold, Nicholas, of Bysshopston, husbandman 2
3745934 1940635 1940635 defendant Walters Thomas husbandman 613511 613511 Walters, Thomas, of Bysshopston, husbandman 3
3772814 1949190 1949190 defendant Eynold John, senior husbandman 613511 613511 Eynold, John, senior, of Bysshopston, husbandman 0
3772815 1949190 1949190 defendant Eynold John, junior husbandman 613511 613511 Eynold, John, junior, of Bysshopston, husbandman 1
3772816 1949190 1949190 defendant Eynold Nicholas husbandman 613511 613511 Eynold, Nicholas, of Bysshopston, husbandman 2
3779585 1951347 1951347 defendant Gyfford Thomas gent 613511 613511 Gyfford, Thomas, of Bysshopston, gent 0
3792586 1955539 1955539 defendant Robynson Richard husbandman 613511 613511 Robynson, Richard, of Bysshopston, husbandman 0
4019289 2031632 2031632 defendant Mathewe Robert (legal representative) 613511 613511 Mathewe, Robert, of Bysshopston, yeoman, administratrix of 0
4098764 2059888 2059888 defendant Barnedon John yeoman 613511 613511 Barnedon, John, of Bysshopston, yeoman 3
4118027 2066731 2066731 defendant Braye Thomas husbandman 613511 613511 Braye, Thomas, of Bysshopston, husbandman 0
4176098 2087117 2087117 defendant Gybson John clerk 613511 613511 Gybson, John, of Bysshopston, clerk 0
4316510 2135892 2135892 defendant Braye Thomas, senior yeoman 613511 613511 Braye, Thomas, senior, of Bysshopston, yeoman 0
4316511 2135892 2135892 defendant Braye John yeoman 613511 613511 Braye, John, of Bysshopston, yeoman 1
4316512 2135892 2135892 defendant Braye Richard yeoman 613511 613511 Braye, Richard, of Bysshopston, yeoman 2
4368464 2153767 2153767 defendant Lambe John yeoman 613511 613511 Lambe, John, of Bysshopston, yeoman 0
4373868 2155721 2155721 defendant Lambe John yeoman 613511 613511 Lambe, John, of Bysshopston, yeoman 0
4377256 2156940 2156940 defendant Harry Stephen yeoman 613511 613511 Harry, Stephen, of Bysshopston, yeoman 0
4377257 2156940 2156940 defendant Harrys Numan husbandman 613511 613511 Harrys, Numan, of Bysshopston, husbandman 1
4644623 2244517 2244517 defendant Hay John   613511 613511 Hay, John, of Bysshopston 3
4992081 2354522 2354522 defendant Apithell David husbandman 613511 613511 Apithell, David, of Bysshopston,husbandman 0
5370373 2466320 2466320 defendant Bythell John, senior husbandman 613511 613511 Bythell, John, senior, of Bysshopston, husbandman 3
5594844 2533356 2533356 defendant Fakener Hugh husbandman 613511 613511 Fakener, Hugh, of Bysshopston, 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);