names

16 rows where place_id = 708837

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4136739 2073488 2073488 defendant Jerham alias Jerome Peter gent 708837 708837 Jerham alias Jerome, Peter, of Cold Norton, or of Daneburie, Essex, gent 0
4175239 2086803 2086803 defendant Brett Anthony yeoman 708837 708837 Brett, Anthony, of Cold Norton, or of Purleighe, Essex, yeoman 0
4175240 2086803 2086803 defendant Jerome Peter gent 708837 708837 Jerome, Peter, of Cold Norton, gent 1
4360458 2150907 2150907 defendant Thayer John husbandman 708837 708837 Thayer, John, of Cold Norton, husbandman 1
4385791 2159939 2159939 defendant Osborne Edward yeoman 708837 708837 Osborne, Edward, of Cold Norton, yeoman 2
4385795 2159940 2159940 defendant Walker William yeoman 708837 708837 Walker, William, of Cold Norton, yeoman 0
4385797 2159940 2159940 defendant Denham Richard husbandman 708837 708837 Denham, Richard, of Cold Norton, husbandman 2
4626464 2239226 2239226 plaintiff Prior William   708837 708837 Prior, William, of Cold Norton 0
4642025 2243774 2243774 defendant Hunte William   708837 708837 Hunte, William, of Cold Norton 0
4921079 2333106 2333106 defendant Cook John husbandman 708837 708837 Cook, John, of Cold Norton, husbandman 0
5072137 2378156 2378156 defendant Smyth alias Webbe Walter   708837 708837 Smyth alias Webbe, Walter, of Cold Norton, herde or herder 0
5461453 2493381 2493381 plaintiff Mounteney William (legal representative) 708837 708837 Mounteney, William, of Cold Norton, gent, executors of 0
5477603 2498318 2498318 defendant Cornewalys Robert gent 708837 708837 Cornewalys, Robert, of Cold Norton, gent 2
5530394 2514019 2514019 defendant Colby Robert yeoman 708837 708837 Colby, Robert, of Cold Norton, yeoman 0
5570489 2525941 2525941 defendant Sherman Thomas husbandman 708837 708837 Sherman, Thomas, of Cold Norton, husbandman 0
5617816 2549386 2549386 defendant Moreatte Robert   708837 708837 Moreatte, Robert, of Cold Norton, parson 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);