names

16 rows where place_id = 600583

✎ 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
3641628 1907840 1907840 defendant Lacy John yeoman 600583 600583 Lacy, John, of Crokhorne, yeoman 5
3641632 1907840 1907840 defendant Laurens Thomas cooper 600583 600583 Laurens, Thomas, of Crokhorne, cooper 9
3641633 1907840 1907840 defendant Lawrens Roger husbandman 600583 600583 Lawrens, Roger, of Crokhorne, husbandman 10
3641634 1907840 1907840 defendant Farnam Richard husbandman 600583 600583 Farnam, Richard, of Crokhorne, husbandman 11
3641635 1907840 1907840 defendant Tret John husbandman 600583 600583 Tret, John, of Crokhorne, husbandman 12
3641636 1907840 1907840 defendant Baker Robert husbandman 600583 600583 Baker, Robert, of Crokhorne, husbandman 13
3641637 1907840 1907840 defendant Browne Thomas husbandman 600583 600583 Browne, Thomas, of Crokhorne, husbandman 14
3641638 1907840 1907840 defendant Elyat William carpenter 600583 600583 Elyat, William, of Crokhorne, carpenter 15
3641639 1907840 1907840 defendant Othirlake Robert husbandman 600583 600583 Othirlake, Robert, of Crokhorne, husbandman 16
3671412 1917037 1917037 defendant Roper Robert mercer 600583 600583 Roper, Robert, of Crokhorne, mercer 0
3676807 1918783 1918783 defendant Roper Robert chapman 600583 600583 Roper, Robert, of Crokhorne, chapman 0
3680581 1920007 1920007 defendant Meryfeld Richard roper 600583 600583 Meryfeld, Richard, of Crokhorne, roper 0
3772153 1948982 1948982 defendant Baker Thomas gent 600583 600583 Baker, Thomas, of Crokhorne, gent 0
3772156 1948983 1948983 defendant Baker Thomas gent 600583 600583 Baker, Thomas, of Crokhorne, gent 0
3854704 1975117 1975117 defendant Bennet John innholder 600583 600583 Bennet, John, of Crokhorne, innholder 0
5612824 2547769 2547769 defendant Pencrich John   600583 600583 Pencrich, John, of Crokhorne 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);