names

12 rows where place_id = 840474

✎ 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
5051575 2372092 2372092 defendant Nicoll William husbandman 840474 840474 Nicoll, William, of Cregilston, husbandman 0
5096233 2385336 2385336 defendant Batte Lawrence husbandman 840474 840474 Batte, Lawrence, of Cregilston, husbandman 1
5128245 2394736 2394736 defendant Wilbore John husbandman 840474 840474 Wilbore, John, of Cregilston, husbandman 0
5128248 2394737 2394737 defendant Wilbore John husbandman 840474 840474 Wilbore, John, of Cregilston, husbandman 0
5128249 2394737 2394737 defendant Wilbore Richard yeoman 840474 840474 Wilbore, Richard, of Cregilston, yeoman 1
5295967 2443808 2443808 defendant Hardgade William husbandman 840474 840474 Hardgade, William, of Cregilston, husbandman 1
5295968 2443808 2443808 defendant Grave Thomas husbandman 840474 840474 Grave, Thomas, of Cregilston, husbandman 2
5295969 2443808 2443808 defendant Batty Robert husbandman 840474 840474 Batty, Robert, of Cregilston, husbandman 3
5394578 2473511 2473511 defendant Bate or Batte Robert yeoman 840474 840474 Bate or Batte, Robert, of Cregilston, yeoman 1
5443875 2488085 2488085 defendant Sprygonell Richard yeoman 840474 840474 Sprygonell, Richard, of Cregilston, yeoman 0
5443877 2488086 2488086 defendant Sprygonell Richard yeoman 840474 840474 Sprygonell, Richard, of Cregilston, yeoman 0
5518047 2510483 2510483 defendant Spreguonell Richard yeoman 840474 840474 Spreguonell, Richard, of Cregilston, 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);