names

38 rows where place_id = 754243

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4418828 2170754 2170754 defendant Strode John de, senior   754243 754243 Strode, John de, senior, of Hierne 1
4467351 2190467 2190467 defendant Yonge John   754243 754243 Yonge, John, of Hierne 0
4476464 2193304 2193304 defendant Colnewode Thomas   754243 754243 Colnewode, Thomas, of Hierne 0
4493090 2198539 2198539 plaintiff atte Halle Richard   754243 754243 atte Halle, Richard, of Hierne 0
4496933 2199707 2199707 defendant atte Halle John   754243 754243 atte Halle, John, of Hierne 0
4496940 2199710 2199710 plaintiff Davy John   754243 754243 Davy, John, of Hierne 0
4516474 2205559 2205559 defendant Stevene William   754243 754243 Stevene, William, of Hierne 0
4516475 2205560 2205560 plaintiff Colnewode Thomas   754243 754243 Colnewode, Thomas, of Hierne, son of William 0
4551361 2216364 2216364 defendant Sove William   754243 754243 Sove, William, of Hierne 0
4557818 2218375 2218375 defendant Haghe Robert, sen   754243 754243 Haghe, Robert, sen, of Hierne 0
4605852 2232943 2232943 defendant Philipp John   754243 754243 Philipp, John, of Hierne 0
4622989 2238167 2238167 defendant Hawe Robert   754243 754243 Hawe, Robert, of Hierne 0
4656956 2248066 2248066 defendant Halle Peter gent 754243 754243 Halle, Peter, of Hierne, gent 0
4741091 2277900 2277900 defendant Hamon Thomas husbandman 754243 754243 Hamon, Thomas, of Hierne, husbandman 1
4741092 2277900 2277900 defendant Blak John (legal representative) 754243 754243 Blak, John, of Hierne, husbandman, executor of 2
4742944 2278449 2278449 defendant Goffe William thatcher 754243 754243 Goffe, William, of Hierne, thatcher 0
4742945 2278449 2278449 defendant Croudere William laborer 754243 754243 Croudere, William, of Hierne, laborer 1
4758619 2283078 2283078 defendant atte Halle Peter esq 754243 754243 atte Halle, Peter, of Hierne, esq 0
4758621 2283079 2283079 defendant atte Halle Peter esq 754243 754243 atte Halle, Peter, of Hierne, esq 0
4781528 2290234 2290234 defendant atte Halle Peter esq 754243 754243 atte Halle, Peter, of Hierne, esq 0
4781530 2290235 2290235 defendant atte Halle Peter esq 754243 754243 atte Halle, Peter, of Hierne, esq 0
4806925 2298373 2298373 defendant Halle Peter esq 754243 754243 Halle, Peter, of Hierne, esq 0
4806927 2298374 2298374 defendant Halle Peter esq 754243 754243 Halle, Peter, of Hierne, esq 0
4830026 2305438 2305438 defendant Colby William husbandman 754243 754243 Colby, William, of Hierne, husbandman 0
4832421 2306175 2306175 defendant atte Halle Peter esq 754243 754243 atte Halle, Peter, of Hierne, esq 0
4832431 2306178 2306178 defendant Halle Peter esq 754243 754243 Halle, Peter, of Hierne, esq 0
4833496 2306482 2306482 defendant Hauke Thomas husbandman 754243 754243 Hauke, Thomas, of Hierne, husbandman 0
4873669 2318706 2318706 defendant Phelip Thomas husbandman 754243 754243 Phelip, Thomas, of Hierne, husbandman 0
4897045 2325729 2325729 defendant Knepe John husbandman 754243 754243 Knepe, John, of Hierne, husbandman 1
4900280 2326721 2326721 defendant Paynot Robert husbandman 754243 754243 Paynot, Robert, of Hierne, husbandman 0
4907196 2328815 2328815 defendant Paynot Robert husbandman 754243 754243 Paynot, Robert, of Hierne, husbandman 1
4952881 2342820 2342820 defendant Loveryk Thomas gent 754243 754243 Loveryk, Thomas, of Hierne, gent 0
4960013 2344959 2344959 defendant Cokke John husbandman 754243 754243 Cokke, John, of Hierne, husbandman 1
4969090 2347720 2347720 defendant Gelovere Robert laborer 754243 754243 Gelovere, Robert, of Hierne, laborer 1
4978906 2350648 2350648 defendant Loveryk Thomas gent 754243 754243 Loveryk, Thomas, of Hierne, gent 0
4978909 2350649 2350649 defendant Loveryk Thomas gent 754243 754243 Loveryk, Thomas, of Hierne, gent 0
5026245 2364567 2364567 defendant Carpenter William husbandman 754243 754243 Carpenter, William, of Hierne, husbandman 0
5636278 2555303 2555303 defendant atte See John husbandman 754243 754243 atte See, John, of Hierne, husbandman 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);