names

19 rows where place_id = 621117

✎ 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
3739626 1938608 1938608 defendant Gawton John butcher 621117 621117 Gawton, John, of Merstham, butcher 0
3772776 1949178 1949178 defendant Stevyn John husbandman 621117 621117 Stevyn, John, of merstham, husbandman 0
4195171 2093869 2093869 defendant Bowman Thomas yeoman 621117 621117 Bowman, Thomas, of Merstham, yeoman 1
4195175 2093870 2093870 defendant Bowman Thomas yeoman 621117 621117 Bowman, Thomas, of Merstham, yeoman 1
4365374 2152679 2152679 defendant Ewen Robert butcher 621117 621117 Ewen, Robert, of Merstham, butcher 0
4437668 2176539 2176539 plaintiff Acres Edmund de   621117 621117 Acres, Edmund de, of Merstham, parson 1
4471115 2191626 2191626 defendant Aleyn John   621117 621117 Aleyn, John, of Merstham 0
4471120 2191627 2191627 defendant Dene John   621117 621117 Dene, John, of Merstham 0
4547639 2215201 2215201 defendant Dene John   621117 621117 Dene, John, of Merstham 0
4575945 2223967 2223967 defendant Rydere William   621117 621117 Rydere, William, of Merstham 0
4812656 2300077 2300077 plaintiff Hamyngherst John   621117 621117 Hamyngherst, John, of Merstham 0
4898256 2326116 2326116 plaintiff Aleyn John   621117 621117 Aleyn, John, of Merstham 0
5145971 2399947 2399947 defendant Pleystowe John husbandman 621117 621117 (Pleystowe, John, of Merstham, husbandman 5
5302834 2445834 2445834 defendant Drake William yeoman 621117 621117 Drake, William, of Merstham, yeoman 2
5302835 2445834 2445834 defendant Synger Richard   621117 621117 Synger, Richard, of Merstham, groom 3
5302836 2445834 2445834 defendant Rolff Robert carpenter 621117 621117 Rolff, Robert, of Merstham, carpenter 4
5302837 2445834 2445834 defendant Warwyk William   621117 621117 Warwyk, William, of Merstham, parish clerk 5
5302838 2445834 2445834 defendant Best Richard yeoman 621117 621117 Best, Richard, of Merstham, yeoman 6
5610240 2546917 2546917 plaintiff atte Tye John   621117 621117 atte Tye, John, of Merstham, bailiff of the prior & convent of Christ Church, Canterbury 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);