names

25 rows where place_id = 588433

✎ 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
3594505 1865912 1865912 defendant Eignon or Gignon John husbandman 588433 588433 Eignon or Gignon, John, of Canon Pewen, husbandman 0
3598966 1867306 1867306 defendant Collyns Thomas husbandman 588433 588433 (Collyns, Thomas, of Canon Pewen, husbandman 1
3658104 1912791 1912791 defendant Alton John yeoman 588433 588433 Alton, John, of Canon Pewen, yeoman 0
3674436 1918051 1918051 defendant Abeynham John husbandman 588433 588433 Abeynham, John, of Canon Pewen, husbandman 0
3677109 1918881 1918881 defendant Mason George husbandman 588433 588433 Mason, George, of Canon Pewen, husbandman 0
3683644 1921015 1921015 defendant Alton Henry husbandman 588433 588433 Alton, Henry, of Canon Pewen, husbandman 1
3683654 1921018 1921018 defendant Alton Henry husbandman 588433 588433 Alton, Henry, of Canon Pewen, husbandman 1
3691516 1923503 1923503 defendant Walsheman Thomas husbandman 588433 588433 Walsheman, Thomas, of Canon Pewen, husbandman 2
3747080 1941003 1941003 defendant Velour alias Welscheman John husbandman 588433 588433 Velour alias Welscheman, John, of Canon Pewen, husbandman 2
3747081 1941003 1941003 defendant Gardener John, junior husbandman 588433 588433 Gardener, John, junior, of Canon Pewen, husbandman 3
3885782 1985498 1985498 defendant Goodman Richard yeoman 588433 588433 Goodman, Richard, of Canon Pewen, yeoman 0
3898264 1989628 1989628 defendant Goodman Richard yeoman 588433 588433 Goodman, Richard, of Canon Pewen, yeoman 0
4178977 2088125 2088125 defendant Knappe Richard yeoman 588433 588433 Knappe, Richard, of Canon Pewen, yeoman 4
4633483 2241325 2241325 defendant Silley Thomas   588433 588433 Silley, Thomas, of Canon Pewen 2
4974503 2349336 2349336 defendant Alton Roger husbandman 588433 588433 Alton, Roger, of Canon Pewen, husbandman 3
5495919 2503676 2503676 defendant Barnard Hugh husbandman 588433 588433 Barnard, Hugh, of Canon Pewen, husbandman 1
5495920 2503676 2503676 defendant Silly Richard husbandman 588433 588433 Silly, Richard, of Canon Pewen, husbandman 2
5550547 2520183 2520183 defendant Colyns Thomas husbandman 588433 588433 Colyns, Thomas, of Canon Pewen, husbandman 0
5550549 2520183 2520183 defendant Sylly Richard husbandman 588433 588433 Sylly, Richard, of Canon Pewen, husbandman 2
5578343 2528296 2528296 defendant Wotton William husbandman 588433 588433 Wotton, William, of Canon Pewen, husbandman 0
5578344 2528296 2528296 defendant Knap William husbandman 588433 588433 Knap, William, of Canon Pewen, husbandman 1
5584210 2530131 2530131 defendant Tayllour Thomas husbandman 588433 588433 Tayllour, Thomas, of Canon Pewen, husbandman 3
5592199 2532555 2532555 defendant Gardener Richard husbandman 588433 588433 Gardener, Richard, of Canon Pewen, husbandman 0
5592202 2532555 2532555 defendant Knappe William husbandman 588433 588433 Knappe, William, of Canon Pewen, husbandman 3
5601417 2535334 2535334 defendant Sylly Agnes widow 588433 588433 Sylly, Agnes, of Canon Pewen, widow 3

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