names

40 rows where place_id = 594002

✎ 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
3614130 1872085 1872085 defendant Olyver Robert husbandman 594002 594002 Olyver, Robert, of Thedylthorp, husbandman 0
3614131 1872085 1872085 defendant Ketyll John husbandman 594002 594002 Ketyll, John, of Thedylthorp, husbandman 1
3614132 1872085 1872085 defendant Leyesthorp William husbandman 594002 594002 Leyesthorp, William, of Thedylthorp, husbandman 2
3630675 1904422 1904422 defendant Hewetson Peter laborer 594002 594002 Hewetson, Peter, of Thedylthorp, laborer 0
3647329 1909552 1909552 defendant Smyth Robert yeoman 594002 594002 Smyth, Robert, of Thedylthorp, yeoman 0
3650782 1910607 1910607 defendant Smyth Robert husbandman 594002 594002 Smyth, Robert, of Thedylthorp, husbandman 0
3650783 1910607 1910607 defendant Cresy Thomas yeoman 594002 594002 Cresy, Thomas, of Thedylthorp, yeoman 1
3863088 1977854 1977854 defendant Rey Nicholas husbandman 594002 594002 Rey, Nicholas, of Thedylthorp, husbandman 3
4005693 2026809 2026809 defendant Cowper Thomas husbandman 594002 594002 Cowper, Thomas, of Thedylthorp, husbandman 0
4071800 2050212 2050212 defendant Smythe alias Kytchen Thomas husbandman 594002 594002 Smythe alias Kytchen, Thomas, of Thedylthorp, husbandman 0
4187415 2091096 2091096 defendant Alenson Robert carpenter 594002 594002 Alenson, Robert, of Thedylthorp, carpenter 1
4707698 2267773 2267773 plaintiff Moigne Laurence   594002 594002 Moigne, Laurence, of Thedylthorp 0
4731483 2275047 2275047 plaintiff Moyne Lawrence esq 594002 594002 Moyne, Lawrence, of Thedylthorp, esq 0
4775324 2288274 2288274 defendant Wyles Joan   594002 594002 Wyles, Joan, of Thedylthorp 0
5014911 2361237 2361237 defendant Angevyn Barnard gent 594002 594002 together with Angevyn, Barnard, of Thedylthorp, gent 1
5059614 2374444 2374444 defendant Stele William husbandman 594002 594002 Stele, William, of Thedylthorp, husbandman 3
5060399 2374687 2374687 defendant Balye John yeoman 594002 594002 Balye, John, of Thedylthorp, yeoman 0
5060400 2374687 2374687 defendant Balye Gilbert   594002 594002 Balye, Gilbert, of Thedylthorp, husbandman, his son 1
5074017 2378716 2378716 defendant Kyng William husbandman 594002 594002 Kyng, William, of Thedylthorp, husbandman 0
5076073 2379343 2379343 defendant Baly John husbandman 594002 594002 Baly, John, of Thedylthorp, husbandman 0
5083188 2381470 2381470 defendant Kynge alias Stele William husbandman 594002 594002 Kynge alias Stele, William, of Thedylthorp, husbandman 5
5140521 2398334 2398334 defendant Warde John husbandman 594002 594002 Warde, John, of Thedylthorp, husbandman 1
5171953 2407511 2407511 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 0
5175971 2408655 2408655 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 0
5175972 2408655 2408655 defendant Warde John, sen husbandman 594002 594002 Warde, John, sen, of Thedylthorp, husbandman 1
5190750 2413046 2413046 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 0
5197700 2415070 2415070 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 0
5197701 2415070 2415070 defendant Warde John husbandman 594002 594002 together with Warde, John, of Thedylthorp, husbandman 1
5200893 2416027 2416027 defendant Ketyll Robert husbandman 594002 594002 Ketyll, Robert, of Thedylthorp, husbandman 0
5215237 2420184 2420184 defendant Mylner John miller 594002 594002 Mylner, John, of Thedylthorp, miller 0
5270788 2436554 2436554 defendant Symkynson Richard merchant 594002 594002 Symkynson, Richard, of Thedylthorp, merchant 0
5296120 2443855 2443855 defendant Symkynson Ricard merchant 594002 594002 Symkynson, Ricard, of Thedylthorp, merchant 0
5297259 2444191 2444191 defendant Ely Robert husbandman 594002 594002 Ely, Robert, of Thedylthorp, husbandman 8
5297260 2444191 2444191 defendant Coke Gilbert husbandman 594002 594002 Coke, Gilbert, of Thedylthorp, husbandman 9
5494002 2503116 2503116 defendant Coleby William husbandman 594002 594002 Coleby, William, of Thedylthorp, husbandman 0
5520607 2511268 2511268 defendant Bowede or Bowode Richard yeoman 594002 594002 Bowede or Bowode, Richard, of Thedylthorp, yeoman 5
5530250 2513970 2513970 defendant Bowede Richard husbandman 594002 594002 Bowede, Richard, of Thedylthorp, husbandman 0
5535386 2515594 2515594 defendant Wilson Bernard clerk 594002 594002 Wilson, Bernard, of Thedylthorp, clerk 0
5535387 2515594 2515594 defendant Olyvere Robert husbandman 594002 594002 Olyvere, Robert, of Thedylthorp, husbandman 1
5540904 2517277 2517277 defendant Richardson William yeoman 594002 594002 Richardson, William, of Thedylthorp, yeoman 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);