names

27 rows where place_id = 603146

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3653573 1911386 1911386 defendant Gayton Edmund husbandman 603146 603146 Gayton, Edmund, of Magna Hale, husbandman 1
3676210 1918605 1918605 defendant Smythe William husbandman 603146 603146 Smythe, William, of Magna Hale, husbandman 0
3676211 1918605 1918605 defendant Magelyn William gent 603146 603146 Magelyn, William, of Magna Hale, gent 1
3676212 1918605 1918605 defendant Smythe Robert husbandman 603146 603146 Smythe, Robert, of Magna Hale, husbandman 2
3784223 1952853 1952853 defendant Chamberleyn Thomas husbandman 603146 603146 Chamberleyn, Thomas, of Magna Hale, husbandman 1
3792911 1955636 1955636 defendant Palmer Thomas (legal representative) 603146 603146 Palmer, Thomas, of Magna Hale, executor of 0
3809595 1960888 1960888 defendant Palmer Thomas (legal representative) 603146 603146 Palmer, Thomas, of Magna Hale, executor of 0
3828130 1966666 1966666 defendant Skathe Thomas husbandman 603146 603146 Skathe, Thomas, of Magna Hale, husbandman 0
3950612 2007285 2007285 defendant Garwell Bartholomew yeoman 603146 603146 Garwell, Bartholomew, of Magna Hale, yeoman 0
3950615 2007286 2007286 defendant Tenant William laborer 603146 603146 Tenant, William, of Magna Hale, laborer 1
3998849 2024344 2024344 defendant Garwell John yeoman 603146 603146 Garwell, John, of Magna Hale, yeoman 0
3999784 2024683 2024683 plaintiff Garwell John husbandman 603146 603146 Garwell, John, of Magna Hale, husbandman 0
4063236 2047145 2047145 plaintiff Garwell John yeoman 603146 603146 Garwell, John, of Magna Hale, yeoman 0
4094858 2058493 2058493 defendant Garwall Bartholomew yeoman 603146 603146 Garwall, Bartholomew, of Magna Hale, yeoman 0
4127124 2069989 2069989 defendant Bennit Christopher husbandman 603146 603146 Bennit, Christopher, of Magna Hale, husbandman 0
4127125 2069989 2069989 defendant Bennit John   603146 603146 Bennit, John, of Magna Hale, husbandman, his son 1
4242668 2110538 2110538 defendant Greene Bartholomew yeoman 603146 603146 Greene, Bartholomew, of Magna Hale, yeoman 2
4252524 2113835 2113835 defendant Garwell Bartholomew yeoman 603146 603146 Garwell, Bartholomew, of Magna Hale, yeoman 2
4283554 2124156 2124156 defendant Gerwell Thomas yeoman 603146 603146 Gerwell, Thomas, of Magna Hale, yeoman 0
4285193 2124754 2124754 defendant Garwell John yeoman 603146 603146 Garwell, John, of Magna Hale, yeoman 0
4292181 2127275 2127275 defendant Garwell William yeoman 603146 603146 Garwell, William, of Magna Hale, yeoman 0
4312737 2134586 2134586 defendant Browne Robert clerk 603146 603146 Browne, Robert, of Magna Hale, clerk 0
5113761 2390419 2390419 defendant Claymonde John chaplain 603146 603146 Claymonde, John, of Magna Hale, chaplain 0
5329858 2453998 2453998 defendant Croke Thomas husbandman 603146 603146 Croke, Thomas, of Magna Hale, husbandman 1
5343168 2458054 2458054 plaintiff Snaynton William husbandman 603146 603146 Snaynton, William, of Magna Hale, husbandman 0
5343169 2458054 2458054 plaintiff Grymysby John   603146 603146 Grymysby, John, of Magna Hale 1
5604993 2536431 2536431 defendant Smyth Robert husbandman 603146 603146 Smyth, Robert, of Magna Hale, 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);