names

50 rows where place_id = 596003

✎ 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
3622739 1874639 1874639 defendant Broun James mariner 596003 596003 Broun, James, of Leystofte, mariner 1
3642311 1908043 1908043 defendant Dene Ralph draper 596003 596003 Dene, Ralph, of Leystofte, draper 0
3692378 1923790 1923790 plaintiff Jetore John   596003 596003 Jetore, John, of Leystofte 0
3696752 1925210 1925210 defendant Sexten John pewterer 596003 596003 Sexten, John, of Leystofte, pewterer 0
3696753 1925210 1925210 defendant Coke Joan widow 596003 596003 Coke, Joan, of Leystofte, widow 1
3696754 1925210 1925210 defendant Hank or Hauk Thomas husbandman 596003 596003 Hank or Hauk, Thomas, of Leystofte, husbandman 2
3696755 1925210 1925210 defendant Clerke Richard husbandman 596003 596003 Clerke, Richard, of Leystofte, husbandman 3
3710124 1929478 1929478 defendant Lobbys Geoffrey merchant 596003 596003 Lobbys, Geoffrey, of Leystofte, merchant 0
3723403 1933587 1933587 defendant Garre Robert yeoman 596003 596003 Garre, Robert, of Leystofte, yeoman 2
3724687 1934006 1934006 defendant Lobbys Geoffrey merchant 596003 596003 Lobbys, Geoffrey, of Leystofte, merchant 0
3734338 1936978 1936978 defendant Lobbys Geoffrey yeoman 596003 596003 Lobbys, Geoffrey, of Leystofte, yeoman 0
3826792 1966232 1966232 defendant Jetar John yeoman 596003 596003 (Jetar, John, of Leystofte, yeoman 2
3826801 1966234 1966234 defendant Jetar John yeoman 596003 596003 (Jetar, John, of Leystofte, yeoman 2
3861897 1977438 1977438 defendant Arnold Matthew cordwainer 596003 596003 Arnold, Matthew, of Leystofte, cordwainer 0
3868035 1979542 1979542 defendant Dubbyng John cooper 596003 596003 Dubbyng, John, of Leystofte, cooper 2
3870978 1980546 1980546 plaintiff Annott Thomas   596003 596003 Annott, Thomas, of Leystofte 0
3940999 2003995 2003995 defendant Tye Thomas clerk 596003 596003 Tye, Thomas, of Leystofte, clerk 0
3947893 2006327 2006327 defendant Goddard John merchant 596003 596003 Goddard, John, of Leystofte, merchant 0
3949089 2006747 2006747 plaintiff Drawer Thomas (legal representative) 596003 596003 Drawer, Thomas, of Leystofte, merchant, executors of 0
3949095 2006748 2006748 plaintiff Drawer Thomas (legal representative) 596003 596003 Drawer, Thomas, of Leystofte, merchant, executors of 0
3949100 2006749 2006749 plaintiff Drawer Thomas (legal representative) 596003 596003 Drawer, Thomas, of Leystofte, merchant, executors of 0
3952361 2007896 2007896 defendant Smythe Robert merchant 596003 596003 Smythe, Robert, of leystofte, merchant 2
3976448 2016336 2016336 defendant Broke William husbandman 596003 596003 Broke, William, of Leystofte, husbandman 0
3976450 2016337 2016337 defendant Broke William husbandman 596003 596003 Broke, William, of Leystofte, husbandman 0
3995484 2023130 2023130 defendant Grudgefeld John merchant 596003 596003 Grudgefeld, John, of Leystofte, merchant 0
4014329 2029849 2029849 defendant Dameron Thomas yeoman 596003 596003 Dameron, Thomas, of Leystofte, yeoman 5
4015470 2030230 2030230 defendant Jagges Thomas innkeeper 596003 596003 Jagges, Thomas, of Leystofte, innkeeper 0
4015471 2030230 2030230 defendant Mewse William butcher 596003 596003 Mewse, William, of Leystofte, butcher 1
4017912 2031120 2031120 defendant Roydon John butcher 596003 596003 Roydon, John, of Leystofte, butcher 0
4029403 2035154 2035154 plaintiff Damford William mercer 596003 596003 Damford, William, of Leystofte, mercer 0
4044092 2040340 2040340 defendant Broke Thomas husbandman 596003 596003 Broke, Thomas, of Leystofte, or of Whetacreburgh, Norf, husbandman 0
4047570 2041579 2041579 defendant Porter William draper 596003 596003 Porter, William, of Leystofte, draper 0
4063723 2047315 2047315 defendant Wardall Richard miller 596003 596003 Wardall, Richard, of Leystofte, miller 2
4132937 2072106 2072106 defendant Neslinge William husbandman 596003 596003 Neslinge, William, of Leystofte, husbandman 2
4177100 2087465 2087465 defendant Rodyen John butcher 596003 596003 Rodyen, John, of Leystofte, butcher 0
4180856 2088783 2088783 defendant Aynesworthe Thomas yeoman 596003 596003 Aynesworthe, Thomas, of Leystofte, yeoman 0
4180857 2088783 2088783 defendant Aynesworthe Anne widow 596003 596003 Anne his wife, formerly Anne Grene, of Leystofte, widow 1
4180858 2088783 2088783 defendant Cawdell William mercer 596003 596003 Cawdell, William, of Leystofte, mercer 2
4275700 2121446 2121446 defendant Acton Edmund yeoman 596003 596003 Acton, Edmund, of Leystofte, or of Aldebye, Norf, yeoman 0
5278837 2438921 2438921 plaintiff Boffe John gent 596003 596003 Boffe, John, of Leystofte, gent 0
5353019 2461032 2461032 defendant Thomson John, junior baker 596003 596003 Thomson, John, junior, of Leystofte, baker 3
5490016 2501900 2501900 defendant Blakeman William mariner 596003 596003 Blakeman, William, of Leystofte, mariner 0
5490017 2501900 2501900 defendant Colte Alan   596003 596003 Colte, Alan, of Leystofte, mariner, administrators of 1
5490018 2501900 2501900 defendant Colte Anne widow 596003 596003 (Colte, Anne, of Leystofte, widow 2
5490019 2501900 2501900 defendant Clerke Edmund shoemaker 596003 596003 Clerke, Edmund, of Leystofte, shoemaker 3
5558021 2522303 2522303 defendant Deene Ralph draper 596003 596003 Deene, Ralph, of Leystofte, draper 0
5569338 2525590 2525590 defendant Denne Ralph yeoman 596003 596003 Denne, Ralph, of Leystofte, yeoman 0
5578699 2528400 2528400 defendant Denne Ralph   596003 596003 Denne, Ralph, of Leystofte, Suff, yailor 0
5593507 2532953 2532953 defendant Dene Ralph draper 596003 596003 Dene, Ralph, of Leystofte, draper 3
5602835 2535771 2535771 defendant Bower John husbandman 596003 596003 Bower, John, of Leystofte, 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);