names

19 rows where place_id = 663254

✎ 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
3968158 2013490 2013490 defendant Lewes Thomas husbandman 663254 663254 Lewes, Thomas, of Rockland, husbandman 1
4023588 2033146 2033146 defendant Critewood Thomas yeoman 663254 663254 Critewood, Thomas, of Rockland, yeoman 0
4031163 2035816 2035816 defendant Davye John husbandman 663254 663254 Davye, John, of Rockland, husbandman 3
4044935 2040643 2040643 defendant Davye John husbandman 663254 663254 Davye, John, of Rockland, husbandman 0
4048940 2042062 2042062 defendant Pulleyn Richard clerk 663254 663254 Pulleyn, Richard, of Rockland, clerk 0
4048941 2042062 2042062 defendant Davy John yeoman 663254 663254 Davy, John, of Rockland, yeoman 1
4060662 2046215 2046215 defendant Ayers Robert carpenter 663254 663254 Ayers, Robert, of Rockland, carpenter 2
4129207 2070748 2070748 defendant Ayers Robert carpenter 663254 663254 Ayers, Robert, of Rockland, carpenter 0
4213454 2100224 2100224 defendant Dowe Robert husbandman 663254 663254 Dowe, Robert, of Rockland, husbandman 0
4217733 2101691 2101691 defendant Springold Richard yeoman 663254 663254 Springold, Richard, of Rockland, or of Hackford, yeoman 0
4223894 2103843 2103843 defendant Rockewood William gent 663254 663254 Rockewood, William, of Rockland, gent 2
4259575 2116179 2116179 defendant Davy John husbandman 663254 663254 Davy, John, of Rockland, husbandman 0
4259576 2116179 2116179 defendant Hudson John   663254 663254 Hudson, John, of Rockland, brick maker 1
4265133 2117978 2117978 defendant Rockwood William gent 663254 663254 Rockwood, William, of Rockland, gent 0
4323811 2138375 2138375 defendant Hasell Christopher yeoman 663254 663254 Hasell, Christopher, of Rockland, yeoman 2
4334581 2141837 2141837 defendant Ogers John yeoman 663254 663254 Ogers, John, of Rockland, yeoman 1
4382728 2158929 2158929 defendant Skeppe Roger yeoman 663254 663254 Skeppe, Roger, of Rockland, yeoman 2
4395414 2163049 2163049 plaintiff Harrold Robert   663254 663254 Harrold, Robert, of Rockland, "boller" 0
4410753 2168186 2168186 defendant Miller Thomas   663254 663254 Miller, Thomas, of Rockland, shepherd 3

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