names

28 rows where place_id = 761702

✎ 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
4481187 2194799 2194799 defendant Ray Lawrence   761702 761702 Ray, Lawrence, of Marcheford 0
4537870 2212129 2212129 defendant Snathesey John   761702 761702 Snathesey, John, of Marcheford 1
4603576 2232305 2232305 plaintiff Worthlyche William   761702 761702 Worthlyche, William, of Marcheford 0
4613086 2235148 2235148 defendant Porynge John smith 761702 761702 Porynge, John, of Marcheford, smith 10
4645966 2244892 2244892 defendant Lenton Thomas   761702 761702 Lenton, Thomas, of Marcheford 0
4730546 2274753 2274753 defendant Spynk John yeoman 761702 761702 Spynk, John, of Marcheford, yeoman 0
4815470 2300943 2300943 defendant Marcheford John chaplain 761702 761702 Marcheford, John, of Marcheford, chaplain 0
4946526 2340908 2340908 defendant Wolryche William fisher 761702 761702 Wolryche, William, of Marcheford, fisher 0
5004766 2358298 2358298 defendant Carter John husbandman 761702 761702 Carter, John, of Marcheford, husbandman 3
5004767 2358298 2358298 defendant Emnethe Simon shoemaker 761702 761702 Emnethe, Simon, of Marcheford, shoemaker 4
5004768 2358298 2358298 defendant Baret William brewer 761702 761702 Baret, William, of Marcheford, brewer 5
5004775 2358298 2358298 defendant Neuton Ivan husbandman 761702 761702 Neuton, Ivan, of Marcheford, husbandman 12
5004778 2358298 2358298 defendant Estmond Robert husbandman 761702 761702 Estmond, Robert, of Marcheford, husbandman 15
5004779 2358298 2358298 defendant Jaynkynson thomas husbandman 761702 761702 Jaynkynson, thomas, of Marcheford, husbandman 16
5004780 2358298 2358298 defendant Stank William husbandman 761702 761702 Stank, William, of Marcheford, husbandman 17
5004781 2358298 2358298 defendant Mobbe William husbandman 761702 761702 Mobbe, William, of Marcheford, husbandman 18
5004797 2358302 2358302 defendant Carter John shoemaker 761702 761702 Carter, John, of Marcheford, shoemaker 3
5004798 2358302 2358302 defendant Baret William brewer 761702 761702 Baret, William, of Marcheford, brewer 4
5004804 2358302 2358302 defendant Neuton Thomas yeoman 761702 761702 Neuton, Thomas, of Marcheford, yeoman 10
5004805 2358302 2358302 defendant Neuton Ivan husbandman 761702 761702 Neuton, Ivan, of Marcheford, husbandman 11
5004807 2358302 2358302 defendant Doget William husbandman 761702 761702 Doget, William,of Marcheford, husbandman 13
5004808 2358302 2358302 defendant Estmond Robert husbandman 761702 761702 Estmond, Robert, of Marcheford, husbandman 14
5004809 2358302 2358302 defendant Jankynson Thomas husbandman 761702 761702 Jankynson, Thomas, of Marcheford, husbandman 15
5004810 2358302 2358302 defendant Stank William husbandman 761702 761702 Stank, William, of Marcheford, husbandman 16
5004811 2358302 2358302 defendant Mobbe William husbandman 761702 761702 Mobbe, William, of Marcheford, husbandman 17
5054229 2372855 2372855 defendant Mathewe William fisher 761702 761702 Mathewe, William, of Marcheford, fisher 1
5610754 2547083 2547083 defendant Stevenson Thomas   761702 761702 Stevenson, Thomas, of Marcheford 0
5619472 2549938 2549938 defendant Messager Ralph   761702 761702 Messager, Ralph, of Marcheford 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);