names

17 rows where case_id = 1903501

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627620 1903501 1903501 plaintiff Bray Edmund esq   Bray, Edmund, esq 0
3627621 1903501 1903501 defendant Coke John gent 595001 595001 Coke, John, of Shute, Devon, gent 0
3627622 1903501 1903501 defendant Spore William gent 595081 595081 Spore, William, of Misterton, gent 1
3627623 1903501 1903501 defendant Lacye John yeoman 597192 597192 Lacye, John, of Crokhorn, yeoman 2
3627624 1903501 1903501 defendant Estmond John gent 597193 597193 Estmond, John, of Midel Chenok, gent 3
3627625 1903501 1903501 defendant Creke John gent 597194 597194 Creke, John, of Huys, gent 4
3627626 1903501 1903501 defendant Michell Nicholas yeoman 597195 597195 Michell, Nicholas, of Meriot, yeoman 5
3627627 1903501 1903501 defendant Geffray Philip butcher 595081 595081 Geffray, Philip, of Misterton, butcher 6
3627628 1903501 1903501 defendant Hill Thomas husbandman 597196 597196 Hill, Thomas, of Seburgh, husbandman 7
3627629 1903501 1903501 defendant Lawrens Thomas baker 597192 597192 Lawrens, Thomas, of Crokhorn, baker 8
3627630 1903501 1903501 defendant Lawrence Roger husbandman 597192 597192 Lawrence, Roger, of Crokhorn, husbandman 9
3627631 1903501 1903501 defendant Farnam Richard husbandman 597192 597192 Farnam, Richard, of Crokhorn, husbandman 10
3627632 1903501 1903501 defendant Tret John husbandman 597192 597192 Tret, John, of Crokhorn, husbandman 11
3627633 1903501 1903501 defendant Baker Robert husbandman 597192 597192 Baker, Robert, of Crokhorn, husbandman 12
3627634 1903501 1903501 defendant Brown Thomas husbandman 597192 597192 Brown, Thomas, of Crokhorn, husbandman 13
3627635 1903501 1903501 defendant Ellyat William carpenter 597192 597192 Ellyat, William, of Crokhorn, carpenter 14
3627636 1903501 1903501 defendant Ochirloke Robert husbandman 597192 597192 Ochirloke, Robert, of Crokhorn, husbandman 15

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);