names

36 rows where place_id = 592577

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608142 1870199 1870199 defendant Salbrugge John husbandman 592577 592577 Salbrugge, John, of Ascote, husbandman 0
4536093 2211565 2211565 defendant Palmer John   592577 592577 Palmer, John, of Ascote 0
4549589 2215815 2215815 defendant Medmenham Thomas   592577 592577 Medmenham, Thomas, of Ascote 0
4563836 2220257 2220257 defendant Hert Richard   592577 592577 Hert, Richard, of Ascote 0
4563837 2220257 2220257 defendant Whityng Thomas   592577 592577 Whityng, Thomas, of Ascote 1
4633683 2241382 2241382 defendant Mynworth William   592577 592577 Mynworth, William, of Ascote 1
4636111 2242125 2242125 defendant Ponde Thomas   592577 592577 Ponde, Thomas, of Ascote 0
4657042 2248094 2248094 defendant Ponde Thomas fisher 592577 592577 Ponde, Thomas, of Ascote, fisher 0
4675336 2257897 2257897 defendant atte Thorne Richard forester & husbandman 592577 592577 atte Thorne, Richard, of Ascote, forester & husbandman 0
4675337 2257897 2257897 defendant Bette William   592577 592577 Bette, William, of Ascote, forest bailiff & husbandman 1
4675338 2257897 2257897 defendant Warner John yeoman 592577 592577 Warner, John, of Ascote, yeoman 2
4675339 2257897 2257897 defendant Hyenes John butcher 592577 592577 Hyenes, John, of Ascote, butcher 3
4675431 2257925 2257925 defendant Taillour Richard husbandman 592577 592577 Taillour, Richard, of Ascote, husbandman 0
4679147 2259088 2259088 defendant Spencer Richard husbandman 592577 592577 Spencer, Richard, of Ascote, husbandman 0
4679148 2259088 2259088 defendant Brok Richard husbandman 592577 592577 Brok, Richard, of Ascote, husbandman 1
4712556 2269244 2269244 defendant Hirne John husbandman 592577 592577 Hirne, John, of Ascote, husbandman 1
4715628 2270216 2270216 plaintiff Warner John   592577 592577 Warner, John, of Ascote 0
4724122 2272839 2272839 defendant Mynworth William husbandman 592577 592577 Mynworth, William, of Ascote, husbandman 0
4748163 2279972 2279972 defendant Thorp Thomas   592577 592577 Thorp, Thomas, of Ascote, bailiff 0
4767102 2285697 2285697 defendant Collyng Walter husbandman 592577 592577 Collyng, Walter, of Ascote, husbandman 4
4774713 2288082 2288082 plaintiff Warner John (legal representative) 592577 592577 Warner, John, of Ascote, executors of 0
4794476 2294409 2294409 defendant Smyth Thomas husbandman 592577 592577 Smyth, Thomas, of Ascote, husbandman 0
4812805 2300122 2300122 defendant Thomes Roger husbandman 592577 592577 Thomes, Roger, of Ascote, husbandman 0
4819389 2302138 2302138 defendant Collyng Walter husbandman 592577 592577 Collyng, Walter, of Ascote, husbandman 1
4823572 2303463 2303463 defendant Thorp Thomas   592577 592577 Thorp, Thomas, of Ascote, bailiff 4
4894938 2325078 2325078 defendant Spencer Richard husbandman 592577 592577 Spencer, Richard, of Ascote, husbandman 4
4934553 2337201 2337201 defendant Collyng Robert husbandman 592577 592577 Collyng, Robert, of Ascote, husbandman 1
5086682 2382496 2382496 defendant Snell or Suell Thomas (legal representative) 592577 592577 Snell or Suell, Thomas,of Ascote, executors of 0
5086683 2382496 2382496 defendant Snell or Suell John husbandman 592577 592577 (Snell or Suell, John, of Ascote, husbandman 1
5100750 2386644 2386644 defendant Payne Thomas husbandman 592577 592577 Payne, Thomas, of Ascote, husbandman 0
5152779 2401953 2401953 defendant Rookes John esq 592577 592577 Rookes, John, of Ascote, esq 3
5170419 2407076 2407076 defendant Rokes John esq 592577 592577 Rokes, John, of Ascote, esq 3
5256843 2432269 2432269 defendant Payne Thomas husbandman 592577 592577 Payne, Thomas, of Ascote, husbandman 0
5437697 2486209 2486209 defendant Knyght Edward   592577 592577 Knyght, Edward, of Ascote 0
5579933 2528803 2528803 defendant Powes Thomas husbandman 592577 592577 Powes, Thomas, of Ascote, husbandman 2
5599499 2534735 2534735 defendant Saunder Robert butcher 592577 592577 Saunder, Robert, of Ascote, butcher 2

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);