names

42 rows where place_id = 619287

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3729095 1935350 1935350 defendant Yong Reginald tinker 619287 619287 Yong, Reginald, of North Merston, tinker 0
3729096 1935350 1935350 defendant Yong William tinker 619287 619287 Yong, William, of North Merston, tinker 1
3815514 1962768 1962768 defendant Carter Thomas yeoman 619287 619287 Carter, Thomas, of North Merston, yeoman 1
3843113 1971370 1971370 defendant Barnes Thomas husbandman 619287 619287 Barnes, Thomas, of North Merston, husbandman 0
3915155 1995426 1995426 defendant Carter Thomas yeoman 619287 619287 Carter, Thomas, of North Merston, yeoman 1
4428992 2173870 2173870 plaintiff Totrenho John de   619287 619287 Totrenho, John de, of North Merston, son of Andrew 0
4485749 2196252 2196252 defendant Colyn Richard   619287 619287 Colyn, Richard, of North Merston 0
4551460 2216395 2216395 defendant Colyn Richard   619287 619287 Colyn, Richard, of North Merston 0
4571501 2222666 2222666 defendant Colyn Richard   619287 619287 Colyn, Richard, of North Merston 0
4573190 2223150 2223150 defendant Colyn Rciahrd   619287 619287 Colyn, Rciahrd, of North Merston 0
4579324 2225017 2225017 defendant Ingram John   619287 619287 Ingram, John, of North Merston 1
4579327 2225017 2225017 defendant Stevenes John   619287 619287 Stevenes, John, of North Merston, vicar 4
4592559 2229025 2229025 defendant Stephenes John   619287 619287 Stephenes, John, of North Merston, vicar 2
4700101 2265453 2265453 defendant Cartere John chaplain 619287 619287 Cartere, John, of North Merston, chaplain 1
4700105 2265454 2265454 defendant Cartere John chaplain 619287 619287 Cartere, John, of North Merston, chaplain 1
4736199 2276457 2276457 plaintiff Sweyn William   619287 619287 Sweyn, William, of North Merston 0
4736201 2276458 2276458 plaintiff Sweyn William   619287 619287 Sweyn, William, of North Merston 0
4774346 2287956 2287956 defendant Kynne John husbandman 619287 619287 Kynne, John, of North Merston, husbandman 0
4845228 2310019 2310019 defendant Carter Walter husbandman 619287 619287 Carter, Walter, of North Merston, husbandman 1
4845229 2310019 2310019 defendant Carter Thomas husbandman 619287 619287 Carter, Thomas, of North Merston, husbandman 2
4853573 2312533 2312533 plaintiff Carter Thomas   619287 619287 Carter, Thomas, of North Merston 2
4862855 2315366 2315366 defendant Kenner John husbandman 619287 619287 Kenner, John, of North Merston, husbandman 0
4867798 2316898 2316898 defendant Carter Walter husbandman 619287 619287 Carter, Walter, of North Merston, husbandman 1
4867799 2316898 2316898 defendant Carter Thomas husbandman 619287 619287 Carter, Thomas, of North Merston, husbandman 2
4938328 2338368 2338368 defendant Carter Thomas   619287 619287 Carter, Thomas, of North Merston, bailiff 0
4970024 2347985 2347985 defendant Carter Thomas yeoman 619287 619287 Carter, Thomas, of North Merston, yeoman 0
4970025 2347985 2347985 defendant Hertwell John husbandman 619287 619287 Hertwell, John, of North Merston, husbandman 1
5035690 2367292 2367292 defendant Hertwell John husbandman 619287 619287 Hertwell, John, of North Merston, husbandman 4
5035698 2367293 2367293 defendant Hertwell John husbandman 619287 619287 Hertwell, John, of North Merston, husbandman 5
5082941 2381399 2381399 defendant Cottebury Thomas   619287 619287 Cottebury, Thomas, of North Merston, notary 0
5389615 2472091 2472091 defendant Carter John husbandman & summoner 619287 619287 Carter, John, of North Merston, husbandman & summoner 0
5444469 2488255 2488255 defendant Kynne Richard (legal representative) 619287 619287 Kynne, Richard, of North Merston, husbandman, executors of 1
5444470 2488255 2488255 defendant Kynne Joan widow 619287 619287 (Kynne, Joan, of North Merston, widow 2
5444471 2488255 2488255 defendant Carter John, senior husbandman 619287 619287 Carter, John, senior, of North Merston, husbandman 3
5444472 2488255 2488255 defendant Carter John, junior   619287 619287 Carter, John, junior, of North Merston 4
5457219 2492058 2492058 defendant Kynne Richard (legal representative) 619287 619287 Kynne, Richard, of North Merston, husbandman, executors of 1
5457220 2492058 2492058 defendant Kynne Joan widow 619287 619287 (Kynne, Joan, of North Merston, widow 2
5457221 2492058 2492058 defendant Carter John, sen husbandman 619287 619287 Carter, John, sen, of North Merston, husbandman 3
5623330 2551228 2551228 defendant Gloucestre John   619287 619287 Gloucestre, John, of North Merston 0
5632531 2554208 2554208 defendant Ingram John   619287 619287 Ingram, John, of North Merston 0
5632532 2554208 2554208 defendant Bledlawe John laborer 619287 619287 Bledlawe, John, of North Merston, laborer 1
5632533 2554208 2554208 defendant Carter Thomas, junior ploughman 619287 619287 Carter, Thomas, junior, of North Merston, ploughman 2

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