names

21 rows where place_id = 599342

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636358 1906163 1906163 defendant Norton Thomas husbandman 599342 599342 Norton, Thomas, of Stokbury, husbandman 1
3644466 1908686 1908686 defendant Plotte Thomas husbandman 599342 599342 Plotte, Thomas, of Stokbury, husbandman 2
3655244 1911898 1911898 defendant Grymston Henry husbandman 599342 599342 Grymston, Henry, of Stokbury, husbandman 0
3655247 1911898 1911898 defendant Bunton William, junior husbandman 599342 599342 Bunton, William, junior, of Stokbury, husbandman 3
3658503 1912911 1912911 defendant Plate Thomas husbandman 599342 599342 Plate, Thomas, of Stokbury, husbandman 1
3751354 1942342 1942342 defendant Knyght john husbandman 599342 599342 Knyght, john, of Stokbury, husbandman 1
3751355 1942342 1942342 defendant Aleyn Stephen husbandman 599342 599342 Aleyn, Stephen, of Stokbury, husbandman 2
3767622 1947512 1947512 defendant Knyght John husbandman 599342 599342 Knyght, John, of Stokbury, husbandman 1
3767623 1947512 1947512 defendant Alyn Stephen husbandman 599342 599342 Alyn, Stephen, of Stokbury, husbandman 2
3907808 1992899 1992899 defendant Plott John, senior yeoman 599342 599342 Plott, John, senior, of Stokbury, yeoman 0
4815305 2300897 2300897 defendant Clerk Roger yeoman 599342 599342 Clerk, Roger, of Stokbury, yeoman 0
5067815 2376875 2376875 defendant Knyght Robert laborer 599342 599342 Knyght, Robert, of Stokbury, laborer 4
5128673 2394870 2394870 defendant Saverey John, junior laborer 599342 599342 Saverey, John, junior, of Stokbury, laborer 3
5167397 2406198 2406198 defendant Cok John husbandman 599342 599342 Cok, John, of Stokbury, husbandman 0
5401132 2475388 2475388 defendant Barkford Roger smith 599342 599342 Barkford, Roger, of Stokbury, smith 0
5486447 2500839 2500839 defendant Bromefild Thomas husbandman 599342 599342 Bromefild, Thomas, of Stokbury, husbandman 0
5486448 2500839 2500839 defendant Beket Simon butcher 599342 599342 Beket, Simon, of Stokbury, butcher 1
5486449 2500839 2500839 defendant Dunton John husbandman 599342 599342 Dunton, John, of Stokbury, husbandman 2
5486450 2500839 2500839 defendant Harryngton John husbandman 599342 599342 Harryngton, John, of Stokbury, husbandman 3
5528074 2513344 2513344 defendant Canon Robert husbandman 599342 599342 Canon, Robert, of Stokbury, husbandman 4
5546308 2518917 2518917 defendant Godegrome John husbandman 599342 599342 Godegrome, John, of Stokbury, 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);