names

34 rows where place_id = 597334

✎ 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
3628174 1903668 1903668 defendant Hobard Thomas husbandman 597334 597334 Hobard, Thomas, of Offeley, husbandman 0
3628177 1903668 1903668 defendant Bolys Thomas laborer 597334 597334 Bolys, Thomas, of Offeley, laborer 3
3681205 1920204 1920204 defendant Holder Lawrence husbandman 597334 597334 Holder, Lawrence, of Offeley, husbandman 0
3681206 1920204 1920204 defendant Samwell William laborer 597334 597334 Samwell, William, of Offeley, laborer 1
3681209 1920204 1920204 defendant Erle Richard laborer 597334 597334 Erle, Richard, of Offeley, laborer 4
3689633 1922918 1922918 defendant Hunt John husbandman 597334 597334 Hunt, John, of Offeley, husbandman 1
3717510 1931764 1931764 plaintiff Dormer Thomas yeoman 597334 597334 Dormer, Thomas, of Offeley, yeoman 0
3855064 1975212 1975212 defendant Shepard John husbandman 597334 597334 Shepard, John, of Offeley, husbandman 0
3855066 1975213 1975213 defendant Shepard John husbandman 597334 597334 Shepard, John, of Offeley, husbandman 0
3907189 1992696 1992696 defendant Gravener Robert husbandman 597334 597334 Gravener, Robert, of Offeley, husbandman 0
3907190 1992696 1992696 defendant Hakyns George husbandman 597334 597334 Hakyns, George, of Offeley, husbandman 1
3917273 1996136 1996136 defendant Hill Thomas husbandman 597334 597334 Hill, Thomas, of Offeley, husbandman 0
3917274 1996136 1996136 defendant Hill Joyce widow 597334 597334 Hill, Joyce, of Offeley, widow 1
3921234 1997453 1997453 defendant Copcott Margaret   597334 597334 Copcott, Margaret, of Offeley, gentlewoman, widow of Copcote, Richard, of Parva Gaddesden 1
4578613 2224799 2224799 defendant Smyth John   597334 597334 Smyth, John, of Offeley 0
4636468 2242239 2242239 defendant atte Welle John   597334 597334 atte Welle, John, of Offeley 1
4636472 2242240 2242240 defendant atte Welle John   597334 597334 atte Welle, John, of Offeley 1
4829820 2305371 2305371 defendant Clyve or Clyne Stephen husbandman 597334 597334 Clyve or Clyne, Stephen, of Offeley, husbandman 2
4855038 2312928 2312928 defendant Grubbe John (legal representative) 597334 597334 Grubbe, John, of Offeley, executor of 0
5042268 2369292 2369292 defendant Kylbese Thomas husbandman 597334 597334 Kylbese, Thomas, of Offeley, husbandman 0
5042270 2369293 2369293 defendant Kylbese Thomas husbandman 597334 597334 Kylbese, Thomas, of Offeley, husbandman 0
5159768 2403958 2403958 defendant Power Thomas husbandman 597334 597334 Power, Thomas, of Offeley, husbandman 0
5315420 2449672 2449672 defendant Brother alias Knyght Lawrence carpenter 597334 597334 Brother alias Knyght, Lawrence, of Offeley, carpenter 1
5315423 2449672 2449672 defendant Monke John husbndman 597334 597334 Monke, John, of Offeley, husbndman 4
5319823 2451021 2451021 defendant Shepherd William, junior husbandman 597334 597334 Shepherd, William, junior, of Offeley, husbandman 1
5319824 2451021 2451021 defendant Shepherd Lawrence husbandman 597334 597334 Shepherd, Lawrence, of Offeley, husbandman 2
5319825 2451021 2451021 defendant Shepherd Thomas husbandman 597334 597334 Shepherd, Thomas, of Offeley, husbandman 3
5338065 2456476 2456476 defendant Shepherd John husbandman 597334 597334 Shepherd, John, of Offeley, husbandman 0
5347626 2459412 2459412 defendant Shepherd John husbandman 597334 597334 Shepherd, John, of Offeley, husbandman 0
5436003 2485707 2485707 defendant Samme Henry husbandman 597334 597334 Samme, Henry, of Offeley, husbandman 1
5545135 2518581 2518581 defendant Shepherde Richard   597334 597334 Shepherde, Richard, of Offeley, husbandman, son of Shiphird, William, of Welwyn 2
5587688 2531166 2531166 defendant Kanke Roger husbandman 597334 597334 Kanke, Roger, of Offeley, husbandman 0
5590250 2531920 2531920 defendant Thorne John husbandman 597334 597334 Thorne, John, of Offeley, husbandman 1
5595863 2533618 2533618 defendant Monk Robert husbandman 597334 597334 Monk, Robert, of Offeley, 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);