names

149 rows where place_id = 587189

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590711 1864737 1864737 defendant Trotte William chapman 587189 587189 Trotte, William, of Arundell, Sussex, chapman 1
3595987 1866374 1866374 defendant Bylmore Richard clerk 587189 587189 Bylmore, Richard, of Arundell, Sussex, or of Kynges Stanley, Glos, clerk 3
3601613 1868160 1868160 defendant Russewe John innholder 587189 587189 Russewe, John, of Arundell, Sussex, innholder 2
3615795 1872582 1872582 defendant Alwyn Thomas gent 587189 587189 Alwyn, Thomas, of Arundell, Sussex, gent 0
3653545 1911375 1911375 defendant Russell John innholder 587189 587189 Russell, John, of Arundell, Sussex, innholder 3
3693479 1924172 1924172 defendant Lynsey Thomas shoemaker 587189 587189 Lynsey, Thomas, of Arundell, Sussex, shoemaker 4
3694403 1924453 1924453 defendant Bosseby John clerk 587189 587189 Bosseby, John, of Arundell, Sussex, clerk 4
3729451 1935458 1935458 defendant Dyneley Francis gent 587189 587189 Dyneley, Francis, of Arundell, Sussex, gent 0
3744512 1940184 1940184 defendant Deneley Francis gent 587189 587189 Deneley, Francis, of Arundell, Sussex, gent 0
3859709 1976748 1976748 defendant Busby William clerk 587189 587189 Busby, William, of Arundell, Sussex, clerk 0
3865837 1978804 1978804 defendant Symcocke John yeoman 587189 587189 Symcocke, John, of Arundell, Sussex, yeoman 1
3878313 1982994 1982994 defendant Laurence Robert chapman 587189 587189 Laurence, Robert, of Arundell, Sussex, chapman 1
3880997 1983914 1983914 defendant Busby William clerk 587189 587189 Busby, William, of Arundell, Sussex, clerk 2
3887535 1986082 1986082 defendant Sheperd Adam mercer 587189 587189 Sheperd, Adam, of Arundell, Sussex, mercer 2
3887538 1986083 1986083 defendant Sheperd Adam mercer 587189 587189 Sheperd, Adam, of Arundell, Sussex, mercer 1
3888853 1986521 1986521 defendant Sheperd Adam mercer 587189 587189 Sheperd, Adam, of Arundell, Sussex, mercer 1
3888856 1986522 1986522 defendant Sheperd Adam mercer 587189 587189 Sheperd, Adam, of Arundell, Sussex, mercer 1
3902228 1990981 1990981 defendant Herberd Thomas gent 587189 587189 Herberd, Thomas, of Arundell, Sussex, gent 3
3906928 1992606 1992606 defendant Carter Thomas merchant 587189 587189 Carter, Thomas, of Arundell, Sussex, merchant 0
3921453 1997519 1997519 defendant Carter Thomas merchant 587189 587189 Carter, Thomas, of Arundell, Sussex, merchant 0
3928714 1999940 1999940 defendant Moynys John beer brewer 587189 587189 Moynys, John, of Arundell, Sussex, beer brewer 0
3966395 2012878 2012878 defendant Taylor Thomas butcher 587189 587189 Taylor, Thomas, of Arundell, Sussex, butcher 0
3988976 2020797 2020797 defendant Bedo Nicholas yeoman 587189 587189 Bedo, Nicholas, of Arundell, Sussex, yeoman 0
4016518 2030614 2030614 defendant Bristoo or Briscoo Anthony carpenter 587189 587189 Bristoo or Briscoo, Anthony, of Arundell, Sussex, carpenter 0
4058970 2045603 2045603 defendant Hilles John tinker 587189 587189 Hilles, John, of Arundell, Sussex, tinker 2
4107822 2063074 2063074 defendant Williamson Thomas clerk 587189 587189 Williamson, Thomas, of Arundell, Sussex, clerk 0
4129008 2070678 2070678 defendant Gaston or Garton Francis gent 587189 587189 Gaston or Garton, Francis, of Arundell, Sussex, gent 0
4139451 2074470 2074470 defendant Parker Edward yeoman 587189 587189 Parker, Edward, of Arundell, Sussex, yeoman 1
4157314 2080624 2080624 defendant Holland Richard chapman 587189 587189 Holland, Richard, of Arundell, Sussex, chapman 0
4164183 2083001 2083001 defendant Parker Edward yeoman 587189 587189 Parker, Edward, of Arundell, Sussex, yeoman 0
4166165 2083670 2083670 defendant Bedo Nicholas merchant 587189 587189 Bedo, Nicholas, of Arundell, Sussex, merchant 0
4225184 2104278 2104278 defendant Hennynge Robert chapman 587189 587189 (Hennynge, Robert, of Arundell, Sussex, chapman 2
4241984 2110310 2110310 defendant Hennynge Robert chapman 587189 587189 (Hennynge, Robert, of Arundell, Sussex, chapman 2
4268465 2119055 2119055 defendant Thomson Oliver merchant 587189 587189 Thomson, Oliver, of Arundell, Sussex, merchant 2
4278979 2122580 2122580 defendant Waglande Richard beer brewer 587189 587189 Waglande, Richard, of Arundell, Sussex, beer brewer 1
4346452 2146012 2146012 defendant Whatman Thomas   587189 587189 Whatman, Thomas, of Arundell, Sussex 0
4350642 2147475 2147475 defendant Lusher William gent 587189 587189 Lusher, William, of Arundell, Sussex, gent 2
4367174 2153316 2153316 defendant Powell Walter mariner 587189 587189 Powell, Walter, of Arundell, Sussex, mariner 0
4373490 2155587 2155587 defendant Lusher William gent 587189 587189 Lusher, William, of Arundell, Sussex, gent 3
4562004 2219683 2219683 defendant Douse Thomas   587189 587189 Douse, Thomas, of Arundell, Sussex 3
4669047 2256026 2256026 defendant Chapman William mercer 587189 587189 Chapman, William, of Arundell, Sussex, mercer 0
4679156 2259090 2259090 defendant Trot William husbandman 587189 587189 Trot, William, of Arundell, Sussex, husbandman 0
4694223 2263694 2263694 defendant Chapman William mercer 587189 587189 Chapman, William, of Arundell, Sussex, mercer 0
4700744 2265633 2265633 defendant Kyde Thomas dyer 587189 587189 Kyde, Thomas, of Arundell, Sussex, dyer 0
4701437 2265854 2265854 defendant Warmycam William   587189 587189 Warmycam, William, of Arundell, Sussex 0
4701443 2265855 2265855 defendant Warnycam William draper 587189 587189 Warnycam, William, of Arundell, Sussex, draper 0
4702306 2266130 2266130 defendant Terry William   587189 587189 Terry, William, of Arundell, Sussex, iron worker 0
4702310 2266131 2266131 defendant Terry William   587189 587189 Terry, William, of Arundell, Sussex, iron worker 0
4712707 2269287 2269287 defendant Trot William husbandman 587189 587189 Trot, William, of Arundell, Sussex, husbandman 0
4728294 2274093 2274093 defendant Wiltshire John   587189 587189 Wiltshire, John, of Arundell, Sussex, knight 0
4728296 2274094 2274094 defendant Wiltshyre John   587189 587189 Wiltshyre, John, of Arundell, Sussex, knight 0
4741831 2278104 2278104 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 2
4762123 2284134 2284134 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 4
4785037 2291335 2291335 defendant Hendeman Richard gent 587189 587189 Hendeman, Richard, of Arundell, Sussex, gent 1
4785040 2291336 2291336 defendant Hendeman Richard gent 587189 587189 Hendeman, Richard, of Arundell, Sussex, gent 1
4785591 2291518 2291518 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 3
4785596 2291519 2291519 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 3
4793728 2294156 2294156 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 2
4819815 2302271 2302271 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 0
4819817 2302272 2302272 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, gent 0
4826481 2304317 2304317 defendant Burnell John gent 587189 587189 Burnell, John, of Arundell, Sussex, & of Lychet Mautravers, Dors, gent 0
4843325 2309429 2309429 defendant Herward Thomas husbandman 587189 587189 Herward, Thomas, of Arundell, Sussex, husbandman 0
4845972 2310246 2310246 defendant Smyth Richard smith 587189 587189 Smyth, Richard, of Arundell, Sussex, smith 0
4849779 2311401 2311401 defendant Foncell John dyer [obscured] 587189 587189 Foncell, John, of Arundell, Sussex, dyer [obscured] 1
4855634 2313130 2313130 defendant Smyth Richard smith 587189 587189 Smyth, Richard, of Arundell, Sussex, smith 1
4925377 2334371 2334371 defendant Trotte Robert chapman 587189 587189 Trotte, Robert, of Arundell, Sussex, chapman 2
4950645 2342166 2342166 defendant Gylmyn John hosteler 587189 587189 Gylmyn, John, of Arundell, Sussex, hosteler 2
4972016 2348570 2348570 defendant Warde Nicholas clerk 587189 587189 Warde, Nicholas, of Arundell, Sussex, clerk 0
4972022 2348571 2348571 defendant Warde Nicholas clerk 587189 587189 Warde, Nicholas, of Arundell, Sussex, clerk 0
4973463 2349006 2349006 defendant Colmord John clerk 587189 587189 Colmord, John, of Arundell, Sussex, clerk 1
4973466 2349007 2349007 defendant Colmord John clerk 587189 587189 Colmord, John, of Arundell, Sussex, clerk 1
4999068 2356599 2356599 defendant Wake Thomas yeoman 587189 587189 Wake, Thomas, of Arundell, Sussex, yeoman 1
4999073 2356600 2356600 defendant Wake Thomas yeoman 587189 587189 Wake, Thomas, of Arundell, Sussex, yeoman 1
5000366 2356974 2356974 defendant Couper John yeoman 587189 587189 Couper, John, of Arundell, Sussex, yeoman 0
5002927 2357761 2357761 defendant Eury or Enry John of the yeoman 587189 587189 Eury or Enry, John of the, of Arundell, Sussex, yeoman 3
5003597 2357942 2357942 defendant Warmocamp William merchant 587189 587189 Warmocamp, William, of Arundell, Sussex, merchant 3
5003628 2357951 2357951 defendant Warmcamp William merchant 587189 587189 Warmcamp, William, of Arundell, Sussex, merchant 3
5004297 2358149 2358149 defendant Taunt Henry butcher 587189 587189 Taunt, Henry, of Arundell, Sussex, butcher 2
5007184 2358991 2358991 defendant Clerkson Thomas esq 587189 587189 Clerkson, Thomas, of Arundell, Sussex, esq 2
5032676 2366441 2366441 defendant Erlee Wiliam gent 587189 587189 Erlee, Wiliam, of Arundell, Sussex, gent 0
5051129 2371950 2371950 defendant fitz Alan or Darundell William   587189 587189 fitz Alan or Darundell, William, of Arundell, Sussex, Earl & Lord of Matrevers, knight 0
5073836 2378663 2378663 defendant Ponynges Edward clerk 587189 587189 Ponynges, Edward, of Arundell, Sussex, clerk 0
5089447 2383286 2383286 defendant FitzAlan William   587189 587189 FitzAlan, William, of Arundell, Sussex, Earl of Arundell 1
5105321 2387999 2387999 defendant Barette Thomas esq 587189 587189 Barette, Thomas, of Arundell, Sussex, esq 2
5107642 2388666 2388666 defendant Everle William esq 587189 587189 Everle, William, of Arundell, Sussex, esq 0
5124576 2393653 2393653 defendant Tanner John   587189 587189 Tanner, John, of Arundell, sussex 0
5135571 2396913 2396913 defendant Ervele William esq 587189 587189 Ervele, William, of Arundell, Sussex, esq 0
5153041 2402034 2402034 defendant Ponynges Edward clerk 587189 587189 Ponynges, Edward, of Arundell, Sussex, clerk 2
5155393 2402728 2402728 defendant Tanner John tanner 587189 587189 Tanner, John, of Arundell, Sussex, tanner 0
5155482 2402762 2402762 defendant Tanner John tanner 587189 587189 Tanner, John, of Arundell, Sussex, tanner 0
5155832 2402866 2402866 defendant Ernele William esq 587189 587189 Ernele, William, of Arundell, Sussex, esq 0
5158491 2403605 2403605 defendant Godenburgh Peter   587189 587189 Godenburgh, Peter, of Arundell, Sussex, white tawyer 0
5172104 2407559 2407559 defendant Tanner John tanner 587189 587189 Tanner, John, of Arundell, Sussex, tanner 0
5172292 2407620 2407620 defendant Ernele William esq 587189 587189 Ernele, William, of Arundell, Sussex, esq 0
5174047 2408109 2408109 defendant Golemburgh Peter   587189 587189 Golemburgh, Peter, of Arundell, Sussex, white tawyer 0
5186487 2411797 2411797 defendant Ponynges Edward clerk 587189 587189 Ponynges, Edward, of Arundell, Sussex, clerk 0
5191592 2413281 2413281 defendant Ernele William esq 587189 587189 Ernele, William, of Arundell, Sussex, esq 0
5194377 2414086 2414086 defendant Godenburgh Peter whitawer 587189 587189 Godenburgh, Peter, of Arundell, Sussex, whitawer 0
5194383 2414087 2414087 defendant Godenburgh Peter   587189 587189 Godenburgh, Peter, of Arundell, Sussex, white tawyer 0
5197938 2415138 2415138 defendant Bowes Richard yeoman 587189 587189 Bowes, Richard, of Arundell, Sussex, yeoman 1

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