names

31 rows where place_id = 670475

✎ 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
3997244 2023784 2023784 defendant Noble Henry yeoman 670475 670475 Noble, Henry, of Warter, yeoman 0
4060102 2046013 2046013 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 0
4060103 2046013 2046013 defendant Horne James husbandman 670475 670475 Horne, James, of Warter, husbandman 1
4062229 2046782 2046782 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 0
4073465 2050794 2050794 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 0
4077358 2052186 2052186 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 0
4103922 2061679 2061679 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 1
4153515 2079323 2079323 defendant Hungate William (legal representative) 670475 670475 Hungate, William, of Warter, esq, executor of 0
4153519 2079324 2079324 defendant Hungate William (legal representative) 670475 670475 Hungate, William, of Warter, esq, executor of 0
4177898 2087743 2087743 defendant Hungate William (legal representative) 670475 670475 Hungate, William, of Warter, esq, executor of 0
4177902 2087744 2087744 defendant Hungate William (legal representative) 670475 670475 Hungate, William, of Warter, esq, executor of 0
4221560 2103033 2103033 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 1
4272090 2120230 2120230 defendant Preston John yeoman 670475 670475 Preston, John, of Warter, yeoman 1
4515615 2205307 2205307 defendant Walker John   670475 670475 Walker, John, of Warter 0
4515616 2205307 2205307 defendant Walker Richard   670475 670475 Walker, Richard, of Warter 1
4549712 2215844 2215844 plaintiff Couper Alice   670475 670475 Couper, Alice, of Warter 0
4549713 2215844 2215844 defendant Norman Thomas   670475 670475 Norman, Thomas, of Warter 0
4764638 2284926 2284926 defendant Blythe Robert tailor 670475 670475 Blythe, Robert, of Warter, tailor 0
4788693 2292518 2292518 defendant Blythe Robert tailor 670475 670475 Blythe, Robert, of Warter, tailor 0
4836179 2307297 2307297 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 1
4848902 2311122 2311122 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 1
4848903 2311122 2311122 defendant Jenyn John husbandman 670475 670475 Jenyn, John, of Warter, husbandman 2
4850637 2311658 2311658 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 0
4863606 2315587 2315587 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 3
4863612 2315588 2315588 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 3
4878632 2320259 2320259 defendant Norman Thomas husbandman 670475 670475 Norman, Thomas, of Warter, husbandman 0
5040623 2368804 2368804 defendant Dyn John laborer 670475 670475 Dyn, John, of Warter, laborer 1
5227308 2423614 2423614 defendant Kynge John yeoman 670475 670475 Kynge, John, of Warter, yeoman 3
5343285 2458095 2458095 defendant Josep William husbandman 670475 670475 Josep, William, of Warter, husbandman 0
5377123 2468434 2468434 plaintiff (not given) William prior of Spencer 670475 670475 Spencer, William, of Warter, prior of the Monastery of St James 0
5377125 2468435 2468435 plaintiff (not given) William prior of Spencer 670475 670475 Spencer, William, of Warter, prior of the Monastery of St James 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);