names

35 rows where place_id = 598538

✎ 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
3632957 1905123 1905123 defendant London Alexander gent 598538 598538 London, Alexander, of South Dalton, gent 0
3635716 1905972 1905972 defendant Newerk Joan widow 598538 598538 Newerk, Joan, of South Dalton, widow 0
3712472 1930218 1930218 defendant Campe Richard husbandman 598538 598538 Campe, Richard, of South Dalton, husbandman 1
3712473 1930218 1930218 defendant Baylly John husbandman 598538 598538 Baylly, John, of South Dalton, husbandman 2
3892151 1987630 1987630 defendant Rydle Andrew clerk 598538 598538 Rydle, Andrew, of South Dalton, clerk 0
3892153 1987631 1987631 defendant Rydle Andrew clerk 598538 598538 Rydle, Andrew, of South Dalton, clerk 0
3906426 1992441 1992441 defendant Rydley Andrew clerk 598538 598538 Rydley, Andrew, of South Dalton, clerk 0
3967344 2013206 2013206 defendant Bannester Edmund gent 598538 598538 Bannester, Edmund, of South Dalton, gent 2
4017428 2030939 2030939 plaintiff Thorley Richard yeoman 598538 598538 Thorley, Richard, of South Dalton, yeoman 0
4017429 2030939 2030939 defendant Sleigh John husbandman 598538 598538 Sleigh, John, of South Dalton, or of Purdon, husbandman 0
4017430 2030940 2030940 plaintiff Thorley Richard yeoman 598538 598538 Thorley, Richard, of South Dalton, yeoman 0
4022635 2032818 2032818 plaintiff Aslabye Maud (legal representative) 598538 598538 Aslabye, Maud, of South Dalton, widow, executor of 0
4048627 2041959 2041959 plaintiff Thorley Richard yeoman 598538 598538 Thorley, Richard, of South Dalton, yeoman 0
4048630 2041960 2041960 plaintiff Thorley Richard yeoman 598538 598538 Thorley, Richard, of South Dalton, yeoman 0
4131705 2071659 2071659 defendant Blaxton or Claxton Thomas yeoman 598538 598538 Blaxton or Claxton, Thomas, of South Dalton, yeoman 0
4155418 2079987 2079987 defendant Claxton or Blaxton Thomas yeoman 598538 598538 Claxton or Blaxton, Thomas, of South Dalton, yeoman 0
4175833 2087023 2087023 defendant Thorley Francis   598538 598538 Thorley, Francis, of South Dalton, yeoman, eldest son of Richard 2
4187256 2091037 2091037 defendant Ellys Anthony gent 598538 598538 Ellys, Anthony, of South Dalton, gent 0
4187258 2091038 2091038 defendant Ellys Stephen gent 598538 598538 Ellys, Stephen, of South Dalton, or of London, gent 0
4462033 2188823 2188823 plaintiff Styward Robert   598538 598538 Styward, Robert, of South Dalton 0
4487456 2196791 2196791 defendant Geree Thomas   598538 598538 Geree, Thomas, of South Dalton 0
4659026 2248693 2248693 plaintiff Dalton John   598538 598538 Dalton, John, of South Dalton 0
4659029 2248694 2248694 plaintiff Dalton John   598538 598538 Dalton, John, of South Dalton 0
4741857 2278114 2278114 defendant Manfeld Robert clerk 598538 598538 Manfeld, Robert, of South Dalton, clerk 0
4784234 2291067 2291067 defendant Calton Robert husbandman 598538 598538 Calton, Robert, of South Dalton, husbandman 3
4793373 2294028 2294028 defendant Stabell William husbandman 598538 598538 Stabell, William, of South Dalton, husbandman 0
4822074 2302979 2302979 defendant Sere William husbandman 598538 598538 Sere, William, of South Dalton, husbandman 0
4837670 2307713 2307713 defendant Cane Alice widow 598538 598538 Cane, Alice, of South Dalton, widow 0
4900473 2326791 2326791 defendant Coke Thomas husbandman 598538 598538 Coke, Thomas, of South Dalton, husbandman 2
4904411 2327993 2327993 defendant Whittyk John husbandman 598538 598538 Whittyk, John, of South Dalton, husbandman 2
4975878 2349747 2349747 defendant Ousteby Robert husbandman 598538 598538 Ousteby, Robert, of South Dalton, husbandman 0
4979294 2350766 2350766 defendant Baynton Robert laborer 598538 598538 Baynton, Robert, of South Dalton, laborer 0
5325305 2452657 2452657 defendant Perston John husbandman 598538 598538 Perston, John, of South Dalton, husbandman 1
5371752 2466753 2466753 defendant Dalton Thomas husbandman 598538 598538 Dalton, Thomas, of South Dalton, husbandman 0
5496464 2503853 2503853 defendant Grymston Thomas gent 598538 598538 Grymston, Thomas, of South Dalton, gent 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);