names

88 rows where place_id = 589689

✎ 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
3598421 1867134 1867134 defendant Lakke William dyer 589689 589689 Lakke, William, of Hornyng, dyer 0
3807434 1960229 1960229 defendant Belk Richard   589689 589689 Belk, Richard, of Hornyng, worsted weaver 2
3807439 1960230 1960230 defendant Kelk Richard   589689 589689 Kelk, Richard, of Hornyng, worsted weaver 2
3807576 1960276 1960276 defendant Warde Peter husbandman 589689 589689 Warde, Peter, of Hornyng, husbandman 3
3823019 1965107 1965107 defendant Heward Robert laborer 589689 589689 Heward, Robert, of Hornyng, laborer 1
3840081 1970469 1970469 defendant Amys William grocer 589689 589689 Amys, William, of Hornyng, grocer 0
3851257 1973989 1973989 defendant Amys William grocer 589689 589689 Amys, William, of Hornyng, grocer 0
3864082 1978170 1978170 defendant Styward Thomas husbandman 589689 589689 Styward, Thomas, of Hornyng, husbandman 1
3884636 1985133 1985133 plaintiff Amys William beer brewer 589689 589689 Amys, William, of Hornyng, beer brewer 0
3904446 1991733 1991733 plaintiff Herne William, senior smith 589689 589689 Herne, William, senior, of Hornyng, smith 0
3904447 1991733 1991733 defendant Heylesdon Elizabeth widow 589689 589689 Heylesdon, Elizabeth, of Hornyng, widow 0
3912548 1994527 1994527 defendant Rome John   589689 589689 Rome, John, of Hornyng, keel man 2
3918560 1996534 1996534 defendant Deynes George gent 589689 589689 Deynes, George, of Hornyng, gent 0
3918566 1996535 1996535 defendant Deynes George gent 589689 589689 Deynes, George, of Hornyng, gent 4
3925577 1998867 1998867 defendant Herne William smith 589689 589689 Herne, William, of Hornyng, smith 1
3925579 1998867 1998867 defendant Rowland Christopher   589689 589689 Rowland, Christopher, of Hornyng, brick maker 3
3948971 2006708 2006708 defendant Baylley William husbandman 589689 589689 Baylley, William, of Hornyng, husbandman 1
3967493 2013267 2013267 defendant Norwiche John husbandman 589689 589689 Norwiche, John, of Hornyng, husbandman 0
3970766 2014367 2014367 defendant Canne Thomas husbandman 589689 589689 Canne, Thomas, of Hornyng, husbandman 0
3976042 2016188 2016188 defendant Porter Robert husbandman 589689 589689 Porter, Robert, of Hornyng, husbandman 0
3980721 2017867 2017867 defendant Norriche John husbandman 589689 589689 Norriche, John, of Hornyng, husbandman 0
3980723 2017868 2017868 defendant Norwiche John husbandman 589689 589689 Norwiche, John, of Hornyng, husbandman 0
3984288 2019144 2019144 defendant Hare Roland gent 589689 589689 Hare, Roland, of Hornyng, gent 3
4163013 2082601 2082601 defendant Goodwyn James baker 589689 589689 Goodwyn, James, of Hornyng, baker 1
4163015 2082602 2082602 defendant Blenerhassett Edward gent 589689 589689 Blenerhassett, Edward, of Hornyng, gent 0
4196808 2094431 2094431 defendant Agges Stephen laborer 589689 589689 Agges, Stephen, of Hornyng, or of Erleham, laborer 2
4216919 2101411 2101411 defendant Thompson Henry innholder 589689 589689 Thompson, Henry, of Hornyng, innholder 1
4216920 2101411 2101411 defendant Gryme William blacksmith 589689 589689 Gryme, William, of Hornyng, blacksmith 2
4251261 2113397 2113397 defendant Ouldman Thomas, junior yeoman 589689 589689 Ouldman, Thomas, junior, of Hornyng, yeoman 0
4263089 2117322 2117322 defendant Blenerhassett Edward gent 589689 589689 Blenerhassett, Edward, of Hornyng, gent 0
4263090 2117322 2117322 defendant Lam or Lain John yeoman 589689 589689 Lam or Lain, John, of Hornyng, yeoman 1
4263091 2117322 2117322 defendant Bolt John yeoman 589689 589689 Bolt, John, of Hornyng, yeoman 2
4263092 2117322 2117322 defendant Stewarde Richard yeoman 589689 589689 Stewarde, Richard, of Hornyng, yeoman 3
4286087 2125078 2125078 defendant Knowles Henry husbandman 589689 589689 Knowles, Henry, of Hornyng, husbandman 3
4393655 2162481 2162481 defendant Folker Thomas husbandman 589689 589689 Folker, Thomas, of Hornyng, husbandman 0
4393656 2162481 2162481 defendant Scurrey William husbandman 589689 589689 Scurrey, William, of Hornyng, husbandman 1
4393657 2162481 2162481 defendant Knolles Henry miller 589689 589689 Knolles, Henry, of Hornyng, miller 2
4512133 2204240 2204240 defendant Broun Richard   589689 589689 Broun, Richard, of Hornyng 2
4624361 2238598 2238598 defendant Boteler Robert   589689 589689 Boteler, Robert, of Hornyng 0
4624363 2238599 2238599 defendant Howys John   589689 589689 Howys, John, of Hornyng 0
4624364 2238599 2238599 defendant Fen John de   589689 589689 Fen, John de, of Hornyng 1
4624365 2238599 2238599 defendant Boteler Roger   589689 589689 together with Boteler, Roger, of Hornyng 2
4634610 2241676 2241676 defendant Broun Richard   589689 589689 Broun, Richard, of Hornyng 0
4706541 2267424 2267424 defendant Daubeney Peter weaver 589689 589689 Daubeney, Peter, of Hornyng, weaver 3
4719444 2271426 2271426 defendant Plomer Robert yeoman 589689 589689 Plomer, Robert, of Hornyng, yeoman 1
4746803 2279566 2279566 defendant Mome Edmund clerk 589689 589689 Mome, Edmund, of Hornyng, clerk 2
4795991 2294894 2294894 defendant Pompe William draper 589689 589689 Pompe, William, of Hornyng, draper 0
4809505 2299145 2299145 defendant Draper John draper 589689 589689 Draper, John, of Hornyng, draper 2
4811206 2299615 2299615 defendant Draper John yeoman 589689 589689 Draper, John, of Hornyng, yeoman 1
4831218 2305794 2305794 defendant Scarlet Henry reeder 589689 589689 Scarlet, Henry, of Hornyng, reeder 0
4850310 2311554 2311554 defendant Ferygate Thomas yeoman 589689 589689 Ferygate, Thomas, of Hornyng, yeoman 0
4856252 2313327 2313327 plaintiff Barfot William   589689 589689 Barfot, William, of Hornyng 0
4878118 2320109 2320109 defendant Beverle Simon husbandman 589689 589689 Beverle, Simon, of Hornyng, husbandman 0
4878121 2320109 2320109 defendant Silham John husbandman 589689 589689 Silham, John, of Hornyng, husbandman 3
4901219 2326990 2326990 defendant Baker William yeoman 589689 589689 Baker, William, of Hornyng, yeoman 0
4907124 2328790 2328790 defendant Redere Henry yeoman 589689 589689 Redere, Henry, of Hornyng, yeoman 0
4926346 2334665 2334665 defendant Ferygate Thomas husbandman 589689 589689 Ferygate, Thomas, of Hornyng, husbandman 2
4966456 2346901 2346901 defendant Ferygate John laborer 589689 589689 Ferygate, John, of Hornyng, laborer 0
4967790 2347312 2347312 defendant Lardener John laborer 589689 589689 Lardener, John, of Hornyng, laborer 1
4967791 2347312 2347312 defendant Wygon Richard laborer 589689 589689 Wygon, Richard, of Hornyng, laborer 2
4967792 2347312 2347312 defendant Bolle Robert laborer 589689 589689 Bolle, Robert, of Hornyng, laborer 3
4967793 2347312 2347312 defendant Collys Thomas yeoman 589689 589689 Collys, Thomas, of Hornyng, yeoman 4
4998002 2356263 2356263 defendant Gegevald John   589689 589689 Gegevald, John, of Hornyng, boat wright 2
5057475 2373803 2373803 defendant Wever Thomas yeoman 589689 589689 Wever, Thomas, of Hornyng, yeoman 0
5057476 2373803 2373803 defendant Gedgebald Gilmun   589689 589689 Gedgebald, Gilmun, of Hornyng, servant 1
5071941 2378098 2378098 defendant Bounde William husbandman 589689 589689 Bounde, William, of Hornyng, husbandman 0
5085844 2382255 2382255 defendant Wulstan Henry reeder or reader 589689 589689 Wulstan, Henry, of Hornyng, reeder or reader 0
5128570 2394833 2394833 defendant atte Grene Geoffrey laborer 589689 589689 atte Grene, Geoffrey, of Hornyng, laborer 0
5128571 2394833 2394833 defendant Poule Thomas laborer 589689 589689 Poule, Thomas, of Hornyng, laborer 1
5147748 2400482 2400482 defendant atte Grene Geoffrey laborer 589689 589689 atte Grene, Geoffrey, of Hornyng, laborer 0
5147749 2400482 2400482 defendant Poule Thomas husbandman 589689 589689 Poule, Thomas, of Hornyng, husbandman 1
5147751 2400483 2400483 defendant atte Grene Geoffrey laborer 589689 589689 atte Grene, Geoffrey, of Hornyng, laborer 0
5147752 2400483 2400483 defendant Poule Thomas laborer 589689 589689 Poule, Thomas, of Hornyng, laborer 1
5260357 2433365 2433365 defendant Edward John husbandman 589689 589689 Edward, John, of Hornyng, husbandman 2
5382334 2470006 2470006 defendant Shotesham John yeoman 589689 589689 Shotesham, John, of Hornyng, yeoman 0
5384771 2470725 2470725 defendant Kelyngham William husbandman 589689 589689 Kelyngham, William, of Hornyng, husbandman 16
5404411 2476333 2476333 defendant Shotesham John yeoman 589689 589689 Shotesham, John, of Hornyng, yeoman 0
5417521 2480161 2480161 defendant Shotesham John yeoman 589689 589689 Shotesham, John, of Hornyng, yeoman 0
5417523 2480162 2480162 defendant Shotesham John yeoman 589689 589689 Shotesham, John, of Hornyng, yeoman 0
5417525 2480163 2480163 defendant Shotesham John   589689 589689 Shotesham, John, of Hornyng, yeoman, servant to the Abbot of St Benedict at Hulme 0
5429476 2483746 2483746 defendant Gogman Katherine widow 589689 589689 Gogman, Katherine, of Hornyng, widow 0
5434916 2485375 2485375 defendant Shottesham John   589689 589689 Shottesham, John, of Hornyng, yeoman, servant of the abbot of St Benedict of Holme 0
5459558 2492770 2492770 defendant Newebawde William husbandman 589689 589689 Newebawde, William, of Hornyng, husbandman 2
5531995 2514549 2514549 defendant Styward Alice (legal representative) 589689 589689 Styward, Alice, of Hornyng, widow, executor of 4
5531996 2514549 2514549 defendant Styward Robert yeoman 589689 589689 Styward, Robert, of Hornyng, yeoman 5
5576040 2527570 2527570 plaintiff Styward John   589689 589689 Styward, John, of Hornyng 0
5576042 2527571 2527571 plaintiff Styward John   589689 589689 Styward, John, of Hornyng 0
5628842 2552990 2552990 defendant Smyth Richard yeoman 589689 589689 Smyth, Richard, of Hornyng, yeoman 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);