names

21 rows where place_id = 602777

✎ 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
3651745 1910899 1910899 plaintiff Taylour John husbandman 602777 602777 Taylour, John, of Smalley, husbandman 0
4271161 2119929 2119929 defendant Bridges Richard yeoman 602777 602777 Bridges, Richard, of Smalley, yeoman 1
4332414 2141132 2141132 defendant Foster John yeoman 602777 602777 Foster, John, of Smalley, yeoman 0
4586177 2227101 2227101 plaintiff Henryson Thomas   602777 602777 Henryson, Thomas, of Smalley 0
4713388 2269511 2269511 defendant Rogerson John husbandman 602777 602777 Rogerson, John, of Smalley, husbandman 1
4739199 2277354 2277354 defendant Catyr Roger husbandman 602777 602777 Catyr, Roger, of Smalley, husbandman 3
4739200 2277354 2277354 defendant Vener William husbandman 602777 602777 Vener, William, of Smalley, husbandman 4
4980152 2351014 2351014 defendant Jacson Thomas yeoman 602777 602777 Jacson, Thomas, of Smalley, yeoman 1
5132015 2395851 2395851 defendant Pyncheware John   602777 602777 Pyncheware, John, of Smalley, wright 1
5151604 2401624 2401624 defendant Pyncheware John   602777 602777 Pyncheware, John, of Smalley, wright 1
5169714 2406882 2406882 defendant Pyncheware John   602777 602777 Pyncheware, John, of Smalley, wright 1
5185919 2411629 2411629 defendant Pyncheware John   602777 602777 Pyncheware, John, of Smalley, wright 1
5287941 2441487 2441487 defendant Grensmyth Joan widow 602777 602777 Grensmyth, Joan, of Smalley, widow 1
5287945 2441488 2441488 defendant Grensmyth Joan widow 602777 602777 Grensmyth, Joan, of Smalley, widow 1
5319399 2450894 2450894 plaintiff Hayward Thomas   602777 602777 Hayward, Thomas, of Smalley 0
5319400 2450894 2450894 defendant Lee Lawrence husbandman 602777 602777 Lee, Lawrence, of Smalley, husbandman 0
5319401 2450894 2450894 defendant Lee John laborer 602777 602777 Lee, John, of Smalley, laborer 1
5636020 2555222 2555222 defendant Cartir Roger husbandman 602777 602777 Cartir, Roger, of Smalley, husbandman 0
5636021 2555222 2555222 defendant Warner William husbandman 602777 602777 Warner, William, of Smalley, husbandman 1
5636610 2555395 2555395 defendant Castir Roger husbandman 602777 602777 Castir, Roger, of Smalley, husbandman 0
5636611 2555395 2555395 defendant Warner William husbandman 602777 602777 Warner, William, of Smalley, husbandman 1

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