names

25 rows where case_id = 1864770

✎ 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
3590832 1864770 1864770 plaintiff Danby Christopher esq   Danby, Christopher, esq 0
3590833 1864770 1864770 defendant Londysdale John taverner 586067 586067 Londysdale, John, of York, taverner 0
3590834 1864770 1864770 defendant Hogeson Stephen   586067 586067 Hogeson, Stephen, of York, mattress maker 1
3590835 1864770 1864770 defendant Wylson Richard   586067 586067 Wylson, Richard, of York, parchment maker 2
3590836 1864770 1864770 defendant Smyth Thomas tailor 586067 586067 Smyth, Thomas, of York, tailor 3
3590837 1864770 1864770 defendant Atkynson Robert walker 586067 586067 Atkynson, Robert, of York, walker 4
3590838 1864770 1864770 defendant Bacon John cooper 586067 586067 Bacon, John, of York, cooper 5
3590839 1864770 1864770 defendant Sherowe Roger miller 586067 586067 Sherowe, Roger, of York, miller 6
3590840 1864770 1864770 defendant Hunter Thomas tiler 586067 586067 Hunter, Thomas, of York, tiler 7
3590841 1864770 1864770 defendant Lax Thomas walker 586067 586067 Lax, Thomas, of York, walker 8
3590842 1864770 1864770 defendant Breten John sherman 586067 586067 Breten, John, of York, sherman 9
3590843 1864770 1864770 defendant Huchenson John baker 586067 586067 Huchenson, John, of York, baker 10
3590844 1864770 1864770 defendant Bell John   586067 586067 Bell, John, of York, wright 11
3590845 1864770 1864770 defendant Teleson John currier 586067 586067 Teleson, John, of York, currier 12
3590846 1864770 1864770 defendant Larom Thomas   586067 586067 Larom, Thomas, of York, card maker 13
3590847 1864770 1864770 defendant Yonson John tailor 586067 586067 Yonson, John, of York, tailor 14
3590848 1864770 1864770 defendant Gybbys Thomas weaver 586067 586067 Gybbys, Thomas, of York, weaver 15
3590849 1864770 1864770 defendant Anderson Thomas miller 586067 586067 Anderson, Thomas, of York, miller 16
3590850 1864770 1864770 defendant Burton John miller 586067 586067 Burton, John, of York, miller 17
3590851 1864770 1864770 defendant Parot Peter baker 586067 586067 Parot, Peter, of York, baker 18
3590852 1864770 1864770 defendant Herryson John shoemaker 586067 586067 Herryson, John, of York, shoemaker 19
3590853 1864770 1864770 defendant Topshawe Thomas saddler 586067 586067 Topshawe, Thomas, of York, saddler 20
3590854 1864770 1864770 defendant Fere John tailor 586067 586067 Fere, John, of York, tailor 21
3590855 1864770 1864770 defendant Barbour Henry barber 586067 586067 Barbour, Henry, of York, barber 22
3590856 1864770 1864770 defendant Robynson William shoemaker 586067 586067 Robynson, William, of York, shoemaker 23

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