names

29 rows where place_id = 588109

✎ 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
3593396 1865568 1865568 defendant Awyke John husbandman 588109 588109 Awyke, John, of Berwyke, husbandman 0
3652362 1911075 1911075 defendant Kyrton Thomas gent 588109 588109 Kyrton, Thomas, of Berwyke, gent 0
3694981 1924642 1924642 defendant Cane Thomas husbandman 588109 588109 Cane, Thomas, of Berwyke, husbandman 0
3696175 1925024 1925024 defendant Cane or Cave James husbandman 588109 588109 Cane or Cave, James, of Berwyke, husbandman 0
3696176 1925024 1925024 defendant Cane or Cave Thomas husbandman 588109 588109 Cane or Cave, Thomas, of Berwyke, husbandman 1
3767106 1947366 1947366 defendant Bryggys William yeoman 588109 588109 Bryggys, William, of Berwyke, yeoman 1
3767107 1947366 1947366 defendant Shawe John husbandman 588109 588109 Shawe, John, of Berwyke, husbandman 2
3778539 1951004 1951004 defendant Cane Thomas, junior yeoman 588109 588109 Cane, Thomas, junior, of Berwyke, yeoman 0
3778540 1951004 1951004 defendant Cane John laborer 588109 588109 Cane, John, of Berwyke, laborer 1
3784928 1953075 1953075 defendant Bryggys William yeoman 588109 588109 Bryggys, William, of Berwyke, yeoman 1
3784934 1953076 1953076 defendant Shawe John husbandman 588109 588109 Shawe, John, of Berwyke, husbandman 1
3801489 1958380 1958380 defendant Hardcastell James husbandman 588109 588109 Hardcastell, James, of Berwyke, husbandman 1
3830447 1967403 1967403 defendant Symkyn Cuthbert yeoman 588109 588109 Symkyn, Cuthbert, of Berwyke, yeoman 1
3830448 1967403 1967403 defendant Borden William yeoman 588109 588109 Borden, William, of Berwyke, yeoman 2
3830676 1967476 1967476 defendant Coniver William husbandman 588109 588109 Coniver, William, of Berwyke, husbandman 4
3873693 1981418 1981418 defendant Susan Richard husbandman 588109 588109 Susan, Richard, of Berwyke, husbandman 1
3882969 1984566 1984566 defendant Cane William husbandman 588109 588109 Cane, William, of Berwyke, husbandman 1
4167187 2084027 2084027 defendant Payne Edward yeoman 588109 588109 Payne, Edward, of Berwyke, yeoman 1
4599883 2231192 2231192 defendant Cowehird Henry   588109 588109 Cowehird, Henry, of Berwyke 3
4709827 2268432 2268432 defendant More Richard husbandman 588109 588109 More, Richard, of Berwyke, husbandman 0
4773926 2287824 2287824 defendant Loupe John clerk 588109 588109 Loupe, John, of Berwyke, clerk 0
5187269 2412003 2412003 defendant Porter Edward husbandman 588109 588109 Porter, Edward, of Berwyke, husbandman 4
5205548 2417368 2417368 defendant Porter Edward husbandman 588109 588109 Porter, Edward, of Berwyke, husbandman 4
5205549 2417368 2417368 defendant Porter Richard laborer 588109 588109 Porter, Richard, of Berwyke, laborer 5
5331790 2454589 2454589 defendant Downyng Thomas clerk 588109 588109 Downyng, Thomas, of Berwyke, clerk 0
5335108 2455567 2455567 defendant Lovet John husbandman 588109 588109 Lovet, John, of Berwyke, husbandman 1
5338785 2456703 2456703 defendant Gylham Richard laborer 588109 588109 Gylham, Richard, of Berwyke, laborer 0
5498609 2504527 2504527 plaintiff Okeford John   588109 588109 Okeford, John, of Berwyke 1
5560038 2522891 2522891 defendant Davy alias Touker Robert tucker 588109 588109 Davy alias Touker, Robert, of Berwyke, tucker 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);