names

34 rows where place_id = 753815

✎ 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
4415940 2169870 2169870 plaintiff Kyngesman William   753815 753815 Kyngesman, William, of Overe 0
4418039 2170522 2170522 plaintiff Toly John   753815 753815 Toly, John, of Overe 0
4448973 2184619 2184619 plaintiff Gavelok William   753815 753815 Gavelok, William, of Overe 0
4448974 2184619 2184619 defendant Hythe John   753815 753815 Hythe, John, of Overe 0
4455890 2186859 2186859 plaintiff Muksham Robert de   753815 753815 Muksham, Robert de, of Overe, parson, on his own account, or Muskham, Robert 0
4456000 2186897 2186897 plaintiff Muskham Robert de   753815 753815 Muskham, Robert de, of Overe, parson, on his own account 0
4456002 2186898 2186898 plaintiff Muskham Robert de   753815 753815 Muskham, Robert de, of Overe, parson, on his own account 0
4456004 2186899 2186899 plaintiff Muskham Robert   753815 753815 Muskham, Robert, of Overe, parson 0
4456006 2186900 2186900 plaintiff Muskham Robert   753815 753815 Muskham, Robert, of Overe, parson 0
4480404 2194539 2194539 defendant Mayner John   753815 753815 Mayner, John, of Overe 1
4575124 2223742 2223742 plaintiff Boll Nicholas   753815 753815 Boll, Nicholas, of Overe 0
4589039 2227949 2227949 defendant Salman Richard   753815 753815 Salman, Richard, of Overe 0
4650043 2246026 2246026 defendant Plowryghte Thomas   753815 753815 Plowryghte, Thomas, of Overe 0
4658307 2248481 2248481 defendant Chene or Cheve Thomas clerk 753815 753815 Chene or Cheve, Thomas, of Overe, clerk 0
4692240 2263088 2263088 defendant Moyne William husbandman 753815 753815 Moyne, William, of Overe, husbandman 1
4719339 2271391 2271391 defendant Richeman Walter husbandman 753815 753815 Richeman, Walter, of Overe, husbandman 2
4731652 2275092 2275092 defendant Denton John   753815 753815 Denton, John, of Overe 0
4745964 2279322 2279322 defendant Samson John husbandman 753815 753815 Samson, John, of Overe, husbandman 0
4753189 2281381 2281381 defendant Denton John fisher 753815 753815 Denton, John, of Overe, fisher 5
4795934 2294876 2294876 defendant Fuge John hosteler 753815 753815 Fuge, John, of Overe, hosteler 0
4815084 2300829 2300829 plaintiff Kyll John   753815 753815 Kyll, John, of Overe, on his own account 0
4815471 2300944 2300944 plaintiff Lassels William   753815 753815 Lassels, William, of Overe, parson, on his own account 0
4914145 2330936 2330936 plaintiff Couper Thomas   753815 753815 Couper, Thomas, of Overe 0
4922754 2333531 2333531 defendant Coweper Thomas husbandman 753815 753815 Coweper, Thomas, of Overe, husbandman 0
4946727 2340978 2340978 defendant Couper Thomas yeoman 753815 753815 Couper, Thomas, of Overe, yeoman 0
4977508 2350237 2350237 defendant Abbot John husbandman 753815 753815 Abbot, John, of Overe, husbandman 1
4977509 2350237 2350237 defendant Wareyn Thomas husbandman 753815 753815 Wareyn, Thomas, of Overe, husbandman 2
4977510 2350237 2350237 defendant Sampson John husbandman 753815 753815 Sampson, John, of Overe, husbandman 3
4978970 2350668 2350668 plaintiff Sampson John, junior   753815 753815 Sampson, John, junior, of Overe 0
4978973 2350669 2350669 plaintiff Sampson John, junior   753815 753815 Sampson, John, junior, of Overe 0
5281560 2439672 2439672 defendant Roberd Thomas, junior yeoman 753815 753815 Roberd, Thomas, junior, of Overe, yeoman 3
5281565 2439673 2439673 defendant Roberd Thomas, junior yeoman 753815 753815 Roberd, Thomas, junior, of Overe, yeoman 3
5629307 2553143 2553143 defendant Grene John butcher 753815 753815 Grene, John, of Overe, butcher 1
5629310 2553144 2553144 defendant Grene John butcher 753815 753815 Grene, John, of Overe, butcher 1

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