names

14 rows where place_id = 597192

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627623 1903501 1903501 defendant Lacye John yeoman 597192 597192 Lacye, John, of Crokhorn, yeoman 2
3627629 1903501 1903501 defendant Lawrens Thomas baker 597192 597192 Lawrens, Thomas, of Crokhorn, baker 8
3627630 1903501 1903501 defendant Lawrence Roger husbandman 597192 597192 Lawrence, Roger, of Crokhorn, husbandman 9
3627631 1903501 1903501 defendant Farnam Richard husbandman 597192 597192 Farnam, Richard, of Crokhorn, husbandman 10
3627632 1903501 1903501 defendant Tret John husbandman 597192 597192 Tret, John, of Crokhorn, husbandman 11
3627633 1903501 1903501 defendant Baker Robert husbandman 597192 597192 Baker, Robert, of Crokhorn, husbandman 12
3627634 1903501 1903501 defendant Brown Thomas husbandman 597192 597192 Brown, Thomas, of Crokhorn, husbandman 13
3627635 1903501 1903501 defendant Ellyat William carpenter 597192 597192 Ellyat, William, of Crokhorn, carpenter 14
3627636 1903501 1903501 defendant Ochirloke Robert husbandman 597192 597192 Ochirloke, Robert, of Crokhorn, husbandman 15
4456403 2187027 2187027 defendant Drok Robert   597192 597192 Drok, Robert, of Crokhorn, parson 6
4497810 2199957 2199957 defendant Spore John draper 597192 597192 Spore, John, of Crokhorn, draper 0
4500733 2200844 2200844 defendant Baker Thomas   597192 597192 Baker, Thomas, of Crokhorn, corsour 0
5597984 2534270 2534270 defendant Trotte John husbandman 597192 597192 Trotte, John, of Crokhorn, husbandman 2
5597985 2534270 2534270 defendant Bony "Unnam" husbandman 597192 597192 Bony, "Unnam", of Crokhorn, husbandman 3

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