names

30 rows where place_id = 593912

✎ 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
3613825 1871980 1871980 defendant Beke William husbandman 593912 593912 Beke, William, of Asshe juxta Sandwich, husbandman 1
3618036 1873262 1873262 defendant Soly Simon carpenter 593912 593912 Soly, Simon, of Asshe juxta Sandwich, carpenter 1
3740829 1938988 1938988 defendant Cresley Richard shoemaker 593912 593912 Cresley, Richard, of Asshe juxta Sandwich, shoemaker 0
3744613 1940210 1940210 defendant Hochyn Edward husbandman 593912 593912 Hochyn, Edward, of Asshe juxta Sandwich, husbandman 0
3751462 1942375 1942375 defendant Afford Richard husbandman 593912 593912 Afford, Richard, of Asshe juxta Sandwich, husbandman 0
3751465 1942375 1942375 defendant Hollewey Thomas husbandman 593912 593912 Hollewey, Thomas, of Asshe juxta Sandwich, husbandman 3
3751468 1942376 1942376 defendant Paramour Thomas husbandman 593912 593912 Paramour, Thomas, of Asshe juxta Sandwich, husbandman 1
3757015 1944173 1944173 defendant Hochyn Edmund husbandman 593912 593912 Hochyn, Edmund, of Asshe juxta Sandwich, husbandman 0
3787909 1954009 1954009 defendant Kyrkby William butcher 593912 593912 Kyrkby, William, of Asshe juxta Sandwich, butcher 1
3815504 1962764 1962764 defendant Tukke Robert gent 593912 593912 Tukke, Robert, of Asshe juxta Sandwich, gent 0
3833704 1968470 1968470 defendant Howlyng Hamon husbandman 593912 593912 Howlyng, Hamon, of Asshe juxta Sandwich, husbandman 0
3903966 1991565 1991565 defendant Barlett Thomas laborer 593912 593912 Barlett, Thomas, of Asshe juxta Sandwich, laborer 0
3997825 2023980 2023980 plaintiff Elmer John yeoman 593912 593912 Elmer, John, of Asshe juxta Sandwich, yeoman 0
3997827 2023981 2023981 plaintiff Elmer John yeoman 593912 593912 Elmer, John, of Asshe juxta Sandwich, yeoman 0
3997829 2023982 2023982 plaintiff Elmer John yeoman 593912 593912 Elmer, John, of Asshe juxta Sandwich, yeoman 0
3997832 2023983 2023983 plaintiff Elmer John yeoman 593912 593912 Elmer, John, of Asshe juxta Sandwich, yeoman 0
4868263 2317050 2317050 defendant Wodhill alias Phelipp John laborer 593912 593912 Wodhill alias Phelipp, John, of Asshe juxta Sandwich, laborer 0
4893782 2324750 2324750 defendant Omyre John husbandman or servant 593912 593912 Omyre, John, of Asshe juxta Sandwich, husbandman or servant 0
4942754 2339704 2339704 defendant Starke Stephen husbandman 593912 593912 Starke, Stephen, of Asshe juxta Sandwich, husbandman 0
4973616 2349061 2349061 defendant Shotyer Thomas tinker 593912 593912 Shotyer, Thomas, of Asshe juxta Sandwich, tinker 0
5080382 2380625 2380625 defendant Baldewyn John yeoman 593912 593912 Baldewyn, John, of Asshe juxta Sandwich, yeoman 3
5085112 2382050 2382050 defendant Clydrowe Roger esq 593912 593912 Clydrowe, Roger, of Asshe juxta Sandwich, esq 0
5259993 2433248 2433248 defendant Lyon John, senior thatcher 593912 593912 Lyon, John, senior, of Asshe juxta Sandwich, thatcher 0
5259994 2433248 2433248 defendant Lyon John, junior laborer 593912 593912 Lyon, John, junior, of Asshe juxta Sandwich, laborer 1
5344653 2458501 2458501 defendant Creke Richard husbandman 593912 593912 Creke, Richard, of Asshe juxta Sandwich, husbandman 0
5348449 2459655 2459655 defendant Soly Richard husbandman 593912 593912 Soly, Richard, of Asshe juxta Sandwich, husbandman 0
5484828 2500385 2500385 defendant Beeke William husbandman 593912 593912 Beeke, William, of Asshe juxta Sandwich, husbandman 0
5486414 2500825 2500825 defendant Creke Richard husbandman 593912 593912 Creke, Richard, of Asshe juxta Sandwich, husbandman 0
5502639 2505742 2505742 defendant Omer Lawrence (legal representative) 593912 593912 Omer, Lawrence, of Asshe juxta Sandwich, executors of 0
5540114 2517031 2517031 defendant Dryssyll Thomas tanner 593912 593912 Dryssyll, Thomas, of Asshe juxta Sandwich, tanner 2

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