names

150 rows where place_id = 588918

✎ 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
3595999 1866378 1866378 defendant Olyver James husbandman 588918 588918 Olyver, James, of Petworth, husbandman 2
3615678 1872549 1872549 defendant Parkeman Richard husbandman 588918 588918 Parkeman, Richard, of Petworth, husbandman 2
3617393 1873058 1873058 defendant Forde William butcher 588918 588918 Forde, William, of Petworth, butcher 0
3618419 1873394 1873394 defendant Heth Robert butcher 588918 588918 Heth, Robert, of Petworth, butcher 0
3618914 1873525 1873525 defendant Everton William   588918 588918 Everton, William, of Petworth, Sussex chapman 3
3670047 1916577 1916577 plaintiff Boyer William, junior   588918 588918 Boyer, William, junior, of Petworth 0
3670049 1916578 1916578 plaintiff Boyer William, junior   588918 588918 Boyer, William, junior, of Petworth 0
3683406 1920932 1920932 defendant Bysby Joan widow 588918 588918 Bysby, Joan, of Petworth, widow 1
3683407 1920932 1920932 defendant Goodyere Thomas weaver 588918 588918 Goodyere, Thomas, of Petworth, weaver 2
3697498 1925438 1925438 defendant Morys Nicholas chaplain 588918 588918 Morys, Nicholas, of Petworth, chaplain 0
3718826 1932168 1932168 defendant Nappar Thomas husbandman 588918 588918 Nappar, Thomas, of Petworth, husbandman 0
3721168 1932919 1932919 defendant Blundell Richard husbandman 588918 588918 Blundell, Richard, of Petworth, husbandman 0
3738638 1938294 1938294 defendant Gobyll Henry yeoman 588918 588918 Gobyll, Henry, of Petworth, yeoman 0
3768196 1947693 1947693 defendant Bowyer William clothmaker 588918 588918 Bowyer, William, of Petworth, clothmaker 2
3785034 1953101 1953101 defendant Skynner Henry yeoman 588918 588918 Skynner, Henry, of Petworth, yeoman 0
3811033 1961344 1961344 defendant Fevam William shoemaker 588918 588918 Fevam, William, of Petworth, shoemaker 0
3811278 1961423 1961423 defendant Bowyer John yeoman 588918 588918 Bowyer, John, of Petworth, yeoman 0
3823634 1965290 1965290 defendant Bowyer John gent 588918 588918 Bowyer, John, of Petworth, gent 0
3844777 1971910 1971910 defendant Bowyer Richard yeoman 588918 588918 Bowyer, Richard, of Petworth, yeoman 0
3856916 1975794 1975794 defendant Durkyn John husbandman 588918 588918 Durkyn, John, of Petworth, husbandman 0
3856917 1975794 1975794 defendant Toplyng John laborer 588918 588918 Toplyng, John, of Petworth, laborer 1
3856918 1975794 1975794 defendant Palmer Richard laborer 588918 588918 Palmer, Richard, of Petworth, laborer 2
3872058 1980885 1980885 defendant Forde Richard butcher 588918 588918 Forde, Richard, of Petworth, butcher 0
3880454 1983719 1983719 defendant Bowyer Richard, junior yeoman 588918 588918 Bowyer, Richard, junior, of Petworth, yeoman 0
3883011 1984582 1984582 defendant Bowyer Richard yeoman 588918 588918 Bowyer, Richard, of Petworth, yeoman 0
3891916 1987550 1987550 defendant Mychell John clother 588918 588918 Mychell, John, of Petworth, clother 0
3899855 1990164 1990164 defendant Beeff William butcher 588918 588918 Beeff, William, of Petworth, butcher 0
3899856 1990164 1990164 defendant Symon Richard clothier 588918 588918 Symon, Richard, of Petworth, clothier 1
3899857 1990164 1990164 defendant Hamper Richard, junior butcher 588918 588918 Hamper, Richard, junior, of Petworth, butcher 2
3899858 1990164 1990164 defendant Okelande Andrew clothier 588918 588918 Okelande, Andrew, of Petworth, clothier 3
3899859 1990164 1990164 defendant Blondell John butcher 588918 588918 Blondell, John, of Petworth, butcher 4
3913959 1995015 1995015 defendant Humfrey John clothier 588918 588918 Humfrey, John, of Petworth, clothier 0
3913985 1995022 1995022 defendant Symond Richard clothier 588918 588918 Symond, Richard, of Petworth, clothier 1
3915270 1995472 1995472 defendant Bowyer Richard merchant 588918 588918 Bowyer, Richard, of Petworth, merchant 0
3920084 1997051 1997051 defendant Manne John husbandman 588918 588918 Manne, John, of Petworth, husbandman 0
3923865 1998291 1998291 defendant Bowyer John butcher 588918 588918 Bowyer, John, of Petworth, butcher 0
3923867 1998292 1998292 defendant Bowyer Richard yeoman 588918 588918 Bowyer, Richard, of Petworth, yeoman 0
3923869 1998293 1998293 defendant Couper Robert yeoman 588918 588918 Couper, Robert, of Petworth, yeoman 0
3930553 2000562 2000562 defendant Forde Robert butcher 588918 588918 Forde, Robert, of Petworth, butcher 0
3933712 2001568 2001568 defendant Aylewyn Richard butcher 588918 588918 Aylewyn, Richard, of Petworth, butcher 0
3933714 2001569 2001569 defendant Aylwyn Richard butcher 588918 588918 Aylwyn, Richard, of Petworth, butcher 0
3937092 2002740 2002740 defendant Smyth alias Lawrence Robert butcher 588918 588918 Smyth alias Lawrence, Robert, of Petworth, butcher 0
3937095 2002741 2002741 defendant Smyth alias Lawrens Robert butcher 588918 588918 Smyth alias Lawrens, Robert, of Petworth, butcher 0
3967298 2013195 2013195 defendant Telynge William husbandman 588918 588918 Telynge, William, of Petworth, husbandman 1
3975898 2016134 2016134 defendant Meryfelde Edward chapman 588918 588918 Meryfelde, Edward, of Petworth, chapman 0
3983329 2018810 2018810 plaintiff Smythe Thomas yeoman 588918 588918 Smythe, Thomas, of Petworth, yeoman 0
4020467 2032043 2032043 defendant Turgeys Richard chapman 588918 588918 Turgeys, Richard, of Petworth, chapman 0
4020988 2032231 2032231 defendant Trashe Thomas tailor 588918 588918 Trashe, Thomas, of Petworth, tailor 3
4079097 2052825 2052825 defendant Agmondesham Francis gent 588918 588918 Agmondesham, Francis, of Petworth, gent 1
4079098 2052825 2052825 defendant Teeling James weaver 588918 588918 Teeling, James, of Petworth, weaver 2
4080326 2053274 2053274 defendant Telynge William yeoman 588918 588918 Telynge, William, of Petworth, yeoman 0
4097307 2059355 2059355 defendant Tylse Richard shoemaker 588918 588918 Tylse, Richard, of Petworth, shoemaker 3
4119296 2067194 2067194 defendant Smyth Nicholas clerk 588918 588918 Smyth, Nicholas, of Petworth, clerk 0
4128119 2070348 2070348 defendant Fowles Robert goldsmith 588918 588918 Fowles, Robert, of Petworth, goldsmith 3
4139159 2074371 2074371 defendant Jago Hugh yeoman 588918 588918 Jago, Hugh, of Petworth, yeoman 1
4139163 2074372 2074372 defendant Ubley William chapman 588918 588918 Ubley, William, of Petworth, chapman 1
4139165 2074372 2074372 defendant Spencer Thomas gent 588918 588918 Spencer, Thomas, of Petworth, gent 3
4164746 2083180 2083180 defendant Smyth Thomas (legal representative) 588918 588918 Smyth, Thomas, of Petworth, yeoman, executors of 1
4167076 2083988 2083988 defendant Smyth Nicholas clerk 588918 588918 Smyth, Nicholas, of Petworth, clerk 0
4185700 2090501 2090501 defendant Norrys John yeoman 588918 588918 Norrys, John, of Petworth, yeoman 2
4307398 2132725 2132725 defendant Rodes Robert yeoman 588918 588918 Rodes, Robert, of Petworth, yeoman 0
4322643 2137987 2137987 defendant Ackson Hugh   588918 588918 Ackson, Hugh, of Petworth, medicus 1
4334200 2141716 2141716 defendant Acson Hugh   588918 588918 Acson, Hugh, of Petworth, medicus 1
4366172 2152940 2152940 defendant Morryshe Thomas weaver 588918 588918 Morryshe, Thomas, of Petworth, weaver 3
4366178 2152942 2152942 defendant Dawtrey Charles gent 588918 588918 Dawtrey, Charles, of Petworth, gent 1
4366938 2153225 2153225 defendant Brytten George gent 588918 588918 Brytten, George, of Petworth, gent 0
4366939 2153225 2153225 defendant Brytten Henry gent 588918 588918 Brytten, Henry, of Petworth, gent 1
4370799 2154608 2154608 defendant Ireland Richard   588918 588918 Ireland, Richard, of Petworth, wood broker 0
4370800 2154608 2154608 defendant Bromham John   588918 588918 Bromham, John, of Petworth, wood broker 1
4378085 2157229 2157229 defendant Breton George gent 588918 588918 Breton, George, of Petworth, gent 0
4378086 2157229 2157229 defendant Breton Henry   588918 588918 Breton, Henry, of Petworth, gent, his son 1
4402020 2165266 2165266 defendant Frye George yeoman 588918 588918 Frye, George, of Petworth, yeoman 4
4478842 2194053 2194053 defendant Sopere John   588918 588918 Sopere, John, of Petworth 0
4495618 2199313 2199313 defendant Bumstede John   588918 588918 Bumstede, John, of Petworth 0
4495620 2199314 2199314 defendant Bumstede John   588918 588918 Bumstede, John, of Petworth 0
4587571 2227517 2227517 plaintiff Imbehawe Thomas   588918 588918 Imbehawe, Thomas, of Petworth 0
4609762 2234148 2234148 plaintiff Burton John   588918 588918 Burton, John, of Petworth, parson 0
4683142 2260342 2260342 defendant Turgys John parker 588918 588918 Turgys, John, of Petworth, parker 0
4694431 2263755 2263755 defendant Apsele William yeoman 588918 588918 Apsele, William, of Petworth, yeoman 1
4696261 2264313 2264313 defendant Turgys John   588918 588918 Turgys, John, of Petworth, park man 0
4711570 2268943 2268943 defendant Wykyng Nicholas chapman 588918 588918 Wykyng, Nicholas, of Petworth, chapman 0
4719968 2271590 2271590 defendant Wright Richard barber 588918 588918 Wright, Richard, of Petworth, barber 0
4728930 2274287 2274287 defendant Wright Richard barber 588918 588918 Wright, Richard, of Petworth, barber 0
4757414 2282692 2282692 defendant Capron William butcher 588918 588918 Capron, William, of Petworth, butcher 2
4845697 2310167 2310167 defendant Strode William husbandman 588918 588918 Strode, William, of Petworth, husbandman 1
4846493 2310412 2310412 defendant atte Halle Robert laborer 588918 588918 atte Halle, Robert, of Petworth, laborer 0
4859731 2314409 2314409 defendant Kyng John chapman 588918 588918 Kyng, John, of Petworth, chapman 1
4868764 2317202 2317202 defendant atte Rook John smith 588918 588918 atte Rook, John, of Petworth, smith 0
4919986 2332762 2332762 defendant Baynard John (legal representative) 588918 588918 Baynard, John, of Petworth, executrix of 2
4919994 2332764 2332764 defendant Baynard John (legal representative) 588918 588918 Baynard, John, of Petworth, executrix of 3
4952951 2342844 2342844 defendant Holden Edmund   588918 588918 Holden, Edmund, of Petworth, administrators of 0
4952954 2342844 2342844 defendant Holden John yeoman 588918 588918 Holden, John, of Petworth, yeoman 3
4957123 2344089 2344089 defendant Percy Henry   588918 588918 Percy, Henry, of Petworth, Earl of Northumberland 0
4957130 2344091 2344091 defendant Percy Henry   588918 588918 Percy, Henry, of Petworth, Earl of Northumberland 0
4966493 2346913 2346913 defendant Gunter John, junior husbandman 588918 588918 Gunter, John, junior, of Petworth, husbandman 0
4967457 2347209 2347209 defendant Mynford Richard baker 588918 588918 Mynford, Richard, of Petworth, baker 0
4975677 2349687 2349687 defendant Yatys Thomas clerk 588918 588918 Yatys, Thomas, of Petworth, clerk 1
4975678 2349687 2349687 defendant Strode John chapman 588918 588918 Strode, John, of Petworth, chapman 2
4983549 2351995 2351995 defendant Percy Henry   588918 588918 Percy, Henry, of Petworth, Earl of Northumberland 0
4990370 2354029 2354029 defendant Fen James carpenter 588918 588918 Fen, James, of Petworth, carpenter 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);