names

18 rows where place_id = 609551

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3678981 1919496 1919496 defendant Toly Thomas tilemaker 609551 609551 Toly, Thomas, of Huchyn, Herts, tilemaker 1
3680601 1920013 1920013 defendant Barker John yeoman 609551 609551 Barker, John, of Huchyn, Herts, yeoman 0
3794654 1956204 1956204 defendant Blok Richard butcher 609551 609551 Blok, Richard, of Huchyn, Herts, butcher 3
3847038 1972621 1972621 defendant Smyth John yeoman 609551 609551 Smyth, John, of Huchyn, Herts, yeoman 0
3847040 1972622 1972622 defendant Smyth John yeoman 609551 609551 Smyth, John, of Huchyn, Herts, yeoman 0
4525175 2208214 2208214 defendant Barbour Thomas fisher 609551 609551 Barbour, Thomas, of Huchyn, Herts, fisher 1
4639928 2243186 2243186 defendant Catworthe William   609551 609551 Catworthe, William, of Huchyn, Herts 0
4665143 2250580 2250580 defendant Coterell Luke husbandman 609551 609551 Coterell, Luke, of Huchyn, Herts, husbandman 0
4665146 2250581 2250581 defendant Coterell Luke husbandman 609551 609551 Coterell, Luke, of Huchyn, Herts, husbandman 0
4948716 2341581 2341581 defendant Besteney Richard husbandman 609551 609551 Besteney, Richard, of Huchyn, Herts, husbandman 0
4977531 2350244 2350244 plaintiff Pulter John draper 609551 609551 Pulter, John, of Huchyn, Herts, draper 0
5003365 2357882 2357882 defendant Tablere Simon shoemaker 609551 609551 Tablere, Simon, of Huchyn, Herts, shoemaker 2
5003369 2357883 2357883 defendant Tablere Simon shoemaker 609551 609551 Tablere, Simon, of Huchyn, Herts, shoemaker 2
5200789 2415991 2415991 defendant Spegon John yeoman 609551 609551 Spegon, John, of Huchyn, Herts, yeoman 0
5263993 2434499 2434499 plaintiff Pulter John gent 609551 609551 Pulter, John, of Huchyn, Herts, gent 1
5263997 2434500 2434500 plaintiff Pulter John gent 609551 609551 Pulter, John, of Huchyn, Herts, gent 1
5429163 2483651 2483651 defendant Baker Nicholas fuller 609551 609551 Baker, Nicholas, of Huchyn, Herts, fuller 1
5466986 2495073 2495073 defendant Clerk Lewis dyer 609551 609551 Clerk, Lewis, of Huchyn, Herts, dyer 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);