names

21 rows where case_id = 2418312

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5208834 2418312 2418312 plaintiff Ramsey John abbot of the moanstery of the BM, in   Ramsey, John, abbot of the moanstery of the BM, in 0
5208835 2418312 2418312 defendant Donhed Thomas fishmonger   Donhed, Thomas, fishmonger 0
5208836 2418312 2418312 defendant Roppesle John yeoman   Roppesle, John, yeoman 1
5208837 2418312 2418312 defendant Moygne William jun, yeoman   Moygne, William, jun, yeoman 2
5208838 2418312 2418312 defendant Mystrechaumbre John gent 757020 757020 Mystrechaumbre, John, of Gormechestre, gent 3
5208839 2418312 2418312 defendant Congerton William draper   Congerton, William, draper 4
5208840 2418312 2418312 defendant Ardyngton Robert draper   Ardyngton, Robert, draper 5
5208841 2418312 2418312 defendant Squyer Richard butcher   Squyer, Richard, butcher 6
5208842 2418312 2418312 defendant Bailly John yeoman   Bailly, John, yeoman 7
5208843 2418312 2418312 defendant Barbour George barber   Barbour, George, barber 8
5208844 2418312 2418312 defendant Geyte John shoemaker   Geyte, John, shoemaker 9
5208845 2418312 2418312 defendant Meryell John weaver   Meryell, John, weaver 10
5208846 2418312 2418312 defendant Skynner John yeoman   Skynner, John, yeoman 11
5208847 2418312 2418312 defendant Nowell Hubert mercer   Nowell, Hubert, mercer 12
5208848 2418312 2418312 defendant Bayes John husbandman   Bayes, John, husbandman 13
5208849 2418312 2418312 defendant Tully Thomas thatcher   Tully, Thomas, thatcher 14
5208850 2418312 2418312 defendant Arneburgh John merchant   Arneburgh, John, merchant 15
5208851 2418312 2418312 defendant Broughton John weaver   Broughton, John, weaver 16
5208852 2418312 2418312 defendant Goodewyn William husbandman   Goodewyn, William, husbandman 17
5208853 2418312 2418312 defendant Wattes John sadler   Wattes, John, sadler 18
5208854 2418312 2418312 defendant Cony Robert husbandman   Cony, Robert, husbandman 19

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