names

69 rows where place_id = 588767

✎ 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
3595505 1866229 1866229 defendant Galowey Thomas yeoman 588767 588767 Galowey, Thomas, of Burn, yeoman 0
3605768 1869470 1869470 defendant Gascoyngne William (legal representative) 588767 588767 Gascoyngne, William, of Burn, knight, executor of 3
3716444 1931436 1931436 defendant Prestgrave Guy waterman 588767 588767 Prestgrave, Guy, of Burn, waterman 0
3716445 1931436 1931436 defendant Quarryer John waterman 588767 588767 Quarryer, John, of Burn, waterman 1
3860836 1977117 1977117 plaintiff Dutton alias Bull Joan widow 588767 588767 Dutton alias Bull, Joan, of Burn, widow 0
3860837 1977117 1977117 plaintiff Bull Thomas   588767 588767 Bull, Thomas, of Burn 1
3895454 1988690 1988690 defendant Bull Thomas yeoman 588767 588767 Bull, Thomas, of Burn, yeoman 0
3905883 1992250 1992250 defendant Bunnyng Thomas yeoman 588767 588767 Bunnyng, Thomas, of Burn, yeoman 0
3914562 1995215 1995215 defendant Wheteley John husbandman 588767 588767 Wheteley, John, of Burn, husbandman 0
3915068 1995395 1995395 plaintiff Comyn Roland   588767 588767 Comyn, Roland, of Burn 0
3958707 2010119 2010119 defendant Draper Richard husbandman 588767 588767 Draper, Richard, of Burn, husbandman 1
4018208 2031235 2031235 defendant Aldred Robert, junior   588767 588767 Aldred, Robert, junior, of Burn 1
4018211 2031236 2031236 defendant Eldred Robert, junior   588767 588767 Eldred, Robert, junior, of Burn, 1
4025666 2033832 2033832 defendant Wylson Edward husbandman 588767 588767 Wylson, Edward, of Burn, husbandman 2
4064970 2047755 2047755 defendant Pepper Roger husbandman 588767 588767 Pepper, Roger, of Burn, husbandman 0
4101134 2060718 2060718 defendant More Gregory gent 588767 588767 More, Gregory, of Burn, gent 1
4173546 2086204 2086204 defendant Wylson Edward mercer 588767 588767 Wylson, Edward, of Burn, mercer 0
4562394 2219798 2219798 defendant Sempryngham Thomas   588767 588767 Sempryngham, Thomas, of Burn 0
4663437 2250039 2250039 defendant Senyer alias Ropere John husbandman 588767 588767 Senyer alias Ropere, John, of Burn, husbandman 1
4711399 2268896 2268896 defendant Cosyn Robert husbandman 588767 588767 Cosyn, Robert, of Burn, husbandman 0
4951889 2342538 2342538 defendant Caston John husbandman 588767 588767 Caston, John, of Burn, husbandman 0
4964384 2346263 2346263 defendant Whitehove Thomas husbandman 588767 588767 Whitehove, Thomas, of Burn, husbandman 2
4987577 2353242 2353242 defendant Baston John husbandman 588767 588767 Baston, John, of Burn, husbandman 2
5051938 2372192 2372192 defendant Chapman John tiler 588767 588767 Chapman, John, of Burn, tiler 3
5103147 2387345 2387345 defendant Clerk John husbandman 588767 588767 Clerk, John, of Burn, husbandman 0
5110393 2389442 2389442 defendant Stok Robert husbandman 588767 588767 Stok, Robert, of Burn, husbandman 1
5124049 2393488 2393488 defendant Lamberd John husbandman 588767 588767 Lamberd, John, of Burn, husbandman 2
5137281 2397415 2397415 defendant Tyler John ironmonger 588767 588767 Tyler, John, of Burn, ironmonger 0
5141370 2398598 2398598 defendant Dandy John   588767 588767 Dandy, John, of Burn 0
5191130 2413144 2413144 defendant Fuller William husbandman 588767 588767 Fuller, William, of Burn, husbandman 0
5191131 2413144 2413144 defendant Hart William husbandman 588767 588767 Hart, William, of Burn, husbandman 1
5191132 2413144 2413144 defendant Hekyngton John husbandman 588767 588767 Hekyngton, John, of Burn, husbandman 2
5191133 2413144 2413144 defendant Nutbroun William potter 588767 588767 Nutbroun, William, of Burn, potter 3
5198760 2415391 2415391 defendant Dandy John yeoman 588767 588767 Dandy, John, of Burn, yeoman 0
5198930 2415440 2415440 defendant Nutbroun William potter 588767 588767 Nutbroun, William, of Burn, potter 2
5207228 2417854 2417854 defendant Fuller William husbandman 588767 588767 Fuller, William, of Burn, husbandman 0
5207229 2417854 2417854 defendant Hart William husbandman 588767 588767 Hart, William, of Burn, husbandman 1
5207230 2417854 2417854 defendant Hekyngton John husbandman 588767 588767 Hekyngton, John, of Burn, husbandman 2
5207231 2417854 2417854 defendant Nutbroun William potter 588767 588767 Nutbroun, William, of Burn, potter 3
5240630 2427472 2427472 defendant Colyn William husbandman 588767 588767 Colyn, William, of Burn, husbandman 0
5258481 2432768 2432768 defendant Gotobed Bartholomew husbandman 588767 588767 Gotobed, Bartholomew, of Burn, husbandman 2
5277753 2438580 2438580 defendant Mares Robert chaplain 588767 588767 Mares, Robert, of Burn, or of Arnyngton, chaplain 1
5291675 2442572 2442572 defendant Eclyngton Robert husbandman 588767 588767 Eclyngton, Robert, of Burn, husbandman 2
5316837 2450122 2450122 defendant White Robert carpenter 588767 588767 White, Robert, of Burn, carpenter 1
5319798 2451015 2451015 defendant Toteriche William yeoman 588767 588767 Toteriche, William, of Burn, yeoman 0
5319799 2451015 2451015 defendant Echard John husbandman 588767 588767 Echard, John, of Burn, husbandman 1
5319800 2451015 2451015 defendant Boston John husbandman 588767 588767 Boston, John, of Burn, husbandman 2
5319801 2451015 2451015 defendant Grey Henry sherman 588767 588767 Grey, Henry, of Burn, sherman 3
5325468 2452700 2452700 defendant Gotobed Bartholomew husbandman 588767 588767 Gotobed, Bartholomew, of Burn, husbandman 0
5325469 2452700 2452700 defendant Gotobed William husbandman 588767 588767 Gotobed, William, of Burn, husbandman 1
5343352 2458110 2458110 defendant Baston William   588767 588767 Baston, William, of Burn, parish clerk 0
5347979 2459508 2459508 defendant Elys Robert maltman 588767 588767 Elys, Robert, of Burn, maltman 0
5361567 2463640 2463640 defendant Palmer Richard chapman 588767 588767 Palmer, Richard, of Burn, chapman 0
5367836 2465567 2465567 defendant Hokyngton Robert laborer 588767 588767 Hokyngton, Robert, of Burn, laborer 1
5379604 2469208 2469208 defendant Banne John husbandman 588767 588767 Banne, John, of Burn, husbandman 2
5394853 2473598 2473598 defendant Sote John tanner 588767 588767 Sote, John, of Burn, tanner 0
5394854 2473598 2473598 defendant Barker John tanner 588767 588767 Barker, John, of Burn, tanner 1
5441325 2487322 2487322 defendant Palmer Richard mercer 588767 588767 Palmer, Richard, of Burn, mercer 1
5476001 2497834 2497834 defendant Hobbys Thomas fishmonger 588767 588767 Hobbys, Thomas, of Burn, fishmonger 1
5487501 2501156 2501156 defendant Hobbys Thomas fishmonger 588767 588767 Hobbys, Thomas, of Burn, fishmonger 1
5488905 2501553 2501553 defendant Ganne John husbandman 588767 588767 Ganne, John, of burn, husbandman 0
5491334 2502297 2502297 defendant Bull Robert butcher 588767 588767 Bull, Robert, of Burn, butcher 1
5491335 2502297 2502297 defendant Alwode Thomas yeoman 588767 588767 Alwode, Thomas, of Burn, yeoman 2
5515016 2509538 2509538 defendant Loksmyth Thomas yeoman 588767 588767 Loksmyth, Thomas, of Burn, yeoman 2
5515017 2509538 2509538 defendant Ganne John butcher 588767 588767 Ganne, John, of Burn, butcher 3
5579787 2528758 2528758 defendant Sampson Henry barber 588767 588767 Sampson, Henry, of Burn, barber 1
5587748 2531186 2531186 defendant Sampson Henry barber 588767 588767 Sampson, Henry, of Burn, barber 1
5598127 2534310 2534310 defendant Wythey Robert yeoman 588767 588767 Wythey, Robert, of Burn, yeoman 3
5598133 2534311 2534311 defendant Whythey Robert yeoman 588767 588767 Whythey, Robert, of Burn, yeoman 3

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