names

46 rows where place_id = 691597

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671885 1917203 1917203 plaintiff Coorby Robert (legal representative) 691597 691597 Coorby, Robert, of Hexham, yeoman, executor of Levyke, Henry, of Wymondham, executor of 0
4090706 2056963 2056963 defendant Bett Francis clerk 691597 691597 Bett, Francis, of Hexham, clerk 2
4205441 2097456 2097456 defendant Lydall Robert cordwainer 691597 691597 Lydall, Robert, of Hexham, cordwainer 2
4448421 2184436 2184436 defendant Hoghton William de   691597 691597 Hoghton, William de, of Hexham 1
4472785 2192159 2192159 plaintiff Cooke William   691597 691597 Cooke, William, of Hexham 0
4517185 2205776 2205776 defendant Baxter Thomas   691597 691597 Baxter, Thomas, of Hexham 2
4517187 2205776 2205776 defendant Sclater William   691597 691597 Sclater, William, of Hexham 4
4517191 2205776 2205776 defendant Walker Roger   691597 691597 Walker, Roger, of Hexham 8
4517192 2205776 2205776 defendant Chapman William   691597 691597 Chapman, William, of Hexham, servant of Thomas Chapman 9
4623638 2238371 2238371 defendant Boltby William sadler 691597 691597 Boltby, William, of Hexham, sadler 3
4680952 2259668 2259668 defendant Rede Henry yeoman 691597 691597 Rede, Henry, of Hexham, yeoman 0
4699503 2265298 2265298 defendant Beek Aldom mercer 691597 691597 Beek, Aldom, of Hexham, mercer 0
4704054 2266646 2266646 defendant Couper Henry cooper 691597 691597 Couper, Henry, of Hexham, cooper 2
4704056 2266646 2266646 defendant Hoorde John   691597 691597 Hoorde, John, of Hexham, shoe maker 4
4715254 2270101 2270101 defendant Corbrig Robert   691597 691597 Corbrig, Robert, of Hexham, dyer, now staying in Carlhill 0
4718960 2271276 2271276 plaintiff Beek Alan   691597 691597 Beek, Alan, of Hexham 0
4731580 2275068 2275068 defendant Monke John, sen shoemaker 691597 691597 Monke, John, sen, of Hexham, shoemaker 2
4731581 2275068 2275068 defendant Ulham Thomas walker 691597 691597 Ulham, Thomas, of Hexham, walker 3
4731583 2275068 2275068 defendant Hunter Stephen yeoman 691597 691597 Hunter, Stephen, of Hexham, yeoman 5
4847160 2310612 2310612 defendant Laverok Patrick   691597 691597 Laverok, Patrick, of Hexham 0
4847161 2310612 2310612 defendant Bek Alan   691597 691597 Bek, Alan, of Hexham 1
4847165 2310613 2310613 defendant Jonson William husbandman 691597 691597 Jonson, William, of Hexham, husbandman 0
4847166 2310613 2310613 defendant Walker John husbandman 691597 691597 Walker, John, of Hexham, husbandman 1
4847167 2310613 2310613 defendant Eland John husbandman 691597 691597 Eland, John, of Hexham, husbandman 2
4847168 2310613 2310613 defendant Richardson John husbandman 691597 691597 Richardson, John, of Hexham, husbandman 3
4847169 2310613 2310613 defendant Laveroke William husbandman 691597 691597 Laveroke, William, of Hexham, husbandman 4
4847174 2310613 2310613 defendant Elyson William husbandman 691597 691597 Elyson, William, of Hexham, husbandman 9
4847178 2310615 2310615 defendant Rydlee Isabel widow 691597 691597 Rydlee, Isabel, of Hexham, widow 0
4911105 2329984 2329984 plaintiff Bray John   691597 691597 Bray, John, of Hexham 0
4955244 2343527 2343527 defendant Deconson Robert yeoman 691597 691597 Deconson, Robert, of Hexham, yeoman 4
4985436 2352567 2352567 defendant Dikson Robert yeoman 691597 691597 Dikson, Robert, of Hexham, yeoman 3
4996987 2355951 2355951 defendant Beeke Alan chapman 691597 691597 Beeke, Alan, of Hexham, chapman 3
5019281 2362527 2362527 defendant Palmer Robert yeoman 691597 691597 Palmer, Robert, of Hexham, yeoman 2
5019284 2362528 2362528 defendant Palmer Robert yeoman 691597 691597 Palmer, Robert, of Hexham, yeoman 1
5026387 2364604 2364604 defendant Hyne or Hyve Richard yeoman 691597 691597 Hyne or Hyve, Richard, of Hexham, yeoman 8
5042864 2369474 2369474 defendant Barker Roger tanner 691597 691597 Barker, Roger, of Hexham, tanner 3
5059251 2374332 2374332 defendant Bowethe John husbandman 691597 691597 Bowethe, John, of Hexham, husbandman 2
5382377 2470017 2470017 defendant Populwell William husbandman 691597 691597 Populwell, William, of Hexham, husbandman 0
5572974 2526646 2526646 defendant Ogle Henry gent 691597 691597 Ogle, Henry, of Hexham, gent 1
5572975 2526646 2526646 defendant Ogle Ralph gent 691597 691597 Ogle, Ralph, of Hexham, gent 2
5572976 2526646 2526646 defendant Ogle Thomas gent 691597 691597 Ogle, Thomas, of Hexham, gent 3
5572984 2526646 2526646 defendant Lambe William yeoman 691597 691597 Lambe, William, of Hexham, yeoman 11
5572985 2526646 2526646 defendant Menemershe Alexander yeoman 691597 691597 Menemershe, Alexander, of Hexham, yeoman 12
5614131 2548199 2548199 defendant Hoghton William de   691597 691597 Hoghton, William de, of Hexham 0
5614809 2548430 2548430 defendant Hoghton William de   691597 691597 Hoghton, William de, of Hexham 1
5618822 2549726 2549726 defendant Marton Alexander de   691597 691597 Marton, Alexander de, of Hexham 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);