names

17 rows where case_id = 2097839

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4206553 2097839 2097839 plaintiff Poley William esq   Poley, William, esq 0
4206554 2097839 2097839 defendant Ramsey Thomas joiner 617783 617783 Ramsey, Thomas, of Northweld Bassett, joiner 0
4206555 2097839 2097839 defendant Ramsey John of Northweld Bassett joiner   Ramsey, John of Northweld Bassett, joiner 1
4206556 2097839 2097839 defendant Spranger Richard junior fuller 617783 617783 Spranger Richard, junior, of Northweld Bassett, fuller 2
4206557 2097839 2097839 defendant Spranger John husbandman 617783 617783 Spranger, John, of Northweld Bassett, husbandman 3
4206558 2097839 2097839 defendant Cakebreade Edward laborer 617783 617783 Cakebreade, Edward, of Northweld Bassett, laborer 4
4206559 2097839 2097839 defendant Cakebreade Roger laborer 617783 617783 Cakebreade, Roger, of Northweld Bassett, laborer 5
4206560 2097839 2097839 defendant Ramsey Nicholas husbandman 617783 617783 Ramsey, Nicholas, of Northweld Bassett, husbandman 6
4206561 2097839 2097839 defendant Pooley Thomas tailor 617783 617783 Pooley, Thomas, of Northweld Bassett, tailor 7
4206562 2097839 2097839 defendant Freman William laborer 617783 617783 Freman, William, of Northweld Bassett, laborer 8
4206563 2097839 2097839 defendant Sparke Walter laborer 617783 617783 Sparke, Walter, of Northweld Bassett, laborer 9
4206564 2097839 2097839 defendant Creamer Edward laborer 617783 617783 Creamer, Edward, of Northweld Bassett, laborer 10
4206565 2097839 2097839 defendant Reyn- Thomas husbandman 600424 600424 Reyn-, Thomas, of Latton, husbandman 11
4206566 2097839 2097839 defendant Flettcher Robert laborer 600424 600424 Flettcher, Robert, of Latton, laborer 12
4206567 2097839 2097839 defendant Claye John husbandman 591820 591820 Claye, John, of Harlowe, husbandman 13
4206568 2097839 2097839 defendant Catroll Thomas laborer 591820 591820 Catroll, Thomas, of Harlowe, laborer 14
4206569 2097839 2097839 defendant Morrell William laborer 617783 617783 Morrell, William, of Northweld Bassett, laborer 15

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);