names

13 rows where place_id = 608184

✎ 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
3672515 1917406 1917406 defendant Rechir Roger husbandman 608184 608184 Rechir, Roger, of Tremley St Martin, husbandman 0
4226394 2104704 2104704 defendant Pikeringe Lancelot yeoman 608184 608184 Pikeringe, Lancelot, of Tremley St Martin, yeoman 0
4832818 2306286 2306286 defendant Hare John yeoman 608184 608184 Hare, John, of Tremley St Martin, yeoman 0
5200676 2415956 2415956 defendant Hendy William husbandman 608184 608184 Hendy, William, of Tremley St Martin, husbandman 0
5211584 2419125 2419125 defendant Hyndy William husbandman 608184 608184 Hyndy, William, of Tremley St Martin, husbandman 0
5508652 2507570 2507570 defendant Sersent or Serfent Edmund husbandman 608184 608184 Sersent or Serfent, Edmund, of Tremley St Martin, husbandman 3
5558895 2522552 2522552 defendant Hyngot Roger mariner 608184 608184 Hyngot, Roger, of Tremley St Martin, mariner 2
5558896 2522552 2522552 defendant Cotton Geoffrey tailor 608184 608184 Cotton, Geoffrey, of Tremley St Martin, tailor 3
5561174 2523247 2523247 defendant Skutt William yeoman 608184 608184 Skutt, William, of Tremley St Martin, yeoman 0
5561175 2523247 2523247 defendant Hendy William husbandman 608184 608184 Hendy, William, of Tremley St Martin, husbandman 1
5561177 2523247 2523247 defendant Bryan John yeoman 608184 608184 Bryan, John, of Tremley St Martin, yeoman 3
5568745 2525407 2525407 defendant Sparman Adam husbandman 608184 608184 Sparman, Adam, of Tremley St Martin, husbandman 0
5601033 2535209 2535209 defendant Hendy John husbandman 608184 608184 Hendy, John, of Tremley St Martin, 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);