names

29 rows where place_id = 719075

✎ 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
3950312 2007193 2007193 defendant Atwood John   719075 719075 Atwood, John, of Maighfeld, "trugger" 0
4227942 2105255 2105255 defendant Baker Joseph yeoman 719075 719075 Baker, Joseph, of Maighfeld, yeoman 0
4227943 2105255 2105255 defendant Parke Christopher yeoman 719075 719075 Parke, Christopher, of Maighfeld, yeoman 1
4227944 2105255 2105255 defendant Tryce Nicholas turner 719075 719075 Tryce, Nicholas, of Maighfeld, turner 2
4280694 2123151 2123151 defendant Nicholls James turner 719075 719075 Nicholls, James, of Maighfeld, turner 0
4316491 2135885 2135885 defendant Phillpott alias Peerce William   719075 719075 Phillpott alias Peerce, William, of Maighfeld, "kember" 0
4316641 2135938 2135938 defendant Peckham George husbandman 719075 719075 Peckham, George, of Maighfeld, husbandman 1
4316642 2135938 2135938 defendant Sawyer John husbandman 719075 719075 Sawyer, John, of Maighfeld, husbandman 2
4316643 2135938 2135938 defendant Hills William husbandman 719075 719075 Hills, William, of Maighfeld, husbandman 3
4316645 2135939 2135939 defendant Weller Richard yeoman 719075 719075 Weller, Richard, of Maighfeld, yeoman 0
4316646 2135939 2135939 defendant Hoadley Bartholomew husbandman 719075 719075 Hoadley, Bartholomew, of Maighfeld, husbandman 1
4316647 2135939 2135939 defendant Maynard William husbandman 719075 719075 Maynard, William, of Maighfeld, husbandman 2
4319963 2137088 2137088 defendant Philpott William husbandman 719075 719075 Philpott, William, of Maighfeld, husbandman 0
4324382 2138551 2138551 defendant Pont George husbandman 719075 719075 Pont, George, of Maighfeld, husbandman 0
4354616 2148846 2148846 defendant Collens William shoemaker 719075 719075 Collens, William, of Maighfeld, shoemaker 2
4359830 2150678 2150678 defendant Stephens Richard husbandman 719075 719075 Stephens, Richard, of Maighfeld, husbandman 2
4364941 2152514 2152514 defendant Howell John yeoman 719075 719075 Howell, John, of Maighfeld, yeoman 2
4365065 2152561 2152561 defendant Lucke Thomas husbandman 719075 719075 Lucke, Thomas, of Maighfeld, husbandman 0
4365066 2152561 2152561 defendant Ewridge Robert carpenter 719075 719075 Ewridge, Robert, of Maighfeld, carpenter 1
4365069 2152562 2152562 defendant Ewridge Robert carpenter 719075 719075 Ewridge, Robert, of Maighfeld, carpenter 1
4369887 2154284 2154284 defendant Humfrey John   719075 719075 Humfrey, John, of Maighfeld, "trugger" 1
4369888 2154284 2154284 defendant Rogers Robert husbandman 719075 719075 Rogers, Robert, of Maighfeld, husbandman 2
4369889 2154284 2154284 defendant Wenborne John smith 719075 719075 Wenborne, John, of Maighfeld, smith 3
4371693 2154933 2154933 defendant Umfrey John   719075 719075 Umfrey, John, of Maighfeld, "trugger" 0
4376454 2156648 2156648 defendant Luck William tailor 719075 719075 Luck, William, of Maighfeld, tailor 2
4377855 2157149 2157149 defendant Hannocke alias Lavender Peter collier 719075 719075 Hannocke alias Lavender, Peter, of Maighfeld, collier 1
4378699 2157453 2157453 defendant Collens William shoemaker 719075 719075 Collens, William, of Maighfeld, shoemaker 2
4405549 2166429 2166429 defendant Hanncok alias Gewe Peter collier 719075 719075 Hanncok alias Gewe, Peter, of Maighfeld, collier 3
4409882 2167908 2167908 defendant Akent William tanner 719075 719075 Akent, William, of Maighfeld, tanner 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);