names

91 rows where place_id = 594410

✎ 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
3616023 1872646 1872646 defendant Millyngton Christopher yeoman 594410 594410 Millyngton, Christopher, of Happesburgh, yeoman 0
3616624 1872829 1872829 defendant Prente Thomas smith 594410 594410 Prente, Thomas, of Happesburgh, smith 0
3628841 1903895 1903895 defendant Frank William husbandman 594410 594410 Frank, William, of Happesburgh, husbandman 2
3706230 1928236 1928236 defendant Smyth Henry husbandman 594410 594410 Smyth, Henry, of Happesburgh, husbandman 1
3749812 1941853 1941853 defendant Aunsell William husbandman 594410 594410 Aunsell, William, of Happesburgh, husbandman 0
3777067 1950575 1950575 defendant Dogett John husbandman 594410 594410 Dogett, John, of Happesburgh, husbandman 0
3821952 1964760 1964760 defendant Hert Alice widow 594410 594410 Hert, Alice, of Happesburgh, widow 1
3857943 1976127 1976127 defendant Chamberleyn Cecilia widow 594410 594410 Chamberleyn, Cecilia, of Happesburgh, widow 0
3862106 1977513 1977513 defendant Smyth Henry draper 594410 594410 Smyth, Henry, of Happesburgh, draper 0
3868735 1979783 1979783 defendant Myddylton Thomas yeoman 594410 594410 Myddylton, Thomas, of Happesburgh, yeoman 2
3882670 1984468 1984468 defendant Chamberleyn Cecilia widow 594410 594410 Chamberleyn, Cecilia, of Happesburgh, widow 0
3935905 2002324 2002324 plaintiff Leme Robert (legal representative) 594410 594410 Leme, Robert, of Happesburgh, administratrix of 0
3958787 2010151 2010151 defendant Callowe Henry husbandman 594410 594410 Callowe, Henry, of Happesburgh, husbandman 0
4027008 2034308 2034308 defendant Turcocke John yeoman 594410 594410 Turcocke, John, of Happesburgh, yeoman 0
4110376 2063972 2063972 defendant Auncell Miles husbandman 594410 594410 Auncell, Miles, of Happesburgh, husbandman 0
4284010 2124324 2124324 defendant Nutt Leonard mariner 594410 594410 Nutt, Leonard, of Happesburgh, mariner 0
4347017 2146212 2146212 defendant Lawes Robert husbandman 594410 594410 Lawes, Robert, of Happesburgh, husbandman 0
4353816 2148555 2148555 defendant Gayes Thomas yeoman 594410 594410 Gayes, Thomas, of Happesburgh, yeoman 1
4398686 2164139 2164139 defendant Lawes Robert husbandman 594410 594410 Lawes, Robert, of Happesburgh, husbandman 1
4398687 2164139 2164139 defendant Callowe Thomas, junior husbandman 594410 594410 Callowe, Thomas, junior, of Happesburgh, husbandman 2
4398692 2164141 2164141 defendant Callowe Thomas, junior husbandman 594410 594410 Callowe, Thomas, junior, of Happesburgh, husbandman 0
4398693 2164141 2164141 defendant Lawes Robert husbandman 594410 594410 Lawes, Robert, of Happesburgh, husbandman 1
4684889 2260868 2260868 defendant Ilneye John   594410 594410 Ilneye, John, of Happesburgh, franklin 1
4765392 2285159 2285159 defendant Tubbyng Robert   594410 594410 Tubbyng, Robert, of Happesburgh, husbandman: Agnes, his wife 0
4775885 2288459 2288459 defendant Turpyn Thomas yeoman 594410 594410 Turpyn, Thomas, of Happesburgh, yeoman 0
4779924 2289719 2289719 defendant Cook John brasier 594410 594410 Cook, John, of Happesburgh, brasier 4
4804455 2297578 2297578 defendant Crispyng Roger gent 594410 594410 Crispyng, Roger, of Happesburgh, gent 0
4909613 2329540 2329540 defendant Herd William husbandman 594410 594410 Herd, William, of Happesburgh, husbandman 2
4912875 2330522 2330522 defendant Swerd John husbandman 594410 594410 Swerd, John, of Happesburgh, husbandman 0
4973267 2348941 2348941 defendant Pampyng Thomas hosier 594410 594410 Pampyng, Thomas, of Happesburgh, hosier 0
4985048 2352459 2352459 defendant Goldyng William husbandman 594410 594410 Goldyng, William, of Happesburgh, husbandman 0
4991144 2354243 2354243 defendant Candebere Thomas clerk 594410 594410 Candebere, Thomas, of Happesburgh, clerk 0
4991145 2354243 2354243 defendant Holbroke William yeoman 594410 594410 Holbroke, William, of Happesburgh, yeoman 1
5007607 2359126 2359126 plaintiff Stapilton Brian esq 594410 594410 Stapilton, Brian, of Happesburgh, esq 0
5024064 2363947 2363947 defendant Auncell Benedict husbandman 594410 594410 Auncell, Benedict, of Happesburgh, husbandman 4
5024065 2363947 2363947 defendant Randolf John husbandman 594410 594410 Randolf, John, of Happesburgh, husbandman 5
5024066 2363947 2363947 defendant Sawere John husbandman 594410 594410 Sawere, John, of Happesburgh, husbandman 6
5024067 2363947 2363947 defendant atte Fen William husbandman 594410 594410 atte Fen, William, of Happesburgh, husbandman 7
5064084 2375793 2375793 defendant Horn Nicholas smith 594410 594410 Horn, Nicholas, of Happesburgh, smith 0
5080187 2380564 2380564 defendant Aslak Walter gent 594410 594410 Aslak, Walter, of Happesburgh, gent 0
5080188 2380564 2380564 defendant Alberd John   594410 594410 Alberd, John, of Happesburgh, servant 1
5080192 2380565 2380565 defendant Boteler Robert yeoman 594410 594410 Boteler, Robert, of Happesburgh, yeoman 0
5080197 2380565 2380565 defendant Aslak Walter gent 594410 594410 together with Aslak, Walter, of Happesburgh, gent 5
5080198 2380565 2380565 defendant Alberd John   594410 594410 Alberd, John, of Happesburgh, servant 6
5087257 2382653 2382653 defendant Chamberlayn John husbandman 594410 594410 Chamberlayn, John, of Happesburgh, husbandman 0
5087258 2382653 2382653 defendant Avelyn John husbandman 594410 594410 Avelyn, John, of Happesburgh, husbandman 1
5106290 2388278 2388278 defendant Lynsted Nicholas yeoman 594410 594410 Lynsted, Nicholas, of Happesburgh, yeoman 0
5107207 2388538 2388538 defendant Stapilton Brian esq 594410 594410 Stapilton, Brian, of Happesburgh, esq 0
5107208 2388538 2388538 defendant Aldres Roger laborer 594410 594410 Aldres, Roger, of Happesburgh, laborer 1
5118971 2391982 2391982 defendant Seyve Richard husbandman 594410 594410 Seyve, Richard, of Happesburgh, husbandman 0
5119916 2392260 2392260 defendant Coo Richard yeoman 594410 594410 Coo, Richard, of Happesburgh, yeoman 1
5122106 2392887 2392887 plaintiff Tubbyng Robert   594410 594410 Tubbyng, Robert, of Happesburgh 0
5122110 2392887 2392887 defendant Bertilmewe Thomas husbandman 594410 594410 Bertilmewe, Thomas, of Happesburgh, husbandman 1
5124229 2393540 2393540 defendant Lynsted Edmund yeoman 594410 594410 Lynsted, Edmund, of Happesburgh, yeoman 12
5124240 2393541 2393541 defendant Lynsted Edmund husbandman 594410 594410 Lynsted, Edmund, of Happesburgh, husbandman 6
5142672 2398982 2398982 defendant Tu--- Robert yeoman 594410 594410 Tu---, Robert, of Happesburgh, yeoman 1
5142673 2398982 2398982 defendant Baxter John husbandman 594410 594410 Baxter, John, of Happesburgh, husbandman 2
5142674 2398982 2398982 defendant Lynsted Edmund husbandman 594410 594410 Lynsted, Edmund, of Happesburgh, husbandman 3
5164061 2405224 2405224 defendant Tubbyng Robert yeoman 594410 594410 Tubbyng, Robert, of Happesburgh, yeoman 1
5164062 2405224 2405224 defendant Lynstede Edmund husbandman 594410 594410 Lynstede, Edmund, of Happesburgh, husbandman 2
5164063 2405224 2405224 defendant Baxter John husbandman 594410 594410 Baxter, John, of Happesburgh, husbandman 3
5193328 2413778 2413778 defendant Lynsted Nicholas yeoman 594410 594410 Lynsted, Nicholas, of Happesburgh, yeoman 1
5193577 2413844 2413844 defendant Tubbyng Robert husbandman 594410 594410 Tubbyng, Robert, of Happesburgh, husbandman 2
5193578 2413844 2413844 defendant Lynstede Nicholas laborer 594410 594410 Lynstede, Nicholas, of Happesburgh, laborer 3
5208137 2418111 2418111 defendant Lynsted Nicholas yeoman 594410 594410 Lynsted, Nicholas, of Happesburgh, yeoman 1
5214254 2419902 2419902 defendant Tebbe John smith 594410 594410 Tebbe, John, of Happesburgh, smith 0
5239819 2427223 2427223 defendant Tebbe John smith 594410 594410 Tebbe, John, of Happesburgh, smith 2
5359277 2462938 2462938 defendant Cook John husbandman 594410 594410 Cook, John, of Happesburgh, husbandman 2
5382271 2469987 2469987 defendant Elswete Nicholas laborer 594410 594410 Elswete, Nicholas, of Happesburgh, laborer 2
5391191 2472559 2472559 defendant Elswete Nicholas laborer 594410 594410 Elswete, Nicholas, of Happesburgh, laborer 2
5437722 2486219 2486219 defendant Baxter Robert yeoman 594410 594410 Baxter, Robert, of Happesburgh, yeoman 0
5452262 2490553 2490553 defendant Lynsted Celia widow 594410 594410 Lynsted, Celia, of Happesburgh, widow 2
5464215 2494203 2494203 defendant Lynsted Nicholas (legal representative) 594410 594410 Lynsted, Nicholas, of Happesburgh, executrix of 2
5464216 2494203 2494203 defendant Lynsted Celia widow 594410 594410 Lynsted, Celia, of Happesburgh, widow 3
5475760 2497748 2497748 defendant Lynstede Nicholas (legal representative) 594410 594410 Lynstede, Nicholas, of Happesburgh, executrix of 0
5475761 2497748 2497748 defendant Lynstede Celia widow 594410 594410 Lynstede, Celia, of Happesburgh, widow 1
5482298 2499649 2499649 defendant Baxster Robert husbandman 594410 594410 Baxster, Robert, of Happesburgh, husbandman 0
5487247 2501083 2501083 defendant Lynsted Cecily widow 594410 594410 Lynsted, Cecily, of Happesburgh, widow 0
5493603 2503002 2503002 plaintiff Elys Thomas   594410 594410 Elys, Thomas, of Happesburgh 0
5496644 2503914 2503914 defendant Johnson John mariner 594410 594410 Johnson, John, of Happesburgh, mariner 0
5497790 2504280 2504280 defendant Baxter Robert yeoman 594410 594410 Baxter, Robert, of Happesburgh, yeoman 1
5502794 2505787 2505787 defendant Heer John husbandman 594410 594410 Heer, John, of Happesburgh, husbandman 0
5502799 2505788 2505788 defendant Lacy John husbandman 594410 594410 Lacy, John, of Happesburgh, husbandman 3
5522155 2511744 2511744 defendant Millyngton Christopher yeoman 594410 594410 Millyngton, Christopher, of Happesburgh, yeoman 0
5525943 2512707 2512707 defendant Salle John mariner 594410 594410 Salle, John, of Happesburgh, mariner 0
5540283 2517089 2517089 defendant Hillyngton Geoffrey yeoman 594410 594410 Hillyngton, Geoffrey, of Happesburgh, yeoman 0
5554425 2521330 2521330 defendant Prent Thomas smith 594410 594410 Prent, Thomas, of Happesburgh, smith 2
5571113 2526113 2526113 defendant Affordby John gent 594410 594410 Affordby, John, of Happesburgh, gent 0
5571114 2526113 2526113 defendant Auncell Robert draper 594410 594410 Auncell, Robert, of Happesburgh, draper 1
5571115 2526113 2526113 defendant Elys Geoffrey yeoman 594410 594410 Elys, Geoffrey, of Happesburgh, yeoman 2
5571118 2526114 2526114 defendant Elys Geoffrey yeoman 594410 594410 Elys, Geoffrey,of Happesburgh, 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);