names

28 rows where place_id = 589173

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596790 1866631 1866631 defendant Uppewell Robert tailor 589173 589173 Uppewell, Robert, of Dallyngton, tailor 0
3834842 1968836 1968836 defendant Pont William husbandman 589173 589173 Pont, William, of Dallyngton, husbandman 1
3980272 2017710 2017710 defendant Olyver William husbandman 589173 589173 Olyver, William, of Dallyngton, husbandman 1
3985643 2019629 2019629 defendant Walloppe John husbandman 589173 589173 Walloppe, John, of Dallyngton, husbandman 0
4057314 2044999 2044999 defendant Flaskett Lawrence husbandman 589173 589173 Flaskett, Lawrence, of Dallyngton, husbandman 3
4082161 2053929 2053929 defendant James William yeoman 589173 589173 James, William, of Dallyngton, yeoman 0
4119875 2067398 2067398 defendant Browne William husbandman 589173 589173 Browne, William, of Dallyngton, husbandman 0
4122328 2068294 2068294 defendant Herne William yeoman 589173 589173 Herne, William, of Dallyngton, yeoman 0
4150219 2078209 2078209 defendant Pretye Thomas husbandman 589173 589173 Pretye, Thomas, of Dallyngton, husbandman 1
4175214 2086792 2086792 defendant Glydd Henry yeoman 589173 589173 Glydd, Henry, of Dallyngton, yeoman 0
4226397 2104705 2104705 defendant Add alias Bunton John collier 589173 589173 Add alias Bunton, John, of Dallyngton, collier 1
4230140 2106028 2106028 defendant Kyngeswell Richard tailor 589173 589173 Kyngeswell, Richard, of Dallyngton, tailor 0
4230424 2106134 2106134 defendant Raye William husbandman 589173 589173 Raye, William, of Dallyngton, husbandman 0
4231071 2106367 2106367 defendant Ashebornham Thomas gent 589173 589173 Ashebornham, Thomas, of Dallyngton, gent 0
4231105 2106381 2106381 defendant Kyngeswell Richard tailor 589173 589173 Kyngeswell, Richard, of Dallyngton, tailor 0
4231106 2106381 2106381 defendant Bachiler Richard yeoman 589173 589173 Bachiler, Richard, of Dallyngton, yeoman 1
4233068 2107073 2107073 defendant Garlande John husbandman 589173 589173 Garlande, John, of Dallyngton, husbandman 3
4234379 2107563 2107563 defendant Asheborneham Thomas gent 589173 589173 Asheborneham, Thomas, of Dallyngton, gent 0
4239649 2109498 2109498 defendant Asheborneham Thomas gent 589173 589173 Asheborneham, Thomas, of Dallyngton, gent 0
4273356 2120651 2120651 defendant Kyngeswell Richard tailor 589173 589173 Kyngeswell, Richard, of Dallyngton, tailor 0
4273357 2120651 2120651 defendant Bachiler Richard yeoman 589173 589173 Bachiler, Richard, of Dallyngton, yeoman 1
4295408 2128444 2128444 defendant Gleade Henry   589173 589173 Gleade, Henry, of Dallyngton, forge master 0
4359370 2150511 2150511 defendant Deacons John clothier 589173 589173 Deacons, John, of Dallyngton, clothier 1
4362487 2151633 2151633 defendant Olyver Edward husbandman 589173 589173 Olyver, Edward, of Dallyngton, husbandman 0
4377827 2157140 2157140 defendant Kyngeswell Richard tailor 589173 589173 Kyngeswell, Richard, of Dallyngton, tailor 0
4378493 2157379 2157379 defendant James William yeoman 589173 589173 James, William, of Dallyngton, yeoman 0
4378501 2157382 2157382 defendant Mathewe Martin smith 589173 589173 Mathewe, Martin, of Dallyngton, smith 2
4392543 2162126 2162126 defendant Stockden or Stockton Robert yeoman 589173 589173 Stockden or Stockton, Robert, of Dallyngton, yeoman 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);