names

51 rows where place_id = 654315

✎ 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
3931963 2000990 2000990 plaintiff Eston Henry   654315 654315 Eston, Henry, of Totteneys 0
4483586 2195556 2195556 defendant Macy Joan daughter & heir of John Macy 654315 654315 Macy, Joan, of Totteneys, daughter & heir of John Macy 0
4527076 2208749 2208749 defendant Herberd John   654315 654315 Herberd, John, of Totteneys 1
4542447 2213524 2213524 plaintiff Zouche William la   654315 654315 Zouche, William la, of Totteneys 0
4543928 2214006 2214006 plaintiff Baker Walter   654315 654315 Baker, Walter, of Totteneys 0
4543929 2214006 2214006 defendant Serle Walter   654315 654315 Serle, Walter, of Totteneys 0
4545797 2214614 2214614 defendant Mayou John   654315 654315 Mayou, John, of Totteneys 0
4571267 2222585 2222585 plaintiff Zouche William la   654315 654315 Zouche, William la, of Totteneys, knight 0
4571269 2222586 2222586 plaintiff Zouche William la   654315 654315 Zouche, William la, of Totteneys, knight 0
4607286 2233390 2233390 defendant Hole John   654315 654315 Hole, John, of Totteneys 0
4654677 2247341 2247341 defendant Mayn Peter butcher 654315 654315 Mayn, Peter, of Totteneys, butcher 1
4664363 2250335 2250335 defendant Halewell Alice gentlewoman 654315 654315 Halewell, Alice, of Totteneys, gentlewoman 1
4664364 2250335 2250335 defendant Halewyll John gent 654315 654315 Halewyll, John, of Totteneys, gent 2
4666983 2255405 2255405 defendant Merssh Simon yeoman 654315 654315 Merssh, Simon, of Totteneys, yeoman 0
4669452 2256151 2256151 defendant Austyn Henry husbandman 654315 654315 Austyn, Henry, of Totteneys, husbandman 0
4669454 2256151 2256151 defendant Symond John mercer 654315 654315 Symond, John, of totteneys, mercer 2
4676645 2258313 2258313 plaintiff Gore William   654315 654315 Gore, William, of Totteneys, on his own account 0
4677356 2258536 2258536 defendant Halewell John gent 654315 654315 Halewell, John, of totteneys, gent 3
4682175 2260047 2260047 defendant Sebryght John vintner 654315 654315 Sebryght, John, of Totteneys, vintner 0
4688856 2262069 2262069 defendant Bastard John gent 654315 654315 Bastard, John, of Totteneys, gent 0
4688857 2262069 2262069 defendant Ewen John husbandman 654315 654315 Ewen, John, of Totteneys, husbandman 1
4688861 2262069 2262069 defendant Vele Thomas husbandman 654315 654315 Vele, Thomas, of Totteneys, husbandman 5
4726026 2273426 2273426 defendant Morgan Thomas ostler 654315 654315 Morgan, Thomas, of Totteneys, ostler 0
4733509 2275655 2275655 defendant Thomas John tailor 654315 654315 Thomas, John, of Totteneys, tailor 0
4791023 2293286 2293286 defendant Symond John mercer 654315 654315 Symond, John, of Totteneys, mercer 0
4814517 2300649 2300649 defendant Hornesey Hugh merchant 654315 654315 Hornesey, Hugh, of Totteneys, merchant 0
4823871 2303546 2303546 defendant Kynge John butcher 654315 654315 Kynge, John, of Totteneys, butcher 0
4858857 2314148 2314148 defendant Veale Geoffrey, senior clerk 654315 654315 Veale, Geoffrey, senior, of Totteneys, clerk 0
4858858 2314148 2314148 defendant Moulissh or Monlissh Thomas boatman 654315 654315 Moulissh or Monlissh, Thomas, of Totteneys, boatman 1
4858859 2314148 2314148 defendant Weston Walter laborer 654315 654315 Weston, Walter, of Totteneys, laborer 2
4874947 2319112 2319112 plaintiff Robyn John, junior   654315 654315 Robyn, John, junior, of Totteneys 0
4890893 2323899 2323899 defendant Burhed John yeoman 654315 654315 Burhed, John, of Totteneys, yeoman 0
4890894 2323899 2323899 defendant Geffray Richard hosier 654315 654315 Geffray, Richard, of Totteneys, hosier 1
4890895 2323899 2323899 defendant Hokymore John soaper 654315 654315 Hokymore, John, of Totteneys, soaper 2
4890896 2323899 2323899 defendant Tinker Richard merchant 654315 654315 Tinker, Richard, of Totteneys, merchant 3
4890897 2323899 2323899 defendant Redeclyff Walter   654315 654315 Redeclyff, Walter, of Totteneys, groom 4
4890898 2323899 2323899 defendant Berd William yeoman 654315 654315 Berd, William, of Totteneys, yeoman 5
4890899 2323899 2323899 defendant Tolk William yeoman 654315 654315 Tolk, William, of Totteneys, yeoman 6
4890900 2323899 2323899 defendant Colyn John yeoman 654315 654315 Colyn, John, of Totteneys, yeoman 7
4894430 2324932 2324932 defendant Hert Henry draper 654315 654315 Hert, Henry, of Totteneys, draper 0
4951069 2342299 2342299 plaintiff Piryham Thomas   654315 654315 Piryham, Thomas, of Totteneys 0
4954017 2343165 2343165 defendant Tukker Richard merchant 654315 654315 Tukker, Richard, of Totteneys, merchant 0
4962102 2345571 2345571 defendant Tolk John husbandman 654315 654315 Tolk, John, of Totteneys, husbandman 1
5026032 2364507 2364507 defendant Hamelyn John butcher 654315 654315 Hamelyn, John, of Totteneys, butcher 2
5070065 2377539 2377539 defendant Bythewater William merchant 654315 654315 Bythewater, William, of Totteneys, merchant 0
5172858 2407795 2407795 plaintiff Noseworthy John smith 654315 654315 Noseworthy, John, of Totteneys, smith 0
5192687 2413598 2413598 plaintiff Noseworthy John smith 654315 654315 Noseworthy, John, of Totteneys, smith 0
5239304 2427081 2427081 defendant Laurens William tanner 654315 654315 Laurens, William, of Totteneys, tanner 0
5243497 2428293 2428293 plaintiff Noseworthy John smith 654315 654315 Noseworthy, John, of Totteneys, smith 0
5309548 2447892 2447892 defendant Barbour William barber 654315 654315 Barbour, William, of Totteneys, barber 0
5525901 2512692 2512692 defendant Vytell John butcher 654315 654315 Vytell, John, of Totteneys, butcher 0

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