names

35 rows where place_id = 604529

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3658311 1912854 1912854 defendant Emonson Lionel husbandman 604529 604529 (Emonson, Lionel, of Ripon, Yorks, husbandman 1
3705019 1927862 1927862 defendant Sele Christopher clerk 604529 604529 Sele, Christopher, of Ripon, Yorks, clerk 0
4256900 2115280 2115280 defendant Hutchenson John chapman 604529 604529 Hutchenson, John, of Ripon, Yorks, chapman 1
4269157 2119279 2119279 defendant Hutchenson John chapman 604529 604529 Hutchenson, John, of Ripon, Yorks, chapman 1
4706282 2267345 2267345 defendant Dall John esq 604529 604529 Dall, John, of Ripon, Yorks, esq 0
4710990 2268794 2268794 defendant Sulby John   604529 604529 Sulby, John, of Ripon, Yorks, canon in the collegiate church 0
4744660 2278957 2278957 defendant Snaythe Robert esq 604529 604529 Snaythe, Robert, of Ripon, Yorks, esq 6
4750027 2280482 2280482 defendant Stowe William gent 604529 604529 Stowe, William, of Ripon, Yorks, gent 0
4769863 2286549 2286549 defendant Geldherd Peter   604529 604529 Geldherd, Peter, of Ripon, Yorks 0
4769870 2286550 2286550 defendant Stowe William gent 604529 604529 Stowe, William, of Ripon, Yorks, gent 0
4771726 2287133 2287133 defendant Faukes William chaplain 604529 604529 Faukes, William, of Ripon, Yorks, chaplain 0
4815507 2300955 2300955 defendant Palhardy Richard chapman 604529 604529 Palhardy, Richard, of Ripon, Yorks, chapman 1
4817666 2301613 2301613 defendant Water William de yeoman 604529 604529 Water, William de, of Ripon, Yorks, yeoman 0
4822464 2303097 2303097 defendant Thorp Lawrence husbandman 604529 604529 Thorp, Lawrence, of Ripon, Yorks, husbandman 0
4823481 2303433 2303433 defendant Playn William clerk 604529 604529 Playn, William, of Ripon, Yorks, clerk 0
4828159 2304849 2304849 defendant Wetherby John mercer 604529 604529 Wetherby, John, of Ripon, Yorks, mercer 0
4830980 2305714 2305714 defendant Flesshewer John dyer 604529 604529 Flesshewer, John, of Ripon, Yorks, dyer 0
4842203 2309095 2309095 defendant Kirkeby John dyer 604529 604529 Kirkeby, John, of Ripon, Yorks, dyer 0
4854074 2312683 2312683 defendant Kyrkeby John dyer 604529 604529 Kyrkeby, John, of Ripon, Yorks, dyer 1
4908588 2329241 2329241 defendant Skrogis William chapman 604529 604529 Skrogis, William, of Ripon, Yorks, chapman 4
4908592 2329242 2329242 defendant Skrogys William chapman 604529 604529 Skrogys, William, of Ripon, Yorks, chapman 2
5041725 2369126 2369126 defendant Percyvell John gent 604529 604529 Percyvell, John, of Ripon, Yorks, gent 0
5104485 2387740 2387740 defendant Flesshewer alias Lyster John dyer 604529 604529 Flesshewer alias Lyster, John, of Ripon, Yorks, dyer 0
5104489 2387741 2387741 defendant Flesshware alis Litester John dyer 604529 604529 Flesshware alis Litester, John, of Ripon, Yorks, dyer 0
5125507 2393946 2393946 defendant Collys Thomas chapman 604529 604529 Collys, Thomas, of Ripon, Yorks, chapman 0
5127801 2394608 2394608 defendant Kyrkeby John dyer 604529 604529 Kyrkeby, John, of Ripon, Yorks, dyer 2
5140839 2398437 2398437 defendant Luffe Robert tanner 604529 604529 Luffe, Robert, of Ripon, Yorks, tanner 3
5145545 2399842 2399842 defendant Dokerer Roger widow 604529 604529 Dokerer, Roger, of Ripon, Yorks, widow 0
5161998 2404619 2404619 defendant Lyffe Robert tanner 604529 604529 Lyffe, Robert, of Ripon, Yorks, tanner 3
5304969 2446490 2446490 defendant Glasyn Thomas merchant 604529 604529 Glasyn, Thomas, of Ripon, Yorks, merchant 0
5306776 2447021 2447021 defendant Bysshop Richard painter 604529 604529 Bysshop, Richard, of Ripon, Yorks, painter 1
5405897 2476759 2476759 defendant Parkere Roland gent 604529 604529 Parkere, Roland, of Ripon, Yorks, gent 2
5434025 2485130 2485130 defendant Ulthwayt John mercer 604529 604529 Ulthwayt, John, of Ripon, Yorks, mercer 1
5451875 2490439 2490439 defendant Wardropere Lawrence dyer 604529 604529 Wardropere, Lawrence, of Ripon, Yorks, dyer 0
5463429 2493972 2493972 defendant Wryght John clerk 604529 604529 Wryght, John, of Ripon, Yorks, clerk 1

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