names

26 rows where place_id = 587545

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591708 1865025 1865025 defendant Lamkyn Richard miller 587545 587545 Lamkyn, Richard, of Halton juxta Spillesby, miller 0
3828793 1966882 1966882 defendant Awcok Richard yeoman 587545 587545 Awcok, Richard, of Halton juxta Spillesby, yeoman 0
4072117 2050327 2050327 defendant Anton Benet yeoman 587545 587545 Anton, Benet, of Halton juxta Spillesby, yeoman 0
4173935 2086341 2086341 defendant Archevoll or Archumvoll Thomas husbandman 587545 587545 Archevoll or Archumvoll, Thomas, of Halton juxta Spillesby, husbandman 0
4655071 2247470 2247470 defendant de Botheby William husbandman 587545 587545 de Botheby, William, of Halton juxta Spillesby, husbandman 0
4660370 2249071 2249071 defendant Taillour Thomas   587545 587545 Taillour, Thomas, of Halton juxta Spillesby 0
4663304 2249994 2249994 plaintiff Girne William   587545 587545 Girne, William, of Halton juxta Spillesby 0
4797420 2295362 2295362 defendant Umfrey Richard husbandman 587545 587545 Umfrey, Richard, of Halton juxta Spillesby, husbandman 0
4797422 2295363 2295363 defendant Umfrey Richard husbandman 587545 587545 Umfrey, Richard, of Halton juxta Spillesby, husbandman 0
4801618 2296690 2296690 defendant Orpyn John husbandman 587545 587545 Orpyn, John, of Halton juxta Spillesby, husbandman 1
4899010 2326333 2326333 defendant Oumfray John husbandman 587545 587545 Oumfray, John, of Halton juxta Spillesby, husbandman 0
4960763 2345180 2345180 defendant Holand Richard butcher 587545 587545 Holand, Richard, of Halton juxta Spillesby, butcher 1
4983394 2351941 2351941 defendant Well Thomas chaplain 587545 587545 Well, Thomas, of Halton juxta Spillesby, chaplain 0
5076400 2379442 2379442 defendant Chalevere or Chalenere Thomas   587545 587545 Chalevere or Chalenere, Thomas, of Halton juxta Spillesby, husbandman, executirx of 0
5076401 2379442 2379442 defendant Chalevere or Chalenere Alice widow 587545 587545 Chalevere or Chalenere, Alice, of Halton juxta Spillesby, widow 1
5084667 2381929 2381929 defendant Totte Henry weaver 587545 587545 Totte, Henry, of Halton juxta Spillesby, weaver 0
5097287 2385638 2385638 defendant Miton Richard laborer 587545 587545 Miton, Richard, of Halton juxta Spillesby, laborer 0
5103312 2387399 2387399 defendant Benetson John fisher 587545 587545 (Benetson, John, of Halton juxta Spillesby, fisher 3
5487500 2501156 2501156 defendant Chamber Thomas yeoman 587545 587545 Chamber, Thomas, of Halton juxta Spillesby, yeoman 0
5500505 2505090 2505090 defendant Pawlyn Richard chaplain 587545 587545 Pawlyn, Richard, of Halton juxta Spillesby, chaplain 1
5515997 2509850 2509850 defendant Affen Benedict husbandman 587545 587545 Affen, Benedict, of Halton juxta Spillesby, husbandman 1
5519596 2510962 2510962 defendant Smyth John chapman 587545 587545 Smyth, John, of Halton juxta Spillesby, chapman 0
5522431 2511835 2511835 defendant Fen Benedict husbandman 587545 587545 Fen, Benedict, of Halton juxta Spillesby, husbandman 3
5522437 2511836 2511836 defendant Fen Benedict husbandman 587545 587545 Fen, Benedict, of Halton juxta Spillesby, husbandman 3
5558438 2522415 2522415 defendant Russell Thomas husbandman 587545 587545 Russell, Thomas, of Halton juxta Spillesby, husbandman 2
5569941 2525785 2525785 defendant Copy Robert husbandman 587545 587545 Copy, Robert, of Halton juxta Spillesby, husbandman 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);