names

34 rows where place_id = 757164

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4443808 2183038 2183038 defendant Pye John   757164 757164 Pye, John, of Faryndon 0
4443809 2183038 2183038 defendant Mulleward John   757164 757164 Mulleward, John, of Faryndon 1
4443810 2183038 2183038 defendant Tanners Henry   757164 757164 Tanners, Henry, of Faryndon 2
4443811 2183038 2183038 defendant Sharp Thomas   757164 757164 Sharp, Thomas, of Faryndon 3
4446766 2183905 2183905 defendant Roo William   757164 757164 Roo, William, of Faryndon 0
4478226 2193863 2193863 defendant Cartere Henry   757164 757164 Cartere, Henry, of Faryndon 0
4496531 2199589 2199589 defendant Crouche John   757164 757164 Crouche, John, of Faryndon 1
4509836 2203564 2203564 plaintiff Bailly (illegible)   757164 757164 Bailly, _, of Faryndon 0
4522700 2207438 2207438 plaintiff Gybbes Henry   757164 757164 Gybbes, Henry, of Faryndon 0
4537652 2212048 2212048 defendant Hunte William   757164 757164 Hunte, William, of Faryndon 0
4545227 2214430 2214430 defendant atte Halle Walter   757164 757164 atte Halle, Walter, of Faryndon 0
4545231 2214431 2214431 defendant Russell Richard   757164 757164 Russell, Richard, of Faryndon 2
4545237 2214432 2214432 defendant Russell Richard   757164 757164 Russell, Richard, of Faryndon 3
4590069 2228256 2228256 plaintiff Lynam Simon   757164 757164 Lynam, Simon, of Faryndon, Winchester diocese, parson 0
4590071 2228256 2228256 defendant Lacy Nicholas   757164 757164 Lacy, Nicholas, of Faryndon 1
4607249 2233378 2233378 defendant Bailby Henry (legal representative) 757164 757164 Bailby, Henry, of Faryndon, executors of 3
4611860 2234772 2234772 defendant Webbe Robert   757164 757164 Webbe, Robert, of Faryndon 2
4626007 2239091 2239091 defendant Herdeman John   757164 757164 Herdeman, John, of Faryndon 0
4636813 2242329 2242329 defendant Bryt John   757164 757164 Bryt, John, of Faryndon 0
4640467 2243323 2243323 plaintiff Dunmere Richard   757164 757164 Dunmere, Richard, of Faryndon 0
4650053 2246029 2246029 plaintiff Webbe Richard   757164 757164 Webbe, Richard, of Faryndon 0
4663431 2250037 2250037 plaintiff Godeman Richard   757164 757164 Godeman, Richard, of Faryndon 0
4668066 2255719 2255719 defendant Bernard Stephen husbandman 757164 757164 Bernard, Stephen, of Faryndon, husbandman 0
4668067 2255719 2255719 defendant Playstowe William husbandman 757164 757164 Playstowe, William, of Faryndon, husbandman 1
4668068 2255719 2255719 defendant Colswayn John husbandman 757164 757164 Colswayn, John, of Faryndon, husbandman 2
4677106 2258456 2258456 defendant Tyrry John husbandman 757164 757164 Tyrry, John, of Faryndon, junior, husbandman 0
4683898 2260572 2260572 defendant Mapuldram Peter husbandman 757164 757164 Mapuldram, Peter, of Faryndon, husbandman 0
4756348 2282351 2282351 defendant Duke John chaplain 757164 757164 Duke, John, of Faryndon, chaplain 0
4763097 2284439 2284439 defendant Muyn John weaver 757164 757164 Muyn, John, of Faryndon, weaver 0
4819898 2302298 2302298 defendant Clenche Richard   757164 757164 Clenche, Richard, of Faryndon, servant 3
5615103 2548514 2548514 defendant Frebody John   757164 757164 Frebody, John, of Faryndon 2
5621125 2550491 2550491 defendant Lowys Geoffrey   757164 757164 Lowys, Geoffrey, of Faryndon 0
5621126 2550491 2550491 defendant Lok John   757164 757164 Lok, John, of Faryndon, servant of the parson 1
5629132 2553084 2553084 defendant Youle John husbandman 757164 757164 Youle, John, of Faryndon, husbandman 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);