names

15 rows where case_id = 2345498

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4961836 2345498 2345498 plaintiff Boynton Christopher     Boynton, Christopher 0
4961837 2345498 2345498 defendant Taillour John husbandman 779600 779600 Taillour, John, of Ronceby, husbandman 0
4961838 2345498 2345498 defendant Taillour William husbandman 779600 779600 Taillour, William, of Ronceby, husbandman 1
4961839 2345498 2345498 defendant Porret William husbandman 827824 827824 Porret, William, of Seton juxta Ronceby, husbandman 2
4961840 2345498 2345498 defendant Tomson William husbandman 827825 827825 Tomson, William, of la Dalehous juxta Bolby, husbandman 3
4961841 2345498 2345498 defendant Keverhugh or Kenerhugh Thomas husbandman 827826 827826 Keverhugh or Kenerhugh, Thomas, of Kyrkle Neuton, husbandman 4
4961842 2345498 2345498 defendant Stephenson John husbandman 827826 827826 Stephenson, John, of Kyrkle Neuton, husbandman 5
4961843 2345498 2345498 defendant Robynson William husbandman 827826 827826 Robynson, William, of Kyrkle Neuton, husbandman 6
4961844 2345498 2345498 defendant Sherewode John husbandman 827827 827827 Sherewode, John, of Kyrkele Thom, husbandman 7
4961845 2345498 2345498 defendant Wodde John husbandman 595315 595315 Wodde, John, of Ormesby, husbandman 8
4961846 2345498 2345498 defendant Megote William husbandman 595315 595315 Megote, William, of Ormesby, husbandman 9
4961847 2345498 2345498 defendant Robynson William husbandman 827828 827828 Robynson, William, of Eppilby, husbandman 10
4961848 2345498 2345498 defendant Frere Robert husbandman 827829 827829 Frere, Robert, of Skytheby, husbandman 11
4961849 2345498 2345498 defendant Walker John husbandman 776577 776577 Walker, John, of Layburn, husbandman 12
4961850 2345498 2345498 defendant Bullok Robert husbandman 827830 827830 Bullok, Robert, of Pynchonthorp, 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);