names

60 rows where place_id = 591527

✎ 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
3604673 1869124 1869124 defendant Baynyard Thomas gent 591527 591527 Baynyard, Thomas, of Gorleston, Suff, gent 1
3864924 1978472 1978472 defendant Gunnevile Richard gent 591527 591527 Gunnevile, Richard, of Gorleston, Suff, gent 1
3871705 1980772 1980772 defendant Envile Richard gent 591527 591527 Envile, Richard, of Gorleston, Suff, gent 1
3931451 2000816 2000816 defendant Hunt John yeoman 591527 591527 Hunt, John, of Gorleston, Suff, yeoman 4
3941217 2004066 2004066 defendant Hunt John husbandman 591527 591527 Hunt, John, of Gorleston, Suff, husbandman 0
3947220 2006094 2006094 defendant Turbutt Walter   591527 591527 Turbutt, Walter, of Gorleston, Suff, shipwright 0
3959094 2010265 2010265 plaintiff Seberfame Peter   591527 591527 Seberfame, Peter, of Gorleston, Suff 0
3959112 2010272 2010272 plaintiff Sekersame Peter   591527 591527 Sekersame, Peter, of Gorleston, Suff 0
3972869 2015084 2015084 defendant Browne Thomas innholder 591527 591527 Browne, Thomas, of Gorleston, Suff, innholder 0
3982658 2018565 2018565 defendant Browne Thomas husbandman 591527 591527 Browne, Thomas, of Gorleston, Suff, husbandman 3
3996740 2023596 2023596 defendant Turbytt Walter   591527 591527 Turbytt, Walter, of Gorleston, Suff, shipwright 0
4000321 2024885 2024885 defendant Nyxton Thomas yeoman 591527 591527 Nyxton, Thomas, of Gorleston, Suff, yeoman 0
4007574 2027493 2027493 defendant Androwe William yeoman 591527 591527 Androwe, William, of Gorleston, Suff, yeoman 0
4007581 2027496 2027496 defendant Androwes William yeoman 591527 591527 Androwes, William, of Gorleston, Suff, yeoman 0
4021009 2032239 2032239 defendant Lewys Thomas laborer 591527 591527 Lewys, Thomas, of Gorleston, Suff, laborer 1
4021561 2032437 2032437 defendant Basingham John haberdasher 591527 591527 Basingham, John, of Gorleston, Suff, haberdasher 1
4029849 2035318 2035318 defendant Gilbert John laborer 591527 591527 Gilbert, John, of Gorleston, Suff, laborer 2
4035620 2037414 2037414 defendant Edwardes Charles yeoman 591527 591527 Edwardes, Charles, of Gorleston, Suff, yeoman 0
4044671 2040542 2040542 defendant Harryson John   591527 591527 Harryson, John, of Gorleston, Suff, or of Norwich, basket maker 0
4044679 2040546 2040546 defendant Harrysson John basketmaker 591527 591527 Harrysson, John, of Gorleston, Suff, or of Norwich, basketmaker 0
4048917 2042057 2042057 defendant Harryson John innholder 591527 591527 Harryson, John, of Gorleston, Suff, innholder 0
4048949 2042065 2042065 defendant Ferror alias Bane Thomas mariner 591527 591527 Ferror alias Bane, Thomas, of Gorleston, Suff, mariner 0
4053282 2043550 2043550 defendant Cresse John husbandman 591527 591527 Cresse, John, of Gorleston, Suff, husbandman 7
4061146 2046395 2046395 defendant Blomevylle Jerome gent 591527 591527 Blomevylle, Jerome, of Gorleston, Suff, gent 0
4066411 2048281 2048281 defendant Havard Barnard smith 591527 591527 Havard, Barnard, of Gorleston, Suff, smith 1
4074099 2051032 2051032 defendant Blomevile Jerome gent 591527 591527 Blomevile, Jerome, of Gorleston, Suff, gent 0
4078189 2052502 2052502 defendant Blomevyll Jerome gent 591527 591527 Blomevyll, Jerome, of Gorleston, Suff, gent 0
4089949 2056694 2056694 defendant Blomevyle Jerome gent 591527 591527 Blomevyle, Jerome, of Gorleston, Suff, gent 0
4125739 2069489 2069489 defendant Johnson Richard cooper 591527 591527 Johnson, Richard, of Gorleston, Suff, cooper 1
4131050 2071421 2071421 defendant Burman Richard husbandman 591527 591527 Burman, Richard, of Gorleston, Suff, husbandman 1
4140665 2074901 2074901 defendant Pynchebecke John gent 591527 591527 Pynchebecke, John, of Gorleston, Suff, gent 0
4144803 2076344 2076344 defendant Townshend Henry grocer 591527 591527 Townshend, Henry, of Gorleston, Suff, grocer 2
4144820 2076348 2076348 defendant Townsend Henry grocer 591527 591527 Townsend, Henry, of Gorleston, Suff, grocer 3
4187135 2090993 2090993 defendant Bretton Thomas gent 591527 591527 Bretton, Thomas, of Gorleston, Suff, gent 0
4191520 2092596 2092596 defendant Andrewes Walter yeoman 591527 591527 Andrewes, Walter, of Gorleston, Suff, yeoman 2
4218655 2102022 2102022 defendant Attwood Edmund smith 591527 591527 Attwood, Edmund, of Gorleston, Suff, smith 2
4220361 2102627 2102627 defendant Smyth Henry beer brewer 591527 591527 Smyth, Henry, of Gorleston, Suff, beer brewer 0
4244361 2111091 2111091 defendant Johnson Richard yeoman 591527 591527 Johnson, Richard, of Gorleston, Suff, yeoman 2
4244366 2111092 2111092 defendant Johnson Richard yeoman 591527 591527 Johnson, Richard, of Gorleston, Suff, yeoman 2
4275859 2121506 2121506 defendant Calfe Robert yeoman 591527 591527 Calfe, Robert, of Gorleston, Suff, yeoman 0
4316038 2135722 2135722 defendant Gostlynge Robert yeoman 591527 591527 Gostlynge, Robert, of Gorleston, Suff, yeoman 0
4393616 2162468 2162468 defendant Browne Robert yeoman 591527 591527 Browne, Robert, of Gorleston, Suff, yeoman 2
4749057 2280209 2280209 defendant Assheman Thomas gent 591527 591527 Assheman, Thomas, of Gorleston, Suff, gent 0
4749060 2280210 2280210 defendant Assheman Thomas gent 591527 591527 Assheman, Thomas, of Gorleston, Suff, gent 0
4786714 2291899 2291899 defendant Asshman Thomas esq 591527 591527 Asshman, Thomas, of Gorleston, Suff, esq 0
4795118 2294619 2294619 defendant Hevyrlond Thomas husbandman 591527 591527 Hevyrlond, Thomas, of Gorleston, Suff, husbandman 1
4830054 2305445 2305445 defendant Radbot William laborer 591527 591527 Radbot, William, of Gorleston, Suff, laborer 3
4835007 2306951 2306951 defendant Strete Roger husbandman 591527 591527 Strete, Roger, of Gorleston, Suff, husbandman 1
4851232 2311833 2311833 defendant Jekkesson William   591527 591527 Jekkesson, William, of Gorleston, Suff, franklin 2
4885047 2322217 2322217 defendant Radbode William husbandman 591527 591527 Radbode, William, of Gorleston, Suff, husbandman 5
4897057 2325734 2325734 defendant Hemmesby John husbandman 591527 591527 Hemmesby, John, of Gorleston, Suff, husbandman 0
4900853 2326898 2326898 defendant Veer John smith 591527 591527 Veer, John, of Gorleston, Suff, smith 2
4935311 2337445 2337445 defendant Scherman John butcher 591527 591527 Scherman, John, of Gorleston, Suff, butcher 1
4954730 2343368 2343368 defendant Waterman William smith 591527 591527 Waterman, William, of Gorleston, Suff, smith 4
5092130 2384075 2384075 defendant Hullok Stephen yeoman 591527 591527 Hullok, Stephen, of Gorleston, Suff, yeoman 1
5093305 2384439 2384439 defendant Clement Robert husbandman 591527 591527 Clement, Robert, of Gorleston, Suff, husbandman 2
5279510 2439085 2439085 defendant Poleyn John capenter 591527 591527 Poleyn, John, of Gorleston, Suff, capenter 0
5358739 2462794 2462794 defendant Lambe Robert merchant 591527 591527 Lambe, Robert, of Gorleston, Suff, merchant 0
5470331 2496049 2496049 defendant (illegible) John (legal representative) 591527 591527 _, John, of Gorleston, Suff, yeoman, executor of 2
5470332 2496049 2496049 defendant Stonham John yeoman 591527 591527 Stonham, John, of Gorleston, Suff, yeoman 3

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