names

65 rows where place_id = 590685

✎ 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
3601993 1868283 1868283 defendant Boby William husbandman 590685 590685 Boby, William, of Sevenok, husbandman 0
3670008 1916565 1916565 defendant Coltherst William gent 590685 590685 Coltherst, William, of Sevenok, gent 0
3676167 1918589 1918589 plaintiff Hunter Richard   590685 590685 Hunter, Richard, of Sevenok 0
3681482 1920298 1920298 defendant Charlwod John butcher 590685 590685 Charlwod, John, of Sevenok, butcher 0
3810181 1961075 1961075 defendant Haseden John husbandman 590685 590685 Haseden, John, of Sevenok, husbandman 0
3871146 1980601 1980601 defendant Bartlet Thomas   590685 590685 Bartlet, Thomas, of Sevenok, notary 0
3886189 1985631 1985631 defendant Stacy John husbandman 590685 590685 Stacy, John, of Sevenok, husbandman 0
3910569 1993849 1993849 defendant Domeryk John brasier 590685 590685 Domeryk, John, of Sevenok, brasier 0
4564735 2220534 2220534 defendant Whitegrom Peter   590685 590685 Whitegrom, Peter, of Sevenok, son & heir of Peter 0
4579039 2224923 2224923 defendant Scotland John   590685 590685 Scotland, John, of Sevenok 0
4668020 2255707 2255707 defendant Stokenbury John baker 590685 590685 Stokenbury, John, of Sevenok, baker 1
4669405 2256139 2256139 defendant Herry William husbandman 590685 590685 Herry, William, of Sevenok, husbandman 0
4777223 2288862 2288862 defendant Gyles Richard husbandman 590685 590685 Gyles, Richard, of Sevenok, husbandman 0
4807382 2298505 2298505 defendant Romeshed Nicholas husbandman 590685 590685 Romeshed, Nicholas, of Sevenok, husbandman 0
4887503 2322929 2322929 defendant Moraunt John fuller 590685 590685 Moraunt, John, of Sevenok, fuller 0
4917034 2331834 2331834 defendant Goddard Thomas laborer 590685 590685 Goddard, Thomas, of Sevenok, laborer 0
4917035 2331834 2331834 defendant Goddard Robert laborer 590685 590685 Goddard, Robert, of Sevenok, laborer 1
4917037 2331834 2331834 defendant Bourneman John laborer 590685 590685 Bourneman, John, of Sevenok, laborer 3
4929966 2335780 2335780 defendant Aleyn Richard yeoman 590685 590685 Aleyn, Richard, of Sevenok, yeoman 0
4955063 2343466 2343466 defendant Hayll William husbandman 590685 590685 Hayll, William, of Sevenok, husbandman 0
5030420 2365765 2365765 defendant Potkyn William husbandman 590685 590685 Potkyn, William, of Sevenok, husbandman 1
5031898 2366202 2366202 defendant Godard Robert laborer 590685 590685 Godard, Robert, of Sevenok, laborer 0
5031899 2366202 2366202 defendant Jenyn Thomas butcher 590685 590685 Jenyn, Thomas, of Sevenok, butcher 1
5031900 2366202 2366202 defendant atte Yerde Roger laborer 590685 590685 atte Yerde, Roger, of Sevenok, laborer 2
5031901 2366202 2366202 defendant Potkyn William carpenter 590685 590685 Potkyn, William, of Sevenok, carpenter 3
5046495 2370590 2370590 defendant Trewys Thomas cooper 590685 590685 Trewys, Thomas, of Sevenok, cooper 0
5071054 2377832 2377832 defendant Brode William saddler 590685 590685 Brode, William, of Sevenok, saddler 0
5074559 2378894 2378894 defendant Elsy Thomas   590685 590685 Elsy, Thomas, of Sevenok, mason 0
5084005 2381718 2381718 defendant Philipp William chapman 590685 590685 Philipp, William, of Sevenok, chapman 2
5085891 2382263 2382263 defendant Janyn John husbandman 590685 590685 Janyn, John, of Sevenok, husbandman 0
5095611 2385140 2385140 defendant Cristemas Alice widow 590685 590685 (Cristemas, Alice, of Sevenok, widow 1
5095612 2385140 2385140 defendant Cristemas Henry tiler 590685 590685 Cristemas, Henry, of Sevenok, tiler 2
5095624 2385144 2385144 defendant Lucas Richard tailor 590685 590685 Lucas, Richard, of Sevenok, tailor 0
5095628 2385145 2385145 defendant Lucas Richard tailor 590685 590685 Lucas, Richard, of Sevenok, tailor 0
5095632 2385145 2385145 defendant Cristemas Alice widow 590685 590685 (Cristemas, Alice, of Sevenok, widow 4
5095633 2385145 2385145 defendant Cristemas Henry tiller or tiler 590685 590685 Cristemas, Henry, of Sevenok, tiller or tiler 5
5106894 2388444 2388444 defendant Hawekyns Robert husbandman 590685 590685 Hawekyns, Robert, of Sevenok, husbandman 2
5112973 2390188 2390188 defendant Bele John gent 590685 590685 Bele, John, of Sevenok, gent 0
5118623 2391876 2391876 defendant Walkelyn Richard, junior husbandman 590685 590685 Walkelyn, Richard, junior, of Sevenok, husbandman 5
5127145 2394415 2394415 defendant Couper Thomas chapman 590685 590685 Couper, Thomas, of Sevenok, chapman 3
5128498 2394808 2394808 defendant Couper William husbandman 590685 590685 Couper, William, of Sevenok, husbandman 0
5133822 2396385 2396385 defendant Bele John gent 590685 590685 Bele, John, of Sevenok, gent 0
5218317 2421089 2421089 defendant Byrd John draper 590685 590685 Byrd, John, of Sevenok, draper 3
5265407 2434937 2434937 defendant Dagdewe alias Gate John miller 590685 590685 Dagdewe alias Gate, John, of Sevenok, miller 0
5265878 2435083 2435083 plaintiff Toft Robert (legal representative) 590685 590685 Toft, Robert, of Sevenok, clerk, provost of Wyngham College, executor of 0
5265880 2435083 2435083 defendant Mychell Thomas baker 590685 590685 Mychell, Thomas, of Sevenok, baker 0
5268108 2435792 2435792 defendant Westbrok Peter gent 590685 590685 Westbrok, Peter, of Sevenok, gent 0
5268110 2435793 2435793 defendant Westbrook Peter gent 590685 590685 Westbrook, Peter, of Sevenok, gent 0
5277720 2438570 2438570 defendant Westbroke Peter gent 590685 590685 Westbroke, Peter, of Sevenok, gent 0
5280984 2439519 2439519 defendant Bird Thomas carpenter 590685 590685 Bird, Thomas, of Sevenok, carpenter 0
5283558 2440244 2440244 defendant Bird Thomas carpenter 590685 590685 Bird, Thomas, of Sevenok, carpenter 0
5296242 2443890 2443890 plaintiff Westbroke Peter   590685 590685 Westbroke, Peter, of Sevenok 0
5312505 2448777 2448777 defendant Olever Robert carpenter 590685 590685 Olever, Robert, of Sevenok, carpenter 0
5323708 2452178 2452178 defendant Newe Thomas husbadman 590685 590685 Newe, Thomas, of Sevenok, husbadman 0
5330471 2454194 2454194 defendant Fleccher Richard miller 590685 590685 Fleccher, Richard, of Sevenok, miller 3
5330472 2454194 2454194 defendant Jenyn John butcher 590685 590685 Jenyn, John, of Sevenok, butcher 4
5339261 2456851 2456851 defendant Shepherd John collier 590685 590685 Shepherd, John, of Sevenok, collier 1
5340981 2457379 2457379 defendant Brode or Brede Thomas   590685 590685 Brode or Brede, Thomas, of Sevenok, collar maker 0
5341142 2457422 2457422 defendant Pocok Robert wheeler 590685 590685 Pocok, Robert, of Sevenok, wheeler 1
5360627 2463356 2463356 defendant Birde Thomas carpenter 590685 590685 Birde, Thomas, of Sevenok, carpenter 2
5527109 2513052 2513052 defendant Smythford John laborer 590685 590685 Smythford, John, of Sevenok, laborer 0
5545647 2518715 2518715 defendant Lacy John yeoman 590685 590685 Lacy, John, of Sevenok, yeoman 0
5589619 2531750 2531750 defendant Studley William barber 590685 590685 Studley, William, of Sevenok, barber 2
5605922 2536743 2536743 defendant Charlewod Richard husbandman 590685 590685 Charlewod, Richard, of Sevenok, husbandman 1
5605926 2536744 2536744 defendant Charlewod Richard husbandman 590685 590685 Charlewod, Richard, of Sevenok, husbandman 2

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