names

25 rows where place_id = 602157

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648701 1909981 1909981 defendant Blakburn Peter husbandman 602157 602157 Blakburn, Peter, of Hunmanby, husbandman 0
3648702 1909981 1909981 defendant Blakburn George husbandman 602157 602157 Blakburn, George, of Hunmanby, husbandman 1
3648703 1909981 1909981 defendant Wodman Thomas laborer 602157 602157 Wodman, Thomas, of Hunmanby, laborer 2
3648704 1909981 1909981 defendant Symson John laborer 602157 602157 Symson, John, of Hunmanby, laborer 3
4323192 2138171 2138171 defendant Leppington Anne widow 602157 602157 Leppington, Anne, of Hunmanby, widow 1
4564855 2220570 2220570 defendant Maddok Thomas   602157 602157 Maddok, Thomas, of Hunmanby 15
4564856 2220570 2220570 defendant Ploman Richard   602157 602157 Ploman, Richard, of Hunmanby 16
4564857 2220570 2220570 defendant Chapman Richard   602157 602157 Chapman, Richard, of Hunmanby 17
4657264 2248161 2248161 plaintiff Clerk Roger   602157 602157 Clerk, Roger, of Hunmanby 0
4764814 2284976 2284976 defendant Maddok Thomas tanner 602157 602157 Maddok, Thomas, of Hunmanby, tanner 0
4764815 2284976 2284976 defendant Maddok Thomas chaplain 602157 602157 Maddok, Thomas, of Hunmanby, chaplain 1
4819012 2302026 2302026 defendant Symson William husbandman 602157 602157 Symson, William, of Hunmanby, husbandman 0
4929807 2335735 2335735 defendant Couper John husbandman 602157 602157 Couper, John, of Hunmanby, husbandman 1
4981584 2351404 2351404 defendant Brymley Thomas chaplain 602157 602157 Brymley, Thomas, of Hunmanby, chaplain 1
5093503 2384500 2384500 defendant Pawelyn Stephen husbandman 602157 602157 Pawelyn, Stephen, of Hunmanby, husbandman 0
5093504 2384500 2384500 defendant Gaire William husbandman 602157 602157 Gaire, William, of Hunmanby, husbandman 1
5093505 2384500 2384500 defendant Parkynson Robert husbandman 602157 602157 Parkynson, Robert, of Hunmanby, husbandman 2
5093506 2384500 2384500 defendant Pardo Thomas husbandman 602157 602157 Pardo, Thomas, of Hunmanby, husbandman 3
5093507 2384500 2384500 defendant Clerk Richard husbandman 602157 602157 Clerk, Richard, of Hunmanby, husbandman 4
5093508 2384500 2384500 defendant Coke John husbandman 602157 602157 Coke, John, of Hunmanby, husbandman 5
5093509 2384500 2384500 defendant Race John husbandman 602157 602157 Race, John, of Hunmanby, husbandman 6
5115690 2391017 2391017 defendant Ramege William chaplain 602157 602157 Ramege, William, of Hunmanby, chaplain 1
5503197 2505907 2505907 defendant Riggald Margaret widow 602157 602157 Riggald, Margaret, of Hunmanby, widow 7
5624075 2551477 2551477 defendant Wryght William husbandman 602157 602157 Wryght, William, of Hunmanby, husbandman 0
5624076 2551477 2551477 defendant Xroxseby William baker 602157 602157 Xroxseby, William, of Hunmanby, baker 1

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);