names

72 rows where place_id = 628180

✎ 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
3780933 1951770 1951770 defendant Sancroft Edward dyer 628180 628180 Sancroft, Edward, of Hingham, dyer 1
3992289 2022009 2022009 plaintiff Burganye Robert saddler 628180 628180 Burganye, Robert, of Hingham, saddler 0
3995401 2023098 2023098 defendant Barraclowe John   628180 628180 Barraclowe, John, of Hingham, wheelwright 0
4008664 2027861 2027861 plaintiff More William sherman 628180 628180 More, William, of Hingham, sherman 0
4023596 2033149 2033149 defendant Gratie Christopher yeoman 628180 628180 Gratie, Christopher, of Hingham, yeoman 0
4026118 2033985 2033985 defendant Burgany Robert saddler 628180 628180 Burgany, Robert, of Hingham, saddler 3
4026678 2034188 2034188 defendant Page William butcher 628180 628180 Page, William, of Hingham, butcher 0
4049531 2042276 2042276 defendant Tolye Thomas shoemaker 628180 628180 Tolye, Thomas, of Hingham, shoemaker 2
4054915 2044150 2044150 defendant Rudd William draper 628180 628180 Rudd, William, of Hingham, draper 0
4059591 2045822 2045822 plaintiff Cooper Robert cordwainer 628180 628180 Cooper, Robert, of Hingham, cordwainer 0
4069632 2049422 2049422 defendant Smyth alias Folsham John husbandman 628180 628180 Smyth alias Folsham, John, of Hingham, husbandman 0
4070216 2049638 2049638 defendant Lovell Thomas yeoman 628180 628180 Lovell, Thomas, of Hingham, yeoman 0
4082398 2054013 2054013 defendant Agg Robert tanner 628180 628180 Agg, Robert, of Hingham, tanner 0
4085495 2055089 2055089 defendant Chambers Richard yeoman 628180 628180 Chambers, Richard, of Hingham, yeoman 1
4093144 2057868 2057868 defendant More Peter grocer 628180 628180 More, Peter, of Hingham, grocer 0
4106893 2062757 2062757 defendant Agg Robert tanner 628180 628180 Agg, Robert, of Hingham, tanner 0
4107805 2063070 2063070 defendant Dymond Henry laborer 628180 628180 Dymond, Henry, of Hingham, laborer 0
4107806 2063070 2063070 defendant Noobes John laborer 628180 628180 Noobes, John, of Hingham, laborer 1
4107807 2063070 2063070 defendant Nobes Christopher laborer 628180 628180 Nobes, Christopher, of Hingham, laborer 2
4107808 2063070 2063070 defendant Toly Joan spinster 628180 628180 Toly, Joan, of Hingham, spinster 3
4108556 2063314 2063314 defendant Wade Alexander butcher 628180 628180 Wade, Alexander, of Hingham, butcher 0
4108557 2063314 2063314 defendant Wade Robert butcher 628180 628180 Wade, Robert, of Hingham, butcher 1
4127536 2070139 2070139 defendant Crosse John clerk 628180 628180 Crosse, John, of Hingham, clerk 2
4142193 2075447 2075447 defendant Aggy Robert yeoman 628180 628180 Aggy, Robert, of Hingham, yeoman 0
4148718 2077676 2077676 defendant Burrough William yeoman 628180 628180 Burrough, William, of Hingham, yeoman 0
4179426 2088281 2088281 defendant Byrcham Simon shoemaker 628180 628180 Byrcham, Simon, of Hingham, shoemaker 1
4179895 2088445 2088445 defendant Smythe alias Folsham John husbandman 628180 628180 Smythe alias Folsham, John, of Hingham, husbandman 0
4184320 2090017 2090017 defendant Lovell Thomas yeoman 628180 628180 Lovell, Thomas, of Hingham, yeoman 0
4204388 2097082 2097082 defendant Fytt John glover 628180 628180 Fytt, John, of Hingham, glover 0
4209106 2098735 2098735 defendant More Peter grocer 628180 628180 More, Peter, of Hingham, grocer 0
4213280 2100160 2100160 defendant Cowper Thomas mercer 628180 628180 Cowper, Thomas, of Hingham, mercer 0
4213281 2100160 2100160 defendant Longe John grocer 628180 628180 Longe, John, of Hingham, grocer 1
4219087 2102173 2102173 plaintiff Longe John   628180 628180 Longe, John, of Hingham 0
4220894 2102802 2102802 defendant More Peter grocer 628180 628180 More, Peter, of Hingham, ,grocer 1
4227929 2105251 2105251 defendant Tanner Edmund cordwainer 628180 628180 Tanner, Edmund, of Hingham, cordwainer 1
4229504 2105806 2105806 defendant Lovell Edward gent 628180 628180 Lovell, Edward, of Hingham, gent 1
4229505 2105806 2105806 defendant Lovell Mary spinster 628180 628180 Lovell, Mary, of Hingham, spinster 2
4245115 2111353 2111353 plaintiff Long John   628180 628180 Long, John, of Hingham 0
4246740 2111888 2111888 defendant Barkham William tailor 628180 628180 Barkham, William, of Hingham, tailor 2
4247673 2112203 2112203 defendant Davye John cooper 628180 628180 Davye, John, of Hingham, cooper 0
4255144 2114711 2114711 defendant Davy John cooper 628180 628180 Davy, John, of Hingham, cooper 0
4257935 2115626 2115626 defendant Wade Robert butcher 628180 628180 Wade, Robert, of Hingham, butcher 0
4260013 2116319 2116319 defendant Burrewe William yeoman 628180 628180 Burrewe, William, of Hingham, yeoman 0
4260014 2116319 2116319 defendant Clarke Elizabeth widow 628180 628180 Clarke, Elizabeth, of Hingham, widow 1
4260015 2116319 2116319 defendant Davye John cooper 628180 628180 Davye, John, of Hingham, cooper 2
4260016 2116319 2116319 defendant Lamme Robert laborer 628180 628180 Lamme, Robert, of Hingham, laborer 3
4261313 2116750 2116750 defendant Lovell Thomas gent 628180 628180 Lovell, Thomas, of Hingham, gent 1
4265003 2117929 2117929 defendant Burrowe William yeoman 628180 628180 Burrowe, William, of Hingham, yeoman 2
4267597 2118795 2118795 defendant Syer Edmund husbandman 628180 628180 Syer, Edmund, of Hingham, husbandman 1
4275905 2121521 2121521 defendant Beales Hugh butcher 628180 628180 Beales, Hugh, of Hingham, butcher 2
4276230 2121629 2121629 defendant Lovell alias Patche Edward gent 628180 628180 Lovell alias Patche, Edward, of Hingham, gent 0
4276661 2121771 2121771 defendant Beales Hugh butcher 628180 628180 Beales, Hugh, of Hingham, or of Ellingham, butcher 0
4289689 2126377 2126377 defendant Lovell Edward yeoman 628180 628180 Lovell, Edward, of Hingham, yeoman 0
4310534 2133837 2133837 defendant Carman Walter husbandman 628180 628180 Carman, Walter, of Hingham, husbandman 3
4313271 2134750 2134750 defendant Beales Hugh butcher 628180 628180 Beales, Hugh, of Hingham, or of Ellyngham, butcher 0
4316810 2135996 2135996 defendant Gillie or Gylly John innholder 628180 628180 Gillie or Gylly, John, of Hingham, innholder 0
4338925 2143368 2143368 defendant Gille John yeoman 628180 628180 Gille, John, of Hingham, yeoman 2
4341025 2144136 2144136 defendant Woodcocke John shoemaker 628180 628180 Woodcocke, John, of Hingham, shoemaker 0
4341026 2144136 2144136 defendant Wade Robert yeoman 628180 628180 together with Wade, Robert, of Hingham, yeoman 1
4341027 2144136 2144136 defendant Neave Thomas chapman 628180 628180 Neave, Thomas, of Hingham, chapman 2
4343651 2145058 2145058 defendant Wade Robert butcher 628180 628180 Wade, Robert, of Hingham, butcher 0
4343676 2145067 2145067 defendant Blomevyle Gregory carpenter 628180 628180 Blomevyle, Gregory, of Hingham, carpenter 0
4350540 2147453 2147453 defendant Dam John cooper 628180 628180 Dam, John, of Hingham, cooper 0
4355865 2149270 2149270 defendant Wright Gregory yeoman 628180 628180 Wright, Gregory, of Hingham, yeoman 0
4385951 2159992 2159992 defendant Gelle John innholder 628180 628180 Gelle, John, of Hingham, innholder 0
4388588 2160823 2160823 defendant Woodcocke Robert carpenter 628180 628180 Woodcocke, Robert, of Hingham, carpenter 1
4389954 2161264 2161264 defendant Dunne John yeoman 628180 628180 Dunne, John, of Hingham, yeoman 2
4389955 2161264 2161264 defendant Bathcombe alias Barkham William tailor 628180 628180 Bathcombe alias Barkham, William, of Hingham, tailor 3
4392951 2162255 2162255 defendant Sparham Luke husbandman 628180 628180 Sparham, Luke, of Hingham, husbandman 1
4404393 2166038 2166038 defendant Jeames William   628180 628180 Jeames, William, of Hingham, sieve maker 0
4410288 2168039 2168039 defendant Martyn Henry husbandman 628180 628180 Martyn, Henry, of Hingham, husbandman 0
4410291 2168039 2168039 defendant Baldwyn William cooper 628180 628180 Baldwyn, William, of Hingham, cooper 3

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