names

31 rows where place_id = 674464

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4014155 2029791 2029791 defendant Hall William yeoman 674464 674464 Hall, William, of Epworth, yeoman 0
4084412 2054698 2054698 defendant Steynton William butcher 674464 674464 Steynton, William, of Epworth, butcher 0
4187506 2091129 2091129 defendant Hatchman Robert husbandman 674464 674464 Hatchman, Robert, of Epworth, husbandman 0
4187511 2091130 2091130 defendant Theker Elizabeth widow 674464 674464 Theker, Elizabeth, of Epworth, widow 1
4247767 2112237 2112237 defendant Laughton John husbandman 674464 674464 Laughton, John, of Epworth, husbandman 2
4247768 2112237 2112237 defendant Laughton Joan widow 674464 674464 Laughton, Joan, of Epworth, widow 3
4288009 2125761 2125761 defendant Farr John gent 674464 674464 Farr, John, of Epworth, gent 0
4300150 2130151 2130151 defendant Starky John yeoman 674464 674464 Starky, John, of Epworth, yeoman 1
4307994 2132940 2132940 defendant Brownelowe John yeoman 674464 674464 Brownelowe, John, of Epworth, yeoman 0
4313244 2134741 2134741 defendant Hatchman Robert husbandman 674464 674464 Hatchman, Robert, of Epworth, husbandman 0
4336726 2142573 2142573 defendant Mawe Thomas yeoman 674464 674464 Mawe, Thomas, of Epworth, yeoman 0
4346095 2145888 2145888 defendant Farre John gent 674464 674464 Farre, John, of Epworth, gent 0
4360956 2151091 2151091 defendant Drewrie John yeoman 674464 674464 Drewrie, John, of Epworth, yeoman 1
4364610 2152401 2152401 defendant Coggan Richard yeoman 674464 674464 Coggan, Richard, of Epworth, yeoman 0
4364611 2152401 2152401 defendant Awdus Roger yeoman 674464 674464 together with Awdus, Roger, of Epworth, yeoman 1
4364613 2152402 2152402 defendant Whitley Richard yeoman 674464 674464 Whitley, Richard, of Epworth, yeoman 0
4364614 2152402 2152402 defendant Awdus Roger yeoman 674464 674464 together with Awdus, Roger, of Epworth, yeoman 1
4364615 2152402 2152402 defendant Mawe John yeoman 674464 674464 Mawe, John, of Epworth, yeoman 2
4369802 2154256 2154256 defendant Farr John gent 674464 674464 Farr, John, of Epworth, gent 0
4373308 2155519 2155519 defendant Farre Elizabeth widow 674464 674464 Farre, Elizabeth, of Epworth, widow 1
4373309 2155519 2155519 defendant Whittacres Alexander yeoman 674464 674464 Whittacres, Alexander, of Epworth, yeoman 2
4377970 2157193 2157193 defendant Mawe George yeoman 674464 674464 Mawe, George, of Epworth, yeoman 2
4453403 2186068 2186068 defendant Walker Richard   674464 674464 Walker, Richard, of Epworth 3
4459946 2188167 2188167 defendant Walker Richard   674464 674464 Walker, Richard, of Epworth 3
4519758 2206537 2206537 defendant Kynghyrst Richard   674464 674464 Kynghyrst, Richard, of Epworth 1
4547155 2215043 2215043 defendant Seel Thomas   674464 674464 Seel, Thomas, of Epworth 0
4597715 2230535 2230535 defendant Lynne Richard de   674464 674464 Lynne, Richard de, of Epworth 0
4897447 2325863 2325863 defendant Berugby or Berngby John gent 674464 674464 Berugby or Berngby, John, of Epworth, gent 0
4899071 2326352 2326352 defendant Berughby John gent 674464 674464 Berughby, John, of Epworth, gent 0
5082640 2381314 2381314 defendant Trapet Ralph husbandman 674464 674464 Trapet, Ralph, of Epworth, husbandman 0
5320954 2451356 2451356 defendant Herreson John yeoman 674464 674464 Herreson, John, of Epworth, yeoman 3

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