names

28 rows where place_id = 607774

✎ 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
3670738 1916808 1916808 defendant Hythe Thomas husbandman 607774 607774 Hythe, Thomas, of Dullyngham, husbandman 1
3670739 1916808 1916808 defendant Reggewell William weaver 607774 607774 Reggewell, William, of Dullyngham, weaver 2
3698230 1925670 1925670 plaintiff Vancy John   607774 607774 Vancy, John, of Dullyngham, administrators of 0
3711877 1930032 1930032 plaintiff Vancy or Vaucy John   607774 607774 Vancy or Vaucy, John, of Dullyngham, administrators of 0
3772129 1948975 1948975 defendant Fawner Thomas husbandman 607774 607774 Fawner, Thomas, of Dullyngham, husbandman 2
3774214 1949651 1949651 defendant Walys William cordwainer 607774 607774 Walys, William, of Dullyngham, cordwainer 0
3786979 1953730 1953730 defendant Walys William cordwainer 607774 607774 Walys, William, of Dullyngham, cordwainer 0
3786980 1953730 1953730 defendant Aplyard John fuller 607774 607774 Aplyard, John, of Dullyngham, fuller 1
3839645 1970325 1970325 defendant Couper Brice husbandman 607774 607774 Couper, Brice, of Dullyngham, husbandman 0
3892176 1987637 1987637 defendant Breten William clerk 607774 607774 Breten, William, of Dullyngham, clerk 2
3925132 1998718 1998718 defendant Coper Brice cooper 607774 607774 Coper, Brice, of Dullyngham, cooper 1
3934759 2001922 2001922 defendant Bewman Richard   607774 607774 Bewman, Richard, of Dullyngham, smith, Dorothy, his wife 1
4220298 2102606 2102606 defendant Thriplowe William yeoman 607774 607774 Thriplowe, William, of Dullyngham, yeoman 0
4298340 2129506 2129506 defendant Hasellwood John husbandman 607774 607774 Hasellwood, John, of Dullyngham, husbandman 0
4298341 2129506 2129506 defendant Stanton Henry yeoman 607774 607774 Stanton, Henry, of Dullyngham, yeoman 1
4298342 2129506 2129506 defendant Brice Jonah yeoman 607774 607774 Brice, Jonah, of Dullyngham, yeoman 2
4326599 2139256 2139256 defendant Shiprit Simon husbandman 607774 607774 Shiprit, Simon, of Dullyngham, husbandman 0
4348390 2146689 2146689 defendant Thriplowe William yeoman 607774 607774 Thriplowe, William, of Dullyngham, yeoman 1
4458466 2187695 2187695 plaintiff Ranewe John   607774 607774 Ranewe, John, of Dullyngham 0
5252725 2430960 2430960 defendant Coke John butcher 607774 607774 Coke, John, of Dullyngham, butcher 0
5286256 2440990 2440990 defendant Felours Thomas husbandman 607774 607774 Felours, Thomas, of Dullyngham, husbandman 3
5342781 2457939 2457939 defendant Reddeswell Walter husbandman 607774 607774 Reddeswell, Walter, of Dullyngham, husbandman 1
5342784 2457940 2457940 defendant Reddeswell Walter husbandman 607774 607774 Reddeswell, Walter, of Dullyngham, husbandman 1
5342785 2457940 2457940 defendant Recheford Edmund husbandman 607774 607774 Recheford, Edmund, of Dullyngham, husbandman 2
5345264 2458690 2458690 defendant Rannewe John husbandman 607774 607774 Rannewe, John, of Dullyngham, husbandman 0
5515383 2509657 2509657 defendant Reddeswell Walter husbandman 607774 607774 Reddeswell, Walter, of Dullyngham, husbandman 1
5515384 2509657 2509657 defendant Rocheford Edmund husbandman 607774 607774 Rocheford, Edmund, of Dullyngham, husbandman 2
5542977 2517924 2517924 defendant Hithe Thomas husbandman 607774 607774 Hithe, Thomas, of Dullyngham, husbandman 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);