names

18 rows where place_id = 600162

✎ 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
3639944 1907306 1907306 defendant Watson Robert husbandman 600162 600162 Watson, Robert, of Sneterley, husbandman 0
3691837 1923607 1923607 plaintiff Holtyng Thomas mariner 600162 600162 Holtyng, Thomas, of Sneterley, mariner 0
3722716 1933372 1933372 plaintiff Barkar John   600162 600162 Barkar, John, of Sneterley 1
3722718 1933372 1933372 plaintiff Smert William   600162 600162 Smert, William, of Sneterley 3
3732330 1936348 1936348 defendant Garrard Edmund butcher 600162 600162 Garrard, Edmund, of Sneterley, butcher 6
3746971 1940971 1940971 defendant Thornham James   600162 600162 Thornham, James, of Sneterley, "rafman" 2
3760452 1945273 1945273 defendant Thornham James raffman 600162 600162 Thornham, James, of Sneterley, raffman 2
3780882 1951754 1951754 defendant Dam Agnes widow 600162 600162 Dam, Agnes, of Sneterley, widow 3
3815676 1962820 1962820 defendant Pawe John yeoman 600162 600162 Pawe, John, of Sneterley, yeoman 0
3886664 1985793 1985793 defendant Payn Adam husbandman 600162 600162 Payn, Adam, of Sneterley, husbandman 1
3925179 1998732 1998732 defendant Thorneham Margaret widow 600162 600162 Thorneham, Margaret, of Sneterley, widow 2
3925180 1998732 1998732 defendant Barker Richard husbandman 600162 600162 Barker, Richard, of Sneterley, husbandman: Skotton, Peter, of Sneterley, husbandman 3
3925189 1998735 1998735 defendant Barker Richard husbandman 600162 600162 Barker, Richard, of Sneterley, husbandman 0
4939317 2338677 2338677 defendant Gysbryght or Eysbryght Simon beer brewer 600162 600162 Gysbryght or Eysbryght, Simon, of Sneterley, beer brewer 0
5572753 2526579 2526579 defendant Flawes Nicholas mariner 600162 600162 Flawes, Nicholas, of Sneterley, mariner 2
5574911 2527234 2527234 defendant Thornham James raffman 600162 600162 Thornham, James, of Sneterley, raffman 1
5574935 2527241 2527241 defendant Thorneham Edmund yeoman 600162 600162 Thorneham, Edmund, of Sneterley, yeoman 2
5596150 2533711 2533711 defendant Quarles William yeoman 600162 600162 Quarles, William, of Sneterley, yeoman 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);