names

21 rows where place_id = 603537

✎ 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
3654863 1911780 1911780 defendant Auger Clement yeoman 603537 603537 Auger, Clement, of Hilborough, yeoman 0
3657034 1912462 1912462 defendant Doraunt Thomas husbandman 603537 603537 Doraunt, Thomas, of Hilborough, husbandman 0
3657035 1912462 1912462 defendant Deynys John husbandman 603537 603537 Deynys, John, of Hilborough, husbandman 1
3740506 1938889 1938889 defendant Anger or Auger Clement (legal representative) 603537 603537 Anger or Auger, Clement, of Hilborough, yeoman, executors of 0
3740507 1938889 1938889 defendant Snellyng Thomas yeoman 603537 603537 (Snellyng, Thomas, of Hilborough, yeoman 1
3788389 1954167 1954167 defendant Duplak Simon husbandman 603537 603537 (Duplak, Simon, of Hilborough, husbandman 1
3788390 1954167 1954167 defendant Deynes John husbandman 603537 603537 Deynes, John, of Hilborough, husbandman 2
3832516 1968087 1968087 defendant Hewes John husbandman 603537 603537 Hewes, John, of Hilborough, husbandman 0
3949189 2006785 2006785 defendant Baker John husbandman 603537 603537 Baker, John, of Hilborough, husbandman 0
3963903 2011980 2011980 defendant Heygrene Thomas husbandman 603537 603537 Heygrene, Thomas, of Hilborough, husbandman 4
4009235 2028069 2028069 defendant Grygg Thomas yeoman 603537 603537 Grygg, Thomas, of Hilborough, husbandman, or of Bokenham, yeoman 0
4013280 2029483 2029483 defendant Gyles Richard miller 603537 603537 Gyles, Richard, of Hilborough, miller 0
4014802 2030007 2030007 defendant Grigges Thomas yeoman 603537 603537 Grigges, Thomas, of Hilborough, yeoman 0
4084210 2054626 2054626 defendant Cowper James carpenter 603537 603537 Cowper, James, of Hilborough, carpenter 0
4084213 2054626 2054626 defendant Snellyng William husbandman 603537 603537 Snellyng, William, of Hilborough, husbandman 3
4243436 2110797 2110797 defendant Cheston John yeoman 603537 603537 Cheston, John, of Hilborough, yeoman 0
4243440 2110798 2110798 defendant Cheston John yeoman 603537 603537 Cheston, John, of Hilborough, yeoman 0
4274289 2120952 2120952 defendant Durrant Edward husbandman 603537 603537 Durrant, Edward, of Hilborough, husbandman 3
4391885 2161911 2161911 defendant Baker Edward husbandman 603537 603537 Baker, Edward, of Hilborough, husbandman 0
4391886 2161911 2161911 defendant Baker Robert husbandman 603537 603537 Baker, Robert, of Hilborough, husbandman 1
4401930 2165240 2165240 defendant Durrante Edward yeoman 603537 603537 Durrante, Edward, of Hilborough, yeoman 2

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);