names

75 rows where place_id = 624085

✎ 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
3756066 1943853 1943853 plaintiff Alambrig Thomas mercer 624085 624085 Alambrig, Thomas, of Dorset, mercer 0
3796827 1956889 1956889 plaintiff Flete John   624085 624085 Flete, John, of Dorset 0
3796833 1956890 1956890 plaintiff Flete John   624085 624085 Flete, John, of Dorset 0
3796839 1956891 1956891 plaintiff Flete John   624085 624085 Flete, John, of Dorset 0
3814095 1962311 1962311 plaintiff Flete John   624085 624085 Flete, John, of Dorset 0
3938419 2003193 2003193 defendant Lake William yeoman 624085 624085 Lake, William, of Dorset, yeoman 3
3984390 2019173 2019173 defendant Wodham John gent 624085 624085 Wodham, John, of Dorset, gent 3
4026083 2033977 2033977 plaintiff Burley John gent 624085 624085 Burley, John, of Dorset, gent 0
4051519 2042961 2042961 defendant (not given) Thomas rector of Wasshington 624085 624085 Wasshington, Thomas, of rector of Godmanston, Dorset 0
4281467 2123421 2123421 defendant Willoughbye Edward gent 624085 624085 Willoughbye, Edward, of Dorset, gent 3
4441808 2182373 2182373 defendant St Quintin John de merchant 624085 624085 St Quintin, John de, of Dorset, merchant 0
4449465 2184779 2184779 defendant Marchall Robert chaplain 624085 624085 Marchall, Robert, of Dorset, chaplain 0
4452871 2185908 2185908 defendant Joustere or Jonstere John   624085 624085 Joustere or Jonstere, John, of Dorset 6
4452879 2185909 2185909 defendant Janstere John   624085 624085 Janstere, John, of Dorset 6
4462121 2188852 2188852 defendant Wetham Thomas   624085 624085 Wetham, Thomas, of Dorset 2
4468065 2190682 2190682 plaintiff Barker Ralph   624085 624085 Barker, Ralph, of Dorset 0
4482675 2195288 2195288 defendant Wikham Theobald   624085 624085 Wikham, Theobald, of Dorset 2
4482681 2195289 2195289 defendant Wykham Theobald   624085 624085 Wykham, Theobald, of Dorset 2
4490187 2197643 2197643 defendant le Moigne John   624085 624085 le Moigne, John, of Dorset, knight 19
4490214 2197644 2197644 defendant le Moigne John   624085 624085 le Moigne, John, of Dorset, knight 19
4490670 2197781 2197781 defendant Scryveyn Eleanor   624085 624085 Scryveyn, Eleanor, of Dorset, formerly wife of John Scryveyne 1
4531812 2210211 2210211 defendant Giffard Walter   624085 624085 Giffard, Walter, of Dorset 0
4537617 2212040 2212040 defendant Thurmond David   624085 624085 Thurmond, David, of Dorset 0
4537621 2212041 2212041 defendant Thurmond David   624085 624085 Thurmond, David, of Dorset 0
4541961 2213377 2213377 defendant Wykham Theobald   624085 624085 Wykham, Theobald, of Dorset 0
4544447 2214174 2214174 defendant Mirefeld Henry   624085 624085 Mirefeld, Henry, of Dorset 3
4547597 2215185 2215185 defendant Aysshelyn John   624085 624085 Aysshelyn, John, of Dorset 0
4553935 2217150 2217150 defendant Fitz John   624085 624085 Fitz, John, of Dorset 0
4564473 2220453 2220453 defendant Speek John   624085 624085 Speek, John, of Dorset 0
4568588 2221755 2221755 defendant Payn William   624085 624085 Payn, William, of Dorset 0
4578782 2224850 2224850 defendant Dyvers John   624085 624085 Dyvers, John, of Dorset 1
4578790 2224851 2224851 defendant Dyvers John   624085 624085 Dyvers, John, of Dorset 1
4582677 2226022 2226022 defendant Asshelyve William   624085 624085 Asshelyve, William, of Dorset 2
4589133 2227979 2227979 defendant James William   624085 624085 James, William, of Dorset 0
4591494 2228695 2228695 defendant Hurlestike John   624085 624085 Hurlestike, John, of Dorset 0
4591495 2228695 2228695 defendant Wastell Nicholas   624085 624085 Wastell, Nicholas, of Dorset 1
4597021 2230311 2230311 defendant Savage John   624085 624085 Savage, John, of Dorset 0
4608629 2233802 2233802 defendant Reson Walter   624085 624085 Reson, Walter, of Dorset 7
4611478 2234652 2234652 defendant Swanangger John   624085 624085 Swanangger, John, of Dorset 0
4611495 2234657 2234657 defendant Smert John mercer 624085 624085 Smert, John, of Dorset, mercer 3
4611500 2234658 2234658 defendant Smert John mercer 624085 624085 Smert, John, of Dorset, mercer 3
4614255 2235471 2235471 defendant Dorset John   624085 624085 Dorset, John, of Dorset 0
4615169 2235751 2235751 defendant Lovell Robert esq 624085 624085 Lovell, Robert, of Dorset, esq 0
4615171 2235752 2235752 defendant Lovell Robert esq 624085 624085 Lovell, Robert, of Dorset, esq 0
4615574 2235871 2235871 defendant Bache John   624085 624085 Bache, John, of Dorset, esq, administrators of 0
4620981 2237544 2237544 defendant Wyseman John   624085 624085 Wyseman, John, of Dorset 0
4621148 2237601 2237601 defendant Wyseman John   624085 624085 Wyseman, John, of Dorset 0
4625086 2238814 2238814 defendant Paynell John   624085 624085 Paynell, John, of Dorset 1
4630308 2240391 2240391 defendant Clerk William   624085 624085 Clerk, William, of Dorset 1
4635443 2241940 2241940 defendant Stone Edward   624085 624085 Stone, Edward, of Dorset 0
4641113 2243491 2243491 defendant Bache John   624085 624085 Bache, John, of Dorset, esq, administrators of 0
4644449 2244465 2244465 defendant Grene Andrew   624085 624085 Grene, Andrew, of Dorset 0
4644458 2244466 2244466 defendant Grene Andrew   624085 624085 Grene, Andrew, of Dorset 0
4687266 2261625 2261625 defendant Chediok John (legal representative) 624085 624085 Chediok, John, of Dorset, knight, executors of 0
4700986 2265711 2265711 plaintiff Frampton John esq 624085 624085 Frampton, John, of Dorset, esq 0
4775295 2288267 2288267 defendant Chidiok John (legal representative) 624085 624085 Chidiok, John, of Dorset, esq, executors of 0
4785583 2291516 2291516 defendant Chideok John esq 624085 624085 Chideok, John, of Dorset, esq 3
4810404 2299403 2299403 plaintiff Fauntleroy John   624085 624085 Fauntleroy, John, of Dorset, brother of the Testator John, Agnes' husband 2
4810414 2299404 2299404 plaintiff Fauntleroy John   624085 624085 Fauntleroy, John, of Dorset, brother of the Testator John, Agnes' husband 2
4852575 2312227 2312227 defendant (illegible) Thomas dyer 624085 624085 _, Thomas, of Dorset, dyer 0
4957631 2344256 2344256 plaintiff Weston Richard   624085 624085 Weston, Richard, of Dorset 0
4999353 2356677 2356677 plaintiff Latamer Nicholas esq 624085 624085 Latamer, Nicholas, of Dorset, esq 0
5135997 2397039 2397039 defendant Coste William   624085 624085 Coste, William, of Dorset 2
5137740 2397550 2397550 defendant Edmond John husbandman 624085 624085 Edmond, John, of Dorset, husbandman 3
5157996 2403463 2403463 plaintiff Plateres William gent 624085 624085 Plateres, William, of Dorset, gent 0
5173726 2408012 2408012 plaintiff Plateres William gent or esquire 624085 624085 Plateres, William, of Dorset, gent or esquire 0
5209975 2418649 2418649 defendant Wylkys John chapman 624085 624085 Wylkys, John, of Abbot Stoke, Dorset, chapman 1
5383341 2470313 2470313 defendant Barton Joan de   624085 624085 Barton, Joan de, of Dorset, widow, formerly wife of Oliver 1
5395671 2473844 2473844 defendant Colyns William husbandman 624085 624085 Colyns, William, of Dorset, husbandman 0
5405442 2476636 2476636 defendant Mar--- Thomas   624085 624085 Mar---, Thomas, of Dorset 2
5423224 2481909 2481909 defendant Revell William   624085 624085 Revell, William, of Dorset 0
5423270 2481923 2481923 defendant Bemyster Roger   624085 624085 Bemyster, Roger, of Dorset, abbot of the house & church, in Cerne, Dors 1
5445313 2488494 2488494 defendant Kem_ Richard yeoman 624085 624085 Kem_, Richard, of Dorset, yeoman 1
5611699 2547394 2547394 defendant St Quintin John de merchant 624085 624085 St Quintin, John de, of Dorset, merchant 0
5628533 2552892 2552892 defendant Marnhill William   624085 624085 Marnhill, William, of Dorset, franklin 4

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