names

34 rows where place_id = 663487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3969025 2013784 2013784 plaintiff Collier Thomas husbandman 663487 663487 Collier, Thomas, of Lea, husbandman 0
4042173 2039685 2039685 plaintiff Pagett William   663487 663487 Pagett, William, of Lea 0
4071041 2049942 2049942 defendant Clarke Thomas yeoman 663487 663487 Clarke, Thomas, of Lea, yeoman 2
4081623 2053730 2053730 defendant Lovell William yeoman 663487 663487 Lovell, William, of Lea, yeoman 1
4088910 2056338 2056338 defendant Calner or Calver John husbandman 663487 663487 Calner or Calver, John, of Lea, husbandman 0
4166664 2083838 2083838 defendant Bradburne Elizabeth widow 663487 663487 Bradburne, Elizabeth, of Lea, widow 0
4169929 2084978 2084978 defendant Wilson Henry yeoman 663487 663487 Wilson, Henry, of Lea, yeoman 1
4173573 2086210 2086210 defendant Mylls William yeoman 663487 663487 Mylls, William, of Lea, yeoman 1
4177263 2087516 2087516 defendant Flesher John yeoman 663487 663487 (Flesher, John, of Lea, yeoman 1
4181433 2088984 2088984 defendant Bradburne Nicholas gent 663487 663487 Bradburne, Nicholas, of Lea, gent 0
4181437 2088985 2088985 defendant Bradbourne Anthony gent 663487 663487 Bradbourne, Anthony, of Lea, gent 0
4190944 2092395 2092395 defendant ap Rered William yeoman 663487 663487 ap Rered, William, of Lea, yeoman 0
4193322 2093231 2093231 defendant Lloyd Robert gent 663487 663487 Lloyd, Robert, of Lea, gent 1
4214230 2100496 2100496 defendant Nurse Henry yeoman 663487 663487 Nurse, Henry, of Lea, yeoman 0
4214236 2100497 2100497 defendant Nurse Henry yeoman 663487 663487 Nurse, Henry, of Lea, yeoman 1
4219755 2102413 2102413 defendant Nurse Henry yeoman 663487 663487 Nurse, Henry, of Lea, yeoman 0
4219756 2102413 2102413 defendant Collyer John husbandman 663487 663487 Collyer, John, of Lea, husbandman 1
4228294 2105377 2105377 defendant Wilson Jerome   663487 663487 Wilson, Jerome, of Lea, yeoman, bailiff of wapentake of Corringham 0
4228609 2105490 2105490 defendant Bannister John gent 663487 663487 Bannister, John, of Lea, gent 0
4233330 2107170 2107170 defendant Fryer Thomas tailor 663487 663487 Fryer, Thomas, of Lea, tailor 3
4237094 2108556 2108556 defendant Bannister John gent 663487 663487 Bannister, John, of Lea, gent 0
4241935 2110294 2110294 defendant Fryer Thomas tailor 663487 663487 Fryer, Thomas, of Lea, tailor 3
4257332 2115428 2115428 defendant Wilson Jerome   663487 663487 Wilson, Jerome, of Lea, yeoman, bailiff of Corringham Wapentake 0
4278400 2122381 2122381 defendant Wynbowe Richard yeoman 663487 663487 Wynbowe Richard, of Lea, yeoman 0
4292967 2127546 2127546 defendant Allen Thomas yeoman 663487 663487 Allen, Thomas, of Lea, yeoman 1
4292968 2127546 2127546 defendant Allen John yeoman 663487 663487 Allen, John, of Lea, yeoman 2
4292969 2127546 2127546 defendant Allen Andrew yeoman 663487 663487 Allen, Andrew, of Lea, yeoman 3
4296298 2128773 2128773 defendant Turgus Humphrey yeoman 663487 663487 Turgus, Humphrey, of Lea, yeoman 2
4299335 2129855 2129855 defendant Fletcher Anthony husbandman 663487 663487 Fletcher, Anthony, of Lea, husbandman 0
4306371 2132371 2132371 defendant Rudge John husbandman 663487 663487 Rudge, John, of Lea, husbandman 2
4347552 2146390 2146390 defendant Allen John yeoman 663487 663487 Allen, John, of Lea, yeoman 2
4347553 2146390 2146390 defendant Allen Andrew yeoman 663487 663487 Allen, Andrew, of Lea, yeoman 3
4371477 2154853 2154853 defendant Allen Andrew yeoman 663487 663487 Allen, Andrew, of Lea, yeoman 3
4396554 2163417 2163417 defendant Bonfam Arthur yeoman 663487 663487 Bonfam, Arthur, of Lea, yeoman 1

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