names

19 rows where place_id = 601843

✎ 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
3647246 1909524 1909524 defendant Aleyn John yeoman 601843 601843 Aleyn, John, of Mowton, yeoman 0
3679010 1919506 1919506 defendant Dyman Nicholas husbandman 601843 601843 Dyman, Nicholas, of Mowton, husbandman 1
3687100 1922136 1922136 defendant Rudde John yeoman 601843 601843 Rudde, John, of Mowton, yeoman 1
3690473 1923186 1923186 defendant Garrard Thomas husbandman 601843 601843 Garrard, Thomas, of Mowton, husbandman 4
3766306 1947114 1947114 defendant Wyner or Wyver Nicholas   601843 601843 Wyner or Wyver, Nicholas, of Mowton, shepherd 0
3800734 1958142 1958142 defendant Wynar Nicholas   601843 601843 Wynar, Nicholas, of Mowton, shepherd 0
4112151 2064604 2064604 plaintiff Smythson Leonard yeoman 601843 601843 Smythson, Leonard, of Mowton, yeoman 0
4112153 2064605 2064605 plaintiff Smythson Leonard yeoman 601843 601843 Smythson, Leonard, of Mowton, yeoman 0
5136373 2397157 2397157 defendant Wright John yeoman 601843 601843 Wright, John, of Mowton, yeoman 0
5239579 2427162 2427162 defendant Mannfreys Adam smith 601843 601843 Mannfreys, Adam, of Mowton, smith 0
5244797 2428648 2428648 defendant Hollere Thomas yeoman 601843 601843 Hollere, Thomas, of Mowton, yeoman 0
5250517 2430268 2430268 defendant Hollere Thomas yeoman 601843 601843 Hollere, Thomas, of Mowton, yeoman 0
5268427 2435891 2435891 plaintiff Holer Thomas   601843 601843 Holer, Thomas, of Mowton 1
5268432 2435892 2435892 plaintiff Holdr' Thomas   601843 601843 Holdr', Thomas, of Mowton 1
5278525 2438828 2438828 plaintiff Holer Thomas   601843 601843 Holer, Thomas, of Mowton 1
5278530 2438830 2438830 plaintiff Holer Thomas   601843 601843 Holer, Thomas, of Mowton 1
5304314 2446293 2446293 defendant Waterman Stephen smith 601843 601843 Waterman, Stephen, of Mowton, smith 3
5573157 2526700 2526700 defendant Dall Robert carpenter 601843 601843 Dall, Robert, of Mowton, carpenter 3
5594736 2533327 2533327 defendant Ronde John yeoman 601843 601843 Ronde, John, of Mowton, yeoman 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);