names

38 rows where place_id = 602679

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651257 1910759 1910759 defendant Spark Thomas clerk 602679 602679 Spark, Thomas, of Bugden, Hunts, clerk 0
3651259 1910760 1910760 defendant Sparke Thomas clerk 602679 602679 Sparke, Thomas, of Bugden, Hunts, clerk 0
3785323 1953197 1953197 defendant Hyatt John gent 602679 602679 Hyatt, John, of Bugden, Hunts, gent 1
3800389 1958039 1958039 defendant Luffe William husbandman 602679 602679 Luffe, William, of Bugden, Hunts, husbandman 1
3814323 1962391 1962391 defendant Luffyn William miller 602679 602679 Luffyn, William, of Bugden, Hunts, miller 0
3876274 1982303 1982303 defendant Luff William husbandman 602679 602679 Luff, William, of Bugden, Hunts, husbandman 4
3932413 2001128 2001128 defendant Williamson Thomas yeoman 602679 602679 Williamson, Thomas, of Bugden, Hunts, yeoman 0
3932415 2001129 2001129 defendant Wilkinson Thomas yeoman 602679 602679 Wilkinson, Thomas, of Bugden, Hunts, yeoman 0
3956946 2009496 2009496 defendant Curtys Thomas husbandman 602679 602679 Curtys, Thomas, of Bugden, Hunts, husbandman 0
3993027 2022254 2022254 defendant Capon William yeoman 602679 602679 Capon, William, of Bugden, Hunts, yeoman 2
4013597 2029599 2029599 defendant Willmott William yeoman 602679 602679 Willmott, William, of Bugden, Hunts, yeoman 0
4013599 2029600 2029600 defendant Wyllmot William yeoman 602679 602679 Wyllmot, William, of Bugden, Hunts, yeoman 0
4014553 2029925 2029925 defendant Curtyse Thomas yeoman 602679 602679 Curtyse, Thomas, of Bugden, Hunts, yeoman 0
4026957 2034293 2034293 defendant Capon William gent 602679 602679 Capon, William, of Bugden, Hunts, gent 0
4045273 2040767 2040767 defendant Cauntlot Thomas husbandman 602679 602679 Cauntlot, Thomas, of Bugden, Hunts, husbandman 0
4045275 2040768 2040768 defendant Hamante Thomas husbandman 602679 602679 Hamante, Thomas, of Bugden, Hunts, husbandman 0
4074243 2051086 2051086 defendant Martyn Gilbert gent 602679 602679 Martyn, Gilbert, of Bugden, Hunts, gent 0
4089136 2056409 2056409 defendant Torkington William gent 602679 602679 Torkington, William, of Bugden, Hunts, gent 0
4146197 2076820 2076820 defendant Langley Thomas yeoman 602679 602679 Langley, Thomas, of Bugden, Hunts, yeoman 0
4209198 2098768 2098768 defendant Hamont or Hamond Thomas yeoman 602679 602679 Hamont or Hamond, Thomas, of Bugden, Hunts, yeoman 0
4215295 2100844 2100844 defendant Collingson or Collison Richard gent 602679 602679 Collingson or Collison, Richard, of Bugden, Hunts, gent 0
4264878 2117891 2117891 defendant Fanne Robert yeoman 602679 602679 Fanne, Robert ,of Bugden, Hunts, yeoman 1
4275476 2121360 2121360 defendant East Francis gent 602679 602679 East, Francis, of Bugden, Hunts, or of Chancery Lane, Middx, gent 1
4329384 2140139 2140139 defendant Easte Francis gent 602679 602679 Easte, Francis, of Bugden, Hunts, gent 0
4336096 2142358 2142358 defendant East Francis gent 602679 602679 East, Francis, of Bugden, Hunts, gent 0
4356104 2149357 2149357 defendant Bywater Thomas yeoman 602679 602679 Bywater, Thomas, of Bugden, Hunts, yeoman 1
4714558 2269882 2269882 defendant Burgeys John husbandman 602679 602679 Burgeys, John, of Bugden, Hunts, husbandman 0
5154060 2402346 2402346 defendant Fuller Robert merchant 602679 602679 Fuller, Robert, of Bugden, Hunts, merchant 0
5171284 2407323 2407323 defendant Fuller Robert merchant 602679 602679 Fuller, Robert, of Bugden, Hunts, merchant 0
5189596 2412699 2412699 defendant Fuller Robert merchant 602679 602679 Fuller, Robert, of Bugden, Hunts, merchant 0
5189598 2412700 2412700 defendant Fuller Robert merchant 602679 602679 Fuller, Robert, of Bugden, Hunts, merchant 0
5242268 2427941 2427941 defendant Fuller John, junior yeoman 602679 602679 Fuller, John, junior, of Bugden, Hunts, yeoman 2
5324954 2452543 2452543 defendant Bocher John tailor 602679 602679 Bocher, John, of Bugden, Hunts, tailor 2
5324970 2452546 2452546 defendant Bocher John tailor 602679 602679 Bocher, John, of Bugden, Hunts, tailor 2
5351666 2460620 2460620 defendant Smyth William husbandman 602679 602679 Smyth, William, of Bugden, Hunts, husbandman 0
5506921 2507079 2507079 defendant Checheley John smith 602679 602679 Checheley, John, of Bugden, Hunts, smith 4
5532522 2514715 2514715 defendant Kyngeston William brickmaker 602679 602679 Kyngeston, William, of Bugden, Hunts, brickmaker 1
5532524 2514716 2514716 defendant Kyngeston William   602679 602679 Kyngeston, William, of Bugden, Hunts, brick maker 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);