names

41 rows where place_id = 592752

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608754 1870401 1870401 defendant Rugeley William gent 592752 592752 Rugeley, William, of Lynley, gent 2
3667947 1915915 1915915 defendant Heley Nicholas yeoman 592752 592752 Heley, Nicholas, of Lynley, yeoman 1
3903951 1991559 1991559 defendant Aneley Richard yeoman 592752 592752 Aneley, Richard, of Lynley, yeoman 1
3913864 1994983 1994983 defendant Bole William husbandman 592752 592752 Bole, William, of Lynley, husbandman 1
3913866 1994983 1994983 defendant Lycas Humphrey husbandman 592752 592752 Lycas, Humphrey, of Lynley, husbandman 3
3973733 2015387 2015387 defendant Aveley Richard clothier 592752 592752 Aveley, Richard, of Lynley, clothier 0
4071392 2050066 2050066 defendant Hyrste Edmund clothier 592752 592752 Hyrste, Edmund, of Lynley, clothier 2
4071393 2050066 2050066 defendant Thewles John clothier 592752 592752 Thewles, John, of Lynley, clothier 3
4078855 2052734 2052734 defendant Fyrthe Thomas clothier 592752 592752 Fyrthe, Thomas, of Lynley, clothier 2
4088549 2056205 2056205 defendant Thewlles John clothier 592752 592752 Thewlles, John, of Lynley, clothier 0
4088550 2056205 2056205 defendant Crowder John clothier 592752 592752 Crowder, John, of Lynley, clothier 1
4088552 2056206 2056206 defendant Thewlles John clothier 592752 592752 Thewlles, John, of Lynley, clothier 0
4088553 2056206 2056206 defendant Crowder John clothier 592752 592752 Crowder, John, of Lynley, clothier 1
4119147 2067137 2067137 defendant Clay Edward yeoman 592752 592752 Clay, Edward, of Lynley, yeoman 0
4142307 2075485 2075485 defendant Clay Edward yeoman 592752 592752 Clay, Edward, of Lynley, yeoman 0
4187163 2091002 2091002 defendant Collyns William yeoman 592752 592752 Collyns, William, of Lynley, yeoman 1
4199381 2095335 2095335 defendant Meredyth Thomas husbandman 592752 592752 Meredyth, Thomas, of Lynley, husbandman 1
4213258 2100153 2100153 defendant Rydley Richard gent 592752 592752 Rydley, Richard, of Lynley, gent 0
4504496 2201964 2201964 defendant Bent William   592752 592752 Bent, William, of Lynley 3
4744361 2278874 2278874 defendant Baret John (legal representative) 592752 592752 Baret, John, of Lynley, executors of 0
4744363 2278874 2278874 defendant Baret Richard husbandman 592752 592752 Baret, Richard, of Lynley, husbandman 2
4744365 2278875 2278875 defendant Baret John (legal representative) 592752 592752 Baret, John, of Lynley, executors of 0
4814073 2300505 2300505 defendant Warde John husbandman 592752 592752 Warde, John, of Lynley, husbandman 0
4814074 2300505 2300505 defendant Irmubell John yeoman 592752 592752 Irmubell, John, of Lynley, yeoman 1
4961536 2345416 2345416 defendant Herdwyke Thomas gent 592752 592752 Herdwyke, Thomas, of Lynley, gent 0
4964694 2346348 2346348 defendant Herdwyke Thomas gent 592752 592752 Herdwyke, Thomas, of Lynley, gent 0
4998171 2356321 2356321 defendant Chatwall John husbandman 592752 592752 Chatwall, John, of Lynley, husbandman 0
4998173 2356321 2356321 defendant Harley Roger husbandman 592752 592752 Harley, Roger, of Lynley, husbandman 2
5096677 2385463 2385463 defendant Rypley Richard chaplain 592752 592752 Rypley, Richard, of Lynley, chaplain 0
5135459 2396882 2396882 defendant Mason John husbandman 592752 592752 Mason, John, of Lynley, husbandman 0
5135460 2396882 2396882 defendant Hewet Robert laborer 592752 592752 Hewet, Robert, of Lynley, laborer 1
5135461 2396882 2396882 defendant May Felicity   592752 592752 May, Felicity, of lynley, servant 2
5200605 2415935 2415935 plaintiff Wyllyngton Thomas   592752 592752 Wyllyngton, Thomas, of Lynley 0
5330947 2454318 2454318 defendant Mason John husbandman 592752 592752 Mason, John, of Lynley, husbandman 14
5356897 2462220 2462220 plaintiff Mason John husbandman 592752 592752 Mason, John, of Lynley, husbandman 0
5377777 2468632 2468632 defendant Dyconson William yeoman 592752 592752 Dyconson, William, of Lynley, yeoman 7
5377899 2468663 2468663 defendant Howeper John yeoman 592752 592752 Howeper, John, of Lynley, yeoman 0
5510348 2508075 2508075 plaintiff Hardwyk John esq 592752 592752 Hardwyk, John, of Lynley, esq 0
5510350 2508076 2508076 plaintiff Hardwyke John esq 592752 592752 Hardwyke, John, of Lynley, esq 0
5572086 2526384 2526384 defendant Hardewyk John gent 592752 592752 Hardewyk, John, of Lynley, gent 0
5586514 2530821 2530821 defendant Beste Christopher clerk 592752 592752 Beste, Christopher, of Lynley, clerk 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);