names

68 rows where place_id = 602315

✎ 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
3649487 1910228 1910228 defendant Cowper Robert husbandman 602315 602315 Cowper, Robert, of Wymbotesham, husbandman 1
3663793 1914609 1914609 defendant Pratt Richard, senior Norfyeoman 602315 602315 Pratt, Richard, senior, of Wymbotesham, Norfyeoman 0
3673573 1917763 1917763 defendant Pratt Richard gent 602315 602315 Pratt, Richard, of Wymbotesham, gent 0
3677732 1919085 1919085 plaintiff Macrowe Robert (legal representative) 602315 602315 Macrowe, Robert, of Wymbotesham, executors of 0
3677735 1919085 1919085 defendant Johnson Richard clerk 602315 602315 Johnson, Richard, of Wymbotesham, clerk 0
3732837 1936498 1936498 defendant Pratt Richard, senior yeoman 602315 602315 Pratt, Richard, senior, of Wymbotesham, yeoman 0
3780285 1951563 1951563 defendant Makrowe Edmund husbandman 602315 602315 Makrowe, Edmund, of Wymbotesham, husbandman 2
3849898 1973552 1973552 defendant Danam John husbandman 602315 602315 Danam, John, of Wymbotesham, husbandman 4
3945088 2005375 2005375 defendant Readhed John husbandman 602315 602315 Readhed, John, of Wymbotesham, husbandman 0
3945089 2005375 2005375 defendant Mackrowe Richard husbandman 602315 602315 Mackrowe, Richard, of Wymbotesham, husbandman 1
3956856 2009468 2009468 defendant Curteys Richard husbandman 602315 602315 Curteys, Richard, of Wymbotesham, husbandman 0
3956861 2009469 2009469 defendant Curteys Thomas yeoman 602315 602315 Curteys, Thomas, of Wymbotesham, yeoman 0
3988023 2020464 2020464 defendant Punt John husbandman 602315 602315 Punt, John, of Wymbotesham, husbandman 0
4017001 2030782 2030782 defendant Lucke William yeoman 602315 602315 Lucke, William, of Wymbotesham, yeoman 0
4039148 2038630 2038630 defendant Holyday Robert   602315 602315 Holyday, Robert, of Wymbotesham, shepherd 1
4039149 2038630 2038630 defendant Drewry Thomas laborer 602315 602315 Drewry, Thomas, of Wymbotesham, laborer 2
4039150 2038630 2038630 defendant Johnson Geoffrey husbandman 602315 602315 Johnson, Geoffrey, of Wymbotesham, husbandman 3
4042369 2039752 2039752 defendant Asshwell Thomas husbandman 602315 602315 Asshwell, Thomas, of Wymbotesham, husbandman 0
4057109 2044927 2044927 defendant Chambers Edward husbandman 602315 602315 Chambers, Edward, of Wymbotesham, husbandman 0
4072556 2050490 2050490 defendant Brewster John husbandman 602315 602315 Brewster, John, of Wymbotesham, husbandman 2
4072631 2050516 2050516 defendant Drewry Thomas husbandman 602315 602315 Drewry, Thomas, of Wymbotesham, husbandman 3
4123085 2068552 2068552 defendant Rylonde Ralph husbandman 602315 602315 Rylonde, Ralph, of Wymbotesham, husbandman 2
4139720 2074568 2074568 defendant Grenegrasse John (legal representative) 602315 602315 Grenegrasse, John, of Wymbotesham, yeoman, administrator of 2
4139721 2074568 2074568 defendant Grenegrasse John yeoman 602315 602315 Grenegrasse, John, of Wymbotesham, yeoman 3
4158428 2081019 2081019 defendant Mannynge James clerk 602315 602315 Mannynge, James, of Wymbotesham, clerk 0
4164507 2083102 2083102 defendant Grenegrasse John yeoman 602315 602315 Grenegrasse, John, of Wymbotesham, yeoman 3
4180412 2088625 2088625 defendant Laycocke Roland laborer 602315 602315 Laycocke, Roland, of Wymbotesham, laborer 0
4185640 2090482 2090482 defendant Bull Thomas   602315 602315 Bull, Thomas, of Wymbotesham, shepherd 0
4205772 2097567 2097567 defendant Bale Robert husbandman 602315 602315 Bale, Robert, of Wymbotesham, husbandman 1
4301583 2130671 2130671 defendant Welles Thomas husbandman 602315 602315 Welles, Thomas, of Wymbotesham, husbandman 0
4301584 2130671 2130671 defendant Wysman John husbandman 602315 602315 Wysman, John, of Wymbotesham, husbandman 1
4301585 2130671 2130671 defendant Wysman Henry husbandman 602315 602315 Wysman, Henry, of Wymbotesham, husbandman 2
4301586 2130671 2130671 defendant Wysman Francis husbandman 602315 602315 Wysman, Francis, of Wymbotesham, husbandman 3
4301588 2130672 2130672 defendant Dye Robert husbandman 602315 602315 Dye, Robert, of Wymbotesham, husbandman 0
4301589 2130672 2130672 defendant Michell Robert husbandman 602315 602315 Michell, Robert, of Wymbotesham, husbandman 1
4301590 2130672 2130672 defendant Michell John thatcher 602315 602315 together with Michell, John, of Wymbotesham, thatcher 2
4301591 2130672 2130672 defendant Ashell Thomas husbandman 602315 602315 Ashell, Thomas, of Wymbotesham, husbandman 3
4302891 2131134 2131134 defendant Blake Jasper gent 602315 602315 Blake, Jasper, of Wymbotesham, gent 0
4302893 2131135 2131135 defendant Blake Jasper gent 602315 602315 Blake, Jasper, of Wymbotesham, gent 0
4302894 2131135 2131135 defendant Plumtree John   602315 602315 Plumtree, John, of Wymbotesham, shepherd 1
4304354 2131661 2131661 defendant Wells Thomas husbandman 602315 602315 Wells, Thomas, of Wymbotesham, husbandman 0
4304355 2131661 2131661 defendant Wysman John husbandman 602315 602315 Wysman, John, of Wymbotesham, husbandman 1
4304356 2131661 2131661 defendant Pey Richard husbandman 602315 602315 Pey, Richard, of Wymbotesham, husbandman 2
4304357 2131661 2131661 defendant Osborne Robert husbandman 602315 602315 together with Osborne, Robert, of Wymbotesham, husbandman 3
4304359 2131662 2131662 defendant Wyseman Henry yeoman 602315 602315 Wyseman, Henry, of Wymbotesham, yeoman 0
4310106 2133690 2133690 defendant Wells Thomas husbandman 602315 602315 Wells, Thomas, of Wymbotesham, husbandman 0
4310107 2133690 2133690 defendant Wyseman John husbandman 602315 602315 Wyseman, John, of Wymbotesham, husbandman 1
4310108 2133690 2133690 defendant Wyseman Henry husbandman 602315 602315 Wyseman, Henry, of Wymbotesham, husbandman 2
4310109 2133690 2133690 defendant Wyseman Francis husbandman 602315 602315 Wyseman, Francis, of Wymbotesham, husbandman 3
4340024 2143777 2143777 defendant Kydd Henry yeoman 602315 602315 (Kydd, Henry, of Wymbotesham, yeoman 1
4532938 2210571 2210571 defendant Socheman Thomas   602315 602315 Socheman, Thomas, of Wymbotesham 0
4532940 2210572 2210572 defendant Sotheman Thomas   602315 602315 Sotheman, Thomas, of Wymbotesham 0
4629486 2240150 2240150 defendant Hamond John   602315 602315 Hamond, John, of Wymbotesham 1
4629487 2240151 2240151 plaintiff Souter Margaret   602315 602315 Souter, Margaret, of Wymbotesham, formerly wife of Peter 0
4731039 2274912 2274912 defendant Smyth William smith 602315 602315 Smyth, William, of Wymbotesham, smith 0
4733385 2275618 2275618 defendant Roper Richard husbandman 602315 602315 Roper, Richard, of Wymbotesham, husbandman 0
4753793 2281559 2281559 defendant Mynnys John husbandman 602315 602315 Mynnys, John, of Wymbotesham, husbandman 2
4825084 2303887 2303887 defendant Slauter Thomas husbandman 602315 602315 Slauter, Thomas, of Wymbotesham, husbandman 0
5117139 2391438 2391438 defendant Bathkome Richard chapman 602315 602315 Bathkome, Richard, of Wymbotesham, chapman 2
5281402 2439632 2439632 defendant Catcheare Edmund husbandman 602315 602315 Catcheare, Edmund, of Wymbotesham, husbandman 0
5338110 2456490 2456490 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 1
5338156 2456501 2456501 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 2
5397156 2474270 2474270 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 0
5397158 2474271 2474271 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 0
5408347 2477469 2477469 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 0
5410328 2478042 2478042 defendant Blake Peter gent 602315 602315 Blake, Peter, of Wymbotesham, gent 0
5524476 2512355 2512355 defendant Moderak William clerk 602315 602315 Moderak, William, of Wymbotesham, clerk 5
5583932 2530051 2530051 defendant Wesenam Thomas husbandman 602315 602315 Wesenam, Thomas, of Wymbotesham, husbandman 1

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