names

22 rows where place_id = 652451

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3923757 1998252 1998252 defendant Hyckys alias Rundell William butcher 652451 652451 Hyckys alias Rundell, William, of Gregorystoke, butcher 1
4139291 2074421 2074421 defendant Wilmott William butcher 652451 652451 Wilmott, William, of Gregorystoke, butcher 2
4161327 2082041 2082041 defendant Newton John jusbandman 652451 652451 Newton, John, of Gregorystoke, jusbandman 0
4182958 2089520 2089520 defendant Henborowe John butcher 652451 652451 Henborowe, John, of Gregorystoke, butcher 0
4230854 2106287 2106287 defendant Wilott William husbandman 652451 652451 Wilott, William, of Gregorystoke, husbandman 0
4241746 2110226 2110226 defendant Curtys John husbandman 652451 652451 Curtys, John, of Gregorystoke, husbandman 0
4241748 2110227 2110227 defendant Curtys John husbandman 652451 652451 Curtys, John, of Gregorystoke, husbandman 0
4241749 2110227 2110227 defendant Bloden John husbandman 652451 652451 Bloden, John, of Gregorystoke, husbandman 1
4241750 2110227 2110227 defendant Lynt William husbandman 652451 652451 Lynt, William, of Gregorystoke, husbandman 2
4243966 2110963 2110963 defendant Pocock William, junior butcher 652451 652451 Pocock, William, junior, of Gregorystoke, yeoman, butcher 0
4243967 2110963 2110963 defendant Pocock William, senior husbandman 652451 652451 Pocock, William, senior, of Gregorystoke, husbandman 1
4243968 2110963 2110963 defendant Eston John husbandman 652451 652451 Eston, John, of Gregorystoke, husbandman 2
4262036 2116979 2116979 defendant Wilmott William husbandman 652451 652451 Wilmott, William, of Gregorystoke, husbandman 0
4287578 2125606 2125606 defendant Zane John (legal representative) 652451 652451 Zane, John, of Gregorystoke, husbandman, administratrix of 0
4287579 2125606 2125606 defendant Zane Joan widow 652451 652451 Zane, Joan, of Gregorystoke, widow 1
4656297 2247861 2247861 defendant Hoke John husbandman 652451 652451 Hoke, John, of Gregorystoke, husbandman 0
5098715 2386053 2386053 defendant Bryce John husbandman 652451 652451 Bryce, John, of Gregorystoke, husbandman 2
5098716 2386053 2386053 defendant Craddok Thomas husbandman 652451 652451 Craddok, Thomas, of Gregorystoke, husbandman 3
5099144 2386175 2386175 defendant Bryce John husbandman 652451 652451 Bryce, John, of Gregorystoke, husbandman 0
5099145 2386175 2386175 defendant Craddok Thomas husbandman 652451 652451 Craddok, Thomas, of Gregorystoke, husbandman 1
5520399 2511201 2511201 defendant Mille John husbandman 652451 652451 Mille, John, of Gregorystoke, husbandman 2
5544084 2518258 2518258 defendant Eliott alias Mille John husbandman 652451 652451 Eliott alias Mille, John, of Gregorystoke, 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);