names

28 rows where place_id = 605205

✎ 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
3660760 1913628 1913628 defendant Wylles Richard clerk 605205 605205 Wylles, Richard, of Hygham Ferrers, clerk 0
3732010 1936243 1936243 plaintiff Cokkys John yeoman 605205 605205 Cokkys, John, of Hygham Ferrers, yeoman 0
4173735 2086270 2086270 defendant Bottom John husbandman 605205 605205 Bottom, John, of Hygham Ferrers, husbandman 2
4312027 2134344 2134344 defendant Whyte William yeoman 605205 605205 Whyte, William, of Hygham Ferrers, yeoman 0
4595055 2229711 2229711 defendant Sadeler Thomas   605205 605205 Sadeler, Thomas, of Hygham Ferrers 3
4637002 2242377 2242377 defendant Barneby John   605205 605205 Barneby, John, of Hygham Ferrers 0
4642592 2243952 2243952 defendant Curtays Alice   605205 605205 Curtays, Alice, of Hygham Ferrers 1
4647976 2245474 2245474 defendant Deyster John   605205 605205 Deyster, John, of Hygham Ferrers 0
4694377 2263741 2263741 defendant Golde Thomas butcher 605205 605205 Golde, Thomas, of Hygham Ferrers, butcher 0
4694378 2263741 2263741 defendant Glover John glover 605205 605205 Glover, John, of Hygham Ferrers, glover 1
4714090 2269735 2269735 defendant Eddesore Thomas   605205 605205 Eddesore, Thomas, of Hygham Ferrers 2
4811392 2299672 2299672 defendant Curford Richard yeoman 605205 605205 Curford, Richard, of Hygham Ferrers, yeoman 0
4960396 2345076 2345076 defendant Alchyrche William husbandman 605205 605205 Alchyrche, William, of Hygham Ferrers, husbandman 3
4983925 2352122 2352122 defendant Pekke Roger husbandman 605205 605205 Pekke, Roger, of Hygham Ferrers, husbandman 1
4983926 2352122 2352122 defendant Turnour Walter mercer 605205 605205 Turnour, Walter, of Hygham Ferrers, mercer 2
5051315 2372005 2372005 defendant Pekke Roger husbandman 605205 605205 Pekke, Roger, of Hygham Ferrers, husbandman 0
5051316 2372005 2372005 defendant Turnour Walter mercer 605205 605205 Turnour, Walter, of Hygham Ferrers, mercer 1
5079917 2380472 2380472 plaintiff Chaundry John   605205 605205 Chaundry, John, of Hygham Ferrers 0
5079918 2380472 2380472 plaintiff Course William   605205 605205 Course, William, of Hygham Ferrers 1
5098510 2385993 2385993 defendant Brokesby Robert yeoman 605205 605205 Brokesby, Robert, of Hygham Ferrers, yeoman 3
5104692 2387808 2387808 defendant Wellys John gent 605205 605205 Wellys, John, of Hygham Ferrers, gent 0
5118407 2391821 2391821 plaintiff Robyns William   605205 605205 Robyns, William, of Hygham Ferrers 0
5127767 2394600 2394600 defendant Wellsy John gent 605205 605205 Wellsy, John, of Hygham Ferrers, gent 0
5163045 2404918 2404918 defendant Fylyan William husbandman 605205 605205 Fylyan, William, of Hygham Ferrers, husbandman 1
5222265 2422219 2422219 defendant Scolle William mercer 605205 605205 Scolle, William, of Hygham Ferrers, mercer 0
5222266 2422219 2422219 defendant Crosse Geoffrey   605205 605205 Crosse, Geoffrey, of Hygham Ferrers, holy water clerk 1
5222267 2422219 2422219 defendant Pelle John yeoman 605205 605205 Pelle, John, of Hygham Ferrers, yeoman 2
5448134 2489331 2489331 defendant Wodhouse Thomas chapman 605205 605205 Wodhouse, Thomas, of Hygham Ferrers, chapman 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);