names

69 rows where place_id = 589511

✎ 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
3597826 1866938 1866938 defendant Elmham John shoemaker 589511 589511 Elmham, John, of Saxmondham, shoemaker 2
3673541 1917750 1917750 plaintiff Fennell Edmund (legal representative) 589511 589511 Fennell, Edmund, of Saxmondham, executors of 0
3947997 2006363 2006363 plaintiff Wyllett Robert sherman 589511 589511 Wyllett, Robert, of Saxmondham, sherman 2
3951835 2007703 2007703 defendant Pattryche Robert laborer 589511 589511 Pattryche, Robert, of Saxmondham, laborer 2
3960992 2010940 2010940 defendant Norman John (legal representative) 589511 589511 Norman, John, of Saxmondham, tailor, executors of 0
3963779 2011933 2011933 defendant Norman Robert yeoman 589511 589511 Norman, Robert, of Saxmondham, yeoman 7
3963780 2011933 2011933 defendant Riches William yeoman 589511 589511 Riches, William, of Saxmondham, yeoman 8
3974069 2015499 2015499 defendant Drewry Edward draper 589511 589511 Drewry, Edward, of Saxmondham, draper 0
3978045 2016895 2016895 defendant Drewry Edward yeoman 589511 589511 Drewry, Edward, of Saxmondham, yeoman 2
4030152 2035429 2035429 defendant Osbern Joan widow 589511 589511 Osbern, Joan, of Saxmondham, widow 2
4032758 2036369 2036369 defendant Drewry Edward   589511 589511 Drewry, Edward, of Saxmondham, woollen draper 0
4063721 2047315 2047315 defendant Lee Robert husbandman 589511 589511 Lee, Robert, of Saxmondham, husbandman 0
4063722 2047315 2047315 defendant Spyncke John clerk 589511 589511 Spyncke, John, of Saxmondham, clerk 1
4197041 2094518 2094518 defendant Castle William husbandman 589511 589511 Castle, William, of Saxmondham, husbandman 1
4198873 2095162 2095162 defendant Barefote John butcher 589511 589511 Barefote, John, of Saxmondham, butcher 1
4198925 2095181 2095181 defendant Venables James clerk 589511 589511 Venables, James, of Saxmondham, clerk 0
4203409 2096744 2096744 defendant Pope Geoffrey yeoman 589511 589511 Pope, Geoffrey, of Saxmondham, yeoman 0
4304451 2131697 2131697 defendant Helwys Nicholas yeoman 589511 589511 Helwys, Nicholas, of Saxmondham, yeoman 0
4304452 2131697 2131697 defendant Helwys Robert yeoman 589511 589511 Helwys, Robert, of Saxmondham, yeoman 1
4306464 2132401 2132401 defendant Webster Thomas singleman 589511 589511 Webster, Thomas, of Saxmondham, yeoman, or of Bramerton, Norf, singleman 0
4307528 2132771 2132771 defendant Kyddall Robert yeoman 589511 589511 Kyddall, Robert, of Saxmondham, yeoman 1
4307748 2132849 2132849 defendant Helwyse Robert yeoman 589511 589511 Helwyse, Robert, of Saxmondham, yeoman 1
4331147 2140716 2140716 defendant Davyes Thomas   589511 589511 Davyes, Thomas, of Saxmondham, collar maker 3
4578762 2224844 2224844 defendant Flykke John   589511 589511 Flykke, John, of Saxmondham 0
4578763 2224844 2224844 defendant Bele Thomas   589511 589511 Bele, Thomas, of Saxmondham 1
4578764 2224844 2224844 defendant Bele John tailor 589511 589511 Bele, John, of Saxmondham, tailor 2
4600297 2231321 2231321 defendant Kille John   589511 589511 Kille, John, of Saxmondham, plough man 0
4600299 2231322 2231322 defendant Kylle John   589511 589511 Kylle, John, of Saxmondham, plough man 0
4643863 2244304 2244304 defendant Page Robert   589511 589511 Page, Robert, of Saxmondham 0
4645821 2244846 2244846 plaintiff Page Robert   589511 589511 Page, Robert, of Saxmondham 0
4645822 2244846 2244846 defendant Launde Edmund   589511 589511 Launde, Edmund, of Saxmondham 0
4645823 2244847 2244847 plaintiff Page Robert   589511 589511 Page, Robert, of Saxmondham 0
4645824 2244847 2244847 defendant Launde Edmund   589511 589511 Launde, Edmund, of Saxmondham 0
4657885 2248351 2248351 defendant Elys Thomas butcher 589511 589511 Elys, Thomas, of Saxmondham, butcher 2
4660601 2249142 2249142 defendant Elys Thomas husbandman 589511 589511 Elys, Thomas, of Saxmondham, husbandman 3
4661574 2249454 2249454 plaintiff Elys Thomas   589511 589511 Elys, Thomas, of Saxmondham 0
4804655 2297652 2297652 defendant Starlyng John mercer 589511 589511 Starlyng, John, of Saxmondham, mercer 0
4826634 2304365 2304365 defendant Fornsete John yeoman 589511 589511 Fornsete, John, of Saxmondham, yeoman 2
4833842 2306591 2306591 defendant Clampe John husbandman 589511 589511 Clampe, John, of Saxmondham, husbandman 0
4952559 2342723 2342723 defendant Seman Thomas cordwainer 589511 589511 Seman, Thomas, of Saxmondham, cordwainer 0
4952560 2342723 2342723 defendant Kenge William husbandman 589511 589511 Kenge, William, of Saxmondham, husbandman 1
4986803 2352992 2352992 defendant Taylour John shoemaker 589511 589511 Taylour, John, of Saxmondham, shoemaker 0
4989959 2353905 2353905 defendant Knyght William baker 589511 589511 Knyght, William, of Saxmondham, baker 0
5009904 2359771 2359771 defendant Taillour John shoemaker 589511 589511 Taillour, John, of Saxmondham, shoemaker 0
5020988 2363038 2363038 defendant Kille Joohn fuller 589511 589511 Kille, Joohn, of Saxmondham, fuller 0
5059215 2374320 2374320 defendant Knyghtes William baker 589511 589511 Knyghtes, William, of Saxmondham, baker 2
5071076 2377841 2377841 defendant Knyght William yeoman 589511 589511 Knyght, William, of Saxmondham, yeoman 0
5076118 2379359 2379359 defendant Pepyn Thomas husbandman 589511 589511 Pepyn, Thomas, of Saxmondham, husbandman 0
5095677 2385158 2385158 defendant Knyght William yeoman 589511 589511 Knyght, William, of Saxmondham, yeoman 0
5139529 2398048 2398048 defendant Knyght William baker 589511 589511 Knyght, William, of Saxmondham, baker 2
5175287 2408464 2408464 defendant Knyght William baker 589511 589511 Knyght, William, of Saxmondham, baker 2
5212561 2419420 2419420 defendant Pye Thomas husbandman 589511 589511 Pye, Thomas, of Saxmondham, husbandman 2
5242811 2428102 2428102 defendant Hygham William gent 589511 589511 Hygham, William, of Saxmondham, gent 0
5254342 2431488 2431488 defendant Dousyng Stephen yeoman 589511 589511 Dousyng, Stephen, of Saxmondham, yeoman 2
5261480 2433703 2433703 defendant Frenshe William scrivener 589511 589511 Frenshe, William, of Saxmondham, scrivener 0
5261482 2433703 2433703 defendant Storke John smith 589511 589511 Storke, John, of Saxmondham, smith 2
5266057 2435134 2435134 defendant Stilyard John clerk 589511 589511 Stilyard, John, of Saxmondham, clerk 0
5280881 2439481 2439481 defendant Bedon Thomas husbandman 589511 589511 Bedon, Thomas, of Saxmondham, husbandman 0
5284422 2440460 2440460 defendant Bedon Thomas baker 589511 589511 Bedon, Thomas, of Saxmondham, baker 0
5298109 2444461 2444461 defendant Bedon Thomas baker 589511 589511 Bedon, Thomas, of Saxmondham, baker 0
5298110 2444461 2444461 defendant Marlyngham Robert husbandman 589511 589511 Marlyngham, Robert, of Saxmondham, husbandman 1
5312898 2448890 2448890 defendant Marlyngham Robert husbandman 589511 589511 Marlyngham, Robert, of Saxmondham, husbandman 0
5314432 2449343 2449343 defendant Grymbyll William, senior yeoman 589511 589511 Grymbyll, William, senior, of Saxmondham, yeoman 0
5413707 2479026 2479026 defendant Kenge Robert laborer 589511 589511 Kenge, Robert, of Saxmondham, laborer 1
5428988 2483589 2483589 defendant Higham William yeoman 589511 589511 Higham, William, of Saxmondham, yeoman 0
5431219 2484281 2484281 defendant Higham William yeoman 589511 589511 Higham, William, of Saxmondham, yeoman 0
5448543 2489462 2489462 defendant Broun Alexander   589511 589511 Broun, Alexander, of Saxmondham 0
5460123 2492961 2492961 defendant Hegham William yeoman 589511 589511 Hegham, William, of Saxmondham, yeoman 0
5460129 2492963 2492963 defendant Higham William yeoman 589511 589511 Higham, William, of Saxmondham, yeoman 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);