names

32 rows where place_id = 636097

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3828861 1966905 1966905 defendant Hurdon John husbandman 636097 636097 Hurdon, John, of Northill, husbandman 1
3917492 1996208 1996208 defendant Hurden William husbandman 636097 636097 Hurden, William, of Northill, husbandman 0
3963475 2011831 2011831 defendant Spore John husbandman 636097 636097 Spore, John, of Northill, husbandman 0
3963476 2011831 2011831 defendant Nyell John laborer 636097 636097 Nyell, John, of Northill, laborer 1
3963477 2011831 2011831 defendant Waren John laborer 636097 636097 Waren, John, of Northill, laborer 2
3963478 2011831 2011831 defendant Olver Joan spinster 636097 636097 Olver, Joan, of Northill, spinster 3
3996474 2023498 2023498 defendant Skynner Ralph husbandman 636097 636097 Skynner, Ralph, of Northill, husbandman 0
4006350 2027047 2027047 defendant Jackman Robert yeoman 636097 636097 Jackman, Robert, of Northill, yeoman 4
4009827 2028291 2028291 defendant Wadge Richard husbandman 636097 636097 Wadge, Richard, of Northill, husbandman 1
4009828 2028291 2028291 defendant Crabbe John husbandman 636097 636097 Crabbe, John, of Northill, husbandman 2
4009829 2028291 2028291 defendant Wethycombe Richard husbandman 636097 636097 Wethycombe, Richard, of Northill, husbandman 3
4018638 2031399 2031399 defendant Wearinge William husbandman 636097 636097 Wearinge, William, of Northill, husbandman 0
4019953 2031866 2031866 defendant Dawe John husbandman 636097 636097 Dawe, John, of Northill, husbandman 0
4038649 2038461 2038461 defendant Vyncent george yeoman 636097 636097 Vyncent, george, of Northill, yeoman 0
4241175 2110036 2110036 defendant Palmer Robert yeoman 636097 636097 Palmer, Robert, of Northill, yeoman 0
4241176 2110036 2110036 defendant Seipe Richard tailor 636097 636097 Seipe Richard, of Northill, tailor 1
4350097 2147292 2147292 defendant Fletcher alias Cooke William   636097 636097 Fletcher alias Cooke, William, of Northill, yeoman, administrators of 0
4350098 2147292 2147292 defendant Paternoster Thomas yeoman 636097 636097 (Paternoster, Thomas, of Northill, yeoman 1
4365822 2152811 2152811 defendant Tytchmarshe John, senior   636097 636097 Tytchmarshe, John, senior, of Northill 0
4365823 2152811 2152811 defendant Tytchmarshe John, junior   636097 636097 Tytchmarshe, John, junior, of Northill 1
4365824 2152811 2152811 defendant Tytchmarshe William husbandman 636097 636097 Tytchmarshe, William, of Northill, husbandman 2
4391775 2161869 2161869 defendant Budge Thomas yeoman 636097 636097 Budge, Thomas, of Northill, yeoman 0
4471830 2191853 2191853 defendant Redeclyf John   636097 636097 Redeclyf, John, of Northill, parson 0
4575917 2223956 2223956 defendant Frygoun Thomas clerk 636097 636097 Frygoun, Thomas, of Northill, clerk 0
4658356 2248497 2248497 defendant Trebartha Nicholas, senior gent 636097 636097 Trebartha, Nicholas, senior, of Northill, gent 0
4658357 2248497 2248497 defendant Trebartha Nicholas, junior gent 636097 636097 Trebartha, Nicholas, junior, of Northill, gent 1
4755531 2282109 2282109 defendant Batyn Stephen husbandman 636097 636097 Batyn, Stephen, of Northill, husbandman 4
5052880 2372452 2372452 defendant Drewe John husbandman 636097 636097 (Drewe, John, of Northill, husbandman 3
5121899 2392840 2392840 defendant Trespetegowe John, senior husbandman 636097 636097 Trespetegowe, John, senior, of Northill, husbandman 2
5121900 2392840 2392840 defendant Trespetegowe John, junior laborer 636097 636097 Trespetegowe, John, junior, of Northill, laborer 3
5373448 2467291 2467291 defendant Cade William yeoman 636097 636097 Cade, William, of Northill, yeoman 4
5440387 2487022 2487022 defendant Blighe John husbandman 636097 636097 Blighe, John, of Northill, 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);