names

57 rows where place_id = 753777

✎ 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
4415764 2169817 2169817 defendant Fenkele Robert   753777 753777 Fenkele, Robert, of Wetheryngsete 0
4421215 2171528 2171528 defendant Gonchild William   753777 753777 Gonchild, William, of Wetheryngsete 0
4422736 2171967 2171967 defendant Bette John   753777 753777 Bette, John, of Wetheryngsete 2
4432250 2174869 2174869 defendant Breggeman William   753777 753777 Breggeman, William, of Wetheryngsete 1
4436955 2176301 2176301 plaintiff Thorp John de (legal representative) 753777 753777 Thorp, John de, of Wetheryngsete, parson, executors of 0
4436961 2176301 2176301 defendant Barre Robert   753777 753777 Barre, Robert, of Wetheryngsete 3
4436963 2176301 2176301 defendant Pouere Stephen le   753777 753777 Pouere, Stephen le, of Wetheryngsete 5
4439092 2181510 2181510 defendant Fraunceys William   753777 753777 Fraunceys, William, of Wetheryngsete 1
4444278 2183197 2183197 defendant Whyte John   753777 753777 Whyte, John, of Wetheryngsete 1
4466014 2190029 2190029 defendant Pournesly Roger   753777 753777 Pournesly, Roger, of Wetheryngsete 0
4474986 2192847 2192847 defendant Broome John   753777 753777 Broome, John, of Wetheryngsete 0
4523126 2207564 2207564 plaintiff Hardekyn Richard   753777 753777 Hardekyn, Richard, of Wetheryngsete 0
4545362 2214474 2214474 defendant Fullere William   753777 753777 Fullere, William, of Wetheryngsete 0
4625447 2238921 2238921 defendant Lobbe Thomas tailor 753777 753777 Lobbe, Thomas, of Wetheryngsete, tailor 0
4625448 2238921 2238921 defendant Lobbe John tailor 753777 753777 Lobbe, John, of Wetheryngsete, tailor 1
4625449 2238921 2238921 defendant Lobbe Roger tailor 753777 753777 Lobbe, Roger, of Wetheryngsete, tailor 2
4625450 2238921 2238921 defendant Lobbe Robert smith 753777 753777 Lobbe, Robert, of Wetheryngsete, smith 3
4625451 2238921 2238921 defendant Govyl Richard thatcher 753777 753777 Govyl, Richard, of Wetheryngsete, thatcher 4
4656063 2247776 2247776 defendant Bylawe John husbandman 753777 753777 Bylawe, John, of Wetheryngsete, husbandman 0
4662261 2249669 2249669 defendant Wryght John carpenter 753777 753777 Wryght, John, of Wetheryngsete, carpenter 0
4663046 2249908 2249908 plaintiff Garnays or Garvays William   753777 753777 Garnays or Garvays, William, of Wetheryngsete 0
4668856 2255963 2255963 defendant Norreys Walter husbandman 753777 753777 Norreys, Walter, of Wetheryngsete, husbandman 0
4698942 2265147 2265147 defendant Wodeward Richard butcher 753777 753777 (Wodeward, Richard, of Wetheryngsete, butcher 2
4714221 2269778 2269778 defendant Gyles Reginald fuller 753777 753777 Gyles, Reginald, of Wetheryngsete, fuller 0
4727572 2273863 2273863 defendant Fuller William fuller 753777 753777 Fuller, William, of Wetheryngsete, fuller 0
4738465 2277122 2277122 defendant Hert John fuller 753777 753777 Hert, John, of Wetheryngsete, fuller 0
4744298 2278855 2278855 defendant fullere William yeoman 753777 753777 fullere, William, of Wetheryngsete, yeoman 1
4756811 2282496 2282496 defendant atte Hawe Thomas yeoman 753777 753777 atte Hawe, Thomas, of Wetheryngsete, yeoman 0
4770118 2286622 2286622 defendant Bilhagh John gent 753777 753777 Bilhagh, John, of Wetheryngsete, gent 0
4772679 2287427 2287427 defendant Bylagh John gent 753777 753777 Bylagh, John, of Wetheryngsete, gent 0
4798007 2295561 2295561 defendant Bylagh John gent 753777 753777 Bylagh, John, of Wetheryngsete, gent 0
4882166 2321325 2321325 defendant Langham William chaplain 753777 753777 Langham, William, of Wetheryngsete, chaplain 0
4894960 2325088 2325088 plaintiff Hamond Robert (legal representative) 753777 753777 Hamond, Robert, of Wetheryngsete, esq, executors of 0
4918566 2332324 2332324 plaintiff Hamond Robert (legal representative) 753777 753777 Hamond, Robert, of Wetheryngsete, esq, executors of 0
4943993 2340087 2340087 plaintiff Gybrook or Eybrook William   753777 753777 Gybrook or Eybrook, William, of Wetheryngsete 0
4944238 2340171 2340171 plaintiff Hamond Robert (legal representative) 753777 753777 Hamond, Robert, of Wetheryngsete, esq, executors of 0
4969992 2347977 2347977 plaintiff Hamond Robert (legal representative) 753777 753777 Hamond, Robert, of Wetheryngsete, esq, executors of 0
4989618 2353818 2353818 defendant Thweyt Mathew   753777 753777 Thweyt, Mathew, of Wetheryngsete, husb 12
5025600 2364395 2364395 defendant Herte Henry fuller 753777 753777 Herte, Henry, of Wetheryngsete, fuller 0
5025601 2364395 2364395 defendant Herte Richard fuller 753777 753777 Herte, Richard, of Wetheryngsete, fuller 1
5025602 2364395 2364395 defendant Herte William fuller 753777 753777 Herte, William, of Wetheryngsete, fuller 2
5072040 2378128 2378128 defendant Eybroke William yeoman 753777 753777 Eybroke, William, of Wetheryngsete, yeoman 0
5072041 2378128 2378128 defendant Longeyere John husbandman 753777 753777 Longeyere, John, of Wetheryngsete, husbandman 1
5074959 2379017 2379017 defendant Bybroke William fuller 753777 753777 Bybroke, William, of Wetheryngsete, fuller 2
5085523 2382156 2382156 defendant Wodeward John husbandman 753777 753777 Wodeward, John, of Wetheryngsete, husbandman 0
5094259 2384726 2384726 defendant Here Richard fuller 753777 753777 Here, Richard, of Wetheryngsete, fuller 3
5096898 2385522 2385522 defendant Eybroke William yeoman 753777 753777 Eybroke, William, of Wetheryngsete, yeoman 0
5096899 2385522 2385522 defendant Langeyerd John mercer 753777 753777 Langeyerd, John, of Wetheryngsete, mercer 1
5103577 2387473 2387473 defendant Fosdyke John cooper 753777 753777 Fosdyke, John, of Wetheryngsete, cooper 2
5107279 2388555 2388555 defendant Brame or Braham John esq 753777 753777 Brame or Braham, John, of Wetheryngsete, or of Boxsted, Essex,esq 0
5145598 2399855 2399855 defendant Fosdyk John cooper 753777 753777 Fosdyk, John, of Wetheryngsete, cooper 1
5254134 2431414 2431414 defendant Percy Robert husbandman 753777 753777 Percy, Robert, of Wetheryngsete, husbandman 0
5341811 2457633 2457633 defendant Braham Geoffrey gent 753777 753777 Braham, Geoffrey, of Wetheryngsete, gent 2
5345907 2458852 2458852 defendant Saham Robert husbandman 753777 753777 Saham, Robert, of Wetheryngsete, or of Crocford, husbandman 0
5627383 2552533 2552533 defendant Belawe John husbandman 753777 753777 together with Belawe, John, of Wetheryngsete, husbandman 4
5636509 2555369 2555369 defendant Sturmyn Henry yeoman 753777 753777 Sturmyn, Henry, of Wetheryngsete, yeoman 0
5636510 2555369 2555369 defendant Sturmyn Richard butcher 753777 753777 Sturmyn, Richard, of Wetheryngsete, butcher 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);