names

23 rows where place_id = 802622

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4789611 2292822 2292822 defendant Eldryche John pulter 802622 802622 Eldryche, John, of Leghton Bosard, Beds, pulter 1
4817458 2301548 2301548 defendant Coteller John butcher 802622 802622 Coteller, John, of Leghton Bosard, Beds, butcher 2
4820126 2302371 2302371 defendant Lenot Thomas draper 802622 802622 Lenot, Thomas, of Leghton Bosard, Beds, draper 0
4822218 2303029 2303029 defendant Smyth John smith 802622 802622 Smyth, John, of Leghton Bosard, Beds, smith 2
4866018 2316340 2316340 defendant Coteler John butcher 802622 802622 Coteler, John, of Leghton Bosard, Beds, butcher 0
4936853 2337904 2337904 defendant Polwhever Roger barber 802622 802622 Polwhever, Roger, of Leghton Bosard, Beds, barber 2
4945923 2340710 2340710 defendant Coteler John yeoman 802622 802622 Coteler, John, of Leghton Bosard, Beds, yeoman 0
5096853 2385510 2385510 defendant Billyngton Hugh gent 802622 802622 Billyngton, Hugh, of Leghton Bosard, Beds, gent 1
5123027 2393166 2393166 defendant atte Seler Duncun fuller 802622 802622 atte Seler, Duncun, of Leghton Bosard, Beds, fuller 0
5238251 2426773 2426773 defendant Seller Duncan fuller 802622 802622 Seller, Duncan, of Leghton Bosard, Beds, fuller 0
5403733 2476140 2476140 defendant Rycot Robert yeoman 802622 802622 Rycot, Robert, of Leghton Bosard, Beds, yeoman 0
5404180 2476275 2476275 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 1
5416839 2479956 2479956 defendant Ryot Robert yeoman 802622 802622 Ryot, Robert, of Leghton Bosard, Beds, yeoman 0
5417329 2480100 2480100 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 5
5417394 2480122 2480122 defendant Ryot Robert yeoman 802622 802622 Ryot, Robert, of Leghton Bosard, Beds, yeoman 0
5434569 2485280 2485280 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 5
5434578 2485281 2485281 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 5
5434587 2485282 2485282 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 5
5445770 2488622 2488622 defendant Hardyng William husbandman 802622 802622 Hardyng, William, of Leghton Bosard, Beds, husbandman 0
5449935 2489869 2489869 defendant Halsy John mercer 802622 802622 Halsy, John, of Leghton Bosard, Beds, mercer 4
5453979 2491080 2491080 defendant Legh William a yeoman 802622 802622 Legh, William a, of Leghton Bosard, Beds, yeoman 0
5481585 2499421 2499421 defendant Hardyng William husbandman 802622 802622 Hardyng, William, of Leghton Bosard, Beds, husbandman 0
5624829 2551696 2551696 defendant Spenser Simon   802622 802622 Spenser, Simon, of Leghton Bosard, Beds 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);