names

93 rows where place_id = 589626

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598218 1867074 1867074 defendant Byrsey Robert husbandman 589626 589626 Byrsey, Robert, of Walkyngton, husbandman 0
3711410 1929873 1929873 defendant Mawre Walter yeoman 589626 589626 Mawre, Walter, of Walkyngton, yeoman 0
3712474 1930218 1930218 defendant Bursay Edward husbandman 589626 589626 Bursay, Edward, of Walkyngton, husbandman 3
3774269 1949671 1949671 defendant Stephyn John yeoman 589626 589626 Stephyn, John, of Walkyngton, yeoman 3
3794787 1956244 1956244 defendant Hunter Edmund yeoman 589626 589626 Hunter, Edmund, of Walkyngton, yeoman 2
3805574 1959684 1959684 defendant Hunter Edmund yeoman 589626 589626 Hunter, Edmund, of Walkyngton, yeoman 0
3838273 1969887 1969887 defendant Clerke Thomas yeoman 589626 589626 Clerke, Thomas, of Walkyngton, yeoman 1
3866903 1979168 1979168 plaintiff Dowghty John yeoman 589626 589626 Dowghty, John, of Walkyngton, yeoman 3
3912015 1994342 1994342 defendant Hunter Edward (legal representative) 589626 589626 Hunter, Edward, of Walkyngton, yeoman, executrix of 0
4062758 2046981 2046981 defendant Wykam Thomas singleman 589626 589626 Wykam, Thomas, of Walkyngton, yeoman, singleman 0
4184538 2090099 2090099 defendant Nalton Francis clerk 589626 589626 Nalton, Francis, of Walkyngton, clerk 0
4184980 2090253 2090253 defendant Manwell Hugh yeoman 589626 589626 Manwell, Hugh, of Walkyngton, yeoman 0
4448721 2184536 2184536 defendant Gate Richard   589626 589626 Gate, Richard, of Walkyngton 0
4527799 2208970 2208970 defendant Walkyngton John   589626 589626 Walkyngton, John, of Walkyngton 0
4558349 2218555 2218555 defendant Hogeson Thomas   589626 589626 Hogeson, Thomas, of Walkyngton 0
4558813 2218716 2218716 defendant Midilton John de   589626 589626 Midilton, John de, of Walkyngton 0
4558815 2218717 2218717 defendant Midilton John de   589626 589626 Midilton, John de, of Walkyngton 0
4559657 2218977 2218977 plaintiff Middelton John   589626 589626 Middelton, John, of Walkyngton 0
4559659 2218978 2218978 plaintiff Middelton John   589626 589626 Middelton, John, of Walkyngton 0
4559670 2218979 2218979 plaintiff Middelton John   589626 589626 Middelton, John, of Walkyngton 0
4559688 2218986 2218986 plaintiff Middilton John   589626 589626 Middilton, John, of Walkyngton 0
4574065 2223412 2223412 defendant Boythorp Richard   589626 589626 Boythorp, Richard, of Walkyngton 0
4580543 2225403 2225403 defendant Boythorp Thomas de   589626 589626 Boythorp, Thomas de, of Walkyngton 0
4580544 2225403 2225403 defendant Knight William   589626 589626 Knight, William, of Walkyngton 1
4580547 2225404 2225404 defendant Boythorp Thomas   589626 589626 Boythorp, Thomas, of Walkyngton 0
4580548 2225404 2225404 defendant Knyght William   589626 589626 Knyght, William, of Walkyngton 1
4580551 2225405 2225405 defendant Goldyngham Thomas   589626 589626 Goldyngham, Thomas, of Walkyngton 0
4580552 2225405 2225405 defendant Wyt John   589626 589626 Wyt, John, of Walkyngton 1
4580553 2225405 2225405 defendant Grayne William   589626 589626 Grayne, William, of Walkyngton 2
4580554 2225405 2225405 defendant Boythorp Thomas de   589626 589626 Boythorp, Thomas de, of Walkyngton 3
4581527 2225673 2225673 defendant Coke Nicholas   589626 589626 Coke, Nicholas, of Walkyngton 0
4581528 2225673 2225673 defendant Boythorp Thomas   589626 589626 Boythorp, Thomas, of Walkyngton 1
4581529 2225673 2225673 defendant Proktour John   589626 589626 Proktour, John, of Walkyngton 2
4581533 2225673 2225673 defendant Tayllour Thomas   589626 589626 Tayllour, Thomas, of Walkyngton 6
4584309 2226502 2226502 defendant Rogerson Thomas   589626 589626 Rogerson, Thomas, of Walkyngton 1
4596028 2230005 2230005 defendant Middilton John   589626 589626 Middilton, John, of Walkyngton 1
4600205 2231292 2231292 defendant Garthom Robert   589626 589626 Garthom, Robert, of Walkyngton 1
4603218 2232214 2232214 defendant Midelton John de   589626 589626 Midelton, John de, of Walkyngton 1
4647285 2245259 2245259 defendant del Hall Richard   589626 589626 del Hall, Richard, of Walkyngton 5
4690750 2262649 2262649 defendant Day Henry husbandman 589626 589626 Day, Henry, of Walkyngton, husbandman 1
4699499 2265297 2265297 defendant Plummer Thomas husbandman 589626 589626 Plummer, Thomas, of Walkyngton, husbandman 2
4703751 2266554 2266554 plaintiff Hogeson Joan   589626 589626 Hogeson, Joan, of Walkyngton 0
4714337 2269814 2269814 defendant Baythorp Richard husbandman 589626 589626 Baythorp, Richard, of Walkyngton, husbandman 1
4730768 2274824 2274824 defendant Letters William husbandman 589626 589626 Letters, William, of Walkyngton, husbandman 0
4734336 2275909 2275909 defendant Stokesley Robert husbandman 589626 589626 Stokesley, Robert, of Walkyngton, husbandman 0
4734337 2275909 2275909 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 1
4773238 2287598 2287598 plaintiff Swanland Thomas   589626 589626 Swanland, Thomas, of Walkyngton 0
4773239 2287598 2287598 defendant Skelton Richard clerk 589626 589626 Skelton, Richard, of Walkyngton, clerk 0
4778438 2289235 2289235 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 0
4778439 2289235 2289235 defendant Boythorp Richard husbandman 589626 589626 Boythorp, Richard, of Walkyngton, husbandman 1
4792763 2293824 2293824 defendant Hothome Thomas husbandman 589626 589626 Hothome, Thomas, of Walkyngton, husbandman 0
4797017 2295228 2295228 defendant Swanland Thomas husbandman 589626 589626 Swanland, Thomas, of Walkyngton, husbandman 0
4798532 2295719 2295719 plaintiff Swanland Thomas   589626 589626 Swanland, Thomas, of Walkyngton 0
4798533 2295719 2295719 defendant Skelton Richard clerk 589626 589626 Skelton, Richard, of Walkyngton, clerk 0
4800640 2296379 2296379 defendant Hothom Thomas husbandman 589626 589626 Hothom, Thomas, of Walkyngton, husbandman 1
4832786 2306275 2306275 defendant Goldyng Thomas husbandman 589626 589626 Goldyng, Thomas, of Walkyngton, husbandman 9
4832787 2306275 2306275 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 10
4847591 2310741 2310741 defendant Richard Richard husbandman 589626 589626 Richard, Richard, of Walkyngton, husbandman 4
4847596 2310742 2310742 defendant Boythorp Richard husbandman 589626 589626 Boythorp, Richard, of Walkyngton, husbandman 0
4847597 2310742 2310742 defendant Hare Robert husbandman 589626 589626 Hare, Robert, of Walkyngton, husbandman 1
4847598 2310742 2310742 defendant Pynke Richard husbandman 589626 589626 Pynke, Richard, of Walkyngton, husbandman 2
4847603 2310743 2310743 defendant Sutton Thomas husbamdman 589626 589626 Sutton, Thomas, of Walkyngton, husbamdman 0
4847604 2310743 2310743 defendant Warde Thomas husbandman 589626 589626 Warde, Thomas, of Walkyngton, husbandman 1
4847605 2310743 2310743 defendant Ruland John husbandman 589626 589626 Ruland, John, of Walkyngton, husbandman 2
4847606 2310743 2310743 defendant Cravern John husbandman 589626 589626 Cravern, John, of Walkyngton, husbandman 3
4847607 2310743 2310743 defendant Ruland William husbandman 589626 589626 Ruland, William, of Walkyngton, husbandman 4
4859684 2314400 2314400 defendant Boythorp Richard husbandman 589626 589626 Boythorp, Richard, of Walkyngton, husbandman 5
4859685 2314400 2314400 defendant Ruland Richard husbandman 589626 589626 Ruland, Richard, of Walkyngton, husbandman 6
4870704 2317815 2317815 defendant Jonson William husbandman 589626 589626 Jonson, William, of Walkyngton, husbandman 0
4871690 2318113 2318113 defendant Askbarough William clerk 589626 589626 Askbarough, William, of Walkyngton, clerk 0
4878921 2320342 2320342 defendant Coke William husbandman 589626 589626 Coke, William, of Walkyngton, husbandman 0
4879775 2320593 2320593 defendant Garthom John laborer 589626 589626 Garthom, John, of Walkyngton, laborer 2
4911232 2330019 2330019 defendant Garthom John   589626 589626 Garthom, John, of Walkyngton, plough wright 11
4911233 2330019 2330019 defendant Boythorp Alice widow 589626 589626 Boythorp, Alice, of Walkyngton, widow 12
4932069 2336423 2336423 defendant Saxby Roger laborer 589626 589626 Saxby, Roger, of Walkyngton, laborer 2
4965683 2346661 2346661 defendant Boythorp William husbandman 589626 589626 Boythorp, William, of Walkyngton, husbandman 0
4965684 2346661 2346661 defendant Johnson Richard husbandman 589626 589626 Johnson, Richard, of Walkyngton, husbandman 1
5000744 2357093 2357093 defendant Smyth William smith 589626 589626 Smyth, William, of Walkyngton, smith 2
5112787 2390134 2390134 plaintiff Johnson Richard   589626 589626 Johnson, Richard, of Walkyngton 0
5120311 2392370 2392370 defendant Johnson Robert husbandman 589626 589626 Johnson, Robert, of Walkyngton, husbandman 3
5159570 2403915 2403915 defendant Sclater Thomas husbandman 589626 589626 Sclater, Thomas, of Walkyngton, husbandman 3
5195391 2414402 2414402 defendant Solater Thomas husbandman 589626 589626 Solater, Thomas, of Walkyngton, husbandman 3
5501069 2505269 2505269 defendant Siggefeld John husbandman 589626 589626 Siggefeld, John, of Walkyngton, husbandman 0
5501070 2505269 2505269 defendant Kyrton John husbandman 589626 589626 Kyrton, John, of Walkyngton, husbandman 1
5540819 2517260 2517260 defendant Howe John husbandman 589626 589626 Howe, John, of Walkyngton, husbandman 0
5594018 2533119 2533119 defendant Abbot William yeoman 589626 589626 Abbot, William, of Walkyngton, yeoman 0
5594019 2533119 2533119 defendant Bursey John, junior husbandman 589626 589626 Bursey, John, junior, of Walkyngton, husbandman 1
5594020 2533119 2533119 defendant Strik Ralph husbandman 589626 589626 Strik, Ralph, of Walkyngton, husbandman 2
5594021 2533119 2533119 defendant Bowrman John husbandman 589626 589626 Bowrman, John, of Walkyngton, husbandman 3
5594038 2533120 2533120 defendant Abbot William yeoman 589626 589626 Abbot, William, of Walkyngton, yeoman 2
5594039 2533120 2533120 defendant Bursey John, junior husbandman 589626 589626 Bursey, John, junior, of Walkyngton, husbandman 3
5594040 2533120 2533120 defendant Strik Ralph husbandman 589626 589626 Strik, Ralph, of Walkyngton, husbandman 4
5594041 2533120 2533120 defendant Bowerman John husbandman 589626 589626 Bowerman, John, of Walkyngton, husbandman 5

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);