names

30 rows where place_id = 598050

✎ 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
3630740 1904438 1904438 defendant Pomeray Edward   598050 598050 Pomeray, Edward, of Bury Pomeray, knight, son of Pomeray, Richard, knight 0
3630906 1904485 1904485 defendant Bamfeld or Bainfeld Andrew yeoman 598050 598050 Bamfeld or Bainfeld, Andrew, of Bury Pomeray, yeoman 2
4674546 2257645 2257645 defendant Harry John yeoman 598050 598050 Harry, John, of Bury Pomeray, yeoman 20
4699688 2265347 2265347 defendant Harry John yeoman 598050 598050 Harry, John, of Bury Pomeray, yeoman 24
4871359 2318011 2318011 defendant Pomeray Edward esq 598050 598050 Pomeray, Edward, of Bury Pomeray, esq 0
4940884 2339173 2339173 defendant Horsyngton Nicholas husbandman 598050 598050 Horsyngton, Nicholas, of Bury Pomeray, husbandman 0
4940885 2339173 2339173 defendant Whithere John shipman 598050 598050 Whithere, John, of Bury Pomeray, shipman 1
4940886 2339173 2339173 defendant Helyer John crocker 598050 598050 Helyer, John, of Bury Pomeray, crocker 2
4958142 2344404 2344404 defendant Horsyngton Nicholas husbandman 598050 598050 Horsyngton, Nicholas, of Bury Pomeray, husbandman 1
5004212 2358124 2358124 defendant William John clerk 598050 598050 William, John, of Bury Pomeray, clerk 0
5078031 2379913 2379913 defendant Strepe John husbandman 598050 598050 Strepe, John, of Bury Pomeray, husbandman 0
5078032 2379913 2379913 defendant Miller John husbandman 598050 598050 Miller, John, of Bury Pomeray, husbandman 1
5078033 2379913 2379913 defendant Peny Richard husbandman 598050 598050 Peny, Richard, of Bury Pomeray, husbandman 2
5087785 2382811 2382811 defendant Goderygge Thomas husbandman 598050 598050 Goderygge, Thomas, of Bury Pomeray, husbandman 0
5087786 2382811 2382811 defendant Hayward John husbandman 598050 598050 Hayward, John, of Bury Pomeray, husbandman 1
5087787 2382811 2382811 defendant Lyghede Thomas husbandman 598050 598050 Lyghede, Thomas, of Bury Pomeray, husbandman 2
5087788 2382811 2382811 defendant Greneway John husbandman 598050 598050 Greneway, John, of Bury Pomeray, husbandman 3
5087789 2382811 2382811 defendant Taillour Mathew husbandman 598050 598050 Taillour, Mathew, of Bury Pomeray, husbandman 4
5087790 2382811 2382811 defendant Gaunt John husbandman 598050 598050 Gaunt, John, of Bury Pomeray, husbandman 5
5093995 2384641 2384641 defendant Hayward John husbandman 598050 598050 Hayward, John, of Bury Pomeray, husbandman 0
5093996 2384641 2384641 defendant Greneway John husbandman 598050 598050 Greneway, John, of Bury Pomeray, husbandman 1
5093997 2384641 2384641 defendant Bowedon Thomas husbandman 598050 598050 Bowedon, Thomas, of Bury Pomeray, husbandman 2
5093998 2384641 2384641 defendant Courteys Robert husbandman 598050 598050 Courteys, Robert, of Bury Pomeray, husbandman 3
5130029 2395268 2395268 defendant Austyn Edward   598050 598050 Austyn, Edward, of Bury Pomeray, groom 0
5168292 2406443 2406443 defendant Austyn Edward   598050 598050 Austyn, Edward, of Bury Pomeray, groom 0
5339509 2456927 2456927 defendant Baker Nicholas yeoman 598050 598050 Baker, Nicholas, of Bury Pomeray, yeoman 0
5507341 2507189 2507189 defendant Drewe William   598050 598050 Drewe, William, of Bury Pomeray, "fissheionter" 4
5509780 2507893 2507893 defendant Pomeray Thomas gent 598050 598050 Pomeray, Thomas, of Bury Pomeray, gent 0
5512670 2508820 2508820 defendant Pomeray Thomas gent 598050 598050 Pomeray, Thomas, of Bury Pomeray, gent 0
5531805 2514489 2514489 defendant Irysshe William husbandman 598050 598050 Irysshe, William, of Bury Pomeray, 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);