names

24 rows where place_id = 780053

✎ 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
4567166 2221292 2221292 plaintiff Taillour John   780053 780053 Taillour, John, of Gilden Mordon, vicar 0
4567199 2221303 2221303 plaintiff Tailour John   780053 780053 Tailour, John, of Gilden Mordon, vicar 0
4665797 2250779 2250779 defendant Vyse Geoffrey courser 780053 780053 Vyse, Geoffrey, of Gilden Mordon, courser 0
4690518 2262591 2262591 defendant Plesele Roger husbandman 780053 780053 Plesele, Roger, of Gilden Mordon, husbandman 1
4732504 2275339 2275339 defendant Morgey Robert carpenter 780053 780053 Morgey, Robert, of Gilden Mordon, carpenter 1
4737685 2276892 2276892 defendant Aunger Geoffrey   780053 780053 Aunger, Geoffrey, of Gilden Mordon, corsour 0
4746252 2279400 2279400 defendant Godfray John husbandman 780053 780053 Godfray, John, of Gilden Mordon, husbandman 0
4746253 2279400 2279400 defendant Frost William, junior husbandman 780053 780053 Frost, William, junior, of Gilden Mordon, husbandman 1
4746254 2279400 2279400 defendant Reve John pulter 780053 780053 Reve, John, of Gilden Mordon, pulter 2
4918371 2332263 2332263 defendant Lovesey Hugh husbandman 780053 780053 Lovesey, Hugh, of Gilden Mordon, husbandman 1
4938528 2338429 2338429 defendant Hasylden William gent 780053 780053 Hasylden, William, of Gilden Mordon, gent 0
4944494 2340257 2340257 defendant Holwell William husbandman 780053 780053 Holwell, William, of Gilden Mordon, husbandman 4
4964139 2346185 2346185 defendant Auncell William yeoman 780053 780053 Auncell, William, of Gilden Mordon, yeoman 0
5073660 2378606 2378606 defendant Hasylden William gent 780053 780053 Hasylden, William, of Gilden Mordon, gent 0
5101963 2386997 2386997 defendant Frost William husbandman 780053 780053 Frost, William, of Gilden Mordon, husbandman 0
5122650 2393057 2393057 defendant Hylgare William husbandman 780053 780053 Hylgare, William, of Gilden Mordon, husbandman 0
5208729 2418277 2418277 defendant Hasilden William esq 780053 780053 Hasilden, William, of Gilden Mordon, esq 0
5208730 2418277 2418277 defendant Alen John yeoman 780053 780053 Alen, John, of Gilden Mordon, yeoman 1
5238838 2426949 2426949 defendant Baldry John husbandman 780053 780053 Baldry, John, of Gilden Mordon, husbandman 1
5238839 2426949 2426949 defendant Horwod John husbandman 780053 780053 Horwod, John, of Gilden Mordon, husbandman 2
5255764 2431924 2431924 defendant Godfray Henry husbandman 780053 780053 Godfray, Henry, of Gilden Mordon, husbandman 0
5255765 2431924 2431924 defendant Holwell Richard husbandman 780053 780053 Holwell, Richard, of Gilden Mordon, husbandman 1
5267124 2435476 2435476 defendant Bragge William husbandman 780053 780053 Bragge, William, of Gilden Mordon, husbandman 0
5548184 2519498 2519498 defendant Browen James draper 780053 780053 Browen, James, of Gilden Mordon, draper 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);