names

73 rows where place_id = 627867

✎ 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
3778947 1951134 1951134 defendant Cupper Robert mercer 627867 627867 Cupper, Robert, of Blandford Forum, mercer 0
3880663 1983798 1983798 defendant Chapyll John innholder 627867 627867 Chapyll, John, of Blandford Forum, innholder 1
3889065 1986582 1986582 defendant Poytt Richard husbandman 627867 627867 Poytt, Richard, of Blandford Forum, husbandman 0
3889066 1986582 1986582 defendant Cocke Thomas, junior husbandman 627867 627867 Cocke, Thomas, junior, of Blandford Forum, husbandman 1
3889067 1986582 1986582 defendant Cocke Thomas, senior husbandman 627867 627867 Cocke, Thomas, senior, of Blandford Forum, husbandman 2
3936601 2002566 2002566 defendant Bremley John butcher 627867 627867 Bremley, John, of Blandford Forum, butcher 0
3938509 2003223 2003223 plaintiff Pynge John merchant 627867 627867 Pynge, John, of Blandford Forum, merchant 0
3938511 2003224 2003224 plaintiff Pynge John merchant 627867 627867 Pynge, John, of Blandford Forum, merchant 0
3940759 2003915 2003915 defendant Collyngwode John pewterer 627867 627867 Collyngwode, John, of Blandford Forum, pewterer 0
3947714 2006263 2006263 plaintiff Comage Christopher merchant draper 627867 627867 Comage, Christopher, of Blandford Forum, merchant draper 0
3978377 2017022 2017022 defendant Bysson John fletcher 627867 627867 Bysson, John, of Blandford Forum, fletcher 0
4012618 2029237 2029237 defendant Reape John beer brewer 627867 627867 Reape, John, of Blandford Forum, innholder, beer brewer 0
4023746 2033194 2033194 defendant Rawlynson George mercer 627867 627867 Rawlynson, George, of Blandford Forum, mercer 0
4026465 2034110 2034110 defendant Hatchet John mercer 627867 627867 Hatchet, John, of Blandford Forum, mercer 0
4034282 2036928 2036928 plaintiff Harbyne Robert mercer 627867 627867 Harbyne, Robert, of Blandford Forum, mercer 0
4200954 2095890 2095890 defendant Pytt John, junior draper 627867 627867 Pytt, John, junior, of Blandford Forum, draper 0
4203043 2096614 2096614 defendant Corbyn Ralph baker 627867 627867 Corbyn, Ralph, of Blandford Forum, baker 0
4220383 2102634 2102634 defendant Golde John yeoman 627867 627867 Golde, John, of Blandford Forum, yeoman 1
4236797 2108446 2108446 defendant Pytt John draper 627867 627867 Pytt, John, of Blandford Forum, draper 0
4238226 2108978 2108978 defendant Rosewell Thomas gent 627867 627867 Rosewell, Thomas, of Blandford Forum, or of Dowkerton, Soms, gent 0
4241571 2110166 2110166 defendant Kennell Robert draper 627867 627867 Kennell, Robert, of Blandford Forum, draper 0
4241653 2110194 2110194 defendant Pytt John, junior   627867 627867 Pytt, John, junior, of Blandford Forum, woollen draper 0
4282139 2123655 2123655 defendant Rawlinson John yeoman 627867 627867 Rawlinson, John, of Blandford Forum, yeoman 1
4286220 2125126 2125126 defendant Herbery Joan widow 627867 627867 Herbery, Joan, of Blandford Forum, widow 0
4286221 2125126 2125126 defendant Coothe or Cootche Thomas blacksmith or butcher 627867 627867 Coothe or Cootche, Thomas, of Blandford Forum, blacksmith or butcher 1
4302062 2130842 2130842 defendant Tyffen Henry tailor 627867 627867 Tyffen, Henry, of Blandford Forum, tailor 2
4305050 2131907 2131907 defendant Strode John yeoman 627867 627867 Strode, John, of Blandford Forum, yeoman 2
4330497 2140497 2140497 defendant Storcke Peter yeoman 627867 627867 Storcke, Peter, of Blandford Forum, or of Marton, Wilts, yeoman 0
4331520 2140837 2140837 defendant Florence Edward gent 627867 627867 Florence, Edward, of Blandford Forum, gent 0
4332529 2141169 2141169 defendant Husey Henry gent 627867 627867 Husey, Henry, of Blandford Forum, or of Luddeston, Wilts, gent 0
4362336 2151582 2151582 defendant Bysshopp Richard   627867 627867 Bysshopp, Richard, of Blandford Forum, gun maker 0
4362337 2151582 2151582 defendant Androwes Robert husbandman 627867 627867 Androwes, Robert, of Blandford Forum, husbandman 1
4362674 2151710 2151710 defendant Gardner William   627867 627867 Gardner, William, of Blandford Forum, hat maker 0
4362675 2151710 2151710 defendant Basterd John yeoman 627867 627867 Basterd, John, of Blandford Forum, yeoman 1
4362753 2151737 2151737 defendant Bonfyld Henry yeoman 627867 627867 Bonfyld, Henry, of Blandford Forum, yeoman 1
4366923 2153220 2153220 defendant Olyver William yeoman 627867 627867 Olyver, William, of Blandford Forum, yeoman 1
4366924 2153220 2153220 defendant Bryce John yeoman 627867 627867 Bryce, John, of Blandford Forum, yeoman 2
4367092 2153286 2153286 defendant Oliver William yeoman 627867 627867 Oliver, William, of Blandford Forum, yeoman 0
4367552 2153450 2153450 defendant Reeve Christopher yeoman 627867 627867 Reeve, Christopher, of Blandford Forum, or of Hughe Purton, Wilts, yeoman 0
4367719 2153508 2153508 defendant Harrys Henry   627867 627867 Harrys, Henry, of Blandford Forum, parchment maker 0
4367720 2153508 2153508 defendant Crewe Robert chapman 627867 627867 Crewe, Robert, of Blandford Forum, chapman 1
4367721 2153508 2153508 defendant Crewe Thomas chapman 627867 627867 Crewe, Thomas, of Blandford Forum, chapman 2
4369096 2154014 2154014 defendant Burde Baron chandler 627867 627867 Burde, Baron, of Blandford Forum, chandler 1
4371678 2154928 2154928 defendant Pytt John, junior draper 627867 627867 Pytt, John, junior, of Blandford Forum, draper 0
4372690 2155310 2155310 defendant Storcke Peter yeoman 627867 627867 Storcke, Peter, of Blandford Forum, or of Marten Wilts, yeoman 0
4373152 2155465 2155465 defendant Burde Baron chandler 627867 627867 Burde, Baron, of Blandford Forum, chandler 1
4375724 2156378 2156378 defendant Olyver William yeoman 627867 627867 Olyver, William, of Blandford Forum, yeoman 0
4376166 2156540 2156540 defendant Spencer Hector yeoman 627867 627867 Spencer, Hector, of Blandford Forum, or of Thompson, yeoman 0
4377307 2156959 2156959 defendant Tobye or Tovye Leonard yeoman 627867 627867 Tobye or Tovye, Leonard, of Blandford Forum, yeoman 2
4388706 2160857 2160857 defendant Bonfyld Henry yeoman 627867 627867 Bonfyld, Henry, of Blandford Forum, yeoman 1
4404435 2166050 2166050 defendant Loder Robert tailor 627867 627867 Loder, Robert, of Blandford Forum, tailor 0
4408594 2167465 2167465 defendant Pitt John, junior   627867 627867 Pitt, John, junior, of Blandford Forum, woollen draper 0
4670187 2256378 2256378 defendant Howebrond John   627867 627867 Howebrond, John, of Blandford Forum, mason 1
4693697 2263528 2263528 defendant White Thomas husbandman 627867 627867 White, Thomas, of Blandford Forum, husbandman 1
4770613 2286790 2286790 defendant Dotys Robert husbandman 627867 627867 Dotys, Robert, of Blandford Forum, husbandman 0
4812593 2300055 2300055 defendant Bysshope Robert butcher 627867 627867 Bysshope, Robert, of Blandford Forum, butcher 0
4884945 2322189 2322189 defendant Knyght Robert husbandman 627867 627867 Knyght, Robert, of Blandford Forum, husbandman 0
4913288 2330656 2330656 defendant Knyght Richard butcher 627867 627867 Knyght, Richard, of Blandford Forum, butcher 1
4952346 2342660 2342660 defendant Houper Walter cooper 627867 627867 Houper, Walter, of Blandford Forum, cooper 2
4952347 2342660 2342660 defendant More John tanner 627867 627867 More, John, of Blandford Forum, tanner 3
5048475 2371182 2371182 defendant Gosselyn John   627867 627867 Gosselyn, John, of Blandford Forum 0
5048502 2371191 2371191 defendant Carter William gent 627867 627867 Carter, William, of Blandford Forum, gent 0
5048503 2371191 2371191 defendant Lukeys William gent 627867 627867 Lukeys, William, of Blandford Forum, gent 1
5048513 2371193 2371193 defendant Gosselyn John yeoman 627867 627867 Gosselyn, John, of Blandford Forum, yeoman 0
5143686 2399287 2399287 defendant Smyth John smith 627867 627867 Smyth, John, of Blandford Forum, smith 1
5214202 2419883 2419883 defendant Rale Simon gent 627867 627867 Rale, Simon, of Blandford Forum, gent 1
5376408 2468218 2468218 defendant Shorte Hugh   627867 627867 Shorte, Hugh, of Blandford Forum, inn holder 0
5397763 2474429 2474429 defendant Smert John miller 627867 627867 Smert, John, of Blandford Forum, miller 2
5410913 2478213 2478213 defendant Smythe John butler 627867 627867 Smythe, John, of Blandford Forum, butler 0
5410914 2478213 2478213 defendant Eve John husbandman 627867 627867 Eve, John, of Blandford Forum, husbandman 1
5410915 2478213 2478213 defendant Smert John miller 627867 627867 Smert, John, of Blandford Forum, miller 2
5418711 2480520 2480520 defendant Shorte Hugh innholder 627867 627867 Shorte, Hugh, of Blandford Forum, innholder 0
5425063 2482459 2482459 defendant Cue or Ove John husbandman 627867 627867 Cue or Ove, John, of Blandford Forum, husbandman 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);