names

19 rows where place_id = 662518

✎ 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
3965250 2012459 2012459 defendant Barnabye Robert husbandman 662518 662518 Barnabye, Robert, of Preston in Holdernes, husbandman 0
4114773 2065571 2065571 defendant Acye John yeoman 662518 662518 Acye, John, of Preston in Holdernes, yeoman 0
4172048 2085689 2085689 defendant Tesmonde Arthur yeoman 662518 662518 Tesmonde, Arthur, of Preston in Holdernes, yeoman 0
4172049 2085689 2085689 defendant Tesmonde Martha widow 662518 662518 Martha his wife, formerly Martha Acye, of Preston in Holdernes, widow 1
4261608 2116841 2116841 defendant Cooke William yeoman 662518 662518 Cooke, William, of Preston in Holdernes, yeoman 0
4313504 2134830 2134830 defendant Cokyn Wilfred yeoman 662518 662518 Cokyn, Wilfred, of Preston in Holdernes, yeoman 0
4313505 2134830 2134830 defendant Cokyn Christopher yeoman 662518 662518 Cokyn, Christopher, of Preston in Holdernes, yeoman 1
4313877 2134960 2134960 defendant Cockin Christopher yeoman 662518 662518 Cockin, Christopher, of Preston in Holdernes, yeoman 0
4315597 2135565 2135565 defendant Cockyn Wilfred yeoman 662518 662518 Cockyn, Wilfred, of Preston in Holdernes, yeoman 0
4317134 2136110 2136110 defendant Cockyn Christopher yeoman 662518 662518 Cockyn, Christopher, of Preston in Holdernes, yeoman 0
4376053 2156498 2156498 defendant Cockyn Wilfred yeoman 662518 662518 Cockyn, Wilfred, of Preston in Holdernes, yeoman 1
4395883 2163201 2163201 defendant Cooke William yeoman 662518 662518 Cooke, William, of Preston in Holdernes, yeoman 0
4395884 2163201 2163201 defendant Utye Philip clerk 662518 662518 Utye, Philip, of Preston in Holdernes, clerk 1
4653418 2247001 2247001 defendant Page John mercer 662518 662518 Page, John, of Preston in Holdernes, mercer 4
4898916 2326303 2326303 defendant Colman Richard husbandman 662518 662518 Colman, Richard, of Preston in Holdernes, husbandman 0
5080848 2380762 2380762 defendant Johnson Robert husbandman 662518 662518 Johnson, Robert, of Preston in Holdernes, husbandman 0
5376895 2468369 2468369 defendant Holme Robert gent 662518 662518 Holme, Robert, of Preston in Holdernes, gent 0
5386326 2471156 2471156 defendant Tog John chaplain 662518 662518 Tog, John, of Preston in Holdernes, chaplain 0
5542308 2517719 2517719 plaintiff Broun John   662518 662518 Broun, John, of Preston in Holdernes 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);