names

65 rows where place_id = 586854

✎ 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
3589814 1864455 1864455 defendant Lowethorp William yeoman 586854 586854 Lowethorp, William, of Bridlyngton, yeoman 0
3665206 1915072 1915072 defendant Grave John   586854 586854 Grave, John, of Bridlyngton, wheel wright 0
3696473 1925124 1925124 plaintiff Semerby Richard (legal representative) 586854 586854 Semerby, Richard, of Bridlyngton, executors of 0
3696475 1925124 1925124 defendant Somerby Henry   586854 586854 Somerby, Henry, of Bridlyngton, yeoman, son of Somerby, John 0
3696476 1925125 1925125 plaintiff Semerby Richard (legal representative) 586854 586854 Semerby, Richard, of Bridlyngton, executors of 0
3696478 1925125 1925125 defendant Somerby Henry   586854 586854 Somerby, Henry, of Bridlyngton, yeoman, son of Somerby, John 0
3702676 1927106 1927106 defendant Middelton Thomas yeoman 586854 586854 Middelton, Thomas, of Bridlyngton, yeoman 1
4137402 2073727 2073727 defendant Ellyottes John husbandman 586854 586854 Ellyottes, John, of Bridlyngton, husbandman 0
4159514 2081396 2081396 defendant Skelton Peter gent 586854 586854 Skelton, Peter, of Bridlyngton, gent 0
4162994 2082593 2082593 defendant Preston Thomas butcher 586854 586854 Preston, Thomas, of Bridlyngton, butcher 0
4178540 2087971 2087971 defendant Preston Thomas butcher 586854 586854 Preston, Thomas, of Bridlyngton, butcher 0
4487323 2196750 2196750 plaintiff Skynner John   586854 586854 Skynner, John, of Bridlyngton 0
4508618 2203174 2203174 defendant atte Nesse William   586854 586854 atte Nesse, William, of Bridlyngton 0
4510805 2203837 2203837 plaintiff Baumburgh William   586854 586854 Baumburgh, William, of Bridlyngton 0
4515116 2205141 2205141 plaintiff Chapman Robert   586854 586854 Chapman, Robert, of Bridlyngton 0
4561386 2219508 2219508 defendant Crook John   586854 586854 Crook, John, of Bridlyngton 0
4579595 2225104 2225104 plaintiff Coupere Stephen   586854 586854 Coupere, Stephen, of Bridlyngton 0
4587150 2227384 2227384 defendant Fouler Thomas   586854 586854 Fouler, Thomas, of Bridlyngton 0
4591212 2228608 2228608 defendant Litster Richard   586854 586854 Litster, Richard, of Bridlyngton 0
4624247 2238570 2238570 plaintiff Nesse Simon de   586854 586854 Nesse, Simon de, of Bridlyngton 0
4635365 2241896 2241896 defendant Radbarowe Richard   586854 586854 Radbarowe, Richard, of Bridlyngton 0
4661971 2249584 2249584 plaintiff Kyng William   586854 586854 Kyng, William, of Bridlyngton 1
4671509 2256734 2256734 defendant Tiler Roger tiler 586854 586854 Tiler, Roger, of Bridlyngton, tiler 1
4705335 2267042 2267042 defendant Suthiby John husbandman 586854 586854 Suthiby John, of Bridlyngton, husbandman 0
4763725 2284644 2284644 defendant Conell Margaret widow 586854 586854 Conell, Margaret, of Bridlyngton, widow 3
4765218 2285104 2285104 defendant Hadelsay Thomas weaver 586854 586854 Hadelsay, Thomas, of Bridlyngton, weaver 0
4770152 2286634 2286634 defendant Allerdale William panyer man 586854 586854 Allerdale, William, of Bridlyngton, panyer man 0
4786018 2291667 2291667 defendant Herpour John mercer 586854 586854 together with Herpour, John, of Bridlyngton, mercer 2
4787446 2292144 2292144 defendant Conell or Covell Margaret widow 586854 586854 Conell or Covell, Margaret, of Bridlyngton, widow 3
4803949 2297416 2297416 defendant Kelyng William   586854 586854 Kelyng, William, of Bridlyngton, ship wright 1
4816887 2301385 2301385 plaintiff Mason William (legal representative) 586854 586854 Mason, William, of Bridlyngton, executors of: (Mason, Margaret, formerly wife of Testator 0
4830296 2305513 2305513 defendant Welborn William miller 586854 586854 Welborn, William, of Bridlyngton, miller 0
4856796 2313500 2313500 defendant Somerby William butcher 586854 586854 Somerby, William, of Bridlyngton, butcher 0
4895481 2325254 2325254 defendant Milner Geoffrey miller 586854 586854 Milner, Geoffrey, of Bridlyngton, miller 0
4898534 2326189 2326189 defendant Dawetre Henry yeoman 586854 586854 Dawetre, Henry, of Bridlyngton, yeoman 4
4901419 2327053 2327053 defendant Welburn James laborer 586854 586854 Welburn, James, of Bridlyngton, laborer 1
4923672 2333840 2333840 defendant Hayby William chapman 586854 586854 Hayby, William, of Bridlyngton, chapman 0
4939236 2338658 2338658 defendant Swale John gent 586854 586854 Swale, John, of Bridlyngton, gent 2
4953565 2343039 2343039 defendant Randson Robert thatcher 586854 586854 Randson, Robert, of Bridlyngton, thatcher 1
5004076 2358078 2358078 defendant Blaktoft Richard thatcher 586854 586854 Blaktoft, Richard, of Bridlyngton, thatcher 0
5006031 2358652 2358652 defendant Larom Thomas husbandman 586854 586854 Larom, Thomas, of Bridlyngton, husbandman 1
5007407 2359060 2359060 defendant Blaktoft Richard yeoman 586854 586854 Blaktoft, Richard, of Bridlyngton, yeoman 0
5007408 2359060 2359060 defendant Pereson John yeoman 586854 586854 Pereson, John, of Bridlyngton, yeoman 1
5068428 2377056 2377056 defendant Almot Richard weaver 586854 586854 Almot, Richard, of Bridlyngton,weaver 1
5073081 2378435 2378435 defendant Bonde William butcher 586854 586854 Bonde, William, of Bridlyngton, butcher 0
5073759 2378640 2378640 plaintiff Wardell John   586854 586854 Wardell, John, of Bridlyngton, franklin 0
5111896 2389867 2389867 defendant Swan Simon chapman 586854 586854 Swan, Simon, of Bridlyngton, chapman 0
5114799 2390740 2390740 defendant Swan Simon chapman 586854 586854 Swan, Simon, of Bridlyngton, chapman 0
5119433 2392110 2392110 defendant Rosdale Thomas cordwainer 586854 586854 Rosdale, Thomas, of Bridlyngton, cordwainer 2
5135451 2396880 2396880 defendant Jakson Richard yeoman 586854 586854 Jakson, Richard, of Bridlyngton, yeoman 4
5155676 2402818 2402818 defendant Jakson Richard yeoman 586854 586854 Jakson, Richard, of Bridlyngton, yeoman 4
5159687 2403935 2403935 defendant Carnaby Richard gent 586854 586854 Carnaby, Richard, of Bridlyngton, gent 0
5198400 2415284 2415284 defendant Dogilby Thomas miller 586854 586854 Dogilby, Thomas, of Bridlyngton, miller 3
5234482 2425675 2425675 defendant Clerk Robert butcher 586854 586854 Clerk, Robert, of Bridlyngton, butcher 4
5307077 2447116 2447116 defendant Beelby Thomas fishmonger 586854 586854 Beelby, Thomas, of Bridlyngton, fishmonger 0
5321513 2451526 2451526 defendant Atkynson Richard laborer 586854 586854 Atkynson, Richard, of Bridlyngton, laborer 1
5344532 2458461 2458461 defendant Symson William tailor 586854 586854 Symson, William, of Bridlyngton, tailor 3
5350771 2460351 2460351 defendant Leland alias Spicer Richard mercer or spicer 586854 586854 Leland alias Spicer, Richard, of Bridlyngton, mercer or spicer 1
5392858 2473031 2473031 defendant Moreton Gilbert dyer 586854 586854 Moreton, Gilbert, of Bridlyngton, dyer 0
5513191 2508974 2508974 defendant Smyth William mercer 586854 586854 Smyth, William, of Bridlyngton, mercer, servant of Manfeld, Peter, of Bridlyngton, mercer 0
5595465 2533531 2533531 plaintiff Brighame William merchant 586854 586854 Brighame, William, of Bridlyngton, merchant 0
5598920 2534540 2534540 defendant Somerby William yeoman 586854 586854 Somerby, William, of Bridlyngton, yeoman 0
5605440 2536580 2536580 defendant Somerby Thomas yeoman 586854 586854 Somerby, Thomas, of Bridlyngton, yeoman 0
5605441 2536580 2536580 defendant Somerby William yeoman 586854 586854 Somerby, William, of Bridlyngton, yeoman 1
5605442 2536580 2536580 defendant Somerby Henry yeoman 586854 586854 Somerby, Henry, of Bridlyngton, yeoman 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);