names

22 rows where place_id = 813345

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4855589 2313113 2313113 defendant Molys Robert weaver 813345 813345 Molys, Robert, of Dodebrokeburgh, weaver 2
4934782 2337276 2337276 defendant Quasshe Richard   813345 813345 Quasshe, Richard, of Dodebrokeburgh, mason 0
4946444 2340883 2340883 defendant Wyndesore John carpenter 813345 813345 Wyndesore, John, of Dodebrokeburgh, carpenter 0
5051705 2372122 2372122 defendant Wyndesore Thomas weaver 813345 813345 Wyndesore, Thomas, of Dodebrokeburgh, weaver 0
5051706 2372122 2372122 defendant Wyndesore Walter weaver 813345 813345 Wyndesore, Walter, of Dodebrokeburgh, weaver 1
5063643 2375659 2375659 defendant Wyndesore Thomas, junior weaver 813345 813345 Wyndesore, Thomas, junior, of Dodebrokeburgh, weaver 0
5069342 2377321 2377321 defendant Lovenay Thomas yeoman 813345 813345 Lovenay, Thomas, of Dodebrokeburgh, yeoman 0
5069344 2377322 2377322 defendant Lovenay Thomas yeoman 813345 813345 Lovenay, Thomas, of Dodebrokeburgh, yeoman 0
5084196 2381778 2381778 defendant Lovenay Thomas yeoman 813345 813345 together with Lovenay, Thomas, of Dodebrokeburgh, yeoman 1
5089306 2383239 2383239 defendant Rode William shoemaker 813345 813345 Rode, William, of Dodebrokeburgh, shoemaker 3
5089478 2383293 2383293 defendant Coysshe Richard   813345 813345 Coysshe, Richard, of Dodebrokeburgh, mason 0
5089483 2383294 2383294 defendant Strange John mariner 813345 813345 Strange, John, of Dodebrokeburgh, mariner 0
5104603 2387781 2387781 defendant Bryce John fisher 813345 813345 Bryce, John, of Dodebrokeburgh, fisher 0
5109168 2389104 2389104 defendant Lovenay Thomas yeoman 813345 813345 Lovenay, Thomas, of Dodebrokeburgh, yeoman 0
5253567 2431224 2431224 defendant Kent Robert fuller 813345 813345 Kent, Robert, of Dodebrokeburgh, fuller 0
5314714 2449436 2449436 defendant Wyndesore Richard tailor 813345 813345 Wyndesore, Richard, of Dodebrokeburgh, tailor 0
5320615 2451258 2451258 defendant Kent Robert carpenter 813345 813345 Kent, Robert, of Dodebrokeburgh, carpenter 0
5323362 2452064 2452064 defendant Parker Thomas   813345 813345 Parker, Thomas, of Dodebrokeburgh, pot maker 0
5331947 2454631 2454631 defendant Wyndesore Thomas, junior weaver 813345 813345 Wyndesore, Thomas, junior, of Dodebrokeburgh, weaver 0
5348178 2459574 2459574 defendant Amyse William chaplain 813345 813345 Amyse, William, of Dodebrokeburgh, chaplain 0
5355634 2461837 2461837 defendant Kent Robert   813345 813345 Kent, Robert, of Dodebrokeburgh, millward 0
5366566 2465196 2465196 defendant Bradlegh John gent 813345 813345 Bradlegh, John, of Dodebrokeburgh, gent 2

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