names

36 rows where place_id = 634769

✎ 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
3821255 1964539 1964539 defendant Wood John husbandman 634769 634769 Wood, John, of Swynford, husbandman 1
3894878 1988495 1988495 plaintiff Pulter William husbandman 634769 634769 Pulter, William, of Swynford, husbandman 1
4262302 2117062 2117062 defendant Adcocke Thomas Leics, gent 634769 634769 Adcocke Thomas, of Swynford, Leics, gent 2
4348334 2146670 2146670 defendant Symons William   634769 634769 Symons, William, of Swynford, yeoman, his son 1
4595395 2229815 2229815 defendant Crounale John   634769 634769 Crounale, John, of Swynford 2
4615496 2235851 2235851 defendant Wryght William   634769 634769 Wryght, William, of Swynford 0
4682004 2259988 2259988 defendant Smyth John smith 634769 634769 Smyth, John, of Swynford, smith 1
4691127 2262745 2262745 plaintiff Wryght William   634769 634769 Wryght, William, of Swynford 0
4710277 2268568 2268568 defendant Swynford William laborer 634769 634769 Swynford, William, of Swynford, laborer 1
4739088 2277317 2277317 plaintiff Wryght William   634769 634769 Wryght, William, of Swynford 0
4769615 2286472 2286472 defendant Taillour Adam tailor 634769 634769 Taillour, Adam, of Swynford, tailor 0
4774441 2287989 2287989 defendant Rage John husbandman 634769 634769 Rage, John, of Swynford, husbandman 0
4782668 2290593 2290593 defendant Cook John husbandman 634769 634769 Cook, John, of Swynford, husbandman 0
4792868 2293858 2293858 plaintiff Mulleward William   634769 634769 Mulleward, William, of Swynford 0
4792869 2293858 2293858 defendant Shilton John ploughman 634769 634769 Shilton, John, of Swynford, ploughman 0
4793891 2294214 2294214 defendant Taillour Adam tailor 634769 634769 Taillour, Adam, of Swynford, tailor 0
4816716 2301325 2301325 plaintiff Mariot Thomas   634769 634769 Mariot, Thomas, of Swynford 0
5057931 2373945 2373945 plaintiff Coveley Nicholas   634769 634769 Coveley, Nicholas, of Swynford 0
5068925 2377205 2377205 defendant Vyelys William husbandman 634769 634769 Vyelys, William, of Swynford, husbandman 2
5068929 2377206 2377206 defendant Violys William husbandman 634769 634769 Violys, William, of Swynford, husbandman 2
5096102 2385301 2385301 defendant Maryot William husbandman 634769 634769 Maryot, William, of Swynford, husbandman 0
5281764 2439739 2439739 plaintiff Coweley Nicholas   634769 634769 Coweley, Nicholas, of Swynford 0
5281766 2439740 2439740 plaintiff Coweley Nicholas   634769 634769 Coweley, Nicholas, of Swynford 0
5332729 2454859 2454859 plaintiff Conley or Couley Nicholas   634769 634769 Conley or Couley, Nicholas, of Swynford 0
5332732 2454860 2454860 plaintiff Conley or Couley Nicholas   634769 634769 Conley or Couley, Nicholas, of Swynford 0
5332735 2454861 2454861 plaintiff Conley or Couley Nicholas gent 634769 634769 Conley or Couley, Nicholas, of Swynford, gent 0
5350869 2460385 2460385 plaintiff Cowley Nicholas   634769 634769 Cowley, Nicholas, of Swynford 0
5368016 2465622 2465622 plaintiff Couley Nicholas (legal representative) 634769 634769 Couley, Nicholas, of Swynford, executors of 0
5432080 2484561 2484561 defendant Carter Richard husbandman 634769 634769 Carter, Richard, of Swynford, husbandman 1
5448291 2489382 2489382 defendant Carter Richard husbandman 634769 634769 Carter, Richard, of Swynford, husbandman 1
5483634 2500055 2500055 defendant Carter Richard husbandman 634769 634769 Carter, Richard, of Swynford, husbandman 1
5615625 2548677 2548677 defendant Belgrave Richard (legal representative) 634769 634769 Belgrave, Richard, of Swynford, executors of 0
5615629 2548677 2548677 defendant Rose John   634769 634769 Rose, John, of Swynford 4
5622408 2550933 2550933 defendant atte Welle William (legal representative) 634769 634769 atte Welle, William, of Swynford, executrix of 0
5636381 2555337 2555337 plaintiff Wryght William   634769 634769 Wryght, William, of Swynford 0
5636383 2555338 2555338 plaintiff Wryght William   634769 634769 Wryght, William, of Swynford 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);