names

215 rows where place_id = 595953

✎ 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
3622525 1874582 1874582 defendant Scarlet John husbandman 595953 595953 Scarlet, John, of Whaplode, husbandman 0
3633021 1905148 1905148 defendant Bukle William yeoman 595953 595953 Bukle, William, of Whaplode, yeoman 0
3633024 1905148 1905148 defendant Storkes alias Pye Richard husbandman 595953 595953 Storkes alias Pye, Richard, of Whaplode, husbandman 3
3633025 1905148 1905148 defendant Tyler Thomas laborer 595953 595953 Tyler, Thomas, of Whaplode, laborer 4
3633026 1905148 1905148 defendant Tyler Robert laborer 595953 595953 Tyler, Robert, of Whaplode, laborer 5
3633027 1905148 1905148 defendant Wryght Thomas laborer 595953 595953 Wryght, Thomas, of Whaplode, laborer 6
3633030 1905148 1905148 defendant Buller William laborer 595953 595953 Buller, William, of Whaplode, laborer 9
3633031 1905148 1905148 defendant Biller John laborer 595953 595953 Biller, John, of Whaplode, laborer 10
3633037 1905149 1905149 defendant Bukle William yeoman 595953 595953 Bukle, William, of Whaplode, yeoman 0
3633040 1905149 1905149 defendant Storkes alias Pye Richard husbandman 595953 595953 Storkes alias Pye, Richard, of Whaplode, husbandman 3
3633041 1905149 1905149 defendant Tyler Thomas laborer 595953 595953 Tyler, Thomas, of Whaplode, laborer 4
3633042 1905149 1905149 defendant Tyler Robert laborer 595953 595953 Tyler, Robert, of Whaplode, laborer 5
3633043 1905149 1905149 defendant Wryght Thomas laborer 595953 595953 Wryght, Thomas, of Whaplode, laborer 6
3633046 1905149 1905149 defendant Buller William laborer 595953 595953 Buller, William, of Whaplode, laborer 9
3633047 1905149 1905149 defendant Biller John laborer 595953 595953 Biller, John, of Whaplode, laborer 10
3641431 1907776 1907776 defendant Thakker John   595953 595953 Thakker, John, of Whaplode, clax chapman 0
3645065 1908865 1908865 defendant Byller William husbandman 595953 595953 Byller, William, of Whaplode, husbandman 0
3649277 1910163 1910163 defendant Pynder William husbandman 595953 595953 Pynder, William, of Whaplode, husbandman 0
3649278 1910163 1910163 defendant Holand John husbandman 595953 595953 Holand, John, of Whaplode, husbandman 1
3649279 1910163 1910163 defendant Pynchebek John husbandman 595953 595953 Pynchebek, John, of Whaplode, husbandman 2
3654916 1911797 1911797 defendant Robertson Thomas butcher 595953 595953 Robertson, Thomas, of Whaplode, butcher 0
3670850 1916848 1916848 defendant Skarlet John laborer 595953 595953 Skarlet, John, of Whaplode, laborer 0
3670851 1916848 1916848 defendant Skarlet Robert laborer 595953 595953 Skarlet, Robert, of Whaplode, laborer 1
3670852 1916848 1916848 defendant Wright Thomas husbandman 595953 595953 Wright, Thomas, of Whaplode, husbandman 2
3675063 1918232 1918232 defendant Schepard Robert husbandman 595953 595953 Schepard, Robert, of Whaplode, husbandman 0
3675064 1918232 1918232 defendant Holand John husbandman 595953 595953 Holand, John, of Whaplode, husbandman 1
3675065 1918232 1918232 defendant Skarlet John husbandman 595953 595953 Skarlet, John, of Whaplode, husbandman 2
3676553 1918709 1918709 defendant Mariet Thomas husbandman 595953 595953 Mariet, Thomas, of Whaplode, husbandman 1
3676555 1918709 1918709 defendant Smyth Robert   595953 595953 Smyth, Robert, of Whaplode, minstrel 3
3681942 1920456 1920456 defendant Coke William husbandman 595953 595953 Coke, William, of Whaplode, husbandman 0
3695919 1924961 1924961 defendant Jerves Richard draper 595953 595953 Jerves, Richard, of Whaplode, draper 0
3698118 1925637 1925637 defendant Wylsey John yeoman 595953 595953 Wylsey, John, of Whaplode, yeoman 0
3701994 1926878 1926878 plaintiff Byrde Hugh husbandman 595953 595953 Byrde, Hugh, of Whaplode, husbandman 0
3701995 1926878 1926878 defendant Bukley John yeoman 595953 595953 Bukley, John, of Whaplode, yeoman 0
3706705 1928383 1928383 plaintiff Jervys Richard   595953 595953 Jervys, Richard, of Whaplode, administrators of 0
3706709 1928383 1928383 defendant Holand John husbandman 595953 595953 Holand, John, of Whaplode, husbandman 0
3706710 1928383 1928383 defendant Stoke John laborer 595953 595953 Stoke, John, of Whaplode, laborer 1
3707585 1928668 1928668 defendant Durlove or Durloue Robert husbandman 595953 595953 Durlove or Durloue, Robert, of Whaplode, husbandman 1
3708983 1929103 1929103 defendant Grome Robert husbandman 595953 595953 Grome, Robert, of Whaplode, husbandman 1
3724005 1933793 1933793 defendant Pynder William husbandman 595953 595953 Pynder, William, of Whaplode, husbandman 0
3724006 1933793 1933793 defendant Johnson Adam husbandman 595953 595953 Johnson, Adam, of Whaplode, husbandman 1
3730818 1935866 1935866 defendant Wright Thomas husbandman 595953 595953 Wright, Thomas, of Whaplode, husbandman 0
3737313 1937907 1937907 defendant Williamson John husbandman 595953 595953 Williamson, John, of Whaplode, husbandman 0
3737314 1937907 1937907 defendant Williamson Robert husbandman 595953 595953 Williamson, Robert, of Whaplode, husbandman 1
3746061 1940673 1940673 plaintiff Chapman Robert (legal representative) 595953 595953 Chapman, Robert, of Whaplode, executors of 0
3758737 1944723 1944723 defendant Bukley John husbandman 595953 595953 Bukley, John, of Whaplode, husbandman 5
3758739 1944723 1944723 defendant Wright Thomas husbandman 595953 595953 Wright, Thomas, of Whaplode, husbandman 7
3758748 1944724 1944724 defendant Idon Thomas husbandman 595953 595953 Idon, Thomas, of Whaplode, husbandman 4
3759166 1944856 1944856 plaintiff Chapman Robert (legal representative) 595953 595953 Chapman, Robert, of Whaplode, executors of 0
3759170 1944857 1944857 plaintiff Chapman Robert (legal representative) 595953 595953 Chapman, Robert, of Whaplode, executors of 0
3760663 1945337 1945337 defendant Pynder Nicholas tailor 595953 595953 Pynder, Nicholas, of Whaplode, tailor 0
3764389 1946523 1946523 defendant Calowe Simon husbandman 595953 595953 Calowe, Simon, of Whaplode, husbandman 0
3766175 1947074 1947074 defendant Mason John butcher 595953 595953 Mason, John, of Whaplode, butcher 2
3769516 1948127 1948127 defendant Idon Thomas carpenter 595953 595953 Idon, Thomas, of Whaplode, carpenter 0
3769517 1948127 1948127 defendant Wright Thomas husbandman 595953 595953 Wright, Thomas, of Whaplode, husbandman 1
3769518 1948127 1948127 defendant Wright Robert husbandman 595953 595953 Wright, Robert, of Whaplode, husbandman 2
3772331 1949031 1949031 defendant Mason John butcher 595953 595953 Mason, John, of Whaplode, butcher 2
3776838 1950494 1950494 defendant Wryght Thomas husbandman 595953 595953 Wryght, Thomas, of Whaplode, husbandman 0
3776843 1950495 1950495 defendant Wryght Thomas husbandman 595953 595953 Wryght, Thomas, of Whaplode, husbandman 0
3818247 1963622 1963622 defendant Atkynson William carpenter 595953 595953 Atkynson, William, of Whaplode, carpenter 0
3823173 1965160 1965160 defendant White William husbandman 595953 595953 White, William, of Whaplode, husbandman 0
3823174 1965160 1965160 defendant Freman William husbandman 595953 595953 Freman, William, of Whaplode, husbandman 1
3823175 1965160 1965160 defendant Smyth William husbandman 595953 595953 Smyth, William, of Whaplode, husbandman 2
3824695 1965597 1965597 defendant Okey Robert fisher 595953 595953 Okey, Robert, of Whaplode, fisher 0
3828412 1966758 1966758 defendant Williamson Robert fisher 595953 595953 Williamson, Robert, of Whaplode, fisher 0
3829356 1967070 1967070 defendant Thakker John husbandman 595953 595953 Thakker, John, of Whaplode, husbandman 0
3866030 1978870 1978870 defendant Byrde Hugh husbandman 595953 595953 Byrde, Hugh, of Whaplode, husbandman 0
3866031 1978870 1978870 defendant Tasshe William draper 595953 595953 Tasshe, William, of Whaplode, draper 1
3866032 1978870 1978870 defendant Wylsey John yeoman 595953 595953 Wylsey, John, of Whaplode, yeoman 2
3866033 1978870 1978870 defendant Bukley Philip, senior yeoman 595953 595953 Bukley, Philip, senior, of Whaplode, yeoman 3
3866952 1979185 1979185 defendant Byller John fisher 595953 595953 Byller, John, of Whaplode, fisher 1
3880585 1983767 1983767 defendant Newdyke Robert husbandman 595953 595953 Newdyke, Robert, of Whaplode, husbandman 0
3880587 1983768 1983768 defendant Hogeman Thomas yeoman 595953 595953 Hogeman, Thomas, of Whaplode, yeoman 0
3893883 1988177 1988177 defendant White William husbandman 595953 595953 White, William, of Whaplode, husbandman 0
3893885 1988177 1988177 defendant Clerke Thomas husbandman 595953 595953 Clerke, Thomas, of Whaplode, husbandman 2
3896185 1988928 1988928 defendant Whyte William husbandman 595953 595953 Whyte, William, of Whaplode, husbandman 0
3951551 2007597 2007597 defendant Blades John clerk 595953 595953 Blades, John, of Whaplode, clerk 2
3965177 2012431 2012431 defendant Marten John yeoman 595953 595953 Marten, John, of Whaplode, yeoman 0
3994481 2022774 2022774 defendant Wensley Roger yeoman 595953 595953 Wensley, Roger, of Whaplode, yeoman 0
4043966 2040291 2040291 plaintiff Pulvertoft Robert esq 595953 595953 Pulvertoft, Robert, of Whaplode, esq 0
4043968 2040292 2040292 plaintiff Pulvertoft Robert esq 595953 595953 Pulvertoft, Robert, of Whaplode, esq 0
4091254 2057161 2057161 defendant Pulvertofte Robert gent 595953 595953 Pulvertofte, Robert, of Whaplode, gent 0
4116045 2066031 2066031 defendant Fakener Robert thatcher 595953 595953 Fakener, Robert, of Whaplode, thatcher 0
4117103 2066422 2066422 defendant Pulvertofte Robert gent 595953 595953 Pulvertofte, Robert, of Whaplode, gent 0
4132483 2071934 2071934 defendant Pulvertofte Robert gent 595953 595953 Pulvertofte, Robert, of Whaplode, gent 2
4141318 2075122 2075122 defendant Cooke Robert yeoman 595953 595953 Cooke, Robert, of Whaplode, yeoman 0
4146548 2076943 2076943 defendant Pulvertofte Robert gent 595953 595953 Pulvertofte, Robert, of Whaplode, gent 0
4147373 2077221 2077221 defendant Pulvertofte Robert gent 595953 595953 Pulvertofte, Robert, of Whaplode, gent 0
4187394 2091091 2091091 defendant Packe George yeoman 595953 595953 Packe, George, of Whaplode, yeoman 0
4187395 2091091 2091091 defendant Weightman William yeoman 595953 595953 Weightman, William, of Whaplode, yeoman 1
4187396 2091091 2091091 defendant Joyese John yeoman 595953 595953 Joyese, John, of Whaplode, yeoman 2
4210967 2099394 2099394 defendant Packe George yeoman 595953 595953 Packe, George, of Whaplode, yeoman 0
4210968 2099394 2099394 defendant Weightman William yeoman 595953 595953 Weightman, William, of Whaplode, yeoman 1
4210969 2099394 2099394 defendant Joyese John yeoman 595953 595953 Joyese, John, of Whaplode, yeoman 2
4215741 2101002 2101002 defendant Lynsey John yeoman 595953 595953 Lynsey, John, of Whaplode, or of Moulton, Lincs, yeoman 1
4239379 2109391 2109391 defendant Pinchebecke Thomas (legal representative) 595953 595953 Pinchebecke, Thomas, of Whaplode, husbandman, executor of 0
4239380 2109391 2109391 defendant Pinchbecke Lawrence husbandman 595953 595953 Pinchbecke, Lawrence, of Whaplode, husbandman 1
4347607 2146412 2146412 defendant Bushoppe Thomas husbandman 595953 595953 Bushoppe, Thomas, of Whaplode, husbandman 0
4347608 2146412 2146412 defendant Bawdrye Anthony husbandman 595953 595953 Bawdrye, Anthony, of Whaplode, husbandman 1
4366748 2153153 2153153 defendant Idon John yeoman 595953 595953 Idon, John, of Whaplode, yeoman 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);