names

15 rows where place_id = 610756

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685009 1921451 1921451 defendant Halle William husbandman 610756 610756 Halle, William, of Skreton, husbandman 0
4494536 2198984 2198984 defendant (not given) (illegible)   610756 610756 & another, of Skreton 1
4608344 2233721 2233721 defendant Hotofte John   610756 610756 Hotofte, John, of Skreton 5
4756975 2282551 2282551 defendant Henhede John   610756 610756 Henhede, John, of Skreton, parson 0
4832254 2306121 2306121 defendant Hotte John husbandman 610756 610756 Hotte, John, of Skreton, husbandman 2
4859151 2314238 2314238 defendant Hotte John husbandman 610756 610756 Hotte, John, of Skreton, husbandman 2
4872133 2318245 2318245 defendant Hotto or Hotte John husbandman 610756 610756 Hotto or Hotte, John, of Skreton, husbandman 2
5009407 2359635 2359635 defendant Smyth William smith 610756 610756 Smyth, William, of Skreton, smith 0
5094919 2384927 2384927 defendant Hotoft John husbandman 610756 610756 Hotoft, John, of Skreton, husbandman 1
5232893 2425205 2425205 defendant Dene William clerk 610756 610756 Dene, William, of Skreton, clerk 0
5259927 2433228 2433228 plaintiff Johnson Richard   610756 610756 Johnson, Richard, of Skreton 0
5267581 2435620 2435620 defendant Johnson Richard yeoman 610756 610756 Johnson, Richard, of Skreton, yeoman 1
5282825 2440038 2440038 defendant Leek Thomas gent 610756 610756 Leek, Thomas, of Skreton, gent 0
5282828 2440039 2440039 defendant Leek Thomas gent 610756 610756 Leek, Thomas, of Skreton, gent 0
5293423 2443048 2443048 defendant Thoreton Robert husbandman 610756 610756 Thoreton, Robert, of Skreton, 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);