names

655 rows where place_id = 587167

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590644 1864716 1864716 defendant Hunte Thomas carpenter 587167 587167 Hunte, Thomas, of Parva Walsyngham, carpenter 0
3591473 1864958 1864958 defendant Candeler Nicholas husbandman 587167 587167 Candeler, Nicholas, of Parva Walsyngham, husbandman 0
3591856 1865074 1865074 defendant Drey Ralph yeoman 587167 587167 Drey, Ralph, of Parva Walsyngham, yeoman 0
3593432 1865579 1865579 defendant Hunt Thomas baker 587167 587167 Hunt, Thomas, of Parva Walsyngham, baker 0
3595854 1866342 1866342 defendant Drye Ralph husbandman 587167 587167 Drye, Ralph, of Parva Walsyngham, husbandman 1
3595855 1866342 1866342 defendant Whitlok Thomas smith 587167 587167 Whitlok, Thomas, of Parva Walsyngham, smith 2
3596238 1866450 1866450 defendant Drye Ralph yeoman 587167 587167 Drye, Ralph, of Parva Walsyngham, yeoman 0
3597891 1866961 1866961 defendant Farwellys John yeoman 587167 587167 Farwellys, John, of Parva Walsyngham, yeoman 2
3602018 1868291 1868291 defendant Goddyng Edward draper 587167 587167 Goddyng, Edward, of Parva Walsyngham, draper 0
3602286 1868380 1868380 defendant Goddyng William shoemaker 587167 587167 Goddyng, William, of Parva Walsyngham, shoemaker 1
3603386 1868731 1868731 defendant Lyng Stephen (legal representative) 587167 587167 Lyng, Stephen, of Parva Walsyngham, administrator of 0
3603387 1868731 1868731 defendant Wandeham Henry husbandman 587167 587167 Wandeham, Henry, of Parva Walsyngham, husbandman 1
3603389 1868732 1868732 defendant Lyng Stephen (legal representative) 587167 587167 Lyng, Stephen, of Parva Walsyngham, administrator of 0
3603390 1868732 1868732 defendant Wandeham Henry husbandman 587167 587167 Wandeham, Henry, of Parva Walsyngham, husbandman 1
3603813 1868863 1868863 defendant Rykker William   587167 587167 Rykker, William, of Parva Walsyngham, paten maker 1
3603814 1868863 1868863 defendant Goddyng William shoemaker 587167 587167 Goddyng, William, of Parva Walsyngham, shoemaker 2
3604013 1868921 1868921 defendant Dry Robert yeoman 587167 587167 Dry, Robert, of Parva Walsyngham, yeoman 0
3604086 1868945 1868945 defendant Drye Ralph yeoman 587167 587167 Drye, Ralph, of Parva Walsyngham, yeoman 0
3604464 1869065 1869065 defendant Goddyng Edward draper 587167 587167 Goddyng, Edward, of Parva Walsyngham, draper 0
3605200 1869292 1869292 defendant Goddyng Edward draper 587167 587167 Goddyng, Edward, of Parva Walsyngham, draper 0
3605201 1869292 1869292 defendant Goddyng William shoemaker 587167 587167 Goddyng, William, of Parva Walsyngham, shoemaker 1
3606801 1869801 1869801 defendant Race Richard glover 587167 587167 Race, Richard, of Parva Walsyngham, glover 0
3607738 1870071 1870071 defendant Ferwellis John yeoman 587167 587167 Ferwellis, John, of Parva Walsyngham, yeoman 2
3607744 1870072 1870072 defendant Farwellys John yeoman 587167 587167 Farwellys, John, of Parva Walsyngham, yeoman 2
3615966 1872627 1872627 defendant Gyles John chaplain 587167 587167 Gyles, John, of Parva Walsyngham, chaplain 1
3618315 1873358 1873358 defendant Mateshale Thomas husbandman 587167 587167 Mateshale, Thomas, of Parva Walsyngham, husbandman 0
3618316 1873358 1873358 defendant Wade William husbandman 587167 587167 Wade, William, of Parva Walsyngham, husbandman 1
3618317 1873358 1873358 defendant Hoker William husbandman 587167 587167 Hoker, William, of Parva Walsyngham, husbandman 2
3620306 1873931 1873931 defendant Gresham William gent 587167 587167 Gresham, William, of Parva Walsyngham, gent 0
3620569 1874009 1874009 defendant Candeler William baker 587167 587167 Candeler, William, of Parva Walsyngham, baker 0
3622106 1874450 1874450 plaintiff Warner John   587167 587167 Warner, John, of Parva Walsyngham 1
3624055 1875053 1875053 defendant Gresham William gent 587167 587167 Gresham, William, of Parva Walsyngham, gent 1
3627484 1903453 1903453 defendant Marcoll Thomas butcher 587167 587167 Marcoll, Thomas, of Parva Walsyngham, butcher 0
3627485 1903453 1903453 defendant Peycok Thomas cordwainer 587167 587167 Peycok, Thomas, of Parva Walsyngham, cordwainer 1
3627486 1903453 1903453 defendant Clerk John glover 587167 587167 Clerk, John, of Parva Walsyngham, glover 2
3628814 1903886 1903886 plaintiff Clyderowe henry (legal representative) 587167 587167 Clyderowe, henry, of Parva Walsyngham, executors of 0
3628818 1903886 1903886 defendant Kesewyk William yeoman 587167 587167 Kesewyk, William, of Parva Walsyngham, yeoman 0
3629788 1904168 1904168 defendant Dodde John butcher 587167 587167 Dodde, John, of Parva Walsyngham, butcher 0
3631584 1904691 1904691 defendant Flegge Peter raffman 587167 587167 Flegge, Peter, of Parva Walsyngham, raffman 0
3631585 1904691 1904691 defendant Carre Thomas yeoman 587167 587167 Carre, Thomas, of Parva Walsyngham, yeoman 1
3634059 1905450 1905450 defendant Stone William (legal representative) 587167 587167 Stone, William, of Parva Walsyngham, yeoman, executors of 1
3634060 1905450 1905450 defendant Stone Margaret widow 587167 587167 (Stone, Margaret, of Parva Walsyngham, widow 2
3634061 1905450 1905450 defendant Stone Richard yeoman 587167 587167 Stone, Richard, of Parva Walsyngham, yeoman 3
3634257 1905513 1905513 defendant Malby William tailor 587167 587167 Malby, William, of Parva Walsyngham, tailor 0
3642536 1908108 1908108 defendant Elys John mercer 587167 587167 Elys, John, of Parva Walsyngham, mercer 0
3642772 1908188 1908188 defendant Burgate Peter husbandman 587167 587167 Burgate, Peter, of Parva Walsyngham, husbandman 3
3642790 1908193 1908193 defendant Burgate Peter yeoman 587167 587167 Burgate, Peter, of Parva Walsyngham, yeoman 0
3643155 1908298 1908298 defendant Hart John innholder 587167 587167 Hart, John, of Parva Walsyngham, innholder 0
3647712 1909673 1909673 defendant Marshall Nicholas husbandman 587167 587167 Marshall, Nicholas, of Parva Walsyngham, husbandman 0
3652568 1911136 1911136 defendant Davyson Thomas baker 587167 587167 Davyson, Thomas, of Parva Walsyngham, baker 0
3670536 1916747 1916747 defendant Lathe Geffrey yeoman 587167 587167 Lathe, Geffrey, of Parva Walsyngham, yeoman 1
3671933 1917220 1917220 defendant Mercer William innholder 587167 587167 Mercer, William, of Parva Walsyngham, innholder 0
3673523 1917746 1917746 defendant Tayllour John tailor 587167 587167 Tayllour, John, of Parva Walsyngham, tailor 0
3673714 1917806 1917806 defendant Burges Oliver glover 587167 587167 Burges, Oliver, of Parva Walsyngham, glover 0
3673715 1917806 1917806 defendant Carre John hosteler 587167 587167 Carre, John, of Parva Walsyngham, hosteler 1
3674121 1917946 1917946 defendant Flege Peter raffman 587167 587167 Flege, Peter, of Parva Walsyngham, raffman 1
3674608 1918109 1918109 defendant Burges Oliver glover 587167 587167 Burges, Oliver, of Parva Walsyngham, glover 3
3674636 1918118 1918118 defendant Oldeman John baker 587167 587167 Oldeman, John, of Parva Walsyngham, baker 0
3674638 1918119 1918119 defendant Oldman John baker 587167 587167 Oldman, John, of Parva Walsyngham, baker 0
3675910 1918502 1918502 defendant Shyrwyn Alan   587167 587167 Shyrwyn, Alan, of Parva Walsyngham, minstrel 0
3676407 1918666 1918666 defendant Qwarell Thomas   587167 587167 Qwarell, Thomas, of Parva Walsyngham, wax chandler 2
3677782 1919099 1919099 defendant Mercer William tapster 587167 587167 Mercer, William, of Parva Walsyngham, tapster 0
3677784 1919100 1919100 defendant Mercer William tapster 587167 587167 Mercer, William, of Parva Walsyngham, tapster 0
3677786 1919101 1919101 defendant Mercer William tapster 587167 587167 Mercer, William, of Parva Walsyngham, tapster 0
3677788 1919102 1919102 defendant Mercer William tapster 587167 587167 Mercer, William, of Parva Walsyngham, tapster 0
3677789 1919102 1919102 defendant Swhayn Thomas barber 587167 587167 Swhayn, Thomas, of Parva Walsyngham, barber 1
3677791 1919103 1919103 defendant Swayn Thomas barber 587167 587167 Swayn, Thomas, of Parva Walsyngham, barber 0
3678088 1919194 1919194 defendant Hart John innholder 587167 587167 Hart, John, of Parva Walsyngham, innholder 0
3679366 1919609 1919609 defendant Baile William innholder 587167 587167 Baile, William, of Parva Walsyngham, innholder 0
3680203 1919880 1919880 defendant Mateshale Thomas, junior mercer 587167 587167 Mateshale, Thomas, junior, of Parva Walsyngham, mercer 0
3680685 1920039 1920039 defendant Marley George yeoman 587167 587167 Marley, George, of Parva Walsyngham, yeoman 0
3681249 1920221 1920221 defendant Marlowe George husbandman 587167 587167 Marlowe, George, of Parva Walsyngham, husbandman 0
3681256 1920223 1920223 defendant Marlowe George husbandman 587167 587167 Marlowe, George, of Parva Walsyngham, husbandman 1
3686176 1921840 1921840 defendant Ramage Thomas baker 587167 587167 Ramage, Thomas, of Parva Walsyngham, baker 0
3686177 1921840 1921840 defendant Wheteley Thomas baker 587167 587167 Wheteley, Thomas, of Parva Walsyngham, baker 1
3686591 1921957 1921957 defendant Clyfton John   587167 587167 Clyfton, John, of Parva Walsyngham, court holder 0
3689586 1922900 1922900 defendant Grene Richard butcher 587167 587167 Grene, Richard, of Parva Walsyngham, butcher 0
3689592 1922903 1922903 defendant Reymes Oliver gent 587167 587167 Reymes, Oliver, of Parva Walsyngham, gent 0
3689595 1922904 1922904 defendant Reymes Oliver gent 587167 587167 Reymes, Oliver, of Parva Walsyngham, gent 0
3689620 1922914 1922914 defendant Malby William draper 587167 587167 Malby, William, of Parva Walsyngham, draper 1
3689624 1922915 1922915 defendant Malby William draper 587167 587167 Malby, William, of Parva Walsyngham, draper 1
3690538 1923207 1923207 defendant Hoker Roger butcher 587167 587167 Hoker, Roger, of Parva Walsyngham, butcher 0
3691838 1923607 1923607 defendant Mathewe John graver 587167 587167 Mathewe, John, of Parva Walsyngham, graver 0
3692252 1923746 1923746 defendant Oldman John baker 587167 587167 Oldman, John, of Parva Walsyngham, baker 1
3692275 1923753 1923753 defendant Chapman William mercer 587167 587167 Chapman, William, of Parva Walsyngham, mercer 2
3692281 1923755 1923755 defendant Oldman John baker 587167 587167 Oldman, John, of Parva Walsyngham, baker 1
3692284 1923756 1923756 defendant Reymes Oliver gent 587167 587167 Reymes, Oliver, of Parva Walsyngham, gent 1
3692286 1923757 1923757 defendant Morley William   587167 587167 Morley, William, of Parva Walsyngham, worsted weaver 0
3693651 1924209 1924209 defendant Cooke Thomas chapman 587167 587167 Cooke, Thomas, of Parva Walsyngham, chapman 0
3693667 1924213 1924213 defendant Matsall Thomas, senior chapman 587167 587167 Matsall, Thomas, senior, of Parva Walsyngham, chapman 1
3693669 1924213 1924213 defendant Reames Oliver gent 587167 587167 Reames, Oliver, of Parva Walsyngham, gent 3
3693671 1924214 1924214 defendant Lyon John (legal representative) 587167 587167 Lyon, John, of Parva Walsyngham, barker, executors of 0
3693673 1924214 1924214 defendant Matsale Thomas, senior chapman 587167 587167 Matsale, Thomas, senior, of Parva Walsyngham, chapman 2
3693674 1924214 1924214 defendant Reames Oliver gent 587167 587167 Reames, Oliver, of Parva Walsyngham, gent 3
3695140 1924698 1924698 defendant Maltby William draper 587167 587167 Maltby, William, of Parva Walsyngham, draper 1
3697461 1925425 1925425 defendant Cootys Robert baker 587167 587167 Cootys, Robert, of Parva Walsyngham, baker 0
3697653 1925490 1925490 defendant Porter James mercer 587167 587167 Porter, James, of Parva Walsyngham, mercer 0
3698413 1925724 1925724 defendant Shirwyn Alan   587167 587167 Shirwyn, Alan, of Parva Walsyngham, minstrel 0
3699782 1926154 1926154 defendant Hoper Roger butcher 587167 587167 Hoper, Roger, of Parva Walsyngham, butcher 0
3699783 1926154 1926154 defendant Semecroft Clement saddler 587167 587167 Semecroft, Clement, of Parva Walsyngham, saddler 1

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