names

37 rows where place_id = 595209

✎ 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
3619414 1873649 1873649 defendant Hawekyn Walter husbandman 595209 595209 Hawekyn, Walter, of Bernham, husbandman 0
3619416 1873649 1873649 defendant Halyday John husbandman 595209 595209 Halyday, John, of Bernham, husbandman 2
3661752 1913957 1913957 defendant Skaysse Ralph chaplain 595209 595209 Skaysse, Ralph, of Bernham, chaplain 0
4504938 2202085 2202085 defendant Wolnard John   595209 595209 Wolnard, John, of Bernham, vicar 0
4525413 2208285 2208285 defendant Bosard Bartholomew   595209 595209 Bosard, Bartholomew, of Bernham 1
4553487 2217019 2217019 defendant Gelham John   595209 595209 Gelham, John, of Bernham 0
4553489 2217020 2217020 defendant Gelham John   595209 595209 Gelham, John, of Bernham 0
4614359 2235500 2235500 defendant Brytyeve Thomas   595209 595209 Brytyeve, Thomas, of Bernham 4
4690356 2262541 2262541 defendant Bryghteve Thomas gent 595209 595209 Bryghteve, Thomas, of Bernham, gent 0
4726949 2273695 2273695 defendant Roger John yeoman 595209 595209 Roger, John, of Bernham, yeoman 0
4756993 2282558 2282558 defendant Gardyner Alan   595209 595209 Gardyner, Alan, of Bernham, wright 2
4762096 2284129 2284129 defendant Caton John   595209 595209 Caton, John, of Bernham 5
4798901 2295831 2295831 defendant Massanger Simon yeoman 595209 595209 Massanger, Simon, of Bernham, yeoman 2
4819320 2302119 2302119 defendant Grogeman John husbandman 595209 595209 Grogeman, John, of Bernham, husbandman 2
4884145 2321949 2321949 defendant atte Lee John husbandman 595209 595209 atte Lee, John, of Bernham, husbandman 0
4892611 2324418 2324418 defendant atte Lee John husbandman 595209 595209 atte Lee, John, of Bernham, husbandman 0
4906411 2328593 2328593 defendant Gruggeman John yeoman 595209 595209 Gruggeman, John, of Bernham, yeoman 0
4946272 2340821 2340821 defendant Anderkyn John   595209 595209 Anderkyn, John, of Bernham, bailiff 3
4947401 2341182 2341182 defendant Cokyll Henry yeoman 595209 595209 Cokyll, Henry, of Bernham, yeoman 2
4959750 2344878 2344878 defendant Pope Geoffrey chaplain 595209 595209 Pope, Geoffrey, of Bernham, chaplain 0
4964692 2346347 2346347 defendant Palmere William husbandman 595209 595209 Palmere, William, of Bernham, husbandman 0
4992837 2354738 2354738 defendant atte Cherche John yeoman 595209 595209 atte Cherche, John, of Bernham, yeoman 2
5008431 2359356 2359356 plaintiff Symond John (legal representative) 595209 595209 Symond, John, of Bernham, executor of 0
5034988 2367093 2367093 plaintiff Symond John (legal representative) 595209 595209 Symond, John, of Bernham, husbandman, executor of 0
5059742 2374477 2374477 plaintiff Exton Henry (legal representative) 595209 595209 Exton, Henry, of Bernham, executrix of 0
5117499 2391550 2391550 plaintiff Pope Geoffrey (legal representative) 595209 595209 Pope, Geoffrey, of Bernham, chaplain, executor of 0
5141959 2398767 2398767 defendant Constable Robert husbandman 595209 595209 Constable, Robert, of Bernham, husbandman 0
5200857 2416013 2416013 defendant Bonyng Peter husbandman 595209 595209 Bonyng, Peter, of Bernham, husbandman 1
5370527 2466366 2466366 defendant Herberd John husbandman 595209 595209 Herberd, John, of Bernham, husbandman 0
5372354 2466948 2466948 defendant Herbert John yeoman 595209 595209 Herbert, John, of Bernham, yeoman 0
5376675 2468299 2468299 defendant Herberd John husbandman 595209 595209 Herberd, John, of Bernham, husbandman 0
5511794 2508542 2508542 defendant Fraunceys George husbandman 595209 595209 Fraunceys, George, of Bernham, husbandman 0
5511795 2508542 2508542 defendant Tebald Roger husbandman 595209 595209 Tebald, Roger, of Bernham, husbandman 1
5580212 2528896 2528896 defendant Fuller John, junior yeoman 595209 595209 Fuller, John, junior, of Bernham, yeoman 0
5581316 2529227 2529227 defendant Lawnse William   595209 595209 Lawnse, William, of Bernham, shepherd, 2
5614577 2548357 2548357 defendant toftes Robert de   595209 595209 #toftes, Robert de, of Bernham, shepherd 0
5636089 2555244 2555244 defendant Lydecok William draper 595209 595209 Lydecok, William, of Bernham, draper 4

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