names

15 rows where place_id = 716275

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4213984 2100413 2100413 defendant Harryngton Robert gent 716275 716275 Harryngton, Robert, of Rippingale, gent 0
4231824 2106628 2106628 defendant Wortley Thomas yeoman 716275 716275 Wortley, Thomas, of Rippingale, yeoman 0
4236027 2108172 2108172 defendant Harrington Robert esq 716275 716275 Harrington, Robert, of Rippingale, esq 2
4236722 2108417 2108417 defendant Marowe Thomas   716275 716275 Marowe, Thomas, of Rippingale, gent, administrators of 0
4236723 2108417 2108417 defendant Rossyter Christopher gent 716275 716275 (Rossyter, Christopher, of Rippingale, gent 1
4245304 2111411 2111411 defendant Marrowe Thomas   716275 716275 Marrowe, Thomas, of Rippingale, gent, administrators of 0
4245305 2111411 2111411 defendant Rossiter Christopher gent 716275 716275 (Rossiter, Christopher, of Rippingale, gent 1
4281564 2123458 2123458 defendant Pownder Robert husbandman 716275 716275 Pownder, Robert, of Rippingale, husbandman 0
4281565 2123458 2123458 defendant Clarke Robert laborer 716275 716275 Clarke, Robert, of Rippingale, laborer 1
4288704 2126016 2126016 defendant Greene William, junior husbandman 716275 716275 Greene, William, junior, of Rippingale, husbandman 0
4288705 2126016 2126016 defendant Chamberlayne Nicholas husbandman 716275 716275 Chamberlayne, Nicholas, of Rippingale, husbandman 1
4288706 2126016 2126016 defendant Warren Thomas husbandman 716275 716275 Warren, Thomas, of Rippingale, husbandman 2
4288707 2126016 2126016 defendant Piggott Thomas husbandman 716275 716275 Piggott, Thomas, of Rippingale, husbandman 3
4366613 2153106 2153106 defendant Tompson Margaret spinster 716275 716275 Tompson, Margaret, of Rippingale, spinster 0
4376567 2156690 2156690 defendant Reeler Robert laborer 716275 716275 Reeler, Robert, of Rippingale, laborer 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);