names

43 rows where place_id = 595378

✎ 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
3620247 1873911 1873911 defendant Hickeys Robert   595378 595378 Hickeys, Robert, of Potterne 0
3636927 1906343 1906343 defendant Grey John weaver 595378 595378 (Grey, John, of Potterne, weaver 1
3638997 1907019 1907019 defendant Grey John weaver 595378 595378 (Grey, John, of Potterne, weaver 1
3822695 1965000 1965000 defendant Trymnell Christopher fuller 595378 595378 Trymnell, Christopher, of Potterne, fuller 1
3958468 2010032 2010032 plaintiff Roke Alice widow 595378 595378 Roke, Alice, of Potterne, widow 0
3984360 2019161 2019161 defendant Flower Edward gent 595378 595378 Flower, Edward, of Potterne, gent 0
4035272 2037291 2037291 defendant Longe Thomas yeoman 595378 595378 Longe, Thomas, of Potterne, yeoman 1
4035286 2037295 2037295 defendant Longe Thomas yeoman 595378 595378 Longe, Thomas, of Potterne, yeoman 1
4141140 2075061 2075061 defendant Clement William yeoman 595378 595378 Clement, William, of Potterne, or of Dinton, yeoman 0
4169983 2084995 2084995 defendant Perry Anthony yeoman 595378 595378 Perry, Anthony, of Potterne, yeoman 0
4279505 2122751 2122751 defendant Trymnell Arthur yeoman 595378 595378 Trymnell, Arthur, of Potterne, yeoman 1
4279750 2122835 2122835 defendant Bancrofte William husbandman 595378 595378 Bancrofte, William, of Potterne, husbandman 0
4288566 2125962 2125962 defendant Trymnell Arthur yeoman 595378 595378 Trymnell, Arthur, of Potterne, yeoman 1
4342185 2144547 2144547 defendant Longe Thomas gent 595378 595378 Longe, Thomas, of Potterne, or of Winterborne Earles, gent 0
4346679 2146092 2146092 defendant Rooke Francis yeoman 595378 595378 Rooke, Francis, of Potterne, yeoman 1
4367331 2153371 2153371 defendant Longe Richard clothier 595378 595378 Longe, Richard, of Potterne, clothier 0
4368897 2153933 2153933 defendant Hiller Roger yeoman 595378 595378 Hiller, Roger, of Potterne, yeoman 0
4876476 2319608 2319608 defendant Axford William husbandman 595378 595378 Axford, William, of Potterne, husbandman 0
5018138 2362192 2362192 defendant Grave alias Parker John yeoman 595378 595378 Grave alias Parker, John, of Potterne, yeoman 0
5041576 2369084 2369084 defendant Grove alias Parker John yeoman 595378 595378 Grove alias Parker, John, of Potterne, yeoman 0
5085053 2382039 2382039 defendant Baron William husbandman 595378 595378 Baron, William, of Potterne, husbandman 0
5085056 2382039 2382039 defendant Purye John husbandman 595378 595378 Purye, John, of Potterne, husbandman 3
5085057 2382039 2382039 defendant Lylbrone John yeoman 595378 595378 Lylbrone, John, of Potterne, yeoman 4
5085058 2382039 2382039 defendant Ryse John husbandman 595378 595378 Ryse, John, of Potterne, husbandman 5
5085060 2382039 2382039 defendant Amys John butcher 595378 595378 Amys, John, of Potterne, butcher 7
5085061 2382039 2382039 defendant Barbour William butcher 595378 595378 Barbour, William, of Potterne, butcher 8
5085062 2382039 2382039 defendant Bony or Bovy John husbandman 595378 595378 Bony or Bovy, John, of Potterne, husbandman 9
5085063 2382039 2382039 defendant Colyns Thomas, junior husbandman 595378 595378 Colyns, Thomas, junior, of Potterne, husbandman 10
5085064 2382039 2382039 defendant Smyth Robert husbandman 595378 595378 Smyth, Robert, of Potterne, husbandman 11
5085065 2382039 2382039 defendant Grevell Thomas butcher 595378 595378 Grevell, Thomas, of Potterne, butcher 12
5085067 2382039 2382039 defendant Swayn Robert laborer 595378 595378 Swayn, Robert, of Potterne, laborer 14
5085069 2382040 2382040 defendant Baron William husbandman 595378 595378 Baron, William, of Potterne, husbandman 0
5085072 2382040 2382040 defendant Purye John husbandman 595378 595378 Purye, John, of Potterne, husbandman 3
5085073 2382040 2382040 defendant Lylbrone John yeoman 595378 595378 Lylbrone, John, of Potterne, yeoman 4
5085074 2382040 2382040 defendant Ryse John husbandman 595378 595378 Ryse, John, of Potterne, husbandman 5
5085076 2382040 2382040 defendant Amys John butcher 595378 595378 Amys, John, of Potterne, butcher 7
5085077 2382040 2382040 defendant Barbour William butcher 595378 595378 Barbour, William, of Potterne, butcher 8
5085078 2382040 2382040 defendant Bony or Bovy John husbandman 595378 595378 Bony or Bovy, John, of Potterne, husbandman 9
5085079 2382040 2382040 defendant Colyns Thomas, junior husbandman 595378 595378 Colyns, Thomas, junior, of Potterne, husbandman 10
5085080 2382040 2382040 defendant Smyth Robert husbandman 595378 595378 Smyth, Robert, of Potterne, husbandman 11
5085081 2382040 2382040 defendant Grevell Thomas butcher 595378 595378 Grevell, Thomas, of Potterne, butcher 12
5085083 2382040 2382040 defendant Swayn Robert laborer 595378 595378 Swayn, Robert, of Potterne, laborer 14
5535312 2515571 2515571 defendant Floure John husbandman 595378 595378 Floure, John, of Potterne, 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);