names

48 rows where place_id = 592312

✎ 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
3607290 1869942 1869942 defendant Glasynby Robert yeoman 592312 592312 Glasynby, Robert, of Saltflethaven, yeoman 0
3607291 1869942 1869942 defendant Colom Robert yeoman 592312 592312 Colom, Robert, of Saltflethaven, yeoman 1
3607293 1869942 1869942 defendant Yonge William butcher 592312 592312 Yonge, William, of Saltflethaven, butcher 3
3624779 1875284 1875284 defendant Dykynson John yeoman 592312 592312 Dykynson, John, of Saltflethaven, yeoman 4
3624780 1875284 1875284 defendant Leyk John yeoman 592312 592312 Leyk, John, of Saltflethaven, yeoman 5
3624781 1875284 1875284 defendant Colom Robert yeoman 592312 592312 Colom, Robert, of Saltflethaven, yeoman 6
3638187 1906761 1906761 plaintiff Taillour John (legal representative) 592312 592312 Taillour, John, of Saltflethaven, executors of 0
3650143 1910415 1910415 plaintiff Rowse Richard   592312 592312 Rowse, Richard, of Saltflethaven 0
3669494 1916397 1916397 defendant Hanson William mariner 592312 592312 Hanson, William, of Saltflethaven, mariner 1
3686316 1921877 1921877 defendant Curtes Walter yeoman 592312 592312 Curtes, Walter, of Saltflethaven, yeoman 0
3970820 2014380 2014380 defendant Westorn William husbandman 592312 592312 Westorn, William, of Saltflethaven, husbandman 2
4037472 2038064 2038064 defendant Story Richard glasier 592312 592312 Story, Richard, of Saltflethaven, glasier 0
4235404 2107951 2107951 defendant Foster John tailor 592312 592312 Foster, John, of Saltflethaven, tailor 0
4268562 2119083 2119083 defendant Rowson Henry blacksmith 592312 592312 Rowson, Henry, of Saltflethaven, blacksmith 3
4295893 2128626 2128626 defendant Broughe John or Jenkin fisher 592312 592312 Broughe, John or Jenkin, of Saltflethaven, fisher 2
4341452 2144286 2144286 defendant Tayler William butcher 592312 592312 Tayler, William, of Saltflethaven, butcher 0
4364601 2152397 2152397 defendant Tayler William butcher 592312 592312 Tayler, William, of Saltflethaven, butcher 0
4370466 2154488 2154488 defendant Tayler William butcher 592312 592312 Tayler, William, of Saltflethaven, butcher 0
4377330 2156968 2156968 defendant Foster Richard yeoman 592312 592312 Foster, Richard, of Saltflethaven, yeoman 0
4381727 2158567 2158567 defendant Taler William butcher 592312 592312 Taler, William, of Saltflethaven, butcher 0
4664105 2250261 2250261 defendant Skotte John miller 592312 592312 Skotte, John, of Saltflethaven, miller 0
4864473 2315862 2315862 defendant Watson Thomas mariner 592312 592312 Watson, Thomas, of Saltflethaven, mariner 1
4887783 2323009 2323009 defendant Goneld Richard shipman 592312 592312 Goneld, Richard, of Saltflethaven, shipman 7
4890381 2323760 2323760 defendant Kelun John butcher 592312 592312 Kelun, John, of Saltflethaven, butcher 5
5082527 2381278 2381278 defendant Nunhouse John   592312 592312 Nunhouse, John, of Saltflethaven 0
5087365 2382686 2382686 defendant Twytte John   592312 592312 Twytte, John, of Saltflethaven 0
5122600 2393043 2393043 defendant Armet John   592312 592312 Armet, John, of Saltflethaven, "armet" 0
5148355 2400657 2400657 defendant Skortereth William mariner 592312 592312 Skortereth, William, of Saltflethaven, mariner 1
5222549 2422311 2422311 defendant Theker Richard butcher 592312 592312 Theker, Richard, of Saltflethaven, butcher 0
5234468 2425671 2425671 defendant Colum John butcher 592312 592312 Colum, John, of Saltflethaven, butcher 4
5250325 2430211 2430211 defendant Yong Alan butcher 592312 592312 Yong, Alan, of Saltflethaven, butcher 0
5289244 2441856 2441856 defendant Arker John mercer 592312 592312 Arker, John, of Saltflethaven, mercer 7
5341608 2457566 2457566 defendant Boteler William shipman 592312 592312 Boteler, William, of Saltflethaven, shipman 0
5341609 2457566 2457566 defendant Manfeld William husbandman 592312 592312 Manfeld, William, of Saltflethaven, husbandman 1
5343287 2458096 2458096 defendant Godknape Simon yeoman 592312 592312 Godknape, Simon, of Saltflethaven, yeoman 0
5343288 2458096 2458096 defendant Theker John yeoman 592312 592312 Theker, John, of Saltflethaven, yeoman 1
5343289 2458096 2458096 defendant Glasenby Robert husbandman 592312 592312 Glasenby, Robert, of Saltflethaven, husbandman 2
5343290 2458096 2458096 defendant Ward Robert husbandman 592312 592312 Ward, Robert, of Saltflethaven, husbandman 3
5343291 2458096 2458096 defendant Clawebek Richard mariner 592312 592312 Clawebek, Richard, of Saltflethaven, mariner 4
5359572 2463030 2463030 defendant Yong Alan butcher 592312 592312 Yong, Alan, of Saltflethaven, butcher 0
5359573 2463030 2463030 defendant Colum Robert butcher 592312 592312 Colum, Robert, of Saltflethaven, butcher 1
5511759 2508530 2508530 defendant Taillor Thomas tailor 592312 592312 Taillor, Thomas, of Saltflethaven, tailor 0
5517850 2510423 2510423 defendant Gudknape Simon yeoman 592312 592312 Gudknape, Simon, of Saltflethaven, yeoman 1
5546256 2518897 2518897 plaintiff Taylour John   592312 592312 Taylour, John, of Saltflethaven 0
5565772 2524583 2524583 defendant Rowsune Robert (legal representative) 592312 592312 Rowsune, Robert, of Saltflethaven, yeoman, executors of 0
5565773 2524583 2524583 defendant Rowsune Thomas yeoman 592312 592312 (Rowsune, Thomas, of Saltflethaven, yeoman 1
5565774 2524583 2524583 defendant Curtes Walter yeoman 592312 592312 Curtes, Walter, of Saltflethaven, yeoman 2
5583570 2529936 2529936 defendant Roddell John mariner 592312 592312 Roddell, John, of Saltflethaven, mariner 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);