names

125 rows where place_id = 602298

✎ 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
3649402 1910204 1910204 defendant Philipp John yeoman 602298 602298 Philipp, John, of Bridport, yeoman 0
3649403 1910204 1910204 defendant Miller Peter miller 602298 602298 Miller, Peter, of Bridport, miller 1
3649405 1910205 1910205 defendant Phillipp John yeoman 602298 602298 Phillipp, John, of Bridport, yeoman 0
3649406 1910205 1910205 defendant Miller Peter yeoman 602298 602298 Miller, Peter, of Bridport, yeoman 1
3826787 1966231 1966231 defendant Hasard Robert husbandman 602298 602298 Hasard, Robert, of Bridport, husbandman 0
4124009 2068887 2068887 defendant Thressher Robert brewer 602298 602298 Thressher, Robert, of Bridport, brewer 1
4215636 2100967 2100967 defendant Gapyn Agnes widow 602298 602298 Gapyn, Agnes, of Bridport, widow 0
4215637 2100967 2100967 defendant Mychell William   602298 602298 together with Mychell, William, of Bridport, sailor 1
4225033 2104225 2104225 defendant Michell William   602298 602298 Michell, William, of Bridport, sailor 0
4225034 2104225 2104225 defendant Gapyn Agnes widow 602298 602298 together with Gapyn, Agnes, of Bridport, widow 1
4258240 2115729 2115729 defendant Davidge William merchant 602298 602298 Davidge, William, of Bridport, merchant 0
4261172 2116706 2116706 defendant Somer Thomas glasier 602298 602298 Somer, Thomas, of Bridport, glasier 0
4282008 2123607 2123607 defendant Valley Robert haberdasher 602298 602298 Valley, Robert, of Bridport, haberdasher 3
4294827 2128235 2128235 defendant Russell Richard gent 602298 602298 Russell, Richard, of Bridport, gent 0
4307366 2132712 2132712 defendant Tyggyns John merchant 602298 602298 Tyggyns, John, of Bridport, merchant 0
4313302 2134759 2134759 defendant Russell Richard gent 602298 602298 Russell, Richard, of Bridport, gent 0
4313306 2134760 2134760 defendant Russell Richard gent 602298 602298 Russell, Richard, of Bridport, gent 0
4333264 2141408 2141408 defendant Moone Gilbert chapman 602298 602298 Moone, Gilbert, of Bridport, chapman 0
4362350 2151588 2151588 defendant Hellyer Giles yeoman 602298 602298 Hellyer, Giles, of Bridport, yeoman 0
4371095 2154723 2154723 defendant Salter alias Ellyott William   602298 602298 Salter alias Ellyott, William, of Bridport, white baker 0
4376513 2156669 2156669 defendant Zowche Charles esq 602298 602298 Zowche, Charles, of Bridport, esq 1
4380168 2158010 2158010 defendant Hellier Giles yeoman 602298 602298 Hellier, Giles, of Bridport, yeoman 0
4408570 2167453 2167453 defendant Betscombe or Bettescombe Christopher mercer 602298 602298 Betscombe or Bettescombe, Christopher, of Bridport, mercer 0
4408580 2167458 2167458 defendant Colefox Simon cordwainer 602298 602298 Colefox, Simon, of Bridport, cordwainer 0
4524600 2208027 2208027 plaintiff Hore William   602298 602298 Hore, William, of Bridport 0
4551946 2216561 2216561 defendant Rogers Thomas   602298 602298 Rogers, Thomas, of Bridport 3
4563828 2220255 2220255 defendant atte Forde Simon   602298 602298 atte Forde, Simon, of Bridport 0
4638781 2242871 2242871 defendant Mountfort William   602298 602298 Mountfort, William, of Bridport 0
4638782 2242871 2242871 defendant Hayward William   602298 602298 Hayward, William, of Bridport 1
4664859 2250488 2250488 defendant Fleccher John   602298 602298 Fleccher, John, of Bridport 0
4675663 2257998 2257998 defendant Saundres Edward husbandman 602298 602298 Saundres, Edward, of Bridport, husbandman 0
4694271 2263707 2263707 defendant Fleccher John chapman 602298 602298 Fleccher, John, of Bridport, chapman 0
4697094 2264567 2264567 defendant Hyder John carrier 602298 602298 Hyder, John, of Bridport, carrier 0
4697095 2264567 2264567 defendant Ball William tailor 602298 602298 Ball, William, of Bridport, tailor 1
4701177 2265773 2265773 defendant Draper Gilbert (legal representative) 602298 602298 Draper, Gilbert, of Bridport, executors of 1
4701179 2265773 2265773 defendant Palmer John merchant 602298 602298 Palmer, John, of Bridport, merchant 3
4701180 2265773 2265773 defendant Bagge Walter chaplain 602298 602298 Bagge, Walter, of Bridport, chaplain 4
4701196 2265775 2265775 defendant Palmer John merchant 602298 602298 Palmer, John, of Bridport, merchant 3
4701197 2265775 2265775 defendant Bagge Walter chaplain 602298 602298 Bagge, Walter, of Bridport, chaplain 4
4703370 2266433 2266433 defendant Stamp John gent 602298 602298 Stamp, John, of Bridport, gent 0
4707913 2267846 2267846 plaintiff Mounteford William merchant 602298 602298 Mounteford, William, of Bridport, merchant 0
4707935 2267852 2267852 plaintiff Mountfort William merchant 602298 602298 Mountfort, William, of Bridport, merchant 0
4707938 2267853 2267853 plaintiff Mountfort William merchant 602298 602298 Mountfort, William, of Bridport, merchant 0
4710949 2268779 2268779 defendant Hider John chapman 602298 602298 Hider, John, of Bridport, chapman 0
4710950 2268779 2268779 defendant Langard Henry laborer 602298 602298 Langard, Henry, of Bridport, laborer 1
4712242 2269144 2269144 defendant Lylye John tailor 602298 602298 Lylye, John, of Bridport, tailor 0
4714534 2269877 2269877 defendant Hore Robert husbandman 602298 602298 Hore, Robert, of Bridport, husbandman 0
4748904 2280172 2280172 plaintiff Mountfort William merchant 602298 602298 Mountfort, William, of Bridport, merchant, on his own account 0
4756913 2282529 2282529 defendant Smyth Robert smith 602298 602298 Smyth, Robert, of Bridport, smith 0
4760463 2283624 2283624 defendant Pernam William husbandman 602298 602298 Pernam, William, of Bridport, husbandman 0
4771485 2287062 2287062 plaintiff (not given) John prior of Schipper 602298 602298 Schipper, John, of Bridport, prior of the priory of St John 0
4799402 2295992 2295992 defendant Barbour John husbandman 602298 602298 Barbour, John, of Bridport, husbandman 4
4805894 2298053 2298053 plaintiff But John   602298 602298 But, John, of Bridport, on his own account 0
4805898 2298054 2298054 plaintiff But John   602298 602298 But, John, of Bridport, on his own account 0
4817743 2301635 2301635 plaintiff Mountford William merchant 602298 602298 Mountford, William, of Bridport, merchant, on his own account 0
4831994 2306037 2306037 defendant Gower John husbandman 602298 602298 Gower, John, of Bridport, husbandman 0
4832180 2306095 2306095 plaintiff Butte John   602298 602298 Butte, John, of Bridport 0
4837489 2307662 2307662 defendant Roger William husbandman 602298 602298 Roger, William, of Bridport, husbandman 0
4847303 2310659 2310659 plaintiff Roger John   602298 602298 Roger, John, of Bridport 0
4849737 2311390 2311390 defendant Broun Roger draper 602298 602298 Broun, Roger, of Bridport, draper 4
4849742 2311391 2311391 defendant Pony Geoffrey husbandman 602298 602298 Pony, Geoffrey, of Bridport, husbandman 3
4859533 2314353 2314353 defendant Mountford William merchant 602298 602298 Mountford, William, of Bridport, merchant 0
4875017 2319135 2319135 plaintiff Roger John merchant 602298 602298 Roger, John, of Bridport, merchant 0
4882519 2321442 2321442 defendant Hog William (legal representative) 602298 602298 Hog, William, of Bridport, husbandman, executors of 0
4884892 2322171 2322171 plaintiff But John   602298 602298 But, John, of Bridport 0
4897969 2326031 2326031 plaintiff Keche John   602298 602298 Keche, John, of Bridport 0
4902956 2327541 2327541 plaintiff But John   602298 602298 But, John, of Bridport 0
4905275 2328244 2328244 plaintiff Roger John merchant 602298 602298 Roger, John, of Bridport, merchant 0
4910880 2329914 2329914 plaintiff Boweley William   602298 602298 Boweley, William, of Bridport 0
4910882 2329914 2329914 defendant Boley John chapman 602298 602298 Boley, John, of Bridport, chapman 1
4910885 2329915 2329915 plaintiff Boweley William   602298 602298 Boweley, William, of Bridport 0
4915773 2331432 2331432 defendant Touker Ralph fuller 602298 602298 Touker, Ralph, of Bridport, fuller 0
4978476 2350509 2350509 defendant Peny Geoffrey yeoman 602298 602298 Peny, Geoffrey, of Bridport, yeoman 1
4988324 2353477 2353477 defendant Payer Ellis laborer 602298 602298 Payer, Ellis, of Bridport, laborer 0
4989054 2353664 2353664 defendant Bouley or Bonley William   602298 602298 Bouley or Bonley, William, of Bridport, merchant, administrators of 1
4989056 2353664 2353664 defendant Boweley Nicholas merchant 602298 602298 Boweley, Nicholas, of Bridport, merchant 3
5000735 2357090 2357090 defendant Howedon Edward   602298 602298 Howedon, Edward, of Bridport, rope maker 1
5000736 2357090 2357090 defendant Trystram John husbandman 602298 602298 Trystram, John, of Bridport, husbandman 2
5006398 2358770 2358770 defendant Bolwey Nicholas chapman 602298 602298 Bolwey, Nicholas, of Bridport, chapman 2
5009274 2359599 2359599 defendant Mankeswell Thomas husbandman 602298 602298 Mankeswell, Thomas, of Bridport, husbandman 0
5015506 2361421 2361421 plaintiff Boweley Nicholas   602298 602298 Boweley, Nicholas, of Bridport 0
5031416 2366045 2366045 defendant Bonley or Bouley Agnes widow 602298 602298 Bonley or Bouley, Agnes, of Bridport, widow 4
5031421 2366046 2366046 defendant Bonley or Bouley William (legal representative) 602298 602298 Bonley or Bouley, William, of Bridport, executrix of 3
5031422 2366046 2366046 defendant Bonley or Bouley Agnes widow 602298 602298 Bonley or Bouley, Agnes, of Bridport, widow 4
5047344 2370823 2370823 defendant Bowley Nicholas chapman 602298 602298 Bowley, Nicholas, of Bridport, chapman 2
5047345 2370823 2370823 defendant Boleyn John   602298 602298 Boleyn, John, of Bridport 3
5047349 2370824 2370824 defendant Bowley Nicholas chapman 602298 602298 Bowley, Nicholas, of Bridport, chapman 2
5047350 2370824 2370824 defendant Boleyn John chapman 602298 602298 Boleyn, John, of Bridport, chapman 3
5062062 2375211 2375211 defendant Boweley Christine widow 602298 602298 Boweley, Christine,of Bridport, widow 3
5112241 2389961 2389961 defendant Pore William roper 602298 602298 Pore, William, of Bridport, roper 0
5164954 2405486 2405486 plaintiff Bailly Thomas   602298 602298 Bailly, Thomas, of Bridport 0
5165669 2405700 2405700 defendant Marshall Richard (legal representative) 602298 602298 Marshall, Richard, of Bridport, executrix of 0
5169364 2406776 2406776 defendant Byttesgate John merchant 602298 602298 Byttesgate, John, of Bridport, merchant 0
5179720 2409805 2409805 defendant Styklan Thomas (legal representative) 602298 602298 Styklan, Thomas, of Bridport, merchant, executor of 0
5185366 2411465 2411465 defendant Blankepayn John fisherman 602298 602298 Blankepayn, John, of Bridport, fisherman 0
5190319 2412912 2412912 defendant Bytelysgate William merchant 602298 602298 Bytelysgate, William, of Bridport, merchant 3
5190320 2412912 2412912 defendant Byrge John laborer 602298 602298 Byrge, John, of Bridport, laborer 4
5192024 2413396 2413396 defendant Strubrigge William   602298 602298 Strubrigge, William, of Bridport, rope maker 0
5192026 2413396 2413396 defendant Cryke William   602298 602298 Cryke, William, of Bridport, ship wright 2
5194249 2414050 2414050 defendant (not given) John prior of Sylke 602298 602298 Sylke, John, of Bridport, prior of the house of St John Baptist 0

Next page

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