names

40 rows where place_id = 586491

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588858 1864166 1864166 defendant Smychurst Geoffrey chapman 586491 586491 Smychurst, Geoffrey, of Depyng, Lincs, chapman 0
3588864 1864167 1864167 defendant Smythurst Geoffrey chapman 586491 586491 Smythurst, Geoffrey, of Depyng, Lincs, chapman 0
3665287 1915096 1915096 defendant Wake Thomas gent 586491 586491 Wake, Thomas, of Depyng, Lincs, gent 0
3740086 1938756 1938756 defendant Wake Thomas gent 586491 586491 Wake, Thomas, of Depyng, Lincs, gent 0
3740088 1938757 1938757 defendant Wake Thomas gent 586491 586491 Wake, Thomas, of Depyng, Lincs, gent 0
3848726 1973187 1973187 defendant Catlyn Thomas chapman 586491 586491 Catlyn, Thomas, of Depyng, Lincs, chapman 2
3883347 1984695 1984695 defendant Catlyn Robert merchant of the staple 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant of the staple 2
3911214 1994076 1994076 defendant Catlyn Robert merchant or the staple 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant or the staple 0
3911217 1994077 1994077 defendant Catlyn Robert merchant or the staple 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant or the staple 0
3911257 1994085 1994085 defendant Catlyn Robert merchant 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant 4
3911265 1994086 1994086 defendant Catlyn Robert merchant 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant 4
3924955 1998663 1998663 defendant Catlyn Robert merchant of the staple 586491 586491 Catlyn, Robert, of Depyng, Lincs, merchant of the staple 5
3983290 2018795 2018795 defendant Ramshawe James (legal representative) 586491 586491 Ramshawe, James, of Depyng, Lincs, executor of 0
3983293 2018796 2018796 defendant Ramshawe or Rainshawe James (legal representative) 586491 586491 Ramshawe or Rainshawe, James, of Depyng, Lincs, executor of 0
4025359 2033731 2033731 defendant Turner William chapman 586491 586491 Turner, William, of Depyng, Lincs, chapman 0
4025570 2033802 2033802 defendant Turnor William chapman 586491 586491 Turnor, William, of Depyng, Lincs, chapman 0
4699808 2265386 2265386 defendant Dryvere John drover 586491 586491 Dryvere, John, of Depyng, Lincs, drover 1
4743907 2278745 2278745 defendant Croukere Robert milner 586491 586491 Croukere, Robert, of Depyng, Lincs, milner 1
4764345 2284844 2284844 defendant Dereyere John fishmonger 586491 586491 Dereyere, John, of Depyng, Lincs, fishmonger 2
4873497 2318669 2318669 defendant Tollard William husbandman 586491 586491 Tollard, William, of Depyng, Lincs, husbandman 1
4873500 2318669 2318669 defendant Jorle Thomas husbandman 586491 586491 Jorle, Thomas, of Depyng, Lincs, husbandman 4
4873527 2318672 2318672 defendant Jorle Thomas husbandman 586491 586491 Jorle, Thomas, of Depyng, Lincs, husbandman 1
4905515 2328324 2328324 defendant Smyth John   586491 586491 Smyth, John, of Depyng, Lincs, mason 0
4913568 2330740 2330740 defendant Dorney John chapman 586491 586491 Dorney, John, of Depyng, Lincs, chapman 1
4946452 2340886 2340886 defendant Thorp alias Flexman Thomas   586491 586491 Thorp alias Flexman, Thomas, of Depyng, Lincs, husbandman, dwelling in Hakford 0
4972323 2348662 2348662 defendant Thorp alias Flaxman Thomas   586491 586491 Thorp alias Flaxman, Thomas, of Depyng, Lincs, chapman, dwelling in Hacford 0
4974468 2349325 2349325 defendant Lytster John dyer 586491 586491 Lytster, John, of Depyng, Lincs, dyer 0
5008998 2359523 2359523 defendant Hareby Simon gent 586491 586491 Hareby, Simon, of Depyng, Lincs, gent 2
5009008 2359524 2359524 defendant Hareby S_ gent 586491 586491 Hareby, S_, of Depyng, Lincs, gent 2
5033392 2366646 2366646 defendant Kyde William husbandman 586491 586491 Kyde, William, of Depyng, Lincs, or of Peterburgh, Nhants, husbandman 0
5033430 2366659 2366659 defendant Kyde William husbandman 586491 586491 Kyde, William, of Depyng, Lincs, or of Petirburgh, husbandman 0
5222920 2422418 2422418 defendant Gryndell William clerk 586491 586491 Gryndell, William, of Depyng, Lincs, clerk 0
5391869 2472750 2472750 defendant Smyth William   586491 586491 Smyth, William, of Depyng, Lincs, free mason 2
5393937 2473325 2473325 defendant Tego Stephen draper 586491 586491 Tego, Stephen, of Depyng, Lincs, draper 1
5406780 2477004 2477004 defendant Tego Stephen draper 586491 586491 Tego, Stephen, of Depyng, Lincs, draper 1
5406783 2477005 2477005 defendant Tego Stephen draper 586491 586491 Tego, Stephen, of Depyng, Lincs, draper 1
5417978 2480303 2480303 defendant Smyth William   586491 586491 Smyth, William, of Depyng, Lincs, free mason 2
5419955 2480884 2480884 defendant Tego Stephen draper 586491 586491 Tego, Stephen, of Depyng, Lincs, draper 1
5554522 2521357 2521357 defendant Wiche Stephen chapman 586491 586491 Wiche, Stephen, of Depyng, Lincs, chapman 1
5623713 2551354 2551354 defendant Dereyere John fisher 586491 586491 Dereyere, John, of Depyng, Lincs, fisher 0

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