names

31 rows where place_id = 652179

✎ 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
3922204 1997735 1997735 defendant Sherman John blacksmith 652179 652179 Sherman, John, of Markeby, blacksmith 0
4566371 2221054 2221054 defendant Chaumpeneys William   652179 652179 Chaumpeneys, William, of Markeby 0
4566372 2221054 2221054 defendant Parys John   652179 652179 Parys, John, of Markeby 1
4566373 2221054 2221054 defendant Horne Hugh   652179 652179 Horne, Hugh, of Markeby 2
4691995 2263031 2263031 defendant Stevenson Richard husbandman 652179 652179 Stevenson, Richard, of Markeby, husbandman 0
4702430 2266170 2266170 defendant Godechyld John carter 652179 652179 Godechyld, John, of Markeby, carter 0
4702431 2266170 2266170 defendant torkesey John carter 652179 652179 torkesey, John, of Markeby, carter 1
4702433 2266170 2266170 defendant Wythum Robert husbandman 652179 652179 Wythum, Robert, of Markeby, husbandman 3
4829237 2305184 2305184 defendant Godard William husbandman 652179 652179 Godard, William, of Markeby, husbandman 0
4829767 2305356 2305356 defendant Swyne John weaver 652179 652179 Swyne, John, of Markeby, weaver 0
4829768 2305356 2305356 defendant Swyne Robert weaver 652179 652179 Swyne, Robert, of Markeby, weaver 1
4887782 2323009 2323009 defendant Scotton Simon gent 652179 652179 Scotton, Simon, of Markeby, gent 6
5038623 2368195 2368195 defendant Smyth Andrew smith 652179 652179 Smyth, Andrew, of Markeby, smith 3
5093316 2384441 2384441 defendant Riby William courser 652179 652179 Riby, William, of Markeby, courser 1
5108160 2388822 2388822 defendant Ryby William   652179 652179 Ryby, William, of Markeby, "cosour" 6
5128944 2394951 2394951 plaintiff Coupland Sibyl   652179 652179 Coupland, Sibyl, of Markeby 0
5135271 2396816 2396816 plaintiff Markeby alias Prior William   652179 652179 Markeby alias Prior, William, of Markeby 0
5245504 2428842 2428842 defendant Ryby William yeoman 652179 652179 Ryby, William, of Markeby, yeoman 1
5260409 2433384 2433384 defendant Ryby William courser 652179 652179 Ryby, William, of Markeby, courser 3
5306137 2446825 2446825 defendant Riby William corser 652179 652179 Riby, William, of Markeby, corser 2
5308245 2447499 2447499 defendant Rybe William yeoman 652179 652179 Rybe, William, of Markeby, yeoman 0
5308247 2447499 2447499 defendant Rybe John yeoman 652179 652179 Rybe, John, of Markeby, yeoman 2
5321446 2451506 2451506 defendant Rynggald Thomas husbandman 652179 652179 Rynggald, Thomas, of Markeby, husbandman 7
5369594 2466076 2466076 defendant Ryby William husbandman 652179 652179 Ryby, William, of Markeby, husbandman 0
5389457 2472034 2472034 defendant Ridley Richard   652179 652179 Ridley, Richard, of Markeby 0
5522436 2511836 2511836 defendant Clerk Robert husbandman 652179 652179 Clerk, Robert, of Markeby, husbandman 2
5532201 2514617 2514617 defendant Hewes John yeoman 652179 652179 Hewes, John, of Markeby, yeoman 0
5532202 2514617 2514617 defendant Yonge John husbandman 652179 652179 Yonge, John, of Markeby, husbandman 1
5560866 2523150 2523150 defendant Hewes John yeoman 652179 652179 Hewes, John, of Markeby, yeoman 0
5560867 2523150 2523150 defendant Yonge John husbandman 652179 652179 Yonge, John, of Markeby, husbandman 1
5577316 2527961 2527961 defendant Burton Thomas barker 652179 652179 Burton, Thomas, of Markeby, barker 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);