names

14 rows where place_id = 756562

✎ 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
4429907 2174140 2174140 plaintiff Whit John   756562 756562 Whit, John, of Holtham, son of William 0
4438786 2181422 2181422 defendant Cadenay Robert   756562 756562 Cadenay, Robert, of Holtham 0
4442942 2182753 2182753 defendant Raa Alice   756562 756562 Raa, Alice, of Holtham, servant of Aleyn 2
4446893 2183943 2183943 plaintiff Douke or Donke Roger   756562 756562 Douke or Donke, Roger, of Holtham, parson 0
4446894 2183943 2183943 defendant Cokes Henry   756562 756562 Cokes, Henry, of Holtham 0
4464844 2189669 2189669 plaintiff West William   756562 756562 West, William, of Holtham, son of William 0
4470302 2191359 2191359 defendant Douke Roger   756562 756562 Douke, Roger, of Holtham, parson 3
4857289 2313668 2313668 defendant Barkeworth Walter husbandman 756562 756562 Barkeworth, Walter, of Holtham, husbandman 0
4973730 2349096 2349096 defendant Pulman Robert yeoman 756562 756562 Pulman, Robert, of Holtham, yeoman 5
5020467 2362874 2362874 defendant Blayk William tailor 756562 756562 Blayk, William, of Holtham, tailor 1
5020468 2362874 2362874 defendant Panyerman John, junior husbandman 756562 756562 Panyerman, John, junior, of Holtham, husbandman 2
5620431 2550250 2550250 defendant Barkeworth William de   756562 756562 Barkeworth, William de, of Holtham, son of, John 0
5621306 2550554 2550554 defendant Cokes Henry   756562 756562 Cokes, Henry, of Holtham 2
5621308 2550554 2550554 defendant White Richard   756562 756562 White, Richard, of Holtham, parson 4

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