names

23 rows where place_id = 603194

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653819 1911454 1911454 defendant Stote Richard draper 603194 603194 Stote, Richard, of Lyskerd, Cornw, draper 1
3708640 1928999 1928999 defendant Mark William pardoner 603194 603194 Mark, William, of Lyskerd, Cornw, pardoner 2
3745338 1940448 1940448 defendant Philipp John yeoman 603194 603194 Philipp, John, of Lyskerd, Cornw, yeoman 0
3758086 1944514 1944514 defendant Marke William yeoman 603194 603194 Marke, William, of Lyskerd, Cornw, yeoman 0
3758089 1944515 1944515 defendant Philipp John clerk 603194 603194 Philipp, John, of Lyskerd, Cornw, clerk 0
3758101 1944519 1944519 defendant Marke John yeoman 603194 603194 Marke, John, of Lyskerd, Cornw, yeoman 0
3788904 1954340 1954340 defendant Coryngton Peter esq 603194 603194 Coryngton, Peter, of Lyskerd, Cornw, esq 1
3864476 1978318 1978318 defendant Quyntrell Richard yeoman 603194 603194 Quyntrell, Richard, of Lyskerd, Cornw, yeoman 0
3878533 1983064 1983064 defendant Quyntrell Richard yeoman 603194 603194 Quyntrell, Richard, of Lyskerd, Cornw, yeoman 0
3932701 2001236 2001236 defendant Arundull Robert gent 603194 603194 Arundull, Robert, of Lyskerd, Cornw, gent 0
3932704 2001237 2001237 defendant Arundall Robert gent 603194 603194 Arundall, Robert, of Lyskerd, Cornw, gent 0
3956602 2009373 2009373 defendant Grose William yeoman 603194 603194 Grose, William, of Lyskerd, Cornw, yeoman 1
3957092 2009549 2009549 defendant Comacke John yeoman 603194 603194 Comacke, John, of Lyskerd, Cornw, yeoman 0
3977284 2016625 2016625 defendant Carswill William grocer 603194 603194 Carswill, William, of Lyskerd, Cornw, grocer 0
4100620 2060547 2060547 defendant Grosse William yeoman 603194 603194 Grosse, William, of Lyskerd, Cornw, yeoman 0
4100623 2060548 2060548 defendant Grosse William yeoman 603194 603194 Grosse, William, of Lyskerd, Cornw, yeoman 0
4102164 2061069 2061069 defendant Connocke John, junior gent 603194 603194 Connocke, John, junior, of Lyskerd, Cornw, gent 2
4102731 2061277 2061277 defendant Grosse William gent 603194 603194 Grosse, William, of Lyskerd, Cornw, gent 0
4244422 2111111 2111111 defendant Connocke John gent 603194 603194 Connocke, John, of Lyskerd, Cornw, gent 0
5263558 2434350 2434350 defendant Graunt Richard clerk 603194 603194 Graunt, Richard, of Lyskerd, Cornw, clerk 0
5336362 2455942 2455942 defendant John Robert yeoman 603194 603194 John, Robert, of Lyskerd, Cornw, yeoman 4
5410746 2478159 2478159 defendant Bromboyte John yeoman 603194 603194 Bromboyte, John, of Lyskerd, Cornw, yeoman 0
5596286 2533751 2533751 defendant Gayer Alice widow 603194 603194 Gayer, Alice, of Lyskerd, Cornw, widow 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);