names

77 rows where place_id = 596935

✎ 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
3626685 1903191 1903191 defendant Brooke John husbandman 596935 596935 Brooke, John, of Baketon, husbandman 1
3626691 1903192 1903192 defendant Brook John husbandman 596935 596935 Brook, John, of Baketon, husbandman 1
3908016 1992974 1992974 plaintiff Pratyman William, junior yeoman 596935 596935 Pratyman, William, junior, of Baketon, yeoman 0
3915475 1995544 1995544 defendant Chapeman Thomas laborer 596935 596935 Chapeman, Thomas, of Baketon, laborer 0
3938834 2003330 2003330 plaintiff Reynberd Nicholas   596935 596935 Reynberd, Nicholas, of Baketon, 0
4448859 2184583 2184583 defendant Hodemyn John   596935 596935 Hodemyn, John, of Baketon 0
4459258 2187942 2187942 defendant Mancer William   596935 596935 Mancer, William, of Baketon 0
4475016 2192856 2192856 defendant Densy Robert pipemaker or pepper maker 596935 596935 Densy, Robert, of Baketon, pipemaker or pepper maker 2
4481264 2194825 2194825 defendant Neketon Thomas   596935 596935 Neketon, Thomas, of Baketon weaver 0
4576358 2224115 2224115 defendant Fastelyn Edmund   596935 596935 Fastelyn, Edmund, of Baketon 1
4596656 2230190 2230190 defendant Pratyman William   596935 596935 Pratyman, William, of Baketon 0
4655333 2247559 2247559 defendant Thurleton William yeoman 596935 596935 Thurleton, William, of Baketon, yeoman 0
4655336 2247559 2247559 defendant Thurleton John laborer 596935 596935 Thurleton, John, of Baketon, laborer 3
4684893 2260869 2260869 defendant Fertlyng William yeoman 596935 596935 Fertlyng, William, of Baketon, yeoman 1
4714916 2269997 2269997 defendant Baron Robert chapman 596935 596935 Baron, Robert, of Baketon, chapman 0
4751059 2280793 2280793 defendant Pope John yeoman 596935 596935 Pope, John, of Baketon, yeoman 3
4755588 2282129 2282129 defendant Merable John yeoman 596935 596935 Merable, John, of Baketon, yeoman 0
4769313 2286378 2286378 plaintiff Stoke Robert   596935 596935 Stoke, Robert, of Baketon 1
4774249 2287928 2287928 defendant Sencle (illegible) shipman 596935 596935 Sencle, _, of Baketon, shipman 0
4809109 2299025 2299025 defendant Dolet John yeoman 596935 596935 Dolet, John, of Baketon, yeoman 2
4823906 2303558 2303558 defendant Ferthyng William husbandman 596935 596935 Ferthyng, William, of Baketon, husbandman 0
4865772 2316261 2316261 defendant Olyve John ploughman 596935 596935 Olyve, John, of Baketon, ploughman 1
4865773 2316261 2316261 defendant Fraunceys Richard laborer 596935 596935 Fraunceys, Richard, of Baketon, laborer 2
4868512 2317127 2317127 defendant Spraggy Thomas (legal representative) 596935 596935 Spraggy, Thomas, of Baketon, husbandman, executors of 0
4868513 2317127 2317127 defendant Hornyngeserth John gent 596935 596935 (Hornyngeserth, John, of Baketon, gent 1
4875692 2319355 2319355 defendant Pope John yeoman 596935 596935 Pope, John, of Baketon, yeoman 1
4882179 2321329 2321329 plaintiff Rag John   596935 596935 Rag, John, of Baketon 0
4888413 2323175 2323175 plaintiff Olyve or Clyve John yeoman 596935 596935 Olyve or Clyve, John, of Baketon, yeoman 1
4891684 2324141 2324141 plaintiff Olyve or Clyve John yeoman 596935 596935 Olyve or Clyve, John, of Baketon, yeoman 1
4915248 2331275 2331275 defendant Rag John yeoman 596935 596935 Rag, John, of Baketon, yeoman 0
4933872 2336975 2336975 defendant Webster John husbandman 596935 596935 Webster, John, of Baketon, husbandman 2
4989624 2353819 2353819 defendant Hornygeserth John gent 596935 596935 Hornygeserth, John, of Baketon, gent 0
5016491 2361716 2361716 plaintiff Burgh William (legal representative) 596935 596935 Burgh, William, of Baketon, executors of 0
5022467 2363473 2363473 defendant Reynberd Thomas yeoman 596935 596935 Reynberd, Thomas, of Baketon, yeoman 0
5040578 2368790 2368790 defendant Hornyngesherth John gent 596935 596935 Hornyngesherth, John, of Baketon, gent 1
5052368 2372306 2372306 defendant Cobbe William husbandman 596935 596935 Cobbe, William, of Baketon, husbandman 4
5061849 2375142 2375142 defendant Halle Thomas carter 596935 596935 Halle, Thomas, of Baketon, carter 1
5072914 2378386 2378386 defendant Reynberd Thomas yeoman 596935 596935 Reynberd, Thomas, of Baketon, yeoman 1
5072915 2378386 2378386 defendant Berdwell John yeoman 596935 596935 Berdwell, John, of Baketon, yeoman 2
5082931 2381396 2381396 defendant Dryver William husbandman 596935 596935 Dryver, William, of Baketon, husbandman 0
5156753 2403135 2403135 defendant Honryngsherth John (legal representative) 596935 596935 Honryngsherth, John, of Baketon, esq, executor of 0
5156754 2403135 2403135 defendant Hornyngsherth Thomas gent 596935 596935 Hornyngsherth, Thomas, of Baketon, gent 1
5156755 2403135 2403135 defendant Symond John husbandman 596935 596935 Symond, John, of Baketon, husbandman 2
5156756 2403135 2403135 defendant Baxster Robert (legal representative) 596935 596935 Baxster, Robert, of Baketon, husbandman, executors of 3
5156759 2403135 2403135 defendant Ferrour John (legal representative) 596935 596935 Ferrour, John, of Baketon, clerk, executors of 6
5156761 2403135 2403135 defendant Grene John carpenter 596935 596935 Grene, John, of Baketon, carpenter 8
5172833 2407787 2407787 defendant Hornyngysherth John (legal representative) 596935 596935 Hornyngysherth, John, of Baketon, esq, executor of 0
5172834 2407787 2407787 defendant Hornyngysherth Thomas gent 596935 596935 Hornyngysherth, Thomas, of Baketon, gent 1
5172835 2407787 2407787 defendant Symond John husbandman 596935 596935 Symond, John, of Baketon, husbandman 2
5172836 2407787 2407787 defendant Baxster Robert (legal representative) 596935 596935 Baxster, Robert, of Baketon, husbandman, executors of 3
5172839 2407787 2407787 defendant Ferrour John (legal representative) 596935 596935 Ferrour, John, of Baketon, clerk, executors of 6
5172841 2407787 2407787 defendant Grene John carpenter 596935 596935 Grene, John, of Baketon, carpenter 8
5192645 2413587 2413587 defendant Hornyngysherth John (legal representative) 596935 596935 Hornyngysherth, John, of Baketon, esq, executor of 0
5192646 2413587 2413587 defendant Hornyngysherth Thomas gent 596935 596935 Hornyngysherth, Thomas, of Baketon, gent 1
5192648 2413587 2413587 defendant Dexster Robert (legal representative) 596935 596935 Dexster, Robert, of Baketon, husbandman, executors of 3
5192658 2413589 2413589 defendant Hornyngysherth John (legal representative) 596935 596935 Hornyngysherth, John, of Baketon, esq, executor of 0
5192659 2413589 2413589 defendant Hornyngysherth Thomas gent 596935 596935 Hornyngysherth, Thomas, of Baketon, gent 1
5192661 2413590 2413590 defendant Symond John husbandman 596935 596935 Symond, John, of Baketon, husbandman 0
5192662 2413590 2413590 defendant Baxster Robert (legal representative) 596935 596935 Baxster, Robert, of Baketon, husbandman, executors of 1
5192665 2413590 2413590 defendant Ferrour John (legal representative) 596935 596935 Ferrour, John, of Baketon, clerk, executors of 4
5207816 2418028 2418028 defendant Hornyngysherth John (legal representative) 596935 596935 Hornyngysherth, John, of Baketon, esq, executor of 0
5207817 2418028 2418028 defendant Hornyngsherth Thomas gent 596935 596935 Hornyngsherth, Thomas, of Baketon, gent 1
5221968 2422128 2422128 defendant Ferrour John (legal representative) 596935 596935 Ferrour, John, of Baketon, clerk, executor of 0
5221969 2422128 2422128 defendant Formage John   596935 596935 Formage, John, of Baketon 1
5230264 2424470 2424470 defendant Folsham Clement husbandman 596935 596935 Folsham, Clement, of Baketon, husbandman 0
5282788 2440027 2440027 defendant Baketon John gent 596935 596935 Baketon, John, of Baketon, gent 0
5286396 2441022 2441022 defendant Baketon John gent 596935 596935 Baketon, John, of Baketon, gent 0
5299611 2444858 2444858 defendant Burgh Nicholas yeoman 596935 596935 Burgh, Nicholas, of Baketon, yeoman 0
5316690 2450079 2450079 plaintiff Dryver John   596935 596935 Dryver, John, of Baketon 0
5366541 2465188 2465188 defendant Baketon John gent 596935 596935 Baketon, John, of Baketon, gent 0
5366542 2465188 2465188 defendant Barber William   596935 596935 Barber, William, of Baketon, yeoman, administrators of 1
5571906 2526324 2526324 defendant Johnson William   596935 596935 Johnson, William, of Baketon, shepherd 0
5582594 2529623 2529623 plaintiff Upton John   596935 596935 Upton, John, of Baketon 9
5593021 2532807 2532807 plaintiff Wyghtman William (legal representative) 596935 596935 Wyghtman, William, of Baketon, executors of 0
5604264 2536196 2536196 defendant Uppeton John   596935 596935 Uppeton, John, of Baketon 0
5618430 2549588 2549588 plaintiff Mirolle William   596935 596935 Mirolle, William, of Baketon 0
5619896 2550084 2550084 defendant Cook William   596935 596935 Cook, William, of Baketon 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);