names

16 rows where place_id = 594919

✎ 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
3618138 1873297 1873297 defendant Serle John yeoman 594919 594919 Serle, John, of Fynden, yeoman 2
3738120 1938142 1938142 plaintiff Meilsho or Melseho John gent 594919 594919 Meilsho or Melseho, John, of Fynden, gent 0
4190366 2092159 2092159 defendant Clyfford Richard gent 594919 594919 Clyfford, Richard, of Fynden, gent 0
4320667 2137319 2137319 defendant Brookes Robert yeoman 594919 594919 Brookes, Robert, of Fynden, or of Chingden, yeoman 0
4320668 2137319 2137319 defendant Guylatt William weaver 594919 594919 Guylatt, William, of Fynden, weaver 1
4320670 2137320 2137320 defendant Guylatt or Gylatt William weaver 594919 594919 Guylatt or Gylatt, William, of Fynden, weaver 0
4320671 2137320 2137320 defendant Brookes Robert yeoman 594919 594919 Brookes, Robert, of Fynden, yeoman 1
4334138 2141697 2141697 defendant Brook Robert husbandman 594919 594919 Brook, Robert, of Fynden, or of Thyngden, husbandman 1
4488079 2196989 2196989 defendant Romlem Richard   594919 594919 Romlem, Richard, of Fynden 0
4674025 2257488 2257488 plaintiff Chaundelere William   594919 594919 Chaundelere, William, of Fynden 1
4788611 2292494 2292494 defendant Adam Robert butcher 594919 594919 Adam, Robert, of Fynden, butcher 1
5220653 2421735 2421735 defendant Swane Robert husbandman or yeoman 594919 594919 Swane, Robert, of Fynden, husbandman or yeoman 4
5220659 2421736 2421736 defendant Swane Robert husbandman or yeoman 594919 594919 Swane, Robert, of Fynden, husbandman or yeoman 4
5502944 2505832 2505832 defendant Dey John husbandman 594919 594919 Dey, John, of Fynden, husbandman 0
5502945 2505832 2505832 defendant Dey William husbandman 594919 594919 Dey, William, of Fynden, husbandman 1
5523362 2512138 2512138 defendant Taillour John clerk 594919 594919 Taillour, John, of Fynden, clerk 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);