names

62 rows where place_id = 602759

✎ 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
3651652 1910876 1910876 defendant Holond William merchant 602759 602759 Holond, William, of Dertmouth, merchant 0
3675232 1918289 1918289 defendant Smyth John yeoman 602759 602759 Smyth, John, of Dertmouth, yeoman 0
3681081 1920162 1920162 plaintiff Seymour Nicholas merchant 602759 602759 Seymour, Nicholas, of Dertmouth, merchant 0
3681083 1920163 1920163 plaintiff Seymour Nicholas merchant 602759 602759 Seymour, Nicholas, of Dertmouth, merchant 0
3691224 1923415 1923415 defendant Smyth John yeoman 602759 602759 Smyth, John, of Dertmouth, yeoman 0
3691227 1923416 1923416 defendant Smyth John yeoman 602759 602759 Smyth, John, of Dertmouth, yeoman 0
3714181 1930734 1930734 defendant Toker John master of the Katherine 602759 602759 Toker, John, of Dertmouth, mariner, master of the Katherine 2
3714185 1930735 1930735 defendant Toker John master of the Katherine 602759 602759 Toker, John, of Dertmouth, mariner, master of the Katherine 2
3812354 1961756 1961756 plaintiff Cornycall John   602759 602759 Cornycall, John, of Dertmouth 0
3818102 1963575 1963575 defendant Howke Richard innholder 602759 602759 Howke, Richard, of Dertmouth, innholder 0
3822225 1964855 1964855 defendant Paynter William merchant 602759 602759 Paynter, William, of Dertmouth, merchant 0
3881482 1984071 1984071 defendant Hoke Richard merchant 602759 602759 Hoke, Richard, of Dertmouth, merchant 0
3948191 2006430 2006430 plaintiff Croft George   602759 602759 Croft, George, of Dertmouth 0
3948273 2006455 2006455 defendant Shapley Robert merchant 602759 602759 Shapley, Robert, of Dertmouth, merchant 1
4457170 2187253 2187253 defendant Cobrugg John   602759 602759 Cobrugg, John, of Dertmouth 0
4584143 2226460 2226460 defendant Hawle John, sen (legal representative) 602759 602759 Hawle, John, sen, of Dertmouth, executors of 0
4616815 2236260 2236260 defendant Corp John   602759 602759 Corp, John, of Dertmouth 1
4655974 2247746 2247746 defendant Clerke William   602759 602759 Clerke, William, of Dertmouth 1
4657837 2248338 2248338 defendant Hauley John   602759 602759 Hauley, John, of Dertmouth 0
4658552 2248552 2248552 defendant Rowe Richard mariner 602759 602759 Rowe, Richard, of Dertmouth, mariner 5
4659472 2248822 2248822 defendant Edmound William merchant 602759 602759 Edmound, William, of Dertmouth, merchant 0
4663193 2249955 2249955 defendant Hawle John, senior (legal representative) 602759 602759 Hawle, John, senior, of Dertmouth, executor of 0
4663194 2249955 2249955 defendant Hawle John, junior   602759 602759 Hawle, John, junior, of Dertmouth 1
4663196 2249956 2249956 defendant Hawle John, senior (legal representative) 602759 602759 Hawle, John, senior, of Dertmouth, executor of 0
4663197 2249956 2249956 defendant Hawle John, junior   602759 602759 Hawle, John, junior, of Dertmouth 1
4663199 2249957 2249957 defendant Hawle John, senior (legal representative) 602759 602759 Hawle, John, senior, of Dertmouth, executor of 0
4663200 2249957 2249957 defendant Hawle John, junior   602759 602759 Hawle, John, junior, of Dertmouth 1
4666393 2250964 2250964 defendant Hert John shipman 602759 602759 Hert, John, of Dertmouth, shipman 0
4666395 2250964 2250964 defendant Caryet Robert shipman 602759 602759 Caryet, Robert, of Dertmouth, shipman 2
4666397 2250965 2250965 defendant Lancastell John hosteler 602759 602759 Lancastell, John, of Dertmouth, hosteler 0
4789927 2292920 2292920 defendant Buk Thomas mariner 602759 602759 Buk, Thomas, of Dertmouth, mariner 0
4812705 2300088 2300088 plaintiff Hanley John esq 602759 602759 Hanley, John, of Dertmouth, esq 0
4823080 2303302 2303302 defendant Crokker John   602759 602759 Crokker, John, of Dertmouth, mason 1
4871507 2318056 2318056 plaintiff Molenere Michael merchant 602759 602759 Molenere, Michael, of Dertmouth, merchant 0
4871509 2318057 2318057 plaintiff Molenere Michael merchant 602759 602759 Molenere, Michael, of Dertmouth, merchant 0
4871568 2318079 2318079 plaintiff More William   602759 602759 More, William, of Dertmouth 1
4933734 2336928 2336928 defendant Loveney Thomas gent 602759 602759 Loveney, Thomas, of Dertmouth, gent 1
5079019 2380208 2380208 defendant Newman John mariner 602759 602759 Newman, John, of Dertmouth, mariner 3
5083883 2381680 2381680 defendant Payne Robert mariner 602759 602759 Payne, Robert, of Dertmouth, mariner 2
5087945 2382853 2382853 defendant Taillour Thomas   602759 602759 Taillour, Thomas, of Dertmouth mariner 2
5087946 2382853 2382853 defendant Payne Robert mariner 602759 602759 Payne, Robert, of Dertmouth, mariner 3
5110954 2389597 2389597 defendant Babbe Gervase (legal representative) 602759 602759 Babbe, Gervase, of Dertmouth, administratrix of 0
5117419 2391526 2391526 defendant Skelton William   602759 602759 Skelton, William, of Dertmouth, ship master 3
5120818 2392519 2392519 defendant Stebbyng Nicholas gent 602759 602759 Stebbyng, Nicholas, of Dertmouth, gent 1
5120825 2392521 2392521 defendant Stebbyng Nicholas gent 602759 602759 Stebbyng, Nicholas, of Dertmouth, gent 1
5227967 2423791 2423791 plaintiff Marchall William merchant 602759 602759 Marchall, William, of Dertmouth, merchant 1
5229515 2424245 2424245 defendant Gaynecote John   602759 602759 Gaynecote, John, of Dertmouth, merchant, administrators of 2
5257762 2432549 2432549 plaintiff Gale Thomas   602759 602759 Gale, Thomas, of Dertmouth 0
5269688 2436247 2436247 plaintiff Code Robert   602759 602759 Code, Robert, of Dertmouth 0
5318860 2450735 2450735 defendant Amadas Walter merchant 602759 602759 Amadas, Walter, of Dertmouth, merchant 0
5323926 2452238 2452238 plaintiff Wychals John   602759 602759 (Wychals, John, of Dertmouth 1
5470316 2496044 2496044 plaintiff Gale Thomas   602759 602759 Gale, Thomas, of Dertmouth 0
5478679 2498649 2498649 defendant Clerke Margaret widow 602759 602759 Clerke, Margaret, of Dertmouth, widow 2
5548682 2519659 2519659 plaintiff Tanner John merchant 602759 602759 Tanner, John, of Dertmouth, merchant 1
5548686 2519660 2519660 plaintiff Tanner John merchant 602759 602759 Tanner, John, of Dertmouth, merchant 1
5568445 2525320 2525320 defendant Aleyn John merchant 602759 602759 Aleyn, John, of Dertmouth, merchant 0
5568452 2525321 2525321 defendant Aleyn John merchant 602759 602759 Aleyn, John, of Dertmouth, merchant 0
5585778 2530611 2530611 defendant Dymmok Thomas merchant 602759 602759 Dymmok, Thomas, of Dertmouth, merchant 1
5589202 2531628 2531628 defendant Robynson William merchant 602759 602759 Robynson, William, of Dertmouth, merchant 0
5590078 2531880 2531880 plaintiff Seymour Nicholas   602759 602759 Seymour, Nicholas, of Dertmouth 0
5624942 2551736 2551736 defendant Monlysh or Moulysh John mariner 602759 602759 Monlysh or Moulysh, John, of Dertmouth, mariner 0
5626470 2552250 2552250 defendant Evelyng John shoemaker 602759 602759 Evelyng, John, of Dertmouth, shoemaker 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);