names

122 rows where place_id = 589200

✎ 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
3596884 1866658 1866658 defendant Plane Robert laborer 589200 589200 Plane, Robert, of Knaresburgh, laborer 8
3617923 1873229 1873229 defendant Beke Richard cordwainer 589200 589200 Beke, Richard, of Knaresburgh, cordwainer 1
3646448 1909286 1909286 defendant Baildon John gent 589200 589200 Baildon, John, of Knaresburgh, gent 0
3718065 1931945 1931945 plaintiff Fenchcliff Robert (legal representative) 589200 589200 Fenchcliff, Robert, of Knaresburgh, mercer, executors of 0
3718584 1932090 1932090 plaintiff Fynchcliff Robert (legal representative) 589200 589200 Fynchcliff, Robert, of Knaresburgh, mercer, executors of 0
3784994 1953087 1953087 defendant Hill John yeoman 589200 589200 Hill, John, of Knaresburgh, yeoman 1
3786880 1953695 1953695 defendant Metcalff Leonard merchant 589200 589200 Metcalff, Leonard, of Knaresburgh, merchant 0
3801460 1958375 1958375 defendant Hawnorth Lawrence yeoman 589200 589200 Hawnorth, Lawrence, of Knaresburgh, yeoman 2
3851011 1973908 1973908 defendant Robynson John clerk 589200 589200 Robynson, John, of Knaresburgh, clerk 0
3977954 2016862 2016862 defendant Pereson Robert yeoman 589200 589200 Pereson, Robert, of Knaresburgh, yeoman 0
4422348 2171858 2171858 defendant Donington William de minister at the house of St Robert 589200 589200 Donington, William de, of Knaresburgh, minister at the house of St Robert 0
4427822 2173540 2173540 defendant Donnygton William de minister at the house of St Robert 589200 589200 Donnygton, William de, of Knaresburgh, minister at the house of St Robert 0
4450600 2185147 2185147 defendant Kirkeby John de   589200 589200 Kirkeby, John de, of Knaresburgh 0
4450601 2185147 2185147 defendant Barker Roger   589200 589200 Barker, Roger, of Knaresburgh 1
4450603 2185148 2185148 defendant Kirkeby John   589200 589200 Kirkeby, John, of Knaresburgh 0
4450604 2185148 2185148 defendant Barker Roger   589200 589200 Barker, Roger, of Knaresburgh 1
4458539 2187721 2187721 defendant del Parke Adam   589200 589200 del Parke, Adam, of Knaresburgh 0
4471396 2191717 2191717 defendant Barker Richard   589200 589200 Barker, Richard, of Knaresburgh 2
4489137 2197318 2197318 defendant Barowe John   589200 589200 Barowe, John, of Knaresburgh 1
4504706 2202015 2202015 plaintiff Sauvage Richard minister of the House of St Robert 589200 589200 Sauvage, Richard, of Knaresburgh, minister of the House of St Robert 0
4504708 2202016 2202016 plaintiff Sauvage Richard minister of the House of St Robert 589200 589200 Sauvage, Richard, of Knaresburgh, minister of the House of St Robert 0
4507874 2202926 2202926 plaintiff Wrenchill Robert de (legal representative) 589200 589200 Wrenchill, Robert de, of Knaresburgh, executors of 0
4515711 2205338 2205338 defendant Frikley William   589200 589200 Frikley, William, of Knaresburgh 0
4534494 2211060 2211060 plaintiff Savage Richard minister of the house of St Robert 589200 589200 Savage, Richard, of Knaresburgh, minister of the house of St Robert 0
4534518 2211069 2211069 plaintiff Sawage Richard minister of the house of St Robert 589200 589200 Sawage, Richard, of Knaresburgh, minister of the house of St Robert 0
4537492 2211996 2211996 plaintiff Symmesson John   589200 589200 Symmesson, John, of Knaresburgh 0
4542796 2213635 2213635 defendant Brygg Thomas de carpenter 589200 589200 Brygg, Thomas de, of Knaresburgh, carpenter 0
4547226 2215065 2215065 plaintiff Burton John de   589200 589200 Burton, John de, of Knaresburgh, vicar 0
4547227 2215065 2215065 defendant Erkonden William de smith 589200 589200 Erkonden, William de, of Knaresburgh, smith 0
4557597 2218311 2218311 plaintiff Langstales John   589200 589200 Langstales, John, of Knaresburgh 0
4559945 2219064 2219064 defendant Taillour Richard   589200 589200 Taillour, Richard, of Knaresburgh 1
4559953 2219065 2219065 defendant Taillour Richard   589200 589200 Taillour, Richard, of Knaresburgh 3
4565199 2220689 2220689 plaintiff Skynner Roger   589200 589200 Skynner, Roger, of Knaresburgh 0
4583925 2226389 2226389 defendant Chaumberlayn Richard   589200 589200 Chaumberlayn, Richard, of Knaresburgh 0
4623630 2238369 2238369 defendant Barow Robert   589200 589200 Barow, Robert, of Knaresburgh 5
4675585 2257974 2257974 defendant Merewyk Joan widow 589200 589200 Merewyk, Joan, of Knaresburgh, widow 0
4675591 2257975 2257975 defendant Merewyk Joan widow 589200 589200 Merewyk, Joan, of Knaresburgh, widow 0
4675592 2257975 2257975 defendant Skynner Roger skinner 589200 589200 Skynner, Roger, of Knaresburgh, skinner 1
4680170 2259406 2259406 defendant Plumpton Robert de   589200 589200 Plumpton, Robert de, of Knaresburgh, knight 2
4711770 2269006 2269006 plaintiff Savage Richard minister in the house of St Robert 589200 589200 Savage, Richard, of Knaresburgh, minister in the house of St Robert 0
4711772 2269007 2269007 plaintiff Savage Richard minister in the house of St Robert 589200 589200 Savage, Richard, of Knaresburgh, minister in the house of St Robert 0
4711926 2269051 2269051 defendant Burton John de   589200 589200 Burton, John de, of Knaresburgh, vicar 0
4711949 2269053 2269053 defendant Esseton Adam de yeoman 589200 589200 Esseton, Adam de, of Knaresburgh, yeoman 2
4718924 2271260 2271260 defendant Colynson Roger chapman 589200 589200 Colynson, Roger, of Knaresburgh, chapman 0
4727837 2273948 2273948 defendant Wrynchell Robert chapman 589200 589200 Wrynchell, Robert, of Knaresburgh, chapman 0
4732406 2275311 2275311 defendant Burton John   589200 589200 Burton, John, of Knaresburgh 1
4737955 2276977 2276977 defendant Lovell John   589200 589200 Lovell, John, of Knaresburgh, mason 0
4754584 2281815 2281815 defendant Wade John yeoman 589200 589200 Wade, John, of Knaresburgh, yeoman 1
4789192 2292675 2292675 defendant Lely Richard husbandman 589200 589200 Lely, Richard, of Knaresburgh, husbandman 1
4809939 2299270 2299270 defendant Wade William shoemaker 589200 589200 Wade, William, of Knaresburgh, shoemaker 0
4815887 2301069 2301069 defendant Urry John smith 589200 589200 Urry, John, of Knaresburgh, smith 0
4822958 2303264 2303264 defendant Raven John weaver 589200 589200 Raven, John, of Knaresburgh, weaver 1
4826687 2304380 2304380 defendant Urry John chapman 589200 589200 Urry, John, of Knaresburgh, chapman 1
4858670 2314087 2314087 plaintiff Brynand Richard   589200 589200 Brynand, Richard, of Knaresburgh, esq, son of Brynand, John 0
4871701 2318118 2318118 defendant Waryng John yeoman 589200 589200 Waryng, John, of Knaresburgh, yeoman 0
4871702 2318118 2318118 defendant Lylly Richard husbandman 589200 589200 Lylly, Richard, of Knaresburgh, husbandman 1
4871703 2318118 2318118 defendant Pekeryng John husbandman 589200 589200 Pekeryng, John, of Knaresburgh, husbandman 2
4873746 2318727 2318727 defendant Northowes Thomas yeoman 589200 589200 Northowes, Thomas, of Knaresburgh, yeoman 12
4873747 2318727 2318727 defendant Wade Thomas yeoman 589200 589200 Wade, Thomas, of Knaresburgh, yeoman 13
4875745 2319376 2319376 defendant Stubbes John husbandman 589200 589200 Stubbes, John, of Knaresburgh, husbandman 0
4875746 2319376 2319376 defendant Sales John husbandman 589200 589200 Sales, John, of Knaresburgh, husbandman 1
4875747 2319376 2319376 defendant Tomson Robert husbandman 589200 589200 Tomson, Robert, of Knaresburgh, husbandman 2
4878891 2320331 2320331 defendant Waryng John yeoman 589200 589200 Waryng, John, of Knaresburgh, yeoman 0
4883150 2321656 2321656 defendant Smyth Adam miller 589200 589200 Smyth, Adam, of Knaresburgh, miller 0
4901484 2327068 2327068 defendant Wyntryngham Thomas husbandman 589200 589200 Wyntryngham, Thomas, of Knaresburgh, husbandman 0
4942828 2339727 2339727 defendant Taillour Richard tailor 589200 589200 Taillour, Richard, of Knaresburgh, tailor 2
4951106 2342309 2342309 defendant Wade William shoemaker 589200 589200 Wade, William, of Knaresburgh, shoemaker 1
4951108 2342310 2342310 defendant Wade William shoemaker 589200 589200 Wade, William, of Knaresburgh, shoemaker 0
4971847 2348511 2348511 defendant Dern- John laboreer 589200 589200 Dern-, John, of Knaresburgh, laboreer 1
4971858 2348515 2348515 defendant Knolles John yeoman 589200 589200 Knolles, John, of Knaresburgh, yeoman 0
4977127 2350113 2350113 defendant Wady William yeoman 589200 589200 together with Wady, William, of Knaresburgh, yeoman 1
4977129 2350114 2350114 defendant Wady William yeoman 589200 589200 Wady, William, of Knaresburgh, yeoman 0
4992050 2354512 2354512 plaintiff Craven John minister of St James 589200 589200 Craven, John, of Knaresburgh, minister of St James 0
5005512 2358512 2358512 defendant Isakson Robert butcher 589200 589200 Isakson, Robert, of Knaresburgh, butcher 0
5012513 2360504 2360504 defendant Smyth Thomas husbandman 589200 589200 Smyth, Thomas, of Knaresburgh, husbandman 3
5019593 2362618 2362618 defendant Allerton Richard laborer 589200 589200 Allerton, Richard, of Knaresburgh, laborer 0
5035136 2367140 2367140 defendant Ryche Thomas glover 589200 589200 Ryche, Thomas, of Knaresburgh, glover 0
5179165 2409642 2409642 plaintiff Bekwyth Ralph gent 589200 589200 Bekwyth, Ralph, of Knaresburgh, gent 0
5179166 2409642 2409642 defendant Bolton Robert minister of the house of St Robert 589200 589200 Bolton, Robert, of Knaresburgh, minister of the house of St Robert 0
5179167 2409643 2409643 plaintiff Bekwyth Ralph gent 589200 589200 Bekwyth, Ralph, of Knaresburgh, gent 0
5179168 2409643 2409643 defendant Bolton Robert minister of the house of St Robert 589200 589200 Bolton, Robert, of Knaresburgh, minister of the house of St Robert 0
5225103 2423010 2423010 defendant Armetstede Thomas forester 589200 589200 Armetstede, Thomas, of Knaresburgh, forester 0
5230854 2424631 2424631 defendant Knaresburgh Thomas   589200 589200 Knaresburgh, Thomas, of Knaresburgh, franklin 2
5234480 2425675 2425675 defendant Childe John mercer 589200 589200 Childe, John, of Knaresburgh, mercer 2
5234481 2425675 2425675 defendant Wady Thomas yeoman 589200 589200 Wady, Thomas, of Knaresburgh, yeoman 3
5246742 2429209 2429209 plaintiff Bolton Robert   589200 589200 Bolton, Robert, of Knaresburgh 1
5247060 2429301 2429301 defendant Lynton Roger clerk 589200 589200 Lynton, Roger, of Knaresburgh, clerk 0
5247061 2429301 2429301 defendant Hoggeson John yeoman 589200 589200 Hoggeson, John, of Knaresburgh, yeoman 1
5268598 2435936 2435936 plaintiff Bolton Robert minister of the house of St Robert 589200 589200 Bolton, Robert, of Knaresburgh, minister of the house of St Robert 0
5287732 2441434 2441434 plaintiff Konghill or Koughill John   589200 589200 Konghill or Koughill, John, of Knaresburgh 0
5297818 2444369 2444369 defendant Picard George yeoman 589200 589200 Picard, George, of Knaresburgh, yeoman 1
5297819 2444369 2444369 defendant Hewetson Robert yeoman 589200 589200 Hewetson, Robert, of Knaresburgh, yeoman 2
5297820 2444369 2444369 defendant Lasynge William yeoman 589200 589200 Lasynge, William, of Knaresburgh, yeoman 3
5297823 2444370 2444370 defendant Pycard George yeoman 589200 589200 Pycard, George, of Knaresburgh, yeoman 1
5297824 2444370 2444370 defendant Hewetson Robert yeoman 589200 589200 Hewetson, Robert, of Knaresburgh, yeoman 2
5297825 2444370 2444370 defendant Lasynge William yeoman 589200 589200 Lasynge, William, of Knaresburgh, yeoman 3
5308156 2447466 2447466 defendant Isakson Robert butcher 589200 589200 Isakson, Robert, of Knaresburgh, butcher 0
5308158 2447467 2447467 defendant Issakson Robert butcher 589200 589200 Issakson, Robert, of Knaresburgh, butcher 0
5341110 2457411 2457411 defendant Wade Thomas yeoman 589200 589200 Wade, Thomas, of Knaresburgh, yeoman 0
5343862 2458267 2458267 defendant Cundall Robert walker 589200 589200 Cundall, Robert, of Knaresburgh, walker 0

Next page

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