names

19 rows where place_id = 618058

✎ 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
3722641 1933341 1933341 defendant Spyttyll William fuller 618058 618058 Spyttyll, William, of Enfeld, Staffs, fuller 0
3722669 1933353 1933353 defendant Spytyll William fuller 618058 618058 Spytyll, William, of Enfeld, Staffs, fuller 0
3833773 1968496 1968496 defendant Cokkys John, senior yeoman 618058 618058 Cokkys, John, senior, of Enfeld, Staffs, yeoman 1
3833774 1968496 1968496 defendant Cokkys John, junior yeoman 618058 618058 Cokkys, John, junior, of Enfeld, Staffs, yeoman 2
3833784 1968498 1968498 defendant Cokkys John, senior yeoman 618058 618058 Cokkys, John, senior, of Enfeld, Staffs, yeoman 1
3833785 1968498 1968498 defendant Cokkys John, junior yeoman 618058 618058 Cokkys, John, junior, of Enfeld, Staffs, yeoman 2
3885560 1985423 1985423 defendant Shadwell Thomas yeoman 618058 618058 Shadwell, Thomas, of Enfeld, Staffs, yeoman 0
3977768 2016794 2016794 plaintiff Lye Richard (legal representative) 618058 618058 Lye, Richard, of Enfeld, Staffs, administratrix of 0
5009018 2359525 2359525 defendant Lowe William esq 618058 618058 Lowe, William, of Enfeld, Staffs, esq 2
5323398 2452074 2452074 defendant Symondes John yeoman 618058 618058 Symondes, John, of Enfeld, Staffs, yeoman 0
5440297 2487001 2487001 defendant Lee Humfrey yeoman 618058 618058 Lee, Humfrey, of Enfeld, Staffs, yeoman 1
5453726 2491010 2491010 defendant Lee Humphrey yeoman 618058 618058 Lee, Humphrey, of Enfeld, Staffs, yeoman 0
5453731 2491011 2491011 defendant Lee Humphrey yeoman 618058 618058 Lee, Humphrey, of Enfeld, Staffs, yeoman 0
5453737 2491012 2491012 defendant Lee Humphrey yeoman 618058 618058 Lee, Humphrey, of Enfeld, Staffs, yeoman 1
5488530 2501456 2501456 defendant Kancke or Kaucke Richard clerk 618058 618058 Kancke or Kaucke, Richard, of Enfeld, Staffs, clerk 0
5503582 2506034 2506034 defendant Cokkes Thomas husbandman 618058 618058 Cokkes, Thomas, of Enfeld, Staffs, husbandman 0
5516739 2510059 2510059 defendant Kyrkham Robert yeoman 618058 618058 Kyrkham, Robert, of Enfeld, Staffs, yeoman 0
5530945 2514195 2514195 defendant Pery James clerk 618058 618058 Pery, James, of Enfeld, Staffs, clerk 2
5557134 2522044 2522044 defendant Cokkes Thomas yeoman 618058 618058 Cokkes, Thomas, of Enfeld, Staffs, 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);