names

48 rows where place_id = 589963

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599390 1867451 1867451 defendant Northe Thomas yeoman 589963 589963 Northe, Thomas, of Fordyngbrigge, yeoman 1
3599391 1867451 1867451 defendant Cramborne William yeoman 589963 589963 Cramborne, William, of Fordyngbrigge, yeoman 2
3630891 1904482 1904482 defendant Asheford Robert fletcher 589963 589963 Asheford, Robert, of Fordyngbrigge, fletcher 0
3786553 1953588 1953588 defendant Coke Anastacia widow 589963 589963 Coke, Anastacia, of Fordyngbrigge, widow 1
3786556 1953589 1953589 defendant Coke Anastacia widow 589963 589963 Coke, Anastacia, of Fordyngbrigge, widow 1
4440525 2181948 2181948 defendant Cook William   589963 589963 Cook, William, of Fordyngbrigge, bailiff 1
4554549 2217353 2217353 defendant Wallere John   589963 589963 Wallere, John, of Fordyngbrigge 0
4561096 2219424 2219424 defendant Chapeleyn Thomas   589963 589963 Chapeleyn, Thomas, of Fordyngbrigge 0
4663915 2250196 2250196 defendant Berde William laborer 589963 589963 Berde, William, of Fordyngbrigge, laborer 1
4688188 2261872 2261872 defendant Assheford Reginald husbandman 589963 589963 Assheford, Reginald, of Fordyngbrigge, husbandman 0
4740038 2277601 2277601 defendant Couper John cooper 589963 589963 Couper, John, of Fordyngbrigge, cooper 0
4935966 2337645 2337645 defendant Voule Thomas husbandman 589963 589963 Voule, Thomas, of Fordyngbrigge, husbandman 0
4954854 2343406 2343406 defendant Panter or Pauter Ralph yeoman 589963 589963 Panter or Pauter, Ralph, of Fordyngbrigge, yeoman 0
4954855 2343406 2343406 defendant Lobat John laborer 589963 589963 Lobat, John, of Fordyngbrigge, laborer 1
4954856 2343406 2343406 defendant Durant John husbandman 589963 589963 Durant, John, of Fordyngbrigge, husbandman 2
4978839 2350626 2350626 defendant Wynge Richard husbandsman 589963 589963 Wynge, Richard, of Fordyngbrigge, husbandsman 0
4989114 2353682 2353682 defendant Starlyng John gent 589963 589963 Starlyng, John, of Fordyngbrigge, gent 0
4989115 2353682 2353682 defendant Barry Thomas husbandman 589963 589963 Barry, Thomas, of Fordyngbrigge, husbandman 1
4989116 2353682 2353682 defendant Glover Robert   589963 589963 Glover, Robert,of Fordyngbrigge, glove maker 2
4989117 2353682 2353682 defendant Godde John husbandman 589963 589963 Godde, John, of Fordyngbrigge, husbandman 3
4989123 2353683 2353683 defendant Barry Thomas husbandman 589963 589963 Barry, Thomas, of Fordyngbrigge, husbandman 0
4992771 2354720 2354720 defendant Dene Philip shoemaker 589963 589963 Dene, Philip, of Fordyngbrigge, shoemaker 2
4997688 2356164 2356164 defendant Parker John, sen husbandman 589963 589963 Parker, John, sen, of Fordyngbrigge, husbandman 0
4997689 2356164 2356164 defendant Parker Joan widow 589963 589963 Parker, Joan, of Fordyngbrigge, widow 1
5018601 2362324 2362324 defendant Whynge Richard Hants, yeoman 589963 589963 Whynge Richard, of Fordyngbrigge, Hants, yeoman 1
5024767 2364164 2364164 defendant Whynge Richard husbandman 589963 589963 Whynge, Richard, of Fordyngbrigge, husbandman 0
5041977 2369202 2369202 defendant Ryngwode Thomas, senior esq 589963 589963 Ryngwode, Thomas, senior, of Fordyngbrigge, esq 0
5070059 2377538 2377538 defendant Baron John husbandman 589963 589963 Baron, John, of Fordyngbrigge, husbandman 0
5070060 2377538 2377538 defendant Burell John carpenter 589963 589963 Burell, John, of Fordyngbrigge, carpenter 1
5070061 2377538 2377538 defendant Wattes John carpenter 589963 589963 Wattes, John, of Fordyngbrigge, carpenter 2
5211733 2419173 2419173 defendant Willisthorpe Richard yeoman 589963 589963 Willisthorpe, Richard, of Fordyngbrigge, yeoman 3
5289823 2442031 2442031 defendant Wyllehtorpe Richard yeoman 589963 589963 Wyllehtorpe, Richard, of Fordyngbrigge, yeoman 1
5289824 2442031 2442031 defendant Bryght Ralph yeoman 589963 589963 Bryght, Ralph, of Fordyngbrigge, yeoman 2
5289825 2442031 2442031 defendant Berkeham John miller 589963 589963 Berkeham, John, of Fordyngbrigge, miller 3
5305113 2446532 2446532 defendant Wolstroppe Richard husbandman 589963 589963 Wolstroppe, Richard, of Fordyngbrigge, husbandman 0
5310252 2448099 2448099 defendant Everard Edward dyer 589963 589963 Everard, Edward, of Fordyngbrigge, dyer 0
5339805 2457023 2457023 defendant Gele John husbandman 589963 589963 Gele, John, of Fordyngbrigge, husbandman 3
5366239 2465103 2465103 defendant Everard Edward mercer 589963 589963 Everard, Edward, of Fordyngbrigge, mercer 2
5366240 2465103 2465103 defendant Forster John smith 589963 589963 Forster, John, of Fordyngbrigge, smith 3
5366241 2465103 2465103 defendant Thorton John husbandman 589963 589963 Thorton, John, of Fordyngbrigge, husbandman 4
5366242 2465103 2465103 defendant Porcher John tailor 589963 589963 Porcher, John, of Fordyngbrigge, tailor 5
5366244 2465103 2465103 defendant Broke John husbandman 589963 589963 Broke, John, of Fordyngbrigge, husbandman 7
5413061 2478838 2478838 defendant Everard Edward dyer 589963 589963 Everard, Edward, of Fordyngbrigge, dyer 3
5459329 2492700 2492700 defendant Hurste William yeoman 589963 589963 Hurste, William, of Fordyngbrigge, yeoman 1
5484532 2500292 2500292 defendant Everard Edward dyer 589963 589963 Everard, Edward, of Fordyngbrigge, dyer 4
5487729 2501218 2501218 defendant North Richard yeoman 589963 589963 North, Richard, of Fordyngbrigge, yeoman 1
5615487 2548630 2548630 defendant Stafford Thomas   589963 589963 Stafford, Thomas, of Fordyngbrigge, parson 0
5620376 2550231 2550231 defendant Stafford Thomas   589963 589963 Stafford, Thomas, of Fordyngbrigge, parson & clerk 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);