names

34 rows where place_id = 617783

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3721257 1932952 1932952 defendant Strode Margaret widow 617783 617783 Strode, Margaret, of Northweld Bassett, widow 0
3758591 1944684 1944684 defendant Hurte William yeoman 617783 617783 Hurte, William, of Northweld Bassett, yeoman 0
3758592 1944684 1944684 defendant Ferne John yeoman 617783 617783 Ferne, John, of Northweld Bassett, yeoman 1
4206542 2097837 2097837 defendant Larder Andrew gent 617783 617783 Larder, Andrew, of Northweld Bassett, gent 0
4206543 2097837 2097837 defendant Allatt Thomas yeoman 617783 617783 Allatt, Thomas, of Northweld Bassett, yeoman 1
4206544 2097837 2097837 defendant Poole Thomas tailor 617783 617783 Poole, Thomas, of Northweld Bassett, tailor 2
4206545 2097837 2097837 defendant Freeman William laborer 617783 617783 Freeman, William, of Northweld Bassett, laborer 3
4206548 2097838 2097838 defendant Larder Andrew gent 617783 617783 Larder, Andrew, of Northweld Bassett, gent 0
4206549 2097838 2097838 defendant Allatt Thomas yeoman 617783 617783 Allatt, Thomas, of Northweld Bassett, yeoman 1
4206550 2097838 2097838 defendant Poole Thomas tailor 617783 617783 Poole, Thomas, of Northweld Bassett, tailor 2
4206552 2097838 2097838 defendant Freeman William laborer 617783 617783 Freeman, William, of Northweld Bassett, laborer 4
4206554 2097839 2097839 defendant Ramsey Thomas joiner 617783 617783 Ramsey, Thomas, of Northweld Bassett, joiner 0
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
4206569 2097839 2097839 defendant Morrell William laborer 617783 617783 Morrell, William, of Northweld Bassett, laborer 15
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
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);