names

26 rows where place_id = 708618

✎ 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
4174001 2086361 2086361 defendant Hobdaye William husbandman 708618 708618 Hobdaye, William, of Eastbourne, husbandman 0
4174002 2086361 2086361 defendant Livered Richard husbandman 708618 708618 Livered, Richard, of Eastbourne, husbandman 1
4353681 2148507 2148507 defendant Vernon John yeoman 708618 708618 Vernon, John, of Eastbourne, yeoman 0
4361634 2151322 2151322 defendant Pepper William husbandman 708618 708618 Pepper, William, of Eastbourne, husbandman 0
4478333 2193900 2193900 defendant Bedell Thomas   708618 708618 Bedell, Thomas, of Eastbourne 0
4543941 2214011 2214011 defendant Sparwe Richard   708618 708618 Sparwe, Richard, of Eastbourne 0
4559311 2218863 2218863 defendant Hone Thomas   708618 708618 Hone, Thomas, of Eastbourne 0
4561887 2219651 2219651 defendant Tayllour William   708618 708618 Tayllour, William, of Eastbourne 0
4618269 2236723 2236723 defendant Glovere Walter   708618 708618 Glovere, Walter, of Eastbourne 0
4692930 2263297 2263297 defendant Bien John laborer 708618 708618 Bien, John, of Eastbourne, laborer 0
4693770 2263553 2263553 defendant Lyvet Richard gent 708618 708618 Lyvet, Richard, of Eastbourne, gent 0
4693772 2263554 2263554 defendant Lyvet Richard gent 708618 708618 Lyvet, Richard, of Eastbourne, gent 0
4696800 2264478 2264478 defendant Chaumberleyn John husbandman 708618 708618 Chaumberleyn, John, of Eastbourne, husbandman 0
4698782 2265100 2265100 defendant Crowemale Roger husbandman 708618 708618 Crowemale, Roger, of Eastbourne, husbandman 2
4701237 2265787 2265787 defendant Gardener John butcher 708618 708618 Gardener, John, of Eastbourne, butcher 0
4711465 2268916 2268916 defendant Caperon Thomas husbandman 708618 708618 Caperon, Thomas, of Eastbourne, husbandman 0
4718404 2271094 2271094 defendant Eylove John husbandman 708618 708618 Eylove, John, of Eastbourne, husbandman 0
4737871 2276948 2276948 defendant Aylove John husbandman 708618 708618 Aylove, John, of Eastbourne, husbandman 0
4737872 2276948 2276948 defendant Bernfeld Robert husbandman 708618 708618 Bernfeld, Robert, of Eastbourne, husbandman 1
4741416 2277984 2277984 defendant Eylone John yeoman 708618 708618 Eylone, John, of Eastbourne, yeoman 3
4775953 2288481 2288481 defendant Eylove John husbandman 708618 708618 Eylove, John, of Eastbourne, husbandman 4
4821357 2302762 2302762 defendant Hasty William shipman 708618 708618 Hasty, William, of Eastbourne, shipman 2
4842461 2309177 2309177 defendant Downe William husbandman 708618 708618 Downe, William, of Eastbourne, husbandman 1
4993850 2355033 2355033 defendant Colyere Richard husbandman 708618 708618 Colyere, Richard, of Eastbourne, husbandman 0
5274455 2437607 2437607 defendant Mewe Thomas husbandman 708618 708618 Mewe, Thomas, of Eastbourne, husbandman 0
5616214 2548864 2548864 defendant Wodelond Richard   708618 708618 Wodelond, Richard, of Eastbourne 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);