names

44 rows where place_id = 602821

✎ 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
3651926 1910950 1910950 defendant Moreff Peter yeoman 602821 602821 Moreff, Peter, of Dunwich, Suff, yeoman 2
3667574 1915801 1915801 defendant Thompson John mariner 602821 602821 Thompson, John, of Dunwich, Suff, mariner 3
3694742 1924560 1924560 defendant Thorp William merchant 602821 602821 Thorp, William, of Dunwich, Suff, merchant 0
3899940 1990199 1990199 defendant Dowe John (legal representative) 602821 602821 Dowe, John, of Dunwich, Suff, yeoman, executors of 0
3899941 1990199 1990199 defendant Bumble Richard butcher 602821 602821 (Bumble, Richard, of Dunwich, of Suff, butcher 1
3936208 2002435 2002435 defendant Cryspe John husbandman 602821 602821 Cryspe, John, of Dunwich, Suff, husbandman 0
3947042 2006029 2006029 defendant Fyler Nicholas mariner 602821 602821 Fyler, Nicholas, of Dunwich, Suff, mariner 1
3947291 2006122 2006122 defendant Aldermen and sheriff of London ex parte John Passett merchant 602821 602821 Aldermen and sheriff of London, ex parte John Passett, of Dunwich, Suff, merchant 0
3963550 2011859 2011859 defendant Flemyng Joan widow 602821 602821 Flemyng, Joan, of Dunwich, Suff, widow 0
3976025 2016180 2016180 defendant Jenney Christopher gent 602821 602821 Jenney, Christopher, of Dunwich, Suff, gent 0
3976465 2016343 2016343 defendant Jenney Christopher gent 602821 602821 Jenney, Christopher, of Dunwich, Suff, gent 0
3976875 2016483 2016483 defendant Foster John mariner 602821 602821 (Foster, John, of Dunwich, Suff, mariner 1
4072745 2050553 2050553 defendant Gentylman John vintner 602821 602821 Gentylman, John, of Dunwich, Suff, vintner 1
4076019 2051722 2051722 defendant Bocher Thomas yeoman 602821 602821 Bocher, Thomas, of Dunwich, Suff, yeoman 0
4080657 2053395 2053395 plaintiff Watson Richard (legal representative) 602821 602821 Watson, Richard, of Dunwich, Suff, merchant, executor of 0
4087389 2055782 2055782 defendant Coppyn Gregory merchant 602821 602821 Coppyn, Gregory, of Dunwich, Suff, merchant 0
4112061 2064568 2064568 defendant Jentleman John innholder 602821 602821 Jentleman, John, of Dunwich, Suff, merchant, innholder 0
4167310 2084065 2084065 defendant Cowper Michael merchant 602821 602821 Cowper, Michael, of Dunwich, Suff, merchant 0
4170596 2085215 2085215 defendant Mayer Thomas mercer 602821 602821 Mayer, Thomas, of Dunwich, Suff, mercer 0
4174709 2086623 2086623 defendant Waller George yeoman 602821 602821 Waller, George, of Dunwich, Suff, yeoman 1
4193396 2093257 2093257 defendant Thackarye Thomas clerk 602821 602821 Thackarye, Thomas, of Dunwich, Suff, clerk 3
4193401 2093258 2093258 defendant Edmund George thatcher 602821 602821 Edmund, George, of Dunwich, Suff, thatcher 3
4195958 2094140 2094140 defendant Coffyn Petronilla widow 602821 602821 Coffyn, Petronilla, of Dunwich, Suff, widow 1
4216195 2101155 2101155 defendant Pickeringe Lancelot yeoman 602821 602821 Pickeringe, Lancelot, of Dunwich, Suff, yeoman 0
4240931 2109952 2109952 defendant Pyckering Lancelot yeoman 602821 602821 Pyckering, Lancelot, of Dunwich, Suff, yeoman 0
4240936 2109953 2109953 defendant Pyckeringe Lancelot yeoman 602821 602821 Pyckeringe, Lancelot, of Dunwich, Suff, yeoman 0
4246751 2111890 2111890 defendant Pickeringe Lancelot yeoman 602821 602821 Pickeringe, Lancelot, of Dunwich, Suff, yeoman 3
4325788 2138999 2138999 defendant Cowper Michael mariner 602821 602821 Cowper, Michael, of Dunwich, Suff, mariner 0
4392366 2162072 2162072 defendant Pyckeryn Lancelot gent 602821 602821 Pyckeryn, Lancelot, of Dunwich, Suff, gent 0
4687487 2261682 2261682 defendant Busshe William merchant 602821 602821 Busshe, William, of Dunwich, Suff, merchant 0
4760373 2283598 2283598 defendant Brampton Thomas taverner 602821 602821 Brampton, Thomas, of Dunwich, Suff, taverner 1
4895704 2325332 2325332 defendant Barbour William yeoman 602821 602821 Barbour, William, of Dunwich, Suff, yeoman 1
5268347 2435867 2435867 defendant Codon Peter gent 602821 602821 Codon, Peter, of Dunwich, Suff, gent 0
5268567 2435927 2435927 defendant Coden Peter gent 602821 602821 Coden, Peter, of Dunwich, Suff, gent 0
5445185 2488450 2488450 defendant Pyers Thomas yeoman 602821 602821 Pyers, Thomas, of Dunwich, Suff, yeoman 0
5457871 2492252 2492252 defendant Aldriche Thomas yeoman 602821 602821 Aldriche, Thomas, of Dunwich, Suff, yeoman 0
5464730 2494365 2494365 defendant Tower John mercer 602821 602821 Tower, John, of Dunwich, Suff, mercer 0
5464732 2494366 2494366 defendant Tower John mercer 602821 602821 Tower, John, of Dunwich, Suff, mercer 0
5469663 2495850 2495850 defendant (illegible) Thomas yeoman 602821 602821 _, Thomas, of Dunwich, Suff, yeoman 0
5476220 2497893 2497893 defendant Tower John mercer 602821 602821 Tower, John, of Dunwich, Suff, mercer 0
5477134 2498169 2498169 defendant Alderyche John yeoman 602821 602821 Alderyche, John, of Dunwich, Suff, yeoman 0
5524350 2512343 2512343 defendant Emster Thomas clerk 602821 602821 Emster, Thomas, of Dunwich, Suff, clerk 1
5524408 2512349 2512349 defendant Emster Thomas clerk 602821 602821 Emster, Thomas, of Dunwich, Suff, clerk 2
5527941 2513304 2513304 defendant Theket John mariner 602821 602821 Theket, John, of Dunwich, Suff, mariner 4

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