names

95 rows where place_id = 595754

✎ 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
3621747 1874341 1874341 defendant Wody Robert chaplain 595754 595754 Wody, Robert, of Brede, chaplain 0
3621758 1874345 1874345 defendant Wayner Robert husbandman 595754 595754 Wayner, Robert, of Brede, husbandman 0
3650485 1910519 1910519 defendant Motte William yeoman 595754 595754 Motte, William, of Brede, yeoman 1
3739047 1938419 1938419 defendant Erle Godard yeoman 595754 595754 Erle, Godard, of Brede, yeoman 0
3739048 1938419 1938419 defendant Ive William yeoman 595754 595754 Ive, William, of Brede, yeoman 1
3739050 1938420 1938420 defendant A Gate John yeoman 595754 595754 A Gate, John, of Brede, yeoman 0
3754256 1943284 1943284 defendant Payn John clerk 595754 595754 Payn, John, of Brede, clerk 0
3754257 1943284 1943284 defendant Motte Robert laborer 595754 595754 Motte, Robert, of Brede, laborer 1
3754258 1943284 1943284 defendant Couper Robert laborer 595754 595754 Couper, Robert, of Brede, laborer 2
3754259 1943284 1943284 defendant Goram John laborer 595754 595754 Goram, John, of Brede, laborer 3
3754260 1943284 1943284 defendant Braynford Oliver laborer 595754 595754 Braynford, Oliver, of Brede, laborer 4
3754261 1943284 1943284 defendant Pyper Thomas husbandman 595754 595754 Pyper, Thomas, of Brede, husbandman 5
3754262 1943284 1943284 defendant A Combe Thomas laborer 595754 595754 A Combe, Thomas, of Brede, laborer 6
3764891 1946683 1946683 defendant Erle Godard husbandman 595754 595754 Erle, Godard, of Brede, husbandman 1
3776107 1950271 1950271 defendant Oxenbryge Goddard   595754 595754 Oxenbryge, Goddard, of Brede, knight 0
3803987 1959163 1959163 defendant Payne John clerk 595754 595754 Payne, John, of Brede, clerk 0
3830262 1967359 1967359 defendant Ive William husbandman 595754 595754 Ive, William, of Brede, husbandman 1
4319809 2137038 2137038 defendant Grave alias Syckle John husbandman 595754 595754 Grave alias Syckle, John, of Brede, husbandman 0
4340756 2144040 2144040 defendant Hunte Robert yeoman 595754 595754 Hunte, Robert, of Brede, yeoman 0
4340758 2144041 2144041 defendant Hunt Robert yeoman 595754 595754 Hunt, Robert, of Brede, yeoman 0
4479418 2194216 2194216 plaintiff Hylde John   595754 595754 Hylde, John, of Brede 0
4483845 2195646 2195646 plaintiff Oxenbregge Robert   595754 595754 Oxenbregge, Robert, of Brede, on his own account 0
4493377 2198633 2198633 defendant Aylard Richard   595754 595754 Aylard, Richard, of Brede 0
4571450 2222654 2222654 defendant Harry Robert   595754 595754 Harry, Robert, of Brede 3
4618475 2236787 2236787 plaintiff Harry Robert   595754 595754 Harry, Robert, of Brede 0
4669955 2256300 2256300 defendant Barton Robert   595754 595754 Barton, Robert, of Brede, parson 0
4677191 2258483 2258483 defendant Sandre John laborer 595754 595754 Sandre, John, of Brede, laborer 1
4677540 2258589 2258589 plaintiff Harry Robert baker 595754 595754 Harry, Robert, of Brede, baker 0
4682988 2260295 2260295 plaintiff Oxenbregge Robert   595754 595754 Oxenbregge, Robert, of Brede, on his own account 0
4693429 2263446 2263446 plaintiff Barton Robert   595754 595754 Barton, Robert, of Brede, parson 0
4702724 2266251 2266251 defendant Watte Robert husbandman 595754 595754 Watte, Robert, of Brede, husbandman 0
4730533 2274748 2274748 defendant Oxenbrigge Robert gent 595754 595754 Oxenbrigge, Robert, of Brede, gent 0
4732251 2275266 2275266 plaintiff Oxenbregge Robert   595754 595754 Oxenbregge, Robert, of Brede 0
4732256 2275267 2275267 defendant Broun Robert butcher 595754 595754 Broun, Robert, of Brede, butcher 0
4732261 2275269 2275269 defendant Harry Richard weaver 595754 595754 Harry, Richard, of Brede, weaver 0
4732263 2275270 2275270 plaintiff Oxenbrigge Robert   595754 595754 Oxenbrigge, Robert, of Brede 0
4732267 2275271 2275271 plaintiff Oxenbrigge Robert   595754 595754 Oxenbrigge, Robert, of Brede 0
4732268 2275271 2275271 defendant Broun Robert butcher 595754 595754 Broun, Robert, of Brede, butcher 0
4732269 2275272 2275272 plaintiff Oxenbrigge Robert   595754 595754 Oxenbrigge, Robert, of Brede 0
4737931 2276969 2276969 defendant Sandre Peter husbandman 595754 595754 Sandre, Peter, of Brede, husbandman 2
4741868 2278119 2278119 plaintiff Broun Robert   595754 595754 Broun, Robert, of Brede, on his own account 0
4751634 2280968 2280968 defendant Marle Robert laborer 595754 595754 Marle, Robert, of Brede, laborer 0
4776644 2288687 2288687 plaintiff Harry Robert   595754 595754 Harry, Robert, of Brede 2
4779217 2289475 2289475 defendant Dyer Robert husbandman 595754 595754 Dyer, Robert, of Brede, husbandman 0
4779821 2289685 2289685 defendant Cobbe William laborer 595754 595754 Cobbe, William, of Brede, laborer 0
4779822 2289685 2289685 defendant Clerk Henry laborer 595754 595754 Clerk, Henry, of Brede, laborer 1
4793604 2294111 2294111 defendant Thrapston Edmund clerk 595754 595754 Thrapston, Edmund, of Brede, clerk 0
4793605 2294111 2294111 defendant Reve John husbandman 595754 595754 Reve, John, of Brede, husbandman 1
4818704 2301936 2301936 defendant Belherst Stephen thatcher 595754 595754 Belherst, Stephen, of Brede, thatcher 0
4818705 2301936 2301936 defendant Gerveys Robert laborer 595754 595754 Gerveys, Robert, of Brede, laborer 1
4818709 2301938 2301938 plaintiff Oxenbrigge Robert   595754 595754 Oxenbrigge, Robert, of Brede, on his own account 0
4863996 2315716 2315716 plaintiff Exenbregge Martin   595754 595754 Exenbregge, Martin, of Brede 0
4872842 2318458 2318458 plaintiff Oxenbregge Robert (legal representative) 595754 595754 Oxenbregge, Robert, of Brede, executor of 0
4872885 2318472 2318472 defendant Broun John butcher 595754 595754 Broun, John, of Brede, butcher 1
4882409 2321411 2321411 defendant atte Wyke Richard, junior laborer 595754 595754 atte Wyke, Richard, junior, of Brede, laborer 0
4889448 2323494 2323494 defendant Sterre John husbandman 595754 595754 Sterre, John, of Brede, husbandman 0
4891724 2324154 2324154 defendant Sterre John husbandman 595754 595754 Sterre, John, of Brede, husbandman 0
4900340 2326743 2326743 defendant Sterre John husbandman 595754 595754 Sterre, John, of Brede, husbandman 0
4950302 2342059 2342059 defendant Osenersh John husbandman 595754 595754 Osenersh, John, of Brede, husbandman 0
4950304 2342060 2342060 defendant Osenerssh John husbandman 595754 595754 Osenerssh, John, of Brede, husbandman 0
4952677 2342757 2342757 defendant Cheseman Richard husbandman 595754 595754 Cheseman, Richard, of Brede, husbandman 0
4982773 2351760 2351760 defendant Hylde John carpenter 595754 595754 Hylde, John, of Brede, carpenter 0
5013290 2360722 2360722 defendant Hamme John laborer 595754 595754 Hamme, John, of Brede, laborer 1
5029617 2365531 2365531 defendant Hony or Hovy John laborer 595754 595754 Hony or Hovy, John, of Brede, laborer 1
5053608 2372680 2372680 defendant Stable Thomas, junior laborer 595754 595754 Stable, Thomas, junior, of Brede, laborer 2
5074246 2378786 2378786 defendant Maynard Thomas panier maker 595754 595754 Maynard, Thomas, of Brede, panier maker 0
5090566 2383622 2383622 defendant Hony or Hovy John husbandman 595754 595754 Hony or Hovy, John, of Brede, husbandman 0
5090567 2383622 2383622 defendant Wever Robert husbandman 595754 595754 Wever, Robert, of Brede, husbandman 1
5092253 2384116 2384116 plaintiff Oxenbrigg Robert esq 595754 595754 Oxenbrigg, Robert, of Brede, esq 0
5092255 2384117 2384117 plaintiff Oxenbrigge Martin   595754 595754 Oxenbrigge, Martin, of Brede 0
5092257 2384118 2384118 plaintiff Oxenbrigge Martin esq 595754 595754 Oxenbrigge, Martin, of Brede, esq 0
5111519 2389767 2389767 defendant Helman John husbandman 595754 595754 Helman, John, of Brede, husbandman 0
5137634 2397521 2397521 defendant B-- William gent 595754 595754 B--, William, of Brede, gent 1
5153259 2402103 2402103 defendant Hyldyche William clerk 595754 595754 Hyldyche, William, of Brede, clerk 0
5179000 2409583 2409583 defendant Lewys William laborer 595754 595754 Lewys, William, of Brede, laborer 0
5188691 2412418 2412418 defendant Hyldych William clerk 595754 595754 Hyldych, William, of Brede, clerk 0
5206186 2417543 2417543 defendant Hyldych William clerk 595754 595754 Hyldych, William, of Brede, clerk 0
5243764 2428367 2428367 defendant Usk Philip clerk 595754 595754 Usk, Philip, of Brede, clerk 0
5248682 2429736 2429736 defendant Oxenbrigge Martin gent 595754 595754 Oxenbrigge, Martin, of Brede, gent 0
5261928 2433839 2433839 defendant Oxenbrygge Richard esq 595754 595754 Oxenbrygge, Richard, of Brede, esq 0
5318039 2450482 2450482 defendant Brde William (legal representative) 595754 595754 Brde, William, of Brede, gent, executrix of 0
5319170 2450830 2450830 plaintiff Harry Robert   595754 595754 Harry, Robert, of Brede 0
5323480 2452101 2452101 plaintiff Oxenbregge Robert esq 595754 595754 Oxenbregge, Robert, of Brede, esq 0
5494403 2503229 2503229 defendant Bovard John husbandman 595754 595754 together with Bovard, John, of Brede, husbandman 1
5494411 2503233 2503233 defendant Bovard John husbandman 595754 595754 Bovard, John, of Brede, husbandman 0
5529096 2513616 2513616 defendant Wode Robert chaplain 595754 595754 Wode, Robert, of Brede, chaplain 0
5529099 2513617 2513617 defendant Wode Robert chaplain 595754 595754 Wode, Robert, of Brede, chaplain 0
5533322 2514972 2514972 defendant Baker William yeoman 595754 595754 Baker, William, of Brede, yeoman 1
5573085 2526683 2526683 defendant Baker William yeoman 595754 595754 Baker, William, of Brede, yeoman 0
5609725 2546739 2546739 plaintiff (illegible) William   595754 595754 ---, William, of Brede 0
5609726 2546739 2546739 defendant Yonge Geoffrey   595754 595754 Yonge, Geoffrey, of Brede 0
5611365 2547286 2547286 defendant Bakere Thomas   595754 595754 Bakere, Thomas, of Brede 1
5622111 2550828 2550828 plaintiff Tournour Richard   595754 595754 Tournour, Richard, of Brede 0
5627604 2552605 2552605 plaintiff Oxenbregge Robert   595754 595754 Oxenbregge, Robert, of Brede 0
5627609 2552606 2552606 plaintiff Oxenbregge Robert   595754 595754 Oxenbregge, Robert, of Brede 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);