names

34 rows where place_id = 770708

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4570540 2222359 2222359 defendant Bocher Walter   770708 770708 Bocher, Walter, of Houke 4
4586868 2227293 2227293 plaintiff Holdernesse Roger   770708 770708 Holdernesse, Roger, of Houke 0
4586869 2227293 2227293 defendant Hoton John   770708 770708 Hoton, John, of Houke 0
4605571 2232864 2232864 defendant Spence James de   770708 770708 Spence, James de, of Houke 0
4605572 2232864 2232864 defendant Olyve John   770708 770708 Olyve, John, of Houke 1
4605573 2232864 2232864 defendant Baillour William   770708 770708 Baillour, William, of Houke 2
4605574 2232864 2232864 defendant Rede John   770708 770708 Rede, John, of Houke 3
4605575 2232864 2232864 defendant Bene Johhn   770708 770708 Bene, Johhn, of Houke 4
4605576 2232864 2232864 defendant Bradhe William   770708 770708 Bradhe, William, of Houke 5
4605577 2232864 2232864 defendant Gousyll William   770708 770708 Gousyll, William, of Houke 6
4605578 2232864 2232864 defendant Totty John   770708 770708 Totty, John, of Houke 7
4605579 2232864 2232864 defendant Chaunceller William   770708 770708 Chaunceller, William, of Houke 8
4605581 2232864 2232864 defendant Clerke John   770708 770708 Clerke, John, of Houke 10
4605582 2232864 2232864 defendant Uttyng Richard   770708 770708 Uttyng, Richard, of Houke 11
4605583 2232864 2232864 defendant Bateman Richard   770708 770708 Bateman, Richard, of Houke 12
4689326 2262222 2262222 defendant Moram Roger husbandman 770708 770708 Moram, Roger, of Houke, husbandman 0
4708191 2267941 2267941 defendant del Spence James husbandman 770708 770708 del Spence, James, of Houke, husbandman 2
4712012 2269068 2269068 defendant Snawe Thomas chaplain 770708 770708 Snawe, Thomas, of Houke, chaplain 0
4723327 2272605 2272605 defendant Rede John fishmonger 770708 770708 Rede, John, of Houke, fishmonger 3
4854651 2312828 2312828 defendant Ibbotson Thomas husbandman 770708 770708 Ibbotson, Thomas, of Houke, husbandman 4
4877054 2319794 2319794 defendant Ibotson Thomas husbandman 770708 770708 Ibotson, Thomas, of Houke, husbandman 3
4898150 2326084 2326084 defendant Nuttyng Richard husbandman 770708 770708 Nuttyng, Richard, of Houke, husbandman 0
4948935 2341649 2341649 defendant Rauly- William husbandman 770708 770708 Rauly-, William, of Houke, husbandman 1
5033859 2366781 2366781 defendant Milner Robert husbandman 770708 770708 Milner, Robert, of Houke, husbandman 0
5033860 2366781 2366781 defendant Gonsell or Gousell John husbandman 770708 770708 Gonsell or Gousell, John, of Houke, husbandman 1
5033861 2366781 2366781 defendant Beryer William husbandman 770708 770708 Beryer, William, of Houke, husbandman 2
5033862 2366781 2366781 defendant Ghonsell or Gousell John, junior husbandman 770708 770708 Ghonsell or Gousell, John, junior, of Houke, husbandman 3
5092205 2384099 2384099 defendant Mersheflete William husbandman 770708 770708 Mersheflete, William, of Houke, husbandman 0
5228762 2424023 2424023 defendant Gildersdale Robert laborer 770708 770708 together with Gildersdale, Robert, of Houke, laborer 1
5298059 2444445 2444445 defendant Brady Richard husbandman 770708 770708 Brady, Richard, of Houke, husbandman 1
5365041 2464737 2464737 defendant Coltard Robert yeoman 770708 770708 Coltard, Robert, of Houke, yeoman 0
5365042 2464737 2464737 defendant Nelson Robert husbandman 770708 770708 Nelson, Robert, of Houke, husbandman 1
5629284 2553136 2553136 defendant de Spence James yeoman 770708 770708 de Spence, James, of Houke, yeoman 0
5634392 2554749 2554749 defendant de la Spense James gent 770708 770708 de la Spense, James, of Houke, gent 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);