names

32 rows where place_id = 599223

✎ 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
3635814 1906002 1906002 defendant Stafford William miller 599223 599223 Stafford, William, of Talyngton, miller 0
3635816 1906002 1906002 defendant Pany or Pavy John husbandman 599223 599223 Pany or Pavy, John, of Talyngton, husbandman 2
3637404 1906504 1906504 defendant Pany or Pavy John husbandman 599223 599223 Pany or Pavy, John, of Talyngton, husbandman 1
3662577 1914213 1914213 defendant Watkyns William husbandman 599223 599223 Watkyns, William, of Talyngton, husbandman 0
3741615 1939247 1939247 defendant Grant Robert husbandman 599223 599223 Grant, Robert, of Talyngton, husbandman 1
3741616 1939247 1939247 defendant Pavy William husbandman 599223 599223 Pavy, William, of Talyngton, husbandman 2
3741617 1939247 1939247 defendant Osson John husbandman 599223 599223 Osson, John, of Talyngton, husbandman 3
3741618 1939247 1939247 defendant Thystylton John husbandman 599223 599223 Thystylton, John, of Talyngton, husbandman 4
4510454 2203728 2203728 defendant Frere John chaplain 599223 599223 Frere, John, of Talyngton, chaplain 0
4510587 2203773 2203773 defendant Frere John chaplain 599223 599223 Frere, John, of Talyngton, chaplain 0
4538055 2212182 2212182 defendant Clerk John   599223 599223 Clerk, John, of Talyngton 1
4568746 2221808 2221808 plaintiff Thorney Simon   599223 599223 Thorney, Simon, of Talyngton 2
4581574 2225682 2225682 defendant Clerk Peter   599223 599223 Clerk, Peter, of Talyngton 0
4593455 2229240 2229240 defendant Whityng William   599223 599223 Whityng, William, of Talyngton 0
4593458 2229241 2229241 defendant Whityng William   599223 599223 Whityng, William, of Talyngton 0
4594099 2229414 2229414 plaintiff Peyntour William   599223 599223 Peyntour, William, of Talyngton 0
4662077 2249615 2249615 defendant (not given) Geoffrey his son, chapman 599223 599223 Geoffrey, his son, of Talyngton, chapman 1
4708719 2268099 2268099 defendant Wryght John husbamdman 599223 599223 Wryght, John, of Talyngton, husbamdman 0
4708721 2268099 2268099 defendant Archer William carver 599223 599223 Archer, William, of Talyngton, carver 2
4710743 2268714 2268714 defendant Rest Geoffrey husbandman 599223 599223 Rest, Geoffrey, of Talyngton, husbandman 0
4716803 2270582 2270582 defendant Rest William husbandman 599223 599223 Rest, William, of Talyngton, husbandman 1
4746867 2279584 2279584 defendant Payk Stephen husbandman 599223 599223 Payk, Stephen, of Talyngton, husbandman 5
4746868 2279584 2279584 defendant Payk William husbandman 599223 599223 Payk, William, of Talyngton, husbandman 6
4846759 2310493 2310493 defendant Broun John husbandman 599223 599223 Broun, John, of Talyngton, husbandman 2
4866268 2316418 2316418 defendant Kynge John husbandman 599223 599223 Kynge, John, of Talyngton, husbandman 0
4874062 2318828 2318828 defendant Roger John husbandman 599223 599223 Roger, John, of Talyngton, husbandman 1
4930932 2336071 2336071 defendant Kaye James   599223 599223 Kaye, James, of Talyngton, vicar 0
4935724 2337563 2337563 defendant Rest William husbandman 599223 599223 Rest, William, of Talyngton, husbandman 1
5188891 2412486 2412486 defendant Peynter William husbandman 599223 599223 Peynter, William, of Talyngton, husbandman 3
5351233 2460478 2460478 defendant Rest John laborer 599223 599223 Rest, John, of Talyngton, laborer 1
5365050 2464739 2464739 defendant Waryn John husbandman 599223 599223 Waryn, John, of Talyngton, husbandman 1
5517720 2510382 2510382 defendant Thornholm Henry yeoman 599223 599223 Thornholm, Henry, of Talyngton, 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);