names

14 rows where place_id = 599647

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637593 1906568 1906568 defendant Gatward Thomas husbandman 599647 599647 Gatward, Thomas, of Elsenham, husbandman 1
3664672 1914903 1914903 defendant Jacobe Richard skinner 599647 599647 Jacobe, Richard, of Elsenham, skinner 0
3710154 1929490 1929490 defendant Gatward John husbandman 599647 599647 Gatward, John, of Elsenham, husbandman 3
3751181 1942296 1942296 defendant Wryght Robert husbandman 599647 599647 Wryght, Robert, of Elsenham, husbandman 0
3753008 1942874 1942874 defendant Catward John husbandman 599647 599647 Catward, John, of Elsenham, husbandman 0
3867315 1979300 1979300 defendant Gateward John husbandman 599647 599647 Gateward, John, of Elsenham, husbandman 1
3882630 1984454 1984454 defendant Comfrett William husbandman 599647 599647 Comfrett, William, of Elsenham, husbandman 1
3910208 1993728 1993728 defendant Ormysby Thomas butcher 599647 599647 Ormysby, Thomas, of Elsenham, butcher 1
4435914 2175980 2175980 defendant Tye John atte   599647 599647 Tye, John atte, of Elsenham 4
4870056 2317601 2317601 defendant Tracche William smith 599647 599647 Tracche, William, of Elsenham, smith 1
5231378 2424764 2424764 defendant Barley John gent 599647 599647 Barley, John, of Elsenham, gent 1
5261614 2433741 2433741 defendant Trachy Thomas husbandman 599647 599647 Trachy, Thomas, of Elsenham, husbandman 0
5261615 2433741 2433741 defendant Crakenell John husbandman 599647 599647 Crakenell, John, of Elsenham, husbandman 1
5442863 2487777 2487777 defendant Motte John, sen husbandman 599647 599647 Motte, John, sen, of Elsenham, husbandman 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);