names

87 rows where place_id = 623295

✎ 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
3751678 1942441 1942441 defendant Barnarde John husbandman 623295 623295 Barnarde, John, of Rode, husbandman 3
3875868 1982184 1982184 defendant Bellitor Henry husbandman 623295 623295 Bellitor, Henry, of Rode, husbandman 1
3936048 2002378 2002378 defendant Godwyn John yeoman 623295 623295 Godwyn, John, of Rode, yeoman 0
3936054 2002381 2002381 defendant Edwyn John yeoman 623295 623295 Edwyn, John, of Rode, yeoman 0
3974768 2015740 2015740 defendant A Rode Hugh yeoman 623295 623295 A Rode, Hugh, of Rode, yeoman 0
3980147 2017665 2017665 defendant Alyde John yeoman 623295 623295 Alyde, John, of Rode, yeoman 1
4010695 2028596 2028596 defendant Rode Hugh yeoman 623295 623295 Rode, Hugh, of Rode, yeoman 0
4010697 2028597 2028597 defendant Rode Hugh yeoman 623295 623295 Rode, Hugh, of Rode, yeoman 0
4053887 2043768 2043768 defendant Stonyar George   623295 623295 Stonyar, George, of Rode, yeoman, son of John 1
4430882 2174417 2174417 defendant Maunsel John   623295 623295 Maunsel, John, of Rode 1
4509896 2203580 2203580 defendant Horlok Roger   623295 623295 Horlok, Roger, of Rode 1
4518020 2206013 2206013 defendant Saltford William   623295 623295 Saltford, William, of Rode 0
4518021 2206013 2206013 defendant Hopere William   623295 623295 Hopere, William, of Rode 1
4518023 2206013 2206013 defendant Pyde John   623295 623295 Pyde, John, of Rode 3
4520162 2206641 2206641 defendant Samford Thomas   623295 623295 Samford, Thomas, of Rode 1
4522687 2207433 2207433 defendant Vuet Richard   623295 623295 Vuet, Richard, of Rode 1
4526635 2208609 2208609 plaintiff Lange Roger   623295 623295 Lange, Roger, of Rode 0
4532546 2210445 2210445 defendant Vnet or Vuet Richard   623295 623295 Vnet or Vuet, Richard, of Rode 2
4534314 2210997 2210997 defendant Salford Thomas   623295 623295 Salford, Thomas, of Rode 0
4536091 2211564 2211564 defendant Vuyet Richard   623295 623295 Vuyet, Richard, of Rode 4
4540492 2212925 2212925 defendant atte Barwe John   623295 623295 atte Barwe, John, of Rode 0
4563752 2220232 2220232 defendant Lange Robert   623295 623295 Lange, Robert, of Rode 0
4568559 2221743 2221743 defendant Lok Nicholas   623295 623295 Lok, Nicholas, of Rode 0
4568560 2221743 2221743 defendant Maunsell Richard   623295 623295 Maunsell, Richard, of Rode 1
4569314 2221989 2221989 defendant Barneby John   623295 623295 Barneby, John, of Rode 14
4572641 2222981 2222981 defendant Locke Nicholas   623295 623295 Locke, Nicholas, of Rode 0
4599824 2231173 2231173 plaintiff Taillour John   623295 623295 Taillour, John, of Rode 0
4626577 2239258 2239258 defendant Frye John   623295 623295 Frye, John, of Rode 0
4629290 2240097 2240097 plaintiff Smyth William   623295 623295 Smyth, William, of Rode 0
4629629 2240191 2240191 defendant Vuet Richard   623295 623295 Vuet, Richard, of Rode 3
4638875 2242893 2242893 defendant Mauncell Richard   623295 623295 Mauncell, Richard, of Rode 0
4643196 2244119 2244119 defendant Jamys William   623295 623295 Jamys, William, of Rode 1
4643201 2244120 2244120 defendant Jamys William   623295 623295 Jamys, William, of Rode 1
4643248 2244133 2244133 defendant Payn Thomas   623295 623295 Payn, Thomas, of Rode 2
4647327 2245272 2245272 plaintiff Saundres William   623295 623295 Saundres, William, of Rode 0
4647586 2245350 2245350 defendant Vessy Richard   623295 623295 Vessy, Richard, of Rode 0
4696556 2264398 2264398 defendant Newe John weaver 623295 623295 Newe, John, of Rode, weaver 1
4697175 2264595 2264595 defendant Havendon Lawrence weaver 623295 623295 Havendon, Lawrence, of Rode, weaver 0
4710974 2268789 2268789 defendant Runggeton Walter   623295 623295 Runggeton, Walter, of Rode, plough man 0
4714242 2269784 2269784 defendant Estmond William husbandman 623295 623295 Estmond, William, of Rode, husbandman 2
4719948 2271585 2271585 defendant Dygon John weaver 623295 623295 Dygon, John, of Rode, weaver 0
4758158 2282925 2282925 defendant blake John husbandman 623295 623295 blake, John, of Rode, husbandman 2
4799551 2296039 2296039 defendant Payn Thomas weaver 623295 623295 Payn, Thomas, of Rode, weaver 0
4805599 2297961 2297961 defendant Longe Robert gent 623295 623295 Longe, Robert, of Rode, gent 0
4816819 2301364 2301364 defendant Smyth John   623295 623295 Smyth, John, of Rode, hoop maker 0
4816970 2301409 2301409 defendant Clerk John laborer 623295 623295 Clerk, John, of Rode, laborer 3
4825019 2303864 2303864 defendant atte Borwe John husbandman 623295 623295 atte Borwe, John, of Rode, husbandman 0
4831450 2305869 2305869 defendant Vessy William husbandman 623295 623295 Vessy, William, of Rode, husbandman 0
4831451 2305869 2305869 defendant Witsay John husbandman 623295 623295 Witsay, John, of Rode, husbandman 1
4831452 2305869 2305869 defendant Herres John husbandman 623295 623295 Herres, John, of Rode, husbandman 2
4843568 2309510 2309510 defendant Trusselove John husbandman 623295 623295 Trusselove, John, of Rode, husbandman 0
4860877 2314757 2314757 defendant Bailly Richard husbandman 623295 623295 Bailly, Richard, of Rode, husbandman 0
4863890 2315681 2315681 defendant Lucas William weaver 623295 623295 Lucas, William, of Rode, weaver 0
4887364 2322884 2322884 plaintiff Jemys Thomas   623295 623295 Jemys, Thomas, of Rode 0
4894411 2324926 2324926 defendant Warwyk William   623295 623295 Warwyk, William, of Rode, groom 0
4894412 2324926 2324926 defendant Warwyk John   623295 623295 Warwyk, John, of Rode, groom 1
4920465 2332916 2332916 plaintiff Chevere William draper 623295 623295 Chevere, William, of Rode, draper 1
4944453 2340244 2340244 defendant Gardyner Thomas yeoman 623295 623295 Gardyner, Thomas, of Rode, yeoman 3
4948682 2341570 2341570 defendant Vessy William husbandman 623295 623295 Vessy, William, of Rode, husbandman 0
4948683 2341570 2341570 defendant Wyttelessey Agnes widow 623295 623295 Wyttelessey, Agnes, of Rode, widow 1
4960120 2344994 2344994 defendant Gewyn Thomas husbandman 623295 623295 Gewyn, Thomas, of Rode, husbandman 0
4984354 2352248 2352248 defendant Lye Thomas husbandman 623295 623295 Lye, Thomas, of Rode, husbandman 0
4984356 2352249 2352249 defendant Paysenorst Henry husbandman 623295 623295 Paysenorst, Henry, of Rode, husbandman 0
4984868 2352402 2352402 defendant Blake John husbandman 623295 623295 Blake, John, of Rode, husbandman 0
5012001 2360359 2360359 defendant Short John husbandman 623295 623295 Short, John, of Rode, husbandman 0
5012002 2360359 2360359 defendant Short Richard husbandman 623295 623295 Short, Richard, of Rode, husbandman 1
5024192 2363988 2363988 defendant Warrewyk William weaver 623295 623295 Warrewyk, William, of Rode, weaver 2
5082770 2381351 2381351 plaintiff Dyer John merchant 623295 623295 Dyer, John, of Rode, or of Tellysford, Soms, merchant 0
5083538 2381577 2381577 defendant Gardener Thomas yeoman 623295 623295 Gardener, Thomas, of Rode, yeoman 0
5149790 2401075 2401075 plaintiff Estmond John   623295 623295 Estmond, John, of Rode 0
5149792 2401076 2401076 plaintiff Estmond John   623295 623295 Estmond, John, of Rode 0
5149794 2401077 2401077 plaintiff Estmonde John draper 623295 623295 Estmonde, John, of Rode, draper 0
5153428 2402158 2402158 plaintiff Jainus or Jannis Thomas (legal representative) 623295 623295 Jainus or Jannis, Thomas, of Rode, executors of 0
5168598 2406537 2406537 plaintiff Estmond John   623295 623295 Estmond, John, of Rode 0
5180624 2410075 2410075 defendant Langeford John husbandman 623295 623295 Langeford, John, of Rode, husbandman 1
5184592 2411241 2411241 plaintiff Estmond John   623295 623295 Estmond, John, of Rode 0
5230542 2424548 2424548 defendant Wyttylsey John husbandman 623295 623295 Wyttylsey, John, of Rode, husbandman 0
5239625 2427176 2427176 defendant Foxe Robert tucker 623295 623295 Foxe, Robert, of Rode, tucker 2
5250137 2430153 2430153 defendant Brokke William husbandman 623295 623295 Brokke, William, of Rode, husbandman 0
5267800 2435689 2435689 defendant Wytelsey Thomas husbandman 623295 623295 Wytelsey, Thomas, of Rode, husbandman 4
5289490 2441926 2441926 defendant Perys Robert laborer 623295 623295 Perys, Robert, of Rode, laborer 1
5300253 2445040 2445040 defendant Foxe Robert fuller 623295 623295 Foxe, Robert, of Rode, fuller 0
5323889 2452226 2452226 defendant Helyer Henry butcher 623295 623295 Helyer, Henry, of Rode, butcher 0
5452309 2490564 2490564 defendant Pryour John fuller 623295 623295 Pryour, John, of Rode, fuller 2
5452310 2490564 2490564 defendant Widdenham William fuller 623295 623295 Widdenham, William, of Rode, fuller 3
5505856 2506754 2506754 defendant Wyttelsey John husbandman 623295 623295 Wyttelsey, John, of Rode, husbandman 0
5506248 2506874 2506874 defendant Goldyng William husbandman 623295 623295 Goldyng, William, of Rode, husbandman 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);