names

45 rows where place_id = 617205

✎ 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
3718360 1932025 1932025 defendant Barrett William yeoman 617205 617205 Barrett, William, of Clive juxta Lewes, yeoman 0
4072424 2050441 2050441 defendant Doredge John yeoman 617205 617205 Doredge, John, of Clive juxta Lewes, yeoman 0
4072426 2050441 2050441 defendant Taperner John yeoman 617205 617205 Taperner, John, of Clive juxta Lewes, yeoman 2
4072736 2050549 2050549 defendant Holford Robert tailor 617205 617205 Holford, Robert, of Clive juxta Lewes, tailor 0
4170098 2085035 2085035 defendant Sekes Samuel yeoman 617205 617205 Sekes, Samuel, of Clive juxta Lewes, yeoman 1
4171492 2085493 2085493 defendant Holford Christopher clerk 617205 617205 Holford, Christopher, of Clive juxta Lewes, clerk 2
4171931 2085644 2085644 defendant Dorrydge John cutler 617205 617205 Dorrydge, John, of Clive juxta Lewes, cutler 1
4172004 2085671 2085671 defendant Foster Nicholas   617205 617205 Foster, Nicholas, of Clive juxta Lewes, "slatlayer" 2
4174975 2086714 2086714 defendant Dallington John butcher 617205 617205 Dallington, John, of Clive juxta Lewes, butcher 1
4174979 2086715 2086715 defendant Dallyngton John butcher 617205 617205 Dallyngton, John, of Clive juxta Lewes, butcher 1
4176591 2087289 2087289 defendant Foster Nicholas   617205 617205 Foster, Nicholas, of Clive juxta Lewes, "slatlayer" 0
4184919 2090233 2090233 defendant Stone Thomas butcher 617205 617205 Stone, Thomas, of Clive juxta Lewes, butcher 0
4220103 2102533 2102533 defendant Stone Thomas   617205 617205 Stone, Thomas, of Clive juxta Lewes butcher 2
4222935 2103510 2103510 defendant Stone Thomas butcher 617205 617205 Stone, Thomas, of Clive juxta Lewes, butcher 1
4225186 2104279 2104279 defendant Parson Thomas miller 617205 617205 Parson, Thomas, of Clive juxta Lewes, yeoman, miller 0
4225187 2104279 2104279 defendant Charles alias Hoode Nicholas glover 617205 617205 Charles alias Hoode, Nicholas, of Clive juxta Lewes, glover 1
4227780 2105198 2105198 defendant Stone Thomas butcher 617205 617205 Stone, Thomas, of Clive juxta Lewes, butcher 0
4230314 2106093 2106093 defendant Mannynge Edward yeoman 617205 617205 Mannynge, Edward, of Clive juxta Lewes, yeoman 2
4318015 2136412 2136412 defendant Foster Nicholas   617205 617205 Foster, Nicholas, of Clive juxta Lewes, slate layer 0
4318023 2136413 2136413 defendant Bother Peter blacksmith 617205 617205 Bother, Peter, of Clive juxta Lewes, blacksmith 2
4319233 2136838 2136838 defendant Betcher or Botcher Peter blacksmith 617205 617205 Betcher or Botcher, Peter, of Clive juxta Lewes, blacksmith 1
4358295 2150136 2150136 defendant Kynge Robert butcher 617205 617205 Kynge, Robert, of Clive juxta Lewes, butcher 0
4362411 2151607 2151607 defendant Hersye John yeoman 617205 617205 Hersye, John, of Clive juxta Lewes, yeoman 0
4363333 2151957 2151957 defendant Brincklowe Robert clerk 617205 617205 Brincklowe, Robert, of Clive juxta Lewes, clerk 0
4367903 2153571 2153571 defendant Kynge Robert butcher 617205 617205 Kynge, Robert, of Clive juxta Lewes, butcher 1
4369227 2154057 2154057 defendant Pickerell Thomas shoemaker 617205 617205 Pickerell, Thomas, of Clive juxta Lewes, shoemaker 1
4369653 2154200 2154200 defendant Picknett Richard innholder 617205 617205 Picknett, Richard, of Clive juxta Lewes, innholder 1
4373618 2155634 2155634 defendant Herne William tailor 617205 617205 Herne, William, of Clive juxta Lewes, tailor 0
4377089 2156881 2156881 defendant Hersey John yeoman 617205 617205 Hersey, John, of Clive juxta Lewes, yeoman 0
4377090 2156881 2156881 defendant Emerye Robert shoemaker 617205 617205 Emerye, Robert, of Clive juxta Lewes, shoemaker 1
4377091 2156881 2156881 defendant Evatt Edward husbandman 617205 617205 Evatt, Edward, of Clive juxta Lewes, husbandman 2
4377092 2156881 2156881 defendant Shurwood Walter yeoman 617205 617205 Shurwood, Walter, of Clive juxta Lewes, yeoman 3
4406450 2166722 2166722 defendant Bryncklowe Robert clerk 617205 617205 Bryncklowe, Robert, of Clive juxta Lewes, clerk 0
4780698 2289960 2289960 defendant Wyre alias Herst Richard glover 617205 617205 Wyre alias Herst, Richard, of Clive juxta Lewes, glover 1
4940020 2338904 2338904 defendant Coteler Walter butcher 617205 617205 Coteler, Walter, of Clive juxta Lewes, butcher 0
5035983 2367380 2367380 defendant Coteler Walter butcher 617205 617205 Coteler, Walter, of Clive juxta Lewes, butcher 0
5080635 2380696 2380696 defendant Warde or Worthe William chapman 617205 617205 Warde or Worthe, William, of Clive juxta Lewes, chapman 0
5082651 2381316 2381316 defendant Cole Richard chapman 617205 617205 Cole, Richard, of Clive juxta Lewes, chapman 1
5109238 2389128 2389128 defendant Lardener John chapman 617205 617205 Lardener, John, of Clive juxta Lewes, chapman 0
5233964 2425524 2425524 plaintiff Cole Richard yeoman 617205 617205 Cole, Richard, of Clive juxta Lewes, yeoman 0
5253705 2431271 2431271 defendant Denys Thomas laborer 617205 617205 Denys, Thomas, of Clive juxta Lewes, laborer 0
5263300 2434268 2434268 defendant Denys Thomas laborer 617205 617205 Denys, Thomas, of Clive juxta Lewes, laborer 0
5267262 2435521 2435521 defendant Denys Thomas laborer 617205 617205 Denys, Thomas, of Clive juxta Lewes, laborer 0
5538006 2516378 2516378 defendant Oughton Andrew yeoman 617205 617205 Oughton, Andrew, of Clive juxta Lewes, yeoman 0
5636853 2555468 2555468 defendant Stikkere John husbandman 617205 617205 Stikkere, John, of Clive juxta Lewes, husbandman 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);