names

31 rows where place_id = 613004

✎ 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
3696046 1924997 1924997 defendant Lister Richard gent 613004 613004 Lister, Richard, of Massam, gent 2
3767716 1947539 1947539 defendant Doddesworth Peter gent 613004 613004 Doddesworth, Peter, of Massam, gent 3
3788720 1954275 1954275 defendant Deddesworth Peter gent 613004 613004 Deddesworth, Peter, of Massam, gent 2
3791613 1955217 1955217 defendant Hardyngton Miles cooper 613004 613004 Hardyngton, Miles, of Massam, cooper 0
3791614 1955217 1955217 defendant Hardyngton Christopher cooper 613004 613004 Hardyngton, Christopher, of Massam, cooper 1
3899441 1990026 1990026 defendant Horseman Leonard clerk 613004 613004 Horseman, Leonard, of Massam, clerk 4
3913371 1994808 1994808 defendant Lyster Richard gent 613004 613004 Lyster, Richard, of Massam, gent 0
4037183 2037959 2037959 plaintiff Johnson John (legal representative) 613004 613004 Johnson, John, of Massam, executor of 0
4215154 2100797 2100797 defendant Johnson Brian husbandman 613004 613004 Johnson, Brian, of Massam, husbandman 3
4250681 2113207 2113207 defendant Johnson Brian yeoman 613004 613004 Johnson, Brian, of Massam, yeoman 3
4309718 2133555 2133555 defendant Danby Marmaduke gent 613004 613004 Danby, Marmaduke, of Massam, gent 3
4353598 2148482 2148482 defendant Beckwith Thomas yeoman 613004 613004 Beckwith, Thomas, of Massam, yeoman 0
4359813 2150672 2150672 defendant Smirthwaite Thomas butcher 613004 613004 Smirthwaite, Thomas, of Massam, butcher 0
4383835 2159298 2159298 defendant Peckett William yeoman 613004 613004 Peckett, William, of Massam, yeoman 0
4383837 2159298 2159298 defendant Wells Agnes widow 613004 613004 (Wells, Agnes, of Massam, widow 2
4383838 2159298 2159298 defendant Chatter Ralph yeoman 613004 613004 Chatter, Ralph, of Massam, yeoman 3
4403083 2165612 2165612 defendant Johnson Thomas yeoman 613004 613004 Johnson, Thomas, of Massam, yeoman 3
4407738 2167151 2167151 defendant Mitchell John chapman 613004 613004 Mitchell, John, of Massam, chapman 1
4532534 2210441 2210441 defendant Lescrop Stephen   613004 613004 Lescrop, Stephen, of Massam, knight 0
4532536 2210442 2210442 defendant Lescrop Stephen   613004 613004 Lescrop, Stephen, of Massam, knight 0
4959891 2344920 2344920 defendant Parcour Giles yeoman 613004 613004 Parcour, Giles, of Massam, yeoman 2
5035656 2367285 2367285 defendant Flesshewer Hugh butcher 613004 613004 Flesshewer, Hugh, of Massam, butcher 1
5035657 2367285 2367285 defendant Hecok Ralph yeoman 613004 613004 Hecok, Ralph, of Massam, yeoman 2
5035658 2367285 2367285 defendant Mendfante or Mendfaute William yeoman 613004 613004 Mendfante or Mendfaute, William, of Massam, yeoman 3
5035659 2367285 2367285 defendant Wryght William yeoman 613004 613004 Wryght, William, of Massam, yeoman 4
5035660 2367285 2367285 defendant Fytheley Thomas husbandman 613004 613004 Fytheley, Thomas, of Massam, husbandman 5
5305481 2446641 2446641 plaintiff Lescrop Thomas   613004 613004 Lescrop, Thomas, of Massam, knight 0
5305483 2446642 2446642 plaintiff Lescrop Thomas   613004 613004 Lescrop, Thomas, of Massam, knight & lord 0
5319784 2451009 2451009 defendant Lytster Richard gent 613004 613004 Lytster, Richard, of Massam, gent 0
5321189 2451435 2451435 plaintiff Lescrop Thomas   613004 613004 Lescrop, Thomas, of Massam, knight 0
5590006 2531860 2531860 defendant Staveley Henry gent 613004 613004 Staveley, Henry, of Massam, gent 2

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