names

21 rows where place_id = 675074

✎ 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
4016966 2030769 2030769 defendant Chamberlen Charles gent 675074 675074 Chamberlen, Charles, of Grymesthorp, gent 0
4796017 2294903 2294903 defendant Cartar Ralph yeoman 675074 675074 Cartar, Ralph, of Grymesthorp, yeoman 0
5121225 2392637 2392637 defendant Been John laborer 675074 675074 Been, John, of Grymesthorp, laborer 0
5219801 2421517 2421517 defendant Darly Philip gent 675074 675074 Darly, Philip, of Grymesthorp, gent 0
5219802 2421517 2421517 defendant Vernon Edmund gent 675074 675074 Vernon, Edmund, of Grymesthorp, gent 1
5219803 2421517 2421517 defendant Bokwyth Thomas yeoman 675074 675074 Bokwyth, Thomas, of Grymesthorp, yeoman 2
5219804 2421517 2421517 defendant Atkok William yeoman 675074 675074 Atkok, William,of Grymesthorp, yeoman 3
5219806 2421517 2421517 defendant Hornclyff Thomas   675074 675074 Hornclyff, Thomas, of Grymesthorp, groom 5
5219807 2421517 2421517 defendant Bell Robert   675074 675074 Bell, Robert, of Grymesthorp, servant 6
5219808 2421517 2421517 defendant Browederer John yeoman 675074 675074 Browederer, John, of Grymesthorp, yeoman 7
5219809 2421517 2421517 defendant Vernon Walter Edmund   675074 675074 Vernon, Walter Edmund, of Grymesthorp, servant 8
5219812 2421518 2421518 defendant Tylman William   675074 675074 Tylman, William, of Grymesthorp, groom 1
5219813 2421518 2421518 defendant Brych John   675074 675074 Brych, John, of Grymesthorp, groom 2
5219817 2421519 2421519 defendant Tylman William   675074 675074 Tylman, William, of Grymesthorp, groom 1
5219818 2421519 2421519 defendant Brych John   675074 675074 Brych, John, of Grymesthorp, groom 2
5219873 2421524 2421524 defendant Tilman William   675074 675074 Tilman, William, of Grymesthorp, groom 2
5219874 2421524 2421524 defendant Brych John   675074 675074 Brych, John, of Grymesthorp, groom 3
5242339 2427965 2427965 defendant Nevyll Robert gent 675074 675074 Nevyll, Robert, of Grymesthorp, gent 1
5272243 2436955 2436955 defendant Grenehowe Peter yeoman 675074 675074 Grenehowe, Peter, of Grymesthorp, yeoman 1
5292788 2442886 2442886 defendant Haxley Robert gent 675074 675074 Haxley, Robert, of Grymesthorp, gent 4
5316836 2450122 2450122 defendant Russell William husbandman 675074 675074 Russell, William, of Grymesthorp, 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);