names

43 rows where place_id = 663045

✎ 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
3967289 2013191 2013191 defendant Whytney Nicholas gent 663045 663045 Whytney, Nicholas, of Castleton, gent 0
3998185 2024098 2024098 defendant Howe William husbandman 663045 663045 Howe, William, of Castleton, husbandman 1
4021264 2032329 2032329 defendant Phylpott Richard husbandman 663045 663045 Phylpott, Richard, of Castleton, husbandman 0
4032382 2036245 2036245 defendant Phylpott Richard yeoman 663045 663045 Phylpott, Richard, of Castleton, yeoman 11
4032401 2036248 2036248 defendant Phylpott Richard yeoman 663045 663045 Phylpott, Richard, of Castleton, yeoman 7
4032437 2036252 2036252 defendant Whytney Nicholas gent 663045 663045 Whytney, Nicholas, of Castleton, gent 13
4042486 2039783 2039783 defendant Whytney Thomas gent 663045 663045 Whytney, Thomas, of Castleton, gent 9
4042499 2039784 2039784 defendant Whytney Thomas gent 663045 663045 Whytney, Thomas, of Castleton, gent 9
4063207 2047136 2047136 defendant Whytney Nicholas gent 663045 663045 Whytney, Nicholas, of Castleton, gent 1
4093851 2058124 2058124 defendant Whitney Nicholas gent 663045 663045 Whitney, Nicholas, of Castleton, gent 0
4099100 2060002 2060002 defendant Whytney Nicholas gent 663045 663045 Whytney, Nicholas, of Castleton, gent 2
4109868 2063788 2063788 defendant Savage John gent 663045 663045 Savage, John, of Castleton, gent 2
4136309 2073331 2073331 defendant Watkyn Howell yeoman 663045 663045 Watkyn, Howell, of Castleton, yeoman 0
4154024 2079501 2079501 defendant Watkyn Howell yeoman 663045 663045 Watkyn, Howell, of Castleton, yeoman 1
4181937 2089162 2089162 defendant Eyre Edmund yeoman 663045 663045 Eyre, Edmund, of Castleton, yeoman 1
4181938 2089162 2089162 defendant Eyre Ralph husbandman 663045 663045 Eyre, Ralph, of Castleton, husbandman 2
4217020 2101447 2101447 defendant Lee Jane spinster 663045 663045 Lee, Jane, of Castleton, spinster 2
4218418 2101943 2101943 defendant Whitney Thomas gent 663045 663045 Whitney, Thomas, of Castleton, gent 0
4227579 2105132 2105132 defendant Whytney Thomas gent 663045 663045 Whytney, Thomas, of Castleton, gent 0
4262363 2117081 2117081 defendant Carpenter Geoffrey husbandman 663045 663045 Carpenter, Geoffrey, of Castleton, husbandman 3
4311165 2134052 2134052 defendant Whitney Thomas gent 663045 663045 Whitney, Thomas, of Castleton, gent 0
4311167 2134053 2134053 defendant Whitney Thomas gent 663045 663045 Whitney, Thomas, of Castleton, gent 0
4338383 2143172 2143172 defendant Kynge Edmund yeoman 663045 663045 Kynge, Edmund, of Castleton, yeoman 0
4360796 2151029 2151029 defendant Savage Thomas gent 663045 663045 Savage, Thomas, of Castleton, gent 0
4360809 2151032 2151032 defendant Savage John gent 663045 663045 Savage, John, of Castleton, gent 0
4368580 2153812 2153812 defendant Whitney Thomas gent 663045 663045 Whitney, Thomas, of Castleton, gent 0
4374190 2155843 2155843 defendant Whitney Thomas gent 663045 663045 Whitney, Thomas, of Castleton, gent 0
4389060 2160970 2160970 defendant Savage John yeoman 663045 663045 Savage, John, of Castleton, yeoman 1
4389061 2160970 2160970 defendant Wyrrall William husbandman 663045 663045 Wyrrall, William, of Castleton, husbandman 2
4395830 2163185 2163185 defendant Bullytont William yeoman 663045 663045 Bullytont, William, of Castleton, yeoman 1
4396488 2163400 2163400 defendant Barbor Humphrey yeoman 663045 663045 Barbor, Humphrey, of Castleton, yeoman 0
4396489 2163400 2163400 defendant Barbor Robert husbandman 663045 663045 Barbor, Robert, of Castleton, husbandman 1
4406824 2166847 2166847 defendant Barbor Elias yeoman 663045 663045 Barbor, Elias, of Castleton, or of Edall, yeoman 0
4406825 2166847 2166847 defendant Hoe Robert husbandman 663045 663045 Hoe, Robert, of Castleton, husbandman 1
4407137 2166950 2166950 defendant Savage Thomas gent 663045 663045 Savage, Thomas, of Castleton, gent 2
4409522 2167780 2167780 defendant Savage Thomas gent 663045 663045 Savage, Thomas, of Castleton, gent 0
4412046 2168620 2168620 defendant Hytchins John miner 663045 663045 Hytchins, John, of Castleton, miner 0
4412047 2168620 2168620 defendant Towman Henry miner 663045 663045 Towman, Henry, of Castleton, miner 1
4412048 2168620 2168620 defendant Henton James miner 663045 663045 Henton, James, of Castleton, miner 2
4692041 2263043 2263043 defendant Stranley John   663045 663045 Stranley, John, of Castleton, knight 0
4709853 2268440 2268440 defendant Stranley John   663045 663045 Stranley, John, of Castleton, knight 0
4792065 2293621 2293621 plaintiff Mawene John gent 663045 663045 Mawene, John, of Castleton, gent 0
5627260 2552495 2552495 defendant Flynt John husbandman 663045 663045 Flynt, John, of Castleton, husbandman 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);