names

38 rows where place_id = 594629

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616898 1872917 1872917 defendant Atthorne Richard husbandman 594629 594629 Atthorne, Richard, of Selsey, husbandman 0
3935321 2002128 2002128 plaintiff Kempe John   594629 594629 Kempe, John, of Selsey 0
4168863 2084599 2084599 defendant Lewkenor Thomas esq 594629 594629 Lewkenor, Thomas, of Selsey, esq 0
4538148 2212215 2212215 defendant Bearde Robert   594629 594629 Bearde, Robert, of Selsey 0
4563192 2220058 2220058 defendant Clarisse John   594629 594629 Clarisse, John, of Selsey 0
4606851 2233253 2233253 defendant Inever John   594629 594629 Inever, John, of Selsey 0
4655725 2247673 2247673 defendant Grygge John, junior seaman 594629 594629 Grygge, John, junior, of Selsey, seaman 3
4667997 2255698 2255698 defendant Barde Robert husbandman 594629 594629 Barde, Robert, of Selsey, husbandman 0
4697933 2264845 2264845 defendant West John husbandman 594629 594629 West, John, of Selsey, husbandman 2
4722752 2272433 2272433 defendant Barde Richard husbandman 594629 594629 Barde, Richard, of Selsey, husbandman 1
4747272 2279707 2279707 defendant Lone or Love John husbandman 594629 594629 Lone or Love, John, of Selsey, husbandman 1
4747318 2279718 2279718 defendant Love John husbandman 594629 594629 Love, John, of Selsey, husbandman 0
4747322 2279719 2279719 defendant Herver Richard laborer 594629 594629 Herver, Richard, of Selsey, laborer 1
4751031 2280783 2280783 defendant Aylemere William husbandman 594629 594629 Aylemere, William, of Selsey, husbandman 0
4853651 2312560 2312560 defendant Aylmere John shipman 594629 594629 Aylmere, John, of Selsey, shipman 1
4868045 2316976 2316976 defendant Lemman John husbandman 594629 594629 Lemman, John, of Selsey, husbandman 0
4891742 2324160 2324160 defendant Aynolfe Roger husbandman 594629 594629 Aynolfe, Roger, of Selsey, husbandman 0
4918330 2332251 2332251 defendant Grenelef Thomas husbandman 594629 594629 Grenelef, Thomas, of Selsey, husbandman 0
4920835 2333029 2333029 defendant Bastard alias Bocher William husbandman 594629 594629 Bastard alias Bocher, William, of Selsey, husbandman 0
4944972 2340415 2340415 defendant Webbe Richard husbandman 594629 594629 Webbe, Richard, of Selsey, husbandman 2
4944973 2340415 2340415 defendant Bocher William husbandman 594629 594629 Bocher, William, of Selsey, husbandman 3
4951292 2342367 2342367 defendant Baron John clerk 594629 594629 Baron, John, of Selsey, clerk 0
4951293 2342367 2342367 defendant atte Hethe Thomas husbandman 594629 594629 atte Hethe, Thomas, of Selsey, husbandman 1
4999603 2356756 2356756 plaintiff Lenne or Kenne Robert   594629 594629 Lenne or Kenne, Robert, of Selsey 0
5063133 2375509 2375509 defendant Pynder William clerk 594629 594629 Pynder, William, of Selsey, clerk 0
5092631 2384223 2384223 defendant Crystemas John husbandman 594629 594629 Crystemas, John, of Selsey, husbandman 0
5100398 2386557 2386557 defendant atte Hethe Thomas husbandman 594629 594629 atte Hethe, Thomas, of Selsey, husbandman 0
5100399 2386557 2386557 defendant Boys John, senior husbandman 594629 594629 Boys, John, senior, of Selsey, husbandman 1
5100400 2386557 2386557 defendant Boys John, junior husbandman 594629 594629 Boys, John, junior, of Selsey, husbandman 2
5100401 2386557 2386557 defendant Boys William laborer 594629 594629 Boys, William, of Selsey, laborer 3
5112005 2389898 2389898 defendant Kenne Richard husbandman 594629 594629 Kenne, Richard, of Selsey, husbandman 0
5112006 2389898 2389898 defendant Kenne John husbandman 594629 594629 Kenne, John, of Selsey, husbandman 1
5112007 2389898 2389898 defendant Kenne Henry laborer 594629 594629 Kenne, Henry, of Selsey, laborer 2
5113043 2390210 2390210 plaintiff Kenne Richard   594629 594629 Kenne, Richard, of Selsey 0
5125155 2393834 2393834 defendant Somerlee Thomas husbandman 594629 594629 Somerlee, Thomas, of Selsey, husbandman 1
5143772 2399312 2399312 defendant Somerlee Thomas husbandman 594629 594629 Somerlee, Thomas, of Selsey, husbandman 1
5199062 2415477 2415477 defendant Boys John fishmonger 594629 594629 Boys, John, of Selsey, fishmonger 0
5277536 2438506 2438506 defendant Geffrey Richard chaplain 594629 594629 Geffrey, Richard, of Selsey, chaplain 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);