names

28 rows where place_id = 604784

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3659278 1913156 1913156 defendant Smyth Richard yeoman 604784 604784 Smyth, Richard, of Adderbury, Oxon, yeoman 0
3660660 1913598 1913598 defendant Danyell Robert   604784 604784 Danyell, Robert, of Adderbury, Oxon, wheel wright 0
3769708 1948181 1948181 defendant Henne Thomas husbandman 604784 604784 (Henne, Thomas, of Adderbury, Oxon, husbandman 1
3873670 1981409 1981409 defendant Bustard Anthony gent 604784 604784 (Bustard, Anthony, of Adderbury, Oxon, gent 1
3883017 1984585 1984585 defendant Bustard Anthony gent 604784 604784 Bustard, Anthony, of Adderbury, Oxon, gent 0
3905219 1992008 1992008 defendant Eton Thomas gent 604784 604784 Eton, Thomas, of Adderbury, Oxon, gent 0
3916580 1995921 1995921 defendant Eyton or Gyton Thomas gent 604784 604784 Eyton or Gyton, Thomas, of Adderbury, Oxon, gent 0
3916582 1995922 1995922 defendant Eyton Thomas gent 604784 604784 Eyton, Thomas, of Adderbury, Oxon, gent 0
3916584 1995923 1995923 defendant Eyton Thomas gent 604784 604784 Eyton, Thomas, of Adderbury, Oxon, gent 0
3949391 2006858 2006858 defendant Lovett John gent 604784 604784 Lovett, John, of Adderbury, Oxon, gent 0
3966181 2012801 2012801 defendant Turner Richard yeoman 604784 604784 Turner, Richard, of Adderbury, Oxon, yeoman 0
3992466 2022069 2022069 defendant Turnor Richard yeoman 604784 604784 Turnor, Richard, of Adderbury, Oxon, yeoman 0
4111362 2064310 2064310 defendant Turnor Richard yeoman 604784 604784 Turnor, Richard, of Adderbury, Oxon, yeoman 0
4274945 2121189 2121189 defendant Bustard Anthony gent 604784 604784 Bustard, Anthony, of Adderbury, Oxon, gent 0
4325459 2138890 2138890 defendant Busterd Anthony gent 604784 604784 Busterd, Anthony, of Adderbury, Oxon, gent 1
4662781 2249817 2249817 defendant Fyfhyde John   604784 604784 Fyfhyde, John, of Adderbury, Oxon, householding man 0
4664340 2250329 2250329 defendant Adderbury John esq 604784 604784 Adderbury, John, of Adderbury, Oxon, esq 0
4739481 2277432 2277432 defendant Adderbery John gent 604784 604784 (Adderbery, John, of Adderbury, Oxon, gent 1
4884564 2322079 2322079 defendant Hawekyns Roger draper 604784 604784 Hawekyns, Roger, of Adderbury, Oxon, draper 2
4890025 2323662 2323662 defendant Hawekyns Roger draper 604784 604784 Hawekyns, Roger, of Adderbury, Oxon, draper 2
4955373 2343565 2343565 defendant Thommes William yeoman 604784 604784 Thommes, William, of Adderbury, Oxon, yeoman 0
5065963 2376343 2376343 defendant Lynde Richard, junior carpenter 604784 604784 Lynde, Richard, junior, of Adderbury, Oxon, carpenter 1
5075599 2379199 2379199 defendant Knolly Robert husbandman 604784 604784 Knolly, Robert, of Adderbury, Oxon, husbandman 0
5075601 2379200 2379200 defendant Knollys Robert husbandman 604784 604784 Knollys, Robert, of Adderbury, Oxon, husbandman 0
5075603 2379201 2379201 defendant Knollys Robert husbandman 604784 604784 Knollys, Robert, of Adderbury, Oxon, husbandman 0
5249381 2429934 2429934 defendant Atwell Roger husbandman 604784 604784 Atwell, Roger, of Adderbury, Oxon, husbandman 2
5286824 2441154 2441154 defendant Boyes Walter yeoman 604784 604784 Boyes, Walter, of Adderbury, Oxon, yeoman 0
5420275 2480989 2480989 defendant Mayhew Richard husbandman 604784 604784 Mayhew, Richard, of Adderbury, Oxon, husbandman 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);