names

22 rows where place_id = 598129

✎ 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
3631260 1904592 1904592 defendant Sible Henry   598129 598129 Sible, Henry, of Chevele 26
3631261 1904592 1904592 defendant Norbury Thomas   598129 598129 Norbury, Thomas, of Chevele 27
3631262 1904592 1904592 defendant Cagge Thomas   598129 598129 Cagge, Thomas, of Chevele 28
4439453 2181601 2181601 defendant Pyn John   598129 598129 Pyn, John, of Chevele 2
4440712 2182008 2182008 defendant Pyn John   598129 598129 Pyn, John, of Chevele 0
4460038 2188197 2188197 defendant Pyn John   598129 598129 Pyn, John, of Chevele 0
4480400 2194538 2194538 defendant Clerk Nicholas   598129 598129 Clerk, Nicholas, of Chevele 1
4480403 2194539 2194539 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 0
4515361 2205219 2205219 plaintiff Chevele William   598129 598129 Chevele, William, of Chevele 0
4556298 2217911 2217911 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 0
4578058 2224642 2224642 plaintiff Chevele William   598129 598129 Chevele, William, of Chevele 0
4580472 2225377 2225377 defendant Hervy Thomas   598129 598129 Hervy, Thomas, of Chevele, parson 0
4585867 2227000 2227000 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 1
4586718 2227250 2227250 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 1
4609650 2234114 2234114 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 0
4619396 2237057 2237057 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 0
4648986 2245753 2245753 defendant Smyth Richard   598129 598129 Smyth, Richard, of Chevele 0
4743080 2278496 2278496 defendant Coke John yeoman 598129 598129 Coke, John, of Chevele, yeoman 0
4795724 2294813 2294813 defendant Cooke John husbandman 598129 598129 Cooke, John, of Chevele, husbandman 0
5219692 2421488 2421488 defendant Everard John husbandman 598129 598129 Everard, John, of Chevele, husbandman 0
5234986 2425813 2425813 defendant Heyward George husbandman 598129 598129 Heyward, George, of Chevele, husbandman 0
5256357 2432112 2432112 defendant Norbury John yeoman 598129 598129 Norbury, John, of Chevele, yeoman 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);