names

35 rows where place_id = 624953

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3761283 1945533 1945533 defendant Smyth Richard mariner 624953 624953 Smyth, Richard, of Dele, mariner 0
3761284 1945533 1945533 defendant Newrynge Robert mariner 624953 624953 Newrynge, Robert, of Dele, mariner 1
3761285 1945533 1945533 defendant Stevyn Robert mariner 624953 624953 Stevyn, Robert, of Dele, mariner 2
3761286 1945533 1945533 defendant Gyllow John mariner 624953 624953 Gyllow, John, of Dele, mariner 3
3761287 1945533 1945533 defendant Tome John mariner 624953 624953 Tome, John, of Dele, mariner 4
3761288 1945533 1945533 defendant Ambler John mariner 624953 624953 Ambler, John, of Dele, mariner 5
3761289 1945533 1945533 defendant Osberne William mariner 624953 624953 Osberne, William, of Dele, mariner 6
3794821 1956250 1956250 defendant Redeman Thomas laborer 624953 624953 Redeman, Thomas, of Dele, laborer 5
4482608 2195264 2195264 plaintiff Monand William   624953 624953 Monand, William, of Dele 0
4573010 2223092 2223092 defendant Fyneux Thomas   624953 624953 Fyneux, Thomas, of Dele 0
4578677 2224819 2224819 defendant Maister Thomas   624953 624953 Maister, Thomas, of Dele 0
4657452 2248222 2248222 defendant Code William shipman 624953 624953 Code, William, of Dele, shipman 0
4657453 2248222 2248222 defendant Pastor Henry husbandman 624953 624953 Pastor, Henry, of Dele, husbandman 1
4734856 2276058 2276058 defendant Noryng Robert laborer 624953 624953 Noryng, Robert, of Dele, laborer 0
5266030 2435128 2435128 defendant Cryell John butcher 624953 624953 Cryell, John, of Dele, butcher 0
5266033 2435128 2435128 defendant Judde James husbandman 624953 624953 Judde, James, of Dele, husbandman 3
5302497 2445717 2445717 defendant Berd Thomas husbandman 624953 624953 Berd, Thomas, of Dele, husbandman 1
5315861 2449816 2449816 defendant Cryell John yeoman 624953 624953 Cryell, John, of Dele, yeoman 0
5315969 2449850 2449850 defendant Cryell John yeoman 624953 624953 Cryell, John, of Dele, yeoman 0
5317894 2450439 2450439 defendant Sayer Thomas husbandman 624953 624953 Sayer, Thomas, of Dele, husbandman 0
5437982 2486297 2486297 defendant Bewell Henry draper 624953 624953 Bewell, Henry, of Dele, draper 2
5437986 2486298 2486298 defendant Reynold Henry draper 624953 624953 Reynold, Henry, of Dele, draper 0
5487183 2501063 2501063 defendant Bewell Hamo husbandman 624953 624953 Bewell, Hamo, of Dele, husbandman 0
5488084 2501328 2501328 defendant Frevill or Frenill George husbandman 624953 624953 Frevill or Frenill, George, of Dele, husbandman 0
5501759 2505484 2505484 defendant Richer Ralph mariner 624953 624953 Richer, Ralph, of Dele, mariner 0
5501761 2505485 2505485 defendant Richer Ralph mariner 624953 624953 Richer, Ralph, of Dele, mariner 0
5516118 2509890 2509890 defendant Rycher Ralph mariner 624953 624953 Rycher, Ralph, of Dele, mariner 0
5530593 2514084 2514084 defendant Morys Richard husbandman 624953 624953 Morys, Richard, of Dele, husbandman 5
5530594 2514084 2514084 defendant Beverigge Henry (legal representative) 624953 624953 Beverigge, Henry, of Dele, yeoman, executor of 6
5530595 2514084 2514084 defendant Homon Thomas husbandman 624953 624953 Homon, Thomas, of Dele, husbandman 7
5599783 2534820 2534820 defendant Palmer James shipman or sheepman 624953 624953 Palmer, James, of Dele, shipman or sheepman 0
5599784 2534820 2534820 defendant Rycher Thomas husbandman 624953 624953 Rycher, Thomas, of Dele, husbandman 1
5623733 2551360 2551360 defendant Cook Thomas butcher 624953 624953 Cook, Thomas, of Dele, butcher 0
5635273 2554997 2554997 defendant Cartere Thomas shipman 624953 624953 Cartere, Thomas, of Dele, shipman 0
5635274 2554997 2554997 defendant Richard Hamo ripier or fishmonger 624953 624953 Richard, Hamo, of Dele, ripier or fishmonger 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);