names

39 rows where place_id = 596057

✎ 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
3622941 1874703 1874703 defendant Frary Richard yeoman 596057 596057 Frary, Richard, of Hedcrone, yeoman 1
3635643 1905949 1905949 defendant Badnore Thomas laborer 596057 596057 Badnore, Thomas, of Hedcrone, laborer 2
3708979 1929102 1929102 defendant Water Clement laborer 596057 596057 Water, Clement, of Hedcrone, laborer 1
3748776 1941551 1941551 defendant Halsnoth Thomas laborer 596057 596057 Halsnoth, Thomas, of Hedcrone, laborer 0
3802576 1958700 1958700 defendant Crotynden Richard laborer or sawyer 596057 596057 Crotynden, Richard, of Hedcrone, laborer or sawyer 3
3810043 1961030 1961030 defendant Ongley William beer brewer 596057 596057 Ongley, William, of Hedcrone, beer brewer 0
3820024 1964143 1964143 defendant Newynden Thomas husbandman 596057 596057 Newynden, Thomas, of Hedcrone, husbandman 4
3827014 1966303 1966303 defendant Cheddys Thomas sherman 596057 596057 Cheddys, Thomas, of Hedcrone, sherman 2
3861442 1977288 1977288 defendant Joce John laborer 596057 596057 Joce, John, of Hedcrone, laborer 1
3913660 1994909 1994909 defendant Maplesden Thomas tailor 596057 596057 Maplesden, Thomas, of Hedcrone, tailor 1
3913661 1994909 1994909 defendant Wodde Thomas yeoman 596057 596057 Wodde, Thomas, of Hedcrone, yeoman 2
3918193 1996418 1996418 defendant Wytt Joseph butcher 596057 596057 Wytt, Joseph, of Hedcrone, butcher 0
3991351 2021661 2021661 defendant Kelsham Nicholas yeoman 596057 596057 Kelsham, Nicholas, of Hedcrone, yeoman 0
4284675 2124567 2124567 defendant Sacrye Thomas butcher 596057 596057 Sacrye, Thomas, of Hedcrone, butcher 0
4284676 2124567 2124567 defendant Cornes Abraham yeoman 596057 596057 Cornes, Abraham, of Hedcrone, yeoman 1
4284687 2124572 2124572 defendant Fullagard alias Domyne William yeoman 596057 596057 Fullagard alias Domyne, William, of Hedcrone, yeoman 0
4284688 2124572 2124572 defendant Deeprise John husbandman 596057 596057 Deeprise, John, of Hedcrone, husbandman 1
4291524 2127043 2127043 defendant Sacrye Thomas yeoman 596057 596057 Sacrye, Thomas, of Hedcrone, yeoman 0
4291525 2127043 2127043 defendant Wythynbrooke Christopher yeoman 596057 596057 Wythynbrooke, Christopher, of Hedcrone, yeoman 1
4291526 2127043 2127043 defendant Standen Richard yeoman 596057 596057 Standen, Richard, of Hedcrone, yeoman 2
4293488 2127734 2127734 defendant Fullagard alias Domyne William yeoman 596057 596057 Fullagard alias Domyne, William, of Hedcrone, yeoman 0
4293489 2127734 2127734 defendant Deeprose John husbandman 596057 596057 Deeprose, John, of Hedcrone, husbandman 1
4321942 2137761 2137761 defendant Sacrye Thomas butcher 596057 596057 Sacrye, Thomas, of Hedcrone, butcher 0
4321943 2137761 2137761 defendant Cornes Abraham yeoman 596057 596057 Cornes, Abraham, of Hedcrone, yeoman 1
4360973 2151097 2151097 defendant Kingsnoth Richard husbandman 596057 596057 together with Kingsnoth, Richard, of Hedcrone, husbandman 1
4360976 2151098 2151098 defendant Kingsnoth Richard husbandman 596057 596057 Kingsnoth, Richard, of Hedcrone, husbandman 1
4362038 2151468 2151468 defendant Standen Richard yeoman 596057 596057 Standen, Richard, of Hedcrone, yeoman 0
4502944 2201490 2201490 defendant Hegge John   596057 596057 Hegge, John, of Hedcrone 0
5245851 2428951 2428951 defendant Suthlane John husbandman 596057 596057 Suthlane, John, of Hedcrone, husbandman 1
5245854 2428951 2428951 defendant Boycote Stephen husbandman 596057 596057 Boycote, Stephen, of Hedcrone, husbandman 4
5313653 2449110 2449110 defendant Borden Robert yeoman 596057 596057 Borden, Robert, of Hedcrone, yeoman 0
5313654 2449110 2449110 defendant Wylkyn Richard laborer 596057 596057 Wylkyn, Richard, of Hedcrone, laborer 1
5319634 2450968 2450968 defendant Borden Robert husbandman 596057 596057 Borden, Robert, of Hedcrone, husbandman 0
5319635 2450968 2450968 defendant Turnour Walter husbandman 596057 596057 Turnour, Walter, of Hedcrone, husbandman 1
5324707 2452462 2452462 defendant Burden Robert husbandman 596057 596057 Burden, Robert, of Hedcrone, husbandman 0
5500144 2504995 2504995 defendant Frary Richard carpenter 596057 596057 Frary, Richard, of Hedcrone, carpenter 3
5530598 2514085 2514085 defendant Frary Richard yeoman 596057 596057 Frary, Richard, of Hedcrone, yeoman 1
5531875 2514514 2514514 plaintiff Stone Stephen   596057 596057 Stone, Stephen, of Hedcrone 0
5575418 2527402 2527402 plaintiff Southland John   596057 596057 Southland, John, of Hedcrone 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);