names

17 rows where case_id = 2097840

✎ 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
4206570 2097840 2097840 plaintiff Poley William esq   Poley, William, esq 0
4206571 2097840 2097840 defendant Ramsey Thomas joiner 617783 617783 Ramsey, Thomas, of Northweld Bassett, joiner 0
4206572 2097840 2097840 defendant Ramsey John joiner 617783 617783 Ramsey, John, of Northweld Bassett, joiner 1
4206573 2097840 2097840 defendant Spranger Richard, junior fuller 617783 617783 Spranger, Richard, junior, of Northweld Bassett, fuller 2
4206574 2097840 2097840 defendant Spranger John husbandman 617783 617783 Spranger, John, of Northweld Bassett, husbandman 3
4206575 2097840 2097840 defendant Cakebrede Edward laborer 617783 617783 Cakebrede, Edward, of Northweld Bassett, laborer 4
4206576 2097840 2097840 defendant Cakebrede Roger laborer 617783 617783 Cakebrede, Roger, of Northweld Bassett, laborer 5
4206577 2097840 2097840 defendant Ramsey Nicholas husbandman 617783 617783 Ramsey, Nicholas, of Northweld Bassett, husbandman 6
4206578 2097840 2097840 defendant Poole Thomas tailor 617783 617783 Poole, Thomas, of Northweld Bassett, tailor 7
4206579 2097840 2097840 defendant Freman William laborer 617783 617783 Freman, William, of Northweld Bassett, laborer 8
4206580 2097840 2097840 defendant Sparke Walter laborer 617783 617783 Sparke, Walter, of Northweld Bassett, laborer 9
4206581 2097840 2097840 defendant Creamer Edward laborer 617783 617783 Creamer, Edward, of Northweld Bassett, laborer 10
4206582 2097840 2097840 defendant Reynold Thomas husbandman 600424 600424 Reynold, Thomas, of Latton, husbandman 11
4206583 2097840 2097840 defendant Fletcher Robert laborer 600424 600424 Fletcher, Robert, of Latton, laborer 12
4206584 2097840 2097840 defendant Cleye John husbandman 591820 591820 Cleye, John, of Harlowe, husbandman 13
4206585 2097840 2097840 defendant Catroll Thomas laborer 591820 591820 Catroll, Thomas, of Harlowe, laborer 14
4206586 2097840 2097840 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);