names

45 rows where place_id = 613967

✎ 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
3690141 1923075 1923075 plaintiff Fysshe John (legal representative) 613967 613967 Fysshe, John, of Scarburgh, Yorks, merchant, executors of 0
3690146 1923076 1923076 plaintiff Fysshe John (legal representative) 613967 613967 Fysshe, John, of Scarburgh, Yorks, merchant, executors of 0
3690151 1923077 1923077 plaintiff Fysshe John (legal representative) 613967 613967 Fysshe, John, of Scarburgh, Yorks, merchant, executors of 0
3701208 1926622 1926622 defendant Brampton George draper 613967 613967 Brampton, George, of Scarburgh, Yorks, draper 5
3701215 1926623 1926623 defendant Brampton George draper 613967 613967 Brampton, George, of Scarburgh, Yorks, draper 5
3831567 1967763 1967763 defendant Fyssher Ralph merchant 613967 613967 Fyssher, Ralph, of Scarburgh, Yorks, merchant 0
4730077 2274607 2274607 defendant Bautre Richard merchant 613967 613967 Bautre, Richard, of Scarburgh, Yorks, merchant 0
4734614 2275989 2275989 defendant Shilborell Peter shipman 613967 613967 Shilborell, Peter, of Scarburgh, Yorks, shipman 0
4765093 2285061 2285061 defendant Barnyngham Thomas laborer 613967 613967 Barnyngham, Thomas, of Scarburgh, Yorks, laborer 0
4852194 2312115 2312115 defendant Barker Thomas gent 613967 613967 Barker, Thomas, of Scarburgh, Yorks, gent 0
4861943 2315114 2315114 defendant Carethorp Robert chapman 613967 613967 Carethorp, Robert, of Scarburgh, Yorks, chapman 0
4886767 2322714 2322714 defendant Danyell Richard merchant 613967 613967 Danyell, Richard, of Scarburgh, Yorks, merchant 2
4889826 2323609 2323609 defendant Sage William chapman 613967 613967 Sage, William, of Scarburgh, Yorks, chapman 0
4890811 2323873 2323873 defendant Martyn John gent 613967 613967 Martyn, John, of Scarburgh, Yorks, gent 4
4896140 2325449 2325449 defendant Sage John chapman 613967 613967 Sage, John, of Scarburgh, Yorks, chapman 0
4896266 2325497 2325497 defendant Topclyf George gent 613967 613967 Topclyf, George, of Scarburgh, Yorks, gent 0
4897499 2325878 2325878 defendant Thorp Robert gent 613967 613967 Thorp, Robert, of Scarburgh, Yorks, gent 1
4916823 2331766 2331766 defendant Breerton John merchant 613967 613967 Breerton, John, of Scarburgh, Yorks, merchant 1
4924351 2334054 2334054 defendant Werdale Robert merchant & burgess 613967 613967 Werdale, Robert, of Scarburgh, Yorks, merchant & burgess 0
4924353 2334055 2334055 defendant Werdale Robert merchant & burgess 613967 613967 Werdale, Robert, of Scarburgh, Yorks, merchant & burgess 0
4925096 2334281 2334281 defendant Millom Christopher yeoman 613967 613967 Millom, Christopher, of Scarburgh, Yorks, yeoman 0
4946576 2340924 2340924 defendant Robynson John merchant 613967 613967 Robynson, John, of Scarburgh, Yorks, merchant 2
4949202 2341738 2341738 defendant Wardell Thomas merchant 613967 613967 Wardell, Thomas, of Scarburgh, Yorks, merchant 1
4949208 2341739 2341739 defendant Wardell Thomas merchant 613967 613967 Wardell, Thomas, of Scarburgh, Yorks, merchant 1
4955274 2343536 2343536 defendant Couper Richard chapman 613967 613967 Couper, Richard, of Scarburgh, Yorks, chapman 2
4965780 2346693 2346693 defendant Johnson Robert fishmonger 613967 613967 Johnson, Robert, of Scarburgh, Yorks, fishmonger 2
4981645 2351426 2351426 defendant Braytoft William yeoman 613967 613967 Braytoft, William, of Scarburgh, Yorks, yeoman 0
4982145 2351577 2351577 defendant Sage John chapman 613967 613967 Sage, John, of Scarburgh, Yorks, chapman 4
4997678 2356161 2356161 defendant Heryson John merchant 613967 613967 Heryson, John, of Scarburgh, Yorks, merchant 0
5031367 2366029 2366029 defendant Topclyf George merchant 613967 613967 Topclyf, George, of Scarburgh, Yorks, merchant 1
5067724 2376844 2376844 defendant Mitforth William merchant 613967 613967 Mitforth, William, of Scarburgh, Yorks, ,merchant 2
5067827 2376879 2376879 defendant Mitforth William merchant 613967 613967 Mitforth, William, of Scarburgh, Yorks, merchant 0
5141335 2398589 2398589 defendant Tomson John merchant 613967 613967 Tomson, John, of Scarburgh, Yorks, merchant 1
5141340 2398589 2398589 defendant Harryson John (legal representative) 613967 613967 Harryson, John, of Scarburgh, Yorks, merchant, executrix of 6
5253144 2431086 2431086 defendant Sounde John merchant 613967 613967 Sounde, John, of Scarburgh, Yorks, merchant 1
5254696 2431584 2431584 defendant Daweson John, junior fisher 613967 613967 Daweson, John, junior, of Scarburgh, Yorks, fisher 3
5340949 2457366 2457366 defendant Elyson John slater 613967 613967 Elyson, John, of Scarburgh, Yorks, slater 0
5359762 2463093 2463093 defendant Benton John merchant 613967 613967 Benton, John, of Scarburgh, Yorks, merchant 0
5359764 2463094 2463094 defendant Benton John merchant 613967 613967 Benton, John, of Scarburgh, Yorks, merchant 0
5360395 2463284 2463284 defendant Hothom Ralph gent 613967 613967 Hothom, Ralph, of Scarburgh, Yorks, gent 1
5360397 2463285 2463285 defendant Hothom Ralph gent 613967 613967 Hothom, Ralph, of Scarburgh, Yorks, gent 0
5360402 2463287 2463287 defendant Hothom Ralph gent 613967 613967 Hothom, Ralph, of Scarburgh, Yorks, gent 1
5360406 2463288 2463288 defendant Hothom Ralph gent 613967 613967 Hothom, Ralph, of Scarburgh, Yorks, gent 1
5536427 2515883 2515883 defendant Percy Peter yeoman 613967 613967 Percy, Peter, of Scarburgh, Yorks, yeoman 1
5536434 2515884 2515884 defendant Bylby Robert chapman 613967 613967 Bylby, Robert, of Scarburgh, Yorks, chapman 1

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