names

67 rows where place_id = 592186

✎ 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
3606874 1869815 1869815 defendant Halyman Richard chapman 592186 592186 Halyman, Richard, of North Allerton, chapman 0
3615123 1872375 1872375 defendant Hopton John gent 592186 592186 Hopton, John, of North Allerton, gent 0
3615124 1872375 1872375 defendant Halyman Richard yeoman 592186 592186 Halyman, Richard, of North Allerton, yeoman 1
3615126 1872376 1872376 defendant Hopton John gent 592186 592186 Hopton, John, of North Allerton, gent 0
3615127 1872376 1872376 defendant Halyman Richard yeoman 592186 592186 Halyman, Richard, of North Allerton, yeoman 1
3642816 1908202 1908202 defendant Chaloner John weaver 592186 592186 Chaloner, John, of North Allerton, weaver 0
3642817 1908202 1908202 defendant Grenebere William barker 592186 592186 Grenebere, William, of North Allerton, barker 1
3642818 1908202 1908202 defendant Clerkeson Reginald barker 592186 592186 Clerkeson, Reginald, of North Allerton, barker 2
3642819 1908202 1908202 defendant Clerkeson Robert barker 592186 592186 Clerkeson, Robert, of North Allerton, barker 3
3653134 1911312 1911312 defendant Conyers John master of St James Hospital 592186 592186 Conyers, John, of North Allerton, clerk, master of St James Hospital 0
3699144 1925944 1925944 defendant Colston Richard clerk 592186 592186 Colston, Richard, of North Allerton, clerk 0
3699145 1925944 1925944 defendant Humfrey Ralph husbandman 592186 592186 Humfrey, Ralph, of North Allerton, husbandman 1
3699508 1926077 1926077 defendant Humfrey Ralph butcher 592186 592186 Humfrey, Ralph, of North Allerton, butcher 0
3699509 1926077 1926077 defendant Colston Richard clerk 592186 592186 Colston, Richard, of North Allerton, clerk 1
3725858 1934361 1934361 defendant Skarlett Edmund yeoman 592186 592186 Skarlett, Edmund, of North Allerton, yeoman 0
3726318 1934501 1934501 defendant Faceby John clerk 592186 592186 Faceby, John, of North Allerton, clerk 2
3741755 1939282 1939282 defendant Faceby John clerk 592186 592186 Faceby, John, of North Allerton, clerk 2
3813274 1962062 1962062 defendant Pryste Richard glover 592186 592186 Pryste, Richard, of North Allerton, glover 3
3814946 1962591 1962591 defendant Malthowse John widow 592186 592186 Malthowse, John, of North Allerton, widow 0
3822622 1964979 1964979 defendant Conyers Richard gent 592186 592186 Conyers, Richard, of North Allerton, gent 0
3822623 1964979 1964979 defendant Jakson Thomas mercer 592186 592186 Jakson, Thomas, of North Allerton, mercer 1
3822624 1964979 1964979 defendant Langrygge Henry shoemaker 592186 592186 Langrygge, Henry, of North Allerton, shoemaker 2
3850227 1973662 1973662 defendant Permeley George tailor 592186 592186 Permeley, George, of North Allerton, tailor 0
3875617 1982086 1982086 defendant Permeley George miller 592186 592186 Permeley, George, of North Allerton, miller 3
4087737 2055908 2055908 defendant Smeaton Robert yeoman 592186 592186 Smeaton, Robert, of North Allerton, yeoman 0
4087738 2055908 2055908 defendant Walker Elizabeth widow 592186 592186 Walker, Elizabeth, of North Allerton, widow 1
4250641 2113198 2113198 defendant Sigiswith John, junior chapman 592186 592186 Sigiswith, John, junior, of North Allerton, chapman 2
4392615 2162152 2162152 defendant Golde Richard chapman 592186 592186 Golde, Richard, of North Allerton, chapman 1
4410197 2168012 2168012 defendant Staynes William yeoman 592186 592186 Staynes, William, of North Allerton, yeoman 0
4423145 2172096 2172096 defendant Dighton Robert   592186 592186 Dighton, Robert, of North Allerton, vicar 0
4453146 2185991 2185991 plaintiff Langbayn Michael   592186 592186 Langbayn, Michael, of North Allerton 0
4498979 2200320 2200320 defendant Swaynby John de   592186 592186 Swaynby, John de, of North Allerton 0
4559438 2218899 2218899 defendant del Hall Nicholas   592186 592186 del Hall, Nicholas, of North Allerton 0
4568573 2221748 2221748 defendant Menell Richard   592186 592186 Menell, Richard, of North Allerton 0
4578468 2224754 2224754 defendant Bower Thomas   592186 592186 Bower, Thomas, of North Allerton 2
4587861 2227604 2227604 defendant Wodecok John walker 592186 592186 Wodecok, John, of North Allerton, walker 1
4717595 2270839 2270839 defendant Rumpton William smith 592186 592186 Rumpton, William, of North Allerton, smith 0
4725056 2273132 2273132 defendant Smyth Thomas smith 592186 592186 Smyth, Thomas, of North Allerton, smith 0
4807836 2298637 2298637 defendant More Richard draper 592186 592186 More, Richard, of North Allerton, draper 0
4807837 2298637 2298637 defendant Neuby John baker 592186 592186 Neuby, John, of North Allerton, baker 1
4815424 2300927 2300927 defendant Lunkcan John husbandman 592186 592186 Lunkcan, John, of North Allerton, husbandman 2
4937534 2338113 2338113 defendant Norreys William yeoman 592186 592186 Norreys, William, of North Allerton, yeoman 0
4948347 2341464 2341464 defendant Leget John yeoman 592186 592186 Leget, John, of North Allerton, yeoman 0
4985440 2352568 2352568 defendant Milner William yeoman 592186 592186 Milner, William, of North Allerton, yeoman 1
4998788 2356525 2356525 defendant Herst John chapman 592186 592186 Herst, John, of North Allerton, chapman 1
4999638 2356767 2356767 defendant Skelton Joan widow 592186 592186 Skelton, Joan, of North Allerton, widow 2
5049248 2371407 2371407 plaintiff Skelton Joan widow 592186 592186 Skelton, Joan, of North Allerton, widow 1
5049251 2371408 2371408 plaintiff Skelton Joan widow 592186 592186 Skelton, Joan, of North Allerton, widow 1
5052225 2372269 2372269 defendant Arondale John tanner 592186 592186 Arondale, John, of North Allerton, tanner 1
5094971 2384939 2384939 defendant Scotte John yeoman or draper 592186 592186 Scotte, John, of North Allerton, or of Sutton Ograve, yeoman or draper 1
5119619 2392171 2392171 plaintiff Skelton Joan widow 592186 592186 Skelton, Joan, of North Allerton, widow 1
5153945 2402312 2402312 defendant Palecer John chaplain 592186 592186 Palecer, John, of North Allerton, chaplain 0
5315177 2449593 2449593 defendant Leke Robert shoemaker 592186 592186 Leke, Robert, of North Allerton, shoemaker 0
5315178 2449593 2449593 defendant Masham John shoemaker 592186 592186 Masham, John, of North Allerton, shoemaker 1
5322479 2451795 2451795 defendant Hoperton John gent 592186 592186 Hoperton, John, of North Allerton, gent 0
5322480 2451795 2451795 defendant Warnum William gent 592186 592186 Warnum, William, of North Allerton, gent 1
5335519 2455696 2455696 defendant Hoton William spicer 592186 592186 Hoton, William, of North Allerton, spicer 0
5339244 2456845 2456845 defendant Farndale Anise or Avise widow 592186 592186 Farndale, Anise or Avise, of North Allerton, widow 0
5339247 2456846 2456846 defendant Ferndale Avise widow 592186 592186 Ferndale, Avise, of North Allerton, widow 0
5339253 2456848 2456848 defendant Fell John yeoman 592186 592186 Fell, John, of North Allerton, yeoman 1
5344340 2458411 2458411 defendant Hoperton John yeoman 592186 592186 Hoperton, John, of North Allerton, yeoman 0
5382997 2470205 2470205 defendant Crosley Thomas yeoman 592186 592186 Crosley, Thomas, of North Allerton, yeoman 2
5394222 2473410 2473410 defendant Crosley Thomas yeoman 592186 592186 Crosley, Thomas, of North Allerton, yeoman 2
5394224 2473410 2473410 defendant Blyth John baker 592186 592186 Blyth, John, of North Allerton, baker 4
5469312 2495749 2495749 defendant Founder Robert yeoman 592186 592186 Founder, Robert, of North Allerton, yeoman 0
5481877 2499511 2499511 defendant Mody Thomas smith 592186 592186 Mody, Thomas, of North Allerton, smith 2
5575686 2527484 2527484 defendant Copeland Christopher yeoman 592186 592186 Copeland, Christopher, of North Allerton, yeoman 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);