names

33 rows where place_id = 588534

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593230 1865517 1865517 plaintiff Hastynges William (legal representative) 588534 588534 Hastynges, William, of Hastynges, knight, executors of 0
3593232 1865517 1865517 plaintiff Hastynges Edward   588534 588534 Hastynges, Edward, of Hastynges, knight 2
3594850 1866018 1866018 defendant Water Robert yeoman 588534 588534 Water, Robert, of Hastynges, yeoman 0
3610340 1870889 1870889 defendant Benever Henry yeoman 588534 588534 Benever, Henry, of Hastynges, yeoman 0
3611523 1871274 1871274 defendant Stephens John fisherman 588534 588534 Stephens, John, of Hastynges, fisherman 0
3611524 1871274 1871274 defendant Rolffe John husbandman 588534 588534 Rolffe, John, of Hastynges, husbandman 1
3751290 1942326 1942326 defendant Franke John merchant 588534 588534 Franke, John, of Hastynges, merchant 0
3805968 1959802 1959802 defendant (not given) Thomas churchwardens of Cowper 588534 588534 Cowper, Thomas, of Hastynges, yeoman, churchwardens of Hastynges St Clement 1
4585383 2226851 2226851 defendant Chapman John   588534 588534 Chapman, John, of Hastynges 0
4585384 2226851 2226851 defendant Page John   588534 588534 Page, John, of Hastynges 1
4605625 2232879 2232879 defendant Gautron John chaplain 588534 588534 Gautron, John, of Hastynges, chaplain 0
4676294 2258198 2258198 plaintiff Gerveys Richard   588534 588534 Gerveys, Richard, of Hastynges 0
4682984 2260293 2260293 defendant Longe John baker 588534 588534 Longe, John, of Hastynges, baker 0
4859511 2314348 2314348 plaintiff Carpenter Thomas   588534 588534 Carpenter, Thomas, of Hastynges 0
5020369 2362840 2362840 defendant Goldyng John mercer 588534 588534 Goldyng, John, of Hastynges, mercer 0
5037807 2367936 2367936 defendant Veyre John (legal representative) 588534 588534 Veyre, John, of Hastynges, executors of 0
5037809 2367936 2367936 defendant Honywode Alan draper 588534 588534 Honywode, Alan, of Hastynges, draper 2
5037811 2367937 2367937 defendant Veyre John (legal representative) 588534 588534 Veyre, John, of Hastynges, executors of 0
5039256 2368382 2368382 defendant Frankes Henry clerk 588534 588534 Frankes, Henry, of Hastynges, clerk 0
5085988 2382294 2382294 defendant Faukes Henry clerk 588534 588534 Faukes, Henry, of Hastynges, clerk 0
5085989 2382294 2382294 defendant Radley John clerk 588534 588534 Radley, John, of Hastynges, clerk 1
5085991 2382295 2382295 defendant Letherlond Edmund tailor 588534 588534 Letherlond, Edmund, of Hastynges, tailor 0
5085992 2382295 2382295 defendant Harowe John yeoman 588534 588534 Harowe, John, of Hastynges, yeoman 1
5085993 2382295 2382295 defendant Elden John laborer 588534 588534 Elden, John, of Hastynges, laborer 2
5085994 2382295 2382295 defendant Bysshop Thomas   588534 588534 Bysshop, Thomas, of Hastynges, servant 3
5319285 2450862 2450862 plaintiff Hastynges William   588534 588534 Hastynges, William, of Hastynges, knight 0
5341947 2457671 2457671 plaintiff Hastynges William   588534 588534 Hastynges, William, of Hastynges, knight 1
5341953 2457672 2457672 plaintiff Hastynges William   588534 588534 Hastynges, William, of Hastynges, knight 1
5414343 2479226 2479226 plaintiff Hastynges Edward   588534 588534 Hastynges, Edward, of Hastynges, knight 1
5472613 2496777 2496777 defendant Calff Thomas clerk 588534 588534 Calff, Thomas, of Hastynges, clerk 0
5525612 2512602 2512602 plaintiff Hastynges Edward   588534 588534 Hastynges, Edward, of Hastynges, knight 0
5540950 2517293 2517293 plaintiff Wylcockys Thomas clerk 588534 588534 (Wylcockys, Thomas, of Hastynges, clerk 1
5540951 2517293 2517293 plaintiff Wryght John clerk 588534 588534 Wryght, John, of Hastynges, clerk 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);