names

15 rows where case_id = 2401778

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5152187 2401778 2401778 plaintiff Haunsert Richard     Haunsert, Richard 0
5152188 2401778 2401778 defendant Lyndesey William syvyer or seive maker 593375 593375 Lyndesey, William, of Tenelby, syvyer or seive maker 0
5152189 2401778 2401778 defendant Gretan William husbandman 586299 586299 Gretan, William, of Barowe, husbandman 1
5152190 2401778 2401778 defendant Sygworth William husbandman 604202 604202 Sygworth, William, of Cadney, husbandman 2
5152191 2401778 2401778 defendant Grene Henry husbandman 776027 776027 Grene, Henry, of Howesom, husbandman 3
5152192 2401778 2401778 defendant Kelsterne Stephen husbandman 604202 604202 Kelsterne, Stephen, of Cadney, husbandman 4
5152193 2401778 2401778 defendant Fayrebarn Thomas husbandman 604202 604202 Fayrebarn, Thomas, of Cadney, husbandman 5
5152194 2401778 2401778 defendant Nevyll Richard husbandman 604202 604202 Nevyll, Richard, of Cadney, husbandman 6
5152195 2401778 2401778 defendant Wright William husbandman 604202 604202 Wright, William, of Cadney, husbandman 7
5152196 2401778 2401778 defendant Wryght Thomas husbandman 604202 604202 Wryght, Thomas, of Cadney, husbandman 8
5152197 2401778 2401778 defendant Kysynge John merchant 589461 589461 Kysynge, John, of Louthe, merchant 9
5152198 2401778 2401778 defendant Ousteby John husbandman 853660 853660 Ousteby, John, of Castyr, husbandman 10
5152199 2401778 2401778 defendant Cristian William   853661 853661 Cristian, William, of Cokewolde, vicar 11
5152200 2401778 2401778 defendant Odlyn Robert husbandman 853661 853661 Odlyn, Robert, of Cokewolde, husbandman 12
5152201 2401778 2401778 defendant Codlynge William husbandman 853663 853663 Codlynge, William, of Cokewodle, husbandman 13

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