names

25 rows where place_id = 778472

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4654380 2247243 2247243 defendant Symond John merchant 778472 778472 Symond, John, of Harburgh, Leics, merchant 0
4683295 2260380 2260380 defendant Laughton John, junior ironmonger 778472 778472 Laughton, John, junior, of Harburgh, Leics, ironmonger 2
4843496 2309485 2309485 defendant Shit John husbandman 778472 778472 Shit, John, of Harburgh, Leics, husbandman 0
4900068 2326652 2326652 defendant Alyngton Thomas, senior gent 778472 778472 Alyngton, Thomas, senior, of Harburgh, Leics, gent 0
4916500 2331665 2331665 defendant Staunton John chapman 778472 778472 Staunton, John, of Harburgh, Leics, chapman 0
4930358 2335894 2335894 defendant Wermyngton Robert yeoman 778472 778472 Wermyngton, Robert, of Harburgh, Leics, yeoman 0
4950956 2342265 2342265 defendant Londy John barber 778472 778472 Londy, John, of Harburgh, Leics, barber 2
4950960 2342266 2342266 defendant Londy John barber 778472 778472 Londy, John, of Harburgh, Leics, barber 2
4985646 2352621 2352621 defendant Stondon John husbandman 778472 778472 Stondon, John, of Harburgh, Leics, husbandman 2
4985650 2352622 2352622 defendant Stondon John husbandman 778472 778472 Stondon, John, of Harburgh, Leics, husbandman 2
4993335 2354877 2354877 defendant Shut_ Thomas   778472 778472 Shut_, Thomas, of Harburgh, Leics, wool man 2
5008045 2359241 2359241 defendant Stonton Richard mercer 778472 778472 Stonton, Richard, of Harburgh, Leics, mercer 2
5031044 2365955 2365955 defendant Shute Richard chapman 778472 778472 Shute, Richard, of Harburgh, Leics, chapman 4
5031056 2365957 2365957 defendant Shitte Richard chapman 778472 778472 Shitte, Richard, of Harburgh, Leics, chapman 4
5048853 2371290 2371290 defendant Stouton or Stonton John chapman 778472 778472 Stouton or Stonton, John, of Harburgh, Leics, chapman 0
5177783 2409206 2409206 defendant Joy Nicholas gent 778472 778472 Joy, Nicholas, of Harburgh, Leics, gent 1
5177789 2409207 2409207 defendant Joy Nicholas gent 778472 778472 Joy, Nicholas, of Harburgh, Leics, gent 1
5201074 2416076 2416076 defendant Joy Nicholas gent 778472 778472 Joy, Nicholas, of Harburgh, Leics, gent 1
5201079 2416077 2416077 defendant Joy Nicholas gent 778472 778472 Joy, Nicholas, of Harburgh, Leics, gent 1
5254602 2431560 2431560 defendant Hawekewyth Thomas yeoman 778472 778472 Hawekewyth, Thomas, of Harburgh, Leics, yeoman 0
5295265 2443609 2443609 defendant Burdon Robert merchant 778472 778472 Burdon, Robert, of Harburgh, Leics, merchant 0
5451789 2490412 2490412 defendant Hawel_uch John dyer 778472 778472 Hawel_uch, John, of Harburgh, Leics, dyer 0
5478652 2498644 2498644 defendant Burdon Robert merchant 778472 778472 Burdon, Robert, of Harburgh, Leics, merchant 1
5478659 2498645 2498645 defendant Burdon Robert merchant 778472 778472 Burdon, Robert, of Harburgh, Leics, merchant 1
5491277 2502279 2502279 defendant Urney John carpenter 778472 778472 Urney, John, of Harburgh, Leics, carpenter 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);