names

26 rows where place_id = 637957

✎ 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
3839606 1970310 1970310 defendant Wytonbery John husbandman 637957 637957 Wytonbery, John, of Potter Heygham, husbandman 2
3863411 1977956 1977956 defendant Tayller William clerk 637957 637957 Tayller, William, of Potter Heygham, clerk 3
3960297 2010694 2010694 defendant Ryngold Johh smith 637957 637957 Ryngold, Johh, of Potter Heygham, smith 1
4096280 2058999 2058999 defendant Jeye or Jeck John husbandman 637957 637957 Jeye or Jeck, John, of Potter Heygham, husbandman 1
4174315 2086479 2086479 defendant Tooley John husbandman 637957 637957 Tooley, John, of Potter Heygham, husbandman 2
4331508 2140833 2140833 defendant Fayerwether Simon yeoman 637957 637957 Fayerwether, Simon, of Potter Heygham, yeoman 1
4331509 2140833 2140833 defendant Clyvesbey Jane widow 637957 637957 Clyvesbey, Jane, of Potter Heygham, widow 2
4665249 2250619 2250619 defendant Jankyns Nicholas yeoman 637957 637957 Jankyns, Nicholas, of Potter Heygham, yeoman 2
4724885 2273077 2273077 defendant Dowe Thomas husbandman 637957 637957 Dowe, Thomas, of Potter Heygham, husbandman 2
4726287 2273506 2273506 defendant Reynald Robert husbandman 637957 637957 Reynald, Robert, of Potter Heygham, husbandman 0
4745879 2279299 2279299 defendant Knotte Edmund husbandman 637957 637957 Knotte, Edmund, of Potter Heygham, husbandman 1
4772060 2287237 2287237 defendant Cook John yeoman 637957 637957 Cook, John, of Potter Heygham, yeoman 1
4809486 2299141 2299141 defendant Davy Thomas   637957 637957 Davy, Thomas, of Potter Heygham, bailiff 0
4809503 2299145 2299145 defendant Tunstede Bartholomew   637957 637957 Tunstede, Bartholomew, of Potter Heygham, bailiff 0
4811205 2299615 2299615 defendant Tunstede Bartholomew yeoman 637957 637957 Tunstede, Bartholomew, of Potter Heygham, yeoman 0
4820952 2302639 2302639 defendant Coke John husbandman 637957 637957 Coke, John, of Potter Heygham, husbandman 0
4858150 2313918 2313918 defendant Tunstede Bartholomew yeoman 637957 637957 Tunstede, Bartholomew, of Potter Heygham, yeoman 0
4865315 2316124 2316124 defendant Cros John yeoman 637957 637957 Cros, John, of Potter Heygham, yeoman 0
4865316 2316124 2316124 defendant Doraunt John yeoman 637957 637957 Doraunt, John, of Potter Heygham, yeoman 1
4917092 2331853 2331853 defendant Tunsted Joan   637957 637957 Tunsted, Joan, of Potter Heygham, widow, formerly wife of Bartholomew Tunsted 0
4998500 2356432 2356432 defendant Grene William husbandman 637957 637957 Grene, William, of Potter Heygham, husbandman 0
5037641 2367883 2367883 defendant Dam Robert, senior husbandman 637957 637957 Dam, Robert, senior, of Potter Heygham, husbandman 1
5280242 2439297 2439297 defendant Jankyns William baker 637957 637957 Jankyns, William, of Potter Heygham, baker 1
5292940 2442927 2442927 defendant Jankyns William baker 637957 637957 Jankyns, William, of Potter Heygham, baker 0
5328261 2453528 2453528 defendant Cower William (legal representative) 637957 637957 Cower, William, of Potter Heygham, husbandman, administratrix of 0
5328262 2453528 2453528 defendant Cower Margery widow 637957 637957 Cower, Margery, of Potter Heygham, widow 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);