names

57 rows where place_id = 589157

✎ 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
3596714 1866607 1866607 defendant Cheseman Philip laborer 589157 589157 Cheseman, Philip, of Alfryston, laborer 2
3641769 1907877 1907877 defendant Loll William yeoman 589157 589157 Loll, William, of Alfryston, yeoman 2
3684578 1921311 1921311 defendant Roles Stephen gent 589157 589157 Roles, Stephen, of Alfryston, gent 2
3684581 1921311 1921311 defendant Lolle William barber 589157 589157 Lolle, William, of Alfryston, barber 5
3693727 1924232 1924232 defendant Reynold Thomas chapman 589157 589157 Reynold, Thomas, of Alfryston, chapman 1
3699806 1926165 1926165 defendant Rotes Stephen gent 589157 589157 Rotes, Stephen, of Alfryston, gent 2
3770358 1948403 1948403 defendant Hennegge Thomas gent 589157 589157 Hennegge, Thomas, of Alfryston, gent 0
3807193 1960146 1960146 defendant Henenge William (legal representative) 589157 589157 Henenge, William, of Alfryston, gent, executor of 0
3807194 1960146 1960146 defendant Henege Thomas gent 589157 589157 Henege, Thomas, of Alfryston, gent 1
3852812 1974486 1974486 defendant Alborne John laborer 589157 589157 Alborne, John, of Alfryston, laborer 0
3860850 1977121 1977121 defendant A Wood Thomas husbandman 589157 589157 A Wood, Thomas, of Alfryston, husbandman 0
3865234 1978578 1978578 defendant Underhyll John butcher 589157 589157 Underhyll, John, of Alfryston, butcher 0
3894477 1988360 1988360 defendant Wellys Richard laborer 589157 589157 Wellys, Richard, of Alfryston, laborer 0
3916382 1995860 1995860 defendant Russell John butcher 589157 589157 Russell, John, of Alfryston, butcher 1
3916385 1995861 1995861 defendant Russell John butcher 589157 589157 Russell, John, of Alfryston, butcher 1
3918223 1996429 1996429 defendant Benett John tailor 589157 589157 Benett, John, of Alfryston, tailor 0
3958708 2010119 2010119 defendant Goodale John husbandman 589157 589157 Goodale, John, of Alfryston, husbandman 2
3988985 2020800 2020800 defendant Sellen Robert husbandman 589157 589157 Sellen, Robert, of Alfryston, husbandman 1
3988986 2020800 2020800 defendant Renne John husbandman 589157 589157 Renne, John, of Alfryston, husbandman 2
4013772 2029656 2029656 plaintiff Russell John yeoman 589157 589157 Russell, John, of Alfryston, yeoman 0
4030292 2035488 2035488 defendant Morrys John tailor 589157 589157 Morrys, John, of Alfryston, tailor 1
4063678 2047301 2047301 defendant Hoell John yeoman 589157 589157 Hoell, John, of Alfryston, yeoman 0
4063679 2047301 2047301 defendant Fyssher Robert yeoman 589157 589157 Fyssher, Robert, of Alfryston, yeoman 1
4063681 2047302 2047302 defendant Walcott William husbandman 589157 589157 Walcott, William, of Alfryston, husbandman 0
4063682 2047302 2047302 defendant Hasylgrove William husbandman 589157 589157 Hasylgrove, William, of Alfryston, husbandman 1
4063683 2047302 2047302 defendant Mathewe Richard husbandman 589157 589157 Mathewe, Richard, of Alfryston, husbandman 2
4067582 2048723 2048723 defendant Hurst Denis clerk 589157 589157 Hurst, Denis, of Alfryston, clerk 0
4079598 2053002 2053002 defendant Russell John butcher 589157 589157 (Russell, John, of Alfryston, butcher 1
4079599 2053002 2053002 defendant Russell Thomas yeoman 589157 589157 Russell, Thomas, of Alfryston, yeoman 2
4095449 2058696 2058696 defendant Cole Benjamin shoemaker 589157 589157 Cole, Benjamin, of Alfryston, shoemaker 0
4095450 2058696 2058696 defendant Fayrebank Salamon shoemaker 589157 589157 Fayrebank, Salamon, of Alfryston, shoemaker 1
4108647 2063347 2063347 defendant Coole Edward husbandman 589157 589157 Coole, Edward, of Alfryston, husbandman 0
4126677 2069828 2069828 defendant Gyles John   589157 589157 Gyles, John, of Alfryston husbandman 0
4126680 2069829 2069829 defendant Gyles John husbandman 589157 589157 Gyles, John, of Alfryston, husbandman 0
4132128 2071804 2071804 defendant Russell John yeoman 589157 589157 Russell, John, of Alfryston, yeoman 0
4136555 2073418 2073418 defendant Colvyle Thomas yeoman 589157 589157 Colvyle, Thomas, of Alfryston, yeoman 0
4153122 2079189 2079189 defendant Russell John husbandman 589157 589157 Russell, John, of Alfryston, husbandman 3
4172325 2085785 2085785 defendant Payne John butcher 589157 589157 Payne, John, of Alfryston, butcher 1
4173956 2086346 2086346 defendant Russell John butcher 589157 589157 Russell, John, of Alfryston, butcher 0
4174013 2086363 2086363 defendant Payne John butcher 589157 589157 Payne, John, of Alfryston, or of Wynchelsie, butcher 0
4181617 2089056 2089056 defendant Standishe Edward yeoman 589157 589157 Standishe, Edward, of Alfryston, yeoman 1
4182004 2089187 2089187 defendant Raynes William shoemaker 589157 589157 Raynes, William, of Alfryston, shoemaker 0
4184917 2090232 2090232 defendant Payne George butcher 589157 589157 Payne, George, of Alfryston, butcher 3
4189009 2091640 2091640 defendant Bryght Richard husbandman 589157 589157 Bryght, Richard, of Alfryston, husbandman 2
4202048 2096260 2096260 defendant Colvyll Thomas yeoman 589157 589157 Colvyll, Thomas, of Alfryston, yeoman 1
4329962 2140321 2140321 defendant Adams William yeoman 589157 589157 Adams, William, of Alfryston, yeoman 0
4370356 2154451 2154451 defendant Addams Alexander husbandman 589157 589157 Addams, Alexander, of Alfryston, husbandman 0
4381795 2158592 2158592 defendant Fyssenden William innkeeper 589157 589157 Fyssenden, William, of Alfryston, yeoman, or of Aston, innkeeper 2
4381798 2158593 2158593 defendant Fyssenden William innkeeper 589157 589157 Fyssenden, William, of Alfryston, yeoman, innkeeper 1
4389431 2161091 2161091 defendant Myssell John glover 589157 589157 Myssell, John, of Alfryston, glover 0
5246810 2429232 2429232 defendant Hyches Richard smith 589157 589157 Hyches, Richard, of Alfryston, smith 0
5335107 2455567 2455567 defendant Ray John husbandman 589157 589157 Ray, John, of Alfryston, husbandman 0
5335112 2455568 2455568 defendant Comber John husbandman 589157 589157 Comber, John, of Alfryston, husbandman 0
5394643 2473529 2473529 defendant Ray John husbandman 589157 589157 Ray, John, of Alfryston, husbandman 0
5407876 2477332 2477332 defendant Ray John husbandman 589157 589157 Ray, John, of Alfryston, husbandman 0
5547875 2519398 2519398 defendant Chuke John husbandman 589157 589157 Chuke, John, of Alfryston, husbandman 0
5575197 2527332 2527332 plaintiff Smyth Robert tailor 589157 589157 Smyth, Robert, of Alfryston, tailor 0

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