names

18 rows where place_id = 594197

✎ 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
3615035 1872347 1872347 defendant Shirlond William husbandman 594197 594197 Shirlond, William, of Colrygge, husbandman 1
3707548 1928655 1928655 defendant Bray Thomas husbandman 594197 594197 Bray, Thomas, of Colrygge, husbandman 0
3728445 1935144 1935144 defendant Wynter Richard husbandman 594197 594197 Wynter, Richard, of Colrygge, husbandman 3
3913586 1994883 1994883 defendant Style John smith 594197 594197 Style, John, of Colrygge, smith 0
3913587 1994883 1994883 defendant Pyke Nicholas husbandman 594197 594197 Pyke, Nicholas, of Colrygge, husbandman 1
3913588 1994883 1994883 defendant Hyll John husbandman 594197 594197 Hyll, John, of Colrygge, husbandman 2
3913589 1994883 1994883 defendant Shubroke John husbandman 594197 594197 Shubroke, John, of Colrygge, husbandman 3
3916236 1995813 1995813 defendant Cowde or Cowle Bartholomew clerk 594197 594197 Cowde or Cowle, Bartholomew, of Colrygge, clerk 8
4619002 2236938 2236938 defendant Spektote Richard skinner 594197 594197 Spektote, Richard, of Colrygge, skinner 0
4699061 2265174 2265174 defendant Legh David   594197 594197 Legh, David, of Colrygge, bailiff 4
4757145 2282603 2282603 defendant Jaunte John   594197 594197 Jaunte, John, of Colrygge 5
4902984 2327548 2327548 defendant Caslegh Richard husbandman 594197 594197 Caslegh, Richard, of Colrygge, husbandman 7
4902994 2327549 2327549 defendant Caslegh Richard husbandman 594197 594197 Caslegh, Richard, of Colrygge, husbandman 7
4985228 2352510 2352510 defendant Wyke John   594197 594197 Wyke, John, of Colrygge, bailiff 4
5139285 2397980 2397980 plaintiff Shirlond William   594197 594197 Shirlond, William, of Colrygge 0
5139287 2397981 2397981 plaintiff Shirlond William   594197 594197 Shirlond, William, of Colrygge 0
5360569 2463336 2463336 defendant Kent John laborer 594197 594197 Kent, John, of Colrygge, laborer 0
5360576 2463339 2463339 defendant Kent John laborer 594197 594197 Kent, John, of Colrygge, laborer 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);