names

45 rows where place_id = 761153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4429154 2173925 2173925 plaintiff Tyete John   761153 761153 Tyete, John, of Romene, son of William 0
4476501 2193317 2193317 defendant Roger John   761153 761153 Roger, John, of Romene 0
4534229 2210971 2210971 plaintiff Salerne John   761153 761153 Salerne, John, of Romene 0
4537645 2212046 2212046 plaintiff Talbot John   761153 761153 Talbot, John, of Romene 0
4542645 2213586 2213586 plaintiff Adam Stephen   761153 761153 Adam, Stephen, of Romene 0
4563647 2220196 2220196 plaintiff Rokesle Thomas   761153 761153 Rokesle, Thomas, of Romene 0
4585225 2226803 2226803 defendant Borde James chaplain 761153 761153 Borde, James, of Romene, chaplain 0
4597485 2230458 2230458 plaintiff Sherthe Brian   761153 761153 Sherthe, Brian, of Romene 0
4600266 2231310 2231310 plaintiff Thornton John de   761153 761153 Thornton, John de, of Romene 0
4617737 2236547 2236547 defendant Adam John   761153 761153 Adam, John, of Romene 0
4628328 2239787 2239787 defendant Adkyn John   761153 761153 Adkyn, John, of Romene 0
4638905 2242900 2242900 defendant Denys William   761153 761153 Denys, William, of Romene 2
4651788 2246512 2246512 defendant Ive John husbandman 761153 761153 Ive, John, of Romene, husbandman 3
4651789 2246512 2246512 defendant Chanew William husbandman 761153 761153 Chanew, William, of Romene, husbandman 4
4655173 2247500 2247500 defendant Worthe John chapman 761153 761153 Worthe, John, of Romene, chapman 0
4655658 2247653 2247653 defendant Worthe John chapman 761153 761153 Worthe, John, of Romene, chapman 0
4664298 2250315 2250315 defendant Jeffe Robert, junior husbandman 761153 761153 Jeffe, Robert, junior, of Romene, husbandman 2
4664303 2250316 2250316 defendant Jeffe Robert, junior husbandman 761153 761153 Jeffe, Robert, junior, of Romene, husbandman 2
4665636 2250725 2250725 plaintiff Holyere Robert   761153 761153 Holyere, Robert, of Romene 0
4666793 2255343 2255343 defendant Kempe John, junior yeoman 761153 761153 Kempe, John, junior, of Romene, yeoman 0
4674861 2257746 2257746 defendant Sherte John   761153 761153 Sherte, John, of Romene 6
4769607 2286470 2286470 defendant Pendere John butcher 761153 761153 Pendere, John, of Romene, butcher 1
4776356 2288598 2288598 plaintiff Adam John gent 761153 761153 Adam, John, of Romene, gent 0
4776365 2288600 2288600 defendant Horne John hosteler 761153 761153 Horne, John, of Romene, hosteler 0
4776367 2288601 2288601 defendant Holyngbrok William husbandman 761153 761153 Holyngbrok, William, of Romene, husbandman 0
4776368 2288601 2288601 defendant Yne or Yve William weaver 761153 761153 Yne or Yve, William, of Romene, weaver 1
4795945 2294878 2294878 defendant Couper Alice widow 761153 761153 Couper, Alice, of Romene, widow 2
4796503 2295064 2295064 defendant Pendere John butcher 761153 761153 Pendere, John, of Romene, butcher 0
4796510 2295066 2295066 defendant Pendere John butcher 761153 761153 Pendere, John, of Romene, butcher 0
4863549 2315570 2315570 defendant Love Lawrence tailor 761153 761153 Love, Lawrence, of Romene, tailor 1
4863551 2315570 2315570 defendant Brykynden Richard husbandman 761153 761153 Brykynden, Richard, of Romene, husbandman 3
4871217 2317976 2317976 defendant Randolf Richard baker 761153 761153 Randolf, Richard, of Romene, baker 0
4939936 2338876 2338876 defendant Spaldyng Walter clerk 761153 761153 Spaldyng, Walter, of Romene, clerk 0
4964168 2346191 2346191 defendant Barry Thomas gent 761153 761153 Barry, Thomas, of Romene, gent 0
4972236 2348641 2348641 defendant Joseph John yeoman 761153 761153 Joseph, John, of Romene, yeoman 0
4972237 2348641 2348641 defendant Lowys John gent 761153 761153 Lowys, John, of Romene, gent 1
5025567 2364383 2364383 defendant Joseph John yeoman 761153 761153 Joseph, John, of Romene, yeoman 1
5025572 2364384 2364384 defendant Joseph John yeoman 761153 761153 Joseph, John, of Romene, yeoman 0
5025574 2364385 2364385 defendant Joseph John yeoman 761153 761153 Joseph, John, of Romene, yeoman 0
5025581 2364387 2364387 defendant Clytherowe Richard esq 761153 761153 Clytherowe, Richard, of Romene, esq 0
5102841 2387249 2387249 defendant Fayreware Richard husbandman 761153 761153 Fayreware, Richard, of Romene, husbandman 0
5113289 2390280 2390280 defendant Joseph John gent 761153 761153 Joseph, John, of Romene, gent 0
5481456 2499388 2499388 defendant Woder William yeoman 761153 761153 Woder, William, of Romene, yeoman 4
5614986 2548481 2548481 plaintiff Fraunceys John   761153 761153 Fraunceys, John, of Romene 0
5627095 2552441 2552441 defendant Munseford John   761153 761153 Munseford, John, of Romene 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);