names

67 rows where place_id = 594154

✎ 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
3614769 1872268 1872268 defendant Acred James husbandman 594154 594154 Acred, James, of Laghton, husbandman 2
3701524 1926726 1926726 defendant Mawger John husbandman 594154 594154 Mawger, John, of Laghton, husbandman 0
3741658 1939260 1939260 defendant Baytman John butcher 594154 594154 Baytman, John, of Laghton, butcher 0
3741659 1939260 1939260 defendant Spede John butcher 594154 594154 Spede, John, of Laghton, butcher 1
4450276 2185044 2185044 defendant Overyngham Adam de   594154 594154 Overyngham, Adam de, of Laghton, knight 0
4496844 2199682 2199682 defendant Weston William   594154 594154 Weston, William, of Laghton, parson 0
4533522 2210756 2210756 defendant Ma_ John de   594154 594154 Ma_, John de, of Laghton, vicar 0
4544998 2214356 2214356 defendant Ingelton Katherine   594154 594154 Ingelton, Katherine, of Laghton 1
4548049 2215326 2215326 defendant Broke William   594154 594154 Broke, William, of Laghton 0
4550342 2216048 2216048 plaintiff Dalyson William   594154 594154 Dalyson, William, of Laghton 0
4580186 2225292 2225292 plaintiff Dalyson William   594154 594154 Dalyson, William, of Laghton 0
4581128 2225581 2225581 defendant Baily John   594154 594154 Baily, John, of Laghton 3
4614237 2235465 2235465 plaintiff Draper John   594154 594154 Draper, John, of Laghton 0
4622782 2238102 2238102 defendant Broke William   594154 594154 Broke, William, of Laghton 0
4639092 2242953 2242953 defendant Wythir Thomas   594154 594154 Wythir, Thomas, of Laghton 0
4652476 2246725 2246725 defendant Cartwright William   594154 594154 Cartwright, William, of Laghton 0
4652477 2246725 2246725 defendant Cartwright John husbandman 594154 594154 Cartwright, John, of Laghton, husbandman 1
4656088 2247784 2247784 defendant Dalison Nicholas esq 594154 594154 Dalison, Nicholas, of Laghton, esq 0
4657105 2248117 2248117 defendant Dalyson William gent 594154 594154 Dalyson, William, of Laghton, gent: Dalyson, Nicholas, of Laghton, gent 0
4660998 2249264 2249264 defendant Dalyson Nicholas gent 594154 594154 Dalyson, Nicholas, of Laghton, gent 1
4664383 2250341 2250341 defendant Tournour Roger turner 594154 594154 Tournour, Roger, of Laghton, turner 1
4675242 2257868 2257868 defendant Dalyson Nicholas gent 594154 594154 Dalyson, Nicholas, of Laghton, gent 0
4682526 2260159 2260159 defendant Draper John husbandman 594154 594154 Draper, John, of Laghton, husbandman 4
4694695 2263837 2263837 defendant Drapur John yeoman 594154 594154 Drapur, John, of Laghton, yeoman 0
4700781 2265644 2265644 defendant Dalyson Nicholas gent 594154 594154 Dalyson, Nicholas, of Laghton, gent 0
4700782 2265644 2265644 defendant Everard Roger husbandman 594154 594154 Everard, Roger, of Laghton, husbandman 1
4709948 2268468 2268468 defendant Souche Robert gent 594154 594154 Souche, Robert, of Laghton, gent 3
4709955 2268469 2268469 defendant Souche Robert gent 594154 594154 Souche, Robert, of Laghton, gent 5
4720322 2271697 2271697 defendant Wegeyn Richard   594154 594154 Wegeyn, Richard, of Laghton 1
4720801 2271838 2271838 defendant Wygeyn Richard husbandman 594154 594154 Wygeyn, Richard, of Laghton, husbandman 0
4724063 2272822 2272822 defendant Laghton Robert gent 594154 594154 Laghton, Robert, of Laghton, gent 0
4729902 2274560 2274560 defendant Dalison William gent 594154 594154 Dalison, William, of Laghton, gent 0
4734474 2275948 2275948 defendant Dalyson Nicholas gent 594154 594154 Dalyson, Nicholas, of Laghton, gent 0
4734727 2276016 2276016 defendant Weston William   594154 594154 Weston, William, of Laghton, parson 0
4736139 2276440 2276440 defendant Draper John yeoman 594154 594154 Draper, John, of Laghton, yeoman 0
4741417 2277984 2277984 defendant Bache John yeoman 594154 594154 Bache, John, of Laghton, yeoman 4
4768832 2286230 2286230 defendant Laghton Robert de gent 594154 594154 Laghton, Robert de, of Laghton, gent 0
4783841 2290964 2290964 defendant de Laghton Robert gent 594154 594154 de Laghton, Robert, of Laghton, gent 0
4785674 2291549 2291549 defendant Pelham John   594154 594154 Pelham, John, of Laghton, knight 0
4789999 2292946 2292946 defendant Drapur John husbandman 594154 594154 Drapur, John, of Laghton, husbandman 0
4809415 2299121 2299121 defendant Turnour William husbandman 594154 594154 Turnour, William, of Laghton, husbandman 2
4809416 2299121 2299121 defendant Mundson John husbandman 594154 594154 Mundson, John, of Laghton, husbandman 3
4809598 2299166 2299166 defendant Draper John yeoman 594154 594154 Draper, John, of Laghton, yeoman 2
4834992 2306948 2306948 defendant Brefeld William laborer 594154 594154 Brefeld, William, of Laghton, laborer 0
4835851 2307201 2307201 defendant Draper John   594154 594154 Draper, John, of Laghton 6
4856858 2313522 2313522 defendant Draper John husbandman 594154 594154 Draper, John, of Laghton, husbandman 0
4877071 2319798 2319798 defendant Cutler James husbandman 594154 594154 Cutler, James, of Laghton, husbandman 4
4889625 2323554 2323554 defendant Bate John husbandman 594154 594154 Bate, John, of Laghton, husbandman 1
4891574 2324103 2324103 defendant Bate John husbandman 594154 594154 Bate, John, of Laghton, husbandman 1
4915848 2331453 2331453 defendant Lister Robert husbandman 594154 594154 Lister, Robert, of Laghton, husbandman 11
4933514 2336867 2336867 defendant Fretour Thomas husbandman 594154 594154 Fretour, Thomas, of Laghton, husbandman 0
4933521 2336868 2336868 defendant Fretour Thomas husbandman 594154 594154 Fretour, Thomas, of Laghton, husbandman 0
4933524 2336868 2336868 defendant atte Bregge John, senior husbandman 594154 594154 atte Bregge, John, senior, of Laghton, husbandman 3
4933525 2336868 2336868 defendant atte Bregge John, junior husbandman 594154 594154 atte Bregge, John, junior, of Laghton, husbandman 4
4943048 2339800 2339800 defendant Laghton Robert, junior gent 594154 594154 Laghton, Robert, junior, of Laghton, gent 0
4973184 2348913 2348913 defendant Herry William husbandman 594154 594154 Herry, William, of Laghton, husbandman 1
5098094 2385873 2385873 defendant Norton Giles husbandman 594154 594154 Norton, Giles, of Laghton, husbandman 0
5297399 2444241 2444241 defendant Coke (illegible) husbandman 594154 594154 Coke, _, of Laghton, husbandman 0
5308100 2447447 2447447 defendant Coke Robert husbandman 594154 594154 Coke, Robert, of Laghton, husbandman 0
5320955 2451356 2451356 defendant Qwyntyn Thomas husbandman 594154 594154 Qwyntyn, Thomas, of Laghton, husbandman 4
5496652 2503916 2503916 plaintiff Keton or Keneton John gent 594154 594154 Keton or Keneton, John, of Laghton, gent 0
5496655 2503917 2503917 plaintiff Keton or Keneton John gent 594154 594154 Keton or Keneton, John, of Laghton, gent 0
5511560 2508463 2508463 plaintiff Keton John (legal representative) 594154 594154 Keton, John, of Laghton, gent, executors of 0
5511565 2508464 2508464 plaintiff Keton John (legal representative) 594154 594154 Keton, John, of Laghton, gent, executors of 0
5630495 2553551 2553551 defendant Cartwryght William   594154 594154 Cartwryght, William, of Laghton, cartwright 0
5631954 2554018 2554018 defendant Dallysson William esq 594154 594154 Dallysson, William, of Laghton, esq 0
5631955 2554018 2554018 defendant Dalysson Nicholas esq 594154 594154 Dalysson, Nicholas, of Laghton, esq 1

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