names

138 rows where place_id = 586066

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587842 1863844 1863844 defendant Rouncyvale John brewer 586066 586066 Rouncyvale, John, of Suthwerke, brewer 0
3602170 1868345 1868345 defendant Bruer Peter yeoman 586066 586066 Bruer, Peter, of Suthwerke, yeoman 0
3603445 1868742 1868742 defendant Marchall Richard fellmonger 586066 586066 Marchall, Richard, of Suthwerke, fellmonger 0
3615845 1872597 1872597 defendant Michell Roland yeoman 586066 586066 Michell, Roland, of Suthwerke, yeoman 3
3615846 1872597 1872597 defendant van Breme John yeoman 586066 586066 van Breme, John, of Suthwerke, yeoman 4
3615851 1872598 1872598 defendant Michell Roland yeoman 586066 586066 Michell, Roland, of Suthwerke, yeoman 3
3615852 1872598 1872598 defendant van Breme John yeoman 586066 586066 van Breme, John, of Suthwerke, yeoman 4
3628466 1903771 1903771 defendant Dale Robert   586066 586066 Dale, Robert, of Suthwerke, shipwright 0
3635810 1906000 1906000 defendant Chiltern John gent 586066 586066 Chiltern, John, of Suthwerke, gent 1
3638795 1906954 1906954 defendant Rower Richard dyer 586066 586066 Rower, Richard, of Suthwerke, dyer 0
3639936 1907304 1907304 defendant Wyche Robert currier 586066 586066 Wyche, Robert, of Suthwerke, currier 0
3651757 1910904 1910904 plaintiff Tesedale Robert tailor 586066 586066 Tesedale, Robert, of Suthwerke, tailor 0
3664419 1914820 1914820 defendant Clerke Simon carrier 586066 586066 Clerke, Simon, of Suthwerke, carrier 0
3664420 1914820 1914820 defendant Gryndall Morris tailor 586066 586066 Gryndall, Morris, of Suthwerke, tailor 1
3664421 1914820 1914820 defendant Lewys John sadler 586066 586066 Lewys, John, of Suthwerke, sadler 2
3664941 1914979 1914979 defendant Bradley John yeoman 586066 586066 Bradley, John, of Suthwerke, yeoman 1
3679882 1919774 1919774 defendant Botye John   586066 586066 Botye, John, of Suthwerke, hat maker 0
3680613 1920018 1920018 defendant Bull Pykerde William capper 586066 586066 Bull Pykerde, William, of Suthwerke, capper 0
3690584 1923220 1923220 defendant Herde Nicholas innholder 586066 586066 Herde, Nicholas, of Suthwerke, innholder 4
3690590 1923221 1923221 defendant Herde Nicholas innholder 586066 586066 Herde, Nicholas, of Suthwerke, innholder 4
3710225 1929513 1929513 defendant Carter Thomas   586066 586066 Carter, Thomas, of Suthwerke, draper, wardens of London Bridge 1
3714724 1930905 1930905 defendant Stone Richard innholder 586066 586066 Stone, Richard, of Suthwerke, innholder 2
3718883 1932185 1932185 defendant Rofullys John carpenter 586066 586066 Rofullys, John, of Suthwerke, carpenter 0
3718884 1932185 1932185 defendant Boty John yeoman 586066 586066 Boty, John, of Suthwerke, yeoman 1
3729646 1935523 1935523 defendant Bysshop Thomas leather seller 586066 586066 Bysshop, Thomas, of Suthwerke, leather seller 0
3731188 1935977 1935977 defendant Grene Thomas yeoman 586066 586066 Grene, Thomas, of Suthwerke, yeoman 0
3732234 1936320 1936320 defendant Pele Thomas tailor 586066 586066 Pele, Thomas, of Suthwerke, tailor 0
3732236 1936321 1936321 defendant Pele Thomas tailor 586066 586066 Pele, Thomas, of Suthwerke, tailor 0
3734248 1936951 1936951 defendant Peyne William gent 586066 586066 Peyne, William, of Suthwerke, gent 1
3734249 1936951 1936951 defendant Denys Philip yeoman 586066 586066 Denys, Philip, of Suthwerke, yeoman 2
3736184 1937558 1937558 defendant Langforde David sherman 586066 586066 Langforde, David, of Suthwerke, sherman 3
3737820 1938049 1938049 defendant Payne William yeoman 586066 586066 Payne, William, of Suthwerke, yeoman 0
3746157 1940705 1940705 defendant Tomlyns alias Buttler Henry yeoman 586066 586066 Tomlyns alias Buttler, Henry, of Suthwerke, yeoman 0
3756621 1944053 1944053 defendant Yong Henry barber 586066 586066 Yong, Henry, of Suthwerke, barber 0
3756624 1944053 1944053 defendant Wellys William yeoman 586066 586066 Wellys, William, of Suthwerke, yeoman 3
3756626 1944054 1944054 defendant Yonge Henry barber 586066 586066 Yonge, Henry, of Suthwerke, barber 0
3762626 1945946 1945946 defendant Thomas William armorer 586066 586066 Thomas, William, of Suthwerke, armorer 0
3762837 1946013 1946013 defendant Byrche Richard glover 586066 586066 Byrche, Richard, of Suthwerke, glover 2
3765414 1946844 1946844 defendant Bradlegh John blacksmith 586066 586066 Bradlegh, John, of Suthwerke, blacksmith 1
3765745 1946952 1946952 defendant Peryn Thomas butcher 586066 586066 Peryn, Thomas, of Suthwerke, butcher 0
3794954 1956286 1956286 defendant Fetipace Thomas gent 586066 586066 Fetipace, Thomas, of Suthwerke, gent 0
3794955 1956287 1956287 plaintiff Coldwell John, senior gent 586066 586066 Coldwell, John, senior, of Suthwerke, gent 0
3797185 1957003 1957003 defendant Alen John butcher 586066 586066 Alen, John, of Suthwerke, butcher 4
3798541 1957447 1957447 defendant Bowyer John butcher 586066 586066 Bowyer, John, of Suthwerke, butcher 0
3800945 1958205 1958205 defendant Prestall Henry haberdasher 586066 586066 Prestall, Henry, of Suthwerke, haberdasher 0
3804281 1959272 1959272 defendant Awsten Robert capper 586066 586066 Awsten, Robert, of Suthwerke, capper 0
3809616 1960895 1960895 plaintiff Bere Matilda (legal representative) 586066 586066 Bere, Matilda, of Suthwerke, widow, executor of 0
3813840 1962239 1962239 defendant Whytehed Roger dyer 586066 586066 Whytehed, Roger, of Suthwerke, dyer 3
3819714 1964046 1964046 defendant Acton Robert gent 586066 586066 Acton, Robert, of Suthwerke, gent 1
3822917 1965074 1965074 defendant Kendall Thomas yeoman 586066 586066 Kendall, Thomas, of Suthwerke, yeoman 1
3826986 1966292 1966292 defendant Austen Robert capper 586066 586066 Austen, Robert, of Suthwerke, capper 0
3826988 1966292 1966292 defendant Spycer Robert butcher 586066 586066 Spycer, Robert, of Suthwerke, butcher 2
3827106 1966338 1966338 defendant Wonckam Leonard shoemaker 586066 586066 Wonckam, Leonard, of Suthwerke, shoemaker 0
3827278 1966398 1966398 defendant Annell John butcher 586066 586066 Annell, John, of Suthwerke, butcher 1
3830818 1967522 1967522 defendant Barwyk John tailor 586066 586066 Barwyk, John, of Suthwerke, tailor 0
3831165 1967635 1967635 plaintiff Gregory John (legal representative) 586066 586066 Gregory, John, of Suthwerke, tailor, executrix of 0
3832347 1968034 1968034 defendant Nicolson Cornelius glasier 586066 586066 Nicolson, Cornelius, of Suthwerke, glasier 0
3833801 1968503 1968503 defendant Alen John butcher 586066 586066 Alen, John, of Suthwerke, butcher 0
3836539 1969332 1969332 defendant Hastynges Francis gent 586066 586066 Hastynges, Francis, of Suthwerke, gent 0
3837757 1969724 1969724 defendant Kellet William innholder 586066 586066 Kellet, William, of Suthwerke, innholder 0
3837762 1969725 1969725 defendant Kellet William innholder 586066 586066 Kellet, William, of Suthwerke, innholder 0
3842729 1971258 1971258 defendant Tomlyn John leather seller 586066 586066 Tomlyn, John, of Suthwerke, leather seller 0
3845073 1972015 1972015 defendant Kellet William innholder 586066 586066 Kellet, William, of Suthwerke, innholder 0
3845074 1972015 1972015 defendant Ele John waterman 586066 586066 Ele, John, of Suthwerke, waterman 1
3848473 1973103 1973103 defendant Markys Alexander baker 586066 586066 Markys, Alexander, of Suthwerke, baker 0
3848702 1973182 1973182 defendant Colson William pinner 586066 586066 Colson, William, of Suthwerke, pinner 0
3850155 1973638 1973638 defendant Maygood Richard dyer 586066 586066 Maygood, Richard, of Suthwerke, dyer 0
3853143 1974604 1974604 defendant Wentworth Thomas   586066 586066 Wentworth, Thomas, of Suthwerke, knight 0
3861873 1977429 1977429 defendant Alen John butcher 586066 586066 Alen, John, of Suthwerke, butcher 2
3862003 1977476 1977476 defendant Brome Richard grocer 586066 586066 Brome, Richard, of Suthwerke, grocer 0
3862805 1977752 1977752 defendant Browne Richard grocer 586066 586066 Browne, Richard, of Suthwerke, grocer 0
3864807 1978425 1978425 defendant Kittons John saddler 586066 586066 Kittons, John, of Suthwerke, saddler 0
3869559 1980060 1980060 defendant Halle Francis   586066 586066 Halle, Francis, of Suthwerke, esq, administrators of 0
3869562 1980060 1980060 defendant Holme Thomas gent 586066 586066 Holme, Thomas, of Suthwerke, gent 3
3880456 1983720 1983720 defendant Potkyng Henry shoemaker 586066 586066 Potkyng, Henry, of Suthwerke, shoemaker 0
3880457 1983720 1983720 defendant Bradley John shoemaker 586066 586066 Bradley, John, of Suthwerke, shoemaker 1
3880956 1983900 1983900 defendant Thomas William gent 586066 586066 Thomas, William, of Suthwerke, gent 3
3887186 1985979 1985979 defendant Dale Thomas   586066 586066 Dale, Thomas, of Suthwerke, shipwright 0
3923708 1998240 1998240 defendant Dey Thomas   586066 586066 Dey, Thomas, of Suthwerke, wax chandler 0
3924599 1998542 1998542 defendant Alen John butcher 586066 586066 Alen, John, of Suthwerke, butcher 0
4568285 2221651 2221651 plaintiff Tyler Richard   586066 586066 Tyler, Richard, of Suthwerke 0
4599784 2231155 2231155 plaintiff Syward John   586066 586066 Syward, John, of Suthwerke 0
4712001 2269065 2269065 plaintiff Segrave Walter   586066 586066 Segrave, Walter, of Suthwerke 0
4865242 2316102 2316102 defendant Pynnowe Alice   586066 586066 Pynnowe, Alice, of Suthwerke, widow of Pynnowe, Michael 1
4875552 2319308 2319308 plaintiff Salford John brewer 586066 586066 Salford, John, of Suthwerke, brewer 0
4907466 2328897 2328897 defendant Cassue John esq 586066 586066 Cassue, John, of Suthwerke, esq 1
5012696 2360553 2360553 defendant Wynchecombe Thomas   586066 586066 Wynchecombe, Thomas, of Suthwerke, yeoman, warden of Marshalsea 2
5036311 2367470 2367470 defendant Hunte Thomas dyer 586066 586066 Hunte, Thomas, of Suthwerke, dyer 0
5038103 2368029 2368029 defendant Wynchecombe Thomas   586066 586066 Wynchecombe, Thomas, of Suthwerke, Warden of Marshalsea Prison 2
5044811 2370084 2370084 defendant Goodrych John (legal representative) 586066 586066 Goodrych, John, of Suthwerke, esq, executors of 1
5076127 2379362 2379362 defendant Gilford Henry brewer 586066 586066 Gilford, Henry, of Suthwerke, brewer 0
5131295 2395641 2395641 defendant Beke Thomas clerk 586066 586066 Beke, Thomas, of Suthwerke, clerk 0
5140604 2398361 2398361 defendant Kynge William brewer 586066 586066 Kynge, William, of Suthwerke, brewer 0
5143204 2399147 2399147 defendant Stone John butcher 586066 586066 Stone, John, of Suthwerke, butcher 0
5223494 2422563 2422563 defendant Donkyn William hackneyman 586066 586066 Donkyn, William,of Suthwerke, hackneyman 0
5223496 2422563 2422563 defendant Coweman John dyer 586066 586066 Coweman, John, of Suthwerke, dyer 2
5231830 2424880 2424880 defendant Derham John baker 586066 586066 Derham, John, of Suthwerke, baker 0
5304076 2446225 2446225 defendant Andrewe Geoffrey   586066 586066 Andrewe, Geoffrey, of Suthwerke, wax chandler 0
5312186 2448679 2448679 defendant More John clerk 586066 586066 More, John, of Suthwerke, clerk 1
5312187 2448679 2448679 defendant Chapman John cordwainer 586066 586066 Chapman, John, of Suthwerke, cordwainer 2

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