names

152 rows where place_id = 594179

✎ 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
3614884 1872309 1872309 defendant Thurbarne William yeoman 594179 594179 Thurbarne, William, of Cotton, yeoman 0
3624450 1875183 1875183 plaintiff Thurberne Thomas   594179 594179 Thurberne, Thomas, of Cotton 0
3647786 1909701 1909701 plaintiff Markham John   594179 594179 Markham, John, of Cotton, knight 0
3647788 1909702 1909702 plaintiff Markham John   594179 594179 Markham, John, of Cotton, knight 0
3647790 1909703 1909703 plaintiff Markham John   594179 594179 Markham, John, of Cotton, knight 0
3647793 1909704 1909704 plaintiff Markham John   594179 594179 Markham, John, of Cotton, knight 0
3651018 1910685 1910685 defendant Kardewell John husbandman 594179 594179 Kardewell, John, of Cotton, husbandman 0
3651019 1910685 1910685 defendant Dade Richard clerk 594179 594179 Dade, Richard, of Cotton, clerk 1
3651020 1910685 1910685 defendant Dade Thomas yeoman 594179 594179 Dade, Thomas, of Cotton, yeoman 2
3654118 1911550 1911550 defendant Hewster Thomas husbandman 594179 594179 Hewster, Thomas, of Cotton, husbandman 1
3661372 1913832 1913832 defendant Kyng William (legal representative) 594179 594179 Kyng, William, of Cotton, thatcher, executors of 0
3661373 1913832 1913832 defendant Kyng Cecilia widow 594179 594179 (Kyng, Cecilia, of Cotton, widow 1
3672311 1917342 1917342 defendant Debank Robert yeoman 594179 594179 Debank, Robert, of Cotton, yeoman 1
3672440 1917380 1917380 plaintiff Bugge alias Granger John   594179 594179 Bugge alias Granger, John, of Cotton 1
3672441 1917380 1917380 plaintiff Valenteyn Robert   594179 594179 Valenteyn, Robert, of Cotton 2
3672442 1917380 1917380 defendant Cuttyng Roger painter 594179 594179 Cuttyng, Roger, of Cotton, painter 0
3672444 1917381 1917381 plaintiff Bugge alias Granger John   594179 594179 Bugge alias Granger, John, of Cotton 1
3672446 1917381 1917381 defendant Kervell John husbandman 594179 594179 Kervell, John, of Cotton, husbandman 0
3672448 1917382 1917382 plaintiff Bugge alias Granger John   594179 594179 Bugge alias Granger, John, of Cotton 1
3679805 1919750 1919750 defendant Palant John thatcher 594179 594179 Palant, John, of Cotton, thatcher 0
3679806 1919750 1919750 defendant Gronger John husbandman 594179 594179 Gronger, John, of Cotton, husbandman 1
3679810 1919751 1919751 defendant Palant John thatcher 594179 594179 Palant, John, of Cotton, thatcher 0
3679811 1919751 1919751 defendant Gronger John husbandman 594179 594179 Gronger, John, of Cotton, husbandman 1
3679815 1919752 1919752 defendant Dade Thomas yeoman 594179 594179 Dade, Thomas, of Cotton, yeoman 0
3679816 1919752 1919752 defendant Thurborn Thomas yeoman 594179 594179 Thurborn, Thomas, of Cotton, yeoman 1
3679817 1919752 1919752 defendant Rose Robert husbandman 594179 594179 Rose, Robert, of Cotton, husbandman 2
3679818 1919752 1919752 defendant Holme Edward husbandman 594179 594179 Holme, Edward, of Cotton, husbandman 3
3679819 1919752 1919752 defendant Gronger John husbandman 594179 594179 Gronger, John, of Cotton, husbandman 4
3679820 1919752 1919752 defendant Losse Thomas husbandman 594179 594179 Losse, Thomas, of Cotton, husbandman 5
3684492 1921284 1921284 defendant Goldeston Peter yeoman 594179 594179 Goldeston, Peter, of Cotton, yeoman 0
3695808 1924922 1924922 defendant Dade Richard clerk 594179 594179 Dade, Richard, of Cotton, clerk 0
3704680 1927751 1927751 defendant Paullaunt John husbandman 594179 594179 Paullaunt, John, of Cotton, husbandman 1
3707286 1928569 1928569 defendant Cuttyng Roger husbandman 594179 594179 Cuttyng, Roger, of Cotton, husbandman 0
3713867 1930639 1930639 defendant Chateras John husbandman 594179 594179 Chateras, John, of Cotton, husbandman 0
3715756 1931217 1931217 defendant Cuttyng Roger painter 594179 594179 Cuttyng, Roger, of Cotton, painter 0
3715757 1931217 1931217 defendant Cuttyng Richard painter 594179 594179 Cuttyng, Richard, of Cotton, painter 1
3726688 1934609 1934609 defendant Gronger John husbandman 594179 594179 Gronger, John, of Cotton, husbandman 3
3732807 1936490 1936490 defendant Rose Robert tanner 594179 594179 Rose, Robert, of Cotton, tanner 2
3732808 1936490 1936490 defendant Rose Thomas laborer 594179 594179 Rose, Thomas, of Cotton, laborer 3
3732809 1936490 1936490 defendant Freman John laborer 594179 594179 Freman, John, of Cotton, laborer 4
3752602 1942744 1942744 defendant Kyng John husbandman 594179 594179 Kyng, John, of Cotton, husbandman 0
3760421 1945262 1945262 plaintiff Dade Thomas   594179 594179 Dade, Thomas, of Cotton 1
3765289 1946809 1946809 plaintiff Kyng John   594179 594179 Kyng, John, of Cotton 0
3769381 1948080 1948080 defendant Kyng John husbandman 594179 594179 Kyng, John, of Cotton, husbandman 0
3779186 1951212 1951212 defendant Cuttyng Richard painter 594179 594179 Cuttyng, Richard, of Cotton, painter 3
3783845 1952719 1952719 defendant Cuttyng Richhard painter 594179 594179 Cuttyng, Richhard, of Cotton, painter 1
3788372 1954162 1954162 defendant Dyxwell John (legal representative) 594179 594179 Dyxwell, John, of Cotton, esq, executors of 1
3788374 1954162 1954162 defendant Dyxwell William gent 594179 594179 Dyxwell, William, of Cotton, gent 3
3788380 1954164 1954164 defendant Dyxwell John (legal representative) 594179 594179 Dyxwell, John, of Cotton, esq, executors of 1
3788382 1954164 1954164 defendant Dyxwell William gent 594179 594179 Dyxwell, William, of Cotton, gent 3
3788762 1954290 1954290 defendant Thurborne Thomas gent 594179 594179 Thurborne, Thomas, of Cotton, gent 0
3788768 1954293 1954293 defendant Thurberne Thomas gent 594179 594179 Thurberne, Thomas, of Cotton, gent 0
3800281 1958009 1958009 defendant Cuttyng Richard painter 594179 594179 Cuttyng, Richard, of Cotton, painter 1
3802952 1958820 1958820 defendant Laund alias Palaunt John thatcher 594179 594179 Laund alias Palaunt, John, of Cotton, thatcher 0
3811210 1961400 1961400 defendant Cuttyng Richard painter 594179 594179 Cuttyng, Richard, of Cotton, painter 1
3828345 1966740 1966740 defendant Darrenton John husbandman 594179 594179 Darrenton, John, of Cotton, husbandman 0
3833465 1968398 1968398 defendant Cuttyng Richard painter 594179 594179 Cuttyng, Richard, of Cotton, painter 0
3843275 1971429 1971429 defendant Arnatt Ralph husbandman 594179 594179 Arnatt, Ralph, of Cotton, husbandman 5
3852021 1974223 1974223 defendant Losse Thomas (legal representative) 594179 594179 Losse, Thomas, of Cotton, husbandman, administrator of 1
3852022 1974223 1974223 defendant Kyng John husbandman 594179 594179 Kyng, John, of Cotton, husbandman 2
3864664 1978379 1978379 defendant Kynge John husbandman 594179 594179 Kynge, John, of Cotton, husbandman 5
3866514 1979030 1979030 defendant Laund Thomas thatcher 594179 594179 Laund, Thomas, of Cotton, thatcher 0
3866515 1979030 1979030 defendant Lawnd alias Palaunt John thatcher 594179 594179 Lawnd alias Palaunt, John, of Cotton, thatcher 1
3880515 1983741 1983741 defendant Laund Thomas husbandman 594179 594179 Laund, Thomas, of Cotton, husbandman 1
3923155 1998051 1998051 defendant Pole Thomas husbandman 594179 594179 Pole, Thomas, of Cotton, husbandman 0
4040833 2039213 2039213 defendant Burton Henry husbandman 594179 594179 Burton, Henry, of Cotton, husbandman 0
4055363 2044316 2044316 defendant Burton John, junior chapman 594179 594179 Burton, John, junior, of Cotton, chapman 1
4074999 2051360 2051360 defendant Gopsyll William laborer 594179 594179 Gopsyll, William, of Cotton, laborer 1
4075000 2051360 2051360 defendant Ball John laborer 594179 594179 Ball, John, of Cotton, laborer 2
4078945 2052769 2052769 plaintiff Tirell John   594179 594179 Tirell, John, of Cotton, esq, "my son" 0
4090541 2056900 2056900 defendant Holmes William husbandman 594179 594179 Holmes, William, of Cotton, husbandman 0
4090693 2056960 2056960 defendant Thurbarn Roger (legal representative) 594179 594179 Thurbarn, Roger, of Cotton, yeoman, executors of 0
4090695 2056960 2056960 defendant Thurbarn William yeoman 594179 594179 Thurbarn, William, of Cotton, yeoman 2
4096661 2059133 2059133 defendant Palmer John husbandman 594179 594179 Palmer, John, of Cotton, husbandman 1
4111141 2064239 2064239 defendant Dunche Andrew yeoman 594179 594179 Dunche, Andrew, of Cotton, yeoman 2
4111690 2064429 2064429 defendant Cole John yeoman 594179 594179 Cole, John, of Cotton, yeoman 0
4114417 2065441 2065441 defendant Hurte John husbandman 594179 594179 Hurte, John, of Cotton, husbandman 0
4114419 2065441 2065441 defendant Hurte Joan widow 594179 594179 Hurte, Joan, of Cotton,widow 2
4115102 2065690 2065690 defendant Dixwell Humphrey gent 594179 594179 Dixwell, Humphrey, of Cotton, gent 0
4159734 2081471 2081471 defendant Woodwarde Stephen clerk 594179 594179 Woodwarde, Stephen, of Cotton, clerk 3
4177696 2087676 2087676 defendant Pallant Robert yeoman 594179 594179 Pallant, Robert, of Cotton, yeoman 0
4200451 2095715 2095715 defendant Benyon John yeoman 594179 594179 Benyon, John, of Cotton, yeoman 0
4225931 2104538 2104538 defendant Goodale Richard yeoman 594179 594179 Goodale, Richard, of Cotton, yeoman 0
4243123 2110691 2110691 defendant Dunche John cooper 594179 594179 Dunche, John, of Cotton, or of Bildeston, cooper 0
4262327 2117070 2117070 defendant Dickens Henry husbandman 594179 594179 Dickens, Henry, of Cotton under Guilsborowe, husbandman 1
4273125 2120572 2120572 defendant Dickens Henry husbandman 594179 594179 Dickens, Henry, of Cotton under Guilborowe, husbandman 1
4281831 2123550 2123550 defendant Candler Simon husbandman 594179 594179 Candler, Simon, of Cotton, husbandman 2
4307149 2132634 2132634 defendant Beart John (legal representative) 594179 594179 Beart, John, of Cotton, yeoman, administrator of 0
4336493 2142498 2142498 defendant Marrett John husbandman 594179 594179 Marrett, John, of Cotton, husbandman 0
4337523 2142862 2142862 defendant Wentworthe Philip gent 594179 594179 Wentworthe, Philip, of Cotton, gent 0
4341043 2144142 2144142 defendant Hugginson John gent 594179 594179 Hugginson, John, of Cotton, gent 0
4387145 2160353 2160353 defendant Woodward Stephen yeoman 594179 594179 Woodward, Stephen, of Cotton, yeoman 0
4397804 2163843 2163843 defendant Woodward Stephen clerk 594179 594179 Woodward, Stephen, of Cotton, clerk 0
4399902 2164555 2164555 defendant Woodward Stephen, junior yeoman 594179 594179 Woodward, Stephen, junior, of Cotton, yeoman 1
4405826 2166512 2166512 defendant Sanders alias Huys Thomas yeoman 594179 594179 Sanders alias Huys, Thomas, of Cotton, yeoman 0
4405963 2166558 2166558 defendant Shulberd Zebed yeoman 594179 594179 Shulberd, Zebed, of Cotton, yeoman 0
4405965 2166558 2166558 defendant Shulberd John yeoman 594179 594179 Shulberd, John, of Cotton, yeoman 2
4405966 2166558 2166558 defendant Hawkes Thomas yeoman 594179 594179 Hawkes, Thomas, of Cotton, yeoman 3
4453013 2185951 2185951 defendant Bakeron Adam   594179 594179 Bakeron, Adam, of Cotton 0
4453017 2185952 2185952 defendant Bakeron Adam   594179 594179 Bakeron, Adam, of Cotton 0

Next page

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