names

12 rows where place_id = 598570

✎ 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
3633139 1905177 1905177 defendant Jakson Richard clerk 598570 598570 Jakson, Richard, of Wytnesham, clerk 0
3690091 1923063 1923063 defendant Joye Thomas husbandman 598570 598570 Joye, Thomas, of Wytnesham, husbandman 0
3690093 1923064 1923064 defendant Joye Thomas husbandman 598570 598570 Joye, Thomas, of Wytnesham, husbandman 0
3956269 2009255 2009255 defendant Latymer William clerk 598570 598570 Latymer, William, of Wytnesham, clerk 0
4301734 2130728 2130728 defendant Whetcrofte William clerk 598570 598570 Whetcrofte, William, of Wytnesham, clerk 0
4301735 2130728 2130728 defendant Westbrowne John gent 598570 598570 Westbrowne, John, of Wytnesham, gent 1
4305030 2131902 2131902 defendant Whetcroft William gent 598570 598570 Whetcroft, William, of Wytnesham, clerk, gent 1
4354040 2148640 2148640 defendant Forthe Philologus gent 598570 598570 Forthe, Philologus, of Wytnesham, gent 0
4572373 2222899 2222899 defendant Reve Walter le (legal representative) 598570 598570 Reve, Walter le, of wytnesham, executors of 0
4824593 2303744 2303744 plaintiff Wardeyn Thomas   598570 598570 Wardeyn, Thomas, of Wytnesham 1
5549483 2519904 2519904 defendant Audeley John   598570 598570 Audeley, John, of Wytnesham, knight 0
5549492 2519905 2519905 defendant Audeley John   598570 598570 Audeley, John, of Wytnesham, knight 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);